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

[iwantavr4]

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/M...m/pick#mirrors -MySQL Download v 4.0.23
http://downloads.activestate.com/Act...SWin32-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/PPMPackag...s/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/PPMPackag...sql-2.9007.zip -DBDMysql Perl Package(this file too, see above.)
http://ppm.activestate.com/PPMPackag...ingy-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) -All Maps(possibly not necessary, huge download 300mb
http://www.facet42.com/downloads/EQE...1-DR1-Perl.zip -EQEmu Upgrade for 6.1Perl Version
http://prdownloads.sourceforge.net/e...Perl-Win32.zip -The remaining EQEmu Config files
http://prdownloads.sourceforge.net/p...ious-beta1.zip -Velious beta Database from PEQ
http://sourceforge.net/project/showf...roup_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/e...1.zip?download -Minilogin 6.1
http://cvs.sourceforge.net/viewcvs.p...rt.sql?rev=1.2 -Upgrades EQEmu items from 60dr2-61dr1(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.p...ql?rev=1.1.2.1 -upgrades something in database(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.p...FG.SQL?rev=1.2 -something else in database(right click, save as .sql and type 'All files')
http://cvs.sourceforge.net/viewcvs.p...ems.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
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]

If you use Minilogin use the following steps next:
(If you aren

[HalberdBlue]

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]

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]

OK I finished doing everything, it works great! Nice work!

[iwantavr4]

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

[tancor]

nm got it worked out

[rempty]

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

[Aradorn]

the default and plugin for eqemu is that supposed to be saved as a .sql also or .pl? nevermind i figured it out

[Grim]

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]

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]

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]

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

[drognir]

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

[Aradorn]

did you make sure all those files are in c:\mysql\bin folder. make sure there are no folders inside the bin