[MySQL] GetPlayerAdminLevel(playerid)
#2

Quote:
new string[1337], playername[MAX_PLAYER_NAME], PlayerAdminLevel[2];
GetPlayerName(playerid, playername, sizeof(playername));

format(string, sizeof(string), "SELECT * FROM `Users` WHERE `Name` ='%s'", playername);

what a waste of cells you use 39 + MAX_PLAYER_NAME = 59 cells max with this query... lol'd

also
Quote:

mysql_fetch_field
Use this function to get name of specific field.

not sure which mysql plugin are you using..

also you may want to return strval(PlayerAdminLevel) instead of a string.

are you sure you want to retrieve all fields? using "SELECT `AdminLevel` [..]" would be more reasonable I think..
Reply


Messages In This Thread
[MySQL] GetPlayerAdminLevel(playerid) - by Unknown123 - 20.05.2011, 15:06
Re: [MySQL] GetPlayerAdminLevel(playerid) - by KoczkaHUN - 20.05.2011, 15:17
Re: [MySQL] GetPlayerAdminLevel(playerid) - by Sascha - 20.05.2011, 15:34
Re: [MySQL] GetPlayerAdminLevel(playerid) - by Unknown123 - 20.05.2011, 17:07
Re: [MySQL] GetPlayerAdminLevel(playerid) - by steki. - 20.05.2011, 17:47
Re: [MySQL] GetPlayerAdminLevel(playerid) - by Unknown123 - 20.05.2011, 17:52
Re: [MySQL] GetPlayerAdminLevel(playerid) - by KoczkaHUN - 20.05.2011, 19:14
Re: [MySQL] GetPlayerAdminLevel(playerid) - by DRIFT_HUNTER - 20.05.2011, 20:03

Forum Jump:


Users browsing this thread: 1 Guest(s)