[mtha]

Display assigned user (if any) in ticket list

In vBSupport.php
search for

PHP Code:

    // start getting the support tickets
    $tickets = $db->query_read("
        SELECT ticket.*
        " . iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
        FROM " . TABLE_PREFIX . "ticket AS ticket
        " . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = ticket.iconid)") . "
        $listtype
        ORDER BY replydateline DESC
        $limitstr
    "); 


by

PHP Code:

    // start getting the support tickets
    $tickets = $db->query_read("
        SELECT ticket.*, user.username AS assignedtechusername
        " . iif($vbulletin->options['privallowicons'], ",icon.title AS icontitle, icon.iconpath") . "
        FROM " . TABLE_PREFIX . "ticket AS ticket
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = ticket.assignedtechid)
        " . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = ticket.iconid)") . "
        $listtype
        ORDER BY replydateline DESC
        $limitstr
    "); 


template edit: support_ticketlistbit

			<span class="smallfont" style="float:$stylevar[right]"><strong>$ticket[status]</span>

replate with

			<span class="smallfont" style="float:$stylevar[right]">
		    	<div align="right"><strong>$ticket[status]</strong>
		    	<br><i><a href="member.php?$session[sessionurl]u=$ticket[assignedtechid]">$ticket[assignedtechusername]</a></i>
				</div>
			</span>

edit template SUPPORTCP
look for

		<td class="thead" width="100%">
		    $vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
		</td>

replace with

		<td class="thead" width="100%">
			<span class="smallfont" style="float:$stylevar[right]">
				$vbphrase[status]/$vbphrase[support_assign_ticket]
			</span>
		    $vbphrase[support_ticket_open_status] / $vbphrase[support_ticket_starter]
		</td>