(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 (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 1848,56
-
-
-
-
-
Description
This watchface shows a world map with the current sunlight coverage, along with the time and date. Watch daylight pass across the earth as the day goes by, and see how the sun hits the earth at different times of the year.
The map is redrawn every 15 minutes.
(The time and date shown on the watch are local time. To draw the map UTC time must be known, and the phone must be queried to determine which time zone the watch is in. This happens once and is automatic.)
White on black version: http://www.mypebblefaces.com/apps/18667/9175/
Source code on github: http://github.com/davidfg4/pebble-day-night
created by - davidfg4
-
-
Description
this is Indonesian translated version of foobacca's very fuzzy time watchface. the time logic also converted to indonesian ways to read a clock. now from 2 to 3 o'clock reads as follow:
dua pas
dua lebih
dua seperempat
setengah tiga kurang
setengah tiga
setengah tiga lebih
tiga kurang seperempat
tiga kurang
tiga
i change the font to bitham 24 to fit the screen, but still not satisfied yet. sorry for not having such skill on programming, this is my first watchface. need to learn to use custom font, and using two different font on same screen. and trying to display the date.
owh, it's compatible to 2.0 firmware not tested on 1.x. and also not tested on iOS.
created by - urayandro
-
Description
its a very fuzzy time from foobacca translated to Indonesian by me. the logic of the time reading is also converted to indonesian way to read a clock. now from 2 to 3 o'clock is:
dua pas
dua lebih
dua seperempat
setengah tiga kurang
setengah tiga
setengah tiga lebih
tiga kurang seperempat
tiga kurang
tiga
but so sorry i'm not having good programming skill & background so it is far from good maybe. it's my first watchface on early stage. future update hope will be a date and different fonts. still looking a way to do that.
owh, and its only 2.0 firmware compatible for now. and not tested to iOS yet (sorry for not having the apple)
created by -
-
Description
Switch your hue lights on and off using your Pebble. Requires SDK 2.0
created by - rlowe
-
Description
Digital and analogue black easy read watchface..
I think this watchface is the best one I've made.. It looks really good on the pebble :-)
created by - dazzerart
-
-
-
-
-
Description
Triumph tiger T110 watch face analogue.
created by -
-
Description
Fun watch face, with the date carefully hidden below the "8".
Enjoy!
created by -
-
-
-
-
-
-
-
-
Description
Features the Digital time, as well as the date, and Miami (OH)'s beveled M design.
created by - pinta1492
-
Description
Features the Digital time, as well as the date, and Miami (OH)'s beveled M design.
created by - pinta1492
-
Description
Features the Digital time, as well as the date, and Miami (OH)'s beveled M design.
created by - pinta1492
-
Description
Features the Digital time, as well as the date, and Miami (OH)'s beveled M design.
created by - pinta1492
-
-
Description
Join me on a magical forest adventure where monochrome fireflies dance on your wrist. Normally, the fireflies swarm and blink and dance, but every minute or so, they join together and do their best to show you the time. They hold formation for only a moment, but the effort is to great for their little wings. In their excitement, they all glow together in unison and then quickly return to their natural state.
This is the original Fireflies watchface by Nate Murray, updated for the 2.0 SDK.
created by - stibbons
-
-
-
-
-
-
-
-
-
-
-
-
-
Description
A watchface featuring Kirito from the popular anime "Sword Art Online" In front of the letters "SAO." Compatible with SDK 2.0
created by - plays2
-
-
Description
Simple watchface featuring Eren Jaeger from popular anime series Attack on Titan (Shingeki No Kyojin)
Compatible with SDK 2.0
created by - plays2
-
-
Description
SDK 2.0
- Day
- Date
- "dancing" colon
- Bluetooth Indicator
- Battery Indicator (if charging or low)
- Weather
- Temperature (my apologies if OpenWeatherMap.org gets your temp incorrect)
A simple watch face which is a heavily modified version of Simplicity. Requires no additional software besides the updated SDK 2.0 software. Tested for iOS 7.0.4 and Android 4.2.2. In future features I'd like to add, a JS configuration page, an inverted theme, and POSSIBLY a translation into other languages, maybe a better source for forecast data, as I have noticed problems with accuracy and OpenWeatherMap.org
created by - CdBot100
-
Description
This is my first game for the Pebble :D
In this game you have to guess a randomly generated number from 1 to 100 in as few tries as possible.
To select a number use the UP/DOWN buttons (you can hold them to change numbers faster) and press SELECT. Then the game will tell you if you should go higher or lower. Good luck!
This version is only compatible with the Pebble SDK 2.0 beta (tested using beta 4).
If you are using Pebble firmware 1.x please use the SDK1 version: http://www.mypebblefaces.com/apps/9628/6957/
Twitter: @dn0z
created by - dinos
-
-
-
-
Description
Michonne, my favorite character from the Walking Dead. Simple digital on white background.
created by - Rowdy
-
-
-
-
-
