(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 '%mikebikemusic%') 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 is the first fully configurable multi-timezone watchface for Pebble 2.0 SDK. Showcasing the latest cool features of this new Pebble OS, including Configuration from the Pebble App, Location awareness, and settings persisted on the watch itself. It uses JavaScript and JQuery mobile for configuration.
Vote for my app in December - Thanks for those who have already done so!
- Any Time supports all 40 timezones - yes 40! Including UTC+13:45
- Plus, your local Sidereal Time, so you'll be sure to know when a comet is overhead!
- Three choices for clock formatting: 12/24 hour plus 24 hour with seconds.
- 5 different Heading styles
- That's over 600 combinations of formats to choose from.
- Last format you chose is remembered when you change watch faces, even in airplane mode.
- The top clock automatically determines your correct UTC offset even with daylight savings time.
Note:
- You can only change configuration if you have internet access - wifi is good enough. This is a limitation of the current SDK.
- If you fly to another time zone, once your phone is aware of its new location, switch away and back from Any Time to update your local time.
created by - mikebikemusic
-
Description
This is my variation on the Text Watch. Differences are:
- Includes the day of the week and date.
- The minutes are written in bold for better readability.
- Black text on white background also for better readability.
- Spelling corrections on some of the teen numbers.
- Font size adjusts in order to maximize screen filling.
- After trying o and o', I settled for "oh".
Updated to run with SDK 2.0. You must have the new watch firmware.
created by - mikebikemusic
-
Description
Never miss an astronomical event. This watchface automatically determines your correct time zone and longitude in order to calculate your local sidereal time (LST) and Universal Time Coordinated(UTC, but also known as Greenwich Mean Time, GMT). The background changes between day and night, and a + or - indicator shows if UTC is ahead or behind your local time by a day.
The LST tells you the Right Ascension of the sky directly above you. This helps you find which night sky objects are better visible.
This build will only run on watches with 2.0 or later firmware and no longer requires any third party applications to run.
created by - mikebikemusic
Description
Same as Sidereal Time, but for SDK 1.X watches. Requires httpebble app to obtain time zone and approximate location needed for LST calculation.
created by - mikebikemusic
Description
Same as Sidereal Time (with local date) but added seconds counting, not because it needs to be more accurate, but because it's really cool to see the local sidereal time increment and switch minutes at a different rate than local time.
created by - mikebikemusic
-
Description
The new 2.0 version no longer needs httpebble to start up. You must have the new firmware to run this version.
This watchface automatically determines your correct time zone, showing your local time and Zulu (GMT) time in large font and 24 hour format. The background changes between day and night, and a + or - indicator shows if Zulu time is ahead or behind your local time by a day.
created by - mikebikemusic
Description
Same as Zulu Time, except using the smaller font to display seconds. You must use the 2.0 pebble firmware.
created by - mikebikemusic
