public sqlSaveAccount(playerid, disconnect)
{
if(IsPlayerLoggedIn(playerid))
{
new strQuery[1024];
mysql_format(Handle, strQuery, 1024, "UPDATE users SET money='%i', bank='%i', skin='%i', spawn='%i', tutorial='%i', ip='%e', hospital='%i', admin='%i' WHERE username='%e'",
pInfo[playerid][pMoney],
pInfo[playerid][pBank],
pInfo[playerid][pSkin],
pInfo[playerid][pSpawn],
pInfo[playerid][Tutorial],
pInfo[playerid][IP],
pInfo[playerid][Hospital],
pInfo[playerid][pAdmin],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE users SET driverlicense='%i', flylicense='%i', boatlicense='%i', trucklicense='%i', bikelicense='%i', weaponlicense='%i', lastlogin=CURRENT_TIMESTAMP WHERE username='%e'",
pInfo[playerid][pDriverLicense],
pInfo[playerid][pFlyLicense],
pInfo[playerid][pBoatLicense],
pInfo[playerid][pTruckLicense],
pInfo[playerid][pBikeLicense],
pInfo[playerid][pWeaponLicense],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE users SET respectpoints='%i', level='%i', Deaths='%i', Kills='%i', Verheiratet='%i', payday='%i', paydaymoney='%i', team='%i', wanted='%i', jailtime='%i' , leader='%i', rang='%i' , fraksperre='%i' WHERE username='%e'",
pInfo[playerid][pRespectPoints],
pInfo[playerid][pLevel],
pInfo[playerid][pDeaths],
pInfo[playerid][pKills],
pInfo[playerid][pVerheiratet],
pInfo[playerid][pPayday],
pInfo[playerid][pPaydayMoney],
pInfo[playerid][pTeam],
pInfo[playerid][pWanteds],
pInfo[playerid][pKnastZeit],
pInfo[playerid][pLeader],
pInfo[playerid][pRank],
pInfo[playerid][pFraksperre],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE users SET multiacc='%i', hwid='%e', houseid='%i', titleid='%i', number='%i', perso='%i', playtime='%i', telefonbuch='%i', dice='%i', forumid='%i' WHERE username='%e'",
pInfo[playerid][pMultiAccount],
pInfo[playerid][pHWID],
pInfo[playerid][pHouseID],
pInfo[playerid][pTitleID],
pInfo[playerid][pNumber],
pInfo[playerid][pPerso],
pInfo[playerid][pPlaytime],
pInfo[playerid][pTelefonbuch],
pInfo[playerid][pDice],
pInfo[playerid][pForumAccountID],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE quests SET wanted='%i', jailed='%i', hospital='%i', eggs='%i', egg_count='%i', occupied='%i', license='%i', perso='%i' WHERE username='%e'",
pPlayerQuest[playerid][pQuestWanted],
pPlayerQuest[playerid][pQuestJailed],
pPlayerQuest[playerid][pQuestHospital],
pPlayerQuest[playerid][pQuestEggs],
pPlayerQuest[playerid][pQuestOccupied],
pPlayerQuest[playerid][pQuestLicense],
pPlayerQuest[playerid][pQuestPerso],
pInfo[playerid][pQuestEggCount],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE savebox SET weedseed='%i', weed='%i' WHERE username='%e'",
pDrugs[playerid][pWeedseeds],
pDrugs[playerid][pWeed],
Playername(playerid));
mysql_pquery(Handle, strQuery);
mysql_format(Handle, strQuery, 1024, "UPDATE jobs SET job='%i', jobtime='%i', jobmoney='%i' WHERE username='%e'",
pJobs[playerid][pJob],
pJobs[playerid][pJobTime],
pJobs[playerid][pJobMoney],
Playername(playerid));
mysql_pquery(Handle, strQuery);
if(disconnect)
sqlResetInfos(playerid);
}
return true;
}
Alles anzeigen
[19:44:25 06/29/17] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'payday='29', paydaymoney='0', team='0', wanted='0', jailtime='0' , leader='1', r' at line 1 (Query: "UPDATE users SET respectpoints='1', level='1', Deaths='0', Kills='0', Verheiratet='1' payday='29', paydaymoney='0', team='0', wanted='0', jailtime='0' , leader='1', rang='0' , fraksperre='0' WHERE username='KontraK'")
[19:44:25 06/29/17] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'payday='29', paydaymoney='0', team='0', wanted='0', jailtime='0' , leader='1', r' at line 1 (Query: "UPDATE users SET respectpoints='1', level='1', Deaths='0', Kills='0', Verheiratet='1' payday='29', paydaymoney='0', team='0', wanted='0', jailtime='0' , leader='1', rang='0' , fraksperre='0' WHERE username='KontraK'")
[19:45:15 06/29/17] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'payday='28', paydaymoney='0', team='1', wanted='0', jailtime='0' , leader='1', r' at line 1 (Query: "UPDATE users SET respectpoints='5', level='2', Deaths='12', Kills='4', Verheiratet='1' payday='28', paydaymoney='0', team='1', wanted='0', jailtime='0' , leader='1', rang='0' , fraksperre='0' WHERE username='Meme_Supreme'")
Kann mir jemand bitte helfen?