Ok, finally got everything setup last evening and am able to login, create a character, even run around and kill stuff. The problem I'm having is not being able to mem or cast spells. The #cast command nor the #spellfind command do not work. AA's seem to not be working correctly either. Any ideas?

I have copied the spells_en and spells_us to the EQEMu folder. Both of these files are dated 3-22-2005.

Also, should we be able to create several characters on one account? I created a second character on the same account and he is not able to move around.

its #castspell #
and #findspell name
not #cast and #spellfind

#cast works also, Ayre

ive been getting this error when I trry to do step 23

C:\Perl>perl load_13thfloor_items.pl -d eq -u '****' -p '******' <items.txt
Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at l
oad_13thfloor_items.pl line 3.
BEGIN failed--compilation aborted at load_13thfloor_items.pl line 3.

can anyone help??

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

install DBI.ppd


4b) Exit ppm, navigate to extracted DBD Directory:
Code:

install DBD-mysql.ppd


4c) Exit ppm, navigate to extracted IO-Stringy Directory:
Code:

install IO-stringy.ppd

I'd try redoing 4a.

"its #castspell #
and #findspell name
not #cast and #spellfind"

thats not the issue. The issue is that no spells work....at all. No right clickies such as Jboots, etc. The #heal command doesn't work either. Not sure whats going on. I have set my character as GM using the world flag status 200 (or whatever the syntax was).

anyone figure out how to get haste items and haste spells to work?
the only way i can get haste while playing is #haste

ok, I have installed it and everything works, but I do not have a pre 5/11 patch. Is there a way I can still play on it? I have tried patching to live, then using WintersRoar patch and it goes to logon screen then I log onto my server and it gives me a 1017 error. Im gonna do a search for 1017 now see if I can get it to work.

nope gonna have to wait till next emu comes out

found out how to get procs and haste to work
here is the link

http://www.steelpsychos.com/index.php?link=eqemu.php

unzipp the update_zone.rar then only extract the zoneperl.exe into you c:\EQEmu folder replaceing the one u have it will allow haste items/spells to work along with procs from weaps and you should no longer have the pet construct error

having problems not sure where to look.
 

I followed the guide and have everything running with out any problems.
minilogin appears to be working
world.exe no errors here.
boot5zones.bat all 5 come up after a min they sleep and appear to be working
I run eqgame patchme login and get my server,
I get char select and create a character.
click enter world it just sits there, eventually I get server not responding.
I check my eq version and that is the same that has been posted previously here as the one that works. last time I did a patch or anything was 4/12
not sure what direction to look in for this problem? I assume login is functioning properly because I get to char select. Any ideas out there?

Chalkin

some additional information
 

ok I get the commands.pl errors but that won't cause my problems. here is what I see in one of my worldperl windows.

[Status] Starting EQ Network server.
Starting factory Reader
Starting factory Writer
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map header: 36325 faces, 162 nodes, 46087 facelists
loaded map: 108975 vertices, 36325 faces
map BB: <-1049.59 -> 209.91, -83.97 -> 2255.09, -601.75 -> 77.97>
map ./maps/akanon.map loaded
Path File ./Maps/akanon.path not found
[Status] Weather should change in 4992 seconds

and so on. the only error I see is the path file.
not sure if that would cause my problems.

Thanks

If I wanted to make this so computers on my Lan can connect do I just change 127.0.0.1 to my ip address??

Okay i notice you made Ak'anon, i think i mentioned it in one of the first two posts... But you are most likely getting petstruct errors in your zoneperl.exe, alt tab out to the one which is hosting akanon and hit ignore... Its a bug, im not a dev or a fixer guy(i seen some people who claim fixes in this post!) but thats an issue that is resident in zones like akanon, sleepers, necropolis, and plenty more...

And as for the path file.. I dont think its needed... I dont have any of those files and it hasnt had any effect on anything i do, seems to work fine without them... Not sure what theyre for either, maybe fear pathing(idont think fear works anyway)

Going good!
 

Greetings all !
I have gotten quite far into the tutorial now, and the guide is excellent! I've worked through most of the errors, I see my server now and when I click play everquest it loads everything as normal, but then I get a popup window on my desktop saying that starting zone "clz" or something like that couldn't be found, You're not running EQ from the correct directory if you have m ultiple directories, call verant if this prob continues.

Well I did have multiple directories of EQ, so I zipped my prepatch for back up, and then just reduced down to one directory, and I'm still getting the same error? Any insight to this problem would be much appreciated!

[EDIT] NM !! I figured it out .

Very lost
 

been at this about 30 hours straight now and still cant get it to work

i have reloaded everything several times , i can log in but im not showing my server minilogin shows one server 0 clients

and World.exe keeps giving me the same error ever few secs still cant figure out how to clear it up its

Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables' doesn't exist

it repeats that error while running ever few seconds

Trying to get this set for single player i fly out in two more days and wont have access to the net for months so really could us some help on this please please , dont know as much about PC as i should i guess :(

Hmm
 

Well I'm definately not the most intelligent but I feel for you situation. It sounds to me like it's not a matter of reloading things, It just looks like you don't have table in your EQ database. When you do all the mysql stuff do you get any errors ? ALSO you might want to look at the NAMe of your server, I think it has to be like 12 chars or over to work and if you have less than that or like 10 your server will be active but it won't show in the login screen, at least.. I had this problem earlier today, same symptoms as you. Ex. my server name was "Futility" but that wouldn't show up in the server listing ! BUT "FutilityIncarnate" did ? weird but I seem to recall something like that from earlier versions, maybe it will help..

I tried :\

Thank you
 

ok sounds good , ill take a look at that right now.
thank you



I must say my Forum experiences have always been horrid, 6 years of everquest LOL. looks like all the cool people that play EQ , quit regular game and came here thanks again guys

As an FYI this would not work for me. It simply crashed my Zoneperl everytime i tried to login. So if it works for you congrats... No dice for me...

As for
It sounds like your database simply wasnt loaded fully... You might have messed up the first one and tried to recreate the second one over the top of it without deleting...

Perhaps try deleting everything from your EQ database and just try redoing the database part... Or maybe try again with a different database name...

Great guide, I've followed it step by step. I'm almost there, but here is the problem: when I attempt to log in, it says I have 0/8 expansions enabled. Please help...
-------------------------
Figured out, the problem is actually no server shows up, similar to what Lagartijoo posted earlier. I'm using minilogin on the same PC, and when I try to connect, minilogin does show new client from 127.0.0.1, but I can't proceed because of no expansions enabled. Any ideas?

Will this guide allow me to host my own server so that I can play without being on the internet, and my brother or friends could connect to me via lan, and also play the game?

If not, is there any way I can go about doing that?

Excellent tutorial!
 

Great work iwantavr4! Using your guide I was able to get the new version (I've been away for awhile) set up without a hitch. Thanks for all your hard work and for sharing all of this with us here.

BTW, someone earlier in this thread posted a problem where their character was stuck in an endless zoning loop. Even though someone else helped them out, I thought I'd mention that you can use the in-game #movechar [character name] [zone short name] command with a different character to move another you're not logged in with. I keep a separate "GM" character camped out in a safe zone specifically for this purpose. ;)

ok, maybe a stupid question, but when you guys sourced the files through sql did it take a really really long time to do the first one? I swear I've been getting "query OK, 1 row affected (0.00 sec)" scrolling for the past hour.

never mind--it finally finished after about 1 1/2 hours.

Newb :(
 

Im embarrassed to say but I on step 4 when you go to command prompt and you say navigate to the extracted DBI file I cant figure out how to navigate there.

cd (locatation)
So for instance i unzipped mine to c:\temp\dbi and c;\temp\scalar

i would type:

When i try t odo the Source Items stuff... i an error stating: ERROR 1146: Table 'eq101.items'(i remade database) dosent exist... it isnt evein in the test or regualr eq database.

I just started this a few days ago and i have everything u linked to download... Hopefully u can help. Sorry for the uber noobnes...

You probably missed out on sourcing something else first. One of the source files creates some tables that the others are used. I'd drop all my db's and go back and source them in the exact order the tut says

alright, i'll try that. Will post back if it works.


EDIT:I just dropped all my databases... i tried to source again and got to the items one and got a error in the cmd. My Cmd was spamming somethin about not have the table eq.items and wouldnt stop beeping untill i closed cmd. thats the only one that does this. Any way someone can link me a database with the items in it or anything? :-?

You think this could have anything to do with them Mysql download? when i clicked on it, it was a dead link so i went to the other tutorial and got it... dont think its 4.0.23...

EDIT2:Hmm i figured out wht i needed to do to get items.. I still get a couple beeps tho on Source for Zone and a coupel for items... that normal or do i need to redo something.

EDIT3: Well i got everything up and running. Only thing is... I cant log in. Maybe its because i patched -.- i jsut started 4 days ago.. Any help as to this?

you wont be able to play if you patched

and there are a few errors in a couple up the database sources (cant remember exactly which ones) but they still finish.

iwantavr4 were you ever able to get a copy of suedeworthey's world.exe and emusharmem.dll i think those are the 2 files we are gonna need also to get the haste/pet to work

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

broken link
 

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?

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.

Not working for me either.

/points at EQEMU6.1DR1

/points at MYSQL

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?