hallo erstmal^^
ich hab heut schon ewig probiert die lastwars box so umzubauen, das da zb steht
squad 1 - clan 5
ich bekomms aber einfach nicht hin, das das richtige squad angezeigt wird. hoffentlich weiß jemand was ich da machen muss
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||





$erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 5, SELECT id FROM prefix_groups WHERE id = tid');


$tid = db_query('SELECT tid FROM prefix_wars');
$team = db_query('SELECT id FROM prefix_groups WHERE id = $tid');



<?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 3');
while ($row = db_fetch_object($erg) ) {
$abf1 = 'SELECT * FROM prefix_groups WHERE id = "'.$row->tid.'"';
$erg1 = db_query($abf1);
$row1 = db_fetch_object($erg1);
$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';
}
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.'"><br>'.$row1->name.'</td></tr>';
}
echo '</table>';
?>

$tid = db_result(db_query('SELECT tid FROM prefix_wars'),0);
$team = db_result(db_query('SELECT name FROM prefix_groups WHERE id = '.$tid),0);


<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$farbe = '';
$farb2 = '';
$erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 5');
while ($row = db_fetch_object($erg) ) {
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
if ($row->wlp == 1) {
$alt = 'gewonnen';
$backgrnd ='#DFFFDF';
$bild = 'include/images/icons/win.gif';
$farbe = '#C8E1B8';
$farb2 = '#00BB00';
} elseif ($row->wlp == 2) {
$alt = 'verloren';
$backgrnd ='#FFDFDF';
$bild = 'include/images/icons/los.gif';
$farbe = '#D8B9B9';
$farb2 = '#BB0000';
} elseif ($row->wlp == 3) {
$alt = 'unendschieden';
$backgrnd ='include/images/diverse/pad.gif';
$bild = 'include/images/icons/pad.gif';
$farbe = '#FDFBB7';
$farb2 = '#BBBB00';
}
echo '<div style="border:ridge thin; border-color:'.$farb2.'; background-image:url('.$backgrnd.');">';
echo '<table width="100%" border="0" cellpadding="0" cellspacing="2">';
echo '<tr>';
echo '<td width="16" rowspan="2" align="center"><div style="vertical-align:middle;"><img src="'.$bild.'"/></div></td>';
echo '<td><div align="center" style="outline-color:#999999 font-size:12px; outline-style:none ;">'.get_wargameimg($row->game).' vs. <a style="font-size:10px;" href="index.php?wars-more-'.$row->id.'">'.$row->tag.'</a></div></td>';
echo '</tr>';
echo '<tr>';
echo ' <td><div align="center" style="font-size:10px; outline-style:none;"><font style="color:'.$farb2.'">'.$row->owp.' '.$lang['at2'].' '.$row->opp.'</font></div></td>';
echo '</tr>';
echo '</table>';
echo '</div>';
echo '<div style="height:4"></div>';
}
?>


$erg = @db_query("SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as time,tag,gegner, id, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 4");
$erg = db_query('SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 4');
$abf1 = 'SELECT * FROM prefix_groups WHERE id = "'.$row->tid.'"'; $erg1 = db_query($abf1); $row1 = db_fetch_object($erg1);
.$rowl->name., funktiniert nicht.
<?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,tag,gegner, id, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 4"); //orig von nextwars
$erg = @db_query("SELECT DATE_FORMAT(datime,'%d.%m.') as time,tag,gegner,id,tid, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 4");
if ( @db_num_rows($erg) == 0 ) {
echo '<tr><td>keine Spiele eingetragen</td></tr>';
} else {
while ($row = @db_fetch_object($erg) ) {
//check
$abf1 = 'SELECT * FROM prefix_groups WHERE id = "'.$row->tid.'"';
$erg1 = db_query($abf1);
$row1 = db_fetch_object($erg1);
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
echo '<tr><td>'.get_wargameimg($row->game).'</td>';
echo '<td><a class="box" href="index.php?wars-more-'.$row->id.'">';
echo $row->time.' '.$row->tag.' - '.$row1->name.'</a></td></tr>';
}
}
echo '</table>';
?>
<?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 4');
while ($row = db_fetch_object($erg) ) {
$abf1 = 'SELECT * FROM prefix_groups WHERE id = "'.$row->tid.'"';
$erg1 = db_query($abf1);
$row1 = db_fetch_object($erg1);
$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';
}
echo '<tr><td>'.get_wargameimg($row->game).'</td><td align="left">';
//echo '<a href="index.php?wars-more-'.$row->id.'">';
echo '<a href="'.$row->icq.'">';
//Heimspiel:
if ($row->mod == 'Heimspiel'){
echo $row1->name.' - '.$row->tag.' : '.$row->owp.'-'.$row->opp.'</a></td><td><img src="'.$bild.'"></td></tr>';
} else if ($row->mod == 'Auswärtsspiel') {
echo $row->tag.' - '.$row1->name.': '.$row->opp.':'.$row->owp.'</a></td><td><img src="'.$bild.'"></td></tr>';
}else{
echo $row->mod.'</a></td><td><img src="'.$bild.'"></td></tr>';
}
}
echo '</table>';
?>
| Geschlossen | ||
![]() |
Zurück zu Module und Modifikationen | |