Mini Mods - Display Number (count) of Articles Posted by user in postbit

What this mod does
After installing this mod it will display the number of articles that a member has posted underneath "Posts:" in the postbit.

What this mod doesn't do (yet!)
This mod will not deduct from Article count when "Unpublishing", i will be working on this when time allows.

How to install
Simply download the product and install via AdminCp>Plugins & Products>Manage Products>Add/Install Product

The resources this mod uses
2 queries on install one of which may take quite some time on big boards
1 query when publishing an article
1 query when deleting an article
1 query on uninstall

Please mark as installed if you use this
Support will only be given to those that have marked it installed

__________________________________________________ ______________
Special Thanks to these people for helping me sort out my installation issues
Lynne
KH99
HMBeaty
Paul M

Version History
7th December 2011 Intial release ver1.0.0
8th Decmber 2011 Minor update, count is now clickable link to articles ver1.0.1
8th December 2011 minor change to fix my fixed url

When upgrading uninstall previous version first!!!

[KristerSwe]

My articles is made from CMS.. but i have table prefix "hd" so what should i do ..

thanks

[Simon Lloyd]

Your table prefix shouldn't make a difference, if you mean your table is like this "hd_user" then you should be good, have you tried running the query i gave above?

[Simon Lloyd]

I have just promoted a post/thread to article and the count increases

[KristerSwe]

okey i tried this now and i this is my settings

SELECT * 
 , COUNT(postusername) as count  
FROM hdthread  
WHERE title LIKE "Article:%" 
 AND postuserid =1

and finded only 1 post of many i have made . sorry am not so familiar with all this

[Simon Lloyd]

Originally Posted by Mr_Running

....Also it would be an improvement if it linked to the articles.

Will release this later tonight

[Simon Lloyd]

Originally Posted by KristerSwe

okey i tried this now and i this is my settings

SELECT * 
 , COUNT(postusername) as count  
FROM hdthread  
WHERE title LIKE "Article:%" 
 AND postuserid =1

and finded only 1 post of many i have made . sorry am not so familiar with all this

Assuming you ARE userid 1 your query should have been this

SELECT * 
 , COUNT(postusername) as count  
FROM hd_thread  
WHERE title LIKE "Article:%" 
 AND postuserid =1

run it and let me know the results , remember it will only show you a single row so it will only be one post but im interested in the column on the far right!

[Simon Lloyd]

Hey all, if you are upgrading you need to uninstall any previous version first

[Mr_Running]

Excellent !
Note: I opened the xml to change the site to mine...may want to make a note to change.

[Mr_Running]

Version 1.0.0 for dbtech tabs

Originally Posted by KristerSwe

you can use this code in DBT Postbilt tabmod but need to remove some doublepost from postbit template... am playing with it right now

<dt>{vb:rawphrase artcount}</dt><dd>{vb:raw $post['artcount']}{vb:raw artvar}</dd>

oh and KristerSwe - I placed your code here in [code] If I may suggest you may want to edit your post too.

Version 1.0.1

<dt>{vb:rawphrase artcount}</dt><dd><a href="http://www.yoursite.com/list.php?author/{vb:raw artlink}">{vb:raw $post['artcount']}{vb:raw artvar}</a>
</dd>

Oh and the 1.0.1 xml as of right now needs to be edited to yoursite.

fixed in 1.0.2 xml

<dt>{vb:rawphrase artcount}</dt><dd><a href="./list.php?author/{vb:raw artlink}">{vb:raw $post['artcount']}{vb:raw artvar}</a>
</dd>

[Simon Lloyd]

Originally Posted by Mr_Running

Excellent !
Note: I opened the xml to change the site to mine...may want to make a note to change.

Fixed in new xml sorry about that, just rushed it out!