(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 '%smily77%') 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 watchface shows the actual altitude + time.
A small dot in the right lower corner flashes when it poll the altitude form the mobile. The sampling period is managed dynamically between 5 and 256 seconds. If you reach the maximum period it is shown in the display. Mostly this means that you are indoor and the phone get no new data from the GPS.
Update: 12/24h support
Update: - Buffer reduced in order to avoid crash using Android
- ft added for feet version
The app uses 2-way communication with httppebble.
You need to download httpebble (Katherine's iPhone app) or the Android version of it for this to work. For iPhone:
In Safari on your iPhone, go to: http://macbuildserver.com/try/
paste the following on the form: http://github.com/Katharine/httpebble-ios
Click Next a few times until the build is done
Katherine's big effort can be donated at http://cloudpebble.net, if someone wish to do so.
created by - smily77
-
Description
This watchapp shows you always automatically the local time (analog) and what time is it at home (digital window) where ever you are.
Update v1.1
Inbound buffer size reduced in order to avoid risk of crash with Android
Functions:
Middle button long -> stores your UTC offset when you are at home
Up / Down button -> Day light saving for the home time on(S)/off(W)
(The watch can't recognize if DLS switches at home when you are abroad)
The app uses 2-way communication (Storage / UTC offset) with httppebble.
You need to download httpebble (Katherine's iPhone app) or the Android version of it for this to work. For iPhone:
In Safari on your iPhone, go to: http://macbuildserver.com/try/
paste the following on the form: http://github.com/Katharine/httpebble-ios
Click Next a few times until the build is done
Katherine's big effort can be donated at http://cloudpebble.net, if someone wish to do so.
created by - smily77
-
Description
I tried to make a watchface in the style of the seventies. As it's difficult to read the exact time I added further a filed showing the time digital and the day of the month.
The watchface is based on segment six and the fonts I took from mmdumi's Phosphor (thanks) as they fit well to the style.
I used the CloudPebble as I deal with windows (thanks) - as usual it looks on the Pebble a bit different (better in my opinion)
created by - smily77
Description
Using the Kelly watchface I struggled to read it. So I made a new version where the function of the hands are exchanged
In this version the inner hand shows the minutes and the outer the hours - somehow easier to read but still the same look
created by - smily77
-
-
Description
A first go for an analog one I have no glue about programming it's an application of zalew's Maurice (thanks) done with Cloudpebble.
Perhaps not top stylish yet - I'm working on - but make usage of the pebble potential for watchmakers they don't have else
Update - background optomized
created by - smily77
-
Description
Simplicity based with Arab characters. Looks really aesthetic (better than on the picture) and is pretty fancy on the wrist. It takes a while until you can read the time but isn't at the end a big deal.
Arab figures: http://danielschereck.com/wp2002arabia/wp-arabicnumbers.htm
Update 2.2:
Little bigger characters
Alignment of the characters
leading 0 in 12h mode
created by - smily77
-
Description
This is an easy (first) application of Big Time with Roman digits. The watchface have been made with the online compiler @ cloudpebble.net , a genius tool - thanks a lot
created by - smily77
