function AjaxInit(){
	var AjaxObj = false;
	if(window.XMLHttpRequest){
		AjaxObj = new XMLHttpRequest();
	}else if(window.ActiveXObject){
		AjaxObj=new ActiveXObject("Msxml2.XMLHTTP");
		if (!AjaxObj){
			AjaxObj=new ActiveXObject("Microsoft.XMLHTTP");
		}
	}
	return(AjaxObj);
}
function ajaxVars(){
	this.colDelim = '|||';
	this.rowDelim = '^^^';
	this.varDelim = '###';
	this.vars = new Array();
	this.fnVars = new Array();
	this.dbVars = new Array();
	this.method = 'POST';
	this.gotoFunction = '';
	this.status = 'loadingDiv';
	this.AjaxPostSQL = AjaxPostSQL;
	this.phpFile = "/lib/ajax.data.php";
}
function AjaxPostSQL(){

	with(this){
		url = this.phpFile;
		this.divObj = document.getElementById(this.status);
		if(this.divObj) {
			window.status = "Loading...";
			this.divObj.innerHTML = "<span class='statusWait'>Saving changes... Please wait.</span>";
		}

		var Ajax=AjaxInit();

		try {
			if(method == 'GET') {
				url += '?' + queryStr;
			}
			Ajax.open(method, url);

			Ajax.setRequestHeader("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8");
			Ajax.onreadystatechange = function() {
				if (Ajax.readyState == 4 && Ajax.status == 200) {
					window.status = "Done";
					dragFlag = false;
					if(divObj) {
						divObj.innerHTML = '<span class=\'statusDone\'>Done.</span>';
					}
					var data = Ajax.responseText;
					if(data.indexOf('on line') >= 0) {
						document.body.innerHTML = data;
						return false;
					}

					//Debug related info
			
					fillSqlDebug(Ajax.responseText);
					cleanData = filterData(Ajax.responseText);
		
					switch(vars['action']) {
						case 'mysql_query':
						case 'mysql_num_rows':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'mysql_fetch_array':
						case 'mysql_fetch_assoc':
						case 'mysql_fetch_row':
							var dataArr = new Array();
							dataArr = createDataArr(data, rowDelim, colDelim, varDelim);
							eval(gotoFunction + '(dataArr, fnVars)');
						break;

						case 'update':
							var dataArr = new Array();
							dataArr = createDataArr(data, rowDelim, colDelim, varDelim);
							eval(gotoFunction + '(dataArr, fnVars)');
						break;

						case 'updateImage':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'modify':
							data = data.replace(/(.*)=/g, '');
							if(fieldObj)
								eval(gotoFunction + '(data, fieldObj)');
							else 
								eval(gotoFunction + '(data)');
						break;

						case 'runFunction':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'runFunctionArr':
							dataArr = createDataArr(data, rowDelim, colDelim, varDelim);
							eval(gotoFunction + '(dataArr, fnVars)');
						break;

						default:
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;
					}
				}
			}
			var queryStr = '&dbVars=' + this.dbVars;
			for(key in this.vars){
				queryStr += '&' + key + '='  + encodeStr(this.vars[key]);
			}
			Ajax.send(queryStr + "&random=" + Math.random());
		}catch (errv) {
			// Ajax.send(errv);

			Ajax.onreadystatechange = function() {
				if (Ajax.readyState == 4 && Ajax.status == 200) {
					window.status = "Done";
					dragFlag = false;
					if(divObj) {
						divObj.innerHTML = '<span class=\'statusDone\'>Done.</span>';
					}
					var data = Ajax.responseText;
					if(data.indexOf('on line') >= 0) {
						document.body.innerHTML = data;
						return false;
					}

					//Debug related info
			
					fillSqlDebug(Ajax.responseText);
					cleanData = filterData(Ajax.responseText);
		

					switch(vars['action']) {
						case 'mysql_query':
						case 'mysql_num_rows':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'mysql_fetch_array':
						case 'mysql_fetch_assoc':
						case 'mysql_fetch_row':
							var dataArr = new Array();
							dataArr = createDataArr(data, rowDelim, colDelim, varDelim);
							eval(gotoFunction + '(dataArr, fnVars)');
						break;

						case 'update':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'updateImage':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						case 'modify':
							data = data.replace(/(.*)=/g, '');
							if(fieldObj)
								eval(gotoFunction + '(data, fieldObj)');
							else 
								eval(gotoFunction + '(data)');
						break;

						case 'runFunction':
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;

						default:
							data = data.replace(/(.*)=/g, '');
							eval(gotoFunction + '(data, fnVars)');
						break;
					}
				}

			}
		}
	}
}
function encodeStr(str){
	if(isNaN(str)) {
		str = str.replace('&', '##AND##');
		str = str.replace('=', '##EQUAL##');
		str = str.replace('?', '##QUESTION##');
	}
	return str;
}
function decodeStr(str){
	str = str.replace('##AND##', '&');
	str = str.replace('##EQUAL##', '=');
	str = str.replace('##QUESTION##', '?');
	return str;
}
function createDataArr(data, rowDelim, colDelim, varDelim){
	//alert(data);
	var rowCount = 0;
	var dataArr = new Array();
	
	if(data.indexOf(rowDelim) >= 0) {
		var rowStr = data.split(rowDelim);
		for(var i=0; i<rowStr.length; i++){
			if(rowStr[i].indexOf(colDelim) >= 0) {
				var colStr = rowStr[i].split(colDelim);
				for(var j=0; j<colStr.length; j++){
					if(colStr[j].indexOf(varDelim) >= 0) {
						var varStr = colStr[j].split(varDelim);
						var key = varStr[0];
						if(rowCount == 0) dataArr[key] = new Array();
						dataArr[key][rowCount] = varStr[1];
					}
				}
				rowCount++;
			}
		}
	}else{
	
	}
	return dataArr;
}

function update(table, id, fieldObj, fieldName){
	var ajaxVar = new ajaxVars();
	ajaxVar.vars['action'] = 'update';
	ajaxVar.vars['table'] = table;
	ajaxVar.gotoFunction = "updateStatus";
	ajaxVar.dbVars = fieldName;
	ajaxVar.vars['id'] = id;
	ajaxVar.vars[fieldName] = fieldObj.value;
	ajaxVar.AjaxPostSQL();
}
function updateImage(table, id, fieldName, fieldImageA){
	if(fieldImageA.hasChildNodes()){
		var imageNode = fieldImageA.firstChild;
		if(imageNode.src.indexOf('/active.gif')>=0) {
			var fieldValue = 0;
			var newImg = imageNode.src.replace(/\/active.gif/g, '/inactive.gif');
			imageNode.alt = 'Inactive';
		}else{
			var fieldValue = 1;
			var newImg = imageNode.src.replace(/\/inactive.gif/g, '/active.gif');
			imageNode.alt = 'Active';
		}
		imageNode.src = newImg;
	}

	var ajaxVar = new ajaxVars();
	ajaxVar.vars['action'] = 'modify';
	ajaxVar.vars['table'] = table;
	ajaxVar.vars[fieldName] = fieldValue;
	ajaxVar.vars['id'] = id;
	ajaxVar.gotoFunction = "empty";
	ajaxVar.dbVars = fieldName;
	ajaxVar.fieldObj = new Object();
	ajaxVar.AjaxPostSQL();
}

function modify(table, fieldElm){

	var ajaxVar = new ajaxVars();
	ajaxVar.vars['action'] = 'modify';
	ajaxVar.vars['table'] = table;
	ajaxVar.gotoFunction = "modifyStatus";
	switch(fieldElm.type) {
		case "radio":
		case "text":
		case "select":
		case "select-one":

			ajaxVar.fieldObj = fieldElm;
			ajaxVar.dbVars = fieldElm.name;
			ajaxVar.vars['id'] = fieldElm.form.id.value;
			ajaxVar.vars[fieldElm.name] = fieldElm.value;
		break;

		default:
			if(fieldElm.id.indexOf('__Frame') >=0) {
				var frmName = fieldElm.id;
				editor_frame = document.getElementById(frmName);
				editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea');
				var mContents = editor_source.contentWindow.document.body.innerHTML;
				hidElm = document.getElementById(frmName.replace(/___Frame/g, ''));
				hidElm.value = mContents;

				ajaxVar.fieldObj = hidElm;
				ajaxVar.dbVars = hidElm.name;
				ajaxVar.vars['id'] = hidElm.form.id.value;
				ajaxVar.vars[hidElm.name] = hidElm.value;
			}
		break;
	}
	ajaxVar.AjaxPostSQL();
}
function updateStatus(data){

}
function modifyStatus(data, fieldObj){
	Obj = document.getElementById('loadingdiv');
	if(Obj) {
		Obj.innerHTML = 'Done';
	}
	fieldObj.form.id.value = data;
}

function empty(data){
	hideStatus();
	// alert(1);
}
/*
function demo(data){
	alert (data);
}
var ajaxVar = new ajaxVars();
ajaxVar.vars['sql'] = "select * from persons order by id";
ajaxVar.vars['action'] = "mysql_fetch_array";
ajaxVar.gotoFunction = "demo";
ajaxVar.AjaxPostSQL();
*/

//Debug related functions [start]

function getPHPsql(){
	var debugObj = document.getElementById('sqldebug');

	var pTags = document.getElementsByTagName('P');
	var errorArr = new Array();
	for(var i=0; i<pTags.length; i++) {
		if(pTags[i].className == 'error'){
			pTags[i].className = 'ajerror';
			debugObj.insertBefore(pTags[i], debugObj.firstChild);
			i--;
		}
	}
	while(errorArr.length) {
		debugObj.insertBefore(pTags[0], debugObj.firstChild);
	}
}

function clearSqlDebug(){
	var debugObj = document.getElementById('sqldebug');
	var responseObj = document.getElementById('responsedebug');
	if(responseObj.hasChildNodes()){
		while(responseObj.hasChildNodes()) {
			responseObj.removeChild(responseObj.firstChild);
		}
	}
	if(debugObj.hasChildNodes()){
		while(debugObj.hasChildNodes()) {
			debugObj.removeChild(debugObj.firstChild);
		}
	}
	debugObj.innerHTML = '';
	debugObj.style.height = "240px";

	responseObj.innerHTML = '';
	responseObj.style.height = "240px";

}

function fillSqlDebug(data){

	var debugDivObj = document.getElementById('debug');
	var debugObj = document.getElementById('sqldebug');

	var sqlData = data.match(/<p class='error'>(.*)<\/p>/);

	var ptagE = document.createElement('P');
	if(sqlData) {
		debugDivObj.style.visibility = "visible";
		debugDivObj.style.display = "block";
		debugDivObj.style.padding = "5px";
		ptagE.innerHTML = sqlData[1];
		ptagE.className = 'ajerror';
		if(debugObj) {
			debugObj.insertBefore(ptagE, debugObj.firstChild);
		}else{
			alert(sqlData[1]);
		}
		var responseObj = document.getElementById('responsedebug');
		var responseData = data.match(/<p>(.*)<\/p>/);
		var ptagR = document.createElement('P');
		ptagR.className = 'ajerror';
		ptagR.innerHTML = filterData(data);
		if(responseObj) {
			responseObj.insertBefore(ptagR, responseObj.firstChild);
		}else{
			alert(filterData(data));
		}
	}

}

function filterData(data) {
	var newdata = data.replace(/<p(.*)p>/g, '');
	return newdata;
}

//Debug related functions [end]

function update(table, id, fieldObj, fieldName){
	var ajaxVar = new ajaxVars();
	ajaxVar.vars['action'] = 'update';
	ajaxVar.vars['table'] = table;
	ajaxVar.gotoFunction = "updateStatus";
	ajaxVar.dbVars = fieldName;
	ajaxVar.vars['id'] = id;
	ajaxVar.vars[fieldName] = fieldObj.value;
	ajaxVar.AjaxPostSQL();
}
// function updateImage(table, id, fieldName, fieldImageA){
// 	if(fieldImageA.hasChildNodes()){
// 		var imageNode = fieldImageA.firstChild;
// 		if(imageNode.src.indexOf('/active_new.gif')>=0) {
// 			var fieldValue = 0;
// 			var newImg = imageNode.src.replace(/\/active_new.gif/g, '/inactive_new.gif');
// 			imageNode.alt = 'Inactive';
// 		}else{
// 			var fieldValue = 1;
// 			var newImg = imageNode.src.replace(/\/inactive_new.gif/g, '/active_new.gif');
// 			imageNode.alt = 'Active';
// 		}
// 		imageNode.src = newImg;
// 	}

// 	var ajaxVar = new ajaxVars();
// 	ajaxVar.vars['action'] = 'modify';
// 	ajaxVar.vars['table'] = table;
// 	ajaxVar.vars[fieldName] = fieldValue;
// 	ajaxVar.vars['id'] = id;
// 	ajaxVar.gotoFunction = "empty";
// 	ajaxVar.dbVars = fieldName;
// 	ajaxVar.fieldObj = new Object();
// 	ajaxVar.AjaxPostSQL();
// 	
// }

function modify(table, fieldElm){
	var ajaxVar = new ajaxVars();
	ajaxVar.vars['action'] = 'modify';
	ajaxVar.vars['table'] = table;
	ajaxVar.gotoFunction = "modifyStatus";
	switch(fieldElm.type) {
		case "radio":
		case "text":
		case "select":
		case "select-one":

			ajaxVar.fieldObj = fieldElm;
			ajaxVar.dbVars = fieldElm.name;
			ajaxVar.vars['id'] = fieldElm.form.id.value;
			ajaxVar.vars[fieldElm.name] = fieldElm.value;
		break;

		default:
			if(fieldElm.id.indexOf('__Frame') >=0) {
				var frmName = fieldElm.id;
				editor_frame = document.getElementById(frmName);
				editor_source = editor_frame.contentWindow.document.getElementById('eEditorArea');
				var mContents = editor_source.contentWindow.document.body.innerHTML;
				hidElm = document.getElementById(frmName.replace(/___Frame/g, ''));
				hidElm.value = mContents;

				ajaxVar.fieldObj = hidElm;
				ajaxVar.dbVars = hidElm.name;
				ajaxVar.vars['id'] = hidElm.form.id.value;
				ajaxVar.vars[hidElm.name] = hidElm.value;
			}
		break;
	}
	ajaxVar.AjaxPostSQL();
}
function updateStatus(data){

}
function modifyStatus(data, fieldObj){
	Obj = document.getElementById('loadingdiv');
	if(Obj) {
		Obj.innerHTML = 'Done';
	}
	fieldObj.form.id.value = data;
}

function empty(data){
}
/*
function demo(data){
	alert (data);
}
var ajaxVar = new ajaxVars();
ajaxVar.vars['sql'] = "select * from persons order by id";
ajaxVar.vars['action'] = "mysql_fetch_array";
ajaxVar.gotoFunction = "demo";
ajaxVar.AjaxPostSQL();
*/