public OnQueryFinish(query[], resultid, extraid, connectionHandle) // this is for threaded SQL queries
{
    switch(resultid)
    {
        case qDefault: return 1;
        case qAuthentication:
        {
            mysql_store_result();
            if(mysql_num_rows() == 1)
            {
                new szResult[500];
                while(mysql_fetch_row_format(szResult, "|"))
                {
                    sscanf(szResult, "e<p<|>s[25]s[30]ddddddddddddddffdddd>", PlayerInfo[extraid]);
                    SPD(extraid, diagAuthentication);
                }
            }
            else if(mysql_num_rows() < 1) SPD(extraid, diagRegistration);
            else SendClientMessage(extraid, COLOR_RED, "There appears to be a problem in our database, please contact an administrator.");
            mysql_free_result();
        }
    }
    return 1;
}

CMD:makeadmin(playerid,params[])
{
    if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pAdminLevel] >= 1337) //the one who typed it
    {
        new string[128],name[MAX_PLAYER_NAME],pID,Level;
        GetPlayerName(playerid,name,MAX_PLAYER_NAME);
        if(j_sscanf(params,"ui",pID,Level)) return SendClientMessage(playerid,COLOR_GREY,"/makeadmin <player> <level>");
        if(IsPlayerConnected(pID))
        {
            if(PlayerInfo[pID][pAdminLevel] != Level)
            {
                if(PlayerInfo[pID][pAdminLevel] < Level)
                {
                    PlayerInfo[pID][pAdminLevel] = Level;
                    format(string,sizeof(string),"** ADMIN PROMOTE: %s Is Now An Administrator Level %d!",name,Level);
                    SendClientMessageToAll(COLOR_PINK,string);
                    GameTextForPlayer(pID,"~g~Promoted",3000,4);
                }
                else
                {
                    GameTextForPlayer(pID,"~r~Demoted",3000,4);
                    format(string,sizeof(string),"** ADMIN DEMOTE: %s Has Been Demoted To Level %d!",name,Level);
                    SendClientMessageToAll(COLOR_PINK,string);
                    PlayerInfo[pID][pAdminLevel] = Level;
                }
            }
            else return SendClientMessage(playerid, COLOR_RED, "This player is already that level.");
        }
        else return SendClientMessage(playerid, COLOR_RED, "Invalid Player Specified.");
    }
    else return 0;
    return 1;
}

CMD:makeadmin(playerid,params[])
{
    if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pAdminLevel] >= 1337) //the one who typed it
    {
        new string[128],name[MAX_PLAYER_NAME],pID,Level,query[128];
        if(j_sscanf(params,"ui",pID,Level)) return SendClientMessage(playerid,COLOR_GREY,"/makeadmin <player> <level>");
        GetPlayerName(pID,name,MAX_PLAYER_NAME);//i think there was a mistake here. You were getting the name of who typed it instead of whom you made admin
        if(IsPlayerConnected(pID))
        {
            if(PlayerInfo[pID][pAdminLevel] != Level)
            {
                if(PlayerInfo[pID][pAdminLevel] < Level)
                {
                    PlayerInfo[pID][pAdminLevel] = Level;
                    format(string,sizeof(string),"** ADMIN PROMOTE: %s Is Now An Administrator Level %d!",name,Level);
                    SendClientMessageToAll(COLOR_PINK,string);
                    GameTextForPlayer(pID,"~g~Promoted",3000,4);
                    format(query,128,"UPDATE Accounts SET AdminLevel=%d Where Name='%s'",Level,name);//Name field is correct right?
                    mysql_query(query);
                }
                else
                {
                    GameTextForPlayer(pID,"~r~Demoted",3000,4);
                    format(string,sizeof(string),"** ADMIN DEMOTE: %s Has Been Demoted To Level %d!",name,Level);
                    SendClientMessageToAll(COLOR_PINK,string);
                    PlayerInfo[pID][pAdminLevel] = Level;
                    format(query,128,"UPDATE Accounts SET AdminLevel=%d Where Name='%s'",Level,name);
                    mysql_query(query);
                }
            }
            else return SendClientMessage(playerid, COLOR_RED, "This player is already that level.");
        }
        else return SendClientMessage(playerid, COLOR_RED, "Invalid Player Specified.");
    }
    else return 0;
    return 1;
}