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