Removing ban

[rogersnm]

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

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

[oninuva]

me too same prob!

[Paul M]

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

[rogersnm]

The hacker issued a ip ban on all ip's

http://wow-elite.org/

[oninuva]

Help!

[rogersnm]

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

[Paul M]

ooops.

Do you have ftp access ?

[rogersnm]

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

[akanevsky]

There isn't one SQL query that could remove all bans. How are you actually 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...

[Paul M]

Via ftp, edit global.php ;

Find these lines;

// check for IP ban on user
verify_ip_ban();
and comment out the second line like this ;

// check for IP ban on user
//verify_ip_ban();

You should then have access.

[oninuva]

i cant even get into ADmin CP

[rogersnm]

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...

[akanevsky]

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

[Paul M]

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

[akanevsky]

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.

[rogersnm]

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

it blocks everything..

they have also deleted ALL forums

[oninuva]

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

/yelp

any way to fix?

[Paul M]

Yes, restore from a backup.

[rogersnm]

he didn't make one :p

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

[akanevsky]

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

[oninuva]

o im screwed

[Paul M]

o im screwedIf 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).

[rogersnm]

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..

[Paul M]

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

[rogersnm]

ok how?

how do i remove an ip ban?

[oninuva]

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


how do i fix?

change it maunally?

[rogersnm]

Would You Mind!

[Wired1]

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.

[oninuva]

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

[Paul M]

update user set usergroupid = 2 where userid not in (x,y)

where x,y are your administrator userids.

[oninuva]

gah im re-installing

this sucks

all my templates are messed up too :(