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

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Tutorials::Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=597)

- - Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows) (https://www.eqemulator.org/forums/showthread.php?t=18707)

Did anyone find a fix for the non-loading opcodes pictured here:
http://img319.imageshack.us/my.php?image=error5xb.jpg

Sorry if I missed it, I did skim through all 10 pages of this thread.

I think in the original tutorial there is a step that says something about making sure you overwrite such and such...go back and do that

If not, re-do the step where you download the world.exe -and- the step where you overwrite it

nice tutorial on how to do it, i have some errors though, starting a thread bout it... :P

Okie dokie.

Well i had a vacation pop-up out of no where(thats good), im also finishing my tour up here in Africa(thats also good), ive also been swamped with turning my duties over to someone else(not so good), and that also means my EQEmu services are pretty much done(also not good). Im sorry to all those who could not get it working. They have patched EQ quite a few times between when this guide was made and now. So fixing the same files i did might not work.

Now htat im going home ill be back contributing to the "Vision", so i wont have much use for an EMu. Perhaps this thread can go into an old archive now, im not sure. But i now understand why it was so difficult for me to find a working guide. EQ changes too much for the average Emu user to keep up without extreme effort. The Devs here are the ones who deserve some major thanks, as well as the people at PEQ.

Good luck everyone. Im pretty much out of here. :)

http://www.facet42.com/downloads/EQE...1-DR1-Perl.zip
appears to be broken...

Anyone know where else I could find this file?

Tharic

I was able to do everything but

perl load_13thfloor_items.pl -d eq -u [user] -p [password] <items.txt

Everytime I run this I get the error:

DBD::mysql::db do failed: Unknown column 'clicklevel12' in 'field list' at load_13thfloor_items.pl line 37, <STDIN> line xx

This repeats for all 45,091 lines and thus converts no items. I tried to add the clicklevel12 field into eq.items but I get the same error - anyone else have this problem?

Quote:

Originally Posted by Tharic

http://www.facet42.com/downloads/EQE...1-DR1-Perl.zip
appears to be broken...

Anyone know where else I could find this file?

Tharic

I'm having trouble with this aswel as the MySQL. Can you post up to date locations of where I can download these from? Much appreciated.

Quote:

Originally Posted by Tharic

http://www.facet42.com/downloads/EQE...1-DR1-Perl.zip
appears to be broken...

Anyone know where else I could find this file?

Tharic

Not working for me either.

/points at EQEMU6.1DR1

/points at MYSQL

Quote:

Originally Posted by kagegod

I am having this same problem after running the tutorial 3 times. I was able to successfully start everything and login to my locally running server. A broad item search shows 0 items and merchants have nothing to sell.

Any suggestions?

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 :)

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.

complete and utter noob here...

Ok im a complete noob to this, but would really like to get this figured out.

Im stuck on this step

4) Extract Scalar, DBI, and DBD-Mysql to individual directories in temp

what temp? create a new temp folder and put the files there?

4a) Open command prompt, navigate to the extracted DBI directory, type in PPM then:
Code: install DBI.ppd

oK, i opened the PPM.. typed in install, and it says it cannot find the files, i guess thats because i dont know where to put them in the first place....
how do i make the PPM find the files? i know Standard DOS code but this doesnt seem to recognize it.
how would i say 'install (folder where i put the files)/DBI.ppd'
so that it works?

like i said im a total noob and need things to be explained in full.
(assume i know nothing) lol

Good call Greyhill, can that be added to the tutorial?

Well, this tutorial finally got me up and running - and thanks Greyhill, I had the same issues with items but the fix worked.

There are alot of other issues right now (characters won't delete, spell msgs are 'Spellunknown', can't scribe spells from scrolls (#scribespells works though)), etc. I'll continue to scour these forums before making a post on them, though.