rendered paste body<?
$usr=stripslashes($_GET['user']);
header("Content-type: image/png");
$connection = mysql_connect('localhost', '', '')
or die('MySQL has failed the life: ' . mysql_error());
mysql_select_db('meteorn_mncontent') or die('Could not connect to database :(');
$query=sprintf("SELECT COUNT(*) AS ratings, rating FROM ratings GROUP BY rating;");
$result = mysql_query($query, $connection) or die(mysql_error());
$resultassoc = mysql_fetch_assoc($result);
$res = array();
foreach ($resultassoc as $key) {
switch ($resultassoc['rating']) {
case "luaking":
$res['luaking'] = $resultassoc['ratings'];
break;
case "dumb":
$res['dumb'] = $resultassoc['ratings'];
break;
}
}
$im = imagecreatefrompng("ratebg.png");
$white = imagecolorallocate($im, 255, 255, 255);
$font=4;
imagestring($im, $font,30,15,$res['dumb'],$white);
imagestring($im, $font,105,15,$res['unfriendly'],$white);
imagestring($im, $font,175,15,$res['informative'],$white);
imagestring($im, $font,240,15,$res['goldstar'],$white);
imagestring($im, $font,310,15,$res['awfulspelling'],$white);
imagestring($im, $font,385,15,$res['luaking'],$white);
imagestring($im, $font,30,45,$res['funny'],$white);
imagestring($im, $font,105,45,$res['friendly'],$white);
imagestring($im, $font,175,45,$res['artistic'],$white);
imagestring($im, $font,240,45,$res['zing'],$white);
imagestring($im, $font,310,45,$res['thanks'],$white);
imagestring($im, $font,385,45,$res['luahelper'],$white);
imagestring($im, $font,420,10,$usr,$white);
imagepng($im);
imagedestroy($im);
mysql_free_result($page);
mysql_close($connection);
?>