Click and drag to zoom into an region. Click on a country to zoom into that country.
Click on the ocean or use the right-click menu to zoom out.
";
/*
include("dbcon.php");
$backthen=date("Y-m-d H:i:s",(strtotime("-1 day")));
if($ccode){
$sql="SELECT mood, count( mood ) as tmood FROM wmi where tid>'$backthen' AND land='".$ccode."' GROUP BY mood";
}else{
$sql="SELECT mood, count( mood ) as tmood FROM wmi where tid>'$backthen' GROUP BY mood";
}
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$moodcount[($row[mood])]=$row[tmood];
}
$moodcount["t"]=$moodcount["n"]+$moodcount["p"];
$moodcount["np"]=@round((100/($moodcount[t]/$moodcount[n])),2);
$moodcount["pp"]=@round((100/($moodcount[t]/$moodcount[p])),2);
if($ccode){
$sql2="SELECT * FROM ccodes WHERE iso3166='".$ccode."'";
$result2=mysql_query($sql2);
$row2=mysql_fetch_array($result2);
$o.= "
$row2[entity] mood: ";
}else{
$o.= "
Current World Mood: ";
}
$o.="Positive: $moodcount[pp]% - Negative: $moodcount[np]%
";
$sql="SELECT land, count(land) as tland FROM wmi GROUP BY land ORDER BY tland DESC LIMIT 10";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result)){
$sql2="SELECT * FROM ccodes WHERE iso3166='".$row[land]."'";
$result2=mysql_query($sql2);
$row2=mysql_fetch_array($result2);
$o.= "$row2[entity] $row[tland] ";
}
*/
$o.="