Ich habe 3 kleine probleme und swar wollte ich das bei der Last und next war box die landes fahne vom gegner auch noch angezeigt wird
und bei war Stats unter den Stats der link zum ausfürlichen War Stats
NextWar Box
<?php
# Copyright by: Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
$akttime = date('Y-m-d');
$erg = @db_query("SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as time,oid, id, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 6");
if ( @db_num_rows($erg) == 0 ) {
echo '<tr><td>kein War geplant</td></tr>';
} else {
while ($row = @db_fetch_object($erg) ) {
$row->tag = get_opponent_details('tag', $row->oid);
$row->gegner = get_opponent_details('name', $row->oid);
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
echo '<tr align="center"><td>'.get_wargameimg($row->game).'</td>';
echo '<td><a class="box" href="index.php?wars-more-'.$row->id.'">';
echo $row->time.' - '.$row->tag.'</a></td></tr>';
}
}
echo '</table>';
?>
Lastwar Box
<?php
# Copyright by: Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$farbe = '';
$farb2 = '';
echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
$erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 6');
while ($row = db_fetch_object($erg) ) {
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
if ($row->wlp == 1) {
$bild = 'include/images/icons/win.gif';
} elseif ($row->wlp == 2) {
$bild = 'include/images/icons/los.gif';
} elseif ($row->wlp == 3) {
$bild = 'include/images/icons/pad.gif';
}
$row->tag = get_opponent_details('tag', $row->oid);
echo '<tr><td>'.get_wargameimg($row->game).'</td><td align="left">';
echo '<a href="index.php?wars-more-'.$row->id.'">';
echo $row->owp.' '.$lang['at2'].' '.$row->opp.' - '.$row->tag.'</a></td><td><img src="'.$bild.'"></td></tr>';
}
echo '</table>';
?>
War Statsbox
<?php
# Copyright by Lord|Schirmer
# Support www.ilch.de
# War-Statistik Box
defined ('main') or die ( 'no direct access' );
echo '<table width="100%" border="0" cellpadding="0" cellspacing="1">';
$i = 0;
$dbgames = db_query('SELECT DISTINCT game FROM `prefix_wars` WHERE status = 3');
while ($row = mysql_fetch_array($dbgames))
{ $i++; $class = ($i % 2) ? 'Cnorm' : 'Cmite' ;
$anzGesG = db_result(db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3" AND game = "'.$row['game'].'"'),0);
$anzWinG = db_result(db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3" AND wlp = "1" AND game = "'.$row['game'].'"'),0);
$anzPatG = db_result(db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3" AND wlp = "3" AND game = "'.$row['game'].'"'),0);
$anzLosG = db_result(db_query('SELECT COUNT(id) FROM `prefix_wars` WHERE status= "3" AND wlp = "2" AND game = "'.$row['game'].'"'),0);
echo '<tr class="'.$class.'">';
echo '<td align="center">'.get_wargameimg($row['game']).'</td>';
echo '<td align="center"><span style="color:#CCCCCC">'.$anzGesG.'</span><br>';
echo '<img src="include/images/warstats/middle_grey.gif" border="0" width="40" height="6"></td>';
echo '<td align="center"><span style="color:#99FF66">'.$anzWinG.'</span><br>';
echo '<img src="include/images/warstats/middle_green.gif" border="0" width="25" height="6"></td>';
echo '<td align="center"><span style="color:#FFCC66">'.$anzPatG.'</span><br>';
echo '<img src="include/images/warstats/middle_yellow.gif" border="0" width="25" height="6"></td>';
echo '<td align="center"><span style="color:#FF6666">'.$anzLosG.'</span><br>';
echo '<img src="include/images/warstats/middle_red.gif" border="0" width="25" height="6"></td>';
echo '</tr>';
}
echo '</table>';
# Ende
?>
Hoffe es kann mir einer helfen.
Mfg brezel
verwendete ilchClan Version: 1.1 N
betroffene Homepage: externer Link
