(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 '%pocketscience%') 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 game is part of my childhood memories from the Commodore 64 era.
Try to get your lander onto one of the 3 landing sites without crashing into the terrain. You have limited fuel, so watch the use of your main thruster and left/right retro thrusters. The harder landing sites will reward successful landings with more points and more fuel.
Enjoy!
v0.2 fixes some memory leaks reported by Eric @ Pebble!
created by - pocketscience
-
Description
Yes, you can now play the classic arcade Asteroids on your Pebble! Control you ship with the up/down buttons to turn left/right. The select button is used to fire your lasers with single presses, and with a long press it fires up your thrusters to move out of the way of oncoming asteroids! Your ship will eventually slow, or you can spin and apply more thrust to change directions or come to a complete stop at a point of your choosing.
This version (0.5) adds quite a few new features, including:
* a mystery ship
* explosions when you die (not asteroids yet)
* better polygon collision checking
* different speed asteroids
* being hit by an asteroid destroys the asteroid
* lots of performance tweaks
Please let me know what you think!
Enjoy!
created by - pocketscience
-
Description
To quote @Pebble: "Space Invaders on your Pebble? Yeah, it happened."
On the splash screen press the button you'd like to use for firing twice (first to confirm, second to start the game). The selected fire button will remain active whilst your in the game, however you'll need to re-select each time you launch Space Invaders as Pebble currently has no way to store app-level user preferences. The remaining buttons become your left/right controls in the most obvious arrangement, i.e. if you use the select button for firing then the down/up button become left/right. If you select up for firing then down/select become left/right.
Please 'like' this (click the thumbs-up icon below) if you want to see improvements and more games - the only incentive for developing is personal gratification and that's bolstered when you add your voice to the 'likes', or when you add comments here or on the Pebble forum (http://forums.getpebble.com/discussion/comment/34145)
Release notes:
0.5
- Easter egg competition! Details here: http://forums.getpebble.com/discussion/5185/competition-pace-invader-easter-egg-hunt
0.4
- improved game over experience
- horizontal progression of invaders increases as their numbers decrease
- updated splash screen to include mystery ship
- your laser impacts the top of the screen just like the real game
0.3 update adds the following:
- performance improvements
- downward progression of invaders. when they reach your bunkers it's game over man!
- ability to shoot invader bombs
- mystery ship!
- configurable buttons - on the splash screen press the button you want to use for the fire button twice. the remaining 2 buttons will be automatically configured for left/right movement.
0.2 update improves some performance bottle-necks and fixes a number of bugs.
created by - pocketscience
-
Description
A space-shoot-em-up game loosely based on a couple of different games from my youth (80's!). You have 3 ships, and get points for blasting aliens - the earlier you blast them the more points you get. Don't get shot by them, run out of ammunition, or run into the scenery. As you progress through the levels the aliens will move around more often, and fire their lasers more often. Sometimes you can block their lasers with your own, but not always! Score more than 999 points and you're a winner!
created by - pocketscience
-
Description
The second in my series of fully playable Game & Watch emulations. Here we have the classic Fire - which appeared in both original Game & Watch and also the Widescreen follow-ups which were (arguably) more popular.
created by - pocketscience
-
Description
My version of the classic Game&Watch game! It's really made to be played with Pebble off your wrist and your thumbs on the up/down buttons to move left/right.
created by - pocketscience
-
-
