[Gesior AAC][Order]News Tickers and Last joined, Free Houses and other

[Eduardo170]

Hello community , I need help with this eh not found any post containing everything to add to my page and want could help me.

News Ticker.

Last joined, Free Houses and other

@up

 

[Owner Maydel]

What Did U Need? Now

 

[Eduardo170]

I need the ticket system and joined Last , Free Houses and other.


I found some post but none is complete.

My Gesior is compatible with tfs 0.3.6
I use Otx 2

 

[Owner Maydel]

Free Houses And Things Its On You'r phpmyadmin Check it.

 

[Eduardo170]

You checked the images ?

It is exactly what I want , what's in the pictures , and I want to install it on my Gesior AAC.

 

[Owner Maydel]

Oo News Ticker And The Most Powerfull Guild? Hmm Wait A moment http://pastebin.com/KWf2dWpm Check it

Work?

 

[Eduardo170]

Not working, I get these errors

Fatal error: Uncaught Error: Call to a member function fetch() on boolean in C:\xampp\htdocs\pages\latestnews.php:3 Stack trace: #0 C:\xampp\htdocs\system\load.page.php(7): include() #1 C:\xampp\htdocs\index.php(37): include_once('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pages\latestnews.php on line 3

Fatal error: Uncaught Error: Call to a member function fetch() on boolean in C:\xampp\htdocs\pages\latestnews.php:8 Stack trace: #0 C:\xampp\htdocs\system\load.page.php(7): include() #1 C:\xampp\htdocs\index.php(37): include_once('C:\\xampp\\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pages\latestnews.php on line 8

These query always give me error

$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();

 

[Owner Maydel]

ca

Private Conversation.

The Problem Has Been Solve...

 

[Eduardo170]

Not Solved :/