@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
Anonymous
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.
Anonymous
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.
Anonymous
Re-downloaded it, still getting the same errors. 🙁
