(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 '%rebootsramblings%') 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
Prerequisites for this watch app to work:
-You must have Pebble SDK2 Beta 2 Firmware on your Pebble.
-You must have the Simply Alarm Holo Android App installed on your android device.
The Simply Alarm Watch App gives you control over your Alarms and Timers from your Pebble; Dismiss or Snooze Alarms and Timers or request an overview of Alarms or Running timers right from your wrist!
New! Create Alarms and Timers from the Simply Alarm Watch App!
http://play.google.com/store/apps/details?id=ca.rebootsramblings.simplyalarmholo
**NOTE: This watch app does nothing on its own, it requires that Simply Alarm Holo (Android Only) be installed **
created by - rebootsramblings
-
Description
Prerequisites for this app to work:
-You must have the Pebble SDK2 Beta 2 Firmware on your Pebble
-You must have the Music Boss for Pebble Android App installed on your Android Device
The Music Boss Watch App gives you total control over your music with your Pebble Smart Watch*
http://musicboss.ca
-Adjust Volume with your Pebble while listening to music
-Launch your current Music App from your Pebble watch
-Quickly change the current Music/Audio app with your Pebble
-Customizable via Music Boss for Pebble (Android)
-Music Boss is now integrated with Tasker http://musicboss.ca/tasker
Please email me with any questions/comments/issues at [email protected]
*Requires that Music Boss for Pebble (Android Only) be installed on your Android device. This watch app does nothing on its own. Music Boss for Pebble is available on the Google Play Store:
http://play.google.com/store/apps/details?id=ca.rebootsramblings.musicboss
created by - rebootsramblings
-
Description
The Simply Alarm Watch App gives you control over your Alarms and Timers from your Pebble; Dismiss or Snooze Alarms and Timers or request an overview of Alarms or Running timers right from your wrist!
http://play.google.com/store/apps/details?id=ca.rebootsramblings.simplyalarmholo
**NOTE: This watch app does nothing on its own, it requires that Simply Alarm Holo (Android Only) be installed **
Simply Alarm Holo:
Simply Alarm Holo is a Minimalistic, Holo Themed Alarm and Timer App with Pebble Smart Watch Integration, which includes a Pebble Watch App.
This Alarm and Timer will fit the needs of anyone with or without a Pebble Smart Watch. Pebble Smart Watch owners, this is the Alarm and Timer App you have been waiting for!
Simply Alarm Holo is now integrated with Glance for Pebble! Quickly return to Glance for Pebble directly from the Simply Alarm Watch App without returning to the Pebble watch app menu.
Simply Alarm Holo has Pebble Smart Watch Specific Customizations, fully customizable Alarms (single or repeating on days of your choosing by expanding alarm), multiple simultaneous Countdown Timers as well as a home screen widget and a customizable status bar notification for next alarm and subsequent Alarms. Also, Smart One Time Alarms delete after one use for a clutter free alarm list.
New in version 2.1.1 is a Simple Desk Clock mode which allows you to use your phone as a clock. You can set it to either default to desk or night mode then change the theme while using it.
Please send any issues or questions to [email protected]
created by - rebootsramblings
-
