Last Kills e Online

[p e o p l e 50]

eae Tkianos Bem ?

Então '-' KKK, meu web site não está funcionando o Last Kills ( Ultimas mortes ) e não está também funcionando o Online ( quando o ot está off aparece 1 player on e tals, já procurei sobre e esse achei esse tutorial de como arrumar.

http://www.tibiaking.com/forum/topic/9814-tirando-bug-do-gesior-server-offline-e-0-players/

Porém não achei essa função. SEgue o meu online e o meu last kills. Obg <3 dou REP+ ://

Online ( eu creio que é essa parte )

<?PHP

                                $order = $_REQUEST['order']; if($order == 'name') {$orderby = 'name';} if($order == 'level') {$orderby = 'level';} if($order == 'vocation') {$orderby = 'vocation';} if(empty($orderby)) {$orderby = 'name';}

                                $players_online_data = $SQL->query(' SELECT * 

FROM '.$SQL->tableName('players').' 

WHERE '.$SQL->fieldName('online').' = 1 

ORDER BY '.$orderby); 

$number_of_players_online = 0;                               

foreach($players_online_data as $player) {$number_of_players_online++; if(is_int($number_of_players_online / 2)) {$bgcolor = $config['site']['darkborder'];} else {$bgcolor = $config['site']['lightborder'];} $players_rows .= '<TR BGCOLOR=.$bgcolor.'><TD WIDTH=70%><A HREF="characters&name='.$player['name].'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$config_vocations[$player['vocation']].'</TD></TR>';} 

                                $whoisonlineworld = 'whoisonline'; 

                                ?>

 

<tr><td><a href="whoisonline"><?PHP if($number_of_players_online >= 1) { ECHO $number_of_players_online.' players online'; } else { ECHO 'Server OFFINE'; } ?>.</a></td></tr>

 

Last Kills:

<?php if(!defined('INITIALIZED')) exit;

 

if($action == "")

{

 

$players_deaths = $SQL->query('

SELECT 

'.$SQL->tableName('player_deaths').'.'.$SQL->fieldName('id').',

'.$SQL->tableName('player_deaths').'.'.$SQL->fieldName('date').',

'.$SQL->tableName('player_deaths').'.'.$SQL->fieldName('level').',

'.$SQL->tableName('players').'.'.$SQL->fieldName('name').',

'.$SQL->tableName('players').'.'.$SQL->fieldName('world_id').'

FROM 

'.$SQL->tableName('player_deaths').'

LEFT JOIN 

'.$SQL->tableName('players').' 

ON 

'.$SQL->tableName('player_deaths').'.'.$SQL->fieldName('player_id').' 

= 

'.$SQL->tableName('players').'.'.$SQL->fieldName('id').' 

ORDER BY 

'.$SQL->tableName('player_deaths').'.'.$SQL->fieldName('date').' 

DESC LIMIT '.$config['site']['last_deaths_limit']);

 

 

$players_deaths_count = 0;

    

if(!empty($players_deaths))

{

foreach($players_deaths as $death)

{

   ######################

   $bgcolor = (($players_deaths_count++ % 2 == 1) ?  $config['site']['darkborder'] : $config['site']['lightborder']); # nao tirar

#####################

 

$players_rows .= '<TR> <TD WIDTH="5%"> <b> <center> <small>'.$players_deaths_count.'.</small> </center> </b> </TD>

<TD WIDTH="5%"> <span class="label label-inverse">'.date("j.m.y - G:i",$death['date']).'</span></center></TD>

    <TD><a href="characters&name='.urlencode($death['name']).'"><b>'.htmlspecialchars($death['name']).'</b></a> ';

 

$killers = 

$SQL->query('

SELECT 

'.$SQL->tableName('environment_killers').'.'.$SQL->fieldName('name').' 

AS monster_name, 

'.$SQL->tableName('players').'.'.$SQL->fieldName('name').'

AS player_name,

'.$SQL->tableName('players').'.'.$SQL->tableName('deleted').' 

AS player_exists 

FROM 

'.$SQL->tableName('killers').' 

LEFT JOIN 

'.$SQL->tableName('environment_killers').' 

ON 

'.$SQL->tableName('killers').'.'.$SQL->fieldName('id').' 

= 

'.$SQL->tableName('environment_killers').'.'.$SQL->fieldName('kill_id').' 

LEFT JOIN 

'.$SQL->tableName('player_killers').' 

ON 

'.$SQL->tableName('killers').'.'.$SQL->fieldName('id').' 

= 

'.$SQL->tableName('player_killers').'.'.$SQL->fieldName('kill_id').' 

LEFT JOIN 

'.$SQL->tableName('players').' 

ON 

'.$SQL->tableName('players').'.'.$SQL->fieldName('id').' 

= 

'.$SQL->tableName('player_killers').'.'.$SQL->fieldName('player_id').' 

WHERE 

'.$SQL->tableName('killers').'.'.$SQL->fieldName('death_id').' 

= '.$SQL->quote($death['id']).' 

ORDER BY 

'.$SQL->tableName('killers').'.'.$SQL->fieldName('final_hit').' 

DESC, 

'.$SQL->tableName('killers').'.'.$SQL->fieldName('id').' 

ASC')->fetchAll();

 

 

$i = 0;

$count = count($killers);

 

foreach($killers as $killer)

{

$i++;

if($i == 1)

{

if($count <= 4) {$players_rows .= 'killed at level <b>'.(int) $death['level'].'</b> by ';}

elseif($count > 4 and $count < 10) {$players_rows .= 'slain at level <b>'.(int) $death['level'].'</b> by ';}

elseif($count > 9 and $count < 15) {$players_rows .= 'crushed at level <b>'.(int) $death['level'].'</b> by ';}

elseif($count > 14 and $count < 20) {$players_rows .= 'eliminated at level <b>'.(int) $death['level'].'</b> by ';}

    elseif($count > 19) {$players_rows .= 'annihilated at level <b>'.(int) $death['level'].'</b> by ';}

}

elseif($i == $count) {$players_rows .= ' and ';} else {$players_rows .= ', ';}

 

if($killer['player_name'] != "")

{

if($killer['monster_name'] != '') {$players_rows .= htmlspecialchars($killer['monster_name']).' summoned by ';}

if($killer['player_exists'] == 0) {$players_rows .= '<a href=\'characters&name=.urlencode($killer['player_name]).'\'>';}

$players_rows .= htmlspecialchars($killer['player_name']);

if($killer['player_exists'] == 0) {$players_rows .= '</a>';}

}

else {$players_rows .= htmlspecialchars($killer['monster_name']);}

}

    $players_rows .= '</td></TR>';

}

}

    

########################################################################################################

ECHO '<div class="well"> <h2> Last Kills </h2>';

    

if($players_deaths_count == 0) # LAST DEATHS (NO ONE DIED)

{

   ECHO '<TABLE class="table table-condensed table-content table-striped">

<TABLE> <TR> <TD> Ninguém morreu em <b>'. htmlspecialchars ($config['server']['serverName']).'</b>. 

</TD> </TR> </TABLE> </table> <BR>';

}

    else # LAST DEATHS

{

   ECHO '<TABLE class="table table-condensed table-content table-striped">'.$players_rows.'</TABLE>';

}

 

ECHO '</div>';

###########################################################################################################

}

?>

 

Aaah e se eu coloco uma noticia, não consigo apagar, nem como admin ://, e preciso adicionar uma coluna na minha data base ' z_shop_offerty_history ' como faz? O jeito que eu tentei não deu certo ://

Obrigado

Editado Junho 24, 2014 por AlekysRocha. (veja o histórico de edições)

[Absolute 0]

É Linux?

[p e o p l e 50]

Não, Windows.