[404UserNotFound]

So one of the fellows I host (ArchangelGabriel) is using the SUM admin plugin and is wanting to change over to SourceBans.

Thing is, he's got the .sq3 file that stores the bans, and it's got a few years worth of bans on it. I've tried before to import the .sq3 file into SourceBans and even into PHPMyAdmin (both didn't work), and I'm a tad confused about how to migrate all the bans within the .sq3 file over to a SourceBans install.

Best idea I have is to try to view the .sq3 file in a plaintext format so I can modify it and remove any non-permanent bans, leaving just the permabans intact, and then further modify the formatting so that SourceBans recognizes it and imports it.

Anyone have any ideas?

[DJ Tsunami]

You can use something like SQLite Database Browser to open the .sq3 file and see the data. You can also write a script to migrate it. For example in PHP you can use PDO:

PHP Code:

$db = new PDO('sqlite:sumdb.sq3');

foreach ($db->query('SELECT * FROM banlog') as $row) {
    // Insert into SourceBans database
} 


[404UserNotFound]

Originally Posted by DJ Tsunami You can use something like SQLite Database Browser to open the .sq3 file and see the data. You can also write a script to migrate it. For example in PHP you can use PDO: PHP Code: $db = new PDO('sqlite:sumdb.sq3'); foreach ($db->query('SELECT * FROM banlog') as $row) {     // Insert into SourceBans database }

i have no idea how to use that code, DJ Pie Safety

[DJ Tsunami]

Then I guess someone will have to write a script for you to migrate the bans.

[404UserNotFound]

Originally Posted by DJ Tsunami Then I guess someone will have to write a script for you to migrate the bans.

That makes sense