TFS 1.0 - Gesior 2012 - offline training script dont work

[giddy92]

Hey.
When i open "offline" in my gesior. i get empty page

Script

<?PHP
$i = 0;
$main_content .= '<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
<h2 align="center">Players Treinando OFFLINE no '.$config['server']['serverName'].'!</h2>
<TABLE border=0 CELLSPACING=1 CELLPADDING=2 WIDTH=100%class="table table-striped"><TR><TD CLASS=white COLSPAN=4>';
$n = $SQL->query('SELECT COUNT(`offlinetraining_skill`) as `count` FROM `players` WHERE `offlinetraining_skill` > 0;')->fetch();
                 $main_content .= '
</TR><TR><TD WIDTH=30%><B>Name</B></TD><TD WIDTH="10%"><B>Level</B></TD><TD WIDTH="20%"><B>Vocation</B></TD><TD WIDTH="50%"><center><B>Training Type</B></center></TD></TR>';
                 $list = $SQL->query('SELECT `name`, `level`, `vocation`, `promotion`, `offlinetraining_skill` FROM `players` WHERE `offlinetraining_skill` > 0;')->fetchAll();
                 foreach($list as $player) {
                                 $i++;
                                 $main_content.= '<TR><TD WIDTH=30%><A HREF="?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=10%>'.$vocation_name[0][$player['promotion']][$player['vocation']].'</TD><TD WIDTH=50%><center>'.$skill_name[0][$player['offlinetraining_skill']].'</center></TD></TR>';
                 }
$main_content .= '</TABLE></td></TD></tr></table><br>';
$main_content .= '</TABLE></td><div class="alert alert-success style1">
  <div align="center"><strong>Atualmente temos '.$n['count'].' players treinando Offline no Servidor!</strong></div>
</div>
</TD></tr></table>';
?>

I think it is problem with connection with SQL.
Someone know how to repair it?

 

[Thosh]

Do you get any error message?

 

[giddy92]

Nope.
It is just white page.

 

[imkingran]

This should work:

<?PHP
$i = 0;
$main_content .= '<style type="text/css">
<!--
.style1 {color: #000000}
-->
</style>
<h2 align="center">Players Treinando OFFLINE no '.$config['server']['serverName'].'!</h2>
<TABLE border=0 CELLSPACING=1 CELLPADDING=2 WIDTH=100%class="table table-striped"><TR><TD CLASS=white COLSPAN=4>';
$n = $SQL->query('SELECT COUNT(`offlinetraining_skill`) as `count` FROM `players` WHERE `offlinetraining_skill` > 0;')->fetch();
                 $main_content .= '
</TR><TR><TD WIDTH=30%><B>Name</B></TD><TD WIDTH="10%"><B>Level</B></TD><TD WIDTH="20%"><B>Vocation</B></TD><TD WIDTH="50%"><center><B>Training Type</B></center></TD></TR>';
                 $list = $SQL->query('SELECT `name`, `level`, `vocation`, `offlinetraining_skill` FROM `players` WHERE `offlinetraining_skill` > 0 LIMIT 30;')->fetchAll();
                 foreach($list as $player) {
                                 $i++;
                                 $main_content.= '<TR><TD WIDTH=30%><A HREF="?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=10%>'.$vocation_name[$player['vocation']].'</TD><TD WIDTH=50%><center>'.$skill_name[0][$player['offlinetraining_skill']].'</center></TD></TR>';
                 }
$main_content .= '</TABLE></td></TD></tr></table><br>';
$main_content .= '</TABLE></td><div class="alert alert-success style1">
  <div align="center"><strong>Atualmente temos '.$n['count'].' players treinando Offline no Servidor!</strong></div>
</div>
</TD></tr></table>';
?>

Make sure, if you haven't already done so, to add this line in your Config.php:

$skill_name[0] = array(1 => 'Club + Shielding',2 => 'Sword + Shielding',3 => 'Axe + Shielding',4 => 'Distance + Shielding',7 => 'Magic + Shielding');

 

[giddy92]

Work! Thanks!