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 '%DannyBres%') 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  
  • PebbleScorer

    Description

    iOS BETA TESTERS needed: http://www.pebblescorer.co.uk

    Using Pebble App

    Up - Increment your team score. (Should be used when you do NOT score the goal/point)
    Hold Up - Increment your team score and your personal tally. (Should be used when you DO score the goal/point)
    Down - Increment opponents score.
    Select – Start/Stop stopwatch timer.
    Hold Select – Reset all.

    Using iOS App (waiting on Pebble then Apple to approve, picture at bottom)

    Track the game using your Pebble Watch App called PebbleScorer, detailed above.
    Following the game, download the data to your iPhone using the iOS app. (Pull to Refresh)
    The iOS app will auto-upload the game data to http://www.pebblescorer.co.uk.
    From the iOS app, a historic record of all games is available, complete with a net score graphs with your scored goals/points highlighted.
    The iOS app supports sharing the score, a link to the game in the Web App and graph image to Facebook and Twitter.

    Using Web App

    Visit http://www.pebblescorer.co.uk.
    Type your Pebble number (short number, found in Bluetooth menu on phone and pebble, mine is '9571') into the form at the bottom of the page.
    View all your uploaded games.
    Select a game and view the game details page.

    I still have alot of ideas to implement across the Apps, including beta tester requested specialised scoring for other games, Rugby (+5, +2 or +3 with Sin Bin timing), Basketball (+2 or +3, timeout tracker) etc.

    created by - DannyBres

QR code for

Keep track of any updates for this App by signing in

×