Mysql Help - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql Help (/showthread.php?tid=623910)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql Help (/showthread.php?tid=623910)
Mysql Help - bugmenotlol - 07.12.2016
Hello all
i have an update code with mysql
but unfortunately its not working
PHP код:
else if(pickupid == gift1)
{
if(XInfo[playerid][pGiftTaken1] == 0)
{
SendClientMessage(playerid,COLOR_ERROR,"You have Found Present Number 1. Keep Searching for the remaining presents !");
new EscName[MAX_PLAYER_NAME];
mysql_real_escape_string(PlayerName(playerid),EscName);
SendClientMessage(playerid,COLOR_ERROR,"You have Found Present Number 1. Keep Searching for the remaining presents !");
new query[100];
format(query,sizeof(query),"UPDATE xmas SET pGiftTaken1='%d' WHERE nicknames='%s'",XInfo[playerid][pGiftTaken1], EscName);
XInfo[playerid][pGiftTaken1] =XInfo[playerid][pGiftTaken1]+1;
mysql_reconnect();
mysql_query(query);
}
else if(XInfo[playerid][pGiftTaken1] == 1)
{
SendClientMessage(playerid,0x912334,"You have already found this present. Search for other presents around the map.");
}
}
return 1;
Re: Mysql Help - iLearner - 07.12.2016
PHP код:
UPDATE xmas SET pGiftTaken1='%d' WHERE nicknames='%s'
PHP код:
UPDATE xmas SET pGiftTaken1=%d WHERE nicknames='%s'
Re: Mysql Help - itsCody - 08.12.2016
Why are you reconnecting MySQL?..
PHP код:
else if(pickupid == gift1)
{
if(!XInfo[playerid][pGiftTaken1])
{
new EscName[MAX_PLAYER_NAME], query[100];
mysql_real_escape_string(PlayerName(playerid), EscName);
format(query,sizeof(query), "UPDATE xmas SET pGiftTaken1 = '%d' WHERE nicknames = '%s'", XInfo[playerid][pGiftTaken1], EscName);
mysql_query(query);
XInfo[playerid][pGiftTaken1] = XInfo[playerid][pGiftTaken1] + 1;
SendClientMessage(playerid, COLOR_ERROR, "You have Found Present Number 1. Keep Searching for the remaining presents !");
}
else SendClientMessage(playerid,0x912334, "You have already found this present. Search for other presents around the map.");
}