for ($tablecount = 1; $tablecount < $anztables; $tablecount++) { $strvondbpassword = $strvondbpassword . "," . $arrvondbpassword[$tablecount]; } $arrnchdbpassword = json_decode($_POST["strnchdbpassword"]); $strnchdbpassword = $arrnchdbpassword[0]; for ($tablecount = 1; $tablecount < $anztables; $tablecount++) { $strnchdbpassword = $strnchdbpassword . "," . $arrnchdbpassword[$tablecount]; } $arrdbsyncnr = json_decode($_POST["strdbsyncnr"]); $strdbsyncnr = $arrdbsyncnr[0]; for ($tablecount = 1; $tablecount < $anztables; $tablecount++) { $strdbsyncnr = $strdbsyncnr . "," . $arrdbsyncnr[$tablecount]; } $arrcolsel = json_decode($_POST["strcolsel"]); bootstraphead(); bootstrapbegin("Datenaustausch"); echo "<a href='" . $callbackurl . "' class='btn btn-primary btn-sm active' role='button'>Zurück</a> "; echo "<div class='alert alert-info'>"; echo "<table>"; echo "<tr><td>callbackurl</td><td> : " . $callbackurl . "</td></tr>"; echo "<tr><td>strnchtables</td><td> : " . $strnchtables . "</td></tr>"; echo "<tr><td>strnchindex</td><td> : " . $strnchindex . "</td></tr>"; echo "<tr><td>strnchbez</td><td> : " . $strnchbez . "</td></tr>"; echo "<tr><td>strnchdbtyp</td><td> : " . $strnchdbtyp . "</td></tr>"; echo "<tr><td>strnchdbname</td><td> : " . $strnchdbname . "</td></tr>"; echo "<tr><td>strnchdbuser</td><td> : " . $strnchdbuser . "</td></tr>"; echo "<tr><td>strnchdbpassword</td><td> : " . $strnchdbpassword . "</td></tr>"; echo "<tr><td>strvondbtyp</td><td> : " . $strvondbtyp . "</td></tr>"; echo "<tr><td>strvondbname</td><td> : " . $strvondbname . "</td></tr>"; echo "<tr><td>strvondbuser</td><td> : " . $strvondbuser . "</td></tr>"; echo "<tr><td>strvondbpassword</td><td> : " . $strvondbpassword . "</td></tr>";
<?php include "bootstrapfunc.php"; include "dbtool.php"; include "insertfunc.php"; include "../config.php"; $menu = $_GET['menu']; $menugrp = $_GET['menugrp']; //echo $menu."<br>"; include "../sites/views/" . $menu . "/showtab.inc.php"; bootstraphead(); bootstrapbegin($pararray['headline']); $insert = $_GET['insert']; $idwert = $_GET['id']; if ($insert == 1) { $show = $_POST['chkanzeigen']; //echo $show."=show<br>"; insertsave($pararray, $listarray, $menu, $show, $autoinc_step, $autoinc_start, $menugrp); if ($show != "anzeigen") { echo "<meta http-equiv='refresh' content='0; URL=showtab.php?menu=" . $menu . "&menugrp=" . $menugrp . "'>"; } } else { insertinput($listarray, $idwert, $menu, $menugrp); } bootstrapend();
<?php include "bootstrapfunc.php"; include "dbtool.php"; include "gettablestrucfunc.php"; bootstraphead(); bootstrapbegin("Get Tables<br>"); $menu = $_GET['menu']; $dbid = $_GET['dbid']; echo "<a href='showtab.php?menu=" . $menu . "&dbid=" . $dbid . "' class='btn btn-primary btn-sm active' role='button'>Zurück</a> "; $db = dbopen('../', '../data/mysqlitesync.db'); $sql = "SELECT * FROM tbldatabase WHERE fldindex=" . $dbid; $results = $db->query($sql); if ($row = dbfetch('../', $results)) { $database = $row['fldbez']; $bemerk = $row['fldbemerk']; $pfad = $row['fldpfad']; $idsel = $row['fldid_select']; //echo $pfad.",".$database."=pfad,database<br>"; } $status = $_POST['status']; if ($status == "empfangen") { $datcnt = $_POST['datcnt']; $bemerk = ""; gettableempfangen($datcnt, $bemerk); } else { if ($idsel == 1) { gettablelocal($pfad, $database, $db, $dbid, $bemerk); } else { echo "<div class='alert alert-warning'>"; echo "Remote-Funktion gestartet.";
<?php include "bootstrapfunc.php"; $menu = $_GET['menu']; $pfad = $_GET['pfad']; $dbtable = $_GET['dbtable']; $fldindex = $_GET['fldindex']; $timestamp = $_GET['timestamp']; $datcnt = $_POST['datcnt']; $db = new SQLite3('../data/joorgsqlite.db'); bootstraphead(); bootstrapbegin('Datenaustausch'); $website = "http://" . $pfad . "sync.php?menu=" . $menu; echo $website . "<br>"; echo $datcnt . "<br>"; for ($i = 1; $i <= $datcnt; $i++) { echo "<div class='alert alert-success'>"; $index = $_POST['index' . $i]; $qryval = "SELECT * FROM " . $dbtable . " WHERE " . $fldindex . "=" . $index; $results = $db->query($qryval); if ($linval = $results->fetchArray()) { $sql = $_POST['updsql' . $i]; } else { $sql = $_POST['inssql' . $i]; } $sql = str_replace("#", "'", $sql); echo $sql . "<br>"; // echo $qryval."=qryval"; echo "</div>"; if ($nuranzeigen != "anzeigen") { $query = $db->exec($sql);
<?php include "bootstrapfunc.php"; include "../config.php"; bootstraphead(); bootstrapbegin($headline . "<br>"); echo "<a href='../index.php' class='btn btn-primary btn-sm active' role='button'>Menü</a> "; echo "<a href='about.php' class='btn btn-primary btn-sm active' role='button'>About</a><br><br>"; //$neuevers=$_GET['neuevers']; $ini_locarr = parse_ini_file("http://horald.github.io/joorgsqlite/versionphpmysync.txt"); $neueversnr = $ini_locarr['versnrphpmysync']; if ($neueversnr == "") { $ini_locarr = parse_ini_file("../version-new.txt"); $neueversnr = $ini_locarr['versnrphpmysync']; } echo "<a href='https://github.com/horald/phpmysync/tree/master/sites/update/zip/update-" . $neueversnr . ".tar.gz' class='btn btn-primary btn-sm active' role='button'>Download Version " . $neuevers . "</a> "; bootstrapend();
<?php include "bootstrapfunc.php"; include "stdlib/dbtool.php"; bootstraphead(); bootstrapbegin("Datenaustausch - Allnosync"); include "../config.php"; $menu = $_GET['menu']; $pfad = $_POST['pfad']; $dbtable = $_POST['dbtable']; echo "<a href='http://" . $pfad . "showtab.php?menu=" . $menu . "' class='btn btn-primary btn-sm active' role='button'>Zurück</a> "; $dbsyncnr = $_POST['dbsyncnr']; $dbtyp = $_POST['dbtyp']; //$database="../data/".$_POST['database']; $database = $_POST['database']; $dbuser = $_POST['dbuser']; $dbpassword = $_POST['dbpassword']; $timestamp = $_POST['timestamp']; $fldindex = $_POST['fldindex']; //$db = new SQLite3($database); echo $dbtyp . "<br>"; echo $database . "<br>"; $db = dbopentyp($dbtyp, $database, $dbuser, $dbpassword); //echo "<div class='alert alert-success'>"; //timestamp ermitteln //$qryval = "SELECT * FROM tblsyncstatus WHERE fldtable='".$dbtable."'"; //echo $qryval."<br>"; //$results = $db->query($qryval); //if ($linval = $results->fetchArray()) { // $timestamp=$linval['fldtimestamp']; //} else {
<?php session_start(); $typ = $_GET['typ']; include "bootstrapfunc.php"; include "../config.php"; bootstraphead(); bootstrapbegin("Hilfe"); $menu = $_GET['menu']; $url = $_GET['url']; $pagename = $_GET['pagename']; $action = $_GET['action']; if ($action == "back") { $pageno = $_GET['pageno']; if ($pageno > 0) { $pageno = $pageno - 1; $pagename = ""; } } if ($action == "forward") { $pageno = $_GET['pageno']; $pageno = $pageno + 1; $pagename = ""; } $db = new SQLite3('../data/' . $database); if ($pagename == "") { $query = "SELECT * FROM tblhelppage WHERE fldpageno='" . $pageno . "'"; } else { $query = "SELECT * FROM tblhelppage WHERE fldpagename='" . $pagename . "'"; } //echo $query."<br>";
<?php include "bootstrapfunc.php"; include "../config.php"; bootstraphead(); bootstrapbegin("Installation"); $dir = getcwd(); $file = $dir . '/sites/install/' . $database; $newfile = $dir . '/data/' . $database; if (!copy($file, $newfile)) { echo "<div class='alert alert-warning'>"; echo "copy {$file} schlug fehl...\n<br>"; echo "Installation der Datenbank (" . $file . ") fehlgeschlagen!"; echo "</div>"; } else { echo "<div class='alert alert-success'>"; echo "Datenbank erfolgreich installiert. (" . $newfile . ")"; echo "</div>"; echo "<a href='index.php' class='btn btn-primary btn-sm active' role='button'>Neustart</a><br>"; } bootstrapend();