submission block with cnbya

Regular Joined: Oct 28, 2004 Posts: 84

hi guys trying to finish up my submission block seem to come accross a snag what i trying to do is display activer users, pending users and suspended users in my admin submission block.

but just cant get it to show it just messes up the display any idears or what i done wrong

Code:

// Submissions


$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_queue"));


$content  .=  "<center><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=\"95%\">";


$content  =  "<div align=\"left\"><img src=\"images/green_dot.gif\" width=\"8\" height=\"8\"> <strong>"._ASNR."</strong></div>";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=submissions\">"._SUBMISSIONS."</a>: <b>$num</b></a><br>\n";





// Reviews


$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_reviews_add"));


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=reviews\">"._WREVIEWS."</a>: <b>$num</b></a><br>\n";





// Downloads


$content  .= "<div align=\"left\"><img src=\"images/green_dot.gif\" width=\"8\" height=\"8\"> <strong>"._UDOWNLOADS."</strong></div>";


$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_newdownload"));


$brokend = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='1'"));


$modreqd = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_modrequest WHERE brokendownload='0'"));


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=DownloadsListBrokenDownloads\">"._BROKENDOWN."</a>: <b>$brokend</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=downloads\">"._UDOWNLOADS."</a>: <b>$num</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=DownloadsListModRequests\">"._MODREQDOWN."</a>: <b>$modreqd</b></a><br>\n";





// Universal


$content  .= "<div align=\"left\"><img src=\"images/green_dot.gif\" width=\"8\" height=\"8\"> <strong>"._ASUNI."</strong></div>";


$numwaiting = $db->sql_numrows($db->sql_query("SELECT id from ".$prefix."_universal_queue"));


$numrequestwaiting = $db->sql_numrows($db->sql_query("SELECT id from ".$prefix."_universal_requests where approved = '0'"));


$nummodrequestwaiting = $db->sql_numrows($db->sql_query("SELECT id from ".$prefix."_universal_modify"));


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Universal&file=admin&op=ItemQueue\">"._ASUNIWI."</a>: <b>$numwaiting</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Universal&file=admin&op=WaitingMods\">"._ASUNIWM."</a>: <b>$nummodrequestwaiting</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Universal&file=admin&op=requestadmin\">"._ASUNIWR."</a>: <b>$numrequestwaiting</b></a><br>\n";





// Web Links


$content  .= "<div align=\"left\"><img src=\"images/green_dot.gif\" width=\"8\" height=\"8\"> <strong>"._ASWL."</strong></div>";


$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_newlink"));


$brokenl = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='1'"));


$modreql = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_links_modrequest WHERE brokenlink='0'"));


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: <b>$brokenl</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=LinksListModRequests\">"._MODREQLINKS."</a>: <b>$modreql</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"".$admin_file.".php?op=Links\">"._WLINKS."</a>: <b>$num</b></a><br>\n";





// User Accounts


$content  .= "<div align=\"left\"><img src=\"images/green_dot.gif\" width=\"8\" height=\"8\"> <strong>"._ADMIN_USER."</strong></div>";


$act = $db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_users WHERE user_level>'0' AND user_id>'1'"));


$sus = $db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_users WHERE user_level='0' AND user_id>'1'"));


//$del = $db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_users WHERE user_level='-1' AND user_id>'1'"));


//$nor = $db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_users WHERE user_id>'1'"));


$pen = $db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_users_temp"));


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Your_Account&file=admin&op=listnormal&query=1'>"._ACTIVEUSERS."</a>: <b>$act</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Your_Account&file=admin&op=listnormal&query=0'>"._SUSPENDUSERS."</a>: <b>$sus</b></a><br>\n";


$content  .= "<img src=\"images/red_dot.gif\" width=\"8\" height=\"8\"> <a href=\"modules.php?name=Your_Account&file=admin&op=listpending'>"._WAITINGUSERS."</a>: <b>$pen</b></a><br>\n";

much thanks

steve

Posted: Sun Jun 05, 2005 3:09 pm

If I could see an example of what it is doing as far as 'messing up the display', that would be helpful in troubleshooting it.

-sting

Posted: Mon Jun 06, 2005 1:59 am

its ok now bro all sorted thanks again