[MadSkillz]

I'm learning SQLite and been trying constantly to retrieve `ADMINLEVEL` from my data. I've tried many ways but failed.

I need advise on how to do it because.. no matter every way i've tried I allways failed.

Код:

COMMAND:setlevel(playerid, params[])
{
	new id,lvl,string[128];
	new pName[24], pTame[24];
	new targetid;
	GetPlayerName(playerid,pName,24);
	GetPlayerName(targetid,pTame,24);
	new
  	DBResult: Result,
   	name[ MAX_PLAYER_NAME ];
	new Field[ 20 ];
	GetPlayerName(playerid, name, sizeof(name));
	format(db_query, 128, "SELECT `ADMINLEVEL` FROM `USERS` WHERE `NAME` = '%s'", name);
	db_get_field_assoc(Result, "ADMINLEVEL", Field, 30);
	Bit16_Set(g_AdminLevel, playerid, strval(Field));
	if(g_AdminLevel[playerid] < 0) return SendClientMessage(playerid,COLOR_RED,"You Are Not Allowed Access To This Command!");
	if(sscanf(params,"ui",id,lvl)) return SendClientMessage(playerid,COLOR_GREEN,""COL_GREY"/setlevel [PlayerID] [Level]");
	if(!IsPlayerConnected(targetid)) return SendClientMessage(playerid, COLOR_WHITE, ""COL_RED"[ERROR]"COL_CMD" Player Not Connected!");
	format(string,sizeof(string),"%s Has Been Promoted To Admin Level:(%d) By Administrator: %s",pTame,lvl,pName);
	SendClientMessage(id,COLOR_GREEN,string);
	if(PlayerInfo[id][AdminLevel] < lvl)
	{
	    GameTextForPlayer(id,"~g~~h~~h~Promoted!",4000,3);
	}
	if(PlayerInfo[id][AdminLevel] > lvl)
	{
	    GameTextForPlayer(id,"~r~~h~Demoted!",4000,3);
	}
	format(string,sizeof(string),"%s(%d) Has Been Set To Level %d",pTame,id,lvl);
	SendClientMessage(playerid,COLOR_GREEN,string);
	PlayerInfo[id][AdminLevel] = lvl;
	return 0;
}

This code is just 1 of my other codes!

Don't treat me like a retard if it's not right... I've tried.. That's all that counts!