(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 '%zandegran%') 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
Google 2 step Authenticator for SDK 2.0 . Shows the time till the key is valid and a progress bar..More detail in the GITHUB readme
NEEDS RECOMPILING
(The timezone and the secret needs to be changed)
A version without need to configure the timezone is on the way
created by - zandegran
-
Description
Now with Persistent Storage: The user can leave the app and still have the scores to continue..
The Score is maintained until the user resets.
ScoreKeeper is a simple app to keep track of scores of any two teams and any Game.
for SDK 1 : http://www.mypebblefaces.com/apps/667/1228/
Simple to use:
Up Key - Increment the score of Team A by 1
Up Key (Long press)- Decrement the score of Team A by 1
Down Key - Increment the score of Team B by 1
Down Key (Long press)- Decrement the score of Team B by 1
Select Key (Long press)-Reset the scores of two teams
Select Key (Short Press)- Toggle the vibration
created by - zandegran
-
Description
This is exactly Katharine's original Watch Face. The difference lies in the ios app. Instead of using Location Services to find the City and the getting the weather. Just enter your city in the ios app and that it. The rest is taken care of.
You can safely turn the location services off and still get weather updates.
The ipa is here
http://dl.dropboxusercontent.com/u/50804655/httpebble-NoLoc.ipa
and the source code can be found in github
created by - zandegran
-
Description
ScoreKeeper is a simple app to keep track of scores of any two teams and any Game.
Simple to use:
Up Key - Increment the score of Team A by 1
Up Key (Long press)- Decrement the score of Team A by 1
Down Key - Increment the score of Team B by 1
Down Key (Long press)- Decrement the score of Team B by 1
Select Key (Long press)-Reset the scores of two teams
Version 1.2 : Now it Vibrates
The vibration feature is added.
Select Key (Short Press)- Toggle the vibration
Version 1.21 : Text alignment Fixed
Please Consider Donating
Paypal: http://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=H6G7SDVKHDWHU
BitCoin: 1AL6DZYDm2c4Yp3ei5JqHSJwrEuZAkGZu4
created by - zandegran
-
Description
Another Google Authenticator based on pokey9000's twostep app. Shows the time till the key is valid and a progress bar..More detail in the GITHUB readme
NEEDS RECOMPILING
(The timezone and the secret needs to be changed)
created by - zandegran
-
-
-
-
