SA-MP Forums Archive
Mysql doesn't insert player data to database - 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 doesn't insert player data to database (/showthread.php?tid=629541)


Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

Hi guys, I'm learning MySQL and I get this error. I'm doing a registration system with MySQL to save the player data. But the problem is when the player register, it doesn't insert anything to my database.
PHP Code:
new pName[MAX_PLAYER_NAME], query[256];
    GetPlayerName(playerid, pName, sizeof(pName));
    mysql_format(MHandle, query, sizeof(query), "SELECT * FROM `character` WHERE `Username` = '%e' LIMIT 1", pName);
    mysql_query(MHandle, query);
    new rows;
    cache_get_row_count(rows);
    if(!rows){
        System_Scm(playerid, COLOR_YELLOW, "REGISTER", "You can register.");
        //SetupCharacter(playerid);    
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registration", "Fill your password into the box below", "Okay", "Cancel");
    } 
PHP Code:
case DIALOG_REGISTER:{
            if(response){
                if(!response) return Kick(playerid); 
                if(!strlen(inputtext) || strlen(inputtext) > 100){
                    System_Scm(playerid, COLOR_RED, "ERROR", "Password must be at least 5 words and lower than 100 words.");
                    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registration", "Fill your password into the box below to register your account", "Ok", "Cancel");
                } 
                else if(strlen(inputtext) > 0 && strlen(inputtext) < 100) 
                {
                    new pName[MAX_PLAYER_NAME], query[256];
                    new Cache:GetCache;
                    GetPlayerIp(playerid, Character[playerid][IP], 16);
                    mysql_format(MHandle, query, sizeof(query), "INSERT INTO `character` (`Username`, `Password`, `Level`, `Money`, `IP`, `posX`, `posY`, `posZ`, `posA`, `Health`, `Armour`) VALUES ('%s', 'SHA1(%s)', (1), (10000), '%s', (1958.3783), (1343.1572), (15.3746), (90.0), (100.0), (0.0))", pName, inputtext, Character[playerid][IP]);
                    GetCache = mysql_query(MHandle, query);
                    cache_delete(GetCache);
                    System_Scm(playerid, COLOR_YELLOW, "REGISTERED", "You have registered succesfully!");
                    SpawnPlayer(playerid);
                }
            }
        } 


Re: Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

Image of my database.


Re: Mysql doesn't insert player data to database - pollo97 - 28.02.2017

Below ongamemodeinit write:

Code:
mysql_log(LOG_ALL);
Then starts the server, try to register an account and paste here the log on mysql_log.txt in your samp server folder

Re: Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

Quote:
Originally Posted by pollo97
View Post
Below ongamemodeinit write:

Code:
mysql_log(LOG_ALL);
Then starts the server, try to register an account and paste here the log on mysql_log.txt in your samp server folder
Quote:

error 017: undefined symbol "LOG_ALL"
I got this error @@!

Re: Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

I didn't use mysql_log but I got this two lines in the mysql logs.
Quote:

[21:39:40] [ERROR] mysql_format: destination size '256' is too small
[21:39:40] [ERROR] error #1065 while executing query "": Query was empty


Re: Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

But I have increased the size of 'query' from 256 up to 512. And there was no empty query.

Respuesta: Mysql doesn't insert player data to database - Eloy - 28.02.2017

change your query

try it

PHP Code:
mysql_format(MHandle, query, sizeof(query), "INSERT INTO `character` (`Username`, `Password`, `Level`, `Money`, `IP`, `posX`, `posY`, `posZ`, `posA`, `Health`, `Armour`)\
 VALUES ('%s', 'SHA1(%s)', 1, 10000, '%s', 1958.3783, 1343.1572, 15.3746, 90.0, 100.0, 0.0)", pName, inputtext, Character[playerid][IP]); 
if use plugin MySQL R41-2 mysql_log(LOG_ALL); change by mysql_log(ALL);

Re: Mysql doesn't insert player data to database - DuyDang2412 - 28.02.2017

Thank you, I have fix it. Thanks for the help, this is my code.
Quote:

mysql_format(MHandle, query, sizeof(query), "INSERT INTO `character` (`Username`, `Password`, `Level`, `Money`, `IP`, `posX`, `posY`, `posZ`, `posA`, `Health`, `Armour`) VALUES ('%s', SHA1('%s'), 1, 10000, '%s', 1958.3783, 1343.1572, 15.3746, 90.0, 100.0, 0.0)", pName, inputtext, Character[playerid][IP]);