Help please guys! - Printable Version

Help please guys! - 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: Help please guys! (/showthread.php?tid=643941)

Help please guys! - Maximun - 30.10.2017

Hello everyone, today I'm facing a problem with mysql (Register System), it doesn't create an account on Database
Here's the details : (I'm using R39-4, guys)

PHP код:



#define SQL_HOSTNAME "127.0.0.1"

#define SQL_USERNAME "root"

#define SQL_DATABASE "srvdata"

#define SQL_PASSWORD ""


forward SQL_Connect(); //Here's the connection mysql

public SQL_Connect()

{

    SQL = mysql_connect(SQL_HOSTNAME, SQL_USERNAME, SQL_DATABASE, SQL_PASSWORD);

    printf("Connecting MYSQL"); //It appears on log

    return 1;

}

PHP код:



Dialog:Register(playerid, response, listitem, inputtext[])

{

    if(!response || !strlen(inputtext))

    {

        SendClientMessage(playerid, COULEUR_GRIS,"Veuillez mettrer un mot de passe..");

        Kick(playerid);

        return 1;

    }

        else if(strlen(inputtext) > 4)

    {

        new query[400];

            mysql_format(SQL, query, sizeof(query), "INSERT INTO srv_users (Username, Password) VALUES ('%e','%e')",ReturnName(playerid), inputtext);

        mysql_tquery(SQL, query,"","");

        printf("%s", query); //It appears on log

    }

    return 1;

}

When I check 'srv_users' I don't see any account.
Visibly, I see that everything is correct, I don't really know what's wrong
Any question please I'm here

Logs:

Код:

[17:05:54] [connection] incoming connection: 127.0.0.1:64888 id: 0
[17:05:55] [join] Usaki_Mortsi has joined the server (0:127.0.0.1)
[17:06:00] INSERT INTO srv_users (Username, Password) VALUES('Usaki_Mortsi','mdpduserv')
[17:07:37] [part] Usaki_Mortsi has left the server (0:1)

Re: Help please guys! - Konstantinos - 30.10.2017

This is not the way to say that the connection was actually successful. See: https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_errno

Check your mysql logs for any error, the connection handle might be invalid (could not connect).

Also consider hashing the passwords + salt for security. Plain text for them is really bad.

Re: Help please guys! - Maximun - 30.10.2017

That's true! But the connection of Mysql is certainly successful, while I get the dialog of registration.
And yeah @Konstantinos I tried 'mysql_errno', I found on logs that it's loaded.
I think the problem is here :

PHP код:



mysql_format(SQL, query, sizeof(query), "INSERT INTO srv_users (Username, Password) VALUES ('%e','%e')",ReturnName(playerid), inputtext);

Re: Help please guys! - kingmk - 30.10.2017

Make sure you write the tabel name "srv_users" correct and the check if columns exist in tabel, "Username" and "Password". You need to use the same letters (CAPS or NO-CAPS), this can modifie the ASCII and I think it could give u an error.

Re: Help please guys! - Maximun - 30.10.2017

I really hope if it was something like this..
But as you see at the pictures

Re: Help please guys! - Konstantinos - 30.10.2017

Find mysql_log.txt and delete the file (unless HTML is supported, I think it is no longer). Set:

pawn Код:

mysql_log(LOG_ALL);

Start the server again and try to register a new account. Check again the mysql logs - that's the only way to know what is wrong.

Re: Help please guys! - Maximun - 30.10.2017

I have done what you requested me @Konstantinos

Quote:

[22:57:28] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:57:28] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de '(ID, Username, Password) VALUES (0, 'Usaki_Mortsi', 'lslsl')' а la ligne 1
[22:57:28] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Sincerely, I don't see what the error want to say..?
I'm using this script right now

PHP код:



        static

        query[512];

        mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `srv_users` (ID, Username, Password) VALUES (%d, '%e', '%e')",cache_insert_id(), ReturnName(playerid), inputtext);

        mysql_tquery(g_iHandle, query);

        mysql_log(LOG_ALL);

EDIT: Thanks to this thread, I resolved this problem, at the same time I got another one

Quote:

[23:12:04] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[23:12:04] [ERROR] CMySQLQuery::Execute[] - (error #1054) Champ 'Usaki_Mortsi' inconnu dans field list
[23:12:04] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

So here I am stuck

Re: Help please guys! - Konstantinos - 31.10.2017

mysql_log should be executed once before the mysql_connect line. cache_insert_id() returns 0 because no active cache (should be used in a specified callback at mysql_tquery) like this:

pawn Код:

mysql_format(g_iHandle, query, sizeof(query), "INSERT INTO `srv_users` (Username, Password) VALUES ('%e', '%e')", ReturnName(playerid), inputtext); 
mysql_tquery(g_iHandle, query, "OnPlayerRegister", "i", playerid);

pawn Код:

forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    // cache_insert_id() will return the "ID" if the field has been set..
    // as AUTO_INCREMENT, must also be set as PRIMARY key
}

---

About the last, Usaki_Mortsi is unknown column to your database. Create it or check if you misspelled it.

Re: Help please guys! - Maximun - 31.10.2017

I really appreciate your help @Konstantinos with me
Problem is solved, thank you really Konstantinos!
+1