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

Reply
 
Thread Tools
Social Group Statistics in Categories Listing Details »»
Social Group Statistics in Categories Listing
Version: 1.1.5, by vbboarder vbboarder is offline
Developer Last Online: Apr 2012 Show Printable Version Email this Page

Category: Social Group and Album Enhancements - Version: 3.8.x Rating:
Released: 02-06-2009 Last Update: 09-30-2009 Installs: 35
Uses Plugins Auto-Templates
Additional Files  
No support by the author.

Group Statistics in Categories Listing
This mod adds 10 features to social groups.

The categories listing page is probably the most bland VB page, only showing the category name and # of groups. This mod will make that page much more interesting and visited by adding statistics per category and overall. You can specify how many groups will be shown in each category. This mod is fully phrased. 10 features are added:
  • Show statistics for newest groups (last created).
  • Show statistics for active groups (last updated).
  • Show statistics for popular groups (most members).
  • Show statistics for photogenic groups (most pics).
  • Show statistics for talkative groups (most messages).
  • Show statistics for talkative groups (most discussions).
  • Show group icon next to unread groups. You can also specify to never show, always show, or alternate show the group icon.
  • Group search input field provided for convenient searching.
  • Show the overall group statistics in forumhome at 3 different places.
  • Show the overall group statistics in VBA blocks; links will work for both VBA installed inside and outside forum directory.
Important Notes:
  • The group statistics in VBA blocks will not show statistics for most discussions to allow cleaner presentation in 3-columns layout.
  • 2-3 queries are required for the group statistics (3 if you enable marking unread groups with icons). If you installed version 1.0, the 2 manual edits are no longer required in version 1.1 in order to achieve 2-3 queries total.
  • This mod requires VB 3.8+ and MySql 4.1+.
Installation:
  • Upload the files to their respective folders in your forum directory.
  • Import the product at Manage Products page and allow overwrite.
  • Go to VB Options > Categories? Group Statistics to set your settings.
  • Optional: to display the tag cloud in vbAdvanced, go to VBA CMPS > Download / Upload Modules > in ?Module to Upload?, select ?groupstats_vba.xml? (in the zip file), and click ?Submit?. Then go to VBA CMPS > Default Settings > Main Options > add to ?Portal Output Global Variables?:
Quote:
groupstats
.
Version History:
1.0.0 - Initial Release.
1.0.1 - fixed table prefix bug.
1.1.0 - upgraded mod to not require file edits to reduce queries.
1.1.5 - fixed a minor bug. Added RTL language support.

Notes:
1. I read all posts for this mod so feel free to post any comments or suggestions.
2. You will be notified by e-mail for future updates if you click ?Marked as Installed.? If you find this mod useful, remember to click ?Nominate for MOTM.?

Download Now

File Type: zip groupstatistics.zip (9.2 KB, 94 views)
File Type: zip groupstatistics_1_1_5.zip (9.4 KB, 86 views)

Screenshots

File Type: jpg group_stats.jpg (138.8 KB, 0 views)
File Type: jpg groupstats_home.jpg (128.8 KB, 0 views)

Supporters / CoAuthors

Show Your Support

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

Comments
  #2  
Old 02-07-2009, 07:15 PM
vbboarder's Avatar
vbboarder vbboarder is offline
 
Join Date: Jun 2008
Location: Silicon Valley, CA
Posts: 417
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fixed the TABLE_PREFIX bug in v1.0.0. Reupload all files and reimport the 1.0.1 product xml file with allow overwrite.
Reply With Quote
  #3  
Old 02-08-2009, 06:41 AM
Huy Ho?ng Huy Ho?ng is offline
 
Join Date: Dec 2008
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Import the file groupstats_vba.xml, you place?
Reply With Quote
  #4  
Old 02-08-2009, 04:02 PM
alehawk alehawk is offline
 
Join Date: Apr 2008
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It doesnt work

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'adforop_000032.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 02:56:10 PM
Error Date : Sunday, February 8th 2009 @ 02:56:10 PM
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log

For some reason didnt add the table prefix to the query, it will query from table socialgroup instead of myprefix_socialgroup.

Can that be fixed?
Reply With Quote
  #5  
Old 02-08-2009, 04:42 PM
RvG2 RvG2 is offline
 
Join Date: Jan 2007
Posts: 457
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

very very nice mod!

thanks for sharing
Reply With Quote
  #6  
Old 02-08-2009, 08:58 PM
kleinschwanz kleinschwanz is offline
 
Join Date: Jan 2007
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

However... when I enable this hack it shows me following:

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT groupid, name, visible, discussions, picturecount, members, lastpost, lastupdate, 
dateline AS createtime FROM socialgroup WHERE groupid IN ();

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number  : 1064
It is not the edit, as I haver undone it with the editor... but the failure still showed up. I can only browse index.php when the mod is disabled... I guess this is not what you wanted...
Reply With Quote
  #7  
Old 02-09-2009, 12:10 AM
PakFuse PakFuse is offline
 
Join Date: Jan 2009
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting a very similar error ... except that my MySQL version is 5.0.51a-log

I first installed noedit version and had to uninstall it due to this error.

I then, installed 2edit version and edited the group.php as advised; same error...

I have disabled the MOD but if this can be fixed or pointed out why such an error is occuring, that would be a great help.


Quote:
Originally Posted by alehawk View Post
It doesnt work

Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'adforop_000032.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 02:56:10 PM
Error Date : Sunday, February 8th 2009 @ 02:56:10 PM
Classname : vB_Database
MySQL Version : 5.0.32-Debian_7etch8-log

For some reason didnt add the table prefix to the query, it will query from table socialgroup instead of myprefix_socialgroup.

Can that be fixed?
Reply With Quote
  #8  
Old 02-09-2009, 12:18 AM
kleinschwanz kleinschwanz is offline
 
Join Date: Jan 2007
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I guess it can... if oyu have a new install create at least one group and then enable the product again... it worked for me
Reply With Quote
  #9  
Old 02-09-2009, 12:38 AM
PakFuse PakFuse is offline
 
Join Date: Jan 2009
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

^ tried that, got the following error:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT COUNT(*) AS groups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.visible DESC, club.name) AS CHAR(255)) AS postgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.discussions DESC, club.name) AS CHAR(255)) AS topicgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.picturecount DESC, club.name) AS CHAR(255)) AS picsgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.members DESC, club.name) AS CHAR(255)) AS hotgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.dateline DESC, club.name) AS CHAR(255)) AS newgroups,
CAST(GROUP_CONCAT(club.groupid ORDER BY club.lastupdate DESC, club.name) AS CHAR(255)) AS activegroups
FROM socialgroup AS club WHERE club.groupid IS NOT NULL;

MySQL Error : Table 'pakfuse_vbulletin_011409.socialgroup' doesn't exist
Error Number : 1146
Request Date : Sunday, February 8th 2009 @ 09:38:12 PM
Error Date : Sunday, February 8th 2009 @ 09:38:12 PM
Script : [url of my forum]
Referrer : [URL of the group I created]
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.51a-log
Reply With Quote
  #10  
Old 02-09-2009, 01:42 AM
vbboarder's Avatar
vbboarder vbboarder is offline
 
Join Date: Jun 2008
Location: Silicon Valley, CA
Posts: 417
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry guys about the Sql error. There were 3 queries where I forgot to prefix the name of the table with TABLE_PREFIX. This error does not affect users who don't use table prefixes. I think I caught all the prefix problems now. The zip files were updated.

To Update: For both versions of this mod, reupload all files to your forum directory AND reimport the product xml file with allow overwrite.
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 09:31 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.04891 seconds
  • Memory Usage 2,332KB
  • Queries Executed 25 (?)
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
  • (1)bbcode_code
  • (2)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
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (4)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)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