pawn Code:
command(creategang, playerid, params[])
{
new string[128], gName[100], Query[200];
if(PlayerInfo[playerid][Gang] != 0) return SendClientMessage(playerid, COLOR_YELLOW, "You are already an member of an gang, please quit that gang before creating a new one.");
if(sscanf(params, "s[100]", gName)) return SendClientMessage(playerid, COLOR_YELLOW, "Usage: /creategang [ Gang-name ].");
if(CheckGangByName(gName)) return SendClientMessage(playerid, COLOR_YELLOW, "An gang with this name already exists.");
format(Query, sizeof(Query), "INSERT INTO gangs (id, name, owner) VALUES (NULL, '%s', '%s');", gName, PlayerName(playerid));
format(string, sizeof(string), "You created an gang with name : %s, you were sat as owner of the gang.", gName);
SendClientMessage(playerid, COLOR_GREEN, string);
db_query( Database, Query );
PlayerInfo[playerid][Gang] = mysql_insert_id();
format(Query, sizeof(Query), "UPDATE users SET gang = %d WHERE username = '%s';", PlayerInfo[playerid][Gang], PlayerName(playerid));
db_query( Database, Query );
return 1;
}