• 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

Raggaer

Godly Member
Joined
Jul 25, 2012
Messages
1,557
Solutions
8
Reaction score
957
Location
Spain
I made this little extension, you will need to have Averatec outfiter installed on znote

- Photo -
Untitled-2.jpg
- Install -
the image is of a 9.6 outfit that wont be released this just works for 8.6 or less

download attach, drag highscores.php into znote folder and drag high.css too

open engine/function/general.php search for
Code:
online

and replace the online_list function with this
PHP:
function online_list() {
    $count = user_count_online();
    $query = mysql_query("SELECT `name`, `level`, `vocation`, `lookfeet`, `lookhead`, `looklegs`, `lookbody`, `looktype`, `lookaddons` 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;
    }
}
View attachment Desktop.rar

We are done
 
Last edited by a moderator:
Thanks for your contribution. :)
 
I made this little extension, you will need to have Avatarec outfiter installed on znote

What is Avatarec outfiter?
And how to install Avatarec outfiter on znote acc?
 
What errors did you come across while trying to add this to your website?
 
Well you cant have errors its very simple to install use ;S
 
Can I add outfits from 8.6+ if I insert correct sprites to sprites and template folder or does this require additional work?
 
You need to add the templates images, and the oufits images, its easy
 
Yea, get the images from a dat file and edit the pixels
 
Code:
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
error in highscore.
 
Notice: Undefined offset: 0 in C:\xampp\htdocs\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


i get this error for highscore
 
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
 
Back
Top