1
Im having some problems trying to add the special ranks to the ranks section of the members. IE: Webmaster, Moderator, and others. Here is the code
include "../../mainfile.php";
include "../../header.php";
$db =& Database::getInstance();
echo "
Member Rank
Rank |
Minimum Post |
Maximum Post |
Image | ";
$result = $db->query("SELECT * FROM ".$db->prefix("ranks")." where rank_special=0 ORDER BY rank_id");
$count = 0;
while ( $rank = $db->fetchArray($result) ) {
if ($count % 2 == 0) {
$class = 'odd';
} else {
$class = 'even';
}
echo "$class' align='center'>
".$rank['rank_title']." |
".$rank['rank_min']." |
".$rank['rank_max']." |
";
if ( $rank['rank_image'] ) {
echo '.XOOPS_URL.'/uploads/'.$rank['rank_image'].'" alt="" /> | ';
} else {
echo ' ';
}
echo"";
$count++;
}
echo '';
include_once XOOPS_ROOT_PATH."/footer.php";
?> Now under
$result = $db->query("SELECT * FROM ".$db->prefix("ranks")." where rank_special=0 ORDER BY rank_id");
If the "rank_special=0" is changed to "rank_special=1" then you get the special ranks of webmaster, moderator, and so forth, but you loose the normal ranks, I would like to put both the normal and special ranks on there. Anyhelp will do. Thanx
