summaryrefslogtreecommitdiff
blob: 1a6a8f762f7afac9b874f508041cba5fbd877b5e (plain)
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
29
30
31
<?

	ini_set('include_path', ini_get('include_path').":/home/steve/php/inc:/home/steve/svn/znurt");
	
	require_once "mdb2/charlie.portage.php";
	require_once 'class.common.php';
	require_once 'class.shell.php';
	
	$c = new Common();
	
	$now = $db->getOne("SELECT NOW();");
	
	function importDiff($table, $arr_new, $where = "") {
 		
 		global $db;
 		
 		if($where)
 			$where = "WHERE $where";
 		
 		$sql = "SELECT name FROM $table $where ORDER BY name;";
 		$arr_old = $db->getCol($sql);
 		
 		$arr_insert = array_diff($arr_new, $arr_old);
 		$arr_delete = array_diff($arr_old, $arr_new);
 		
 		$arr = array('insert' => $arr_insert, 'delete' => $arr_delete);
 		
 		return($arr);
 	}

?>