Mysql problem - Printable Version

Mysql problem - 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 (/showthread.php?tid=569867)

Mysql problem - AlexBlack - 03.04.2015

Hi, i have a small mysql problem, so my accounts doesn't load , i have check mysql log i have find this ( i'am using mysql on PPC_Trucking )

pawn Код:

[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsAssistance", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Jailed", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Bans", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "BanTime", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "TruckerLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "BusLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "PilotLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "MafiaLicense", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Team", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Leader", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_float - row: 0, field_name: "StatsMetersDriven", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_float - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsTruckerJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsConvoyJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsBusDriverJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPilotJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsMafiaJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsMafiaStolen", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPoliceFined", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsPoliceJailed", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsCourierJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "StatsRoadworkerJobs", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "RulesRead", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Muted", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Minutesjouer", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype
[15:22:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Heuresjouer", connection: 1
[15:22:57] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:22:57] [ERROR] cache_get_field_content_int - invalid datatype

my code

PHP код:



public PlayerFile_Load(playerid)

{

    APlayerData[playerid][StatsAssistance] = cache_get_field_content_int(0, "StatsAssistance");

    APlayerData[playerid][PlayerLevel] = cache_get_field_content_int(0, "Level");

    APlayerData[playerid][VIPLevel] = cache_get_field_content_int(0, "VIP");

    APlayerData[playerid][PlayerJailed] = cache_get_field_content_int(0, "Jailed");

    APlayerData[playerid][Bans] = cache_get_field_content_int(0, "Bans");

    APlayerData[playerid][BanTime] = cache_get_field_content_int(0, "BanTime");

    APlayerData[playerid][TruckerLicense] = cache_get_field_content_int(0, "TruckerLicense");

    APlayerData[playerid][BusLicense] = cache_get_field_content_int(0, "BusLicense");    

    APlayerData[playerid][PilotLicense] = cache_get_field_content_int(0, "PilotLicense");    

    APlayerData[playerid][MafiaLicense] = cache_get_field_content_int(0, "MafiaLicense");    

    APlayerData[playerid][Team] = cache_get_field_content_int(0, "Team");    

    APlayerData[playerid][Leader] = cache_get_field_content_int(0, "Leader");

    APlayerData[playerid][StatsMetersDriven] = cache_get_field_content_float(0, "StatsMetersDriven");

    APlayerData[playerid][StatsTruckerJobs] = cache_get_field_content_int(0, "StatsTruckerJobs");

    APlayerData[playerid][StatsConvoyJobs] = cache_get_field_content_int(0, "StatsConvoyJobs");

    APlayerData[playerid][StatsBusDriverJobs] = cache_get_field_content_int(0, "StatsBusDriverJobs");

    APlayerData[playerid][StatsPilotJobs] = cache_get_field_content_int(0, "StatsPilotJobs");

    APlayerData[playerid][StatsMafiaJobs] = cache_get_field_content_int(0, "StatsMafiaJobs");

    APlayerData[playerid][StatsMafiaStolen] = cache_get_field_content_int(0, "StatsMafiaStolen");

    APlayerData[playerid][StatsPoliceFined] = cache_get_field_content_int(0, "StatsPoliceFined");

    APlayerData[playerid][StatsPoliceJailed] = cache_get_field_content_int(0, "StatsPoliceJailed");

    APlayerData[playerid][StatsCourierJobs] = cache_get_field_content_int(0, "StatsCourierJobs");

    APlayerData[playerid][StatsRoadworkerJobs] = cache_get_field_content_int(0, "StatsRoadworkerJobs");

    APlayerData[playerid][PlayerMoney] = cache_get_field_content_int(0, "Money");

    APlayerData[playerid][PlayerScore] = cache_get_field_content_int(0, "Score");

    APlayerData[playerid][RulesRead] = cache_get_field_content_int(0, "RulesRead");

    APlayerData[playerid][Muted] = cache_get_field_content_int(0, "Muted");

    

    APlayerData[playerid][pMinutes] = cache_get_field_content_int(0, "Minutesjouer");

    APlayerData[playerid][pHeures] = cache_get_field_content_int(0, "Heuresjouer");

    printf("SERVER STATS : AN ACCOUNT HAVE BEEN LOADED.");

    return 1;

}

Thx for advance.

Re : Mysql problem - AlexBlack - 03.04.2015

anyone please?

Re: Mysql problem - willsuckformoney - 03.04.2015

Have you downloaded MySQL r39 plugin and added it to your server folders and recompiled your script?

Re: Mysql problem - Chlorine - 03.04.2015

Can you show me the query which is executed?
The row which the script is trying to retrieve doesn't exist in the database.

Re : Mysql problem - AlexBlack - 03.04.2015

@will yes, i have the compatible version ( mysql R39-2)

@Chlorine yes check

PHP код:



public OnAccountCheck(playerid)

{

    new rows, fields, string[240], plrIP[16];

    GetPlayerIp(playerid, plrIP, sizeof(plrIP));

    cache_get_data(rows, fields, g_iHandle);

    if(rows) //if there is row

    {

        cache_get_field_content(0, "Password", APlayerData[playerid][PlayerPassword], g_iHandle, 129);

        APlayerData[playerid][CompteID] = cache_get_field_content_int(0, "ID");

        printf("MDP CHARGE : %s", APlayerData[playerid][PlayerPassword]);

        format(string, 2000, TXT_DialogLoginMsg, GetPlayerNameEx(playerid), plrIP);

        ShowPlayerDialog(playerid, DialogLogin, DIALOG_STYLE_PASSWORD, TXT_DialogLoginTitle, string, TXT_DialogLoginButton1, TXT_DialogButtonCancel);

    }

    else

    {

        new strStartRules[2000];

                // RULES TEXT

        ShowPlayerDialog(playerid, DialogStartRules, DIALOG_STYLE_MSGBOX, "Rиglement du serveur", strStartRules, "Refuser", "Accepter");

    }

    printf("ETAT DU SERVEUR : CHECK D'UN COMPTE");

    return 1;

}

Query :

PHP код:



    mysql_format(g_iHandle, query, sizeof(query),"SELECT `Password`, `ID` FROM `users` WHERE `PlayerName` = '%e' LIMIT 1", GetPlayerNameEx(playerid));

    mysql_tquery(g_iHandle, query, "OnAccountCheck", "i", playerid);

Dialog response :

PHP код:



// Process the login-dialog

Dialog_Login(playerid, response, inputtext[])

{

    switch (response) // Check which button was clicked

    {

        case 1: // Player clicked "Login"

        {

            // Check if the player entered a password

            if (strlen(inputtext) > 0)

            {

                new query[100]; // for formatting our query.

                if(!strcmp(inputtext, APlayerData[playerid][PlayerPassword])) 

                { 

                    mysql_format(g_iHandle, query, sizeof(query), "SELECT * FROM `users` WHERE `ID` = '%d' LIMIT 1", APlayerData[playerid][CompteID]);

                    mysql_tquery(g_iHandle, query, "PlayerFile_Load", "i", playerid);

                    

                    mysql_format(g_iHandle, query, sizeof(query), "SELECT * FROM `bank` WHERE `ID` = '%d' LIMIT 1", APlayerData[playerid][CompteID]);

                    mysql_tquery(g_iHandle, query, "BankFile_Load", "i", playerid);


                    format(query, sizeof(query), "UPDATE `users` SET `LoggedIN` = '1' WHERE `ID` = %d", APlayerData[playerid][CompteID]);

                    mysql_format(g_iHandle, query, sizeof(query), "%s", query);

                    mysql_tquery(g_iHandle, query); 

    

                    APlayerData[playerid][LoggedIn] = true;

                }

                else

                {

                    ShowPlayerDialog(playerid, DialogLogin, DIALOG_STYLE_PASSWORD, TXT_DialogLoginTitle, TXT_LoginEnterPasswordWrong, TXT_DialogLoginButton1, TXT_DialogButtonCancel);

                }

                return 1;

            }

            else

            {

                SendClientMessage(playerid, 0xFFFFFFFF, TXT_WrongPassword);

                KickEx(playerid);

            }

        }

        case 0: // Player clicked "Cancel"

        {

            // Show a message that the player must be logged in to play on this server

            SendClientMessage(playerid, 0xFFFFFFFF, TXT_PlayerMustLogin);

            // Kick the player

            KickEx(playerid);

        }

    }


    return 1;

}

Re: Mysql problem - Chlorine - 03.04.2015

Check your database table. Clearly check if you have a row with that user id.

Re : Mysql problem - AlexBlack - 03.04.2015

i'am succesfully logged in with my password

Re: Mysql problem - Chlorine - 03.04.2015

Try to debug it:

pawn Код:

public OnAccountCheck(playerid) 
{ 
    new rows, fields, string[240], plrIP[16]; 
    GetPlayerIp(playerid, plrIP, sizeof(plrIP)); 
    cache_get_data(rows, fields, g_iHandle); 
    printf("Rows: %i, Fields: %i", rows, fields);
    if(rows) //if there is row 
    { 
        cache_get_field_content(0, "Password", APlayerData[playerid][PlayerPassword], g_iHandle, 129); 
        APlayerData[playerid][CompteID] = cache_get_field_content_int(0, "ID"); 
        printf("MDP CHARGE : %i: %s", APlayerData[playerid][Compte], APlayerData[playerid][PlayerPassword]); 
        format(string, 2000, TXT_DialogLoginMsg, GetPlayerNameEx(playerid), plrIP); 
        ShowPlayerDialog(playerid, DialogLogin, DIALOG_STYLE_PASSWORD, TXT_DialogLoginTitle, string, TXT_DialogLoginButton1, TXT_DialogButtonCancel); 
    } 
    else 
    { 
        new strStartRules[2000]; 
                // RULES TEXT 
        ShowPlayerDialog(playerid, DialogStartRules, DIALOG_STYLE_MSGBOX, "Rиglement du serveur", strStartRules, "Refuser", "Accepter"); 
    } 
    printf("ETAT DU SERVEUR : CHECK D'UN COMPTE"); 
    return 1; 
}

I've made 2 debugs (one already existed; Password).
Show me what it prints on the console.

Re : Mysql problem - AlexBlack - 03.04.2015

i have got : 1 rows and 2 fields

MDP CHARGE: 9: test

Re: Mysql problem - Chlorine - 03.04.2015

Alright then, show me your database (users table).