Indicating an administrator on the discussions page

kl · March 2009

There is already an indicator on the comments page that lets users know when a comment's author is an administrator. What I would like to do is add this functionality to the discussions page. If you look at where it says "Started By: kl" under the discussion topic, I would like to add a piece of text or an image there that indicates that I am an administrator (assuming I were an administrator on this board). In the comments page this is easily accomplished because the $Comment->AuthRoleID attribute is retrieved as part of the row data. In fact, it's built in to Vanilla. Unfortunately in the discussions page no similar AuthRoleID attribute is retrieved. Looking at the code, and at extensions dealing with similar functionality, it appears this will require adding some SQL to the SQLBuilder. I have not played much yet with the SQL part of Vanilla, so it would take me some time before I could be sure I was writing correct code to do this. Has anyone already done this, or is there an extension that I don't know about that does this? How would you go about adding this feature? Thanks

sirlancelot · March 2009

You're correct in that the GetDiscussionList() method doesn't retrieve the Role IDs of the users. Here is an extension file that will make those available in the Discussion Object so you can then utilize them in the theme files:

<?php
/*
Extension Name: Discussion List Role Style
Extension Url: http://lussumo.com/community/
Description: Adds a class in the discussion list defining the roles of the Original Author and Last Posters. It will take the form of: class="AuthUserRoleID-x LastUserRoleID-x"
Version: 1.0
Author: Matthew Pietz
Author Url: http://lance-systems.com/
*/

if ($Context->SelfUrl == 'index.php') {
$Context->AddToDelegate('DiscussionManager', 'PreGetDiscussionList', 'DLRS_InjectRoleSQL');
function DLRS_InjectRoleSQL(&$Manager) {
$s =& $Manager->DelegateParameters['SqlBuilder'];

// Discussion author Role ID
$s->AddSelect('RoleID', 'u', 'AuthUserRoleID');
// Last poster Role ID
$s->AddSelect('RoleID', 'lu', 'LastUserRoleID');
}

$Context->AddToDelegate('Discussion', 'PostGetPropertiesFromDataSet', 'DLRS_AddToDataSet');
function DLRS_AddToDataSet(&$Discussion) {
$DataSet =& $Discussion->DelegateParameters['DataSet'];

$Discussion->AuthUserRoleID = @$DataSet['AuthUserRoleID'];
$Discussion->LastUserRoleID = @$DataSet['LastUserRoleID'];
}
}

Then, all you need to do in the themes/discussion.php file is add whatever classes you want and select them in your CSS.

kl · March 2009

sirlancelot, I added your extension and everything worked as you said. It's good code. We are testing migrating our forum system (http://www.etsy.com/forums_main.php) to Vanilla and this is helpful to have. kl

sirlancelot · March 2009

Glad it worked for you. A little optimization I would do now that I looked at the code again would be to add an if construct around that entire bit of code like so:

<?php

if ($Context->SelfUrl == 'index.php') {
// [Code goes here]
}

This is to conform to the "useless load" guideline in the documentation: vanilla:extensions. That will ensure that the code will only be executed when it is needed. Be sure to keep the comments at the top as that is how Vanilla determines if the folder is in fact an extension

EDIT: I modified my first comment to reflect this change.

Indicating an administrator on the discussions page

Comments