Recent content by coolgogo

of the server or xampp? - - - Updated - - - if server is done sha1 if xampp there is no encryptionType in config

my server is runing with sha1 and the account that are made by the website to the database aren't in sha1 (readable and i tried Perform these in MySQL command shell or phpMyAdmin SQL tab within root of selected database: ALTER TABLE `accounts` CHANGE `password` `plainpassword` VARCHAR(...

it is right

/7/2013 3:9:16] >> Loading RSA key [15/7/2013 3:9:16] >> Starting SQL connection [15/7/2013 3:9:16] > WARNING: MYSQL Lost connection, attempting to reconnect...>> Running Database Manager [15/7/2013 3:9:16] > Optimizing table: account_viplist... [success] [15/7/2013 3:9:22] > Optimizing...

sha1 and readable

same :(

I no have even 1/1 - - - Updated - - - Help please - - - Updated - - - :( :(

/7/2013 3:9:16] >> Loading RSA key [15/7/2013 3:9:16] >> Starting SQL connection [15/7/2013 3:9:16] > WARNING: MYSQL Lost connection, attempting to reconnect...>> Running Database Manager [15/7/2013 3:9:16] > Optimizing table: account_viplist... [success] [15/7/2013 3:9:22] > Optimizing...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE `player_id` = 42 AND `skillid` = 0' at...

Thanks to amiroslo it worked thank you

now other Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'expires' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1...

Other error :( Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1...

same don't work

don't work :(

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' in 'field list'' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1...