//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);