Announcement

Collapse
No announcement yet.

[RELEASE] Last Active Thread for 2.01

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [RELEASE] Last Active Thread for 2.01

    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 ) I'm releasing it seperately.
    http://britishexpats.com/ - British expatriate community

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

    Comment


    • #3
      I think it works with vb 2.0.0, try it

      Comment


      • #4
        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

        Comment


        • #5
          nuno waves at fastfoward
          tx
          You're my Prince of Peace
          And I will live my life for You

          Comment


          • #6
            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?

            Comment


            • #7
              Hmm, correct me if I'm wrong...

              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
              OPEN TECH SUPPORT
              "Tech is our middle name!"

              Comment


              • #8
                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.

                Comment


                • #9
                  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.
                  http://britishexpats.com/ - British expatriate community

                  Comment


                  • #10
                    Ah ok, thx for the info!

                    Comment


                    • #11
                      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");
                          }
                        } 

                      Comment


                      • #12
                        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 
                          

                        You're my Prince of Peace
                        And I will live my life for You

                        Comment


                        • #13
                          oops
                          Digital-Forums: www.digital-forums.com | CK3 Games: www.ck3.co.uk

                          Comment


                          • #14
                            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/
                            Last edited by Raptor; Fri 29 Jun '01, 5:01pm.
                            Digital-Forums: www.digital-forums.com | CK3 Games: www.ck3.co.uk

                            Comment


                            • #15
                              @raptor

                              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!

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X