(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 '%smognus%') 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
This version of the Sunset Watch attempts to auto-locate using the new pebblekit-js geolocation API. Please note that timezone handling is very rough at the moment and will likely skew sunrise/sunset times inaccurate in different parts of the world. This version also allows for an option to display the percentage of the remaining watch battery and for enabling DST offsets (please give feedback on this feature especially).
The watchface now honors the Pebble OS 12/24 hour setting.
The watchface is also now configurable in a few aspects from within the Pebble phone app, namely:
- Whether or not a second hand is displayed.
- Whether or not the phase of the moon is displayed.
- Whether or not hour-marking numbers are displayed.
- Whether or not the digital time is displayed.
- Whether or not the remaining watch battery percentage is displayed.
- Whether or not to account for DST when calculating sunrise/sunset times.
- To calculate sunrise/sunset times based on a manually-set timezone.
I would love to take credit for the idea for this watchface (because it is wonderful), but the idea, and a lot of the code, is taken from:
http://www.mypebblefaces.com/apps/1528/2270/
created by - smognus
-
Description
Pebble Sunrise/Sunset and Moon Phase Watch Face
It is a 24hour face with an hour hand and a second hand. Sunrise/sunset times are calculated, and the face is overlaid with with day/night masks. The phase of the moon is calculated and drawn in the night mask area. Sunrise and sunset times are in the bottom left and bottom right corners, respectiviely.
This is a rewrite of the watchface at http://github.com/KarbonPebbler/KP_Sun_Moon_Vibe_Clock, which was badly broken by SDK changes. This version uses no bitmaps, and since the GCompOps aren't working for vector stuff yet, it does some truly silly stuff to simulate transparency.
To make it work for your location, modify config.h for your Latitude and Longitude and Timezone.
The original author is KarbonPebbler, and he adds the additional credits to his project:
- Michael Ehrmann (Boldo) for the original SunClock source
- Chad Harp for the Almanac source
- Dersie for beta testing the revised code
created by - smognus
-
Description
Sunset Watch, but without the second hand, and with the digital time displayed in 24-hour. Migrated from 1.x SDK to 2.0 SDK
As with the older versions, modify config.h to reflect your TZ and Lat/Long in the world and recompile. I _may_ update this to request the phone's geographic location and use that instead using the new pebblekit-js features.
created by - smognus
-
Description
The same as "Variable Hands", but with a tiny diamond with the current month day inside.
This analog watchface's hands' lengths are always the same distance from the edge of the screen. The minute and second hands reach all the way to the edge of the screen, and the hour hand is a constant 35 pixels from the screen edge.
created by - smognus
-
Description
This analog watchface's hands' lengths are always the same distance from the edge of the screen. The minute and second hands reach all the way to the edge of the screen, and the hour hand is a constant 35 pixels from the screen edge.
created by - smognus
-
Description
Pebble Sunrise/Sunset and Moon Phase Watch Face
It is a 24hour face with an hour hand and a second hand. Sunrise/sunset times are calculated, and the face is overlaid with with day/night masks. The phase of the moon is calculated and drawn in the night mask area. Sunrise and sunset times are in the bottom left and bottom right corners, respectiviely.
This is a rewrite of the watchface at http://github.com/KarbonPebbler/KP_Sun_Moon_Vibe_Clock, which was badly broken by SDK changes. This version uses no bitmaps, and since the GCompOps aren't working for vector stuff yet, it does some truly silly stuff to simulate transparency.
To make it work for your location, modify config.h for your Latitude and Longitude and Timezone.
The original author is KarbonPebbler, and he adds the additional credits to his project:
- Michael Ehrmann (Boldo) for the original SunClock source
- Chad Harp for the Almanac source
- Dersie for beta testing the revised code
Updates:
1.1 - App now only does moon phase, sunrise, sunset calculations once per day instead of once per second
1.2 - Improved moon rendering (less eclipse-like)
1.3 - Changed some font sizes/styles and text positioning to improve readability.
created by - smognus
Description
Sunset Watch, but without the second hand, and with the digital time displayed in 24-hour.
created by - smognus
