TEREMEP database importer

<?php
	require_once 'php.init.php';

	set_time_limit(0);
	
	function slashize($str) {
		return addslashes(stripslashes($str));
	}
	
	function debug($str) {
		echo "<script>debug('$str')</script>\n";
		flush();
	}
	
	function debugpr($table, $i, $n, $page = 0, $pages = 0) {
		if (@$GLOBALS['last_debugpr_time'] != time()) {
			$GLOBALS['last_debugpr_time'] = time();
			if ($n > 0) {
				$p = intval(1000 * $i / $n) / 10;
			} else {
				$p = 0;
			}
			if ($page < $pages) {
				$pagination = " - page $page of $pages";
			} else {
				$pagination = "";
			}
			debug("processing $table: $i of $n $pagination");
		}
	}
	
	echo ("<HTML>
		<script>
			function debug(str) {
				document.getElementById('div_debug').innerHTML = str;
			}
		</script>
		<h1>TEREMEP database importer</h1>
		<div id='div_debug' style='background:#ddd; border:1px solid #aaa; width:500px;'>initializing...</div>
		</HTML>");
	
	
	
	$src = 'teremep_db';
	$dest = 'lcei';

	/*
	executesql("DROP TABLE IF EXISTS `__admin_columns`", __LINE__, __FILE__);
	executesql("CREATE TABLE `__admin_columns` ( `ac_id` bigint(20) NOT NULL auto_increment, `ac_at_name` varchar(255) collate latin1_general_ci NOT NULL, `ac_name` varchar(255) collate latin1_general_ci NOT NULL, `ac_title` varchar(255) collate latin1_general_ci NOT NULL, `ac_order` bigint(20) NOT NULL default '0', `ac_create` varchar(100) collate latin1_general_ci NOT NULL default 'yes', `ac_read` varchar(100) collate latin1_general_ci NOT NULL default 'yes', `ac_update` varchar(100) collate latin1_general_ci NOT NULL default 'yes', `ac_class` enum('text','textarea','html','select','image','file') collate latin1_general_ci NOT NULL default 'text', `ac_belongs` varchar(255) collate latin1_general_ci NOT NULL, `ac_notset` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY  (`ac_id`), KEY `at_names` (`ac_at_name`,`ac_name`))", __LINE__, __FILE__);

	executesql("DROP TABLE IF EXISTS `__admin_tables`", __LINE__, __FILE__);
	executesql("CREATE TABLE `__admin_tables` ( `at_id` bigint(20) NOT NULL auto_increment, `at_name` varchar(255) collate latin1_general_ci NOT NULL, `at_title` varchar(255) collate latin1_general_ci NOT NULL, `at_type` enum('table','file','menugroup','hidden') collate latin1_general_ci NOT NULL default 'table', `at_parent_id` bigint(20) NOT NULL, `at_display` varchar(255) collate latin1_general_ci NOT NULL, `at_sortby` varchar(255) collate latin1_general_ci NOT NULL, `at_order` bigint(20) NOT NULL, `at_create` varchar(100) collate latin1_general_ci NOT NULL, `at_read` varchar(100) collate latin1_general_ci NOT NULL, `at_update` varchar(100) collate latin1_general_ci NOT NULL, `at_delete` varchar(100) collate latin1_general_ci NOT NULL, PRIMARY KEY  (`at_id`), KEY `at_order` (`at_order`), KEY `at_name` (`at_name`), KEY `at_parent` (`at_parent_id`))", __LINE__, __FILE__);

	executesql("DROP TABLE IF EXISTS `documents`", __LINE__, __FILE__);
	executesql("CREATE TABLE `documents` ( `doc_id` int(11) NOT NULL auto_increment, `doc_name` varchar(255) collate latin1_general_ci default NULL, `doc_data` longblob NOT NULL, PRIMARY KEY  (`doc_id`))", __LINE__, __FILE__);
	
	executesql("DROP TABLE IF EXISTS `image_cache`", __LINE__, __FILE__);
	executesql("CREATE TABLE `image_cache` ( `image_cache_id` int(11) NOT NULL auto_increment, `image_cache_image_id` int(11) NOT NULL default '0', `image_cache_w` int(11) NOT NULL default '0', `image_cache_h` int(11) NOT NULL default '0', `image_cache_realw` int(11) NOT NULL default '0', `image_cache_realh` int(11) NOT NULL default '0', `image_cache_data` longblob NOT NULL, `image_cache_resizetype` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY  (`image_cache_id`), KEY `id_w_h` (`image_cache_image_id`,`image_cache_w`,`image_cache_h`))", __LINE__, __FILE__);	
	
	executesql("DROP TABLE IF EXISTS `images`", __LINE__, __FILE__);
	executesql("CREATE TABLE `images` ( `image_id` int(11) NOT NULL auto_increment, `image_name` varchar(100) collate latin1_general_ci default NULL, `image_data` longblob NOT NULL, `image_source` enum('table','extern') collate latin1_general_ci NOT NULL default 'table', PRIMARY KEY  (`image_id`))", __LINE__, __FILE__);	
	
	executesql("DROP TABLE IF EXISTS `pag_anunturi`", __LINE__, __FILE__);
	executesql("CREATE TABLE `pag_anunturi` ( `id` int(11) NOT NULL auto_increment, `pag_id` int(11) NOT NULL, `anunt` text collate latin1_general_ci,
  `data` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `afiseaza` enum('da','nu') collate latin1_general_ci NOT NULL default 'da', `safe` enum('da','nu') collate latin1_general_ci NOT NULL default 'nu', PRIMARY KEY  (`id`))", __LINE__, __FILE__);
	
	executesql("DROP TABLE IF EXISTS `pag_persoane`", __LINE__, __FILE__);
	executesql("CREATE TABLE `pag_persoane` ( `id` int(11) NOT NULL auto_increment, `pag_id` int(11) NOT NULL, `grup` varchar(100) collate latin1_general_ci NOT NULL, `nume` varchar(255) collate latin1_general_ci NOT NULL, `cv` int(11) default NULL, `email` varchar(100) collate latin1_general_ci default NULL, `skype` varchar(100) collate latin1_general_ci default NULL, `mobil` varchar(100) collate latin1_general_ci default NULL, `poza` int(11) default NULL, `afiseaza` enum('da','nu') collate latin1_general_ci NOT NULL default 'da', `safe` enum('da','nu') collate latin1_general_ci NOT NULL default 'nu', PRIMARY KEY  (`id`))", __LINE__, __FILE__);
	
	executesql("DROP TABLE IF EXISTS `pag_text`", __LINE__, __FILE__);
	executesql("CREATE TABLE `pag_text` ( `id` int(11) NOT NULL auto_increment, `pag_id` int(11) NOT NULL, `text` text collate latin1_general_ci, `docs` varchar(100) collate latin1_general_ci default NULL, `afiseaza` enum('da','nu') collate latin1_general_ci NOT NULL default 'da', `safe` enum('da','nu') collate latin1_general_ci NOT NULL default 'nu', PRIMARY KEY  (`id`))", __LINE__, __FILE__);

	executesql("DROP TABLE IF EXISTS `pages`", __LINE__, __FILE__);
	executesql("CREATE TABLE `pages` ( `id` int(11) NOT NULL auto_increment, `titlu` varchar(255) collate latin1_general_ci NOT NULL, `tip` enum('text','tabel_persoane','anunturi') collate latin1_general_ci NOT NULL default 'text', `ordinea` int(11) default NULL, `safe` enum('da','nu') collate latin1_general_ci NOT NULL default 'nu', PRIMARY KEY  (`id`))", __LINE__, __FILE__);

	executesql("DROP TABLE IF EXISTS `parameters`", __LINE__, __FILE__);
	executesql("CREATE TABLE `parameters` ( `parameter_id` int(20) NOT NULL, `parameter_name` varchar(50) collate latin1_general_ci NOT NULL, `parameter_value` varchar(255) collate latin1_general_ci NOT NULL, `parameter_title` varchar(100) collate latin1_general_ci NOT NULL, `parameter_description` text collate latin1_general_ci NOT NULL, `parameter_function_use` varchar(255) collate latin1_general_ci NOT NULL, `parameter_function_set` varchar(255) collate latin1_general_ci NOT NULL, `parameter_dateadded` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY  (`parameter_id`), UNIQUE KEY `parameter_name` (`parameter_name`)) ", __LINE__, __FILE__);

	executesql("DROP TABLE IF EXISTS `sessions`", __LINE__, __FILE__);
	executesql("CREATE TABLE `sessions` ( `session_hash` varchar(40) collate latin1_general_ci NOT NULL, `session_timestamp` timestamp NOT NULL default '0000-00-00 00:00:00', `session_array` longtext collate latin1_general_ci NOT NULL, PRIMARY KEY  (`session_hash`), KEY `session_timestamp` (`session_timestamp`)) ", __LINE__, __FILE__);
	
	debug('done with done with db structure');

	//data
	
	executesql("TRUNCATE TABLE $dest.__admin_columns", __LINE__, __FILE__);
	debug('getting admin_columns');
	
	$sql = "SELECT * FROM $src.__admin_columns  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.__admin_columns SET
					ac_id			= '" . $v['ac_id'] . "',
					ac_at_name		= '" . $v['ac_at_name'] . "',
					ac_name			= '" . $v['ac_name'] . "',
					ac_title		= '" . $v['ac_title'] . "',
					ac_order		= '" . $v['ac_order'] . "',
					ac_create		= '" . $v['ac_create'] . "',
					ac_read			= '" . $v['ac_read'] . "',
					ac_update		= '" . $v['ac_update'] . "',
					ac_class		= '" . $v['ac_class'] . "',
					ac_belongs		= '" . $v['ac_belongs'] . "',
					ac_notset		= '" . $v['ac_notset'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('admin_columns', $k, $numrows);
	}
	debug('done with admin_columns');

	
	executesql("TRUNCATE TABLE $dest.__admin_tables", __LINE__, __FILE__);
	debug('getting admin_tables');
	
	$sql = "SELECT * FROM $src.__admin_tables  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.__admin_tables SET
					at_id			= '" . $v['at_id'] . "',
					at_name			= '" . $v['at_name'] . "',
					at_title		= '" . $v['at_title'] . "',
					at_type			= '" . $v['at_type'] . "',
					at_parent_id		= '" . $v['at_parent_id'] . "',
					at_display		= '" . $v['at_display'] . "',
					at_sortby		= '" . $v['at_sortby'] . "',
					at_order		= '" . $v['at_order'] . "',
					at_create		= '" . $v['at_create'] . "',
					at_read			= '" . $v['at_read'] . "',
					at_update		= '" . $v['at_update'] . "',
					at_delete		= '" . $v['at_delete'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('admin_tables', $k, $numrows);
	}
	debug('done with admin_tables');

	
	executesql("TRUNCATE TABLE $dest.documents", __LINE__, __FILE__);
	debug('getting documents');
	
	$sql = "SELECT * FROM $src.documents  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.documents SET
					doc_id			= '" . $v['doc_id'] . "',
					doc_name		= '" . $v['doc_name'] . "',
					doc_data		= '" . $v['doc_data'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('documents', $k, $numrows);
	}
	debug('done with documents');
	

	executesql("TRUNCATE TABLE $dest.pag_text", __LINE__, __FILE__);
	debug('getting pag_text');
	
	$sql = "SELECT * FROM $src.pag_text  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.pag_text SET
					id			= '" . $v['id'] . "',
					pag_id			= '" . $v['pag_id'] . "',
					text			= '" . slashize($v['text']) . "',
					docs			= '" . $v['docs'] . "',
					afiseaza		= '" . $v['afiseaza'] . "',
					safe			= '" . $v['safe'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('pag_text', $k, $numrows);
	}
	debug('done with pag_text');
	

	executesql("TRUNCATE TABLE $dest.pages", __LINE__, __FILE__);
	debug('getting pages');
	
	$sql = "SELECT * FROM $src.pages  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.pages SET
					id			= '" . $v['id'] . "',
					titlu			= '" . $v['titlu'] . "',
					tip			= '" . $v['tip'] . "',
					ordinea			= '" . $v['ordinea'] . "',
					safe			= '" . $v['safe'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('pages', $k, $numrows);
	}
	debug('done with pages');

	
	executesql("TRUNCATE TABLE $dest.parameters", __LINE__, __FILE__);
	debug('getting parameters');
	
	$sql = "SELECT * FROM $src.parameters  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.parameters SET
					parameter_id		= '" . $v['parameter_id'] . "',
					parameter_name		= '" . $v['parameter_name'] . "',
					parameter_value		= '" . $v['parameter_value'] . "',
					parameter_title		= '" . $v['parameter_title'] . "',
					parameter_description	= '" . slashize($v['parameter_description']) . "',
					parameter_function_use	= '" . slashize($v['parameter_function_use']) . "',
					parameter_function_set	= '" . slashize($v['parameter_function_set']) . "',
					parameter_dateadded	= '" . $v['parameter_dateadded'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('parameters', $k, $numrows);
	}
	debug('done with parameters');
	

	executesql("TRUNCATE TABLE $dest.images", __LINE__, __FILE__);
	debug('getting images');
	
	$sql = "SELECT * FROM $src.images  ";
	$rows = get_select2($sql);
	$numrows = sizeof($rows);
	foreach ($rows as $k => $v) {
		
		$sql = "INSERT INTO $dest.images SET
					image_id			= '" . $v['image_id'] . "',
					image_name			= '" . $v['image_name'] . "',
					image_data			= '" . slashize($v['image_data']) . "',
					image_source		= '" . $v['image_source'] . "'
				";
		executesql($sql, __LINE__, __FILE__);
		debugpr('images', $k, $numrows);
	}
	debug('done with images');
	
	executesql("TRUNCATE TABLE $dest.image_cache", __LINE__, __FILE__);
	
	debug('<b>DONE !!!</b>');
	*/
	debug('disabled for now');
	
?>