Tutorial:Transferring bans from WC3-Banlist

From Eurobattle.net WiKi
Revision as of 23:49, 21 December 2011 by 127.0.0.1 (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

[COLOR="Green"][B][SIZE=+1]Automatic Method - Using GhostOne[/COLOR][/B][/SIZE] [SPOILER]Instead of using Ghost++, use GhostOne, the modified version of Ghost++ and use it's configuration to transfer the bans. GhostOne can be found [B][URL="http://www.eurobattle.net/showthread.php?p=908530"]here[/URL][/B] [B]First[/B], go to WC3Banlist and export the bans. [url]http://img183.imageshack.us/my.php?image=99013336jd3.jpg[/url] [B]Second[/B], go to GhostOne Database [url]http://img390.imageshack.us/my.php?image=69925845vy3.jpg[/url] [B]Third[/B], open the database [url]http://img216.imageshack.us/my.php?image=61561404op6.jpg[/url] [B]Forth[/B], Import exported bans [url]http://img216.imageshack.us/my.php?image=25698648gf4.jpg[/url] [B]Fifth[/B], specify the server, and path to file, then click on [I]Import Bans from XML[/I], then click on [I]Add imported bans to ghost.dbs[/I] [url]http://img183.imageshack.us/my.php?image=80366044ew9.jpg[/url] [B]Finally[/B], close the database ... and you're done ! [url]http://img216.imageshack.us/my.php?image=53438020nw0.jpg[/url][/SPOILER]

[COLOR="Green"][B][SIZE=+1]Manual Method[/COLOR][/B][/SIZE] [SPOILER] Export your bans and name the file [B]localdb.xml[/B] Make sure it has the following structure: [QUOTE]<?xml version="1.0" encoding="UTF-8"?> <database version="1.0">

<banlist>

.... </banlist> </database>[/QUOTE] If not edit it and fix the structure.

you can use [url]http://snosnhoj.info/ghost/[/url]

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 [URL="http://sqlite.org/download.html"]sqlite command line [/URL](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 [QUOTE] ghost.dbs ".read ghost.sql"[/QUOTE] 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

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

2 selecting the ghost database in the list go to file -> open and select the file created from the website

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