Archives for Říjen 2009

tbNotes 0.1.5 comming soon

Here is only a list of already finished changes and one screenshot from upcomming tbNotes version: updated for Thunderbird 3.0b4 first implementation of message header view first implementation of the all notes view added new toolbar button

Customizing Thunderbird’s message header view

As I worked on tbNotes extension I needed to add item to the message header view (see the picture). I didn’t found any usefull informations on MDC or Google so I look into the Thunderbird‘s sources (msgHdrViewOverlay.js) file and there I founded it. Solution is simple: Code placed in overlays.xul: <!– Message header view overlay [...]

MySQL Trick: GROUP_CONCAT

Today I discovered and firstly used MySQL aggregate function GROUP_CONCAT and it’s really usefull in same cases. Consider structure database like this: ┌───────────────────────────────┐ ┌───────────────────────┐ │ eshop_items │ │ eshop_items_to_genres │ ├───────────────────────────────┤ ├───────────────────────┤ │ * ID [INTEGER] |—-| item_ID [INTEGER] │ │ title [VARCHAR] │ │ genre_ID [INTEGER] |—-┐ │ image [VARCHAR] │ └───────────────────────┘ | │ [...]