21.09.2014, 01:54
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);