Tutorial:Transferring bans from WC3-Banlist

From Eurobattle.net WiKi
Jump to: navigation, search

Automatic Method - Using GhostOne


Instead of using Ghost++, use GhostOne, the modified version of Ghost++ and use it's configuration to transfer the bans.


GhostOne can be found http://www.codelain.com/forum/index.php?topic=11643.0



First, go to WC3Banlist and export the bans.


http://img183.imageshack.us/my.php?image=99013336jd3.jpg



Second , go to GhostOne Database


http://img390.imageshack.us/my.php?image=69925845vy3.jpg



Third , open the database


http://img216.imageshack.us/my.php?image=61561404op6.jpg



Forth , Import exported bans


http://img216.imageshack.us/my.php?image=25698648gf4.jpg


Fifth , specify the server, and path to file, then click on Import Bans from XML , then click on Add imported bans to ghost.dbs


http://img183.imageshack.us/my.php?image=80366044ew9.jpg


Finally , close the database ... and you're done !


http://img216.imageshack.us/my.php?image=53438020nw0.jpg


Manual Method


Export your bans and name the file localdb.xml


Make sure it has the following structure:


<?xml version="1.0" encoding="UTF-8"?>
<database version="1.0"> <banlist> .... </banlist> </database>


If not edit it and fix the structure.


Upload your localdb.xml from WC3banlist to generate a sql file ghost.sql then import that into your ghost.dbs which will update it with records from your banlist you can import it using sqlite analyzer or any other sqlite dbms using http://sqlite.org/download.htmlsqlite command line (Windows)



1. Extract to your ghost folder (the location of ghost.dbs)
2. Create a shorcut to the extracted sqlite3
3. Right-click the shortcut, in target add to the end


 ghost.dbs ".read ghost.sql"


4. Make sure the ghost.sql is in the ghost folder also, click the shortcut When the empty console box closes it is done if a console box appears and disappears quickly you might of made an error using sqlite analyzer.



a). In sqlite analyzer create a new database registration file -> New Database Registration, put the full location of ghost.dbs in database path



b). Selecting the ghost database in the list go to file -> open and select the file created from the website



c).Click on the Green play button in the toolbar then wait patiently until that turns green again then your done.