(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 '%matthewtole%') 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
Show the time as a collection of dots, one for each hour, minute and second in the day.
created by - matthewtole
Description
Show the time as a collection of dots, one for each hour, minute and second in the day.
created by - matthewtole
-
Description
This is the Android version of London Tube. If you use an iOS device with your Pebble, please use the other version.
--
Stay on top of the status of the London Underground wherever. Just launch the app and it will use your phone's Internet connection to find out what's happening on the Tube.
In order for the app to work you'll need to have a httpebble client on your phone, for Android users that's Pebble Connect on Google Play.
created by - matthewtole
Description
This is the iOS version of London Tube. If you use an Android phone with your Pebble, please use the other version.
--
Stay on top of the status of the London Underground wherever. Just launch the app and it will use your phone's Internet connection to find out what's happening on the Tube.
In order for the app to work you'll need to have a httpebble client on your phone, for iOS users it's called "httpebble" on the iTunes Store.
created by - matthewtole
-
Description
A simple yet elegant watchface that displays the current time using three horizontal sliders, displaying the current second, minute and hour.
IF YOU ARE ON THE 1.X VERSION OF THE PEBBLE FIRMWARE, DOWNLOAD THE 1.X WATCHFACE INSTEAD. THIS ONE WILL NOT WORK.
created by - matthewtole
Description
If you're running the Pebble 1.x firmware, download this instead of the main watchface.
created by - matthewtole
-
-
Description
Multi timer is an app that allows you to have up to 8 up or down timers all running simultaneously, with the ability to pause, resume, stop, reset and delete them all individually.
Note: Due to a limitation with the Pebble itself, the timers you create will be lost whenever you exit the app.
** Version 1.2 **
- Implemented hold-to-repeat on the Add Timer window, so the length of the timer can be set more quickly.
- Change vibration to be a configurable option, ranging from no vibration to a constant vibration that only stops when the user presses a button.
created by - matthewtole
