Close threads after X replies

This hack allow the administrator to set, in a forum, a limit of replies. So, with this hack, you can control easily the maximum number of replies in forums you want.

This hack can be usefull for example, if you have a 'Bug forum' and you don't want other members to reply, just you, and the thread to be close after.



Ce hack permet a l'administrateur du forum d'ajouter dans son panneau de controle admin d'ajouter des forums ou il peut controler le nombre de reponses avant la fermeture des posts dans ce forum.

Ce hack est en fait une evolution d'un hack que j'avais deja fait pour VB2 mais qui fermait les posts automatiquement apres 1 reponse.


Installation time : 4min
Templates to add : 0
Templates to modify : 0
Files to upload : 3
Files to modify : 2
Phrases to add : 5
Query to run : 2


:devious:


[HIGH]This hack has been released by VBulletinDev's team : http://www.vbulletindev.net

Ce hack a ete realis? par la team de VBulletinDev et est telechargeable en FR sur http://www.vbulletindev.net[/HIGH]

[koon]

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT fermeture FROM forum WHERE forumid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

Script: profile.php?do=editsignature

My users are getting this error when trying to edit there profile signature from the User CP. I tested it and get the same error, everything else works fine in the UserCP except the "Edit Signatures" link which gives the above error.

[koon]

Hi, can you make it so that when the threads are closed, they are moved to a specified forum?

As in this example: if forumid=1 or forumid=2 and its closed then move to forumid=3

This would be a great since it lessens the burden on having to manually move closed threads ourselves.

[Killahbyte]

installl worked perfect thanks alot!!!

KB

[Tombstone]

Invalid SQL: SELECT fermeture FROM vb_forum WHERE forumid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Get this when I try and send a PM

[cinq]

Have the problems been resolved on this great idea ?
I checked your support forum but it seems no solutions were given too.
Do keep us in the loop vbdev

[sjaakie]

Originally Posted by Tombstone

Invalid SQL: SELECT fermeture FROM vb_forum WHERE forumid =
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Get this when I try and send a PM

I have this problem after upgrading to 3.0.6. Reinstalled hack and then problems with sending pm's and opening topics in certain forums.

[GeoffE]

Same thing when I upgraded to 3.6 .. anyone got any ideas?

[PET]

it don't works anymore on 3.0.7

[~rc~]

In the file includes/functions_newpost.php

replace :

PHP Code:

//Fermeture apres X posts Grog6 VBulletinDEV 
           $fermeture = $DB_site->query_first("SELECT fermeture FROM forum WHERE forumid = $foruminfo[forumid]"); 

           if ($fermeture[fermeture] != "x") { 
           $reponses = $DB_site->query_first("SELECT replycount FROM thread WHERE threadid = $threadinfo[threadid]"); 

           if ($fermeture['fermeture'] <= ($reponses['replycount'])) 
            $DB_site->query("UPDATE thread SET open= '0' WHERE threadid = '$threadinfo[threadid]'"); 
           } 


PHP Code:

//Fermeture apres X posts Grog6 VBulletinDEV 
    $fermeture = $DB_site->query_first("SELECT fermeture FROM " . TABLE_PREFIX . "forum WHERE forumid = $foruminfo[forumid]"); 

    if ($fermeture[fermeture] != "x" and $threadinfo[threadid] != '') { 
    $reponses = $DB_site->query_first("SELECT replycount FROM " . TABLE_PREFIX . "thread WHERE threadid = $threadinfo[threadid]"); 

    if ($fermeture['fermeture'] <= ($reponses['replycount'])) 
    $DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET open= '0' WHERE threadid = '$threadinfo[threadid]'"); 
    } 


or Newthread will not work for any forums with set limit on replies

[dimdan]

Fatal error: Call to a member function on a non-object in /home/virtuald/public_html/new/forum/includes/functions_newpost.php on line 705

Got This Error