Hi! I'm looking for a SQL to open all threads with zero replies. thanks!
SQL to open all threads with zero replies
Collapse
X
-
Tags: None
-
Run this on a test site first to be sure it works! And, always make a database backup before running any queries on a live site.
I believe your query would be:
Code:UPDATE thread SET open=1 WHERE replycount=0;
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css help👍 1 -
Run this on a test site first to be sure it works! And, always make a database backup before running any queries on a live site.
I believe your query would be:
Code:UPDATE thread SET open=1 WHERE replycount=0;
Comment
Related Topics
Collapse
-
I want that all Forummembers and Guests will see all Threads/Topics in the channels. Actual all see only threads/topics of the last 30days. I tried the SQL Query - but I received a error message: SQl...
-
Channel: Support Issues & Questions
Wed 15 Apr '15, 3:12am -
Comment