<?php

	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "";


	$conn = new mysqli($servername, $username, $password, $dbname);

	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}

	$sql = "SELECT id,username,email,armaid,rank,grp FROM members WHERE grp <> 'a1'";
	$result = $conn->query($sql);

	$filePath = 'squad.xml';

	$xml= new DOMDocument('1.0','utf-8');
	$xml->formatOutput=true;
	$squad=$xml->createElement("squad");
	$squad->setAttribute('nick', 'XSQN');
	$xml->appendChild($squad);



	$name=$xml->createElement("name","X Squadron");
	$squad->appendChild($name);
	$email=$xml->createElement("email","noreply.xsqaudron@gmail.com");
	$squad->appendChild($email);
	$web=$xml->createElement("web","http://www.xsquadron.co.uk");
	$squad->appendChild($web);
	$picture=$xml->createElement("picture","logo.paa");
	$squad->appendChild($picture);
	$title=$xml->createElement("title","X Squadron");
	$squad->appendChild($title);




	while($row = $result->fetch_assoc()) {

		$member=$xml->createElement("member");
		$member->setAttribute('id', $row['armaid']);
		$member->setAttribute('nick', $row['username']);
		$squad->appendChild($member);

		$membername=$xml->createElement("name",$row['username']);
		$member->appendChild($membername);
		$memberemail=$xml->createElement("email",'n/a');
		$member->appendChild($memberemail);
		$membericq=$xml->createElement("icq",$row['id']);
		$member->appendChild($membericq);
		$memberrank=$xml->createElement("remark",$row['rank']);
		$member->appendChild($memberrank);
	}


	echo "<xmp>" .$xml->saveXml(). "</xmp>";
	$xml->save($filePath);



?>