SA-MP Forums Archive
Mysql Problem ( cache_insert_id ) - 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: Mysql Problem ( cache_insert_id ) (/showthread.php?tid=574168)


Mysql Problem ( cache_insert_id ) - AlexBlack - 14.05.2015

Hi everyone , i'am now creating register/login system and i got a problem with registration , so when i'am logged in with account that i have created ( for example Account ID 17 ) , then i disconnect and reconnect with new account that i will create it In game , i got the same 'CompteID' and when my account save , the stats of my new account will be in the old account, check my PlayerFile_Create

PHP код:
forward PlayerFile_Create(playerid);
public PlayerFile_Create(playerid)
{
    APlayerData[playerid][CompteID] = cache_insert_id();
    printf("ETAT DU SERVEUR: ENREGISTREMENT D'UN COMPTE ID : %d", APlayerData[playerid][CompteID]);
    return 1;
} 
Save :

PHP код:
forward PlayerFile_Save(playerid);
public PlayerFile_Save(playerid)
{
    new query[1024]; 
    format(query, sizeof(query), "UPDATE `users` SET `Level` = %d,", APlayerData[playerid][PlayerLevel]);
    format(query, sizeof(query), "%s `VIP` = %d, `Jailed` = %d, `Wanted` = %d,", query, APlayerData[playerid][VIPLevel], APlayerData[playerid][PlayerJailed], GetPlayerWantedLevel(playerid));
    format(query, sizeof(query), "%s `Bans` = %d, `BanTime` = %d, `TruckerLicense` = %d,", query, APlayerData[playerid][Bans], APlayerData[playerid][BanTime], APlayerData[playerid][TruckerLicense]);
    format(query, sizeof(query), "%s `BusLicense` = %d, `PilotLicense` = %d,", query, APlayerData[playerid][BusLicense], APlayerData[playerid][PilotLicense]);
    format(query, sizeof(query), "%s `MafiaLicense` = %d, `Muted` = %d,", query, APlayerData[playerid][MafiaLicense], APlayerData[playerid][Muted]);
    format(query, sizeof(query), "%s `RulesRead` = %d, `StatsMetersDriven` = %d, `LastLoggin` = %d,", query, APlayerData[playerid][RulesRead], APlayerData[playerid][StatsMetersDriven], ReturnDate());
    format(query, sizeof(query), "%s `StatsTruckerJobs` = %d, `StatsConvoyJobs` = %d,", query, APlayerData[playerid][StatsTruckerJobs], APlayerData[playerid][StatsConvoyJobs]);
    format(query, sizeof(query), "%s `StatsBusDriverJobs` = %d, `StatsPilotJobs` = %d,", query, APlayerData[playerid][StatsBusDriverJobs], APlayerData[playerid][StatsPilotJobs]);
    format(query, sizeof(query), "%s `StatsMafiaJobs` = %d, `StatsMafiaStolen` = %d,", query, APlayerData[playerid][StatsMafiaJobs], APlayerData[playerid][StatsMafiaStolen]);
    format(query, sizeof(query), "%s `StatsPoliceFined` = %d, `StatsPoliceJailed` = %d,", query, APlayerData[playerid][StatsPoliceFined], APlayerData[playerid][StatsPoliceJailed]);
    format(query, sizeof(query), "%s `StatsCourierJobs` = %d, `StatsRoadworkerJobs` = %d,", query, APlayerData[playerid][StatsCourierJobs], APlayerData[playerid][StatsRoadworkerJobs]);
    format(query, sizeof(query), "%s `StatsAssistance` = %d, `Team` = %d, `Leader` = %d,", query, APlayerData[playerid][StatsAssistance], APlayerData[playerid][Team], APlayerData[playerid][Leader]);
    format(query, sizeof(query), "%s `Heuresjouer` = %d, `Minutesjouer` = %d,", query, APlayerData[playerid][pHeures], APlayerData[playerid][pMinutes]);
    format(query, sizeof(query), "%s `Money` = %d, `Score` = %d WHERE `ID` = %d", query, APlayerData[playerid][PlayerMoney], APlayerData[playerid][PlayerScore], APlayerData[playerid][CompteID]);
    mysql_format(g_iHandle, query, sizeof(query), "%s", query);
    mysql_tquery(g_iHandle, query); 
    printf("STATS DU SERVEUR | ENREGISTREMENT MYSQL : %s", query);
    return 1;
} 
Thank's for reading.

Re: Mysql Problem ( cache_insert_id ) - Konstantinos - 14.05.2015

Is the "ID" field set with auto increment in the table structure?

Re : Mysql Problem ( cache_insert_id ) - AlexBlack - 14.05.2015

Yes it is.

PHP код:

CREATE TABLE IF NOT EXISTS `users` (
  `ID` int(12) NOT NULL AUTO_INCREMENT, 
PHP код:
  PRIMARY KEY (`ID`) 


Re: Mysql Problem ( cache_insert_id ) - Konstantinos - 14.05.2015

I can only think of 2 things (not sure about the second one though):

- In INSERT query, ID is given a value instead of being NULL.
- Multiply connections have different connection handle so using "1" as default might conflict.

Re : Re: Mysql Problem ( cache_insert_id ) - AlexBlack - 14.05.2015

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
I can only think of 2 things (not sure about the second one though):

- In INSERT query, ID is given a value instead of being NULL.
- Multiply connections have different connection handle so using "1" as default might conflict.
When i connect with old account that i have create it , i got ID 17 , i disconnect everything is OK , all work in save system , then i reconnect with new name that it's not register in database i create account and i disconnect second time the second account will take ID 17 and everything in the old account will take the stats of the new account ( everything will be 0 because it's a new account ).

Re : Mysql Problem ( cache_insert_id ) - AlexBlack - 14.05.2015

i think problem can be here ( in registration dialog )

PHP код:
Dialog_Register(playerid, response, passwordtext[])
{
    new file[100], Name[MAX_PLAYER_NAME]; // Setup local variables
    GetPlayerName(playerid, Name, sizeof(Name)); // Get the playername
    format(file, sizeof(file), PlayerFile, Name); // Construct the complete filename for this player's account
    switch (response) // Check which button was clicked
    {
        case 1: // Player clicked "Register"
        {
            // Check if the player entered a password
            if(strlen(passwordtext) > 0)
            {
                new query[300];
                // mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `users` (`PlayerName`, `Password`) VALUES ('%e', '%s')", GetPlayerNameEx(playerid), passwordtext);
                mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `users` (`PlayerName`, `Password`, `email`) VALUES ('%e', '%s', '%s')", GetPlayerNameEx(playerid), passwordtext, APlayerData[playerid][Email]);
                mysql_tquery(g_iHandle, query, "", "i", playerid);
                
                // Send a message to the client to inform him that his account has been registered
                SendClientMessage(playerid, 0xFFFFFFFF, TXT_AccountRegistered);
                APlayerData[playerid][LoggedIn] = true; // The player has logged in properly
            }
            else
            {
                SendClientMessage(playerid, 0xFFFFFFFF, TXT_WrongPassword);
                KickEx(playerid);
            }
        }
        case 0: // Player clicked "Cancel"
        {
            // Show a message that the player must be registered to play on this server
            SendClientMessage(playerid, 0xFFFFFFFF, TXT_PlayerMustRegister);
            // Kick the player
            KickEx(playerid);
        }
    }
    return 1;
} 
EDIT :

i didn't use "PlayerFile_Create" anywhere.

Re: Mysql Problem ( cache_insert_id ) - Konstantinos - 14.05.2015

Yes, you didn't.
pawn Код:
mysql_tquery(g_iHandle, query, "PlayerFile_Create", "i", playerid);