EQEMU 6.0 Perl DR3 download

[Belfedia]

For a short time you can download
working DR3 perl release on my website.
http://eqfroggy.ath.cx/download/EQEMU%20Perl%200.6.0-DR3.7z
Enjoy :)

Thanks to all people who help me
to make this archive :)

[Sakrateri]

thanks alot for this Bel, but it does not seem to be working , keep getting a timeout ?

[Belfedia]

Timeout with download (try again, it is just my internet down).
Timeout with Eqemu files ? (don't have this error, my server working with this files).

[Sakrateri]

was a timeout to download it but I got it now thanks so much :)

[steelrat]

whats a .7z extension??.. or can I just rename the file?
sorry if this is a daft question!


SR

[Belfedia]

"7-Zip is a file archiver with the high compression ratio. The program supports 7z, ZIP, CAB, RAR, ARJ, GZIP, BZIP2, Z, TAR, CPIO, RPM and DEB formats. Compression ratio in the new 7z format is 30-50% better than ratio in ZIP format"

Don't use winzip, winrar without registration :p
Use GPL packer !!!

You can find at : http://sourceforge.net/projects/sevenzip/

[steelrat]

Hi Bel, yes got the 7z extension sorted...(NICE compression).. but, on trying the program, I found that the Zones crashed whenever the char tried to access them :(

Do you have any idea what may be causing this?...

Waiting in hope.. :)

SR

[Belfedia]

Hi Bel, yes got the 7z extension sorted...(NICE compression).. but, on trying the program, I found that the Zones crashed whenever the char tried to access them :(

Do you have any idea what may be causing this?...

Waiting in hope.. :)

SR

Have you install all the files where is in archive ?
Have you install Maps directory from this : http://www.eqemulator.net/forums/showthread.php?t=18184 ?
Are you using Peq_velious_Beta1_DB ?

If all is right, don't understand.
I haved this problem when i don't have right configuration files :(

Edit: forget one thing :
REPLACE INTO `variables` VALUES ('holdzones', '1', 'Restart Crashed Zone Servers | 0 - off | 1 - on |', '20050329232941');
That help much and don't forget to restart your PC for clean memory, i think this DR3 trash some memory :(

[Belfedia]

Bump :p
I want live compatible h

[Darktanion]

Belfedia what files exactly do you have sourced if I May be so bold as to ask because I am getting an Items crash saying my items and merchant prices etc. do not exist. Would you please list out for me the files you have sourced exactly to a tee. Thanks so much :)

[Belfedia]

np, with this, i sourced only velious peq database fresh install :) http://www.projecteq.net/phpBB2/viewtopic.php?t=307
But this DR3 have some random problems :(
I'm waiting for the next stable version (after this week i hope).

[Darktanion]

ok so with the new release of velious right we downloaded these files...
1.Drop_users
2.Load_empty_users
3.Drop_system
4.Load_system
5.DBUpdate
All are .sql. My question for you or anyone that can answer it is do I source the drop_system first and when I do source it does that automatically convert it to a fresh install??
My second question is would you explain in what order I use the sql files if i already have sourced in Kunark. Or can someone explain to me on how I would make my whole files fresh again to start from scratch without re formating my hard drive. Thanks alot :)

OH and I posted somewhere in the minilogin about doors being screwed up and I found that there was a link which I dont have off hand over at eqprojects that updates nightly so what I did is used the doors on the top of that menu and the doors at the bottom and made a doors_update.sql for myself with that and all extra doors disappeared. Just FYI if anyone wants to use what I made let me know and I will post it.

And also this Bel I know you have seen this on another post cannot find it or I would have posted it in there. I noticed that another guy posted this under his DR2 and I am confused because my DR2 works perfectly and I get his error when I load in with the DR3.... Any help on this would be awsome too thanks so very much...
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR3
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Error] DBLoadItems query 'select charges,unknown001,collected_slot_id,merchantp
rice,unknown004,collected_inst_id,unknown006,spell charges,attuneable,itemclass,n
ame,lore,idfile,id,weight,norent,nodrop,size,slots ,cost,icon,unknown021,unknown0
22,unknown023,tradeskills,cr,dr,pr,mr,fr,astr,asta ,aagi,adex,acha,aint,awis,hp,m
ana,ac,deity,skillmodvalue,skillmodtype,banedmgrac e,banedmgamt,banedmgbody,magic
,casttime2,hasteproclvl,reqlevel,bardtype,bardvalu e,light,delay,reclevel,recskil
l,elemdmgtype,elemdmgamt,effecttype,range,damage,c olor,classes,races,unknown064,
spellid,maxcharges,itemtype,material,sellrate,unkn own070,casttime,unknown072,pro
c_rate_mod,focusid,combateffects,shielding,stunres ist,strikethrough,combatskill,
combatskilldmg,spellshield,avoidance,accuracy,char mformula,factionmod1,factionmo
d2,factionmod3,factionmod4,factionamt1,factionamt2 ,factionamt3,factionamt4,charm
file,augtype,augslot1type,augslot2type,augslot3typ e,augslot4type,augslot5type,ld
onpointtheme,ldonpointcost,ldonsold,bagtype,bagslo ts,bagsize,bagwr,booktype,unkn
own108,filename,banedmgamt2,augmentrestriction,lor eflag,pendingloreflag,artifact
flag,summonedflag,tribute,gmflag,endur,dotshieldin g,attackbonus,hpregen,manarege
n,hastepercent,damageshield,unknown125,unknown126, unknown127,distiller,unknown12
9,unknown130,unknown131,unknown132 from items order by id', #1054: Unknown colum
n 'unknown001' in 'field list'
[Error] If you got an error related to the 'charmformula' field, run the followi
ng SQL Query: ALTER TABLE `items` CHANGE `unknown084` `charmformula` INT(11) DE
FAULT "0" NOT NULL;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Liberating a country that despises us...
TCP listening on: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Setting World to MiniLogin Server type
Connected to LoginServer: 127.0.0.1:5999

[Darktanion]

Sorry for this bump but I wanted to leave that other post for noobs going from one eqemu to another.
I figured out what the problem was exaclty. I am learning something on my own thank god hehe.
Basically what is happening to MOST people is they are missunderstanding the tutorials alot. Basically when you source things it will not overwrite any of the existing stuff that is there. Well you can do it without screwups but it will keep giving you duplicate key unless there is something that is not already there then it will show the code of row affected (0). What this error I had above was from is this::::
If you want to load only PEQ_Kunark then just load it and not anything from the velious package. For some reason it will screw up alot of things. Well at least for me from what I have done so far. I would suggest deleting your eq folder and starting from scratch. If you load the velious over the top of your existing DB it should work but when you try to go back to your DR2 it will not run I will gaurantee it wont. The reason for this is you just made it velious capable and now it wants you to upgrade to the DR3 version of eqemu. I found this out the hard way. The error above is because I was using Kunark on the DR3 and that was not working at all....

In short if you use Kunark then you will want to use the eqemu 0.6.0 DR2 version.
If you want to use Velious then you will need to download the 0.6.0 DR3 from Belfedia before he stops the download processing from his site....
If I am way off then I am sorry for this post but I tried to run DR2 after installing the velious and it wouldnt work properly at all. But it ran the DR3 just fine.

[Ghost Fire]

Well I'm running Original/Kunark/Velious with Pearl Enabled on 0.6.0 DR2. I did have it working with 0.6.0 DR3 also. But It was a little buggy for me.

[Darktanion]

Ghost I am trying to figure out what steps the first users have gone through so I can copy there exact pattern to a tee. You cannot rely really on the tutorials there all kinda hard to follow and alot of the links dont support there exection link anymore so it would be great if someone would post from beginning to end of how they got everything working and hopefully we all can copy the pattern and catch up. However if its not possible anymore because of the links being outdated then maybe there is a problem with noobs trying to start now??

[Ghost Fire]

Well It's not an easy thing to get a server up and running from nothing. As anyone can see from the Tutorials. It's a lot of things to do and learn. But I made a Bug list to help myself out. And here it is, I hope it helps some.

"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe" -b (-b makes it so you don't hear the beeps)

---> WARNING: IN THIS ORDER OR ELSE! <---
{} Means ONLY if Vel Database is new ONLY

source lootdrop_entries.sql;
source PEQ_Kunark_RC1.sql;
source PEQ_Kunark_RC1_keep_accts.sql;
source merchantlist_temp.sql;
source doors_update.sql;
source zonepoints.sql;
source tl.sql;
source tributes.sql;

Source aug_updates.sql
Source tribute_levels.sql
Source quest_globals.sql
Source spawn_conditions.sql
Source spawn_events.sql

{source drop_users.sql} {} Means ONLY if Vel Database is new only
source drop_system.sql
{source load_empty_users.sql} {} Means ONLY if Vel Database is new only
source load_system.sql

(When your connecting from another computer and not able to get into server)
Change your ports in Boot5zones.bat to 8780-8785
Also don't take your time picking the server you will get a time out error

(Fix for Quests in Perl not working)
Make sure your Quests are in the zone that they goto and that all zones are in your Quests folder

(Fix for [Status] Error initializing perlembed: failed to install plugin printhook, do yo
u lack IO::Scalar?
[Status] Fatal error initializing perl: failed to install plugin printhook, do y
ou lack IO::Scalar?)
Don't use Scalar.pm and WrapTie.pm.


(Fix for Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#2006: MySQL server has gone away')
Make the DB.ini Host=localhost or 127.0.0.1

(Fix for [Error] Starting command queue Mapping...)
Thats not a real error it just says error for logging purposes...

(Fix for Error: LoginServer::Connect:'TCPConnection::Connect():con nect()failed.Error:10061')
The Error for this is in the LoginServer.ini. Check the Ip's if they are right.

(Fix for Error: No zoneserver to bootup)
1)Match the Boot5zones.bat Ip Address for Minilogin Example: localhost
2)Download the .map files

(Fix for #2006 bug)
code: SET PASSWORD FOR 'username'@'localhost' = OLD_PASSWORD('newpassword');

(Fix for Name Rejected)
C:\>mysql -u root eq <---------------- Type that in!

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.12-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> repair table character_ ; <---------------- Type that in!

+------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+----------+
| 57dr1.character_ | repair | status | OK |
+------------------+--------+----------+----------+
1 row in set (0.01 sec)

mysql>

(Fix for [Error] DBLoadItems query)

- Download the kunark PEQ database, load it up.
- Source in aug_updates.sql
- Run the doors ID 0 updates from below
- Source in doors_update.sql
- Source in doorsdata.sql
- Source in merchantlist_temp.sql
- Source in tributes.sql
- Source in tribute_levels.sql
- Source in quest_globals.sql
- Source in spawn_conditions.sql
- Source in spawn_events.sql
- Run the rest of the SQL below.


Random Updates:
ALTER TABLE spawnentry ADD spawn_limit TINYINT NOT NULL DEFAULT '0';
ALTER TABLE npc_types ADD spawn_limit TINYINT NOT NULL DEFAULT '0';
ALTER TABLE character_ ADD extprofile BLOB NOT NULL;
ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';
ALTER TABLE npc_types ADD attack_speed FLOAT NOT NULL DEFAULT '0';
ALTER TABLE npc_types ADD findable TINYINT NOT NULL DEFAULT '0';
ALTER TABLE spawn2 ADD condition MEDIUMINT UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE spawn2 ADD cond_value MEDIUMINT NOT NULL DEFAULT '1';

#Fix doors with ID 0, from Belfedia
update doors set doorid=9 where id=5767;
update doors set doorid=18 where id=5749;
update doors set doorid=19 where id=5776;
update doors set doorid=2 where id=946;
update doors set doorid=3 where id=947;
update doors set doorid=6 where id=950;
update doors set doorid=7 where id=964;
update doors set doorid=8 where id=976;
update doors set doorid=10 where id=992;
update doors set doorid=4 where id=1385;
update doors set doorid=5 where id=1386;
update doors set doorid=6 where id=1390;
#optional additional door fix, not well tested, but seems to work OK:
UPDATE doors SET doorid=525 WHERE doorid=0;


#Items Updates:
ALTER TABLE `items` CHANGE `unknown002` `unknown001` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown003` `collected_slot_id` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown005` `unknown004` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown006` `collected_inst_id` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown007` `unknown006` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown018` `unknown021` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown019` `unknown022` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown020` `unknown023` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown061` `unknown064` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown067` `unknown070` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown069` `unknown072` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown081` `charmformula` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown105` `unknown108` INT(11) DEFAULT "0" NOT NULL;
ALTER TABLE `items` CHANGE `unknown128` `distiller` int(10) DEFAULT "0" NOT NULL;

(Missing Zone in the VelDatabase)
UPDATE zone SET min_status=0 WHERE short_name="sleeper";
Also here is another useful Fixes I use
###Lock Zone Code:

UPDATE zone SET min_status=0 WHERE short_name="Zonename"; (O enables it 1 Disables it)

###Edit Zone

INSERT INTO zone (short_name, long_name, safe_x, safe_y, safe_z, zoneidnumber, underworld, minclip, maxclip, fog_minclip, fog_maxclip) VALUES ('dranik', 'The Ruined City of Dranik', '-1112', '-1944', '-367', '336', '-2030', '450', '2000', '450', '2000');

###Doors like caves

RUJPORTAL701, and POKTELE500

###Stop the beeps

"C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe" -b

###(New Account)

Whenever the user connects to minilogin, it will display their ip in the console window, that IP must match the ip you put in the account table. Make sure the ip addresses are the same!

insert into account (name,status, minilogin_ip) values('username',0,'127.0.0.1');

###(If you want to login with an existing account) Put the ip address of the computer your using to
login in the minilogin_ip field of the users account you wish to play.

update account set minilogin_ip='127.0.0.1' where name='Username';

0 - Legit
10 - Semi-Legit
20 - Non-Legit
60 - Guide
80 - GM-Quest Troupe
100 - GM-Admin
150 - GM-Lead Admin
200 - GM-Mgmt &lt;--- SERVER OP, the one you want for yourself.

###Other Login Users get LD and kicked off server after Char Creation.

If you're going to get anybody but the same machine connecting to the server, you cannot use 127.0.0.1 as an IP address on any of your world or zone setups. Use your Network Card's IP address, which can be found in the Network Connections properties.

###spawn command

#spawn &lt;Name> &lt;Race> &lt;Level> &lt;Material> &lt;HP> &lt;Gender> &lt;Class> >Item_Visual_1&lt; >Item_Visual_2&lt; &lt;Merchant_ID>

Name = Name of the mob.
Race = Model for the mob (eg Giant, Human, Dragon).
Level = Level of the mob.
Material = What texture (eg Sand Giant, FG, IG).
HP = How many HP the mob has.
Gender = Male / Female / Neuter ( 0 / 1 / 2)
Class = Class of mob. (eg 1 for Warrior, 5 for SK).
Item_Visuals = What the mob looks like it's weilding (eg Sword, Shield, Axe, Wand).
Merchant_ID = Never used this, not sure =P

For dragons and mobs where you can't tell the gender, use 2 or you will get a bald man.

Make sure you fill in all the arguments, even if you leave them 0 (ie, don't just go up to class then stop).

Don't have a clue what merchant ID is for, never used it. I presume it is for merchants with an item list already done. (Just use the merchant ID from DB and the merchant should have the items for sale that you set - at a guess )

Useful Spawns:

#spawn Banker 1 75 3 1000000 0 16 162 162 0
Will give you a level 75 human banker with 1000000 HP, duel weilding cool weapons and wearing cool armour.

#spawn Merchant 1 75 3 1000000 0 32 162 162 0
Will give you a level 75 human merchant with 1000000 HP, duel weilding cool weapons and wearing cool armour. He won't have any items for sale, but you can sell items to him.