EQEMU 6.0 Perl DR3 download - Page 2

Ghost Fire · #16 05-07-2005, 03:57 PM

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.

Code:

"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():connect()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

Code:

###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.