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!!!

[Simon Lloyd]

***reserved***

[leejohn02]

is there a way to use this in the db postbit tabs, ie can u please release the code and what template its in so i can move it into dbtech postbit icons, thanks, and nice mod been looking for this

[Simon Lloyd]

I have no idea what you mean by db postbit tabs!

[KristerSwe]

Hi, installed it and shows in postbit, but is not count the articles i have already done? is show zero.

Maybe it counts the articles i made after the install ... ???

[KristerSwe]

Originally Posted by leejohn02

is there a way to use this in the db postbit tabs, ie can u please release the code and what template its in so i can move it into dbtech postbit icons, thanks, and nice mod been looking for this

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>

[Dr.osamA]

installed

thank you bro , keep it up

[Mr_Running]

Originally Posted by KristerSwe

but is not count the articles i have already done? is show zero.

Maybe it counts the articles i made after the install ... ???

Yes, confirm mine reads zero - 0 - too!

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

[Simon Lloyd]

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>

Have you now got a count since you are trying to integrate it?

Originally Posted by Mr_Running

Yes, confirm mine reads zero - 0 - too!

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

I installed this on a live board and it DID count the articles on install, how did you create your articles? was it through the CMS or was it by promoting a post to article?, also it will only count articles if you haven't changed the prefix from Article to something else, the best way to check is to run this in your admincp>maintainance>execute query:

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

don't forget to change PREFIX for your forum database prefix so it would read something like "vb_thread" (without the quotes), and dont forget to insert your userid inplace of YOUR USERID.

When you run the query you will get a single row table, at the far right of the table will be the count row where your total amount of threads that have the prefix "Article:" in front of them, let me know the result.

[Mr_Running]

Originally Posted by Simon Lloyd

how did you create your articles?

Article was originally published in blog. (blog promoted to article)

I will try the execute query when I get to my computer.