(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 '%Benkhoo%') 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
Note: httPebble is required!
This is a updated world time watch face that supports many time zones including zones that are in 0.5 hours or 0.75 hours difference.
- More focus has been placed on the local time making it easier to see. More emphasis has been placed on the hour difference of the city as the minutes generally follows the local time.
- An indicator at the bottom of the city reflects the previous or next day difference between the city and the local time.
- The watch face would automatically switch between white and black backgrounds to indicate the day/night status of the city.
Just setup the required timezones in http://www.setPebble.com and switch to the watch face. Give it about 15 seconds for the watch face to set itself up. If there are problems, ensure that your httPebble bridge is connected.
created by - Benkhoo
-
Description
NOTE: You need httPebble for this to work! We also do not support DST at this stage. Please adjust the offset on your own!
A Simple Timezone application based of inspiration from http://bitbucket.org/hudson/pebble/src/8979393cfa2a/timezones and http://gist.github.com/matthewtole/6003318. You can set your own City labels (3 characters only!) and UTC offsets (from 12 to -12). The app will calculate everything else for you. The timezones defaults to UTC/SGP/SFO if something goes wrong trying to communicate with the http server.
After logging into setPebble, setup the watch face at
http://setpebble.com/set?app=13
(Please set it up correctly as i do no error checking.)
When the watch face starts, it will fetch the UTC offset based on httPebble of your phone. After which it will retrieve your settings from setPebble.com and display the timezones that you have setup. (give it about 30 seconds)
To make the watch face try fetch the settings again, just restart the watchface.
12/24 hour setting is supported.
Also check out a newer version available here ( http://www.mypebblefaces.com/concepts/9259/6869/ )
created by - Benkhoo
