I got two queries out of some christmas repack...
REMOVES OLD VALUES
Code:
/*REMOVE WEATHER*/
DELETE FROM `weather` WHERE `zoneid` = '1';
DELETE FROM `weather` WHERE `zoneid` = '3';
DELETE FROM `weather` WHERE `zoneid` = '4';
DELETE FROM `weather` WHERE `zoneid` = '8';
DELETE FROM `weather` WHERE `zoneid` = '10';
DELETE FROM `weather` WHERE `zoneid` = '11';
DELETE FROM `weather` WHERE `zoneid` = '12';
DELETE FROM `weather` WHERE `zoneid` = '14';
DELETE FROM `weather` WHERE `zoneid` = '15';
DELETE FROM `weather` WHERE `zoneid` = '16';
DELETE FROM `weather` WHERE `zoneid` = '17';
DELETE FROM `weather` WHERE `zoneid` = '28';
DELETE FROM `weather` WHERE `zoneid` = '33';
DELETE FROM `weather` WHERE `zoneid` = '36';
DELETE FROM `weather` WHERE `zoneid` = '38';
DELETE FROM `weather` WHERE `zoneid` = '40';
DELETE FROM `weather` WHERE `zoneid` = '41';
DELETE FROM `weather` WHERE `zoneid` = '44';
DELETE FROM `weather` WHERE `zoneid` = '45';
DELETE FROM `weather` WHERE `zoneid` = '46';
DELETE FROM `weather` WHERE `zoneid` = '47';
DELETE FROM `weather` WHERE `zoneid` = '51';
DELETE FROM `weather` WHERE `zoneid` = '85';
DELETE FROM `weather` WHERE `zoneid` = '130';
DELETE FROM `weather` WHERE `zoneid` = '139';
DELETE FROM `weather` WHERE `zoneid` = '141';
DELETE FROM `weather` WHERE `zoneid` = '148';
DELETE FROM `weather` WHERE `zoneid` = '215';
DELETE FROM `weather` WHERE `zoneid` = '267';
DELETE FROM `weather` WHERE `zoneid` = '331';
DELETE FROM `weather` WHERE `zoneid` = '357';
DELETE FROM `weather` WHERE `zoneid` = '361';
DELETE FROM `weather` WHERE `zoneid` = '400';
DELETE FROM `weather` WHERE `zoneid` = '405';
DELETE FROM `weather` WHERE `zoneid` = '406';
DELETE FROM `weather` WHERE `zoneid` = '440';
DELETE FROM `weather` WHERE `zoneid` = '490';
DELETE FROM `weather` WHERE `zoneid` = '618';
DELETE FROM `weather` WHERE `zoneid` = '1377';
DELETE FROM `weather` WHERE `zoneid` = '1519';
DELETE FROM `weather` WHERE `zoneid` = '1637';
DELETE FROM `weather` WHERE `zoneid` = '1638';
DELETE FROM `weather` WHERE `zoneid` = '1657';
DELETE FROM `weather` WHERE `zoneid` = '3430';
DELETE FROM `weather` WHERE `zoneid` = '3433';
DELETE FROM `weather` WHERE `zoneid` = '3518';
DELETE FROM `weather` WHERE `zoneid` = '3521';
DELETE FROM `weather` WHERE `zoneid` = '3524';
DELETE FROM `weather` WHERE `zoneid` = '3525';
DELETE FROM `weather` WHERE `zoneid` = '3557';
DELETE FROM `weather` WHERE `zoneid` = '3703';
Puts In new Values
Code:
/* IMPORT WEATHER */
INSERT INTO `weather` VALUES ('1', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('4', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('8', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('10', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('11', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('12', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('14', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('15', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('16', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('17', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('28', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('33', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('36', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('38', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('40', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('41', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('44', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('45', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('46', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('47', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('51', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('85', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('130', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('139', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('141', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('148', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('215', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('267', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('331', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('357', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('361', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('400', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('405', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('406', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('440', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('490', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('618', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('1377', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('1519', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('1637', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('1638', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('1657', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3430', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3433', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3518', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3521', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3524', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3525', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3557', '70', '1', '40', '8', '0', '0');
INSERT INTO `weather` VALUES ('3703', '70', '1', '40', '8', '0', '0');
And to get it normal again :
Code:
/* IMPORT DEFAULT WEATHER */
INSERT INTO `weather` VALUES ('1', '80', '8', '5', '1', '1', '2');
INSERT INTO `weather` VALUES ('3', '20', '16', '2', '2', '0', '0');
INSERT INTO `weather` VALUES ('4', '10', '1', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('8', '65', '1', '55', '2', '0', '0');
INSERT INTO `weather` VALUES ('10', '50', '2', '5', '1', '0', '0');
INSERT INTO `weather` VALUES ('11', '70', '2', '60', '4', '5', '1');
INSERT INTO `weather` VALUES ('12', '20', '2', '10', '4', '0', '0');
INSERT INTO `weather` VALUES ('14', '2', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('15', '40', '2', '35', '1', '0', '0');
INSERT INTO `weather` VALUES ('16', '25', '2', '5', '1', '0', '0');
INSERT INTO `weather` VALUES ('17', '1', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('28', '5', '2', '2', '1', '0', '0');
INSERT INTO `weather` VALUES ('33', '80', '2', '40', '4', '20', '1');
INSERT INTO `weather` VALUES ('36', '80', '8', '10', '1', '0', '0');
INSERT INTO `weather` VALUES ('38', '40', '2', '10', '4', '2', '1');
INSERT INTO `weather` VALUES ('40', '5', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('41', '10', '1', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('44', '20', '2', '5', '1', '0', '0');
INSERT INTO `weather` VALUES ('45', '20', '2', '5', '1', '0', '0');
INSERT INTO `weather` VALUES ('46', '5', '1', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('47', '30', '2', '10', '4', '5', '1');
INSERT INTO `weather` VALUES ('51', '5', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('85', '10', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('130', '20', '2', '5', '4', '0', '0');
INSERT INTO `weather` VALUES ('139', '5', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('141', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('148', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('215', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('267', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('331', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('357', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('361', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('400', '25', '16', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('405', '5', '2', '1', '16', '0', '0');
INSERT INTO `weather` VALUES ('406', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('440', '25', '16', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('490', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('618', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('1377', '25', '16', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('1519', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('1637', '5', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('1638', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('1657', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('3430', '5', '2', '0', '0', '0', '0');
INSERT INTO `weather` VALUES ('3433', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('3518', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('3521', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('3524', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('3525', '40', '2', '20', '4', '0', '0');
INSERT INTO `weather` VALUES ('3557', '40', '2', '20', '4', '5', '1');
INSERT INTO `weather` VALUES ('3703', '40', '2', '0', '0', '0', '0');