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 ;/