getConnection()); $ron = ''; $num = $_GET['num']; $ron = $_GET['ron']; $name = $_GET['name']; // echo "HALLO"; echo '

'.$name.'

'; // echo $num; $arSpalten = $htmlCon->getSpalten(); //var_dump($arSpalten); $val = $arSpalten[$num]; $valNeu = $arSpalten[$num]; //echo $val; $numneu = $num + 1; $valNeu = $arSpalten[$numneu]; // echo "SELECT * from guildmembers WHERE $val > 0 ORDER BY $val DESC"; $rs = mysql_query("SELECT * from guildmembers WHERE $val > 0 ORDER BY $val DESC", $database->getConnection()) or die (mysql_error()); // echo "SELECT * from guildmembers WHERE $val > 0 ORDER BY $val DESC"; if (isset($ron)) { if ($ron ==1) { $rs = mysql_query("SELECT * from guildmembers WHERE NAME IN ('Ronaldo', 'Hildchen', 'Traumfrau', 'Mercaba', 'Thekla', 'Frauschmitt','Suspiria', 'Faerghail', 'Wäscheleinen') ORDER BY $val DESC", $database->getConnection()) or die (mysql_error()); } } echo '
'; //echo 'Weiter ('.$valNeu.')'; echo ''; echo ''; $count = 0; while ($row = mysql_fetch_assoc($rs)) { if ($row["spec_icon"] != null) { $count ++; echo ''; echo ''; echo ''; // echo ''; echo ''; $pic = $htmlCon->drawImage($row["avatar"]); echo ''; echo ''; echo ''; echo ''; //echo ''; //echo ''; //echo ''; //echo ''; //echo ''; //echo ''; echo ''; } } echo ''; ?>
CountNameAvatarClass/RaceSpecPoints
'.$count.''.$row["name"].''.$row['name'].''.$pic.''.$htmlCon->getRaceIcon($row["race"], $row["gender"]); echo ' '.$htmlCon->getClassIcon($row["class"]).''.$htmlCon->getSpecIcon($row["spec_icon"]).''.$row[$val].''.$htmlCon->.''.$row->health.''.$row->averageItemLevel.''.$row->mountsCollected.''.$row->petsCollected.''.$row->clBWL.'