Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function synctable($table, $array){
- global $config;
- $result['insert'] = $result['update'] = $result['delete'] = 0;
- $rows = array('vendors' => array('vendorid', 'name', 'vendororder', 'empty'),
- 'files' => array('fileid', 'vendorid', 'name', 'filename', 'dateof', 'restriction', 'fileorder', 'md5'),
- 'models' => array('modelid', 'fileid', 'name', 'modelorder', 'contenttype', 'contenttitle', 'contenttext'));
- $q = mysql_query("SELECT * FROM `".escape($config['db_pref']).escape($table)."` ORDER BY ".escape($rows[$table][0])) or od(5);
- while($row = mysql_fetch_array($q, MYSQL_ASSOC))
- if(!is_array($array[$row[$rows[$table][0]]])){
- $result['delete']++;
- mysql_query("DELETE FROM `".escape($config['db_pref']).escape($table)."` WHERE ".escape($rows[$table][0])." = '".escape($row[$rows[$table][0]])."' LIMIT 1") or od(6);
- }else
- $db[$row[$rows[$table][0]]] = $row;
- foreach($array as $unit)
- if(is_array($db[$unit[$rows[$table][0]]])){
- $result['update']++;
- $qw = "UPDATE `".escape($config['db_pref']).escape($table)."` SET ";
- $count = count($rows[$table]);
- if($table = 'models')
- $count -= 2;
- for($i = 1;$i < $count;$i++){
- $qw .= escape($rows[$table][$i])." = '".escape($unit[$rows[$table][$i]])."'";
- if($i != count($rows[$table]) - 1)
- $qw .= ", ";
- }
- $qw .= " WHERE ".escape($rows[$table][0])." = '".escape($unit[$rows[$table][0]])."' LIMIT 1";
- mysql_query($qw) or od(7);
- }else{
- $qw = "INSERT INTO `".escape($config['db_pref']).escape($table)."` (";
- for($i = 0;$i < count($rows[$table]);$i++){
- $qw .= escape($rows[$table][$i]);
- if($i != count($rows[$table]) - 1)
- $qw .= ", ";
- }
- $qw .= ") VALUES (";
- for($i = 0;$i < count($rows[$table]);$i++){
- $qw .= "'".escape($unit[$rows[$table][$i]])."'";
- if($i != count($rows[$table]) - 1)
- $qw .= ", ";
- }
- $qw .= ")";
- mysql_query($qw) or od(8);
- $result['insert']++;
- }
- return '<p><em>Таблица "'.$table.'". Добавлено записей: '.$result['insert'].', обновлено записей: '.$result['update'].', удалено записей: '.$result['delete'].'</em></p>';
- }
Add Comment
Please, Sign In to add comment