Aural Moon - Progressive Rock Discussion - The Aural Moon "FLAG PROJECT"

Aural Moon - Progressive Rock Discussion (http://auralmoon.com/forum/index.php)

- General Discussion/Prog News (http://auralmoon.com/forum/forumdisplay.php?f=5)

- - The Aural Moon "FLAG PROJECT" (http://auralmoon.com/forum/showthread.php?t=4678)

The Aural Moon "FLAG PROJECT"

Yesterday in the speakeasy, someone referred to the project to add country of origin information to the Aural Moon music library as the "FLAG PROJECT" so, for lack of a better title, it is the "FLAG PROJECT".

If you want to help, here is what is needed. Doing this all manually in SAM will take much time. It would be far easier to simply issue a script of SQL commands to update this. So, if you want to help, here is what is needed:

Use this table (sorted by country name):

Code:

SELECT DISTINCT code, country FROM ip2country ORDER BY country ASC code country AF Afghanistan AX Aland Islands AL Albania DZ Algeria AS American Samoa AD Andorra AO Angola AI Anguilla AQ Antarctica AG Antigua and Barbuda AR Argentina AM Armenia AW Aruba AP Asia/Pacific Region AU Australia AT Austria AZ Azerbaijan BS Bahamas BH Bahrain BD Bangladesh BB Barbados BY Belarus BE Belgium BZ Belize BJ Benin BM Bermuda BT Bhutan BO Bolivia BA Bosnia and Herzegovina BW Botswana BV Bouvet Island BR Brazil IO British Indian Ocean Territory BN Brunei Darussalam BG Bulgaria BF Burkina Faso BI Burundi KH Cambodia CM Cameroon CA Canada CV Cape Verde KY Cayman Islands CF Central African Republic TD Chad CL Chile CN China CO Colombia KM Comoros CG Congo CD Congo CK Cook Islands CR Costa Rica HR Croatia CU Cuba CY Cyprus CZ Czech Republic DK Denmark DJ Djibouti DM Dominica DO Dominican Republic EC Ecuador EG Egypt SV El Salvador GQ Equatorial Guinea ER Eritrea EE Estonia ET Ethiopia EU Europe FK Falkland Islands (Malvinas) FO Faroe Islands FJ Fiji FI Finland FR France GF French Guiana PF French Polynesia GA Gabon GM Gambia GE Georgia DE Germany GH Ghana GI Gibraltar GR Greece GL Greenland GD Grenada GP Guadeloupe GU Guam GT Guatemala GG Guernsey GN Guinea GW Guinea-Bissau GY Guyana HT Haiti VA Holy See (Vatican City State) HN Honduras HK Hong Kong HU Hungary IS Iceland IN India ID Indonesia IR Iran IQ Iraq IE Ireland IM Isle of Man IL Israel IT Italy JM Jamaica JP Japan JE Jersey JO Jordan KZ Kazakhstan KE Kenya KI Kiribati KP Korea KR Korea KW Kuwait KG Kyrgyzstan LV Latvia LB Lebanon LS Lesotho LR Liberia LY Libyan Arab Jamahiriya LI Liechtenstein LT Lithuania LU Luxembourg MO Macau MK Macedonia MG Madagascar MW Malawi MY Malaysia MV Maldives ML Mali MT Malta MH Marshall Islands MQ Martinique MR Mauritania MU Mauritius YT Mayotte MX Mexico FM Micronesia MD Moldova MC Monaco MN Mongolia ME Montenegro MS Montserrat MA Morocco MZ Mozambique MM Myanmar NA Namibia NR Nauru NP Nepal NL Netherlands AN Netherlands Antilles NC New Caledonia NZ New Zealand NI Nicaragua NE Niger NG Nigeria NU Niue NF Norfolk Island MP Northern Mariana Islands NO Norway OM Oman PK Pakistan PW Palau PS Palestinian Territory PA Panama PG Papua New Guinea PY Paraguay PE Peru PH Philippines PN Pitcairn Islands PL Poland PT Portugal PR Puerto Rico QA Qatar RE Reunion RO Romania RU Russian Federation RW Rwanda KN Saint Kitts and Nevis LC Saint Lucia MF Saint Martin PM Saint Pierre and Miquelon VC Saint Vincent and the Grenadines WS Samoa SM San Marino ST Sao Tome and Principe SA Saudi Arabia SN Senegal RS Serbia SC Seychelles SL Sierra Leone SG Singapore SK Slovakia SI Slovenia SB Solomon Islands SO Somalia ZA South Africa ES Spain LK Sri Lanka SD Sudan SR Suriname SZ Swaziland SE Sweden CH Switzerland SY Syrian Arab Republic TW Taiwan TJ Tajikistan TZ Tanzania TH Thailand TL Timor-Leste TG Togo TK Tokelau TO Tonga TT Trinidad and Tobago TN Tunisia TR Turkey TM Turkmenistan TC Turks and Caicos Islands TV Tuvalu UG Uganda UA Ukraine AE United Arab Emirates GB United Kingdom US United States UM United States Minor Outlying Islands UY Uruguay UZ Uzbekistan VU Vanuatu VE Venezuela VN Vietnam VG Virgin Islands VI Virgin Islands WF Wallis and Futuna YE Yemen ZM Zambia ZW Zimbabwe

or this one (sorted by code):

Code:

SELECT DISTINCT code,country FROM joomla.ip2country ORDER BY code ASC code country AD Andorra AE United Arab Emirates AF Afghanistan AG Antigua and Barbuda AI Anguilla AL Albania AM Armenia AN Netherlands Antilles AO Angola AP Asia/Pacific Region AQ Antarctica AR Argentina AS American Samoa AT Austria AU Australia AW Aruba AX Aland Islands AZ Azerbaijan BA Bosnia and Herzegovina BB Barbados BD Bangladesh BE Belgium BF Burkina Faso BG Bulgaria BH Bahrain BI Burundi BJ Benin BM Bermuda BN Brunei Darussalam BO Bolivia BR Brazil BS Bahamas BT Bhutan BV Bouvet Island BW Botswana BY Belarus BZ Belize CA Canada CD Congo CF Central African Republic CG Congo CH Switzerland CK Cook Islands CL Chile CM Cameroon CN China CO Colombia CR Costa Rica CU Cuba CV Cape Verde CY Cyprus CZ Czech Republic DE Germany DJ Djibouti DK Denmark DM Dominica DO Dominican Republic DZ Algeria EC Ecuador EE Estonia EG Egypt ER Eritrea ES Spain ET Ethiopia EU Europe FI Finland FJ Fiji FK Falkland Islands (Malvinas) FM Micronesia FO Faroe Islands FR France GA Gabon GB United Kingdom GD Grenada GE Georgia GF French Guiana GG Guernsey GH Ghana GI Gibraltar GL Greenland GM Gambia GN Guinea GP Guadeloupe GQ Equatorial Guinea GR Greece GT Guatemala GU Guam GW Guinea-Bissau GY Guyana HK Hong Kong HN Honduras HR Croatia HT Haiti HU Hungary ID Indonesia IE Ireland IL Israel IM Isle of Man IN India IO British Indian Ocean Territory IQ Iraq IR Iran IS Iceland IT Italy JE Jersey JM Jamaica JO Jordan JP Japan KE Kenya KG Kyrgyzstan KH Cambodia KI Kiribati KM Comoros KN Saint Kitts and Nevis KP Korea KR Korea KW Kuwait KY Cayman Islands KZ Kazakhstan LB Lebanon LC Saint Lucia LI Liechtenstein LK Sri Lanka LR Liberia LS Lesotho LT Lithuania LU Luxembourg LV Latvia LY Libyan Arab Jamahiriya MA Morocco MC Monaco MD Moldova ME Montenegro MF Saint Martin MG Madagascar MH Marshall Islands MK Macedonia ML Mali MM Myanmar MN Mongolia MO Macau MP Northern Mariana Islands MQ Martinique MR Mauritania MS Montserrat MT Malta MU Mauritius MV Maldives MW Malawi MX Mexico MY Malaysia MZ Mozambique NA Namibia NC New Caledonia NE Niger NF Norfolk Island NG Nigeria NI Nicaragua NL Netherlands NO Norway NP Nepal NR Nauru NU Niue NZ New Zealand OM Oman PA Panama PE Peru PF French Polynesia PG Papua New Guinea PH Philippines PK Pakistan PL Poland PM Saint Pierre and Miquelon PN Pitcairn Islands PR Puerto Rico PS Palestinian Territory PT Portugal PW Palau PY Paraguay QA Qatar RE Reunion RO Romania RS Serbia RU Russian Federation RW Rwanda SA Saudi Arabia SB Solomon Islands SC Seychelles SD Sudan SE Sweden SG Singapore SI Slovenia SK Slovakia SL Sierra Leone SM San Marino SN Senegal SO Somalia SR Suriname ST Sao Tome and Principe SV El Salvador SY Syrian Arab Republic SZ Swaziland TC Turks and Caicos Islands TD Chad TG Togo TH Thailand TJ Tajikistan TK Tokelau TL Timor-Leste TM Turkmenistan TN Tunisia TO Tonga TR Turkey TT Trinidad and Tobago TV Tuvalu TW Taiwan TZ Tanzania UA Ukraine UG Uganda UM United States Minor Outlying Islands US United States UY Uruguay UZ Uzbekistan VA Holy See (Vatican City State) VC Saint Vincent and the Grenadines VE Venezuela VG Virgin Islands VI Virgin Islands VN Vietnam VU Vanuatu WF Wallis and Futuna WS Samoa YE Yemen YT Mayotte ZA South Africa ZM Zambia ZW Zimbabwe
Use the following template SQL query command:

Code:

UPDATE samdb.songlist set lyrics="xx" where artist="artist";

Fill in the CC (country code) and the artist name.

For example:

Code:

UPDATE samdb.songlist set lyrics="GB" where artist="YES";
Keep in mind that Jim does things like "The Moody Blues" -> "Moody Blues, The" and "Roger Waters" -> "Waters, Roger"
Post your efforts in this thread by keeping the SQL command inside the CODE tags (the hash # mark in the options above) and copy each preceding contribution and then add yours.
Don't top post!!! I will delete them!!!
JUST post the updated SQL.

Thanks. I will delete posts as they are accrued leaving only the most recent so as not to clutter this effort too much. Do not worry about duplicates. I will sort through. If you see an error, feel free to correct it when you post.

Also, the artist name must be exact. For example: "Premiata Forneria Marconi" is acceptable whereas "PFM" is not... unless you happen to find that Jim listed this band as "PFM" in the library. (hint: he didn't).

Thanks so far to:

Yesspaz
tobytanzer
dnsrees
jtmckinley
Wojtek

for their contributions to the effort.