Quick 'n' Dirty Search Plugin

[dadaemon]

Quick 'n' Dirty Search Plugin Version 0.0.1 for Multi User 0.5.7 available. (Works with 0.6.1!)

More information here:
http://forum.taskfreak.com/index.php?topic=516.0
Download
See attachment


Version 0.0.1 -- March 26, 2007
---------------------------------
+ Made a plugin from the code xdu has written so it would be easier to implement the search into TaskFreak!
+ Three supported languages. (English, French and Dutch.)

Notes
---------------------------------
As mentioned by the original author

This has NOT been heavily tested, and comes with no warranty of any kind. It is notably a HUGE security breach, as a SQL statement may be freely executed, with no syntax check at all. Don't use outside your LAN!

PS: I don't hope Searcher would mind me taking his plugin posts as base of this topic.

[Searcher]

Splendid!

Searcher doesn't mind at all, just few mininotes..
- why 0.5.7 if it works with 0.6.1
- u didn't change the copied changelog.txt
- it's not really such a security breach because it's using the default taskfreak query syntax so it is being sanitized after all (right, Stan?)

I love your plugin, you should run through the forum and make few more like this

[dadaemon]

Searcher,

- Since plugins aren't officially supported in 0.6.1 (see the download page) and your plugin manager hasn't been written for 0.6.1. (Give us an updated version! )
- ok changed the changelog
- Well. I'll wait for his anwser then remove the warning if needed

I've just changed the search hack into a plugin version. All credits goes to xdu!
But I will look for more handy additions to Taskfreak. Realy love it!

[Searcher]

DaDaemon,

- Blah blah blah, blah blah.. I'm waiting for 0.6.2
-
- Very responsible!

[stan]

Oh Searcher, 0.6.0 wasn't stable, but I think 0.6.1 is OK. ...

[Searcher]

Oh Stan, when I read between your lines I can read '0.6.2 is not coming soon'
Does it mean that you are not done with subtasks yet?

[stan]

Subtasks will be in 1.0
I don't plan to work on 0.x anymore

[Searcher]

Excellent, Searcher's calmed down

[Ralf]

@ dadaemon

nice ... when you want, here is the code for German (./de/freak.php):

Code:

---[find]---
'warning_install' => 'Der Installationsordner existiert noch. Sie sollten ihn aus Sicherheitsgründen löschen'
---[replace]---
'warning_install' => 'Der Installationsordner existiert noch. Sie sollten ihn aus Sicherheitsgründen löschen',
'search' => 'Suche'

Thanks Ralf

[v-kooistra]

dutch translation:

Code:

---[find]---
'warning_install' => 'De installatiemap bestaat nog. Verwijder deze uit veiligheids overwegingen'
---[replace]---
'warning_install' => 'De installatiemap bestaat nog. Verwijder deze uit veiligheids overwegingen',
'search' => 'Zoeken'

why not making this with then Global language array?
allot easier with multilanguage

gr vk

[Searcher]

and what is the include/language/nl/freak.php in your opinion?

[sonvan]

How can you make the search box to search everything instead of only the listed task?

[sonvan]

anyone figure out how to search for the whole database instead of just the listed yet?

[Searcher]

the filters begin on line 39 of index.php

Code:

$arrFilters = array();

and end with

Code:

// --- Task order ---------------------------------------------------------

what you need to do is to move the entire search script above and the rest of the filters enclose into an else { } statement

Code:

// search filter
$pSearch = ($_REQUEST['search']);
if ($pSearch) {
  $sqlFilter = '(ii.title LIKE \'%'.$pSearch.'%\' OR ii.description LIKE \'%'.$pSearch.'%\')';
  $objItemList->addWhere($sqlFilter);
}
else {
  $arrFilters = array();
.
.
.
}
// --- Task order ---------------------------------------------------------

[sonvan]

I tried this but it still didn't work. It would just search for what's being displayed =(