(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 '%asyba%') 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
Turns your Android device into a remote control for your Windows PC. Control your favorite programs like Power, Power Point, Spotify, VLC (Keyboard), YouTube, Chrome , Firefox, iTunes, Monitor, Netflix, XBMC (Keyboard).
Unified Remote for Pebble , need companion app for Android, and you need to have Unified Remote full.
http://pblweb.com/appstore/5326cd204735a938ab000100/
http://play.google.com/store/apps/details?id=com.Relmtech.RemotePaid
created by - asyba
-
Description
- Used information from FlightAware.
- Is in Beta.
- Track for 3 tracking code with persist data.
- With configuration view.
- Need Internet connection.
- More feature coming if this has a future.
- Need feedback for testing if the information if right/close ([email protected]).
- the time display in my app is the approximate time of arriv/departure but in a future when the status is on route or arrived i will put the display to show the real time when arrive or is in route.
created by - asyba
-
Description
English
- Displays the stop times of collective enterprise Coniferal city in Cordoba Capital, Argentina.
- By way of example only works with these three stops are what I use most .
- Anything you want you can contact me if you need to change or add your own favorites stops.
Español
- Muestra los tiempos de las paradas de los colectivos de la empresa Coniferal de la ciudad de Cordoba Capital,Argentina.
- Solo a modo de ejemplo funciona con esas tres paradas que son las que mas utilizo
- Cualquier cosa me pueden contactar si queiren cambiar o agregar sus propios favoritos.
created by - asyba
-
Description
Plex Advance Remote
- Configuration inside JS Pebble App (need connection to internet for one time for configuration)
- 2 Clients Setup with persist data.
- Work with the new HTTP API - Home Theater and Android/iOS apps of Plex
- If only one was configure any menu client will work.
- Dont enter menu client 3 is not finished and probably will use the last configuration set.
- Next/Previous is about 15 seg of the streaming.
- Based of the work of @spangborn
Coming Soon
- 1 more client to configure.
Attention
- This not support Chromecast control Plex.
- Sometimes you must click another time more the select click to start/play the stream for the first time to the app know when you are starting to use my WachtApp if it is currently playing or in pause.
- Any problem or request plz comment and tell me :)
created by - asyba
-
-
Description
Watchface "Kingdom Hearts Nobody Dymbol"
by Watchface-Generator for Pebble
created by - asyba
-
Description
Watchface "Kingdom Hearts v3 Crown"
by Watchface-Generator for Pebble
created by - asyba
-
Description
Watchface "Kingdom Hearts v2"
by Watchface-Generator for Pebble
created by - asyba
-
Description
Watchface "Kingdom Hearts"
by Watchface-Generator for Pebble
created by - asyba
