1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
error mysql r39-3
Jimmi
Huge Clucker
****
Posts: 387
Threads: 132
Joined: Jan 2015
Reputation: 0
#1

26.07.2015, 20:30
Код:
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)
Find
Reply
Jimmi
Huge Clucker
****
Posts: 387
Threads: 132
Joined: Jan 2015
Reputation: 0
#2

26.07.2015, 21:30
up please?
Find
Reply
Jimmi
Huge Clucker
****
Posts: 387
Threads: 132
Joined: Jan 2015
Reputation: 0
#3

26.07.2015, 22:34
upppp
Find
Reply
Jefff
Banned
Posts: 2,593
Threads: 34
Joined: Dec 2007
#4

27.07.2015, 00:46
You need use mysql_tquery in this version

mysql_tquery(connectionHandleHere, string);
Find
Reply
TwinkiDaBoss
Gangsta
*****
Posts: 803
Threads: 138
Joined: Jul 2014
Reputation: 0
#5

27.07.2015, 00:48
Example:

pawn Код:
mysql_tquery(mysql, query);
Find
Reply
Jimmi
Huge Clucker
****
Posts: 387
Threads: 132
Joined: Jan 2015
Reputation: 0
#6

27.07.2015, 00:58
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;
				}
	        }
		}
	}
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help