XF 1.5 Banned IP and emails did not import

[wardsweb]

Is there a way to retrieve banned IP's and banned email addresses from the database? These did not show up in the admin console after the change from vB3.8 to XenForo 1.5.

 

[Mike]

These are not covered by the import. Unfortunately, they would need to be brought over manually.

 

[wardsweb]

So if I phpAdmin into the database and export them. Do I need to type them in one at a time in XenForo?

 

[Paul B]

Yes, or write a script to populate the table.

 

[wardsweb]

What is the table name for banned IP's in XenForo?

 

[Mike]

xf_ip_match. I generally wouldn't recommend trying to change the database directly though. IPs likely aren't stored in the format you expect (plus caches, etc).

 

[wardsweb]

OK, I'm trying to avoid manually entering IP's one at a time that have been accumulated over the last 13 years. The same will be true of banned email addresses. With a forum as large as Audiokarma.org, we get hammered on a daily basis.

 

[Vincent Gabriel]

i just did this:

$model = XenForo_Model::create('XenForo_Model_Banning');
$ips = explode("\n", $ips);

foreach($ips as $ip) {
    try {
        $model->banIp($ip);
    } catch(Exception $e) {
        echo $ip . ':' . $e->getMessage() . "\n";
    }
}

is there a reason why IPs/emails are not imported? seems pretty easy to add.