Flash :: SQLite With Actionscript (AIR) For All Users
Sep 27, 2010
I would like to save settings for an AIR application to a local SQLite database. Wherever I read, it's recommended that you use File.applicationStorageDirectory to save the database file.
My problem is that in most cases, the AIR application will be first started by an administrator that configs and setup the application (and save the settings to database) and later used by different users. And what I would like to know is if there is possible to save the database to a location that every user can load it from? As I understand it, File.applicationStorageDirectory points to the user directory? There is probably possible too make the admins set correct permissions and stuff, but I don't want to make it difficult too install...
View 2 Replies
Similar Posts:
Jan 12, 2011
I need to store a large amount of data that will be internally accessed often within a flash file. The database is temporary and does not need to be stored in an external file. Is it possible to use SQLite to create a database that may be used internally in flash? As far as access speeds are concerned, is this an efficient solution?
View 1 Replies
Jul 16, 2011
im having some problems trying to read a SQlite data base from flash using AS3. The data base was created with this php script:
[Code]....
As you can see, this creates a database like this: After this i need to read this database in AS3, using this very simple script:
[Code]...
View 2 Replies
Jan 10, 2012
I would like to have a Flash Application (not air) to connect to a local database. Air is not only getting unsupported by Adobe in LINUX but besides, it has serious problems and miss implementation with SQLite. So we want to connect to a local MySQL database. This application should be simple, so we do not want to also have an unnecessary web server (also local) to make a middle communication between the flash app and the MySQL server. There is this driver that allow to communicate Flash with MySQL [URL] Question is: Would it be any problem using this approach when installing the whole application to each client? (because we also in the installation should install a MySQL server).
View 1 Replies
Oct 4, 2011
I have this little piece of code to retrieve data from a local SQLite database (to an AIR app):
import flash.filesystem.File;
import flash.data.SQLConnection;
import flash.data.SQLStatement;
[Code]....
It is only a "proof of concept" piece of code and it "lives" in the first frame of the timeline of the Flash IDE. What happens? When I compile my SWF (AIR for iPhone), I get this error:
SQLError: 'Error #3115: SQL Error.', details:'no such table: 'background'', operation:'execute', detailID:'2013'
I created a basic db with a Firefox extension (SQLiteManager). What can cause this error? The table exists!
View 1 Replies
Oct 29, 2009
We have a little in-house LMS with courses built in Flash. Scores are updated and retrieved with POSTs to PHP scripts which query a MySQL database. All the course content and quiz questions are in xml files. Those XML files are easily accessible from a user's Temporary Internet Files (sort of SCORM style, for those familiar with it) and while you'd have to be pretty desperate to cheat at something like a Fire Safety test, it's still a vulnerability we'd like to solve.
I intend to move the quiz data (and eventually, the course content) into a MySQL database, then probably build the XML in PHP and echo that to the Flash course (as we've been doing to update and retrieve assessment scores). I think I could limit how and when the xml is displayed by passing hashes and shared secrets and whatnot between the PHP page and Flash, but this only limits outside access, and anyone viewing the course legitimately will still see the XML passed around (I think..).
Surely I'm not reinventing fire here. Is there a method or a technology in existence that allows the safe, discrete passage of xml into Flash?
View 1 Replies
Jun 27, 2011
The users using my website say they can't see the flash videos on the website, even after downloading the latest version of Adobe flash. May there be any reason for this ?
[Code]...
One of the users that the videos do not run for him has Windows operating system & Internet explorer browser.
I've put a check in the videos page to check if the user has the required flash version installed or not to run the video, but even if that user installs the latest flash version he keeps getting my check message, as in this screenshot: [URL]...
View 2 Replies
Aug 13, 2008
I made a game with Adobe CS3 and posted it on the internet, and some users (very few, but some) have reported that the game doesn't work, it just runs through every frame without regards to stop() or anything else..
It's at 50fps, which might matter, and it's located at [URL] if you may need to take a look at it.
I just need to know if this is something that I can fix on my end, or if these people may need to update their flash player or what else it might be?
View 0 Replies
Apr 11, 2011
I would like to know if it's possible to capture a users webcam in flash and directly upload it to YouTube without a backend server setup. Or if there are any third party providers that support this service. I see YouTube offers a live streaming API, but it seems it's only available for selected users.
View 1 Replies
Dec 27, 2010
My client wants to distribute a video to some people, specifically car dealers, but he doesn't want the video to end up on Youtube or something like that. Therefore he wants the recipients of the video to be able to see it only once. My idea to implement this is:Generate a unique key per viewerSend each viewer a link to a page with a Flash based video player, with their key in the URLHave Flash get the video from the server. On the server the key is checked and the file sent (using php's readfile or something equivalent).Then the key is invalidated.I was thinking this wouldn't take more than a day to build.I know that if you want somebody to be able to play something, you implicitly give them the power to record it as well, but the client just wants me to make it as hard as possible.
View 2 Replies
Jan 10, 2012
I'm using a regular flash video player to play rtmp streams hosted on a cdn. Does anyone know if it is possible to get a count of the number of users watching a stream, through actionscript or flash?
View 1 Replies
Mar 30, 2011
I was just wondering if it is possible to detect and display any or all of the following of someone visiting my site, preferably just using AS:
[Code]...
View 0 Replies
Nov 9, 2010
I am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?
View 4 Replies
Jan 5, 2010
I'm working on a simple todo app that has a column for each day of the week. On startup, the app checks to see if there are any incomplete tasks from before the current date. If so, they're moved to the top of the current date's column. The app is cloud-based, but the tasks are backed up for offline mode with an SQLite db. I can easily move the tasks by updating their date property, but I need the order property of each task to increment starting at 0 to place them at the top. I need to be able to define a count variable in SQLite alone and increment it with each update that's performed. I know this code doesn't work, but it's an easy way of explaining what needs to be done:
[Code]....
View 4 Replies
Dec 8, 2011
I have an as3 app which utilises an sqlite db to save metrics data. It is well known that as3 is single threaded, so when I save to this db, the Stage Video I am playing becomes jumpy! I have heard that saving db data in batches can speed up this process so I save in a loop:
for (var i:int=0; i < metricsObject.metricsComponentData.length; i++){
switch (metricsObject.metricsComponentData[i].mouseType) {
case MetricsCollator.MOUSE_OVER:
this._query_txt = "INSERT INTO " + this._tablePath[0] + " VALUES (null, " + this._sessionID +
[code]...
I have looked into pseudo threading examples but they all require a sprite or stage instance, the class I am executing this code in, is not a display class, I don't really want to pass an instance of the stage into this class.
View 1 Replies
Jan 17, 2011
I am looking to build an app that allows end users to draw and save mini animations (simple predetermined shapes that move in 2D). So far I have a written a app that allows the user to draw a single frame using simple shapes and lines, but I am having some small troubles at this stage, and have not attempted to allow the user to animate or save the drawing.
If anyone knows of a tutorial or some other resource to put me on the right path I would be very grateful. I can also share what I have if anyone would be willing to give me some pointers
View 2 Replies
Jun 10, 2011
I have a flash application. One of the options is to copy a pdf onto the users desktop, but I can not seem to get it to work. I am writing a flash application that sends "fscommands" out to batch files. This is what my batch file looks like:---------------------------------------------------------------------- ---------------------------------------@ echo off copy ../Application/pdf/Ebook.pdf %userprofile%Desktop exit---------------------------------------------------------------------- -----------------------My intent is to copy the specified file to the user's desktop. So far it does not function.
View 1 Replies
Mar 10, 2010
I am running an online flash multiplayer game. However, I have been facing a problem lately where some users cannot actually completely load all the resources required to run the game. The percentage that users get stuck at is different for different users (for instance, one could get stuck at 43% and some other at 91%). I don't think there is any problem with the files as such because the resources are completely loaded for the majority of the users and the game works just fine for them. Has anyone faced such a problem before?
View 1 Replies
Apr 19, 2010
Adobe flash: How to determine users CPU characteristics? (its mhz, its current ocupation) I need to know how fast is users computer now, and I have only 150 ms for it. How to do such thing in actionscript?
View 2 Replies
Jul 10, 2010
I am developing a ASP.NET web site where users will need to be able to create their own business cards. So, I'm looking for a tool (most likely Flash) that I can easily integrate into a web site and lets users add text and custom images to their cards and then create an image and/or PDF from their work.
is there a plugin that does this?
View 2 Replies
Jun 7, 2011
Here is my situation, everytime a user gets a new highscore, i wanna send a facebook message into my game account, and i've managed to do that with infinite session, i've stored the session data with the attributes of my account and always connects directly to my profile and posts it.
Now imagine that i want to do the same thing, but with another profile, is it possible to user the same application? Any ideas how would i identify the different accounts before logging in?
Or do i have to have different facebook programs doing the same things for different account?
View 1 Replies
Dec 30, 2009
I am creating an application in Flex that uses an embedded SQLite database. The data in the database contains quotes and other special characters which are escaped using a backslash or ''.Before I retrieve the data and render it in a Flex text area control I want to remove the ''. Is there any function in Flex which can help me do this - some equivalent of stripslashes() in PHP?
View 1 Replies
Mar 14, 2010
I'm having a problem with an expression in my sql statement in SQLite for Adobe AIR basically I have this sql = "UPDATE uniforms SET status=@status WHERE customerId IN(19,20)"; updateStmt.parameters["@status"] = args[1]; updateStmt.execute();
if I run the above code it works, updating the status when the id are 19 and 20
but if I pass the ids list as a parameter like this
sql = "UPDATE uniforms SET status=@status WHERE customerId IN(@ids)";
updateStmt.parameters["@status"] = args[1];
updateStmt.parameters["@ids"] = "19,20";
updateStmt.execute();
it gives me and error, saying could not convert text value to numeric value, which make sense because I'm passing and string but the IN expression should convert it accordingly, like it does when I pass directly the list values, why is not working the other way,
View 1 Replies
Nov 16, 2010
I'm making an application (web based) using flex and i have a requirment to access the SQLite database on the local system. There is no server running and i've decided to give them the link to the html file and see how that works out.
So in the root directory, there will be all required swf, html files, etc and a .db file. Can i access that database thro the flex web application ?
View 2 Replies
Dec 13, 2010
I have been struggling with trying to interface with SQLite and Adobe AIR. I am using the Flex 4 SDK with AIR 2.0. I modified code from a tutorial by David Tucker on InsideRIA ([URL]). I am writing in FlashDevelop (which I suppose could be my problem), and I can compile and run the app. The issue is that when I go to search the db file, I always get some error which results in the 'BREAKER' trace (ie - the 'queryError' function is called). I have tried simply running the SQL command on the db and it works fine, so there is an issue somewhere in the way Flex or AIR is handling my query (or obviously I could have made a mistake in coding).
[Code]....
View 1 Replies
Aug 17, 2011
I am going to start doing a couple of Adobe AIR projects that will be using SQLite feature provided by AIR. Since this is the first time I am attempting to do this, Since this application will be accessing a local db, I think I can open a connection to the database at the start of the app and keep it open till the application closes. Is this a right approach to use here?
How should design my application if I am using an MVC framework like Mate or Cairngorm? Should I create some wrapper class to perform the db operations so I can reuse this in some other project? Looking forward to some valuable information...
View 1 Replies
Aug 26, 2011
This link: [URL] has an interesting class to do just that! Encrypt an unencrypted database: but I'm having difficulty with a few things: You can find where the author, @probertson! Now I've got the following error: Compiler Error: Error #2044: Unhandled error:. text=Error #3125: Unable to open the database
Let me start by saying the source file works, since I've been using it (and the path) in another application. The error arises in the call to attach the source db to the newly created db.
View 1 Replies
Dec 5, 2011
I tried looking on google but without luck. I have a SELECT SQLStatement and I want to use the LIKE operator but the parameters won't work and the query give me an error
public function getUsersList(username:String):SQLStatement
{
selectRecord= new SQLStatement();
selectRecord.sqlConnection = connection;
selectRecord.text =
"SELECT id_u
[Code]...
View 2 Replies
Jan 18, 2012
I can write to db when running in IDE(FB), while after packaging a air, the app wont write to sqlite db, Why?
View 2 Replies
Mar 21, 2012
I try to display the Total sum() from a sqlStmt but all i got is [object, object], any idea how?
private function displayAmountHeading():void {
sqlStmt = new SQLStatement();
sqlStmt.sqlConnection = sqlConn;
sqlStmt.text = "SELECT SUM(Amount) FROM MainTable";
sqlStmt.execute();
[Code]...
View 2 Replies