Question about Admin Waiting Content

Client Joined: Jul 18, 2003 Posts: 977

Where can I locate the code for this block? There are some links that need changed now that I am using NSN Groups. The current Downloads, Broken Download, and the Modify Download do not link properly. I would like to change them. I looked and look and I cannot find it. Thank you!

Sells PC To Pay For Divorce Joined: Posts: 5661

thats at function adminblock() blith..
in mainfile.php line : 1019

function adminblock() {
global $admin, $prefix, $db, $admin_file;
if (is_admin($admin)) {
$sql = "SELECT title, content FROM ".$prefix."_blocks WHERE bkey='admin'";
$result = $db->sql_query($sql);
while (list($title, $content) = $db->sql_fetchrow($result)) {
$content = "".$content."";
themesidebox($title, $content);
}
$title = _WAITINGCONT;
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_queue"));
$content = "";
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=submissions\">"._SUBMISSIONS."</a>: $num ";
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_reviews_add"));
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=reviews\">"._WREVIEWS."</a>: $num ";
$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 .= "<big>·</big> <a href=\"".$admin_file.".php?op=Links\">"._WLINKS."</a>: $num ";
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=LinksListModRequests\">"._MODREQLINKS."</a>: $modreql ";
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: $brokenl ";
$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 .= "<big>·</big> <a href=\"".$admin_file.".php?op=downloads\">"._UDOWNLOADS."</a>: $num ";
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=DownloadsListModRequests\">"._MODREQDOWN."</a>: $modreqd ";
$content .= "<big>·</big> <a href=\"".$admin_file.".php?op=DownloadsListBrokenDownloads\">"._BROKENDOWN."</a>: $brokend ";
themesidebox($title, $content);

Posted: Sat Mar 25, 2006 4:21 pm

thank you!

Posted: Mon Mar 27, 2006 2:10 pm

This is a continuation question... okay so I change the links in the Admin Waiting Content so the links take me to the proper page but what about the little numbers after the links. Since I have NSN Downloads will I need to change some other code to get that to report if I have any waiting content? If so can someone help me out with it? Thank you.

Posted: Mon Mar 27, 2006 2:30 pm

ah blith...im sure you can do that...
just check nsn Downloads query and replace it with the old one in the mainfile...usualy its a few words or letters to replace..

Posted: Mon Mar 27, 2006 4:37 pm

okay I will take a look. thanks. I just didn't want to bugger it up... but I guess that is what the original file is for. Fixin'!

Posted: Mon Mar 27, 2006 4:45 pm

Well its just a guess but change :
$num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_newdownload"));

into:

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

Posted: Mon May 08, 2006 12:22 pm

Here is my working Admin Content:

Code:

$title = _WAITINGCONT;


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


      $content = "<span class=\"content\">";


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=submissions\">"._SUBMISSIONS."</a>: $num<br>";


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


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=reviews\">"._WREVIEWS."</a>: $num<br>";


      $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 .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=Links\">"._WLINKS."</a>: $num<br>";


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=LinksListModRequests\">"._MODREQLINKS."</a>: $modreql<br>";


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: $brokenl<br>";


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


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


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


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=DownloadNew\">"._UDOWNLOADS."</a>: $num<br>";


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=DownloadModifyRequests\">"._MODREQDOWN."</a>: $modreqd<br>";


      $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".$admin_file.".php?op=DownloadBroken\">"._BROKENDOWN."</a>: $brokend<br></span>";


      themesidebox($title, $content);


   }


}

registered · Posted: Tue May 09, 2006 5:51 am

Thanks for sharing the final solution!

New Member Joined: May 08, 2006 Posts: 3

Thanks for posting the fix, blith! Works for me!