I cant clean(erase) guilds from my DB.

[Zeruel_angel]

I'm using some DBs that came with 199 guilds on it, all with chinese names. and a lots of accounts too.
I managed to clean the DB by erasing the accounts and characters info and everithing runs smooth...

BUT

if I also erase the content of "guilds" table inside "GameDB" database, the "groupserver" exe dosn't work. It starts, say some garbage and stops...

Does anyone know a way to "clean" the database? or maybe someone has a "clean" database to share?

Thank you! See you later!

[MentaL]

[swordsman57140]

If you want delet Guild , Char , Account etc open Query Analyser from SQL server 2000

[Zeruel_angel]

As I say, I already deleted the accounts and chars (using the query analizer) and everithing runs smooth, BUT if I delete the guilds (again using the query analizer) then I can't start the server unless I use another data base.

See you later!

[xcaliboper]

If you are trying to delete the Navy Guilds = Impossible (wouldn't load)
Edit (translate to English) = Possible

[Zeruel_angel]

Ah! thats the problem! Now the problem is to figure out wich of the 199 chinese guilds are the navy and the pirate guild :P

THANK YOU VERY MUCH!

[xcaliboper]

The Guild ID's 0-100