<?php
	// Edit this bit with your details
	$server = "mysql.server.com:port";
	$user = "myuser";
	$pass = "mypass";
	$table = "tablename";

	// This bit takes care of the work, no need to change things
	// Set variables
	$users = array();
	$stats = array("Scavenger","Excavation,"Mining","Forgery","Dexterity","Range","Combat","WoodCutting");

	// Read the stats from the files
	foreach ($stats as $stat){
		$lines = file($stat.".exp");
		foreach($lines as $line){
			list($user,$value) = split("=",$line);
			$users[$user][$stat] = $value;
		}
	}

	// Connect to the database
	$link = mysql_connect($server,$user,$pass);
	if (!$link) {
		die('Could not connect: ' . mysql_error());
	}

	// Build up our query for inserting the values
	$query = "INSERT INTO ".$table." VALUES";
	foreach ($users as $user=>$data){
		$query = $query." ( \"".$user."\"";
		foreach ($data as $stat=>$value){
			$query = $query.", ".$value;
		}
		$query = $query." ),";
	}
	$query = substr($query,0,-1);

	// Run our query
	$result = mysql_query($query);
	if (!$result) {
		die('Invalid query: ' . mysql_error());
	}

	// Close the connection
	mysql_close($link);
?>