Example #1
0
    $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">';
Example #2
0
    }
    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";
}