(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 '%elitemrp%') 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
Simple SOS morse code distress signal app for Pebble.
It will flash and/or vibrate to the SOS morse code signal
(. . . - - - . . .)
Press Select to start and stop.
Press Up button to toggle the back light.
Press Down to toggle vibration.
created by - elitemrp
-
Description
Peb-L-Sketch app inspired by an Etch-a-Sketch.
Use the Up and Down arrows to draw on the screen. To change to Right and Left press the middle select button to swap the orientation (Up becomes Right, Down becomes Left). You can now also draw angles by switching to Diagonal mode. To switch to diagonal mode simply press and hold the Select button until the orientation indicator shows diagonal arrows. To go back to normal mode just press and hold Select again.
To start over simply Back out of the app and go back in.
My Peb-L-Sketch watchface is also available at
http://www.mypebblefaces.com/view?fID=736&aName=elitemrp&pageTitle=Peb-L-Sketch
- Version 1.3 released May 30, 2013: Fixed bug where Peb-L-Sketch App would hang and then cause PebbleOS v1.11 to crash (bug doesn't affect older versions of PebbleOS). Also compiled with the latest SDK (v1.1).
-Version 1.2 released April 20, 2013: Fixed bug that was causing dots to appear on the right side of the sketch area. Also some memory optimization.
- Version 1.1 released April 20, 2013: Added diagonal mode and instruction screen (goes away automatically after 10 seconds or when a button is pressed)
created by - elitemrp
-
-
Description
Quadrants is a simple watch face that divides the time and date into quadrants. The top two squares contain the current hour and the lower two contain the minutes. The center is divided into additional quadrants for the date with the top two being the month and the bottom being the day.
- Version 1.1 released April 18, 2013: Fixed blank display on startup where only the grid was showing until the time and date loaded.
created by - elitemrp
-
Description
Quadrants is a simple watch face that divides the time and date into quadrants. The top two squares contain the current hour and the lower two contain the minutes. The center is divided into additional quadrants for the date with the top two being the month and the bottom being the day.
- Version 1.1 released April 18, 2013: Fixed blank display on startup where only the grid was showing until the time and date loaded.
created by - elitemrp
