[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>