Difference between revisions of "IconToAllianceID Mappings/SQL"

From EVEDev
Jump to: navigation, search
m
 
Line 11: Line 11:
 
   ALTER TABLE `allianceTable` ADD COLUMN `icon` varchar(100) CHARACTER SET utf8_general_ci NULL DEFAULT  
 
   ALTER TABLE `allianceTable` ADD COLUMN `icon` varchar(100) CHARACTER SET utf8_general_ci NULL DEFAULT  
 
    
 
    
 +
  -- update 354 alliances
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_02' WHERE `t1`.`AllianceID` = '1974662341'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_02' WHERE `t1`.`AllianceID` = '1974662341'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_04' WHERE `t1`.`AllianceID` = '1967302747'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_04' WHERE `t1`.`AllianceID` = '1967302747'  
Line 31: Line 32:
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_01' WHERE `t1`.`AllianceID` = '342755901'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_01' WHERE `t1`.`AllianceID` = '342755901'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_02' WHERE `t1`.`AllianceID` = '1026886508'  
 
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_02' WHERE `t1`.`AllianceID` = '1026886508'  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_03' WHERE `t1`.`AllianceID` = '1220922756'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_03' WHERE `t1`.`AllianceID` = '1220922756';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_04' WHERE `t1`.`AllianceID` = '1259365112'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_04' WHERE `t1`.`AllianceID` = '1259365112';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_01' WHERE `t1`.`AllianceID` = '537119222'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_01' WHERE `t1`.`AllianceID` = '537119222';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_02' WHERE `t1`.`AllianceID` = '995013977'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_02' WHERE `t1`.`AllianceID` = '995013977';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_03' WHERE `t1`.`AllianceID` = '239739827'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_03' WHERE `t1`.`AllianceID` = '239739827';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_04' WHERE `t1`.`AllianceID` = '414616857'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_04' WHERE `t1`.`AllianceID` = '414616857';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_02' WHERE `t1`.`AllianceID` = '173739862'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_02' WHERE `t1`.`AllianceID` = '173739862';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_03' WHERE `t1`.`AllianceID` = '1441788490'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_03' WHERE `t1`.`AllianceID` = '1441788490';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_01' WHERE `t1`.`AllianceID` = '978733650'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_01' WHERE `t1`.`AllianceID` = '978733650';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_02' WHERE `t1`.`AllianceID` = '264952485'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_02' WHERE `t1`.`AllianceID` = '264952485';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_03' WHERE `t1`.`AllianceID` = '373024435'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_03' WHERE `t1`.`AllianceID` = '373024435';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_04' WHERE `t1`.`AllianceID` = '521381722'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_04' WHERE `t1`.`AllianceID` = '521381722';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_01' WHERE `t1`.`AllianceID` = '157368852'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_01' WHERE `t1`.`AllianceID` = '157368852';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_02' WHERE `t1`.`AllianceID` = '628083666'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_02' WHERE `t1`.`AllianceID` = '628083666';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_03' WHERE `t1`.`AllianceID` = '881159574'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_03' WHERE `t1`.`AllianceID` = '881159574';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_04' WHERE `t1`.`AllianceID` = '937904219'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_04' WHERE `t1`.`AllianceID` = '937904219';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_01' WHERE `t1`.`AllianceID` = '755412150'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_01' WHERE `t1`.`AllianceID` = '755412150';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_02' WHERE `t1`.`AllianceID` = '898521033'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_02' WHERE `t1`.`AllianceID` = '898521033';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_03' WHERE `t1`.`AllianceID` = '894206965'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_03' WHERE `t1`.`AllianceID` = '894206965';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_04' WHERE `t1`.`AllianceID` = '893275782'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_04' WHERE `t1`.`AllianceID` = '893275782';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_01' WHERE `t1`.`AllianceID` = '741557221'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_01' WHERE `t1`.`AllianceID` = '741557221';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_02' WHERE `t1`.`AllianceID` = '327815755'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_02' WHERE `t1`.`AllianceID` = '327815755';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_03' WHERE `t1`.`AllianceID` = '295773986'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_03' WHERE `t1`.`AllianceID` = '295773986';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_01' WHERE `t1`.`AllianceID` = '937099054'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_01' WHERE `t1`.`AllianceID` = '937099054';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_02' WHERE `t1`.`AllianceID` = '618162213'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_02' WHERE `t1`.`AllianceID` = '618162213';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_03' WHERE `t1`.`AllianceID` = '613888047'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_03' WHERE `t1`.`AllianceID` = '613888047';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_04' WHERE `t1`.`AllianceID` = '632866070'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_04' WHERE `t1`.`AllianceID` = '632866070';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_01' WHERE `t1`.`AllianceID` = '790581431'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_01' WHERE `t1`.`AllianceID` = '790581431';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_02' WHERE `t1`.`AllianceID` = '701459600'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_02' WHERE `t1`.`AllianceID` = '701459600';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_03' WHERE `t1`.`AllianceID` = '900209169'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_03' WHERE `t1`.`AllianceID` = '900209169';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_04' WHERE `t1`.`AllianceID` = '898789246'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_04' WHERE `t1`.`AllianceID` = '898789246';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_01' WHERE `t1`.`AllianceID` = '759477551'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_01' WHERE `t1`.`AllianceID` = '759477551';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_02' WHERE `t1`.`AllianceID` = '1327233264'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_02' WHERE `t1`.`AllianceID` = '1327233264';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_03' WHERE `t1`.`AllianceID` = '794831862'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_03' WHERE `t1`.`AllianceID` = '794831862';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_04' WHERE `t1`.`AllianceID` = '735932392'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_04' WHERE `t1`.`AllianceID` = '735932392';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_01' WHERE `t1`.`AllianceID` = '830660878'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_01' WHERE `t1`.`AllianceID` = '830660878';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_02' WHERE `t1`.`AllianceID` = '922541302'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_02' WHERE `t1`.`AllianceID` = '922541302';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_03' WHERE `t1`.`AllianceID` = '845358580'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_03' WHERE `t1`.`AllianceID` = '845358580';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_04' WHERE `t1`.`AllianceID` = '830476259'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_04' WHERE `t1`.`AllianceID` = '830476259';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_01' WHERE `t1`.`AllianceID` = '294099361'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_01' WHERE `t1`.`AllianceID` = '294099361';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_02' WHERE `t1`.`AllianceID` = '225947254'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_02' WHERE `t1`.`AllianceID` = '225947254';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_03' WHERE `t1`.`AllianceID` = '873672554'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_03' WHERE `t1`.`AllianceID` = '873672554';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_04' WHERE `t1`.`AllianceID` = '820673945'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_04' WHERE `t1`.`AllianceID` = '820673945';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_01' WHERE `t1`.`AllianceID` = '780843225'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_01' WHERE `t1`.`AllianceID` = '780843225';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_02' WHERE `t1`.`AllianceID` = '693547580'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_02' WHERE `t1`.`AllianceID` = '693547580';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_03' WHERE `t1`.`AllianceID` = '521550159'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_03' WHERE `t1`.`AllianceID` = '521550159';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_04' WHERE `t1`.`AllianceID` = '980676917'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_04' WHERE `t1`.`AllianceID` = '980676917';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_01' WHERE `t1`.`AllianceID` = '819637246'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_01' WHERE `t1`.`AllianceID` = '819637246';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_02' WHERE `t1`.`AllianceID` = '851986092'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_02' WHERE `t1`.`AllianceID` = '851986092';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_03' WHERE `t1`.`AllianceID` = '68685221'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_03' WHERE `t1`.`AllianceID` = '68685221';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_04' WHERE `t1`.`AllianceID` = '657191413'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_04' WHERE `t1`.`AllianceID` = '657191413';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_01' WHERE `t1`.`AllianceID` = '628991027'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_01' WHERE `t1`.`AllianceID` = '628991027';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_02' WHERE `t1`.`AllianceID` = '916366622'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_02' WHERE `t1`.`AllianceID` = '916366622';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_03' WHERE `t1`.`AllianceID` = '709354881'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_03' WHERE `t1`.`AllianceID` = '709354881';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_04' WHERE `t1`.`AllianceID` = '902819350'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_04' WHERE `t1`.`AllianceID` = '902819350';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_01' WHERE `t1`.`AllianceID` = '680656525'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_01' WHERE `t1`.`AllianceID` = '680656525';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_02' WHERE `t1`.`AllianceID` = '280458946'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_02' WHERE `t1`.`AllianceID` = '280458946';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_03' WHERE `t1`.`AllianceID` = '651394709'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_03' WHERE `t1`.`AllianceID` = '651394709';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_04' WHERE `t1`.`AllianceID` = '228932850'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_04' WHERE `t1`.`AllianceID` = '228932850';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_01' WHERE `t1`.`AllianceID` = '166439722'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_01' WHERE `t1`.`AllianceID` = '166439722';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_02' WHERE `t1`.`AllianceID` = '824518128'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_02' WHERE `t1`.`AllianceID` = '824518128';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_03' WHERE `t1`.`AllianceID` = '939383666'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_03' WHERE `t1`.`AllianceID` = '939383666';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_04' WHERE `t1`.`AllianceID` = '764328405'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_04' WHERE `t1`.`AllianceID` = '764328405';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_02' WHERE `t1`.`AllianceID` = '853118644'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_02' WHERE `t1`.`AllianceID` = '853118644';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_03' WHERE `t1`.`AllianceID` = '133380850'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_03' WHERE `t1`.`AllianceID` = '133380850';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_04' WHERE `t1`.`AllianceID` = '970258311'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_04' WHERE `t1`.`AllianceID` = '970258311';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_01' WHERE `t1`.`AllianceID` = '719152641'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_01' WHERE `t1`.`AllianceID` = '719152641';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_02' WHERE `t1`.`AllianceID` = '630715029'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_02' WHERE `t1`.`AllianceID` = '630715029';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_03' WHERE `t1`.`AllianceID` = '101400224'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_03' WHERE `t1`.`AllianceID` = '101400224';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_04' WHERE `t1`.`AllianceID` = '227106310'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_04' WHERE `t1`.`AllianceID` = '227106310';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_01' WHERE `t1`.`AllianceID` = '734409701'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_01' WHERE `t1`.`AllianceID` = '734409701';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_02' WHERE `t1`.`AllianceID` = '162958353'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_02' WHERE `t1`.`AllianceID` = '162958353';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_03' WHERE `t1`.`AllianceID` = '230415007'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_03' WHERE `t1`.`AllianceID` = '230415007';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_04' WHERE `t1`.`AllianceID` = '861668420'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_04' WHERE `t1`.`AllianceID` = '861668420';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_01' WHERE `t1`.`AllianceID` = '134442284'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_01' WHERE `t1`.`AllianceID` = '134442284';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_02' WHERE `t1`.`AllianceID` = '185649283'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_02' WHERE `t1`.`AllianceID` = '185649283';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_03' WHERE `t1`.`AllianceID` = '348908787'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_03' WHERE `t1`.`AllianceID` = '348908787';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_04' WHERE `t1`.`AllianceID` = '210997485'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_04' WHERE `t1`.`AllianceID` = '210997485';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_02' WHERE `t1`.`AllianceID` = '409364568'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_02' WHERE `t1`.`AllianceID` = '409364568';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_03' WHERE `t1`.`AllianceID` = '670047585'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_03' WHERE `t1`.`AllianceID` = '670047585';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_04' WHERE `t1`.`AllianceID` = '113001540'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_04' WHERE `t1`.`AllianceID` = '113001540';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_01' WHERE `t1`.`AllianceID` = '952720760'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_01' WHERE `t1`.`AllianceID` = '952720760';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_02' WHERE `t1`.`AllianceID` = '846017099'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_02' WHERE `t1`.`AllianceID` = '846017099';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_03' WHERE `t1`.`AllianceID` = '650545116'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_03' WHERE `t1`.`AllianceID` = '650545116';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_04' WHERE `t1`.`AllianceID` = '567099488'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_04' WHERE `t1`.`AllianceID` = '567099488';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_01' WHERE `t1`.`AllianceID` = '614102619'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_01' WHERE `t1`.`AllianceID` = '614102619';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_02' WHERE `t1`.`AllianceID` = '211088879'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_02' WHERE `t1`.`AllianceID` = '211088879';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_03' WHERE `t1`.`AllianceID` = '240835459'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_03' WHERE `t1`.`AllianceID` = '240835459';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_04' WHERE `t1`.`AllianceID` = '347057845'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_04' WHERE `t1`.`AllianceID` = '347057845';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_01' WHERE `t1`.`AllianceID` = '118499027'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_01' WHERE `t1`.`AllianceID` = '118499027';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_02' WHERE `t1`.`AllianceID` = '443039986'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_02' WHERE `t1`.`AllianceID` = '443039986';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_03' WHERE `t1`.`AllianceID` = '243562438'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_03' WHERE `t1`.`AllianceID` = '243562438';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_04' WHERE `t1`.`AllianceID` = '488282414'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_04' WHERE `t1`.`AllianceID` = '488282414';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_01' WHERE `t1`.`AllianceID` = '119175035'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_01' WHERE `t1`.`AllianceID` = '119175035';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_02' WHERE `t1`.`AllianceID` = '935962111'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_02' WHERE `t1`.`AllianceID` = '935962111';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_03' WHERE `t1`.`AllianceID` = '1081180970'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_03' WHERE `t1`.`AllianceID` = '1081180970';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_04' WHERE `t1`.`AllianceID` = '647194493'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_04' WHERE `t1`.`AllianceID` = '647194493';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_01' WHERE `t1`.`AllianceID` = '309570220'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_01' WHERE `t1`.`AllianceID` = '309570220';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_02' WHERE `t1`.`AllianceID` = '829299188'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_02' WHERE `t1`.`AllianceID` = '829299188';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_03' WHERE `t1`.`AllianceID` = '826025559'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_03' WHERE `t1`.`AllianceID` = '826025559';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_04' WHERE `t1`.`AllianceID` = '213401527'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_04' WHERE `t1`.`AllianceID` = '213401527';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_01' WHERE `t1`.`AllianceID` = '838011673'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_01' WHERE `t1`.`AllianceID` = '838011673';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_02' WHERE `t1`.`AllianceID` = '937872513'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_02' WHERE `t1`.`AllianceID` = '937872513';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_03' WHERE `t1`.`AllianceID` = '389924442'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_03' WHERE `t1`.`AllianceID` = '389924442';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_04' WHERE `t1`.`AllianceID` = '927767240'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_04' WHERE `t1`.`AllianceID` = '927767240';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_01' WHERE `t1`.`AllianceID` = '581956272'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_01' WHERE `t1`.`AllianceID` = '581956272';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_02' WHERE `t1`.`AllianceID` = '716050598'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_02' WHERE `t1`.`AllianceID` = '716050598';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_03' WHERE `t1`.`AllianceID` = '102441019'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_03' WHERE `t1`.`AllianceID` = '102441019';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_04' WHERE `t1`.`AllianceID` = '487868936'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_04' WHERE `t1`.`AllianceID` = '487868936';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_01' WHERE `t1`.`AllianceID` = '891616204'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_01' WHERE `t1`.`AllianceID` = '891616204';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_02' WHERE `t1`.`AllianceID` = '822746991'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_02' WHERE `t1`.`AllianceID` = '822746991';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_03' WHERE `t1`.`AllianceID` = '217728874'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_03' WHERE `t1`.`AllianceID` = '217728874';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_04' WHERE `t1`.`AllianceID` = '204298938'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_04' WHERE `t1`.`AllianceID` = '204298938';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_01' WHERE `t1`.`AllianceID` = '1178366869'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_01' WHERE `t1`.`AllianceID` = '1178366869';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_02' WHERE `t1`.`AllianceID` = '1281684917'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_02' WHERE `t1`.`AllianceID` = '1281684917';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_03' WHERE `t1`.`AllianceID` = '283331937'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_03' WHERE `t1`.`AllianceID` = '283331937';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_04' WHERE `t1`.`AllianceID` = '107660664'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_04' WHERE `t1`.`AllianceID` = '107660664';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_01' WHERE `t1`.`AllianceID` = '202628879'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_01' WHERE `t1`.`AllianceID` = '202628879';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_02' WHERE `t1`.`AllianceID` = '689376961'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_02' WHERE `t1`.`AllianceID` = '689376961';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_03' WHERE `t1`.`AllianceID` = '129639137'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_03' WHERE `t1`.`AllianceID` = '129639137';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_04' WHERE `t1`.`AllianceID` = '662918705'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_04' WHERE `t1`.`AllianceID` = '662918705';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_01' WHERE `t1`.`AllianceID` = '927094775'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_01' WHERE `t1`.`AllianceID` = '927094775';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_02' WHERE `t1`.`AllianceID` = '902819350'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_02' WHERE `t1`.`AllianceID` = '902819350';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_03' WHERE `t1`.`AllianceID` = '159826257'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_03' WHERE `t1`.`AllianceID` = '159826257';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_04' WHERE `t1`.`AllianceID` = '348978562'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_04' WHERE `t1`.`AllianceID` = '348978562';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_01' WHERE `t1`.`AllianceID` = '1657456469'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_01' WHERE `t1`.`AllianceID` = '1657456469';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_02' WHERE `t1`.`AllianceID` = '1617353742'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_02' WHERE `t1`.`AllianceID` = '1617353742';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_03' WHERE `t1`.`AllianceID` = '1474035720'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_03' WHERE `t1`.`AllianceID` = '1474035720';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_04' WHERE `t1`.`AllianceID` = '1171357902'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_04' WHERE `t1`.`AllianceID` = '1171357902';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_01' WHERE `t1`.`AllianceID` = '419865710'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_01' WHERE `t1`.`AllianceID` = '419865710';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_02' WHERE `t1`.`AllianceID` = '979280912'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_02' WHERE `t1`.`AllianceID` = '979280912';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_03' WHERE `t1`.`AllianceID` = '424172891'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_03' WHERE `t1`.`AllianceID` = '424172891';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_04' WHERE `t1`.`AllianceID` = '670303846'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_04' WHERE `t1`.`AllianceID` = '670303846';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_01' WHERE `t1`.`AllianceID` = '973532707'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_01' WHERE `t1`.`AllianceID` = '973532707';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_02' WHERE `t1`.`AllianceID` = '386292982'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_02' WHERE `t1`.`AllianceID` = '386292982';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_03' WHERE `t1`.`AllianceID` = '427019530'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_03' WHERE `t1`.`AllianceID` = '427019530';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_04' WHERE `t1`.`AllianceID` = '942594614'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_04' WHERE `t1`.`AllianceID` = '942594614';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_01' WHERE `t1`.`AllianceID` = '1439278447'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_01' WHERE `t1`.`AllianceID` = '1439278447';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_02' WHERE `t1`.`AllianceID` = '305786028'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_02' WHERE `t1`.`AllianceID` = '305786028';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_03' WHERE `t1`.`AllianceID` = '361595181'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_03' WHERE `t1`.`AllianceID` = '361595181';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_04' WHERE `t1`.`AllianceID` = '655846070'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_04' WHERE `t1`.`AllianceID` = '655846070';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_01' WHERE `t1`.`AllianceID` = '1731851374'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_01' WHERE `t1`.`AllianceID` = '1731851374';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_02' WHERE `t1`.`AllianceID` = '364303645'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_02' WHERE `t1`.`AllianceID` = '364303645';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_03' WHERE `t1`.`AllianceID` = '897877797'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_03' WHERE `t1`.`AllianceID` = '897877797';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_04' WHERE `t1`.`AllianceID` = '444203333'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_04' WHERE `t1`.`AllianceID` = '444203333';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_01' WHERE `t1`.`AllianceID` = '1733643802'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_01' WHERE `t1`.`AllianceID` = '1733643802';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_02' WHERE `t1`.`AllianceID` = '287387070'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_02' WHERE `t1`.`AllianceID` = '287387070';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_03' WHERE `t1`.`AllianceID` = '1538108032'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_03' WHERE `t1`.`AllianceID` = '1538108032';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_04' WHERE `t1`.`AllianceID` = '1334228324'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_04' WHERE `t1`.`AllianceID` = '1334228324';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_01' WHERE `t1`.`AllianceID` = '562804261'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_01' WHERE `t1`.`AllianceID` = '562804261';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_02' WHERE `t1`.`AllianceID` = '136013311'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_02' WHERE `t1`.`AllianceID` = '136013311';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_03' WHERE `t1`.`AllianceID` = '1305592065'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_03' WHERE `t1`.`AllianceID` = '1305592065';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_04' WHERE `t1`.`AllianceID` = '1778250850'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_04' WHERE `t1`.`AllianceID` = '1778250850';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_01' WHERE `t1`.`AllianceID` = '1326438017'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_01' WHERE `t1`.`AllianceID` = '1326438017';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_02' WHERE `t1`.`AllianceID` = '500912361'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_02' WHERE `t1`.`AllianceID` = '500912361';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_03' WHERE `t1`.`AllianceID` = '344549974'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_03' WHERE `t1`.`AllianceID` = '344549974';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_04' WHERE `t1`.`AllianceID` = '1633825631'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_04' WHERE `t1`.`AllianceID` = '1633825631';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_01' WHERE `t1`.`AllianceID` = '693829445'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_01' WHERE `t1`.`AllianceID` = '693829445';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_02' WHERE `t1`.`AllianceID` = '1617262222'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_02' WHERE `t1`.`AllianceID` = '1617262222';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_03' WHERE `t1`.`AllianceID` = '273254349'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_03' WHERE `t1`.`AllianceID` = '273254349';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_04' WHERE `t1`.`AllianceID` = '268264129'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_04' WHERE `t1`.`AllianceID` = '268264129';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_01' WHERE `t1`.`AllianceID` = '812396591'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_01' WHERE `t1`.`AllianceID` = '812396591';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_02' WHERE `t1`.`AllianceID` = '1399057309'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_02' WHERE `t1`.`AllianceID` = '1399057309';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_03' WHERE `t1`.`AllianceID` = '1510350889'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_03' WHERE `t1`.`AllianceID` = '1510350889';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_04' WHERE `t1`.`AllianceID` = '176358229'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_04' WHERE `t1`.`AllianceID` = '176358229';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_01' WHERE `t1`.`AllianceID` = '1259761645'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_01' WHERE `t1`.`AllianceID` = '1259761645';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_02' WHERE `t1`.`AllianceID` = '915114162'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_02' WHERE `t1`.`AllianceID` = '915114162';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_03' WHERE `t1`.`AllianceID` = '714390465'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_03' WHERE `t1`.`AllianceID` = '714390465';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_04' WHERE `t1`.`AllianceID` = '664511700'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_04' WHERE `t1`.`AllianceID` = '664511700';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_01' WHERE `t1`.`AllianceID` = '933731581'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_01' WHERE `t1`.`AllianceID` = '933731581';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_02' WHERE `t1`.`AllianceID` = '1218667238'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_02' WHERE `t1`.`AllianceID` = '1218667238';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_03' WHERE `t1`.`AllianceID` = '1333213624'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_03' WHERE `t1`.`AllianceID` = '1333213624';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_04' WHERE `t1`.`AllianceID` = '585089448'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_04' WHERE `t1`.`AllianceID` = '585089448';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_01' WHERE `t1`.`AllianceID` = '985451579'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_01' WHERE `t1`.`AllianceID` = '985451579';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_02' WHERE `t1`.`AllianceID` = '982284363'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_02' WHERE `t1`.`AllianceID` = '982284363';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_03' WHERE `t1`.`AllianceID` = '485127066'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_03' WHERE `t1`.`AllianceID` = '485127066';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_04' WHERE `t1`.`AllianceID` = '702036928'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_04' WHERE `t1`.`AllianceID` = '702036928';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_01' WHERE `t1`.`AllianceID` = '1231017993'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_01' WHERE `t1`.`AllianceID` = '1231017993';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_02' WHERE `t1`.`AllianceID` = '494403294'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_02' WHERE `t1`.`AllianceID` = '494403294';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_03' WHERE `t1`.`AllianceID` = '227446060'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_03' WHERE `t1`.`AllianceID` = '227446060';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_04' WHERE `t1`.`AllianceID` = '581933217'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_04' WHERE `t1`.`AllianceID` = '581933217';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_01' WHERE `t1`.`AllianceID` = '1492453355'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_01' WHERE `t1`.`AllianceID` = '1492453355';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_03' WHERE `t1`.`AllianceID` = '588312332'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_03' WHERE `t1`.`AllianceID` = '588312332';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_04' WHERE `t1`.`AllianceID` = '145834652'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_04' WHERE `t1`.`AllianceID` = '145834652';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_01' WHERE `t1`.`AllianceID` = '748398192'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_01' WHERE `t1`.`AllianceID` = '748398192';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_02' WHERE `t1`.`AllianceID` = '605296635'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_02' WHERE `t1`.`AllianceID` = '605296635';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_03' WHERE `t1`.`AllianceID` = '923562637'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_03' WHERE `t1`.`AllianceID` = '923562637';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_04' WHERE `t1`.`AllianceID` = '1436568627'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_04' WHERE `t1`.`AllianceID` = '1436568627';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_01' WHERE `t1`.`AllianceID` = '709173242'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_01' WHERE `t1`.`AllianceID` = '709173242';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_02' WHERE `t1`.`AllianceID` = '921274069'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_02' WHERE `t1`.`AllianceID` = '921274069';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_03' WHERE `t1`.`AllianceID` = '161789084'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_03' WHERE `t1`.`AllianceID` = '161789084';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_04' WHERE `t1`.`AllianceID` = '248309546'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_04' WHERE `t1`.`AllianceID` = '248309546';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_01' WHERE `t1`.`AllianceID` = '288377808'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_01' WHERE `t1`.`AllianceID` = '288377808';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_02' WHERE `t1`.`AllianceID` = '1358408357'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_02' WHERE `t1`.`AllianceID` = '1358408357';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_03' WHERE `t1`.`AllianceID` = '154532576'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_03' WHERE `t1`.`AllianceID` = '154532576';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_04' WHERE `t1`.`AllianceID` = '872127712'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_04' WHERE `t1`.`AllianceID` = '872127712';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_01' WHERE `t1`.`AllianceID` = '306798858'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_01' WHERE `t1`.`AllianceID` = '306798858';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_02' WHERE `t1`.`AllianceID` = '729078756'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_02' WHERE `t1`.`AllianceID` = '729078756';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_03' WHERE `t1`.`AllianceID` = '223369706'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_03' WHERE `t1`.`AllianceID` = '223369706';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_04' WHERE `t1`.`AllianceID` = '1083654693'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_04' WHERE `t1`.`AllianceID` = '1083654693';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_01' WHERE `t1`.`AllianceID` = '275725590'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_01' WHERE `t1`.`AllianceID` = '275725590';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_02' WHERE `t1`.`AllianceID` = '831252438'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_02' WHERE `t1`.`AllianceID` = '831252438';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_03' WHERE `t1`.`AllianceID` = '284278305'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_03' WHERE `t1`.`AllianceID` = '284278305';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_04' WHERE `t1`.`AllianceID` = '917526329'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_04' WHERE `t1`.`AllianceID` = '917526329';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_01' WHERE `t1`.`AllianceID` = '1471767458'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_01' WHERE `t1`.`AllianceID` = '1471767458';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_02' WHERE `t1`.`AllianceID` = '1236486154'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_02' WHERE `t1`.`AllianceID` = '1236486154';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_03' WHERE `t1`.`AllianceID` = '1470696988'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_03' WHERE `t1`.`AllianceID` = '1470696988';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_04' WHERE `t1`.`AllianceID` = '628280874'   
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_04' WHERE `t1`.`AllianceID` = '628280874';  
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_01' WHERE `t1`.`AllianceID` = '1695410410'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_01' WHERE `t1`.`AllianceID` = '1695410410';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_02' WHERE `t1`.`AllianceID` = '961848448'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_02' WHERE `t1`.`AllianceID` = '961848448';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_03' WHERE `t1`.`AllianceID` = '1003067784'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_03' WHERE `t1`.`AllianceID` = '1003067784';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_04' WHERE `t1`.`AllianceID` = '682915307'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_04' WHERE `t1`.`AllianceID` = '682915307';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_01' WHERE `t1`.`AllianceID` = '630969519'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_01' WHERE `t1`.`AllianceID` = '630969519';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_02' WHERE `t1`.`AllianceID` = '330639100'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_02' WHERE `t1`.`AllianceID` = '330639100';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_03' WHERE `t1`.`AllianceID` = '156756939'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_03' WHERE `t1`.`AllianceID` = '156756939';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_04' WHERE `t1`.`AllianceID` = '843638752'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_04' WHERE `t1`.`AllianceID` = '843638752';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_01' WHERE `t1`.`AllianceID` = '1015092638'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_01' WHERE `t1`.`AllianceID` = '1015092638';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_02' WHERE `t1`.`AllianceID` = '1114190180'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_02' WHERE `t1`.`AllianceID` = '1114190180';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_03' WHERE `t1`.`AllianceID` = '1040376220'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_03' WHERE `t1`.`AllianceID` = '1040376220';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_04' WHERE `t1`.`AllianceID` = '496431473'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_04' WHERE `t1`.`AllianceID` = '496431473';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_01' WHERE `t1`.`AllianceID` = '1206229240'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_01' WHERE `t1`.`AllianceID` = '1206229240';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_02' WHERE `t1`.`AllianceID` = '959524143'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_02' WHERE `t1`.`AllianceID` = '959524143';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_03' WHERE `t1`.`AllianceID` = '596408142'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_03' WHERE `t1`.`AllianceID` = '596408142';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_04' WHERE `t1`.`AllianceID` = '607835872'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_04' WHERE `t1`.`AllianceID` = '607835872';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_01' WHERE `t1`.`AllianceID` = '1325294000'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_01' WHERE `t1`.`AllianceID` = '1325294000';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_02' WHERE `t1`.`AllianceID` = '1438160193'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_02' WHERE `t1`.`AllianceID` = '1438160193';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_04' WHERE `t1`.`AllianceID` = '1598600949'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_04' WHERE `t1`.`AllianceID` = '1598600949';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_01' WHERE `t1`.`AllianceID` = '384524280'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_01' WHERE `t1`.`AllianceID` = '384524280';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_02' WHERE `t1`.`AllianceID` = '979339647'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_02' WHERE `t1`.`AllianceID` = '979339647';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_03' WHERE `t1`.`AllianceID` = '1793821574'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_03' WHERE `t1`.`AllianceID` = '1793821574';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_04' WHERE `t1`.`AllianceID` = '1184264779'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_04' WHERE `t1`.`AllianceID` = '1184264779';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_01' WHERE `t1`.`AllianceID` = '320774832'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_01' WHERE `t1`.`AllianceID` = '320774832';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_02' WHERE `t1`.`AllianceID` = '1324392282'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_02' WHERE `t1`.`AllianceID` = '1324392282';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_03' WHERE `t1`.`AllianceID` = '878866718'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_03' WHERE `t1`.`AllianceID` = '878866718';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_04' WHERE `t1`.`AllianceID` = '1813726532'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_04' WHERE `t1`.`AllianceID` = '1813726532';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_01' WHERE `t1`.`AllianceID` = '845224486'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_01' WHERE `t1`.`AllianceID` = '845224486';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_02' WHERE `t1`.`AllianceID` = '655616830'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_02' WHERE `t1`.`AllianceID` = '655616830';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_03' WHERE `t1`.`AllianceID` = '704856874'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_03' WHERE `t1`.`AllianceID` = '704856874';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_04' WHERE `t1`.`AllianceID` = '613493214'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_04' WHERE `t1`.`AllianceID` = '613493214';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_01' WHERE `t1`.`AllianceID` = '817618922'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_01' WHERE `t1`.`AllianceID` = '817618922';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_02' WHERE `t1`.`AllianceID` = '969494429'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_02' WHERE `t1`.`AllianceID` = '969494429';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_03' WHERE `t1`.`AllianceID` = '313987070'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_03' WHERE `t1`.`AllianceID` = '313987070';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_04' WHERE `t1`.`AllianceID` = '166924340'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_04' WHERE `t1`.`AllianceID` = '166924340';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_01' WHERE `t1`.`AllianceID` = '151380924'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_01' WHERE `t1`.`AllianceID` = '151380924';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_02' WHERE `t1`.`AllianceID` = '1353656102'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_02' WHERE `t1`.`AllianceID` = '1353656102';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_03' WHERE `t1`.`AllianceID` = '1206021109'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_03' WHERE `t1`.`AllianceID` = '1206021109';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_04' WHERE `t1`.`AllianceID` = '1653863703'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_04' WHERE `t1`.`AllianceID` = '1653863703';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_01' WHERE `t1`.`AllianceID` = '1302181348'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_01' WHERE `t1`.`AllianceID` = '1302181348';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_02' WHERE `t1`.`AllianceID` = '1173986008'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_02' WHERE `t1`.`AllianceID` = '1173986008';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_03' WHERE `t1`.`AllianceID` = '905407070'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_03' WHERE `t1`.`AllianceID` = '905407070';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_04' WHERE `t1`.`AllianceID` = '715032274'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_04' WHERE `t1`.`AllianceID` = '715032274';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_01' WHERE `t1`.`AllianceID` = '614765194'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_01' WHERE `t1`.`AllianceID` = '614765194';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_02' WHERE `t1`.`AllianceID` = '586234421'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_02' WHERE `t1`.`AllianceID` = '586234421';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_03' WHERE `t1`.`AllianceID` = '455411710'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_03' WHERE `t1`.`AllianceID` = '455411710';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_04' WHERE `t1`.`AllianceID` = '1254379905'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_04' WHERE `t1`.`AllianceID` = '1254379905';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_01' WHERE `t1`.`AllianceID` = '1309030271'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_01' WHERE `t1`.`AllianceID` = '1309030271';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_02' WHERE `t1`.`AllianceID` = '306798858'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_02' WHERE `t1`.`AllianceID` = '306798858';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_03' WHERE `t1`.`AllianceID` = '1402003305'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_03' WHERE `t1`.`AllianceID` = '1402003305';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_04' WHERE `t1`.`AllianceID` = '1097355312'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_04' WHERE `t1`.`AllianceID` = '1097355312';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_01' WHERE `t1`.`AllianceID` = '1433868460'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_01' WHERE `t1`.`AllianceID` = '1433868460';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_02' WHERE `t1`.`AllianceID` = '1104449696'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_02' WHERE `t1`.`AllianceID` = '1104449696';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_03' WHERE `t1`.`AllianceID` = '448511760'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_03' WHERE `t1`.`AllianceID` = '448511760';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_04' WHERE `t1`.`AllianceID` = '1260627398'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_04' WHERE `t1`.`AllianceID` = '1260627398';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_01' WHERE `t1`.`AllianceID` = '999297753'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_01' WHERE `t1`.`AllianceID` = '999297753';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_02' WHERE `t1`.`AllianceID` = '1161017884'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_02' WHERE `t1`.`AllianceID` = '1161017884';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_03' WHERE `t1`.`AllianceID` = '1583356798'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_03' WHERE `t1`.`AllianceID` = '1583356798';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_04' WHERE `t1`.`AllianceID` = '294930214'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_04' WHERE `t1`.`AllianceID` = '294930214';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_01' WHERE `t1`.`AllianceID` = '580611538'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_01' WHERE `t1`.`AllianceID` = '580611538';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_02' WHERE `t1`.`AllianceID` = '673817002'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_02' WHERE `t1`.`AllianceID` = '673817002';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_03' WHERE `t1`.`AllianceID` = '1136157539'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_03' WHERE `t1`.`AllianceID` = '1136157539';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_04' WHERE `t1`.`AllianceID` = '1490024253'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_04' WHERE `t1`.`AllianceID` = '1490024253';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_01' WHERE `t1`.`AllianceID` = '1453523683'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_01' WHERE `t1`.`AllianceID` = '1453523683';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_02' WHERE `t1`.`AllianceID` = '659333041'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_02' WHERE `t1`.`AllianceID` = '659333041';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_03' WHERE `t1`.`AllianceID` = '686603391'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_03' WHERE `t1`.`AllianceID` = '686603391';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_04' WHERE `t1`.`AllianceID` = '911652170'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_04' WHERE `t1`.`AllianceID` = '911652170';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_01' WHERE `t1`.`AllianceID` = '532949740'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_01' WHERE `t1`.`AllianceID` = '532949740';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_02' WHERE `t1`.`AllianceID` = '1499311634'  
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_02' WHERE `t1`.`AllianceID` = '1499311634';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_03' WHERE `t1`.`AllianceID` = '1480700727'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_03' WHERE `t1`.`AllianceID` = '1480700727';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_04' WHERE `t1`.`AllianceID` = '166924340'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_04' WHERE `t1`.`AllianceID` = '166924340';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_02' WHERE `t1`.`AllianceID` = '896695182'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_02' WHERE `t1`.`AllianceID` = '896695182';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_03' WHERE `t1`.`AllianceID` = '833571739'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_03' WHERE `t1`.`AllianceID` = '833571739';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_04' WHERE `t1`.`AllianceID` = '437579728'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_04' WHERE `t1`.`AllianceID` = '437579728';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_01' WHERE `t1`.`AllianceID` = '1087160562'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_01' WHERE `t1`.`AllianceID` = '1087160562';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_02' WHERE `t1`.`AllianceID` = '1538382401'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_02' WHERE `t1`.`AllianceID` = '1538382401';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_03' WHERE `t1`.`AllianceID` = '1685237465'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_03' WHERE `t1`.`AllianceID` = '1685237465';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_04' WHERE `t1`.`AllianceID` = '861898608'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_04' WHERE `t1`.`AllianceID` = '861898608';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_01' WHERE `t1`.`AllianceID` = '264679431'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_01' WHERE `t1`.`AllianceID` = '264679431';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_03' WHERE `t1`.`AllianceID` = '1007323374'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_03' WHERE `t1`.`AllianceID` = '1007323374';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_04' WHERE `t1`.`AllianceID` = '849565342'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_04' WHERE `t1`.`AllianceID` = '849565342';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_01' WHERE `t1`.`AllianceID` = '1294094452'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_01' WHERE `t1`.`AllianceID` = '1294094452';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_02' WHERE `t1`.`AllianceID` = '608839271'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_02' WHERE `t1`.`AllianceID` = '608839271';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_03' WHERE `t1`.`AllianceID` = '1550724751'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_03' WHERE `t1`.`AllianceID` = '1550724751';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_04' WHERE `t1`.`AllianceID` = '1987964414'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_04' WHERE `t1`.`AllianceID` = '1987964414';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_01' WHERE `t1`.`AllianceID` = '855555544'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_01' WHERE `t1`.`AllianceID` = '855555544';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_02' WHERE `t1`.`AllianceID` = '1610350138'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_02' WHERE `t1`.`AllianceID` = '1610350138';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_04' WHERE `t1`.`AllianceID` = '1798720604'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_04' WHERE `t1`.`AllianceID` = '1798720604';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='84_04' WHERE `t1`.`AllianceID` = '703129312'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='84_04' WHERE `t1`.`AllianceID` = '703129312';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_01' WHERE `t1`.`AllianceID` = '505495351'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_01' WHERE `t1`.`AllianceID` = '505495351';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_03' WHERE `t1`.`AllianceID` = '1045152576'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_03' WHERE `t1`.`AllianceID` = '1045152576';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_04' WHERE `t1`.`AllianceID` = '1658767552'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_04' WHERE `t1`.`AllianceID` = '1658767552';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_01' WHERE `t1`.`AllianceID` = '215451578'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_01' WHERE `t1`.`AllianceID` = '215451578';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_02' WHERE `t1`.`AllianceID` = '1323245561'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_02' WHERE `t1`.`AllianceID` = '1323245561';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_03' WHERE `t1`.`AllianceID` = '1393073050'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_03' WHERE `t1`.`AllianceID` = '1393073050';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_01' WHERE `t1`.`AllianceID` = '1854757882'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_01' WHERE `t1`.`AllianceID` = '1854757882';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_02' WHERE `t1`.`AllianceID` = '1960982151'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_02' WHERE `t1`.`AllianceID` = '1960982151';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_03' WHERE `t1`.`AllianceID` = '1315108737'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_03' WHERE `t1`.`AllianceID` = '1315108737';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_04' WHERE `t1`.`AllianceID` = '1012079455'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_04' WHERE `t1`.`AllianceID` = '1012079455';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_01' WHERE `t1`.`AllianceID` = '1411711376'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_01' WHERE `t1`.`AllianceID` = '1411711376';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_02' WHERE `t1`.`AllianceID` = '675031356'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_02' WHERE `t1`.`AllianceID` = '675031356';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_03' WHERE `t1`.`AllianceID` = '1489655626'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_03' WHERE `t1`.`AllianceID` = '1489655626';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_04' WHERE `t1`.`AllianceID` = '349521578'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_04' WHERE `t1`.`AllianceID` = '349521578';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_01' WHERE `t1`.`AllianceID` = '1609780791'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_01' WHERE `t1`.`AllianceID` = '1609780791';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_02' WHERE `t1`.`AllianceID` = '418808473'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_02' WHERE `t1`.`AllianceID` = '418808473';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_03' WHERE `t1`.`AllianceID` = '1913014423'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_03' WHERE `t1`.`AllianceID` = '1913014423';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_04' WHERE `t1`.`AllianceID` = '1671078301'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_04' WHERE `t1`.`AllianceID` = '1671078301';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_01' WHERE `t1`.`AllianceID` = '1980649055'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_01' WHERE `t1`.`AllianceID` = '1980649055';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_02' WHERE `t1`.`AllianceID` = '1096087041'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_02' WHERE `t1`.`AllianceID` = '1096087041';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_03' WHERE `t1`.`AllianceID` = '1482692012'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_03' WHERE `t1`.`AllianceID` = '1482692012';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_04' WHERE `t1`.`AllianceID` = '1179747074'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_04' WHERE `t1`.`AllianceID` = '1179747074';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_01' WHERE `t1`.`AllianceID` = '1397356346'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_01' WHERE `t1`.`AllianceID` = '1397356346';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_02' WHERE `t1`.`AllianceID` = '1210620300'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_02' WHERE `t1`.`AllianceID` = '1210620300';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_03' WHERE `t1`.`AllianceID` = '1620533655'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_03' WHERE `t1`.`AllianceID` = '1620533655';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_04' WHERE `t1`.`AllianceID` = '581235492'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_04' WHERE `t1`.`AllianceID` = '581235492';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_01' WHERE `t1`.`AllianceID` = '1568020072'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_01' WHERE `t1`.`AllianceID` = '1568020072';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_02' WHERE `t1`.`AllianceID` = '828884805'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_02' WHERE `t1`.`AllianceID` = '828884805';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_03' WHERE `t1`.`AllianceID` = '1875292563'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_03' WHERE `t1`.`AllianceID` = '1875292563';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_04' WHERE `t1`.`AllianceID` = '1212162615'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_04' WHERE `t1`.`AllianceID` = '1212162615';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_01' WHERE `t1`.`AllianceID` = '1494254776'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_01' WHERE `t1`.`AllianceID` = '1494254776';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_02' WHERE `t1`.`AllianceID` = '723015129'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_02' WHERE `t1`.`AllianceID` = '723015129';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_03' WHERE `t1`.`AllianceID` = '204800686'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_03' WHERE `t1`.`AllianceID` = '204800686';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_04' WHERE `t1`.`AllianceID` = '1854195496'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_04' WHERE `t1`.`AllianceID` = '1854195496';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_01' WHERE `t1`.`AllianceID` = '892861216'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_01' WHERE `t1`.`AllianceID` = '892861216';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_02' WHERE `t1`.`AllianceID` = '1484395853'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_02' WHERE `t1`.`AllianceID` = '1484395853';
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_03' WHERE `t1`.`AllianceID` = '2068015105'
+
   UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_03' WHERE `t1`.`AllianceID` = '2068015105';

Latest revision as of 18:02, 20 July 2010

The following is a script to add the icon filename suffixes to the alliance table based on the table in IconToAllianceID Mappings.

Usable with CPP Database Dump:

  • Tyrannis 1.0.1 build 33641

Usable with Database Engine:

  • MySQL 5.0

Please note that the name of the allianceTable was not known to the script creator, you can improve the quality of this article by subtituting it in and removing this note.

 ALTER TABLE `allianceTable` ADD COLUMN `icon` varchar(100) CHARACTER SET utf8_general_ci NULL DEFAULT 
 
 -- update 354 alliances
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_02' WHERE `t1`.`AllianceID` = '1974662341' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='01_04' WHERE `t1`.`AllianceID` = '1967302747' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_02' WHERE `t1`.`AllianceID` = '1965875958' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_03' WHERE `t1`.`AllianceID` = '1962981871' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='02_04' WHERE `t1`.`AllianceID` = '1962870426' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_03' WHERE `t1`.`AllianceID` = '1988009450' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_02' WHERE `t1`.`AllianceID` = '1962835064' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='03_04' WHERE `t1`.`AllianceID` = '1988009449' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_01' WHERE `t1`.`AllianceID` = '1966049571' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_02' WHERE `t1`.`AllianceID` = '1963166628' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_03' WHERE `t1`.`AllianceID` = '2031941852' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='04_04' WHERE `t1`.`AllianceID` = '1988009451' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_01' WHERE `t1`.`AllianceID` = '1962872433' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_02' WHERE `t1`.`AllianceID` = '937038506' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_03' WHERE `t1`.`AllianceID` = '1439416485' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='05_04' WHERE `t1`.`AllianceID` = '1374837394' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='06_02' WHERE `t1`.`AllianceID` = '1099063355' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='06_03' WHERE `t1`.`AllianceID` = '1041482450' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_01' WHERE `t1`.`AllianceID` = '342755901' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_02' WHERE `t1`.`AllianceID` = '1026886508' 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_03' WHERE `t1`.`AllianceID` = '1220922756'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='07_04' WHERE `t1`.`AllianceID` = '1259365112'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_01' WHERE `t1`.`AllianceID` = '537119222'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_02' WHERE `t1`.`AllianceID` = '995013977'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_03' WHERE `t1`.`AllianceID` = '239739827'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='08_04' WHERE `t1`.`AllianceID` = '414616857'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_02' WHERE `t1`.`AllianceID` = '173739862'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='09_03' WHERE `t1`.`AllianceID` = '1441788490'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_01' WHERE `t1`.`AllianceID` = '978733650'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_02' WHERE `t1`.`AllianceID` = '264952485'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_03' WHERE `t1`.`AllianceID` = '373024435'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='10_04' WHERE `t1`.`AllianceID` = '521381722'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_01' WHERE `t1`.`AllianceID` = '157368852'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_02' WHERE `t1`.`AllianceID` = '628083666'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_03' WHERE `t1`.`AllianceID` = '881159574'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='11_04' WHERE `t1`.`AllianceID` = '937904219'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_01' WHERE `t1`.`AllianceID` = '755412150'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_02' WHERE `t1`.`AllianceID` = '898521033'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_03' WHERE `t1`.`AllianceID` = '894206965'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='12_04' WHERE `t1`.`AllianceID` = '893275782'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_01' WHERE `t1`.`AllianceID` = '741557221'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_02' WHERE `t1`.`AllianceID` = '327815755'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='13_03' WHERE `t1`.`AllianceID` = '295773986'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_01' WHERE `t1`.`AllianceID` = '937099054'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_02' WHERE `t1`.`AllianceID` = '618162213'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_03' WHERE `t1`.`AllianceID` = '613888047'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='14_04' WHERE `t1`.`AllianceID` = '632866070'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_01' WHERE `t1`.`AllianceID` = '790581431'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_02' WHERE `t1`.`AllianceID` = '701459600'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_03' WHERE `t1`.`AllianceID` = '900209169'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='15_04' WHERE `t1`.`AllianceID` = '898789246'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_01' WHERE `t1`.`AllianceID` = '759477551'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_02' WHERE `t1`.`AllianceID` = '1327233264'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_03' WHERE `t1`.`AllianceID` = '794831862'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='16_04' WHERE `t1`.`AllianceID` = '735932392'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_01' WHERE `t1`.`AllianceID` = '830660878'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_02' WHERE `t1`.`AllianceID` = '922541302'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_03' WHERE `t1`.`AllianceID` = '845358580'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='17_04' WHERE `t1`.`AllianceID` = '830476259'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_01' WHERE `t1`.`AllianceID` = '294099361'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_02' WHERE `t1`.`AllianceID` = '225947254'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_03' WHERE `t1`.`AllianceID` = '873672554'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='18_04' WHERE `t1`.`AllianceID` = '820673945'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_01' WHERE `t1`.`AllianceID` = '780843225'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_02' WHERE `t1`.`AllianceID` = '693547580'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_03' WHERE `t1`.`AllianceID` = '521550159'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='19_04' WHERE `t1`.`AllianceID` = '980676917'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_01' WHERE `t1`.`AllianceID` = '819637246'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_02' WHERE `t1`.`AllianceID` = '851986092'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_03' WHERE `t1`.`AllianceID` = '68685221'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='20_04' WHERE `t1`.`AllianceID` = '657191413'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_01' WHERE `t1`.`AllianceID` = '628991027'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_02' WHERE `t1`.`AllianceID` = '916366622'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_03' WHERE `t1`.`AllianceID` = '709354881'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='21_04' WHERE `t1`.`AllianceID` = '902819350'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_01' WHERE `t1`.`AllianceID` = '680656525'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_02' WHERE `t1`.`AllianceID` = '280458946'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_03' WHERE `t1`.`AllianceID` = '651394709'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='22_04' WHERE `t1`.`AllianceID` = '228932850'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_01' WHERE `t1`.`AllianceID` = '166439722'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_02' WHERE `t1`.`AllianceID` = '824518128'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_03' WHERE `t1`.`AllianceID` = '939383666'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='23_04' WHERE `t1`.`AllianceID` = '764328405'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_02' WHERE `t1`.`AllianceID` = '853118644'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_03' WHERE `t1`.`AllianceID` = '133380850'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='24_04' WHERE `t1`.`AllianceID` = '970258311'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_01' WHERE `t1`.`AllianceID` = '719152641'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_02' WHERE `t1`.`AllianceID` = '630715029'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_03' WHERE `t1`.`AllianceID` = '101400224'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='25_04' WHERE `t1`.`AllianceID` = '227106310'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_01' WHERE `t1`.`AllianceID` = '734409701'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_02' WHERE `t1`.`AllianceID` = '162958353'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_03' WHERE `t1`.`AllianceID` = '230415007'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='26_04' WHERE `t1`.`AllianceID` = '861668420'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_01' WHERE `t1`.`AllianceID` = '134442284'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_02' WHERE `t1`.`AllianceID` = '185649283'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_03' WHERE `t1`.`AllianceID` = '348908787'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='27_04' WHERE `t1`.`AllianceID` = '210997485'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_02' WHERE `t1`.`AllianceID` = '409364568'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_03' WHERE `t1`.`AllianceID` = '670047585'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='28_04' WHERE `t1`.`AllianceID` = '113001540'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_01' WHERE `t1`.`AllianceID` = '952720760'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_02' WHERE `t1`.`AllianceID` = '846017099'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_03' WHERE `t1`.`AllianceID` = '650545116'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='29_04' WHERE `t1`.`AllianceID` = '567099488'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_01' WHERE `t1`.`AllianceID` = '614102619'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_02' WHERE `t1`.`AllianceID` = '211088879'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_03' WHERE `t1`.`AllianceID` = '240835459'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='30_04' WHERE `t1`.`AllianceID` = '347057845'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_01' WHERE `t1`.`AllianceID` = '118499027'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_02' WHERE `t1`.`AllianceID` = '443039986'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_03' WHERE `t1`.`AllianceID` = '243562438'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='31_04' WHERE `t1`.`AllianceID` = '488282414'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_01' WHERE `t1`.`AllianceID` = '119175035'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_02' WHERE `t1`.`AllianceID` = '935962111'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_03' WHERE `t1`.`AllianceID` = '1081180970'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='32_04' WHERE `t1`.`AllianceID` = '647194493'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_01' WHERE `t1`.`AllianceID` = '309570220'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_02' WHERE `t1`.`AllianceID` = '829299188'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_03' WHERE `t1`.`AllianceID` = '826025559'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='33_04' WHERE `t1`.`AllianceID` = '213401527'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_01' WHERE `t1`.`AllianceID` = '838011673'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_02' WHERE `t1`.`AllianceID` = '937872513'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_03' WHERE `t1`.`AllianceID` = '389924442'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='34_04' WHERE `t1`.`AllianceID` = '927767240'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_01' WHERE `t1`.`AllianceID` = '581956272'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_02' WHERE `t1`.`AllianceID` = '716050598'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_03' WHERE `t1`.`AllianceID` = '102441019'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='35_04' WHERE `t1`.`AllianceID` = '487868936';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_01' WHERE `t1`.`AllianceID` = '891616204'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_02' WHERE `t1`.`AllianceID` = '822746991'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_03' WHERE `t1`.`AllianceID` = '217728874'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='36_04' WHERE `t1`.`AllianceID` = '204298938';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_01' WHERE `t1`.`AllianceID` = '1178366869'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_02' WHERE `t1`.`AllianceID` = '1281684917'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_03' WHERE `t1`.`AllianceID` = '283331937'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='37_04' WHERE `t1`.`AllianceID` = '107660664'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_01' WHERE `t1`.`AllianceID` = '202628879'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_02' WHERE `t1`.`AllianceID` = '689376961'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_03' WHERE `t1`.`AllianceID` = '129639137'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='38_04' WHERE `t1`.`AllianceID` = '662918705'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_01' WHERE `t1`.`AllianceID` = '927094775'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_02' WHERE `t1`.`AllianceID` = '902819350'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_03' WHERE `t1`.`AllianceID` = '159826257'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='39_04' WHERE `t1`.`AllianceID` = '348978562';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_01' WHERE `t1`.`AllianceID` = '1657456469'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_02' WHERE `t1`.`AllianceID` = '1617353742'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_03' WHERE `t1`.`AllianceID` = '1474035720'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='40_04' WHERE `t1`.`AllianceID` = '1171357902';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_01' WHERE `t1`.`AllianceID` = '419865710'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_02' WHERE `t1`.`AllianceID` = '979280912'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_03' WHERE `t1`.`AllianceID` = '424172891'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='41_04' WHERE `t1`.`AllianceID` = '670303846';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_01' WHERE `t1`.`AllianceID` = '973532707'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_02' WHERE `t1`.`AllianceID` = '386292982'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_03' WHERE `t1`.`AllianceID` = '427019530'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='42_04' WHERE `t1`.`AllianceID` = '942594614';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_01' WHERE `t1`.`AllianceID` = '1439278447'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_02' WHERE `t1`.`AllianceID` = '305786028'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_03' WHERE `t1`.`AllianceID` = '361595181'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='43_04' WHERE `t1`.`AllianceID` = '655846070'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_01' WHERE `t1`.`AllianceID` = '1731851374'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_02' WHERE `t1`.`AllianceID` = '364303645'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_03' WHERE `t1`.`AllianceID` = '897877797'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='44_04' WHERE `t1`.`AllianceID` = '444203333'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_01' WHERE `t1`.`AllianceID` = '1733643802'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_02' WHERE `t1`.`AllianceID` = '287387070'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_03' WHERE `t1`.`AllianceID` = '1538108032'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='45_04' WHERE `t1`.`AllianceID` = '1334228324'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_01' WHERE `t1`.`AllianceID` = '562804261'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_02' WHERE `t1`.`AllianceID` = '136013311'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_03' WHERE `t1`.`AllianceID` = '1305592065'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='46_04' WHERE `t1`.`AllianceID` = '1778250850'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_01' WHERE `t1`.`AllianceID` = '1326438017'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_02' WHERE `t1`.`AllianceID` = '500912361'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_03' WHERE `t1`.`AllianceID` = '344549974'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='47_04' WHERE `t1`.`AllianceID` = '1633825631'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_01' WHERE `t1`.`AllianceID` = '693829445'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_02' WHERE `t1`.`AllianceID` = '1617262222'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_03' WHERE `t1`.`AllianceID` = '273254349'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='48_04' WHERE `t1`.`AllianceID` = '268264129'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_01' WHERE `t1`.`AllianceID` = '812396591'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_02' WHERE `t1`.`AllianceID` = '1399057309'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_03' WHERE `t1`.`AllianceID` = '1510350889'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='49_04' WHERE `t1`.`AllianceID` = '176358229'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_01' WHERE `t1`.`AllianceID` = '1259761645'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_02' WHERE `t1`.`AllianceID` = '915114162'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_03' WHERE `t1`.`AllianceID` = '714390465'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='50_04' WHERE `t1`.`AllianceID` = '664511700'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_01' WHERE `t1`.`AllianceID` = '933731581'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_02' WHERE `t1`.`AllianceID` = '1218667238'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_03' WHERE `t1`.`AllianceID` = '1333213624'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='51_04' WHERE `t1`.`AllianceID` = '585089448'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_01' WHERE `t1`.`AllianceID` = '985451579'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_02' WHERE `t1`.`AllianceID` = '982284363'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_03' WHERE `t1`.`AllianceID` = '485127066'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='52_04' WHERE `t1`.`AllianceID` = '702036928'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_01' WHERE `t1`.`AllianceID` = '1231017993'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_02' WHERE `t1`.`AllianceID` = '494403294'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_03' WHERE `t1`.`AllianceID` = '227446060'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='53_04' WHERE `t1`.`AllianceID` = '581933217'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_01' WHERE `t1`.`AllianceID` = '1492453355'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_03' WHERE `t1`.`AllianceID` = '588312332'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='54_04' WHERE `t1`.`AllianceID` = '145834652'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_01' WHERE `t1`.`AllianceID` = '748398192'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_02' WHERE `t1`.`AllianceID` = '605296635'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_03' WHERE `t1`.`AllianceID` = '923562637'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='55_04' WHERE `t1`.`AllianceID` = '1436568627'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_01' WHERE `t1`.`AllianceID` = '709173242'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_02' WHERE `t1`.`AllianceID` = '921274069'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_03' WHERE `t1`.`AllianceID` = '161789084'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='56_04' WHERE `t1`.`AllianceID` = '248309546';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_01' WHERE `t1`.`AllianceID` = '288377808'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_02' WHERE `t1`.`AllianceID` = '1358408357'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_03' WHERE `t1`.`AllianceID` = '154532576'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='57_04' WHERE `t1`.`AllianceID` = '872127712';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_01' WHERE `t1`.`AllianceID` = '306798858'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_02' WHERE `t1`.`AllianceID` = '729078756'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_03' WHERE `t1`.`AllianceID` = '223369706'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='58_04' WHERE `t1`.`AllianceID` = '1083654693';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_01' WHERE `t1`.`AllianceID` = '275725590'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_02' WHERE `t1`.`AllianceID` = '831252438'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_03' WHERE `t1`.`AllianceID` = '284278305'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='59_04' WHERE `t1`.`AllianceID` = '917526329';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_01' WHERE `t1`.`AllianceID` = '1471767458'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_02' WHERE `t1`.`AllianceID` = '1236486154'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_03' WHERE `t1`.`AllianceID` = '1470696988'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='60_04' WHERE `t1`.`AllianceID` = '628280874';  
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_01' WHERE `t1`.`AllianceID` = '1695410410'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_02' WHERE `t1`.`AllianceID` = '961848448'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_03' WHERE `t1`.`AllianceID` = '1003067784'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='61_04' WHERE `t1`.`AllianceID` = '682915307'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_01' WHERE `t1`.`AllianceID` = '630969519'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_02' WHERE `t1`.`AllianceID` = '330639100'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_03' WHERE `t1`.`AllianceID` = '156756939'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='62_04' WHERE `t1`.`AllianceID` = '843638752'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_01' WHERE `t1`.`AllianceID` = '1015092638'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_02' WHERE `t1`.`AllianceID` = '1114190180'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_03' WHERE `t1`.`AllianceID` = '1040376220'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='63_04' WHERE `t1`.`AllianceID` = '496431473'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_01' WHERE `t1`.`AllianceID` = '1206229240'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_02' WHERE `t1`.`AllianceID` = '959524143'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_03' WHERE `t1`.`AllianceID` = '596408142'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='64_04' WHERE `t1`.`AllianceID` = '607835872'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_01' WHERE `t1`.`AllianceID` = '1325294000'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_02' WHERE `t1`.`AllianceID` = '1438160193'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='65_04' WHERE `t1`.`AllianceID` = '1598600949'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_01' WHERE `t1`.`AllianceID` = '384524280'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_02' WHERE `t1`.`AllianceID` = '979339647'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_03' WHERE `t1`.`AllianceID` = '1793821574'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='66_04' WHERE `t1`.`AllianceID` = '1184264779'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_01' WHERE `t1`.`AllianceID` = '320774832'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_02' WHERE `t1`.`AllianceID` = '1324392282'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_03' WHERE `t1`.`AllianceID` = '878866718'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='67_04' WHERE `t1`.`AllianceID` = '1813726532'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_01' WHERE `t1`.`AllianceID` = '845224486'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_02' WHERE `t1`.`AllianceID` = '655616830'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_03' WHERE `t1`.`AllianceID` = '704856874'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='68_04' WHERE `t1`.`AllianceID` = '613493214'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_01' WHERE `t1`.`AllianceID` = '817618922'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_02' WHERE `t1`.`AllianceID` = '969494429'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_03' WHERE `t1`.`AllianceID` = '313987070'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='69_04' WHERE `t1`.`AllianceID` = '166924340'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_01' WHERE `t1`.`AllianceID` = '151380924'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_02' WHERE `t1`.`AllianceID` = '1353656102'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_03' WHERE `t1`.`AllianceID` = '1206021109'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='70_04' WHERE `t1`.`AllianceID` = '1653863703'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_01' WHERE `t1`.`AllianceID` = '1302181348'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_02' WHERE `t1`.`AllianceID` = '1173986008'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_03' WHERE `t1`.`AllianceID` = '905407070'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='71_04' WHERE `t1`.`AllianceID` = '715032274'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_01' WHERE `t1`.`AllianceID` = '614765194'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_02' WHERE `t1`.`AllianceID` = '586234421'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_03' WHERE `t1`.`AllianceID` = '455411710'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='72_04' WHERE `t1`.`AllianceID` = '1254379905'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_01' WHERE `t1`.`AllianceID` = '1309030271'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_02' WHERE `t1`.`AllianceID` = '306798858'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_03' WHERE `t1`.`AllianceID` = '1402003305'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='73_04' WHERE `t1`.`AllianceID` = '1097355312'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_01' WHERE `t1`.`AllianceID` = '1433868460'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_02' WHERE `t1`.`AllianceID` = '1104449696'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_03' WHERE `t1`.`AllianceID` = '448511760'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='74_04' WHERE `t1`.`AllianceID` = '1260627398'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_01' WHERE `t1`.`AllianceID` = '999297753'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_02' WHERE `t1`.`AllianceID` = '1161017884'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_03' WHERE `t1`.`AllianceID` = '1583356798'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='75_04' WHERE `t1`.`AllianceID` = '294930214'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_01' WHERE `t1`.`AllianceID` = '580611538'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_02' WHERE `t1`.`AllianceID` = '673817002'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_03' WHERE `t1`.`AllianceID` = '1136157539'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='76_04' WHERE `t1`.`AllianceID` = '1490024253'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_01' WHERE `t1`.`AllianceID` = '1453523683'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_02' WHERE `t1`.`AllianceID` = '659333041'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_03' WHERE `t1`.`AllianceID` = '686603391'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='77_04' WHERE `t1`.`AllianceID` = '911652170'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_01' WHERE `t1`.`AllianceID` = '532949740'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_02' WHERE `t1`.`AllianceID` = '1499311634'; 
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_03' WHERE `t1`.`AllianceID` = '1480700727';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='78_04' WHERE `t1`.`AllianceID` = '166924340';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_02' WHERE `t1`.`AllianceID` = '896695182';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_03' WHERE `t1`.`AllianceID` = '833571739';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='79_04' WHERE `t1`.`AllianceID` = '437579728';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_01' WHERE `t1`.`AllianceID` = '1087160562';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_02' WHERE `t1`.`AllianceID` = '1538382401';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_03' WHERE `t1`.`AllianceID` = '1685237465';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='80_04' WHERE `t1`.`AllianceID` = '861898608';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_01' WHERE `t1`.`AllianceID` = '264679431';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_03' WHERE `t1`.`AllianceID` = '1007323374';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='81_04' WHERE `t1`.`AllianceID` = '849565342';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_01' WHERE `t1`.`AllianceID` = '1294094452';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_02' WHERE `t1`.`AllianceID` = '608839271';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_03' WHERE `t1`.`AllianceID` = '1550724751';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='82_04' WHERE `t1`.`AllianceID` = '1987964414';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_01' WHERE `t1`.`AllianceID` = '855555544';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_02' WHERE `t1`.`AllianceID` = '1610350138';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='83_04' WHERE `t1`.`AllianceID` = '1798720604';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='84_04' WHERE `t1`.`AllianceID` = '703129312';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_01' WHERE `t1`.`AllianceID` = '505495351';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_03' WHERE `t1`.`AllianceID` = '1045152576';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='85_04' WHERE `t1`.`AllianceID` = '1658767552';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_01' WHERE `t1`.`AllianceID` = '215451578';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_02' WHERE `t1`.`AllianceID` = '1323245561';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='86_03' WHERE `t1`.`AllianceID` = '1393073050';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_01' WHERE `t1`.`AllianceID` = '1854757882';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_02' WHERE `t1`.`AllianceID` = '1960982151';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_03' WHERE `t1`.`AllianceID` = '1315108737';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='87_04' WHERE `t1`.`AllianceID` = '1012079455';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_01' WHERE `t1`.`AllianceID` = '1411711376';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_02' WHERE `t1`.`AllianceID` = '675031356';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_03' WHERE `t1`.`AllianceID` = '1489655626';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='88_04' WHERE `t1`.`AllianceID` = '349521578';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_01' WHERE `t1`.`AllianceID` = '1609780791';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_02' WHERE `t1`.`AllianceID` = '418808473';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_03' WHERE `t1`.`AllianceID` = '1913014423';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='89_04' WHERE `t1`.`AllianceID` = '1671078301';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_01' WHERE `t1`.`AllianceID` = '1980649055';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_02' WHERE `t1`.`AllianceID` = '1096087041';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_03' WHERE `t1`.`AllianceID` = '1482692012';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='90_04' WHERE `t1`.`AllianceID` = '1179747074';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_01' WHERE `t1`.`AllianceID` = '1397356346';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_02' WHERE `t1`.`AllianceID` = '1210620300';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_03' WHERE `t1`.`AllianceID` = '1620533655';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='91_04' WHERE `t1`.`AllianceID` = '581235492';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_01' WHERE `t1`.`AllianceID` = '1568020072';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_02' WHERE `t1`.`AllianceID` = '828884805';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_03' WHERE `t1`.`AllianceID` = '1875292563';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='92_04' WHERE `t1`.`AllianceID` = '1212162615';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_01' WHERE `t1`.`AllianceID` = '1494254776';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_02' WHERE `t1`.`AllianceID` = '723015129';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_03' WHERE `t1`.`AllianceID` = '204800686';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='93_04' WHERE `t1`.`AllianceID` = '1854195496';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_01' WHERE `t1`.`AllianceID` = '892861216';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_02' WHERE `t1`.`AllianceID` = '1484395853';
 UPDATE `allianceTable` AS `t1` SET `t1`.`icon`='94_03' WHERE `t1`.`AllianceID` = '2068015105';
Personal tools