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]

[PET]

where where ?

[VBDev]

In the first post of the tread

[bolynn]

Ok instructions are unclear. I figured that I needed to run two separate SQL Queries and then add the phrases but this "and add above" thing is utterly confusing. If you'd be kind enougt to let us know UNDER what lines should we paste the additional code instead of the Above thing we may even succeed. Also I assume the setting options for this hack should show up in the Admin control panel but exactly where?

Bo

[gmarik]

This is fundamental

[bolynn]

It may be but your command of the English language is not (no offence)

mili

[poetic]

I am getting a db error when doing things exactly as you stated.

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

in private.php (Pulling the newpost.php)

and

newthread.php

SELECT replycount FROM thread WHERE threadid =
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

[hawk]

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]'");
           } 


by

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") {
           $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]'");
           }
} 


[VBDev]

Our team has opened its support forum.

Now we will make support on our forum

So if you want better support on our hacks go on our forum: http://www.vbulletindev.net/

There are not a lot of hacks for the moment but it will come.

Cya soon on our forum

[PET]

In vBulletin RC2 or 4 (can't remember) the hack worked. Now, in vB3 FINAL i get this error :

PHP Code:

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT replycount FROM thread WHERE threadid = 
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064 


I have made the changes that Hawk post, now i get an error about a }. I remove the } and...the SQL problem appears again.

[PET]

P.S. I also want to make it clear that i have Forum Description installed (if it mathers).