ok sry wegen den fred ich hab es mit deinem substring geschafft, aber nicht ganz so wie du gemeint hast
sondern, hier der orginale code:
$erg = db_query(\"SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,\'%d.%m.%y\') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 ORDER BY a.datime DESC, id DESC LIMIT \".$anfang.\",\".$limit);
while ($row = db_fetch_assoc($erg) ) {
$row[\'erg\'] = $row[\'owp\'].\':\'.$row[\'opp\'];
$row[\'farbe\'] = $farbe1wlpar[$row[\'wlp\']];
$row[\'farbe2\'] = $farbe2wlpar[$row[\'wlp\']];
if ( $class == \'Cmite\' ) { $class = \'Cnorm\'; } else { $class = \'Cmite\'; }
$row[\'class\'] = $class;
$tpl->set_ar_out($row,3);
}
$tpl->out(4);
echo $MPL;
} else {
und dann mein code:
$erg = db_query(\"SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,\'%d.%m.%y\') as time FROM prefix_wars a left join prefix_groups b ON a.tid = b.id WHERE status = 2 ORDER BY a.datime DESC, id DESC LIMIT \".$anfang.\",\".$limit);
while ($row = db_fetch_assoc($erg) ) {
$row[\'erg\'] = $row[\'owp\'].\':\'.$row[\'opp\'];
$row[\'farbe\'] = $farbe1wlpar[$row[\'wlp\']];
$Text = $row[\'gegner\'];
$row[\'gegner2\'] = substr($Text, 0, 20);
$row[\'farbe2\'] = $farbe2wlpar[$row[\'wlp\']];
if ( $class == \'Cmite\' ) { $class = \'Cnorm\'; } else { $class = \'Cmite\'; }
$row[\'class\'] = $class;
$tpl->set_ar_out($row,3);
}
$tpl->out(4);
echo $MPL;
} else {
das hat geklappt thx 4 help, bin doch net so blöd wie ich dachte mit php.
MfG
