Acc...

[Boski Roman]

Hello.
I have Account Manager by Gesior rewritten by Infinity.
And many errors ... Infinity say: Add Top Powergamers by Gęsior - I add.
And errors...
Look for np. - Rook Sample:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'exphist_lastexp' in 'field list'' in X:\Lol\xampp\htdocs\pot\OTS_Player.php:1811 Stack trace: #0 X:\Lol\xampp\htdocs\pot\OTS_Player.php(1811): PDO->query('SELECT `exphist...') #1 X:\Lol\xampp\htdocs\characters.php(426): OTS_Player->getCustomField('exphist_lastexp') #2 X:\Lol\xampp\htdocs\index.php(171): include('X:\Lol\xampp\ht...') #3 {main} thrown in X:\Lol\xampp\htdocs\pot\OTS_Player.php on line 1811

Help me! :thumbup:

 

[Kavvson]

SQL Querys needed

Hm

 

[Boski Roman]

Errors :/

 

[Kavvson]

In MySQL execute (phpmyadmin -> 'SQL'):

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

and:

UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

 

[Boski Roman]

I add. Error: X:\Lol\xampp\htdocs\top_exp.php on line 38

Top_Exp.php - line 38:

	$groupMembers = $SQL->query('SELECT `name`,`exphist_lastexp`,`onlinetimetoday`,`experience`,`level`,`world_id`,`online`,`account_id` FROM `players`'.$world.' ORDER BY `experience`-`exphist_lastexp` DESC LIMIT 30');

The topic Powergamers: http://otland.net/f118/gesior-acc-maker-forgotten-server-0-3-5-powergamers-online-time-stats-44762/