(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 '%imangerf07%') 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
User Notes:
for any questions visit my twitter account:
- this version to been edited by @imangerf07
NOTE:
For icons show the actual status of notifications for this need to change the "Bundle ID" in the application "SmartWatch +" Available in Cydia.
In the first line be added: net.whatsapp.WhatsApp
In the second line be added: com.apple.MobileSMS (default)
In the third line be added: com.facebook.Facebook
- SmartFace+ (FlipStatus) is FREE! That said, please support RobH and buy the required Smartwatch+ companion app on Cydia… it’s worth every penny
- You MUST have a JAILBROKEN iPhone on iOS 7.0.4 or 7.0.6 to use SmartFace+ (FlipStatus) (if you are not jailbroken and have already upgraded to iOS 7.1 or 7.1.2, you are screwed). THIS APP WILL NOT WORK WITH THE APP STORE VERSION OF SMARTWATCH+
- You MUST upgrade Smartwatch+ to 1.600 using Cydia (restart the iPhone)
- You MUST have Weather enabled in Smartwatch+
- You REALLY SHOULD read the PDF instructions for SmartFace+ (FlipStatus) here: http://bit.ly/1gXuuIq (it will make usage and secret buttons much easier to understand)
- There is a KNOWN ISSUE where Flip Status will sometimes crash when you try to close it… I have no idea why. If somebody else does, please let me know.
Developer Notes:
- SmartFace+ (FlipStatus) pushes the memory limits of a watch app, if you make changes and SmartFace+ (FlipStatus) crashes, despite your code being correct, this is probably why.
- There is temporary code in there for a feature I am working on to auto reply to SMS and Phone calls with your canned text messages… you can take it out of you want, but if you modify FlipStatus and want to re-add this feature later, it will probably not work with your changes (the app will be too large)
- FlipStatus code is shared on GitHub under GPLv3. This means that you can modify, post your code to a public place and distribute, but you cannot modify then keep your code private or attempt to profit from it in any way.
- Here is the GitHub repo: http://github.com/AstroPoverty/FlipStatus
- If you want to modify FlipStatus, I would prefer one of two ways (but it’s up to you entirely):
- Make a formal request to “fork” the GitHub repo. This will ensure that your code remains public and we can all learn from one another.
- Make a request to me if you would like to see something added to the official repo.
Update History
- In this version the icons change was applied.
- System not been modified and carries all the original code Flipstatus
For any concerns or questions visit my twitter account:
@ imangerf07
created by - imangerf07
-
Description
User Notes:
for any questions visit my twitter account:
- this version to been edited by @imangerf07
- SmartFace+ (FlipStatus) is FREE! That said, please support RobH and buy the required Smartwatch+ companion app on Cydia… it’s worth every penny
- You MUST have a JAILBROKEN iPhone on iOS 7.0.4 or 7.0.6 to use SmartFace+ (FlipStatus) (if you are not jailbroken and have already upgraded to iOS 7.1 or 7.1.2, you are screwed). THIS APP WILL NOT WORK WITH THE APP STORE VERSION OF SMARTWATCH+
- You MUST upgrade Smartwatch+ to 1.600 using Cydia (restart the iPhone)
- You MUST have Weather enabled in Smartwatch+
- You REALLY SHOULD read the PDF instructions for SmartFace+ (FlipStatus) here: http://bit.ly/1gXuuIq (it will make usage and secret buttons much easier to understand)
- There is a KNOWN ISSUE where Flip Status will sometimes crash when you try to close it… I have no idea why. If somebody else does, please let me know.
Developer Notes:
- SmartFace+ (FlipStatus) pushes the memory limits of a watch app, if you make changes and SmartFace+ (FlipStatus) crashes, despite your code being correct, this is probably why.
- There is temporary code in there for a feature I am working on to auto reply to SMS and Phone calls with your canned text messages… you can take it out of you want, but if you modify FlipStatus and want to re-add this feature later, it will probably not work with your changes (the app will be too large)
- FlipStatus code is shared on GitHub under GPLv3. This means that you can modify, post your code to a public place and distribute, but you cannot modify then keep your code private or attempt to profit from it in any way.
- Here is the GitHub repo: http://github.com/AstroPoverty/FlipStatus
- If you want to modify FlipStatus, I would prefer one of two ways (but it’s up to you entirely):
- Make a formal request to “fork” the GitHub repo. This will ensure that your code remains public and we can all learn from one another.
- Make a request to me if you would like to see something added to the official repo.
created by - imangerf07
