Portal Software - Ap - Groups

Ap - Groups

I didnt like view default vbulletin groups page and i decided make this plugin...

Mark as Installed - Nominate for MOTM

Install

Please read the readme.txt file.

Ap - Groups

Go to your admin cp, then:
vBulletin Options -> Ap - Groups ->

Modifications Info

Plugin : 5
Template : 3
Setting : 3

Versions:
v1.0 - 18 June 2008
- First release

v1.1 - 18 June 2008
- Some template bugs fixed
- Phrase bug fixed
- Added "Groups Description Cut"

v1.5 - 20 June 2008
- Some template bugs fixed
- Phrase bug fixed
- Changed "Groups Description Cut" with "Groups Comments Cut"
- Added "Active Groups Name Cut"
- Added "Popuplar Groups Name Cut"
- Added "Latest Post - Groups Name Cut"
- Some php codes changed
- Style 1 Deleted, Style 2 Actived

DEMO: http://www.aktifpaylasim.com/gruplar

[transparent]

Originally Posted by sross

Warning, this can cause mass carnage on a large site it shows info from private groups in the latest post block, no fix yet, guess I'll uninstall it..

Originally Posted by Zacarias

The latest posts show posts from boards that a user is not a member of, even when the group's messages and content are set to private.

Originally Posted by sross

Yes, very dangerous! Can someone supply a fix for this asap? Thanks! -and great mod btw!

This is a great hack but I can't see how any w/ private groups can use it without this bug being fixed first. I have it disabled for now.

Is this being worked on????

[desibw]

installed ...thanks man ...its realy good

[Baldilocks]

I have the "Latest Posts and Most Active" blocks disabled anyway. Since I use the Social Group Forums, those two blocks don't pull the correct information anyway....

If you set them to 0, they won't display.

[Animecraving]

For the next version if you can make it have favorite group. where people can add a group as their favorite

[Chadi]

I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

[jacki]

very nice thanx kaptanblack

[Ideal Web Tech]

Originally Posted by chadi

I'm getting this error:


Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT g.dateline AS sonmesajtarih, g.gmid, s.description, g.pagetext, g.postuserid, g.postusername, s.groupid, s.dateline, s.name, s.lastposter, s.lastposterid, g.state, s.visible, s.lastgmid, s.lastpost, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM groupmessage AS g
LEFT JOIN socialgroup AS s ON (g.gmid = s.lastgmid)
LEFT JOIN user AS user ON(user.username = g.postusername)
WHERE g.state = 'visible' AND s.visible > '0'
ORDER BY g.dateline DESC
LIMIT 0, 10;

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Sunday, July 6th 2008 @ 02:08:35 PM
Error Date : Sunday, July 6th 2008 @ 02:08:35 PM
Script : http://www.talkjesus.com/group.php
Referrer : http://www.talkjesus.com/
IP Address : *****
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.51a-community

Check and make sure that all your db's tables are set to the same collation type as from the error thats telling me that your tables for vbulletin are not all of the same collation type.

You can check this using phpmyadmin. (I dont remember how off the top of my head, If I get time later to look it up I will let you know the steps)

[Chadi]

I don't see why I should have to do that. I have never encountered this issue before and I have nearly 70 mods installed too.

[Justin Murad]

Thanks, nice plugin.

[zmmmzz]

nice!