Mysql no save - Printable Version

Mysql no save - 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 no save (/showthread.php?tid=611979)

Mysql no save - Izaki - 13.07.2016

LOG Mysql

PHP код:



[09:20:10] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2

[09:20:10] [DEBUG] CMySQLHandle::Create - creating new connection..

[09:20:10] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called

[09:20:10] [DEBUG] CMySQLHandle::Create - connection created (id: 1)

[09:20:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] mysql_errno - connection: 1

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"

[09:20:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'Damar' LIMI", callback: "OnAccountCheck", format: "i"

[09:20:49] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution

[09:20:51] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 1662.285 milliseconds

[09:20:51] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[09:20:51] [DEBUG] Calling callback "OnAccountCheck"..

[09:20:51] [DEBUG] cache_get_data - connection: 1

[09:20:51] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129

[09:20:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"

[09:20:51] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[09:20:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "2"

[09:20:51] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[09:21:03] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"

[09:21:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'Damar' LIMIT 1", callback: "OnAccountLoad", format: "i"

[09:21:03] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution

[09:21:03] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 16.311 milliseconds

[09:21:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[09:21:03] [DEBUG] Calling callback "OnAccountLoad"..

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"

[09:21:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

What 's wrong with my mysql ?

Re: Mysql no save - Napst34 - 13.07.2016

It doesn't save what ?

Re: Mysql no save - Izaki - 13.07.2016

PHP код:



[09:20:10] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "database", password: "****", port: 3306, autoreconnect: true, pool_size: 2

[09:20:10] [DEBUG] CMySQLHandle::Create - creating new connection..

[09:20:10] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called

[09:20:10] [DEBUG] CMySQLHandle::Create - connection created (id: 1)

[09:20:10] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] mysql_errno - connection: 1

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - establishing connection to database...

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:11] [DEBUG] CMySQLConnection::Connect - connection was successful

[09:20:11] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled

[09:20:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = '%e' LIMIT 1"

[09:20:49] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `users` WHERE `Name` = 'Damar' LIMI", callback: "OnAccountCheck", format: "i"

[09:20:49] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution

[09:20:51] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 1662.285 milliseconds

[09:20:51] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[09:20:51] [DEBUG] Calling callback "OnAccountCheck"..

[09:20:51] [DEBUG] cache_get_data - connection: 1

[09:20:51] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129

[09:20:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "FD9D94340DBD72C11B37EBB0D2A19B4D05E00FD78E4E2CE8923B9EA3A54E900DF181CFB112A8A73228D1F3551680E2AD9701A4FCFB248FA7FA77B95180628BB2"

[09:20:51] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1

[09:20:51] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "2"

[09:20:51] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[09:21:03] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `users` WHERE `Name` = '%e' LIMIT 1"

[09:21:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `users` WHERE `Name` = 'Damar' LIMIT 1", callback: "OnAccountLoad", format: "i"

[09:21:03] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution

[09:21:03] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 16.311 milliseconds

[09:21:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called

[09:21:03] [DEBUG] Calling callback "OnAccountLoad"..

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pAdminLevel", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pAdminLevel", data: "0"

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Premium", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Premium", data: "0"

[09:21:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "pEXP", connection: 1

[09:21:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pEXP", data: "0"

[09:21:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[09:40:07] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,"

[09:40:07] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `database` SET `pEXP` = 0, `Premium` = 0, `pAdminLevel` =", callback: "(null)", format: "(null)"

[09:40:07] [DEBUG] CMySQLQuery::Execute[] - starting query execution

[09:40:07] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

[09:40:07] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

Re: Mysql no save - itsCody - 13.07.2016

[09:40:07] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Post where you save your stuff.

Re: Mysql no save - Izaki - 13.07.2016

PHP код:



public OnPlayerDisconnect(playerid, reason)
{
    new query[128];

    mysql_format(mysql, query, sizeof(query), "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,",
    pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel]);
    mysql_tquery(mysql, query, "", "");
    

    SetPVarInt(playerid, "laser", 0);
     RemovePlayerAttachedObject(playerid, 0);
    if(InfectedLeft[playerid] == 1)
    {
        ZombieTimer = SetTimer("ZombieCounts",3000,1);
        InfectedLeft[playerid] = 0;
    }
    return 1;
}

Re: Mysql no save - Flake. - 13.07.2016

Quote:

Originally Posted by Izaki

PHP код:



public OnPlayerDisconnect(playerid, reason)

{

    new query[128];


    mysql_format(mysql, query, sizeof(query), "UPDATE `database` SET `pEXP` = %d, `Premium` = %d, `pAdminLevel` = %d,",

    pInfo[playerid][pEXP], pInfo[playerid][Premium], pInfo[playerid][pAdminLevel]);

    mysql_tquery(mysql, query, "", "");

    


    SetPVarInt(playerid, "laser", 0);

     RemovePlayerAttachedObject(playerid, 0);

    if(InfectedLeft[playerid] == 1)

    {

        ZombieTimer = SetTimer("ZombieCounts",3000,1);

        InfectedLeft[playerid] = 0;

    }

    return 1;

}

As you're trying to update a players stats you need to assign the update somewhere rather than updating the database and hoping it does something.

PHP код:



UPDATE `table.name` SET `pEXP`='%i', `Premium`='%i', `pAdminLevel` = '%i' WHERE `ID`='%d'

Re: Mysql no save - Izaki - 13.07.2016

PHP код:



[00:01:51] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:01:51] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
[00:01:51] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError