[Tanush123]

Well i did /setocol 1 0xFF0000FF and my name color turns red and it goes fine. It also updates it on my Database but when i restart my server i get dark blue name.
This is my onplayerspawn code

pawn Код:

format(str, sizeof(str), "SELECT Hex FROM orgs WHERE Orgid = %d",PlayerData[playerid][Member]);
        mysql_query(str);
        mysql_store_result();
        OrgInfo[PlayerData[playerid][Member]][Color] = mysql_fetch_int();
        mysql_free_result();
        SetPlayerColor(playerid,HexToInt(OrgInfo[PlayerData[playerid][Member]][Color]));
        GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep1],5000);
        GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep2],5000);
        GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep3],5000);

My cmd: setocol

pawn Код:

CMD:setocol(playerid,params[])
{
    new oncol[11];
    if(!IsPlayerAdmin(playerid)) return 0;
    if(sscanf(params,"is",orgid,oncol)) return SendClientMessage(playerid,grey,"USAGE: /setocol [orgid] [SA-MP HEX COLOR]");
    CheckMySQL();
    format(str,sizeof(str),"SELECT * FROM orgs WHERE Orgid = %d",orgid);
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        mysql_free_result();
        format(str,sizeof(str),"You have updated orgid %d hex to %s",orgid,oncol);
        SendClientMessage(playerid,COLOR_YELLOW,str);
        format(str,sizeof(str),"UPDATE orgs SET Hex = '%s' WHERE Orgid = '%d'",oncol,orgid);
        mysql_query(str);
        format(OrgInfo[orgid][Color],11,"%s",oncol);
        foreach(Player,i)
        {
            if(orgid == PlayerData[i][Member])
            {
                SetPlayerColor(i,HexToInt(OrgInfo[orgid][Color]));
            }
        }
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is not used.");
    }
    return 1;
}

[Jefff]

pawn Код:

new org_color[11];
format(str, sizeof(str), "SELECT Hex FROM orgs WHERE Orgid = %d",PlayerData[playerid][Member]);
mysql_query(str);
mysql_store_result();
if(mysql_fetch_string(org_color))
{
    sscanf(org_color,"x",OrgInfo[PlayerData[playerid][Member]][Color]);
}
mysql_free_result();
SetPlayerColor(playerid,OrgInfo[PlayerData[playerid][Member]][Color]);
GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep1],5000);
GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep2],5000);
GivePlayerWeapon(playerid,OrgInfo[PlayerData[playerid][Member]][Wep3],5000);

Better if Your field type be a integer than varchar