(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 3080,56
-
-
-
-
-
-
-
Description
Classic Pebble Watch face
Appears to be showing as a SDK 2.0. This is for SDK 1.0
created by - Ganku
-
-
-
-
-
-
Description
This app was suggested by my 11-year-old son, who wanted a tamagotchi-style robot. I created a sort of body physics engine and then a scripting language to animate the body parts.
The robot will animate every minute, or when the watch is tapped or shaken in any direction. There are about 40 animations (so far!).
Custom settings include screen background, date format, vibration alerts, and more. Settings can be customized through http://SetPebble.com or the new Pebble 2.0 configuration feature.
created by - GORGES
-
Description
The classic version of the watchface "simptastic", 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/matteogisler/
created by - matteogisler
-
-
Description
The classic version of the watchface "simptastic", but without the 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/matteogisler/
created by - matteogisler
-
Description
Don't think this one needs much explanation..
All pretty simple:
- up button starts recording
- down button stops
- long press on the select button erases the highscore
Records how long you take, how many faps total end faps per second.
The highest fps is saved in the watch's persistent storage.
Feel free to donate if you like the app: 1LwVCorC3qj7Z2vm4TWwQPmYFzLC6NeMCk
created by - fapgauge
-
-
-
-
Description
Gun Fans
Don't forget if your rocking one of my Pebble watch faces, send me a Picture on my Twiter: @iJ0rd8n
I also take watch face design requests :-)
created by - iJ0rd8n
-
-
Description
Same basis as my previous Stopwatch, Yachtimer, Countdown. Not yed adjustable yet so 10 minute countdown. With analog face.
Made full screen, added date and watch mode as you toggle mode (down button) icon appears briefly to tell you the mode.
Demonstrates how to replace a watch in codebase with core yachtimer logic.
created by - MikeM
-
-
Description
Watchface based on new iOS7 Home screen for SDK 2.0
Shows Bluetooth connection status and watch battery power status when the watch is tapped. This display remains visible for a minute and then disappears.
This status display remains visible when the watch is being charged.
Only works with SDK 2.0 firmware.
created by - bmachine
Description
Watchface based on new iOS7 Home screen for SDK 2.0 - Inverted (black on white)
Shows Bluetooth connection status and watch battery power status when the watch is tapped. This display remains visible for a minute and then disappears.
This status display remains visible when the watch is being charged.
Only works with SDK 2.0 firmware.
created by - bmachine
-
Description
I really liked the original 'iWatch' face by DerekC, so I decided to re-do an iOS7 theme one.
SDK 2.0 Version - Use with SDK2.0 Firmware ONLY.
created by - mattgreen
Description
iWatch (iOS7) - Inverted Version
SDK 2.0 Version - Use with SDK2.0 Firmware ONLY.
created by - mattgreen
Description
No Background version of iWatch (iOS7)
SDK 2.0 Version - Use with SDK2.0 Firmware ONLY.
created by - mattgreen
Description
iWatch (iOS7) - No Background - Inverted Version
SDK 2.0 Version - Use with SDK2.0 Firmware ONLY.
created by - mattgreen
-
-
-
Description
Multi mode app supports
1: Yachtimer start sequence.
2. Countdown.
3. Stopwatch, lap times etc.
4. Countdown adjust (Hours, Minutes, Seconds)
5. Watch (time, data plus running mode that Stopwatch etc was started in).
6. In clock mode up/down inverts watch face.
Press Select long time to switch mode.
created by - MikeM
-
Description
Get the surf report from all the SoCal spots SpitCast has to offer. This app pulls you GPS coords and gives you constant updates on the nearest Gnar.
UP - Change Spot
SELECT (Single Click) - Refresh Current Spot
SELECT (Double Click) - Back to Nearest Spot
Down - Change Spot
Future upgrade will include more data (including tide info), vibration surf alert, etc.
ONLY COMPATIBLE WITH FIRMWARE V2.0+ (ie SDK 2.0+)
created by - aclymer
-
-
-
-
Description
This is a little Jungle Timer for the MOBA Game League of Legends.
How it works:
After clearing a camp in the Jungle just press the corresponding button on your Pebble to activate the timer.
- a black bar will indicate the row
- 60 seconds before respawn the bar will start indicating the progress
- 30 seconds before respawn a vibe pattern will be fired to remind you
- when the progress bar is empty a last vibe will occur
Buttons:
Blue Buff: press 'UP' Button once
Red Buff: press 'DOWN' Button once
Dragon: press 'SELECT' Button once
Enemy Blue: press 'UP' Button twice
Enemy Red: press 'DOWN' Button twice
Baron: press 'SELECT' Button twite
Vibe Pattern:
The dots and lines in front of the names represent the vibe pattern that is fired 30 sec. berfore respawn.
. _ . (short-long-short)
_ . _ (long-short-long)
. . . (short-short-short)
Note:
The animation of the Bars was broken if it was timed bigger than 60 seconds, therefore the bars start not before 60 sec. are remaining before resapwn.
created by - Airbagman
-
Description
A quick watchface i made. Its a cool watch face for people who love basketball
created by - Beaustrr
-
-
-
-
-
-
-
-
-
Description
A watchface to remind you that it's always time to party!
created by - timl
-
-
-
Description
Magic 8 wrist using Pebble tap service accelerometer.
Think of a question shake your wrist and have your answer!
To reset for another question simply press select.
20 answers all together.
created by - dsexton702
-
-
Description
A watch face that resembles Michael's communicator watch in the hit series Knight Rider.
created by - Blindjuggler
-
-
Description
If you like Super Smash Bros than this is the watch face for you. I wear it whenever I play.
created by - Blindjuggler
-
-
-
Description
A simple watch face with time and date which allows you to rep one of the greatest record labels of all time.
created by - sonofiron
-
-
