• 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!

[Znote AAC] Show outfit on online list

When I added this to mine all pages went blank lol

I seem to be having the exact same problem. I copied the outfitter php file and folder into my "www" folder. I replaced the content of the online function with the one provided on the first page. Yet when I check the online list, it's blank.

Any ideas on how I could resolve the issue?
 
@MadMOOK Add this to www/layout/leftside.php
Code:
  <a href='addons.php'>
                    <div id='submenu_addons' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                        <div class='LeftChain' style='background-image:url(layout/images/global/general/chain.gif);'></div>
                        <div id='ActiveSubmenuItemIcon_submenu_addons' class='ActiveSubmenuItemIcon' style='background-image:url(layout/images/global/menu/icon-activesubmenu.gif);'></div>
                        <div id='ActiveSubmenuItemLabel_submenu_addons' class='SubmenuitemLabel'><font color='yellow'>Addon Bonuses</font></div>
                        <div class='RightChain' style='background-image:url(layout/images/global/general/chain.gif);'></div>
                    </div>
                </a>
And add the Images, to www/images
np mate :)
 
engine/function/general.php
PHP:
function online_list() {
    $count = user_count_online();
    $query = mysql_query("SELECT `name`, `level`, `vocation`, `looktype`, `lookaddons`, `lookhead`, `lookbody`, `looklegs`, `lookfeet` FROM `players` WHERE `online`='1' ORDER BY `name` DESC;");
    for ($i = 0; $i < $count; $i++) {
        $row = mysql_fetch_row($query);
        $array[] = $row;
    }
   
    if (isset($array)) {
        return $array;
    } else {
        return false;
    }
}

onlinelist.php

Could anyone test this? It should work :p
 
I have the same problem, please need help from someone to fix this issue


PHP:
string(47) "SELECT `group_id` FROM `players` WHERE `id` = ;"
(query - SQL error)
Type: select_single (select single row 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

thanks
 
Me too, in Adictive Ot

I had this error:

Notice: Undefined offset: 0 in C:\xampp\htdocs\znoteaac\highscores.php on line 73
string(47) "SELECT `group_id` FROM `players` WHERE `id` = ;"
(query - SQL error)
Type: select_single (select single row 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

- - - Updated - - -

Me too, in http://adictiveot.sytes.net/znoteaac/highscores.php

I had this error:

Notice: Undefined offset: 0 in C:\xampp\htdocs\znoteaac\highscores.php on line 73
string(47) "SELECT `group_id` FROM `players` WHERE `id` = ;"
(query - SQL error)
Type: select_single (select single row 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
bump
 
engine/function/general.php
PHP:
function online_list() {
    $count = user_count_online();
    $query = mysql_query("SELECT `name`, `level`, `vocation`, `looktype`, `lookaddons`, `lookhead`, `lookbody`, `looklegs`, `lookfeet` FROM `players` WHERE `online`='1' ORDER BY `name` DESC;");
    for ($i = 0; $i < $count; $i++) {
        $row = mysql_fetch_row($query);
        $array[] = $row;
    }
  
    if (isset($array)) {
        return $array;
    } else {
        return false;
    }
}

onlinelist.php

Could anyone test this? It should work :p

Is it hard to make this competitive with Znote tfs 1.0?
 
Is it hard to make this competitive with Znote tfs 1.0?
engine/function/general.php
PHP:
function online_list() {
    if (config('TFSVersion') == 'TFS_10') return mysql_select_multi("SELECT `o`.`player_id` AS `id`, `p`.`looktype` as `looktype`, `p`.`lookaddons` as `lookaddons`, `p`.`lookhead` as `lookhead`, `p`.`lookbody` as `lookbody`, `p`.`looklegs` as `looklegs`, `p`.`lookfeet` as `lookfeet`, `p`.`name` as `name`, `p`.`level` as `level`, `p`.`vocation` as `vocation` FROM `players_online` as `o` INNER JOIN `players` as `p` ON o.player_id = p.id");
    else return mysql_select_multi("SELECT `name`, `level`, `vocation`, `looktype`, `lookaddons`, `lookhead`, `lookbody`, `looklegs`, `lookfeet` FROM `players` WHERE `online`='1' ORDER BY `name` DESC;");
}
onlinelist.php
PHP:
echo '<td><div style="position:relative; left:-32px; top:-48px;"><div style="background-image: url(outfitter.php?a='.$value['looktype'].'&b='.$value['lookaddons'].'&c='.$value['lookhead'].'&d='.$value['lookbody'].'&e='.$value['looklegs'].'&f='.$value['lookfeet'].'&g=0&h=3&i=1);width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"></div></div></td>';

bjvZDWo.png


- - - Edit - - -

Download: Outfitter-1031
 
Last edited:
engine/function/general.php
PHP:
function online_list() {
    if (config('TFSVersion') == 'TFS_10') return mysql_select_multi("SELECT `o`.`player_id` AS `id`, `p`.`looktype` as `looktype`, `p`.`lookaddons` as `lookaddons`, `p`.`lookhead` as `lookhead`, `p`.`lookbody` as `lookbody`, `p`.`looklegs` as `looklegs`, `p`.`lookfeet` as `lookfeet`, `p`.`name` as `name`, `p`.`level` as `level`, `p`.`vocation` as `vocation` FROM `players_online` as `o` INNER JOIN `players` as `p` ON o.player_id = p.id");
    else return mysql_select_multi("SELECT `name`, `level`, `vocation` FROM `players` WHERE `online`='1' ORDER BY `name` DESC;");
}
onlinelist.php
PHP:
echo '<td><div style="position:relative; left:-32px; top:-48px;;"><div style="background-image: url(outfitter.php?a='.$value['looktype'].'&b='.$value['lookaddons'].'&c='.$value['lookhead'].'&d='.$value['lookbody'].'&e='.$value['looklegs'].'&f='.$value['lookfeet'].'&g='.$value['lookmount'].'&h=3&i=1);width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"></div></div></td>';

bjvZDWo.png


What am I doing wrong, outfit doesn't show up. :eek:
I have changed general.php and onlinelist.php
I have outfitter.php and outfits folder in the main website folder.

But something has happened, if I "inspect element" in chrome I see
Code:
<td><div style="position:relative; left:-32px; top:-48px;;"><div style="background-image: url(outfitter.php?a=138&amp;b=0&amp;c=79&amp;d=94&amp;e=81&amp;f=88&amp;g=&amp;h=3&amp;i=1);width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"></div></div></td>

But nothing shows up, just empty table.
 
You're probably using an outdated version of outfitter, I've edited my previous post so you can download the updated version.
 
Back
Top