SA-MP Forums Archive
mysql saving prob - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql saving prob (/showthread.php?tid=142208)



mysql saving prob - WardenCS - 17.04.2010

hello,i haz mysql script and i have problem with it,it wont save the accounts :/

Код:
stock SavePlayerAccount( playerid )
{
	new String[ 255 ];


	if( PlayerStatistics[ playerid ][ pAuth ] == 1 )
	{
	  format( String, sizeof( String ), "UPDATE `Accounts` SET `pAge` = '%d', `Password` = '%s', `AdminLevel` = '%d', `Tutorial` = '%d', `Group` = '%d', `Gender` = '%d' WHERE `UserID` = '%d'", PlayerStatistics[ playerid ][ pAge ], PlayerStatistics[ playerid ][ pPassword ], PlayerStatistics[ playerid ][ pAdminLevel ], PlayerStatistics[ playerid ][ pTutorial ], PlayerStatistics[ playerid ][ pGroup ], PlayerStatistics[ playerid ][ pGender ], PlayerStatistics[ playerid ][ pDatabaseID ] );
		mysql_query( String );

		GetPlayerPos( playerid, PlayerStatistics[ playerid ][ pLastPosX ], PlayerStatistics[ playerid ][ pLastPosY ], PlayerStatistics[ playerid ][ pLastPosZ ] );
	  format( String, sizeof( String ), "UPDATE `Accounts` SET `LastPosX` = '%f', `LastPosY` = '%f', `LastPosZ` = '%f', `LastInterior` = '%d', `LastWorld` = '%d' WHERE `UserID` = '%d'", PlayerStatistics[ playerid ][ pLastPosX ], PlayerStatistics[ playerid ][ pLastPosY ], PlayerStatistics[ playerid ][ pLastPosZ ], GetPlayerInterior( playerid ), GetPlayerVirtualWorld( playerid ), PlayerStatistics[ playerid ][ pDatabaseID ] );
		mysql_query( String );

	  format( String, sizeof( String ), "UPDATE `Accounts` SET `BankMoney` = '%d' WHERE `UserID` = '%d'", PlayerStatistics[ playerid ][ pBankMoney ], PlayerStatistics[ playerid ][ pDatabaseID ] );
		mysql_query( String );
		
 		format( String, sizeof( String ), "UPDATE `Accounts` SET `pSpawnPlace` = '%d' WHERE `UserID` = '%d'", PlayerStatistics[ playerid ][ pSpawnPlace ], PlayerStatistics[ playerid ][ pDatabaseID ] );
		mysql_query( String );

	}
	return 0;
}



Re: mysql saving prob - WardenCS - 17.04.2010

iBUMP ?