error mysql r39-3 - 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: error mysql r39-3 (/showthread.php?tid=583209)
+- 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: error mysql r39-3 (/showthread.php?tid=583209)
error mysql r39-3 - Jimmi - 26.07.2015
Код:
if(dialogid == 130)
{
if(!response)
{
return 1;
}
switch(listitem)
{
case 0:
{
if(PlayerInfo[playerid][pGPPoints] >= 150)
{
PlayerInfo[playerid][pDonateRank] = 1;
PlayerInfo[playerid][pGPPoints] -= 150;
format(string, sizeof(string), "UPDATE players SET DonateRank='%d' WHERE id=%d", PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
format(string, sizeof(string), "UPDATE players SET GamePoints='%d' WHERE id=%d", PlayerInfo[playerid][pGPPoints], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Cont VIP' in schimbul a 150 {FF8C00}GamePoints{FFFFFF}!");
SendClientMessage(playerid, -1, "Tasteaza /desprevip pentru informatii!");
return 1;
}
else
{
SendClientMessage(playerid, -1, "Nu detii 150 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
case 1:
{
if(PlayerInfo[playerid][pGPPoints] >= 20)
{
if(PlayerInfo[playerid][pWarns] > 0)
{
PlayerInfo[playerid][pWarns] = 0;
PlayerInfo[playerid][pGPPoints] -= 20;
format(string, sizeof(string), "UPDATE players SET GamePoints='%d' WHERE id=%d", PlayerInfo[playerid][pGPPoints], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
format(string, sizeof(string), "UPDATE players SET Warnings='%d' WHERE id=%d", PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Clear Warns' in schimbul a 20 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
else
{
SendClientMessage(playerid, -1 ,"Nu ai warn-uri!");
return 1;
}
}
else
{
SendClientMessage(playerid, -1, "Nu detii 20 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
case 2:
{
if(PlayerInfo[playerid][pGPPoints] >= 40)
{
if(PlayerInfo[playerid][pPunish] > 0)
{
PlayerInfo[playerid][pPunish] = 0;
PlayerInfo[playerid][pGPPoints] -= 40;
format(string, sizeof(string), "UPDATE players SET GamePoints='%d' WHERE id=%d", PlayerInfo[playerid][pGPPoints], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
format(string, sizeof(string), "UPDATE players SET Fpunish='%d' WHERE id=%d", PlayerInfo[playerid][pPunish], PlayerInfo[playerid][pSQLID]);
mysql_query(string);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Clear FPunish' in schimbul a 40 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
else
{
SendClientMessage(playerid, -1 ,"Nu ai FPunish!");
return 1;
}
}
else
{
SendClientMessage(playerid, -1, "Nu detii 40 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
}
}
Код:
C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12123) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12125) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12145) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12147) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12172) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12174) : error 035: argument type mismatch (argument 1) C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(13254) : error 035: argument type mismatch (argument 1)
Re: error mysql r39-3 - Jimmi - 26.07.2015
up please?
Re: error mysql r39-3 - Jimmi - 26.07.2015
upppp
Re: error mysql r39-3 - Jefff - 27.07.2015
You need use mysql_tquery in this version
mysql_tquery(connectionHandleHere, string);
Re: error mysql r39-3 - TwinkiDaBoss - 27.07.2015
Example:
pawn Код:
mysql_tquery(mysql, query);
Re: error mysql r39-3 - Jimmi - 27.07.2015
yes:
Код:
C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12120) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12121) : error 017: undefined symbol "tquery" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12122) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12123) : error 017: undefined symbol "tquery" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12142) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12143) : error 017: undefined symbol "tquery" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12144) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12145) : error 017: undefined symbol "tquery" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12169) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12170) : error 017: undefined symbol "tquery" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12171) : error 017: undefined symbol "MySQL" C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn(12172) : error 017: undefined symbol "tquery"
Код:
if(dialogid == 130)
{
if(!response)
{
return 1;
}
switch(listitem)
{
case 0:
{
if(PlayerInfo[playerid][pGPPoints] >= 150)
{
PlayerInfo[playerid][pDonateRank] = 1;
PlayerInfo[playerid][pGPPoints] -= 150;
mysql_tquery(MySQL, "UPDATE players SET DonateRank='%d' WHERE id=%d", "");
mysql_tquery(tquery);
mysql_tquery(MySQL, "UPDATE players SET GamePoints='%d' WHERE id=%d", "");
mysql_tquery(tquery);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Cont VIP' in schimbul a 150 {FF8C00}GamePoints{FFFFFF}!");
SendClientMessage(playerid, -1, "Tasteaza /desprevip pentru informatii!");
return 1;
}
else
{
SendClientMessage(playerid, -1, "Nu detii 150 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
case 1:
{
if(PlayerInfo[playerid][pGPPoints] >= 20)
{
if(PlayerInfo[playerid][pWarns] > 0)
{
PlayerInfo[playerid][pWarns] = 0;
PlayerInfo[playerid][pGPPoints] -= 20;
mysql_tquery(MySQL, "UPDATE players SET GamePoints='%d' WHERE id=%d", "");
mysql_tquery(tquery);
mysql_tquery(MySQL, "UPDATE players SET Warnings='%d' WHERE id=%d", "");
mysql_tquery(tquery);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Clear Warns' in schimbul a 20 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
else
{
SendClientMessage(playerid, -1 ,"Nu ai warn-uri!");
return 1;
}
}
else
{
SendClientMessage(playerid, -1, "Nu detii 20 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
case 2:
{
if(PlayerInfo[playerid][pGPPoints] >= 40)
{
if(PlayerInfo[playerid][pPunish] > 0)
{
PlayerInfo[playerid][pPunish] = 0;
PlayerInfo[playerid][pGPPoints] -= 40;
mysql_tquery(MySQL, "UPDATE players SET GamePoints='%d' WHERE id=%d", "");
mysql_tquery(tquery);
mysql_tquery(MySQL, "UPDATE players SET Fpunish='%d' WHERE id=%d", "");
mysql_tquery(tquery);
SendClientMessage(playerid, -1, "Felicitari! Ai achizitionat 'Clear FPunish' in schimbul a 40 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
else
{
SendClientMessage(playerid, -1 ,"Nu ai FPunish!");
return 1;
}
}
else
{
SendClientMessage(playerid, -1, "Nu detii 40 {FF8C00}GamePoints{FFFFFF}!");
return 1;
}
}
}
}