<?php
mysql_connect("*******", "*****", "*****") or die(mysql_error());
mysql_select_db("jadey") or die(mysql_error());
?>
<?php
$file = 'guild.xml';
$xml = simplexml_load_file($file);
foreach ($xml->Members->children() as $member) {
$T = stripos($member->Joined, 'T');
$JoinDate = substr($member->Joined, 0, $T);
$PersonalNote = addslashes($member->PersonalNotes);
$result = mysql_query("SELECT * FROM members WHERE Name='" . $member->Name . "'")or die(mysql_error());
$row = mysql_fetch_array($result);
if ($row == NULL) {
$query1 = "INSERT INTO members (Name, Level, Calling, PersonalNotes, GuildXP, Achievement) VALUES ('" . $member->Name . "', '" . $member->Level . "', '" . $member->Calling . "', '" . $PersonalNote . "', '" . $member->GuildXPContribution . "', '" . $member->AchievementScore . "')";
$result1 = mysql_query($query1)or die(mysql_error());
echo $member->Name . " was added to the database. <br />";
} else {
$query1 = "UPDATE members SET Level = '" . $member->Level . "', Calling = '" . $member->Calling . "', PersonalNotes = '" . $PersonalNote . "', GuildXP = '" . $member->GuildXPContribution . "', Achievement = '" . $member->AchievementScore . "' WHERE Name = '" . $member->Name . "'";
$result1 = mysql_query($query1)or die(mysql_error());
echo $member->Name . " was successfully updated. <br />";
}
}
?>
<?php
$motd = addslashes($xml->MOTD);
$name = $xml->Name;
$level = $xml->Level;
$experience = $xml->Experience;

$result = mysql_query("SELECT * FROM guild WHERE Name='" . $name . "'");
$row = mysql_fetch_array($result);

if ($row == NULL) {
$query1 = "INSERT INTO guild (Name, Level, Experience, MOTD) VALUES ('" . $name . "', '" . $level . "', '" . $experience . "', '" . $motd . "')";
$result1 = mysql_query($query1) or die(mysql_error());
echo "Guild Data Added";
} else {
$query1 = "UPDATE guild SET Level = '" . $level . "', Experience = '" . $experience . "', MOTD = '" . $motd . "' WHERE Name = '" . $name . "'";
$result1 = mysql_query($query1) or die(mysql_error());
echo "Guild Data Updated";
}
?>
<?php
mysql_close();
?>