Run This Query To: version 3.0.x

[Jose Amaral Rego]

Run this query to enable Search Indexing in all forums

Run this query to enable Search Indexing in all forums:

UPDATE forum SET options=options + 16384 WHERE NOT(options & 16384)

[Jose Amaral Rego]

Run this query to set Forums Default View Age

Run this query to set Forums Default View Age:

Two methods shown below will do this job: One is manually and other is a query.

In the Forum Manager set the Default View Age to 'Show All Threads':

1. Admin CP -> Forums & Moderators -> Forum Manager -> Edit Forum -> Default View Age -> Show All Threads
   
   Or to update them all at once, run this query:
   
2. 
   

   UPDATE forum SET daysprune=[COLOR="Red"]X[/COLOR];

You can use the following values for Days Prune:

• Show threads from last day: 1
• Show threads from last 2 days: 2
• Show threads from last week: 7
• Show threads from last 10 days: 10
• Show threads from last 2 weeks: 14
• Show threads from last month: 30
• Show threads from last 45 days: 45
• Show threads from last 2 months: 60
• Show threads from last 75 days: 75
• Show threads from last 100 days: 100
• Show threads from last year: 365
• Show all threads: -1

Follow by Update Counter.
Admin CP -> Import & Maintenance -> Update Counters -> Rebuild Forum Information

[Jose Amaral Rego]

Future Post

Future Post

[Jose Amaral Rego]

Future Post

Future Post

[Jose Amaral Rego]

Future Post

Future Post

[Jose Amaral Rego]

Future Post

Future Post

[Jose Amaral Rego]

Run this query to replace known text with new text

Run this query to replace known text with new text:
Where X is known and XX results to new text.

UPDATE post SET pagetext = REPLACE(pagetext, '[COLOR="Red"]X[/COLOR]', '[COLOR="Blue"]XX[/COLOR]');

[Jose Amaral Rego]

Run this query to turn board off via phpMyAdmin database

Run this query to turn board off via phpMyAdmin database:

UPDATE datastore SET data=REPLACE(data,'"bbactive";s:1:"1"','"bbactive" ;s:1:"0"') WHERE title='options';

UPDATE setting SET value=0 WHERE varname='bbactive';

[Jose Amaral Rego]

Run this query to turn board on via phpMyAdmin database

Run this query to turn board on via phpMyAdmin database:

UPDATE datastore SET data=REPLACE(data,'"bbactive";s:1:"0"','"bbactive" ;s:1:"1"') WHERE title='options';

UPDATE setting SET value=1 WHERE varname='bbactive';

[Jose Amaral Rego]

Run this query to reset the cookie timeout

Run this query to reset the cookie timeout:

UPDATE `setting` SET `value` = '900' WHERE `varname` = 'cookietimeout' LIMIT 1 ;

[Jose Amaral Rego]

Run this query to reclaim userid

Run this query to reclaim userid:
Where X is your current userid.
Please read link first... http://www.vbulletin.com/forum/showp...31&postcount=2

UPDATE user
SET userid = 1
WHERE userid = [COLOR="red"]X[/COLOR]

[Jose Amaral Rego]

Run this query to reset the reputations

Run this query to reset the reputations:

DELETE FROM reputation;

UPDATE user SET reputation = 0, reputationlevelid = 0;

[Jose Amaral Rego]

Run this query to reinstate delete member and post:

Run this query to reinstate deleted member to own posts:

1. Setup a new account for this user. Record the new userid number.

2. Run this query to associate all previous posts to this account:

UPDATE post SET userid='[COLOR="Red"]xxx[/COLOR]' WHERE username='[COLOR="Blue"]old name[/COLOR]';

...with 'xxx' being the new userid number and 'old name' being the name of the use that was deleted.

3. Now update the user, thread and forum counters

[Jose Amaral Rego]

Run this query to reset all users birthday's

Run this query to reset all users birthday's:
(that's two single quotes with no space in between them)

UPDATE user SET birthday=[COLOR="Red"]''[/COLOR];

[Jose Amaral Rego]

Run this query to set all users reputation's

Run this query to set all users reputation's:

UPDATE user SET reputation ='[COLOR="Red"]10[/COLOR]';

Next

Admin CP -> Import & Maintenance -> Update Counters -> Rebuild User Reputation