Actionscript 3.0 :: MySQL And PHP To Make A Scoreboard?
May 29, 2009
I need to create a scoreboard for my game. I want to be able to let my user submit the time it took to complete the game to my scoreboard. I have been able to purchase webspace with SQL, PHP. I have set up my SQL database. I have found a great tutorial about how to do precisely what I wanted on YouTube BUT after starting the tutorial I realised it was ActionScript 2, I REALLY need time type of tutorial but for ACTIONSCRIPT.
I need to create a scoreboard for my game. I want to be able to let my user submit the time it took to complete the game to my scoreboard. I have been able to purchase webspace with SQL, PHP. I have set up my SQL database. I have found a great tutorial about how to do precisely what I wanted on YouTube BUT after starting the tutorial I realised it was ActionScript 2, I REALLY need time type of tutorial but for ACTIONSCRIPT. I have searched google for over two weeks now, but cannot find anything that suits.
The problem with this is, when flash receives rankings such as time, they are seperated by newlines () which makes them strings instead of integers as they rightly should be.
I'm using a time to string function to convert the time as integer (getTimer()) to a format HH:MM:SS It's fine ranking the times in the getTimer format but it all becomes a mess when trying to display the string format instead. (Considering times for all players are linked in the same string passed by PHP as time
time time time (000000
[code]...
The reason they are split with newlines is because the rankings are displayed in a single dynamic text.I tried converting each time in flash using the int function, but what would you do for newlines? The time rankings just comes out as '0' because of the newlines.I've also tried using this following function to remove the newlines and then possibly put each time into an array.
What would I check for in order to get each time into an array?Though I'd much prefer using a much more efficient and easy method for display high scores.
I need to make a scoreboard/timer that would show on a projector so that everyone can see the current points and the 8 second timer, all this controlled for a non-flash-user, considering someone else will have to do it cause I'm IN the gameshow, so it has to be easily-changable.
[[[I'd also like to mention I apparently heard that this could somehow be done sending information between flash and excel? The image attached is what it'd look like. Each peice is a graphic object in flash.
how can i make a shared object save a user name for a scoreboard it works like this i made a mc that is the scoreboard and the scoreboard has text boxes in it and the game gets a popup when it starts with a editeble text i want that text to save on to a text box in the scoreboard mc how can i do that?
what I should read up on to let me store 'very flexible' data in a mySQL database?I've written an AS3 'online experiment' platform (soon to be opensource) where I run my psyc experiments (e.g.[url]..- a follow up to this [url]...experiments specified in XML). The big issue is that I want to be able to store data from many experiments in mySQL.
Each experiment will have a different list of variables it will want to store. E.g.
How on earth do I get mySQL to be so flexible??? Currently I have as3 -> php -> boring file on my server. Can you advise on reading material for me to learn how to make php -> mySQL flexible enough to do this?
make a PHP, mySQL, Flash calendar. I want to do this to teach myself a little bit about all three of these things. I know a little about all of them, but I don't really understand how to use them all together. I have searched around the forums, and kirupa, and the web in general and I am having trouble with a few things. First of all let's say I have 3 different fields in my table. Date, Event, and Description. How can I pull each record with PHP? Do I have to pull them one field at a time, or can I just pull the whole record, and send it straight to flash via PHP?
i will make slide show using Flash actionScript 3.0, PHP and using MySql also (have animation too inside) for my final exam. how to make the slide show from begining ?
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
I have a scoreboard in flash which works great, but once go back onto the scores page at the end of the game it adds the text to each field again rather than refreshing the scores/names, therefore each item appears twice in each box..
Is there a correct way to dynamically update the scores each time I access the page ? I've tried creating a loop that sets the value of each text_box.text to ""; once I leave the page but that didn't work !!
I'm building a dynamic scoreboard for a client currently. The first application will be a golf leaderboard. It needs to be updateable by the client (I'll write a form that fills in the xml file from the users input)I need to have a xml file that defines..-number of columns/rows-titles-content in each boxand then the flash that takes that and generates a table from it.Is there any tutorials or source files floating around that do this? There's plenty that talk about in-game scoreboards, but we need to have all the data input from an external file.
I've done this flash scoreboard with shared objects.but what i can done is it will replace the 1st score in my scoreboard, it won't have 2nd, 3rd, 4th and etc...the script i used is:
Basically I've set up a scoreboard for a flash game I've made for a client. Now the scoreboard works fine but apparently it's not very secure. One of the clients friends was able to add a score of 100,000 without even playing the game. This is quite a big problem as they are planning on doing a competition with prizes for the highest scores.
What's the normal way to encrypt data on a scoreboard? The scores are stored in a MySQL database btw.
In my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
I've done this flash scoreboard with shared objects. But what I can done is it will replace the 1st score in my scoreboard, it won't have 2nd, 3rd, 4th and etc...
The script I used is: submit_btn.onPress = function(){ //create a new sharedObject called 'userName' var mySharedObject:SharedObject = SharedObject.getLocal("userName"); var mySharedObject2:SharedObject = SharedObject.getLocal("userScore"); //assign (data) the sharedObject (mySharedObject) a var called 'name1', which has the value of whatever is in textField 'save_txt' [Code] .....
I want to have each higher score goes to the scoreboard, so will have 10 highest score in my scoreboard. Here is my attached file in CS5 format.
I am making a scoreboard. On this scoreboard I will have 10 different scores. I want to compare the 10 scores and list the top 3 scores in another location. I was thinking at first if(score1>score2&&score1>score3&&score1>score4 etc.....){ some function } But this will only give me the top score in the group. I would like to find the top 3 scores, and then list them.
I also want another fla file to be able to reference this external array and pull the top 15 scores from it, and then display those scores on a scrolling banner. I want the banner to be able to update dynamically (I assume reloading the banner fla each time it reaches the end of its cycle, having the first frame load the external array on an onClipEvent action would accomplish this), that way it will update while remaining open. The main reason I need two separate files for the quiz and the score banner is they will be displayed on two different monitors. What would be the most efficient way of accomplishing this? I know a little about actionscript but I don't have much experience with calling data and functions from external fla or as files (the array and the function designating how the data will be arranged within said array are going to be in a separate .as file).
Im trying to setup a scoreboard type deal. I'm using SharedObjects.I can make it WRITE to the .sol without any problems but I cant seem to make it READ from the .sol to re-display the data once the user opens the swf again.
I need this for a simple iPhone app...I was trying to create a Scoreboard for my iPhone using Flash CS5 in Air for iOS mode. I succesfully add the Timer and the 24-seconds Timer, but now i need soooo much help. Problems: 1. When the Timer reaches 0 mins, it display only :59, not 00:59 2. I tried to add a Button for the Counter of the points, but it seems very complicated in AS3(not in AS2 :/). I created a TLF Read Only Text named "HomeScore" . But it's a String not a Number so i can't add a simple counter. 4. with the Reset button (for Timer & 24-Seconds) and the Start/Stop buttons (for Timer & 24). My code:import flash.events.MouseEvent;
I would like to know how to save more than 1 score into the text file and not overwriting the previous score so that it can be displayed in the high score list...I'm not sure how to write the array and where to write itwrite a sample code of for example getting 3 scores, saving it and displaying it in the high score board ?
I am making my very first AS3 game, and though it's quite simple I'm having trouble setting up a scoring system. The concept of the game is simple. Objects appear on the screen, clicking the objects adds points. For this project I am working with 3 AS files, a Document class and two movieclip class files. I would also like to track how many objects have been added to the stage in addition to the score which should track how many objects have been clicked. Here is my Doc Class
i am good in php though, i am trying to make it so when the user presses a button, it updates a field by 1, i dont mind if it cant do it with text but if it just can do numbers at least then i can do an if echo statement. so far i have looked around and this is the best one i got (it is a poll but should give similar results)(i replace personal details with exactly 5 *'s): With this the table is called votesystem with fields vote1, vote2, vote3, vote4
i've done some simple apps to get the felling of it, nothing involving updating a file or a database.I wanted help, how to do a query to a MySql DB from a Flex application (thats gonna be running in a web server).I didn't saw any duplicated questions, sorry if any exists, just point me to it.
tutorials (e.g. ) show how to integrate Flash and MySQL. Also Flash can manipulate and sent this back to serverTo integrate flash and MySQL one can do the following:(1) MySQL -> php -> Flash (e.g. What is the most robust way to set up (1) and (2) to work at scale - as quickly as possible? What are the server loading implications? Is there any other way to do (1) and (2) more effectively?
I wanted to use flex line chart for displaying data stored in mysql table. Can anyone suggest me on how do I do this with flex as UI and mysql as db, I am not sure how to call .php file in flex to query from mysql. I wanted to show some data of time v/s temperature.I wrote a php file to query data from mysql, but my flex program is not able to connect to mysql, is there any configuration I need to update. I am using XAMPP
