Tulosta sivu - Ban List table export

Otsikko: Ban List table export
Kirjoitti: furnitureman - marraskuu 12, 2010, 05:40:50 AP

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

Otsikko: Re: Ban List table export
Kirjoitti: Aleksi "Lex" Kilpinen - marraskuu 12, 2010, 05:44:24 AP

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 :)

Otsikko: Re: Ban List table export
Kirjoitti: robi2106 - kesäkuu 27, 2011, 05:39:10 IP

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

Otsikko: Re: Ban List table export
Kirjoitti: Aleksi "Lex" Kilpinen - kesäkuu 27, 2011, 11:50:44 IP

Actually, if you happen to have Excel on your computer, it should be a fairly easy copy/paste to do. ;)

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: furnitureman - marraskuu 12, 2010, 05:40:50 AP