[MySql Help] Get a value from db

[MySql Help] Get a value from db - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [MySql Help] Get a value from db (/showthread.php?tid=189585)

[MySql Help] Get a value from db - XePloiT - 12.11.2010

hm how can i get the level of player or name from the data base?
i tried:

Код:

stock IsPlayerAdminR(playerid)
{
    new playrname[24],str2[256];
	GetPlayerName(playerid,playrname,sizeof(playrname));
	format(str2,sizeof(str2),"SELECT `AdminLevel` FROM `rUsers` WHERE `Name`='%s'",playrname);
	new res=mysql_fetch_int(mysql_query(str2));
	return res;
}

bot this is doesn't work....
as you can see i new in all that MYSQL+PAWNO stuff...

Re: [MySql Help] Get a value from db - Cameltoe - 12.11.2010

Quote:

Originally Posted by XePloiT

hm how can i get the level of player or name from the data base?
i tried:

Код:

stock IsPlayerAdminR(playerid)
{
    new playrname[24],str2[256];
	GetPlayerName(playerid,playrname,sizeof(playrname));
	format(str2,sizeof(str2),"SELECT `AdminLevel` FROM `rUsers` WHERE `Name`='%s'",playrname);
	new res=mysql_fetch_int(mysql_query(str2));
	return res;
}

bot this is doesn't work....
as you can see i new in all that MYSQL+PAWNO stuff...

Why did you make yet another thread on this?

Re: [MySql Help] Get a value from db - XePloiT - 12.11.2010

well i don't need the another one because i started all of my system from the beginning to use mysql in them