SA-MP Forums Archive
Help mysql r39-5 | +rep - 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: Help mysql r39-5 | +rep (/showthread.php?tid=611170)


Help mysql r39-5 | +rep - KingPersona - 03.07.2016

Hello.

i want make this in mysql r39-5 , because in my gm i use mysql r39-5, any one can help me please


when i compile i get this error msg
Код:
error 017: undefined symbol "handle"
and me i use mysql r39-5
code
Код:
CMD:unbanall(playerid, params[])
{
	if(PlayerInfo[playerid][pAdmin] >= 5)
	{
		new text[500];
		//new re[500];

 		mysql_format (handle, text, sizeof ( text ), "UPDATE ban SET Active = '0''");
		mysql_query(handle, text);
		SendClientMessage(playerid, COLOR_LIGHTRED, "Update bans!");
	}
	return 1;
}
Код:
CMD:uninviteall(playerid, params[])
{
	if(PlayerInfo[playerid][pAdmin] >= 8)
	{
		new text[500];
		//new re[500];
		for(new i=0; i< 3000; i++)
	 	{
	    	mysql_format (handle, text, sizeof ( text ), "UPDATE users SET Member = '0' AND Rank ='0' AND Model ='24'");
	    	mysql_query(handle, text);
		}
		SendClientMessage(playerid, COLOR_LIGHTRED, "Update!");
	}
	return 1;
}


Re: Help mysql r39-5 | +rep - itsCody - 03.07.2016

is "handle" defined as global?

new handle;

OnGameModeInit
handle = mysql_connect(...);

Re: Help mysql r39-5 | +rep - KingPersona - 03.07.2016

Quote:
Originally Posted by itsCody
Посмотреть сообщение
is "handle" defined as global?

new handle;

OnGameModeInit
handle = mysql_connect(...);
No,
Код:
SQL = mysql_connect


Re: Help mysql r39-5 | +rep - TwinkiDaBoss - 03.07.2016

any errors, warnings, or such?

Re: Help mysql r39-5 | +rep - d1git - 03.07.2016

Код:
mysql_format (SQL, ..
mysql_query(SQL, ..