Mood Map for the past month
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.="
Check out our Mood Stats - Local and global mood during the past month


"; include("topmoodinfo.php"); $o.=""; $pt=" - Mood Map for the past month"; include("template.php"); ?>