Converting GesiorAcc to ZnoteAcc - Powergamers.php

[therrax]

Hello.

Information: TFS 1.0

Could someone convert powergamers.php from GesiorAcc to ZnoteAcc?
Or help me how to do this..
Unfortunately, I can't do this myself..

It's a powergamers.php
https://github.com/gesior/Gesior2012/blob/TFS-1.0/pages/powergamers.php

Greets

 

[Peonso]

https://github.com/Znote/ZnoteAAC/pull/65/files

 

[therrax]

string(334) "SELECT `p`.`name`, `p`.`level`, `p`.`vocation`, `p`.`experience`, `p`.`exphist1`, `p`.`exphist2`, `p`.`exphist3`, `p`.`exphist_lastexp`, `p_on`.`player_id` AS `online` FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`player_id` WHERE `p`.`group_id` < 2 ORDER BY `p`.`experience`-`p`.`exphist_lastexp` DESC LIMIT "
(query - SQL error)
Type: select_multi (select multiple rows from database)

Thanks @Peonso But what I have to add to my database? And to my globalevents ?

 

[Peonso]

Same things from this one. http://otland.net/threads/gesior-acc-maker-tfs-0-3-powergamers-and-online-time-stats.8640/

 

[therrax]

string(334) "SELECT `p`.`name`, `p`.`level`, `p`.`vocation`, `p`.`experience`, `p`.`exphist1`, `p`.`exphist2`, `p`.`exphist3`, `p`.`exphist_lastexp`, `p_on`.`player_id` AS `online` FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`player_id` WHERE `p`.`group_id` < 2 ORDER BY `p`.`experience`-`p`.`exphist_lastexp` DESC LIMIT "
(query - SQL error)
Type: select_multi (select multiple rows from database)

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

@Peonso I add it but I still have this problem.

 

[therrax]

It's for TFS 1.0?

 

[Peonso]

Try this one. https://github.com/peonso/guilcera/blob/master/www/powergamers.php

I got no idea what my cause this error. What Znote are you using?

 

[therrax]

Znote ACC 1.5 :/

 

[therrax]

Now It work ! thanks Bro!!! @Peonso It's possible to add best day and best weekly exp?

 

[Peonso]

Znote ACC 1.5 :/

It should work with TFS 1.0 and Znote 1.5. You sure you did everything right from this one? http://otland.net/threads/gesior-acc-maker-tfs-0-3-powergamers-and-online-time-stats.8640/

 

[ATT3]

string(334) "SELECT `p`.`name`, `p`.`level`, `p`.`vocation`, `p`.`experience`, `p`.`exphist1`, `p`.`exphist2`, `p`.`exphist3`, `p`.`exphist_lastexp`, `p_on`.`player_id` AS `online` FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`player_id` WHERE `p`.`group_id` < 2 ORDER BY `p`.`experience`-`p`.`exphist_lastexp` DESC LIMIT "
(query - SQL error)
Type: select_multi (select multiple rows from database)

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

@Peonso I add it but I still have this problem.

Are you using this?
(globalevent, querys)
https://github.com/att3/ZnoteAAC/commit/dd270ed12f73c6db850c7482b39bface75ec07a4

 

[Evil Puncker]

Are you using this?
(globalevent, querys)
https://github.com/att3/ZnoteAAC/commit/dd270ed12f73c6db850c7482b39bface75ec07a4

do you have any plan on updating it? xD

 

[therrax]

for me, only this work https://github.com/peonso/guilcera/blob/master/www/powergamers.php
and I used this :http://otland.net/threads/gesior-acc-maker-tfs-0-3-powergamers-and-online-time-stats.8640/
but how add best ever weekly and daily stats?

 

[ATT3]

do you have any plan on updating it? xD

Ye

I tried to "fix" it couple months ago but couldn't figure it out (SQL)
Well I will try again tomorrow and see if I have learned anything during these few months xd

 

[therrax]

@Evil Puncker When I put it to my characterprofile it show same EXP history for all players. for example: Player x get 200.000. Player y get 200.000. And It's wrong, because only x get this EXP. What I have to change?

<?php
$powergamers = $config['powergamers'];
$limit = 1;
$type = @$_GET['type'];
function coloured_value($valuein)
{
    $value2 = $valuein;
    while(strlen($value2) > 3)
    {
        $value .= '.'.substr($value2, -3, 3);
        $value2 = substr($value2, 0, strlen($value2)-3);
    }
    @$value = $value2.$value;
    if($valuein > 0)
        return '<b><font color="green">+'.$value.'</font></b>';
    elseif($valuein < 0)
        return '<font color="red">'.$value.'</font>';
    else
        return $value;
}
if(empty($type))
    $players = mysql_select_multi('SELECT `p`.`name`, `p`.`level`, `p`.`vocation`, `p`.`experience`, `p`.`exphist1`, `p`.`exphist2`, `p`.`exphist3`, `p`.`exphist_lastexp`, `p_on`.`player_id` AS `online` FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`player_id` WHERE `p`.`group_id` < 2 ORDER BY `p`.`experience`-`p`.`exphist_lastexp` DESC LIMIT ' . $limit);
elseif($type == "sum")
    $players = mysql_select_multi('SELECT `p`.*, `p_on`.`player_id` AS online FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`experience`-`p`.`exphist_lastexp` DESC LIMIT ' . $limit);
elseif($type >= 1 && $type <= 7)
    $players = mysql_select_multi('SELECT `p`.*, `p_on`.`player_id` AS online FROM `players` p LEFT JOIN `players_online` p_on ON `p`.`id` = `p_on`.`player_id` WHERE `p`.`group_id` < 2 ORDER BY `p`.`exphist' . (int) $type . '` DESC LIMIT '.$limit);
if($player)
    foreach($players as $player)
    {
    echo coloured_value($player['experience']-$player['exphist_lastexp']);
    }
    ;
    ?>