Whats wrong with this? (MySQL R33)
#2

pawn Код:
mysql_format(mysql, query, sizeof(query), "UPDATE `"PlayerTable"` SET `pAdmin`=%d, `pWarns`=%d, `pScore`=%d, `pMoney`=%d, `pSeconds`=%d, `pHours`=%d WHERE `user` = %e", pInfo[playerid][pAdmin], pInfo[playerid][pWarns], GetPlayerScore(playerid), GetPlayerMoney(playerid), pInfo[playerid][pSeconds], pInfo[playerid][pHours], Name[playerid]);
mysql_format(mysql, query1, sizeof(query1), "UPDATE `"PlayerTable"` SET `pKills`=%d, `pDeaths`=%d, `pVip`=%d, `pSwat`=%d, `pArmy`=%d, `pTazers`=%d WHERE `user` = %e", pInfo[playerid][pKills], pInfo[playerid][pDeaths], pInfo[playerid][pVip], pInfo[playerid][pSwat], pInfo[playerid][pArmy], pInfo[playerid][pTazers], Name[playerid]);
mysql_format(mysql, query2, sizeof(query2), "UPDATE `"PlayerTable"` SET `pCuffs`=%d, `pArrests`=%d, `pRobs`=%d, `pRapes`=%d, `pEvade`=%d, `pCookies`=%d WHERE `user` = %e", pInfo[playerid][pCuffs], pInfo[playerid][pArrests], pInfo[playerid][pRobs], pInfo[playerid][pRapes], pInfo[playerid][pEvade], pInfo[playerid][pCookies], Name[playerid]);

mysql_tquery(mysql, query, "", "");
mysql_tquery(mysql, query1, "", "");
mysql_tquery(mysql, query2, "", "");
You had an extra variable in your first query, pMinutes. I removed it from the parameters list, but if you want to keep it, edit the query and add `pMinutes`=%d instead.
Reply


Messages In This Thread
Whats wrong with this? (MySQL R33) - by FunnyBear - 10.02.2015, 19:02
Re: Whats wrong with this? (MySQL R33) - by HazardouS - 10.02.2015, 19:14

Forum Jump:


Users browsing this thread: 2 Guest(s)