MYSQL not saving account
#1

Ok, For some reason, this isn't saving my account, It can connect fine to MYSQL:

pawn Код:
function SaveAccount(playerid) {
    GetPlayerPos(playerid, AccountData[playerid][Spawn][0],AccountData[playerid][Spawn][1],AccountData[playerid][Spawn][2]);
    GetPlayerFacingAngle(playerid, AccountData[playerid][Spawn][3]);
    AccountData[playerid][InteriorSpawn] = GetPlayerInterior(playerid);
    AccountData[playerid][WorldSpawn] = GetPlayerVirtualWorld(playerid);
    format(string,sizeof(string), "UPDATE Accounts SET AdminLevel=%i,Money=%i,Bank=%i,Faction=%i,Rank=%i,HouseKey=%i,BizKey=%i,Skin=%i,Spawn1='%f',Spawn2='%f',Spawn3='%f',Spawn4='%f',Spawn5=%i,Reg=%i,Sex=%i,Wallet=%i,Renting=%i,Products=%i,PhoneNumber=%i,Minutes=%i,Spawn6=%i,Arrested=%i,Prisoned=%i,Jailed=%i,JailTime=%i, \
    Cell=%i,Towe=%i,License=%i,Linked=%i,ForumName='%s',ForumPassword='%s',wLicense=%i,Job=%i,Donator=%i,CarParts=%i,PlayingTime=%i,FightingStyle=%i WHERE Name = '%s'"
,
    AccountData[playerid][AdminLevel],GetPlayerCash(playerid),AccountData[playerid][Bank],
    AccountData[playerid][Faction],AccountData[playerid][Rank],AccountData[playerid][HouseKey],
    AccountData[playerid][BizKey],GetPlayerSkin(playerid),AccountData[playerid][Spawn][0],AccountData[playerid][Spawn][1],AccountData[playerid][Spawn][2],AccountData[playerid][Spawn][3],
    AccountData[playerid][InteriorSpawn],AccountData[playerid][Reg],AccountData[playerid][Sex],GetPlayerWalletCash(playerid),AccountData[playerid][Renting],AccountData[playerid][Products],
    AccountData[playerid][PhoneNumber],AccountData[playerid][Minutes],AccountData[playerid][WorldSpawn],AccountData[playerid][Arrested],AccountData[playerid][Prisoned],AccountData[playerid][Jailed],
    AccountData[playerid][JailTime],AccountData[playerid][Cell],AccountData[playerid][Towe],AccountData[playerid][License], AccountData[playerid][Linked], AccountData[playerid][ForumName],
    AccountData[playerid][ForumPassword],AccountData[playerid][wLicense],AccountData[playerid][pJob], AccountData[playerid][Donator], AccountData[playerid][CarParts], AccountData[playerid][PlayingTime],
    AccountData[playerid][FightingStyle],GetUserName(playerid));
    mysql_query(string, MYSQL_SAVE_USERS);
   
    format(string,sizeof(string), "UPDATE Accounts SET Materials=%i WHERE Name = '%s'",
    AccountData[playerid][Materials],GetUserName(playerid));
    mysql_query(string, MYSQL_SAVE_USERS);
   
    format(string, sizeof(string), "UPDATE enrolled SET Classes=%i WHERE Name = '%s'", AccountData[playerid][Classes],
    GetUserName(playerid));
    mysql_query(string);
   
    format(string, sizeof(string), "UPDATE scholarships SET Psychology=%i,Criminal_Justice=%i,Medicine=%i WHERE Name = '%s'", UniversityData[playerid][Psychology], UniversityData[playerid][Criminal_Justice],
    UniversityData[playerid][Medicine],GetUserName(playerid));
    mysql_query(string);
   
    format(string, sizeof(string), "UPDATE drugs SET Cocaine=%d,Crack=%d,Heroin=%d,Hydrocodone=%d,\
    Inhalants=%d,LSD=%d,Marijuana=%d,MDMA=%d,Methamphetamine=%d,Anabolic_Steroids=%d,Needles=%d,Blunts=%d WHERE Name = '%s'"
,
    PlayerDrugData[playerid][Cocaine],PlayerDrugData[playerid][Crack],PlayerDrugData[playerid][Heroin],PlayerDrugData[playerid][Hydrocodone],
    PlayerDrugData[playerid][Inhalants],PlayerDrugData[playerid][LSD],PlayerDrugData[playerid][Marijuana],PlayerDrugData[playerid][MDMA],
    PlayerDrugData[playerid][Methamphetamine],PlayerDrugData[playerid][Anabolic_Steroids],PlayerDrugData[playerid][Needles],PlayerDrugData[playerid][Blunts],GetUserName(playerid));
    mysql_query(string);
   
    format(string, sizeof(string), "UPDATE Settings SET Turfs=%i,SAN=%i,Phone=%i,Room=%i WHERE Name = '%s'", PlayerSettingsData[playerid][TurfTog], PlayerSettingsData[playerid][SANTog],
    PlayerSettingsData[playerid][PhoneTog], PlayerSettingsData[playerid][RoomTog],GetUserName(playerid));
    mysql_query(string);
   
    SavePlayerWeapons(playerid);
    SavePlayerWeaponsAmmo(playerid);
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)