• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC ZNOTE ACC - POWERGAMERS/TOPONLINE PROBLEM

rexgandi

Member
Joined
Oct 22, 2011
Messages
189
Reaction score
9
Hi,
I use Znote ACC 1.5 SVN.
In my database i don't have data on exphi1, exphi2 itd. and onlinetime1, onlinetime2.
Whats wrong?

And in toponline.php

Lua:
string(153) "SELECT * FROM `znote_players` AS `z` JOIN `players` AS `p` WHERE `p`.`id`=`z`.`player_id` and `p`.`group_id` < 3 ORDER BY `onlinetimetoday` DESC LIMIT 20"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Column 'onlinetimetoday' in order clause is ambiguous

@Znote can u help me? I use TFS 0.3.7 ...
 
Last edited:
Hi,
I use Znote ACC 1.5 SVN.
In my database i don't have data on exphi1, exphi2 itd. and onlinetime1, onlinetime2.
Whats wrong?

On main folder of Znote:

Lua/tfs ( Tfs version you are using ) if 1.3 lua/tfs_10/
You will find scripts also tables to execute SQL on your database.

First
ALTER TABLE znote_players ADD exphist_lastexp BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist1 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist2 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist3 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist4 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist5 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist6 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD exphist7 BIGINT UNSIGNED NOT NULL DEFAULT '0',
ADD onlinetimetoday BIGINT NOT NULL DEFAULT '0',
ADD onlinetime1 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime2 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime3 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime4 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime5 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime6 BIGINT NOT NULL DEFAULT '0',
ADD onlinetime7 BIGINT NOT NULL DEFAULT '0',
ADD onlinetimeall BIGINT NOT NULL DEFAULT '0';

Then
UPDATE znote_players AS z INNER JOIN players AS p ON p.id=z.player_id SET z.exphist_lastexp=p.experience;

Also don't forget to copy paste script powergamers.lua unicated on lua folder.
 
On main folder of Znote:

Lua/tfs ( Tfs version you are using ) if 1.3 lua/tfs_10/
You will find scripts also tables to execute SQL on your database.

First


Then


Also don't forget to copy paste script powergamers.lua unicated on lua folder.

powergamers.lua have in folder TFS_10. I use TFS 0.3. This is the same script?
 
Back
Top