xtcom/confedit.php

   1 <?
   2 if (!isset($_SERVER['PHP_AUTH_USER'])) {
   3         Header("WWW-Authenticate: Basic realm=\"Configurations-Editor\"");
   4         Header("HTTP/1.0 401 Unauthorized");
   5         echo "Sie m&uuml;ssen sich autentifizieren\n";
   6         exit;
   7 } else {
   8         $login=($_GET["login"])?$_GET["login"]:$_POST["login"];
   9         if (file_exists ("conf$login.php")) {
  10                 require "conf$login.php";
  11         } else {
  12                 require "conf.php";
  13         }
  14         if ($_SERVER['PHP_AUTH_USER']<>$ERPftpuser || $_SERVER['PHP_AUTH_PW']<>$ERPftppwd) {
  15                 Header("WWW-Authenticate: Basic realm=\"My Realm\"");
  16                 Header("HTTP/1.0 401 Unauthorized");
  17                 echo "Sie m&uuml;ssen sich autentifizieren\n";
  18                 exit;
  19         }
  20         require_once "DB.php";
  21         function pg($sel) {
  22         global $dbP;
  23                 echo "\t<option value=0";
  24                 if ($sel==0) echo " selected";
  25                 echo ">Standard VK\n";
  26                 $sql="select id,pricegroup from pricegroup";
  27                 if (!$dbP) return;
  28                 $pgs=$dbP->getall($sql);
  29                 if ($pgs) foreach ($pgs as $row) {
  30                         echo "\t<option value=".$row[0];
  31                         if ($sel==$row[0]) echo " selected";
  32                         echo ">".$row[1]."\n";
  33                 }
  34         }
  35         function shoplang($sel,$default) {
  36         global $dbM;
  37                 if (!$dbM) return;
  38                 $sql="SELECT L.*, C.configuration_value FROM languages L LEFT JOIN configuration C ";
  39                 $sql.="ON L.code = C.configuration_value";
  40                 $rs=$dbM->getAll($sql,DB_FETCHMODE_ASSOC);
  41                 if (!$rs) {
  42                       echo "\t\t<option value='0'>keine Sprachen\n";
  43                 } else {
  44                         echo "\t\t<option value='0' ".(($sel==0)?"selected":"").">nicht verwenden\n";
  45                         foreach ($rs as $row) {
  46                                 if ($default["id"]<>$row["languages_id"]) {
  47                                         echo "\t\t<option value='".$row["languages_id"]."' ";
  48                                         echo (($row["languages_id"]==$sel)?"selected":"").">";
  49                                         echo ($row["code"]==$row["configuration_value"])?"!":" ";
  50                                         echo $row["name"]."\n";
  51                                 }
  52                         }
  53                 }
  54         }
  55         function erplang($sel) {
  56         global $dbP;
  57                 if (!$dbP) return;
  58                 $sql="select * from language";
  59                 $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
  60                 if (!$rs) {
  61                       echo "\t\t<option>keine Sprachen\n";
  62                 } else {
  63                         //echo "\t\t<option value='0' ".(($sel==0)?"selected":"").">Standard\n";
  64                         foreach ($rs as $row) {
  65                                 echo "\t\t<option value='".$row["id"]."' ";
  66                                 echo ($sel==$row["id"])?"selected":"";
  67                                 echo ">".$row["description"]."\n";
  68                         }
  69                 }
  70         }
  71         function getERPlangs() {
  72         global $dbP;
  73                 if (!$dbP) return;
  74                 $sql="select * from language";
  75                 $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
  76                 return $rs;
  77         }
  78         function getShopDefault() {
  79         global $dbM;
  80                 if (!$dbM) return;
  81                 $sql="select * from languages L left join configuration C on L.code=C.configuration_value ";
  82                 $sql.="where  configuration_key = 'DEFAULT_LANGUAGE'";
  83                 $rs=$dbM->getAll($sql,DB_FETCHMODE_ASSOC);
  84                 if ($rs) {
  85                         return array("id"=>$rs[0]["languages_id"],"name"=>$rs[0]["name"]);
  86                 } else  {
  87                         return 0;
  88                 }
  89         }
  90         function getBugru() {
  91         global $dbP;
  92                 if (!$dbP) return;
  93                 $sql ="select  BG.id as bugru,(T.rate * 100) as rate,TK.startdate from buchungsgruppen BG ";
  94                 $sql.="left join chart C on BG.income_accno_id_0=C.id left join taxkeys TK ";
  95                 $sql.="on TK.chart_id=C.id left join tax T on T.id=TK.tax_id where ";
  96                 $sql.="TK.startdate <= now() order by BG.id, TK.startdate";
  97                 $rs=$dbP->getAll($sql,DB_FETCHMODE_ASSOC);
  98                 if ($rs) foreach ($rs as $row) {
  99                         $bugru[$row["bugru"]]=$row["rate"];
 100                 }
 101                 return $bugru;
 102         }
 103         if ($_POST["ok"]=="sichern") {
 104                 $ok=true;
 105                 $dsnP = array(
 106                     'phptype'  => 'pgsql',
 107                     'username' => $_POST["ERPuser"],
 108                     'password' => $_POST["ERPpass"],
 109                     'hostspec' => $_POST["ERPhost"],
 110                     'database' => $_POST["ERPdbname"],
 111                     'port'     => $_POST["ERPport"]
 112                 );
 113                 $dbP=@DB::connect($dsnP);
 114                 if (DB::isError($dbP)||!$dbP) {
 115                         $ok=false;
 116                         echo "Keine Verbindung zur ERP<br>";
 117                         echo $dbP->userinfo;
 118                         $dbP=false;
 119                 } else {
 120                         $bugru=getBugru();
 121                         $sql="SELECT id,description,buchungsgruppen_id FROM parts where partnumber = '%s'";
 122                         $rs=$dbP->getall(sprintf($sql,$_POST["div16NR"]));
 123                         $_POST["div16ID"]=$rs[0][0];
 124                         $div16txt=addslashes($rs[0][1]);
 125                         $_POST["div16TAX"]=$bugru[$rs[0][2]];
 126                         $rs=$dbP->getall(sprintf($sql,$_POST["div07NR"]));
 127                         $_POST["div07ID"]=$rs[0][0];
 128                         $_POST["div07TAX"]=$bugru[$rs[0][2]];
 129                         $div07txt=addslashes($rs[0][1]);
 130                         $rs=$dbP->getall(sprintf($sql,$_POST["versandNR"]));
 131                         $_POST["versandID"]=$rs[0][0];
 132                         $_POST["versandTAX"]=$bugru[$rs[0][2]];
 133                         $versandtxt=addslashes($rs[0][1]);
 134                         $rs=$dbP->getall(sprintf($sql,$_POST["nachnNR"]));
 135                         $_POST["nachnID"]=$rs[0][0];
 136                         $_POST["nachnTAX"]=$bugru[$rs[0][2]];
 137                         $nachntxt=addslashes($rs[0][1]);
 138                         $rs=$dbP->getall(sprintf($sql,$_POST["minderNR"]));
 139                         $_POST["minderID"]=$rs[0][0];
 140                         $_POST["minderTAX"]=$bugru[$rs[0][2]];
 141                         $mindertxt=addslashes($rs[0][1]);
 142                         $rs=$dbP->getall(sprintf($sql,$_POST["paypalNR"]));
 143                         $_POST["paypalID"]=$rs[0][0];
 144                         $_POST["paypalTAX"]=$bugru[$rs[0][2]];
 145                         $paypaltxt=addslashes($rs[0][1]);
 146                         $rs=$dbP->getall("select id from employee where login = '".$_POST["ERPusrN"]."'");
 147                         $_POST["ERPusrID"]=$rs[0][0];
 148                 }
 149                 $dsnM = array(
 150                     'phptype'  => 'mysql',
 151                     'username' => $_POST["SHOPuser"],
 152                     'password' => $_POST["SHOPpass"],
 153                     'hostspec' => $_POST["SHOPhost"],
 154                     'database' => $_POST["SHOPdbname"],
 155                     'port'     => $_POST["SHOPport"]
 156                 );
 157                 $dbM=@DB::connect($dsnM);
 158                 if (DB::isError($dbM)||!$dbM) {
 159                         //$ok=false;
 160                         echo "Keine Verbindung zum Shop<br>";
 161                         echo $dbM->userinfo;
 162                         $dbM=false;
 163                 };
 164                 if ($ok) {
 165                         $ShopDefaultLang=getShopDefault();
 166                         $f=fopen("conf$login.php","w");
 167                         $v="2.0";
 168                         $d=date("Y/m/d H:i:s");
 169                         fputs($f,"<?\n// Verbindung zur ERP-db\n");
 170                         fputs($f,"\$ERPuser=\"".$_POST["ERPuser"]."\";\n");
 171                         fputs($f,"\$ERPpass=\"".$_POST["ERPpass"]."\";\n");
 172                         fputs($f,"\$ERPhost=\"".$_POST["ERPhost"]."\";\n");
 173                         fputs($f,"\$ERPport=\"".$_POST["ERPport"]."\";\n");
 174                         fputs($f,"\$ERPdbname=\"".$_POST["ERPdbname"]."\";\n");
 175                         fputs($f,"\$ERPusr[\"Name\"]=\"".$_POST["ERPusrN"]."\";\n");
 176                         fputs($f,"\$ERPusr[\"ID\"]=\"".$_POST["ERPusrID"]."\";\n");
 177                         fputs($f,"\$ERPdir=\"".$_POST["ERPdir"]."\";\n");
 178                         fputs($f,"\$ERPimgdir=\"".$_POST["ERPimgdir"]."\";\n");
 179                         fputs($f,"\$maxSize=\"".$_POST["maxSize"]."\";\n");
 180                         fputs($f,"\$ERPftphost=\"".$_POST["ERPftphost"]."\";\n");
 181                         fputs($f,"\$ERPftpuser=\"".$_POST["ERPftpuser"]."\";\n");
 182                         fputs($f,"\$ERPftppwd=\"".$_POST["ERPftppwd"]."\";\n");
 183                         fputs($f,"//Verbindung zur osCommerce-db\n");
 184                         fputs($f,"\$SHOPuser=\"".$_POST["SHOPuser"]."\";\n");
 185                         fputs($f,"\$SHOPpass=\"".$_POST["SHOPpass"]."\";\n");
 186                         fputs($f,"\$SHOPhost=\"".$_POST["SHOPhost"]."\";\n");
 187                         fputs($f,"\$SHOPport=\"".$_POST["SHOPport"]."\";\n");
 188                         fputs($f,"\$SHOPdbname=\"".$_POST["SHOPdbname"]."\";\n");
 189                         fputs($f,"\$SHOPdns=\"mysql://\$SHOPuser:\$SHOPpass@\$SHOPhost/\$SHOPdbname\";\n");
 190                         fputs($f,"\$SHOPdir=\"".$_POST["SHOPdir"]."\";\n");
 191                         fputs($f,"\$SHOPimgdir=\"".$_POST["SHOPimgdir"]."\";\n");
 192                         fputs($f,"\$SHOPftphost=\"".$_POST["SHOPftphost"]."\";\n");
 193                         fputs($f,"\$SHOPftpuser=\"".$_POST["SHOPftpuser"]."\";\n");
 194                         fputs($f,"\$SHOPftppwd=\"".$_POST["SHOPftppwd"]."\";\n");
 195                         fputs($f,"\$div16[\"ID\"]=\"".$_POST["div16ID"]."\";\n");
 196                         fputs($f,"\$div07[\"ID\"]=\"".$_POST["div07ID"]."\";\n");
 197                         fputs($f,"\$versand[\"ID\"]=\"".$_POST["versandID"]."\";\n");
 198                         fputs($f,"\$nachn[\"ID\"]=\"".$_POST["nachnID"]."\";\n");
 199                         fputs($f,"\$minder[\"ID\"]=\"".$_POST["minderID"]."\";\n");
 200                         fputs($f,"\$paypal[\"ID\"]=\"".$_POST["paypalID"]."\";\n");
 201                         fputs($f,"\$div16[\"NR\"]=\"".$_POST["div16NR"]."\";\n");
 202                         fputs($f,"\$div07[\"NR\"]=\"".$_POST["div07NR"]."\";\n");
 203                         fputs($f,"\$versand[\"NR\"]=\"".$_POST["versandNR"]."\";\n");
 204                         fputs($f,"\$nachn[\"NR\"]=\"".$_POST["nachnNR"]."\";\n");
 205                         fputs($f,"\$minder[\"NR\"]=\"".$_POST["minderNR"]."\";\n");
 206                         fputs($f,"\$paypal[\"NR\"]=\"".$_POST["paypalNR"]."\";\n");
 207                         fputs($f,"\$div16[\"TAX\"]=\"".$_POST["div16TAX"]."\";\n");
 208                         fputs($f,"\$div07[\"TAX\"]=\"".$_POST["div07TAX"]."\";\n");
 209                         fputs($f,"\$versand[\"TAX\"]=\"".$_POST["versandTAX"]."\";\n");
 210                         fputs($f,"\$nachn[\"TAX\"]=\"".$_POST["nachnTAX"]."\";\n");
 211                         fputs($f,"\$minder[\"TAX\"]=\"".$_POST["minderTAX"]."\";\n");
 212                         fputs($f,"\$paypal[\"TAX\"]=\"".$_POST["paypalTAX"]."\";\n");
 213                         fputs($f,"\$div16[\"TXT\"]=\"".$div16txt."\";\n");
 214                         fputs($f,"\$div07[\"TXT\"]=\"".$div07txt."\";\n");
 215                         fputs($f,"\$versand[\"TXT\"]=\"".$versandtxt."\";\n");
 216                         fputs($f,"\$nachn[\"TXT\"]=\"".$nachntxt."\";\n");
 217                         fputs($f,"\$minder[\"TXT\"]=\"".$mindertxt."\";\n");
 218                         fputs($f,"\$paypal[\"TXT\"]=\"".$paypaltxt."\";\n");
 219                         fputs($f,"\$bgcol[1]=\"#ddddff\";\n");
 220                         fputs($f,"\$bgcol[2]=\"#ddffdd\";\n");
 221                         fputs($f,"\$preA=\"".$_POST["preA"]."\";\n");
 222                         fputs($f,"\$preK=\"".$_POST["preK"]."\";\n");
 223                         fputs($f,"\$auftrnr=\"".$_POST["auftrnr"]."\";\n");
 224                         fputs($f,"\$debug=".$_POST["debug"].";\n");
 225                         fputs($f,"\$kdnum=\"".$_POST["kdnum"]."\";\n");
 226                         fputs($f,"\$stdprice=\"".$_POST["stdprice"]."\";\n");
 227                         fputs($f,"\$altprice=\"".$_POST["altprice"]."\";\n");
 228                         fputs($f,"\$KDGrp=\"".$_POST["KDGrp"]."\";\n");
 229                         fputs($f,"\$nopic=\"".$_POST["nopic"]."\";\n");
 230                         fputs($f,"\$showErr=\"true\";\n");
 231                         $Language=array();
 232                         $DefaultLangOk=false;
 233                         if ($_POST["ERPlang"]) foreach ($_POST["ERPlang"] as $key=>$val) {
 234                                 if ($_POST["SHOPlang"][$key]==$ShopDefaultLang["id"]) $DefaultLangOk=true;
 235                                 if ($_POST["SHOPlang"][$key])
 236                                         fputs($f,"\$Language[$key]=array(\"ERP\"=>$val,\"SHOP\"=>".$_POST["SHOPlang"][$key].");\n");
 237                         }
 238                         if (!$DefaultLangOk) {
 239                                 fputs($f,"\$SHOPdbname=\"\";\n");
 240                                 echo "Es wurde keine ERP-Sprache der Shopdefaultsprache zugewiesen.";
 241                                 echo "Verbindung zum Shop abgebrochen<br>";
 242                         }
 243                         fputs($f,"\$SHOPdefaultlang=\"".$ShopDefaultLang["id"]."\";\n");
 244                         fputs($f,"\$SpracheAlle=\"".$_POST["SpracheAlle"]."\";\n");
 245                         fputs($f,"?>");
 246                         fclose($f);
 247                         echo "<br>'conf.php' geschriebeni!<br>";
 248                         if (file_exists ("conf$login.php")) {
 249                                 require "conf$login.php";
 250                         } else {
 251                                 require "conf.php";
 252                         }
 253                         $sql="select count(*) from customers_number";
 254                         $rc=@$dbM->query($sql);
 255                         if ($rc->code==-18) {
 256                                 $sql="CREATE TABLE customers_number (  cid int(6) NOT NULL auto_increment,  customers_id int(3) NOT NULL default '0', ";
 257                                 $sql.="kdnr int(3) NOT NULL default '0', shipto int ,  PRIMARY KEY  (cid)) TYPE=MyISAM";
 258                                 $rc=@$dbM->query($sql);
 259                                 if ($rc->code==-1) {
 260                                         echo "Fehler beim Erzeugen der Tabelle 'customers_number' in der Shop-db";
 261                                 } else {
 262                                         echo "Tabelle 'customers_number' in der Shop-db angelegt.";
 263                                 }
 264                         } else {
 265                                 $sql="select shipto from customers_number limit 1";
 266                                 $rc=@$dbM->query($sql);
 267                                 if ($rc->code==-19) {
 268                                         $sql="alter table customers_number add column shipto int";
 269                                         $rc=@$dbM->query($sql);
 270                                         if ($rc->code==-1) {
 271                                                 echo "Fehler beim Anlegen der Spalte 'shipto' in 'customers_number'";
 272                                         } else {
 273                                                 echo "'shipto' in 'customers_number' angelegt.";
 274                                         }
 275                                 }
 276                         }
 277                 } else {
 278                         $ERPuser=$_POST["ERPuser"];
 279                         $ERPpass=$_POST["ERPpass"];
 280                         $ERPhost=$_POST["ERPhost"];
 281                         $ERPport=$_POST["ERPport"];
 282                         $ERPdbname=$_POST["ERPdbname"];
 283                         $ERPusrN=$_POST["ERPusrN"];
 284                         $ERPdir=$_POST["ERPdir"];
 285                         $ERPimgdir=$_POST["ERPimgdir"];
 286                         $maxSize=$_POST["maxSize"];
 287                         $ERPftphost=$_POST["ERPftphost"];
 288                         $ERPftpuser=$_POST["ERPftpuser"];
 289                         $ERPftppwd=$_POST["ERPftppwd"];
 290                         $SHOPuser=$_POST["SHOPuser"];
 291                         $SHOPpass=$_POST["SHOPpass"];
 292                         $SHOPhost=$_POST["SHOPhost"];
 293                         $SHOPport=$_POST["SHOPport"];
 294                         $SHOPdbname=$_POST["SHOPdbname"];
 295                         $SHOPlang=$_POST["SHOPlang"];
 296                         $SHOPdir=$_POST["SHOPdir"];
 297                         $SHOPimgdir=$_POST["SHOPimgdir"];
 298                         $SHOPftphost=$_POST["SHOPftphost"];
 299                         $SHOPftpuser=$_POST["SHOPftpuser"];
 300                         $SHOPftppwd=$_POST["SHOPftppwd"];
 301                         $div16NR=$_POST["div16NR"];
 302                         $div07NR=$_POST["div07NR"];
 303                         $versandNR=$_POST["versandNR"];
 304                         $nachnNR=$_POST["nachnNR"];
 305                         $minderNR=$_POST["minderNR"];
 306                         $paypalNR=$_POST["paypalNR"];
 307                         $preA=$_POST["preA"];
 308                         $preK=$_POST["preK"];
 309                         $kdnum=$_POST["kdnum"];
 310                         $auftrnr=$_POST["auftrnr"];
 311                         $debug=$_POST["debug"];
 312                         $altprice=$_POST["altprice"];
 313                         $stdprice=$_POST["stdprice"];
 314                         $nopic=$_POST["nopic"];
 315                 }
 316                 $ERPlangs=getERPlangs();
 317                 $CntERPLang=count($ERPlangs); //$rs[0][0];
 318         }       else {
 319                 if (file_exists ("conf$login.php")) {
 320                         require "conf$login.php";
 321                 } else {
 322                         require "conf.php";
 323                 }
 324                 $dsnP = array(
 325                     'phptype'  => 'pgsql',
 326                     'username' => $ERPuser,
 327                     'password' => $ERPpass,
 328                     'hostspec' => $ERPhost,
 329                     'database' => $ERPdbname,
 330                     'port'     => $ERPport
 331                 );
 332                 $dbP=@DB::connect($dsnP);
 333                 if (DB::isError($dbP)||!$dbP) {
 334                         echo "Keine Verbindung zur ERP<br>";
 335                         $dbP=false;
 336                         //echo $dbP->userinfo;
 337                 } else {
 338                         //$rs=$dbP->getAll("select count(*) from language");
 339                         $ERPlangs=getERPlangs();
 340                         $CntERPLang=count($ERPlangs); //$rs[0][0];
 341                 }
 342                 $dsnM = array(
 343                     'phptype'  => 'mysql',
 344                     'username' => $SHOPuser,
 345                     'password' => $SHOPpass,
 346                     'hostspec' => $SHOPhost,
 347                     'database' => $SHOPdbname,
 348                     'port'     => $SHOPport
 349                 );
 350                 $dbM=@DB::connect($dsnM);
 351                 if (DB::isError($dbM)||!$dbM) {
 352                         echo "Keine Verbindung zum SHOP<br>";
 353                         $dbM=false;
 354                         //echo $dbM->userinfo;
 355                 } else {
 356                         $ShopDefaultLang=getShopDefault();
 357                 }
 358         }
 359 ?>
 360 <html>
 361 <body>
 362 <center>
 363 <table style="background-color:#cccccc">
 364 <form name="ConfEdit" method="post" action="confedit.php">
 365 <input type="hidden" name="div16ID" value="<?= $div16["ID"] ?>">
 366 <input type="hidden" name="div07ID" value="<?= $div07["ID"] ?>">
 367 <input type="hidden" name="minderID" value="<?= $minder["ID"] ?>">
 368 <input type="hidden" name="versandID" value="<?= $versand["ID"] ?>">
 369 <input type="hidden" name="nachnID" value="<?= $nachn["ID"] ?>">
 370 <input type="hidden" name="paypalID" value="<?= $paypal["ID"] ?>">
 371 <input type="hidden" name="ERPusrID" value="<?= $ERPusr["ID"] ?>">
 372 <input type="hidden" name="login" value="<?= $login ?>">
 373 <tr><th>Daten</th><th>Lx-ERP</th><th></th><th>Shop</th></tr>
 374 <tr>
 375         <td>db-Host</td>
 376         <td colspan="2"><input type="text" name="ERPhost" size="25" value="<?= $ERPhost ?>"></td>
 377         <td><input type="text" name="SHOPhost" size="25" value="<?= $SHOPhost ?>"></td>
 378 </tr>
 379 <tr>
 380         <td>db-Port</td>
 381         <td colspan="2"><input type="text" name="ERPport" size="25" value="<?= $ERPport ?>"></td>
 382         <td><input type="text" name="SHOPport" size="25" value="<?= $SHOPport ?>"></td>
 383 </tr>
 384 <tr>
 385         <td>Database</td>
 386         <td colspan="2"><input type="text" name="ERPdbname" size="20" value="<?= $ERPdbname ?>"></td>
 387         <td><input type="text" name="SHOPdbname" size="20" value="<?= $SHOPdbname ?>"></td>
 388 </tr>
 389 <tr>
 390         <td>db-User Name</td>
 391         <td colspan="2"><input type="text" name="ERPuser" size="15" value="<?= $ERPuser ?>"></td>
 392         <td><input type="text" name="SHOPuser" size="15" value="<?= $SHOPuser ?>"></td>
 393 </tr>
 394 <tr>
 395         <td>db-User PWD</td>
 396         <td colspan="2"><input type="text" name="ERPpass" size="15" value="<?= $ERPpass ?>"></td>
 397         <td><input type="text" name="SHOPpass" size="15" value="<?= $SHOPpass ?>"></td>
 398 </tr>
 399 <tr>
 400         <td>User-ID</td>
 401         <td colspan="2"><input type="text" name="ERPusrN" size="10" value="<?= $ERPusr["Name"] ?>">
 402                 <input type="checkbox" name="a1" <?= (empty($ERPusr["ID"])?"":"checked") ?> onFocus="blur();"></td>
 403         <td></td>
 404 </tr>
 405 <tr>
 406         <td>CSV-Dir</td>
 407         <td colspan="2"><input type="text" name="ERPdir" size="30" value="<?= $ERPdir ?>"></td>
 408         <td><input type="text" name="SHOPdir" size="30" value="<?= $SHOPdir ?>"></td>
 409 </tr>
 410 <tr>
 411         <td>Image-Dir</td>
 412         <td colspan="2"><input type="text" name="ERPimgdir" size="30" value="<?= $ERPimgdir ?>"></td>
 413         <td><input type="text" name="SHOPimgdir" size="30" value="<?= $SHOPimgdir ?>"></td>
 414 </tr>
 415 <tr>
 416         <td>FTP-Host</td>
 417         <td colspan="2"><input type="text" name="ERPftphost" size="20" value="<?= $ERPftphost ?>"></td>
 418         <td><input type="text" name="SHOPftphost" size="20" value="<?= $SHOPftphost ?>"></td>
 419 </tr>
 420 <tr>
 421         <td>FTP-User</td>
 422         <td colspan="2"><input type="text" name="ERPftpuser" size="15" value="<?= $ERPftpuser ?>"></td>
 423         <td><input type="text" name="SHOPftpuser" size="15" value="<?= $SHOPftpuser ?>"></td>
 424 </tr>
 425 <tr>
 426         <td>FTP-User PWD</td>
 427         <td colspan="2"><input type="text" name="ERPftppwd" size="15" value="<?= $ERPftppwd ?>"></td>
 428         <td><input type="text" name="SHOPftppwd" size="15" value="<?= $SHOPftppwd ?>"></td>
 429 </tr>
 430 <tr>
 431         <td>ID Diverse 19%</td>
 432         <td><input type="text" name="div16NR" size="10" value="<?= $div16["NR"] ?>">
 433                 <input type="checkbox" name="a1" <?= (empty($div16["ID"])?"":"checked") ?>></td>
 434         <td>ID Diverse 7%</td>
 435         <td><input type="text" name="div07NR" size="10" value="<?= $div07["NR"] ?>">
 436                 <input type="checkbox" name="a1" <?= (empty($div07["ID"])?"":"checked") ?>></td>
 437 </tr>
 438 <tr>
 439         <td>ID Versand</td>
 440         <td><input type="text" name="versandNR" size="10" value="<?= $versand["NR"] ?>">
 441                 <input type="checkbox" name="a1" <?= (empty($versand["ID"])?"":"checked") ?>></td>
 442         <td>ID Nachname</td>
 443         <td><input type="text" name="nachnNR" size="10" value="<?= $nachn["NR"] ?>">
 444                 <input type="checkbox" name="a1" <?= (empty($nachn["ID"])?"":"checked") ?>></td>
 445 </tr>
 446 <tr>
 447         <td>ID Paypal</td>
 448         <td><input type="text" name="paypalNR" size="10" value="<?= $paypal["NR"] ?>">
 449                 <input type="checkbox" name="a1" <?= (empty($paypal["ID"])?"":"checked") ?>></td>
 450         <td>ID Mindemenge</td>
 451         <td><input type="text" name="minderNR" size="10" value="<?= $minder["NR"] ?>">
 452                 <input type="checkbox" name="a1" <?= (empty($minder["ID"])?"":"checked") ?>></td>
 453 </tr>
 454 <tr>
 455         <td >Sprachen</td>
 456         <td ><input type="hidden" name="ERPlang[0]" value="0">Standard</td>
 457         <td >--&gt;</td>
 458         <td ><input type="hidden" name="SHOPlang[0]" value="<?= $ShopDefaultLang["id"] ?>"><?= $ShopDefaultLang["name"] ?></td>
 459 </tr>
 460 <? for($i=0; $i < $CntERPLang; $i++) {  ?>
 461 <tr>
 462         <td >Sprachen</td>
 463         <td><input type="hidden" name="ERPlang[<?= $i+1 ?>]" value="<?= $ERPlangs[$i]["id"] ?>"><?= $ERPlangs[$i]["description"] ?>
 464         <td >--&gt;</td>
 465         <td ><select name="SHOPlang[<?= $i+1 ?>]">
 466 <?= shoplang($Language[$i+1]["SHOP"],$ShopDefaultLang); ?>
 467         </select></td>
 468 </tr>
 469 <? } ?>
 470 <tr>
 471         <td colspan="2">Nur &uuml;bersetzte Artikel</td>
 472         <td><input type="radio" name="SpracheAlle" value="true"  <?= ($SpracheAlle=="true")?"checked":"" ?>> Ja</td>
 473         <td><input type="radio" name="SpracheAlle" value="false" <?= ($SpracheAlle<>"true")?"checked":"" ?>> Nein</td>
 474 </tr>
 475 <tr>
 476         <td>Standardpreis</td>
 477         <td><select name="stdprice">
 478 <? pg($stdprice); ?>
 479             </select></td>
 480         <td>Defaultbild</td>
 481         <td><input type="text" name="nopic" size="20" value="<?= $nopic ?>">
 482 <tr>
 483         <td>abweichender Preis</td>
 484         <td><select name="altprice">
 485 <? pg($altprice); ?>
 486             </select></td>
 487         <td>Kundengruppe</td>
 488         <td><input type="text" name="KDGrp" size="3" value="<?= $KDGrp ?>">
 489 </tr>
 490 <tr>
 491         <td colspan="2">Auftragsnummern durch</td>
 492         <td><input type="radio" name="auftrnr" value="1" <?= ($auftrnr==1)?"checked":"" ?>> LxO</td>
 493         <td><input type="radio" name="auftrnr" value="0" <?= ($auftrnr<>1)?"checked":"" ?>> Shop</td>
 494 </tr>
 495 <tr>
 496         <td colspan="2">Kundennummern durch</td>
 497         <td><input type="radio" name="kdnum" value="1" <?= ($kdnum==1)?"checked":"" ?>> LxO</td>
 498         <td><input type="radio" name="kdnum" value="0" <?= ($kdnum<>1)?"checked":"" ?>> Shop</td>
 499 </tr>
 500 <tr>
 501         <td colspan="2">Nummernerweiterung</td>
 502         <td>Auftrag<input type="text" name="preA" size="5" value="<?= $preA ?>"></td>
 503         <td>Kunde<input type="text" name="preK" size="5" value="<?= $preK ?>"></td>
 504 </tr>
 505 <tr>
 506         <td>Logging</td>
 507         <td>ein<input type="radio" name="debug" value="true" <?= ($debug=="true")?"checked":"" ?>>
 508         aus<input type="radio" name="debug" value="false" <?= ($debug!="true")?"checked":"" ?>></td>
 509         <td></td><td></td>
 510 </tr>
 511 <tr><td colspan="4" align="center"><input type="submit" name="ok" value="sichern"></td></tr>
 512 </form>
 513 </table>
 514 </center>
 515 </body>
 516 </html>
 517 <? } ?>