First things first backup your database and game client. There are a number of zones missing from the database but that does not mean you can not use them. As long as your game client has the zone files for the missing zone you can just create the missing database entries and zone into it. The following will enable you to zone into Plane of Shadow assuming you have the zone files in place.
INSERT INTO `zone` (`short_name`, `id`, `file_name`, `long_name`, `map_file_name`, `safe_x`, `safe_y`, `safe_z`, `graveyard_id`, `min_level`, `min_status`, `zoneidnumber`, `version`, `timezone`, `maxclients`, `ruleset`, `note`, `underworld`, `minclip`, `maxclip`, `fog_minclip`, `fog_maxclip`, `fog_blue`, `fog_red`, `fog_green`, `sky`, `ztype`, `zone_exp_multiplier`, `walkspeed`, `time_type`, `fog_red1`, `fog_green1`, `fog_blue1`, `fog_minclip1`, `fog_maxclip1`, `fog_red2`, `fog_green2`, `fog_blue2`, `fog_minclip2`, `fog_maxclip2`, `fog_red3`, `fog_green3`, `fog_blue3`, `fog_minclip3`, `fog_maxclip3`, `fog_red4`, `fog_green4`, `fog_blue4`, `fog_minclip4`, `fog_maxclip4`, `fog_density`, `flag_needed`, `canbind`, `cancombat`, `canlevitate`, `castoutdoor`, `hotzone`, `insttype`, `shutdowndelay`, `peqzone`, `expansion`, `suspendbuffs`, `rain_chance1`, `rain_chance2`, `rain_chance3`, `rain_chance4`, `rain_duration1`, `rain_duration2`, `rain_duration3`, `rain_duration4`, `snow_chance1`, `snow_chance2`, `snow_chance3`, `snow_chance4`, `snow_duration1`, `snow_duration2`, `snow_duration3`, `snow_duration4`, `gravity`, `type`, `skylock`, `fast_regen_hp`, `fast_regen_mana`, `fast_regen_endurance`, `npc_max_aggro_dist`, `max_movement_update_range`) VALUES ('poshadow', 5968, '', 'The Plane of Shadow', NULL, -172, -625, -33, 0, 0, 0, 764, 0, 0, 0, 2, '', -5000, 50, 5000, 10, 500, 0, 0, 0, 0, 1, 1.50, 0.4, 2, 0, 0, 0, 10, 500, 0, 0, 0, 10, 500, 0, 0, 0, 10, 500, 0, 0, 0, 10, 500, 0.33, '', 1, 1, 1, 1, 0, 0, 900000, 1, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.4, 1, 0, 180, 180, 180, 600, 600);
If you are missing the zone files you can copy them from the live everquest client. I have never had any issues moving zone files from the EQ live client into the RoF client. If you move none zone files you can screw up your client really quickly so be careful.
Full disclosure...I acquired the above sql information by tinkering around and using process of elimination. These methods are not very accurate and was done solely for experimentation.
|