Show filters

(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 '%CMontgomery%') 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  
  • Binary Blocks V2

    Description

    This is an update to my old app (Binary Blocks - http://www.mypebblefaces.com/apps/5650/4755/)

    It displays the time in binary, using squares to represent the hour/minutes. The left most column is the hour, the next column is the tens digit of minutes, and the righmost column is the ones digit for minutes.
    For example the time in the screenshot is:
    Hours (leftmost column) the top two boxes are marked, that means the 3rd and 4th 'bits' are active. Binary goes 1,2,4,8; since the 3rd and the 4th are lit up, that means the hour is 8+4 = 12

    Tens minute: Here the only active one is the bottom block. That's easy! Since the first 'bit' is lit, it is a 1 (remember 1,2,4,8!)

    Ones minute: This one is trickier. Here the 1st, 2nd, and 3rd 'bits' are all lit. So the time is (remember 1,2,4,8!) 1 + 2 + 4 = 7

    Add those all up and it is 12:17 :)

    That may seem like alot of work but eventually you recognize the patterns. I enjoy it as a teacher because my students see my watch and it gives them something to think about, maybe a new concept to learn!


    As of now 24 Hour mode does not work, the watch will simply display the 12 hour time.

    The watch also displays the date and day (as I often forget them). The next thing I was going to add was a vibrate on phone connection lost command.

    I hope you enjoy! If there is anything else you would like to have in a watchface let me know!

    created by - CMontgomery
  • Binary Blocks

    Description

    This is a binary clock based on the pebble developers Just a Bit watchface. I changed the circles to squares and made the time in columns instead of rows. I also saw Paul's awesome small date (from http://www.mypebblefaces.com/view?fID=1350&aName=PEP&pageTitle=Text+with+Small+ and put the date (spelled out with words) on the bottom.

    There is no support for 24 hour mode however, even if 24 hour mode is selected it will only display the time in 12 hours.

    The text looks better on the watch, I made the picture in MSPaint.

    This is my first watchface so if there is anything you think I should change/add please let me know!

    Hope you enjoy!

    V1.1: Moved the date around so the day of the month no longer gets clipped on the right side. Whoops!

    V2.0.0 Updated to SDK2 finally! (I noticed when my phone updated and my watch broke...)

    created by - CMontgomery

QR code for

Keep track of any updates for this App by signing in

×