PDA

View Full Version : 6.0 Perl Server DR2 FULLY WORKS


1Boppoom1
11-13-2004, 04:28 PM
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 (http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.18-win.zip/from/pick#mirrors) MYSQL 4.1 not supported

2) EQEmu 6.0 - Perl Enabled

EQEMU 6.0 - Perl Enabled (http://adam.eqemulator.net/11-09-04_Compiled_Perl.zip)

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

Avtive Perl 5.8 (http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.2.808-MSWin32-x86.msi)

4) NMAKE

NMAKE (http://www-124.ibm.com/developerworks/oss/cvs/jsp/~checkout~/jspformatbean2/Attic/NMAKE.EXE?rev=1.1.1.1&content-type=application/exe)

5) Databases:

Kunark Update or Fresh (http://www.peqserver.com/)

6) Default.pl

Default.pl (http://home.comcast.net/~molimo140/default.pl)

7) Plugin.pl

Plugin.pl (http://home.comcast.net/~molimo140/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 (http://cvs.sourceforge.net/viewcvs.py/eqemulator/EQEmuCVS/SQL-Files/)

9) Scalar.pm and WrapTie.pm

WrapTie.pm (WrapTie = http://search.cpan.org/src/ERYQ/IO-stringy-2.109/lib/IO/WrapTie.pm)


WrapTie.pm (Scalar.pm = http://search.cpan.org/src/NWCLARK/perl-5.8.5/ext/PerlIO/scalar/scalar.pm)

10) Maps.zip

Maps.zip (http://www.rogean.com/maps/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
11-14-2004, 08:09 PM
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
11-15-2004, 12:03 AM
No such thing as zoneperl.exe. I think he means a PERL compiled zone.

-Sarepean

1Boppoom1
11-15-2004, 03:17 AM
yeah thats what i meant lol srry bout that.

Darkened
11-15-2004, 04:05 AM
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
11-15-2004, 04:16 PM
There is an edit for where to DL the files at

Darkened
11-15-2004, 05:42 PM
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
11-15-2004, 06:29 PM
post what uve sourced in what db release ur using everything you queried and i shall help

Darkened
11-15-2004, 09:42 PM
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 :D

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
11-16-2004, 02:51 AM
this guide is showing exactly what ive source.......it shows the db and everything and it shows the steps ive done

Darkened
11-16-2004, 03:22 AM
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
11-16-2004, 12:48 PM
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
11-16-2004, 05:38 PM
Doesn't matter , I solved my own problem myself anyways :)

1Boppoom1
11-16-2004, 05:53 PM
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
11-16-2004, 07:12 PM
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...........

1Boppoom1
11-17-2004, 05:02 AM
ok well thanks im going to make another guide so it wont be released for a while that is fully detailed down to the every move..... Hopefully that will help lots.....thanks for input so i know what to fix!!!

Darkened
11-17-2004, 05:34 AM
no problem

1Boppoom1
11-17-2004, 06:50 AM
Ok instead of working your ass off trying to get these zones to open when trying to get in start the zone as a static zone and your in!!!!. Yeah well mabey you dont want all the zones open so then type #zoneshutdown (zoneshortname) and its not booted anymore just give it a try may work for you i just tested it cause i couldnt get in and im in and its awsome i can enter game that way.......

sileosicarius
11-24-2004, 12:30 PM
I am getting a server timed out when trying to log into my server, any thoughts..?

1Boppoom1
11-24-2004, 06:04 PM
no do a search on timeout error theres a post how to fix

sileosicarius
11-25-2004, 08:05 AM
ok here is what i am getting

Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
DB Query Error #1054: Unknown column 'npc_aggro' in 'field list'
Error loading NPCs from database. Bad query.
[Status] 59953 New client from ip:127.0.0.1 port:1958
Read group ID for 'Sileo': 0
Loaded group id 0 from DB.
Dumping inventory on load:
Worn items:
Slot 2: Runed Circlet (1)
Slot 6: Barnacle-covered Pauldron (1)
Slot 8: Seahorse Scale Cloak (1)
Slot 13: Short Sword* (1)
Slot 14: A Worn Candle (1)
Inventory items:
Slot 22: Backpack* (1)
Slot 251: Mushroom (2)
Slot 252: Bandages* (20)
Slot 253: Bread Cakes* (20)
Slot 254: Skin of Milk (20)
Slot 255: Roots (1)
Bank items:
Shared Bank items:

[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f5, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4
0: 48 1F 73 00 | H.s.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x0355, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x0355, size: 4
0: 48 1F 73 00 | H.s.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02e9, size: 8
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02e9, size: 8
0: 3A 00 00 00 40 00 00 00 | :...@...
Tribute update:
0: 00 00 00 00 FF FF FF FF - FF FF FF FF FF FF FF FF | ................
16: FF FF FF FF FF FF FF FF - 00 00 00 00 00 00 00 00 | ................
32: 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 | ................

and from my world

Logged in: FirstLogin Account #1: eqadmin
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Sileo': 0
0: 2C 30 2C 2E 53 69 6C 65 - 6F 2C 30 36 37 61 37 39 | ,0,.Sileo,067a79
16: 64 34 00 | d4.
Attempting autobootup of Gfaydark (54) for Sileo
Zoneserver SetZone: 127.0.0.1:8781 Gfaydark (54)
Enter world: Sileo: Gfaydark (54)
Zoneserver SetZone: 127.0.0.1:8781 Gfaydark (54)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:1956


PLease help, i can log into and run around, but no mobs are there, also i cant get to it from another machine... any help with this would be greatly appreciated....!

Malignus Wingnut
11-25-2004, 09:31 AM
You have plagiarised from MY guide. Most of your guide was stolen from my post in the tutorials section. Before you create a guide and call it your own, give credit to the original creator. Thanks...

mrea
11-25-2004, 09:34 AM
Malignus, although yes, they are for the most part the same, how much can you differ on how to set this up? There isn't much variance. It's not his fault that the way he sets it up is identical to your way.

Malignus Wingnut
11-25-2004, 09:37 AM
I'm just irked by the fact that he copy/pasted large portions from my guide, using my exact wording in a lot of it.

sileosicarius
11-25-2004, 10:26 AM
can any one help with my prior stated error? i am @ a loss, been searching the eq board 4 ever...

Derision
11-25-2004, 01:24 PM
can any one help with my prior stated error? i am @ a loss, been searching the eq board 4 ever...

If you mean the missing npc_aggro field, from a very brief seach of the forums, you might need to look at:

http://www.eqemulator.net/forums/viewtopic.php?t=18490&highlight=npcaggro

per the change log:
ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

jhb45jr
12-12-2004, 08:31 AM
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)

How can i get this to happen?
No such window pops up for me. is there any way i can change my settings so this window will pop up? I am running XP Pro

mwmdragon
12-14-2004, 08:38 PM
It the IO::Scalar thing condusive to loging in ?

I couldn't get it to install correctly and when i try to log in to my server via the mini login i get a timed out error in my eq client.

the database went smooth, even with all the little add-ons sourced like you said. I have had other versions of eqemu working before so i know mysql is set up right as well as my IP addresses. Any help woth the installing of the scalar thing would be great...

the error i get from the install says. I don' have the last-updated header in my 02packages.details.txt.gz file and that i should check the validity of the index file by comparing it to more than one .cpan mirror.


Any help would be great.

PS: if this stuff isn't needed to run a 6.0dr2 minilogin server please let me know.

ubatch
09-03-2005, 04:42 PM
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)

How can i get this to happen?
No such window pops up for me. is there any way i can change my settings so this window will pop up? I am running XP Pro

For this, just edit a notepad, and do save as, type "tributes.sql" -- USE THE QUOTES! If you dont use the quotes, it'll save as tributes.sql.txt (assuming txt is what you had in the extension pull down bar....

bleh
09-04-2005, 11:58 AM
The part where you talk about granting privileges seems a little strange to me. It sounds like you are suggesting to create a new user, and then give the new user root access. The order should be more along the lines of:

1. Create database
2. Grant access to newly created database to user
3. Flush privileges