(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 '%raj%') 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
A polar clock watchface which uses arcs to show hours and minutes. The 2.0 version is now configurable through the Pebble app to optionally show the date and/or time in text form, as well as invert the color. This "lite" watch face is less animated since it updates every minute instead of every second, and consequently it will use less battery life. For a more animated version that consumes more battery, try Polar Clock 2.0 - http://www.mypebblefaces.com/apps/20969/9703/
created by - NirajSanghvi
-
Description
A polar clock watchface which uses arcs to show hours, minutes, and seconds. The 2.0 version is now configurable through the Pebble app to optionally show the date and/or time in text form, as well as invert the color. This watch face is more animated since it updates every second, and consequently it will use more battery life. For a lightweight/less animated version, try Polar Clock Lite 2.0 - http://www.mypebblefaces.com/apps/20969/9704/
created by - NirajSanghvi
-
Description
This is the same basic "Orbits" watch face but white on a black background instead. Some people wanted this, so here it is. Personally., I think it's harder to read.
I'll post the source "soon", so others can play with it as they like.
This latest version is updated to agree with the white face version.
created by - raj
-
Description
I'm calling it "Orbits". The idea is that the planet orbits the sun every 12 hours and the little moon orbits the planet every 60 minutes. So, for example, the picture here shows the face displaying the time of 7:00.
The current version of this watchface is named "Orbits - white with numbers". There is also a black version named "orbits - black".
Thanks to Tycho for posting his code to Gatekeeper, which is what I used to get started!
created by - raj
Description
This version has month and date in the top corners and hour (24hr form) and minute in the bottom corners. I have also shortened the sun rays and have them fading out a little.
The source code is the same as the original version.
created by - raj
-
-
