Miscellaneous Hacks - Module CMPS: Latest and Random Public Social Groups

Adds a Module which shows the last 5 public Social Groups Created

Added a module which randomly displays Groups.
Use latestsocialgroups to display the most recently created or use randomsocialgroups to display 5 random groups.
See screenshot for details

Dependencies:
VbA CMPS


How to install

Admincp => vBa CMPS => Download / Upload Module
Click [Browse]
Browse for the file "latestsocialgroups.module" or randomsocialgroups.module
2-26-2008 - Added XML files as an alternative to install.
Submit
Select pages and locations

To restrict to a specific category find in your modules folder either vba_groups.php for latest or vba_randgroups.php for random:

FROM " . TABLE_PREFIX . "socialgroup WHERE type = 'public'

and replace with:

FROM " . TABLE_PREFIX . "socialgroup WHERE type = 'public' AND socialgroupcategoryid = '2'

Where socilagroupcategoryid is the category id of the category you wish to show.

Tested on Vb 3.8.3
VbAdvanced CMPS v3.2

Please Click Installed if you use this.

[acegames]

First install , thankyou

[goblues]

You are welcome!

[Networknutz]

installed works great!

[goblues]

I added to the first post a Random Module in addition to the Latest Module. Enjoy!

[abroad]

Installed it and the modules are shown on my portal BUT

it doesnt show any group. Only if I click on "Show all GRoups"

What is wrong?

[goblues]

These modules only pull "Public" groups. If the only groups you have created are invite only, they will not show.

EDIT: Now that I said above I got to looking at the code and realized that statement wasn't true. Updated the Zips to make it true.

[abroad]

My groups are public...

[goblues]

Redownload the module and allow overwrite and see if that helps. If it does not, PM your site with login details and I will have a look if you want.

[abroad]

overwrote it and now it works well! Thanks!