Waiting Content Block Missing???

Worker Joined: Aug 06, 2004 Posts: 192

Ok I had this problem when I first started using PHP-Nuke. I was using 7.2. The waiting content block never shows in the Admin page of nuke. I upgrade to 7.3 and now 7.4 to see if this fixed the error, however it didn't.

I am know running version 7.4 and have the same problem. The waiting content block just will never show. I found out its hard coded in one of the files and its not in the blocks directory. I can see it in the file, but it won't display.

This is the code from my mainfile.php:

Code:

function adminblock() {


    global $admin, $prefix, $db;


    if (is_admin($admin)) {


   $result = $db->sql_query("SELECT title, content FROM ".$prefix."_blocks WHERE bkey='admin'");


   while ($row = $db->sql_fetchrow($result)) {


       $content = "<font class=\"content\">$row[content]</font>";


       themesidebox($row[title], $row[content]);


   }


   $title = ""._WAITINGCONT."";


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


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


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


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


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


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


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


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


   themesidebox($title, $content);


    }


}

Does anyone now why this would not be showing up and what file calls the admin_block function?

Posted: Tue Aug 24, 2004 1:19 pm

Well I just answered my own question. For some reason in the nuke_blocks table, the value for the bkey for the Administrative links was set to my username, and it should have been set to 'admin'.

Once I changed that it worked correctly. I have been trying to figure this out for months...

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

'admin' is the default, so how it got changed is beyond me Confused

In any event, glad it's working!