MW_057DR2_alpha_1 RELEASED!!

[govtcheeze]

I HIGHLY advise correcting your .sql file with the below fixes and resourcing the sql.

FYI, when I sourced I got he following output:

C:\mysql\bin>mysql -f eq<MW_057DR2_alpha_1.sql
ERROR 1061 at line 18254: Duplicate key name 'slotid'
ERROR at line 21993: Unknown command '\\'.
ERROR 1064 at line 21993: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'The dead must rest\\"","1","0","0","-1
","0","0","255","0","3276
ERROR 1061 at line 169041: Duplicate key name 'account'

C:\mysql\bin>mysql -f eq<MW_057DR2_alpha_1.sql

To fix these errors, you have to change the following lines:

Delete (in inventory table):

20484:   KEY slotid (slotid),
20485:   KEY slotid (charid)

and replace with:

  UNIQUE KEY slotid (slotid,charid)

Delete (in items table):

 24217: INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \\"The dead must rest\\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");

and replace with:

INSERT INTO items VALUES("5701","0","Engraved Di'Zok Deathbringer","0","0","0","0","0","15","0","0","4","0","0","0","0","0","15","0","0","0","0","0","0","0","0","0","0","-1","","22","0","0","1","0","16","0","22","0","0","0","0","0","0","0","0","0","0","0","0","","0","0","0","0","581","IT178","0","3","50","0","*an inscription reads \"The dead must rest\"","1","0","0","-1","0","0","255","0","32767","0","0","0","0","1","0","0","0","0","8192","662","0","0","0","0","0","0","0","1","-1","0","-1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","2003-10-03 20:29:09","50","","0","0","0","0","0","0");

Delete (in sharedbank table):

171271:   UNIQUE account (acctid),
171272:  UNIQUE account (slotid)

and replace with:

  UNIQUE KEY account (acctid,slotid)

Not sure if these errors were causing the inventory stuff before, but no more errors when sourcing