{Request} Newest Threads

[Automated]

Hi All!

I have searched High and low, and cannot find a hack/mod that will let me show the 10 newest threads on my forums on another website!

What i mean is, I have a forum and a content site that is related to the forum, and want to have a table at the bottom of the page that shows the 10 newest threads, its author and the number of replies.

I have seen a load of these in use on other website and cannot find the dam thing!

Please point me in the right direction! Thanks a lot!

Matthew

[Neo]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=44719" target="_blank">https://vborg.vbsupport.ru/showt...threadid=44719</a>

[Automated]

thats not what i mean, have a look at the bottom of the page at sitepoint.com thats what i want!

Thanks
Matthew

[FlyingDutchman]

you might wanna check this out:

https://vborg.vbsupport.ru/showthrea...threadid=38334

you could 'rip' the not-needed code out...
or you could rip the code from one of those other 'home' pages, like vbportal, vbindex, vbhome, etc.

[Automated]

I am not a programmer, and i have VERY basic VBulletin skillls as i only got the license 3 days ago

Could anyone help me out?

thanks
Matthew

[FlyingDutchman]

o, sorry didn't know...
well, i can do this lil' flick for you if you can tell me where you actually want it... on your forum home page, or your website homepage? (i assume it's the last one)
if it's your website homepage, what language is it written in? php? plain html? something else?

please tell me

[Automated]

Thanks a lot man!

it is written in PHP!

And it is on another server my forums http://freelanceforums.com and the site i want it on is http://howtofreelance.com (not yet built) so i dont know if this effects anything

the page is in PHP so if you could make the page that i just need to add my DB details to that would be great ! Thanks a lot!

Matthew

[FlyingDutchman]

ok, this might work (i haven't tested... and b/c of your forums are on another server/domain, i'm not sure if it actually works...)
i also removed the permissions code that was included in the original, this might not be so secure, but if you don't do strange things, it should be ok (supposing your forums are viewable by guests...)

open your php file, just after <? add:

PHP Code:

// Simple Newsportal & Threads overview hack
// Copyright by KuraFire, 2002 :)
// With extra credit to PPN for the permissions section

$templatesused = 'newsportal,newsportal_threadbit,newsportal_newsbit';
include('http://url-to-your-forums/forums/global.php');

// These are the variables which define the news forum and the
// limit of threads.
$newsforum = 5;
$threadslimit = 10; 


(Remember to change the url: ''http://url-to-your-forums/forums/" to the right url and set the variables...)


then, where you want the 10 (or more or less if you want, see the variables) latest threads/replies list to show up, put this in the php file:

PHP Code:

/* ### THREADS SECTION ### */

$threadsql = $DB_site->query("SELECT lastposter, threadid, title, replycount FROM thread WHERE open='1' AND open<>10 $forumperms ORDER BY lastpost DESC LIMIT 

$threadslimit");

if (!$threadsql) {
  // use this only to check whether it works on your board, 
  // after all tests turn successful you can remove it if you want (remove entire IF-statement of course)
  echo "<p>Could not get thread records.";
  exit;
}

while ($thread=$DB_site->fetch_array($threadsql)) {
    $lastposter=$thread['lastposter'];
    $threadid=$thread['threadid'];
    $title=$thread['title'];
    $replycount=$thread['replycount'];
    
    $fulltitle = $title;
    if (strlen($title) > 50) {
            $title = substr($title, 0, 50);
            $title .= '...';
    }

    eval("\$threadbits .= \"".gettemplate('newsportal_threadbit')."\";");
} 


finally log in to the admin panel of your forums and make a new template called 'newsportal_threadbit' with the following contents:

PHP Code:

  <tr bgcolor="#F1F1F1"> 
   <td bgcolor="#F1F1F1" width="7" align="center" valign="top"><smallfont>&raquo;</smallfont></td>
   <td onMouseOver="style.backgroundColor='#8080A6'; style.cursor='hand'" onMouseOut="style.backgroundColor='#F1F1F1';" onClick="location.href='showthread.php?s=&threadid=$threadid&goto=lastpost'">&nbsp;<a href="showthread.php?s=&threadid=$threadid&goto=lastpost">$title</a> <smallfont color="#FFFFFF">[$replycount]-[$lastposter]</smallfont></td>
  </tr> 


REMEMBER THAT I DID NO CODING ON THIS ONE, EVERYTHING IS CODED BY KuraFire, AND THEREFORE ALL CREDITS ABOUT THE CODE SHOULD GO TO HIM!!!

[Automated]

Thanks A LOT for that!

I will test it now

[hides the excitement ]

Matthew

[FlyingDutchman]

lol, tell me if it works