 |
Broomball Association of South Australia |
 Latest BASA News |
|
| Broomball Videos |
|
| Adelaide League | |
| This Weeks Schedule |
|
| Last Weeks Results |
|
| Premiership Table |
|
| Next Weeks Schedule |
|
| Season Schedule |
|
| Rink Location |
|
| Contact Us |
|
| Southern League | Match Results |
| Premiership Table |
|
| Rink Location |
|
| Contact Us |
|
| Administration | |
| Administration |
|
| Google Web Search |
|
| BASA Mobile Home |
|
|
$users Online \n");
} else {
print(" $users Online \n");
}
$result = mysql_query("SELECT id FROM TG_whos_online order by id desc limit 0,1") or die("Error in who's online result query!");
$row = mysql_fetch_array($result);
//Show Who's Online
print("and $row[id] visits. \n");
// $result = mysql_query("SELECT DISTINCT ip, file FROM TG_whos_online") or die("Error in who's online read result query!");
// while ($row = mysql_fetch_array ($result) )
//{
// Query for getting visitor countrycode
$country_query = "SELECT country_code2,country_name FROM iptocountry WHERE IP_FROM<=inet_aton('".$_SERVER['REMOTE_ADDR']."') AND IP_TO>=inet_aton('".$_SERVER['REMOTE_ADDR']."')";
// Executing above query
$country_exec = mysql_query($country_query);
// Fetching the record set into an array
$ccode_array=mysql_fetch_array($country_exec);
// getting the country code from the array
$country_code=$ccode_array['country_code2'];
// getting the country name from the array
$country_name=$ccode_array['country_name'];
$insert = mysql_query("INSERT INTO BASA_WEB_STATS (ip, page,country) VALUES('".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."','$country_name')") or die("Error in who's online insert query!");
// }
mysql_close($Link);
?> |