// JavaScript Document

// Generic variables
var sportdivhtml = "";
var contacthtml = "";
var categoryMainhtml = "";
var categoryAthletehtml = "";
var categoryCoachhtml = "";
var cursport = "";
var curnewssport = "";
var cursportresult = "";
var cursportforms = "";
var cursportnews = "";
var cursportprofile = "";
var comarray = Array();
var curfix = "";
var fixhtml = "";

function viewsportdiv() {
	$('sportdiv').style.display = 'block';
	var id = $('ddSport').value;
	var sport = $('ddSport').SelectedLabel();
	
	getCoordinator(id);
	getSO(sport);
	getEvents(sport);
	getResults(sport);
	getEntryForms(sport);
}

function getCoordinator(id) {
	var url = "../../includes/ajax/fvds.php?method=getCoordinator";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:insertCoordinator}).request();
}

function insertCoordinator(sText,oXml) {
	var ds = new DataSet(oXml);
	var name = '';
	var email = '';
	var sport = '';
	
	var r = ds.rowcount();
	var i;
	for (i=0;i<r;i++) {
		name = ds.cell(i,"name");
		email = ds.cell(i,"email");
		sport = ds.cell(i,"sport");
		so = ds.cell(i,"socoordinator");
		
		sportdivhtml = "<hr><h1>"+sport+"</h1>";
		sportdivhtml += "<h3>Forth Valley Co-ordinator<br><span class=\"normal\">";
		(name == '') ? sportdivhtml += "Currently Vacant" : sportdivhtml += name;
		sportdivhtml += "</span></h3>";
	}
}

function getSO(s) {
	var url = "../../includes/ajax/fvds.php?method=getSO";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:insertSO}).request();
}

function insertSO(sText,oXml) {
	var ds = new DataSet(oXml);
	var name = '';
	var email = '';
	var sport = '';
	
	var r = ds.rowcount();
	var i;
	sportdivhtml += "<h3>Special Olympic Co-ordinator";
	if (r > 1) { sportdivhtml += "s"; }
	sportdivhtml += "<br><span class=\"normal\">";
	for (i=0;i<r;i++) {
		so = ds.cell(i,"socoordinator");
		sportdivhtml += so;
		if (i >= 0 && !(i==r)) { sportdivhtml += '<br>'; }
	}
}

function getEvents(s) {
	var url = "../../includes/ajax/fvds.php?method=getEvents";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:insertEvents}).request();
}

function insertEvents(sText,oXml) {
	var ds = new DataSet(oXml);
	var id = '';
	var eventname = '';
	
	var r = ds.rowcount();
	var i;
	if (r > 0) {
		sportdivhtml += "<h3>Events</h3>";
		sportdivhtml += "<table border=\"1\" width=\"80%\" class=\"sportstable\" rules=\"none\" frame=\"box\">";
		
		for (i=0;i<r;i++) {
			id = ds.cell(i,"id");
			eventname = ds.cell(i,"eventname");
		
			sportdivhtml += "<tr><td";
			if (i%2==0) { sportdivhtml += " class=\"alt\""; }
			sportdivhtml += "><a href=\"/events/events.php?id="+id+"\">"+eventname+"</a></td></tr>";
		}
		sportdivhtml += "</table>";
	}
	else {
		sportdivhtml += "<h3>Events</h3>";
		sportdivhtml += "There are current no events running";
	}
}

function getResults(s) {
	var url = "../../includes/ajax/fvds.php?method=getResults";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:insertResults}).request();
}

function insertResults(sText,oXml) {
	var ds = new DataSet(oXml);
	var filename = '';
	var eventname = '';
	
	var r = ds.rowcount();
	var i;
	if (r > 0) {
		sportdivhtml += "<h3>Results</h3>";
		sportdivhtml += "<table border=\"1\" width=\"80%\" class=\"sportstable\" rules=\"none\" frame=\"box\">";
		
		for (i=0;i<r;i++) {
			filenamae = ds.cell(i,"filename");
			eventname = ds.cell(i,"event");
		
			sportdivhtml += "<tr><td";
			if (i%2==0) { sportdivhtml += " class=\"alt\""; }
			sportdivhtml += "><a href=\"/includes/results/"+filename+"\" target=\"_blank\">"+eventname+"</a></td></tr>";
		}
		sportdivhtml += "</table>";
	}
	else {
		sportdivhtml += "<h3>Results</h3>";
		sportdivhtml += "There are current no results available";
	}
	refreshSportDiv();
}

function getEntryForms(s) {
	var url = "../../includes/ajax/fvds.php?method=getEntryForms";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:insertEntryForms}).request();
}

function insertEntryForms(sText,oXml) {
	var ds = new DataSet(oXml);
	var filename = '';
	var name = '';
	
	var r = ds.rowcount();
	var i;
	if (r > 0) {
		sportdivhtml += "<h3>Entry Forms</h3>";
		sportdivhtml += "<table border=\"1\" width=\"80%\" class=\"sportstable\" rules=\"none\" frame=\"box\">";
		
		for (i=0;i<r;i++) {
			filenamae = ds.cell(i,"url");
			name = ds.cell(i,"name");
		
			sportdivhtml += "<tr><td";
			if (i%2==0) { sportdivhtml += " class=\"alt\""; }
			sportdivhtml += "><a href=\"/includes/entryforms/"+filename+"\" target=\"_blank\">"+namae+"</a></td></tr>";
		}
		sportdivhtml += "</table>";
	}
	else {
		sportdivhtml += "<h3>Entry Forms</h3>";
		sportdivhtml += "There are current no entry forms available";
	}
	refreshSportDiv();
}

function refreshSportDiv() {
	$('sportdiv').innerHTML = "";
	$('sportdiv').innerHTML = sportdivhtml;
}

function checkform() {
	var n = $('txtname').value;
	var e = $('txtemail').value;
	var m = tinyMCE.get('tamessage').getContent();
	var p = $('txtphone').value;
	var noname = false, noemail = false, validemail = false, nomessage = false;
	var errors=0;
	if (n == "") {
		errors=1;
		noname = true;
	}
	if (e == "") {
		errors=1;
		noemail = true;
	}
	else {
		var reg = /^([A-Za-z0-9_\-\.])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
		if (reg.test(e) == false) {
			errors=1;
			validemail = true;
		}
		
	}
	if (m == "") {
		errors=1;
		nomessage = true;
	}
	if (errors == 1) {
		contacthtml += '<p>We are sorry, but it appears that there has been a problem while submitting your message.  Please review the form below and resubmit.</p>';
		
		contacthtml += "<p>* - fields required</p>"
		+ '<table border="1" bgcolor="#ffffff" cellspacing="5" cellpadding="5" class=\"sportstable\" rules=\"none\" frame=\"box\">'
		+ '<input type="hidden" id="submitted" name="submitted" value="" />'
		+ '<tr><td class="links"><strong>Name:</strong></td><td class="links"><input type="text" size="20" id="txtname" name="txtname" />*';
		if (noname) { contacthtml += "<br><span class=\"red\">Please supply a name</span>"; }
		contacthtml += '</td></tr>'
		+ '<tr><td class="links"><strong>Email Address:</strong></td><td class="links"><input type="text" size="20" id="txtemail" name="txtemail" />*';
		if (noemail) { contacthtml += "<br><span class=\"red\">Please supply an email address</span>"; }
		else {
			if (validemail) { contacthtml += "<br><span class=\"red\">Please supply a valid email address</span>"; }
		}
		contacthtml += '</td></tr>'
		+ '<tr><td class="links"><strong>Phone:</strong></td><td class="links"><input type="text" size="20" id="txtphone" name="txtphone" /></td></tr>'
		+ '<tr><td class="links" valign="top"><strong>Message:</td><td class="links" valign="top"<textarea id="tamessage" name="tamessage" col="20" rows="3"></textarea>*';
		if (nomessage) { contacthtml += "<br><span class=\"red\">Please enter a message</spam>"; }
		contacthtml += '</td></tr>'
		+ '<tr><td class="links" colspan="2"><input type="submit" value="Send" /></td></tr>'
		+ '</table>';
	}
	else {
		contacthtml += "<p>Thank you for your comments/questions.  We will attempt to contact you as soon as we can with an answaer for you.";
		$('submitted').value = 'true';
	}
	$('contactdiv').innerHTML = '';
	$('contactdiv').innerHTML = contacthtml;
	if (errors == 1) {
		var tinyMCEA = new Array("tamessage");
		for (var t=0;t<tinyMCEA.length;t++) {
			callTMCE(tinyMCEA[t]);
		}
	}
}

// athlete profiles
function showCategoryDiv() {
	var sport = $('profilesport').value;
	var n = $('txtname').value;
	
	if (sport != "-1") {
		displayCategoryDiv(sport,n);
	}
	else {
		alert("Please select from a sport and type athletes, coaches or both");
	}
}

function displayCategoryDiv(s,name) {
	var url = "../includes/ajax/fvds.php?method=";
	var pars = '';
	var complete = '';
	
	if (s == "all") {
		url += "getCategoryDivAll";
		pars = "name="+name;
		new Ajax(url, {postBody:pars, onComplete:insertCategoryDivAll}).request();
	}
	else {
		url += "getCategoryDiv";
		pars += "name="+name+"&sport="+s;
		new Ajax(url, {postBody:pars, onComplete:insertCategoryDiv}).request();
	}
}

function insertCategoryDiv(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();

	$('categorydiv').style.display = "block";
	$('categorydiv').innerHTML = '';
	categoryMainhtml = '';
	categoryAthletehtml = '';
	categoryCoachhtml = '';
	if (r > 0) {
		categoryMainhtml += "<hr>";
		var i = 0, a = 0, c = 0;
		for (i=0;i<r;i++) {
			var t = ds.cell(i,"type");
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"name");

			if (t == "Athlete") {
				a = 1;
				categoryAthletehtml += '<tr><td';
				if (i%2==0) { categoryAthletehtml += ' class="alt"'; }
				categoryAthletehtml += '><a href="athletes.php?id='+id+'">'+name+'</a></td></tr>';
			}
			
			if (t == "Coach") {
				c = 1;
				categoryCoachhtml += '<tr><td';
				if (i%2==0) { categoryCoachhtml += ' class="alt"'; }
				categoryCoachhtml += '>'+name+'</td></tr>';
			}
		}
			if (a > 0) {
				categoryMainhtml += '<h3>Athletes</h3><table border="1" width="80%" class=\"sportstable\" rules=\"none\" frame=\"box\">';
				categoryMainhtml += categoryAthletehtml;
				categoryMainhtml += '</table>';
			}
			if (c > 0) {
				categoryMainhtml += '<h3>Coaches</h3><table border="1" width="80%" class=\"sportstable\" rules=\"none\" frame=\"box\">';
				categoryMainhtml += categoryCoachhtml;
				categoryMainhtml += '</table>';
			}
		$('categorydiv').innerHTML = categoryMainhtml;		
	}
	else {
		categoryMainhtml = "<hr>No results";
		$('categorydiv').innerHTML = categoryMainhtml;		
	}			
}

function insertCategoryDivAll(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	var curtype='';
	var first = 0;

	$('categorydiv').style.display = "block";
	$('categorydiv').innerHTML = '';
	categoryMainhtml = '';
	categoryAthletehtml = '';
	categoryCoachhtml = '';
	if (r > 0) {
		categoryMainhtml += "<hr>";
		var i = 0, a = 0, c = 0;
		for (i=0;i<r;i++) {
			var t = ds.cell(i,"type");
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"name");
			var sport = ds.cell(i,"sport");
			
			if (sport != curtype) {
				if (first == 0) {
					categoryMainhtml += '<h3>'+sport+'</h3>';
					categoryMainhtml += '<table border="1" width="80%">';
					first++;
				}
				else {
					categoryMainhtml += '</table>';
					categoryMainhtml += '<h3>'+sport+'</h3>';
					categoryMainhtml += '<table border="1" width="80%">';
				}
				curtype = sport;
			}
			
			categoryMainhtml += '<tr><td';
			if (i%2==0) { categoryMainhtml += ' class="alt"'; }
			categoryMainhtml += '><a href="athletes.php?id='+id+'">'+name+'</a></td></tr>';			
			if (i+1 == r) {
				categoryMainhtml += '</table>';
			}
		}
		$('categorydiv').innerHTML = categoryMainhtml;		
	}
	else {
		categoryMainhtml = "<hr>No results";
		$('categorydiv').innerHTML = categoryMainhtml;		
	}			
}

// login
function checklogin() {
	var u = $('txtusername').value;
	var p = $('txtpassword').value;
	var url = "../includes/ajax/fvds.php?method=checkLogin";
	var pars = "username="+u+"&password="+p;
	new Ajax(url, {postBody:pars, onComplete:decidePage}).request();
}

function decidePage(sText,oXml) {
	if (sText == "passed") { window.location.href = 'login.php'; }
	else { $('logindiv').innerHTML = '<span style="color: red">Sorry could not log you in, please try again.</span>'; }
}

// admin menus
function showAthleteEventsDiv() {
	var s = $('adminathleteeventsdiv').style.display;
	var now = '';
	(s == 'none') ? now = 'block' : now = 'none';
	$('adminathleteeventsdiv').style.display = now;
}

function showAthleteNewsDiv() {
	var n = $('adminathletenewsdiv').style.display;
	var now = '';
	(n == 'none') ? now = 'block' : now = 'none';
	$('adminathletenewsdiv').style.display = now;
}

// admin stuff
function insertNewEvent() {
	var ordernumber = new Array(6,7,8,9,10,11,12,1,2,3,4,5);
	var month = ($('addeventdd').SelectedValue())-1;
	var o = ordernumber[month];

	var m = $('addeventdd').SelectedLabel();
	var s = $('addsportdd').SelectedLabel();
	var n = $('addtxtname').value;
	var v = $('addtxtvenue').value;
	var d = $('addtxtdate').value;
	var st = $('starttime').SelectedLabel();
	var et = $('endtime').SelectedLabel();

	var age = tinyMCE.get('addtxtage').getContent();
	var aim = tinyMCE.get('addtxtaim').getContent();

	n = replacechars(n);
	v = replacechars(v);
	age = replacechars(age);
	aim = replacechars(aim);
	n = replacechars(n);
	
	var url = "../../includes/ajax/fvds.php?method=insertNewEvent";
	var pars = "month="+m+"&sport="+s+"&eventname="+n+"&venue="+v+"&date="+d+"&starttime="+st+"&endtime="+et+"&age="+age+"&aim="+aim+"&ordernumber="+o;
	new Ajax(url, {postBody:pars, onComplete:updateAddEvent}).request();
}

function updateAddEvent() {
	$('addeventdiv').innerHTML = '<p style="color: green">Your event has been successfully added.</p>';
}
// edit event
function showEditEvent() {
	var id = $('editeventdd').value;
	var url = "../../includes/ajax/fvds.php?method=getEditEventsInfo";
	var pars = "id="+id;
	new Ajax(url,{postBody:pars, onComplete:displayEditEventsInfo}).request();
}

function displayEditEventsInfo(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('editeventdiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var month = ds.cell(0,"month");
		var sport = ds.cell(0,"sport");
		var name = ds.cell(0,"eventname");
		var venue = ds.cell(0,"venue");
		var date = ds.cell(0,"date");
		var stime = ds.cell(0,"starttime");
		var etime = ds.cell(0,"endtime");
		var age = decode(ds.cell(0,"age"));
		var aim = decode(ds.cell(0,"aim"));
		var act = ds.cell(0,"active");
		var on = ds.cell(0,"orderNumber")
		
		var start = stime.substr(0,5);
		var end = etime.substr(0,5);
		cursport = sport;

		$('editeventdiv').innerHTML = '';
		var editeventdiv = '';
		editeventdiv += '<hr width="410px">';
		editeventdiv += '<table bgcolor="#ffffff" border="1" rules=none frame=box width="410px"><div id="editeventdiv">'
						+ '<tr><td style="padding: 5px" colspan="2"><img src="/images/admin/editeventinformation.jpg" /></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><input type="hidden" id="editeventhiddenid" value="" /><strong>Month: </strong></td><td style="padding: 5px;"><select id="editmontheventdd" onfocus="changebg(this)" onblur="plainbg(this)">';
			var editmonths = new Array('January','February','March','April','May','June','July','August','September','October','November','December');
			for(var em=0;em<editmonths.length;em++) { 
				var mon = editmonths[em];
				editeventdiv += '<option value="'+em+'"';
				if (mon == month) { editeventdiv += ' selected'; }
				editeventdiv += '>'+editmonths[em]+'</options>';
			}
		
		editeventdiv += '</select></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Sport: </strong></td><td style="padding: 5px;"><select id="editsportsportdd" onfocus="changebg(this)" onblur="plainbg(this)">';
			var url = "../../includes/ajax/fvds.php?method=getAdminSports";
			var pars = "";
			new Ajax(url, {postBody:pars, onComplete:populateEditSportDD}).request();
		editeventdiv += '</select></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Event name: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtname" size="20" onfocus="changebg(this)" onblur="plainbg(this)"/></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Venue: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtvenue" size="20" onfocus="changebg(this)" onblur="plainbg(this)"/></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Date: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtdate" size="20" onfocus="changebg(this)" onblur="plainbg(this)"/></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Times: </strong></td><td style="padding: 5px;">'
		+' <select id="editstarttime" onfocus="changebg(this)" onblur="plainbg(this)">';
			var m = Array(0,15,30,45);
			for (var i=8;i<23;i++) {
				for (var j=0;j<4;j++) {
					if ((i==22) && (j>0)) { break; }
					else {
						var minu = m[j];
						if (minu==0) { minu = minu+'0'; }
						var o = i+':'+minu;
						if (i<10) { o = '0'+o; }
						editeventdiv += '<option value="'+o+'"';
						if (start == o) { editeventdiv += ' selected'; }
						editeventdiv += '>'+o+'</option>';
					}
				}
			}
	    editeventdiv += '</select> -'
		+ ' <select id="endtime" onfocus="changebg(this)" onblur="plainbg(this)">';
		var m = Array(0,15,30,45);
			for (var i=8;i<23;i++) {
				for (var j=0;j<4;j++) {
					if ((i==22) && (j>0)) { break; }
					else {
						var minu = m[j];
						if (minu==0) { minu = minu+'0'; }
						var o = i+':'+minu;
						if (i<10) { o = '0'+o; }
						editeventdiv += '<option value="'+o+'"';
						if (end == o) { editeventdiv += ' selected'; }
						editeventdiv += '>'+o+'</option>';
					}
				}
			}
			editeventdiv += '</select></td></tr>';
		editeventdiv += '<tr><td valign="top" style="padding: 5px;"><strong>Age: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtage" size="20"  onfocus="changebg(this)" onblur="plainbg(this)"/></td></tr>';
		editeventdiv += '<tr><td valign="top" style="padding: 5px;"><strong>Aim: </strong></td><td style="padding: 5px;"><textarea id="edittxtaim" row="5" cols="20"></textarea></td></tr>';
		editeventdiv += '<tr><td style="padding: 5px;"><strong>Active? </strong></td><td style="padding: 5px;"><input type="checkbox" id="activecb"';
		if (act==1) { editeventdiv += ' checked'; }
		editeventdiv += '></td></tr>';
		editeventdiv += '<tr><td colspan="2" style="padding: 5px;"><input type="hidden" id="edithiddenactive" /><input type="hidden" id="edithiddenorder" /><button id="addeventbtn" onclick="editEditEvent()" class="buttonsdesign">Edit Event</button></td></tr>';
		editeventdiv += '</table></div>';
		$('editeventdiv').innerHTML = editeventdiv;
		
		var tinyMCEA = new Array('edittxtaim','edittxtage');
		var cal = new Array('edittxtdate');
		for (var t=0;t<tinyMCEA.length;t++) {
			callTMCE(tinyMCEA[t]);
		}
		for (var c=0;c<cal.length;c++) {
			callCalendar(cal[c]);
		}
		date = date.replace(/-/g,"/");
		populateEditDD(id,month,sport,name,venue,date,age,aim,act,on);
	}
}

function populateEditDD(i,month,s,n,v,d,ag,ai,a,onum) {
	$('editeventhiddenid').value = i;


	var namel = n.length;
	var venuel = v.length;
	var agel = ag.length;
	$('edittxtname').value = n;
	$('edittxtname').size = namel;
	$('edittxtvenue').value = v;
	$('edittxtvenue').size = venuel;
	$('edittxtdate').value = d;
	$('edittxtage').value = ag;
	$('edittxtaim').value = ai;
	$('edithiddenactive').value = a;
	$('edithiddenorder').value = onum;
}

function populateEditSportDD(sText,oXml) {
	var is = 0;
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var s = ds.cell(i,"sport");
			$('editsportsportdd').options[i] = new Option(s,i);
			if (s == cursport) { is=i; }
		}
		$('editsportsportdd').value = is;
	}
}

function editEditEvent() {
	var id = $('editeventhiddenid').value;
	var m = $('editmontheventdd').SelectedLabel();
	var ordernumber = new Array(6,7,8,9,10,11,12,1,2,3,4,5);
	var month = $('editmontheventdd').SelectedValue();
	var s = $('editsportsportdd').SelectedLabel();
	var n = $('edittxtname').value;
	var v = $('edittxtvenue').value;
	var d = $('edittxtdate').value;
	var ag = tinyMCE.get('edittxtage').getContent();
	var ai = tinyMCE.get('edittxtaim').getContent();
	var o = ordernumber[month];
	var st = $('editstarttime').value;
	var et = $('endtime').value;
	var act = $('activecb').checked;

	var active;
	(act) ? active=1 : active=0;
	n = replacechars(n);
	v = replacechars(v);
	ag = replacechars(ag);
	ai = replacechars(ai);
	
	var url = "../../includes/ajax/fvds.php?method=editNewEvent";
	var pars = "id="+id+"&month="+m+"&sport="+s+"&eventname="+n+"&venue="+v+"&date="+d+"&starttime="+st+"&endtime="+et+"&age="+ag+"&aim="+ai+"&ordernumber="+o+"&active="+active;
	new Ajax(url, {postBody:pars, onComplete:updateEditEvent}).request();
}

function updateEditEvent() {
	$('editeventdiv').innerHTML = '<p style="color: green">Your event has been successfully updated.</p>';
	eraseDropDown($('editeventdd'));
	var url = "../../includes/ajax/fvds.php?method=getEditEvents";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateEditDropDownAgain}).request();
}

function populateEditDropDownAgain(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"eventname");
			$('editeventdd').options[i+1] = new Option(e,id);
			var a = ds.cell(i,"active");
			var col;
			(a==1) ? col = 'green' : col = 'red';
			$('editeventdd').options[i+1].style.color = col;
		}
	}
}

// delete events
function showDeleteEvent() {
	var id = $('deleteeventdd').value;
	var url = "../../includes/ajax/fvds.php?method=getEditEventsInfo";
	var pars = "id="+id;
	new Ajax(url,{postBody:pars, onComplete:displayDeleteEventsInfo}).request();
}

function displayDeleteEventsInfo(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('deleteeventdiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var month = ds.cell(0,"month");
		var sport = ds.cell(0,"sport");
		var name = decode(ds.cell(0,"eventname"));
		var venue = ds.cell(0,"venue");
		var date = ds.cell(0,"date");
		var stime = ds.cell(0,"starttime");
		var etime = ds.cell(0,"endtime");
		var age = decode(ds.cell(0,"age"));
		var aim = decode(ds.cell(0,"aim"));
		var act = ds.cell(0,"active");
		var on = ds.cell(0,"orderNumber")
		stime = stime.substr(0,5);
		etime = etime.substr(0,5);
		
		var c, t;
		(act==1) ? c = "greentext" : c = 'redtext';
		(act==1) ? t = "Active" : t = 'Not Active';
		$('deleteeventdiv').innerHTML = '';
		var editeventdiv = '';
		editeventdiv += '<hr>';
		editeventdiv += '<table border="1" width="410px" bgcolor="#ffffff" rules=none frame=box>'
					+ '<tr><td colspan="2" style="padding: 5px"><img src="/images/admin/deleteeventinformation.jpg"></td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><input type="hidden" id="deleteeventhiddenid" value="'+id+'" /><strong>Month: </strong></td><td style="padding: 5px">'+month+'</td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><strong>Sport: </strong></td><td style="padding:5px">'+sport+'</td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><strong>Event name: </strong></td><td style="padding:5px">'+name+'</td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><strong>Venue: </strong></td><td style="padding:5px">'+venue+'</td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><strong>Date: </strong></td><td style="padding:5px">'+date+'</td></tr>';
		editeventdiv += '<tr><td style="padding:5px"><strong>Times: </strong></td><td style="padding:5px">'+stime+' - '+etime+'</td></tr>';
		editeventdiv += '<tr><td valign="top" style="padding:5px"><strong>Age: </strong></td><td style="padding:5px" class="popupheadings">'+age+'</td></tr>';
		editeventdiv += '<tr><td valign="top" style="padding:5px"><strong>Aim: </strong></td><td style="padding:5px" class="popupheadings">'+aim+'</td></tr>';
		editeventdiv += '<tr><td valign="top" style="padding:5px"><strong>Active? </strong></td><td style="padding:5px"><span class="'+c+'">'+t+'</span></td></tr>';
		editeventdiv += '<tr><td colspan="2" style="padding:5px"><button id="deleteeventbtn" onclick="deleteEditEvent()" class="buttonsdesign">Delete Event</button></td></tr>';
		editeventdiv += '</table>';
		$('deleteeventdiv').innerHTML = editeventdiv;
	}
}

function deleteEditEvent() {
	var id = $('deleteeventhiddenid').value;
	var c = confirm("Are you sure you want to delete this event?");
	if (c) {
		var url = "../../includes/ajax/fvds.php?method=deleteEditEvent";
		var pars = "id="+id;
		new Ajax(url, {postBody:pars, onComplete:updateDelete}).request();
	}
}

function updateDelete() {
	$('deleteeventdiv').innerHTML = '<p style="color: green">Your event has been successfully deleted</p>';
	
	eraseDropDown($('deleteeventdd'));
	var url = "../../includes/ajax/fvds.php?method=getEditEvents";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateDropDownAgain}).request();
}

function populateDropDownAgain(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"eventname");
			var a = ds.cell(i,"active");
			$('deleteeventdd').options[i+1] = new Option(e,id);
			var col;
			(a==1) ? col = "green" : col = "red";
			$('deleteeventdd').options[i+1].style.color = col;
		}
	}
}

function eraseDropDown(form){
	for(var i=form.length-1;i>0;i--){
		//alert(form.options[i]);
		form.options[i] = null;
		
	}
}

// news
function insertNewNews() {
	var n = $('addnewstxtname').value;
	var s = tinyMCE.get('addnewstxtstory').getContent();
	var sp = $('addnewssportdd').SelectedLabel();

	n = replacechars(n);
	s = replacechars(s);

	var url = "../../includes/ajax/fvds.php?method=insertNewNews";
	var pars = "news="+n+"&story="+s+"&sport="+sp;
	new Ajax(url, {postBody:pars, onComplete:updateAddNewsDiv}).request();
}

function updateAddNewsDiv() {
	$('addnewnewsdiv').style.display = "block";
	$('addnewnewsdiv').innerHTML = 'You news item has been successfully added';
}

// edit news
function showNewsInfo() {
	var id = $('editnewsdd').value;
	var url = "../../includes/ajax/fvds.php?method=getEditNewsInfo";
	var pars = "id="+id;
	new Ajax(url,{postBody:pars, onComplete:displayEditNewsInfo}).request();
}

function displayEditNewsInfo(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('editnewsdiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var news = ds.cell(0,"news");
		var story = ds.cell(0,"story");
		var sport = ds.cell(0,"sport");
		var pic = ds.cell(0,"picture");
		var intro = ds.cell(0,"intro");
		var active = ds.cell(0,"active");

		story = decode(story);
		intro = decode(intro);
		news = decode(news);

		curnewssport = sport;

		$('editnewsdiv').innerHTML = '';
		var editnewsdiv = '';
		editnewsdiv += '<hr>';
editnewsdiv += '<div id="editnewsdiv"><form action="edit.php" method="post" enctype="multipart/form-data" id="editnewsform"><table border="1" width="410px" bgcolor="#ffffff" rules=none frame=box>'
					+ '<tr><td style="padding:5px" colspan="2"><img src="/images/admin/editnewsinformation.jpg" /></td></tr></form>'
					+ '<tr><td><input type="hidden" name="submitted" id="submitted" value="1"><input type="hidden" id="editnewshiddenid" name="editnewshiddenid" value="" /></td></tr>'
					+ '<tr><td style="padding:5px;"><strong>News Title: </strong></td><td style="padding: 5px"><input type="text" id="editnewstxtname" name="editnewstxtname" size="20" onfocus="changebg(this)" onblur="plainbg(this)"/></td></tr>'
					+ '<tr><td style="padding:5px"><strong>Sport: </strong></td><td style="padding:5px"><select id="editnewssportdd" onfocus="changebg(this)" onblur="plainbg(this)">';
			var url = "../../includes/ajax/fvds.php?method=getAdminSports";
			var pars = "";
			new Ajax(url, {postBody:pars, onComplete:populateEditNewsSportDD}).request();
		editnewsdiv += '</select><input type="hidden" id="editnewshidden" name="editnewshidden" value=""></td></tr>'
					+ '<tr><td valign="top" style="padding:5px"><strong>Introduction: </strong></td><td style="padding:5px"><textarea id="editnewstxtintroduction" rows="10" cols="30"></textarea><input type="hidden" id="editintrohidden" name="editintrohidden" value="" /></td></tr>'
					+ '<tr><td valign="top" style="padding:5px"><strong>Picture: </td><td valign="top" style="padding: 5px"><input type="file" id="editpicture" name="editpicture" value="" onfocus="changebg(this)" onblur="plainbg(this)"><br>'
					+ '<img src="../../images/news/'+pic;
		editnewsdiv	+= '" height="120" width="240"></td></tr>'
					+ '<tr><td valign="top" style="padding:5px"><strong>Story: </strong></td><td style="padding: 5px"><textarea id="editnewstxtstory" rows="10" cols="30"></textarea><input type="hidden" id="editstoryhidden" name="editstoryhidden" value="" /></td></tr>'
					+ '<tr><td style="padding: 5px"><strong>Active?</td><td style="padding: 5px"><input type="checkbox" id="editcheckbox" name="editcheckbox"';
					if (active == 1) { editnewsdiv += ' checked'; }
					editnewsdiv += '></table></form>'
					+ '<table rules=none frame=box><tr><td colspan="2" style="padding:5px"><button id="addnewsbtn" onclick="popnewshiddenedit()" class="buttonsdesign">Edit News</button></td></tr>'
					+ '</div>';
		$('editnewsdiv').innerHTML = editnewsdiv;
		
		var tinyMCEA = new Array('editnewstxtstory',"editnewstxtintroduction");
		for (var n=0;n<tinyMCEA.length;n++) {
			callTMCE(tinyMCEA[n]);
		}
		populateEditNewsDD(id,news,story,sport,intro);
	}
}

function populateEditNewsDD(i,n,st,sp,int) {
	$('editnewshiddenid').value = i;

	var namel = n.length;
	$('editnewstxtname').value = n;
	if (namel > 20) { $('editnewstxtname').size = namel; }
	$('editnewstxtstory').value = st;
	$('editnewstxtintroduction').value = int;
}

function populateEditNewsSportDD(sText,oXml) {
	var is = 0;
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var s = ds.cell(i,"sport");
			$('editnewssportdd').options[i] = new Option(s,i);
			if (s == curnewssport) { is=i; }
		}
		$('editnewssportdd').value = is;
	}
}

function editNewNews() {
	var id = $('editnewshiddenid').value;
	var n = $('editnewstxtname').value;
	var st = tinyMCE.get('editnewstxtstory').getContent();
	var sp = $('editnewssportdd').SelectedLabel();

	n = replacechars(n);
	st = replacechars(st);
	
	var url = "../../includes/ajax/fvds.php?method=editNewNews";
	var pars = "id="+id+"&news="+n+"&story="+st+"&sport="+sp;
	new Ajax(url, {postBody:pars, onComplete:updateEditNews}).request();
}

function updateEditNews() {
	$('editnewsdiv').innerHTML = '<p style="color: green">Your news has been successfully updated.</p>';
	eraseDropDown($('editnewsdd'));
	var url = "../../includes/ajax/fvds.php?method=getEditNews";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateEditNewsDropDownAgain}).request();
}

function populateEditNewsDropDownAgain(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"news");
			var a = ds.cell(i,"active");
			$('editnewsdd').options[i+1] = new Option(e,id);
			var c;
			(a==1) ? c = 'green' : c = "red";
			$('editnewsdd').options[i+1].style.color = c;
		}
	}
}

// delete news
function showDeleteNews() {
	var id = $('deletenewsdd').value;
	var url = "../../includes/ajax/fvds.php?method=getEditNewsInfo";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayDeleteDeleteNewsInfo}).request();
}

function displayDeleteDeleteNewsInfo(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('deletenewsdiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var news = ds.cell(0,"news");
		var story = ds.cell(0,"story");
		var sport = ds.cell(0,"sport");
		var intro = ds.cell(0,"intro");
		var pic = ds.cell(0,"picture");
		var act = ds.cell(0,"active");

		news = decode(news);
		story = decode(story);
		intro = decode(intro);
		
		var c, t;
		(act==1) ? c = "greentext" : c = "redtext";
		(act==1) ? t = "Active" : t = "Not Active";
		$('deletenewsdiv').innerHTML = '';
		var editnewsdiv = '';
		editnewsdiv += '<hr>';
		editnewsdiv += '<table border="1" width="410px" bgcolor="#ffffff" rules=none frame=box>'
					+ '<tr><td style="padding:5px" colspan="2"><img src="/images/admin/deletenewsinformation.jpg" /></td></tr>';
		editnewsdiv += '<tr><td style="padding:5px"><input type="hidden" id="deletenewshiddenid" value="'+id+'" /><strong>News Item: </strong></td><td style="padding:5px;">'+news+'</td></tr>';
		editnewsdiv += '<tr><td style="padding:5px"><strong>Sport: </strong></td><td style="padding:5px">'+sport+'</td></tr>';
		editnewsdiv += '<tr><td style="padding:5px" valign="top"><strong>Introduction: </strong></td><td style="padding:5px" class="popupheadings">'+intro+'</td></tr>';
		editnewsdiv += '<tr><td style="padding:5px" valign="top"><strong>Picture: </strong></td><td style="padding:5px" valign="top"><img src="/images/news/'+pic+'" height="120" width="240"></td></tr>';
		editnewsdiv += '<tr><td valign="top" style="padding:5px"><strong>Story: </strong></td><td style="padding:5px" class="popupheadings">'+story+'</td></tr>';
		editnewsdiv += '<tr><td valign="top" style="padding:5px"><strong>Active? </strong></td><td style="padding:5px" class="'+c+'">'+t+'</td></tr>';
		editnewsdiv += '<tr><td colspan="2" style="padding:5px"><button id="deletenewsbtn" onclick="deleteEditNews()" class="buttonsdesign">Delete News</button></td></tr>';
		editnewsdiv += '</table>';
		$('deletenewsdiv').innerHTML = editnewsdiv;
	}
}

function deleteEditNews() {
	var id = $('deletenewshiddenid').value;
	var c = confirm("Are you sure you want to delete this news item?");
	if (c) {
		var url = "../../includes/ajax/fvds.php?method=deleteEditNews";
		var pars = "id="+id;
		new Ajax(url, {postBody:pars, onComplete:updateDeleteNews}).request();
	}
}

function updateDeleteNews() {
	$('deletenewsdiv').innerHTML = '<p style="color: green">Your news has been successfully deleted';
	
	eraseDropDown($('deletenewsdd'));
	var url = "../../includes/ajax/fvds.php?method=getEditNews";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateDeleteNewsDropDownAgain}).request();
}

function populateDeleteNewsDropDownAgain(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"news");
			var a = ds.cell(i,"active");
			$('deletenewsdd').options[i+1] = new Option(e,id);
			var c;
			(a==1) ? c = "green" : c = "red";
			$('deletenewsdd').options[i+1].style.color = c;
		}
	}
}

// profiles
function updateProfile() {
	var id = $('uphiddenid').value;
	var lives = $('uplives').value;
	var bio = tinyMCE.get('upbio').getContent();
	
	var url = "../../includes/ajax/fvds.php?method=updateAthleteProfile";
	var pars = "id="+id+"&lives="+lives+"&bio="+bio;
	new Ajax(url, {postBody:pars, onComplete:updateAthleteProfile}).request();
}

function updateAthleteProfile() {
	$('updiv').style.display = 'block';
	$('updiv').innerHTML = '<p style="color:green">Your profile has been successfully updated</p>';
}

// tinymce
function callTMCE(field) {
 	tinyMCE.init({
			mode : "exact",
	        elements : field,
			theme : "advanced",
			encoding : "xml",
			width : "280",
			height : '200',
			theme_advanced_buttons1 : "bold,italic,underline,separator,justifyleft,justifycenter,justifyright, justifyfull,separator,bullist,numlist,link",
			theme_advanced_buttons2 : "cut,copy,paste,separator,undo,redo,separator,image,hr",
			theme_advanced_buttons3 : "",
			theme_advanced_toolbaxr_location : "top",
			theme_advanced_toolbar_align : "left",

			extended_valid_elements : "a[name|href|target|title|onclick],img[class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]"
		});
}

// calendar
function callCalendar(field) {
	Calendar.setup({
		inputField : field,
		ifFormat : "%Y/%m/%d",
		align : "Br",
		singleClick : true
	});
}

// sports
function showSportResults(s) {
	var url = "../../includes/ajax/fvds.php?method=getSportResults";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displaySportResults}).request();
	cursportresults = s;
}

function displaySportResults(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('sportresults').style.display = "block";
			sresult = '';
			sresult = '<hr><table border="1" bgcolor="#ffffff" width="410px">'
					+ '<tr><td><img src="/images/sports/headings/'+cursportresults+'.jpg" /></td></tr>';
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"event");
			var filename = ds.cell(i,"filename");
			var sport = ds.cell(i,"sport");
			
			sresult += '<tr><td class="links">'
					+ '<a href="/includes/results/'+filename+'" target="_blank">'+name+'</a></td></tr>';
		}
		sresult += '</table>';
		$('sportresults').innerHTML = sresult;
	}
}

// entryforms
function showEntryForms(s) {
	var url = "../../includes/ajax/fvds.php?method=getEntryFormsPage";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displayEntryForms}).request();
	cursportforms = s;
}

function displayEntryForms(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('sportforms').style.display = "block";
			fresult = '';
			fresult = '<hr><table border="1" bgcolor="#ffffff" width="410px">'
					+ '<tr><td><img src="/images/sports/headings/'+cursportforms+'.jpg" /></td></tr>';
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"name");
			var filename = ds.cell(i,"url");
			var sport = ds.cell(i,"sport");
			var cd = ds.cell(i,"closingdate");
			
			var dates = cd.split('-');
			var date = dates[2];
			var year = dates[0];
			var m = dates[1];
			
			var datesarray = new Array('January','February','March','April','May','June','July','August','September','October','November','December');
			
			var month = datesarray[m-1];
			fresult += '<tr><td class="links">'
					+ '<a href="/includes/entryforms/'+filename+'" target="_blank">'+name+'<br><em>Closing Date: '+date+' '+month+' '+year+'</em></a></td></tr>';
		}
		fresult += '</table>';
		$('sportforms').innerHTML = fresult;
	}
}

// news
function showNewsReports(s) {
	var url = "../includes/ajax/fvds.php?method=getNewsReports";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displayNewsReports}).request();
	cursportnews = s;
}

function displayNewsReports(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('sportnews').style.display = "block";
			nresult = '';
			nresult = '<hr><table border="1" bgcolor="#ffffff" width="410px">'
					+ '<tr><td><img src="/images/sports/headings/'+cursportnews+'.jpg" /></td></tr>';
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"news");

			nresult += '<tr><td class="links">'
					+ '<a href="#" onclick="window.open(\'/news/news.php?id='+id+'\')">'+name+'</a></td></tr>';
		}
		nresult += '</table>';
		$('sportnews').innerHTML = nresult;
	}
}

// news
function showProfileList(s) {
	var url = "../includes/ajax/fvds.php?method=getProfileList";
	var pars = "sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displayProfileList}).request();
	cursportprofile = s;
}

function displayProfileList(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('sportprofiles').style.display = "block";
			presult = '';
			presult = '<hr><table border="1" bgcolor="#ffffff" width="410px">'
					+ '<tr><td><img src="/images/sports/headings/'+cursportprofile+'.jpg" /></td></tr>';
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var name = ds.cell(i,"name");

			presult += '<tr><td class="links">'
					+ '<a href="#" onclick="window.open(\'/athleteprofiles/athletes.php?id='+id+'&sport='+cursportprofile+'&tab=bio\')">'+name+'</a></td></tr>';
		}
		presult += '</table>';
		$('sportprofiles').innerHTML = presult;
	}
}

function makeMoodal(e) {
	MOOdalBox.open("http://www.fvds.org.uk"+e,"","");
}		

// funds
function showEditFund() {
	var id = $('editfunddd').SelectedLabel();
	var url = "../../includes/ajax/fvds.php?method=getEditFundsInfo";
	var pars = "id="+id;
	new Ajax(url,{postBody:pars, onComplete:displayEditFunds}).request();
}

function displayEditFunds(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('editfunddiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var fund = ds.cell(0,"fund");
		var amount = ds.cell(0,"amount");
		var total = ds.cell(0,"target");
		var active = ds.cell(0,"active");

		$('editfunddiv').innerHTML = '';
		var editfunddivh = '';
		editfunddivh += '<hr width="410px">'
		+ '<table bgcolor="#ffffff" border="1" width="410px"><div id="editfunddiv">'
		+ '<tr><td style="padding: 5px" colspan="2"><img src="/images/admin/fundinformation.jpg" /></td></tr>'
		+ '<tr><td style="padding: 5px;"><input type="hidden" id="editfundhiddenid" value="" /><strong>Fund name: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtfund" size="20" value="" /></td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Amount Raised: </strong></td><td style="padding: 5px;"><input type="text" id="edittxtamount" size="20" value="" /></td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Target Amount: </strong></td><td style="padding: 5px;"><input type="text" id="edittxttarget" size="20" value="" /></td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Active: </strong></td><td style="padding: 5px;"><input type="checkbox" id="editactivecb" ';
		if (active == 1) { editfunddivh += 'checked '; }
		editfunddivh += '/>'
		+ '<tr><td colspan="2" style="padding: 5px;"><button id="addeventbtn" class="buttonsdesign" onclick="editFund()">Edit Fund</button></td></tr>'
		+ '</table></div>';
		$('editfunddiv').innerHTML = editfunddivh;
		
		populateFundInfo(id,fund,amount,total);
	}
}

function populateFundInfo(i,f,a,t) {
	$('editfundhiddenid').value = i;
	$('edittxtfund').value = f;
	$('edittxtamount').value = a;
	$('edittxttarget').value = t;
}

function editFund() {
	var id = $('editfundhiddenid').value;
	var f = $('edittxtfund').value;
	var a = $('edittxtamount').value;
	var t = $('edittxttarget').value;
	var act = $('editactivecb').checked;
	
	var actsend;
	if (act) { actsend = 1; } else { actsend=0; }
	
	var url = "../../includes/ajax/fvds.php?method=updateFund";
	var pars = "id="+id+"&fund="+f+"&amount="+a+"&target="+t+"&active="+actsend;
	new Ajax(url, {postBody:pars, onComplete:doNothing}).request();

	updateFunds();
}

function editFunds() {
	var i = 0;
	while ($('hid'+i)) {
		var id = $('hid'+i).value;
		var f = $('name'+i).value;
		var a = $('amount'+i).value;
		var t = $('raised'+i).value;
		var act = $('check'+i).checked;
		
		var actsend;
		if (act) { actsend = 1; } else { actsend=0; }
		
		var url = "../../includes/ajax/fvds.php?method=updateFund";
		var pars = "id="+id+"&fund="+f+"&amount="+a+"&target="+t+"&active="+actsend;
		new Ajax(url, {postBody:pars, onComplete:doNothing}).request();
		i++;
	}
	updateFunds();
}

function updateFunds() {
	$('updatefunddiv').innerHTML = '<p style="color:green">The funds been successfully updated.</p>';
}

function populateFundsDD(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"fund");
			$('editfunddd').options[i] = new Option(e,id);
		}
	}
}

// delete funds
function showDeleteFund() {
	var id = $('deletefunddd').SelectedLabel();
	var url = "../../includes/ajax/fvds.php?method=getEditFundsInfo";
	var pars = "id="+id;
	new Ajax(url,{postBody:pars, onComplete:displayDeleteFunds}).request();
}

function displayDeleteFunds(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		$('deletefunddiv').style.display = 'block';	
		var id = ds.cell(0,"id");
		var fund = ds.cell(0,"fund");
		var amount = ds.cell(0,"amount");
		var total = ds.cell(0,"target");
		var active = ds.cell(0,"active");

		$('deletefunddiv').innerHTML = '';
		var deletefunddiv= '';
		deletefunddiv += '<hr width="410px">'
		+ '<table bgcolor="#ffffff" border="1" width="410px" rules=none frame=box><div id="editfunddiv">'
		+ '<tr><td style="padding: 5px" colspan="2"><img src="/images/admin/fundinformation.jpg" /></td></tr>'
		+ '<tr><td style="padding: 5px;"><input type="hidden" id="deletefundhiddenid" value="'+id+'" /><strong>Fund name: </strong></td><td style="padding: 5px;">'+fund+'</td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Amount Raised: </strong></td><td style="padding: 5px;">'+amount+'</td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Target Amount: </strong></td><td style="padding: 5px;">'+total+'</td></tr>'
		+ '<tr><td style="padding: 5px;"><strong>Active: </strong></td><td style="padding: 5px;"><span style="color:';
		if (active == 1) { deletefunddiv += 'green;">Active'; } else { deletefunddiv += 'red;">Not Active'; }
		deletefunddiv += '</span></td></tr>'
		+ '<tr><td colspan="2" style="padding: 5px;">';
		if (active == 1) { deletefunddiv += '<button id="addeventbtn" onclick="deleteFund()" class="buttonsdesign">Delete '; } else { deletefunddiv += '<button id="addeventbtn" onclick="restoreFund()" class="buttonsdesign">Restore '; }
		deletefunddiv += 'Fund</button></td></tr>'
		+ '</table></div>';
		$('deletefunddiv').innerHTML = deletefunddiv;
	}
}

function deleteFund() {
	var c = confirm("Are you suere you want to delete this fund");
	if (c) {
		var id = $('deletefundhiddenid').value;
		var url = "../../includes/ajax/fvds.php?method=deleteFund";
		var pars = "id="+id;
		new Ajax(url,{postBody:pars, onComplete:updateFundsDelete}).request();
	}
}

function updateFundsDelete() {
	$('deletefunddiv').innerHTML = '<p style="color: green">The fund been successfully deleted.</p>';
	eraseDropDown($('deletefunddd'));
	var url = "../../includes/ajax/fvds.php?method=getFunds";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateFundsDDDelete}).request();
}

function restoreFund() {
	var c = confirm("Are you suere you want to restore this fund");
	if (c) {
		var id = $('deletefundhiddenid').value;
		var url = "../../includes/ajax/fvds.php?method=restoreFund";
		var pars = "id="+id;
		new Ajax(url,{postBody:pars, onComplete:updateFundsRestore}).request();
	}
}

function updateFundsRestore() {
	$('deletefunddiv').innerHTML = '<p style="color: green">The fund been successfully restored.</p>';
	eraseDropDown($('deletefunddd'));
	var url = "../../includes/ajax/fvds.php?method=getFunds";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:populateFundsDDDelete}).request();
}

function populateFundsDDDelete(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var e = ds.cell(i,"fund");
			var a = ds.cell(i,"active");
			var col;
			(a==1) ? col="green" : col="red";
			$('deletefunddd').options[i] = new Option(e,id);
			$('deletefunddd').options[i].style.color = col;
		}
	}
}

function insertNewFund() {
	var f = $('addtxtfund').value;
	var r = $('addtxtraised').value;
	var a = $('addtxttarget').value;
	var c = $('addcbactive').checked;

	var send;
	if (c) { send = 1; } else { send = 0; }
	var url = "../../includes/ajax/fvds.php?method=insertFund";
	var pars = "fund="+f+"&raised="+r+"&amout="+a+"&active="+send;
	new Ajax (url, {postBody:pars, onComplete:showInfo}).request();
}

function showInfo() {
	$('addfunddiv').innerHTML = "<p style='color: green'>The new fund has been successfully added.</p>";
}

function popnewshidden() {
	$('sporthidden').value = $('addnewssportdd').SelectedLabel();
	
	var i = tinyMCE.get('addnewstxtintroduction').getContent();
	var s = tinyMCE.get('addnewstxtstory').getContent();
	var intro = replacechars(i);
	var story = replacechars(s);
	
	$('introhidden').value = intro;
	$('storyhidden').value = story;	
	
	$('addnewsform').submit();
}

function popnewshiddenedit() {
	$('editnewshidden').value = $('editnewssportdd').SelectedLabel();
	
	var i = tinyMCE.get('editnewstxtintroduction').getContent();
	var s = tinyMCE.get('editnewstxtstory').getContent();
	var intro = replacechars(i);
	var story = replacechars(s);
	
	$('editintrohidden').value = intro;
	$('editstoryhidden').value = story;	
	
	$('editnewsform').submit();
}

function replacechars(i) {
	i = i.replace(/</g,"&lt;");
	i = i.replace(/>/g,"&gt;");
	i = i.replace(/&/g,"#amp#");
	i = i.replace(/'/g,"#qot#");
	i = i.replace(/"/g,"#dqot#");
	return i;
}

function decode(s) {
	s = s.replace(/#amp#/g,"&");
	s = s.replace(/&lt;/g,"<");
	s = s.replace(/&gt;/g,">");
	s = s.replace(/#qot#/g,"'");
	s = s.replace(/#dqot#/g,"\"");
	return s;
}

function showMyBio(id) {
	var url = "../includes/ajax/fvds.php?method=getBio";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:showBio}).request();
}

function showBio(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r>0) {
		var b = decode(ds.cell(0,"bio"));
		
		$('athleteinfo').innerHTML = b;
	}
	else {
		$('athleteinfo').innerHTML = '<p>I\'m sorry, but I currently do not have a bio to display</p>';
	}
}

function showMyPhotos(id) {
	var url = "../includes/ajax/fvds.php?method=getPhotos";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:showPhotos}).request();
}

function showPhotos(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	if (Shadowbox.init()) { alert("Y"); } else { alert("n"); }
	if (r>0) {
		var phdiv = '';
		phdiv = '<table border="0" cellpadding="2" cellspacing="2" align="center"><tr>';
		for (var i=0;i<r;i++) {
			var f = ds.cell(i,"file");
			var id = ds.cell(i,"id");
			
			if ((i%3)==0) {
				phdiv += '</tr><tr>';
			}
			
			phdiv += '<td style="padding:5px" width="33%"><a href="/images/photos/'+f+'" rel="shadowbox[images];" class="option"><img src="/images/photos/'
				  + f
				  + '" height="80" width="60"></a>'
				  + '</td>';
		}
		phdiv += '</tr></table>';
		$('athleteinfo').innerHTML = phdiv;
	}
	else {
		$('athleteinfo').innerHTML = '<p>Currently, I have no photos on my profile</p>';
	}
}

function viewaotd() {
	var i = $('selaotd').value;
	var sp = i.split('&');
	var id = sp[0];
	var s = sp[1];
	
	window.location.href = "/athleteprofiles/athleteoftheday.php?id="+id+"&sport="+s;
}

function updatePhotos() {
	var i = 0;
	while ($('check'+i)) {
		var c = $('check'+i).checked;
		var id = $('hid'+i).value;
		
		var url="../../includes/ajax/fvds.php?method=updatePhotos";
		var pars = "id="+id+"&active=";
		
		if (c) {
			pars += 1;
		} else {
			pars += 0;
		}
		
		new Ajax(url, {postBody:pars, onComplete:doNothing}).request();
		i++;
	}
	showUpdatedPhotos();
}

function showUpdatedPhotos() {
	var url="../../includes/ajax/fvds.php?method=getUpdatedPhotos";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayUpdatedPhotos}).request();
}

function displayUpdatedPhotos(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	var photodiv = '';
	$('photoadmin').innerHTML = '';
	var photodiv = '<table border="1" width="410px" bgcolor="#FFFFFF">'
		+ '<input type="hidden" id="athleteid" value="" />'
		+ '<tr><td colspan="3" style="padding:5px"><img src="/images/admin/managephotos.jpg" /></td></tr>'
		+ '<tr>';

	var ath = 0;
	for (var i=0;i<r;i++) {
		var id = ds.cell(i,"id");
		var aid = ds.cell(i,"athleteid");
		var f = ds.cell(i,"file");
		var a = ds.cell(i,"active");
		
		if (i == 0) { ath = aid; }
		if ((i%3)==0) { photodiv += '</tr></tr>'; }
		photodiv += '<td align="center"><input type="hidden" id="hid'+i+'" value="'+id+'">'
			+ '<img src="/images/photos/'+f+'" height="100" width="80"><br>'
			+ 'Display: <input type="checkbox" id="check'+i+'" ';
			if (a != 0) { photodiv += 'checked'; }
		photodiv += '></td>';
		
	}
		photodiv += '</tr><tr><td colspan="3" style="padding: 5px"><button onclick="updatePhotos()">Update Your Photos</button></td></tr></table>';
		$('photoadmin').innerHTML = photodiv;
		$('athleteid').value = ath;
		alert("Your photos have been successfully updated");
}

function doNothing() { }

function addmorecommittee() {
	var pos = $('newposition').value;
	var a = new Array();
	for (var i=0; i<3;i++) {
		var s = $('addindb'+i).checked;
		a[i] = s;
	}
	
	if (a[0] == true) {
		var url="../../includes/ajax/fvds.php?method=addNewPosition";
		var pars = "pos="+pos+"&type=beginning";
		new Ajax(url, {postBody:pars, onComplete:displayPositionMessage}).request();
	}
	if (a[1] == true) {
		var url="../../includes/ajax/fvds.php?method=addNewPosition";
		var pars = "pos="+pos+"&type=end";
		new Ajax(url, {postBody:pars, onComplete:displayPositionMessage}).request();
	}
	if (a[2] == true) {
		var oldon = $('addafterdd').value;
		var url="../../includes/ajax/fvds.php?method=addNewPosition";
		var pars = "pos="+pos+"&type="+oldon;
		new Ajax(url, {postBody:pars, onComplete:displayPositionMessage}).request();
	}
}

function displayPositionMessage() { alert("Position Added"); }

function changeradio() {
	var a = new Array();
	for (var i=0; i<3;i++) {
		var s = $('addindb'+i).checked;
		a[i] = s;
	}
	if (a[2] != true) {
		$('addafterdd').disabled = true;
	}
	else {
		$('addafterdd').disabled = false;
	}
}

function displayClub() {
	var i = $('clubsdd').value;
	window.location.href = "clubs.php?id="+i;
}

function changebg(s) {
	$(s).style.background = '#eed6af';
}

function plainbg(s) {
	$(s).style.background = '#ffffff';
}

function restorebg() {
	var i = 0;
	while ($('hid'+i)) {
		$('select'+i).background = '#ffffff';
		$('extra'+i).background = '#ffffff';
		$('name'+i).background = '#ffffff';
	}
}

function updateCommittee() {
	var i = 0;
	while ($('hid'+i)) {
		 var id = $('hid'+i).value;
		 var pos = $('select'+i).SelectedValue();
		 var extra = $('extra'+i).value;
		 var name = $('name'+i).value;
		 
		var url="../../includes/ajax/fvds.php?method=updateCommittee";
		var pars = "id="+id+"&pos="+pos+"&extra="+extra+"&name="+name;
		if (!($('hid'+(i+1)))) { new Ajax(url, {postBody:pars, onComplete:displayCommittee}).request(); }
		else { new Ajax(url, {postBody:pars, onComplete:doNothing}).request(); }
		i++;
	 }
 
}

function displayCommittee() {
	window.location.href = "index.php?message=submitted";
}

function showEditClubs() {
	var id = $('clubsdd').value;
	var url="../../includes/ajax/fvds.php?method=getEditClubs";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayEditClubs}).request();
}

function displayEditClubs(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		var id = ds.cell(0,"id");
		var n = ds.cell(0,"name");
		var info = decode(ds.cell(0,"info"));
		var a = ds.cell(0,"active");
		var s = ds.cell(0,"sport");
				
		$('clubid').value = id;
		$('clubname').value = n;
		tinyMCE.get('clubinfo').setContent(info);
		(a == 1) ? $('clubactive').checked = true : $('clubactive').checked = false;
		(a == 0) ? $('activateclubs').style.display = "block" : $('removeclubs').style.display = "block";
		$('clubclear').style.display = "block";
		$('clubbtnedit').style.display = "block";
		$('clubbtn').style.display = "none";		
		$('clubsport').value = s;
	}
}
function clearfields() {
	$('clubid').value = '';
	$('clubname').value = '';
	tinyMCE.get('clubinfo').setContent("");
	$('clubactive').checked = true;
	$('clubsport').value = options[0];

	$('activateclubs').style.display = "none";
	$('removeclubs').style.display = "none";
	$('clubbtnedit').style.display = "none";
	$('clubbtn').style.display = "block";	
}

function addClub() {
	var n = replacechars($('clubname').value);
	var info = replacechars(tinyMCE.get('clubinfo').getContent());
	var a = $('clubactive').checked;
	var s = $('clubsport').value;
	var active;
	
	(a) ? active = 1 : active = 0;
	
	var url="../../includes/ajax/fvds.php?method=addClub";
	var pars = "name="+n+"&info="+info+"&active="+active+"&sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displayAddClubs}).request();
}

function displayAddClubs() {
	$('clubinfodiv').innerHTML = '<p style="color:green"><strong>'+$('clubname').value+'</strong> has been successfully added</p>';
	
	eraseDropDown($('clubsdd'));
	var url="../../includes/ajax/fvds.php?method=getClubs";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewClubs}).request();
}

function displayNewClubs(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r>0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var s = ds.cell(i,"name");
			var a = ds.cell(i,"active");
			var c;
			(a==1) ? c="green" : c="red";
			$('clubsdd').options[i] = new Option(s,id);
			$('clubsdd').options[i].style.color = c;
		}
	}
	clearfields();
}

function addCourse() {
	var n = replacechars($('coursename').value);
	var b = $('bodytype').value;
	var info = replacechars(tinyMCE.get('courseinfo').getContent());
	var venue = replacechars($('coursevenue').value);
	var date = $('coursedate').value;
	var st = $('starttime').value;
	var et = $('endtime').value;
	var age = replacechars($('courseage').value);
	var cost = replacechars($('coursecost').value);
	var duration = replacechars($('courseduration').value);
	var tutor = replacechars($('coursetutor').value);
	var ch = $('coursecb').checked;
	
	date = date.replace(/\//g,"-");
	var url="../../includes/ajax/fvds.php?method=addCourse";
	var pars = "bodytype="+b+"&name="+n+"&info="+info+"&vanue="+venue+"&date="+date+"&starttime="+st+"&endtime="+et+"&age="+age+"&cost="+cost+"&duration="+duration+"&tutor="+tutor;
	var active;
	(ch) ? active = 1 : active = 0;
	pars += "&active="+active;
	new Ajax(url, {postBody:pars, onComplete:displayAddCourses}).request();
}

function displayAddCourses() {
	$('courseinfodiv').innerHTML = '<p style="color:green"><strong>'+$('coursename').value+'</strong> has been successfully added</p>';

	eraseDropDown($('coachdd'));
	var url="../../includes/ajax/fvds.php?method=getCourses";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewCourses}).request();
}

function displayNewCourses(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r>0) {
		for (var i=0;i<r;i++) {
			var s = ds.cell(i,"title");
			var id = ds.cell(i,"id");
			var a = ds.cell(i,"active");
			var b = ds.cell(i,"bodytype");
			var c;
			(a==1) ? c="green" : c="red";
			s += " ("+b+")";
			$('coachdd').options[i] = new Option(s,id);
			$('coachdd').options[i].style.color = c;
		}
	}
	courseclearfields();
}

function showEditCourses() {
	var id = $('coachdd').value;

	var url="../../includes/ajax/fvds.php?method=getEditCourses";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayEditCourses}).request();
}

function displayEditCourses(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		var b = ds.cell(0,"bodytype");
		var id = ds.cell(0,"id");
		var n = decode(ds.cell(0,"title"));
		var info = decode(ds.cell(0,"description"));
		var v = ds.cell(0,"venue");
		var d = ds.cell(0,"date");
		var st = ds.cell(0,"starttime");
		var et = ds.cell(0,"endtime");
		var a = decode(ds.cell(0,"age"));
		var c = decode(ds.cell(0,"cost"));
		var dur = decode(ds.cell(0,"duration"));
		var t = decode(ds.cell(0,"tutor"));
		var ac = ds.cell(0,"active");
		
		st = st.substr(0,5);
		et = et.substr(0,5);
		d = d.replace(/-/g,"/");
		$('bodytype').value = b;
		$('courseid').value = id;
		$('coursename').value = n;
		tinyMCE.get('courseinfo').setContent(info);
		$('coursevenue').value = v;
		$('coursedate').value = d;
		$('starttime').value = st;
		$('endtime').value = et;
		$('courseage').value = a;
		$('coursecost').value = c;
		$('courseduration').value = dur;
		$('coursetutor').value = t;
		(ac == 1) ? $('coursecb').checked = true : $('coursecb').checked = false;

		(ac == 0) ? $('activatecourse').style.display = 'block' : $('removecourse').style.display = 'block';
		$('courseclear').style.display = "block";
		$('coursebtnedit').style.display = "block";
		$('coursebtn').style.display = "none";		
	}
}

function editCourse() {
	var id = $('courseid').value;
	var n = replacechars($('coursename').value);
	var info = replacechars(tinyMCE.get('courseinfo').getContent());
	var venue = replacechars($('coursevenue').value);
	var date = $('coursedate').value;
	var st = $('starttime').value;
	var et = $('endtime').value;
	var age = replacechars($('courseage').value);
	var cost = replacechars($('coursecost').value);
	var duration = replacechars($('courseduration').value);
	var tutor = replacechars($('coursetutor').value);
	
	date = date.replace(/\//g,"-");
	var url="../../includes/ajax/fvds.php?method=editCourse";
	var pars = "id="+id+"&name="+n+"&info="+info+"&vanue="+venue+"&date="+date+"&starttime="+st+"&endtime="+et+"&age="+age+"&cost="+cost+"&duration="+duration+"&tutor="+tutor;
	new Ajax(url, {postBody:pars, onComplete:displayEditCourses}).request();
}

function displayEditCourse() {
	$('courseinfodiv').innerHTML = '<p style="color:green"><strong>'+$('coursename').value+'</strong> has been successfully updated</p>';
	courseclearfields();
}

function courseclearfields() {
	$('courseid').value = "";
	$('coursename').value = "";
	tinyMCE.get('courseinfo').setContent("");
	$('coursevenue').value = "";
	$('coursedate').value = "";
	$('starttime').value = "08:00";
	$('endtime').value = "08:00";
	$('courseage').value = "";
	$('coursecost').value = "";
	$('courseduration').value = "";
	$('coursetutor').value = "";
	$('coursecb').checked = true;

	$('activatecourse').style.display = 'none';
	$('removecourse').style.display = 'none';
	$('coursebtnedit').style.display = "none";
	$('coursebtn').style.display = "block";		
}

function editCourseInfo() {
	var id = $('courseid').value;
	var n = replacechars($('coursename').value);
	var info = replacechars(tinyMCE.get('courseinfo').getContent());
	var venue = replacechars($('coursevenue').value);
	var date = $('coursedate').value;
	var st = $('starttime').value;
	var et = $('endtime').value;
	var age = replacechars($('courseage').value);
	var cost = replacechars($('coursecost').value);
	var duration = replacechars($('courseduration').value);
	var tutor = replacechars($('coursetutor').value);
	var ch = $('coursecb').checked;
	
	date = date.replace(/\//g,"-");
	var url="../../includes/ajax/fvds.php?method=editCourse";
	var pars = "id="+id+"&name="+n+"&info="+info+"&vanue="+venue+"&date="+date+"&starttime="+st+"&endtime="+et+"&age="+age+"&cost="+cost+"&duration="+duration+"&tutor="+tutor;
	var active;
	(ch) ? active = 1 : active = 0;
	pars += "&active="+active;
	new Ajax(url, {postBody:pars, onComplete:displayEditCoursesEdit}).request();
}

function displayEditCoursesEdit() {
	$('courseinfodiv').innerHTML = '<p style="color:green"><strong>'+$('coursename').value+'</strong> has been successfully updated</p>';

	eraseDropDown($('coachdd'));
	var url="../../includes/ajax/fvds.php?method=getCourses";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewCourses}).request();
}

function removeCourse() {
	var id = $('courseid').value;
	var url="../../includes/ajax/fvds.php?method=removeCourse";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayRemoveCourses}).request();
}

function activateCourse() {
	var id = $('courseid').value;
	var url="../../includes/ajax/fvds.php?method=activateCourse";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayActivateCourses}).request();
}

function displayRemoveCourses() {
	$('courseinfodiv').innerHTML = '<p style="color:green"><strong>'+$('coursename').value+'</strong> has been successfully removed</p>';

	eraseDropDown($('coachdd'));
	var url="../../includes/ajax/fvds.php?method=getCourses";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewCourses}).request();
}

function displayActivateCourses() {
	$('courseinfodiv').innerHTML = '<p style="color:green"><strong>'+$('coursename').value+'</strong> has been successfully activated</p>';

	eraseDropDown($('coachdd'));
	var url="../../includes/ajax/fvds.php?method=getCourses";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewCourses}).request();
}

function editClubInfo() {
	var id = $('clubid').value;
	var n = replacechars($('clubname').value);
	var info = replacechars(tinyMCE.get('clubinfo').getContent());
	var a = $('clubactive').checked;
	var s = $('clubsport').value;
	var active;
	
	(a) ? active = 1 : active = 0;
	
	var url="../../includes/ajax/fvds.php?method=editClubs";
	var pars = "id="+id+"&name="+n+"&info="+info+"&active="+active+"&sport="+s;
	new Ajax(url, {postBody:pars, onComplete:displayEditClubsEdit}).request();
}

function displayEditClubsEdit() {
	$('clubinfodiv').innerHTML = '<p style="color:green"><strong>'+$('clubname').value+'</strong> has been successfully updated</p>';

	eraseDropDown($('clubsdd'));
	var url="../../includes/ajax/fvds.php?method=getClubs";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewClubs}).request();
}

function removeClubs() {
	var id = $('clubid').value;
	var url="../../includes/ajax/fvds.php?method=removeClubs";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayRemoveClubs}).request();
}

function activateClubs() {
	var id = $('clubid').value;
	var url="../../includes/ajax/fvds.php?method=activateClubs";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayActivateClubs}).request();
}

function displayRemoveClubs() {
	$('clubinfodiv').innerHTML = '<p style="color:green"><strong>'+$('clubname').value+'</strong> has been successfully removed</p>';

	eraseDropDown($('clubsdd'));
	var url="../../includes/ajax/fvds.php?method=getClubs";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewClubs}).request();
}

function displayActivateClubs() {
	$('clubinfodiv').innerHTML = '<p style="color:green"><strong>'+$('clubname').value+'</strong> has been successfully activated</p>';

	eraseDropDown($('clubsdd'));
	var url="../../includes/ajax/fvds.php?method=getClubs";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewClubs}).request();
}

function updateOrder() {
	var i = 0;
	while ($('old'+i)) {
		var o = $('old'+i).value;
		var n = $('new'+i).value;
		var p = $('pos'+i).value;
		
		var url="../../includes/ajax/fvds.php?method=updateOrder";
		var pars = "old="+o+"&new="+n+"&position="+p;
		if (!($('old'+(i+1)))) { new Ajax(url, {postBody:pars, onComplete:newOrder}).request(); }
		else { new Ajax(url, {postBody:pars, onComplete:doNothing}).request(); }
		i++;
	}
}

function newOrder(sText,oXml) {
	window.location.href = "editorder.php?message=submitted";
}

// links
function showEditLinks() {
	var id = $('linksdd').value;
	var url="../../includes/ajax/fvds.php?method=getEditLinks";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayEditLinks}).request();
}

function displayEditLinks(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	if (r > 0) {
		var id = ds.cell(0,"id");
		var t = ds.cell(0,"type");
		var n = ds.cell(0,"link");
		var u = ds.cell(0,"url");
		var a = ds.cell(0,"active");
				
		$('linksid').value = id;
		$('editlinksdd').value = t;
		$('linkname').value = n;
		$('linkurl').value = u;
		(a == 1) ? $('linkactive').checked = true : $('linkactive').checked = false;
		(a == 0) ? $('activatelinks').style.display = "block" : $('removelinks').style.display = "block";
		$('linkclear').style.display = "block";
		$('linkbtnedit').style.display = "block";
		$('linkbtn').style.display = "none";		
	}
}

function editLinkInfo() {
	var id = $('linksid').value;
	var t = $('editlinksdd').value;
	var n = replacechars($('linkname').value);
	var u = $('linkurl').value;
	var a = $('linkactive').checked;
	var active;
	
	(a) ? active = 1 : active = 0;
	
	var url="../../includes/ajax/fvds.php?method=editLinks";
	var pars = "id="+id+"&type="+t+"&link="+n+"&url="+u+"&active="+active;
	new Ajax(url, {postBody:pars, onComplete:displayEditLinksEdit}).request();
}

function displayEditLinksEdit() {
	$('linksinfodiv').innerHTML = '<p style="color:green"><strong>'+$('linkname').value+'</strong> has been successfully updated</p>';

	eraseDropDown($('linksdd'));
	var url="../../includes/ajax/fvds.php?method=getLinks";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewLinks}).request();
}

function displayNewLinks(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r>0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var s = ds.cell(i,"link");
			var a = ds.cell(i,"active");
			var c;
			(a==1) ? c="green" : c="red";
			$('linksdd').options[i] = new Option(s,id);
			$('linksdd').options[i].style.color = c;
		}
	}
	clearfieldslinks();
}

function clearfieldslinks() {
	$('linksid').value = '';
	$('linkname').value = '';
	$('linkurl').value = '';
	$('linkactive').checked = true;

	$('activatelinks').style.display = "none";
	$('removelinks').style.display = "none";
	$('linkbtnedit').style.display = "none";
	$('linkbtn').style.display = "block";	
}

function addLink() {
	var t = $('editlinksdd').value
	var n = $('linkname').value;
	var u = $('linkurl').value;
	var a = $('linkactive').checked;
	var active;
	
	(a) ? active = 1 : active = 0;
	
	var url="../../includes/ajax/fvds.php?method=addLink";
	var pars = "type="+t+"&link="+n+"&url="+u+"&active="+active;
	new Ajax(url, {postBody:pars, onComplete:displayAddLinks}).request();
}

function displayAddLinks() {
	$('linksinfodiv').innerHTML = '<p style="color:green"><strong>'+$('linkname').value+'</strong> has been successfully added</p>';
	
	eraseDropDown($('linksdd'));
	var url="../../includes/ajax/fvds.php?method=getLinks";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewLinks}).request();
}

function displayNewLinks(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r>0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var s = ds.cell(i,"link");
			var a = ds.cell(i,"active");
			var c;
			(a==1) ? c="green" : c="red";
			$('linksdd').options[i] = new Option(s,id);
			$('linksdd').options[i].style.color = c;
		}
	}
	clearfieldslinks();
}

function removeLinks() {
	var id = $('linksid').value;
	var url="../../includes/ajax/fvds.php?method=removeLinks";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayRemoveLinks}).request();
}

function activatelinks() {
	var id = $('linksid').value;
	var url="../../includes/ajax/fvds.php?method=activateLinks";
	var pars = "id="+id;
	new Ajax(url, {postBody:pars, onComplete:displayActivateLinks}).request();
}

function displayRemoveLinks() {
	$('linksinfodiv').innerHTML = '<p style="color:green"><strong>'+$('linkname').value+'</strong> has been successfully removed</p>';

	eraseDropDown($('linksdd'));
	var url="../../includes/ajax/fvds.php?method=getLinks";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewLinks}).request();
}

function displayActivateLinks() {
	$('linksinfodiv').innerHTML = '<p style="color:green"><strong>'+$('linkname').value+'</strong> has been successfully activated</p>';

	eraseDropDown($('linksdd'));
	var url="../../includes/ajax/fvds.php?method=getLinks";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayNewLinks}).request();
}

// results & fixtures
function showFixtures() {
	var d = $('fixturedate').value;
	curfix = "";
	
	var spld = d.split('-');
	var year = spld[0];
	var day = spld[2];
	fixhtml = '<p align="center"><strong>Currently Showing Events for: '+day+' July '+year+'</strong></p><hr style="text-align:center; width="65%">';
	var url="../../includes/ajax/fvds.php?method=getFixtureSports";
	var pars = "dateon="+d;
	new Ajax(url, {postBody:pars, onComplete:gettheevents}).request();
}

function gettheevents(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	if (r > 0) {
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			
			var url="../../includes/ajax/fvds.php?method=getTheEvents";
			var pars = "id="+id;
			new Ajax(url, {postBody:pars, onComplete:displaytheevents}).request();
		}
	}
	else {
		fixhtml += '<p>There are no events on this date</p>';
		$('fixdiv').innerHTML = fixhtml;
	}
}

function displaytheevents(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	var ev = ds.cell(0,"event");
	var sp = decode(ds.cell(0,"sport"));
	
	if (ev != curfix) {
		fixhtml += '<h2>'+ev+'</h2>';
		curfix = ev;
	}
	fixhtml += '<ul><li>'+sp+'</li></ul>';

	$('fixdiv').innerHTML = fixhtml;
}

function games() {
	var g = $('gamessel').value;
	window.location.href = "index.php?games="+g;
}

// gallery
function addnewgallery() {
	var g = $('newgallery').value;
	var m = $('pgamesel').value;
	var url="../../includes/ajax/fvds.php?method=addnewgallery";
	var pars = "name="+g+"&game="+m;
	new Ajax(url, {postBody:pars, onComplete:updategallerylist}).request();
}

function updategallerylist() {
	var url="../../includes/ajax/fvds.php?method=getGallery";
	var pars = "";
	new Ajax(url, {postBody:pars, onComplete:displayGallery}).request();
}

function displayGallery(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	eraseDropDown($('galsel'));
	$('galsel').options[0] = new Option('Select galley');
	for (var i=0;i<r;i++) {
		var g = ds.cell(i,"gallery");
		$('galsel').options[i+1] = new Option(g,i);
	}
	$('newgalley').value = "";
}

function submittheform(s) {
	if (s) {
		$('addGalleryForm').action = "index.php";
		$('addGalleryForm').submit();
	}
}

function checkform() {
	var g = $('pgamesel').value;
	var gal = $('galsel').value;
	var pic = $('newPicture').value;
	var ok = true;
	var msg = 'There was a problem submitting the form.  Please ensure that:\n';
	
	if (g == '-1') { msg += '\n\tYou have selected a game'; ok = false; }
	if (gal ==  '-1') { msg += '\n\tYou have selected a gallery'; ok = false; }
	if (pic == '') { msg += '\n\tYou have selected a picture to upload'; ok = false; }
	
	if (!ok) { alert(msg); } else { submittheform(ok); }
}

function getthegalleries() {
	var g = $('gamessel').value;
	var url="../includes/ajax/fvds.php?method=getthegalleries";
	var pars = "games="+g;
	new Ajax(url, {postBody:pars, onComplete:popGalleries}).request();
}

function popoGalleries(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	if (r>0) {
		$('galsel').disabled = false;
		eraseDropDown($('galsel'));
		$('galsel').options[0] = new Option('Select galley');
		for (var i=0;i<r;i++) {
			var g = ds.cell(i,"gallery");
			var id = ds.cell(i,"id");
			$('galsel').options[i+1] = new Option(g,id);
		}
	}
	else {
		alert("No galleries found");
	}
}

function getpictures() {
	var g = $('pgamesel').value;
	var gal = $('pgalsel').value;
	var url="../../includes/ajax/fvds.php?method=getgalpictures";
	var pars = "games="+g+"&gallery="+gal;
	new Ajax(url, {postBody:pars, onComplete:showavailablepictures}).request();
}

function showavailablepictures(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	var html = "";
	if (sText == "none") { alert("No pictures found"); }
	else { $('picdiv').innerHTML = sText; }
}

function pgamessel() {
	var g = $('pgamesel').value;
	if (g != "-1") {
		var url="../../includes/ajax/fvds.php?method=pgamessel";
		var pars = "games="+g;
		new Ajax(url, {postBody:pars, onComplete:getCategories}).request();
	}
}

function getCategories(sText,oXml) {
	var ds = new DataSet(oXml);
	var r = ds.rowcount();
	
	if (sText == "none") { alert("No Galleries available"); }
	else { $('picdiv').innerHTML = sText; }
/*	if (r>0) {
		eraseDropDown($("pgalsel"));
		$('pgalsel').options[0] = new Option('Select category');
		for (var i=0;i<r;i++) {
			var id = ds.cell(i,"id");
			var gal = ds.cell(i,"gallery");
			$('pgalsel').options[i+1] = new Option(gal,id);
		}
	}
	else {
		alert("No categories found");
	}*/
}

function selectpage() {
	if ($('pagesel').value != "-1") {
		window.location.href = $('pagesel').value;
	}
}