(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 '%partlyhuman%') 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
Kitch cat. Put some retro Americana on your wrist.
This watchface will probably eat your battery up. But lookit those adowabwe wittwe eyes.
created by - partlyhuman
-
Description
PblPdx is hands-down the easiest way to plan your trip on TriMet in Portland, OR! Just walk up to any TriMet stop (bus, streetcar, or MAX!) and launch PblPdx from your Pebble watch. In just a moment it will identify your stop and show you the next few buses to arrive, counting down to their arrival. It's that easy. no need to pull out your phone. Just peep your Pebble!
BETA VERSION 1.2 - This is a PUBLIC BETA. Please try it out and submit feedback!
Requires Pebble phone app 2.0+ and firmware 2.0+.
created by - partlyhuman
-
-
Description
WARNING!! THIS APP IS FOR SDK 2.0, WHICH AT TIME OF WRITING WAS STILL IN BETA!
To use this you will need to have the 2.0 firmware installed. If you are not a Pebble developer, probably best to sit tight, it will be released to the public soon.
created by - partlyhuman
-
Description
[See http://www.mypebblefaces.com/apps/10156/7157/ for an SDK 2.0 version!]
This is a customizable, multilingual, simple, and attractive work timer. You can use it with the Pomodoro Technique® or other time management systems. The use of vibration means you can use your timers without worrying about disturbing others, or having it drowned out by your music.
Current languages include English and Spanish. We are looking for translators. Adding a language is easy. Fork the repository, add your language to the PomLanguage enum in pom_text.h, and add an entry in your language for every text key in pom_text.c. Submit a pull request.
This project uses the httpebble library by Katharine Berry. Your settings will be maintained as long as you have httpebble running in the background on your phone. Phone and httpebble are both completely optional.
The "Pomodoro Technique®" and "Pomodoro®" are registered trademarks of Francesco Cirillo. We have no relationship with, nor do we endorse, these marks, their owner, or the company FC Garage.
created by - partlyhuman
-
Description
The "Brains" analog watchface from Pebble, but COUNTERCLOCKWISE!
Why? Because we can. All credit is due to Pebble, this is a 5 minute hack.
created by - partlyhuman
