| 1Boppoom1 |
11-13-2004 04:28 PM |
6.0 Perl Server DR2 FULLY WORKS
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.
Code:
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
Code:
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
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 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
Code:
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:
Code:
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:
Code:
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:
then type
Code:
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:
Code:
Create database eq;
After that it Should say
Code:
Query OK, 1 Rows Affected, (0.0)sec
Next type:
All changes made will be made to the database that is being used.
After that it Should say
Now type:
Code:
source PEQ_Classic_058.sql;
The following will fly by but will eventually stop (this will take time)
Code:
Query OK, 1 Rows Affected, 0.0sec
Wehn finished type
Code:
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
Code:
INSERT INTO variables (varname, value, information) VALUES ('LoginType', 'Minilogin', 'Set this to Minilogin to login using a minilogin server ');
then
Code:
alter table account add minilogin_ip varchar(32) not null;
to allow other incoming connections play on your server type the following:
Code:
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:
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:
Code:
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):
Code:
#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:
Code:
# 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:
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=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:
Code:
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:
Code:
[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. |