(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 1568,56
Perspective
Description
Standard Version: Allways White on Black.
Night Mode Version: screen switches to Black on White between 6PM and 8AM.
Both have been compiled using SDK 2.0b6, so it may not work with previous versions of the firmware.
Here's a proof of concept to see what's possible with the Pebble ARM processor that may remind some of you of the good ol'time of demos on Amiga :)
The time is displayed using small dots in a 3D fashion.
The screen refreshes 10 times per second using the accelerometer to rotate the displayed time depending on your movements. Yes, this is surely a battery-sucker!
And for those who are curious, it uses real 3D projection.
Other Versions
Perspective Night Mode
Description
Standard Version: Allways White on Black. Night Mode Version: screen switches to Black on White between 6PM and 8AM. Both have been compiled using SDK 2.0b6, so it may not work with previous versions of the firmware. Here's a proof of concept to see what's possible with the Pebble ARM processor that may remind some of you of the good ol'time of demos on Amiga :) The time is displayed using small dots in a 3D fashion. The screen refreshes 10 times per second using the accelerometer to rotate the displayed time depending on your movements. Yes, this is surely a battery-sucker! And for those who are curious, it uses real 3D projection.
Other Versions
420 smoke break
Description
Update: Added everyone's favorite leaf as a background to the analog clock. PUFF PUFF PASS...
This stoner friendly watchface uses the simple analog clock without a second hand. At 4:20pm, a 'special' message pops up with picture of a pot leaf and the watch also vibrates to alert the user its toking time..
Other Versions
The Verge
Description
Here is a watch face for all the Verge readers out there, Verge logo with time and date.
Ford Mustang
Description
Ford Mustang Logo with digital time.
#TeamMustang ? Follow me on twitter!
@Irish116_
White Pixels
Description
An inverted and enlarged version of the watchface "Pixel Array" ( http://www.mypebblefaces.com/apps/21/44/ ) by Jdiez17 ( http://jdiez.me )
E8N
Description
This watchface was inspired by the E8 watch from Lexon, originally designed by Brieuc du Roscoät.
From left to right, the first column represents the ten of the hours, the second column represents the one of the hours, the third represents the ten of the minutes, the fourth represents the one of the minutes.
On the example, it is 8:55 and 8:56
You can find the negative of this watchface here :
http://www.mypebblefaces.com/apps/13465/8137/
Flight2
Description
Same as Flight inverse. Hands modified. Simple analog with easy to read face.
Thanks to http://www.watchface-generator.de/
M2
Description
University of Michigan style M on black background, with stadium time and date. Generated for SDK 2.0.
Other Versions
M2 w/ Indicators
Description
Same as M2 but adds Bluetooth and Battery indicators.
Other Versions
Orbit
Description
Watchface celebrating planetary orbit. Configurable to include a random starfield background.
Requires firmware version 2.
QR Rick Roll
Description
Show how high tech you are, then rick roll your friends.
Green Lantern Logo
Description
Watchface for the Green Lantern fan.
Watchface created via watch face-generators.de
Portland Trail Blazers
Description
Watchface showing your love for the Portland Trail Blazers NBA basketball team.
Sleep Mode
Description
This watchface has no indication of date, time, status' or anything. It is a static watchface that will not refresh the display. This allows for using the watch while you are sleeping and still have the notification or alarm functions of the watch.
Dialetto Veneto
Description
Divertente orologio testuale in dialetto veneto.
Basato su FuzzyIta di chrispazz http://www.mypebblefaces.com/apps/12994/8165/
Decimal
Description
Simple analog helps calculate decimal time (for time cards, and using mathematical operations with time).
With decimal time you can easily calculate your pay by simply multiplying the decimal time by the hours worked (it's much easier to multiply 1.5 hours than 1 hour and 30 minutes.) Also calculate worked ours (Simply subtract time started, 0.5 (12:30) from time finished, 8.9 (8:54) = 8.4 hours times $10/hr = $84.00) Operations will be easier, of course, if you use 24 or military time, which doesn't usually require a calculator.
The outside ring shows the hour split into tenths, 1:15 is 1.25, 1:20 is about 1.35, etc. The dots are at intervals of 0.025.
Thanks to http://www.watchface-generator.de
Kylie Minogue
Description
Kylie Minogue digital watch face
Other Versions
Kylie Minogue V2.0
Description
Kylie Minogue digital watchface
Other Versions
Funivia Digital
Description
Funivia, Seilbahn, Cablecar, Ropeway... simple but funny
Funivia Analog
Description
Funivia, Seilbahn, Cablecar, Ropeway... simple but funny
Text Watch Ru
Description
Текстовые часы, русские, прошивка 2.x
Индикация соединения с телефоном, индикация батареи, вибро при подключении/отключении к телефону, день недели и дата, анимация, интегрированы шрифты (должно работать и на неруссифицированных прошивках), добавлены статусы соединения и батареи
При разработке использовались "24 Hour Text Watch" и Timely
Simptastic Flat 2
Description
The normal (date in US) version of my watchface "simptastic flat 2" I hope you like it!
If you want me to add or change something, please leave a comment below or contact me on Twitter: http://twitter.com/mtttst/
(This is for FW2.0 only!)
Simptastic Flat 2 (German Date Version)
Description
The german date version of my watchface "simptastic flat 2". I hope you like it! If you want me to add or change something, please leave a comment below or contact me on Twitter: http://twitter.com/mtttst/ (This is for FW2.0 only!)
Simptastic Flat 2 w/o date
Description
The normal version of my watchface "simptastic flat 2", but without date. I hope you like it! If you want me to add or change something, please leave a comment below or contact me on Twitter: http://twitter.com/mtttst/ (This is for FW2.0 only!)
BostonBruins
Description
A watch face for all the Boston Bruins fans out there. :D
#BruinsFam follow me on twitter @Irish116_
Delay Calculator
Description
This app is for musicians, sound engineers, or anyone else that works with music.
This app allows you to quickly calculate delay times based on the beat that you click in with the middle button. You will get the ms. values for the quarter note, eighth note, and dotted eighth note.
Thanks to my buddy Jon Dayton from the blog, Smart2Noise Ratio, for the idea! http://smart2noise.blogspot.com
PebbleFormulas
Description
A quick convenient way to access many formulas for Algebra, Geometry, Trigonometry, Calculus, Biology, Physics, Chemistry, Conversions, and electricity! Updates will be common, adding new features, formulas, and surprises!
Smart Square
Description
A modified WordSquare watch face to support tap gestures for displaying basic info.
Bluetooth = "X" at the bottom of the screen if disconnected
Battery level = Squares on the right side of the screen
Day of the month = Digits at the left side of the screen
Some settings are configurable via the Pebble phone app.
Text Watch with Small Full Date [Inverted] [2.0]
Description
This is an inverted tweak on the Text Watch, it now reads full date in a small font in the bottom right corner. There are also versions of this with (o') and (oh) added before minutes one through nine.
The non-inverted version can be found here:
http://www.mypebblefaces.com/apps/94/9459
Text Watch with Small Full Date (o') [Inverted] [2.0]
Description
This is an inverted tweak on the Text Watch, it now reads full date in a small font in the bottom right corner. There are also versions of this without (o') and one with (oh) added before minutes one through nine. The non-inverted version can be found here: http://www.mypebblefaces.com/apps/94/9459/9460/
Text Watch with Small Full Date (oh) [Inverted] [2.0]
Description
This is an inverted tweak on the Text Watch, it now reads full date in a small font in the bottom right corner. There are also versions of this without (oh) and one with (o') added before minutes one through nine. The non-inverted version can be found here: http://www.mypebblefaces.com/apps/94/9459/9461/
Polar Clock Lite 2.0
Description
A polar clock watchface which uses arcs to show hours and minutes. The 2.0 version is now configurable through the Pebble app to optionally show the date and/or time in text form, as well as invert the color. This "lite" watch face is less animated since it updates every minute instead of every second, and consequently it will use less battery life. For a more animated version that consumes more battery, try Polar Clock 2.0 - http://www.mypebblefaces.com/apps/20969/9703/
Polar Clock 2.0
Description
A polar clock watchface which uses arcs to show hours, minutes, and seconds. The 2.0 version is now configurable through the Pebble app to optionally show the date and/or time in text form, as well as invert the color. This watch face is more animated since it updates every second, and consequently it will use more battery life. For a lightweight/less animated version, try Polar Clock Lite 2.0 - http://www.mypebblefaces.com/apps/20969/9704/
3D Dots
Description
Watchface that shows the time in a stylish, three-dimensional way with cubes.
Note that this watchface is made for the Pebble firmware 2.0 developer preview and won't work on the 1.x firmware.
Bits
Description
Simple analog using binary to represent the numbers on the dial.
Thanks to http://www.watchface-generator.de
3D Blocks
Description
Watchface that shows date and time in a stylish, blocky three-dimensional way.
Note that this watchface is made for the Pebble firmware 2.0 developer preview and won't work on the 1.x firmware.
All Seeing Eye (Time and Date)
Description
Image of an all seeing eye with the time and date.
