Updated...

Here is the query for those using [b]RQ Money[/b] instead of Money Manager Ex:

Summary about currencies:

[code]SELECT Currency || ':' as Currency, SUM(Amount) as Amount FROM
(

SELECT u_code as Currency, a_startsum as Amount
FROM currencies JOIN accounts on (u_code=a_currency)

UNION ALL

SELECT u_code as Currency, case when c_kind IN ("+", "p") then d_sum else -d_sum end as Amount
FROM
data
JOIN
categories ON (d_category = c_id),
accounts ON (d_account = a_id),
currencies ON (u_code=a_currency)
)
GROUP BY Currency[/code]

To use it with bbmmex, put this one long line into your bbmmex.rc:
[code]bbmmex.Query.1: SELECT Currency || ':' as Currency, SUM(Amount) as Amount FROM (SELECT u_code as Currency, a_startsum as Amount FROM currencies JOIN accounts on (u_code=a_currency) UNION ALL SELECT u_code as Currency, case when c_kind IN ("+", "p") then d_sum else -d_sum end as Amount FROM data JOIN categories ON (d_category = c_id), accounts ON (d_account = a_id), currencies ON (u_code=a_currency)) GROUP BY Currency;
[/code]

This is great!

Anyone who contributes to Blackbox is a superstar!

Updated...

Any new plugin is welcome! Thank you for your effort, bro! :)

If you use [url=http://www.codelathe.com/mmex/][b]Money Manager Ex[/b][/url] or [url=http://www.rq.sk/][b]RQ Money[/b][/url],
or [b]anything that keeps data in (unencrypted) SQLite database[/b], this plugin could be useful to you.

Out of the box, it shows summary about currencies from Money Manager Ex, hence the name.

It can be also used to show custom messages and toolbar label messages.

History:
========

14-Feb-2012 - bbmmex 0.06
-------------------------
- Added: For each query in the rc settings, you can now specify path to the database if you don't want to use the default database for that query.
- Added: @bbmmex.PreviousQuery bro@m (this is now default action on ctrl+middle click)
- Added: @bbmmex.ShowMenu bro@m (this is now default action on right and ctrl+right clicks)
- Added: Right click, ctrl+right click, and ctrl+middle click mouse actions
- Added: Another useful Money Manager Ex query to the sample rc file
- Added: RQ Money (http://www.rq.sk/) query example to the sample rc file
- Fixed: SQL result was refreshed unnecessarily after showing the custom/toolbar messages

29-Jan-2012 - bbmmex 0.05
-------------------------
- Added: Support for multiple queries
- Added: Another useful Money Manager Ex query to the sample rc file
- Default query setting is now bbmmex.Query.1 in rc file, so check out provided sample
- Other queries can be selected via @bbmmex.QueryNumber bro@m
(if you combine this with @bbmmex.DBpath bro@am in a script, you can use bbmmex to easily run queries on multiple sqlite databases)
- Added support for cycling through provided queries with @bbmmex.NextQuery bro@m (this is now default action on middle click)
- Added support for showing custom messages via @bbmmex.ShowMessage bro@m
- Added support for showing toolbar label messages (can be set via menu or via @bbmmex.ShowToolbarLabelMessages bro@m)
- Message duration can be set via menu or via @bbmmex.MessageTimeout bro@m

24-Jan-2012 - bbmmex 0.04
-------------------------

- Added CenterText option
- Added View Readme option in menu (if Readme.txt is available)

- Added support for custom OnClick, OnMiddleClick and OnDoubleClick actions
- Added ClickToRefresh option if you (don't) want to refresh result in addition to custom OnClick action
- Rearranged configuration menu
- Error messages are drawn to the plugin window now (they were shown in message box)

- Added support for custom row delimiter
- Renamed column delimiter setting and bro@m from "Delimiter" to "ColumnDelimiter"
- Added support for \t, \r, \n, \" and \\ in delimiter settings