$result = $db->query($sql); unset($array); while ($row = $db->fetch_array($result)) { $array[count($array)]["name"] = $gdClass[$row["class"] - 1]["name"] . ' ' . $gdNetherHatcheries[$row["hatchery"]][$row["type"]]; $array[count($array) - 1]["value"] = $row["aantal"]; } sEntry("Most popular hatcheries", $array); sColumn("next"); $sql = "SELECT s.name, COUNT(*) AS aantal FROM {$db_previousage_accounts} AS a, signs AS s WHERE a.sign = s.id GROUP BY s.id ORDER BY aantal ASC, s.name ASC LIMIT 0,{$gdMaxStatLines}"; $result = $db->query($sql); unset($array); while ($row = $db->fetch_array($result)) { $array[count($array)]["name"] = $row["name"]; $array[count($array) - 1]["value"] = $row["aantal"]; } sEntry("Rarest birth signs", $array); sColumn("end"); $text .= '</table>'; // updating $sql = "INSERT INTO statistics (age, page, text) VALUES ('{$age}', '7', '')"; $result = $db->query($sql); $sql = "UPDATE statistics SET text = '" . addslashes($text) . "' WHERE age = '{$age}' AND page = '7'"; $result = $db->query($sql); $woot_datum = date("Y-m-d H:i:s"); echo "{$woot_datum}: w00t!\n"; } if ($action == "make3") { $text = '<table width="100%" border="0" cellspacing="0" cellpadding="0">'; $sql = "SELECT {$gdSpecialCreatureSelect}, a.name AS aname FROM summons AS s, creatures AS c, races AS r, {$db_previousage_accounts} AS a, nethers AS ns WHERE a.status != '2' AND ns.sid = s.id AND s.account = a.id AND s.creature = c.id AND c.race = r.id ORDER BY ns.skill DESC LIMIT 0,150"; $result = $db->query($sql); $text .= '<tr><td width="100%" valign="top" colspan="2">';
} sEntry("top magi by death skill", $array); sColumn("end"); // top magi by air skill sColumn("new"); $sql = "SELECT a.id, a.name, a.air, k.id AS kdid, k.name AS kdname FROM accounts AS a, kingdoms AS k WHERE a.status != '2' AND a.kingdom = k.id ORDER BY a.air DESC, a.xp DESC LIMIT 0,{$gdMaxStatLines}"; $result = $db->query($sql); unset($array); while ($row = $db->fetch_array($result)) { $array[count($array)]["name"] = '<a href="index.php?page=playerinfo&action=viewinfo&aid=' . $row["id"] . '">' . $row["name"] . '</a> (<a href="index.php?page=kingdominfo&action=viewinfo&kid=' . $row["kdid"] . '">' . $row["kdname"] . '</a>)'; $array[count($array) - 1]["value"] = $row["air"]; } sEntry("top magi by air skill", $array); sColumn("next"); // top magi by earth skill $sql = "SELECT a.id, a.name, a.earth, k.id AS kdid, k.name AS kdname FROM accounts AS a, kingdoms AS k WHERE a.status != '2' AND a.kingdom = k.id ORDER BY a.earth DESC, a.xp DESC LIMIT 0,{$gdMaxStatLines}"; $result = $db->query($sql); unset($array); while ($row = $db->fetch_array($result)) { $array[count($array)]["name"] = '<a href="index.php?page=playerinfo&action=viewinfo&aid=' . $row["id"] . '">' . $row["name"] . '</a> (<a href="index.php?page=kingdominfo&action=viewinfo&kid=' . $row["kdid"] . '">' . $row["kdname"] . '</a>)'; $array[count($array) - 1]["value"] = $row["earth"]; } sEntry("top magi by earth skill", $array); sColumn("end"); $text .= '</table>'; // write second part to file $sql = "UPDATE misctext SET text = '{$text}' WHERE name = 'rodia2'"; $result = mysql_query($sql); $woot_datum = date("Y-m-d H:i:s"); echo "{$woot_datum}: w00t!\n"; }