(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 '%Gordidon%') 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
This is a watchface that works in iOS and is for Pebble running 1.13. This watchface display the next game the New York Knicks are playing, display the current game with current score.
This app was made possible thanks to Mr. Jason Ramboz. Jason made a watchface for the Washington Capitals, the face basically gives the scores and upcoming games on your Pebble. His code is in Github for everybody to use and I made this watchface by just doing that, making some changes and put it to work for any sport.
You are require to have HTTPebble, you can use the iOS app call HTTPebble or SmartWatch+ which now have support for HTTPebble.
As stated on Mr. Jason Ramboz GitHub; The face doesn't support playoff data since we still don't know which team will play on the playoff but as soon as the playoff start, the app will update with that data. Also sometimes the app stops communicating with the watch and you have to switch from watchfaces and get back to HeatScores.
This version is in BlackBG but if there are a decent number of request for a WhiteBG I would make that happen. Also if there are some Androids fans and want to use this app with Android, let me know and I would try to make that happen.
Check my others Watchface;
PebNYRangers: http://www.mypebblefaces.com/apps/5925/7591/
HeatScores: http://www.mypebblefaces.com/apps/5925/7904/
More sports and teams coming soon!!!!
created by - Gordidon
-
Description
This is a watchface that works in iOS and is for Pebble running 1.13. This watchface display the next game the Miami Heat are playing, display the current game with current score.
This app was made possible thanks to Mr. Jason Ramboz. Jason made a watchface for the Washington Capitals, the face basically gives the scores and upcoming games on your Pebble. His code is in Github for everybody to use and I made this watchface by just doing that, making some changes and put it to work for any sport.
You are require to have HTTPebble, you can use the iOS app call HTTPebble or SmartWatch+ which now have support for HTTPebble.
As stated on Mr. Jason Ramboz GitHub; The face doesn't support playoff data since we still don't know which team will play on the playoff but as soon as the playoff start, the app will update with that data. Also sometimes the app stops communicating with the watch and you have to switch from watchfaces and get back to HeatScores.
This version is in BlackBG but if there are a decent number of request for a WhiteBG I would make that happen. Also if there are some Androids fans and want to use this app with Android, let me know and I would try to make that happen.
Check my others Watchfaces;
PebNYRangers: http://www.mypebblefaces.com/apps/5925/7591/
KnicksScores: http://www.mypebblefaces.com/apps/5925/8110/
More sports and teams coming soon!!!!
created by - Gordidon
-
Description
This is a watchface that works in iOS and is for Pebble running 1.13. This watchface display the next game the New York Rangers are playing, display the current game with current score.
This app was made possible thanks to Mr. Jason Ramboz. Jason made a watchface for the Washington Capitals, the face basically gives the scores and upcoming games on your Pebble. His code is in Github for everybody to use and I made this watchface by just doing that, making some changes and put it to work for the NY Rangers.
You are require to have HTTPebble, you can use the iOS app call HTTPebble or SmartWatch+ which now have support for HTTPebble.
As stated on Mr. Jason Ramboz GitHub; The face doesn't support playoff data since we still don't know which team will play on the playoff but as soon as the playoff start, the app will update with that data. Also sometimes the app stops communicating with the watch and you have to switch from watchfaces and get back to PebNYRangers.
This version is in BlackBG but if there are a decent number of request for a WhiteBG I would make that happen. Also if there are some Androids fans and want to use this app with Android, let me know and I would try to make that happen.
Check my others Watchfaces:
HeatScore: http://www.mypebblefaces.com/apps/5925/7904/
KnicksScore: http://www.mypebblefaces.com/apps/5925/8110/
created by - Gordidon
