//start
$nn = 0;
$result = $db->query("SELECT * FROM cc" . $n . "_allianz ORDER BY points DESC LIMIT {$start},30");
while ($row = $db->fetch_array($result)) {
$alli = $row['aid'];
if ($row['text']) {
$infotext = substr($row['text'], 0, 30);
if (strlen($row['text']) > 30) {
$infotext .= "...";
}
} else {
$infotext = $ln_rankings_no_allianz_infos;
}
$i++;
$nn++;
$inhalt[$nn]['ali_name'] = generate_allilink($alli);
$inhalt[$nn]['ali_test'] = $infotext;
$inhalt[$nn]['points'] = $row['points'];
$inhalt[$nn]['platz'] = $i;
$ali_flag = get_allianz_flag($row['aid']);
$inhalt[$nn]['ali_flag'] = $ali_flag;
$inhalt[$nn]['ali_anz'] = $row['members'];
}
for ($i = 0; $i < $maxpage + 1; $i++) {
$pagesbit .= "<option value=\"{$i}\">" . ($i + 1) . "</option>";
}
$tpl->assign('page', $pagesbit);
$tpl->assign('daten', $inhalt);
template_out('ranking_ali.html', $modul_name);
exit;
}
$c_date = $row_e['change_date'];
$change_date = date("d.m.Y (H:i:s)", $c_date);
}
$tpl->assign('description', $description);
$tpl->assign('change_date', $change_date);
template_out('ali_news.html', $modul_name);
exit;
}
if ($action == "fahne") {
$erlaubt = is_allowed("change_fahne");
$ali_id = $userdata['allianzid'];
if ($erlaubt == 0) {
show_error('ln_allianz_php_2', $modul_name);
exit;
}
$ali_flag_pic = get_allianz_flag($ali_id);
$result_e = $db->query("SELECT fahne FROM cc" . $n . "_allianz WHERE aid ='{$ali_id}' ");
while ($allianz = $db->fetch_array($result_e)) {
$f1[$allianz['fahne'][0]] = "selected";
$f2[$allianz['fahne'][1]] = "selected";
$f3[$allianz['fahne'][2]] = "selected";
$f4[$allianz['fahne'][3]] = "selected";
$f5[$allianz['fahne'][4]] = "selected";
$f6[$allianz['fahne'][5]] = "selected";
$f7[$allianz['fahne'][6]] = "selected";
$f8[$allianz['fahne'][7]] = "selected";
$f9[$allianz['fahne'][8]] = "selected";
}
$tpl->assign('ali_flag_pic', $ali_flag_pic);
$tpl->assign('f1', $f1);
$tpl->assign('f2', $f2);
