<?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 />";
}
}
?>