vb.org Archive - Last X Posts Titles on Non-VB page

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Last X Posts Titles on Non-VB page (https://vborg.vbsupport.ru/showthread.php?t=62624)

RobinHood

03-17-2004 10:00 PM

Last X Posts Titles on Non-VB page

Hi everyone,

Well, here is my first full release to the vB.org community. It's a small little script I just whipped up a few minutes ago. I already have this on my webpage for months now and thought I'd share it with the rest of you.

Description:
This script will display the titles, poster's names, and times of the last X's posts. It's fully customizable. Should be very easy to understand so enjoy!

Instructions:
1) Download the script below.
2) Change the settings in the script.
3) Insert include("/path/to/lastposts3.php"); anywhere in a non-VB page.

If you like to check out a live demo, you may go visit one of my sites: http://www.generazn.com.

If you have any problems, questions, or comments regarding this, feel free to post them here or send me an email to tre@phase1media.com.

sabret00the

03-18-2004 09:03 AM

i can't see it on your site, screenie?

mr_fox

03-18-2004 12:00 PM

it's work!
Thenks

gmarik

03-18-2004 01:43 PM

heah, thanks ...

Owen	03-18-2004 03:34 PM

Is it possible to limit the number of characters displayed?

bluecat

03-18-2004 05:07 PM

Cool, I've been waiting for one for vb3. Thanks!

Q8vbhacks

03-19-2004 11:42 AM

thanks

i get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/XXX/public_html/lastposts3.php on line 43

accyroy

03-20-2004 10:09 AM

how do i offset the time, my forum and server are different and this hack displays server time...?

Buddha

03-20-2004 07:29 PM

is there a way to set this up so that it can display threads from a forum that is installed on another subdomain? say i've got a forum on a.domain.com and i want to display the latest threads on b.domain.com/index.php... how would i go about this?

thanks

apokphp

03-21-2004 06:16 PM

very nice...this is what I've been waiting for. ;)

SmasherMaster

03-21-2004 11:51 PM

Works...prefectly! :D

[high]* SmasherMaster hits install[/high]

RobinHood

03-22-2004 05:57 AM

Quote:

Originally Posted by Q8vbhacks

thanks

i get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/XXX/public_html/lastposts3.php on line 43

Make sure you set the $limit variable.

RobinHood

03-22-2004 05:59 AM

Quote:

Originally Posted by Buddha

As long as it's on the same server, you sure can.

All you have to do is change the original include to:

include("/path/to/lastpost3.php");

Also, make sure you change the $forum_url variable to forum A.

RobinHood

03-22-2004 06:14 AM

Quote:

Originally Posted by Owen

Is it possible to limit the number of characters displayed?

It sure is. Just download the updated version of the script. :)

Buddha

03-22-2004 06:36 PM

Quote:

Originally Posted by RobinHood

thanks for the quick reply, robinhood... and i may seem like a complete dunce here, so bear with me, ok.

first, i'm assuming i upload the lastposts3.php file to the same directory as my forum... which is on subdomain A. then, on my index.php on subdomain B, i would put

PHP Code:


		
			
<? include("/public_html/A/lastpost3.php"); ?>

if this is right, then i'm curious why it isn't working... i've changed the script so it points to the proper forum directory...

Ian Cunningham

03-22-2004 07:23 PM

How could I make this check multiple forums? I changed $forum_id =(x,y), but that doesnt work :(

Buddha

03-24-2004 02:56 PM

any chance getting some support on this, as i would really love to use this hack, but i cannot get it to work with the sub-domains.
thanks.

pablo

03-26-2004 02:12 PM

why not use the RSS feeds for this ?

is this capable of giving the last replies that people have replied to, almost like a last 10 active topics.

pablo

03-28-2004 02:08 PM

*bump*
anyone ? :confused:

Dok[AB]

04-01-2004 06:28 AM

]

Quote:

Originally Posted by Ian Cunningham

How could I make this check multiple forums? I changed $forum_id =(x,y), but that doesnt work :(

:cry: :cry:

sammyman

04-02-2004 05:36 AM

I am with Buddha. I am trying everything but it doesn't like me much. Where do I install this file, and what do I do for the include.

Any help for a beginer?

sammyman

04-02-2004 06:13 AM

I realized that the file lastposts3.php works, but it is not importing correctly into the non-VB page. I guess the import file is not right.

sammyman

04-02-2004 06:17 AM

Ok- I am an idiot. Don't answer my questions. I forgot the "s" in "lastposts". IDIOT.

Oblivion Knight

04-03-2004 08:08 AM

Here's an addon to exclude forums that I've quickly thrown together.. :)

Find:

Code:

$limit = "10"; // Number of posts displayed.

Add below:

Code:

$excludeforums = ""; // The forums you want to exclude from being displayed, put their ID here.

Find:

Code:

if ($limit) {

        $limited = "LIMIT $limit";

}

Add below:

Code:

if ($excludeforums == "" or $excludeforums <= "0") {

        $quarter = "no";

} else {

        $excfid = explode(",",$excludeforums); $i = 0; $a = count($excfid);

        while ($i < $a) {

                $wheresql .= " AND thread.forumid!='$excfid[$i]'";        ++$i;

        }

}

Find:

Code:

SELECT threadid,title,lastpost,lastposter

Add on the same line:

Code:

,forumid

Find:

Code:

WHERE visible=1

Add on the same line:

Code:

$wheresql

All done.. :)

sabret00the

04-03-2004 02:18 PM

nice add-on, when i get round to installing this i'll try and write a truncating threadname add-on

krohnathlonman

04-09-2004 08:44 PM

Anybody using this on a higher traffic site? I'll do about 50k pageviews today... I'm using turk mmcache and the load didn't seem to jump very much, but it was noticeable.

TYorke

04-14-2004 12:35 AM

Alternating Row Colours

I added "outside" of the WHILE loop:

$color1 = "#DEDFDF";
$color2 = "#F7F7F7";
$rowcolorcount = 0;

"Inside" of the WHILE loop:

$rowcolor = ($rowcolorcount % 2) ? $color1 : $color2;

-- "Before" the final '}' at the end of the WHILE loop:

$rowcolorcount++;

add <tr bgcolor=\"$rowcolor\"> where you want your rows to change colours

Add Thread Replies and Views

Replace the entire line that starts with $thread_sql with:

Code:

$thread_sql = mysql_query("SELECT threadid,title,lastpost,lastposter,replycount,views FROM thread WHERE visible=1 AND open=1 $forumid ORDER BY lastpost DESC $limited");

Find:

$tid = $thread_get['threadid'];

Add underneath:

$view = $thread_get['views'];
$reply = $thread_get['replycount'];

Use something like <br />Replies: $reply | Views: $view where you want the counts to display

For an example check out http://www.cchl.ca/web/scripts/last.php

nektar

04-18-2004 10:23 AM

Hi!

If I could include the forum name of the post in the output this would be what I was looking for :squareeyed:

Any ideas?

nektar

04-22-2004 07:33 AM

Hi!

Thank you for the hack!

However, I would like to see a more advanced Top X posts on my homepage like I do now whith phpbb2.

What I would like to see is the forum name of each post + an icon next to each post showing if the post has been read or not by the visitor.

I know this is available for phpbb2 because I'm using it. Now I want to move to vbulletin but my visitors have used to see the last posts (and if they have read them or not) on my homepage.

Is this possible?

I think this would make the hack perfect.

Thanks.

fabz	04-26-2004 03:34 AM

Hello and thank you for this,

is there a way to get this script show post contents (like Pluhnews do for vb2) instead of only titles and posters ?

Detomah

05-06-2004 12:06 PM

I've been trying to achieve this for a while now, with certain, but limited, success. This has just made my life so much easier, saving me quite a bit of work. Thanks :)

fabz	05-06-2004 05:49 PM

I got Pluhnews working for my vb 3.0.1 and this works too.

sbryan

05-13-2004 09:59 AM

hmmmm ive got mine configured properly but the links never work, it always says that theyre wrong :(

fabz	05-13-2004 03:59 PM

Yes, you have to modify your pluhnews php files and replace all the lines containing links.

For example, a link to a thread in vb 2 was :
http://path_to_your_forum/showthread.php?s=Array[sessionhash]&threadid=xxxx

In vb 3, links to threads are now like this
http://path_to_your_forum/showthread.php?t=xxxx

So just search for lines containing "threadid=", remove "s=....." and change "threadid=" to "t="

It's simple, but if you don't succeed in it, I can send you my files.

northernstar

05-13-2004 08:27 PM

great hack!
Just wondering though if there's any way to not show topic titles from forums the user is not allowed to see?

boatdesign

05-13-2004 08:39 PM

Great mod - but one big problem.

It is showing links to threads that have been soft deleted by a moderator, so when a non-admin clicks them they get "invalid thread specified" since it's been soft deleted.

Is there a way to make this mod not display the thread title if the thread has been soft deleted by a moderator?

Synicide

05-13-2004 08:44 PM

Here's a question that's probably off topic a little bit, how would one go about and show the contents of the first post? Like say if I had event threads and the first post of those threads were summaries, could I have those summaries on that page?

freakify

05-26-2004 06:22 AM

I keep getting this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in "path" on line 57

Almost forgot, my line 57 is:
while($thread_get=mysql_fetch_array($thread_sql))

any suggestions?

thanks

007	06-05-2004 11:01 PM

/me clicks install!

Works like a charm!

One thing I would like to see, is if the title gets cut off due to the character limit, it should add "..." at the end of the title like VB does on the forumhome.

sbryan

06-07-2004 01:49 PM

Quote:

Originally Posted by freakify

im getting a similar message as well...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xboxworld/public_html/lastposts3.php on line 48

does anyone know what causes this?

All times are GMT. The time now is 04:50 PM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01288 seconds Memory Usage 1,820KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: