17.04.2010, 15:53
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;
}