var xmlhttp;

function database_query(query, vars) {
	xmlhttp = null;
	if (window.XMLHttpRequest) {
		// code for IE7, Firefox, Opera, etc.
		xmlhttp = new XMLHttpRequest();
	} else if (window.ActiveXObject) {
		// code for IE6, IE5
		xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
	}

	if (xmlhttp != null) {
		xmlquery = "../php/database_query.php?query=" + query + vars;
		xmlhttp.onreadystatechange = state_change;
		
		xmlhttp.open("GET", xmlquery, true);
		xmlhttp.send(null);
	}
}

function state_change() {
	if (xmlhttp.readyState == 4) {
		// 4 = "loaded"
		if (xmlhttp.status == 200) {
			// 200 = "OK"
			ResultData = xmlhttp.responseText.split("<nf>");

			switch(ResultData[0]) {
				case "video_showcase":
					document.getElementById('now_playing').innerHTML = ResultData[1];
					document.getElementById('about_box_heading_padding').innerHTML = ResultData[2];
					document.getElementById('about_box_content_padding').innerHTML = ResultData[3];
					break;
				case "go_green":
					document.getElementById('GoGreen').innerHTML = ResultData[1];
					break;
				case "keyword_search":
					var AdsDisplayed = 0;

					var nl =  ResultData[1].split("<nl>");
					var innerHTML = "";
				
					for (var n in nl) {
						var ni =  nl[n].split("<ni>");
						
						switch(ni[0]) {
							case "cat_id":
								CatId = ni[1];
								break;
							case "innerHTML":
								document.getElementById(ni[1]).innerHTML = innerHTML;
								document.getElementById(ni[1]).style.display = "block";
								innerHTML = "";
								break;
							case "web_content":
								innerHTML += ni[1];
								break;
							case "headline_ad": case "right_ad": case "medium_ad":
								AdsDisplayed = 1;
								innerHTML += ni[1];
								break;
							case "middle_ad_flash": case "headline_ad_flash": case "right_ad_flash": case "medium_ad_flash":
								AdsDisplayed = 1;
								ni[1] = ni[1].replace(/\n/g, "").replace(/\t/g, "");
								var fl = ni[1].split("<fl>");
								innerHTML += fl[0];
								innerHTML += AC_FL_ReadContent(
									'codebase', fl[1],
									'width', fl[2],
									'height', fl[3],
									'src', fl[4],
									'quality', fl[5],
									'pluginspage', fl[6],
									'align', fl[7],
									'play', fl[8],
									'loop', fl[9],
									'scale', fl[10],
									'wmode', fl[11],
									'devicefont', fl[12],
									'id', fl[13],
									'name', fl[14],
									'menu', fl[15],
									'allowFullScreen', fl[16],
									'allowScriptAccess',fl[17],
									'movie', fl[18],
									'salign', fl[19]
								);
								innerHTML += fl[20];
								break;
						}

					}
					if (AdsDisplayed == 1) {
						var about_box_video_showcase = document.getElementById('about_box_video_showcase');
						if (about_box_video_showcase) {
							about_box_video_showcase.style.top = '590px';
							document.getElementById('video_showcase_headline_ad').style.display = "none";
							document.getElementById('video_showcase_sml').style.display = "block";
						}
					}

					break;
				case "stage_chart":
					document.getElementById('display_stage_chart_content').innerHTML = ResultData[1];
					document.getElementById('stage_chart_loading').innerHTML = '<img src=\"http://www.creativehandbook.com/images/StageChart.gif\" alt=\"Stage Chart\" align=\"center\">';
					break;
				case "category_dropdown":
					document.getElementById('category_dropdown').innerHTML = ResultData[1];
					break;
			}
		}
	}
}