Database Develop

Desktop Folders? Yes, you can!

I have discovered a way to create folders on the ADW desktop without having to use additional software/android packages. Basically you have to manipulate a table in the launcher database.
Photos
1) Shows the folder “System Stuff” on the desktop. (Look for it near Santa’s beard.)
2) Shows the “System Stuff” folder open and with applications inside
3) Shows the edited fields of the favorites table of the launcher.db
My Setup/Requirements
NookColor Rooted/ADB access
ADW.Launcher installed (I am running version 23)
Root Explorer
SQLite Editor installed
Linda File Manager installed (optional, but necessary if you want to create shortcuts to books)
Steps
1. Open Root Explorer and find the database for the launcher. Mine is located at /data/data/org.launcher/databases
2. Open the database. (Mine is called launcher.db)
3. Open the favorites table
4. Use the menu button to create a new record and enter the following information into the fields:
_id = Assign the next sequential record id (increment +1 from the last record in the table)
Title =The name you want to give your folder
Intent = Leave blank
Container = -100
Screen= 1 (or the number of the screen you want the folder displayed on)
cellX = 2 (or the column you want the folder displayed on)
cellY = 0 (or the row you want the folder displayed on)
spanX = 1 (the folder will be 1X1 in size)
spanY = 1 (the folder will be 1X1 in size)
itemType = 2 (this declares the type to be something other than a shortucut)
appWidgetID = -1 (this identifies the widget as a folder)
5. Save the record
6. Exit Root Explorer
7. Reboot the NookColor
8. When the system finishes booting, you should now see a folder on whatever screen you put it on.
9. To add items to the folder, simply click and drag.
Comments: You can also add shortcuts to the folder by manipulating the favorites table in the launcher.db. You find your shortcut in the table and modify the record so that the container field is the same as the _id field of the folder shortcut.
I added Linda File Manager to the Setup/Requirements list because if you want to add books to a folder, LFM is the only program so far that I’ve seen that will allow the creation of a shortcut (for a book) to the desktop.

Slipsystems Automate My Life

AUTOMATE MY LIFE
A LIST OF AUTOMATION SCRIPTS AND PROGRAMS THAT WILL AUTOMATE YOUR EVERYDAY LIFE.
MOST BUT NOT ALL OF THESE TUTORIALS REQUIRE TASKER AND A PLUGIN OF SOME SORT.
WINDOWS TUTORIALS CAN BE FOUND IN THE FIRST POST.
LINUX TUTORIALS CAN BE FOUND IN THE SECOND POST.
GENERAL TUTORIALS CAN BE FOUND IN BOTH POSTS.
THERE WILL BE SOME TASKS THAT ARE ONLY LISTED ON WINDOWS AND SOME TASKS THAT ARE ONLY ONLY LISTED ON LINUX, THIS DOES NOT MEAN IT IS NOT POSSIBLE TO PERFORM THEM ON OTHER PLATFORMS IT JUST MEANS I AM UNSURE OF HOW TO GET THEM TO WORK.
WINDOWS
Automatically Turn On Your Computer on a Schedule
Over View
This task is reasonable easy to set up, It will allow you to turn on your home or work pc on a schedule. In this case we are turning on our computer as soon as we unplug our device from the charger.
Requirements
Tasker
Wol Wake on Lan Wan
Setup
Before we get into creating our task we first need to set up the Wol Wake on Lan Wan application
Enable Wake on Lan
On the computer go to Control Panel>Network and Internet>Network and Sharing Center
Click on Change Adapter settings
Right Click on Ethernet and go to properties
Click Configure and then click the Advanced tab
Find Wake on Magic Packet and Change the Value to Enabled
Find Your Mac Address
Open Command Prompt
type "ipconfig /all"
under Ethernet adapter find physical address(00-11-22-33-44-55)
Remember It or write it down
Setup Wol Wake on Lan Wan
Open Wol Wake on Lan Wan
Press Add New
Under Name Call It Anything
Under Mac Enter your mac address as in ipconfig
Under SecureOn Leave As Is
Under IP or Domain Enter your Default Gateway also found in ipconfig
Under Port Leave as is
Check Send as Broadcast
The Rest is fine as default
Press Save
Create The Task
Open Tasker
Press the TASKS Tab
Press The +
Give The Task A Name Like Switch on Home PC
Press The +
Press Plugin
Press WoL Wake On Lan
Press the configuration pencil
Select the name you chose when setting up Wol Wake on Lan
Press the back button twice to save changes to configuration and task
Create The Profile
Press the profiles tab
Press the + Button to add a new profile
Select State
Select Power
Select Power
Select Source Any
press back to save
select the task we created
long press on the task and press move to exit

LINUX
Notify Me When Detecting Movement In My House
Overview
We will use simplecv as a security camera to detect motion in our house. it will then send a notification to our phone alerting us that someone is inside.
Requirements
SimpleCV
WebCam or IP Camera
Tasker
Autoremote
Setup
Install SimpleCV
Thanks To Tinkernut for this tutorial
Open Terminal and Type
Code:
sudo apt-get update
sudo apt-get install ipython python-opencv python-scipy python-numpy python-setuptools
sudo pip install https://github.com/sightmachine/SimpleCV/zipball/master
sudo pip install pyparsing svgwrite
simplecv
Setting Up The Script
Make a new python file called camera.py
Code:
sudo nano camera.py
and paste this code
Code:
'''THIS IS A MOTION DETECTING PROGRAM FOR THE RASPBERRY PI
It is part of a tutorial series that you can find here:
https://www.youtube.com/playlist?list=PLlg8lN4r9qWiDzF13lJY-lGtiTFHHGcpx
Running this program requires installing SimpleCV as well as
a few other prerequisits on your pi. You can find detailed
instructions for how to do that here:
http://tinkernut.com/YtQH9
The script was slightly modified by slipsystem to send a autoremote command
'''
#!/usr/bin/python
#import the SimpleCV, shutil and urllib libraries
from SimpleCV import *
import shutil
import urllib
#set autoremote variables
#key taken from http://goo.gl/xxxxx
autoremotekey = ""
#message to send autoremote
autoremotemessage = "Motion Detected"
#initialize the camera
cam = Camera()
#set the max display size
display = Display((800,600))
#create a threshold variable to change motion sensitivity
threshold = 0.5
#get the date for saving images
datestr = time.strftime("%Y%m%d")
#set a streaming variable to stream webcam online
streaming = JpegStreamer("0.0.0.0:1212")
#create destination directorie for the pictures
dst = "pic/%s" % (datestr) #destination directory for images
#if the picture directories don't exist, create them
if not os.path.exists(dst):
os.makedirs(dst)
#create a loop that constantly grabs new images from the webcam
while True:
#set a time variable that updates with the loop
current_time = time.time()
#grab an image still from the camera and convert it to grayscale
img01 = cam.getImage().toGray()
#wait half a second
time.sleep(0.05)
#grab an unedited still to use as our original image
original = cam.getImage()
#set webcam image
original.save(streaming)
#grab another image still from the camera and conver it to grayscale
img02 = cam.getImage().toGray()
#subract the images from each other, binarize and inver the colors
diff = (img01 - img02).binarize(50).invert()
#dump all the values into a Numpy matrix and extract the mean avg
matrix = diff.getNumpy()
mean = matrix.mean()
#find and highlight the objects within the image
blobs = diff.findBlobs()
#if the mean is greater than our threshold variable, then look for objects
if mean >= threshold:
#check to see if any objects were detected
if blobs:
#find the central point of each object
#and draw a red circle around it
for b in blobs:
try:
loc = (b.x,b.y) #locates center of object
original.drawCircle(loc,b.radius(),Color.RED,2)
except:
e = sys.exc_info()[0]
#use the current date to create a unique file name
timestr = time.strftime("%H%M%S")
#initialize the counter variable
i = 1
#check to see if the filename already exists
while os.path.exists("pic/motion%s-%s.png" % (timestr, i)):
#if it does, add one to the filename and try again
i += 1
#once a unique filename has been found, save the image
original.save(dst + "/motion%s-%s.png" % (timestr, i))
#print results to terminal
print("Motion Detected")
f = urllib.urlopen("https://autoremotejoaomgcd.appspot.com/sendmessage?key=" + autoremotekey + "&message=" + autoremotemessage)
print("Message Send " + f.read())
open autoremote and follow your link (goo.gl/xxxx)
once you have opened the link you will notice the url say something like key=xxxxx
paste the key inside autoremotekey = ""
save the script by typing ctrl+x
run the python script by typing
Code:
python camera.py
now your camera server should be running ,if you move in front of the camera you should see a output of motion detected
Create The Task
The Task can be whatever you want to run when the camera detects motion in my case I have it play your dongeon is under attack then open the camera viewer. but for the purpose of this tutorial we are going to make it just open the camera.
Open Tasker
Press the TASKS Tab
Press The +
Give The Task A Name Like Camera
Press The +
Click Net
Click Browse URL
Enter the Ip address of your computer(ifconfig) followed by :1212 (192.168.1.12:1212)
Press the back button to save
Press the +
Press Task
Press Wait
adjust the slider to one minute so we don’t get bombarded with messages
press back twice to save configuration and task
Create The Profile
Press the profiles tab
Press the + Button to add a new profile
Select State
Select Plugin
Select Autoremote
Press the Configuration pencil
Check Event Behavior
Message Filter type Motion Detected
press back twice to save
click the newly created task

NFC, plugin auto input mistake...really easy question...

I'm trying to get auto input upon NFC event to click the start command on the wo mic app menu of (wo mic app). The options for what to click are just "start, settings, mute, drop down menu".
1. event: nfc tag
2. task edit:
1. launch app
(app wo mic)
2. wait
1 seconds
3. autoinput action
configuration type: text value: start action: click...x,y coordinates
text: "start"
I've done this via easy setup and it seems to have gotten everything correct, will launch app but not select "start"
its frustrating, shouldn't I have that "wait"command?

Well, the way I see it, either the coordinates are wrong (and the Start button doesn't get clicked) or you need a longer wait.

tried that, any other ideas?
also cant upload pictures yet so thats a big limit on this

[Ask] Create or add volume keys on navigation bar ?

hello
I want to add volume buttons on navigation bar for my handy daughter.
for ex:
volume (-) on left
classic navbar buttons (on center)
volume (+) on right
(She have a Teclast T30 with Android 9)
I try custom navigation bar app but it have some issues (buttons disappearing when rotate)
I try systemui tuner but no navigation bar entries
So for now, i want to try with tasker but i'm a noob
Can somebody help me to create this profil ?
thx for all

Nobody to help me ?

Let me start by saying that if you have zero experience with Tasker, please help yourself by working through some beginner tutorials found in excess online.
You will need to decide what type of profile should trigger the task containing the following actions. Maybe when specific apps are launched (video, music, ...). Or maybe you want them displayed always which means an "on boot" event. Or something else
This is straightforward using the built in "settings -> custom setting" action. If the device is not rooted, you will need to give write secure settings permissions to tasker through ADB.
Reference the "Using Shell Commands" section (scroll down pretty far) of How to Add Left/Right Keyboard Cursors to the Nav Bar during Text Input post.
It's very similar except instead of using the keycodes for left and right cursor movement (21, 22), we're using the keycodes for volume up and volume down (24,25).
We are also using volume up/down icons instead of left/right. The link to the website to get the icons is on that same page, in the same section. The links to the pages containing the 64x64 icons I used are: Volume Up and Volume Down.
And most importantly, instead of using a run shell command action, we're taking advantage of the relatively new custom setting action. As described above, you don't need a rooted device for this as long as you give the permissions through ADB.
I created a folder under the Tasker folder called "NavIcons" to hold icons for tasks like this. You may need to try different icon sizes to find a size that suits your device.
There is a nice summary of keycodes here.
add volume +/- buttons
Code:
A1: Custom Setting [
Type: Secure
Name: sysui_nav_bar
Value: key(25:file:///storage/emulated/0/Tasker/NavIcons/volume-down-64.png),back;home;key(24:file:///storage/emulated/0/Tasker/NavIcons/volume-up-64.png)
Use Root: Off
Read Setting To:
remove volume +/- buttons (without recent button)
Code:
A1: Custom Setting [
Type: Secure
Name:sysui_nav_bar
Value: space,back;home;menu_ime
Use Root: Off
Read Setting To:
remove volume +/- buttons (with recent button)
Code:
A1: Custom Setting [
Type: Secure
Name: sysui_nav_bar
Value: space,back;home;recent,menu_ime
Use Root: Off
Read Setting To:

Thanks for all !!
I understood how to and it work !
I launch this task on event "home launcher" because on "on start" don't work
Many thx !!

S Pen Button Remap (Bluetooth Single/Double/Long Press, Hover)

Hi,
This guide will show you how to remap your Spen/Stylus Bluetooth button + Hover action + button press while hovering the screen to any action/app/task you want.
This guide will only show beginners guide. Further per app action configuration is not shown. It is DIY but if you want to share your configuration, you are welcome here.
Requirements (will not work without these) :
1. Samsung OneUI Based Roms (Sure will not work on lineage)
2. Spen/Stylus with Bluetooth capabilities (Knock offs will not work)
3. Spen/Stylus paired to your phone and Air actions enabled
4. Tasker Latest Beta (As its Tasker guide)
5. Note 9 (Oneui 2.0/2.1)
My Configuration:
Device: N960F Exynos
Rooted: Yes
How to:
1. Import Tasker projects from link below (Extremely Beginner Friendly)
Links:
Download
Steps:
Download above file
Import to Tasker
Enable it and Then detach spen to use it
Change Task or Try it out first
OR
2. DIY and Other methods of hover/Single press while hover will be soon posted.
Troubleshoot:
• Remap does not work:
1. Check requirements again
2. Make sure Tasker is not disabled/Profile is not disabled
3. Make sure necessary permissions are given to Tasker already.
4. You will need to check point 2 in How to guide above and find button clicks for your device if they are different and replace above with your ones.
• Other actions also initiates/duplicate actions:
1. If long press is defined in Settings > Spen > Air Actions then assign it to Tasker secondary app and detach Spen > long press > popup comes about secondary app > disable it
2. Disable per app actions in Settings > Spen > Air Actions
3. Turn off Air command if you want button pressed while hovering remap
4. If you want to disable customisation while in particular app, in tasker profile like in above project Single Click -> long press on current context -> add context -> application -> select applications and tick invert box at bottom -> press back (Example already added in the project file)
Further DIY:
1. Per app configuration
2. Initiate multiple actions/shortcuts/activities
3. Create an app out of it (However Tasker is superior with many options)
Tags:
Ble Stylus Spen note note9 note10 capacitive remote air action airaction

2. Spen/Stylus with Bluetooth capabilities (Knock offs will not work)
what does it mean?
and please share tasker download link

amirfrkhi said:
2. Spen/Stylus with Bluetooth capabilities (Knock offs will not work)
what does it mean?
and please share tasker download link
Click to expand...
Click to collapse
Counterfeit Spen will not work that do not possess bluetooth capabilities.
Tasker Link: Download

Error
when i import it said error. contain bad data

amirfrkhi said:
when i import it said error. contain bad data
Click to expand...
Click to collapse
Which tasker version you are using? I reinstalled tasker just for you and used same file and imported it with no problems. Are you importing as project or 3 dots->data->restore? It should not fail.
Reattaching file for you to this reply. Extract it and import. Hope it works.