[Gesior 2012 1.0.1] Latestnews.php

[imback1]

Thanks for this great php script but top guilds not working with me .
Using TFS 0.3.6
Gesior 2012
https://github.com/gesior/Gesior2012/archive/TFS-0.3.6_and_0.4_to_rev_3703.zip

 

[3alola1]

you should fix it that it wont show the staff levels if they are the first level of the game

 

[Shadow Dan]

change:

$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();

to:

$query = $SQL->query("SELECT * FROM `players` WHERE `group_id`=1 ORDER BY `experience` DESC")->fetch();

 

[Shadow Dan]

i mean
change:

$query = $SQL->query("SELECT * FROM `players` ORDER BY `experience` DESC")->fetch();

to:

$query = $SQL->query("SELECT * FROM `players` WHERE `group_id`=1 ORDER BY `experience` DESC")->fetch();

why i can not edit my post? -_-

 

[starahmed57]

I Have New Last News I Forget Who Was Make It Script
<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 50px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
</style>

<?PHP
//######################## SHOW TICKERS AND NEWS #######################

$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();

$main_content .= '
<p align="center"><img src="images/latest.png" alt="*">
<br/>
<p align="center"><img src="images/line.png" alt="*"><br/>


<table class="tg"><td>
<img src="images/logo1.gif" alt="*">


';


$main_content .= '<font color="green"><a href="?subtopic=whoisonline">Online</a>: '.$config['status']['serverStatus_players'].'</font>';



$main_content .= '
</td>
<td>
<img src="images/logo4.gif" alt="*"> Exp rate: <a href="?subtopic=serverinfo">Here</a>
</td>
<td>
<img src="images/logo7.gif" alt="*"> Old PVP System
</td>
<tr>
<td>
<img src="images/logo2.gif" alt="*"> Accounts: '.$accounts[0].'
</td>
<td>
<img src="images/logo5.gif" alt="*"> Loot rate: '.$config['site']['sInfoLoot'].'
</td>

<td>
<img src="images/logo8.gif" alt="*"> Memory: 96 GB!!
</td>

<tr>
<td>
<img src="images/logo3.gif" alt="*"> Players: '.$players[0].'
</td>
<td>
<img src="images/logo6.gif" alt="*"> Skills rate: '.$config['site']['sInfoSkill'].'
</td>

<td>
<img src="images/logo9.gif" alt="*"> Inter core i7 - 3.2 ghz
</td>
<tr>
</table>
<p align="center"><img src="images/line.png" alt="*"><br/>
</p>
';


if($group_id_of_acc_logged >= $config['site']['access_admin_panel']){$main_content .= '<a href="?subtopic=forum&action=new_topic&section_id=1">Add new news</a>';}
$tables = $SQL->query("SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;")->fetchAll();

if($tables){
$main_content .= '<table><td>';
}
foreach ($tables as $row)
{
$BB = array(
'/\[b\](.*?)\[\/b\]/is' => '<strong>$1</strong>',
'/\[quote\](.*?)\[\/quote\]/is' => '<table cellpadding="0" style="background-color: #c4c4c4; width: 480px; border-style: dotted; border-color: #007900; border-width: 2px"><tr><td>$1</td></tr></table>',
'/\[u\](.*?)\[\/u\]/is' => '<u>$1</u>',
'/\[i\](.*?)\[\/i\]/is' => '<i>$1</i>',
'/\(.*?)\[\/url\]/is' => '<a href=$1>$...mage and video hosting by TinyPic"></a>[/IMG]

 

[0567891234]

Good Job

 

[Ambro997]

Fatal Error :/ Fatal error: Call to a member function fetch() on a non-object in C:\WebServ\httpd\classes\account.php on line 33

 

[Ambro997]

Warning: Invalid argument supplied for foreach() in C:\WebServ\httpd\pages\latestnews.php on line 38