1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<?php
/* $Id: function.popularposts.php,v 1.2 2005/01/09 11:54:18 donncha Exp $ */
/*
* Smarty plugin
* -------------------------------------------------------------
* File: function.popularposts.php
* Type: function
* Name: popularposts
* Purpose: outputs an image from the images/ directory.
* -------------------------------------------------------------
*/
function getlinks( $wpblog )
{
global $wpdb, $site;
$s = strlen( $site );
$sql = "SELECT visitURL, sum( visitTimes ) as c
FROM `referer_visitLog`
WHERE blogID = '".$wpblog."'
AND visitURL LIKE '%/'
GROUP BY visitURL
ORDER BY c DESC LIMIT 0 , 30";
$results = $wpdb->get_results($sql);
if( $results )
{
reset( $results );
while( list( $key, $t ) = each( $results ) )
{
if( substr( $t->visitURL, -9 ) == 'index.php' )
$t->visitURL = substr( $t->visitURL, 0, -9 );
$hits[ $t->visitURL ] += $t->c;
}
arsort( $hits );
$hits = array_flip( $hits );
reset( $hits );
while( list( $key, $val ) = each( $hits ) )
{
if( substr( $val, -1 ) == '/' )
{
$post_name = substr( $val, 0, -1 );
$post_name = substr( $post_name, strrpos( $post_name, '/' ) + 1 );
$sql = "SELECT post_title
FROM ".$wpdb->posts."
WHERE post_name = '".$post_name."'";
$results = $wpdb->get_results($sql);
if( $results )
{
$links[ $key ] = array( "url" => $val, "title" => stripslashes( $results[0]->post_title ) );
}
}
}
}
else
{
$links = false;
}
return $links;
}
function smarty_function_popularposts($params, &$smarty)
{
global $wpblog;
extract( $params );
if( @include_once( "Cache/Function.php" ) )
{
$cache = new Cache_Function( 'file', array('cache_dir' => ABSPATH . "/wp-content/smarty-cache", 'filename_prefix' => 'popularposts_cache_' ), 3600 );
$links = $cache->call( "getlinks", $wpblog );
}
else
{
$links = getlinks( $wpblog, $site );
}
$smarty->assign( "pposts", $links );
}
?>
|
