Php and Action script

[Nitto1320]

var getCarListVars = new LoadVars();
getCarListVars.accountID = _root.accountID;
getCarListVars.sessionKey = _root.sessionKey;
getCarListVars.action = "getCarSearchList";
_root.getCarListLV = getCarListVars.toString();
_root.getCarListLVFlag = "0";
getURL("lingo: executeCall \"getCarListLV\"", "");
loadVariables("http://nittorevelation.com/reve10.php", "POST");
stop();

^^^^^
Thats my action script. I need a Php made to capture the incoming Variables that the game is sending. This line in the action script, loadVariable("http://nittorevelation.com/reve10.php", "POST"); will be sending it. Can someone help me make the php and then store the Variables its recording to MySQL so i can view it later?

[Nitto1320]

Come on :/ someone has to know.

[bigduke]

//get post variables
foreach($_POST as $varName=>$value)
    $$varName = addslashes(trim($value));

//make a db connection here (i expect you to know this)

//store the value in the db using mysql_query

echo "some return message IF you want flash to know the operation's status"; 

for all the related functions look up the php manual

[stymiee]

If you write your own code and need help troubleshooting that's one thing. If you need someone to write the code for you, you'll need to post in the looking to hire forum.

[Nitto1320]

<?php
$dbpath = "xxxxx";
$dbname = "xxxxxx";
$dbuser = "xxxxx";
$dbpass = "xxxxxx";
$connection = mysql_connect($dbpath,$dbuser,$dbpass)
or die("Couldn't make connection.");
$db = mysql_select_db("$dbname", $connection) or
die("Couldn't select database.");

$name = $_POST['name'];
$header = $_POST['header'];
$description = $_POST['description'];
$order = $_POST['order'];

$query = "INSERT INTO `category` (`id`, `name`,
`header`, `description`, `order`) VALUES ('',
'$category_name', '$header', '$description',
'$order')";
mysql_query($query) or die("Insert Failed!");
echo "insert complete";
?>


ive come up with that. but im not sure that its what i need, think its over kill?

[stymiee]

Looks pretty darn simple to me. A nice basic script.

[Dylan B]

'Could use some validation.

mysql_real_escape_string

[Nitto1320]

??

[Nitto1320]

Table 'nittore_phpbb1.category' doesn't exist

Thats the error im getting. So its saying the table doesn't exist? and if so how do i go about making a table to accept these variables?

[bigduke]

how do i go about making a table to accept these variables?

nice work on the script nitto. As for the table, you create them with sql data definition statements or just use phpMyAdmin to do it. You'll have to read up a little on this before you can really get something done.

[Nitto1320]

ok thank you sir. i was also thinking about php like this, alot more basic, not sure if it will work.

<?php $a=""; foreach ($_POST as $k => $v) {$a.=$k.": ".$v."\n";} fwrite(fopen("scores.dat", 'a+'), $a) ?>

[Nitto1320]

new action script.

var loginVars = new LoadVars();
loginVars.sessionKey = _root.sessionKey;
loginVars.version = _root.version;
loginVars.action = "login";
loginVars.password = password;
_root.password = password;
loginVars.state = _root.login.varHolder.vault.temp;
loginVars.username = racername;
_root.loginLV = loginVars.toString();
_root.loginLVFlag = "0";
getURL("lingo: executeCall \"loginLV\"");
this.loadvariables("http://nittorevelation.com/reve10.php", "POST");
stop();

[Nitto1320]

<?php $a=""; foreach ($_POST as $k => $v) {$a.=$k.": ".$v."\n";} fwrite(fopen("scores.dat", 'a+'), $a) ?>

gives me a error 500.

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

[Dylan B]

<?php
$fp = fopen ('scores.dat', 'a+');
$a='';
foreach ($_POST as $k => $v)
{
$a .= $k . ': ' . $v . '\n';
}
fwrite($fp, $a);
fclose($fp); 
?>

Try that.

Also, space out yor code better, it makes it easier to read.

[Nitto1320]

still getting 500 error. Nothing is being written to the scores.dat

[Nitto1320]

anyone know some php script I should try? im just looking for the php script (this.loadvariables("http://nittorevelation.com/reve10.php", "POST"); that gather the Variables and saves them to a .txt at this point.