(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 3696,56
FrenzyCon (fixed)
Description
FrenzyCon! It's the next best thing to not actually being there....kind of.
Displays date and time.
P.S. Reese Roper is not my friend.
Antonio Mail_to_SMS
Description
Warning: this one is not for the faint of heart!!!
This app (not a watchface) allows you to send texts directly from the pebble. The contacts & msgs are hardcoded in the main program. It works by sending an email (from the server that hosts the php file) to the target cellphone using cell_number@the_carrier.com (for rogers in Canada, that's like [email protected]).
To get it to work ...
1) grab a copy of the source code
2) personalize the ./src/main & ./server/mail_to_sms.php files.
3) plunk mail_to_sms.php on your webserver that supports an email account
4) pull the code into cloudpebble and compile
5) run app on watch with httpebble
Instructions:
Top right button changes "To:" selection.
Bottom right button changes "Msg:" selection.
Middle button (long press) sends msg.
Should say "Success!!" if mail_to_sms worked.
Reverts back to "SEND Y/N?" after 5 secs.
Have fun.
Cleveland Indians Digital
Description
The Block "C" Indians logo with Digital Time.
Derpy Loves You
Description
A cute Derpy watchface for any brony or pegasister out there!
Walking Dead - Season 4
Description
Inspired by the poster for Season 4 of The Walking Dead. Includes digital time and abbreviated date at bottom center.
Walking Dead - Season 3
Description
Inspired by the poster for Season 3 of The Walking Dead. Includes digital time and abbreviated date at top of display.
Walking Dead - Season 2
Description
Inspired by the poster for Season 2 of The Walking Dead. Includes analog clock in upper left, digital time and abbreviated date at bottom right.
Five Iron Frenzy (fixed)
Description
Finally a fixed version of this watchface!
Five Iron Frenzy fans, I hope you enjoy this watchface as much as I do!
Sorry if your old one wasn't working correctly.
Displays time and date.
P.S. Reese Roper is not my real friend.
Basic Analog Diagonal Mix
Description
Same basic analog watchface but diagonal and mix.
Other Versions
Go Niners (Digital Dark Date)!
Description
49er Logo Analog watchface with dark hands and date.
Deadhead Analog Dark
Description
Deadhead Logo Analog watchface with dark hands.
Eagles Analog+Digital
Description
An unofficial Pebble watch face for the Eagles!
Chunk German
Description
Made a german Version of the Chunk Weather Watchface.
httpebble is required
V1.1: small tweaks; added "." after day date
Other Versions
Chunk German - black on white
Description
black on white version of Chunk German
Other Versions
Counter
Description
A simple counter app for the Pebble smartwatch using standard system components like ActionBarLayer.
Lets's you count from -9999 to 9999
Other Versions
MtG Life Points
Description
A special version of my Counter app http://www.mypebblefaces.com/apps/8826/6390/)( that suits best for counting life points in the trading card game Magic: the Gathering. The counter starts and resets at 20 and does not permit negative numbers. The hold-to-repeat is more slowly.
Other Versions
Walking Dead
Description
Inspired by the poster for Season 1 of The Walking Dead. Includes analog clock in upper right, digital time and abbreviated date at bottom.
Zingy
Description
EDF Energy's famous Zingy tells you the time and date on your Pebble
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
Cheeky Ballmer
Description
Steve Ballmer really likes to stick his tongue out. It’s his way of showing excitement, much like dogs do when you hold the leash up and jingle your keys. Ballmer may be leaving soon, but we can all delight because his tongue will live on through this Pebble face.
The O.C Supertones
Description
Skankin' to the beat The O.C Supertones are back!
Displays date and time.
Newer Version. Date doesn't overlap.
Avionic
Description
A classic analog plus Day of Month display.
Created with http://www.watchface-generator.de
JP (Black)
Description
God creates dinosaurs. God destroys dinosaurs. God creates man. Man destroys God. Man creates dinosaurs. And I am just here, making a watchface...
Other Versions
JP (White)
Description
God creates dinosaurs. God destroys dinosaurs. God creates man. Man destroys God. Man creates dinosaurs. And I am just here, making a watchface...
Other Versions
ARD
Description
ARD are a South East England based company who look after the freshest best musical talent around.
http://www.ard-uk.org
Pasko - Countdown
Description
This is a countdown app (vs watchface) for Pasko - Philippines. It can be accessed through applications and exits through back button. An update was made to change the target hour to 0 hr instead of 12 hr.
Dot Line 3 Hands
Description
Minimalist analog design with dots and lines. Digital hour, day and date on the corners.
Win 3.1
Description
So ugly it makes it almost beautiful. Here comes the recreation of old Windows 3.1 system clock window for those who remember. Enjoy!
Created with help of http://www.watchface-generator.de
Spiral Watch (White)
Description
Time is not a straight line...
Other Versions
Spiral Watch (Black)
Description
Time is not a straight line...
Other Versions
Super Sonico
Description
A watch face to celebrate the cute and curvaceous Nitroplus company mascot Super Sonico!
Made with the help of Watchface Generator
http://www.watchface-generator.de/
Olda Robot
Description
Rob Holder [Olda Robot] is a Graphic Designer, Based in England. He’s worked for various commercial clients in England and around the globe.
Some of his Clients: Bolton Council, UCLAN Students, Colour Mi Natural, Winsford Flash Sailing Club & Represent Clothing.
His style ever changing and developing. He works with minimalism and searches for new fresh approaches to his work. His work has featured several times on Computer Arts’ Blog and Various other Publications around the world.
Mr Rootsy
Description
Mr Rootsy Pebble watch face design.
Mr Rootsy is a MA & LBMA Multi Award Nominated Artist.
#Blessed #Believe
http://www.mrrootsy.co.uk