Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks
Author Message
perfect-games
Regular
Regular


Joined: Oct 28, 2004
Posts: 84

PostPosted: Sun May 22, 2005 10:01 pm Reply with quote

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
 
View user's profile Send private message
sting
Involved
Involved


Joined: Sep 23, 2003
Posts: 456
Location: Somewhere out there...

PostPosted: Sun Jun 05, 2005 3:09 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
perfect-games
PostPosted: Mon Jun 06, 2005 1:59 am Reply with quote

its ok now bro all sorted thanks again
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Blocks

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©