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 '%cstrat%') 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  
  • Tennis Pro

    Description

    The first tennis score keeping app for the Pebble!
    I am only working on this in my spare time, so please be patient.

    If you've any ideas or if you find any bugs please let me know in the comments.

    Supports:
    - Game scoring, including deuce/advantage play
    - Set scoring, including tiebreak
    - Set aggregate scoring
    - Serve indicator (always from the view of the person wearing the watch looking up court)

    Controls:
    - Up (add opponent point)
    - Up *hold* (minus opponent point)
    - Down (add your point)
    - Down *hold* (minus your point)
    - Middle Button - view set history
    - Middle Button *hold* - cycle serve marker

    ## Updated 8/Aug - Version 1.1
    - Fixed scoring bug with regard to sets
    - Added a version indicator on the quit page

    ## Updated 7/Aug - Version 1.0
    - Version 1.0 Release
    - I am pretty sure that I haven't gotten the serve marker operating correctly, especially with regard to tiebreaks.

    ## Updated 18/July - Version 0.0 [Beta]
    - Fixed incorrect scoring
    - Added vibration feedback to some functions
    - Added some labels above scores for clarity

    created by - cstrat
  • Squash Score Keeper

    Description

    My first attempt at a Pebble App.

    Only useful for those of you who play squash.
    Current version only supports PARS to 11.
    The app will keep track of score, games and which side of the court the ball needs to be served from.

    - Click top or bottom button to add to the score.
    - Hold top or bottom button to deduct from the score.
    - Hold middle button to completely reset the game.
    - Click the middle button while the scores are 0 to swap sides.
    - Indicator highlights which player was last to score

    Any tips or ideas please let me know.
    I am going to release the source once I have tidied it up.

    ** Updated **
    - Stability improvements, better unloading of resources (another attempt)

    created by - cstrat

QR code for

Keep track of any updates for this App by signing in

×