vb.org Archive - Last Active Thread for 2.01

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Last Active Thread for 2.01 (https://vborg.vbsupport.ru/showthread.php?t=19446)

fastforward

06-05-2001 10:00 PM

This is for vB 2.01

This is new thread as there seems to be a problem with editing attachments on old posts.

This little hack allows the display of the last active thread on the forums pages. This is the 'UBB like' feature. You can see an example at http://dbforums.com.

NOTES
It requires two extra column to be added in the forum table a few code additions and then the thread title and iconid can be referenced using the variables $forum[lastactivethread] and icon$forum[lastactiveiconid].gif. Instructions are in the attachment.

This was originally part of my usenet hack and due to popular request ( all two of them :D ) I'm releasing it seperately.

furious

06-06-2001 09:08 AM

nice hack
but may we have one which works with vb 2.0.0?

h4p3	06-06-2001 10:18 AM

I think it works with vb 2.0.0, try it ;)

Nicholas Brown

06-06-2001 12:43 PM

Quote:

Originally posted by furious
nice hack
but may we have one which works with vb 2.0.0?

Just download 2.0.1 from the members area

nuno	06-06-2001 03:47 PM

nuno waves at fastfoward :D
tx;)

h4p3	06-06-2001 04:16 PM

fastforward:

It still doesn't do what it should, because it isn't very usefull if you move a topic into another forum then the title of the moved topic isn't showing up in the new forum if you refresh. The old Topic in the forum where it shouldn't be is still showing up but links to the next Topic after the one which was moved. I hope u know what i mean :)

The same thing if you delete a topic. What did you change?

Tolitz

06-06-2001 04:35 PM

But isn't active topics considered to be topics that have recently been posted or replied to? Moving a thread to another forum doesn't necessarily signify that the thread is "active" unless someone replies to it. So IMHO the script is doing what it is supposed to do, which is pull "active" topics...

Then again, I may be wrong ;p

h4p3	06-06-2001 04:38 PM

Nope, if you delete a thread then the titel of the deleted thread is still showing up and links to the next thread. Try it out, it is confusing for users.

fastforward

06-06-2001 05:58 PM

Quote:

Originally posted by h4p3
fastforward:

It still doesn't do what it should, because it isn't very usefull if you move a topic into another forum then the title of the moved topic isn't showing up in the new forum if you refresh. The old Topic in the forum where it shouldn't be is still showing up but links to the next Topic after the one which was moved. I hope u know what i mean :)

The same thing if you delete a topic. What did you change?

As I said before. The hack will re-calculate the latest active thread only when the thread is re-indexed. I'm not going to over-complicate this by taking into account every rare possibility. The same goes for editing the thread title. If vB doesn't re-index, then the active thread will not change; simple as that.

The change with this version is the displaying of icons.

h4p3	06-06-2001 06:08 PM

Ah ok, thx for the info!

NanoEntity

06-08-2001 03:54 PM

Where do I ADD THIS, I dont get the instructions, help!!!

a) admin/functions.php

OLD_CODE
--------
No old code to replace. ADD the new code just before the closing brace of the indexpost() function.

NEW CODE
--------
// START LAST ACTIVE THREAD HACK
update_last_active_thread(0,$post[threadid],0);
// END LAST ACTIVE THREAD HACK

PHP Code:


		
			
// ###################### Start indexpost #######################

function indexpost($postid,$firstpost=-1) {



  global $DB_site,$bbadminon,$minsearchlength,$maxsearchlength;

  global $firstpst,$badwords,$incp;



  if (!is_array($badwords)) {

    if ($incp) {

      include("./badwords.php");

    } else {

      include("./admin/badwords.php");

    }

  }

nuno	06-08-2001 04:24 PM

PHP Code:


		
			
// ###################### Start indexpost #######################

function indexpost($postid,$firstpost=-1) {



  global $DB_site,$bbadminon,$minsearchlength,$maxsearchlength;

  global $firstpst,$badwords,$incp;



  if (!is_array($badwords)) {

    if ($incp) {

      include("./badwords.php");

    } else {

      include("./admin/badwords.php");

    }

// START LAST ACTIVE THREAD HACK 

update_last_active_thread(0,$post[threadid],0); 

// END LAST ACTIVE THREAD HACK 

  }

Raptor

06-29-2001 11:57 PM

oops

Raptor

06-29-2001 11:58 PM

I am seeing a bug. It is consistantly displaying the title of the post one post BEFORE the last post. It worked the first time through, meaning that the first post registered correctly. Now, it is consistantly one behind.

It seems to work perfect when I make a new thread/reply but if left for a while it constantly stays one post behind

whats also weird is that some forums are correct and some are one behind - very VERY strange

check it out and you will see what I mean

I REALLY loved this feature when used to use UBB so was very happy when you rls'd this

any help would be much appreciated (perhaps table indexes are wrong? or the function.php is slightly wrong?)

also how to increase the table width for Last post - i'd like to widen it a bit but i'm totally missing where I should implement the change (doh!)

thanks FF !

http://digital-forums.com/forum/

eurosale

07-21-2001 08:30 PM

I had the same problem. Under certain circumstances vB is not reindexing when replying to a message. This additionl index-call should solve the problem:

Just replace in newreply.php :

PHP Code:


		
			
indexpost($postid,0);



if ($visible) {

        if ($threadinfo[replycount]%10==0) {

          $replies=$DB_site->query_first("SELECT COUNT(*)-1 AS replies FROM post WHERE threadid='$threadid'");

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount='$replies[replies]',lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");

        } else {

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount=replycount+1,lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");

        }

}

by:

PHP Code:


		
			
indexpost($postid,0);



if ($visible) {

        if ($threadinfo[replycount]%10==0) {

          $replies=$DB_site->query_first("SELECT COUNT(*)-1 AS replies FROM post WHERE threadid='$threadid'");

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount='$replies[replies]',lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");

        } else {

          $DB_site->query("UPDATE thread SET lastpost='".time()."',replycount=replycount+1,lastposter='".addslashes($postusername)."' WHERE threadid='$threadid'");

        }

      indexpost($postid,0);

}

I hope that helps!

ztsky

07-21-2001 10:44 PM

See mine
there's a demo:
http://tsing.com/vb/

I think it's not need to change any table,I get last activetiltle and its icon in edit index.php.

eurosale

07-21-2001 11:08 PM

So please ztsky,

if there are better solutuions, please let us know how! :eek:

ztsky

07-21-2001 11:19 PM

Quote:

Originally posted by eurosale
So please ztsky,

if there are better solutuions, please let us know how! :eek:

eurosale:
Sorry ,i still have a problem to solve.
I have three sub forums in a main forum.
in my hacked board, the main forumhome lastposttitle always show the main forum's,but the sub forums have newest thread!:rolleyes:

TDawson

07-22-2001 01:27 AM

Quote:

Originally posted by ztsky

eurosale:
Sorry ,i still have a problem to solve.
I have three sub forums in a main forum.
in my hacked board, the main forumhome lastposttitle always show the main forum's,but the sub forums have newest thread!:rolleyes:

I have the same problem.

I found this out AFTER i installed this hack

ztsky

07-22-2001 01:37 AM

Quote:

Originally posted by TDawson

I have the same problem.

I found this out AFTER i installed this hack

I didn't use this hack,I write a hack of mine,the effection is same but it's more simple and not need to edit table,but my problem is above i said.

TDawson

07-22-2001 09:42 PM

Don't matter, this hack has too many problems:
1) Doesn't show last post of subforums
2) Is always 1 thread behind.

I'm sure there are more, but i took it off before i could find out...

Reef Board

07-30-2001 01:31 AM

I need some help. I tried installing this hack, ran the queries etc.. and it only displays the icon on the main page.

Even when someone posts a new topic with a different icon the icon on the main page remains the same?

http://www.reefboard.com/cgi-bin/forum

Phil~

All times are GMT. The time now is 02:45 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01262 seconds Memory Usage 1,784KB 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 (4)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (22)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: