(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 2576,56
-
-
-
-
Description
Diversify your sex life! Click on the button and get one of the 672 combinations of poses and places!
created by - vvzvlad
-
Description
For people who want all the time information at once. Can be configured for normal or inverted display. Based on a concept by plumliz. Updated for SDK 2.0.
NOTE: There is now a setting to configure normal or inverted display, so this also updates the old "AccuWhite" face. Click the gear next to the face in the Pebble app to configure.
created by - bobhwasatch
-
Description
In the style of the clock from Android 4.2. Orignal concept by cassidyjames. Updated for SDK 2.0 and to make the font a bit larger and more readable.
created by - bobhwasatch
-
Description
Minor modification of the standard Simplicity face to add the day of the week. Updated for SDK 2.0.
created by - bobhwasatch
-
-
-
-
-
-
-
-
Description
A simple analogue watch with optional day-of-month, second-hand, inverted colors, and Bluetooth/battery status icons. The watchface can be configured using the Pebble phone app.
Migrated to Pebble OS 2
created by - tomgidden
-
Description
This app adds a counter to your Pebble. But you still will be able to read the time, cause this is the main task of a watch:)
Now with Auto 24h and 12h time.
Add and remove numbers with the upper and lower buttons, go back to zero with a long press on the middle button, invert the screen with a short press on the middle button.
created by - Idoodler
-
-
Description
Displays 3 rows of information from bitcoin trades.
1st row: 24h high
2nd row: last price
3rd row: 24h low
Up/down button cycles through the different markets available. Currently MtGox, Bitstamp and BTCChina.
Middle button forces refresh of ticker info.
Auto refresh every 3 min.
If new 24h high is achieved screen will light up and the watch will vibrate once.
If new 24h low is reached screen will light up and the watch will vibrate twice.
Roadmap (if I get donations and see that there is interest):
•Graph. 24h price graph
•Graph. Cumulated bid/ask volume graph
•Customizable refresh-rate
•More trades
Donations: 1C7WCMDKuZTozopukrU7wn4L5QeEP9zkiG
QR: http://imgur.com/05Cr2ia
Enjoy!
created by - gusost
-
-
-
Description
Analoguhr / Digitaluhr / Datum (Wochentag+Monat als Text)
created by - moe
-
Description
This app will keep you to up to date on your next upcoming bus. It periodically updates itself so it will always have the latest information for you. In a quick glance, you can check the current time and when your next bus will arrive.
This uses the OC Transpo open data API and the Travvik framework to serve the data.
Quick how to.
Short presses on the Action button will move the selection arrow to either bus or stop numbers. The left is the bus and the right is the stop.
Long press on the Action button tells the app to immediately grab the information. Long press of the Action bar will also change the current direction the app is set to as OC Transpo combines both route directions into a single bus & stop tuple.
The up and down buttons increment and decrements the numbers so you can select the bus you want to keep tabs on.
created by - jaimeyu
-
Description
Same simplicity but rewritten for 2.0 SDK + charge information added. Fork&modify&enjoy.
created by - Remper
-
Description
All credit here to Foxel for the code - i've just made a few tweaks. Functionality is identical.
I just found the Roboto font wasn't rendering that well for me, so instead i've used the sansation font standard on samsung phones, which seemed to give the best result of those i tried.
ps. will invert if you shake/tap watch within 2 sec of changing watchface to this.
created by - mereed
Description
this was simply a test using the font from 'halftone time' to see how big i could make the font size before i started getting artefacts (numbers not displaying). it was font size 75 with this font. At 76 and above i started losing the num 4 as it's the widest num. otherwise it all works the same. Code by Foxel.
created by - mereed
-
-
-
-
-
Description
Simple watchface with an image of a T-Rex from an original ipad painting.
created by - Jevist
-
-
-
-
-
-
Description
Modern Runic Clock by Jason Bales (White, original)
The runes have values of 1 to 24. Since there are 24 hours in a day, this means we can assign one rune to each hour of the day. Ideally we would make 24 equal divisions, each with a rune, on a clock face and have the clock run at half speed. Since I have only seen one clock that runs at half speed, we will need to make a new face for a standard 12 hour clock
created by - JanSolo
-
Description
Modern Runic Clock by Jason Bales
The runes have values of 1 to 24. Since there are 24 hours in a day, this means we can assign one rune to each hour of the day. Ideally we would make 24 equal divisions, each with a rune, on a clock face and have the clock run at half speed. Since I have only seen one clock that runs at half speed, we will need to make a new face for a standard 12 hour clock
created by - JanSolo
-
-
Description
24h digital
source : wikipedia
Soviet stamp (1988) with the image of Nelson Mandela on the occasion of his 70th birthday.
created by - Parisien
-
-
Description
Hazuki Ferrari from Galilei Donna. Digital time, no seconds. English long day/month names.
created by - dgw
-
Description
Приложение - аналог игральной кости. Потрясите ваши часы, чтобы кинуть кубик!
created by - vvzvlad
-
Description
Приложение-аналог игральных костей на которых нарисованы позы и места.
created by - vvzvlad
-
-
-
-
-
Description
Plain and obvious sector watch,
time is displayed by a sector between hour and minute hand.
Polar or pie clock, originally way to wear time.
created by - berge01
-
-
-
-
-
-
-
Description
This watch face gives you the time along with everyone's favourite Breaking Bad phrase.
created by - Jimmynidas
-
-
