Total number of posts in last year

All you need to do is modify the SQL query. Using the code you linked as a base: $numposts = $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->posts WHERE post_status=”publish” AND year(post_date) = 2010″); if (0 < $numposts) $numposts = number_format($numposts); The ‘AND’ I added basically gives you all the posts of 2010. Change the year accordingly

Possibility to Display Most used Words?

This answer is just to put down a kind of roadmap. I think the question touches some machine learning concepts, you used the right “statistics” tag. You need to build a dictionary plugin learning from your new posts. Probably doing something like: Manually create a first json filter dataset of most used words in your … Read more

Best Apache Log Analyzer Plugin? [closed]

“best apache log analyzer plugin for WordPress” This is a joke question, right? If not, no offense, but you’re probably new to the web. And if so, you probably should know that Apache logs actually pick up and log: Search Engine bots (not just Google: any bot, and there are many, many, many…) Comment spam … Read more

Jetpack – stats_get_csv period parameter

While researching to answer this SO Question, stumbled upon this one, which gave me the final hint. I’ll reproduce the relevant part: Function get_stats_csv /plugins/jetpack/modules/stats.php The function get_stats_csv calls http://stats.wordpress.com/csv.php. If we visit this address, we get this response: Error: api_key is a required parameter. Required parameters: api_key, blog_id or blog_uri. Optional parameters: table, post_id, … Read more

Network wide post count (WP Multisite)

You don’t seem to call posts_count_func() anywhere, so if your transient expires, it’s not getting reset. function posts_shortcode_count_func( $atts ){ $post_count = get_site_transient( ‘total_posts_cache’ ); if( ! $post_count ) { posts_count_func(); $post_count = get_site_transient( ‘total_posts_cache’ ); } return $post_count; } add_shortcode( ‘posts’, ‘posts_shortcode_count_func’ ); According to the docs for get_transient() (which is the non-network version … Read more

Blog statistics

Piwik is similar to Google Analytics, but you install on your own server. Also- I’ve seen a private internal intranet site that was tracked on Google Analytics. It was certainly not publicly or search engine accessible, so it is possible to at least use GA on a private site if you’re curious to investigate further.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)