 |
5. July 2006, 14:36Jerome’s Keyword Manager – Final Destination |
80 |
Finally – This should be it. After reports of bugs nearly to big for such a small plugin i’ve rewritten the original sql clause with a little bit better one. Now we should have Jerome’s Keywords Manager – Final Destination.
Download the (i hope) final version:
 |
jeromes-keywords-manager-v4.zip Internal name: final destination |
For the more technical fraction of my growing fan-community:
The original sql clause to retrieve posts with an specific assigned keyword was formulated to generally and reported to many results. A basic "attribute LIKE %keyword%" wasn’t correct in this case.
Sample:
Chip showed me this example: We have lot’s of posts tagged with the keyword "c" (programming language). After selecting the keyword in the Jerome’s Keywords Manager overview page, all posts having assigned keywords with the letter "c" would be shown on the edit page (like "cocaine", "furuncle", "canalisation", "canabalismn" and so on). urg.
Solution:
Since jerome decided to save assigned keywords as a comma-seperated list (straight without spaces in between) the SQL-Clause was redefined easely:
attribute LIKE ‘keyword,%’ OR
attribute LIKE ‘%,keyword’ OR
attribute LIKE ‘%,keyword,%’ OR
attribute = ‘keyword’
This should catch all cases.
erreichen.
Pingback by Jerome’s Keywords Manager « johannes.jarolim.com
[...] Version 4 of the plugin (Developement name: Final destination) – more info [...]
Comment by Sterling Camden
Johannes, I got some sort of PHP error with the new plugin. It just produces a blank page (dies after the dashboard menus) in Manage/Jerome’s Keywords. I’ll try to better identify the failure.
Comment by Sterling Camden
Here it is: ‘WHERE meta_key=\’keywords\’ AND (" Mismatched quotes (caught by SlickEdit syntax highlighting)
Pingback by Jerome’s Keyword Manager ver.4 « :: plasticdreams ::
[...] via Jerome’s Keyword Manager – Final Destination [...]
Pingback by Correction for Jerome’s Keywords plugin for WordPress -- Chip’s Tips for Developers
[...] I mentioned this problem to Johannes Jarolim, author of the Jerome’s Keywords Manager plugin. Johannes came up with the correct LIKE clause (value LIKE ‘keyword,%’ OR value LIKE ‘%,keyword’ OR value LIKE ‘%,keyword,%’ OR value = ‘keyword’) and implemented that in his plugin. But alas, that did not help my widget, which relies on the ?tag=keyword link operation provided by Jerome. [...]
Pingback by Tag — you’re it, Jerome! -- Chip’s Quips
[...] This morning I corrected the Jerome’s Keywords plugin for WordPress to eliminate the problem with too inclusive tag searches, and I posted it on Chip’s Tips (I’ll take down my version and point to Jerome’s if/when Jerome implements a fix also). Thanks to Johannes for the SQL syntax. BTW, Johannes has a new version of his Jerome’s Keywords Manager plugin (the final destination — where have I heard that before?) that implements a similar fix for his dashboard component. [...]
Pingback by Magic quotes correction for Jerome’s Keywords WordPress plugin -- Chip’s Tips for Developers
[...] You can download the corrected version below. If Jerome would like to adopt this fix in his master version, I’ll take down my copy and point to him instead. Johannes, you might want to implement a similar test in your Jerome’s Keywords Manager plugin. Sorry to give you one more place to go after your “final destination”. Share and Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages. [...]
Pingback by Jeroaming versions -- Chip’s Quips
[...] That makes at least three people besides Jerome who have contributed to the functionality of this plugin, resulting in three different versions of the plugin itself, an add-on plugin, and a widget. What do you say, Jerome, can we get all these pieces packaged together before they get further split apart? Can we set up some sort of collaborative development project to help you to keep up? [...]
Trackback by e-Learning Blog
Verwendete PlugIns…
Nachdem ich nun ebenfalls schon einige Plugins einsetze, ist es an der Zeit sie einmal für alle Interessierten aufzulisten:
Adhesive: Damit kann die Reihenfolge der Beiträge geringfügig beeinflusst werden.
WP-Email: Möglichkeit Beiträge per eMail…
Pingback by Jerome’s presenting keywords BETA 2 « johannes.jarolim.com
[...] Hah – finally jerome’s presenting his tagging plugin in second version. I downloaded the plugin and installed it like jerome wanted to. Oddly it doesn’t create a database on activation so i’ve to stick with his 1.9 version and my puny keywords-manager addition. [...]
Comment by Jan
Ich habe Wordpress 2.0.5, Jerome’ Keywords 1.9 und den Manager 4. Beim Klick auf Verwalten -> Jerome’s Keywords gibt es nur eine leere Seite. Testkeywords sind vorhanden. Ich stehe vor einem Brezel… Bin für jede Tipp dankbar. Die Dateien habe ich alle wie beschrieben eingespielt. Mh.