Uutiset:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu
Advertisement:

Ban List table export

Aloittaja furnitureman, marraskuu 12, 2010, 05:40:50 AP

« edellinen - seuraava »

furnitureman

Could anyone tell me the name of the MySQL database table for "Ban List->Ban Log>IP". I'm running 1.1.12
I wish to export it to a (huge) csv file and prune it to see any banned "repeat offender's"  IP's who are spamming my forum. There are 800+ pages of banned ip addresses. Thanks

Aleksi "Lex" Kilpinen

I believe all ban related details are kept in
smf_ban_groups and smf_ban_items :)

EDIT: No wait - that's 2.0 - I'll check 1.1 in a minute :P

EDIT2: Alright, seems it is the same in 1.1 :)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

robi2106

I'd love to export these from the web interface (since it already has them formatted and collected by IP trigger).

Are there any plans to allow exporting from the admin interface of any of the "big list of things" type displays (member list, Ban list, ban logs, etc).

Aleksi "Lex" Kilpinen

Actually, if you happen to have Excel on your computer, it should be a fairly easy copy/paste to do. ;)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Advertisement: