(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 '%sirtate%') 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
NEW IN VERSION 2:
- Multiple Lists!
========================
"Groceries" allows you to store, view and edit your todo or shopping list online and on the Pebble. Because of current limitations of the SDK, the app cannot save the data on the watch itself, which made it necessary to store the lists somewhere else.
With "Groceries", I let you store and edit your data on my web server. To register your Pebble for "Groceries" go to: http://goo.gl/su3h4K
Your Pebble will be identified by its Serial Number and you automatically get your data when you open the app.
It is important to know that "Groceries" is based on "httpebble", a library which makes it easy for a Pebble app to communicate with a web server. "httpebble" has a companion for the smartphone, which needs to be installed in order to use "Groceries".
Usage:
=====
To mark an item as "done", which is indicated by the item being stroke through, short-press the center-right button.
The same action applies for toggling the state back to "open".
You can delete an item by long-pressing the center-right button.
created by - sirtate
-
Description
This is an advanced version of GPS Coords. If you're looking for the first "raw" version of GPS Coords., you will find it as a sub-app called "GPS Coords. v1"
This app simply shows the latitude, longitude & altitude of your current location. It uses httpebble, so you must have installed it on your Smartphone for this app to work.
Features:
=======
- a nice way of presenting the current location, as provided by the smart phone.
- Latitude, Longitude & Altitude
- Set different autoupdate intervals
- Set different display styles
Usage:
=====
Manual update: Press the middle-right button, which triggers a data update and screen refresh.
If you do not update the screen manually, the data stays static. Long-press the middle-right button to enter the settings and toggle through the different preferences. Use up/down to change current setting. Use top-left button to go back, as usual.
created by - sirtate
Description
This app simply shows the latitude and longitude of your current location. It uses httpebble, so you must have installed it on your Smartphone for this app to work.
This version of GPS Coords. is intended to serve as a template for other developers who would like to build an app which displays location data.
If you want more functionality or a nicer, cleaner way of data representation, I direct you to the parent-app called "GPS Coords."
created by - sirtate
