(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 '%EngineerBill%') 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
An Animated Bitmap Viewer for your Pebble Watch!
The latest offering from the Steamchest Chronicles workbench, this animated bitmap viewer allows the user to load up two sets of bitmaps and either single step through them, or run them as an animation series at any rate between two and 20 frames per second. The user can toggle between single step and animation mode, as well as between the two different image sets.
To demonstrate the Pebble's ability to multitask (and to reduce the number of program slots required) this App also includes a copy of both the Lefthanded and Righthanded versions of the SteamCab Analog Watchface.
The maximum size of images that can be included is currently limited to 64k (this is the upper limit of a program resource segment in the current version of the Pebble SDK). For demonstration purposes this version of the program has been preloaded with two series of 11 images taken from Eadweard Muybridge's groudbreaking work on image animation, including his original 1878 series "Sallie Gardner at a Gallop" (also known as "The Horse in Motion") and one of his later series of studies of the human form produced while working at the University of Pittsburgh.
As is customary for SteamCab offerings, the source code to this App is published simultaneously at Github.com. It has been extensively annotated to encourage learning and experimentation.
created by - EngineerBill
-
Description
A light-hearted but hopefully somewhat useful event-driven Pebble App. In addition to its traditional Stopwatch and Countdown Timer functions, Tempus Fugit also provides a Real Time Meeting Cost calculator and three embedded watchfaces, including two variants of the SteamCab Simple Analog Watchface, as well as the Simplicity digital display.
The Meeting Cost Calculator automatically provides the total cost of any timed event, based upon user-controlled parameters (Total Number of Attendees, Average Salary and Elapsed Time). If you prefer to see your costs rising in real time, start the function timer and your Pebble will provide you with second-by-second meeting cost updates.
Both the Stopwatch and Countdown functions include an Alert feature. sounding distinctive Vibe patterns at user-specified intervals and the distinctive Analog Watchface App can be configured to operate in either "right handed" (clockwise) or "left handed" (counterclockwise) mode.
And best of all, all four functions can operate at the same time. Yes, your Pebble can now multitask!
created by - EngineerBill
-
Description
Now with Animated Arm Motion!
Note: This is the "counterrevolutionary" version of of the Chairman Mao Analog Watchface. There is also a traditional "clockwise" version, as well...
This watchface is a whimsical revisiting of the traditional “Chairman Mao” watch, developed at the request of reddit user “saltedlolly”. It is the first example of a family Chairman Mao Analog watchfaces for the Pebble world – Wear It With Pride!
A Couple of Release Notes:
1)This Watchface is available in both Right-Handed (clockwise) and Left-Handed (counterclockwise) versions. Each has a unique UUID, which means you can install both, if you wish (search on “Chairman Mao” at the mypebblefaces.com home page);
2) This is a Mark II release – it has the Chairman Mao bitmap, as well as the animated arm motion that defines the original…
created by - EngineerBill
-
Description
Now with Animated Arm Motion!
This watchface is a whimsical revisiting of the traditional “Chairman Mao” watch, developed at the request of reddit user “saltedlolly”. It is the first example of a famkly of Chairman Mao Analog watchfaces for the Pebbl world – Wear It With Pride!
A Couple of Release Notes:
1)This Watchface is available in both Right-Handed (clockwise) and Left-Handed (counterclockwise) versions. Each has a unique UUID, which means you can install both, if you wish (search on “Chairman Mao” at the mypebblefaces.com home page);
2) This is a Mark II release – it has the Chairman Mao bitmap, as well as the animated arm motion that defines the original…
created by - EngineerBill
-
Description
Note: This is the "counterrevolutionary" version of of the Chairman Mao Analog Watchface. There is also a traditional "clockwise" version, as well...
It is a whimsical revisiting of the traditional “Chairman Mao” watch, developed at the request of reddit user “saltedlolly”. Here’s his description of the original:
“If you have ever visited China, an almost essential souvenir is the infamous Chairman Mao watch. The watch features a picture of Chairman Mao and his hand waves as it runs. It definitely falls into the so-tacky-it's-awesome camp, and is a "communist kitsch" must have! The other thing about the watches is that, being cheaply made in China, they are also almost guaranteed to break after a few days of use....”
“Living in Beijing, I have been thinking recently that it would be awesome if the watch could be recreated as a Pebble watchface. I'd love to have Mao's mug waving back at me from my Pebble. It would also be good that the damn thing doesn't break after a few days. ;)”
Well, who could resist a challenge like that? So here is a first cut at a Pebble Chairman Mao Analog watchface – Wear It With Pride!
A Couple of Release Notes:
1)This Watchface is available in both Right-Handed (clockwise) and Left-Handed (counterclockwise) versions. Each has a unique UUID, which means you can install both, if you wish (search on “Chairman Mao” at the mypebblefaces.com home page);
2) This is a Mark I release – it has the Chairman Mao bitmap, but his arm is not yet animated – Animated Arm versions are planned soon …
created by - EngineerBill
-
Description
Chairman Mao Right-Handed Analog - Mark I
This is a whimsical revisiting of the traditional “Chairman Mao” watch, developed at the request of reddit user “saltedlolly”. Here’s his description of the original:
“If you have ever visited China, an almost essential souvenir is the infamous Chairman Mao watch. The watch features a picture of Chairman Mao and his hand waves as it runs. It definitely falls into the so-tacky-it's-awesome camp, and is a "communist kitsch" must have! The other thing about the watches is that, being cheaply made in China, they are also almost guaranteed to break after a few days of use....”
“Living in Beijing, I have been thinking recently that it would be awesome if the watch could be recreated as a Pebble watchface. I'd love to have Mao's mug waving back at me from my Pebble. It would also be good that the damn thing doesn't break after a few days. ;)”
Well, who could resist a challenge like that? So here is a first cut at a Pebble Chairman Mao Analog watchface – Wear It With Pride!
A Couple of Release Notes:
1) This Watchface is available in both Right-Handed (clockwise) and Left-Handed (counterclockwise) versions. Each has a unique UUID, which means you can install both, if you wish (search on “Chairman Mao” at the mypebblefaces.com home page);
2) This is a Mark I release – it has the Chairman Mao bitmap, but his arm is not yet animated – Animated Arm versions are planned soon …
created by - EngineerBill
-
Description
The Mark II model! Now without a second hand to reduce battery drain and increase endurance!
Have you ever found yourself asking, as you leave the house and glance down at your new Pebble smart watch - "Hey, wouldn't it be nice if I had a nice, left-handed, counterclockwise analog watch face?" As a person of the Left-Handed persuasion, have you ever wondered what it would be like to have a watchface that reflects your lifestyle?
Well, your wait is over. From the folks at the SteamChest Chronicles, here is the SteamCab Left-Handed Analog Pebble Watchface - Mark I. The world's first left-handed, counterclockwise analog watch for the Pebble - wear it with Pride!
created by - EngineerBill
-
Description
Have you ever found yourself asking, as you leave the house and glance down at your new Pebble smart watch - "Hey, wouldn't it be nice if I had a nice, left-handed, counterclockwise analog watch face?" As a person of the Left-Handed persuasion, have you ever wondered what it would be like to have a watchface that reflects your lifestyle?
Well, your wait is over. From the folks at the SteamChest Chronicles, here is the SteamCab Left-Handed Analog Pebble Watchface - Mark I. The world's first left-handed, counterclockwise analog watch for the Pebble - wear it with Pride!
created by - EngineerBill
