Free The Quick Modifs Thread by Sheep

[Sheep]

Welcome to the QMTS! (Quick Modifs Thread by Sheep)

I've got a list of feature requests from "my" staff team but as my training period is almost over (2 weeks left), i'll do the modifications myself instead of posting a request in the feature request thread (and waiting for kayako to consider it).
I'll share here the modifications (instead of opening many threads).

Feel free to discuss here.

List (updated 23/07/07):

Staff Side:
QMS1 - Order ressources in the staff pannel using the display order
The Quick Modifs Thread by Sheep

QMS2 - Add a quick box when adding a kb article to quick create a link to a DL ressource
The Quick Modifs Thread by Sheep

QMS6 - When Ticket Setting "HTML Conversion" is set to STRIP let some default tag
http://forums.kayako.com/showpost.ph...1&postcount=19


Client Side:
QMS3 - A back button when viewing a download or kb articles
The Quick Modifs Thread by Sheep

QMS4 - Remember the search query
The Quick Modifs Thread by Sheep

QMS5 - IRS should search in title
http://forums.kayako.com/showpost.ph...6&postcount=16

[Sheep]

Feature request:
In the staff panel the ressources categories aren’t ordered using their display orders (but in the client panel they do !).

Modifications:
-- Knowledgebase --
in modules/knowledgebase/functions_knowledgebase.php
replace near line 416

PHP Code:

$dbCore->query("SELECT kbcategories.* FROM `". TABLE_PREFIX ."kbcategories` AS kbcategories LEFT JOIN `". TABLE_PREFIX ."tgroupassigns` AS tgroupassigns ON (kbcategories.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '". TGROUP_KNOWLEDGEBASE ."') WHERE tgroupassigns.tgroupid = '". intval($filtertgroupid) ."' ORDER BY kbcategories.kbcategoryid ASC;"); 


by

PHP Code:

$dbCore->query("SELECT kbcategories.* FROM `". TABLE_PREFIX ."kbcategories` AS kbcategories LEFT JOIN `". TABLE_PREFIX ."tgroupassigns` AS tgroupassigns ON (kbcategories.kbcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '". TGROUP_KNOWLEDGEBASE ."') WHERE tgroupassigns.tgroupid = '". intval($filtertgroupid) ."' ORDER BY displayorder ASC;"); 


replace near line 418

PHP Code:

$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbcategories` ORDER BY `kbcategoryid` ASC;"); 


by

PHP Code:

$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbcategories` ORDER BY displayorder ASC;"); 


-- Downloads --
in modules/downloads/functions_downloads.php
replace (near line 286)

PHP Code:

$dbCore->query("SELECT downloadcategories.* FROM `". TABLE_PREFIX ."downloadcategories` AS downloadcategories LEFT JOIN `". TABLE_PREFIX ."tgroupassigns` AS tgroupassigns ON (downloadcategories.downloadcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '". TGROUP_DOWNLOADS ."') WHERE tgroupassigns.tgroupid = '". intval($filtertgroupid) ."' ORDER BY downloadcategories.downloadcategoryid ASC;"); 


by

PHP Code:

$dbCore->query("SELECT downloadcategories.* FROM `". TABLE_PREFIX ."downloadcategories` AS downloadcategories LEFT JOIN `". TABLE_PREFIX ."tgroupassigns` AS tgroupassigns ON (downloadcategories.downloadcategoryid = tgroupassigns.toassignid AND tgroupassigns.type = '". TGROUP_DOWNLOADS ."') WHERE tgroupassigns.tgroupid = '". intval($filtertgroupid) ."' ORDER BY displayorder ASC;"); 


replace (near line 288)

PHP Code:

$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."downloadcategories` AS downloadcategories". $wheresql ." ORDER BY downloadcategories.downloadcategoryid ASC;"); 


by

PHP Code:

$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."downloadcategories` AS downloadcategories". $wheresql ." ORDER BY displayorder ASC;"); 


-- TroubleShooter --
in modules/troubleshooter/staff_troubleshooter.php
find near line 435

PHP Code:

  // Build all its steps!
  doTSCategoryTreeLoop($val["troubleshootercatid"], $categorydata, 0, $catnodelist[$catnodecount], 0); 


add before

PHP Code:

        function TSDisplayOrderCompare($a, $b) 
        {
            if ($a["displayorder"] == $b["displayorder"]) {
              return 0;
            }
            return ($a["displayorder"] > $b["displayorder"]) ? 1 : -1;
        } 


in modules/troubleshooter/functions_troubleshooter.php
find near line 173

PHP Code:

function doTSCategoryTreeLoop($troubleshootercatid, $data, $parentid, &$nodeclass, $selectedcatid=0) 


a bit after find

PHP Code:

        // We itterate through all the childs
  for ($ii=0; $ii<$childcount; $ii++) 


add before

PHP Code:

$data[$troubleshootercatid][$parentid][$ii]=usort($data[$troubleshootercatid][$parentid],'TSDisplayOrderCompare'); 


[Sheep]

Here comes a nice one:

Feature request:
Staff pannel, creating/editing a kb article: I'd like to have a quick box like in the new ticket, that allows me to quick create a link to a download file

Animation:
See results here:
http://www.sheep.fr/EONA/Kayako-Supp...y/QMS/QMS2.htm

NOTE: USE THE FOLLOWING MOD INSTEAD (link - matthew's improvment)
The Quick Modifs Thread by Sheep

Modifications:
in modules/knowledgebase/functions_knowledgebase.php
find near line 918

PHP Code:

printhtmlAreaRow("contents", $_SWIFT["language"]["contents"], $_POST["contents"]); 


addbefore

PHP Code:

       echo '<script type="text/javascript">
    selectedTab = "kbedit";
    </script>'; 
        echo '<tr class="'. getRowBG() .'">
    <td width="100" align="left" id="fmenuref"><span class="tabletitle">QuickLink to:</span></td>
    <td align="left"><a href="#" title="Downloads" id="fdlcachelink" onClick="javascript:CustomPopupRef(\'dlcachemenu\', event, \'fdlcachelink\', \'dlcachemenu\', \'fmenuref\', dlmenuloaded);this.blur();" onMouseUp="javascript:this.blur();"><img src="'. $_SWIFT["themepath"] .'icon_quickinsert.gif" border="0" align="absmiddle" />&nbsp;Downloads&nbsp;<img src="'. $_SWIFT["themepath"] .'menudrop.gif" border="0" align="absmiddle" /></a>&nbsp;&nbsp;&nbsp;</td>
    </tr>'; 


in themes/admin_default/main.js

find near line 1347

PHP Code:

} else if (link != "") { 


add before

PHP Code:

 } else if (formname=="swiftform") {
 
        editor.setHTML(editor.getHTML()+'<img src="http://yourdomain.com/themes/client_default/mimeico_blank.gif" border="0" /><a href="http://yourdomain.com/index.php?_m=downloads&_a=viewdownload&downloaditemid='+downloaditemid+'&nav=0">'+title+'</a>'); 


find near line 1424(in function getActiveFormName())

PHP Code:

  } else {
  formname = "replyform";
 } 


add before

PHP Code:

 } else if (selectedTab == "kbedit") {
        formname = "swiftform"; 


[caitlyntw]

Wow. A lot of people have been begging for this feature. Kayako should hire you.

[craigbrass]

Kayako should hire you.

Yea, they should. You certainly know your way around Kayako's software...

[Sheep]

I don't want to be a programmer I'm good at it, but i don't want it to be my main job. I'm doing my studies on project management, business information, workflow etc... On such projects, there are part where you have to get your hand in codes, but that's not the main job.
(And i still have 1 year to study anyway )

On this project (Support reorganization, 3 months), some specifications couldn't be reached with the plateforms that got set up so that's why i'm using a 1 month extension to code the missing parts (as set in the specifications that we analysed in the company were i'm doing my training period), the main missing part was SERM, now i'm doing some custom requests

The idea of giving the new features freely to the community wasn't easy to introduce in the company used to old school habits. That's where the new open source philosophy comes in. The fact that i'm going to leave my company makes that they'll lose most of the knowledge that got used on this project. So as EONA (the company) activity isn't to sell kayako mods, and they doesn't have time to do so, and even if the modifications costed them money (my salary), there's no impact on their activity if they share it. Better than that, if the mods get includeds as kayako features, or if anyone is maintaining it, that'll be better for EONA on further updates of the platform.
That's the situation

Anyway thanks a lot for your support

[Sheep]

Client side this time:

Feature request:
Client side: A back button when browsing a download or kb article

Modifications:
For the knowledgebase:
in modules/knowledgebase/client_knowledgebase.php
find near line 191

PHP Code:

echo $template->displayTemplate("kbarticleview"); 


add before:

PHP Code:

    $_nav=explode(',',$_nav);
    $parent=intval(end($_nav));
    array_pop($_nav);
    $_nav=implode(',',$_nav);
    $template->assign("backurl", iif(defined("ISMODERNBILL"), "user.php?op=menu&tile=faq&_m=knowledgebase&_a=view&parentcategoryid=".parent."&nav=".$_nav, "index.php?_m=knowledgebase&_a=view&parentcategoryid=".$parent."&nav=".$_nav)); 


For the downloads
in modules/downloads/client_downloads.php
find near line 191

PHP Code:

echo $template->displayTemplate("dlviewdownload"); 


add before:

PHP Code:

    $_nav=explode(',',$_nav);
    $parent=intval(end($_nav));
    array_pop($_nav);
    $_nav=implode(',',$_nav);
    
    $template->assign("backurl", "index.php?_m=downloads&_a=view&parentcategoryid=".$parent."&nav=".$_nav); 


[Sheep]

Client side again:

Feature request:
Client side: remember the search query

Modifications:
in modules/core/client_search.php
find near line 191

PHP Code:

echo $template->displayTemplate("searchresultdisplay"); 


add before

PHP Code:

$template->assign("searchquery",$_POST['searchquery']); 


go to the admin pannel:
edit the template general > navbar
find

PHP Code:

<td width="79%"><input name="searchquery" type="text" class="searchtext"></td> 


replace by

PHP Code:

<td width="79%"><input name="searchquery" type="text" class="searchtext" value="<{$searchquery}>"></td> 


[Siora]

Great work Antoine. However, would it be possible to include a little bit more of a description as to what these mods do and/or fix?

[Sheep]

Ah? wich one is confusing you?
These aren't fix but improvments

[Siora]

1, 2, 4 - LOL. I guess I'm confused cause I don't know or can't visualize what you are improving and how it is improving it.

[Sheep]

1) Create 3 categories (in downloads for exemple) named (in order) c1, c3, c2
they have the display order 1,2,3 (but you see, c3 has 2 and c2 has 3)
lets change their display order to 1,3,2
If you visualise the categories list, they'ill stay like c1,c3,c2 because the display order isn't used...
That what the patch changes.

2) There's a video

4) When you use the search box on the right, you get the result. If you want to just add one more keyword to filter your search, yo have to type the query again. With the patch the search box has your last query (while you're not changing page)

[Siora]

Excellent...thanks Antoine, that makes sense. BTW, I saw the video and it did make things a little clear but I guess until I apply the improvement and try it myself I may not fully understand it. Just waiting for the stable build to come out so I can start applying so many of the mods that you put out.

[Sheep]

For 2) Does one of your kB article says: please download this, you'll find it there in the download section.
The mod helps you to create a direct link to the download

[Siora]

Originally Posted by Sheep

For 2) Does one of your kB article says: please download this, you'll find it there in the download section.
The mod helps you to create a direct link to the download

It does not hence the fact that I didn't quite understand it...but this will definately help me when I start adding downloads.