PDA

View Full Version : Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows)


iwantavr4
06-05-2005, 02:09 AM
Okay first disclaimer:
I did this mainly for myself since i was working on this on a computer i plan on not using the emulator on. Also because i found that there is no 1 current guide that has the information in it on HOW to set up a new server from scratch... It took me 3 days to get all this stuff put together from tons of different pages and forums. It worked finally, and i had a ton of issues(especially with the way they were saying to download the perl plugins IO::Scalar, etc). So im posting it here in hopes that someone else wont have to to through the same process i have in killing themselves trying to get this thing working.

If you PM me about the patch i will report and / or delete your pm, depending on my mood. So stop PMing me about where you can find it. I cant help you, i wish i could. Im tired of going thru these friggin PMs that are only about the patch!

Also, wherever it has brackets [ and ] be sure to note them, that means whatever username / password / server YOU wish to create. Dont type the brackets in if it says user/password/server, because thats simply me telling you thats where you choose your input.

Also also, any SQL files will save by Internet Explorer default to .txt files! Ensure when you right click to download them, you are saving them as 'All Files' and ensure they have .sql at the end of the name and be named .sql.txt and will not source properly!

Let me know if theres any errors, i will try to keep this free of bugssss!

Download:
Non EQEmu Programs
http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.23-win.zip/from/pick#mirrors -MySQL Download v 4.0.23
http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.2.808-MSWin32-x86.msi -Perl 5.8.2.808
http://home.comcast.net/~molimo140/NMAKE.EXE -NMake(perl thing)
http://home.comcast.net/~molimo140/default.pl -Plugin for EQEmu Quests(right click, save as)
http://home.comcast.net/~molimo140/plugin.pl -Another plugin for EQEmu Quests(right click save as)
http://ppm.activestate.com/PPMPackages/zips/8xx-builds-only/Windows/DBI-1.48.zip -DBI Perl package(this file may take a few tries to download, the site can be buggy, but its worth it!)
http://ppm.activestate.com/PPMPackages/zips/8xx-builds-only/Windows/DBD-mysql-2.9007.zip -DBDMysql Perl Package(this file too, see above.)
http://ppm.activestate.com/PPMPackages/zips/8xx-builds-only/Windows/IO-stringy-2.110.zip -IO::Scalar Perl Package(this file too, see above.)
You will also need to make sure you didnt patch after May 11, 2005. There are ways to fix it if you did, but dont ask.

EQEmu Stuff
http://prdownloads.sourceforge.net/eqemulator/Maps.tar.gz?download) (http://prdownloads.sourceforge.net/eqemulator/Maps.tar.gz?download) -All Maps(possibly not necessary, huge download 300mb
http://www.facet42.com/downloads/EQEmu-0.6.1-DR1-Perl.zip -EQEmu Upgrade for 6.1Perl Version
http://prdownloads.sourceforge.net/eqemulator/Compiled-Perl-Win32.zip -The remaining EQEmu Config files
http://prdownloads.sourceforge.net/projecteq/peq-velious-beta1.zip -Velious beta Database from PEQ
http://sourceforge.net/project/showfiles.php?group_id=127915
http://www.projecteq.net/sql/altadv_vars-contents.sql -Alternate Advance Contents from PEQ(right click, save as .sql and type 'All files')
http://prdownloads.sourceforge.net/eqemulator/MiniLogin6.1.zip?download -Minilogin 6.1
http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemulator/EQEmuCVS/utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql?rev=1.2 -Upgrades EQEmu items from 60dr2-61dr1(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemulator/EQEmuCVS/utils/0.6.1-upgrade.sql?rev=1.1.2.1 -upgrades something in database(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemulator/EQEmuCVS/utils/ZONECFG.SQL?rev=1.2 -something else in database(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemulator/EQEmuCVS/utils/load_13thfloor_items.pl?rev=1.2 -Perl items conversion script(right click, save as)
http://eqitems.13th-floor.org/download/items.zip -Text file Items from 13thfloor

Steps:
1) Install Mysql to C:\MySQL
2) Install Perl to C:\Perl
3) Copy Nmake to C:\Perl\Bin
4) Extract Scalar, DBI, and DBD-Mysql to individual directories in temp
4a) Open command prompt, navigate to the extracted DBI directory, type in PPM then:
install DBI.ppd
4b) Exit ppm, navigate to extracted DBD Directory, re-enter PPM:
install DBD-mysql.ppd
4c) Exit ppm, navigate to extracted IO-Stringy Directory, re-enter PPM:
install IO-stringy.ppd
5) Extract Compiled-Perl-Win32.zip to C:\EQEmu\, then extract EQEmu-0.6.1-DR1-Perl.zip to the same directory and ensure you *OVERWRITE* world.exe, zoneperl.exe, and emusharemem.dll
5a) Copy Plugin.pl to C:\EQEmu
6) Create Directory C:\EQEmu\quests
6a) Copy default.pl to C:\EQEmu\quests
6b) Extract peq-velious-beta1-quests.zip to C:\EQEmu\quests
7) Create Directory C:\EQEmu\Maps
7a) Extract Maps.tar.gz to C:\EQEmu\Maps
8) Create Directory C:\EQEmu\logs
9) Extract the following database files to C:\Mysql\bin
9a) peq-velious-beta1.zip
9b) altadv_vars-contents.sql
9c) items-0.6.0-DR2-0.6.1-DR1-convert.sql
9d) 0.6.1-upgrade.sql
9e) ZONECFG.SQL
10) Open C:\Mysql\bin directory, and double click on WinMySQLAdmin.exe
11) It will ask you to create a username/password(write down/remember what you put in!)
12) Open a command prompt type:
cd C:\mysql\bin
13) then type
[CODE]mysql

iwantavr4
06-05-2005, 02:19 AM
If you use Minilogin use the following steps next:
(If you aren

HalberdBlue
06-05-2005, 02:52 AM
Thanks for an up-to-date guide, I've been trying to use the older guides here all weekend, haven't had much luck :/.

I'll let you know how it works for me.

EDIT: OK still working on this, but if the above doesn't work for you, then try this:

on the GRANT PRIVILEGES thing, instead of making it '@192.bla.bla.bla' make it '@localhost'

And then on the perl_load13thfloor thing, instead of '-d db' use '-d eq'

And then when doing the 'INSERT INTO' etc thing, you have to type 'use eq;' beforehand.


These may sound obvious to MySQL and perl veterans but this is my first experience with this stuff (but I have a little programming background)



Thats just the changes I've had to make to make this work. Your results may vary

iwantavr4
06-05-2005, 03:21 AM
No problem, just hope it works out... Took two days to get it up and running so i just hope i got it all remembered right!

HalberdBlue
06-05-2005, 04:40 AM
OK I finished doing everything, it works great! Nice work! :)

iwantavr4
06-05-2005, 05:19 AM
Edit: Fixed all the errors up top, totally borked those somehow. I knew id forget something! First time with perl and sql, heh.

sweet, i hadnt tried it since i typed it out, im about to do that myself on the other computer.

Glad it worked though, tahts good news for me! I did most of the perl and eqemu stuff a couple days ago, and have been messing with the database since then trying to get it to work...

Hurrah, just glad theres finally something people can work off of 1 source wise :P

Now just gotta find out how you modify this stuff because so many of these mobs are just not quite right...

HalberdBlue
06-05-2005, 05:28 AM
OK maybe I spoke too soon, I am having the 1017 error after clicking Play Everquest but I think thats because of my router, and doesn't have to do with your instructions.

Belfedia
06-05-2005, 05:51 AM
Nice tutorial, this one of best i see :)
But link for download pre-patch 05/11/2005 everquest files is against forum's rules... (http://www.eqemulator.net/forums/announcement.php?f=586).
You may be permaban for that :(
I'm not moderator, administrator or devs in eqemu, this is just a advice.
This is my last message for this kind of rules. In french country, backpatch are not considered like warez, if you have the original software.

Calabeth
06-05-2005, 06:16 AM
Hopefully if he just takes that link out and puts a notice that ppl have to have copy of the pre 5/11 patch he should be gtg.
I will erase my old DB and try and mostly start from scratch trying this see if I can finally get my lil server going correctly and be seen hehe.

iamjooish
06-05-2005, 06:25 AM
Nice tutorial, this one of best i see :)
But link for download pre-patch 05/11/2005 everquest files is against forum's rules... (http://www.eqemulator.net/forums/announcement.php?f=586).
You may be permaban for that :(
I'm not moderator, administrator or devs in eqemu, this is just a advice.
This is my last message for this kind of rules. In french country, backpatch are not considered like warez, if you have the original software.

nor is it /truely/ considered 'warez' here in the states, but everyone uses the word in the broadest possible sense anyways.

strike what I said earlier. eqemu works as well as it does because it's developed in the legal grey/white area and because SOE can't do anything about them as long as that's the case. (for now!) allowing links to older files, even for just a few moments, puts the emu's developement at risk.

I don't think he has to change his language, however. He could link to Dr. Zauis's system resore idea, for example. A number of custom-legit servers, too, have a solution for this problem.

solid11
06-05-2005, 08:02 AM
Yeah, great tutorial, but do us all a favor and edit that link for pre patch from your post please. Don't want one mistake to ruin it for the rest of us.

HalberdBlue
06-05-2005, 08:47 PM
I just tried updating to live from the patch given above. There is NOTHING different. All the server downloaded was eqhost.ini which I had changed, even after a full file scan. The EQ Version number program gave the same version number as well.

Dunno if that means he has to take it down, but that patch isn't worth much unless you know what version of EQ you have to patch it from.

So I'm thinking that the fact I get stuck at the 1017 error and can't get past the log in screen trying to log onto other EQEmu servers is because the patch given above is the same as live.

tancor
06-06-2005, 03:15 AM
Are there any other places other then activestate.com to get those few utility addons? I can't seem to get access to that site - I'm very much looking forward to trying the tutorial.

-- Edit --

Nevermind - I managed to get into it finally, must have just been really busy this morning and got the modules needed.

iamjooish
06-06-2005, 07:24 AM
bull... I just ran everquest.exe and it replaced my eqgame.exe, among other things.


it doesn't bother me, I have the subject thread and the silly zipfile nested nicely in one of my folders. Besides, there are much less riskier ways of of reverting to the december patch, why put this great guide at risk...


edit

one last little thing



[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: open 'commands.pl' No such file or directory at (eval 4) line 1.



something I shourd be worried about?

sylverwolf
06-06-2005, 11:29 AM
Ok. a little note to any new folks out there (like me) and hope everyone reads this whole thread before doing this (this is a really well put together guide btw) :)

When i sourced the first database (the big one), i went for a cup of coffee and did a couple more things and came back and waited...and waited. when it got done, i lost track of where i was and cut right to the next procedure (the delete items deal)

DON'T MAKE THE SAME MISTAKE I DID!

be sure to source the other little items into the database first. what happened was when i ran the perl load items, i got a crapload of errors because i skipped the 6.0-6.1 convert and had to start ALL OVER hehe

tancor
06-06-2005, 01:22 PM
nm got it worked out

iwantavr4
06-06-2005, 05:31 PM
Okay, i editted out the patch thing, didnt realise. Thanks alot for letting me know Belf, i see your posts everywhere, you are very informative! And there were quite a few files that were updated on 5/11. I havent gotten it to work yet with the newest patch.

As for the command.pl aparently its an unnecisary file and you can create a blank one if you wish. The PEQ guys told me its not needed... I tried what they said and it just gave me another error. So im not going to bother posting what it was.

Also, if someone else is new to this like me... You need to eb careful when you are in zones like AkAnon, Dragon Necropolis, Veeshans Peak, and Sleepers Tomb... You will get a ton of errors from zone.exe in regards to petstruct not being redefined... And if you click abort it will basically LD you from the zone.

Hope the guide works for everyone else, really sorry about the patch thing. I didnt realise that was warez or whatever...

keerwen
06-07-2005, 02:46 AM
went through the guide and came across a couple things last nite. a couple of the links when clicking on them open up a text doc. i tried saving it as an sql file and they come up errors when trying to source them.


http://www.projecteq.net/sql/altadv_vars-contents.sql -Alternate Advance Contents from PEQ
http://prdownloads.sourceforge.net/....1.zip?download -Minilogin 6.1
http://cvs.sourceforge.net/viewcvs....ert.sql?rev=1.2 -Upgrades EQEmu items from 60dr2-61dr1
http://cvs.sourceforge.net/viewcvs....sql?rev=1.1.2.1 -upgrades something in database
http://cvs.sourceforge.net/viewcvs....CFG.SQL?rev=1.2 -something else in database

those are the ones. was wondering if i'm just doing something wrong with those. also atm i'm coming up with a connection failed 10061 error for world.exe. i deleted everything once already to start over thinking maybe i missed a step or something and am still getting the same error. any advice would be cool.

sylverwolf
06-07-2005, 04:28 AM
hmmm. so thats what that error is. i came across it in lake of ill omen and had to manually put my char back in SFG through the DB. i guess its one certain kind of pet (since i couldn't see any when i got the error) i went all through seb with chanter pets and wizzie familiars with no prob. so until there's a fix, guess we need to avoid those places :\

iwantavr4
06-07-2005, 06:44 AM
went through the guide and came across a couple things last nite. a couple of the links when clicking on them open up a text doc. i tried saving it as an sql file and they come up errors when trying to source them.

The reason its happening is when you save them you are actually saving them as .sql.txt. When you right cilck to save them, make sure in the 'save as type' box, you click 'All Files' as well as making sure that the File Name: has a .sql at the end. You are basically saving them as text files if you save them default. This is how IE works, not an error with the writeup or the script...

hmmm. so thats what that error is. i came across it in lake of ill omen and had to manually put my char back in SFG through the DB. i guess its one certain kind of pet (since i couldn't see any when i got the error) i went all through seb with chanter pets and wizzie familiars with no prob. so until there's a fix, guess we need to avoid those places :\

I have found this to be specific to wizard pets, namely the uhmm... Sword one, i think its called like sword of xuxil, whenever wizards cast this pet it causes this error. I dont know if thats the only thing that causes it, but im pretty sure it has something specifically to do with wizard pets and th sword of xuzil or whatever. Ive killed their pets and had them remake it only to find the exact same error... If you alt-tab out when you hear the computer ding, you can usually hit I for ignore and keep playing no problems.

Changed the first post to be alittle more specific on how to download the SQL files, and which files you can download by right clicking.

tancor
06-07-2005, 06:46 AM
went through the guide and came across a couple things last nite. a couple of the links when clicking on them open up a text doc. i tried saving it as an sql file and they come up errors when trying to source them.


http://www.projecteq.net/sql/altadv_vars-contents.sql -Alternate Advance Contents from PEQ
http://prdownloads.sourceforge.net/....1.zip?download -Minilogin 6.1
http://cvs.sourceforge.net/viewcvs....ert.sql?rev=1.2 -Upgrades EQEmu items from 60dr2-61dr1
http://cvs.sourceforge.net/viewcvs....sql?rev=1.1.2.1 -upgrades something in database
http://cvs.sourceforge.net/viewcvs....CFG.SQL?rev=1.2 -something else in database



The SQL files, alternate advance, eqemu items upgrade, upgrades something in db, something else in db - those links, just right click and save target as and it will pop up a window with most likely the file name that is correct and save it somewhere to find it.

Minilogin should bring up a page with mirrors to download from.

-T

Lagartijoo
06-07-2005, 09:20 AM
Hi guys,this tutorial is really great,but i got the next problem :p
When im on the server selection screen i see no servers,all worked fine on the world,boot5zones and minilogin,when i log into the server screen selection i see on the minilogin i get one client,so that is working fine.
My Eqhost.txt of my Everquest directory is:

[LoginServer]
Host=127.0.0.1:5999

LOGINSERVER.INI

[LoginServer]
loginserver=127.0.0.1
loginserver2=127.0.0.1
loginport=5999
loginport2=5999
worldname=-------------
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

DB.INI

[Database]
host=127.0.0.1
user=*******
password=*******
database=eq

BOOT5ZONES.BAT

start zoneperl . 127.0.0.1 8780 127.0.0.1
start zoneperl . 127.0.0.1 8781 127.0.0.1
start zoneperl . 127.0.0.1 8782 127.0.0.1
start zoneperl . 127.0.0.1 8783 127.0.0.1
start zoneperl . 127.0.0.1 8784 127.0.0.1
exit
cls


Any sugestions plz?on the world.txt i can see i get logged on the loging server correctly,but on the server selection i see no servers,plz help :)

tancor
06-07-2005, 02:42 PM
First question is are you playing on the same computer as the server is on, and in the databaase file, in accounts, did you set the minilogin_ip to 127.0.0.1?

-T

iamjooish
06-07-2005, 05:38 PM
hmmm. so thats what that error is. i came across it in lake of ill omen and had to manually put my char back in SFG through the DB. i guess its one certain kind of pet (since i couldn't see any when i got the error) i went all through seb with chanter pets and wizzie familiars with no prob. so until there's a fix, guess we need to avoid those places :\

and how'd you do that? I got a similar problem with trake's teeth except mine's more of a opcode/database thing... says character is in emerald jungle when I select and upon entry my toon immediately zones to Teeth except I can't zone to save my bum because of opcode stuff

Lagartijoo
06-07-2005, 05:49 PM
I host and play from the same pc

MiniloginAccounts.ini

# Max 200 lines total (including comments and blank lines)
# Blank lines may mess up the line # reported in error messages
81.9.208.65 account password


On the account password i have to put my eqemu account?

sylverwolf
06-08-2005, 02:24 AM
and how'd you do that? I got a similar problem with trake's teeth except mine's more of a opcode/database thing... says character is in emerald jungle when I select and upon entry my toon immediately zones to Teeth except I can't zone to save my bum because of opcode stuff

i just did #zone sebilis. none of the clicky ports i tried worked so i didn't even bother doing the run

Calabeth
06-08-2005, 02:35 AM
Only couple things I could see Lgar is in your miniloginsaccount.ini use the same 127.0.0.1 as the rest and yes you use the name/pass that you will log into the game with. Also does you eqhost.txt file say 127.0.0.1:5999 aswell?

iwantavr4
06-08-2005, 03:36 AM
Hi guys,this tutorial is really great,but i got the next problem
When im on the server selection screen i see no servers,all worked fine on the world,boot5zones and minilogin,when i log into the server screen selection i see on the minilogin i get one client,so that is working fine.
Ive had my server not show up, and restarted my EQ client and then it is there... Maybe try that first. After that i would make sure that youre launching the world.exe after you launch minilogin, and check to see on both programs(minilogin and world.exe) that you show a connection to the other. There should be a message stating the connection between the two. If not you might have other problems.

I dont have a miniloginacounts.txt or whatever, im not sure wehre it would go or whats supposed to be in there honestly. So i cant comment on that, mine worked completely without it.

Grim
06-08-2005, 05:29 AM
I've been reading for a few days.. and im closer than i've been in about 2 years to getting this up and running. I don't have any errors with mini/world/boot zones except a plugin one for perl. I'm stuck at logging in to server right at beginning of game.. Eqhost is 127.0.0.1:5999 and loginserver

[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=abcdefghijklmno
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress=
chatport=

[LoginConfig]
ServerMode=Minilogin
ServerPort=5999

currently.. about my 9th combination trying my local ip.. localhost and 127.0.0.1 i shouldn't worry about bootzones until i see my server correct?

Lagartijoo
06-08-2005, 05:53 AM
Yeah cala i got 127.0.0.1:5999 on eqhost and all the others files,but still dont see my server on the server selection screen :/

Grim
06-08-2005, 08:45 AM
Legar, im stuck at connecting, are you behind a router? I've had this working a long long time ago.. and i remember switching between localhost/127.0.0.1/and my ip 192.168.-.- and had my wife and I both playing. but i can't get the right combo. My eq version is correct, i can play on other eqemulator servers.

rempty
06-08-2005, 02:05 PM
holy balls! id just like to say thanks, ive been looking for a viable everquest emulator for going on a year and ive tried more tutorials on doing one than i should have. got everything working on this one up to the point of 1017 cause i am yet to find a working eq version, but i think that will do it so id like to say THANKS!
*edit*
I have managed to get a working version, but at the moment all i can access is fatesdestiny, if i change my eqhost to whats on the tutorial, the window just hangs after i hit connect

kl9470spin
06-08-2005, 04:02 PM
Omgsh! Great awsome guide!

Worked Magic for me! :D

if you figure out how to do a internet server let us know :D

Thanks again!

iwantavr4
06-08-2005, 11:08 PM
Hey, I dont know where all the errors are coming from. I ran this guide on a few computers now and it worked perfectly for me.

As for *where* the PEQ pre5/11 patch is i cant say. Sorry, i dont know if its a rule over at projecteq, but i would probably ask over there instead.

Hopefully this works for most, i honestly cant say why your servers are not showing up. Like i said before, sometimes that would happen, but if i logout or restart my EQ client it would show up, it was never permanent. If you put everything in the way it was stated in the guide you should be good to go. I would say if you change any of the 127.0.0.1 to localhost, that you change them all.

If you cannot connect to the worldserver, then i would make sure your loginserver and worldserver are actually takling to each other. If they are, then theres probably a problem between the two of them, but thats a guess.

So once again, sorry for thsoe who it isnt working for. I can try to help where i can, but i cant offer up the info on where the patch is, and i dont know why the servers arent showing up. Sorry :(

As for a working internet version, i cant say. I am behind a military network, so i basically built this for my personal laptop, since i get no chance to play on my live account and im having withdrawls :P

Maybe some experienced veterans will come visit and inform on some of the errors. Because i dont know :(

Aradorn
06-09-2005, 09:07 AM
the default and plugin for eqemu is that supposed to be saved as a .sql also or .pl? nevermind i figured it out

Grim
06-09-2005, 09:17 AM
This guide is fantastic..I just can't get to server select for some reason.. Keep getting the "make sure you are online" window Must be my host file?

Grim
06-09-2005, 12:25 PM
reading some .txt files in my eq folder, most say october 25th, not sure that is accurate.. but I've tried 0.6.0 DR 3 and 0.6.1 DR2... with 6.0 minilogin and 6.1 to match. I can play on other servers just fine.. and I can even see mine on that list. I've dished out 15$ for a domain name as well, trying to get past my D-Link router.. Still trying.

Aradorn
06-09-2005, 03:39 PM
i typed cd c:\mysql\bin
then mysql -u root
then create database eq;
i get ERROR 1007: cant crate database 'eq' database exist
this is the first time ive installed and tried to pust this together

iwantavr4
06-09-2005, 04:57 PM
Aradorn:
http://dev.mysql.com/doc/mysql/en/drop-database.html

Look there... Try dropping the database and recreating it.

Grim:
Keep getting the "make sure you are online" window Must be my host file?
Are you talking about the patch window..? If so you didnt make youre EQ shortcut read patchme... If youre talking about 1027 or 1017 in EQ then it could be your host file, could be your login server...

Aradorn
06-09-2005, 06:33 PM
ive done the patchme thing along time ago it just says the database already exist

i went on to step 16 and typed Source load_system.sql;
and everyitem when it tried to source said it was duplicate i sat for over an hour and it did this

Aradorn
06-09-2005, 07:00 PM
bull... I just ran everquest.exe and it replaced my eqgame.exe, among other things.


it doesn't bother me, I have the subject thread and the silly zipfile nested nicely in one of my folders. Besides, there are much less riskier ways of of reverting to the december patch, why put this great guide at risk...


edit

one last little thing





something I shourd be worried about?
i did everything in the post to do and i got his error too
when i did source the Source items-0.6.0-DR2-0.6.1-DR1-convert.sql;

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Brandon>cd\ c:\mysql\bin
The filename, directory name, or volume label syntax is incorrect.

C:\Documents and Settings\Brandon>cd c:\mysql\bin

C:\Mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 4.0.23-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
ERROR 1054: Unknown column 'unknown021' in 'items'
ERROR 1054: Unknown column 'unknown022' in 'items'
ERROR 1054: Unknown column 'unknown023' in 'items'
ERROR 1054: Unknown column 'unknown064' in 'items'
ERROR 1054: Unknown column 'unknown070' in 'items'
ERROR 1054: Unknown column 'unknown072' in 'items'
ERROR 1054: Unknown column 'combatskill' in 'items'
ERROR 1054: Unknown column 'combatskilldmg' in 'items'
ERROR 1054: Unknown column 'booktype' in 'items'
ERROR 1054: Unknown column 'unknown108' in 'items'
ERROR 1054: Unknown column 'banedmgamt2' in 'items'
ERROR 1054: Unknown column 'augmentrestriction' in 'items'
ERROR 1054: Unknown column 'tribute' in 'items'
ERROR 1054: Unknown column 'attackbonus' in 'items'
ERROR 1054: Unknown column 'hpregen' in 'items'
ERROR 1054: Unknown column 'hastepercent' in 'items'
ERROR 1054: Unknown column 'unknown125' in 'items'
ERROR 1054: Unknown column 'unknown126' in 'items'
ERROR 1054: Unknown column 'unknown127' in 'items'
ERROR 1054: Unknown column 'distiller' in 'items'
ERROR 1054: Unknown column 'unknown129' in 'items'
ERROR 1054: Unknown column 'unknown130' in 'items'
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'unknown131' in 'items'
ERROR 1054: Unknown column 'unknown132' in 'items'
ERROR 1060: Duplicate column name 'UNK121'
ERROR 1060: Duplicate column name 'pointtype'
ERROR 1060: Duplicate column name 'potionbelt'
ERROR 1060: Duplicate column name 'UNK124'
ERROR 1060: Duplicate column name 'stacksize'
ERROR 1054: Unknown column 'hasteproclvl' in 'items'
ERROR 1054: Unknown column 'spellid' in 'items'
ERROR 1054: Unknown column 'focusid' in 'items'
ERROR 1054: Unknown column 'effecttype' in 'items'
ERROR 1054: Unknown column 'level' in 'items'
ERROR 1060: Duplicate column name 'UNK129'
ERROR 1060: Duplicate column name 'proceffect'
ERROR 1060: Duplicate column name 'proctype'
ERROR 1060: Duplicate column name 'proclevel'
ERROR 1060: Duplicate column name 'UNK133'
ERROR 1060: Duplicate column name 'worneffect'
ERROR 1060: Duplicate column name 'worntype'
ERROR 1060: Duplicate column name 'wornlevel'
ERROR 1060: Duplicate column name 'UNK137'
ERROR 1060: Duplicate column name 'focustype'
ERROR 1060: Duplicate column name 'focuslevel'
ERROR 1060: Duplicate column name 'UNK141'
ERROR 1060: Duplicate column name 'scrolleffect'
ERROR 1060: Duplicate column name 'scrolltype'
ERROR 1060: Duplicate column name 'scrolllevel'
ERROR 1060: Duplicate column name 'UNK145'
ERROR 1054: Unknown column 'cost' in 'items'
ERROR 1054: Unknown column 'casttime2' in 'items'
ERROR 1054: Unknown column 'proc_rate_mod' in 'items'
ERROR 1054: Unknown column 'charmformula' in 'items'
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'ldonpointtheme' in 'items'
ERROR 1054: Unknown column 'ldonpointcost' in 'items'
ERROR 1054: Unknown column 'gmflag' in 'items'
ERROR 1060: Duplicate column name 'serialized'
ERROR 1060: Duplicate column name 'verified'
ERROR 1060: Duplicate column name 'serialization'
ERROR 1060: Duplicate column name 'source'
ERROR 1060: Duplicate column name 'UNK033'
ERROR 1091: Can't DROP 'charges'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown001'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_slot_id'. Check that column/key exists
ERROR 1091: Can't DROP 'merchantprice'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown004'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_inst_id'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown006'. Check that column/key exists
ERROR 1091: Can't DROP 'spellcharges'. Check that column/key exists
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql>

i know this is out of order with the steps but this is what happend when i did all the steps in synch
im doing a fresh install with no other server to be upgraded

iwantavr4
06-09-2005, 10:50 PM
Aradorn:
Drop the EQ Database! I linked to a page where it describes how to drop a database. You already aparently have a eq database.(and from the looks of it, one which isnt current, or is incomplete)

If you dont want to drop the databse then simply make the database name eqb or eq2 or testing, or database. And just make sure you change the db.ini file to point to your new database.

You dont need it named EQ. It looks as though you already have a eq database.

The second way you can rid yourself of the database is to navigate to your mysql/data directory and DELETE the eq folder. Then restart your computer, and start from step 1.

Either way, you missed my post about dropping teh database, you already have one there, youre trying to overwrite it.

Aradorn
06-10-2005, 03:49 PM
sorry bout that i see it now thanks.... one last question im not clear on. on step 14 I dont put the bracket around username and password right

Grim
06-10-2005, 03:59 PM
Thanks Iwantavr4, my issue is when i type username and password in EQ (after the patchme thing) it just pauses for a minute then says, make sure you are online, can't connect to server. I can't get past that when using minilogin. If i use eqemu login i can get to others servers and such, and even see mine if i start world.exe and all, Course i can't play on mine i get 1017:) so i tried getting a dns $15.00 and all kinds of other combos

Not going to give up. I have had this working, and im awesome at database work.. i populated like 12 zones with correct mob named and itemized drops. I really liked doing that and am trying to get this working so i can do it again lol. May have to wait for eqemu to catch live. Would probably be best.

iwantavr4
06-10-2005, 05:47 PM
sorry bout that i see it now thanks.... one last question im not clear on. on step 14 I dont put the bracket around username and password right
No brackets around the user/password.

Course i can't play on mine i get 1017 so i tried getting a dns $15.00 and all kinds of other combos

If youre trying to set this up with a network i cant help you... I didnt set mine up that way. I set it up to fly solo on my own PC. 127.0.0.1 is local loopback for computers.

Aradorn
06-10-2005, 07:05 PM
dropping server and redoing it fixed the database prob
in world.exe it does this
[status] loading ./addon.ini'
couldn't open './addon.ini'.
[status] loading EQ time of day..
Failed to open log file: logs/emu_error_world_3044.log
[error] could not load EQTime file ./eqtime.cfg
[error] Unable to load ./egtime.cfg
and in all boot5zones it does this
[quest] loading perl commands...
[quest] Warning - commands.pl: perl runtime error: open 'commands.pl' No such file or directory at (eval 4) line 1.

other then that everything else loads fine

iwantavr4
06-10-2005, 09:31 PM
[status] loading ./addon.ini'
couldn't open './addon.ini'.
[status] loading EQ time of day..
Failed to open log file: logs/emu_error_world_3044.log
[error] could not load EQTime file ./eqtime.cfg
[error] Unable to load ./egtime.cfg
and in all boot5zones it does this
[quest] loading perl commands...
[quest] Warning - commands.pl: perl runtime error: open 'commands.pl' No such file or directory at (eval 4) line 1.
Okay, i was wondering if some files would be missing. Now that you mention it, there are a few other files.

The commands.pl is a file i havent been able to find and the folks at PEQ said its not neccisary. So no worries on that one. Ill update the guide in a couple hours, but for now, CHOW! :)

Edit: Cant get those extra files. For some reason i cant upload anything here. Probably has to do with the firewall. See post below, updated main guide also to reflect changes.

Aradorn
06-10-2005, 09:45 PM
the file says the archive is either in unknown format or damaged

iwantavr4
06-11-2005, 02:07 AM
Okay i changed step 5 of the guide, it now has a link to the eqemu compile perl version from the eqemulator sourceforge site. Download that file, extract all the files within to your C:\eqemu\ then overwrite world.exe, perlzone.exe and emusharemem with the updated files from the other 6.1perl zip file.

iwantavr4
06-11-2005, 02:37 AM
Oh, also! I feel i should mention i tried this on my laptop, which is running windows XP with service pack 2. You need to make sure your XP Firewall is set to prompt you when you have programs trying to run servers, open ports, or connect to stuff... Otherwise this wont work. I think i had to set 3 or 4 different programs when they popped up to 'unblock'. If you are running winXP this may be why some of you arent seeing your servers. Because XP Firewall is blocking the server programs from broadcasting or recieving information!

drognir
06-11-2005, 07:55 AM
At this step

16) Then source the following databases into the database by typing the following commands(In this order)
Code:

Source load_system.sql; Source load_empty_users.sql; Source items-0.6.0-DR2-0.6.1-DR1-convert.sql; Source 0.6.1-upgrade.sql; Source ZONECFG.SQL; Source altadv_vars-contents.sql;

i am getting this error

mysql> source load_system.sql;
ERROR:
Failed to open file 'load_system.sql', error: 2
mysql>

I'm sure that i'm doing something totally noobish, and that this error is easily fixed. If anyone could help me i'd really appreciate it 8) thanks.

Aradorn
06-11-2005, 08:35 AM
did you make sure all those files are in c:\mysql\bin folder. make sure there are no folders inside the bin

Aradorn
06-11-2005, 08:38 AM
iwantavr4 do you have EQVercheck if you do can u post your version i want to make sure mine matches i didnt patch on 5/11 but i did patch up to 5/11 and i want to make sure my version matchs befor i continue

drognir
06-11-2005, 08:38 AM
I think that's the problem, those first two files don't exist.

Source load_system.sql;
Source load_empty_users.sql;

I didn't see anywhere in the tut where it says to download them.

Aradorn
06-11-2005, 08:44 AM
those files are in the peq-velious-beta1.zip

vRandom
06-11-2005, 08:44 AM
Velious beta Database from PEQ
http://prdownloads.sourceforge.net/projecteq/peq-velious-beta1.zip

then extract them in step:

8) Extract the following database files to C:\Mysql\bin
8a) peq-velious-beta1.zip

:)

Used this tutorial and everthing works execpt the merchants :)
i did get 2 beeps on the Source load_system.sql but it scrolled by so fast i wasnt able to find out what caused the beeping...

[edit] Aradorn types faster than me

drognir
06-11-2005, 08:45 AM
Thanks 8). I noticed when i extraced the velious db that there was a directory in the zip file, and the tut didn't mention anything about not leaving it there so i just extracted the directory. I really appreciate the help.

Aradorn
06-11-2005, 08:47 AM
this is my eq version pre 5/11 just wondering if this is the right one to work with the 6.1dr1
SHORT VERSION: SEQ8A667
LONG VERSION: EQ10F6C5D8579C384AAACC9FA61E2727A6B8291587

vRandom
06-11-2005, 08:49 AM
thats the same eq version i have that works with this tutorial

Aradorn
06-11-2005, 08:57 AM
ok i guess im gonna have to redo the tutorial ... one thing i found wierd tho when i installed winmysqladmin it didnt ask me to put in a username\pass but when i go to my.ini setup it has the username\pass in there...


i did have this program before i did the tutorial, but i went to control panel and add\remove software and installed the winmysql i downloaded.


anyways i use the user/pass off of winmysql when i do the sourceing i hope this is correct also

vRandom
06-11-2005, 10:13 AM
yep, use the username and pass you made when starting the winmsqladmin

GRANT ALL PRIVILEGES ON *.* TO Username@localhost IDENTIFIED BY 'Password' WITH GRANT OPTION;

change the username to the username your using, likely root, then set the password to what ever you want the pass to be

this changes the permissions to allow the user to use any database, if you wanted to just do one database for example, change the *.* to dbname.* (database name . and * for all tables etc in that database)

execute this command using the mysql -u [username] -p[passsword]
just with the -p and it will prompt for the password if one is set

forexample:
c:\mysql\bin\mysql -u root -ppassword
(notice no space between the -p and the password)

dont forget to change databases before sourcing, example:
use eq;

:) hope that helps some

kl9470spin
06-11-2005, 10:32 AM
Anyone wanna add onto this explaining how to get it to go public?

drognir
06-11-2005, 10:50 AM
Alright, i got through the whole tutorial with only one error this time, when i try running world.exe i get this

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

Anyone know what's wrong?

Aradorn
06-11-2005, 11:04 AM
Failed to open log file: logs/eqemu_world_0196.log 1st line on world.exe

this below is the last thing in world.exe everything inbetween loads perfectly now
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1170: 127.0.0.1:8782
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1169: 127.0.0.1:878088166 New TCP connection: 127.0.0.1:16777343New zoneserver: #3 127.0.0.1:1173
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1173: 127.0.0.1:878490169 New TCP connection: 127.0.0.1:16777343New zoneserver: #4 127.0.0.1:1172
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1172: 127.0.0.1:878192172 New TCP connection: 127.0.0.1:16777343New zoneserver: #5 127.0.0.1:1171
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1171: 127.0.0.1:8783

this is the only 2 errors i see on world.exe now

was i supposed to put username\pass in LoginServer.ini

Aradorn
06-11-2005, 12:08 PM
Alright, i got through the whole tutorial with only one error this time, when i try running world.exe i get this

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

Anyone know what's wrong?

5) Extract Compiled-Perl-Win32.zip to C:\EQEmu\, then extract EQEmu-0.6.1-DR1-Perl.zip to the same directory and ensure you *OVERWRITE* world.exe, zoneperl.exe, and emusharemem.dll
did you unzipp both those into c:\eqemu

drognir
06-11-2005, 12:11 PM
I'm pretty sure i did, but i'm completely redoing the tut now..

Aradorn
06-11-2005, 12:15 PM
if you redo make sure you go to control panel and add/remove mysql and perl.. then delete the perl mysql and eqemu folder or you will still get problems

drognir
06-11-2005, 12:35 PM
Thanks, i tried redoing it once, and didn't completely remove mysql and i ran into problems when i tried making the eq db

drognir
06-11-2005, 01:27 PM
I just redid the entire tutorial without error until i got to where i lauch world.exe, and it gave me this same error again

Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

I'm stumped... Anyone have any advice please?

Aradorn
06-11-2005, 04:49 PM
iwantavr4 i got a question... finnaly gotinto eq but when im in wfreeport i get a pet error or something then after a few min it dropps me has this happend to you

ok here is the error
Debug Error!

Program: C:\eqemu\zoneperl.exe
modul:c:\eqemu\zoneperl.exe
file:

Run-time check failuer #3- the variable 'petstruct' is being used with being defined.
(press retry to debug the application)

its a microsoft visual c++ debug library

vRandom
06-11-2005, 04:53 PM
Aradorn,
**WARNING** You have not setup a zone server password into the database, it is HIGHLY recommended that you add a variable into variables with the varname ZSPassword and the value with random characters to protect from people connecting to your world server.Zoneserver SetConnectInfo: 127.0.0.1:1170: 127.0.0.1:8782

import these in to your database, its originally from cavedudes database, but i changed the server name in my set up :)

you might already have the minilogin one thats if your useing it, i dont know what they all do but the error is mainly related to


INSERT INTO variables VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-06-02 21:32:56');


might actually change the pass too though, here are the rest of the vars i have set currently


INSERT INTO variables VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server :)', '2005-06-11 11:59:56');
INSERT INTO variables VALUES ('MOTD', 'Welcome to Gooberville!', 'Server Message of the Day', '2005-06-11 12:04:57');
INSERT INTO variables VALUES ('disablecommandline', '0', 'Allow command lines to be run from world.exe | 0 - off | 1 - on |', '2004-10-20 07:49:25');
INSERT INTO variables VALUES ('PersistentZoneState', '0', 'Save zone state on shutdown for bootup | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('decaytime 1 54', '300', 'Corpse decay time for Level\'s 1 to 54', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('decaytime 55 100', '1800', 'Corpse decay time for Level\'s 55 to 100', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('Max_AAXP', '21626880', 'Max AA Experience', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-06-02 21:32:56');
INSERT INTO variables VALUES ('loglevel', '0000', 'Commands,Merchants,Trades,Loot', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('MerchantsKeepItems', '1', 'Merchants keep items sold to them | 0 - off | 1 - on |', '2004-08-27 18:12:07');
INSERT INTO variables VALUES ('GuildWars', '0', 'Enable Guild Wars Type Server | 0 - off | 1 - on |', '0000-00-00 00:00:00');
INSERT INTO variables VALUES ('leavecorpses', '1', 'Players leave corpses | 0 - off | 1 - on |', '2004-10-19 20:41:59');
INSERT INTO variables VALUES ('holdzones', '1', 'Restart Crashed Zone Servers | 0 - off | 1 - on |', '2004-09-19 15:05:13');
INSERT INTO variables VALUES ('EXPMod', '.8', 'Experience multipler. Increase to increase exp rate', '2005-02-04 11:37:19');
INSERT INTO variables VALUES ('GroupEXPBonus', '.2', 'Experience multipler. Increase to increase group exp rate', '2004-11-10 15:00:37');
INSERT INTO variables VALUES ('AAXPMod', '.9', 'AA Experience multipler. Increase to increase exp rate', '2004-09-21 23:51:08');
INSERT INTO variables VALUES ('Expansions', '255', 'Accessible expansions for each player', '2004-04-03 21:54:03');
INSERT INTO variables VALUES ('ServerType', '0', 'Sets server type | 0 - normal | 1 - pvp |', '2004-10-28 11:09:41');
INSERT INTO variables VALUES ('DisableNoDrop', '0', 'Takes No-Drop off of items', '2004-10-28 11:08:04');
INSERT INTO variables VALUES ('ACfail', '35', 'the percentage of time AC fails to protect. 0 would mean there was always some level of protection, 100 would mean AC has no affect. When AC fails, it will be possible to get a max dmg hit.', '2005-02-04 11:36:09');
INSERT INTO variables VALUES ('ACreduction', '1', 'the percentage of AC that is ALWAYS reduced from a hit (except when AC fails with ACfail) \n\n', '2004-11-03 10:24:23');
INSERT INTO variables VALUES ('ACrandom', '3', 'the maximum amount of additional protection AC provides. 0 would mean no additional protection is provided, otherwise an additional amount of reduction is calculated using a random percentage of 1 to this value (except when AC fails with ACfail) \n', '2005-02-04 11:36:15');
INSERT INTO variables VALUES ('DBVersion', '061_gooberville', 'DB version info', '2005-06-11 12:05:06');
INSERT INTO variables VALUES ('LootCoin', '0', 'Allows players to loot coin off a player corpse in pvp | 0 - off | 1 - on |', '2004-11-08 07:28:26');
INSERT INTO variables VALUES ('PvPreward', '0', 'Allows players to loot items off a player corpse in pvp | 0 - no items | 1 - a single item | 2 - all items | 3 - item specified in PvPreward |', '2004-11-08 07:28:35');
INSERT INTO variables VALUES ('PvPitem', '0', 'Specific item that can be looted off a player in pvp', '2004-11-08 07:28:08');
INSERT INTO variables VALUES ('ailevel', '6', '', '2005-04-12 18:20:14');


:)

vRandom
06-11-2005, 04:54 PM
drognir,
Failed to open log file: logs/eqemu_error_world_2744.log

might try making a log dir in your eqemu dir, not sure otherwize :)

vRandom
06-11-2005, 04:55 PM
iwantavr4 i got a question... finnaly gotinto eq but when im in wfreeport i get a pet error or something then after a few min it dropps me has this happend to you

I had the pet construct error, but its late and i'm not remembering what i did to fix it..... hummm

iwantavr4
06-11-2005, 04:58 PM
I dont know how you got your version number... The one i have was created/modified on this date:
Sunday, April 17, 2005, 10:13:30 PM

And has the following MD5 Hash:
40B0DA1CCB3C3C07947261B016201328

Aradorn
06-11-2005, 05:00 PM
that log thing u jsut mentioned do you just make a folder called log? i also updated post above about the error

vRandom
06-11-2005, 05:04 PM
that log thing u jsut mentioned do you just make a folder called log? i also updated post above about the error

yes, logs actually ;)

vRandom
06-11-2005, 05:08 PM
version tool
http://www.eqemulator.net/forums/showthread.php?t=17992

thats what i used to determin which version i am running, though it doesnt list my version, but its working - at lease at the moment

vRandom
06-11-2005, 05:10 PM
pet construct error, actually still have this error

I think it is related to the perl compile version of zone, i just started messing with it today, i dont know of a fix. there is a non-perl version that does work, but no quests with it as far as i know...

i'll look up the link....
http://www.eqemulator.net/forums/showthread.php?t=18675

try one of the no perl versions listed there, have to beg the others here to find out more about the pet construct error

iwantavr4
06-11-2005, 05:18 PM
Run-time check failuer #3- the variable 'petstruct' is being used with being defined.
(press retry to debug the application)
When i get that problem, i hit ignore, otherwise it crashes the zone. Not sure how to fix it. If you hit retry or abort it will usually make you LD. Ignore just lets it continue. I dont know how to fix it...

Failed to open log file: logs/eqemu_error_world_2744.log
For that you just need to create a c:\eqemu\logs directory.

Im adding these extra steps and the sourced in stuff you put here also.. Thanks vRandom.

iwantavr4
06-11-2005, 05:34 PM
Failed to open log file: logs/eqemu_world_2744.log
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.1-DR1
[Status] Loading opcodes..
[Error] Load Shared Library 'EMuShareMem' failed. Error=Error #14001
Unable to laod EMuShareMem for opcodes.
Failed to open log file: logs/eqemu_error_world_2744.log
[Error] Loading opcodes failed. I can't live like this!

I'm stumped... Anyone have any advice please?

Okay, before you redo everything. First create a logs directory in your C:\EQEmu folder (C:\EQEmu\logs).

Then, try re-unzipping the EQEmu-0.6.1-DR1-Perl.zip again to your eqemu directory, make sure you overwrite the three files zone, world, and emusharemem.

I think im going to add some troubleshooting steps to the bottom of my minilogin post...

Also:
If you feel the urge to REDO the database, you dont have to reinstall everything. Type the following code to delete the eq database:
DROP database IF EXISTS eq;

You can then redo your database.

vRandom
06-11-2005, 05:44 PM
here is some info about the pet construct, it didnt read as it was totaly fixed but might be a thread to keep an eye on

http://www.eqemulator.net/forums/showthread.php?t=18731

iwantavr4
06-11-2005, 06:08 PM
cool, posted my findings... :) Hopefully they will figure it out.

vRandom
06-11-2005, 06:09 PM
:) noticed, i hope so

I'm just happy my merchants work lol

I tried out the perl version they mentioned, compiled yesterday it crashes before even loading, though i could just be really tired and messed it up somehow lol

[edit] oh yah, i can't type now, must be tired

Aradorn
06-11-2005, 06:31 PM
the post with the zspassword what password will that actually change?

drognir
06-11-2005, 07:27 PM
I've redone it yet again, but still getting the same error. I'm starting to think it's not something that i'm doing wrong, because i followed the steps correctly all 3 times. I don't know what else to do, i tried re-extracting the file you said to, and it's still not working. If anyone can help, i'd really appreciate it. Thanks

iwantavr4
06-11-2005, 08:27 PM
i know you already said you followed it to the letter...

But maybe you have a zone.exe in your folder.. and its trying to run off that?

Is your boot5zones have start zonerperl instead of start zone, in them?

Should look like this in the middle of the file:
start zoneperl . 172.16.21.80 8780 127.0.0.1
start zoneperl . 172.16.21.80 8781 127.0.0.1
start zoneperl . 172.16.21.80 8782 127.0.0.1
start zoneperl . 172.16.21.80 8783 127.0.0.1
start zoneperl . 172.16.21.80 8784 127.0.0.1

Easy way to check would be see if you have a zone.exe in your folders, if so delete it, then rerun and see if your boot5zones even works at all.

Also did you fix the logs errors? All you should need to do is create a folder for that... should be easy

vRandom
06-12-2005, 03:24 AM
the post with the zspassword what password will that actually change?

hehe, dont actually know myself but it made the error stop. :)

Aradorn
06-12-2005, 04:32 AM
where do i look to find the number string for paly epic weaps?nm found it

though the delete button under char select doesnt work anyone know how to delete a char?

also found something else i dont knowhow to fix.... i zoned from highpass into highpass keep and now im in a continuous loop trying to load into the keep

vRandom
06-12-2005, 05:07 PM
where do i look to find the number string for paly epic weaps?nm found it

though the delete button under char select doesnt work anyone know how to delete a char?

also found something else i dont knowhow to fix.... i zoned from highpass into highpass keep and now im in a continuous loop trying to load into the keep

In the database there is a table called character_ change the zonename of your char to something else north, example freeport's zone name is freportn (if your faction would allow you to go there). You might end up in a weird place do to the x,y,z being different, but you can type #zone [zonename] after you get logged in, if you do the #zone [name of current zone] you will get moved to the safe point in that zone.

at lease thats how i got mine back to working....

Zone names are the file names without the extension in the maps folder, use them with the #zone command.

hope that helps :)

Aradorn
06-12-2005, 05:44 PM
well the problem is i cant type anything it tries to rezone me within a milisecond so i cant rezone myself even when i login it loops this

vRandom
06-13-2005, 01:12 AM
well the problem is i cant type anything it tries to rezone me within a milisecond so i cant rezone myself even when i login it loops this

these are the steps i did

1. changed database characters_ zonename to freportn
2. logged in to the game
3. came in somewhere under the world
4. typed #zone freportn

/shrug
you might try changing the value while in the game, during the zoning loop...

I'm not sure otherwise....

Calabeth
06-13-2005, 03:04 AM
Ok I might be rather dumb on this Q and over looked the right thread using search and such.

But a couple things.

1. The guide is great, I got it up and am playing on it but I want to now have the server run on my one comp as it has more ram and less CPU power, while I play on the other comp which has alot better Cpu/ and almost as much ram.
Off to search some more and hopefully find my answer for this one.

2. Quest related file error. When I zone into Thurgadina I crash and get perl quest error from Lorekeeper E. I attempted to look at the lines it said was messed up but it seemed fine to my noobish attempts of figuring it out.

Night74
06-13-2005, 04:34 AM
for some reason I keep getting error 2006 when I run world.exe "mysql has gone away"
I have tried rebuilding the database as well as completely removing and redoing everything. I would be greatfull for any help.
also I was wondering if the Vel DB contains all the old kunark DB data as well?
thanks,

vRandom
06-13-2005, 11:02 AM
Ok I might be rather dumb on this Q and over looked the right thread using search and such.

But a couple things.

1. The guide is great, I got it up and am playing on it but I want to now have the server run on my one comp as it has more ram and less CPU power, while I play on the other comp which has alot better Cpu/ and almost as much ram.
Off to search some more and hopefully find my answer for this one.

2. Quest related file error. When I zone into Thurgadina I crash and get perl quest error from Lorekeeper E. I attempted to look at the lines it said was messed up but it seemed fine to my noobish attempts of figuring it out.
Calabeth,
for question number 1:

I run my eqemu on another machine here, this is my set up

on the "server" machine running the eqemu, it also has my database on it, lets say its ip is 10.10.10.10

my boot5zones.bat file looks like this, at lease the parts that get changed
start zoneperl . 10.10.10.10 8780 127.0.0.1

note: the [start zoneperl] might be [start zone] if your using the non-perl version

If your running the database on the same machine as the eqemu then the db.ini shouldn't need changing.

Next to update the database, for example i created an account called goober (hehe, really i did) if i wanted to be able to login using my goober account on a different machine, i would need to update the database with the following

lets say my pc i want to login with is at 10.10.10.11 then i would run the following to update the database
update account set minilogin_ip = '10.10.11.11' where name = 'goober';

if you want to dump your existing database you can use this:
mysqldump -u username -ppassword database_name > FILE.sql

then to import it on the other machine:
mysql -u username -ppassword database_name < FILE.sql

this file could be very big, might take a bit to import (fyi)

for question number 2:
sorry i dont know, just now getting started in messing with the quests, might try deleting the file for now /shrug

Hope that helps :)
vRandom

Calabeth
06-13-2005, 12:05 PM
Hehe thanks, I moved the file outta the way for now and it works fine.

Not understanding the dump reason really. Though all I needed on the comp playing eq was an edit to the eqhost.txt such as host=10.10.10.11:5999

and that would be it. DB,World,minilogin,zoneperl are all on the other comp hehe.

vRandom
06-13-2005, 01:22 PM
Hehe thanks, I moved the file outta the way for now and it works fine.

Not understanding the dump reason really. Though all I needed on the comp playing eq was an edit to the eqhost.txt such as host=10.10.10.11:5999

and that would be it. DB,World,minilogin,zoneperl are all on the other comp hehe.

lol yah forgot that step.... phone rang when i was posting :) it would need to be pointed to the machine hosting

vRandom
06-13-2005, 01:35 PM
1) Commands.pl in zone.exe errors: I dont know where to get a valid file for commands.pl. PEQ father says the file is not required, the program works without it.


notice the troublshooting tips :)

if you dont want the errors create the file and put code below in it (file should be in the directory with world, zone.. etc)

found it somewhere in the forums, but i can't remember where


sub commands_init{}

iwantavr4
06-13-2005, 06:10 PM
Thanks for all the help vRandom, i will try that out and see if it fixes the commands.pl error on mine. Youve been very helpful!

for some reason I keep getting error 2006 when I run world.exe "mysql has gone away"
I have tried rebuilding the database as well as completely removing and redoing everything. I would be greatfull for any help.
also I was wondering if the Vel DB contains all the old kunark DB data as well?
thanks,
when you see mysql has gone away, it usually means your server cannot connect to the database. So somewhere in there you have a problem. It can be a number of places, you could have named the db incorrecctly, you could have not put the right name in the db.ini, your sql could be shut down or not on... I would check to make sure your mysql is running properly and ou didnt acidentally name is something else than what is in your db.ini.

About the velious db, yes it includes all of kunark, i was surprised, but it does.

Also please check the first two posts, i will be updating them as fixes come in to make it the best guide that i can.

Aradorn
06-13-2005, 09:08 PM
ok by know you guys know i got my emu running and been havin fun....thanks i wantavr4 for all the help and guide and others here who have been nice on giving info....

so here goes another question. do quest work or will they need to be set up cause i was gonna do the armor of ro quest for my pally and when i hail the npc they dont say anything

Ghost Fire
06-14-2005, 12:13 AM
(Fix for #2006 Lost connection bug)
code: SET PASSWORD FOR 'usernameforDB'@'localhost' = OLD_PASSWORD('newpasswordhere');

Night74
06-14-2005, 01:45 AM
ok got all fixed seems I still have an error though
when trying to enter world I get disconected server shows the following error
[Debug] unable to convert EQ opcode 0x071e to an emu opcode

Calabeth
06-14-2005, 02:53 AM
For the quests, you might have to make it or check the quest section out to see if anyone has already done it. In your EQemu Directory go into teh Quests folder. From there goto the zone the quest starts in and see if the starting NPC has a *npcname*.pl file there, if not then no quest.

Aradorn
06-14-2005, 03:05 PM
For the quests, you might have to make it or check the quest section out to see if anyone has already done it. In your EQemu Directory go into teh Quests folder. From there goto the zone the quest starts in and see if the starting NPC has a *npcname*.pl file there, if not then no quest.

i checked the load_system.sql file in the quest folder and it has the char names and molds of ro in it for the quest... i dont understand where you mean to go to find the *npcname*.pl is this ingame?

vRandom
06-14-2005, 04:46 PM
i checked the load_system.sql file in the quest folder and it has the char names and molds of ro in it for the quest... i dont understand where you mean to go to find the *npcname*.pl is this ingame?

it should be in the following location, eqemu dir\quests\zonename\npc name.pl

example my quest for north freeport would be in the following: c:\eq_emu\quests\nfreportn\nameofnpc.pl

there should have been a lot of directorys created when you unziped the quests zip file.

vRandom

Aradorn
06-14-2005, 04:57 PM
ok so i should have default.pl, drop_system.sql.drop_users.sql,load_empty_users.sq l, load_system.sql, commands.pl(thanks to above), convert, channelog,

and 129 folders in the C:\EQEmu\Quest


will i need to resource my database cause i did forget to unzip quest zone folders into C:\EQEmu\Quest
just unzipped it now eventhough i have had everything all set up

vRandom
06-15-2005, 02:57 AM
ok so i should have default.pl, drop_system.sql.drop_users.sql,load_empty_users.sq l, load_system.sql, commands.pl(thanks to above), convert, channelog,

and 129 folders in the C:\EQEmu\Quest

will i need to resource my database cause i did forget to unzip quest zone folders into C:\EQEmu\Quest
just unzipped it now eventhough i have had everything all set up

I dont think so on the resourcing the db, just find a npc and hail them, if they talk then the pl files are at lease running or try a quest npc.

note, not all of the npcs say anything...

I havent made it up to actually completeting any quests, or even getting one, got a big project that has to be done in 3 weeks, grrr so my time is way limited now - and i was having so much fun

vRandom

Aradorn
06-15-2005, 03:18 PM
I dont think so on the resourcing the db, just find a npc and hail them, if they talk then the pl files are at lease running or try a quest npc.

note, not all of the npcs say anything...

I havent made it up to actually completeting any quests, or even getting one, got a big project that has to be done in 3 weeks, grrr so my time is way limited now - and i was having so much fun

vRandom

well i read up on the quest says each person that gives the mold has a certain faction to see if u have good enough faction i have to go to the appropriate npc and ask them "am i an honored member" but they never reply
but i have the freportn folder in the eqemu/quest and the chars name is in it with the text for the armor quest

vRandom
06-15-2005, 03:44 PM
sorry i can't be much help on the quest problem Aradorn. Other than making sure the perl version your running is actually executing, i'm not sure otherwise.

There is a guard by the nfp bank or any of them in front of the cleric guild area, (i think) if you can hail them and they say something then i think thats a good test for if the perl is running.

:(

Aradorn
06-15-2005, 03:52 PM
well in my boot5zones it says
[quest] loading perlemb plugins.
[quest] loading perl commands...
[quest]loading perlemb plugins.
[quest] loading perl commands

now will my quest not work if i unzipped it after i set everything up...

i forgot to do it when i was going through all the steps could this be the reason why?

Tulwen
06-17-2005, 01:39 AM
Great Job on the tutorial!!
I'm so close I can smell the character creation screen... but I'm having issues

I've got everything done with one exception. Because I couldn't find a pre 5/11 patch, I just reinstalled my cds (EverQuest Platinum, released last fall) and didn't patch. I run the Minilogin, World and then 5zonebatch and launch the eqgame-patchme shortcut. I get all the way up to logging in and when I login I get a windows FUBAR error saying "World.exe has generated errors and needs to shut down". Could this be because of the version of EQ I am running? Do I need to install an older EQEmu version? If so which one?

Thanks :)

Calabeth
06-17-2005, 04:26 AM
Yes it sounds like the version your trying to run is a mismatch. Even though it was released last fall doesnt mean it will have the most up to date files. The files on Disk are probably the basic files of each when they were first made and still need the patching.

Try finding some of the 6.1 servers that are already up as a few offer a patcher that helps ppl be compatible with playing on them. What ye do is patch to live then run their patchers.

Tulwen
06-17-2005, 12:37 PM
Awesome thanks!!! I'll give it a try :D

iwantavr4
06-17-2005, 05:59 PM
Hey people... STOP PMing me about the patch. I cant help you.

Next PMs i get about it im either going to start reporting or will just delete them without replying. Depending on the mood im in.

This isnt in response to any of hte posts here, just the PMs in my box!

Aydun
06-19-2005, 09:43 AM
Ok I must be much thicker than most, so please do not killed me I read every post on this thread to make sure no one experienced the same problem..

Step 4. I extracted the DBD/DBI etc to their own directories, I go to cmd line and get to their respective directories (the one that contains the .ppd file) i type
install DBD-mysql.ppd
etc etc..

I keep getting this error.
'install' is not recognized as an internal or external command,
operable program or batch file.

you say in PPM type the install line... I'm not sure I follow what PPM is.

Well any insight into this would be much appreciated!

mrea
06-19-2005, 09:50 AM
Before you do that, type PPM

Aydun
06-19-2005, 10:15 AM
Ok I typed:
C:\Documents and Settings\Alan\Desktop\Futility\DBD-mysql-2.9007>PPM install DBD
-mysql.ppd
'PPM' is not recognized as an internal or external command,
operable program or batch file.
I still got the same error, perhaps I can understand the problem more if I understood what PPM is ? thank you for your quick response, and again my apologies to post such a simple problem.

mrea
06-19-2005, 10:19 AM
Did you install Perl correctly? If so, type PPM... once that loads type your "install soandso". Not all in the same command.

Aydun
06-19-2005, 03:43 PM
Hmm, I figured it was an initialization for perl. I ran through the installation just fine and there is a perl folder in my C:\ so I was assuming it went fine. I tried typing PPM first but i got the same error, perhaps i'll try running it again and see what happens, thank you very much for your continued support mrea! It's appreciated :D

Tulwen
06-19-2005, 05:59 PM
You don't type ppm until you are in each directory

Example.

c:\>cd\temp\io-stringy
c:\>ppm
ppm>install io-stringy.ppd
ppm>exit
c:\>cd\temp\DBI
etc. etc.

Aydun
06-20-2005, 03:14 AM
Excellent, I could've sworn I already had tried that before but third times a charm eh! thank you very much everyone *bow*

jrmayii
06-21-2005, 12:56 AM
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.

Ayre
06-21-2005, 10:43 AM
its #castspell #
and #findspell name
not #cast and #spellfind

mrea
06-21-2005, 10:49 AM
#cast works also, Ayre

Sims
06-21-2005, 03:32 PM
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??

drognir
06-21-2005, 10:14 PM
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.

jrmayii
06-22-2005, 03:45 AM
"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).

Aradorn
06-22-2005, 02:55 PM
anyone figure out how to get haste items and haste spells to work?
the only way i can get haste while playing is #haste

32ones
06-22-2005, 07:22 PM
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.

Aradorn
06-22-2005, 10:25 PM
nope gonna have to wait till next emu comes out

Aradorn
06-23-2005, 09:44 AM
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

billibo
06-23-2005, 06:32 PM
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

billibo
06-23-2005, 07:20 PM
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

32ones
06-23-2005, 09:05 PM
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??

iwantavr4
06-24-2005, 12:33 AM
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.

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)

Aydun
06-24-2005, 01:10 AM
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 .

Judice
06-24-2005, 09:52 AM
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 :(

Aydun
06-24-2005, 11:45 AM
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 :\

Judice
06-24-2005, 12:22 PM
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

iwantavr4
06-25-2005, 03:37 AM
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
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
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables' doesn't exist
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...

wooow
06-25-2005, 10:04 AM
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?

Mossfiend
06-28-2005, 04:44 AM
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?

devlor
06-28-2005, 10:10 AM
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. ;)

ruprecht1010
06-29-2005, 06:27 PM
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.

Skyiron
07-02-2005, 06:41 PM
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.

iwantavr4
07-03-2005, 04:34 PM
cd (locatation)
So for instance i unzipped mine to c:\temp\dbi and c;\temp\scalar

i would type:
cd c:\temp\dbi [enter]
ppm [enter]
install dbi.ppm [enter]
exit [enter]
cd c:\temp\scalar [enter]
ppm [enter]
install io-scalar.ppm [enter]
exit [enter]

ShadowVax
07-05-2005, 06:32 PM
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...

duke_nemmerle
07-05-2005, 08:45 PM
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

ShadowVax
07-06-2005, 05:50 AM
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?

iwantavr4
07-06-2005, 07:28 PM
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.

Aradorn
07-09-2005, 02:53 PM
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

Aquelin
07-15-2005, 04:59 PM
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.

duke_nemmerle
07-17-2005, 03:49 PM
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

MysticDeath
07-19-2005, 04:49 AM
nice tutorial on how to do it, i have some errors though, starting a thread bout it... :P

iwantavr4
07-29-2005, 01:08 AM
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. :)

Tharic
08-02-2005, 01:35 AM
http://www.facet42.com/downloads/EQEmu-0.6.1-DR1-Perl.zip
appears to be broken...

Anyone know where else I could find this file?

Tharic

kagegod
08-02-2005, 02:32 PM
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?

Havock
08-02-2005, 04:10 PM
http://www.facet42.com/downloads/EQEmu-0.6.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.

marqmajere
08-04-2005, 04:01 PM
http://www.facet42.com/downloads/EQEmu-0.6.1-DR1-Perl.zip
appears to be broken...

Anyone know where else I could find this file?

Tharic

Not working for me either.

Aretnap
08-04-2005, 09:43 PM
/points at EQEMU6.1DR1 (http://www.steelpsychos.com/eqemu/eqemu_0.6.1_DR1_PERL.rar)

/points at MYSQL (http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.25-win32.zip/from/http://mysql.mirror.redwire.net/)

Carnage_ou812
08-06-2005, 04:21 AM
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 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?

Greyhill
08-06-2005, 04:56 AM
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
08-06-2005, 09:44 AM
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.

-Arctura-
08-07-2005, 12:42 PM
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

kawika
08-10-2005, 06:00 PM
Good call Greyhill, can that be added to the tutorial?

Debacle
08-11-2005, 01:07 AM
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.

Dr Zauis
08-11-2005, 01:07 AM
http://www.facet42.com/downloads/EQEmu-0.6.1-DR1-Perl.zip

Im getting a page not found error..Anywhere else I can find this??

Edit>>Found and working!

EDIT2>>>Not found..Not working! The perl version I found is not loading the quests for some reason..Too bad this file is missing..It might have been my answer..

Wakanna
08-25-2005, 06:35 PM
Yeah... I cant find the file either... the webpage seems to not be hosting the zip anymore.

Anyone got a link?

Ellengos
08-25-2005, 07:52 PM
I am able to log into the game and play on the preferred server, but the server I created does not work.


When I try to run world.exe, I keep getting these two errors:

Error message: 'Version invalid'


and

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

Dr Zauis
08-26-2005, 01:23 AM
Yeah... I cant find the file either... the webpage seems to not be hosting the zip anymore.

Anyone got a link?

Try these links..http://www.eqemulator.net/forums/showthread.php?t=18675

Dr Zauis
08-26-2005, 01:27 AM
I am able to log into the game and play on the preferred server, but the server I created does not work.


When I try to run world.exe, I keep getting these two errors:

Error message: 'Version invalid'


and

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

Im guessing your database isnt right. The first error I dont know about. The second error it seems to me world.exe is trying to load a table called eq variables but the database dont even have the table.

Crow102
08-30-2005, 02:00 PM
Having problems on Step 14 it says that create command is not recoginsed as an internal or external command,opertable program or batch file anyone know why im getting this?

PiboDIE
09-01-2005, 04:44 PM
I can't find spells_us and spells_en files in my EQ game directory. Anybody can upload that files or give me links where i can find it?

Dr Zauis
09-02-2005, 04:07 AM
Having problems on Step 14 it says that create command is not recoginsed as an internal or external command,opertable program or batch file anyone know why im getting this?

You might not be in the right "directory". I think its -uroot or something.
There might be an extra space somewhere..Try typing it different ways.

Dr Zauis
09-02-2005, 04:09 AM
I can't find spells_us and spells_en files in my EQ game directory. Anybody can upload that files or give me links where i can find it?

They are there in your folder. Otherwise they are provided in the packages I have linked to in my previous posts.

PiboDIE
09-02-2005, 07:34 PM
:o I'm really sorry. A have wrong client. I have EverQuest 2.
Whether there is a server for this client?

Dr Zauis
09-02-2005, 07:56 PM
:o I'm really sorry. A have wrong client. I have EverQuest 2.
Whether there is a server for this client?

There is..But its in its first stages..You will need to go to this forum
http://www.eq2emulator.net/forums/
for help with that.

PiboDIE
09-03-2005, 05:36 AM
Thank you.

32ones
09-13-2005, 12:32 PM
Ok, I installed everything ok because I have done work with mysql and dos before. I change every thing, the server boots up fine. When I go to start EQ it says something like. Error d3d9.dll cannot be found. I hope this has nothing to do with todays patch... =( If it is, I will have to look for the back up of EQ I made on sept 11th... =(

Edit**

Ok I got my pre september 13th files and I still get the error.. Whats wrong?!?! Lol is it with my target path? It it currently at
C:\EverQuest\eqgame.exe patchme

EDIT AGAIN**

How could I be so stupid!?!? Lol! I reinstalled windows and forgot to get directx. I got it now it and boots up fine. I hope the server will work thou.

Edit again, again**

I seem to get
Error: Loginserver:connect: 'TCPConnection:connect(): connect() failed. Error: 10060'

It will display that a few times, then display
Setting world to minilogin server type

and after doing that a few times, it then it said something like
connected to LoginServer: 127.0.0.1:599

then when I launce boot5zones it to
EmuShareMem loaded

Then I boot up EQ, typein my ID and PW and it freezes (I can move the mouse, but it stays at the little pop up)

32ones
09-14-2005, 08:09 PM
Sorry for that question, I feel like crying now =(

Polygon_Window
09-27-2005, 08:13 PM
I have some bug questions:

My Server is running very stable (great guide btw)with this configuration, but there are some things, i would like to know how to get them fixed...

The Zoneperl.exe bug

I know...its a known issue, just ignore hit and continue. But perhaps is there a possible patch or file, that patches that bug?
If not...is there any possibilty to get a script running in the background that automatically hits Ignore when the bug message comes up?

Im pretty new to Emu, sorry if my question is dumb, because i dont know what files are really related to do this bug

Belfedia
09-27-2005, 11:31 PM
Use 0.6.2 version you can find guide in :
http://www.eqemulator.net/wiki/wikka.php?wakka=HomePage
don't forget to read all the message in section serverguide :)
0.6.1 is obsolete now :p

Crow102
09-29-2005, 10:42 AM
Started following the tutorial and got stuck on step number 2 does he want me to extract the files from EQEMU 6.2 Original binaries or EQEmu 6.2-DR1-Perl if anyone could help it would be great

tallerin
09-29-2005, 11:51 AM
you extract which ever one YOU what to use. if YOU want perl you extract the perl not the non perl. If YOU want non perl you download and extract the non perl version. Its not that confuseing really the guide is esentially now two guides into one as the perl version and non perl are simular in installation except for the installation of perl ect for the perl version.

Crow102
09-29-2005, 12:08 PM
thanks reason I asked was it never created a DB.ini in my EQ emu folder and I thought I had to use both

Belfedia
09-29-2005, 06:15 PM
Just a recall this tutorial is obsolete for 0.6.2 do not hesitate has to consult that it:
http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6
And put your question in Support forum :)

Crow102
09-29-2005, 09:37 PM
wait now im even more confused that tutorial no longer can be used?

Belfedia
09-30-2005, 12:57 AM
You have a fresh tutorial, in the link on my post for 0.6.2 eqemu guide made by tallerin :)
I think you don't work on a 0.6.1 dr1 server ? i see 0.6.2 in your post ?
this tutorial work with 0.6.1 the tutorial for 0.6.2 is in the wiki :)
http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6

I understand you are confuse; i'm here for some time and i'm lost for many things :) but this entire tutorial section is obsolete (but you can find usefull information inside) and need to be CLOSE (plz one admin make it just read only that was fine).

For question about guide, you just need to post it in the correct support forum , support windows servers (you use windows) support linux servers (you use linux) or support general support if question is right on windows and linux :)

Crow102
09-30-2005, 12:07 PM
okay got it because yeah I was following the 0.6.2 guide from the link ya gave and I guess I was reading your post too fast and I thought you said the linked guide was obsolute already hehe thanks for the help though hopefully I can get this thing set up today.

Netdrifter
10-13-2005, 02:23 PM
ok server up and running now couple probs so far my toons arent getting hps back an i get the petstruct error vc++ debug thing scanned through this post but havent seen anything as of yet also gates in neriak wouldnt open

Belfedia
10-13-2005, 08:41 PM
Hello you don't read my message ?
Plz this is the tutorial section :)

You just need to post it in the correct support forum , support windows servers (you use windows) support linux servers (you use linux) or support general support if question is right on windows and linux.

I hope with that many people can help you :)

Viper2904
10-16-2005, 07:24 AM
ok, i have followed the directions word for word the best i could and read a little. i get the same exact error dragnir got before (think that was his name).

I get an error 2 when sourcing the various bin files, i copy and pasted the original sqls that were in the directory and copy and pasted the names & information for each so they would automatically be sqls. I sourced the first 2 fine, then starting with items-0.6.0-DR2-0.6.1-DR2-convert.sql "or something" and the rest to follow i got errors. The files are all in the bin folder and are NOT in other folders, i checked that after reading his post. I know im running the EQ current patch but i am not sure if that would affect anything up to this point. I dont know how to like.. downgrade to a different version and i wanted to get this done first. Im sure i can read somewhere to figure out what to do as far as patching, but if i need to do that first... well, i dont know what i need to do at this point, just following directions.

Thanks in advance

Belfedia
10-16-2005, 08:47 AM
Sorry to be not polite :( this is just same question on many many many post with same answer... i'm little tired to repeat hehe ;)
BUT READ THREAD BEFORE POST
Many message speak about EQEMU limitation, version, etc...
If a message DO NOT PACH ON 9/13 OR LATER is on red on the top of forum this is not for decorate :)
If you read some post just before your on this thread you have some answer also !

Plz read !!!

Viper2904
10-17-2005, 12:15 AM
Ok, sorry, i just thought that i could work on this before i figured out how to fix my version. Didnt realize that it had anything to do with the Everquest directory.

I cannot find any information on how to patch to pre 9/13. I installed:
Everquest - original
Luclin
Kunark
Velious
Planes of Power
Then I ran the patcher

I seen a post earlier about wiki but still kinda oblivious to what that is, seems like another tutorial and/or user documentation webpage.

I see that it says not to patch after 9/13 but i kinda missed on how to do that, if i only have the original everquest - luclin - kunark - velious - planes of power version do i just use the version checker and match that to the Eqemu versions? I am sorta lost here and i dont know a whole lot about what i am doing. I just want to be able to run the quests and enjoy the lore through the velious expansion, i dont care for pop+. I am guessing i have to setup like a host for my wife to also be on at the same time, but still i am a noob...

Thanks in advance

Belfedia
10-17-2005, 01:55 AM
To be a newb on eqemu is'nt a problem :) when i start here i'm very newb...
But ! if say DO NOT PATCH on 9/13 or later that because they are no LEGAL solution, player have this patch are happy, other can't play. And i'm sure you have read the forum rules about the CENSURED, you can find some solution easy, but speak about it, link it EVEN IN PM is forbidden here and Against forum's rules.

Sakrateri
10-17-2005, 08:02 AM
Heres how IT works :

1: You buy the game and install
2: You connect to EverQuest and a patcher starts
3: When patcher is finished you hit PLAY and it takes you into the game

The previous is the way to play EQ Live . Otherwise know as the OFFICIAL EverQuest. The following is the way to play EQEMU:

1: The Devs say "we are compatible with live"
2: Everyone patches to live
3: Everyone changes their eqhost.txt to correspond to the proper EQEMU login
4: Everyone clicks on the eqgame.exe that they sent to desktop with the patchme fix on the end of it
5:Then hopefully everyone has fun

And then Everquest live has another patch ! Ooops did we all remember to make a backup of the version of EverQuest we were playing EQEMU with before we hit the shortcut to EverQuest and it started patching to live??
Well if you did not and you happened to patch to live then guess what? Well you CANT play EQEMU until the Devs once again say that it is compatible with live.

You can do a fresh install all day long with whatever discs you have laying around ....EQ Platinum , Kunark , Half-Life2, Doom 3,......Whatever you wish but it will still NOT allow you to play on the EQEMU servers ....But why you ask ? Well because in those patches you did miss out on between whatever discs you did install and the date they say do NOT patch after there were some important files that you need installed from EQLive that you can NO LONGER get. It does not matter if you do a version check on your Everquest you have installed , I can tell you that if its a fresh install it will NOT work.

I hope this clears some of the confusion you are having with this or at least answers a question or two , It all is rather confusing especially for those that have not been around it , This is in no way meant to be a rant nor a flame just hopefully a simplified answer to a question asked very often.

Swyft01
11-06-2005, 02:22 PM
Sorry all I am very very new to this, I'm trying to follow the guide posted in this thread for 0.6.2 but the second step doesn't have a link and I can't find the download on sourceforge..does anyone know where I can download:
a EQEmu 6.2-DR1 Version to Download

Belfedia
11-07-2005, 07:33 AM
explore : http://www.eqemulator.net/wiki/wikka.php?wakka=HomePage
you find some links...
explore just first page of site : http://www.eqemulator.net/main.php
you find sourceforge... on files link

Hardhat
11-11-2005, 12:10 PM
This looks to be one of the best guides to this current date, and mind you there are a lot out there, I have used most if not all of them.

If you are new as of the last few days.
THIS IS USELESS, AS YOU CANNOT GET THE NEEDED FILES, UNLESS YOU HAVE A FRIEND WITH THEM!

If you have patched EverQuest anytime in the last several month's.. You are a screwed pooch.

Yes, that is correct all you uber-banned MQ2 users! Wait with the rest of us!:D