The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Undo Queries
i would like to undo querys. how whould i do that ?
|
#2
|
|||
|
|||
You can't unless you know what the queries did, or unless you have a database backup.
|
#3
|
||||
|
||||
i have the queries i added. thnx for helping hopfully i can undo these
+-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ INSERT INTO settinggroup VALUES (302,'[HL]Signature Settings',302); +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ INSERT INTO setting VALUES (320,302,'Maximum signature lines?', 'maxsiglines', '5', 'Maximum number of *line breaks* allowed in signatures. Set this to 0 to have no effect.', '', '1'); +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ INSERT INTO setting VALUES (221,302,'Maximum images per signature?', 'maxsigimages','5' , 'Maximum number of *images* to allow in signatures. Set this to 0 to have no effect.','', '2'); +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ INSERT INTO setting VALUES (322,302,'Maximum image width?', 'maxsigwidth','450','Maximum *width* allowed for images in signatures. Set this to 0 to have no effect.', '', '3'); +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ INSERT INTO setting VALUES (323,302,'Maximum image height?', 'maxsigheight','125','Maximum *height* allowed for images in signatures. Set this to 0 to have no effect.', '', '4'); +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ UPDATE setting SET title='Maximum images per post?' WHERE settingid='18'; +-------------------------------------------------------------------------------------------------+ +-------------------------------------------------------------------------------------------------+ | Run this query: | +-------------------------------------------------------------------------------------------------+ UPDATE setting SET description='Maximum number of images to allow in posts. Set this to 0 to have no effect.' WHERE settingid='18'; |
#4
|
|||
|
|||
There's no really easy way to do it, especially because the queries are so badly coded that there are no specific columns referenced.
|
#5
|
||||
|
||||
any suggestions though ?
edit all of those queries add things to the vBulletin Options page in the admincp |
#6
|
|||
|
|||
Try:
[sql] DELETE FROM settinggroup WHERE settinggroupid = 302; DELETE FROM setting WHERE settinggroupid = 302; [/sql] My god, that's really bad now that I look upon it (not relying on the auto_increment in that type of column)... |
#7
|
||||
|
||||
im scared now lol.
|
#8
|
|||
|
|||
Just back up your database first and nothing can go wrong.
"What could possibly go wrong?" |
#9
|
||||
|
||||
Better yet, run admin/setting.php and just find the extra settings and delete them manually.
|
#10
|
||||
|
||||
Quote:
Omg.... I never knew that. Lol thanks. edit BTW its setting not settings |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|