BEFORE MOD
AFTER MOD
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
WARNING
Always, always backup your files before doing ANY change to your osTicket files and/or database!
BE WARNED
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FIRST STEP
File: /include/clienttickets.inc.php
FIND: ~21
$qwhere =' WHERE email='.db_input($thisclient->getEmail());
REPLACE BY:
// START MOD11 CHG TO VIEW TICKET
$qwhere =' WHERE ticket.email='.db_input($thisclient->getEmail());
// END MOD11 CHG TO VIEW TICKET
FIND: ~47 ~50
$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name,email '.
',dept_name,status,source,priority_id ,ticket.created ';
$qfrom=' FROM '.TICKET_TABLE.' ticket LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
REPLACE BY:
// START MOD11 CHG TO VIEW TICKET
$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name '.
',dept_name,status,source,priority_id,ticket.created,ticket.updated,staff.firstname,staff.lastname';
$qfrom=' FROM ('.TICKET_TABLE.' ticket'.
' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id )'.
' LEFT JOIN '.STAFF_TABLE.' staff ON ticket.staff_id=staff.staff_id';
// END MOD11 CHG TO VIEW TICKET
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
FIND: ~80 ~88
<a href="view.php?status=open"><img src="images/view_open_btn.gif" alt="View Open" border=0></a>
REPLACE BY:
START MOD11 CHG TO OPEN NEW TICKET
<a href="open.php"><img src="images/new_ticket_btn.gif" alt="Create new ticket" border=0></a>
END MOD11 CHG TO OPEN NEW TICKET
<a href="view.php?status=open"><img src="images/view_open_btn.gif" alt="View Open" border=0></a>
FIND: ~89 ~100
<tr>
<th width="70" nowrap>
<a href="view.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket #</a></th>
<th width="100">
<a href="view.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Create Date</a></th>
<th width="60">Status</th>
<th width="240">Subject</th>
<th width="150">
<a href="view.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>
<th width="150">Email</th>
</tr>
REPLACE BY:
START MOD11 CHG TO VIEW TICKET
<tr>
<th width="60" align="Left"><a href="view.php?sort=ID&order=<?=$negorder?><?=$qstr?>" title="Sort By Ticket ID <?=$negorder?>">Ticket #</a></th>
<th width="230" align="Left"><font size="2"> Subject</font></th>
<th width="90" align="Left"><a href="view.php?sort=date&order=<?=$negorder?><?=$qstr?>" title="Sort By Date <?=$negorder?>">Create Date</a></th>
<th width="110" align="Left"><font size="2">Last update</font></th>
<th width="70" align="Left"><font size="2">Status</font></th>
<th width="120" align="Left"><font size="2">Assigned Staff</font></th>
<th width="120" align="Left"><a href="view.php?sort=dept&order=<?=$negorder?><?=$qstr?>" title="Sort By Category <?=$negorder?>">Department</a></th>
</tr>
END MOD11 CHG TO VIEW TICKET
FIND: ~114 ~125
<tr class="<?=$class?> " id="<?=$row?>">
<td align="center" title="<?=$row?>" nowrap>
<a class="Icon <?=strtolower($row)?>Ticket" title="<?=$row?>" href="view.php?id=<?=$row?>">
<?=$ticketID?></a></td>
<td nowrap> <?=Format:($row)?></td>
<td> <?=ucfirst($row)?></td>
<td> <a href="view.php?id=<?=$row?>"><?=$subject?></a>
<?=$row?"<span class='Icon file'> </span>":''?></td>
<td nowrap> <?=Format:($dept,30)?></td>
<td> <?=Format:($row,40)?></td>
</tr>
REPLACE BY:
START MOD11 CHG TO VIEW TICKET
<tr class="<?=$class?> " id="<?=$row?>">
<td align="center" title="<?=$row?>" nowrap>
<a class="Icon <?=strtolower($row)?>Ticket" title="Click for ticket details" href="view.php?id=<?=$row?>"><?=$ticketID?></a></td>
<td> <a href="view.php?id=<?=$row?>" title="Click for ticket details"><?=$subject?></a>
<?=$row?"<span class='Icon file'> </span>":''?></td>
<td> <?=Format:($row)?></td>
<td> <?=Format:($row)?></td>
<td> <?=ucfirst($row)?></td>
<td><?=($row) ? $row : ' ';?> <?=($row) ? $row : '';?></td>
<td> <?=$dept?></td>
</tr>
END MOD11 CHG TO VIEW TICKET
SECOND STEP
Save the attached image to \images\ with the name new_ticket_btn.gif
