//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;
}
}
$tpl->config_load($lang_file);
$members_koords = $tpl->get_config_vars('MEMBERS_KOORDS');
$members_points = $tpl->get_config_vars('MEMBERS_POINT');
$profile_on = $tpl->get_config_vars('PROFILE_ONLINE');
$profile_off = $tpl->get_config_vars('PROFILE_OFFLINE');
$result = $db->query("SELECT rassenname FROM cc" . $n . "_rassen WHERE rassenid='{$row['rassenid']}'");
$userrasse = $db->fetch_array($result);
$result = $db->query("SELECT userid,name,islandid,points,x,y FROM cc" . $n . "_countries WHERE userid='{$id}'");
while ($i = $db->fetch_array($result)) {
$module = get_modulname(7);
$map_modul_org = "./../" . $module[0] . "/" . $module[1];
$land_link = "<a href=\"{$map_modul_org}?x={$i['x']}&y={$i['y']}\">" . $i[name] . " " . $members_koords . " ({$i['x']}:{$i['y']})</a>";
$ibit .= $land_link . " {$i['points']} " . $members_points . "<br>";
}
$userallianzname = generate_allilink($row['allianzid']);
if ($row['lastactive'] > time() - 3600) {
$online = "<span class=\"green\">" . $profile_on . "</span>";
} else {
$online = "<span class=\"red\">" . $profile_off . "</span>";
}
if (trim($row['userpic']) == "") {
$upic = "./images/no_user_pic.jpg";
} else {
$upic = $row['userpic'];
}
$description = bb2html($row['description']);
$message_link = generate_messagelink($row['username'], 1);
$tpl->assign('description', $row['description']);
$tpl->assign('message_link', $message_link);
$tpl->assign('username', $row['username']);
