Show filters

(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 '%Grimbert%') 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  
  • Sickbeard

    Description

    Show your recent Sickbeard downloaded and upcoming shows on your Pebble.
    It is required that your Sickbeard is reachable through the internet. (So that the watchface can be updated when on 3G)

    Get your Sickbeard API key from "general > config" in Sickbeard

    Set your Sickbeard address and api key in the configuration screen.

    created by - Grimbert
  • PebbleTV

    Description

    PebbleTV Shows upcoming tv shows you're following on trakt.tv on your pebble.
    Set your Trakt username in the configuration screen.

    The watchface shows a bluetooth icon top-left when connected.
    Battery charge is shown top-right

    When the pebble gets connected to your phone it wil vibrate 2 times, when disconnected it will vibrate 3 times.

    Note: disable "Protect my data" on trakt.tv settings, otherwise the watchface can't retrieve anything.

    Want to donate for this watchface?
    LTC: LUSCQzTPtJqGxXnT6dDcwX6q4WRx8C3k79
    BTC: 19eedmhy2uRTkPRJtzcbkC9UnLQxHXjnay

    created by - Grimbert
  • Pip Boy 100

    Description

    A Pebble watchface inspired by Fallout’s Pip Boy.

    Lef-top shows the date.
    Right-top shows battery charge.
    Middle “VaultBoy” shows bluetooth connection. (images changes depending on the connection state)
    When the connection state changes the Pebble will vibrate.
    The watchface uses the accelerometer and with certain movements you will gain experience points and you can level up.
    You can shake your Pebble to get the current weather shown.

    Your experience points will be saved on the Pebble so you can safely switch watchfaces without losing your experience.

    Want to donate for this watchface?
    LTC: LUSCQzTPtJqGxXnT6dDcwX6q4WRx8C3k79
    BTC: 19eedmhy2uRTkPRJtzcbkC9UnLQxHXjnay

    created by - Grimbert

QR code for

Keep track of any updates for this App by signing in

×