Mysql Not Saving
#5

Still no luck

Quote:

[21:40:50] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "newage", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[21:40:50] [DEBUG] CMySQLHandle::Create - creating new connection..
[21:40:50] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[21:40:50] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[21:40:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:40:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:40:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:40:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:40:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:40:50] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:40:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:40:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:40:50] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:40:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:40:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:40:50] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:41:14] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = '%s' LIMIT 1"
[21:41:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Username` = 'Mike", callback: "OnAccountCheck", format: "i"
[21:41:14] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[21:41:14] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.869 milliseconds
[21:41:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:41:14] [DEBUG] Calling callback "OnAccountCheck"..
[21:41:14] [DEBUG] cache_get_data - connection: 1
[21:41:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[21:41:24] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `Admin`=%d, `VIP`=%d, `Cash`=%d, `X`=%f, `Y`=%f, `Z`=%f WHERE `ID`=%d"
[21:41:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Admin`=5, `VIP`=0, `Cash`=0, `X`=1684.297", callback: "(null)", format: "(null)"
[21:41:24] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:41:24] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.423 milliseconds
[21:41:24] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

pawn Код:
new hashpass[129], query[2500], tquery[2500];
                WP_Hash(hashpass,sizeof(hashpass),inputtext);
                format(tquery, sizeof(tquery), "INSERT INTO `accounts` (`Username`, `Password`, `IP`, `Skin`, `Cash`, `Bank`, `Gold` ,`Level`, `Respect`, `Admin`, `Helper`, `VIP`, `Tutorial`, `X`, `Y`, `Z`, `A`, `INT`, `VW`, `Health`) VALUES ('%s', '%s', '%s', 26, 5000, 10000, 1, 1, 0, 0, 0, 0,0, 0.0, 0.0, 0.0, 0.0, 0, 0, 100.0)", RPNU(playerid), hashpass, PlayerInfo[playerid][pIP]);
                mysql_format(mysql, query, sizeof(query), tquery);
                format(tquery, sizeof(tquery), "INSERT INTO `accounts` (`Armour`, `Weapon1`, `Ammo1`, `Weapon2`, `Ammo2`, `Weapon3`, `Ammo3`, `Weapon4`, `Ammo4`, `Weapon5`, `Ammo5`, `Weapon6`, `Ammo6`, `Weapon7`, `Ammo7`, `Weapon8`, `Ammo8`, `Weapon9`, `Ammo9`, `Weapon10`, `Ammo10`, `Weapon11`, `Ammo11`) VALUES (0.0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0)");
                mysql_format(mysql, query, sizeof(query), tquery);
                format(tquery, sizeof(tquery), "INSERT INTO `accounts` (`Weapon12`, `Ammo12`, `Weapon13`, `Ammo13`, `Seconds`, `Minutes`, `Hours`, `Kills`, `Deaths`, `Banned`, `BanReason`) VALUES (0,0, 0,0, 0,0, 0,0,0,0,0 'No', '')");
                mysql_format(mysql, query, sizeof(query), tquery);
Reply


Messages In This Thread
Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:05
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:20
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:29
Re: Mysql Not Saving - by Eth - 21.09.2014, 01:32
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 01:54
Re: Mysql Not Saving - by Eth - 21.09.2014, 04:50
Re: Mysql Not Saving - by Ox1gEN - 21.09.2014, 05:33
Re: Mysql Not Saving - by trapstar2020 - 21.09.2014, 08:48

Forum Jump:


Users browsing this thread: 4 Guest(s)