Есть сис-ма кланов, точнее, немного недоделанная, не могу понять как ее нормально реализовать
PHP код:
stock CreateClan(playerid, clan_name[])
{
new query_string[74-2+15-2+24];
format(query_string, sizeof(query_string), "INSERT INTO `clans` (`name`, `leader`, `members`) VALUES ('%s', '%s', '1')", clan_name, PlayerInfo[playerid][pName]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
format(query_string, sizeof(query_string), "Клан %s создан!", clan_name);
SendClientMessage(playerid, 0xFFFFFF00, query_string);
mysql_function_query(mysql_connect_ID, "SELECT * FROM `clans`", true, "LoadClan","i");
PlayerInfo[playerid][pClan] = ClanInfo[ClanInfo[totalclan][pID]][pID];
return 1;
}
PHP код:
stock LoadClan()
{
new rows;
for(new idx = 1; idx <= rows; idx++)
{
ClanInfo[idx][pID] = cache_get_field_content_int(0, "ID", mysql_connect_ID);
ClanInfo[idx][pName] = cache_get_field_content_int(0, "name", mysql_connect_ID);
ClanInfo[idx][pLeader] = cache_get_field_content_int(0, "leader", mysql_connect_ID);
ClanInfo[idx][pMembers] = cache_get_field_content_int(0, "members", mysql_connect_ID);
totalclan ++;
}
return 1;
}