(mysqlt): select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and (ak_pebble_authorName LIKE '%fbpebbleface%') and (p1.cID!='128') and cvName != '' and pt.ctID = '10' and (ak_exclude_page_list = 0 OR ak_exclude_page_list is null) and PagePaths.cPath like '/apps/%' and PagePaths.ppIsCanonical = '1' and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((select count(cID) from PagePermissionAssignments ppa1 inner join PermissionAccessList pa1 on ppa1.paID = pa1.paID where ppa1.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and pa1.accessType = 10 and pa1.pdID in (0)
and pa1.peID in (2) and (if(pa1.peID = 4 and p1.uID <>0, false, true)) and (ppa1.pkID = 1 and cv.cvIsApproved = 1)) > 0
or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL)) and ((select count(cID) from PagePermissionAssignments ppaExclude inner join PermissionAccessList paExclude on ppaExclude.paID = paExclude.paID where ppaExclude.cID = if(p2.cID is null, p1.cInheritPermissionsFromCID, p2.cInheritPermissionsFromCID) and accessType = -1 and pdID in (0)
and paExclude.peID in (2) and (if(paExclude.peID = 4 and p1.uID <>0, false, true)) and (ppaExclude.pkID = 1 and cv.cvIsApproved = 1)) = 0) and ak_pebble_flag = '0' and ak_pebble_subApp = '0' and p1.cIsActive = '1' order by ak_pebble_dateAdded desc limit 0,56
-
Description
A very informative whatchface showing:
* time,
* date,
* current weather,
* temperature,
* moonphase,
* sunset and sunrise time,
* pebble battery status,
* bt connection status.
Derived from ninety hank 2 available on github, with the following modification:
* no week number, which I didn't care about
* smaller moonphase icon and leaner description ("+" for growing, "-" for shrinking)
* seconds are not displayed as this should use less battery
* weather icon and temperature have been added
PLEASE NOTE:
My app at the moment doesn't have an option menu, this means that:
* timezones are hardcoded (Singapore and Sydney)
* sunset and sunrise are calculated for a hardcoded location (Milano)
In a way I think having no settings is preferrable: this means the whatchface will work offline even if the phone is down. In any case, it's options mean flexibility, so I will probably release a configurable version at some point in the future.
If you need any different timezone or timezones/sunset location, please proceed as follows:
1) please help me by commenting "Ninety Hank Universal" whatchface (http://www.mypebblefaces.com/apps/582/11125/), and require the developer to "release the source code of this app, because it is a rework of the original Ninety Hank (by Hank) released under GPLv2"... even if you don't know what that means :D
and then
2) contact me and I'll create a separate app for you to download with whatever coordinates you may have
created by - fbpebbleface