News Problem & Forum Moderator Problem

New Member Joined: Mar 07, 2005 Posts: 19

Hello all,

Long time reader, first time poster. Just upgraded to Raven's Distro 2 and I'm having some issues. My install has nothing major as far as addons go, just sommaire, MS Info Block, and Coppermine.

First is News. When I create a news story, assign a topic, and preview the story, I have no issues. The topic icon shows just fine. However, when I post to home, the topic icon does not show. Plus, when I click on extended story, I get blank, white page and you can't comment on stories either. Can't figure it out. So, I picked up this nifty little block to display my news in. Topic shows fine, but extended story when clicked still shows blank, white page and no comments available. I would like to get both items working properly. Any ideas would be appreciated. If you would like to experience what I'm talking about, the link to my site:
http://www.theperfectgeneral.com

Code to the block is here:

Code:

<?php


######################################################################


# PHP-Nuke                                                           #


#====================================================================#


#  Copyright (c) 2003 - Francisco Burzi                              #


#  http://phpnuke.org/                                               #


#====================================================================#


# Dutchies block-fancy_newsblock.php for PHP-Nuke 6+                 #


#====================================================================#


#  Copyright (c) 2004 - (webmaster@dutchies.be)                      #


#  http://wwww.dutchies.be/                                          #


#====================================================================#


#  Use of this program is goverened by the terms of the GNU General  #


#     Public License (GPL - version 1 or 2) as published by the      #


#           Free Software Foundation (http://www.gnu.org/)           #


######################################################################





if (eregi("block-Fancy_Newsblock.php",$_SERVER['PHP_SELF'])) {Header("Location: index.php");


die();}








$limit     = 5;     // <= Total news items in block


$hnews     = 3;      // <= Maximum of highlighted news items in block


$showlinks = 1;      // Show more links at bottom


$strip     = "400";  // Size of the Max Number of characters displayed in highlighted news


$hnbdr     = 1;      // highlighted News Border off = 0 or border on = 1


$nnbdr     = 0;      // Normal News     Border off = 0 or border on = 1


$blbrd     = 0;      // border arround all items





//Dont change anything below!!


global $currentlang, $sitename, $ThemeSel;





if ($currentlang == "dutch") {


$title       = "Laatste";


$title1      = "Nieuws items";


$from        = "Geplaatst door";


$moreLink    = "Meer nieuws";


$topicLink   = "Onderwerp";


$archiveLink = "Nieuws Archief";


$submitLink  = "Nieuws Toevoegen";


$morenews    = "Lees meer";


$Printer     = "Print vriendelijk";


$friend      = "Stuur naar vriend";


$LDcounter   = "X Gelezen";


} else if ($currentlang == "french") {


$title       = "-";


$title1      = "-";


$from        = "-";


$moreLink    = "-";


$topicLink   = "-";


$archiveLink = "-";


$submitLink  = "-";


$morenews    = "-";


$Printer     = "-";


$friend      = "-";


$LDcounter   = "-";


} else {


$title       = "Latest";


$title1      = "News items";


$from        = "Posted by";


$moreLink    = "More news";


$topicLink   = "Subject";


$archiveLink = "News Archive";


$submitLink  = "Submit News";


$morenews    = "Read more";


$Printer     = "Print frindly";


$friend      = "Send to friend";


$LDcounter   = "times read";


}





function sa_darkColor($color, $level=16) {


$ret = strval($color);


if ($ret[0] == "#") {


$red = hexdec(substr($ret,1,2));


$grn = hexdec(substr($ret,3,2));


$blu = hexdec(substr($ret,5,2));


$red = (($red-$level) > 0) ? $red-$level : 0;


$grn = (($grn-$level) > 0) ? $grn-$level : 0;


$blu = (($blu-$level) > 0) ? $blu-$level : 0;


$ret = sprintf("#%02X%02X%02X", $red, $grn, $blu);


}


return $ret;


}





function sa_lightColor($color, $level=16) {


$ret = strval($color);


if ($ret[0] == "#") {


$red = hexdec(substr($ret,1,2));


$grn = hexdec(substr($ret,3,2));


$blu = hexdec(substr($ret,5,2));


$red = (($red+$level) < 255) ? $red+$level : 255;


$grn = (($grn+$level) < 255) ? $grn+$level : 255;


$blu = (($blu+$level) < 255) ? $blu+$level : 255;


$ret = sprintf("#%02X%02X%02X", $red, $grn, $blu);


}


return $ret;


}


global $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $nukeurl, $db, $prefix, $admin, $topic, $topicname, $topicimage, $topictext, $informant, $multilingual, $currentlang;





$bgdark1  = sa_darkColor ($bgcolor1, 5);


$bgdark2  = sa_darkColor ($bgcolor2, 25);


$bgdark3  = sa_darkColor ($bgcolor3, 25);





$bglight1 = sa_lightColor($bgcolor1, 25);


$bglight2 = sa_lightColor($bgcolor2, 15);


$bglight3 = sa_lightColor($bgcolor3, 5);





if ($multilingual == 1) {$querylang = "AND (alanguage='$currentlang' OR alanguage='')";} else {$querylang = "";}


$content = "<div align=center><img src=\"images/Fancy_NB/dutch-ies.gif\" border=\"0\" Alt=\"$nukeurl\"><table cellspacing=\"2\" cellPadding=\"1\" width=\"100%\" border=\"$blbrd\" bordercolor=\"$bgdark2\" bgcolor=\"$bgcolor1\"><tr><td align=\"center\">";





$sql = "SELECT t1.title AS cat, t0.score, t0.sid, t0.catid, t0.alanguage, t0.informant, t0.title, t0.time, t0.hometext, t0.topic, t0.comments, t0.counter, t2.topicimage, t2.topicid, t2.topictext FROM ".$prefix."_stories t0, ".$prefix."_stories_cat t1, ".$prefix."_topics t2 WHERE t0.catid=t1.catid AND t0.topic=t2.topicid $querylang ORDER BY t0.sid DESC LIMIT 0, $limit";


$result = $db->sql_query($sql);


$rc = 0;


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


$score = $row[score];


$sid = $row[sid];


$title  = $row[title];


$inform = $row[informant];


$langu  = $row[alanguage];


$text   = $row[hometext];


$D = substr($row[time], 8, 2);


$M = substr($row[time], 5, 2);


$Y = substr($row[time], 2, 2);


$time = $D."/".$M."/".$Y;


$linkstrip7 = stripslashes($text);


if(strlen($linkstrip7) > $strip) {


$linkstrip7 = substr($linkstrip7,0,$strip);


$linkstrip7 .= "...";}


$comtotal = $row[comments];


$counter = $row[counter];


if ($hnbdr==1) {$hncs = 1;} else {$hncs = 2;}


if ($nnbdr==1) {$nncs = 1;} else {$nncs = 1;}


if ($rc<$hnews) {


$pict     = "images/topics/$row[topicimage]";


$size     = getimagesize($pict);


$width    = "$size[1]";


$content .= "<table cellspacing=\"$hncs\" align=\"center\" cellPadding=\"2\" width=\"100%\" border=\"$hnbdr\" bordercolor=\"$bgdark2\" bgcolor=\"$bgdark1\"><tr><td bgcolor=\"$bglight1\" align=center valign=\"top\" width=\"".$width."\"><b><a href=\"modules.php?name=News&amp;new_topic=$row[topic]\"><img src=\"$pict\" border=\"0\" Alt=\"$row[topictext]\"></a></b></td>";


$content .= "<td bgcolor=\"$bglight1\" valign=\"top\" title=\"$from $inform\" onMouseOver=this.style.backgroundColor=\"$bgdark1\" onMouseOut=this.style.backgroundColor=\"$bglight1\" onclick=\"window.location.href='modules.php?name=News&amp;file=article&amp;sid=$sid'\"><a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"3\"><b>$title</b></font></a><br>";


$content .= "<font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\">$linkstrip7</font></td></tr></table>\n";


if ($hnews!=$limit) {$content .= "<table><tr><td height=\"3\"></td></tr></table>";}


} else {


$pict     = "images/Fancy_NB/$row[topicid].gif";


$content .= "<table cellspacing=\"$nncs\" align=\"center\" cellPadding=\"2\" width=\"99.5%\" border=\"$nnbdr\" bordercolor=\"$bgdark2\" bgcolor=\"$bgdark1\">";


$content .= "<tr><td bgcolor=\"$bglight1\" align=center width=\"3%\"><b><a href=\"modules.php?name=News&amp;new_topic=$row[topic]\"><img src=\"$pict\" border=\"0\" Alt=\"$row[topictext]\"></a></b></td>";


$content .= "<td bgcolor=\"$bglight1\" align=center width=\"9%\">$time</td><td bgcolor=\"$bglight1\" align=left valign=\"top\" width=\"84%\" title=\"$from $inform\" onMouseOver=this.style.backgroundColor=\"$bgdark1\" onMouseOut=this.style.backgroundColor=\"$bglight1\" onclick=\"window.location.href='modules.php?name=News&amp;file=article&amp;sid=$sid'\"><a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><b>$title</b></font></a></td><td bgcolor=\"$bglight1\" align=right width=\"4%\" title=\"$LDcounter\">$counter</td></tr></table>\n";


}


$rc = $rc+1;


}


$content .= "</td></tr><tr><td align=center>";


if ($hnews!=$limit) {


$sql1 = "SELECT topicid, topictext FROM ".$prefix."_topics order by topicid";


$result4 = $db->sql_query($sql1);


while( list($topicid, $topictext) = $db->sql_fetchrow( $result4 )){


$content .= "<img src=\"images/Fancy_NB/$topicid.gif\" border=\"0\" Alt=\"$topictext\" align=\"absmiddle\"> $topictext&nbsp;";


}


}


$content .= "</td></tr>";


if ($showlinks==1){$content .= "<tr><td align=center><A HREF=\"news.html\">$moreLink</A>&nbsp;<strong><big>&middot;</big></strong>&nbsp;<A HREF=\"topics.html\">$topicLink</A>&nbsp;<strong><big>&middot;</big></strong>&nbsp;<A HREF=\"archive.html\">$archiveLink</A>&nbsp;<strong><big>&middot;</big></strong>&nbsp;<A HREF=\"modules.php?name=FCKeditor\">$submitLink</A></td></tr>";}


$content .= "</table>";


?>

Second problem is this. I can't assign individual moderators to forums. When I try, I get this error:

Code:

Could not obtain moderator status





DEBUG MODE





SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND aa.group_id = ug.group_id AND aa.auth_mod = 1





SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id





Line : 530


File : admin_ug_auth.php

Sorry for the long post. Again, any help is appreciated.

Posted: Mon Apr 10, 2006 7:07 am

First problem, try replacing

Code:

if (eregi("block-Fancy_Newsblock.php",$_SERVER['PHP_SELF'])) {Header("Location: index.php"); 


die();}

with

Code:

if ( !defined('BLOCK_FILE') ) {


    Header("Location: ../index.php");


    die();


}

see if that helps.

Second issue - check your nuke_bbauth_access table to see if the field auth_mod actually exists.

Which version of nuke did you upgrade from?

Posted: Mon Apr 10, 2006 3:46 pm

Nope, I changed the block as you suggested and just get a white page. Same thing I get when I click on the actual news module when posted in home.

Yes, the field does exist.

I did a fresh install of RN, then imported my table data as necessary. However, I did not import any news data. Thanks for the response.

Posted: Mon Apr 10, 2006 9:48 pm

Yes, having no news in the DB would have that affect.
I have installed it on my test site at [ Only registered users can see links on this board! Get registered or login! ] as the second center block down with the title 'NewsTest' and it works fine apart from the missing images which came with your download of the block file.
Incidentally, you should keep that file change for security - this will also allow you to rename the block file without any adverse affects.

Posted: Wed Apr 12, 2006 10:47 pm

Ok, the problem with the topics icons not showing was my theme. I changed my theme and they show fine in news posts. I removed the news block. Now the only issue I'm having is the blank, white page when I click on a news story from home or click on comments.