Difference between revisions of "Tutorial:Transferring bans from WC3-Banlist"

From Eurobattle.net WiKi
Jump to navigation Jump to search
 
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
[COLOR="Green"][B][SIZE=+1]Automatic Method - Using GhostOne[/COLOR][/B][/SIZE]
+
'''<h1><font color="green">Automatic Method - Using GhostOne</font></h1>'''
−
[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.
+
Instead of using Ghost++, use GhostOne, the modified version of Ghost++ and use it's configuration to transfer 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]
+
GhostOne can be found '''http://www.codelain.com/forum/index.php?topic=11643.0'''
−
[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]
+
<br>'''First''', go to WC3Banlist and export the bans.
−
[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 !
+
http://img183.imageshack.us/my.php?image=99013336jd3.jpg
−
[url]http://img216.imageshack.us/my.php?image=53438020nw0.jpg[/url][/SPOILER]
+
 
 +
 
 +
<br>'''Second''' , go to GhostOne Database
 +
 
 +
 
 +
http://img390.imageshack.us/my.php?image=69925845vy3.jpg
 +
 
 +
 
 +
<br>'''Third''' , open the database
 +
 
 +
 
 +
http://img216.imageshack.us/my.php?image=61561404op6.jpg
 +
 
 +
 
 +
<br>'''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
 +
 
 +
 
 +
'''<h1><font color="green">Manual Method</font></h1>'''
 +
 
 +
 
 +
Export your bans and name the file '''localdb.xml'''
 +
 
  
−
[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:
 
Make sure it has the following structure:
−
[QUOTE]<?xml version="1.0" encoding="UTF-8"?>
+
 
−
<database version="1.0">
+
<BR><?xml version="1.0" encoding="UTF-8"?>
−
<banlist>
+
<BR><database version="1.0">
 +
<banlist>
 
....
 
....
 
</banlist>
 
</banlist>
−
</database>[/QUOTE]
+
</database>
 +
 
 +
 
 +
 
 
If not edit it and fix the structure.
 
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
+
 
 +
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
 
which will update it with records from your banlist
 
you can import it using sqlite analyzer or any other sqlite dbms
 
you can import it using sqlite analyzer or any other sqlite dbms
−
using [URL="http://sqlite.org/download.html"]sqlite command line [/URL](Windows)
+
using http://sqlite.org/download.htmlsqlite command line (Windows)
 +
 
 +
 
 +
<br>1. Extract to your ghost folder (the location of ghost.dbs)
 +
<br>2. Create a shorcut to the extracted sqlite3
 +
<br>3. Right-click the shortcut, in target add to the end
 +
<br><pre> ghost.dbs ".read ghost.sql"</pre>
 +
<br>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.
 +
 
 +
 
 +
<br>a). In sqlite analyzer create a new database registration  file -> New Database Registration, put the full location of ghost.dbs in database path
  
−
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
+
<br>b). Selecting the ghost database in the list go to file -> open and select the file created from the website
  
−
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
+
<br>c).Click on the <font color="green">Green</font> play button in the toolbar then wait patiently until that turns green again then your done.
  
−
[[Category:Eurobattle Wiki]]
+
{{IncCat|Page=Tutorial:Transferring bans from WC3-Banlist|Category=Tutorials}}
 +
{{IncCat|Page=Tutorial:Transferring bans from WC3-Banlist|Category=Ghost}}

Latest revision as of 16:53, 24 January 2012

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.

Retrieved from "http://wiki.eurobattle.net/index.php?title=Tutorial:Transferring_bans_from_WC3-Banlist&oldid=372"