(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 '%rfrcarvalho%') 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 builds upon the work of zonemr (Roboto + Weather) and hank (ninety_hank).
It displays the Time (12/24) in the format DD/MM/YYYY, Calendar Week, Sunset and Sunrise and the Weather (in Celsius). It communicates with the smartphone to retrieve the Weather and Timezone for your current location.
You need to have the httpebble app installed on your phone for the weather/link notification to function.
Changes:
V1.1 - Solve issue with repeating º symbol after several Weather updates.
V1.2 - Added 24H and PM image for a better 12/24 hour support.
V1.3 - Changed APP_ID so it's no longer incompatible with the other Watchfaces that use httpebble (thanks to mstandfield).
V1.4 - Added Missed Calls and Unread SMS. This is based on the "Futura Weather" watchface and requires the "Pebbler" app v2.0.0 or newer (http://play.google.com/store/apps/details?id=com.bg.pebbler) and at the moment this only exists for Android. The indicator for missed calls doesn't seem to be working at the moment but unread SMS should be OK.
V1.5 - Solved Issue with Sunrise/Sunset not being calculated.
V1.6 - Changed weather server to http://ofkorth.net/pebble/weather.php (thanks to noVo)
V1.7 - Changed weather server (Thanks to orviwan)
created by - rfrcarvalho
Description
This watchface builds upon the work of zonemr (Roboto + Weather) and hank (ninety_hank).
It displays the Time (12/24) in the format MM/DD/YYYY, Calendar Week, Sunset and Sunrise and the Weather (in Celsius). It communicates with the smartphone to retrieve the Weather and Timezone for your current location.
You need to have the httpebble app installed on your phone for the weather/link notification to function.
Changes:
V1.1 - Solve issue with repeating º symbol after several Weather updates.
V1.2 - Added 24H and PM image for a better 12/24 hour support.
V1.3 - Changed APP_ID so it's no longer incompatible with the other Watchfaces that use httpebble (thanks to mstandfield).
V1.4 - Added Missed Calls and Unread SMS. This is based on the "Futura Weather" watchface and requires the "Pebbler" app v2.0.0 or newer (https://play.google.com/store/apps/details?id=com.bg.pebbler) and at the moment this only exists for Android. The indicator for missed calls doesn't seem to be working at the moment but unread SMS should be OK.
V1.5 - Solved Issue with Sunrise/Sunset not being calculated.
V1.6 - Changed weather server to https://ofkorth.net/pebble/weather.php (thanks to noVo)
V1.7 - Changed weather server (Thanks to orviwan)
created by - rfrcarvalho
Description
This Wathface is only for users that don't have the latest httpebble that allows for different APP_IDs.
Note:
This Watchface is incompatible with all the ones that use httpebble so as soon as you install one of those, it uninstalls this one.
At the moment only people using iOS are having problems with the normal versions.
If you are using Android and you are having problems with the normal versions, please update httpebble to the latest version.
V1.6 - Changed weather server to https://ofkorth.net/pebble/weather.php (thanks to noVo)
V1.7 - Changed weather server (Thanks to orviwan)
created by - rfrcarvalho
Description
This Wathface is only for users that don't have the latest httpebble that allows for different APP_IDs.
Note:
This Watchface is incompatible with all the ones that use httpebble so as soon as you install one of those, it uninstalls this one.
At the moment only people using iOS are having problems with the normal versions.
If you are using Android and you are having problems with the normal versions, please update httpebble to the latest version.
V1.6 - Changed weather server to https://ofkorth.net/pebble/weather.php (thanks to noVo)
V1.7 - Changed weather server (Thanks to orviwan)
created by - rfrcarvalho
Description
This watchface builds upon the work of zonemr (Roboto + Weather) and hank (ninety_hank).
It displays the Time (12/24) in the format MM/DD/YYYY, Calendar Week, Sunset and Sunrise and the Weather (in Fahrenheit). It communicates with the smartphone to retrieve the Weather and Timezone for your current location.
You need to have the httpebble app installed on your phone for the weather/link notification to function.
Changes:
V1.1 - Solve issue with repeating º symbol after several Weather updates.
V1.2 - Added 24H and PM image for a better 12/24 hour support.
V1.3 - Changed APP_ID so it's no longer incompatible with the other Watchfaces that use httpebble (thanks to mstandfield).
V1.4 - Added Missed Calls and Unread SMS. This is based on the "Futura Weather" watchface and requires the "Pebbler" app v2.0.0 or newer (https://play.google.com/store/apps/details?id=com.bg.pebbler) and at the moment this only exists for Android. The indicator for missed calls doesn't seem to be working at the moment but unread SMS should be OK.
V1.5 - Solved Issue with Sunrise/Sunset not being calculated.
V1.6 - Changed weather server to https://ofkorth.net/pebble/weather.php (thanks to noVo)
V1.7 - Changed weather server (Thanks to orviwan)
created by - rfrcarvalho
