(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 '%kumkee%') 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
Simple Chinese Weather
Description
Simplicity based Chinese watchface
INPORTANT:
1. in order for the weather function to work properly, you have to install a bridge agent on you phone: for example, "pebble connect" on Android, or "httpebble" on iOS.
2. in order to get your local weather status, you have to turn on your GPS when you switching to the watch face. Subsequent weather update will use the previous location when you last switch to "Simple Chinese Weather".
Featuring:
0. Current weather condition and temperature from yahoo
1. Chinese Calendar date (or you can choose not to include it by picking other sub edtion)
2. Gregorian Calendar date in Chinese
3. Day of week in Chinese
4. 24h style clock supported
5. Option to include second display
6. 8 sub watchfaces to choose
Other Versions
Simple Chinese Weather (N)
Description
without Chinese calendar date
Other Versions
Simple Chinese Weather (NS)
Description
without Chinese calendar date, but with second
Other Versions
Simple Chinese Weather (SW)
Description
with second black on white
Other Versions
Simple Chinese Weather (NW)
Description
black on white without Chinese calendar date
Other Versions
Simple Chinese Weather (NSW)
Description
black on white without Chinese calendar date, but with second
Other Versions
Simple Chinese Weather (SF)
Description
temperature in Farenheit with second displayed.
Other Versions
Simple Chinese Weather (WF)
Description
black on white temperature in Farenheit
Other Versions
Simple Chinese
Description
Simplicity based Chinese watchface
Featuring:
1. Chinese Calendar date (or you can choose not to include it by picking other sub edtion)
2. Gregorian Calendar date in Chinese
3. Day of week in Chinese
4. 24h style clock supported
5. Option to include second display
6. 8 sub watchfaces to choose
Sub edition name codes:
Standard edition: with Chinese Calendar date, white on black, without second display;
S: with second display;
N: without Chinese Calendar date;
W: black on white blackground.
Simple Chinese (NSW)
Description
black on white without Chinese calendar date, but with second
Chinese Geek
Description
Chinese (Japanese) geek watch face
Feathers:
1. Eight-Character (八字, a.k.a. Four-Column 四柱) solar clock (double-hour, date, month, and year)
2. Chinese quarter of hour (刻)
3. Yijing Hexagram (易经八卦图) as the binary representation of the 64ths of a quarter
4. Chinese traditional calendar date (农历)
5. Gregorgian year and date
6. Day of week
Warning: This is a beta version. The month and year columns of the 8-character clock have errors, but are accurate within a day.
Todo: Improve accuracy of month and year columns of the 8-character clock to minute position.
Chinese Calendar Date
Description
A simple watch face to display the current Chinese calendar date
在simplicity的基础上显示当日农历日期。
The design is based on the stock watch face Simplicity, and the calendar conversion algorithm is based on the lunar package by Fung F. Lee and Ricky Yeung (http://packages.debian.org/wheezy/lunar ).
For those who can't read Chinese, there is a version in Arabic numerals: http://www.mypebblefaces.com/apps/7079/5583/5632/
Source code is provided. If you want other related functions or designs, please write down your feature requst below.
Other Versions
Chinese Calendar Date (in numbers)
Description
A simple watch face to display the current Chinese calendar date The design is based on the stock watch face Simplicity, and the calendar conversion algorithm is based on the lunar package by Fung F. Lee and Ricky Yeung (http://packages.debian.org/wheezy/lunar). This version will display the Chinese calendar date in arabic numerals. For a Chinese caracter verison, please follow this link: http://www.mypebblefaces.com/apps/7079/5583/ Source code is provided. If you want other related functions or designs, please write down your feature requst below.