(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 '%mjculross%') 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
Chrono2
Description
Chrono2: A "sweep analog" watchface with a smooth second hand
[ SDK 2.0 compatible version ]
This watchface was created from the combination of the Brains watchface from the SDK 1.0 and the simple_analog watchface provided as an exmaple with the SDK 2.0
Mark J Culross (KD5RXT) [email protected]
DblTime2
Description
DblTIme2 - display two timezones
[ SDK 2.0 compatible version ]
NOTE: to allow full use of the buttons, DblTime2 loads in as an app (at the same menu level as "Settings" on the Pebble), not as a watchface . . . it just displays a watchface
Features (v 2.2):
- dual date & time displays
- with black-on-white for daytime displays & white on black for nighttime displays
- adjustable # hours offset (-23:30 to +23:30) in 30-minute increments, between primary & secondary time displays (default = 0:00)
- when # hours offset = 0, secondary date & time are not displayed (primary time display only)
- enable/disable snooze mode (display blanks after 10 seconds) - default = enable
- enable/disable hourly chime mode (buzzes on the hour & activates display) - default = disable
- selectable mm/dd/yy vs dd/mm/yy date display - default = mm/dd/yy
- enable/disable display of seconds - default = enable
- displays 12/24 hour format time (using current Pebble Settings)
- minimal delay when showing time at start-up & when waking from snooze
- preference settings saved in persistent storage
Operating instructions:
- to enter "set mode" (snooze), long-press the "select" (middle) button (Z's blink)
- with "set mode" on "snooze", press the "up" & "down" buttons to toggle between "enable" & "disable"
- to change "set mode" to "chime", long-press the "select" button (bell blinks)
- with "set mode" on "chime", press the "up" & "down" buttons to toggle between "enable" & "disable"
- to change "set mode" to "month-day", long-press the "select" button (M/D blinks)
- with "set mode" on "month-day", press the "up" & "down" buttons to toggle between mm/dd/yy & dd/mm/yy
- to change "set mode" to "display seconds", long-press the "select" button (S blinks)
- with "set mode" on "display seconds", press the "up" & "down" buttons to toggle between "enable" & "disable"
- to change "set mode" to "offset", long-press the "select" button (TZ blinks)
- with "set mode" on "offset", press the "up" & "down" buttons to adjust the offset value by 30-minute increments
- with "set mode" on "offset", press the "select" button to force the offset back to 0
- to exit "set mode", long-press the "select" button (nothing blinking)
- with "snooze" mode activated (display blank), press the "up" or "down" buttons to repaint the display
Mark J Culross (KD5RXT)
[email protected]
Ricochet2: [SDK 2.0 compatible] a very simplistic watchface showing time, date, & battery level
Description
Ricochet2: a very simplistic watchface showing time, date, & battery level
[ SDK 2.0 compatible version ]
Time & day/date float around the screen (a la Roomba style) in a semi-random fashion, "bouncing" off the edges of the screen & "ricocheting" off of each other.
NOTE: to allow full use of the buttons, ScrSaver loads in as an app (at the same menu level as "Settings" on the Pebble), not as a watchface . . . it just displays a watchface
Features (v 2.2):
selectable white-on-black or black-on-white display
selectable date-on-top or time-on-top display mode
selectable 12/24 hour format time
selectable mm/dd/yy or dd/mm/yy format date
preference settings are maintained in persistent storage
continuously shows battery % level ("+" in front indicates charging)
Operating instructions:
to toggle between black-on-white & white-on-black displays, long-press the "select" button
to toggle between date-on-top & time-on-top display mode, double-click the "select" button (also freezes the display for 4-seconds)
to toggle between 12/24 hour format time, press the "down" button
to toggle between mm/dd/yy & dd/mm/yy date format, press the "up" button
to turn backlight on/off (automatically turns off after 4-seconds), either press "select" button, or tap/shake (also freezes the display for 4-seconds)
Mark J Culross (KD5RXT) [email protected]
WordTime2 - [SDK 2.0 compatible] a customized version of the Pebble Textwatch for my wife
Description
WordTime2 - a customized version of the Pebble Textwatch for my wife
[ SDK 2.0 compatible version ]
NOTE: to allow full use of the buttons, WordTime loads in as an app (at the same menu level as "Settings" on the Pebble), not as a watchface . . . it just displays a watchface
Features (v 2.2):
this app/watchface is based upon the original Pebble TextWatch, but modified to meet some new requirements as requested by my wife (fix minor logic errors & remove all animations) for the new Pebble that I gave her for her birthday !!
credit & thanks to sethadam1 for posting his source on github (which is what I started with for this project)
credit & thanks to sethadam1 also for the idea of a "debug mode", which I further extended by providing a means to selectively enable/disable it on-the-fly for demo and/or testing purposes
Operating instructions:
to enter "debug mode", long-press the "select" (middle) button (hour is capitalized)
with "debug mode" on, press the "up" & "down" buttons to advance or retard the time by one minute
with "debug mode" on, press & hold the "up" & "down" buttons to advance or retard the time by one minute repeatedly
to exit "debug mode", long-press the "select" (middle) button (hour is all lowercase)
Mark J Culross (KD5RXT) [email protected]
TZplus2 - [SDK 2.0 compatible] display 3 timezones
Description
TZplus2 - a Pebble watchapp that displays 3 selectable timezones
[ SDK 2.0 compatible version ]
NOTE: to allow full use of the buttons, TZplus2 loads as an app (at the same menu level as "Settings" on the Pebble), not as a watchface . . . it just displays a watchface
Features (v2.2):
- select and display three timezones, plus local time, selectable on-the-fly
(no recompile required) from a picklist of locations and timezones
- toggle between showing timezone #1 & local time in upper time slot
- uses local time to determine offset from UTC on all displays
- displays nighttime as white characters on black background & daytime as
black characters on white background
- displays +/- 1 to indicate that a particular timezone display is 1-day ahead
or 1-day behind UTC
- displays 12/24 hour format time (using current Pebble Settings)
- preference settings are maintained in persistent storage
Operating instructions:
- to turn backlight on/off (automatically turns off after 4-seconds), either press
"select" (middle) button, or tap/shake
- to toggle between local time and timezone 1 display in the upper slot,
double-click the "select" button (when "set mode" is NOT active)
- to enter "set mode" (local), long-press the "select" (middle) button (upper slot
displays local time, blinks "LOCAL" for 2-seconds, then the currently selected
local timezone blinks)
- with "set mode" on "local", press the "up" & "down" buttons to change the
local timezone (note that the hour & minute displayed for local time may
temporarily change for a second, but will then return since this time
corresponds to either the time sync'd from your phone or the time set in the
Pebble's Settings: Date & Time menu)
- to change "set mode" to "timezone 1", press the "select" button (upper slot
displays timezone 1 time, blinks "TIMEZONE 1" for 2-seconds, then the
currently selected timezone 1 blinks)
- with "set mode" on "timezone 1", press the "up" & "down" buttons to change
timezone 1 (note that the time for timezone 1 will adjust in sync with the
selected timezone to reflect the offset from UTC, taking into consideration the
local offset from UTC selected earlier)
- to change "set mode" to "timezone 2", press the "select" button (the currently
selected timezone 2 blinks in the middle slot)
- with "set mode" on "timezone 2", press the "up" & "down" buttons to change
timezone 2 (note that the time for timezone 2 will adjust in sync with the
selected timezone to reflect the offset from UTC, taking into consideration the
local offset from UTC selected earlier)
- to change "set mode" to "timezone 3", press the "select" button (the currently
selected timezone 3 blinks in the lower slot)
- with "set mode" on "timezone 3", press the "up" & "down" buttons to change
timezone 3 (note that the time for timezone 3 will adjust in sync with the
selected timezone to reflect the offset from UTC, taking into consideration the
local offset from UTC selected earlier)
- to change "set mode" to "local", press the "select" button (upper slot displays
local time, blinks "LOCAL" for 2-seconds, then the currently selected local
timezone blinks)
- to exit "set mode" at anytime, long-press the "select" button (nothing blinking)
Mark J Culross (KD5RXT) [email protected]
WordTime - a customized TextWatch
Description
NOTE: to allow full use of the buttons, WordTime
loads in as an app (at the same menu level as
"Settings" on the Pebble), not as a watchface
. . . it just displays a watchface
Features (v 1.0):
- this app/watchface is based upon the original
Pebble TextWatch, but modified to meet some
new requirements as requested by my wife (fix
minor logic errors & remove all animations)
for the new Pebble that I gave her for her
birthday !!
- credit & thanks to sethadam1 for posting his
source on github (which is what I started
with for this project)
- credit & thanks to sethadam1 also for the
idea of a "debug mode", which I further
extended by providing a means to selectively
enable/disable it on-the-fly for demo and/or
testing purposes
Operating instructions:
- to enter "debug mode", long-press the "select"
(middle) button (hour is capitalized)
- with "debug mode" on, press the "up" & "down"
buttons to advance or retard the time by one
minute
- with "debug mode" on, press & hold the "up" &
"down" buttons to advance or retard the time
by one minute repeatedly
- to exit "debug mode", long-press the "select"
(middle) button (hour is all lowercase)
Mark J Culross (KD5RXT)
[email protected]
Chrono - smooth second hand
Description
Chrono - an "analog sweep" version of Pebble's Brain watch
This is a proof-of-concept watchface, based off of Pebble's original Brain watchface, where the hands are swept smoothly (pseudo-analog) instead of jumping (digital). The amount of smoothing is a trade-off . . . any faster updates would probably drastically deplete the battery with screen updates, but likely not provide much more perceptible smoothing of the sweep.
MineSweep - locate the mines
Description
MineSweep: classic game of finding the hidden mines for Pebble
Features (v 1.0):
- indicates total number of mines hidden
- tracks number of mines found so far
- allows "hint" for a given location
Operating instructions:
- "up" button moves cursor towards the right (cursor wraps
from right edge in a row to left-most square in same row)
- "down" button moves cursor towards the bottom (cursor
wraps from bottom edge in a column to top square in same
column)
- "select" button cycles through guesses (bomb, empty,
unknown)
- "long-select" button commits to a guess (or exposes hint
for current square if unknown is indicated)
- cursor is prevented from being moved when a square is
a bomb guess or an empty guess - guess must be committed
first or the square must be returned to unknown to move
- commiting to an "empty" guess on a square that actually
contains a bomb loses the game
- successfully finding all bombs wins the game
- exit & restart the game to play again
Thanks for trying my MineSweep app . . . all feedback is
welcomed & encouraged !!
Mark J Culross (KD5RXT)
[email protected]
Ricochet - date/time bounce around
Description
Ricochet: a very simplistic watchface without being boring
Time & day/date float around the screen (a la Roomba style) in a semi-random fashion, "bouncing" off the edges of the screen & "ricocheting" off of each other.
NOTE: to allow full use of the buttons, ScrSaver loads in as an app (at the same menu level as "Settings" on the Pebble), not as a watchface . . . it just displays a watchface
Fixes (v 1.1):
updated white-on-black mode such that the background is solid black (as it should have been from the start !!)
made white-on-black mode the default
Features (v 1.1):
selectable white-on-black (default) or black-on-white display
selectable date-on_top display mode (default) & time-on-top display mode
selectable 12/24 hour format time (defaults to using current Pebble Settings)
selectable mm/dd/yy (default) & dd/mm/yy date format
Operating instructions:
to toggle between white-on-black & black-on-white displays, long-press the "select" button
to toggle between date-on-top display mode & time-on-top display mode, press the "select" button (also freezes the display for 5-seconds)
to toggle between 12/24 hour format time, press the "down" button
to toggle between mm/dd/yy & dd/mm/yy date format, press the "up" button
Mark J Culross (KD5RXT) [email protected]
ScrSaver - date/time float around
Description
ScrSaver: a very simplistic watchface without being boring
Time & day/date float around the screen (a la Roomba
style) in a semi-random fashion, "bouncing" off the edges
of the screen.
Features (v 1.2):
- selectable black-on-white (default) or white-on-black display
- selectable time-overwrites-date display mode (default) or
date-overwrites-time display mode
- selectable 12/24 hour format time (defaults to using current
Pebble settings)
- selectable mm/dd/yy (default) & dd/mm/yy date format
- freeze mode (time stops moving for 5-seconds)
Operating instructions:
- to toggle between black-on-white & white-on-black displays,
long-press the "select" button
- to toggle between time-overwrites-date display mode &
date-overwrites-time display mode, press the "select" button
(when time is displayed above date, then time-overwrites-date
display mode is active . . . pressing the "select" button also
activates freeze mode)
- to toggle between 12/24 hour format time, press the "down"
button
- to toggle between mm/dd/yy & dd/mm/yy date format,
press the "up" button
Mark J Culross (KD5RXT)
[email protected]
TZplus - 3 selectable timezones
Description
NOTE: to allow full use of the buttons, TZplus
loads as an app (at the same menu level as
"Settings" on the Pebble), not as a watchface
. . . it just displays a watchface
NOTE2: until a new version of the SDK exposes
functions for doing so, applications (including this
one) currently have no means to save/restore
settings . . . each time you start TZplus, it will
always revert to initial defaults . . . as soon as
functions are provided by the SDK that allow
apps to save/restore settings, TZplus will be
updated to take full advantage of them !!
Features (v1.0):
- select and display three timezones, plus local time,
selectable on-the-fly (no recompile required) from
a picklist of locations and timezones
- toggle between showing timezone #1& local time
in upper time slot
- uses local time to determine offset from UTC on all
displays
- displays nighttime as white characters on black
background & daytime as black characters on white
background
- displays +/- 1 to indicate that a particular timezone
display is1-day ahead or 1-day behind UTC
- displays 12/24 hour format time (using current
Pebble Settings)
Operating instructions:
- to toggle between local time and timezone 1 display
in the upper slot, press the "select" (middle) button
(when "set mode" is NOT active)
- to enter "set mode" (local), long-press the "select"
(middle) button (upper slot displays local time,
blinks "LOCAL" for 2-seconds, then the currently
selected local timezone blinks)
- with "set mode" on "local", press the "up" &
"down" buttons to change the local timezone (note
that the hour & minute displayed for local time will
not change since this time corresponds to either the
time sync'd from your phone or the time set in the
Pebble's Settings: Date & Time menu)
- to change "set mode" to "timezone 1", press the
"select" button (upper slot displays timezone 1
time, blinks "TIMEZONE 1" for 2-seconds, then
the currently selected timezone 1 blinks)
- with "set mode" on "timezone 1", press the "up" &
"down" buttons to change timezone 1 2(note that
the time for timezone 1 will adjust in sync with the
selected timezone to reflect the offset from UTC,
taking into consideration the local offset from
UTC selected earlier)
- to change "set mode" to "timezone 2", press the
"select" button (the currently selected timezone 2
blinks in the middle slot)
- with "set mode" on "timezone 2", press the "up" &
"down" buttons to change timezone 2 (note that
the time for timezone 2 will adjust in sync with the
selected timezone to reflect the offset from UTC,
taking into consideration the local offset from
UTC selected earlier)
- to change "set mode" to "timezone 3", press the
"select" button (the currently selected timezone 3
blinks in the lower slot)
- with "set mode" on "timezone 3", press the "up" &
"down" buttons to change timezone 3 (note that
the time for timezone 3 will adjust in sync with the
selected timezone to reflect the offset from UTC,
taking into consideration the local offset from
UTC selected earlier)
- to change "set mode" to "local", press the
"select" button (upper slot displays local time,
blinks "LOCAL" for 2-seconds, then the currently
selected local timezone blinks)
- to exit "set mode" at anytime, long-press the "select"
button (nothing blinking)
Mark J Culross (KD5RXT)
[email protected]
DblTime - dual timezone display
Description
NOTE: to allow full use of the buttons, DblTime
loads in as an app (at the same menu level
as "Settings" on the Pebble), not as a
watchface . . . it just displays a watchface
NOTE2: until a new version of the SDK exposes
functions for doing so, applications (including
this one) currently have no means to
save/restore settings . . . each time you start
DblTime, it will always revert to initial defaults
. . . as soon as functions are provided by the
SDK that allow apps to save/restore settings,
DblTime will be updated to take full advantage
of them !!
Features (v 1.6):
- dual date & time displays
- with black-on-white for daytime displays &
white-on-black for nighttime displays
- adjustable # hours offset (-23:30 to +23:30) in
30-minute increments, between primary &
secondary time displays (default = 0)
- when # hours offset = 0, secondary date & time
are not displayed (primary time display only)
- enable/disable snooze mode (display blanks after
10 seconds) - default = enable
- enable/disable hourly chime mode (buzzes on the
hour & activates display) - default = disable
- selectable mm/dd/yy vs dd/mm/yy date display -
default = mm/dd/yy
- enable/disable display seconds display- default =
enable
- displays 12/24 hour format time (using current
Pebble Settings)
- eliminated delay when showing time at start-up &
when waking from snooze
Operating instructions:
- to enter "set mode" (snooze), long-press the "select"
(middle) button (Z's blink)
- with "set mode" on "snooze", press the "up" &
"down" buttons to toggle between "enable" &
"disable"
- to change "set mode" to "chime", long-press the
"select" button (bell blinks)
- with "set mode" on "chime", press the "up" & "down"
buttons to toggle between "enable" & "disable"
- to change "set mode" to "month-day", long-press
the "select" button (M/D blinks)
- with "set mode" on "month-day", press the "up" &
"down" buttons to toggle between mm/dd/yy &
dd/mm/yy
- to change "set mode" to "display seconds",
long-press the "select" button (S blinks)
- with "set mode" on "display seconds", press the
"up" & "down" buttons to toggle between "enable"
& "disable"
- to change "set mode" to "offset", long-press the
"select" button (TZ blinks)
- with "set mode" on "offset", press the "up" & "down"
buttons to adjust the offset value in 30-minute
increments
- with "set mode" on "offset", press the "select" button
to force the offset back to 0
- to exit "set mode", long-press the "select" button
(nothing blinking)
- with "snooze" mode activated (display blank), press
the "up" or "down" buttons to repaint the display
Mark J Culross (KD5RXT)
[email protected]