[Znote AAC] Show outfit on online list

Raggaer

Godly Member
Joined
Jul 25, 2012
Messages
1,556
Best answers
8
Reaction score
895
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:

Dalt0n

Hiho:)
Joined
Dec 14, 2011
Messages
536
Best answers
0
Reaction score
30
Location
Italia
Thanks Raggaer, i use it :D works perfect : )
 

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,668
Best answers
202
Reaction score
1,376
Location
Norway, Oslo
Thanks for your contribution. :)
 

Dylanaw

Godly Member
Joined
Feb 18, 2009
Messages
473
Best answers
0
Reaction score
9
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?
 

Ninja

Global Moderator
Staff member
Global Moderator
Joined
Apr 6, 2010
Messages
5,937
Best answers
30
Reaction score
1,422
Location
Sweden
What errors did you come across while trying to add this to your website?
 
OP
Raggaer

Raggaer

Godly Member
Joined
Jul 25, 2012
Messages
1,556
Best answers
8
Reaction score
895
Location
Spain
Well you cant have errors its very simple to install use ;S
 

Gall

Member
Joined
Nov 8, 2007
Messages
78
Best answers
0
Reaction score
10
Can I add outfits from 8.6+ if I insert correct sprites to sprites and template folder or does this require additional work?
 
OP
Raggaer

Raggaer

Godly Member
Joined
Jul 25, 2012
Messages
1,556
Best answers
8
Reaction score
895
Location
Spain
You need to add the templates images, and the oufits images, its easy
 
OP
Raggaer

Raggaer

Godly Member
Joined
Jul 25, 2012
Messages
1,556
Best answers
8
Reaction score
895
Location
Spain
Yea, get the images from a dat file and edit the pixels
 

soba

I ♥ Deep House .
Joined
May 10, 2009
Messages
183
Best answers
0
Reaction score
5
Location
Bełchatów
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.
 

4490101

New Member
Joined
Dec 27, 2010
Messages
30
Best answers
0
Reaction score
1
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
 

GOD Suimy

Member
Joined
Sep 11, 2012
Messages
98
Best answers
0
Reaction score
15
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
 
Top