Data Integration :: Game Stats Stored In MySql Or Xml
Aug 23, 2009
First time on here.We teach English through games. All done on flash AS3 now. Want to put courses online so I have been told to use php to communicate to server and database. My question is:Do I use mysql to save stats or xml FIRST: I will get info from xml and send it to my activities in flash - I'm OK with thisSECOND: I want to send out stats from flash to mysql OR xml. The stats are:1. Student logs on of course using username and password (well that comes in not out)2. What lesson the student is on ie: 2, 3, etc...3. Highscores for game activities4. Scores student gets on each activity As far as I can see the only stats that grow are the scores on each activity and even those could be erased periodically.
View 1 Replies
Similar Posts:
May 10, 2010
For various reasons, I would prefer to store binary data like images and videos as BLOBs within a MySQL database and have Flash retrieve that content directly from the database as opposed to getting it from a URL on a fileserver. So, I have written a PHP script that Flash calls which does a database query and returns the bitmap data from the BLOB. I have verified that the image data is being sent from the database through the PHP, but Flash either doesn't display the image or gives me an error saying that it is an unknown type.
[Code]....
Is there a way to get Loader() to accept bitmap image data that is retrieved from a BLOB in a database? Should I try to get PHP to mimic the response from an HTTP server or is there another way to load bitmap data stored as a BLOB into a display object?
View 2 Replies
Aug 17, 2006
I have written the following code to access data stored in an XML file . . .
//load the required data from the VoucherNumbers XML file
var VoucherNumbers:XML = new XML();
VoucherNumbers.load("VoucherNumbers.xml");
[Code]....
View 4 Replies
Jul 18, 2008
Im having a bit of trouble integrating dynamic variables pulled from a databse using an ASP script with a flash movie.
Background:
I need to send variables stored in a ms sql db to a flash movie to display several values.
The dyanmic element comes in because i am using an ID to select the values from the db e.g id1 = joe bloggs id2 = paul smith
etc
When i am hardcoding the id in the asp script the variables are sent to the flash movie no probs and they display correctly.
I am also printing the asp code on the page and that all displaying fine.
HOWEVER, the issue arises when i make the asp code dynamic and by that i mean I am using request.querystring to pull the id
from the URL - The print out of the asp code is still displaying the correct variables, BUT they are not being passed to the
flash movie at all - the placeholder is blank there isn't event an error!!.
Couple of things to note -
- if you change the id bit of the url in the dynamic script to the printed asp code changes
- THE FLASH MOVIE IS IDENTIAL in both scenarios
- all variable names have remained the same
- it is NOT a location of file issue as we have tested the dynamic code files In another folder and no joy
- we are not using any other file includes or asp code in any of the page - all other code has been stripped out
THE ISSUE WE HAVE IS THAT THE PRINTED VARIABLES ARE NOT BEING PASSED TO THE FLASH MOBIE in scenario 2 where the asp code is looking for the participant id dynamically (i.e from the URL)
View 1 Replies
May 23, 2007
I got a music portfolio web site running PHP, MySQL and Flash. There's a page showing all the artists my client worked for and when you click on a song title, this title is passed as a variable to a PHP page then to a Flash page. The Flash page contains an actionscript music player which then looks for the right audio file in the database and plays the song. Everything works great except for the dynamic text field which displays the song title. If the song title contains an apostrophe or a single quote, the Flash dynamic text field then shows the apostrophe.[code]
View 1 Replies
Feb 16, 2009
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replies
Jun 17, 2007
I would like flash to send and receive data from mysql.
To send data I would like to create 5 input fields, and then use a submit button.
Then to retrieve the data I would like to use the data grid or a dynamic text field.
View 6 Replies
Oct 1, 2007
I like to call for different SWF files from a link in a MySQL database to use in a Detailpage with PHP. Photos and text are no problem. The AC code is probably complicating things.
View 6 Replies
Jun 27, 2006
I need to create a stand alone desktop app that uses a database. It's been a long time since I did any VB work, and I need to learn Flash for another job anyway...is there any reason why I shouldn't use Flash for the desktop app?
View 1 Replies
Mar 24, 2007
I'm in the process of expanding an admin area for a website (coded with PHP and MySQL) and would like to get my client list into a flash combo box. the main columns I would need would be the account and the company name... In a regular example would be
<select name='client'>
<option value='2460'>Client 1</option>
<option value='2461'>Client 2</option>
</select>
If I could get this I should be away...
View 2 Replies
Feb 23, 2007
ive managed to get info from a mysql database into flash in a combo box. i have a text field and i want it to load in the corresponding data when a new title is selected in the combo box.
View 1 Replies
Jan 23, 2007
I would like load values from mySQL to select from in a combobox. I would love to do this the most simple way w/o php, but that
View 3 Replies
Mar 13, 2007
I am a DBA and I provide data to the developers at my companyin XML format. The developers create Flash graphics and use the XMLto populate data variables. I want to start requiring thedevelopers to make calls directly to my MySQL databases so anytimei have to make a change to the underlying data, I don't get stuckgenerating an updated XML file for the developers.My developers tell me a Flash graphic cannot make a calldirectly to a mySQL database. They say Flash has to reference apage in which variables are defined, such as an XML, PHP, ASP pageetc. This page, they say, is generated from database info, butFlash does not directly make the call to the database ... thatanother programming technology (XML, PHP, etc.) does and has toparse the information, making it available to Flash.
View 3 Replies
Jun 16, 2009
I am using the function below to convert a Flash AS3 Date type to a MySQL- compatible 'datetime' string. It is working fine, BUT I am worried that AS3 may not extract the 'same date format' from different client computers thereby rendering my function useless.Is there a better way of passing date to MySQL? One that gaurantees consistancy.
public function getMySQLdate(flashDate:Date):String var year:String;var month:String;var day:String;var hours:String;
var minutes:String;var seconds:String;
[code]......
View 1 Replies
Jul 29, 2006
I need to display a full recordset (say a table or a select from a table, returning many rows, not a single one) in a Flash doc, but I'm clueless. BTW, I read in other messages about amfphp which seems to be a good choice, but I can't use it on the Web Server (got no choice here).
View 2 Replies
Jul 5, 2007
make a trivia game though the big question is how shuld i load the questions (with multiple answers) from flash or from txt or from asp?
View 1 Replies
Mar 7, 2011
I am a middle school teacher and would like to create a Flash Jeopardy game for the teachers at our school to use on our school website.I would like a game similar to the game on url..I have been able to successfully create a flash jeopardy game that uses a xml file.My problem is that I have to have a swf file and an xml file for every game we create.I want to be able to have one swf file that will load many different Jeopardy games.I am using Flash CS3, Dreamweaver CS3, and MySQL.The files I have created are here: url...
View 2 Replies
Apr 4, 2010
I'm having a problem with the supposed AI that I've created for a card game that I'm making. The purpose is to have the function meant for 'player 2' to run after the human player has put down a card. What the function is supposed to do is to compare the value of the card which is stored in a array, and then according to the value assigned the AI is supposed to compared with the 4 cards in its hand and decide on which is the best possible card to pick. Though the human player's code seem to work as expected, for some reason the function for the computer did not run and instead churned out a huge chunk of data in the output. I will attach 2 separate text files; one will include the portion of the code which I highly suspect is giving the problem, the second will be the supposed error message.
View 1 Replies
Jan 1, 2010
I have a video player that is currently using XML for its video library which is all fine and dandy. Now I have some developers working on a CMS type page in PHP that is going to hopefully pass some sort of information to my player that will let it know where the video is stored on our server. Is there a way to do this without using FMS? If so does anyone have ideas where I can find the information for it.
View 2 Replies
Oct 29, 2011
I'm using URLStream to download a big file and save locally on a mobile app. To do this, i need to store the downloaded bytes on a ByteArray:
private function handleStreamProgress(event : ProgressEvent) : void {
if ( urlStream.bytesAvailable == 0 ) return;
if ( urlStream.connected ) {
[Code]....
Are these bytes from the downloaded file stored in Memory? (Profiler doesn't show any excessive memory consumption, though...)
Should I clean the byteArray after each sequence of bytes is stored?
View 1 Replies
Nov 12, 2011
I am planning on making a game with actionscript 3.0 (flash). However, I am having some security issues on saving user points. To be more specific, read below and you'll understand what's the exact problem. You are starting my flash application. PHP creates a session for your username. Playing for few minutes and reaching 750 points. You click on "Save my points" button. It connects "game.php?points=[]" with your point amount, hence, game.php?points=750. PHP connects to MySQL and does an update/insert query with the username you entered when opening application, and gets the points with $_GET['points'] as you can see on 3.
The issue is, Anyone who could directly browse "game.php?points=999999999999" would have his points saved in the database. I thought about encrypting the points, however, Flash is a client-side application and anyone could change the "points" value with an application like "Cheat Engine". Once they change the points, encrypted points will automatically be generated by Flash.
I also thought about creating a private key for each player on their signup and encrypt accordingly, but it also won't work because once an user change his points with Cheat Engine, flash will automatically encrypt the points with given private key, hence, another useless theory...
View 2 Replies
Apr 30, 2007
I was wondering... i thought this might be a dumb question to ask but ive been wondering if it is possible to remove all the data that was inserted into an array?
i.e.
ActionScript Code:
var loadAllThumbnails:Array = new Array("poop1", "poop2", "poop3", "poop4", "poop5");
someBtn.onRelease = function(){
//clears/emptys the array when released
}
View 4 Replies
Nov 12, 2007
I'd like to create one empty Flash movie that is essentially a placeholder for externally loaded content I can change through XML. This content would just be able to randomly load 1 of 3 photos, with a button linking to a website within each of the photos on page load. If the user refreshes the page, a new photo with it's link would appear, but I understand since it's random,having 3 images the same image is likely to reappear, but I can always add additional photos and links.
Does anyone know of a tutorial that might lead me on the correct path to create this? I've found some tuts, but they've been different than my need.
View 2 Replies
Feb 1, 2007
We want to be able to upload over 100+ files (if needed) to a server along with desc + keywords. I see that Flash 8 has the neccessary tools to handle file uploading, but my question is, can we have it act as a Stand alone FTP program so that we can utilize the fastest user upload, or will we be confined to the settings in the server INI settings.IE MAX_UPLOAD_TIME,MAX_FILESIZE, etc. If possible we want to avoid using the HTTP upload as it is noticeably slower. So if we can use flash to utilize user BW to upload, then that would be ideal.
View 1 Replies
May 6, 2009
I am new to Flash and ActionScript platform. Presently, I am using ActionScript 3.0.I know only basics of Flash but not in depth. My issue starts here: For example, In Windows Operating System, Paint-brush uses Clipboard for temporary storage. My question is: Does Flash have Cache(i.e., buffer for temporary storage)? If Flash has Cache, then where does the temporary data gets stored, in what form, is the data accessible or atleast viewable?
[Code]...
View 1 Replies
Mar 19, 2012
i'm trying to perform simple automated test on my Adobe Air Application. I decide to store some test data in external MS Excel file to decrease hardcode quantity. But I discovered, that this is not a trivial task, when you're working with Adobe Air.
Actually, i need to correct initialize an excelApp object, the rest part of logger is already implemented. I tried the following approach, but I can't find a package with ActiveXObject class defined.
excelApp = new ActiveXObject("Excel.Application");
View 1 Replies
Oct 14, 2010
Once a button is clicked in a submenu called SelectChar(a menu class extending my menu base class), it dispatches a custom event carrying an array of variables. This event is then listened for in the main Document Class called Engine, where the value of the passed variable can be used. For testing purposes im only passing 1 arguement in the array.
my Error when trying to trace the passed variable in isolation "trace(e.arg[0]);": 1119: Access of possibly undefined property arg through a reference with static type flash.events:Event.
Okay, i hope that made sense... heres the relevent code:
custom event class: passCharEvent.as
Code: Select allpackage com.asgamer.snipergame
{
import flash.events.Event;
public class passCharEvent extends Event
[Code].....
View 2 Replies
Jul 18, 2009
I want to extend the dictionary class. Everything works so far except that in some of my methods that need to reference the dictionary's content I make a call like:
this[ key ]
It doesn't like that. It just tells me that there's no property 'key'. Is there a way to way to access the data within this class?Also, I'm using an integer for the key.
Edit: I've found that the same behavior happens when you extend Array.
var myArray : Array = new Array();
trace( myArray[ 0 ] );
var myArrayExtender : ArrayExtender = new ArrayExtender();[code]....
Where in this case, myArray returns "undefined" and myArrayExtender throws error 1069. ArrayExtender is an empty class that extends Array and calls super() in the constructor.
View 1 Replies
Jul 31, 2009
I'm looking for a good method to compare a single bitmap data instance against an array of stored bitmap data objects. I need to figure out how I can compare and arrive at the conclusion that the result either means that the images are of the same object/aka similar or if they are two totally different images. I tried checking threshold of the result of the compare() function but my efforts have failed so far.
View 5 Replies
May 4, 2007
How to store the data text in Access databases using flash form and to search into the database. It is possible to work without server because I don't want to put this flash file on the net. how to make databases and to connect with flash and to have possibility to search the database, but to work database in the local computer.
View 1 Replies
