Originally Posted by
IzNoGoD
PHP Code:
args = [];
args[0] = player;
self maps\mp\gametypes\_mysql::asyncquery(yourquery, ::showlocation, args);
PHP Code:
showlocation(rows, args)
{
if(!isdefined(args[0]))
return;
if(isdefiend(rows) && isdefined(rows[0]) && isdefined(rows[0]["country"]))
self iprintln(args[0].name + " is from " + rows[0]["country"]);
}
Using this but got error:
in cod2 console
PHP Code:
^8idk^7: !location
script runtime error: potential infinite loop in script - killing thread.
(file 'maps/mp/gametypes/_callbacksetup.gsc', line 466)
for(i = 0; i < ip.size; i++)
*
Hitch warning: 5007 msec frame time
Script:
PHP Code:
getcountry(player)
{
//self = admin
//player = who u want to know
ip = player getip();
ip_parts = [];
part = 0;
ip_parts[part] = "";
prev_found = 0;
for(i = 0; i < ip.size; i++)
{
if(ip[i] != ".")
ip_parts[part] += ip[i];
else
{
part++;
ip_parts[part] = "";
}
}
multi = 1;
num = 0;
for(i = ip_parts.size - 1; i >= 0; i--)
{
num += int(ip_parts[i]) * multi;
multi *= 256;
}
args = [];
args[0] = player;
maps\mp\gametypes\_mysql::asyncQuery("SELECT country FROM countries WHERE ip < " + num + " ORDER BY ip DESC LIMIT 1", ::showLocation, args);
}
showlocation(rows, args)
{
if(!isdefined(args[0]))
return;
if(isdefined(rows) && isdefined(rows[0]) && isdefined(rows[0]["country"]))
self iprintln(args[0].name + " is from " + rows[0]["country"]);
self iprintln("test");
}
getlongcountry(c)
{
switch(c)
{
case "AD": return "Andorra";
case "AE": return "United Arab Emirates";
case "AF": return "Afghanistan";
case "AG": return "Antigua and Barbuda";
case "AL": return "Albania";
case "AM": return "Armenia";
case "AN": return "Netherlands Antilles";
case "AO": return "Angola";
case "AR": return "Argentina";
case "AT": return "Austria";
case "AU": return "Australia";
case "AW": return "Aruba";
case "AZ": return "Azerbaijan";
case "BA": return "Bosnia and Herzegowina";
case "BB": return "Barbados";
case "BD": return "Bangladesh";
case "BE": return "Belgium";
case "BF": return "Burkina Faso";
case "BG": return "Bulgaria";
case "BH": return "Bahrain";
case "BJ": return "Benin";
case "BM": return "Bermuda";
case "BN": return "Brunei Darussalam";
case "BO": return "Bolivia";
case "BR": return "Brazil";
case "BS": return "Bahamas";
case "BT": return "Bhutan";
case "BW": return "Botswana";
case "BY": return "Belarus";
case "BZ": return "Belize";
case "CA": return "Canada";
case "CD": return "Congo The Democratic Republic of The";
case "CF": return "Central African Republic";
case "CG": return "Congo";
case "CH": return "Switzerland";
case "CI": return "Cote D\'ivoire";
case "CL": return "Chile";
case "CM": return "Cameroon";
case "CN": return "China";
case "CO": return "Colombia";
case "CR": return "Costa Rica";
case "CU": return "Cuba";
case "CV": return "Cape Verde";
case "CY": return "Cyprus";
case "CZ": return "Czech Republic";
case "DE": return "Germany";
case "DJ": return "Djibouti";
case "DK": return "Denmark";
case "DO": return "Dominican Republic";
case "DZ": return "Algeria";
case "EC": return "Ecuador";
case "EE": return "Estonia";
case "EG": return "Egypt";
case "ES": return "Spain";
case "EU": return "European Union";
case "FI": return "Finland";
case "FJ": return "Fiji";
case "FM": return "Micronesia Federated States of";
case "FO": return "Faroe Islands";
case "FR": return "France";
case "GA": return "Gabon";
case "GB": return "United Kingdom";
case "GD": return "Grenada";
case "GE": return "Georgia";
case "GG": return "Guernsey";
case "GH": return "Ghana";
case "GI": return "Gibraltar";
case "GL": return "Greenland";
case "GM": return "Gambia";
case "GN": return "Guinea";
case "GQ": return "Equatorial Guinea";
case "GR": return "Greece";
case "GT": return "Guatemala";
case "GU": return "Guam";
case "GY": return "Guyana";
case "HK": return "Hong Kong";
case "HN": return "Honduras";
case "HR": return "Croatia (LOCAL Name: Hrvatska)";
case "HT": return "Haiti";
case "HU": return "Hungary";
case "ID": return "Indonesia";
case "IE": return "Ireland";
case "IL": return "Israel";
case "IM": return "Isle of Man";
case "IN": return "India";
case "IQ": return "Iraq";
case "IR": return "Iran (ISLAMIC Republic Of)";
case "IS": return "Iceland";
case "IT": return "Italy";
case "JE": return "Jersey";
case "JM": return "Jamaica";
case "JO": return "Jordan";
case "JP": return "Japan";
case "KE": return "Kenya";
case "KG": return "Kyrgyzstan";
case "KH": return "Cambodia";
case "KP": return "Korea Democratic People\'s Republic of";
case "KR": return "Korea Republic of";
case "KW": return "Kuwait";
case "KY": return "Cayman Islands";
case "KZ": return "Kazakhstan";
case "LA": return "Lao People\'s Democratic Republic";
case "LB": return "Lebanon";
case "LI": return "Liechtenstein";
case "LK": return "Sri Lanka";
case "LR": return "Liberia";
case "LS": return "Lesotho";
case "LT": return "Lithuania";
case "LU": return "Luxembourg";
case "LV": return "Latvia";
case "LY": return "Libyan Arab Jamahiriya";
case "MA": return "Morocco";
case "MC": return "Monaco";
case "MD": return "Moldova Republic of";
case "ME": return "Montenegro";
case "MF": return "Saint Martin";
case "MG": return "Madagascar";
case "MH": return "Marshall Islands";
case "MK": return "Macedonia";
case "ML": return "Mali";
case "MM": return "Myanmar";
case "MN": return "Mongolia";
case "MO": return "Macau";
case "MR": return "Mauritania";
case "MT": return "Malta";
case "MU": return "Mauritius";
case "MV": return "Maldives";
case "MW": return "Malawi";
case "MX": return "Mexico";
case "MY": return "Malaysia";
case "MZ": return "Mozambique";
case "NA": return "Namibia";
case "NC": return "New Caledonia";
case "NE": return "Niger";
case "NG": return "Nigeria";
case "NI": return "Nicaragua";
case "NL": return "Netherlands";
case "NO": return "Norway";
case "NP": return "Nepal";
case "NU": return "Niue";
case "NZ": return "New Zealand";
case "OM": return "Oman";
case "PA": return "Panama";
case "PE": return "Peru";
case "PF": return "French Polynesia";
case "PG": return "Papua New Guinea";
case "PH": return "Philippines";
case "PK": return "Pakistan";
case "PL": return "Poland";
case "PM": return "St. Pierre and Miquelon";
case "PR": return "Puerto Rico";
case "PS": return "Palestinian Territory Occupied";
case "PT": return "Portugal";
case "PY": return "Paraguay";
case "QA": return "Qatar";
case "RE": return "Reunion";
case "RO": return "Romania";
case "RS": return "Serbia";
case "RU": return "Russian Federation";
case "RW": return "Rwanda";
case "SA": return "Saudi Arabia";
case "SC": return "Seychelles";
case "SD": return "Sudan";
case "SE": return "Sweden";
case "SG": return "Singapore";
case "SI": return "Slovenia";
case "SK": return "Slovakia (SLOVAK Republic)";
case "SL": return "Sierra Leone";
case "SM": return "San Marino";
case "SN": return "Senegal";
case "SO": return "Somalia";
case "SR": return "Suriname";
case "SV": return "El Salvador";
case "SY": return "Syrian Arab Republic";
case "SZ": return "Swaziland";
case "TC": return "Turks and Caicos Islands";
case "TD": return "Chad";
case "TG": return "Togo";
case "TH": return "Thailand";
case "TJ": return "Tajikistan";
case "TK": return "Tokelau";
case "TL": return "Timor-leste";
case "TM": return "Turkmenistan";
case "TN": return "Tunisia";
case "TO": return "Tonga";
case "TR": return "Turkey";
case "TT": return "Trinidad and Tobago";
case "TW": return "Taiwan; Republic of China (ROC)";
case "TZ": return "Tanzania United Republic of";
case "UA": return "Ukraine";
case "UG": return "Uganda";
case "US": return "United States";
case "UY": return "Uruguay";
case "UZ": return "Uzbekistan";
case "VC": return "Saint Vincent and The Grenadines";
case "VE": return "Venezuela";
case "VG": return "Virgin Islands (BRITISH)";
case "VI": return "Virgin Islands (U.S.)";
case "VN": return "Viet Nam";
case "VU": return "Vanuatu";
case "WF": return "Wallis and Futuna Islands";
case "WS": return "Samoa";
case "YE": return "Yemen";
case "ZA": return "South Africa";
case "ZM": return "Zambia";
case "ZW": return "Zimbabwe";
case "ZZ": return "Reserved";
default: return "Unknown";
}
}
In db
PHP Code:
CREATE TABLE IF NOT EXISTS `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) DEFAULT NULL,
`name` varchar(55) CHARACTER SET utf32 NOT NULL,
`country` varchar(55) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
Ofc i put developer 1 to see the prob
And trying to put countries_april_2014.sql too but idk.. maybe im wrong ?