From 354f4761316e2f62600fedf51149e41bde6557d9 Mon Sep 17 00:00:00 2001 From: Hugues Hiegel Date: Wed, 12 Nov 2008 22:13:20 +0100 Subject: Badges is not a link anymore. --- Badges_v2.php | 370 ---------------------------------------------------------- 1 file changed, 370 deletions(-) delete mode 100644 Badges_v2.php (limited to 'Badges_v2.php') diff --git a/Badges_v2.php b/Badges_v2.php deleted file mode 100644 index 0e21357..0000000 --- a/Badges_v2.php +++ /dev/null @@ -1,370 +0,0 @@ - - - Thanks to Pavel Zbytovský - www.zby.cz - for saving me time with the MySQL stuff ! - - -CREATE TABLE `users` ( - `username` varchar(100) NOT NULL, - `statsstart` bigint(11) NOT NULL, - `playcount` int(10) unsigned NOT NULL, - `lastupdate` bigint(11) unsigned NOT NULL, - PRIMARY KEY (`username`) -) ; - -CREATE TABLE `badges` ( - `username` varchar(100) NOT NULL, - `type` varchar(100) NOT NULL, - `style` varchar(100) NOT NULL, - `color` varchar(100) NOT NULL, - `lastupdate` bigint(11) default NULL, - `hits` bigint(20) unsigned NOT NULL, - `lasthit` bigint(11) unsigned default NULL, - `png` longblob, - PRIMARY KEY (`username`,`type`) -); - - * - */ - -/*get the parameters*/ -$Pathinfo=$_SERVER['PATH_INFO']; -$pathinfo=explode("/", $Pathinfo); -$script=explode("/", $_SERVER['SCRIPT_NAME']); - -$username=$pathinfo[1]; -$type=$pathinfo[2]; -$style=$pathinfo[3]; -$color=$pathinfo[4]; - -include("Config.php"); - -mysql_connect(MYSQL_HOST, MYSQL_USER); -mysql_select_db(MYSQL_DB); - -/*make cache data (array $data)*/ -$res = mysql_query("SELECT * FROM users WHERE username='" . gpc_addslashes(strtolower($username)) . "'"); -$data = mysql_fetch_assoc($res); - -if(($username AND !mysql_num_rows($res)) -OR ($data["lastupdate"] AND $data["lastupdate"]+CACHE < time())) - make_db_cache($username); - -/*output image cache*/ -$Cache=CACHE_FOLDER."/Pictures/".strtolower(rawurlencode($username))."_$type-$style-$color.png"; -//if (strtolower($username)=="gugusse") - //$Cache=""; - -clearstatcache(); - -//if (is_file($Cache) AND (filemtime($Cache) >= $data['lastupdate'])){ - //header("Location: ".$Cache); //its faster, but you should set CACHE_FOLDER = "." -//} - -/*----------------------------------------------------------- - Ok, now we are ready to create the image with GD. -*/ - -$playcount = $data['playcount']; -$statsstart = $data['statsstart']; - -$Lines = array(); -$Lines[] = new Text; - -if (! $playcount) -{ - $Lines[0]->value="Sorry, $username is not"; - $Lines[0]->angle=rand(-1,2); - $Lines[] = new Text; - $Lines[1]->value="a valid Last.fm account"; - $Lines[1]->angle=rand(-2,1); - define(HEIGHT, 50); - $Cache=""; -} -else -{ - $res = mysql_query("SELECT * FROM badges WHERE username='" . gpc_addslashes(strtolower($username)) . "' AND type='$type' AND style='$style' AND color='$color';"); - $badge = mysql_fetch_assoc($res); - - if ( !is_file($Cache) - OR (filemtime($Cache) < $data['lastupdate']) - OR !filesize($Cache)) - { - - $duration = $_SERVER['REQUEST_TIME'] - $statsstart; - $months = $duration / (60*60*24*30); - $weeks = $duration / (60*60*24*7); - $days = $duration / (60*60*24); - $permonth = floor($playcount / $months); - $perweek = floor($playcount / $weeks); - $perday = floor($playcount / $days); - - switch($type) - { - case "PerDay": - $Lines[0]->value = "$perday tracks per Day"; - $Lines[0]->angle = rand(2,13); - break; - case "PerWeek": - $Lines[0]->value = "$perweek tracks per Week"; - $Lines[0]->angle = rand(2,13); - break; - case "PerMonth": - $Lines[0]->value = "$permonth tracks per Month"; - $Lines[0]->angle = rand(2,13); - break; - case "PerDay2": - $Lines[] = new Text; - $Lines[0]->value = "$perday"; - $Lines[0]->angle = rand(2,13); - $Lines[1]->value = "tracks per Day"; - $Lines[1]->angle = rand(2,13); - break; - case "PerWeek2": - $Lines[] = new Text; - $Lines[0]->value = "$perweek"; - $Lines[0]->angle = rand(2,13); - $Lines[1]->value = "tracks per Week"; - $Lines[1]->angle = rand(2,13); - break; - case "PerMonth2": - $Lines[] = new Text; - $Lines[1]->value = "tracks per Month"; - $Lines[0]->angle = rand(2,13); - $Lines[0]->value = "$permonth"; - $Lines[1]->angle = rand(2,13); - break; - case "Trueness": - $Lines[0]->value = "is "; - $Lines[0]->value .= ($permonth > TRUENESS ? "an" : "a"); - $Lines[0]->angle = rand(2,13); - define(HEIGHT, 50); - $Lines[] = new Text; - $Lines[1]->value = ($permonth > TRUENESS ? "untrue" : "true"); - $Lines[1]->value .= " listener"; - $Lines[1]->angle = rand(2,13); - - if (strlen($username." ".$Lines[0]->value) >= strlen($Lines[1]->value)) - { - $Lines[1]->value = $Lines[0]->value." ".$Lines[1]->value; - $Lines[0]->value = $username; - } - else - { - $Lines[0]->value = $username." ".$Lines[0]->value; - } - break; - case "Trueness2": - $Lines[] = new Text; - $Lines[] = new Text; - $Lines[0]->value = "$username is "; - $Lines[0]->value .= ($permonth > TRUENESS ? "an" : "a" ) ; - $Lines[0]->angle = rand(2,13); - $Lines[1]->value = ($permonth > TRUENESS ? "Untrue" : "True"); - $Lines[1]->angle = rand(2,13); - $Lines[2]->value = "listener"; - $Lines[2]->angle = rand(2,13); - break; - case "Since": - $Lines[0]->value = strftime("since %B %Y", $statsstart); - $Lines[0]->angle = rand(2,13); - break; - case "Since2": - $Lines[] = new Text; - $Lines[] = new Text; - $Lines[0]->value = "listening since"; - $Lines[0]->angle = rand(2,13); - $Lines[1]->value = strftime("%B", $statsstart); - $Lines[1]->angle = rand(2,13); - $Lines[2]->value = strftime("%Y", $statsstart); - $Lines[2]->angle = rand(2,13); - break; - case "Total": - $Lines[0]->value = "$playcount tracks played"; - $Lines[0]->angle = rand(2,13); - define(HEIGHT, 40); - break; - case "Total2": - $Lines[0]->value = "$playcount"; - $Lines[0]->angle = rand(2,13); - $Lines[] = new Text; - $Lines[1]->value = "tracks played"; - $Lines[1]->angle = rand(2,13); - break; - default: - $Lines[0]->value = "Sorry !"; - $Lines[0]->angle = rand(2,13); - $Lines[] = new Text; - $Lines[1]->value = "Not available"; - $Lines[1]->angle = rand(2,13); - define(HEIGHT, 50); - break; - } - - foreach ($Lines as $Line) - $Line->font = "import/" . $Styles[$style]; - - $y=0; - foreach ($Lines as $Line) - { - $size=imageftbbox($Line->size, $Line->angle, $Line->font, $Line->value); - $Line->initiate($size); - $y+=$Line->height; - $Line->y=$y; - } - - $Image = new Text; - $Image->width = WIDTH; - $Image->height = $y; - - $img=imagecreatetruecolor($Image->width, $Image->height); - imagealphablending($img, FALSE); - imagesavealpha($img, TRUE); - - foreach ($Lines as $Line) - { - $Line->color=imagecolorallocate($img, GetColor("r", $Colors[$color]), - GetColor("g", $Colors[$color]), - Getcolor("b", $Colors[$color])); - } - - $transparent=imagecolorallocatealpha($img, 255, 255, 255, 127); - - imagefilledrectangle($img, 0, 0, $Image->width, $Image->height, $transparent); - - foreach ($Lines as $Line) - imagettftext($img, $Line->size, $Line->angle, $Line->x, $Line->y, $Line->color, $Line->font, $Line->value); - - - imagepng($img, $Cache); - imagedestroy($img); - - $QUERY=sprintf("REPLACE INTO badges (username, type, style, color, lastupdate, png) VALUES ('%s','%s','%s','%s', %s, '%s');", - $username, - $type, - $style, - $color, - time(), - $Cache ); - //echo $QUERY; - mysql_query($QUERY); - } - - if (is_file($Cache)) - { - touch_badge($username, $type, $style, $color); - header("Content-Type: image/png"); - //echo $Cache; - echo file_get_contents($Cache); - } -} - - - -function make_db_cache($username){ - global $data; - $profile_xml = file_get_contents("http://ws.audioscrobbler.com/1.0/user/".rawurlencode($username)."/profile.xml"); - - $feed=new XMLReader(); - if($feed->xml($profile_xml)){ - while ($feed->read()) - { - switch ($feed->name) - { - case "playcount": - $feed->read(); - $data['playcount']=intval($feed->value); - $feed->read(); - break; - - case "registered": - case "statsreset": - $data['statsstart']=$feed->getAttribute("unixtime"); - $feed->read(); - $feed->read(); - break; - - case "profile": - $data['username']=$feed->getAttribute("username"); - break; - } - } - - if ($playcount != 0) - { - $QUERY=(sprintf("REPLACE INTO users (statsstart,playcount,lastupdate,username) VALUES ('%s',%s,'%s','%s');", - time(), $data['playcount'], gpc_addslashes($data['statsstart']), gpc_addslashes(strtolower($username)))); - mysql_query($QUERY); - } - } -} - -function touch_badge($username, $type, $style, $color) -{ - $res = mysql_query("SELECT hits FROM badges WHERE username='" . gpc_addslashes(strtolower($username)) . "' AND type='$type' AND style='$style' AND color='$color';"); - $data = mysql_fetch_assoc($res); - - if(mysql_num_rows($res)) - $hits = $data["hits"]; - $hits++; - - $QUERY=sprintf("UPDATE badges SET hits=%s, lasthit='%s' WHERE username='%s' AND type='$type' AND style='$style' AND color='$color';", - $hits, time(), gpc_addslashes(strtolower($username))); - //echo $QUERY; - mysql_query($QUERY); -} - -function gpc_addslashes($str){ - return (get_magic_quotes_gpc() ? $str : addslashes($str)); -} - -function GetColor($color, $code) { - switch($color) - { - case "r": - return ($code >> 16) & 0xff; - break; - case "g": - return ($code >> 8) & 0xff; - break; - case "b": - return ($code >> 0) & 0xff; - break; - } -} - - -class Text { - var $width = 0; - var $height = 0; - var $x = 0; - var $y = 0; - - var $font = ""; - var $size = 150; // High values to better quality - var $angle = 0; - var $color = 0; - var $value = ""; - - function initiate($size) { - $this->width = abs( - max($size[0], $size[2], $size[4], $size[6]) - - min(0, $size[0], $size[2], $size[4], $size[6]) - ); - $this->height= abs( - max($size[1], $size[3], $size[5], $size[7]) - - min(0, $size[1], $size[3], $size[5], $size[7]) - ); - - $ratio = WIDTH / $this->width; - - $this->width *= WIDTH; - $this->height *= $ratio; - $this->size *= $ratio; - } -} - -- cgit v1.2.3