pawn Код:
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, GetPlayerNameEx(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);
mysql_query(Query);
PlayerInfo[playerid][Gang] = mysql_insert_id();
format(Query, sizeof(Query), "UPDATE users SET gang = %d WHERE username = '%s';", PlayerInfo[playerid][Gang], GetPlayerNameEx(playerid));
mysql_query(Query);
return 1;
}
With SQLite, you would probably need to use a SELECT statement to get the auto increment ID and use it later on, or you could use the owner or name values to find the line that you want to update.