Fix for instances

[Jacksparrow]

just to say the enemies are not spawned ill update this later use CONSOLE for this
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for worldmap_info
-- ----------------------------
CREATE TABLE `worldmap_info` (
`mapid` int(10) NOT NULL default '0',
`screenid` int(10) default '0',
`type` int(10) default '0',
`maxplayers` int(10) default '0',
`minlevel` int(11) unsigned zerofill default '00000000001',
`repopx` float default '0',
`repopy` float default '0',
`repopz` float default '0',
`repopmapid` int(5) unsigned zerofill default '00000',
`area_name` varchar(100) default '0',
`flags` int(11) unsigned NOT NULL default '0',
`cooldown` int(15) NOT NULL default '0',
`lvl_mod_a` int(11) NOT NULL default '0',
PRIMARY KEY (`mapid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `worldmap_info` VALUES ('0', '0', '0', '0', '00000000001', '0', '0', '0', '00000', 'Estern Kingdoms Continent', '1', '0', '0');
INSERT INTO `worldmap_info` VALUES ('1', '1', '0', '0', '00000000001', '0', '0', '0', '00001', 'Kalimdor Continent', '1', '0', '0');
INSERT INTO `worldmap_info` VALUES ('30', '30', '3', '0', '00000000001', '0', '0', '0', '00000', 'Alterac Valley', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('33', '204', '2', '5', '00000000001', '-229.49', '1576.35', '78.8909', '00000', 'Shadowfang Keep', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('34', '34', '2', '5', '00000000001', '-8769.86', '842.181', '89.8765', '00000', 'Stormwind Stockades', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('35', '194', '2', '5', '00000000001', '0', '0', '0', '00000', 'Stormwind Vault - UNUSED', '0', '0', '0');
INSERT INTO `worldmap_info` VALUES ('36', '36', '2', '5', '00000000008', '-11208.4', '1673.85', '24.6245', '00000', 'DeadMines', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('43', '143', '2', '5', '00000000008', '-753.596', '-2212.78', '21.5403', '00001', 'Wailing Caverns', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('47', '188', '2', '5', '00000000001', '-4456.7', '-1655.99', '86.1095', '00001', 'Razorfen Kraul', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('48', '196', '2', '5', '00000000008', '4252.37', '756.974', '-23.0632', '00001', 'Blackfathom Deeps', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('70', '144', '2', '5', '00000000001', '-6606.48', '-3762.19', '266.91', '00000', 'Uldaman', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('90', '193', '2', '5', '00000000001', '-5081.82', '719.549', '260.554', '00000', 'Gnomeregan', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('109', '109', '2', '5', '00000000001', '-10184.9', '-3992.84', '-109.194', '00000', 'Temple of Atal\'Hakkar', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('129', '145', '2', '5', '00000000001', '-4666.52', '-2536.82', '86.9671', '00001', 'Razorfen Downs', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('189', '42', '2', '5', '00000000008', '2870.97', '-759.845', '160.333', '00000', 'Scarlet Monastery', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('209', '146', '2', '5', '00000000001', '-6773.49', '-2889.77', '15.1063', '00001', 'Zul\'Farrak', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('229', '189', '2', '10', '00000000055', '-7518.19', '-1239.13', '287.243', '00000', 'Blackrock Spire', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('230', '103', '2', '10', '00000000055', '-7176.63', '-937.667', '170.206', '00000', 'Blackrock Depths', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('249', '61', '1', '40', '00000000055', '-4768.61', '-3752.11', '53.4317', '00001', 'Onyxia\'s Lair', '3', '432000', '0');
INSERT INTO `worldmap_info` VALUES ('269', '269', '1', '5', '00000000064', '-8770.08', '-4171.7', '-210.158', '00001', 'Opening of the Dark Portal', '9', '0', '0');
INSERT INTO `worldmap_info` VALUES ('289', '102', '2', '5', '00000000055', '1282.05', '-2548.73', '85.3994', '00000', 'Scholomance', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('309', '161', '1', '20', '00000000055', '-11915.8', '-1236.43', '96.1502', '00000', 'Zul\'Gurub', '3', '259200', '0');
INSERT INTO `worldmap_info` VALUES ('329', '101', '2', '5', '00000000055', '3237.46', '-4060.6', '112.01', '00000', 'Stratholme', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('349', '81', '2', '5', '00000000001', '-1431.07', '2970.64', '99.8095', '00000', 'Maraudon', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('369', '369', '0', '0', '00000000001', '0', '0', '0', '00000', 'Deeprun Tram', '1', '0', '0');
INSERT INTO `worldmap_info` VALUES ('389', '195', '2', '5', '00000000008', '1818.4', '-4427.26', '-10.4478', '00001', 'Ragefire Chasm', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('409', '192', '1', '40', '00000000055', '-7510.31', '-1041.63', '180.912', '00000', 'Molten Core', '3', '604800', '0');
INSERT INTO `worldmap_info` VALUES ('429', '82', '2', '5', '00000000001', '-4278.76', '1332.49', '161.214', '00001', 'Dire Maul', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('449', '181', '0', '0', '00000000001', '-8761.85', '848.557', '87.8052', '00000', 'Alliance Military Barracks', '1', '0', '0');
INSERT INTO `worldmap_info` VALUES ('450', '182', '0', '0', '00000000001', '1643.36', '-4233.6', '56.1557', '00001', 'Horde Military Barracks', '1', '0', '0');
INSERT INTO `worldmap_info` VALUES ('469', '141', '1', '40', '00000000055', '-7655.63', '-1221.93', '287.798', '00000', 'Blackwing Lair', '3', '604800', '0');
INSERT INTO `worldmap_info` VALUES ('509', '184', '1', '20', '00000000055', '-8134.79', '1525.9', '6.1904', '00001', 'Ahn\'Qiraj Ruins', '0', '259200', '0');
INSERT INTO `worldmap_info` VALUES ('530', '530', '0', '0', '00000000055', '0', '0', '0', '00530', 'Outlands', '9', '0', '0');
INSERT INTO `worldmap_info` VALUES ('531', '531', '1', '40', '00000000055', '-8134.79', '1525.9', '6.1904', '00001', 'Ahn\'Qiraj Temple', '0', '259200', '0');
INSERT INTO `worldmap_info` VALUES ('532', '532', '1', '25', '00000000070', '-11106.5', '-2001.64', '49.8927', '00000', 'Karazhan', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('533', '0', '2', '40', '00000000055', '3237.46', '-4060.6', '112.01', '00000', 'Naxxramas', '3', '604800', '0');
INSERT INTO `worldmap_info` VALUES ('534', '534', '2', '25', '00000000068', '-8178.25', '-4184.74', '-168.4', '00001', 'The Battle for Mount Hyjal', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('560', '560', '1', '5', '00000000064', '-8343.69', '-4057.43', '207.924', '00001', 'Caverns Of Time - Hillsbrad Past', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('553', '553', '2', '5', '00000000068', '3365.84', '1519.15', '179.541', '00530', 'Tempest Keep: The Botanica', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('545', '545', '2', '5', '00000000070', '816.87', '6935.02', '-80.5606', '00530', 'Steamvault', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('554', '554', '2', '5', '00000000070', '2863.4', '1546.33', '252.159', '00530', 'Tempest Keep: Mechanar', '9', '0', '0');
INSERT INTO `worldmap_info` VALUES ('564', '564', '2', '25', '00000000070', '-3649.89', '317.177', '35.3295', '00530', 'Black Temple', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('565', '565', '2', '25', '00000000070', '3546.78', '5087.77', '2.9403', '00002', 'Gruul\'s Lair', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('552', '552', '2', '5', '00000000070', '3312.09', '1331.89', '505.559', '00530', 'The Arcatraz', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('550', '550', '2', '40', '00000000070', '3088.08', '1382.74', '1382.74', '00530', 'Tempest Keep', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('540', '540', '2', '5', '00000000060', '-310.402', '3082.47', '-3.73108', '00530', 'Shattered Halls', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('544', '544', '2', '25', '00000000060', '-313.997', '3088.45', '-116.499', '00530', 'Magtheridon\'s Lair', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('543', '543', '2', '5', '00000000060', '-362.679', '3076.29', '-15.0364', '00530', 'Hellfire Ramparts', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('542', '542', '2', '5', '00000000060', '-301.116', '3161.07', '31.7029', '00530', 'The Blood Furnace', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('557', '557', '2', '5', '00000000060', '-3083.3', '4942.84', '-101.048', '00530', 'Mana Tombs', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('555', '555', '2', '5', '00000000060', '-3637.51', '4940.85', '-101.047', '00530', 'Shadow Labyrinth', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('556', '556', '2', '5', '00000000060', '-3361.9', '4666.01', '-101.048', '00530', 'Sethekk Halls', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('558', '558', '2', '5', '00000000060', '-3361.87', '5220.98', '-101.048', '00530', 'Auchenai Crypts', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('547', '547', '2', '25', '00000000060', '732.239', '7014.22', '-71.8797', '00530', 'The Slave Pens', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('548', '548', '2', '40', '00000000060', '783.103', '6866.53', '-65.9414', '00530', 'Serpentshrine Cavern', '3', '0', '0');
INSERT INTO `worldmap_info` VALUES ('546', '546', '2', '25', '00000000060', '775.655', '6765.93', '-71.1669', '00530', 'The Underbog', '3', '0', '0');

black temple is not spawned in this

[popo]

were do you put that?????????????

[Nebels]

You put it into a .sql and execute it into the database. xD

[ShadowReaper31]

This fixes all of the instances...?

use CONSOLE for this

I think he means the console inside navicat.

[Nebels]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `worldmap_info` (
`mapid` int(10) NOT NULL default '0',
`scre' at line 2
[Msg] Finished - Unsuccessfully

[Jacksparrow]

eh oh well lol worked for me and no not all it gives all exept black temple but no spawns

[Nebels]

Does this fix all bg's where you can enter them and actually play? and same with the instances?

[Jacksparrow]

bg idk instances yes

[Zeldagod]

ok cool im gonna try this.

[Wildcard999]

I tried this for Rev 3.5 but it doesnt work, I get the same error message as the guy above. I there another way to fix these instances?

[wrath99]

if you want t good Instance fix use a diffrent DB then what jargs has, the oen he has is kinda...............lacking. i'll search for some for you guys to choose from

[Thorz]

The only reason Jargs is lacking is because he's the only one working on the Repack, were currently working on setting up a repack team.

[wrath99]

well good coause he needs it, i can be part of it, well for the website part, and i know alot about the mysql stuff......still need to ge the new revision

[Thorz]

You should talk to Jargs. Let him know your interested.

[wrath99]

Oh i will, and dude, you need to take a break fromt eh website man, you like on 24/7 lol

[Thorz]

I know. But, I'm one of the only active mod's we have atm.

[wrath99]

yeah well, i WAS a mod, but i go on a little time away for a bit and i get striped lol

[Thorz]

I know. It kinda sucks. Ill talk to Jargs.

[lemoncade]

i get a lot of errors.

[Wildcard999]

So this issue is not a matter of me screwing something up. Those instances are just not populated for everyone? Just curious so I know that I didnt screw something up or does everyone else have spawns in there. Instances like mana tombs and underbog etc. Most of the Burning Crusade instances are blank.

[sirpro]

try the terranet rev 5 database from silvermoon, i use that while using your repacks, good repack btw seriously does the job !!

[Fleek182]

using that db i still don't have any spawns in Magtheridons lair nor have I seen a fel reaver in HP. Any ideas plz

[Wildcard999]

Must not be populated yet. Even with the new repack it most places are still empty.

[BigFatLord]

Good work! Did you wrote this script by your self?

[Cele]

Don't bump two year old posts...