Colors For Usergroup In Forum Display
Shows colors for usergroups in forum
1.0.1
hide_errors();
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD lastposter_displaygroupid smallint(5)");
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."forum, ".TABLE_PREFIX."user SET ".TABLE_PREFIX."forum.lastposter_displaygroupid=".TABLE_PREFIX."user.displaygroupid WHERE ".TABLE_PREFIX."user.displaygroupid<>0 and ".TABLE_PREFIX."forum.lastposter=".TABLE_PREFIX."user.username");
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."forum, ".TABLE_PREFIX."user SET ".TABLE_PREFIX."forum.lastposter_displaygroupid=".TABLE_PREFIX."user.usergroupid WHERE ".TABLE_PREFIX."user.displaygroupid=0 and ".TABLE_PREFIX."forum.lastposter=".TABLE_PREFIX."user.username");
$db->show_errors();
build_forum_permissions();
]]>
hide_errors();
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum DROP lastposter_displaygroupid");
$db->show_errors();
]]>
usergroupcache["$lastpostinfo[lastposter_displaygroupid]"]['opentag'] . $lastpostinfo['lastposter'] . $vbulletin->usergroupcache["$lastpostinfo[lastposter_displaygroupid]"]['closetag']">
]]>
Forum pre save
forumdata_presave
setfields['lastposter']) {
if (!$this->validfields['lastposter_displaygroupid']) {
$this->validfields['lastposter_displaygroupid'] = array(TYPE_UINT, REQ_NO);
}
$lastposter = $this->fetch_field('lastposter');
$displaygroupid = $this->dbobject->query_first("SELECT displaygroupid, usergroupid FROM " . TABLE_PREFIX . "user where username='".$this->dbobject->escape_string($lastposter)."'");
$display = $displaygroupid['displaygroupid'];
if ($display == "0") {
$display = $displaygroupid['usergroupid'];
}
$this->set('lastposter_displaygroupid', $display);
}
]]>
Update cache
cache_ordered_forums
Cache Tag Templates
cache_templates
Colors For Usergroup In Forum Display
parse_templates
templatecache['forumhome_lastpostby'] = $vbulletin->templatecache['colorsforusergroupinforumdisplay'] . $vbulletin->templatecache['forumhome_lastpostby'];
]]>