Fix for Guilds and Faction!

[IAFloppie]

When I try to source any of the files on this thread, it whines about duplicate column names and tables already existing. What should I do to take out the original db?

This is the text in my happy little DOS-mysql.exe window:

mysql> source factionfix.sql
Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> source fix.sql;
ERROR 1060: Duplicate column name 'minstatus'
mysql> source 42to43.sql;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1050: Table 'npc_faction_entries' already exists
ERROR 1060: Duplicate column name 'minstatus'
ERROR 1091: Can't DROP 'usedspells'. Check that column/key exists
ERROR 1060: Duplicate column name 'npc_spells_id'
ERROR 1060: Duplicate column name 'zoneid'
ERROR 1054: Unknown column 'zonename' in 'player_corpses'
ERROR 1091: Can't DROP 'time'. Check that column/key exists
ERROR 1060: Duplicate column name 'timeofdeath'