<ul> <?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5"); foreach ($result as $post) { setup_postdata($post); $postid = $post->ID; $title = $post->post_title; $commentcount = $post->comment_count; if ($commentcount != 0) { ?> <li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>"> <?php echo $title ?></a> {<?php echo $commentcount ?>}</li> <?php } } ?> </ul> 2009-08-22T15:30:43Z 196 35 false 2009-08-22T15:30:43Z 7 function getShortUrl($url) { $tinyurl = file_get_contents("http://tinyurl.com/api-create.php?url=".$url); return $tinyurl; } 2009-04-26T14:42:42Z paste the function in function.php file and call in you template with: <?php echo '<a href="'.getShortUrl(get_permalink($post->ID)).'">short url</a>'; ?> 172 35 false 2009-04-26T14:42:42Z 7 <?php if($_GET){ if($_GET['file']) { $filename = $_GET['file']; $download_path = "files/"; } if(eregi("\.\.", $filename)) die("I'm sorry, you may not download that file."); $file = str_replace("..", "", $filename); if(eregi("\.ht.+", $filename)) die("I'm sorry, you may not download that file."); $file = "$download_path$file"; if(!file_exists($file)) die("I'm sorry, the file doesn't seem to exist."); $type = filetype($file); $today = date("F j, Y, g:i a"); $time = time(); header("Content-type: $type"); header("Content-Disposition: attachment;filename=$filename"); header("Content-Transfer-Encoding: binary"); header("Cache-Control: "); header("Pragma: "); set_time_limit(0); readfile($file); } ?> 2009-01-06T00:58:17Z 146 35 true 2009-01-06T00:58:17Z 7 function watermark($imagesource){ $filetype = substr($imagesource,strlen($imagesource)-4,4); $filetype = strtolower($filetype); if($filetype == ".gif") $image = @imagecreatefromgif($imagesource); if($filetype == ".jpg") $image = @imagecreatefromjpeg($imagesource); if($filetype == ".png") $image = @imagecreatefrompng($imagesource); if (!$image) die(); $watermark = @imagecreatefrompng('../images/watermark.png'); $imagewidth = imageSX($image); $imageheight = imageSY($image); $watermarkwidth = imageSX($watermark); $watermarkheight = imageSY($watermark); $startwidth = $imagewidth - $watermarkwidth - 5; $startheight = $imageheight - $watermarkheight - 5; imagecopy($image, $watermark, $startwidth, $startheight, 0, 0, $watermarkwidth, $watermarkheight); imagejpeg($image,$imagesource); imagedestroy($image); imagedestroy($watermark); } 2008-11-23T22:09:18Z 116 35 false 2008-11-23T22:09:18Z 7 // comments_count function comments_count() { global $wpdb; $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"; echo $wpdb->get_var($count); } // < ?php comments_count() ?> comments // posts_count function posts_count() { global $wpdb; $count = "SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'"; echo $wpdb->get_var($count); } // <?php posts_count() ?></strong> articles // retro_count function retro_count() { global $wpdb; $count = "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_type = 'pingback'"; echo $wpdb->get_var($count); } // < ?php retro_count() ?> pingbacks 2008-11-18T02:26:17Z for example: save all functions in 'your_theme/stats.php' 107 35 false 2008-11-18T02:26:17Z 7 <?php function backup_tables($host,$user,$pass,$name,$tables = '*'){ $link = mysql_connect($host,$user,$pass); mysql_select_db($name,$link); //get all of the tables if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } //cycle through foreach($tables as $table) { $result = mysql_query('SELECT * FROM '.$table); $num_fields = mysql_num_fields($result); for ($i = 0; $i < $num_fields; $i++) { $return.= 'DROP TABLE '.$table.';'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); $return.= "\n\n".$row2[1].";\n\n"; while($row = mysql_fetch_row($result)) { $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j<$num_fields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = ereg_replace("\n","\\n",$row[$j]); if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; } if ($j<($num_fields-1)) { $return.= ','; } } $return.= ");\n"; } } $return.="\n\n\n"; } //save file $handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+'); fwrite($handle,$return); fclose($handle); } backup_tables('localhost','username','password','blog'); ?> 2008-09-01T00:10:48Z 55 35 false 2008-09-01T00:10:48Z 7 <? //////////////////////////////////////////////////////////////////////////////////// // generate a croped-image from a picture // source: http://mediumexposure.com/techblog/smart-image-resizing-while-preserving-transparency-php-and-gd-library // resizes a image, without crop // usage: resizeImage("test/6.jpg", "540", "720", true, "test/output.jpg") //////////////////////////////////////////////////////////////////////////////////// function resizeImage( $file, $width = 0, $height = 0, $proportional = false, $output = 'file') { $info = getimagesize($file); $image = ''; $final_width = 0; $final_height = 0; list($width_old, $height_old) = $info; if ($proportional) { if ($width == 0) $factor = $height/$height_old; elseif ($height == 0) $factor = $width/$width_old; else $factor = min ( $width / $width_old, $height / $height_old); $final_width = round ($width_old * $factor); $final_height = round ($height_old * $factor); } else { $final_width = ( $width <= 0 ) ? $width_old : $width; $final_height = ( $height <= 0 ) ? $height_old : $height; } switch ( $info[2] ) { case IMAGETYPE_GIF: $image = imagecreatefromgif($file); break; case IMAGETYPE_JPEG: $image = imagecreatefromjpeg($file); break; case IMAGETYPE_PNG: $image = imagecreatefrompng($file); break; default: return false; } $image_resized = imagecreatetruecolor( $final_width, $final_height ); if ( ($info[2] == IMAGETYPE_GIF) || ($info[2] == IMAGETYPE_PNG) ) { $trnprt_indx = imagecolortransparent($image); if ($trnprt_indx >= 0) { $trnprt_color = imagecolorsforindex($image, $trnprt_indx); $trnprt_indx = imagecolorallocate($image_resized, $trnprt_color['red'], $trnprt_color['green'], $trnprt_color['blue']); imagefill($image_resized, 0, 0, $trnprt_indx); imagecolortransparent($image_resized, $trnprt_indx); } elseif ($info[2] == IMAGETYPE_PNG) { imagealphablending($image_resized, false); $color = imagecolorallocatealpha($image_resized, 0, 0, 0, 127); imagefill($image_resized, 0, 0, $color); imagesavealpha($image_resized, true); } } imagecopyresampled($image_resized, $image, 0, 0, 0, 0, $final_width, $final_height, $width_old, $height_old); switch ( strtolower($output) ) { case 'browser': $mime = image_type_to_mime_type($info[2]); header("Content-type: $mime"); $output = NULL; break; case 'file': $output = $file; break; case 'return': return $image_resized; break; default: break; } switch ( $info[2] ) { case IMAGETYPE_GIF: imagegif($image_resized, $output); break; case IMAGETYPE_JPEG: imagejpeg($image_resized, $output); break; case IMAGETYPE_PNG: imagepng($image_resized, $output); break; default: return false; } return true; } ?> 2008-07-05T19:20:58Z 24 35 false 2008-07-05T19:20:58Z 1 //////////////////////////////////////////////////////////////////////////////////// // generate a croped-image from a picture // source: http://www.seaton-online.com/forum/index.php?showtopic=545 // usage: cropImage("300", "225", "test/5.jpg", "jpg", "test/output.jpg"); //////////////////////////////////////////////////////////////////////////////////// function cropImage($nw, $nh, $source, $stype, $dest) { $size = getimagesize($source); $w = $size[0]; $h = $size[1]; switch($stype) { case 'gif': $simg = imagecreatefromgif($source); break; case 'jpg': $simg = imagecreatefromjpeg($source); break; case 'png': $simg = imagecreatefrompng($source); break; } $dimg = imagecreatetruecolor($nw, $nh); $wm = $w/$nw; $hm = $h/$nh; $h_height = $nh/2; $w_height = $nw/2; if($w> $h) { $adjusted_width = $w / $hm; $half_width = $adjusted_width / 2; $int_width = $half_width - $w_height; imagecopyresampled($dimg,$simg,-$int_width,0,0,0,$adjusted_width,$nh,$w,$h); } elseif(($w <$h) || ($w == $h)) { $adjusted_height = $h / $wm; $half_height = $adjusted_height / 2; $int_height = $half_height - $h_height; imagecopyresampled($dimg,$simg,0,-$int_height,0,0,$nw,$adjusted_height,$w,$h); } else { imagecopyresampled($dimg,$simg,0,0,0,0,$nw,$nh,$w,$h); } imagejpeg($dimg,$dest,80); } 2008-07-05T19:19:43Z 23 35 false 2008-07-05T19:19:43Z 1 <?php echo "hello kitty"; ?> 2008-07-05T19:03:38Z 22 35 false 2008-07-05T19:03:38Z 1 $name = 'we_love_code'; preg_replace('/_([a-z])/e', 'strtoupper(\\1)', "_{$name}"); 2008-07-04T13:29:36Z Transforma uma string usando underscores para CamelCase 17 35 false 2008-07-04T13:29:36Z 28