Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.219

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Related articles

7 Replies / 3004 Views


www.clanthemes.com Forum Index » Blocks	View previous topic :: View next topic

dconnor
Reputation: 462.2
Local time: 11:35 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 02, 2007
Last Visit: 18 Dec 2007
Posts: 7
Points: 100

Related articles Posted: Thu Aug 02, 2007 6:27 am

Hi:

I was wondering where I could get the "Related Articles" Block that is used in the news article on this site?

Thanks,

Dan

floppy
Reputation: 2088.8
votes: 22
Local time: 11:35 AM
Location: Jackson Mississippi

Site Admin

1.17 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 03 May 2012
Posts: 2353
Points: 132516

Related articles Posted: Thu Aug 02, 2007 12:52 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

This code needs a little refining, but I got this far on it. Open modules/News/article.php.

Find

Code:

$boxtitle = _RELATED;
$boxstuff = '';
$result8 = $db->sql_query('SELECT name, url FROM '.$prefix.'_related WHERE tid=\''.$topic.'\'');
while ($row8 = $db->sql_fetchrow($result8)) {
$name = stripslashes($row8['name']);
$url = stripslashes($row8['url']);
$boxstuff .= '<big>·</big> <a href="'.$url.'" target="_blank">'.$name.'</a> '."\n";
}

$boxstuff .= '<big>·</big> <a href="modules.php?name=Search&topic='.$topic.'">'._MOREABOUT.' '.$topictext.'</a> '."\n";
$boxstuff .= '<big>·</big> <a href="modules.php?name=Search&author='.$aaid.'">'._NEWSBY.' '.$aaid.'</a>'."\n";
$boxstuff .= ' <hr noshade="noshade" width="95%" size="1" /><center>'._MOSTREAD.' '.$topictext.': '."\n";

global $multilingual, $currentlang, $admin_file, $user;
if ($multilingual == 1) {
$querylang = 'AND (alanguage=\''.$currentlang.'\' OR alanguage=\'\')'; /* the OR is needed to display stories who are posted to ALL languages */
} else {
$querylang = '';
}
$row9 = $db->sql_fetchrow($db->sql_query('SELECT sid, title FROM '.$prefix.'_stories WHERE topic=\''.$topic."' $querylang".' ORDER BY counter DESC LIMIT 0,1'));
$topstory = intval($row9['sid']);
$ttitle = stripslashes(check_html($row9['title'], 'nohtml'));

$boxstuff .= '<a href="modules.php?name='.$module_name.'&file=article&sid='.$topstory.'">'.$ttitle.'</a></center> '."\n";
themesidebox($boxtitle, $boxstuff);

Replace With

Code:

$boxtitle = " Related Articles";
$checkrows = $db->sql_numrows($db->sql_query("select sid, title from ".$prefix."_stories where title LIKE %$title% $querylang order by counter desc limit 0,10"));
$boxstuff .= "<table cellspacing='2'>";
if($checkrows == 0){
$sql = $db->sql_query("select sid, title from ".$prefix."_stories where topic='$topic' $querylang order by counter desc limit 0,10");
while($row9 = $db->sql_fetchrow($sql)){
$topstory = intval($row9['sid']);
$ttitle = stripslashes(check_html($row9['title'], "nohtml"));
$boxstuff .= "<tr><td><a href=\"modules.php?name=$module_name&file=article&sid=$topstory\">$ttitle</a></center><hr></td></tr>";
}
}else{
$sql = $db->sql_query("select sid, title from ".$prefix."_stories where title LIKE %$title% $querylang order by counter desc limit 0,10");
while($row9 = $db->sql_fetchrow($sql)){
$topstory = intval($row9['sid']);
$ttitle = stripslashes(check_html($row9['title'], "nohtml"));
$boxstuff .= "<tr><td><a href=\"modules.php?name=$module_name&file=article&sid=$topstory\">$ttitle</a></center></td></tr>";
}
}
$boxstuff .= "</table>";
themesidebox($boxtitle, $boxstuff);

Phpnuke Downloads | VMaxxRx Male Enhancement

dconnor
Reputation: 462.2
Local time: 11:35 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 02, 2007
Last Visit: 18 Dec 2007
Posts: 7
Points: 100

Related articles Posted: Thu Aug 02, 2007 10:08 pm

Hi:

I tried to post a reply with some issues in my article.php file, using the

Code:

, but was blocked from the site.

how do i post code here?

Thanks,
dan

floppy
Reputation: 2088.8
votes: 22
Local time: 11:35 AM
Location: Jackson Mississippi

Site Admin

1.17 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 03 May 2012
Posts: 2353
Points: 132516

Related articles Posted: Thu Aug 02, 2007 11:14 pm
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

using the code tags. Hmmm.. I would need to see the syntax you posted. Usually javascript and a little php causes that.

dconnor
Reputation: 462.2
Local time: 11:35 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 02, 2007
Last Visit: 18 Dec 2007
Posts: 7
Points: 100

Related articles Posted: Fri Aug 03, 2007 5:53 am

I thank you in advance for your help:

I posted it here:

http://www.encyclocentral.com/article.txt

Your thoughts?

dconnor
Reputation: 462.2
Local time: 11:35 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 02, 2007
Last Visit: 18 Dec 2007
Posts: 7
Points: 100

Related articles Posted: Fri Aug 03, 2007 6:00 am

LOL, what I forgot to writes was, all the info that was in the blocked post...

The "Related Articles" and "Vote" code was removed by a programmer several years ago, as we tried to control what appeared and did not appear in the right hand block.

I would now like to have the "Related Articles" and "Vote" appear as a right hand block. Can you help me reimplement this code back into article.php?

Thank you,

Dan

floppy
Reputation: 2088.8
votes: 22
Local time: 11:35 AM
Location: Jackson Mississippi

Site Admin

1.17 posts per day
Medals: 2 (View more...)

Scripts/Coder

Joined: Nov 14, 2006
Last Visit: 03 May 2012
Posts: 2353
Points: 132516

Related articles Posted: Fri Aug 03, 2007 10:34 am
Shop Purchases:Clan Roster 2.0 · Multi Gaming (Warrior) Evo Theme · COD6 ModernWarfare 2 Teaser Splash Screen · Left for Dead Evo Extreme Version

If thats your only change then the logical thing to do would be restore the original articles.php from your original distrobution download.

dconnor
Reputation: 462.2
Local time: 11:35 AM

Noob

0.00 posts per day
Medals: 0

Joined: Aug 02, 2007
Last Visit: 18 Dec 2007
Posts: 7
Points: 100

Related articles Posted: Fri Aug 03, 2007 8:52 pm

Actually, I have a lot of SEO changes to that file.

I would like to make both the Related Article and the Vote code as blocks, so I could call to them as blocks.

But i am not converting the code correctly.

Dan

www.clanthemes.com Forum Index » Blocks

7 Replies / 3004 Views
Page 1 of 1
All times are GMT

Display posts from previous:

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 cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work