(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 '%JamesFowler42%') 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
Please download from the Pebble App store: http://apps.getpebble.com/applications/52e79fe4f6e72005f7000016 This version will no longer be maintained.
This is a simple animated digital watchface for use with Max Bäumle's Smartwatch Pro.
The watch face shows the next 5 calendar events in rotation. The time of the event is turned from a simple date into an easier to read 'today', 'tomorrow', 'Tuesday' or, if sufficiently far in the future the date as month name and day. If the watch detects movement the events change every 3 seconds but this gradually slows down to 30 seconds per change to save battery.
The status bar shows the event being shown (1-5), an indication of communcation with your iPhone (top arrow is a request, bottom arrow a reply), the phone battery state and the Pebble battery state.
Watchface settings from inside Smartwatch Pro: Inverse; animation; day name; month name; week no
Note: The calendar alert facility found in the SDK1.x version of this software has been retired, as ios7 ANCS notifications surplant it.
created by - JamesFowler42
-
Description
Modern watchface (thanks to Zalew) providing bluetooth connection status and watch battery charge level (with charging indicator).
When the battery falls below 20% power, the second hand disappears in order to conserve power.
created by - JamesFowler42
-
Description
Please download from the Pebble App Store: http://apps.getpebble.com/applications/52b20a9b05c04688bf000058 This version will no longer be maintained.
Your Pebble watch, your phone and the free Morpheuz app are all you need to monitor your night's sleep.
Inside the Pebble watch is a movement sensor called an accelerometer. Using this Morpheuz tracks your movement during the night and transmits this back to your phone.
You view this information on your phone as a graph of movement over the night, and as a chart of the time spent in deep sleep, light sleep and potentially awake states.
Morpheuz includes a Smart Alarm facility. This enables you to set an earliest and latest wake-up time. When Morpheuz detects that you are stirring within this period, Morpheuz will gently awaken you with 30 seconds of watch vibration. If you remain in a deep sleep until the latest wake up time, Morpheuz will always attempt to wake you.
Morpheuz also includes a Power Nap feature. Once activated (by pressing select for 1.5 seconds), Morpheuz starts a countdown once you stop moving, giving an optimum 27 minutes of rest before stirring you with gentle vibration.
You can export a single night’s data via an email. You can then easily import this CSV data into a spreadsheet.
Instructions and information: http://www.morpheuz.net
Like Morpheuz on facebook at http://www.facebook.com/morpheuzsleepmonitor
Show a past chart from CSV data: http://www.morpheuz.net/p/revisit.html
AS THIS APP USES JAVASCRIPT IOS USERS WILL NOT BE ABLE TO RUN IT FROM THIS SITE. INSTEAD PLEASE DOWNLOAD FROM THE PEBBLE APP STORE.
created by - JamesFowler42
-
Description
This is a simple digital watchface for use with Max Bäumle's Smartwatch Pro.
It provides calendar alerts for events with a time in the current day. The watch will vibrate twice and turn the light on. 15 seconds later it will vibrate and light again. The event is shown with location and a relative time (e.g. In 15 mins).
When not showing an alert the watch face shows the next 5 calendar events in rotation. The time of the event is turned from a simple date into an easier to read 'today', 'tomorrow', 'Tuesday' or, if sufficiently far in the future the date as month name and day. The events are shown for 3 seconds each during the day and 10 seconds each overnight to save power.
The iPhone battery status is shown giving a level and, if on charge, a charging indicator.
There are three indicators showing communication from Pebble to iPhone, iPhone to Pebble and whether an alert has been set.
I RECOMMEND REMOVING OTHER WATCHFACES USING SMARTWATCH PRO BEFORE INSTALLING. E.G. MODERN CALENDAR. The Smartwatch Pro app works nicely alongside it.
created by - JamesFowler42
-
Description
Modern watchface (thanks to Zalew) with the ability to pick up calendar events from Smartwatch Pro (thanks to Max Baeumle) and create alerts from them.
After starting and every 10 minutes a calendar request is issued to Smartwatch Pro. Any event which is for today, has a time and alerts has alerts generated for it.
When an alert triggers the usual date and day is replaced by the title of the event with a relative time (e.g. In 15 mins). The vibration and light are triggered. After 15 seconds the vibration and light are triggered again. After 30 the display reverts to showing the date.
There are up to three icons under the pebble logo. A right arrow indicates a request has been made of the iphone. A left arrow indicates a reply has been recieved. The bell indicates an alert has been created.
If the connection cannot be made to Smartwatch Pro for any reason, then existing alerts remain active.
When I first got a Pebble I expected I wanted all alerts, but after a while I realised all I care about are incoming calls, text/iMessage messages, emails and meeting alerts. The standard Pebble software reliably gives me the first three - this watchface and Max's Smartwatch Pro completes the set.
created by - JamesFowler42
