IconToAllianceID Mappings/SQL

From EVEDev
Revision as of 17:59, 20 July 2010 by Finlay (Talk | contribs)

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 `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