6.0 Perl Server DR2 FULLY WORKS

[1Boppoom1]

THIS GUIDE WILL REQUIRE SOME TIME AND SOME COMPUTER KNOWLEDGE

EDIT::Thanks to Malignus Wingnut for writting the base of this tutorial...

Minilogin Setup - Windows XP or later

this guide assumes you are using the database eq and the Kunark DB

Downloads:

1) MySQL - used for database editing.

MYSQL Mirrors MYSQL 4.1 not supported

2) EQEmu 6.0 - Perl Enabled

EQEMU 6.0 - Perl Enabled

3) Active Perl - Used for writing quests. Perl 5.8

Avtive Perl 5.8

4) NMAKE

NMAKE

5) Databases:

Kunark Update or Fresh

6) Default.pl

Default.pl

7) Plugin.pl

Plugin.pl

8) Additional Database Files

If you are using the Kunark DB download aa_swarmpets.sql. aa_actions.sql, and traps.sql from

aa_swarmpets.sql , aa_acions.sql , traps.sql

9) Scalar.pm and WrapTie.pm

WrapTie.pm


WrapTie.pm

10) Maps.zip

Maps.zip

---------------------------------------------------------------

STEP ONE: MAKEING tribute.sql FILE and tribute_levels.sql FILE

1) Create a new text document and name it tributes.sql (a prompt will appeare asking if you want to change the file name extension. Click Yes)

2) Now right click the file created and click edit or open with notepad. Once open paste the following into the file.

CREATE TABLE tributes ( 
id INT UNSIGNED AUTO_INCREMENT, 
name VARCHAR(255) NOT NULL, 
descr MEDIUMTEXT NOT NULL, 
PRIMARY KEY(id) 
); 

INSERT INTO tributes (id,name,descr) VALUES(1, 'Aura of Clarity', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(2, 'Vengeful Aura', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(3, 'Power of Will', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(4, 'Bulwark of Honor', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(5, 'Arm of Strength', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(6, 'Body of the Brute', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(7, 'Rabbit\'s Song', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(8, 'Juggler\'s Hands', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(9, 'Sage\'s Advice', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(10, 'Sage\'s Knowledge', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(11, 'Glowing Beauty', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(12, 'Strength of Body', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(13, 'Strength of Mind', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(14, 'Replenishing Body', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(15, 'Harmony of Drums', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(16, 'Harmony of Wind', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(17, 'Harmony of String', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(18, 'Harmony of Horns', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(19, 'Chorus', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(20, 'Concerto', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(21, 'Strength of Will', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(22, 'Visions of Suffering', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(23, 'Twinge of Pain', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(24, 'Expeditious Aid', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(25, 'Persistent Boon', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(26, 'Power of Sight', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(27, 'Power of Recovery', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(28, 'Power of Conservation', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(29, 'Power of Alacrity', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(30, 'Visions of Command', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(31, 'Commanding Presence', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(32, 'Swift Arms', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(33, 'Power of Suffering', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(34, 'Gills of the Bass', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(35, 'Candlelight Vigil', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(36, 'Sight of the Falcon', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(37, 'Gift of the Enchanter', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(38, 'Ethereal Protection', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(39, 'Blazing Shield', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(40, 'Insulation', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(41, 'Antibody', 'No Text Collected!'); 
INSERT INTO tributes (id,name,descr) VALUES(42, 'Antidote', 'No Text Collected!'); 


#Stupid mysql wont let you insert the value 0 into a INT UNSIGNED AUTO_INCREMENT field 
UPDATE tributes SET id=id-1;

3) Save and quit the editor

4) Now repeat the steps 1 and 2 again but name the file tribute_levels.sql and paste this into the file

CREATE TABLE tribute_levels ( 
tribute_id INT UNSIGNED NOT NULL, 
level INT UNSIGNED NOT NULL, 
cost INT UNSIGNED NOT NULL, 
item_id INT UNSIGNED NOT NULL, 
PRIMARY KEY(tribute_id,level) 
); 

INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,20,5,56300); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,30,5,56301); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,40,12,56302); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,50,20,56303); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,60,29,56304); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,45,5,56305); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,50,13,56306); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,55,20,56307); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,60,27,56308); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,65,33,56309); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,20,4,56310); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,40,5,56311); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,50,12,56312); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,60,20,56313); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,10,6,56484); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,20,1,56314); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,30,3,56315); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,40,7,56316); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,50,13,56317); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,60,27,56318); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,10,6,56319); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,20,1,56320); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,30,3,56321); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,40,7,56322); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,50,11,56323); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,60,15,56477); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,10,6,56324); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,20,1,56325); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,30,3,56326); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,40,7,56327); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,50,11,56328); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,60,15,56478); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,10,6,56329); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,20,1,56330); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,30,3,56331); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,40,7,56332); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,50,11,56333); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,60,15,56479); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,10,6,56334); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,20,1,56335); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,30,3,56336); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,40,7,56337); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,50,11,56338); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,60,15,56480); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,10,6,56339); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,20,1,56340); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,30,3,56341); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,40,7,56342); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,50,11,56343); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,60,15,56481); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,10,6,56344); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,20,1,56345); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,30,3,56346); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,40,7,56347); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,50,11,56348); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,60,15,56482); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,10,6,56349); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,20,1,56350); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,30,3,56351); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,40,7,56352); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,50,11,56353); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,60,15,56483); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,10,6,56476); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,20,1,56354); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,30,3,56355); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,40,7,56356); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,50,11,56357); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,60,15,56358); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,10,6,56475); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,20,1,56359); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,30,3,56360); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,40,7,56361); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,50,11,56362); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,60,15,56363); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,20,5,56369); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,30,5,56370); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,40,12,56371); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,50,20,56372); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,60,29,56373); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,30,3,56374); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,45,10,56375); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,60,13,56376); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,30,3,56377); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,45,10,56378); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,60,13,56379); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,30,3,56380); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,45,10,56381); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,60,13,56382); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,30,3,56383); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,45,10,56384); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,60,13,56385); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,30,3,56386); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,45,10,56387); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,60,13,56388); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,55,3,56389); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,60,30,56390); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,65,39,56391); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,10,6,56485); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,20,1,56392); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,30,3,56393); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,40,7,56394); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,50,11,56395); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,60,15,56396); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,20,4,56397); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,40,5,56398); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,50,12,56399); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,60,20,56400); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,20,4,56401); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,40,5,56402); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,50,12,56403); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,60,20,56404); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,20,4,56405); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,40,5,56406); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,50,12,56407); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,60,20,56408); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,20,4,56409); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,40,5,56410); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,50,12,56411); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,60,20,56412); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,20,4,56413); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,40,5,56414); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,50,12,56415); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,60,20,56416); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,20,4,56417); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,40,5,56418); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,50,12,56419); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,60,20,56420); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,20,4,56421); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,40,5,56422); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,50,12,56423); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,60,20,56424); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,20,4,56425); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,40,5,56426); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,50,12,56427); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,60,20,56428); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,20,4,56429); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,40,5,56430); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,50,12,56431); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,60,20,56432); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,20,4,56433); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,40,5,56434); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,50,12,56435); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,60,20,56436); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,20,5,56437); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,30,5,56438); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,40,12,56439); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,50,20,56440); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,60,29,56441); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,20,4,56442); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,30,5,56443); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,40,12,56444); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,50,20,56445); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(34,20,1,56446); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(35,20,1,56447); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(36,20,1,56448); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(37,50,1,56449); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,20,5,56450); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,30,7,56451); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,40,10,56452); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,50,14,56453); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,60,18,56454); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,20,5,56455); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,30,7,56456); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,40,10,56457); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,50,14,56458); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,60,18,56459); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,20,5,56460); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,30,7,56461); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,40,10,56462); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,50,14,56463); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,60,18,56464); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,20,5,56465); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,30,7,56466); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,40,10,56467); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,50,14,56468); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,60,18,56469); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,20,5,56470); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,30,7,56471); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,40,10,56472); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,50,14,56473); 
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,60,18,56474); 

#Stupid mysql wont let you insert the value 0 into a INT UNSIGNED AUTO_INCREMENT field 
UPDATE tribute_levels SET tribute_id=tribute_id-1;

4) save and quit the program or editor.
----------------------------------------------------

STEP TWO: Installing Stuff

1) Install MySQL, run the program I had you download.

2) Extract the contents of 11-9-04_Compiled_Perl.zip to C:\eqemu (you will need a previous copy of the server in the folder)

EDIT:: unzip maps.zip to your C:\EqEmu\Maps directory

Also copy spells_us.txt, and spells_en.txt from your Everquest directory to C:\EQEmu.

3) Install Perl 5.8

4) Copy NMAKE (downloaded above) into C:\perl\bin

5) Copy Scalar.pm and WrapTie.pm to you C:\perl\lib\io directory

6) Install IO::Scalar

Open a Command Prompt (Start menu -> run -> type cmd -> hit enter

type

		cd C:\perl\bin

Then type

 
		perl -MCPAN -e shell

It will ask you if you want to configure Manually. Say no.

When that is done type

 

		install IO::Scalar

A quite a few things will go through the command prompt. This may take serveral minutes.

Once complete it will say Install OK (or something to that effect).

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

 

		perl -MIO::Scalar -e "print 'Installed'"

If it was installed properly, you should see the word "Intalled" on your command prompt.

If you are having trouble installing IO::Scalar, and you have typed 'install IO::Scalar' into cmd prompt and it still refuses to install, visit http://search.cpan.org./

NOTE:: This is NOT fully tested and may/may not work for you.

7) Copy necessary perl files

Copy Plugin.pl to your C:\EQEmu directory

Create a new folder in your eqemu directory called Quests.

Copy default.pl into the quests directory.

8) Extract your database that you downloaded to C:\mysql\bin

9) copy all of the additional sql files you downloaded and created to C:\mysql\bin (traps,tribute,tribute_levels)

-----------------------------------------------------

STEP THREE: Setting up your database

1) Go to C:\mysql\bin and run WinMySQLAdmin.exe (mysql v. 4.1 NOT SUPPORTED)

A window should pop up asking you for a username and a password. Pick both and write them down, you will need them later.

You can now close this.

2) In C:\mysql\bin, run mysql.exe

Type into the window:

 

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

Replace Username with the username you selected previously and do the same with password.

It should say something like:

 

	Query OK, 1 Rows Affected, (0.0)sec

Note: If you get an error when typing the grant all privileges line:

1) Make SURE you copied the line of code EXACTLY as written and changed username/password. (you need the apostrophes around the password. for example: 'example', not "example", nor example.)

2) Try opening a command prompt. Type:

 
			
			CD C:\mysql\bin

then type

 

			mysql -u root mysql

And proceed to type the grant all privileges command again.

Now here are a few database thing we need to create and do:

Now type in the same command window:

			Create database eq;

After that it Should say

 

			Query OK, 1 Rows Affected, (0.0)sec

Next type:

 

			Use eq;

All changes made will be made to the database that is being used.

After that it Should say

 
			Database Changed.

Now type:

			source PEQ_Classic_058.sql;

The following will fly by but will eventually stop (this will take time)

 

			Query OK, 1 Rows Affected, 0.0sec

Wehn finished type

			source aa_swarmpets.sql;
			
			source aa_actions.sql;

			source tribute.sql;

			source tribute_levels.sql;

when that has finished sourcing in type the following commands to enable minilogin on your server

INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server ');

then

alter table account add minilogin_ip varchar(32) not null;

to allow other incoming connections play on your server type the following:

insert into account (name,status, minilogin_ip) values('accountnamehere',250,'127.0.0.1');

Where it says 'accountnamehere' put in your account name. Change '250' to what game level status you want them/you to be( listed at bottom of page) Last but not least their ip#

for example:

insert into account (name,status, minilogin_ip) values('1Boppoom1',200,'XXX.XXX.XXX.XXX');

Now you can close this command prompt!!! YAY Type:

	
			quit

And it will close.



------------------------------------------------------------------

STEP FOUR: Setting up your EQEmu folder

1) create another text file called it commands.pl

a) yes change the file extention

b) edit the file with notepad and paste this into it:

sub commands_init {}

c) save and close the file

2) Go to c:\eqemu

copy the file commands.pl you just made to your C:\EqEmu directory

open addon.ini

addon.ini should look like this (legit server):

#Addon release file

[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

You can change the numbers around to fit the status each groups gets (bottom of forum has Game Status Levels)

Open up DB.ini

DB.ini Should look like this:

# READ README.TXT! 

[Database] 
host=localhost 
user=MySQLUsername 
password=MySQLPassword 
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.

where it says user= and password=, enter the username and password you selected when you ran winmysqladmin.exe

Save and close.

Open up LoginServer.ini

Looks like this:

 

### --- 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=servername
worldaddress=localhost
locked=false
account=
password=


[WorldServer]
Defaultstatus=0
Unavailzone=

[ChatChannelServer]
worldshortname=
chataddress= 
chatport=

[LoginConfig]
ServerMode=standalone
ServerPort=5999

Where it says worldname=, enter the name of your server. Whatever is there is what will show up on server select. Do not put the word Server in your server name, it is automatically added.

Where it says locked=, enter either true or false. This controls whether or not your server shows up as LOCKED on server select. In the locked state, only GM-Admins or higher can log in.

Where it says worldshortname=, type your servers short name (min char. 3)

Leave everything else in this file alone.

Save and close.

Open up Boot5Zones.bat, it should look like this:

 

REM: ****Read this first!!!**** 

REM: If you still get errors try using localhost instead of 127.0.0.1 

REM:--------------Start----------------------- 
@echo off 

if NOT exist spells_us.txt goto NOSPELL 

start zone . 127.0.0.1 7995 localhost
start zone . 127.0.0.1 7996 localhost
start zone . 127.0.0.1 7997 localhost
start zone . 127.0.0.1 7998 localhost
start zone . 127.0.0.1 7999 localhost
exit
cls 

:NOSPELL 
echo You did not copy the spells_us.txt from your everquest directory to this one. Please do so or zones will crash on startup. 
PAUSE 

REM:---------------END------------------------

-----------------------------------------------------------------------

STEP FIVE: Starting up your server.

1)Run World.exe in your C:\eqemu folder.

2)Run Boot5Zones.BAT.

3) Let them both run...log in and you're ready to connect.

(Make sure your eqhost.txt file is correct in your Everquest directory) It should read:

 
[Loginserver] 
host=localhost:5999

---------------------------------------------------------------

ANY PROBLEMS PLEASE TELL ME SO I CAN FIX AND UPDATE THE GUIDE THANKS

GAME STATUS LEVEL

0 - Legit - Very Limited commands
10 - semi-legit - Can summon items by commands
20 - Non-Legit - Can sommon items and level themselves by commands
60 - Guide
80 - GM-Quest Troupe
100 - GM-Admin
150 - GM-Lead Admin
200 - GM-Mgmt <--- SERVER OP, the one you want for yourself.

[Xentar]

First of all, great job man! This is a very nice, easy to follow guide. This should be a sticky.
<---- Look, my monkey agrees too! :lol:

A quick question, what is zoneperl.exe compared to just zone.exe? Should we run zoneperl instead?

[Sarepean]

No such thing as zoneperl.exe. I think he means a PERL compiled zone.

-Sarepean

[1Boppoom1]

yeah thats what i meant lol srry bout that.

[Darkened]

i can't find Scalar.pm or TieWrap.pm on that site anywhere, got a direct link to both? that would be much more helpful.

EDIT: oh , and what about sourcing the door_updates and doordata.sql files?

[1Boppoom1]

There is an edit for where to DL the files at

[Darkened]

bah , i still have the same issue of not having any npcs or mobs show in my world :(

its getting aggravating , been trying to determine why for almost a week.

[1Boppoom1]

post what uve sourced in what db release ur using everything you queried and i shall help

[Darkened]

i'm gonna do a completely fresh install of the db (again) - so why don't u tell me EXACTLY what u sourced for your DB right from the very beginning , that way i can compare and try with my own

and please try to be as detailed as possible because i need to know as many little things about what was done as possible to rule out what could be causing my problem.

examples: what version of mysql u use? etc.. very specific.

thanks alot.

[1Boppoom1]

this guide is showing exactly what ive source.......it shows the db and everything and it shows the steps ive done

[Darkened]

hmm , well it doesn't make a difference for me

and it shows "parts" of what u did , but you've left things out (such as the sourcing of the door_updates and doorsdata files and what mysql version u run - u just list mirror locations not give details about which version u were actually running yourself)

key bits of information in troubleshooting that were left out.

never solved my problem, but appreciate the guide :(

[1Boppoom1]

well all that i sourced in is listed you shouldnt need to source doors or anythign else other than the db's listed and ok

MySQL: 4.0.1
O/S: Windows XP Pro


what else yas need?

[Darkened]

Doesn't matter , I solved my own problem myself anyways

[1Boppoom1]

how did yas solve im currious ....... for future refrence when i come accross error? also i will add it to guide so no one gets that error.

[Darkened]

source this query into your db

ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

it's clearly mentioned in the changelog...........