(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 '%bert%') 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
Packers G Face
Description
Green Bay Packers "G" logo watch face with digital time and date.
Other Versions
Packers Analog
Description
Analog watch on the Green Bay Packers text logo.
Other Versions
Packers G white
Description
Green Bay Packers "G" logo, white
Other Versions
Sickbeard
Description
Show your recent Sickbeard downloaded and upcoming shows on your Pebble.
It is required that your Sickbeard is reachable through the internet. (So that the watchface can be updated when on 3G)
Get your Sickbeard API key from "general > config" in Sickbeard
Set your Sickbeard address and api key in the configuration screen.
PebbleTV
Description
PebbleTV Shows upcoming tv shows you're following on trakt.tv on your pebble.
Set your Trakt username in the configuration screen.
The watchface shows a bluetooth icon top-left when connected.
Battery charge is shown top-right
When the pebble gets connected to your phone it wil vibrate 2 times, when disconnected it will vibrate 3 times.
Note: disable "Protect my data" on trakt.tv settings, otherwise the watchface can't retrieve anything.
Want to donate for this watchface?
LTC: LUSCQzTPtJqGxXnT6dDcwX6q4WRx8C3k79
BTC: 19eedmhy2uRTkPRJtzcbkC9UnLQxHXjnay
Superman/Batman
Description
Watch face with digital date, digital time, and Superman/Batman logo.
A combination from GobraKi and myself.
Pebble Version 1.x.x Compatible
Superman Classic
Description
Watch face with digital date, digital time, and Superman logo.
Pebble Version 1.x.x Compatible
Apple Think Different
Description
Watch face with digital date, digital time, and Apple Logo.
Pebble Version 1.x.x Compatible
Wrecking Ball
Description
Watch face with digital date, digital time, and Miley Cyrus on a Wrecking Ball! Ha!
Pebble Version 1.x.x Compatible
The Wolverine
Description
Watch face with digital date, digital time, and The Wolverine.
Pebble Version 1.x.x Compatible
All Your Base 03
Description
Classic "All Your Base Are Belong To Us" saying watch face.
Pebble Version 1.x.x Compatible
All Your Base 02
Description
Classic "All Your Base Are Belong To Us" saying watch face.
Pebble Version 1.x.x Compatible
All Your Base 01
Description
Classic "All Your Base Are Belong To Us" saying watch face.
Pebble Version 1.x.x Compatible
Happy Holidays
Description
Watch face with digital date, digital time, and holiday lady.
Pebble Version 1.x.x Compatible
Nerd Herd
Description
Watch face with digital date, digital time, and Nerd Herd logo from Chuck.
Pebble Version 1.x.x Compatible
NOS
Description
Watch face with digital date, digital time, and NOS logo.
Pebble Version 1.x.x Compatible
ND Logo
Description
Watch face with digital date, digital time, ND logo, and "Fighting Irish" text.
Pebble Version 1.x.x Compatible
RVCA
Description
Watch face with digital date, digital time, and RVCA logo.
Pebble Version 1.x.x Compatible
FBI
Description
Watch face with analog time, and FBI logo as watch face.
Pebble Version 1.x.x Compatible
Deadpool
Description
Watch face with date, analog time, and Deadpool logo as watch face.
Pebble Version 1.x.x Compatible
Pip Boy 100
Description
A Pebble watchface inspired by Fallout’s Pip Boy.
Lef-top shows the date.
Right-top shows battery charge.
Middle “VaultBoy” shows bluetooth connection. (images changes depending on the connection state)
When the connection state changes the Pebble will vibrate.
The watchface uses the accelerometer and with certain movements you will gain experience points and you can level up.
You can shake your Pebble to get the current weather shown.
Your experience points will be saved on the Pebble so you can safely switch watchfaces without losing your experience.
Want to donate for this watchface?
LTC: LUSCQzTPtJqGxXnT6dDcwX6q4WRx8C3k79
BTC: 19eedmhy2uRTkPRJtzcbkC9UnLQxHXjnay
Big MOD
Description
Big MOD is a modification by Albert Rojo (@albertrojo) based on the Big Time watch by Pebble Technologies.
I just wanted to use my favourite fat type MOD (http://fontfabric.com/mod-font/) for this futuristic watchface.
All programming credits go to Pebble Technologies.
Big iOS 7
Description
It's time to make your Pebble look like your favourite mobile operating system, iOS 7 by Apple.
Big iOS 7 is a modification by Albert Rojo (@albertrojo) based on the Big Time watch by Pebble Technologies.
All programming credits go to Pebble Technologies.
iOS 7 and Apple are registered trademarks of Apple Computer inc.
Big iOS 7 White
Description
It's time to make your Pebble look like your favourite mobile operating system, iOS 7 by Apple. Big iOS 7 White is a modification by Albert Rojo (@albertrojo) based on the Big Time watch by Pebble Technologies. All programming credits go to Pebble Technologies. iOS 7 and Apple are registered trademarks of Apple Computer inc.
Big iOS 7 (leading zero)
Description
It's time to make your Pebble look like your favourite mobile operating system, iOS 7 by Apple. Big iOS 7 (leading zero) is a modification by Albert Rojo (@albertrojo) and Maurice (@Maurice_vB) based on the Big Time watch by Pebble Technologies. This version of Big iOS 7 has a leading zero on hour times with just one number. All programming credits go to Pebble Technologies. iOS 7 and Apple are registered trademarks of Apple Computer inc.
Big iOS 7 White (leading zero)
Description
It's time to make your Pebble look like your favourite mobile operating system, iOS 7 by Apple. Big iOS 7 White (leading zero) is a modification by Albert Rojo (@albertrojo) and Maurice (@Maurice_vB) based on the Big Time watch by Pebble Technologies. This version of Big iOS 7 White has a leading zero on hour times with just one number. All programming credits go to Pebble Technologies. iOS 7 and Apple are registered trademarks of Apple Computer inc.
Big Bariol
Description
Big Bariol is a modification by Albert Rojo (@albertrojo) based on the Big Time watch by Pebble Technologies.
I just wanted to use my favourite type Bariol Light (http://www.bariol.com) for this smartwatch.
All programming credits go to Pebble Technologies. I just did some mods on the resource files.
Arsenal
Description
Simple watch face with a classic version of the Arsenal cannon. Come on you Gunners!!!
TextWatch SK
Description
Text Watch in Slovak language - with accented characters.
This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...).
Variant tags:
- N = no hourly vibrations
- C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours)
- U = no animation
- R = reverse colours
v1.0
+ added vibration every hour
+ added more watchface variants
v0.5
+ added animations from PebbleTextWatch
+ created alternative without animations
v0.4
- slightly bigger fonts
v0.3 changes
- fixed declension near number 4 (štyri minút -> štyri minúty)
v0.2 changes:
- new menu icon
- some text changes to limit empty spaces and lines
- basic declension
- now using SDK 1.1
- reduction of needed font characters (the size was cut in a half)
TextWatch SK N
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK U
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK R
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK C
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NU
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK CR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK UR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
TextWatch SK NUR
Description
Text Watch in Slovak language - with accented characters. This is a watchface in development but it should work without any problems - in case there are some, please, report them to me (use comments, send me an email...). Variant tags: - N = no hourly vibrations - C = more complex vibrations (short beep = 1, long beep = 5, long short short = 7 hours) - U = no animation - R = reverse colours v1.0 + added vibration every hour + added more watchface variants v0.5 + added animations from PebbleTextWatch + created alternative without animations v0.4 - slightly bigger fonts v0.3 changes - fixed declension near number 4 (štyri minút -> štyri minúty) v0.2 changes: - new menu icon - some text changes to limit empty spaces and lines - basic declension - now using SDK 1.1 - reduction of needed font characters (the size was cut in a half)
ONE
Description
The ONE watch face to use every day when you *don't* need to show off to your friends. A simple and highly readable analog watch, with a large day and date that will never be obscured by the hands, plus optional battery and bluetooth indicators, and inverted colors. It can even buzz if you lose your phone!