How do I close my board from phpMyadmin

[Remi]

Hi every body:

I tried to use this query to close my forum from phpMyadmin but it did not work I dont know whay!!

UPDATE setting SET value='0' WHERE settingid='1';

can correct me please

also, can you kindly show me how to delet a post or a thread by ID from phpMyadmin

Thank you very much in advance

[ManagerJosh]

Erm, why not just do all that through the vBulletin administration?

[Remi]

that is not the point ManagerJosh

I have a very valid reason for that

[NTLDR]

Switch Board Off:

[sql]UPDATE setting SET value='0' WHERE varname='bbactive';[/sql]

Delete Post:

[sql]DELETE FROM post WHERE postid='POSTIDHERE';[/sql]

Delete Thread:

[sql]DELETE FROM thread WHERE threadid='THREADIDHERE';[/sql]
[sql]DELETE FROM post WHERE threadid='THREADIDHERE';[/sql]

Remember to replace POSTIDHERE & THREADIDHERE with the correct thread/post id.

[g-force2k2]

Remi try this query:

PHP Code:

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


regards... i never use phpmyadmin i just use the query runner (by Firefly)

g-force2k2

[Remi]

Thank you Thank you Thank you Thank you Veeeeeeeeeeeeeery much, you are great.

All of them are working accept this:


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

It changes the value from 1 to 0 but the forum is still open!!

Any idia what is the problebm!!

[NTLDR]

After taking a look I remembed that vB requires you to Submit the options after they have been changed, so a query similar to the following is needed, however it will not work, so don't run it on a live board:

[sql]UPDATE template SET template='bbactive' WHERE title='options'[/sql]

This is taken from options.php

[Remi]

OK

Thank you very much NTLDR , now every thing makes sence

[FASherman]

Originally posted by NTLDR
Switch Board Off:

Delete Post:

[sql]DELETE FROM post WHERE postid='POSTIDHERE';[/sql]

Delete Thread:

[sql]DELETE FROM thread WHERE threadid='THREADIDHERE';[/sql]
[sql]DELETE FROM post WHERE threadid='THREADIDHERE';[/sql]

Remember to replace POSTIDHERE & THREADIDHERE with the correct thread/post id.

You do realize these instructions won't fully delete a post or a thread, right?

The correct way to do this:

To delete a thread, you have to delete the thread, any associated posts and any attachements associated with those posts, any polls associated with those threads and the poll answers associated with those threads and finally, any thread ratings for the thread.

You've left way too much out.

[NTLDR]

Originally posted by FASherman
You've left way too much out.

I answered the question that was asked, all the other stuff is "optional" based on whether or not they are included in the thread, which wasn't specified. The correct way actually to do it is from the ACP, that way its done in a minimal amount of time and nothing will ever be left out.