Social Group and Album Enhancements - View all your social group messages

A page to display all the messages in all the groups a user has joined.

I have found on my forums, that it is hard to keep up with new messages in your social groups. You have to go to each individual group and see if there is anything new. So, I created this page to list all the messages in your social groups in date descending order.

[s]You will need to create two new templates and upload one file.[/s] edit: The two templates and the phrases for this modification are now included in a product.

The users may either view All My Groups and see the messages from all their groups in the list, or they may select one of the groups they belong to and see just the messages in that group. I used the option vboptions > Message Searching Options > Maximum Search Results to Return to set maximum results shown.

Version History:
1.0 2009-02-12:
- initial release by Lynne at vbulletin.org

1.2 2009-03-12:
- fully phrased, templates now in product to import.
- added option to view only messages from single group
- used vboptions > Message Searching Options > Maximum Search Results to Return to set maximum results shown
- cached all bbcode templates
- AFTER INSTALL OF PRODUCT, YOU WILL HAVE TO REVERT THE TWO TEMPLATES (socialgroups_messagelist and socialgroups_messagelistbits) IF YOU HAD INSTALLED THIS PREVIOUSLY (or else you will still be using the original templates)


Please mark INSTALL if you find this useful.

[Xencored]

Thansk Lynne all working now

[unfv]

Hi Lynne, it would be great to have this as a widget for VB CMS

[MrRem]

Installed. Thanks

[bjhuang]

to reduce queries:

PHP Code:

        if (!$message['discussiontitle']&&!$discussiontitlecache[$message['discussionid']]) 
        {
            $title = $vbulletin->db->query_first("
                SELECT groupmessage.title as discussiontitle
                FROM " . TABLE_PREFIX . "groupmessage as groupmessage
                JOIN " . TABLE_PREFIX . "discussion AS discussion 
                    ON (discussion.firstpostid = groupmessage.gmid)
                WHERE groupmessage.discussionid = " . $message['discussionid'] ."
                LIMIT 1
            ");
            $message['discussiontitle']=$title['discussiontitle'];
            $discussiontitlecache[$message['discussionid']] = $title['discussiontitle'];
        }
        else $message['discussiontitle']=$discussiontitlecache[$message['discussionid']]; 


Originally Posted by Lynne

Add? Since it's a totally new page, you don't get added queries to the page. But, it currently has the potential of one small query per message to get the Discussion Name. If you don't want the Discussion name listed, you may comment out the following code in messagelist.php:

PHP Code:

        if (!$message['discussiontitle'])
        {
        $title = $vbulletin->db->query_first("
            SELECT groupmessage.title as discussiontitle
            FROM " . TABLE_PREFIX . "groupmessage as groupmessage
            JOIN " . TABLE_PREFIX . "discussion AS discussion 
        ON (discussion.firstpostid = groupmessage.gmid)
            WHERE groupmessage.discussionid = " . $message['discussionid'] ."
            LIMIT 1
            ");
            $message['discussiontitle']=$title['discussiontitle'];
        } 


And then take out these lines in 'socialgroups_messagelistbits':

                <div>
                    <span><phrase 1="group.php?$session[sessionurl]gmid=$message[gmid]#gmessage$message[gmid]" 2="$message[discussiontitle]">$vbphrase[discussion_x]</phrase></span>
                </div>

[sross]

Hi, I could really use this for vbull 4.x any plans to port it? Thanks!

[Lynne]

Originally Posted by sross

Hi, I could really use this for vbull 4.x any plans to port it? Thanks!

No, not until I actually have my live site moved over to 4.x and I am able to test it before releasing it..