Projekte
New Tag Cloud v0.7 released
Von FunnyDingo | 10. November 2009, 23:22
Wow, it’s a very long time ago I released the last update. But now New Tag Cloud has some new features!
Filtering
No you are able to filter for tags used in defined categories and skip tags. It’s very nice because you can say: Only display tags used in categories a, b and c but not the tags home, baby and car. I hope you like it!
Caching
That’s done too. I’ve implemented a caching feature. For the first time the cloud is generated normal but after generating, the complete HTML code will be written to the database and for every next time the cloud has to been shown, the plugin can read the complete HTML code from the database and can skip the generating process. That’s very cool 
Oh, the cache will be cleared every time you publish or update an post, so the cloud is up to date (sure, you have the ability to clear the cache manualy).
Keine Kommentare | Keine Trackbacks
Filter tags in New Tag Cloud
Von FunnyDingo | 9. November 2009, 18:19
Often I've been asked for a way to filter the tags used by New Tag Cloud. Only tags used in posts from defined categories should be used. Today I found the time to play with possible SQL statements and found a good one:
-
SELECT wp_terms.term_id, wp_terms.name, LOWER(wp_terms.name) AS lowername, wp_term_taxonomy.count
-
FROM wp_terms
-
LEFT JOIN wp_term_taxonomy ON wp_terms.term_id = wp_term_taxonomy.term_id
-
LEFT JOIN wp_term_relationships ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
-
LEFT JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.ID
-
WHERE wp_term_relationships.object_id IN
-
(
-
SELECT object_id
-
FROM wp_term_relationships
-
LEFT JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
-
WHERE term_id IN (1,2,...)
-
)
-
AND wp_term_taxonomy.taxonomy = 'post_tag'
-
AND wp_term_taxonomy.count> 0
-
GROUP BY wp_terms.name
-
ORDER BY wp_term_taxonomy.count DESC
This query is very similar to the old one and needs on my system only 0.05 seconds more than the old one. But lets take a look in detail.
We will start in lines 8 - 11. Realy, that is all the magic! This small query returns the IDs of all objects (in our case posts) wich are in the categories wich IDs have been placed in the brackets. Now the main query (lines 1-6 and 13-16) can filter the relevant posts for those, wich are returned by the sub query. Sure, in this case, we have to do a join with the posts table, but cause we are only interested in tags used in already published posts, we have to do it anyway.
So, in the next days I'll implement this in the plugin and release the new version.
Keine Kommentare | Keine Trackbacks
Windows 7 langsamer bei HDD Burstrate!?
Von FunnyDingo | 22. Mai 2009, 11:11
Ich habe gerade mal mit HD Tach die Performance meiner Platten gemessen. Ich war erstaunt, dass die Zugriffe langsamer waren als unter Windows XP SP3. Da ich seit dem letzten Test unter Windows XP einiges an der Hardware geändert habe, habe ich die Messung unter XP wiederholt. Selbes Ergebnis. Beim Burst ist Windows 7 langsamer. Hier mal ein paar Screenshots (rot = Windows 7, blau = Windows XP SP3).
-
- Samsung HD502IJ (500GB)
-
- WDC WD10 (1TB)
-
- WDC WD400BB (40GB)
Keine Kommentare | Keine Trackbacks
Test of WordPress 2.5
Von FunnyDingo | 16. März 2008, 14:27
A few minutes ago I tested compatibility between my WordPress installation and the new WordPress 2.5 (nightly build). Everything works. The theme, all plugins (even my New Tag Cloud) and the widgets. So I think it should be possible to upgrade my blog to 2.5 on release date and optimize it later.
Keine Kommentare | Keine Trackbacks
Kleines yac Update
Von FunnyDingo | 19. Januar 2008, 01:03
Gerade habe ich ein kleines yac Update veröffentlich. Dieses Update löst ein Problem mit bestimmten Formatierungszeichen die zu Problemen in manchen Browsern führen können. Der next4u.de-Chat hat das Bugfix direkt eingespielt bekommen. Nun ist Version 0.9.7 aktuell.
Für alle anderen yac Betreiber steht die aktuelle Version wie immer via SVN zur Verfügung.
Keine Kommentare | Keine Trackbacks
Laufzeit aktueller yac Installationen
Von FunnyDingo | 18. Januar 2008, 23:21
Es sind zwar nicht viele, aber hier ein kleiner Überblick:
next4u.de: 1427h 15m
recensio.org: 632h 10m
funnydingo.de: 1427h 22m
Ich glaube bei recensio.org war der letzte Reboot nur wegen eines Serverumzugs notwenig (oder Bernhard?).
New Tag Cloud 0.4 Testing Version
Von FunnyDingo | 16. Januar 2008, 22:36
A few minutes ago I uploaded version 0.4 of New Tag Cloud. It's only a testing version, so access the svn repository to download it. Read the readme.txt to see what's new.
Keine Kommentare | Keine Trackbacks
Get New Tag Cloud colored
Von FunnyDingo | 27. November 2007, 19:43
coke3grad had a very greate idea to get the tag cloud colored. By adding a class-property to the a-tag you are able to define more style definitions for the tag cloud. See coke3grad's comment.
Keine Kommentare | Keine Trackbacks
Bug in New Tag Cloud
Von FunnyDingo | 25. November 2007, 18:15
There is a little bug in version 0.3 of New Tag Cloud. If you have downloaded the plugin between 19th and 25th Nov please redownload it. See this comment for more informations.
Keine Kommentare | Keine Trackbacks
NewTagCloud 0.3 released
Von FunnyDingo | 19. November 2007, 20:50
Version 0.3 of NewTagCloud is released. Much fun!
Keine Kommentare | Keine Trackbacks