Hi Johan, I am attaching the missing files to this message. You'll also find "sorttable-RT.js", which we implemented after I wrote the article: with this you can sort the results table by clicking on the field names in the table header (like other tables in RT). It still lacks feedback when you hover the table headers, but it works very well otherwise.
To enable table sorting you have to modify sphinx.php and insert the following code in the <head> section (obviosuly you'll have to adapt the path): <script src='JavaScript/sorttable-RT.js' type='text/javascript'></script> Before doing this, please reget the sphinx.php script from the wiki because I'm going to add a few lines of necessary code there. Hope this helps! Bye Cristiano Da: Johan Sjöberg [mailto:johan.sjob...@deltamanagement.se] Inviato: Tuesday, January 11, 2011 10:39 AM A: Guadagnino Cristiano; rt-users@lists.bestpractical.com Oggetto: RE: Sphinx full-text search engine in RT Hi. Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems. In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere? Best Regards, Johan From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Guadagnino Cristiano Sent: den 13 september 2010 15:22 To: rt-users@lists.bestpractical.com Subject: [rt-users] Sphinx full-text search engine in RT Hi all, I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT. It is simply great: full-text searches on the whole RT db in just fractions of a second! I am slowly documenting the whole thing on the RT wiki. You can find it by looking for "IntegratingSphinx". It is not yet complete though. I hope it will be useful to somebody else. Bye Cris
This attachment was removed by Edge3 Transport Agent