Okiedokie, EQEmu wins for tonight, my face is about to explode im so tired from reading all these blathering posts

~
I got my server online, so thats good, but I still have the 1017 error. Wasnt sure if it was due to my usage of a 0.5.8 build server so just to take precautionary measures I went ahead and upgraded it to a 0.6.0-DR2 (whatever the hell that means, I assume since 6.0 > 5.8 that the 6 is better, plus it had some more files. *shrug* Just being fecetious)
http://www.eqemulator.net/forums/viewtopic.php?t=1021 <-- Seems to me that my answer is being tiptoed around in here but I have read the entire thread 3x now and I still dont see the key.
BUT, since all my stuff works up to what seems to be my IP conflict, I am going to recap, in STUPID_MONKY_NON_BRAINHEAD instructions =)
First and foremost, I visited:
http://www.eqemulator.net/forums/viewtopic.php?t=17531
Make a folder on your desktop labeled "EQEmu Server Downloads"
Download all this crap to that folder:
http://dev.mysql.com/get/Downloads/M...m/pick#mirrors (updated from post, thats ok tho)
http://adam.eqemulator.net/11-09-04_Compiled_Perl.zip <--Perl baybee!
http://downloads.activestate.com/Act...SWin32-x86.msi <--install this
http://www.engelschall.com/~sb/downl...2-bin-0000.zip <--NMAKE.exe
Of course you can pick a database (DB) but just download
http://www.peqserver.com/download.php?id=773 <--Kunark update
http://home.comcast.net/~molimo140/default.pl <--default.pl
http://home.comcast.net/~molimo140/plugin.pl <--plugin.pl
when he says "additional DB files.." you dont know what to download, so just download these
http://cvs.sourceforge.net/viewcvs.p...1&view=log adventures
http://cvs.sourceforge.net/viewcvs.p...2&view=log AA's I assume
http://cvs.sourceforge.net/viewcvs.p...1&view=log *shrug*
http://cvs.sourceforge.net/viewcvs.p...1&view=log Doors, pretty important
http://cvs.sourceforge.net/viewcvs.p...1&view=log GRID, omg grid
http://cvs.sourceforge.net/viewcvs.p...1&view=log trader
http://cvs.sourceforge.net/viewcvs.p...1&view=log traps
http://cvs.sourceforge.net/viewcvs.p...2&view=log trib levels
http://cvs.sourceforge.net/viewcvs.p...2&view=log tribs
Where did I come up with all those SQL files? well, when installing other junk down the road, I noticed errors saying they couldnt find these files, so I had ya get em ahead of time!
OK now here comes a hard part...
right click this link
http://search.cpan.org/author/ERYQ/I...b/IO/Scalar.pm then click "save target as" ...where it says HTML document, click the arrow and select "all files." Once thats done, add ".pm" to the "scalar" and press save. (should be saving Scalar.pm)
right click this link
http://search.cpan.org/author/ERYQ/I.../IO/WrapTie.pm then click "save target as" ...where it says HTML document, click the arrow and select "all files." Once thats done, add ".pm" to the "scalar" and press save. (should be saving WrapTie.pm)
whew that was rough.. onward ho.
Download
http://www.rogean.com/maps/maps.zip its a doozy tho, take a bio break or get some food, youre looking kindof pale.
VERY HELPFUL GUIDE
http://eqemu.sourceforge.net/shawn319/Guidebook12.rar DOWNLOAD THIS DAMNIT
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Now time to start installing.
1- Unzip mysql-4.0.22-win.zip and extract all files to C:\MYSQL
2- Unzip 11-9-04_Compiled_Perl.zip to C:\EQEMU
3- Unzip maps.zip to your C:\EQEMU\Maps directory
4- Open up your EverQuest directory and find Spells_us.txt
Copy that file and paste the copy in C:\EQEMU
5- Install ActivePerl-5.8.2.808-MSWin32-x86.msi
6- Unzip contents of perl-5.005_03-win32-bin-0000.zip into C:\perl\bin
7- Copy Scalar.pm and WrapTie.pm to C:\perl\lib\io directory
=========================================
8- Now time to Install the harder stuff. . =
=========================================
Open a Command Prompt (aka DOS prompt) by clicking Start menu on your taskbar, then click run. Type cmd and hit enter
In the black box, type
Then type
Code:
perl -MCPAN -e shell
It will ask you if you want to configure Manually. Say no.
When that is done, type
A bunch of garbled messages will go through the command prompt. This could take a bit.
Once complete it will say Install OK (or something to that effect).
Quote:
IF YOU GET AN ERROR MESSAGE saying it failed to install, It should say something at the bottom as an alternate method of installing IO::Scalar. Type what it says to.
|
To make sure IO::Scalar is installed properly, type
Code:
perl -MIO::Scalar -e "print 'Installed'"
If it was installed properly, you should see the word "Intalled" on your command prompt.
9- Copy Plugin.pl to C:\EQEMU
9.a-Create a new folder in C:\EQEMU called Quests
10- Copy default.pl into the Quests folder you just created.
11- Extract peq_kunark_keep_accts_release-1099244297 to C:\MYSQL\bin
12- Copy Adventures.sql, aa_actions.sql, aa_swarmpets.sql, doors.sql, grid.sql, trader.sql, traps.sql, tribute_levels.sql, and tributes.sql to C:\MYSQL\bin
################################################## ################################################## ###################
Here's where it gets hard again, prepare for brain deterioration =D
-------------------------------------------------------------------------------
1- Click on your Start Menu on your taskbar, then click run, then type c:\mysql\bin
2- Doubleclick WinMySQLAdmin.exe
NOTE: A dialog box will appear querying you for a username/password. Make sure you use something you will remember. Perhaps.. user=BEAVIS / pass=BUTTHEAD I know thats redundant, but its important.
You can go ahead and close that, or leave it open, doesnt matter.
BIG STEP - 3- Click Start button on your taskbar, select run, and type cmd
(3a) in the Command (DOS) Prompt, type:
then type:
Code:
mysql -u root mysql
This will put you in the MySQL program dialog. you should have a prompt which looks like:
Now.. Lets assume that the database you will be making is named
EQ, your favorite username is
BEAVIS, and your favie password is
BUTTHEAD. Type this string exactly:
Code:
GRANT ALL PRIVILEGES ON
EQ.* TO
BEAVIS@localhost IDENTIFIED BY
'BUTTHEAD' WITH GRANT OPTION;
If you typed it all out correctly, inluding the apostrophes ' and semicolon ; you should get this message:
Code:
Query OK, 1 Rows Affected, (0.0)sec
If you happen to get an ERROR, poke yourself in the eye because you just fatfingered something. Restart from
BIG STEP -3- and try not to fatfinger this time =)
Now, since you got it right this time, youll still have a command prompt in front of you. Type this:
Code:
Create database EQ;
This creates your mysql "EQ" database. It should kick back out:
Code:
Query OK, 1 Rows Affected, (0.0)sec
You gain experience!
Now type:
WOW yer on a roll now! Now that you are "use EQ," any changes you make from here on will affect the database EQ. You should see this message:
Now, type:
Code:
source peq_kunark_keep_accts_release-1099244297.sql;
Yeah, its a bitch. It might kick back a bunch of errors, i think because of the underscores and the dash, That is what happened to me, SOOO I just renamed the file in the c:\mysql\bin folder to:
peq.sql *chortle*
Now, it will run thru a bunch of code garble so fast that only Merth the Beeker Muppet could decipher it, so take a break, you made it this far. Go grab a beer =)
Now thatyou learned how to source, do the same thing with the next slab of .SQL files...
Code:
source Adventures.sql;
then
then
then
pant...
then
then
then
Code:
tribute_levels.sql;
aand theeennnn....
Whew! You having fun yet? I sure am! Now imagine if you didnt download all those files and had to go back thru all those steps. Better off doing them all at once I say!
Now, before we get into this next hoonanner, you are going to want to know your internal and external IP addresses. How do you find this out? Oh its actually quite easy! First of all, Click your Start Button on your taskbar, click run, and type... you guessed it! CMD! In the command prompt, type:
You should get something to the likes of this back:
Code:
IP Address. . . . . . . . . . . . . . . . . . :68.217.134.200
Subnet Mask . . . . . . . . . . . . . . . . :255.255.255.0
Default Gateway . . . . . . . . . . . . . :68.217.000.0
Now, your INTERNAL IP address is that top number. And to my understanding, it is important that your subnet mask reads 255.255.255.0 ...and if it reads 255.0.0.0 then yer screwed and I dont know what to tell ya. *sadface* Youll have to spend months searching the forums for the answer.
To get your EXTERNAL IP address, go to
www.whatismyip.com ...simple.
Enter in this next string to enable minilogin on your server:
Code:
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server ');
and then type:
Code:
alter table account add minilogin_ip varchar(32) not null;
Now, with just that code alone, you would have the server allll to your lonesome. Now I just know you didnt go thru all this trouble so you could be a recluse... you want some friends to be able to see your grand masterpeice too, so in order to allow them to play, insert this string... But prior to entering it, you need to know what to put in it. ACCOUNT_NAME_HERE being the user name you/others use to log into the server select screen. 250 is the GM status, and of course, theres the internal IP address.
Code:
insert into account (name,status, minilogin_ip) values('ACCOUNT_NAME_HERE',200,'127.0.0.1');
For instance, I would write it for me as such:
EXAMPLE insert into account (name,status, minilogin_ip) values('pooky',200,'68.217.134.200');
EXAMPLE
0 - Legit
10 - Semi-Legit
20 - Non-Legit
60 - Guide ......................... Status Pyramid
80 - GM-Quest Troupe
100 - GM-Admin
150 - GM-Lead Admin
200 - GM-Mgmt <--- SERVER OP, the one you want for yourself.
Guess what.. now type:
Done there! Now we get to play with the c:\EQEMU folder we have been neglecting.
on your desktop, right click anywhere, and choose to make a new text document. dont name it anything. open it up and type:
Code:
sub commands_init {}
Now Select File --> Save as... -- > then where it says Save as type.. Click the arrow and change it to All files. Save the file as
commands.pl Now copy that file to your c:\EQEMU directory.
Now, if youre feeling pretty good about yourself, you can feel free to open up the Addon.ini file that is in your C:\EQEMU folder.
Each of the numbers represents a status from the Status Pyramid Just a little ways up from here. *remember the minilogin status? Yep, each of those numbers can be changed to affect how your server plays. A tightly sealed "EQLive-like" server would have no 0's for any of the access commands, while a "Liberal Non-Legit Cheater" server would probably have most commands near the 0-20. I will post it here for convenience:
#Addon release file
Code:
[CommandLevels]
$MAXCLIENTS=25
@NPCSPELLS=8
!setaaxp=100
!setaapts=100
!level=10
!damage=100
!heal=10
!npcspecialattk=100
!kill=100
!timeofday=80
!date=80
!haste=100
!weather=80
!shutdown=200
!setxp=100
!summonitem=10
!itemsearch=0
!finditem=0
!search=0
!spawn=10
!delacct=200
!size=80
!worldshutdown=200
!chat=200
!appearance=150
!zoneshutdown=150
!zonebootup=150
!emote=80
!summon=100
!kick=150
!mana=10
!npcloot=80
!findspell=20
!spfind=20
!castspell=20
!cast=20
!invul=80
!invulnerable=80
!setskill=20
!setskillall=20
!setallskill=20
!save=100
!depop=100
!depopcorpses=100
!depopzone=100
!repop=100
!spawnstatus=100
!listnpcs=100
!listnpccorpses=100
!listplayercorpses=100
!deletenpccorpses=100
!deleteplayercorpses=150
!showbuffs=100
!nukebuffs=100
!hideme=80
!deletecorpse=150
!sendzonespawns=200
!flymode=20
!race=20
!texture=10
!gender=10
!zheader=80
!zsky=80
!zcolor=80
!zcolour=80
!zuwcoords=100
!zsafecoords=100
!zclip=80
!zsave=200
!npccast=80
!dbspawn2=200
!npctypespawn=10
!attack=150
!zstats=80
!lock=150
!unlock=150
!motd=150
!makepet=20
!crashtest=201
!showpetspell=250
!freeze=100
!unfreeze=100
!pvp=100
!permaclass=80
!permarace=80
!permagender=80
!gm=100
!gmspeed=100
!movechar=100
!title=100
!copychar=200
!serverinfo=201
!npcstats=80
!memspell=100
!zone=10
Now open up the DB.ini file in your C:\EQEMU directory. It should look like this:
Code:
# READ README.TXT!
[Database]
host=localhost
user=BEAVIS
password=BUTTHEAD
database=EQ
### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.
I know you remember your favorite username and password! Just enter them in the user= and password= areas. Very simple. Save.
Now open up the LoginServer.ini file in your C:\EQEMU folder. This one is slightly tricky, but relatively easy.
Code:
### --- This file tells world.exe what loginserver to connect to.
### --- Leave the account and password field BLANK.
### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.
### --- NOTE: the word "Server" is added to each server automaticly.
# READ README.TXT
[LoginServer]
loginserver=localhost
loginport=5994
worldname=The name you want for your server goes here
worldaddress=localhost
locked=false
account=
password=
[WorldServer]
Defaultstatus=0
Unavailzone=
[ChatChannelServer]
worldshortname=
chataddress=
chatport=
[LoginConfig]
ServerMode=standalone
ServerPort=5999
The only things you need to worry about at this current time is the wordname and the locked fields. Worldname is what you want your server to be named. Locked is duh, whether its locked or not. USAGE: True/False
Now, open up boot5zones.bat by RIGHT CLICKING IT and selecting EDIT. Otherwise youll just run it and get 5 command prompts.
Right click and choose select all, and press backspace to delete all that garbage out of there, we dont need to mess with that crap thanks to our friend MUUSS!!!!! for making an automatic script for us!! Simply copy the script below, and paste it into the boot5zones.bat file.
Code:
REM: ****Read this first!!!****
REM: This file requires your real IP in the place of "EXTERNAL_IP_HERE" when you are connecting
REM: To the EQEmu Loginserver.
REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1
REM: If you still get errors try using localhost instead of 127.0.0.1
REM:--------------Start-----------------------
@echo off
REM >> Update INTERNAL_IP with the IP address used by YOUR server on YOUR lan
set INTERNAL_IP=192.168.0.2
if NOT exist spells_en.txt goto NOSPELL
for /f "tokens=1-7 usebackq delims=:. " %%a in (`ipconfig ^| find "IP" ^| find "ress" ^| find /v "0.0.0.0" ^| find /v "%INTERNAL_IP%"`) do set EXTERNAL_IP=%%d.%%e.%%f.%%g
echo External ip for this system is %EXTERNAL_IP%, internal is %INTERNAL_IP%
start zone . %EXTERNAL_IP% 7995 %INTERNAL_IP%
start zone . %EXTERNAL_IP% 7996 %INTERNAL_IP%
start zone . %EXTERNAL_IP% 7997 %INTERNAL_IP%
start zone . %EXTERNAL_IP% 7998 %INTERNAL_IP%
start zone . %EXTERNAL_IP% 7999 %INTERNAL_IP%
exit
cls
:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE
REM:---------------END------------------------
That right there is just simply amazing. /sniff
Now, make sure your EQHost.txt file which is in your EverQuest directory, reads as such:
Code:
[Loginserver]
host=newlogin1.eqemulator.net:5994
Right click the file, select properties, and check READ ONLY. This is one of the main reasons for problems loading up EQEmu.
Now you are ready to rock and roll!!
1) Open up your C:\EQEMU folder, doubleclick world.exe and let it finish loading.
next...
2) Open up your C:\EQEMU folder, doubleclick boot5zones.bat and let the 5 command prompts load.
3) Make a new shortcut on your desktop by right clicking and selecting new shortcut...
4) Copy and paste the following code into your shortcut's destination path:
Code:
"C:\Program Files\Sony\EverQuest\eqgame.exe" patchme
5) Doubleclick your shortcut, Log in, and kick some ass!
================================================== ================================================== ===============================
I would like to thank all the folks on the
www.eqemulator.net forums for the comprehensive, massive amount of collective information. Some of you guys make me feel like an ape banging my computer with a rock you're so smart. ><
IE: see:
http://www.eqemulator.net/forums/viewtopic.php?t=9201
Especially thanks to Merth, Melwin, Doodman, 1boppoom1 (for the majority of this guide), Xentar, hoppy02...
Muuss for the script
Spike for the:
Quote:
well if you want the complete newbie, beginners version of what he's trying to say is....
|
Cuz damnit jim that made it all fall together!
and sdabbs65 for putting up with my ass and letting me spawn mobs that multiply faster than cells. :lol:
I hope you guys think that this is allright for being a compilation of what I learned in 2 days. I just felt the need to spread the knowledge I learned in at least a teeny bit less technical way =)
aka: so retards like me go, "og? og! oggggg!! uh uh uh.. LOADING...PLEASE WAIT..."
