Announcement!

Have you read the author's personal blog? FYI, his personal blog is written in Malay.

Nov25

WP Plugin: Site Statistics

No Category

Last Update: 25 January 2008

Plugin Name: Site Statistics
Version: 1.7
Plugin URI: http://www.cypherhackz.net/plugins-themes/site-statistics/
Description: Show your site statistics. Posts, comments, categories, last post, last commentator and last modified.
Author: Fauzi Mohd Darus
Author URI: http://www.cypherhackz.net/

Demo:

Posts: 759
Comments: 7,040
Categories: 109
Last Post: FileHippo.com – My Source to Download Free Softwares
Last Commentator: FileHippo.com – My Source to Download Free Softwares at … | Bollywood World Bollywood Movies Bollywood Songs Bollywood Gossip Tube4ever.com
Last Modified: July 3, 2009 @ 11:46 pm (GMT 8)

Download:

How to Install

  1. Download the plugin file.
  2. Extract file cypher_site-statistics.zip.
  3. Upload site-statistics.php to your Wordpress plugin folder.
  4. Activate the plugin in your Plugins admin panel.
  5. Put this function <?php cypher_sitestats(); ?> in your sidebar.php
  6. Done!

How to Upgrade

  1. Download the plugin file.
  2. Extract file cypher_site-statistics.zip.
  3. Upload site-statistics.php to your Wordpress plugin folder to replace the previous version plugin.
  4. Done!

Version History

  • 1.7
    - Fix the category issue. Thanks to Fabian Terh.
  • 1.6
    - Change from categories to terms table. Wordpress 2.3 compatible.
  • 1.5
    - Fix count posts issue. Thanks to Martin.
  • 1.4
    - Compatible with Wordpress 2.1
  • 1.3
    - Only display approved comments.
    - Last Modified is now easier to read.
  • 1.2
    - Include permalinks instead of using Wordpress post IDs.
  • 1.0
    - Initial Release

As a part of 70-431 and 350-030, students have to learn the evaluation and determination of site statistics. Usually the pros in 640-822 and 642-642 series also learn this but not until they are done with 70-294 too.

41 Responses to “WP Plugin: Site Statistics”

  1. Spearhead
    December 1st, 2006 | 11:47 pm

    Very good! Thank you very much!
    非常好的插件，值得大家使用！

  2. CypherHackz
    December 2nd, 2006 | 3:21 am

    No problem and thanks for the comment. :)

  3. La strada in salita » Alcune modifiche
    January 9th, 2007 | 7:05 pm

    [...] Site Statistics, che potete vedere ora attivo sotto i Siti Consigliati. [...]

  4. Martin
    February 15th, 2007 | 4:26 pm

    Hello there. I am using your plugin on my site and I really think it’s very good, but:

    The point “posts” in the list do not only count the posts! It also counts the sites. So how can deal with that? I just wanted the posts to be counted! Maybe it would be good to add the point “sites” to this list. So that the sites are counted seperately!?

    I am not the pro in php – better said a lil noob :d

    Thanks for answer – u can also send me an e-mail but please use no slang, my english is not that good! ;)

  5. Martin
    February 15th, 2007 | 4:40 pm

    solved the problem alone :d

  6. CypherHackz
    February 15th, 2007 | 7:31 pm

    dear martin,

    could you please give me more details about your problem and how you solve it? thank you. :d

  7. Martin
    February 15th, 2007 | 7:44 pm

    the code which defines to display the number of posts not only counts the posts. The sites are also counted. That means that the number displayed is posts + sites. That was the Problem.

    I changed your code a lil bit ::
    $numpages = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'page'");

    $numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post'");
    if (0 get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'");
    if (0 get_var("SELECT COUNT(*) FROM $wpdb->categories");
    if (0 posts: ' . $numposts . 'Comments: ' . $numcomms . 'Cats: ' . $numcats . '';
    By trying this you will see, that the pages are also listed and seperately counted.

    I hope u could unterstand my bad english?! Hope that i could help with the changed code!? :d

  8. CypherHackz
    February 15th, 2007 | 7:51 pm

    i got it. i’ve checked back the plugin and it is incorrect. i will edit it and will release the next version. thanks for bring up this issue. :)>-

  9. Martin
    February 15th, 2007 | 7:55 pm

    :d/ … :d

  10. CypherHackz
    February 15th, 2007 | 8:05 pm

    plugin updated. thanks to you man. btw i put your link in the version history.

  11. Martin
    February 15th, 2007 | 8:10 pm

    Wow. getting prominent by editing 2 lines of php … thnx … :)>-

  12. hate and pain » Blog Archive » Kleine Plugins für mein Blog.
    February 22nd, 2007 | 9:24 pm

    [...] da wir schon mal dabei sind: Site Statistics – zu sehen im Menü [...]

  13. The Plugins I use » Home Biz Blogger
    March 30th, 2007 | 8:43 am

    [...] Site Statistics [...]

  14. Populiariausi tinklaraščio straipsniai - WordPress Gidas
    June 21st, 2007 | 11:26 pm

    [...] Kai kurie statistikos įskiepiai taip pat turi galimybę pateikti populiariausių straipsnių sąrašus. Keli iš jų: Referral Tracker, bsuite b2, Site Statistics. [...]

  15. Ktb
    June 24th, 2007 | 7:21 am

    i’ve followed your tutorial.
    a thousand times approx.
    and all i get is this!

    Fatal error: Call to undefined function: cypher_sitestats() in /home/jenny/public_html/dirtycandie/home.php on line 256

    grrrrrr! :((

  16. CypherHackz
    June 24th, 2007 | 12:22 pm

    are you sure? have you activated the plugin? :-?

  17. Ktb
    June 25th, 2007 | 10:28 am

    Yeah i Did. :(

  18. CypherHackz
    June 25th, 2007 | 4:14 pm

    it seems like the function is not working because the plugin is not activate. did you use the latest version?

  19. Ktb
    June 26th, 2007 | 11:23 am

    YAY!
    I got it working.
    It didn’t have to do with the activation,
    something wierd.
    Thanks for the code, I love it.

  20. CypherHackz
    June 26th, 2007 | 11:37 am

    lol… but im glad to hear that. :d

  21. oggin
    July 21st, 2007 | 7:47 pm

    10x for your very nice plugin!

  22. منتديات
    August 18th, 2007 | 5:46 pm

    thanks

  23. Jay
    September 28th, 2007 | 10:29 am

    On my site it is showing this error

    WordPress database error: [Table 'wastedre_wordpress.wp_categories' doesn't exist]
    SELECT COUNT(*) FROM wp_categories

    Does anyone know how to fix that? Thanks

  24. Rick
    September 28th, 2007 | 1:36 pm

    I got the same error as Jay, but the fix is straightforward. The error occurs because WP2.3 uses “terms” instead of “categories” for the taxonomy and changes the SQL table “wp_categories” to “wp_terms” as part of the upgrade.

    The fix is to alter line 23 in site-statistics.php from:

    $numcats = $wpdb->get_var(”SELECT COUNT(*) FROM $wpdb->categories”);

    to:

    $numcats = $wpdb->get_var(”SELECT COUNT(*) FROM $wpdb->terms”);

    This works for me with no further modification needed. Let me know if it does for you too.

  25. Jay
    September 28th, 2007 | 2:20 pm

    Yeah that worked, thanks Rick

  26. thebinding - V1 » Blog Archive » domain
    October 1st, 2007 | 9:03 am

    [...] yet, I’m still on my first one.Wordpress PluginsAsk Me WP2.1Comment PluggerCounterizeExec-PHPSite StatisticsText ControlTiger Style Administration Thanks: [...]

  27. CypherHackz
    October 26th, 2007 | 12:09 pm

    Rick – Thanks for the fix. I don’t have time to check the code because I have other works and need to study for my exam. Anyway, thanks again. Will release the new update soon.

  28. urdu bloggin plugin tidbits | بدتمیز
    January 1st, 2008 | 4:57 am

    [...] اب ڈیش پورڈ سے اٹھ کر سائیڈ بار میں آ گئیں ہیں۔ اس پلگ ان کی [...]

  29. Fabian
    January 20th, 2008 | 6:14 pm

    Um why does the category shows “38″ when I have only 3 categories?

  30. CypherHackz
    January 21st, 2008 | 6:51 pm

    I already know about it but don’t have time to fix this plugin. I am really2 sorry for that.

  31. timmie
    January 25th, 2008 | 4:49 am

    hello.. i read the comment above and saw that someone is also having category issues.. where exactly is the problem maybe we could fix it ourselves if it’s simple? i’m having the same problem and i do want to use the plugin but i want to fix the category number first. thanks :D

  32. CypherHackz
    January 25th, 2008 | 11:35 pm

    New version has been released. Please download the latest version. :)

  33. Hypercast » Blog Archive » Plugins do WordPress em uso no Hypercast
    March 14th, 2008 | 8:05 am

    [...] Site Statistics – Coleta várias estatísticas interessantes sobre o site; [...]

  34. Anoynmous
    May 17th, 2008 | 6:14 am

    Have you thought about making this into a sidebar widget for those who use widgets?

  35. CypherHackz
    May 19th, 2008 | 7:23 pm

    Yeah but not now because kinda busy lately. But thanks for you suggestion. :)

  36. nadiyah
    June 3rd, 2008 | 8:12 am

    I was wondering… how do you change the date and time where it says “Last Modified”?

  37. rule strategy poker
    July 28th, 2008 | 12:14 am

    poker rule rules poker rule rules

  38. hentai pic medusa
    September 5th, 2008 | 9:56 am

    medusa hentai pic pic hentai medusa

  39. مركز تحميل
    October 7th, 2008 | 8:27 pm

    poker rule rules poker rule rules

  40. ♥ true-luv.com » Blog Archive » Site Statistics
    October 14th, 2008 | 12:14 am

    [...] dúvidas Jul 07 Site Statistics Sexta-feira, 07-07-2006 # 13:35 Plugins, Tutoriais 168 palavras Mostra o número de posts, comentários gerais, além do nome da última pessoa que comentou e a data e hora da última atualização. Compatível com Wordpress 2.3 e 2.5. Para outras versões do wordpress, verifique a compatibilidade ou a disponibilidade de outra versão do plugin no site do autor. Página do plugin cypherhackz.net [...]

  41. Lee.org » Blog Archive » Current Wordpress Plugins 4-20-09
    April 21st, 2009 | 7:54 am

    [...] Site Statistics (v. 1.7) by Fauzi Mohd Darus. [...]

Leave a Reply




Subscribe RSSSend Trackback