03.01.2014, 12:33
Yes they are. Because when i rejoin it asks me to login, so i guess tables are set correctly.
EDIT: Rechecked mysql log now:
EDIT: Rechecked mysql log now:
Quote:
[13:49:20] >> mysql_query( Connection handle: 1 ) [13:49:20] CMySQLHandler::Query(SELECT IP FROM `playerdata` WHERE user = 'Face9000' LIMIT 1) - Successfully executed. [13:49:20] >> mysql_store_result( Connection handle: 1 ) [13:49:20] CMySQLHandler::StoreResult() - Result was stored. [13:49:20] >> mysql_num_rows( Connection handle: 1 ) [13:49:20] CMySQLHandler::NumRows() - Returned 0 row(s) [13:49:20] >> mysql_free_result( Connection handle: 1 ) [13:49:20] CMySQLHandler::FreeResult() - Result was successfully free'd. [13:49:23] >> mysql_query( Connection handle: 1 ) [13:49:23] CMySQLHandler::Query(INSERT INTO playerdata (user, password, Scores, Cash, Admin, Deaths, Nopm, Muted, Vip, Warn, RegisterDate, Jailed, AdminActions, Cookies, Rank, VipTime, Class, PrototypesStolen, KillAsUsaTeam, KillAsGermanyTeam, KillAsItalyTeam, KillAsJapanTeam, KillAsMercTeam, KillAsMexicoTeam, IP) VALUES('Face9000', SHA1('sdjiodafjiodwjfiojiowojihoihijo'), 0, 0, 0, 0, 0, 0, 0, 0, '13:49:23 - 3/1/2014', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '')) - Successfully executed. [13:49:28] >> mysql_query( Connection handle: 1 ) [13:49:28] CMySQLHandler::Query(UPDATE `playerdata` SET Scores='0', Cash='0', Admin='0', Deaths='0', Nopm='0', Muted='0', Vip='0', Warn='0', RegisterDate='0', Jailed='0', AdminActions='0', Cookies='0', Rank='0', VipTime='0', Class='0', PrototypesStolen='0', Exp='0', Duty='0', KillAsUsaTeam='0', KillAsGermanyTeam='0', KillAsItalyT) - 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 '' at line 1) [13:49:51] >> mysql_query( Connection handle: 1 ) [13:49:52] >> mysql_store_result( Connection handle: 1 ) [13:49:52] CMySQLHandler::StoreResult() - No data to store. [13:49:52] >> mysql_num_rows( Connection handle: 1 ) [13:49:52] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection) [13:49:52] >> mysql_fetch_row_format( Connection handle: 1 ) [13:49:52] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result) [13:49:52] >> mysql_query( Connection handle: 1 ) [13:49:52] >> mysql_free_result( Connection handle: 1 ) [13:49:52] CMySQLHandler::FreeResult() - The result is already empty. |