(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 '%FlashBIOS%') 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
Game Dice is an animated polyhedral dice roller for those who play table top role playing games, board games, or even people who have trouble making decisions. It will roll dice in all the common polyhedral flavors (d3, d4, d6, d8, d10, d12, d20, and d100), and of any quantity (as long as "any quantity" means 50 or less).
Usage
* Select Button (long press) - Roll the die!
* Select Button (normal press) - Switch between updating the dice's sides (d#), and the quantity of dice to roll (#d)
* Select Button (double press) - Roll a "default" die quickly. Currently this is 1d20, but that will change when settings can be saved.
* Up Button - Increase the dice's sides (d#) or dice quantity (#d). Hold this button for speedy changes.
* Down Button - Decrease the dice's sides (d#) or dice quantity (#d). Hold this button for speedy changes.
If you find this app useful, please "like" it!
Version 1.4 - Increased font size for the individual dice results when multiple dice are rolled (by popular request!). Adjusted layout to retain vertical centering of the results when multiple dice are rolled.Updated the project to support PebbleKit 1.1. Sundry bug fixes
Version 1.3 - Users can now roll a "default" die (currently 1d20) with a double-press of the select button
Version 1.2 - Added support for displaying the individual dice values in a multi-dice roll
created by - FlashBIOS