Members By Country

Browse tshirtslayer members by country.

This relies on our IP country detection which is not always very accurate and theres a lot of users that don't show up here. we will improve this!

Click on a flag to list those members

1 group by country order by c desc ;" ); while ( $row = db_fetch_array ( $result ) ) { $flag = strtolower ( $row ['country'] ) . '.png'; $p = strtolower ( $row ['country'] ); print " " . $row ["c"] . '  '; } ?>

---

"; $result = db_query ( "SELECT * from iso3166 where lower(country_code2)='%s' ", strtolower ( $_GET ['f'] ) ); $row = db_fetch_array ( $result ); if ($row) { print '

' . $row ['country_name'] . '

'; drupal_set_title ( "Members By Country - " . $row ['country_name'] ); } include_once drupal_get_path ( 'module', 'tshirtslayer' ) . '/geoip/geoipcity.inc'; include_once drupal_get_path ( 'module', 'tshirtslayer' ) . '/geoip/geoipregionvars.php'; geoip_load_shared_mem ( drupal_get_path ( 'module', 'tshirtslayer' ) . '/geoip/GeoLiteCity.dat' ); $gi = geoip_open ( drupal_get_path ( 'module', 'tshirtslayer' ) . '/geoip/GeoLiteCity.dat', GEOIP_SHARED_MEMORY ); $result = db_query ( "SELECT login, access, name, uid, last_ip from users where lower(country)='%s' order by access desc", strtolower ( $_GET ['f'] ) ); while ( $acc = db_fetch_object ( $result ) ) { if ($acc->access == 0) { $ago = "never"; } else { $record = geoip_record_by_addr ( $gi, $acc->last_ip ); $city = ""; if($record->region) { $city = " from ".$GEOIP_REGION_NAME[$record->country_code][$record->region]." region"; } $ago = 'Visited ' . format_interval ( time () - $acc->access ) . ' ago'.$city; } print theme ( 'username', $acc ) . ' ' . $ago . '
'; } geoip_close($gi); } ?>