Removing ban
 

what sql query would i run to remove everyban set inclkuding ip bans?

my site has been hacked and i can't get in,

me too same prob!

There isn't one SQL query that could remove all bans. How are you actually banned ?

The hacker issued a ip ban on all ip's

http://wow-elite.org/

Help!

i have got the tools.php up so i can run query's but thats all..

ooops.

Do you have ftp access ?

yes, i do, but i can't run a vB page because i am banned...

Yeah there is. But what's required to know is:
Banned Usergroupid
Normal Usergroupid
Table Prefix
UPDATE TABLE_PREFIXuser SET usergroupid=NORMAL WHERE usergroupid=BANNED
UPDATE TABLE_PREFIXuser SET usergroupid=6 WHERE userid=YOURADMINID

As for ip ban, you just remove that from vb options.

Or if you cannot access your vb options, an option rebuild script would be required...

Via ftp, edit global.php ;

Find these lines;

and comment out the second line like this ;

You should then have access.

i cant even get into ADmin CP

ok
thanks

nope still got it:
http://www.wow-elite.org/
http://www.wow-elite.org/forum/

i think they have changed the whole template...

Interesting. My ip is banned too, although I haven't ever visited the site. lol.

Feel free to post this magic query that will remove all bans including IP bans, e-mail bans & usergroup bans.

Well, it isn't exactly one query, it's two queries given that admin is banned too - but see the post, I updated it.
I could combine the two queries into one, but it isn't worth it.

i am in the admin cp.. how do you remove the ip ban?

it blocks everything..

they have also deleted ALL forums

i got in the ACP but they delteed all my forums :(

/yelp

any way to fix?

Yes, restore from a backup.

he didn't make one :p

where's the ip ban so i can remove it?

And if there's not backup, you'll have to start anew.

o im screwed

If you didn't back anything up and the data has been deleted, then yes, you are pretty much screwed.

First rule - backup regularly. Second rule - refer to first rule.

(if your threads, posts and users are intact, a vb expert could rebuild your actual forums with some sql manipulation).

i'll see if his posts are intact

vb.com phone support is closed

nope he's screwed the thread and post tables have been dropped..

All you members are administrators atm, I suggest you fix that pretty quick.

ok how?

how do i remove an ip ban?

how do i fix?

change it maunally?

Would You Mind!

Check with your host to see how often they backup stuff. Also notify them of the hack, in case it's more widespread than just your site.

how do i mass change a user group? cause all my users are mods... and i want to change them back

[sql]update user set usergroupid = 2 where userid not in (x,y)[/sql]

where x,y are your administrator userids.

gah im re-installing

this sucks

all my templates are messed up too :(