unset($r1['users_count']); } $mess_id = $table[0] == 'ignor' ? "user_id = {$r1['user_id']} AND target_id = {$r1['target_id']}" : "id = {$r1['id']}"; if (empty($r2)) { $master->insert($table[0], $r1); mess("MASTER: Insert into {$table[0]} with {$mess_id}. PgQ bug."); } else { if ($diff = eq_rows($r1, $r2, $eq_filter)) { $master->update($table[0], $diff, $table[1], $r1[$table[2]], empty($table[3]) ? "" : $r1[$table[3]]); mess("MASTER: Update {$table[0]} with {$mess_id}. PgQ bug."); } } } } } mess("Complete."); function eq_rows($row1, $row2, $skip) { $keys = array_keys($row1); $res = array(); foreach ($keys as $key) { if (!in_array($key, $skip) && $row1[$key] != $row2[$key]) { $res[$key] = $row1[$key]; } } return $res; } function mess($message) { $m = $message . "\n"; echo $m;
if (isset($r2['users_cont'])) { $r1['users_cont'] = $r1['users_count']; unset($r1['users_count']); } $mess_id = $table[0] == 'ignor' ? "user_id = {$r1['user_id']} AND target_id = {$r1['target_id']}" : "id = {$r1['id']}"; if (empty($r2)) { $master->insert($table[0], $r1); mess("MASTER: Insert into {$table[0]} with {$mess_id}. PgQ bug."); } elseif ($diff = eq_rows($r1, $r2, $eq_filter)) { $master->update($table[0], $diff, $table[1], $r1[$table[2]], empty($table[3]) ? '' : $r1[$table[3]]); mess("MASTER: Update {$table[0]} with {$mess_id}. PgQ bug."); } } } } mess('Complete.'); function eq_rows($row1, $row2, $skip) { $keys = array_keys($row1); $res = array(); foreach ($keys as $key) { if (!in_array($key, $skip) && $row1[$key] != $row2[$key]) { $res[$key] = $row1[$key]; } } return $res; } function mess($message) { $m = $message . "\n"; echo $m;