Database Info

Where is MMS saved?

I'm sure someone has figured this out.
Where in the file system are the pictures I receive via mms saved?
I'm sure they have to be somewhere, there has to be a way to get them without the fwd to pc email / attach image to new email / email back to phone trick.
Bonus points, I deleted a thread - can I still find those images somewhere in the file system and restore them?

I believe they're stored in a sqlite3 database, so it's not as easy as just copying a file.
It looks like this is the database:
/data/data/com.android.providers.telephony/databases/mmssms.db
I don't have any mms/sms messages atm (recently wiped phone), so I don't have any data to look at in the database.
If you want, give me an IM or PM and I'll give you my cell number so you can send me an sms with a pic, so I can figure out how to extract it from the database

i dont think its in the database: its the same size no matter how many messages there is

Found it. The text and attachments are saved in /data/data/com.android.providers.telephony/app_parts
They are stored in files named something like "PART_1228000671287", with no extension.
To see what type of files they are, you can run this command on the phone (assuming you have RC30 v1.2).
sqlite3 -header /data/data/com.android.providers.telephony/databases/mmssms.db "SELECT _data, ct FROM part;"
The first column is the full path to the file, and the 2nd column is the mime type of the file

Awesome, good work Android Master JesusFreke.
too bad I have the factory RC30
(why oh why did I hit the update button that night?)*
but that's cool to know that they can be found.
Now we just need someone to apply that knowledge into making a SaveImage option appear in the MMS thread.
* on an unrelated note I need to put in another thread: when RC29 came I noticed the camera worked like 5 times better. I was even able to snap pics of the kids on the swings and they came out clear, when RC30 came it was back to blurriness as usual.

JesusFreke said:
Found it. The text and attachments are saved in /data/data/com.android.providers.telephony/app_parts
They are stored in files named something like "PART_1228000671287", with no extension.
To see what type of files they are, you can run this command on the phone (assuming you have RC30 v1.2).
sqlite3 -header /data/data/com.android.providers.telephony/databases/mmssms.db "SELECT _data, ct FROM part;"
The first column is the full path to the file, and the 2nd column is the mime type of the file
Click to expand...
Click to collapse
Would it be possible to write a program that would automatically extract the imgs/vids from that path and put them on the sd card with the correct file extension?

Sure. It would certainly be possible for rooted phones. I'm not sure for non-rooted phones.

I should have added on rooted phones on my first post.
Guess i should get off my butt and start messing around with some code.
I'm kinda leery about messing with root comands.

I think it would be possible for rooted as well. Can't applications have message privys so they can read messages? if they can read them can't they save the data?

JesusFreke said:
Found it. The text and attachments are saved in /data/data/com.android.providers.telephony/app_parts
They are stored in files named something like "PART_1228000671287", with no extension.
To see what type of files they are, you can run this command on the phone (assuming you have RC30 v1.2).
sqlite3 -header /data/data/com.android.providers.telephony/databases/mmssms.db "SELECT _data, ct FROM part;"
The first column is the full path to the file, and the 2nd column is the mime type of the file
Click to expand...
Click to collapse
Now I can save my pictures people texted me! Thanks dude!

games into games folder

hi there i've installed some games onto my HD2 (uno, FM, tonyhawks) and want to locate them in the games folder not in the main windows area. can anyone help me do this?

open file explorer. browse to windows/startmenu/programs.....look for ur games shortcuts......cut..... nd paste in windows/startmenu/programs/games. done

You're not done at all.
OK, it will move the shortcut to the correct folder, but the icon won't follow. It's defined in the registry ([HKLM\Security\Shell\Startinfo\Start] then the folder name, then the shortcut name, string value "Icon").
People making CABs should be a bit less lousy and direct shortcuts to the correct folder, same for the acompanying icon.
Actually, some people put icon definitions into several registry keys, so they will "follow" the shortcut if you move it. It's actually a satisfying alternative, if you consider it gives the user the ability to put the shortcut wherever he wants (including copying it to several locations) without losing the icon.
But yes, having shortcuts piling up into the Start Menu's first level, or even worse, placing them into dummy folders with a fixed name (sometimes in a foreign language), is pig work, and I saw even worse (yes, it's possible !) : shortcuts landing to a foreign language "Programs" or even "Start menu" folder, so actually not even displaying in the Start Menu !
When you create (or modify) a CAB file, you should heavily use aliases in order to let Windows Mobile translate them to the actual names during installation.
For instance, if you wanted to direct a shortcut to the "Games" folder, whatever its actual name in your own language is, you should NOT put it into "\Windows\StartMenu\Programs\Games" (neither into "%StartMenu_Programs%\Games", though it's still better like that), but you should actually use "%StartMenu_Programs_Games%", which will put the shortcut in the exact correct location.
You can do the same for the program's location itself. For instance, %ProgramFiles_Games% will direct it to the correct folder, according to your system's language, and will even do so, either you choose to install it on the internal memory, or on the SD card.
You can use these aliases inside registry values, too.
Unfortunately, this process may sometimes do it "too much".
It's the case on cooked ROMs, where the author may retain WWE names for some folders and translate others, sometimes using his own syntax. Since the CAB will always translate using the official way, it may still land in an incorrect location...
The ony way to be sure you'll obtain the wanted result, anyway, is to get some CAB editor program and peek inside before copying them to the pocket PC and installing them... And maybe, fix them before using them.
It will be handy each time you'll need to reinstal it, so don't mind inspecting and fixing the CABs you find : it's always better than crashing your system because something wrong or inadequate to your setup was put inside.
One classic case is TouchFlo / Sense tabs, for instance.
Unfortunately, they're all defined inside a unique XML Manila file, so you actually can't just ADD a tab : in fact, this notion does not even exist ; all you can do is overwrite your whole tabs list with another complete one, and pray that you'll end up with the same list, plus the new one... Would you bet your life on that ? I won't.
In real life, you really can NEVER trust a CAB intended to add a tab to your existing setup, as the author most probably don't have the same tabs as you have. In the best case, you'll just loose some tabs (they'll just disappear, even in the tabs list from the settings, and you won't get them back) : the programs and files are still there, but their definition file will have been replaced by the new one. And in the worst case, it will add a definition for a tab whose programs and files are not previously installed on your phone - and you'll crash it once and for all.
That's the reason why now, I never give a tab CAB containing any tabs definitions. I only provide all but the tabs list, and provide separate CABs for all the possible tabs combinations - and you have to choose and use the good one. Or use Maltwater's SenseUtil program to setup your tabs. The good news is my method will setup all the tabs in perfect order as soon as you've soft resetted the device, since my CABs contain the XML file, plus all the registry keys, plus it resets ManiFull.xml.
So, people, whatever I said about good CABs putting the shortcuts where they should... OK, you may be lucky... But the right behaviour should always be to look inside CABs before trying them. You can trust me !

i'm new coming nice to know all

russeini said:
open file explorer. browse to windows/startmenu/programs.....look for ur games shortcuts......cut..... nd paste in windows/startmenu/programs/games. done
Click to expand...
Click to collapse
It's been a while since I had the need to move icons, so there may be newer versions of this program, but the JWMDIconChanger will move the icons for you.

[Q] Exclude folders from HTC Album?

Does anyone know how to keep a folder from showing up as an album when you go to the photo tab -> albums and select either "all" or storage/device?
I have a number of folders I'd rather not see (tons of icons and such) and several I'd rather not have others see...
I've marked the folders as hidden, but that doesn't seem to stop the program from finding them. Also tried putting a "~" and a "." in front of the folder name.

Moving to device-neutral Q&A forum so that your question will get greater exposure to the XDA masses.

a 2 Minute Search gave me this
the-equinoxe said:
Key
HKLM\Software\HTC\HTCAlbum\Ignored
(if ignored doesn't exist: create it)
Make a new String Value and give it any name
example: igo
set the Data for the new value to the full path of the folder to be ignored
example: \Storage Card\iGO8
(note: all sub-folders will be ignored as well)
source
Click to expand...
Click to collapse

I really can't thank you enough! That's what I needed.
I am somewhat ashamed that all of the keywords I was looking for seem to be in that post, but I still didn't find it. Maybe I was just hung up on the word "exclude"... in any case, thanks for doing for me what I should have been able to do.

APK Batch Rename Tool (for Windows and Linux)

Hi guys!
This is a quick tool I jotted together for myself in the past couple days and found it very useful. So I decided to clean it up and share it. Hope you will like it! Do comment and ask!
APK Batch Rename Tool
* for Windows and Linux for now.
APK Batch Rename Tool recursively crawls input folder and all of its subfolders looking for Android Package files (.apk's). It reads Label and Version info from apk's found and creates a copy for each apk under the output folder but using the Label and Version info acquired.
For example a com.example.hw.apk will make Hello World! 1.21.apk provided that the label inside the package was set to Hello World! and version is 1.21.
The old and the new apk files are 100% the same in terms of content and are unchanged. Only the new copies are given new filenames. Input files are left completely intact.
Why?
Have you ever wondered what are your 1500+ apk files with wierd names nested to different wierd folders on your harddrive? Have you ever wanted to find an app but you were unable to because it had some undescriptive javaish name that made no sense reflected no version and your apps were swept across a hundred junk folders anyway? Then APK Batch Rename is the tool for you! And me!
APK Batch Rename will set a human readable name for all your Android apps, and drop such a copy into a folder. You will finally be able to browse them, sort them alphabetically and be able to pick from versions available.
How?
1. Copy all your apk files (or folders with apk files in them) into the input folder. You may copy folders of any depth. APK Batch Rename Tool will recurse all subfolders of the input folder anyway.
2. Hit or click ApkBatchRename.bat . (For Linux users it's: apkbatchrename, or on a terminal enter: ./apkbatchrename ) Wait until it finishes the job.
3. Find your freshly named files in the output folder.
Simple as that!
Have fun! & Comment!
phsorx

great work, just like reading mp3 tag then rename to "song - artist.mp3"
thanks!

Cool. I use to do it manually. Time saver app.
Thanks.

This is awesome! Thank you very much, situation you described in first post is just like mine, I find your tool very useful!

Folks,
Let me join you crediting phsorx's job, that app is just great!
Thanks and congrats!

Very cool, Works well. Always wanted to do this but was too lazy to try aapt.
I just checked:
aapt said:
badging Print the label and icon for the app declared in APK.
Click to expand...
Click to collapse
Code:
> aapt d badging Talk.apk
[B]package: name='com.google.android.talk' [/B]versionCode='130' [B]versionName[/B]='1.3'
sdkVersion:'8'
targetSdkVersion:'8'
uses-permission: **truncated***
application: [B]label='Talk'[/B] icon='res/drawable-hdpi/ic_launcher_google_talk.png'
uses-feature:'android.hardware.touchscreen'
main
other-activities
search
other-receivers
supports-screens: 'small' 'normal' 'large'
locales: '--_--' 'es' 'es_US'
densities: '160' '240'
I'll definitely use your script but with a small change to show the package name as well as its valuable for when you need to uninstall the package.
i.e label_packagename(version).apk -> Talk_com.google.android.talk(1.3).apk
Attached a slightly modified batch file and screenshot
For single file one-off renames (right-click->open with->rename single) you can use the script here.

De jo! Honfitars. Hajra Magyarok!

Customizable naming planned in future version
britoso said:
Very cool, Works well. Always wanted to do this but was too lazy to try appt.
i.e label_packagename(version).apk -> Talk_com.google.android.talk(1.3).apk
Click to expand...
Click to collapse
Hi Britoso,
Yeah! That's a neat way to do it too!
Eventually I want to make naming and spacing fully customizable! Including what attributes to pick (name, label, versionName) to constitute the filename, and what separators (_,-,(,),space) should go where.
In the howto.txt I have a little road-map for the project. Will add customizable naming too.
Will keep you guys posted.
EOF
phsorx
Ps: Anyone who has another naming suggestion drop a post! I'd be interested.

great job...bravo..
thanks

Very nice tool, thanks for sharing this .
Using it with britoso's edited script.
Edit: I would appreciate it if a log of the conversion would be saved in a \logs\ subfolder, so I can check which files were not converted properly and see if I have to do those manually.

Handy ! Thanks...

deleted

For one-off renames you can use the below batch file.
1) create the below batch file in the same folder as apkrename.bat (its attached too)
Name: rename-single.bat (change this if you want)
content:
Code:
cd "C:\change_me\ApkRename\"
apkrename.bat %1 %~dp1
Change the path(change_me) as needed.
2)Associate it with apks by right clicking on the apk and choosing "choose default program", browse and select the batch file "rename-single.bat".
Uncheck "make this the default operation"
Screenshot and batch file attached. Enjoy.
update:
-12/8 uploaded a new version that fixed a bug involving long path names with spaces.
Also added a check for success and then delete the original apk. (backup your apks just in case).
Remember to set the path to the ApkRename folder in rename_single.bat once before using it.

Really gd job )

APK Batch Rename Tool for Linux is on the way
luvgirl12345 said:
would like a linux version...
Click to expand...
Click to collapse
Hi luvgirl12345,
The Linux port is on the way & will be posted here soon!
Actually, the Windows release is running on win32 ports of a few common Linux tools. And that's so, because I am lazy. Having Linux's much better support for shell scripting plus the same tool set always at hand, porting is a breeze.
Ciao,
phsorx

Sounds very useful, thank you!

Looks nice for massive apk renaming.
Found a similar tool called APKInfo some month ago which i am using for single apk files for a while now.
But finally something for batch renaming.
Thanks

your the man!, works like a charm. Thanks!

Any plans for making an Android version of this to run on our devices?

Future plans for an on-phone version of the APK Rename Tool
del4 said:
Any plans for making an Android version of this to run on our devices?
Click to expand...
Click to collapse
Yes! Certainly. Its in the plans.
But firstly there are a few things to be fixed on the desktop version first. See road map section of the howto.txt file in the archive. The most burning issue is the so called overwrite issue that I want to be sorted out next. Say you have two copies of the same app (same name, label, versionName) but one of them has a patch against it (because its been modded by a reverser) than one of the copies will overwrite the other (ApkRename 1.10).
Secondly on a mobile device's SD card there is usually less space than on a desktop's hard drive. This implies that APK Renamer will actually have to rename the files in place instead of creating a copy of each in a separate folder. Or at least it will need to figure out the empty space left on the device, and if its not enough to hold the copies, it should offer in-place renaming instead. Not a lot of logic to add but still...
Having all the outstanding questions be figured out on the desktop still, will allow me to implement a more established version for the phone right from start. But hold still its not going to take very long
Bests,
phsorx

[APP][4.0+]Auto Move Free - the app that knows where your files should be!

Hi,
I recently launched my new app at Google Play and know I want to present it here!
Auto Move is an app, which moves all the files you want to your desired location - and you don't have to do anything for it!
Example: You want every PDF file you are downloading to be moved to a certain destination. That's no problem for Auto Move!
In order to get the app working like this, you have to add a filter, which is filtering for "pdf" files - if you want it to filter for several filetypes at once, that's no problem - just seperate the filter tags by commas. Alternatively it's possible to filter for the filename (e.g. "wallpaper" or "university").
After defining source and target destination you can save the filter now (or add just more filters) and begin filtering!
There's an option in the settings, which let you define how the app should work in the backgroud:
Service: The app will register new files automatically and begin to move them.
Time Intervall: The app will scan the filesystem for new files in the defined intervall.
no automatic filtering: The app won't do anything accept to told him so manually.
All advantages of the app:
unlimited amout of filters
easy configuration because of several filterwords in one filter
filtering for file extension or file name is possible
moving or copying of the files is possible
automatic moving (with service) oder by time intervall is possible
loss of data isn't possible since backup and restore feature
great design
RESTRICTIONS OF THE FREE VERSION:
there is a maximum of one filter
you can't restore a database backup
I've attached some screenshots, that you can look at the app.
I hope you like my app! If don't please contact me!
Here is the link: https://play.google.com/store/apps/details?id=de.luhu.automove.free

@luhu
What a most smart app I've ever seen! Good work
Can you add the case about apk files which require root permissions or xposed framework or not?

@marbulas
Thank you very much!
Do you mean that it should possible to filter for apk files with these different properties?

luhu said:
@marbulas
Thank you very much!
Do you mean that it should possible to filter for apk files with these different properties?
Click to expand...
Click to collapse
I think many people will need this app being much smarter.
(the specified amount of size of files, resorting files in specified directory based in date
(for example, many people will need to sort with folders about their photos and videos : if I take pictures today, the app put them into the folder names 20140915 made by the app automatically),
specied something other people suggests...)

Useful app i'm gone use it from now on! Keep the improvements coming

Thank you very much guys!
I'm going to look how difficult it is to implement these features!