vb.org Archive - Mini Mods - Display Number (count) of Articles Posted by user in postbit

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Mini Mods - Display Number (count) of Articles Posted by user in postbit (https://vborg.vbsupport.ru/showthread.php?t=275156)

Simon Lloyd

12-06-2011 11:00 PM

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

1 Attachment(s)

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

12-07-2011 08:41 AM

***reserved***

leejohn02

12-07-2011 01:20 PM

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

12-07-2011 03:58 PM

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

KristerSwe

12-07-2011 10:21 PM

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

12-07-2011 10:24 PM

Quote:

Originally Posted by leejohn02 (Post 2275538)

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

12-07-2011 10:50 PM

installed

thank you bro , keep it up

Mr_Running

12-08-2011 12:55 AM

Quote:

Originally Posted by KristerSwe (Post 2275705)

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

12-08-2011 06:47 AM

Quote:

Originally Posted by KristerSwe (Post 2275706)

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

Quote:

Originally Posted by Mr_Running (Post 2275737)

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:

HTML Code:

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

12-08-2011 11:31 AM

Quote:

Originally Posted by Simon Lloyd (Post 2275805)

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. :)

KristerSwe

12-08-2011 12:27 PM

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

thanks

Simon Lloyd

12-08-2011 01:44 PM

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

12-08-2011 02:04 PM

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

KristerSwe

12-08-2011 02:57 PM

okey i tried this now and i this is my settings

HTML Code:

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

12-08-2011 03:02 PM

Quote:

Originally Posted by Mr_Running (Post 2275737)

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

Will release this later tonight :)

Simon Lloyd

12-08-2011 03:04 PM

Quote:

Originally Posted by KristerSwe (Post 2275904)

okey i tried this now and i this is my settings

HTML Code:

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

HTML Code:

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

12-08-2011 03:32 PM

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

Mr_Running

12-08-2011 05:44 PM

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

Mr_Running

12-08-2011 06:34 PM

Version 1.0.0 for dbtech tabs

Quote:

Originally Posted by KristerSwe (Post 2275706)

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

Code:

<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

Code:

<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

Code:

<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

12-08-2011 07:17 PM

Quote:

Originally Posted by Mr_Running (Post 2275965)

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!

Simon Lloyd

12-08-2011 07:18 PM

Quote:

Originally Posted by Mr_Running (Post 2275975)

Version 1.0.1

Code:

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

This is fixed now :) Ver 1.0.2

Mr_Running

12-09-2011 03:02 AM

If I wanted to hide the word "Articles" and the "number" from usergroups where would I edit? and if I wanted to move it? :)

Simon Lloyd

12-09-2011 04:57 AM

You'd edit the template postbit_artcount and wrap the whole statement in that template in an IF condition like this

HTML Code:

<vb:if condition="!is_member_of($bbuserinfo, X, Y, Z)"><dt>{vb:rawphrase artcount}</dt><dd><a href="./list.php?author/{vb:raw artlink}">{vb:raw artvar}</a>

</dd></vb:if

So now it will show to all usergroups except x,y & z

kpuls

12-13-2011 03:20 PM

Thanks Simon!

Mr_Running

12-13-2011 04:26 PM

Quote:

Originally Posted by Simon Lloyd (Post 2275908)

Assuming you ARE userid 1 your query should have been this

HTML Code:

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!

An error occurred while attempting to execute your query. The following information was returned.

Code:

error number: 1146 error desc: Table 'xxxxxxxxxxxxxxx .hdthread' doesn't exist

Simon Lloyd

12-13-2011 09:54 PM

That may be because you have run the query to look for hdthread when it's probably hd_thread

Simon Lloyd

12-13-2011 09:55 PM

You're very welcome Kpuls, and thank you for allowing me to use www.excelguru.ca as a testing ground!

Mr_Running

12-14-2011 01:51 AM

Quote:

Originally Posted by Simon Lloyd (Post 2277496)

That may be because you have run the query to look for hdthread when it's probably hd_thread

Okay double checked

Code:

hd_thread

same error

Simon Lloyd

12-14-2011 07:30 AM

Quote:

Originally Posted by Mr_Running (Post 2277570)

Okay double checked

Code:

hd_thread

same error

PM Sent :)

Tri@de

06-18-2012 09:17 AM

I installed on 4.2.
the strange thing is i see i made only 1 article.
There's a way to update (recount) articles maded?

Simon Lloyd

06-18-2012 01:00 PM

Remove this line from the product xml

PHP Code:


		
			
$vbulletin->db->query_write(" ALTER TABLE " . TABLE_PREFIX . "user ADD artcount int(10) unsigned NOT NULL ");

then re-import th eproduct and select overwrite.

Tri@de

06-18-2012 01:45 PM

No way. i see only "1" but if i click on it i see all of them.
There's something with the language? I use italian language instead english.

Tri@de

06-18-2012 02:14 PM

I solved modifying the query in this way:

PHP Code:


		
			
$vbulletin->db->query_write(" UPDATE " . TABLE_PREFIX . "user AS user 
SET artcount = (SELECT COUNT(postusername) AS count 
FROM thread 
WHERE title LIKE 'Articolo:%' 
AND postuserid = user.userid) 
");

deverill2010

06-18-2012 02:52 PM

Quote:

Originally Posted by Tri@de (Post 2340725)

I solved modifying the query in this way:

PHP Code:


		
			
$vbulletin->db->query_write(" UPDATE " . TABLE_PREFIX . "user AS user 

SET artcount = (SELECT COUNT(postusername) AS count 

FROM thread 

WHERE title LIKE 'Articolo:%' 

AND postuserid = user.userid) 

");

that doesnt work for me either, I just have a 0 although I have clearly written loads of articles..

Tri@de

06-18-2012 03:55 PM

It can't work for you if you don't use italian language.
Try replacing

PHP Code:


		
			
'Articolo:%'

with

PHP Code:


		
			
'Artic%'

Tri@de

06-22-2012 07:41 AM

No way. Uninstalled.
It doesn't work properly.

Simon Lloyd

06-22-2012 01:41 PM

What do you mean doesn't work properly?, it should work exactly as described.

Tri@de

06-22-2012 02:39 PM

it count only some articles.
a user has displayed 8 but if i click on the number it displays 10 articles.

Seems that don't count older articles

Tri@de

06-22-2012 03:08 PM

I found this looking in the db: some are called Artilces others "Discussion" as first word...

but i don't know why. the artilce settings are the same.

Simon Lloyd

06-22-2012 05:30 PM

Well some could be unpublished, in moderation or not promoted to article :)

All times are GMT. The time now is 03:08 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01392 seconds Memory Usage 1,837KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (6)bbcode_html_printable (5)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: