(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 '%robisodd%') 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
A realtime 3D first person engine running at 30fps.
Control with the accelerometer. Start by holding the Pebble flat (face up) and move by tilting the pebble: forward and back to walk and side to side to rotate. Hold the bottom button to strafe instead of rotate. Press the center button to remove walls. Press the up button to generate a new maze map.
This is just a demo. There is no goal or objective other than to move around and bump into walls. A single sprite has been added to demonstrate sprite rendering.
The source code has been provided so anyone can use this to create their own game or other 3D application.
created by - robisodd
-
-
Description
Note: I really recommend downloading the most current version (v0.9b at the time of this writing) as it is much faster and more responsive and includes more features.
http://www.mypebblefaces.com/apps/8596/11670/
------------------------------------------
A realtime 3D first person engine. Control with the accelerometer by tilting the pebble, forward and back to walk and side to side to rotate. The buttons haven't been implemented to do anything yet.
This is just a demo. There is no goal or objective other than to move around and bump into walls.
The source code has been provided so anyone can use this to create their own game or other 3D application.
created by - robisodd
Description
A realtime 3D first person engine. Control with the accelerometer by tilting the pebble, forward and back to walk and side to side to rotate. The buttons haven't been implemented to do anything yet.
This is just a demo. There is no goal or objective other than to move around and bump into walls.
The source code has been provided so anyone can use this to create their own game or other 3D application.
Update to v0.1b: Code optimized to be much faster. Included zebra blocks and door blocks for examples.
created by - robisodd
Description
A realtime 3D first person engine. Control with the accelerometer by tilting the pebble, forward and back to walk and side to side to rotate. The buttons haven't been implemented to do anything yet.
This is just a demo. There is no goal or objective other than to move around and bump into walls.
The source code has been provided so anyone can use this to create their own game or other 3D application.
Update v0.2b: Code optimized to be much faster. Included zebra blocks and door blocks for examples.
Update v0.3b: Shading based on distance, optimized algorithm further.
created by - robisodd
Description
A realtime 3D first person engine running at 30fps.
Control with the accelerometer. Start by holding the Pebble flat (face up) and move by tilting the pebble: forward and back to walk and side to side to rotate. Hold the bottom button to strafe instead of rotate. Press the center button to remove walls. Press the up button to generate a new maze map.
This is just a demo. There is no goal or objective other than to move around and bump into walls. A single sprite has been added to demonstrate sprite rendering.
The source code has been provided so anyone can use this to create their own game or other 3D application.
created by - robisodd
