![]() |
|
Mod Options |
![]() |
|||||||||||
Social Group Statistics in Categories Listing
![]() Developer Last Online: Apr 2012 ![]() ![]() ![]()
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:
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 Only licensed members can download files, Click Here for more information. Supporters / CoAuthors Screenshots Show Your Support
No members have liked this post.
|
Comments |
#2
|
||||
|
||||
Fixed the TABLE_PREFIX bug in v1.0.0. Reupload all files and reimport the 1.0.1 product xml file with allow overwrite.
__________________
My Mods: Social Group Statistics in Categories Listing ![]() Navbar Search Fields + Notices + ShareThis -- Custom Tag Clouds for Forums, VBA, Social Groups No members have liked this post.
Last edited by vbboarder; 09 Feb 2009 at 03:09. |
#3
|
||||
|
||||
Import the file groupstats_vba.xml, you place?
No members have liked this post.
|
#4
|
|||
|
|||
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? No members have liked this post.
|
#5
|
||||
|
||||
very very nice mod!
![]() thanks for sharing No members have liked this post.
|
#6
|
||||
|
||||
It doesn't work...
However... when I enable this hack it shows me following:
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... No members have liked this post.
Last edited by kleinschwanz; 08 Feb 2009 at 22:06. |
#7
|
|||
|
|||
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.
Originally Posted by alehawk
![]()
No members have liked this post.
|
#8
|
|||
|
|||
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
No members have liked this post.
|
#9
|
|||
|
|||
^ 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 No members have liked this post.
|
#10
|
||||
|
||||
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.
__________________
My Mods: Social Group Statistics in Categories Listing ![]() Navbar Search Fields + Notices + ShareThis -- Custom Tag Clouds for Forums, VBA, Social Groups No members have liked this post.
Last edited by vbboarder; 09 Feb 2009 at 02:48. |
#11
|
||||
|
||||
Has successfully installed. Very good
No members have liked this post.
|
#12
|
||||
|
||||
__________________
My Mods: Social Group Statistics in Categories Listing ![]() Navbar Search Fields + Notices + ShareThis -- Custom Tag Clouds for Forums, VBA, Social Groups No members have liked this post.
|
#14
|
||||
|
||||
I then upgraded that version is still 1.0.0? (selected override mode)
No members have liked this post.
|
#15
|
||||
|
||||
The version number in the xml file was not updated - it will not affect the functionality of the mod or VB. If you want to update it, simply go to Manage Products > Categories' Group Statistics > and update the version # to 1.0.1
__________________
My Mods: Social Group Statistics in Categories Listing ![]() Navbar Search Fields + Notices + ShareThis -- Custom Tag Clouds for Forums, VBA, Social Groups No members have liked this post.
|
![]() |
«
Previous Mod
|
Next Mod
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Mod Options | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 21:20.