import.categories.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

<?

	require_once 'header.php';
	require_once 'class.portage.tree.php';
	
	$tree = new PortageTree();
	$table = 'category';
	
	$arr = $tree->getCategories();
	
	$arr_diff = importDiff($table, $arr);
	
	if(count($arr_diff['delete'])) {
		foreach($arr_diff['delete'] as $name) {
			$sql = "DELETE FROM $table WHERE name = ".$db->quote($name).";";
			shell::msg($sql);
			$db->query($sql);
		}
	}
	
	if(count($arr_diff['insert'])) {
		foreach($arr_diff['insert'] as $name) {
			$arr_insert = array('name' => $name);
			$db->autoExecute($table, $arr_insert, MDB2_AUTOQUERY_INSERT);
		}
	}

?>