var xmlhttp;
var CurrentAds = '';
var advars = '';
var querycounter = Get_Cookie('querycounter');
if (querycounter < 1) querycounter = 1;

function database_query(query, vars) {
	advars = 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) {
		querycounter++;
		Set_Cookie('querycounter', querycounter, 0, '/', '', '');
		xmlquery = "../php/database_query.php?query=" + query + vars + "&" + querycounter;
		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 "full_blog":
					var nl =  ResultData[1].split("<nl>");
					document.getElementById(nl[0]).innerHTML = nl[1];
					break;
				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];
					var isiPad = navigator.userAgent.match(/iPad/i) != null;
					if (!isiPad) {
						jwplayer('div_video_showcase_main').getPlugin('weblink').link(ResultData[4]);
					}
					break;
				case "update_video_sml_counter":
					break;
				case "go_green":
					document.getElementById('GoGreen').innerHTML = ResultData[1];
					break;
				case "qr_code":
					document.getElementById('QRCode').innerHTML = ResultData[1];
					break;
				case "keyword_search": case "equipment_search": case "ads_search":
					var AdsDisplayed = 0;
					var NewAds = '';

					var nl = ResultData[1].split("<nl>");
					var innerHTML = "";
					for (var n = 0; n < nl.length; n++) {
						var ni =  nl[n].split("<ni>");
						switch(ni[0]) {
							case "video_showcase_sml_xml_file":
								advars += "&video_showcase_sml_xml_file=" + ni[1];
								if (ni[2] != null) advars += "&middle_ad_string=" + ni[2];
								database_query('ads_search', advars);
								break;
							case "cat_id":
								CatId = ni[1];
								break;
							case "innerHTML":
								document.getElementById(ni[1] + ipad_ext).innerHTML = innerHTML;
								document.getElementById(ni[1] + ipad_ext).style.display = "block";
								innerHTML = "";
								break;
							case "web_content":
								innerHTML += ni[1];
								break;
							case "video":
								NewAds += "[" + ni[0] + ni[1] + "]";
								if (CurrentAds.indexOf("[" + ni[0] + ni[1] + "]") == -1) {
									var isiPad = navigator.userAgent.match(/iPad/i) != null;
									if (isiPad) {
										playlist_max = 0;
										var videos = ni[1].split("<video>");
										for (var v = 0; v < videos.length; v++) {
											var video =  videos[v].split("|");
											//document.getElementById("xxx").innerHTML += video[0] + "<br />";
											playlist_max++;
											
											title[playlist_max] = video[0] + "|" + video[1];
											media[playlist_max] = video[2];
											poster[playlist_max] = video[2].substring(0,video[2].length - 8) + ".jpg";
											link[playlist_max] = video[3];
										}
										PlayNextVideo();
									} else {
										jwplayer('video_small').load({file:"http://creativehandbook.com/xml/" + ni[1]});
									}
								}
								break;
							case "middle_ad": case "headline_ad": case "right_ad": case "medium_ad":
								var isiPad = navigator.userAgent.match(/iPad/i) != null;
								if (isiPad) {
									//document.getElementById("xxx").innerHTML += ni[1] + "<br />";
								}
								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";
						}
					}
					CurrentAds = NewAds;
					break;
				case "stage_chart":
					document.getElementById('web_content' + ipad_ext).innerHTML = ResultData[1];
					document.getElementById('stage_chart_loading').innerHTML = '&nbsp;';
					if(Prototype.Browser.IE == false) {
						new webkit_draggable('stage_chart_ipad_table');
					}
					break;
				case "category_dropdown":
					document.getElementById('category_dropdown').innerHTML = ResultData[1];
					break;
				default:
			}
		}
	}
}