• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

best quest makers help

Bumpys

Experienced Joker
Joined
Jan 18, 2012
Messages
190
Reaction score
11
Code:
<?PHP

    $id = intval($_REQUEST['id']);
    $i = 0;
    $quests = $config['site']['quests'];

    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=2 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white COLSPAN=';
    if(!is_int($id) || !in_array($id, $quests)) {
        $main_content .= '2><B>Quests</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=80%><B>Name</B></TD><TD><B>Players done</B></TD></TR>';
        foreach ($quests as $name => $storage) {
            $i++;
            $main_content .= '<TR BGCOLOR="'.(is_int($i / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']).'"><TD WIDTH=80%><a href="?subtopic=quests&id='.$storage.'" >'.$name.'</a></TD>';
            $n = $SQL->query('SELECT COUNT(`key`) as `count` FROM `player_storage` WHERE `key` = '.$storage.' AND `value` > 0;')->fetch();
            $main_content .= '<TD><CENTER>'.$n['count'].'</CENTER></TD></TR>';
        }
    }
    else {
        $main_content .= '3><B>Players who done '.array_search($id, $quests).' Quest</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=70%><B>Name</B></TD><TD WIDTH="10%"><B>Level</B></TD><TD WIDTH="20%"><B>Vocation</B></TD></TR>';
        $list = $SQL->query('SELECT `name`, `level`, `vocation`, `promotion` FROM `players` WHERE (SELECT `value` FROM `player_storage` WHERE `player_id` = `players`.`id` AND `key` = '.$id.' LIMIT 1) > 0;')->fetchAll();
        foreach($list as $player) {
            $i++;
            $main_content.= '<TR BGCOLOR='.(is_int($i / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']).'><TD WIDTH=70%><A HREF="?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[0][$player['promotion']][$player['vocation']].'</TD></TR>';
        }
    }
    $main_content .= '</TABLE></td></tr></table>';
?>


its got the best quest makers on server, how to make to show everyone even if he dont have done quest? because if not done its not showing ;/
 
Back
Top Bottom