コード例 #1
0
                <div class="yui-u">
                    <div id="class_div"></div><div id="level_div"></div><div id="race_div"></div>
                </div>
            </div>
        </div>
        <div id="ft" role="contentinfo"><p>Last update on <?php 
echo $date;
?>
</p></div>
    </div>
  </body>
</html><?php 
$short_name = 'kon_members-1';
ScraperWiki::attach($short_name, 'src');
$keys = ScraperWiki::sqliteexecute("select * from swdata limit 0")->keys;
$data = ScraperWiki::select("* from swdata");
$class = array("captain" => 0, "lore-master" => 0, "rune-keeper" => 0, "guardian" => 0, "minstrel" => 0, "hunter" => 0, "burglar" => 0, "champion" => 0, "warden" => 0);
$level = array('0-9' => 0, '10-19' => 0, '20-29' => 0, '30-39' => 0, '40-49' => 0, '50-59' => 0, '60-65' => 0);
$race = array('elf' => 0, 'race of man' => 0, 'hobbit' => 0, 'dwarf' => 0);
$rank = array('leader' => 0, 'officer' => 0, 'member' => 0);
$members = array();
foreach ($data as $i => $member) {
    $class[strtolower($member->class)]++;
    $race[strtolower($member->race)]++;
    $rank[strtolower($member->rank)]++;
    $lvl = intval($member->level);
    $range = $lvl - $lvl % 10;
    if ($lvl <= 10) {
        $st = 0;
        $en = 10;
    } elseif ($lvl >= 60) {
コード例 #2
0
function get_page($url, $table_name = "pages")
{
    $rows = ScraperWiki::select("`text` from " . $table_name . " where url=?;", array($url));
    #Check length, then
    return $rows[0]['text'];
}