WordPress Blogs Stats

@southerngal: I tried posting a post with a p/w protected post, no prob over here. what kind of error u getting?
@mtanner: =D

An error is coming in as I don’t know where to put the code you pasted here. ?? I guess I’m still learning all that stuff. I guessed as to where to put it! ?? Help, please!

hmm you mean how to exclude the cat?

You posted this GamerZ:
@southerngal: okie, updated. For the private category I think you need to modify the sql statement Add in ‘ AND cat_ID != {YOUR_CAT_ID}’ into gmz_get_blogcat()
So, where do I put that Add In? ;P

You need to use a JOIN and GROUP BY if you want to check cat_ID in 1.0+

Thanks so much! It was really easy to install. =)

Thanks GamerZ, I will try that. ?? ??

No Prob. Got Error, post it here =D

Wow, this is a great hack. I’m looking to switch from MT to WordPress. If I import all of my entries and comments from my MT site, do you know if your Stats hack will correlate? Or does it start from a clean slate despite the fact?

if its on WP, i believe stats will work with it.
@gamerz: Is there any modification in the code? coz i am still running the original version. never checked again… ?? if there are any updates, do tell me!

@sushubh: there is an update for private post with password will not appear on the stats. It is helpful if you are using private post =)

GamerZ, what do I put here? YOUR_CAT_ID
The number or name? I have tried everything. The cat ID is 2. Ack. I’m lost. ??
Is there a way to link the categories? I would like to have that option as well.

I’m trying to put this in my blog (WP 1.0.1) and got two errors:
Most commented post doesn’t show up properly.
? 10 Most Commented Posts
+ (13 Comments)
+ (13 Comments)
+ (13 Comments)
+ (11 Comments)
…
and so on. No posts are actually shown, just the number of comments. O.o
“Link Categories Stats” gives me this error:
Warning: Invalid argument supplied for foreach() in /home/alhenan/public_html/blog/wp-stats.php on line 134

@southerngal: Okie now the Blog Categories have link, and i have fixed some bugs and cut away redundant codes. replace YOUR_CAT_ID with your category, in this case is 2. Here is the code

SELECT cat_ID, cat_name, category_nicename, COUNT(*) AS ‘total_posts’ FROM $tableposts INNER JOIN $tablepost2cat ON $tablepost2cat.post_id = $tableposts.ID INNER JOIN $tablecategories ON $tablepost2cat.category_id = $tablecategories.cat_ID WHERE cat_ID != 2 GROUP BY $tablepost2cat.category_id ORDER BY total_posts DESC

@anonymous: can you try to re-download the file again? I ahve updated some stuffs.

Re-downloaded it, still getting the same errors. ??