18.09.2011, 10:08
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.
This code is just 1 of my other codes!
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; }
Don't treat me like a retard if it's not right... I've tried.. That's all that counts!