(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 '%malrobot%') 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
Falldown is a game where the point is to steer a ball around lines of bricks as the ball endlessly falls down. You steer with the UP and DOWN buttons. Your main objective is not to let the ball hit the top of the screen. If you hit a line of bricks, it will push you upward until you can steer around it. Like all classic video games, you will eventually lose as the increasing speed of falling takes its toll. Try to get the highest score you can before it's all over!
Your high scores are now automatically entered in competition with those of others playing Falldown around the world at http://pebblescores.appspot.com/list?game=Falldown . Your score is identified for now by your Pebble's Bluetooth address, located in Settings > About > BT Address. Note that for this feature to work, you must have an app implementing HTTPebble installed on your phone.
HTTPebble Android instructions: install http://goo.gl/BimoY and disconnect/reconnect your Pebble in the regular Pebble app (this works around http://goo.gl/ae4xBU).
HTTPebble iPhone instructions: install http://goo.gl/JqKx3.
If you like this game or would like to see me make more Pebble apps, feel free to donate Bitcoin to address 15tqNp6eD3A15MTavs1dqR2fyavDfqYBxo :).
NEW: The game can be paused / unpaused with the SELECT button.
created by - malrobot
Description
Falldown is a game where the point is to steer a ball around lines of bricks as the ball endlessly falls down. You can steer with the UP and DOWN buttons or by flicking your wrist, if motion controls are enabled. Your main objective is not to let the ball hit the top of the screen. If you hit a line of bricks, it will push you upward until you can steer around it. Like all classic video games, you will eventually lose as the increasing speed of falling takes its toll. Try to get the highest score you can before it's all over!
Your high scores are automatically entered in competition with those of others playing Falldown around the world at http://pebblescores.appspot.com/list?game=Falldown2. Your score is identified by the name you set within Falldown's app preferences (located in the Watch Apps section of the Pebble phone app).
If you like this game or would like to see me make more Pebble apps, feel free to donate Bitcoin to address 15tqNp6eD3A15MTavs1dqR2fyavDfqYBxo :).
created by -
