(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 '%rigel314%') 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
Pebble text watch in 24 hour time.
Displays date in a small font at the bottom of the screen.
Animation support.
Displays "o'clock" on the hour, "o'" for a leading zero in the minutes, and nothing for a leading zero in the hours.
created by - rigel314
Description
Pebble text watch in 24 hour time.
Displays date in a small font at the bottom of the screen.
Animation support.
Displays "o'clock" on the hour, "oh" for a leading zero in the minutes, and nothing for a leading zero in the hours.
created by - rigel314
Description
Pebble text watch in 24 hour time.
Animation support.
Displays "o'clock" on the hour, "oh" for a leading zero in the minutes, and nothing for a leading zero in the hours.
created by - rigel314
Description
Pebble text watch in 24 hour time.
Animation support.
Displays "o'clock" on the hour, "o'" for a leading zero in the minutes, and nothing for a leading zero in the hours.
created by - rigel314
-
Description
A Pebble watchface inspired by the map in the amazing game, Antichamber.
created by - rigel314
Description
A Pebble watchface inspired by the map in the amazing game, Antichamber.
created by - rigel314
Description
A Pebble watchface inspired by the map in the amazing game, Antichamber.
created by - rigel314
Description
A Pebble watchface inspired by the map in the amazing game, Antichamber.
created by - rigel314
-
Description
Hex Editor for pebble. This is a DANGEROUS tool, not a toy. Be careful with it. Misuse could brick your Pebble.
When launched, you get a menu. Up, down, and select work as you would expect.
Choosing hex editor will present a hex dump. Up and down will scroll. Select will start editing the selected word.
In the word editor, up and down change the value of the selected nibble, and select will advance. Holding select will set the value. Clicking back at this point will not save any changes.
Set Address functions the same as the word editor.
The other menu items will display informative text.
Please don't blame me if you brick your pebble while playing with this hex editor. This is a DANGEROUS tool, not a toy. Be careful.
Some areas of memory are not allowed to be read. If you try to read them, your Pebble will crash. Just trying to read protected memory should not harm your Pebble. However, upon trying to find a boundary for readable memory, I crashed my Pebble enough times quick enough that it decided to boot the recovery firmware. It has you send the firmware from your phone again. It worked just fine, but it was scary.
0x2001C08C is where one of my app's global varables is stored on my Pebble.
created by - rigel314
-
Description
Sine wave watch face for the Pebble smart watch.
To read:
The number of nodes is the number of hours, not counting the one at the bottom of the screen. That is to say, the number of times the wave crosses the middle of the screen. At one o'clock, there is only half a cycle showing.
The number of minutes is shown by looking at the top end of the wave. The antinodes, places furthest from the middle of the screen, is 30 minutes. Zero minutes is at the most recent node. 60 minutes is at the next node that isn't shown yet.
Example:
This watch face in the picture is showing about 4:20.
created by - rigel314
