/modules/modules/instal/update.php

<? 

include "../../../inc/connect_db.php";
$query = mysql_query("select value from {$pref}db_vars where `key`='version'");
$cms_ver=mysql_result($query,0,"value");
include "../../../inc/function.cms.php";
include "../../../inc/token.php";
if (getUserType()<>2) die();

include "var.php";


$num=0;

if ($_SESSION['update_modul']!=1)
foreach ($tables_instal as $tbl => $colum) {
	include "../../sql/instalcopy.php";
}
$_SESSION['update_modul']=1;

if ($_SESSION['update_modul']!=2)
foreach ($tables_instal as $tbl => $colum) {
	if (in_array($tbl, $tables_uninstal)){
		if (empty($_SESSION['order_id'.$tbl])) $_SESSION['order_id'.$tbl]=0;
		$count = mysql_result(mysql_query("select count(*) from {$pref}db_{$modul}{$tbl} where id>'".$_SESSION['order_id'.$tbl]."' order by id"),0, 'count(*)');
		if ($count>0){
			include "../../sql/backaptocopy.php";
		}
		$num += mysql_result(mysql_query("select count(*) from {$pref}db_{$modul}{$tbl} where id>'".$_SESSION['order_id'.$tbl]."' order by id"),0, 'count(*)');
	}
}

if ($num!=0) echo '{"num":"'.$num.'"}';
else{

	$_SESSION['update_modul']=2;

	unset($_SESSION['update_modul']);
	foreach ($tables_uninstal as $key => $tbl) {
		include "../../sql/uninstal.php";
	}
	foreach ($tables_instal as $tbl => $colum) {
		include "../../sql/uninstalcopy.php";
		unset($_SESSION['order_id'.$tbl]);
	}

	$mod_ver='';
	foreach ($tables_instal as $tbl => $colum) {
	  $query = mysql_query("show columns from {$pref}db_{$modul}{$tbl}");
	  while ($res= mysql_fetch_array($query))
	  $mod_ver.=$res[0].'-'.$res[1];
	}
	$mod_ver=md5($mod_ver);

	if (($mod_ver!= $ver)||($cms_ver!='1.3')||mysql_num_rows(mysql_query("select * from {$pref}db_modules"))!=17) {
		mysql_query("TRUNCATE {$pref}db_modules");
		mysql_query("INSERT INTO `{$pref}db_modules` (`id`, `name`, `title`, `table`, `instal`, `status`) VALUES
	(2001, 'banners', 'Банеры', 'db_banners', 1, 1),
	(2002, 'forum', 'Форум', 'db_forum', 1, 1),
	(2003, 'gallery', 'Галерея', 'db_gallery', 1, 1),
	(2004, 'news', 'Новости', 'db_news', 1, 1),
	(1001, 'structure', 'Структура', 'db_structure', 1, 1),
	(1002, 'users', 'Полльзователи', 'db_users', 1, 1),
	(1003, 'components', 'Компоненты', 'db_components', 1, 1),
	(9001, 'modules', 'Модули', 'db_components', 1, 1),
	(8001, 'logs', 'Логи', 'db_logs', 1, 1),
	(8002, 'pic', 'Изображения', 'db_pic', 1, 1),
	(8003, 'rate', 'Рейтинг', 'db_rate', 1, 1),
	(8004, 'session', 'Сессии', 'db_session', 1, 1),
	(8005, 'statistics', 'Статистика', 'db_statistics', 1, 1),
	(8006, 'comment', 'Комментарии', 'db_comment', 1, 1),
	(2005, 'catalog', 'Каталог', 'db_catalog', 1, 1),
	(2006, 'materials', 'Материалы', 'db_materials', 1, 1),
	(2007, 'menu', 'Меню', 'db_menu', 1, 1);
	");
		mysql_query("UPDATE  `{$pref}db_vars` SET  `value` =  '1.3' WHERE  `{$pref}db_vars`.`id` =2;");
	}


	echo '{"num":"0"}'; 
}