| commit | author | age | ||
| b5a2f8 | 1 | <?php |
| T | 2 | /* |
| 3 | Copyright (c) 2005, Till Brehm, projektfarm Gmbh | |
| 4 | All rights reserved. | |
| 5 | ||
| 6 | Redistribution and use in source and binary forms, with or without modification, | |
| 7 | are permitted provided that the following conditions are met: | |
| 8 | ||
| 9 | * Redistributions of source code must retain the above copyright notice, | |
| 10 | this list of conditions and the following disclaimer. | |
| 11 | * Redistributions in binary form must reproduce the above copyright notice, | |
| 12 | this list of conditions and the following disclaimer in the documentation | |
| 13 | and/or other materials provided with the distribution. | |
| 14 | * Neither the name of ISPConfig nor the names of its contributors | |
| 15 | may be used to endorse or promote products derived from this software without | |
| 16 | specific prior written permission. | |
| 17 | ||
| 18 | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND | |
| 19 | ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | |
| 20 | WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. | |
| 21 | IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, | |
| 22 | INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, | |
| 23 | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, | |
| 24 | DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY | |
| 25 | OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING | |
| 26 | NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, | |
| 27 | EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | |
| 28 | */ | |
| 29 | require_once('../../lib/config.inc.php'); | |
| 30 | require_once('../../lib/app.inc.php'); | |
| 31 | ||
| 32 | $dbsync_list = $app->db->queryAllRecords("SELECT * FROM sys_dbsync WHERE active = 1"); | |
| 33 | ||
| 34 | if(is_array($dbsync_list)) { | |
| 35 | foreach($dbsync_list as $dbsync) { | |
| 36 | // erstelle database connection | |
| 37 | ||
| 38 | $db = new db(); | |
| 39 | $db->dbHost = $dbsync["db_host"]; | |
| 40 | $db->dbName = $dbsync["db_name"]; | |
| 41 | $db->dbUser = $dbsync["db_username"]; | |
| 42 | $db->dbPass = $dbsync["db_password"]; | |
| 43 | ||
| 44 | // hole neue Einträge aus dblog | |
| 45 | $datalog_records = $app->db->queryAllRecords("SELECT * FROM sys_datalog WHERE dbtable in ('".str_replace(",","','",$dbsync["db_tables"])."') AND datalog_id > $dbsync[last_datalog_id]"); | |
| 46 | foreach($datalog_records as $d) { | |
| 47 | ||
| 48 | if($d["action"] == 'n') { | |
| 49 | $data = unserialize(stripslashes($d["data"])); | |
| 50 | $idx = explode(":",$d["dbidx"]); | |
| 51 | $tmp_sql1 = ''; | |
| 52 | $tmp_sql2 = ''; | |
| 53 | foreach($data as $fieldname => $val) { | |
| 54 | $tmp_sql1 .= "$fieldname,"; | |
| 55 | $tmp_sql2 .= "'$val[new]',"; | |
| 56 | } | |
| 57 | $tmp_sql1 .= "$idx[0]"; | |
| 58 | $tmp_sql2 .= "$idx[1]"; | |
| 59 | $sql = "INSERT INTO $d[dbtable] ($tmp_sql1) VALUES ($tmp_sql2)"; | |
| 60 | $db->query($sql); | |
| 61 | } | |
| 62 | ||
| 63 | if($d["action"] == 'u') { | |
| 64 | $sql = "UPDATE $d[dbtable] SET "; | |
| 65 | $data = unserialize(stripslashes($d["data"])); | |
| 66 | foreach($data as $fieldname => $val) { | |
| 67 | $sql .= "$fieldname = '$val[new]',"; | |
| 68 | } | |
| 69 | $sql = substr($sql,0,-1); | |
| 70 | $idx = explode(":",$d["dbidx"]); | |
| 71 | $sql .= " WHERE $idx[0] = $idx[1]"; | |
| 72 | $db->query($sql); | |
| 73 | } | |
| 74 | ||
| 75 | if($d["action"] == 'd') { | |
| 76 | $idx = explode(":",$d["dbidx"]); | |
| 77 | $sql = "DELETE FROM $d[dbtable] SET "; | |
| 78 | $sql .= " WHERE $idx[0] = $idx[1]"; | |
| 79 | $db->query($sql); | |
| 80 | } | |
| 81 | ||
| 82 | if($dbsync["sync_datalog_external"] == 1) { | |
| 83 | $sql = "INSERT INTO sys_datalog (dbtable,dbidx,action,tstamp,user,data) VALUES ('$d[dbtable]','$d[dbidx]','$d[action]','".time()."','$d[user]','$d[data]')"; | |
| 84 | $db->query($sql); | |
| 85 | } | |
| 86 | ||
| 87 | if($dbsync["empty_datalog"] == 1) { | |
| 88 | $sql = "DELETE FROM sys_datalog WHERE datalog_id = $d[datalog_id]"; | |
| 89 | $app->db->query($sql); | |
| 90 | } | |
| 91 | ||
| 92 | $app->db->query("UPDATE sys_dbsync SET last_datalog_id = $d[datalog_id] WHERE id = $dbsync[id]"); | |
| 93 | ||
| 94 | echo "Synchronisiere: $d[dbtable]:$d[dbidx]<br>"; | |
| 95 | ||
| 96 | } | |
| 97 | } | |
| 98 | } | |
| 99 | ||
| 100 | ?> | |
