vb.org Archive
Page 2 of 3 1 2 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)
-   -   Close threads after X replies (https://vborg.vbsupport.ru/showthread.php?t=60059)

PET 01-16-2004 10:54 PM
where where ?

VBDev 01-16-2004 10:56 PM
In the first post of the tread ;)

bolynn 01-17-2004 04:35 AM
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 01-17-2004 07:26 AM
This is fundamental ;)

bolynn 01-17-2004 05:18 PM
It may be but your command of the English language is not (no offence)

mili

poetic 03-16-2004 06:45 PM
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 03-21-2004 02:31 PM
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 03-24-2004 08:43 PM
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 03-30-2004 12:27 AM
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 03-30-2004 12:29 AM
P.S. I also want to make it clear that i have Forum Description installed (if it mathers).


All times are GMT. The time now is 08:00 AM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01161 seconds
  • Memory Usage 1,746KB
  • 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
  • (3)bbcode_php_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
  • (10)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