ich nutze das advanced wars 1 .2 Modul und ich wollte gerne "mod" abfragen also obs ein 5 gegen 5 oder anderes ist. Das funktioniert aber nicht sobald ich mod abfrage bekomme ich folgenden Fehler:
MySQL Error: 1064 : Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei ' id, game FROM ic1_wars WHERE status = 2 AND datime > '2011-07-12' ORDER BY dati' in Zeile 1 in Query: SELECT DATE_FORMAT(datime,'%d.%m.%y - %H:%i') as time,oid,wo, mod, id, game FROM ic1_wars WHERE status = 2 AND datime > '2011-07-12' ORDER BY datime LIMIT 5 Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ nextwars.php:10 -- db_query(...) @ design.php:332 -- require_once(...) @ design.php:174 -- design->get_boxcontent(...) @ design.php:71 -- design->replace_boxes(...) @ news.php:12 -- design->design(...) @ index.php:35 -- require_once(...)
meine Nextwars box:
<?php
# Copyright by: Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
echo '<div width="100%" border="0" cellpadding="2" cellspacing="0">';
$akttime = date('Y-m-d');
$erg = @db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y <br /> %H:%i') as time,oid, mtyp, id, game FROM prefix_wars WHERE status = 2 AND datime > '".$akttime."' ORDER BY datime LIMIT 3");
if ( @db_num_rows($erg) == 0 ) {
echo '<tr><td></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' <a style="text-decoration:none;" href="index.php?wars-more-'.$row->id.'">';
echo' <div class="entry" style="background-image:url(include/images/wargames/'.$row->game.'.png)">';
echo' <div style="float: right; color: #ffffff;">'.$row->time.'</div>';
echo' <span style="color: #d2191f;">Team Zodiacx</span> vs. <span style="color: #ffffff;">'.$row->gegner.'</span><br />'.$row->mtyp.'</div>';
echo' </a>';
}
}
echo '</div>';
?>
