File manager - Edit - /home/autoph/public_html/tasks/queries.tar
Back
read_ticket_reply_attachments.sql 0000644 00000001235 15024754701 0013357 0 ustar 00 SELECT tra.id,tra.ticket_reply_id,tra.attachment_name,tra.original_name FROM ticket_replies tr LEFT OUTER JOIN tickets t ON tr.ticket_id = t.id LEFT OUTER JOIN users u ON tr.user_id = u.id LEFT OUTER JOIN ticket_status ts ON tr.ticket_status_id = ts.id LEFT OUTER JOIN ticket_reply_attachments tra ON tr.id = tra.ticket_reply_id WHERE 1 AND tra.ticket_reply_id = 73 AND tr.status = 1 AND tra.status = 1 ORDER BY tra.original_name ASC index.php 0000644 00000000000 15024754701 0006357 0 ustar 00 read_ticket_replies.sql 0000644 00000001411 15024754701 0011270 0 ustar 00 SELECT tr.id,tr.ticket_id,t.user_id as owner_id,u.id as from_user,u.firstname,u.lastname,tr.description,ts.name as ticket_status, IF(DATE_FORMAT(tr.date_added,'%Y') = DATE_FORMAT(NOW(),'%Y') , DATE_FORMAT(tr.date_added,'%b. %d - %h:%i%p'),DATE_FORMAT(tr.date_added,'%b %d, %Y %h:%i%p')) as date_addedf FROM ticket_replies tr LEFT OUTER JOIN tickets t ON tr.ticket_id = t.id LEFT OUTER JOIN users u ON tr.user_id = u.id LEFT OUTER JOIN ticket_status ts ON tr.ticket_status_id = ts.id WHERE 1 AND tr.ticket_id = 86 AND tr.status = 1 ORDER BY tr.date_added DESC
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings