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();
