SA-MP Forums Archive
SQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL (/showthread.php?tid=290738)



SQL - Cowboy - 16.10.2011

Hello,

from this code from CamelToe's gang fs

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;
}
How would I be able to convert this code to sqlite

pawn Код:
PlayerInfo[playerid][Gang] = mysql_insert_id();



Re: SQL - Cowboy - 17.10.2011

Anyone?


Re: SQL - [HiC]TheKiller - 17.10.2011

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.


Re: SQL - Cowboy - 17.10.2011

No other way? I'd rather not interfere with the database so much