IconToAllianceID Mappings
From EVEDev
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
