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

Full story »

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 –>
[...]

Full story »

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 │
├───────────────────────────────┤ [...]

Full story »