/* Changes the 2 rep values for both sides */
UPDATE character_reputation SET reputation=55 WHERE faction=911;
UPDATE character_reputation SET reputation=49 WHERE faction=930;
/* adds all the missing starting reps and values to both sides */
INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 922, 56, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 932, 58, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 933, 60, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 934, 62, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 935, 39, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 936, 59, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 941, 61, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 942, 64, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 946, 38, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 947, 37, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 967, 63, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 970, 65, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 978, 66, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 980, 43, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 989, 67, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 990, 57, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 1005, 58, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 1011, 58, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 1012, 58, '0', '0' FROM `character`; INSERT IGNORE INTO `character_reputation` SELECT `character`.`guid`, 1015, 58, '0', '2' FROM `character`;
/* adds the flags to horde */
UPDATE `character_reputation`, `character` SET `character_reputation`.`flags` = '2'
WHERE `character_reputation`.`guid` = `character`.`guid` AND (`character_reputation`.`faction` = '946' OR `character_reputation`.`faction` = '978') AND (`character`.`race` = 2 OR `character`.`race` = 5 OR `character`.`race` = 6 OR `character`.`race` = 8 OR `character`.`race` = 10 );
/* adds the flags to alliance */
UPDATE `character_reputation`, `character` SET `character_reputation`.`flags` = '2'
WHERE `character_reputation`.`guid` = `character`.`guid` AND (`character_reputation`.`faction` = 934) AND (`character`.`race` = 1 OR `character`.`race` = 3 OR `character`.`race` = 4 OR `character`.`race` = 7 OR `character`.`race` = 11 );