improved country and city browsing

[GoogleCodeExporter]

To make it more dynamic, the first query should be something like

select "country/primary location name" as c1, count(*) as c2 from files group 
by "country/primary location name" 

Now we have the different countries and the number of pictures in that country.

Compared to the previous version, I have combined 2 function/queries into 1, 
like “def list_country():”  and “def count_country(p_country):”

With this result

select "country/primary location name" as c1, count(*) as c2 from files group 
by "country/primary location name" 

we have to build the list in XBMC using . The result could be looking like this:
         Australia       100 pictures
         France           25 pictures
         Netherlands     999 pictures

The actions should be different
1) The context-menu for each entry, should contain the standard functionality 
of pictures; in French the “<string id="13318">Diaporama 
rö©cursif</string>”
Eg. For France it must be showing ALL 25 pictures
2) The enter-key enabled the next stage, the cities
         select city, count(*) from files where "country/primary location name" = "France" group by city

With this result we have to build the list in XBMC. The result could be looking 
like this:
         Paris            10 pictures
         Lyon            15 pictures

The actions should be different.
1) The context-menu for each entry, should contain the standard functionality 
of pictures; in French the “<string id="13318">Diaporama 
rö©cursif</string>”
Eg. For Paris it must be showing ALL 10 pictures

2) The enter-key enabled the next stage, the pictures it self
         select strFilename from files where "country/primary location name" = "France" and city = "Paris"

Looking to your implementation of “keywords” you have made your own 
contextmenu
                            contextmenu   = [( __language__(30152),"XBMC.RunPlugin(\"%s?action='addfolder'&method='keyword'&kw='%s'&viewmode='scan'\")"%(sys.argv[0],kw)),
                                             ( __language__(30061),"XBMC.RunPlugin(\"%s?action='showpics'&method='keyword'&viewmode='zip'&name='%s'&kw='%s'\")"%(sys.argv[0],kw,kw) ),
                                             ( __language__(30062),"XBMC.RunPlugin(\"%s?action='showpics'&method='keyword'&viewmode='export'&name='%s'&kw='%s'\")"%(sys.argv[0],kw,kw) )]

But I miss the default option for showing these picture. Changing the code to 
                            contextmenu   = None,

the first 2 options I always use. These options I’d like to see always in the 
contextmenu

Original issue reported on code.google.com by mdeb...@gmail.com on 21 Jan 2011 at 7:50

[GoogleCodeExporter]

Some infos :
Browsing by countries then cities for a given country is working now (on my 
local copy, not in the repo yet)
I just need to make some code cleanup, add some contextual menus, ...
The translation strings should be checked for updates (I wrote updated strings 
using [[ ]] markup to be sure to not forget any update.

Original comment by alexso...@gmail.com on 31 Jan 2011 at 10:41

• Changed state: Started

[GoogleCodeExporter]

Original comment by alexso...@gmail.com on 31 Jan 2011 at 11:07

• Changed state: Fixed