(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 '%drwrose%') 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
This is the same as http://www.mypebblefaces.com/apps/4412/4216/ , but I uploaded this SDK v1 build again as a separate entry because the site's built-in search has trouble finding it as a sub-face of the SDK 2.0 entry.
This version has fully-functioning chronograph (stopwatch) hands. Press the "up" button to start/stop the chronograph. While it is running, press the "down" button to freeze the lap time and again to release it. When it is not running, press and hold the "down" button to reset the chronograph time to zero.
Note that this is compiled as a watch app, not as a normal watch face, so it appears in the watch menu.
created by - drwrose
-
Description
This is the same as http://www.mypebblefaces.com/apps/4412/5630/ , but I uploaded this SDK v1 build again as a separate entry because the site's built-in search has trouble finding it as a sub-face of the SDK 2.0 entry.
The hours are indicated by the particular Doctor shown. The minutes are shown in the lower right.
A spinning TARDIS animation introduces the watchface when it is selected, and it also reappears (or one of a couple of other cute animations) at the top of each hour to transition between Doctors.
created by - drwrose
-
-
-
-
Description
This needed to exist in the world, so I made it.
The hours are indicated by the particular Doctor shown. The minutes are shown in the lower right.
A spinning TARDIS animation introduces the watchface when it is selected, and it also reappears (or one of a couple of other cute animations) at the top of each hour to transition between Doctors.
Battery and bluetooth indicators are included, and a day/date display can be enabled and in the language of your choice.
Also available on the Pebble App Store: http://apps.getpebble.com/applications/529997b1e627ceb4e200005a
created by - drwrose
-
-
-
Description
A fancy Chronograph-style watch, with a second hand.
This app has fully-functioning chronograph (stopwatch) hands. Press the "up" button to start/stop the chronograph. While it is running, press the "down" button to freeze the lap time and again to release it. When it is not running, press and hold the "down" button to reset the chronograph time to zero. The chronograph time is preserved (and the chronograph continues to run) even while the app isn't active.
You can also press the "select" (center) button to show the running chronograph time, and the past four lap times, in a convenient and easy-to-read digital display.
The left subdial shows the seconds of the time-of-day (it's part of the main watch time, not related to the chronograph function). The right subdial shows the chronograph minutes elapsed, up to 30.
The bottom subdial shows chronograph tenths-of-a-second by default, but it can also be configured to show chronograph hours elapsed (up to 12).
As with all of the Rosewrights, battery and bluetooth indicators are included, and day and/or date display can be enabled and in the language of your choice.
Also available on the Pebble App Store: http://apps.getpebble.com/applications/529993a5e627cef6e100004b
Also check out the other faces in the Rosewright family: http://www.mypebblefaces.com/?orderBy=pebble_likes_desc&query=rosewright&pebble
created by - drwrose
Description
This is a separate build of the Rosewright Chronograph that is compiled as a Watchface, rather than an app. This means the buttons are non-functional and the Chronograph feature cannot be used, but it can be installed and set as a regular watchface to tell the time.
Install the other version of this app if you wish to use the stopwatch feature.
created by - drwrose
-
-
