All pastes #526624 Raw Edit

Unnamed

public text v1 · immutable
#526624 ·published 2007-05-31 21:43 UTC
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);
?>