13.12.2012, 09:34
Already had enabled it, *FACEPALM* To me, should've provided the log.
Код:
[16:23:19]
[16:23:19] ---------------------------
[16:23:19] MySQL Debugging activated (12/13/12)
[16:23:19] ---------------------------
[16:23:19]
[16:23:19] >> mysql_connect( )
[16:23:19] CMySQLHandler::CMySQLHandler() - constructor called.
[16:23:19] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "database" | Username: "root" ...
[16:23:19] CMySQLHandler::Connect() - Connection was successful.
[16:23:19] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:23:19] >> mysql_query( Connection handle: 1 )
[16:23:19] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(40), score INT(20), money INT(20), level INT(20), vip INT(20), kma INT(20), rank INT(20), kills INT(20), deaths INT(20), muted INT(20), jailed INT(20), frozen INT(20), mutedtimes INT(20), jailedtimes INT(20), frozentimes INT(20), logins INT(20), posx INT(20), posy INT(20), posz INT(20), posa INT(20), IP VARCHAR(15) )) - Successfully executed.
[16:23:19] >> mysql_query( Connection handle: 1 )
[16:23:19] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS Bans(Username VARCHAR(32), Admin VARCHAR(32), IP VARCHAR(16), Reason VARCHAR(64), Seconds INT(12), Banned INT(5) )) - Successfully executed.
[16:23:19] >> mysql_query( Connection handle: 1 )
[16:23:19] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `playerhouses`( `id` int(20) NOT NULL AUTO_INCREMENT,Owner VARCHAR(24) DEFAULT NULL, Owned INT(1) DEFAULT NULL, Price INT(7) DEFAULT NULL, xpos FLOAT(9) DEFAULT NULL, ypos FLOAT(9) DEFAULT NULL,zpos FLOAT(9) DEFAULT NULL , virtualworld INT(2) DEFAULT NULL, labeltext VARCH) - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCH' at line 1)
[16:23:19]
[16:23:19] ---------------------------
[16:23:19] MySQL Debugging activated (12/13/12)
[16:23:19] ---------------------------
[16:23:19]
[16:23:50] >> mysql_query( Connection handle: 1 )
[16:23:50] CMySQLHandler::Query(SELECT * FROM `Bans` WHERE (`Username` = 'Rajat_pawaR' OR `IP` = '127.0.0.1') AND `Banned` = 1 LIMIT 1) - Successfully executed.
[16:23:50] >> mysql_store_result( Connection handle: 1 )
[16:23:50] CMySQLHandler::StoreResult() - Result was stored.
[16:23:50] >> mysql_num_rows( Connection handle: 1 )
[16:23:50] CMySQLHandler::NumRows() - Returned 0 row(s)
[16:23:50] >> mysql_free_result( Connection handle: 1 )
[16:23:50] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:23:50] >> mysql_query( Connection handle: 1 )
[16:23:50] CMySQLHandler::Query(SELECT IP FROM `playerdata` WHERE user = 'Rajat_pawaR' LIMIT 1) - Successfully executed.
[16:23:50] >> mysql_store_result( Connection handle: 1 )
[16:23:50] CMySQLHandler::StoreResult() - Result was stored.
[16:23:50] >> mysql_num_rows( Connection handle: 1 )
[16:23:50] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:23:50] >> mysql_fetch_field_row( Connection handle: 1 )
[16:23:50] CMySQLHandler::FetchField(IP) - You cannot call this function now. (Reason: Fields/Rows are empty.)
[16:23:50] >> mysql_free_result( Connection handle: 1 )
[16:23:50] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:24:06] >> mysql_real_escape_string( Connection handle: 1 )
[16:24:06] CMySQLHandler::EscapeString(120996Rox); - Escaped 9 characters to 120996Rox.
[16:24:06] >> mysql_query( Connection handle: 1 )
[16:24:06] CMySQLHandler::Query(SELECT `user` FROM playerdata WHERE user = 'Rajat_pawaR' AND password = SHA1('120996Rox')) - Successfully executed.
[16:24:06] >> mysql_store_result( Connection handle: 1 )
[16:24:06] CMySQLHandler::StoreResult() - Result was stored.
[16:24:06] >> mysql_num_rows( Connection handle: 1 )
[16:24:06] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:24:06] >> mysql_query( Connection handle: 1 )
[16:24:06] CMySQLHandler::Query(SELECT score, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa FROM playerdata WHERE user = 'Rajat_pawaR') - Successfully executed.
[16:24:06] >> mysql_store_result( Connection handle: 1 )
[16:24:06] CMySQLHandler::StoreResult() - Result was stored.
[16:24:06] >> mysql_fetch_row_format( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchRow() - Return: 0|0|16|0|0|0|0|0|0|0|0|0|0|0|0||46|127|-64|2|315
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("score") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("money") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("level") - 16
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("vip") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("kma") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("rank") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("kills") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("deaths") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("muted") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("jailed") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("frozen") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("mutedtimes") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("jailedtimes") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("frozentimes") - 0
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("logins") - 46
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("posx") - 127
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("posy") - -64
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("posz") - 2
[16:24:06] >> mysql_fetch_field_row( Connection handle: 1 )
[16:24:06] CMySQLHandler::FetchField("posa") - 315
[16:24:06] >> mysql_fetch_row_format( Connection handle: 1 )
[16:24:06] >> mysql_free_result( Connection handle: 1 )
[16:24:06] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:24:06] >> mysql_free_result( Connection handle: 1 )
[16:24:06] CMySQLHandler::FreeResult() - The result is already empty.