(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 '%Meiguro%') 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
Orbtime is a Drop7 / Chainfactor clone with a twist. The gameplay is often described as a cross between sudoku and a falling block game. And the twist? Orbtime recognizes that a Pebble is a timepiece and includes time orbs which represent the current time. In Orbtime, what time you play will affect the outcome of your game.
Controls
Up: Move Left
Select: Drop Floating Orb
Down: Move Right
Back: Pause to Main Menu
Drop numbered orbs one at a time which eventually clear themselves. In order for an orb to clear, the orb's number must be equal to the number of orbs in its row or column. One too many or one too little and the orb will stay on the field.
There are basic orbs and time orbs. Time orbs are distinguished by their sharp corner. The direction of the sharp corner determines the type of time orb: a day orb, hour orb, minute orb, or the fast changing second orb. If you are wondering what a certain time orb will have as its number, simply press back and glance at the time orbs in the main menu. The time orbs in the main menu also include wrap dots which you can use to decipher the current time.
When a time orb clears, it'll promote the closest basic orb of the same number into a time orb of the same type. You can use this mechanic to your advantage, changing basic orbs into time orbs and then waiting for just the right time.
Detailed How-To-Play: http://meiguro.com/orbtime/pebble
Comment about it: http://forums.getpebble.com/discussion/5704/game-orbtime-a-drop7-clone-with-a-twist
created by - Meiguro
-
Description
Droptype is a match-4 falling block puzzle game without rotation. Try making chains under pressure while keeping yourself from overflowing, or just drop blocks and watch them clear themselves.
The idea is to makes blocks of the same type adjacent to each other. When four or more of the same kind are touching, they immediately clear. Blocks above them fall, and if that creates another clear, then you've made a chain!
Controls
Up: Move Left
Select: Drop Floating Piece
Down: Move Right
Back: Pause to Main Menu
The game is endless, you lose when a block overflows. However, when you chain -- that is, clear blocks successively before getting your next floating piece -- you gain a free block. When you overflow with free blocks, you lose free blocks instead of losing. Droptype however is wary about letting you have too many free blocks, so there is a risk.
The game features a Main Menu in which you may press back to pause your game. There is also an Infinity Mode. In this mode, there is no drop timer and thus no clock to race against. This reduces battery usage to just whenever the status clock updates, when you press a button, or the animations. If you like the game enough, you can pretend it's a watchface! Infinity Mode appends an infinity to your score to let others know how you obtained the score.
Droptype becomes progressively more difficult the longer you play it.
Webpage: http://meiguro.com/droptype/pebble/
Comment about it: http://forums.getpebble.com/discussion/5267/game-droptype-a-match-4-falling-block-puzzl
created by - Meiguro
-
Description
This is a battery consuming novelty watchface! Expect to charge your Pebble very frequently.
Watch discs float across your Pebble! Rotate or twist your wrist to direct the motion of the discs. The discs will fall down according to gravity while the time will try its best to move itself where it's visible. Disc sizes are randomized, so you'll get a different assortment every time you launch the watchface.
The font used is Viga by Fontstage.
created by - Meiguro
-
Description
* Multiplayer is currently in development, this is a single-pebble release :)
An entire chess board on your wrist. You can ponder what your next move will be while the board is always a glance away. Think deeply, or make a move.
* This game uses the httpebble app UUID! If you're on Android and you have an app that uses the same UUID, see if that app has an Android version. Let me know if you'd like me to release a Pebble Connect version of Chess.
Controls
Up: Previous Piece
Select: Enter Piece's Move Mode
Down: Next Piece
Back: Pause to Main Menu
Cycle through the pieces to decide which piece you want to move. As you cycle, you will see each piece's possible moves. Once you select a piece, select the square you want it to move to. When pieces have many moves, like a queen in an open space, you get to select the direction first.
Piece Move Mode Controls
Up: Previous Possible Move
Select: Use Move Selection
Down: Next Possible Move
Back: Return to Piece Selection
Use solo mode to either practice your chess ideas, or take turns passing your Pebble with a friend. Make daring plays, or sport your favorite game positions with Pebble Chess!
Comment in the Forums: http://forums.getpebble.com/discussion/6024/watch-app-game-chess
Website: http://pebblechess.meiguro.com
created by - Meiguro
-
Description
Orbtime is a Drop7 / Chainfactor clone with a twist. The gameplay is often described as a cross between sudoku and a falling block game. And the twist? Orbtime recognizes that a Pebble is a timepiece and includes time orbs which represent the current time. In Orbtime, what time you play will affect the outcome of your game.
Controls
Up: Move Left
Select: Drop Floating Orb
Down: Move Right
Back: Pause to Main Menu
Drop numbered orbs one at a time which eventually clear themselves. In order for an orb to clear, the orb's number must be equal to the number of orbs in its row or column. One too many or one too little and the orb will stay on the field.
There are basic orbs and time orbs. Time orbs are distinguished by their sharp corner. The direction of the sharp corner determines the type of time orb: a day orb, hour orb, minute orb, or the fast changing second orb. If you are wondering what a certain time orb will have as its number, simply press back and glance at the time orbs in the main menu. The time orbs in the main menu also include wrap dots which you can use to decipher the current time.
When a time orb clears, it'll promote the closest basic orb of the same number into a time orb of the same type. You can use this mechanic to your advantage, changing basic orbs into time orbs and then waiting for just the right time.
New in v1.1:
- The main menu time orbs animation is fancier :)
- Garbage orbs can no longer initially change into time orbs. This should make the game more difficult and less sporadic. After becoming basic orbs, they can be still be promoted as normal.
Detailed How-To-Play: http://meiguro.com/orbtime/pebble
Comment about it: http://forums.getpebble.com/discussion/5704/game-orbtime-a-drop7-clone-with-a-twist
created by - Meiguro
-
Description
Droptype is a match-4 falling block puzzle game without rotation. Try making chains under pressure while keeping yourself from overflowing, or just drop blocks and watch them clear themselves.
The idea is to makes blocks of the same type adjacent to each other. When four or more of the same kind are touching, they immediately clear. Blocks above them fall, and if that creates another clear, then you've made a chain!
Controls
Up: Move Left
Select: Drop Floating Piece
Down: Move Right
Back: Pause to Main Menu
The game is endless, you lose when a block overflows. However, when you chain -- that is, clear blocks successively before getting your next floating piece -- you gain a free block. When you overflow with free blocks, you lose free blocks instead of losing. Droptype however is wary about letting you have too many free blocks, so there is a risk.
The game features a Main Menu in which you may press back to pause your game. There is also an Infinity Mode. In this mode, there is no drop timer and thus no clock to race against. This reduces battery usage to just whenever the status clock updates, when you press a button, or the animations. If you like the game enough, you can pretend it's a watchface! Infinity Mode appends an infinity to your score to let others know how you obtained the score.
Droptype becomes progressively more difficult the longer you play it.
New in v1.3:
- There is now an options menu accessible in the main menu even when you pause. With it, you can enable vibrate on react or disable light on react. The settings are per-session and are not saved after you exit.
- Blocks are now rendered via images, so Hard mode should now perform just as fast as Normal mode. You should no longer feel time slowing down when the field is incredibly full.
Webpage: http://meiguro.com/droptype/pebble/
Comment about it: http://forums.getpebble.com/discussion/5267/game-droptype-a-match-4-falling-block-puzzl
created by - Meiguro
