|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself. |
 |
|
 |
10-13-2005, 11:31 AM
|
 |
Dragon
|
|
Join Date: Mar 2004
Location: England
Posts: 776
|
|
Sure here it is . Im using it with Velious database.
Code:
INSERT INTO `zone` VALUES ('broodlands', '', 'The broodlands', -1785, -1203, 15, 0, 100, 337, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('stillmoona', '', 'Stillmoon Temple', -8, -123, -30, 0, 100, 338, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('stillmoonb', '', 'The Ascent', 172, 1030, 43, 0, 100, 339, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('thundercrest', '', 'Thundercrest Isles', 3, -1685, 114, 0, 100, 340, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('delvea', '', 'Lavaspinner s Lair', -239, -1574, 69, 0, 100, 341, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('delveb', '', 'Tirranun s Delve', -150, -321, 20, 0, 100, 342, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('thenest', '', 'The Accursed Nest', -148, -75, -81, 0, 100, 343, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('guildlobby', '', 'The Guild Lobby', 0, 0, 2, 0, 100, 344, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('guildhall', '', 'Guild Hall', -3, -143, 4, 0, 100, 345, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('barter', '', 'The Barter Hall', -64, -244, 33, 0, 100, 346, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('illsalin', '', 'Ruins of Illsalin', -1152, -1144, 111, 0, 100, 347, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('illsalina', '', 'Imperial Bazaar', 5, 1, -22, 0, 100, 348, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('illsalinb', '', 'Temple of the Korlach', 0, 0, -22, 0, 100, 349, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('Illsalinc', '', 'The Nargilor Pits', 3, 2, -15, 0, 100, 350, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('dreadspire', '', 'Dreadspire Keep', 196, 3020, 85, 0, 100, 351, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('drachnidhive', '', 'The Hive', -52, 168, -73, 0, 100, 354, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('drachnidhivea', '', 'Living Larder', 0, 0, -19, 0, 100, 355, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('drachnidhiveb', '', 'Coven of the Skinwalkers', 140, 1424, 152, 0, 100, 356, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('drachnidhivec', '', 'Queen Sendaii s Lair', -5, 72, -756, 0, 100, 357, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('westkorlach', '', 'Stoneroot Fall', 681, 905, 165, 0, 100, 358, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('westkorlachb', '', 'Caverns of the Lost', 0, 0, 4, 0, 100, 360, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('westkorlachc', '', 'Lair of the Korlach', 474, 1230, 120, 0, 100, 361, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('eastkorlach', '', 'Undershore', 0, 0, -2, 0, 100, 362, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('eastkorlacha', '', 'Snarlstone Dens', 0, 0, -15, 0, 100, 363, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('shadowspine', '', 'Shadowspine', 0, 0, 3, 0, 100, 364, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('corathus', '', 'Corathus Creep', 0, 0, -21, 0, 100, 365, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('corathusa', '', 'Sporali Caverns', 0, 0, -6, 0, 100, 366, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
INSERT INTO `zone` VALUES ('corathusb', '', 'Corathus Lair', 0, -9, -12, 0, 100, 367, 0, 0, 1, '', -2030, 450, 2000, 450, 2000, 0, 0, 0, 1, 1, 1, 0.4, 2);
|
 |
|
 |
|
|
|
10-17-2005, 06:33 AM
|
|
Demi-God
|
|
Join Date: Jan 2005
Posts: 1,109
|
|
My sql update don't work in cavedude database because it don't have same fields on zone table than peq. You need some work for correct it :
Cavedude :
Code:
CREATE TABLE `zone` (
`short_name` varchar(16) NOT NULL default '',
`file_name` varchar(16) default NULL,
`long_name` text NOT NULL,
`safe_x` float NOT NULL default '0',
`safe_y` float NOT NULL default '0',
`safe_z` float NOT NULL default '0',
`min_level` tinyint(3) unsigned NOT NULL default '0',
`min_status` tinyint(3) unsigned NOT NULL default '0',
`zoneidnumber` int(4) NOT NULL default '0',
`timezone` int(5) NOT NULL default '0',
`maxclients` int(5) NOT NULL default '0',
`weather` smallint(6) NOT NULL default '1',
`underworld` float NOT NULL default '0',
`minclip` float NOT NULL default '450',
`maxclip` float NOT NULL default '450',
`fog_minclip` float NOT NULL default '450',
`fog_maxclip` float NOT NULL default '450',
`fog_blue` tinyint(3) unsigned NOT NULL default '0',
`fog_red` tinyint(3) unsigned NOT NULL default '0',
`fog_green` tinyint(3) unsigned NOT NULL default '0',
`sky` tinyint(3) unsigned NOT NULL default '1',
`ztype` tinyint(3) unsigned NOT NULL default '1',
`zone_exp_multiplier` float NOT NULL default '1',
`walkspeed` float NOT NULL default '0.4',
`time_type` tinyint(3) unsigned NOT NULL default '2',
`ldondungeon` tinyint(1) NOT NULL default '0',
`qflagreq` int(2) NOT NULL default '0',
`fog_red2` tinyint(3) unsigned NOT NULL default '0',
`fog_green2` tinyint(3) unsigned NOT NULL default '0',
`fog_blue2` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip2` float NOT NULL default '450',
`fog_maxclip2` float NOT NULL default '450',
`fog_red3` tinyint(3) unsigned NOT NULL default '0',
`fog_green3` tinyint(3) unsigned NOT NULL default '0',
`fog_blue3` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip3` float NOT NULL default '450',
`fog_maxclip3` float NOT NULL default '450',
`fog_red4` tinyint(3) unsigned NOT NULL default '0',
`fog_green4` tinyint(3) unsigned NOT NULL default '0',
`fog_blue4` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip4` float NOT NULL default '450',
`fog_maxclip4` float NOT NULL default '450',
PEQ:
Code:
CREATE TABLE `zone` (
`short_name` varchar(16) NOT NULL default '',
`file_name` varchar(16) default NULL,
`long_name` text NOT NULL,
`safe_x` float NOT NULL default '0',
`safe_y` float NOT NULL default '0',
`safe_z` float NOT NULL default '0',
`min_level` tinyint(3) unsigned NOT NULL default '0',
`min_status` tinyint(3) unsigned NOT NULL default '0',
`zoneidnumber` int(4) NOT NULL default '0',
`timezone` int(5) NOT NULL default '0',
`maxclients` int(5) NOT NULL default '0',
`weather` smallint(6) NOT NULL default '1',
`note` varchar(80) default NULL,
`underworld` float NOT NULL default '0',
`minclip` float NOT NULL default '450',
`maxclip` float NOT NULL default '450',
`fog_minclip` float NOT NULL default '450',
`fog_maxclip` float NOT NULL default '450',
`fog_blue` tinyint(3) unsigned NOT NULL default '0',
`fog_red` tinyint(3) unsigned NOT NULL default '0',
`fog_green` tinyint(3) unsigned NOT NULL default '0',
`sky` tinyint(3) unsigned NOT NULL default '1',
`ztype` tinyint(3) unsigned NOT NULL default '1',
`zone_exp_multiplier` float NOT NULL default '1',
`walkspeed` float NOT NULL default '0.4',
`time_type` tinyint(3) unsigned NOT NULL default '2',
`fog_red1` tinyint(3) unsigned NOT NULL default '0',
`fog_green1` tinyint(3) unsigned NOT NULL default '0',
`fog_blue1` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip1` float NOT NULL default '450',
`fog_maxclip1` float NOT NULL default '450',
`fog_red2` tinyint(3) unsigned NOT NULL default '0',
`fog_green2` tinyint(3) unsigned NOT NULL default '0',
`fog_blue2` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip2` float NOT NULL default '450',
`fog_maxclip2` float NOT NULL default '450',
`fog_red3` tinyint(3) unsigned NOT NULL default '0',
`fog_green3` tinyint(3) unsigned NOT NULL default '0',
`fog_blue3` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip3` float NOT NULL default '450',
`fog_maxclip3` float NOT NULL default '450',
`fog_red4` tinyint(3) unsigned NOT NULL default '0',
`fog_green4` tinyint(3) unsigned NOT NULL default '0',
`fog_blue4` tinyint(3) unsigned NOT NULL default '0',
`fog_minclip4` float NOT NULL default '450',
`fog_maxclip4` float NOT NULL default '450',
Add missing zone fields and that can work i think 
__________________
__________________________________________________ _____________________________________
I speak english like a spanish cow..., I speak spanish like a english pudding...
But I try to speak good french !!! (Non au langage SMS sur forum)
http://eqfroggy.new.fr : Froggy French Server Website.
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 10:03 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
