Colors - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Colors (
/showthread.php?tid=309020)
Colors -
Tanush123 - 06.01.2012
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;
}
Re: Colors -
Jefff - 06.01.2012
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