mysql help - Printable Version

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=628713)

mysql help - itachi - 13.02.2017

I need help with admins in mysql..

Only Online admins :

Код:

	if (typ == 1)
	{
		mysql_format(handle, query, sizeof(query), "SELECT * FROM `ASystem` WHERE Title >=2 AND logged=1  ORDER BY hodnost DESC");
		format(caption, sizeof(caption), "ONLINE ADMINS");
	}

ALL Admins:

Код:

	else if (typ == 0)
	{
		mysql_format(handle, query, sizeof(query), "SELECT * FROM `ASystem` WHERE Title >=2 ORDER BY hodnost DESC");
		format(caption, sizeof(caption), "ADMIN TEAM ALL");
	}

but if send /admins so show only show ALL Admins

Re: mysql help - BiosMarcel - 13.02.2017

You are saving the login state in your db? why?? just use a local variable, i guess u don't need it outside of your samp server, right?