cleaning up the hacks

[Azhrialilu]

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]

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

[Azhrialilu]

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]

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]

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]

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

If:ALTER TABLE table_name
ADD column_name datatype
Reverse:ALTER TABLE table_name
DROP COLUMN column_name

If:CREATE TABLE table_name
Reverse:DELETE TABLE table_name

If:INSERT INTO table_name
VALUES (some_value)
Reverse:DELETE FROM table_name
WHERE column_name = some_value

[Azhrialilu]

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*