My First Ever Build

lofz · 12 Jun 2008 at 13:30

Hi Folks,

I thought I'd show off my first ever website build, I made it using phpnuke 8.1, I don't think I'd build a website with it again as it seems a bit outdated.

The site is for a warcraft guild I'm in please let me know what you think

www.thelionrampant.co.uk

I could use some help getting a scrolling forum block working. I have one that works but it displays topics from forums that are restricted to the mods group. i've tested it with a standard user account and they can't read the topics from that part of the forum all the same i'd like to hide the topics because we discuss confidential stuff about the guild.

Am I allowed to paste php code on this forum so I can get some assistance?

Thanks

Lofz

Edit: by looking at some other posts I've noticed that we are allowed to paste code I'll post it in a separate reply

Cheers

lofz · 12 Jun 2008 at 13:37

Here is the original code -

<?php

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

//include_once ('blocks/smileys.php');

global $prefix, $dbi, $sitename, $user, $cookie, $group_id;
$count = 1;
$amount = 15;
$content = "<A name= \"scrollingCode\"></A>";
$content .="<MARQUEE behavior= \"scroll\" align= \"center\" direction= \"up\" height=\"220\" scrollamount= \"2\" scrolldelay= \"25\" onmouseover='this.stop()' onmouseout='this.start()'>";
$content .="<center> <STYLE=\"text-decoration: none\">Last $amount Forum Messages</center>";
$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC LIMIT $amount", $dbi);
$content .= " ";
while(list($topic_id, $topic_last_post_id, $topic_title) = sql_fetch_row($result1, $dbi)) {
$result2 = sql_query("SELECT topic_id, poster_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %T') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);
list($topic_id, $poster_id, $post_time)=sql_fetch_row($result2, $dbi);

$result3 = sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$poster_id'", $dbi);
list($username, $user_id)=sql_fetch_row($result3, $dbi);

//$topic_title = substr("$topic_title", 0,17);
//$topic_title=parseEmoticons($topic_title);
// Remove the comment below to add the counter
//$content .="<STYLE=\"text-decoration: none\">Message: $count ";

$content .= "<img src=\"modules/Forums/templates/subSilver/images/icon_mini_message.gif\" border=\"0\"alt=\"\"><a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\"> $topic_title </a> Last post by <A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"STYLE=\"text-decoration: none\"> $username </a> on $post_time ";
$count = $count + 1;
}
$content .= " <center>[ <a href=\"modules.php?name=Forums\"STYLE=\"text-decoration: none\">$sitename ]</center>";
//$content .= "<center><img src=\"images/banners/fatalexception-logo-88x31.gif\" border=\"0\"></center>";
$content .= "</a>";
?>

I got told to try this but it stops the site loading properly -

Try changing line 16 from:
$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC LIMIT $amount", $dbi);
to
$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics WHERE forum_id NOT IN(###a CSV list of forum ids ####) ORDER BY topic_last_post_id DESC LIMIT $amount", $dbi);

replace "###a CSV list of forum ids ####"
with "2, 10" if the forum id of the officers board is 2 and some other board you don't want to see posts from is 10

You should be able to find the forum id by looking at the url when you click on the "officers" board link.

Any help would be really appreciated

Thanks

Leodido · 12 Jun 2008 at 14:03

looks ok, i'm not really a big fan of the color scheme it's a bit plain ! but the information is well displayed for a guild. Also you should improve the quality of your logo there

lofz · 12 Jun 2008 at 14:10

Aye, It needs a new theme and for some reason I can't get it to show a jpg banner with that specific theme.

Phpnuke is a bit pants tbh, I'd be tempted to buy another variation of the domain and start again. I can't just take the site offline its an essential part of the guild

lofz · 12 Jun 2008 at 15:47

fixed the code problem