(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 '%stibbons%') 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
Join me on a magical forest adventure where monochrome fireflies dance on your wrist. Normally, the fireflies swarm and blink and dance, but every minute or so, they join together and do their best to show you the time. They hold formation for only a moment, but the effort is to great for their little wings. In their excitement, they all glow together in unison and then quickly return to their natural state.
This is the original Fireflies watchface by Nate Murray, updated for the 2.0 SDK.
created by - stibbons
-
Description
A combination analogue / digital watchface that shows two time zones. The local wall time is always shown on the analogue face, while the digital face shows a user-configurable time zone.
This app requires the beta 2.0 firmware and mobile app. Configuration is done through the mobile app.
created by - stibbons
-
Description
I accidentally made the hands too big and heavy for the mechanism. So they get dragged down by gravity and move faster at the bottom.
Thought I could fix that by moving all the markings up a bit, but now they're starting to sag too...
(watch face looks considerably nicer than this app image, check forum thread at http://forums.getpebble.com/discussion/7291/watch-face-gravity for a photo. my kingdom for a good screen shooter!)
created by - stibbons
-
Description
A watch face that displays time on two analogue gauges.
This is currently a straight port of the watchface to SDK 2.0. I plan to add (optional) bluetooth and battery notifications.
created by - stibbons
-
Description
A combination analogue / digital watchface that shows two time zones. The local wall time is always shown on the analogue face, while the digital face shows a user-configurable time zone. Uses httpebble, and a separate app to set the time zone.
This face is the iOS version. A separate version with a unique UUID is available for Android users.
TO USE:
First, make sure you have httpebble installed.
Then install a DualTZ-selector app. If you use an iOS device use the iOS version. The Android version will work better on Android devices. Run it, and change the timezone to one near you.
Install the DualTZ face. Again, choose the one that matches the phone your Pebble's paired to. Run it, and it should update to your configured timezone shortly.
NOTE FOR 2.0:
The way data is stored on the watch has changed. If you're upgrading from older versions, you'll need to re-run the selector. Sorry about that.
NOTE:
The locations this app uses come from the tz database, a full list of zones is at http://en.wikipedia.org/wiki/List_of_tz_database_time_zones
created by - stibbons
Description
A combination analogue / digital watchface that shows two time zones. The local wall time is always shown on the analogue face, while the digital face shows a user-configurable time zone. Uses httpebble, and a separate app to set the time zone.
This version is built for Android
created by - stibbons
Description
This is a regular Pebble app that will let you configure which timezone will be shown on the DualTZ watchface.
This version will work on iOS devices. A separate version with a unique UUID is available for Android.
created by - stibbons
Description
This is a regular Pebble app that will let you configure which timezone will be shown on the DualTZ watchface.
This version will work better with Android devices.
created by - stibbons
