(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 '%Niknam%') 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
Futura Weather 2 (Celsius)
Description
Modification of 'Roboto + Weather' by Martin Rosinski.
Features:
- Location-based weather information from Yahoo! Weather (updates every 15 minutes)
- Phone disconnection alert
- Stale weather information indicator
- 12h/24h support
Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from:
- Standard: Phone link monitor + vibration alert
- No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently
- No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either
More info about features and functionality can be found here: http://github.com/Niknam/futura-weather
INSTALLATION NOTES
For the weather notifications to work you need to have an httpebble app installed on your device.
Android users:
Download and install "Pebble Connect" from Google Play:
http://play.google.com/store/apps/details?id=com.lukekorth.httpebble
iOS users:
Download and install "httpebble" from the App Store: http://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8
HELP A STUDENT OUT
The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only).
If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you!
http://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6
Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Futura Weather 2 (Celsius, no vibration alert)
Description
Modification of 'Roboto + Weather' by Martin Rosinski. Features: - Location-based weather information from Yahoo! Weather (updates every 15 minutes) - Phone disconnection alert (no vibration, icon only) - Stale weather information indicator - 12h/24h support Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from: - Standard: Phone link monitor + vibration alert - No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently - No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either More info about features and functionality can be found here: https://github.com/Niknam/futura-weather INSTALLATION NOTES For the weather notifications to work you need to have an httpebble app installed on your device. Android users: Download and install "Pebble Connect" from Google Play: https://play.google.com/store/apps/details?id=com.lukekorth.httpebble iOS users: Download and install "httpebble" from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8 HELP A STUDENT OUT The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only). If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you! https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6 Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Futura Weather 2 (Celsius, no phone link monitor)
Description
Modification of 'Roboto + Weather' by Martin Rosinski. Features: - Location-based weather information from Yahoo! Weather (updates every 15 minutes) - Stale weather information indicator - 12h/24h support Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from: - Standard: Phone link monitor + vibration alert - No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently - No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either More info about features and functionality can be found here: https://github.com/Niknam/futura-weather INSTALLATION NOTES For the weather notifications to work you need to have an httpebble app installed on your device. Android users: Download and install "Pebble Connect" from Google Play: https://play.google.com/store/apps/details?id=com.lukekorth.httpebble iOS users: Download and install "httpebble" from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8 HELP A STUDENT OUT The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only). If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you! https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6 Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Futura Weather 2 (Fahrenheit)
Description
Modification of 'Roboto + Weather' by Martin Rosinski. Features: - Location-based weather information from Yahoo! Weather (updates every 15 minutes) - Phone disconnection alert - Stale weather information indicator - 12h/24h support Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from: - Standard: Phone link monitor + vibration alert - No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently - No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either More info about features and functionality can be found here: https://github.com/Niknam/futura-weather INSTALLATION NOTES For the weather notifications to work you need to have an httpebble app installed on your device. Android users: Download and install "Pebble Connect" from Google Play: https://play.google.com/store/apps/details?id=com.lukekorth.httpebble iOS users: Download and install "httpebble" from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8 HELP A STUDENT OUT The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only). If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you! https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6 Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Futura Weather 2 (Fahrenheit, no vibration alert)
Description
Modification of 'Roboto + Weather' by Martin Rosinski. Features: - Location-based weather information from Yahoo! Weather (updates every 15 minutes) - Phone disconnection alert (no vibration, icon only) - Stale weather information indicator - 12h/24h support Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from: - Standard: Phone link monitor + vibration alert - No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently - No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either More info about features and functionality can be found here: https://github.com/Niknam/futura-weather INSTALLATION NOTES For the weather notifications to work you need to have an httpebble app installed on your device. Android users: Download and install "Pebble Connect" from Google Play: https://play.google.com/store/apps/details?id=com.lukekorth.httpebble iOS users: Download and install "httpebble" from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8 HELP A STUDENT OUT The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only). If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you! https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6 Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Futura Weather 2 (Fahrenheit, no phone link monitor)
Description
Modification of 'Roboto + Weather' by Martin Rosinski. Features: - Location-based weather information from Yahoo! Weather (updates every 15 minutes) - Stale weather information indicator - 12h/24h support Futura Weather 2 comes in separate Celsius/Fahrenheit versions. Also, there are three different variations to choose from: - Standard: Phone link monitor + vibration alert - No vibration alert: Works like the standard version except that it does not vibrate upon phone disconnections and also pings the phone less frequently - No phone link monitor: This version does not check for phone disconnections at all, and thus does not ping the phone either More info about features and functionality can be found here: https://github.com/Niknam/futura-weather INSTALLATION NOTES For the weather notifications to work you need to have an httpebble app installed on your device. Android users: Download and install "Pebble Connect" from Google Play: https://play.google.com/store/apps/details?id=com.lukekorth.httpebble iOS users: Download and install "httpebble" from the App Store: https://itunes.apple.com/app/httpebble/id650174711?l=en&mt=8 HELP A STUDENT OUT The weather requests made from the previous versions of this watchface were funded straight from my own pocket. The monthly bills from the service provider were great blows to my student budget, to say the least ($430 for July only). If you are enjoying Futura Weather, please consider donating the amount of your choice to cover the expenses I've had in the past. If I, by any chance, will receive more than I have spent, I will remove the donation link below and donate the surplus to charity. Thank you! https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=SELDPV4T45FK6 Also check out Futura For Pebbler (Android only): http://www.mypebblefaces.com/apps/3775/3903/
Swedish TextWatch
Description
Modification of 'TextWatch' by mmdumi. Translated to Swedish.
Special features:
- Displays "midnatt" at midnight and "lunch" at noon
- Displays "noll" before the minute, if under 10 minutes into the hour (e.g. "fem noll nio")
Note that this is a direct translation, i.e. not always consistent with how you would normally tell time in Swedish. This is mainly due to maintaing the clean aesthetics. It would look messy if changing the position of the hour, which would have been the case at certain times, e.g. when displaying "kvart över tre".