Go Back   vb.org Archive > vBulletin Modifications > vBulletin 4.x Modifications > vBulletin 4.x Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Display Number (count) of Articles Posted by user in postbit Details »»
Display Number (count) of Articles Posted by user in postbit
Version: 1.0.2, by Simon Lloyd Simon Lloyd is offline
Developer Last Online: May 2023 Show Printable Version Email this Page

Category: Mini Mods - Version: 4.x.x Rating:
Released: 12-06-2011 Last Update: 12-07-2011 Installs: 29
DB Changes Uses Plugins
 
No support by the author.

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

Download Now

File Type: xml product-articlecount.xml (3.0 KB, 130 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #32  
Old 06-18-2012, 01:00 PM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #33  
Old 06-18-2012, 01:45 PM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #34  
Old 06-18-2012, 02:14 PM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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) 
"
); 
Reply With Quote
  #35  
Old 06-18-2012, 02:52 PM
deverill2010 deverill2010 is offline
 
Join Date: Jan 2011
Posts: 412
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tri@de View Post
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..
Reply With Quote
  #36  
Old 06-18-2012, 03:55 PM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It can't work for you if you don't use italian language.
Try replacing
PHP Code:
'Articolo:%' 
with
PHP Code:
'Artic%' 
Reply With Quote
  #37  
Old 06-22-2012, 07:41 AM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No way. Uninstalled.
It doesn't work properly.
Reply With Quote
  #38  
Old 06-22-2012, 01:41 PM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What do you mean doesn't work properly?, it should work exactly as described.
Reply With Quote
  #39  
Old 06-22-2012, 02:39 PM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #40  
Old 06-22-2012, 03:08 PM
Tri@de's Avatar
Tri@de Tri@de is offline
 
Join Date: Sep 2003
Posts: 168
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #41  
Old 06-22-2012, 05:30 PM
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Location: Manchester
Posts: 3,481
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well some could be unpublished, in moderation or not promoted to article
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:56 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05276 seconds
  • Memory Usage 2,338KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (5)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete