IconToAllianceID Mappings

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The CCP Database Dump INSERT ALLIANCE TABLE NAME HERE (Dump) table is missing the filename suffix for the CPP Image Dump.

Scripts to add it to Tyrannis 1.0.1 build 33641:

The following is a mapping table as of 2009-07-28 and includes 354 alliances. It can be imported into MS Excel or used with regular expressions to create SQL scripts. Please do not convert to wiki/html table.

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