Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows)

[Greyhill]

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...

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:

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

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

[Carnage_ou812]

I got a syntax error when adding the last set of commands from that first section. Adding 'int' before the not null fixed it to where there was no syntax error and I was able to login.

Now, spells are all screwy. My first level wizard is unable to even scribe spells because they are all listed at level 255 with a tiger claw skill.