0

Hi,
I have a small problem I have a flash game SWF file not the fla and it sends and recieves values from a PHP file send - update and recieve is INIT

Great except the person who gave me the SWF and PHP file did not tell me how to set up the database If I was to post the code could someone tell me the table layout to wright with PHP My Admin?

I know its only a small database we are talking 4 or 5 objects in 1 table but I just cant get my head around the code not knowing PHP

Cheers

Kev

3
Contributors
4
Replies
5
Views
12 Years
Discussion Span
Last Post by kevin_smithers
0
<?

if ($command=="init"){
	$link = @mysql_connect("localhost", "username", "password");

	if (!$link){
		print "&message=Error connecting to database";
		exit;
	}

	if (!@mysql_select_db("kevinsmi_game")){
		print "&message=Couldn't select database";
		exit;
	}

	$players = "";
	$scores = "";
	$distances = "";
	$victims = "";
	$innerquery = "SELECT * FROM game ORDER BY scores DESC";
	$innerresult = @mysql_query($innerquery);
	$numPlayers=mysql_num_rows($innerresult);
	for($loop=0;$loop<$numPlayers; $loop++) {
		$newPlayer = mysql_result($innerresult,$loop,"players");
		$newScore = mysql_result($innerresult,$loop,"scores");
		$newDistance = mysql_result($innerresult,$loop,"distances");
		$newVictim = mysql_result($innerresult,$loop,"victims");
		$players = "$players<br>$newPlayer";
		$scores = "$scores<br>$newScore";
		$distances = "$distances<br>$newDistance";
		$victims = "$victims<br>$newVictim";
	}
	printf("&players=%s", $players);
	printf("&scores=%s", $scores);
	printf("&distances=%s", $distances);
	printf("&victims=%s", $victims);

	mysql_close($link);


}


if ($command=="update"){
	$link = @mysql_connect("localhost", "username", "password");

	if (!$link){
		print "&message=Error connecting to database";
		exit;
	}

	if (!@mysql_select_db("game")){
		print "&message=Couldn't select database";
		exit;
	}

	$players = "";
	$scores = "";
	$query = "SELECT scores FROM game where players = '$name'";
	$result = @mysql_query($query);
	if(@mysql_num_rows($result)>0){
		$oldScore = mysql_result($result,"scores");
		if($score>$oldScore){
			$query = "UPDATE game SET scores = '$score' where players = '$name'";
			$result = @mysql_query($query);
		}
	}

	else {
    	$query ="INSERT INTO game (players, scores, distances, victims) VALUES ('$name', '$score', '$distance', '$victim')";
		$result = @mysql_query($query);
	}

	$innerquery = "SELECT * FROM game ORDER BY scores DESC";
	$innerresult = @mysql_query($innerquery);
	$numPlayers=mysql_num_rows($innerresult);
	for($loop=0;$loop<$numPlayers; $loop++) {
		$newPlayer = mysql_result($innerresult,$loop,"players");
		$newScore = mysql_result($innerresult,$loop,"scores");
		$newDistance = mysql_result($innerresult,$loop,"distances");
		$newVictim = mysql_result($innerresult,$loop,"victims");
		$players = "$players<br>$newPlayer";
		$scores = "$scores<br>$newScore";
		$distances = "$distances<br>$newDistance";
		$victims = "$victims<br>$newVictim";
	}
	printf("&players=%s", $players);
	printf("&scores=%s", $scores);
	printf("&distances=%s", $distances);
	printf("&victims=%s", $victims);

	mysql_close($link);
}
?>
0

So... you realize you are trying to use 2 databases??

for command == "init" you have: mysql_select_db("kevinsmi_game")

for command == "update" you have mysql_select_db("game")

As far as the table:
db name: kevinsmi_game
table: game
field1: players
field2: scores
field3: distances
field4: victims

0

Cheers for that didn't notice I hadn't changed the second connection values :-)

I still can't get the thing to work though!! It is bugging me, I have the database set up as you have layed out above and that is how I have had it done from the start, but I just can't get it to read or write ot the database I have set up a simple table on a blank page and connected to the database through a simple table connection in dreamweaver and that works OK!!!!!!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.