IconToAllianceID Mappings/SQL

From EVEDev
Jump to: navigation, search

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