<?php
    include('utilities.php');
	$hostname = 'mysql.cs.rmit.edu.au:4020';
	$username = 's3285812';
	$password = 'xxxxxxx';
	$db = 's3285812';

	$firstused = DATE("Y-m-d");
	$lastused = DATE("Y-m-d");

	$nick = $_GET['nick'];
	$address = $_GET['address'];

	//check if the nick has used this address before
	$qtrack = 'SELECT id FROM track WHERE (nick = "' . $nick . '" AND address = "' . $address . '")';
	$track = executeselect($qtrack);

	if (numrows($qtrack) > 0)
	//found an existing row, just update the date
	{
		$qupdate = 'UPDATE track SET lastused = "' . $lastused . '" WHERE id = "' . $track[$row]['id'] . '"' ;
		$update = executemodify($qupdate);
	}

	else
	//else nick hasnt been used from address before, insert new row
	{
		$qinsert = 'INSERT INTO track (nick, address, firstused, lastused) VALUES("' . $nick . '", "' . $address . '", "' . $firstused . '", "' . $lastused . '")';
		$insert = executemodify($qinsert);
	}
?>