18.08.2014, 15:46
Hello! Optimized functions, before everything worked perfectly preserved account, but now that is not saved is not correct in SQL queries to mine please help solve the problem. code:
PHP код:
SaveAccount(playerid)
{
if(gPlayerLogged[playerid] == false) return true;
new src[1024], name[MAX_PLAYER_NAME]; GetPlayerName(playerid, name, sizeof(name));
format(src,sizeof(src),"UPDATE "TABLE_ACCOUNT" SET Brunt = '%i', EnterHour = '%i', CrimeWho = '%s', Crime = '%s', NewlyWeds = '%i', NewlyWedsTo = '%s', Jerrycan = '%i', Tools = '%i', JailTime = '%i', WantedLevel = '%i', Mats = '%i', Drugs = '%i', WarnTime = '%i', Warn = '%i', Mute = '%i', MuteReport = '%i', MobileCash = '%i', Number = '%i',",
PlayerInfo[playerid][pBrunt],
PlayerInfo[playerid][pEnterHour],
PlayerInfo[playerid][pCrimeWho],
PlayerInfo[playerid][pCrime],
PlayerInfo[playerid][pNewlyWeds],
PlayerInfo[playerid][pNewlyWedsTo],
PlayerInfo[playerid][pJerrycan],
PlayerInfo[playerid][pTools],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pWantedLevel],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pWarnTime],
PlayerInfo[playerid][pWarn],
PlayerInfo[playerid][pMute],
PlayerInfo[playerid][pMuteReport],
PlayerInfo[playerid][pMobilecash],
PlayerInfo[playerid][pNumberPhone]);
format(src,sizeof(src),"%s Bank = '%i', Money = '%i', FracSkin = '%i', Rang = '%i', Leader = '%i',Member = '%i', AdminPass = '%s', Admin = '%i', Job = '%i', Sex = '%i', Health = '%f', Level = '%i', Exp = '%i', Char = '%i', Check = '%i', Donate = '%i', ExpTime = '%i', HourFraction = '%i', Reputation = '%i', Dependence = '%i', Dolg = '%i', UseKrisha = '%i', Krisha = '%i', Eat = '%i', Vip = '%i', Escape = '%i' WHERE ID = '%i'",
src,
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pRang],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pAdminPassword],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pCheck],
PlayerInfo[playerid][pScrDonate],
PlayerInfo[playerid][pExpTime],
PlayerInfo[playerid][pHourFractions],
PlayerInfo[playerid][pReputation],
PlayerInfo[playerid][pDepen],
PlayerInfo[playerid][pDolg],
PlayerInfo[playerid][pUseKrisha],
PlayerInfo[playerid][pKrisha],
PlayerInfo[playerid][pEat],
PlayerInfo[playerid][pStatusVip],
PlayerInfo[playerid][pEscape],
PlayerInfo[playerid][pID]);
//==========================================================================
format(PlayerInfo[playerid][pLics],40,"%d,%d,%d,%d",PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2],PlayerInfo[playerid][pLic][3]);
format(src,sizeof(src)," `Lics` = '%s',",PlayerInfo[playerid][pLics]);
strcat(query,src,sizeof(query));
new notice[8];
format(notice,sizeof(notice),"%d,%d,%d",PlayerInfo[playerid][pNotice][0],PlayerInfo[playerid][pNotice][1],PlayerInfo[playerid][pNotice][2]);
format(src,sizeof(src)," `Notice` = '%s',",notice);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pTogs],40,"%d,%d,%d",PlayerInfo[playerid][pTog][0],PlayerInfo[playerid][pTog][1],PlayerInfo[playerid][pTog][2]);
format(src,sizeof(src)," `Togs` = '%s',",PlayerInfo[playerid][pTogs]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pJails],40,"%d,%d,%d",PlayerInfo[playerid][pJail][0],PlayerInfo[playerid][pJail][1],PlayerInfo[playerid][pJail][2]);
format(src,sizeof(src)," `Jails` = '%s',",PlayerInfo[playerid][pJails]);
strcat(query,src,sizeof(query));
new gunskill[30];
format(gunskill,sizeof(gunskill),"%d,%d,%d,%d,%d,%d",PlayerInfo[playerid][pGunSkill][0],PlayerInfo[playerid][pGunSkill][1],PlayerInfo[playerid][pGunSkill][2],
PlayerInfo[playerid][pGunSkill][3],PlayerInfo[playerid][pGunSkill][4],PlayerInfo[playerid][pGunSkill][5]);
format(src,sizeof(src)," `Skills` = '%s'",gunskill);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE `Name` = '%s'",name);
strcat(query,src,sizeof(query));
mysql_query(query);
new guns[56], ammo[56];
format(guns,56,"%i, %i, %i, %i, %i", CarInfo[playerid][cGun][0],CarInfo[playerid][cGun][1],CarInfo[playerid][cGun][2],CarInfo[playerid][cGun][3],CarInfo[playerid][cGun][4]);
format(ammo,56,"%i, %i, %i, %i, %i", CarInfo[playerid][cGunAmmo][0],CarInfo[playerid][cGunAmmo][1],CarInfo[playerid][cGunAmmo][2],CarInfo[playerid][cGunAmmo][3],CarInfo[playerid][cGunAmmo][4]);
format(CarInfo[playerid][cColors],16,"%d,%d", CarInfo[playerid][cColor][0], CarInfo[playerid][cColor][1]);
format(query,sizeof(query),"UPDATE "TABLE_CARS" SET `Colors` = '%s', `Model` = '%i', `Cost` = '%i', `Guns` = '%s', `Ammo` = '%s', `Drugs` = '%i', `Wheel` = '%i', `Nitro` = '%i', `FBumber` = '%i', `RBumber` = '%i', `Spoiler` = '%i', `Hydra` = '%i' WHERE `Owner` = '%s'",
CarInfo[playerid][cColors],CarInfo[playerid][cModel],CarInfo[playerid][cCost],guns,ammo,CarInfo[playerid][cDrugs],CarInfo[playerid][cWheel],CarInfo[playerid][cNitro],CarInfo[playerid][cFBumber],CarInfo[playerid][cRBumber],CarInfo[playerid][cSpoiler],CarInfo[playerid][cHydra],name);
mysql_query(query);
return 1;
}