01.11.2013, 15:10
Basically from what i can tell its loading from the database correctly but isn't placing it into the players data (enum)
pawn Код:
enum cInfo
{
AccID,
Character[50],
Password[129],
Ip[16],
Gender,
Age,
OnHandCash,
StaffLevel,
StaffName[10],
HelperLevel,
IsDonator,
FactionID,
FactionRank,
FactionLeader,
FactionBadge[8],
GunLicense,
DrivingLicense,
HasBankAccount,
BankBalance,
ObtainedCredit,
CreditBalance,
OwnsHouse,
IsMuted,
Logged,
FailedLogins,
FirstSpawn
};
new CharacterInfo[MAX_PLAYERS][cInfo];
stock LoadStats(playerid)
{
format(Query, sizeof(Query), "SELECT * FROM `characters` WHERE `Character` = '%s'", GetOriginalName(playerid));
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Query, "|");
sscanf(Query, "e<p<|>is[24]s[129]s[16]iiiis[10]iiiiis[8]iiiiiii>", CharacterInfo[playerid]);//Remember to update this if you are going to add more info!
mysql_free_result();
return 1;
}
pawn Код:
[15:19:09] CMySQLHandler::Query(SELECT * FROM `characters` WHERE `Character` = 'Jason_Hall') - Successfully executed.
[15:19:09] >> mysql_store_result( Connection handle: 1 )
[15:19:09] CMySQLHandler::StoreResult() - Result was stored.
[15:19:09] >> mysql_fetch_row_format( Connection handle: 1 )
[15:19:09] CMySQLHandler::FetchRow() - Return: 1|Jason_Hall|59ecef26213d557e39d8443365341085|5|1|27|1000|9|Rapter|0|1|1|9|1|BG653|1|1|1|4567890|1|234567|0
[15:19:09] >> mysql_free_result( Connection handle: 1 )
[15:19:09] CMySQLHandler::FreeResult() - Result was successfully free'd.
[15:19:09] >> mysql_free_result( Connection handle: 1 )
[15:19:09] CMySQLHandler::FreeResult() - The result is already empty.