(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 '%wwsean08%') 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
This is a watch face for the house of Stark, it includes the Stark household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Greyjoy, it includes the Greyjoy household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/18/2013:
*I have made some slight modifications to pretty up greyjoy a little bit by getting a couple of features to actually appear.
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Baratheon, it includes the Baratheon household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Lannister, it includes the Lannister household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Targaryen, it includes the Targaryen household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Tully, it includes the Tully Household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Arryn, it includes the Arryn Household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Cerwyn, it includes the Cerwyn Household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Hornwood, it includes the Hornwood Household sigil, saying, and of course the time.
Please note that this looks much better on the actual watch than it does in the preview!
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Jordayne, it includes the Jordayne Household sigil, saying, and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Frey, it includes the Frey Household sigil, title (as we don't have a saying for them yet), and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
Description
This is a watch face for the house of Karstark, it includes the Karstark Household sigil, title (as we don't have a saying for them yet), and of course the time.
For the source and more information (or more watchfaces) feel free to checkout my site, http://wwsean08.com/pebble/game-of-thrones/
Change Log:
6/1/2013:
*Recompiled with the 1.1 SDK to produce a smaller pbw file.
5/22/2013:
*Changed the font of the house saying to reflext the GoT font with bar's thru the O's
created by - wwsean08
-
Description
Gate Watch was a watchface I created for the pebble inspired by the shows Stargate SG1, Atlantis, and Universe, with the iconic stargate surrounding the time on the watch. Although the detail isn't great, any stargate fan that sees this will instantly recognize this.
For more information and source code please feel free to visit my site, http://wwsean08.com/pebble/gate-watch/
created by - wwsean08
Description
This is an alternative version of the Gate Watch using the alteran font. It is quite easy to read once you get used to it, and will be a hit with the geeks.
Here's the font that I used, http://www.fonts2u.com/alteran-regular.font
created by - wwsean08
