Carnage + Kagegod:
There's a problem because the item table changed (
http://eqemulator.net/forums/showthread.php?t=18990) with the "release" of 0.6.2-DR0. To get around this, you can follow exactly the steps in the tutorial above, but, before you type...
Code:
perl load_13thfloor_items.pl -d eq -u [user] -p [password] <items.txt
1) Go into the command prompt.
2) \mysql\bin\mysql -u [username] -p
3) Enter your password.
4) Execute the following commands:
Code:
use eq;
ALTER TABLE items CHANGE UNK145 UNK150 int not null;
ALTER TABLE items CHANGE UNK141 UNK145 int not null;
ALTER TABLE items CHANGE UNK137 UNK140 int not null;
ALTER TABLE items CHANGE UNK133 UNK135 int not null;
ALTER TABLE items CHANGE UNK129 UNK130 int not null;
ALTER TABLE items ADD clicklevel2 int not null AFTER clicktype;
ALTER TABLE items ADD proclevel2 int not null AFTER proctype;
ALTER TABLE items ADD wornlevel2 int not null AFTER worntype;
ALTER TABLE items ADD focuslevel2 int not null AFTER focustype;
ALTER TABLE items ADD scrolllevel2 int not null AFTER scrolltype;
5) Exit mysql and continue with the tutorial.
6) After you've set everything else up, it's back to mysql (\mysql\bin\mysql -u [username] -p)
7) Now, we do everything in reverse
Code:
use eq;
alter table items change unk130 unk129 not null;
alter table items change unk135 unk133 not null;
alter table items change unk140 unk137 not null;
alter table items change unk145 unk141 not null;
alter table items change unk150 unk145 not null;
alter table items drop column clicklevel2;
alter table items drop column wornlevel2;
alter table items drop column proclevel2;
alter table items drop column focuslevel2;
alter table items drop column scrolllevel2;
It ought to work (does for me) at this point. Thanks for the fantastic tutorial, iwantavr4
