EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)
-   -   Does anyone want some custom zones? (https://www.eqemulator.org/forums/showthread.php?t=25398)

Scorpious2k 06-10-2008 06:08 PM

Website is now at http://zones.2fear.com.

How could I resist a name like that??

quadroplex 06-11-2008 01:56 AM

im drollin here any eta on the last zones?

Scorpious2k 06-11-2008 11:46 AM

Manhattan zones are online and ready to download.

quadroplex 06-11-2008 11:48 AM

WOOOO you rock!

quadroplex 06-11-2008 11:49 AM

ummmm where? LOL i checked both and the buttons to dl them dont work?

Scorpious2k 06-11-2008 11:52 AM

You probably are looking at a cached version of the page, try refreshing/reloading it.

quadroplex 06-11-2008 11:55 AM

its the url redirect the old site link works fine!

Scorpious2k 06-11-2008 01:10 PM

It's been pointed out that I got a little careless with my sql entries and the zone.sql files have errors.. The correct sql for each zone is:

Nektropis is correct in the zip file.

Mars:
Code:

REPLACE INTO zone values ('ruja',NULL,'Mars Sector One',909,-2407,-194,0,0,0,230,0,0,0,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1);
REPLACE INTO zone values ('rujb',NULL,'Mars Sector Two',0,0,-439.3,0,0,0,235,0,0,0,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1);
REPLACE INTO zone values ('rujd',NULL,'Mars Sector Three',-362.05,1279.76,-95.25,0,0,0,245,0,0,0,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1);

Juno:
Code:

REPLACE INTO zone values ('ruje',NULL,'Juno - Southeast',-1835,209,-1460.9,0,0,0,250,0,0,1,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1};
REPLACE INTO zone values ('rujf',NULL,'Juno - Southwest',1700,2600,-1027.4,0,0,0,255,0,0,1,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1};
REPLACE INTO zone values ('rujg',NULL,'Juno - Northwest',-3630,-2695,-1169,0,0,0,260,0,0,1,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1};
REPLACE INTO zone values ('rujh',NULL,'Juno - Northeast',4952,-2047,-1224,0,0,0,265,0,0,1,'',-2300,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1};

Manhattan:
Code:

REPLACE INTO zone values ('ruji',NULL,'South Manhattan',2475,-2773,-190,0,0,0,269,0,0,1,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1);
REPLACE INTO zone values ('rujj',NULL,'North Manhattan',352,1286,-13.9,0,0,0,273,0,0,1,'',-2030,1500,2000,500,2000,0,0,0,1,255,0.75,0.4,2,0,0,0,450,450,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,'',1,1,1,1);

Sorry aboiut the errors. I will have updated versions up later.

Scorpious2k 06-11-2008 01:59 PM

Changes are uploaded and online.

The DB I am using is 1108, so you may have to add a ,1 at the end of the zone sql. I assume that is within most serverOp's abilities :P

Scorpious2k 06-11-2008 03:37 PM

Homeland Island zones are now online and available for download.

Scorpious2k 06-11-2008 04:21 PM

Copper City is now online and ready for download.

Rathora 06-12-2008 03:19 PM

Quote:

Originally Posted by Scorpious2k (Post 150257)
Jump in, join in, and have fun!

And I shall :)

quadroplex 06-12-2008 09:13 PM

It should be mentioned that if you use scorpious2k's zones youll need to delete the bazaar.eqg and tutorialb.eqg files

nosfentora 06-13-2008 08:39 AM

Is it possible to add these as 'new' zones without overwriting old zones? I tried adding copper city as a new zone, adjusting the values in the sql to make it a new zone, and inserted it into my db, changed the names of the files to ccity.xxx, restarted my server and logged in. I did #zone ccity and nothing happened - it didn't give me an error, but it didn't zone either. any thoughts?

i was thinking if i could get these added as new zones, i could make them accessable via quest or npc - kind of like tutorial.

Scorpious2k 06-13-2008 08:46 AM

Quote:

Originally Posted by nosfentora (Post 150550)
Is it possible to add these as 'new' zones without overwriting old zones? I tried adding copper city as a new zone, adjusting the values in the sql to make it a new zone, and inserted it into my db. restarted my server and logged in. I did #zone ccity and nothing happened - it didn't give me an error, but it didn't zone either. any thoughts?

i was thinking if i could get these added as new zones, i could make them accessable via quest or npc - kind of like tutorial.

The list of short names for zones is hard coded into the client, so you can't add a new name. It will always be a trade-off, one existing zone for a new one.

There are some zones that are in the client but not used in the game: tutorial, aviak, tutoriala, tutorialb, nektropos, arttest, and probably others. So you could technically use these without affecting the game or taking a zone used in live.

The best way to find these is to match short_name from the DB zone table with files in your EQ folder.


All times are GMT -4. The time now is 08:49 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.