howto generate a fulltext search?

[moogli]

Script URL:
Version of script:
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:
Hesk is an excellent programme.
Congratulations!!!
The installation and configuration is very easy.

But I have following problem: in the Admin range if I liked to generate a fulltext search with the input field "subject".
How I must define the search in the file admin / find_tickets.php to generate a search about following fields:
*tickets.subject
*tickets.message
*replies.message
*notes.message

greetings
moogli

[Klemen]

Sorry, this kind of editing is out of the scope of my support.

[moogli]

To generate a fulltext search, I have modified the file
./admin/find_tickets.php:

Near line 90:
old:

case 'subject':
$extra = hesk_input($_GET['subject'],$hesklang['enter_subject']);
$sql .= "`subject` LIKE '%$extra%' ";

new:

case 'subject':
$sql = "SELECT *
FROM hesk_tickets
LEFT JOIN hesk_replies ON hesk_tickets.id = hesk_replies.replyto
WHERE hesk_tickets.subject LIKE '%$extra%'
OR hesk_tickets.message LIKE '%$extra%'
OR hesk_replies.message LIKE '%$extra%'";

Not nice, but it works



Greetings from Old Germany!