getall($sql); } function pg($sel) { global $pgs; echo "\tStandard VK\n"; if ($pgs) foreach ($pgs as $row) { echo "\t".$row[1]."\n"; } } if ($_SERVER['PHP_AUTH_USER']<>$ERPftpuser || $_SERVER['PHP_AUTH_PW']<>$ERPftppwd) { Header("WWW-Authenticate: Basic realm=\"My Realm\""); Header("HTTP/1.0 401 Unauthorized"); echo "Sie müssen sich autentifizieren\n"; exit; } if ($_POST["ok"]=="sichern") { $ok=true; $dsnP="pgsql://".$_POST["ERPuser"].":".$_POST["ERPpass"]."@".$_POST["ERPhost"]."/".$_POST["ERPdbname"]; $dbP=DB::connect($dsnP); if (DB::isError($dbP)||!$dbP) { $ok=false; echo "Keine Verbindung zur ERP
"; echo $dbP->userinfo; } else { $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div16NR"]."'"); $_POST["div16ID"]=$rs[0][0]; $div16txt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["div07NR"]."'"); $_POST["div07ID"]=$rs[0][0]; $div07txt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["versandNR"]."'"); $_POST["versandID"]=$rs[0][0]; $versandtxt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["nachnNR"]."'"); $_POST["nachnID"]=$rs[0][0]; $nachntxt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["minderNR"]."'"); $_POST["minderID"]=$rs[0][0]; $mindertxt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["paypalNR"]."'"); $_POST["paypalID"]=$rs[0][0]; $paypaltxt=$rs[0][1]; $rs=$dbP->getall("select id,description from parts where partnumber = '".$_POST["treuhNR"]."'"); $_POST["treuhID"]=$rs[0][0]; $treuhtxt=$rs[0][1]; $rs=$dbP->getall("select id from employee where login = '".$_POST["ERPusrN"]."'"); $_POST["ERPusrID"]=$rs[0][0]; } $dsnM="mysql://".$_POST["SHOPuser"].":".$_POST["SHOPpass"]."@".$_POST["SHOPhost"]."/".$_POST["SHOPdbname"]; $dbM=DB::connect($dsnM); if (DB::isError($dbM)||!$dbM) { $ok=false; echo "Keine Verbindung zum Shop
"; echo $dbM->userinfo; }; if (ok) { $f=fopen("conf.php","w"); $v="1.5"; $d=date("Y/m/d H:i:s"); fputs($f,""); fclose($f); require "conf.php"; } else { $ERPuser=$_POST["ERPuser"]; $ERPpass=$_POST["ERPpass"]; $ERPhost=$_POST["ERPhost"]; $ERPdbname=$_POST["ERPdbname"]; $ERPusrN=$_POST["ERPusrN"]; $ERPdir=$_POST["ERPdir"]; $ERPimgdir=$_POST["ERPimgdir"]; $maxSize=$_POST["maxSize"]; $ERPftphost=$_POST["ERPftphost"]; $ERPftpuser=$_POST["ERPftpuser"]; $ERPftppwd=$_POST["ERPftppwd"]; $SHOPuser=$_POST["SHOPuser"]; $SHOPpass=$_POST["SHOPpass"]; $SHOPhost=$_POST["SHOPhost"]; $SHOPdbname=$_POST["SHOPdbname"]; $SHOPdir=$_POST["SHOPdir"]; $SHOPimgdir=$_POST["SHOPimgdir"]; $SHOPftphost=$_POST["SHOPftphost"]; $SHOPftpuser=$_POST["SHOPftpuser"]; $SHOPftppwd=$_POST["SHOPftppwd"]; $div16NR=$_POST["div16NR"]; $div07NR=$_POST["div07NR"]; $versandNR=$_POST["versandNR"]; $nachnNR=$_POST["nachnNR"]; $treuhNR=$_POST["treuhNR"]; $minderNR=$_POST["minderNR"]; $paypalNR=$_POST["paypalNR"]; $preA=$_POST["preA"]; $preK=$_POST["preK"]; $kdnum=$_POST["kdnum"]; $pricegroup=$_POST["pricegroup"]; $auftrnr=$_POST["auftrnr"]; } } else { require "conf.php"; } ?> "> "> "> "> "> "> "> ">

Daten	Lx-ERP		Shop
db-Host
Database
db-User Name
db-User PWD
User-ID	"> >
CSV-Dir
Image-Dir
FTP-Host
FTP-User
FTP-User PWD
ID Diverse 16%	"> >	ID Diverse 7%	"> >
ID Versand	"> >	ID Nachname	"> >
ID Paypal	"> >	ID Treuhand	"> >
ID Mindermenge	"> >	Preisgruppe
Auftragsnummern durch		> LxO	1)?"checked":"" ?>> Shop
Kundennummern durch		> LxO	1)?"checked":"" ?>> Shop
Nummernerweiterung		Auftrag	Kunde