(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 '%opasco%') 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
Digital version (SmartStatus-op) available here: http://www.mypebblefaces.com/apps/3027/6714/
This is an analog version of my SmartStatus-op app (http://www.mypebblefaces.com/apps/3027/6714/), itself a modified version of the SmartStatus watch app by Robert Hesse. It only works in conjunction with the Smartwatch+ iOS app available on the Apple App Store: http://itunes.apple.com/us/app/id711357931?mt=8
On screen info:
- time and date (month and day only)
- status information showing the connectivity status with the phone app
- battery indication (icon only, no text)
- current day's weather icon and current temperature
- next day's forecast icon and min/max
- artist and title info/street and city name
- next appointment
Notifications:
- vibes on time of currently displayed appointment
Buttons:
- middle: play/pause on short press, find-my-phone on long press
- up/down: volume up/down
Known issue:
Some times the communication with the phone stops on a timeout error and never recovers. It seems that the BT communication of the watch dies and you need to reset the Pebble. It looks like the Pebble might be resetting once or twice a day while the app is running.
created by - opasco
-
Description
Analog version SmartStatusAnalog available here: http://www.mypebblefaces.com/apps/3027/6815/
This is a modified version of the SmartStatus watch app by Robert Hesse. It only works in conjunction with the Smartwatch+ iOS app available on the Apple App Store: http://itunes.apple.com/us/app/id711357931?mt=8
On screen info:
- time and date (month and day only)
- status information showing the connectivity status with the phone app
- battery indication (icon only, no text)
- current day's weather icon and current temperature
- next day's forecast icon and min/max
- artist and title info/street and city name
- next appointment
Notifications:
- vibes on time of currently displayed appointment
Buttons:
- middle: play/pause on short press, find-my-phone on long press
- up/down: volume up/down
Known issue:
Some times the communication with the phone stops on a timeout error and never recovers. It seems that the BT communication of the watch dies and you need to reset the Pebble.
All credit goes to Robert Hesse.
created by - opasco
