BEFORE MOD

blank

AFTER MOD

blank

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-

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">  Subject</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">Last update</th>

<th width="70" align="Left">Status</th>

<th width="120" align="Left">Assigned Staff</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?" ":''?></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?" ":''?></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