(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 '%JeroenDG%') 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
-
Description
An app that allows untappd users to quickly check in to their recent or favorite beers.
created by - JeroenDG
-
Description
Shows the current exchange rate for different cryptocurrencies on different exchanges.
The following are supported at the moment:
- crypto: BTC, LTC, NMC
- exchanges: MT.Gox, Kraken
- fiat: USD, EUR, GBP
More will follow later.
created by - JeroenDG
-
Description
Displays time and date only for a couple of seconds after the watch is tapped or flicked. If the watch doesn't move the screen will stay blank.
You can also make the time always visible by setting the time-out to 0.
Currently works in English, French, German, Dutch and Italian.
All settings can be configured using the pebble app, this includes:
- Changing the style (white on black or black on white)
- Changing length of screen time-out
- Changing the language
- Enable/disbale the bluetooth icon
- Enable/disable the battery icon
- Enable/disable disconnect notification
Supports both 12h and 24h mode.
NOTE: This app requires the 2.0 (beta) firmware
Feel free to donate BTC: 19YrGV8Yd4ovqaBndYUXU1Jo1jNLrP8Mui
created by - JeroenDG
-
Description
Big battery shows the current charge of the pebble's battery.
It also shows a bluetooth icon when connected and will make the watch vibrate if the connection is lost.
When the pebble is charging this will be indicated on the top right.
Feel free to donate BTC: 19YrGV8Yd4ovqaBndYUXU1Jo1jNLrP8Mui
created by - JeroenDG
-
Description
Watchface displays time in binary format.
First row for the hour, second row for the minutes and the third one for the seconds.
In 12h mode the left bit in the hour notation is replaced by an A or P indicating AM or PM.
Feel free to donate BTC: 19YrGV8Yd4ovqaBndYUXU1Jo1jNLrP8Mui
created by - JeroenDG
-
Description
Simple watchface that displays the time and the current selling value of bitcoin.
The bitcoin value is updated every minute.
Available in EUR and USD versions.
Httpebble app is required on the phone.
created by - JeroenDG
-
Description
Simple watchface that displays the time and the current selling value of bitcoin.
The bitcoin value is updated every minute.
Available in EUR and USD versions.
Httpebble app is required on the phone.
created by - JeroenDG
-
Description
Watchface displays time in binary format.
First row for the hour, second row for the minutes and the third one for the seconds.
In 12h mode the left bit in the hour notation is replaced by an A or P indicating AM or PM.
created by - JeroenDG
-
Description
Calculates the equivalent of "normal" beers for the parameters you enter.
I have used 25cl with 5.2% ABV as reference since this is around average for a pilsner in Belgium.
Up button increases value, down button decreases, middle selects, long press middle resets.
If you want to use differents values to compare to and/or use different units you can find the source on github to adjust to your liking.
created by - JeroenDG
