vb.org Archive - cleaning up the hacks

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - cleaning up the hacks (https://vborg.vbsupport.ru/showthread.php?t=56711)

Azhrialilu

09-02-2003 04:00 PM

cleaning up the hacks

I've just been looking at my oh-so-messy forum and want to wipe off all the hacks except for vbportal, which I want to keep running.

I'll be reinstalling the hacks, so I'm not too concerned about removing the extra tables from the db, it's just that during my first "play" with the vbulletin forums I messed the hacks up a few times and, although the board works fine, the admin cp is messier than it really needs to be now LOL

So what I need you much-cleverer people than me to tell me is that I can just overwrite the hacked php files with the clean ones LOL ...... at least that's what I hope you're gonna tell me, and not say I need to reinstall.. cos that would just be tiresome ;) I'd really like to be able to do this without closing the site down for ages!

Am I making sense? I know what I mean but I have a tendency to confuse everyone else LOL

Thanx anyway, guys :)

Xenon

09-02-2003 06:10 PM

Yes, normally you can just overwrite your hacked files with fresh ones and everything should work :)

Azhrialilu

09-02-2003 07:58 PM

great, thanx :)

Okay, I know I'm probably being really annoying now... but what if I decided I needed to clean up the database? LOL ..... I'm getting an error 1136 when I try to add a new user group... apart from that it's not causing any problems, apart from irritating me *grin*

SmEdD

09-02-2003 08:20 PM

Go though all you hack instructions and reverse the queries :)

And this I just though of and probley won't work but make 2.3.2 think it is 2.3.0 and upgrade again.

But for ether way definatly BACKUP YOUR DATABASE!!! Expscially for the second way, that probley won't work.

But for the phpmyadmin the added stuff is always the last column(s) in the table.

Azhrialilu

09-02-2003 08:22 PM

now I'm gonna look really thick.. how do I manually reverse queries, is it thru the mysql section on my host?.. I know nothing about databases LOL... the hack I'm having problems with is the warning hack ... it gives an uninstall option, which I tried... but the error keeps on coming LOL

SmEdD

09-02-2003 08:34 PM

Na man it's no problem, we all were at some point a n00b ;)

If:

Code:

ALTER TABLE table_name 

ADD column_name datatype

Reverse:

Code:

ALTER TABLE table_name 

DROP COLUMN column_name

If:

Code:

CREATE TABLE table_name

Reverse:

Code:

DELETE TABLE table_name

If:

Code:

INSERT INTO table_name

VALUES (some_value)

Reverse:

Code:

DELETE FROM table_name

WHERE column_name = some_value

Azhrialilu

09-02-2003 08:41 PM

Thanx for that :) I'll give it a go..... expect a howl from somewhere near Heathrow Airport in about 20 minutes when I screw the whole thing up *grin*

All times are GMT. The time now is 10:04 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00974 seconds Memory Usage 1,722KB 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 (6)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: