(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 '%lesliesbird%') 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
Deep Thoughts by Jack Handey
Displays a random Deep Thought every minute. The up and down buttons can be used to scroll through the text on the longer quotes. Be sure to check out MoreDeepThoughts for additional quotes on original Pebble/Pebble Steel. On the Pebble Time a random color background is selected when the app is run; if you get an unreadable combination hit the BACK button and run it again.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
Description
More Deep Thoughts by Jack Handey.
I had too many deep thoughts for one watch app, so here are more. This works the same as DeepThoughts. There are a total of 89 deep thoughts here, but many of these are fairly long so it ends up about the same memory-wise.
If you have Pebble Time or Time Steel, you do not need this app as it has been consolidated with the Pebble Time version of DeepThoughts.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
-
Description
A watchface version of the Spinning Dancer Illusion. The illusion was created in 2003 by Nobuyuki Kayahara. The pirouetting figure can appear to spin in either direction, due to a lack of visual cues for depth. http://en.wikipedia.org/wiki/Spinning_Dancer for more information.
It takes practice but you will be able to make the dancer change direction. The direction of rotation depends on whether you see the foot touching the ground as the left foot or the right foot.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
-
Description
Recreates the original Boing Ball demo from the Amiga computer. The ball rotates and bounces around the screen, while the time readout is using the original Amiga Topaz font. Shake or tap the watch along the Y (negative) axis to change the pattern of the bounce. Best way is to hold the watch the way you look at it, then bring your arm abruptly towards your body.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
-
Description
Show your love for the Commodore 64, the best-selling computer model of all time, according to Guinness! 16 shades of grey revolve around the outside every second for Pebble/Pebble Steel, while the display is full color on Pebble Time/Time Steel. An actual C64 was used for reference for the creation of this watchface. The border was created using an emulator and then saved out as a frame animation.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
-
Description
Remind yourself that it's time for some Slack when you look down to see the smiling face of J.R. "Bob" Dobbs! As you watch, random images will flash on the watchface at random intervals. Or maybe you're just imagining it? Random subliminal images can now be turned OFF or ON by a tap along the Y (negative) axis. An image will show if a tap is registered.
Like my app? Feel free to support further development by throwing some Bitcoin my way: 1JbxfRpG4iv3qscRe8wgFBXbNhmPesP723
created by - lesliesbird
-
Description
A watchface version of the Spinning Dancer Illusion. The illusion was created in 2003 by Nobuyuki Kayahara. The pirouetting figure can appear to spin in either direction, due to a lack of visual cues for depth. http://en.wikipedia.org/wiki/Spinning_Dancer for more information.
It takes practice but you will be able to make the dancer change direction. The direction of rotation depends on whether you see the foot touching the ground as the left foot or the right foot.
created by - lesliesbird
-
Description
Show your love for the Commodore 64, the best-selling computer model of all time, according to Guinness! 16 shades of grey revolve around the outside every second. A pity it can't be in color.
An actual C64 was used for reference for the creation of this watchface. The border was created using an emulator and then saved out as a frame animation.
1.1 AM - PM not displaying correctly with double-digit hours - fixed.
1.2 AM - PM indicator moved to new position, time field box truncated on sides.
created by - lesliesbird
-
Description
Recreates the original Boing Ball demo from the Amiga computer. The ball rotates and bounces around the screen, while the time readout is using the original Amiga Topaz font.
Version 1.2 - BIG ball physics update - ball gains velocity as it drops, bounces much more faithful to the original.
Older version of this watchface with the pong style bounce also available.
created by - lesliesbird
-
Description
Remind yourself that it's time for some Slack when you look down to see the smiling face of J.R. "Bob" Dobbs!
For extra fun, check out the subliminal version below!
created by - lesliesbird
Description
Same as DobbsHead, except random images will flash on the watchface at random intervals. Or maybe you're just imagining it?
1.2 code optimization, added more images.
created by - lesliesbird
