1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql no save
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#1

13.07.2016, 02:24
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 ?
Find
Reply
Napst34
Big Clucker
***
Posts: 55
Threads: 1
Joined: May 2015
Reputation: 0
#2

13.07.2016, 02:47
It doesn't save what ?
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#3

13.07.2016, 04:33
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 
Find
Reply
itsCody
Gangsta
****
Posts: 519
Threads: 21
Joined: Nov 2012
Reputation: 0
#4

13.07.2016, 04:52
[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.
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#5

13.07.2016, 05:07
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;
} 
Find
Reply
Flake.
High-roller
*****
Posts: 1,166
Threads: 44
Joined: Sep 2009
Reputation: 0
#6

13.07.2016, 05:27
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' 
Find
Reply
Izaki
Big Clucker
***
Posts: 81
Threads: 38
Joined: Sep 2014
Reputation: 0
#7

13.07.2016, 17:03
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 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help