Cum pot muta top pe mysql.

[SkyLeAs]

Problema intalnita (descriere):Pai sistemu meu de clan ruleaza sqlite si vreau sa mut pe mysql sa pot face un script php pentru site dar nu am idee cum sa-l fac...
Ero(area / rile) / warning-(ul / urile):!
Liniile de cod / sursa / script-ul:

ShowTopClan( playerid, stats[ ], what[ ], limit = MAX_TOP_LIMIT ) // THX to Zh3r0 & Roach_
{
	#pragma unused what
	//--------------------------------------------------------------------------
	new Speed = GetTickCount(), DialString[3_000], String[2][256], Query[2][256],
		DBResult:Result1, cColor[12] = "{FFFFFF}", oColor[12] = "{AEFF00}";
	//--------------------------------------------------------------------------
    Database = db_open( "CSystem.db" ); //Open DB
	//--------------------------------------------------------------------------
	format( Query[ 0 ], 256, "SELECT `clanname` FROM `clans` ORDER BY (`%s` * 1) DESC limit %d", stats, limit);
	Result1 = db_query( Database, Query[ 0 ] );
	//--------------------------------------------------------------------------
	format( DialString, sizeof DialString, "%sMore info about our {FF0000}Clan System {AEFF00}find on: {FF0000}/chelpn",oColor);
	for( new Qr; Qr < db_num_rows( Result1 ); Qr ++ )
	{
		db_get_field( Result1, 0, String[ 0 ], 256 );
		format( Query[ 1 ], 256, "SELECT `%s` FROM `clans` WHERE `clanname` = '%s'", stats, String[ 0 ] );
		new DBResult:Result2 = db_query( Database, Query[ 1 ] );
		db_get_field( Result2, 0, String[ 1 ], 256 );
		format( DialString, sizeof DialString, "%sn{AFAFAF}%d.{FF0000} %s {AFAFAF}Clan Points: %s%s {FF0000}(Members: %d)", DialString, Qr + 1, String[0], cColor, FormatNumber(strval(String[1])), GetTotalMembers(String[0]));
		db_next_row( Result1 );
		db_free_result( Result2 );
	}
	db_free_result( Result1 );
	format( DialString, sizeof DialString, "%snn{AEFF00}Top list generated in {FF0000}%d{AEFF00}ms.", DialString, GetTickCount( ) - Speed );
	ShowPlayerDialog( playerid, Nothing, DIALOG_STYLE_MSGBOX, "{0066CC}E{FFFF00}S{FF0000}S{AFAFAF} - Top Clans", DialString, "Ok", "" );
	return ( 1 );
}

//--------------------------------------------------------------------------
	Database = db_open("CSystem.db");
	//--------------------------------------------------------------------------
    db_query(Database, "CREATE TABLE IF NOT EXISTS clans(`ID` INTEGER PRIMARY KEY AUTOINCREMENT,
						clanname VARCHAR(30),
						clantag VARCHAR(5),
						clanleader VARCHAR(100),
						clandes VARCHAR(100),
						clanmotd VARCHAR(50),
						clankills INT(5),
						clandeaths INT(5),
						clancolor VARCHAR(50),
						clanposx float NOT NULL,
						clanposy float NOT NULL,
						clanposz float NOT NULL,
						lskin INT(3),
						mskin INT(3),
						weap1 INT(3),
						weap2 INT(3),
						weap3 INT(3),
						weap4 INT(3),
						weap5 INT(3),
						weap6 INT(3))");
	//--------------------------------------------------------------------------
	db_query(Database, "CREATE TABLE IF NOT EXISTS members(`ID` INTEGER PRIMARY KEY AUTOINCREMENT,
						clanname VARCHAR(30),
						playername VARCHAR(30),
						playerclanrank INT(5),
						isinclan INT(2),
						IsOnline INT(2))");
	return ( 1 );

Imagini / Video (optional):!!
Ati incercat sa rezolvati singur?:Pai am incercat dar mai mult am facut prostie mare ) si lam pus la loc pe sqlite cum erea.

[(SE)SoNNy]

Ce fain, asta e sistemul meu de clanuri.

[kwnx]

Ce fain, asta e sistemul meu de clanuri.

Exact )

 

Daca vrei sa muti :top-ul" de pe SQLite, pe MySQL, ne trebuie tot scriptul, si nu fii convins ca Staff-ul iti va da totul mura in gura, o sa te facem sa intelegi cum sa il muti tu singur, caci daca vrei sa inveti, doar din greseli o faci...

[SkyLeAs]

Ce fain, asta e sistemul meu de clanuri.

Stai linistit ca esti trecut in fs cine la facut si modificat .Dar da o rezolvare daca tot e al tau

[Gireada]

O rezolvare este urmatoarea: Inveti bine bine mysql iar dupa convertesti tot script-ul din SQL in MySQl deoarece daca modifici ceva din SQL in MySQL nu o sa iti mearga. Trebuie modific totul.

[(SE)SoNNy]

Nu am ce rezolvare sa dau la sistemul meu de clanuri pentru ca e ok asa ) Daca vrei tu sa-l faci pe MySQL e treaba ta si pune mana si invata mai intai cate ceva despre MySQL.