var rows = new Array();
var a_rows = new Array();
var totalEps = 0;

function queryServer(select)
{
	var req = new DataRequestor();

	req.getURL('http://www.theanimeplace.com/scripts/db_retrieve.php?type=title&action=edit&id=' + select.value, _RETURN_AS_DOM);

	req.onload = function (data, obj)
	{
		updateForm(data);
	}
}

function updateForm(r)
{
	var xml  = r;
	var episodes	= xml.getElementsByTagName('episode');
	var producers	= xml.getElementsByTagName('producer');
	var licensors	= xml.getElementsByTagName('licenser');
	var directors	= xml.getElementsByTagName('director');

	resetRows(rows);
	resetRows(a_rows);

	resetSelect('title_producer_submit');
	resetSelect('title_licenser_submit');
	resetSelect('title_director_submit');

	document.getElementById('title_synopsis').value = xml.getElementsByTagName('title_synopsis').item(0).firstChild.data;
        document.getElementById('release_date').value = xml.getElementsByTagName('release_date').item(0).firstChild.data;
        document.getElementById('licensed_title').value = xml.getElementsByTagName('license_title').item(0).firstChild.data;
	document.getElementById('production_title').value = xml.getElementsByTagName('production_title').item(0).firstChild.data;

	for ( var i = 0; i < episodes.length; ++i )
	{
		rows[i] = document.createElement('tr');
		var mytd = document.createElement('td');
		var mytd2 = document.createElement('td');
		var episodeNumber = document.createTextNode('Episode #' + episodes[i].getAttribute('id') + ':');
		var input	= document.createElement('input');

		mytd.className = 'row1';
		mytd.height = '28';

		mytd2.className = 'row2';

		input.id = 'episode[' + episodes[i].getAttribute('id') + ']';
		input.name = 'episode[' + episodes[i].getAttribute('id') + ']';
		input.value = episodes[i].firstChild.nodeValue;
		input.type = 'text';
		input.size = '60';

		mytd.appendChild(episodeNumber);
		rows[i].appendChild(mytd);

		mytd2.appendChild(input);
		rows[i].appendChild(mytd2);

		document.getElementById('add-episode').parentNode.insertBefore(rows[i], document.getElementById('add-episode'));
	}

	var select = document.getElementById('title_producer_submit');

	for ( var i = 0; i < producers.length; i++)
	{
		var option = document.createElement('option');
		option.appendChild(document.createTextNode(producers[i].firstChild.nodeValue));
		option.setAttribute('value', producers[i].getAttribute('id'));

		select.appendChild(option);
	}

	var select = document.getElementById('title_licenser_submit');

	for ( var i = 0; i < licensors.length; i++)
	{
		var option = document.createElement('option');
		option.appendChild(document.createTextNode(licensors[i].firstChild.nodeValue));
		option.setAttribute('value', licensors[i].getAttribute('id'));

		select.appendChild(option);

		deleteOption('title_licenser', licensors[i].getAttribute('id'));
	}

	var select = document.getElementById('title_director_submit');

	for ( var i = 0; i < directors.length; i++)
	{
		var option = document.createElement('option');
		option.appendChild(document.createTextNode(directors[i].firstChild.nodeValue));
		option.setAttribute('value', directors[i].getAttribute('id'));

		select.appendChild(option);

		deleteOption('title_director', directors[i].getAttribute('id'));
	}

	totalEps = rows.length
}

function addEpisode()
{
	totalEps++;
	var count = totalEps;
	var i = a_rows.length;

	a_rows[i] = document.createElement('tr');
	var mytd = document.createElement('td');
	var mytd2 = document.createElement('td');
	var episodeNumber = document.createTextNode('Episode #' + totalEps + ':');
	var input	= document.createElement('input');

	mytd.className = 'row1';
	mytd.height = '28';

	mytd2.className = 'row2';

	input.name = 'episode[]';
	input.type = 'text';
	input.size = '60';

	mytd.appendChild(episodeNumber);
	a_rows[i].appendChild(mytd);

	mytd2.appendChild(input);
	a_rows[i].appendChild(mytd2);

	document.getElementById('add-episode').parentNode.insertBefore(a_rows[i], document.getElementById('add-episode'));
}