<!--
function pagination( page ) {
			if (page == "next") {
				offset = offset + limit;
			} else if (page == "prev" ) {
				offset = offset - limit;
			} else {
				offset = 0;
			}
			if ( dir == "asc" ) {
				thisdir = "asc";
			} else {
				thisdir = "desc";
			}
			dojo.io.bind({
    			url: "/main/build_table/" + tablename,
    			method: 'post',
				load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
				formNode: dojo.byId("searchform"),
				content: {
					task: 'gettable',
					t: t,
					tablename: tablename,
					offset: offset,
					ordering: field,
					dir: thisdir
    			}
			});
			//alert("Dir = " + dir + " Field = " + field + " Offset = " + offset);
		}
		function addItem( id , tablename , view  ) {
			if (view == "tableview" ) {
				var showhide = dojo.byId("showhide_table_" + id).value;
			} else {
				var showhide = dojo.byId("showhide_detail_" + id).value;
			}
			dojo.io.bind({
    			url: "/main/add_item/" + tablename,
    			method: 'post',
				load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
				content: {
					task: 'additem',
					id: id,
					t: t,
					tablename: tablename,
					showhide: showhide,
					view: view
				}
				//formNode: document.getElementById("form" + id )
			});
			if  ( showhide == 0 ) {
				if ( view == "tableview" ) { 
					dojo.byId("showhide_table_" + id).value = 1;
				} else {
					dojo.byId("showhide_detail_" + id).value = 1;
				}
				dojo.byId(view + '_' + id).src = url + '/administrator/images/publish_x.png';	
			} else {
				if ( view == "tableview" ) { 
					dojo.byId("showhide_table_" + id).value = 0;
				} else {
					dojo.byId("showhide_detail_" + id).value = 0;
				}
				dojo.byId(view + '_' + id).src = url + '/administrator/images/tick.png';	
			}
		}
		function sortTable( whichfield ) {
			field = whichfield;
			dojo.io.bind({
    			url: "/main/build_table/" + tablename,
    			method: 'post',
				load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
				formNode: dojo.byId("searchform"),
				content: {
					task: 'gettable',
					tablename: tablename,
					t: t,
					offset: offset,
					ordering: field,
					dir: dir
    			}
			});
			if ( dir == "asc" ) {
				dir = "desc";
			} else {
				dir = "asc";
			}
			//alert("Dir = " + dir + " Field = " + field + " Offset = " + offset);
		}
		function searchDB() {
			dojo.io.bind({
    			url: "/main/build_table/" + tablename,
    			method: 'post',
				load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
      			//error: returnError,
      			formNode: dojo.byId("searchform"),
				content: {
					task: 'search',
					t: t,
					tablename: tablename
				}
			});
		}
		function makeDraggable( element ) {
			//new dojo.dnd.HtmlDragMoveSource( element );
			new dojo.dnd.HtmlDragSource(dojo.byId( element ));
		}
		function toggleShow( element , header ) {
			var content = dojo.byId( element ); 
			if ( content.style.display == 'none' ) {
				dojo.lfx.html.wipeIn(content,400).play();
				dojo.byId(element).style.zIndex = '999999';
				dojo.byId(header).style.backgroundImage = 'url(images/minus.gif)';
			} else {
				dojo.lfx.html.wipeOut(content,400).play();
				dojo.byId(element).style.zIndex = '99999';
				dojo.byId(header).style.backgroundImage = 'url(images/plus.gif)';
			}
		}
		function addSearchOptions( id , tablename , fieldname , alias , admin ) {
			if (!dojo.byId("sbr_" + fieldname)) {
				var searchview = 1;
				var searchboxwrapper = document.createElement('div');
				searchboxwrapper.className = 'searchboxwrapper';
				searchboxwrapper.id = 'sbr_' + fieldname;
				searchboxwrapper.className= "searchbox";
				var searchbox = document.createElement('div');
				searchbox.id = fieldname;
				var search_text = document.createTextNode(alias);
				dojo.byId('searchnode').appendChild(searchboxwrapper);
				searchboxwrapper.appendChild( search_text );
				searchboxwrapper.appendChild( searchbox );
				var dataUrl = 'newfunctions.php?task=dataforselect&tablename=' + tablename + '&fieldname=' + fieldname
				searchboxwidget = dojo.widget.createWidget("ComboBox",{ id: "search_" + fieldname, name:"search_" + fieldname + "", dataUrl: dataUrl, maxListLength: 15 }, dojo.byId(fieldname));
				if ( admin ) {
					dojo.byId('s_' + id).src = url + '/administrator/images/disabled.png';
				}
				dojo.io.bind({
					url: "/main/add_search/"+t+'/'+tablename,
					method: 'post',
					load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
					content: {
						task: 'addsearch',
						id: id,
						t: t,
						tablename: tablename,
						searchview: searchview
					}
					//formNode: document.getElementById("form" + id )
				});			
			} else {
				var searchview = 0;
				var wrapper = dojo.byId('sbr_' + fieldname);
				dojo.widget.manager.removeById( "search_" + fieldname );
				wrapper.parentNode.removeChild(wrapper);
				dojo.byId('s_' + id).src = url + '/administrator/images/publish_g.png';
				dojo.io.bind({
					url: "newfunctions.php",
					method: 'post',
					load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
					content: {
						task: "/main/add_search/"+t+'/'+tablename,
						id: id,
						t: t,
						tablename: tablename,
						searchview: searchview
					}
					//formNode: document.getElementById("form" + id )
				});	
			}
		}
		function addSearchRange( id , tablename , fieldname , alias , admin ) {
			if (!dojo.byId("sbr_range_" + fieldname)) {
				var searchrange = 1;
				var searchboxwrapper = document.createElement('div');
				searchboxwrapper.className = 'searchboxwrapper';
				searchboxwrapper.id = 'sbr_range_' + fieldname;
				var searchfrombox = document.createElement('div');
				searchfrombox.id = fieldname + "_from";
				searchfrombox.style.width = "160px";
				var searchtobox = document.createElement('div');
				searchtobox.id = fieldname + "_to";			
				searchtobox.style.width = "160px";
				
				var search_text = document.createTextNode(alias);
				dojo.byId('searchnode').appendChild(searchboxwrapper);
				searchboxwrapper.appendChild( search_text );
				searchboxwrapper.className= "searchbox";
				//searchboxwrapper.appendChild( searchfrombox );
				//searchboxwrapper.appendChild( searchtobox );
				// CREATE A TABLE
				table = document.createElement('table');
				table.setAttribute("cellpadding",0);
				table.setAttribute("cellspacing",0);
				table.style.border = "0px solid #ff0000";
				tbody = document.createElement('tbody')
				row1 = document.createElement('tr');
				row2 = document.createElement('tr')
				fromlabel = document.createElement('td');
				tolabel = document.createElement('td');
				fromcontent = document.createElement('td');
				tocontent = document.createElement('td');
				searchboxwrapper.appendChild(table);
				table.appendChild(tbody);
				tbody.appendChild(row1);
				row1.appendChild(fromlabel);
				fromlabel.appendChild(document.createTextNode('From:'));
				row1.appendChild(fromcontent);
				tbody.appendChild(row2);
				row2.appendChild(tolabel);
				tolabel.appendChild(document.createTextNode('To:'));
				row2.appendChild(tocontent);
				//\td.appendChild(td);
				fromcontent.appendChild( searchfrombox );
				tocontent.appendChild( searchtobox );
				
				
				var dataUrl = '/main/get_data_for_select/' +tablename + '/fieldname:' + fieldname;
				searchboxfromwidget = dojo.widget.createWidget("ComboBox",{ id: "range_from_" + fieldname, name:"range_from_" + fieldname, dataUrl: dataUrl, maxListLength: 15 }, dojo.byId(fieldname + "_from"));
				searchboxtowidget = dojo.widget.createWidget("ComboBox",{ id: "range_to_" + fieldname, name:"range_to_" + fieldname, dataUrl: dataUrl, maxListLength: 15 }, dojo.byId(fieldname + "_to"));

				if ( admin ) {
					dojo.byId('r_' + id).src = url + '/administrator/images/disabled.png';
				}
				dojo.io.bind({
					url: "newfunctions.php",
					method: 'post',
					load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
					content: {
						task: 'addsearchrange',
						id: id,
						t: t,
						tablename: tablename,
						searchrange: searchrange
					}
					//formNode: document.getElementById("form" + id )
				});			
			} else {
				var searchrange = 0;
				var wrapper = dojo.byId('sbr_range_' + fieldname);
				dojo.widget.manager.removeById( "range_from_" + fieldname );
				dojo.widget.manager.removeById( "range_to_" + fieldname );
				wrapper.parentNode.removeChild(wrapper);
				dojo.byId('r_' + id).src = url + '/administrator/images/publish_g.png';
				dojo.io.bind({
					url: "newfunctions.php",
					method: 'post',
					load: function(type, data, evt){ dojo.byId('tableContainer').innerHTML = data },
					content: {
						task: 'addsearchrange',
						id: id,
						t: t,
						tablename: tablename,
						searchrange: searchrange
					}
					//formNode: document.getElementById("form" + id )
				});	
			}
		}
		function getScrollXY() {
		  var scrOfX = 0, scrOfY = 0;
		  if( typeof( window.pageYOffset ) == 'number' ) {
			//Netscape compliant
			scrOfY = window.pageYOffset;
			scrOfX = window.pageXOffset;
		  } else if( document.body && ( document.body.scrollLeft || document.body.scrollTop ) ) {
			//DOM compliant
			scrOfY = document.body.scrollTop;
			scrOfX = document.body.scrollLeft;
		  } else if( document.documentElement && ( document.documentElement.scrollLeft || document.documentElement.scrollTop ) ) {
			//IE6 standards compliant mode
			scrOfY = document.documentElement.scrollTop;
			scrOfX = document.documentElement.scrollLeft;
		  }
		  return scrOfY;
		}
		function createDetailsPage( id , tablename , title ) {
			dialog = dojo.widget.createWidget("FloatingPane",{ 
				id: "dialog_" + id,
				title: title,
				//iconSrc: "images/flatScreen.gif",
				constrainToContainer: true,
				hasShadow: true,
				resizable: true ,
				windowState:"normal",
				displayCloseAction: true,
				//displayMaximizeAction: true,
				toggle: "explode",
				style: "z-index:99999999;width: 500px; position: absolute;"
		  	}, dojo.byId('moreinfocontainer'));
			dialog.domNode.style.height="450px";
			dialog.domNode.style.width="400px";
			dialog.domNode.style.left = document.body.offsetWidth/2-200;
			dialog.domNode.style.top = getScrollXY();// + (document.body.offsetHeight/2-225);
			var layoutWin = dojo.widget.createWidget("LayoutContainer");
			layoutWin.domNode.style.width = "100%";
			layoutWin.domNode.style.height = "100%";
			dojo.io.bind({
				url: "/main/get_detail/"+t+'/'+tablename,
				method: 'post',
				load: function(type, data, evt){ layoutWin.domNode.innerHTML =  data },
				content: {
					task: 'getdetail',
					id: id,
					t: t,
					tablename: tablename
				}
			});
			dialog.addChild(layoutWin);
			//dialog.className = 'dialog';
			document.body.appendChild(dialog.domNode);
			dialog.show();
		}
		function uploadFile( evt ) {
			dojo.io.bind({   
				url: "newfunctions.php",
				method: 'post',
				load: function(type, data, evt){ 
					//window.location = 'dbtable.php?t=' + data; 
				},
				error: returnError,
				formNode: dojo.byId("uploadform"),
				content: {
					task: "uploadfile",
					t: t
				}
			});
			//dojo.byId('file').value = '';
		}
		function createDB( evt ) {
			dojo.io.bind({   
				url: "newfunctions.php",
				method: 'post',
				load: function(type, data, evt){ 
					//window.location = 'dbtable.php?t=' + data; 
				},
				error: returnError,
				formNode: dojo.byId("newdbform"),
				content: {
					task: "uploadfile"
				}
			});
			//dojo.byId('file').value = '';
		}
		function deleteDB( evt ) {
			if (confirm('Are you sure you want to delete this database?')) {
				dojo.io.bind({   
					url: "newfunctions.php",
					method: 'post',
					load: function(type, data, evt){ window.location = 'dbtable.php'; },
					error: returnError,
					content: {
						task: "deletedb",
						tablename: tablename
					}
				});
				return true;
			} else {
				return false;
			}
			//dojo.byId('file').value = '';
		}
		function returnError(type, error) {
 			// called when the login script returns...
    		alert("There was an error uploading this database, please check the format and try again.");    
  		 }
		 function chooseColor( element ) {
		 	dojo.byId(element).value = dojo.widget.manager.getWidgetById(element + '_widget').color;
		 }

        function colorPicker(obj,name,type){
            //alert(name);
			var domPosArray = dojo.style.getAbsolutePosition(obj);
            var cp =  dojo.widget.getWidgetsByType("colorPalette")[0];
            if (!cp){
                var props = {palette:"7x10light"};
                cp = dojo.widget.createWidget("ColorPalette", props)
                cp.domNode.style.position = "absolute";
				cp.domNode.style.width = "150px";
				cp.domNode.style.position = "absolute";
            }
            cp.showAt(domPosArray['x'] + 5,domPosArray['y'] + 5);
            cp.onColorSelect = function(color) {
				if (type == 'bg') {
					obj.style.backgroundColor = color;
					dojo.byId(name).value = color;
					dojo.byId(name + 'fontlabel').style.backgroundColor = color;
				} else {
					dojo.byId(name + 'label').style.color = color;
					obj.style.color = color;
					dojo.byId(name + 'font').value = color;
				}
                
				//alert(color);
                this.hide();
           }
       }
	   function clearSearch() {
			window.location.reload();
			//var searchboxes = dojo.widget.getWidgetsByType("ComboBox")
			//for(x=0;x < searchboxes.length;x++) {
				//dojo.widget.manager.getWidgetById(searchboxes[x].id).clearResultList;
			//}
	   }
-->