/*
urmatoarele:
- in baza de date trebuie adaugat:
( => `ClanName` varchar(42) NOT NULL DEFAULT 'None' <= )
( => `ClanTag` varchar(42) NOT NULL DEFAULT 'None' <= )
adaugi la playerdata sau cum ai definit enum-ul
ClanTag[24], ClanName[32] ...
*/
stock PN(playerid)
{
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
return name;
}
stock LoadPlayerClan(playerid) // Incarca detaliile
{
if(Player[playerid][ClanID] != 0)
{
new Query[128], cTag[24], cName[32];
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Name` = '%s' LIMIT 1", PN(playerid));
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
new Cache: result = mysql_query(SQL, Query);
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
cache_delete(result);
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
cTag = cache_get_field_content_int(0, "ClanTag", SQL);
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
cName = cache_get_field_content_int(0, "ClanName", SQL);
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
format(Player[playerid][ClanTag], 24, "%s", cTag);
format(Player[playerid][ClanName], 32, "%s", cName);
}
return true;
}
stock LoadPlayerClanName(playerid)
{
new String[128];
//
if(strfind(Player[playerid][ClanName], "None", true) == -1)
{
format(String, sizeof(String), "%s", Player[playerid][ClanName]);
}
else
{
String = "";
}
return String;
}
stock LoadPlayerClanTag(playerid)
{
new String[128];
//
if(strfind(Player[playerid][ClanTag], "None", true) == -1)
{
format(String, sizeof(String), "%s", Player[playerid][ClanTag]);
}
else
{
String = "";
}
return String;
}
stock SavePlayerClan(playerid)
{
new Query[128];
//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
if(Player[playerid][ClanID] != 0)
{
format(Query, sizeof(Query), "UPDATE `Users` SET `ClanName` = '%s', `ClanTag` = '%s' WHERE `Name` = '%s'", Player[playerid][ClanName], Player[playerid][ClanTag], PN(playerid));
mysql_tquery(SQL, Query, "", "");
}
}