Es kann i.wie nur ein Clan in der DB gespeichert werden, wieso?
COMMAND:createclan(playerid,params[])
{
new query[128],clan[11],name[MAX_PLAYER_NAME],str[128];
GetPlayerName(playerid,name,sizeof(name));
if(cWar[playerid][pLeader] || cWar[playerid][pMember] ==1) return SendClientMessage(playerid,COLOR_GRAU,"Du bist bereits in einem Clan aktiv");
if(sscanf(params,"s[11]",clan)) return SendClientMessage(playerid,COLOR_GRAU,"BENUTZE: /createclan [ClanName]");
format(query,128,"INSERT INTO Clans (Clanname,Leader) VALUES ('%s','%s') ",clan,name);
mysql_function_query(mydb,query,false,"","");
format(str,128," [CLAN] {FEFEFE}Du hast dir den Clan: %s erfolgreich erstellt!",clan);
SendClientMessage(playerid,0xFF9600FF,str);
cWar[playerid][pLeader] = 1;
return 1;
}
ID in der Datenbank von dem Clan 0