Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `pool_members` SET `poolSpawnId`=3310 WHERE `type`=1 AND `SpawnId` IN (69260,69261,69262,69263,69264,69265);
- UPDATE `pool_members` SET `poolSpawnId`=3410 WHERE `type`=1 AND `SpawnId` IN (69860,69861,69862,69863,69864,69865);
- UPDATE `pool_members` SET `poolSpawnId`=3210 WHERE `type`=1 AND `SpawnId` IN (68660,68661,68662,68663,68664,68665);
- DELETE FROM `pool_members` WHERE `poolSpawnId` IN (9907) AND `spawnId` IN (11150, 11151, 11152,11153,11154,11155,11156,11157,11158,11159,11160, 11161, 11162,11163,11164,11165,11166,11167,11168,11169,11170, 11171, 11172,11173,11174,11175,11176,11177,11178,11179,11180, 11181, 11182,11183,11184,11185,11186,11187,11188,11189,11190, 11191, 11192,11193,11194,11195,11196,11197,11198,11199,11200, 11201, 11202,11203,11204,11205,11206,11207,11208,11209,11210, 11211, 11212,11213,11214,11215,11216,11217,11218,11219,11220, 11221, 11222,11223,11224,11225,11226,11227,11228,11229,11230, 11231, 11232,11233,11234,11235,11236,11237,11238,11239,11240, 11241, 11242,11243,11244,11245,11246,11247,11248,11249,11250, 11251, 11252,11253,11254,11255,11256,11257,11258,11259,11389) AND `type`=2;
- INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES
- (2, 11150, 9907, 0, 'Storm Peaks Ore'),
- (2, 11151, 9907, 0, 'Storm Peaks Ore'),
- (2, 11152, 9907, 0, 'Storm Peaks Ore'),
- (2, 11153, 9907, 0, 'Storm Peaks Ore'),
- (2, 11154, 9907, 0, 'Storm Peaks Ore'),
- (2, 11155, 9907, 0, 'Storm Peaks Ore'),
- (2, 11156, 9907, 0, 'Storm Peaks Ore'),
- (2, 11157, 9907, 0, 'Storm Peaks Ore'),
- (2, 11158, 9907, 0, 'Storm Peaks Ore'),
- (2, 11159, 9907, 0, 'Storm Peaks Ore'),
- (2, 11160, 9907, 0, 'Storm Peaks Ore'),
- (2, 11161, 9907, 0, 'Storm Peaks Ore'),
- (2, 11162, 9907, 0, 'Storm Peaks Ore'),
- (2, 11163, 9907, 0, 'Storm Peaks Ore'),
- (2, 11164, 9907, 0, 'Storm Peaks Ore'),
- (2, 11165, 9907, 0, 'Storm Peaks Ore'),
- (2, 11166, 9907, 0, 'Storm Peaks Ore'),
- (2, 11167, 9907, 0, 'Storm Peaks Ore'),
- (2, 11168, 9907, 0, 'Storm Peaks Ore'),
- (2, 11169, 9907, 0, 'Storm Peaks Ore'),
- (2, 11170, 9907, 0, 'Storm Peaks Ore'),
- (2, 11171, 9907, 0, 'Storm Peaks Ore'),
- (2, 11172, 9907, 0, 'Storm Peaks Ore'),
- (2, 11173, 9907, 0, 'Storm Peaks Ore'),
- (2, 11174, 9907, 0, 'Storm Peaks Ore'),
- (2, 11175, 9907, 0, 'Storm Peaks Ore'),
- (2, 11176, 9907, 0, 'Storm Peaks Ore'),
- (2, 11177, 9907, 0, 'Storm Peaks Ore'),
- (2, 11178, 9907, 0, 'Storm Peaks Ore'),
- (2, 11179, 9907, 0, 'Storm Peaks Ore'),
- (2, 11180, 9907, 0, 'Storm Peaks Ore'),
- (2, 11181, 9907, 0, 'Storm Peaks Ore'),
- (2, 11182, 9907, 0, 'Storm Peaks Ore'),
- (2, 11183, 9907, 0, 'Storm Peaks Ore'),
- (2, 11184, 9907, 0, 'Storm Peaks Ore'),
- (2, 11185, 9907, 0, 'Storm Peaks Ore'),
- (2, 11186, 9907, 0, 'Storm Peaks Ore'),
- (2, 11187, 9907, 0, 'Storm Peaks Ore'),
- (2, 11188, 9907, 0, 'Storm Peaks Ore'),
- (2, 11189, 9907, 0, 'Storm Peaks Ore'),
- (2, 11190, 9907, 0, 'Storm Peaks Ore'),
- (2, 11191, 9907, 0, 'Storm Peaks Ore'),
- (2, 11192, 9907, 0, 'Storm Peaks Ore'),
- (2, 11193, 9907, 0, 'Storm Peaks Ore'),
- (2, 11194, 9907, 0, 'Storm Peaks Ore'),
- (2, 11195, 9907, 0, 'Storm Peaks Ore'),
- (2, 11196, 9907, 0, 'Storm Peaks Ore'),
- (2, 11197, 9907, 0, 'Storm Peaks Ore'),
- (2, 11198, 9907, 0, 'Storm Peaks Ore'),
- (2, 11199, 9907, 0, 'Storm Peaks Ore'),
- (2, 11200, 9907, 0, 'Storm Peaks Ore'),
- (2, 11201, 9907, 0, 'Storm Peaks Ore'),
- (2, 11202, 9907, 0, 'Storm Peaks Ore'),
- (2, 11203, 9907, 0, 'Storm Peaks Ore'),
- (2, 11204, 9907, 0, 'Storm Peaks Ore'),
- (2, 11205, 9907, 0, 'Storm Peaks Ore'),
- (2, 11206, 9907, 0, 'Storm Peaks Ore'),
- (2, 11207, 9907, 0, 'Storm Peaks Ore'),
- (2, 11208, 9907, 0, 'Storm Peaks Ore'),
- (2, 11209, 9907, 0, 'Storm Peaks Ore'),
- (2, 11210, 9907, 0, 'Storm Peaks Ore'),
- (2, 11211, 9907, 0, 'Storm Peaks Ore'),
- (2, 11212, 9907, 0, 'Storm Peaks Ore'),
- (2, 11213, 9907, 0, 'Storm Peaks Ore'),
- (2, 11214, 9907, 0, 'Storm Peaks Ore'),
- (2, 11215, 9907, 0, 'Storm Peaks Ore'),
- (2, 11216, 9907, 0, 'Storm Peaks Ore'),
- (2, 11217, 9907, 0, 'Storm Peaks Ore'),
- (2, 11218, 9907, 0, 'Storm Peaks Ore'),
- (2, 11219, 9907, 0, 'Storm Peaks Ore'),
- (2, 11220, 9907, 0, 'Storm Peaks Ore'),
- (2, 11221, 9907, 0, 'Storm Peaks Ore'),
- (2, 11222, 9907, 0, 'Storm Peaks Ore'),
- (2, 11223, 9907, 0, 'Storm Peaks Ore'),
- (2, 11224, 9907, 0, 'Storm Peaks Ore'),
- (2, 11225, 9907, 0, 'Storm Peaks Ore'),
- (2, 11226, 9907, 0, 'Storm Peaks Ore'),
- (2, 11227, 9907, 0, 'Storm Peaks Ore'),
- (2, 11228, 9907, 0, 'Storm Peaks Ore'),
- (2, 11229, 9907, 0, 'Storm Peaks Ore'),
- (2, 11230, 9907, 0, 'Storm Peaks Ore'),
- (2, 11231, 9907, 0, 'Storm Peaks Ore'),
- (2, 11232, 9907, 0, 'Storm Peaks Ore'),
- (2, 11233, 9907, 0, 'Storm Peaks Ore'),
- (2, 11234, 9907, 0, 'Storm Peaks Ore'),
- (2, 11235, 9907, 0, 'Storm Peaks Ore'),
- (2, 11236, 9907, 0, 'Storm Peaks Ore'),
- (2, 11237, 9907, 0, 'Storm Peaks Ore'),
- (2, 11238, 9907, 0, 'Storm Peaks Ore'),
- (2, 11239, 9907, 0, 'Storm Peaks Ore'),
- (2, 11240, 9907, 0, 'Storm Peaks Ore'),
- (2, 11241, 9907, 0, 'Storm Peaks Ore'),
- (2, 11242, 9907, 0, 'Storm Peaks Ore'),
- (2, 11243, 9907, 0, 'Storm Peaks Ore'),
- (2, 11244, 9907, 0, 'Storm Peaks Ore'),
- (2, 11245, 9907, 0, 'Storm Peaks Ore'),
- (2, 11246, 9907, 0, 'Storm Peaks Ore'),
- (2, 11247, 9907, 0, 'Storm Peaks Ore'),
- (2, 11248, 9907, 0, 'Storm Peaks Ore'),
- (2, 11249, 9907, 0, 'Storm Peaks Ore'),
- (2, 11250, 9907, 0, 'Storm Peaks Ore'),
- (2, 11251, 9907, 0, 'Storm Peaks Ore'),
- (2, 11252, 9907, 0, 'Storm Peaks Ore'),
- (2, 11253, 9907, 0, 'Storm Peaks Ore'),
- (2, 11254, 9907, 0, 'Storm Peaks Ore'),
- (2, 11255, 9907, 0, 'Storm Peaks Ore'),
- (2, 11256, 9907, 0, 'Storm Peaks Ore'),
- (2, 11257, 9907, 0, 'Storm Peaks Ore'),
- (2, 11258, 9907, 0, 'Storm Peaks Ore'),
- (2, 11259, 9907, 0, 'Storm Peaks Ore'),
- (2, 11389, 9907, 0, 'Storm Peaks Ore');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement