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