I saw this hack-mod once.
Is for a non-VB page, that's why it get all that data directly from DB.
And that's why it wont work if you put it direct into a vb-page (in a template for example)

Ah, sorry 'bout that. I forgot to mention about prefixes. Tnguy3n is correct, you have to substitute your own database prefix (if any). My prefix for my database tables is "vb_". If you don't use a prefix, change these lines as follows:
$result = mysql_query("SELECT postid FROM vb_post WHERE visible=1");
to
$result = mysql_query("SELECT postid FROM post WHERE visible=1");

$post_sql = mysql_query("SELECT postid,threadid,username,userid,dateline FROM vb_post WHERE visible=1 ORDER BY postid DESC $limited");
to
$post_sql = mysql_query("SELECT postid,threadid,username,userid,dateline FROM post WHERE visible=1 ORDER BY postid DESC $limited");

and

$thread_sql = mysql_query("SELECT title FROM vb_thread WHERE threadid=$tid");
to
$thread_sql = mysql_query("SELECT title FROM thread WHERE threadid=$tid");

(pretty much just what tn said).

I don't *think* so (the "WHERE visible=1" should prevent non-public posts from showing up, if I understand that database entry correctly), but I haven't actually tested it. Let me know if it doesn't work as intended, and I'll see what I can do. I'll work on the code as well so there's an entry in the "modifiables" section for the database prefix so it's more obvious.

Ron

ok thxn its working now, how can i change bg color and stuff?

i have tried to use it as a postnuke block, so the block on right side displays the latest forums posts.
but it gives error. the page is working fine from direct url, but when i use it as block it doesnt work. Any suggetions

Updated the code to make the database prefix issue more user friendly.

Selene: What error are you getting with postnuke?

To answer your question about the table color, there's a few ways you can change it. To change the background color, put an entry in the tr field. For the font color, unfortunately, because we are dealing with static text, links, and (possibly) visited links, it's a bit more complex. Also, I've set it up so that you can control the fonts for each field individually, so we have three different fields to deal with (because I have < font > in three seperate places, I don't think you can set the three entries globally, as the < /font > would kill them, so you have to do them one at a time, if I'm not mistaken).

So let's say you wanted black background with white text, the resulting output line would look like this:

echo "<tr bgcolor='black'><td><font size='2' color='white' link='white' vlink='white'>$date2<BR></font><font size='2' color='white' link='white' vlink='white'><a href=\"$forum_url/showthread.php?p=$pid#post$pid\">$title</a></font><font size='2' color='white' link='white' vlink='white'><i><BR><a href=\"$forum_url/member.php?userid=$userid\">$poster</a></i></font></td></tr>";

Ugly, I know. But it should work :) I haven't tested it though, so I make no promises. You could shorten it a little bit by being more specific for particular lines (for instance, we know the first line (the date) is static text, so there's really no need to set the link or vlink colors there, I'm doing it just for consistency sake).

Hope that helps.

Ron

Hi Ron, gr8 ! i will try that out so thats sorted! well its just when i try to make the latest forums page open as block using php in postnuke i get error:

u can check http://67.19.62.198/post/

i also opened a thread on postnuke site : http://forums.postnuke.com/index.php...topic&p=154711


Otherwise gr8 and useful hack! and good work :)

done no problem already !

www.aroclubindonesia.com

arowana club indonesia !

hendri i still cant get it to work with postnuke as block. can u see the url in my previous post and check the error. wud be nice if I can get it to work in postnuke

I've had something like this on my site for a while: http://www.s3squad.com

Check these links out:
https://vborg.vbsupport.ru/showthread.php?t=62823
https://vborg.vbsupport.ru/showthread.php?t=62624


But noine that use the built in vB functions. Would be nice.