(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 '%MikeM%') 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
Based upon revolution watch but with added features of Stopwatch, YachtTimer, Countdown and Minute adjust mode for countdown.
Another demonstration of how Yachtimer model can be added to watches. Now working on a modular controller for Yachtimer toolkit. To make it even easier to add functionality. Sections changed are pretty clear and will be looking to spin out.
Big thanks for Douwe Maan for starting point.
created by - MikeM
-
Description
Classic Studio Watch based on design created by Dale Perkel and Phillipe Hagege. This one though has multi mode of stopwatch, yachtimer, countdown as well as watch. use down to switch modes, up to reset select to start/stop.
1.1 Adds new mode for adjusting countdown time use select -1 minute up +1 minute.
1.2 Now stop watch removes am/pm and sets to 0 if configured in 12 hour mode.
2.0 SDK 2.0 Compatible
created by - MikeM
-
Description
Same basis as my previous Stopwatch, Yachtimer, Countdown. Not yed adjustable yet so 10 minute countdown. With analog face.
Made full screen, added date and watch mode as you toggle mode (down button) icon appears briefly to tell you the mode.
Demonstrates how to replace a watch in codebase with core yachtimer logic.
created by - MikeM
-
Description
Multi mode app supports
1: Yachtimer start sequence.
2. Countdown.
3. Stopwatch, lap times etc.
4. Countdown adjust (Hours, Minutes, Seconds)
5. Watch (time, data plus running mode that Stopwatch etc was started in).
6. In clock mode up/down inverts watch face.
Press Select long time to switch mode.
created by - MikeM
-
Description
Based upon revolution watch but with added features of Stopwatch, YachtTimer, Countdown and Minute adjust mode for countdown.
Another demonstration of how Yachtimer model can be added to watches. Now working on a modular controller for Yachtimer toolkit. To make it even easier to add functionality. Sections changed are pretty clear and will be looking to spin out.
Big thanks for Douwe Maan for starting point.
SDK 2.0 versions available here: http://www.mypebblefaces.com/apps/1164/7339/
created by - MikeM
-
Description
Classic Studio Watch based on design created by Dale Perkel and Phillipe Hagege. This one though has multi mode of stopwatch, yachtimer, countdown as well as watch. use down to switch modes, up to reset select to start/stop.
1.1 Adds new mode for adjusting countdown time use select -1 minute up +1 minute.
1.2 Now stop watch removes am/pm and sets to 0 if configured in 12 hour mode.
SDK 2.0 Compatible versions available here: http://www.mypebblefaces.com/apps/1164/7334/
created by - MikeM
-
Description
Same basis as my previous Stopwatch, Yachtimer, Countdown. Not yed adjustable yet so 10 minute countdown. With analog face.
Made full screen, added date and watch mode as you toggle mode (down button) icon appears briefly to tell you the mode.
Demonstrates how to replace a watch in codebase with core yachtimer logic.
Version compatible with SDK 2.0 available here: http://www.mypebblefaces.com/apps/1164/7298/
created by - MikeM
-
Description
Multi mode app supports
1: Yachtimer start sequence.
2. Countdown.
3. Stopwatch, lap times etc.
4. Countdown adjust (Hours, Minutes, Seconds)
5. Watch (time, data plus running mode that Stopwatch etc was started in).
6. In clock mode up/down inverts watch face.
Press Select long time to switch mode.
SDK 2.0 versions available here http://www.mypebblefaces.com/apps/1164/7283/
Version 5.0 complete rewrite. Segregating Model from view and controller for anyone interested in the code. Allowing logic to be added to any other watch easily.
Stopwatch and countdowns now go up to 7 days. Watch shows stopwatch/countdown that was started. Countdown now vibrates at significant times i.e. hours, 10 minutes, 5 minutes, every minute, every 30 seconds, every 10 seconds and every 5 seconds. With special vibration at 0. Countdown then switch over to stoppwatch measuring from time countdown finished.
created by - MikeM
