When I added this to mine all pages went blank lol
<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>
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;
}
}
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
too Blank PageStill blank pages @Ninja
bumpMe 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
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
engine/function/general.phpIs it hard to make this competitive with Znote tfs 1.0?
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;");
}
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>';
engine/function/general.php
onlinelist.phpPHP: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;"); }
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>';
<td><div style="position:relative; left:-32px; top:-48px;;"><div style="background-image: url(outfitter.php?a=138&b=0&c=79&d=94&e=81&f=88&g=&h=3&i=1);width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"></div></div></td>