gistfile1.php

<?php
require_once('classes/class_dbo.php');
$dbo = new DatabaseObject;

$doc = new DOMDocument();
$doc->load( 'php://input' );

$players = $doc->getElementsByTagName( "player" );
foreach( $players as $player )
{
	$name = $player->getElementsByTagName( "name" )->item(0)->nodeValue;
	$hp = $player->getElementsByTagName( "hp" )->item(0)->nodeValue;
	$mp = $player->getElementsByTagName( "mp" )->item(0)->nodeValue;
	$pclass = $player->getElementsByTagName( "pclass" )->item(0)->nodeValue;
	$guildname = $player->getElementsByTagName( "guildname" )->item(0)->nodeValue;
	$guildrank = $player->getElementsByTagName( "guildrank" )->item(0)->nodeValue;
	$accessorya = $player->getElementsByTagName( "accessorya" )->item(0)->nodeValue;
	$accessoryb = $player->getElementsByTagName( "accessoryb" )->item(0)->nodeValue;
	$armor = $player->getElementsByTagName( "armor" )->item(0)->nodeValue;
	$belt = $player->getElementsByTagName( "belt" )->item(0)->nodeValue;
	$boots = $player->getElementsByTagName( "boots" )->item(0)->nodeValue;
	$displayhelm = $player->getElementsByTagName( "displayhelm" )->item(0)->nodeValue;
	$earrings = $player->getElementsByTagName( "earrings" )->item(0)->nodeValue;
	$greaves = $player->getElementsByTagName( "greaves" )->item(0)->nodeValue;
	$helm = $player->getElementsByTagName( "helm" )->item(0)->nodeValue;
	$leftgauntlet = $player->getElementsByTagName( "leftgauntlet" )->item(0)->nodeValue;
	$leftring = $player->getElementsByTagName( "leftring" )->item(0)->nodeValue;
	$necklace = $player->getElementsByTagName( "necklace" )->item(0)->nodeValue;
	$overcoat = $player->getElementsByTagName( "overcoat" )->item(0)->nodeValue;
	$rightgauntlet = $player->getElementsByTagName( "rightgauntlet" )->item(0)->nodeValue;
	$rightring = $player->getElementsByTagName( "rightring" )->item(0)->nodeValue;
	$shield = $player->getElementsByTagName( "shield" )->item(0)->nodeValue;
	$weapon = $player->getElementsByTagName( "weapon" )->item(0)->nodeValue;
	
	$resultSet = $dbo->query("SELECT name, hp, mp FROM tblPlayers WHERE name = '".$name."';");
	$playerdata = $resultSet->fetch_object();
	$old_hp = $playerdata->hp;
	$old_mp = $playerdata->mp;

	if ($playerdata->name)
	{

		if ($old_hp > $hp)
		{
			$hp = $old_hp;
		}

		if ($old_mp > $mp)
		{
			$mp = $old_mp;
		}

	}
	else
	{
		$dbo->query("INSERT INTO tblPlayers (name) VALUES ('".$name."')");
	}

	$dbo->query("UPDATE tblPlayers SET " .
				 "hp='" . $hp . "', " .
				 "mp='" . $mp . "', " .
				 "class='" . $pclass . "', " .
				 "guild='" . $guildname . "', " .
				 "guildrank='" . $guildrank . "', " .
				 "accessorya='" . $accessorya . "', " .
				 "accessoryb='" . $accessoryb . "', " .
				 "armor='" . $armor . "', " .
				 "belt='" . $belt . "', " .
				 "boots='" . $boots . "', " .
				 "displayhelm='" . $displayhelm . "', " .
				 "earring='" . $earrings . "', " .
				 "greaves='" . $greaves . "', " .
				 "helm='" . $helm . "', " .
				 "leftgauntlet='" . $leftgauntlet . "', " .
				 "leftring='" . $leftring . "', " .
				 "necklace='" . $necklace . "', " .
				 "overcoat='" . $overcoat . "', " .
				 "rightgauntlet='" . $rightgauntlet . "', " .
				 "rightring='" . $rightring . "', " .
				 "shield='" . $shield . "', " .
				 "weapon='" . $weapon . "' " .
				 "WHERE name = '" . $name . "';");
}

?>