Database Develop

Problems with video files

I am having problems playing video files with my Tilt.
In explorer, I can not "click" on a .mpg file that I downloaded from the net and have it play. (They play fine when transfered to a PC) It says that I need to open from within an application. Okay....how do you open a particular file from within Windows Media? This is probably a silly question for most of you....but it is fustrating to me!
P.S. To whoever suggested charging a dollar for those who start a thread, that has been repeated....where do I send the money? It would be well worth it to me....simply NOT to feel so guilty when I ask what is likely to be such a "stupid" question to most. If I paying the price....I won't feel guilty at all!!!

mlpoland said:
I am having problems playing video files with my Tilt.
In explorer, I can not "click" on a .mpg file that I downloaded from the net and have it play. (They play fine when transfered to a PC) It says that I need to open from within an application. Okay....how do you open a particular file from within Windows Media? This is probably a silly question for most of you....but it is fustrating to me!
P.S. To whoever suggested charging a dollar for those who start a thread, that has been repeated....where do I send the money? It would be well worth it to me....simply NOT to feel so guilty when I ask what is likely to be such a "stupid" question to most. If I paying the price....I won't feel guilty at all!!!
Click to expand...
Click to collapse
Maybe you have lost the file associations
http://forum.xda-developers.com/showthread.php?p=1776275
JJ

File association?
Is there a way of checking to see if I have lost the "file association" somehow, without downloading something that I don't understand?
Following the thread the comment was made:
(I don't know how to a quote so I copied the text)​
"Note that it contains a lot of additional HKCR entries. I tried very hard to delete all the non multimedia-related keys but there still are. Therefore, you'll want to clean up the file before deploying and ONLY leave associations that are definitely set by TCPMP."
I have no idea what either "HKCR" or "TCPMP", so therefore I'm relunctant to blunder ahead.

mlpoland said:
Is there a way of checking to see if I have lost the "file association" somehow, without downloading something that I don't understand?
Following the thread the comment was made:
(I don't know how to a quote so I copied the text)​
"Note that it contains a lot of additional HKCR entries. I tried very hard to delete all the non multimedia-related keys but there still are. Therefore, you'll want to clean up the file before deploying and ONLY leave associations that are definitely set by TCPMP."
I have no idea what either "HKCR" or "TCPMP", so therefore I'm relunctant to blunder ahead.
Click to expand...
Click to collapse
Actually I'm so used to using "Coreplayer" that thinking about it again, I don't think there's any point in associating MPGs with WMplayer 'cos I don't think it can play them anyway (does play AVI, Mpeg-4, WMV ). Sorry to mislead you. Maybe you should consider Coreplayer:
http://www.mobihand.com/product.asp?id=8905
JJ

or the free version of coreplayer
http://pocketpcfreewares.com/en/index.php?soft=1080
but coreplayer have been reported to work better with the qualcomm cpu
because wmp as said is somewhat limited in what codecs it support
ms like to push their own formats

How to display Java Games in Full Screen ?

Hi,
I tried a few java games today from gameloft, and they eventually showed up 320x240 (which is very small) on my diamond.
Anyone knows a way to make the game to show full screen ?
Any help would be appreciated.. thanks
(I've tried the 'search' button)

denis_sianto said:
Hi,
I tried a few java games today from gameloft, and they eventually showed up 320x240 (which is very small) on my diamond.
Anyone knows a way to make the game to show full screen ?
Any help would be appreciated.. thanks
(I've tried the 'search' button)
Click to expand...
Click to collapse
AFAIK there is no way of scaling up games. you need to install 640x480 games to get full screen (as that is the screen res).

Any links ?

of course not, we don't condone warez

to be honest, i havent found any worth playing!

Addicteddddd said:
of course not, we don't condone warez
Click to expand...
Click to collapse
Links to online shops?

Mr.Sir said:
Links to online shops?
Click to expand...
Click to collapse
Google?

Many games are "clever" to detect the screen resolution, not because the VGA as we have in diamond , because of
many kinds of mobiles with many resolutions, i have some java games working fine with the vga resolution (beside the
fonts are too small)

java
there is a small app to change resolution, You have to open *.jar file and edit something, google it cause i do not remember all

If you are going to buy a game, bejeweled 2 is great!

mugglesquop said:
Google?
Click to expand...
Click to collapse
I don´t want that, I just wanted to point that links to shop is not warez, or is it? What is warez? I thought it was pirated stuff.

mugglesquop said:
to be honest, i havent found any worth playing!
Click to expand...
Click to collapse
I had Puzzle Quest Warlords on my Instinct. I would like to be able to play that one on my Diamond.
It's basically Bejeweled with kind of an rpg storyline twist. Fun and addictive.
Can't seem to get it to run with Esmertec tho.

denis_sianto said:
Hi,
I tried a few java games today from gameloft, and they eventually showed up 320x240 (which is very small) on my diamond.
Anyone knows a way to make the game to show full screen ?
Any help would be appreciated.. thanks
(I've tried the 'search' button)
Click to expand...
Click to collapse
Some games can be changed by modifying the MANIFEST.MF file.
Here is an example (using the excellent 7Zip Program)...
Open 7Zip
Browse to your Java Game & open it
Open the folder "META-INF"
in the "META-INF" folder should be a file called "MANIFEST.MF" - right click it & choose Edit [F4] - the file should open in a text editor (i.e. Notepad).
Perform edits...
If the file contains the lines (or something similar)
Code:
Nokia-MIDlet-Original-Display-Size: 176,208
Nokia-MIDlet-Target-Display-Size: 240,320
change them to
Code:
Nokia-MIDlet-Original-Display-Size: 176,208
Nokia-MIDlet-Target-Display-Size: 480,640
Otherwise, just add them.
Mostly, you need to get the Original-Display-Size correct and even then, this doesnt work for all games.
If that doesnt work, then I have found some games contain the lines
Code:
LGE-MIDlet-TargetLCD-Width: 240
LGE-MIDlet-TargetLCD-Height: 320
Obviously these can be changed to
Code:
LGE-MIDlet-TargetLCD-Width: 480
LGE-MIDlet-TargetLCD-Height: 640
Close the text editor & save your edits
Click yes on the 7Zip message box to update the original archive
Transer the modified JAR to your device, install it & cross your fingers.
NOTE: I am by no means an expert in this arena - this info comes from searching the net, opening many JARs & trial and error (i.e. your questions will likely go unanswered).
Give it a shot - might work - I've had about 40% success.
Regards, Steve.

Android Access Database

Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
Click to expand...
Click to collapse
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.

Thanks this is deffenetly a start, From what I can tell this This Looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Forms would be as simply as making a program, this is great thanks much

kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me....
Click to expand...
Click to collapse
I would like to say, "yes, please!" to this idea. I currently use Smart List to Go (the descendant of ThinkDB) on my Palm TX. The TX is dying, and I've been shopping for a replacement. HanDBase exists for the iPhone, but I don't want an iPhone. So I've been focused on WinMo - not by choice as much as by necessity.
And android option would be very welcome around my computers.

benmyers2941 said:
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
Click to expand...
Click to collapse
androids sqlite its for applications to access and store data using java code.
try the pocket office app

Freedomcaller said:
androids sqlite its for applications to access and store data using java code.
try the pocket office app
Click to expand...
Click to collapse
Exactly and we're talking about creating an app that would enable manipulation of an sqlite database. Essentially all that would be needed would be to create a ui framework wrapper for the existing api in android. Not the least monumental task I've heard of an individual taking on but not the most either.
The versions of pocket office that I've seen for android do not currently support Access databases as far as I'm aware. If I'm wrong could you post a link and save everyone some trouble?

aaaaaaaaaaaaaaaaaaa

kronos82 said:
Thanks this is deffenetly a start, From what I can tell this looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Click to expand...
Click to collapse
Jackcess library is now patched to support android (will be in 1.2.2 release). Also seems to support 2000, 2003 and 2007 formats now.
Works great for me.

View jackcess site. Couldn't find anything on support for android. I'm using htc desire and would really like to find program to view ms access file. Can you tell me how you do it?

As I remember reading worked as on PC, while writing had some problems.
This forum prevents me from linking directly, but if you click tracker/patches on Jackcess project, check Android Compatibility Fix - ID: 3101578
The changes are in trunk and will be in the 1.2.2 release. I've added some
notes which will eventually make it to the FAQ page on the website
detailing the compatibility steps:
- Set the system property "com.healthmarketscience.jackcess.broken
Nio=true"
- Set the system property "com.healthmarketscience.jackcess.resour
cePath=res/raw/"
- Copy the *.txt, *.mdb, and *.accdb files from the
"com/healthmarketscience/jackcess/" directory in the Jackcess jar to the
"/res/raw" Android application directory.
- Before executing any Jackcess code, set the current Thread's context
classloader, e.g.
"Thread.currentThread().setContextClassLoader(Database.class.getClassLoader())".
Click to expand...
Click to collapse
Until this version (1.2.2) is released you need to build lib yourself.
You also need commons-lang and commons-logging from apache commons.
Before you use Jackcess in Android code, you set
Thread.currentThread().setContextClassLoader(
getClass().getClassLoader());
System.setProperty(
"com.healthmarketscience.jackcess.brokenNio",
"true");
System.setProperty(
"com.healthmarketscience.jackcess.resourcePath",
"res/raw/");
Click to expand...
Click to collapse
and copy those resource files to res/raw
Then you can work as on PC, for example open /sdcard/yourprogram/file.mdb
Jackcess has no GUI, it's a library to read/write access files.

Getting an Access file into Android
I keep a lot of information on a Psion Revo, which has just turned its face to the wall and is giving up the ghost, and have always backed the information up on to my pc as an Access file. It looks easier to get this into a format acceptable to Android by converting the Access .mbx file into an Excel .xls file. This can be searched readily by Column and Values. Maybe this deals with too simple a need for most enquirers to the forum, but if it helps somebody then so much the better.

hi all i have beenlooking for something the same for some time now and just the other day i came accross this site cellica.com
the android app is free and the desktop application has a 5 day trial period or its $50 to buy it works great the only thing you can not do is create a report from the phone
i have emailed support team and they said they will be adding it on in the future.

Any Updates???
I currently build and use databases in MS Access and was wondering if there are any updates on this topic now that Tablets are in use now. Looking to get the Motorola Xoom (2nd version) in the future, but would love to be able to use a program that I would be able to access my MS Access databases while "on-the-go".
Anyone? This would be huge (I believe), since we now have tablets.
Thanks a bunch,
~Kilch~

Access to MS Access by Android
Hi,
I'm also looking to get on-the-go access to my Access databases on my Android HTC Tattoo.
The file is on it, I just need a tool to access it in read-only / search mode, but judging from the previous comments, there doesn't seem to be an oversupply in applications.
The "convert to Excel format" may be OK for me. I want to use a 3 language Access DB (dictionary) on my phone, so I'll try the Excel solution.
It would be nice if we had an ACCESS reader though...
John

Panacea Database
I know XDA frowns upon excessively hawking your own products here, but I do seem to be directly answering more than one of the reply questions, it just happens that the answer is an application my company released.
The Panacea Database application can handle Access from Access 2000 to Access 2007. It has also worked so far on every Access 2010 database we've tested, and we've received no complaints in that department yet. We release updates from time to time as we improve its functionality and features, often guided in our priorities by user e-mail and market comments. Our next update will be focused on improving screen layout for a variety of Android devices - from small QVGA smartphones, to large WXGA tablets. After that we may move onto other functionality.
In the interest of fairness, I'll point out arafa1209's post. He mentions Celicca Database, which is the only other application that I know of that deals with Access databases on Android. It has features Panacea does not have (yet) - ability to work with forms, ability to create and modify databases, ability to connect to your PC etc. Like us, they also send out updates improving their app regularly. So you can compare the apps, and use which one fits your needs better (or use both). If anyone knows of any others they can post here as well, but these are the only two I know of currently.

Just tried Panacea. Although it is more basic and annoyingly doesn't remember the last files you'be opened necessitating finding the file each time you open the app I prefer it for the simple reason you don't have to convert the Access database to another format.

amwebby said:
doesn't remember the last files you'be opened necessitating finding the file each time you open the app
Click to expand...
Click to collapse
If you update the app, this should be fixed, the last version should have this feature.

Got the update last week. Certainly goes a long way to making it more user-friendly. Keep up the great work!

Since the last update it seems to be broken. Although it remembers the last database I cannot open a table within any database.
Edit: It appears the file was corrupted. Loaded a new file and all working again.

Any news in this topic.
I tried panacea Database, works fine. But not very effective. Searching data is a must for me however I didnt manage to find a search option. When I search for tables, it cant even locate the tables by names.

Where can I find .XAP decompiler for phone 8 ?

I've been searching for .XAP decompiler/disAssembler (to do reverse engineer) for phone 8 xap files. I've seen that the new .xap files are not longer simple .zip/.rar files. They have something more.
In short I'm asking something similar to http://forum.xda-developers.com/showthread.php?t=1443692 for phone 8 . Does anyone know any (free) tool which can help me out ?

Could you please attache XAP? I'll investigate it.

Sure
Please see the attachment.

It appears MS have encrypted XAPs now - this has a PlayReady DRM header:
Code:
<WRMHEADER xmlns="http://schemas.microsoft.com/DRM/2007/03/PlayReadyHeader" version="4.0.0.0"><DATA><PROTECTINFO><KEYLEN>16</KEYLEN><ALGID>AESCTR</ALGID></PROTECTINFO><KID>w3i0edJP7EOqQ6aQzdAoSQ==</KID><LA_URL>http://microsoft.com/</LA_URL><CUSTOMATTRIBUTES xmlns=""><S>9FcV5qmfIsMc+X2MVmX3Hw==</S><KGV>0</KGV></CUSTOMATTRIBUTES><CHECKSUM>Hu3+fizBvKU=</CHECKSUM></DATA></WRMHEADER>

So, does it mean I'll never be able to decompile any .xap ?

XAPs downloaded from the Marketplace are encrypted starting sometime in summer last year. That was also the time when devices that had not installed the WP7.5 update lost access to the Marketplace.
So unless you know the decryption key no: you won't be able to decompile XAP files downloaded from the Marketplace. As for XAPs you get from a Dev directly or created yourself - those should still be in the same ZIP-Format as before.

if we get admin access on the phone we can make the phone to decompile it for us and then make an unencrypted version of the .xap

StevieBallz said:
XAPs downloaded from the Marketplace are encrypted starting sometime in summer last year. That was also the time when devices that had not installed the WP7.5 update lost access to the Marketplace.
So unless you know the decryption key no: you won't be able to decompile XAP files downloaded from the Marketplace. As for XAPs you get from a Dev directly or created yourself - those should still be in the same ZIP-Format as before.
Click to expand...
Click to collapse
Does anybody developed some hack to see content of .xap files which are from market place ? if yes, where can I get it ?
ellokomen said:
if we get admin access on the phone we can make the phone to decompile it for us and then make an unencrypted version of the .xap
Click to expand...
Click to collapse
And how can I get admin permission on my phone win 8 phone ? In other words, is it possible to get admin permission on win 8 mobile ?

@shek007
WP8 is much more secure than WP7. So it will take much time or never to hack the OS.
Regarding the xap decompile, it seems you are insisting on 'hacking'. That is a bad behaviour, trying to steal other's logic/data If it's your's or friend's .xap, then you'll get access to the code. Otherwise you have no right to decompile the code if it's not yours or the others didn't provide you access.
Anyway, you got the answer back then: no, it won't work.

shek007 said:
And how can I get admin permission on my phone win 8 phone ? In other words, is it possible to get admin permission on win 8 mobile ?
Click to expand...
Click to collapse
1. No one knows what "win 8 phone" and "win 8 mobile" are. Never heard of those.
2. Go somewhere else to discuss theft.

narrowing the subject to "theft" is not appropriate as when one wants to make out the most of some applications.
Examples are: Decompile the Field Test app from nokia to see the internal API calls to the radio module in order to obtain RF related data, such as cell ID, MCC+MNC, Ec/Lo etc..
using this API calls we can make Apps for RF field engineers to test the network performance and signal levels using the Lumia phone.
This functionality is well known on others smartphones but lacking in Windows Phone platform so far.
Another example will be using multiple whatsapp accounts in the same phone ( another functionality from other mobile platform missing in WP)

As far as I understood the security architecture not just any App would be able to access those APIs even if it knew about them. It requires special permissions and I would guess that at the moment those are not available with a regular Developer Unlock.
As for decrypting the file or gaining access to the phone and extracting the data from there: WP8 security has not yet been broken. There might be people working on it but for now we know of no way to do it.

StevieBallz said:
As far as I understood the security architecture not just any App would be able to access those APIs even if it knew about them. It requires special permissions and I would guess that at the moment those are not available with a regular Developer Unlock.
As for decrypting the file or gaining access to the phone and extracting the data from there: WP8 security has not yet been broken. There might be people working on it but for now we know of no way to do it.
Click to expand...
Click to collapse
Idk if you guys know about this website... [http]://xapapp[dot]blogspot.com/
this guys does exactly what the OP asked. If m wrong then please correct me

I guess I'll have to wait until I can learn about this
Btw, I never had intention to hack/theft others app..

tai4de2 said:
1. No one knows what "win 8 phone" and "win 8 mobile" are. Never heard of those.
2. Go somewhere else to discuss theft.
Click to expand...
Click to collapse
1. Yes. No one knows what win 8 phone is.
That is why YOU are on this forum thread., because is called just like that. "Windows Phone 8" looks similar to windows 8 phone. Or not.
2. " Windows Phone 8 Development and Hacking>> Windows Phone 8 Q&A, Help & Troubleshooting" is the name of this thread. So, where else could discuss hacking windows 8 apps.
You just needed to post something.
I just needed to reply (two years later), so I joined to forum. :laugh:
BTW are there any new tools for decompile xap files?

Please don't necropost!
Posting here rather in a PM in the hopes that others will see and remember...
You just posted in a 22-month-inactive thread. This violates a near-universal guideline (sometimes rule) of online forums: do not post in dead threads (common called "necroposting"). Your post added nothing of value and effectively constitutes spam, as it brings a thoroughly outdated thread to the top of the forum list. It's much better to create a new thread (linking the old one, if you feel that will help) as then people who read earlier posts in the thread but don't notice the datestamps won't be seeing stuff that is years out of date.
While I agree that the person you responded to was being needlessly pedantic, it does seriously annoy some members of the community to have people screw up the name of the OS. Win8 and WP8 have about as much in common as Mac OS X and iOS; that doesn't mean it's reasonable to say an iPhone runs "Phone OS X". The fact that there existed a legacy (and *very* different) OS called Windows Mobile (or WinMo), and that people routinely seem to think that WP is just the continuation of WinMo (it's really, really not), is a large part of why some folks stomp on people who use the wrong name for the OS.
Decompiling apps is easy. Breaking PlayReady DRM is really, really hard. There's no decompiler anywhere I know of that can take a DRMed XAP and decompile it. You'll have to get the app without DRM encryption if you want to decompile it.
PLEASE DO NOT POST ANY MORE IN THIS THREAD!

[Q] Can someone test this AppCache website out in IE?

I have a website that uses AppCache and I would like to know if the IE engine in Windows Phone 8/8.1 supports AppCache/Local Storage/IndexedDB.
It's more of a scripting IDE than a web page and if it works correctly it will store about 5 megs of web files into an AppCache so it could work offline. You would probably need to delete/clean internet files if you want to get rid of that.
The web page is at :
http://www.obeliskos.com/TridentSandbox
At the top left (if it works correctly) you will see status for LS (local storage), IDB (indexedDB), and AC (AppCache) ... the appcache should show downloading and then idle.
Can someone test and let me know what the status information of LS/IDB/AC are.... or if you use it, how well it works? There's a samples browser button (second from right under help) if it lets you load all the samples.
Thanks

LS/IDB/AC all work great! WP8, IE10. Haven't had a chance to really play with it yet, but you will probably want to make it more mobile-friendly. We don't have meta-keys on the phone.

hah, your all over this forum and once again with good info, thanks!
Yea I was thinking of using it just as a viewer to run prg files created on tablet/desktop and saved to skydrive. I think xbox one IE also fully supports and that has skydrive and possibly keyboard/mouse as well. I guess it might be good cross-platform for simple user programs.
Looks like I have a reason to upgrade my phone sometime soon now
GoodDayToDie said:
LS/IDB/AC all work great! WP8, IE10. Haven't had a chance to really play with it yet, but you will probably want to make it more mobile-friendly. We don't have meta-keys on the phone.
Click to expand...
Click to collapse