-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
WARNING
Always, always backup your files before doing ANY change to your osTicket files and/or database!
BE WARNED
IF YOU HAVE ERRORS PLEASE OPEN ANOTHER TOPIC, LET THIS TOPIC CLEAN
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FIRST STEP
File: include\class.ticket.php
FIND: ~925
/*============== Functions below do not require an instance of the class to be used. To call it use Ticket:(params); ==================*/
REPLACE BY:
// START MOD19 Add tooltip thumbnail in Open Tickets view
function getScreenshot($tktid,$type){
global $cfg;
$helpdesk_url=$cfg->getUrl();
$dir=$cfg->getUploadDir();
$dir = preg_replace("/\\\\/","/",$dir);
$dir = explode('/', $dir);
$arrDir = array_reverse($dir);
$dir = $arrDir;
$sql ='SELECT attach_id,file_size,file_name,file_key FROM '.TICKET_ATTACHMENT_TABLE.
' WHERE deleted=0 AND ticket_id='.db_input($tktid).' AND ref_type='.db_input($type);
$res=db_query($sql);
if($res && db_num_rows($res)){
while(list($id,$size,$name,$key)=db_fetch_row($res)){
$hash=MD5($this->getId()*$refid.session_id());
$size=Format:($size);
$ext = strtolower(substr(strrchr($name, '.'), 1));
$fullfilename = $helpdesk_url.$dir.'/'.$key.'_'.$name;
if (in_array($ext,array('jpg', 'png', 'gif', 'bmp'))) {
$attachstr.= '<a href="tickets.php?id='.db_input($tktid).'" class="screenshot" rel="'.$fullfilename.'"><IMG alt="blank" src="./images/icons/file.gif"></IMG></a>';
} else {
$attachstr.= "<span class='Icon file'> </span>";
}
}
}
return ($attachstr);
}
// END MOD19
/*============== Functions below do not require an instance of the class to be used. To call it use Ticket:(params); ==================*/
SECOND STEP
File: include\staff\header.inc.php
FIND: ~14
<script type="text/javascript" src="js/bsn.AutoSuggest_2.1.3.js" charset="utf-8"></script>
REPLACE BY:
START MOD19 Add tooltip thumbnail in Open Tickets view
<script type="text/javascript" src="js/jQuery/jquery.js"></script>
<script type="text/javascript" src="js/jQuery/tooltip.js"></script>
<style>
/* */
#screenshot{
position;
border solid #ccc;
background:#333;
padding;
display;
color:#fff;
}
/* */
</style>
END MOD19
<script type="text/javascript" src="js/bsn.AutoSuggest_2.1.3.js" charset="utf-8"></script>
THIRD STEP
File: include\staff\tickets.inc.php
FIND: ~415
<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>
href="tickets.php?id=<?=$row?>"><?=$subject?></a>
<?=$row?"<span class='Icon file'> </span>":''?></td>
<td nowrap><?=Format:($row,30)?></td>
REPLACE BY:
<td><a <?if($flag) { ?> class="Icon <?=$flag?>Ticket" title="<?=ucfirst($flag)?> Ticket" <?}?>
href="tickets.php?id=<?=$row?>"><?=$subject?></a>
START MOD19 Add tooltip thumbnail in Open Tickets view
<?
if ($row) {
$ticket= new Ticket($row);
print $ticket->getScreenshot($row,'M');
}
?>
</td>
END MOD19
<td nowrap><?=Format:($row,30)?></td>
FOURTH STEP
Create a folder named jQuery in path scp\js. (path now should be scp\js\jQuery)
Unzip jquery.zip and copy the attached files jquery.js and tooltip.js to newly created folder (scp\js\jQuery)
And thats it.
IF YOU HAVE ERRORS PLEASE OPEN ANOTHER TOPIC, LET THIS TOPIC CLEAN
[jquery.zip](https://forum.osticket.com/assets/files/migrated/d/5a26105f889c3090217957d2f42af18.zip)
