'".$hidden1."'"); $sum1 = mysql_result($sql1,0); if ($sum1 == 0) { $geb = $_POST['knd17'].'-'.$_POST['knd16'].'-'.$_POST['knd15']; if ($_POST['knd04'] == 'Frau') { $anrede = 'Frau'; } if ($_POST['knd04'] == 'Herr') { $anrede = 'Herr'; } if ($_POST['knd02'] != '') { $post_pass = $_POST['knd02']; } $update = mysql_query("UPDATE kd01 SET k1_user='".$_POST['knd01']."', k1_pass='".$post_pass."', k1_anrede='".$anrede."', k1_name1='".$_POST['knd05']."', k1_name2='".$_POST['knd06']."', k1_firma='".$_POST['knd18']."', k1_strasse='".$_POST['knd07']."', k1_plz='".$_POST['knd08']."', k1_stadt='".$_POST['knd09']."', k1_land='".$_POST['knd10']."', k1_email1='".$_POST['knd11']."', k1_page='".$_POST['knd12']."', k1_tel='".$_POST['knd13']."', k1_fax='".$_POST['knd14']."', k1_gebdat='".$geb."' WHERE k1_idnr='".$hidden1."' LIMIT 1"); $user = $hidden1; session_register('user'); } else { $user2 = 'user_existiert'; $user = $hidden1; session_register('user'); } } if ($form2 != '') { $sql1 = mysql_query("SELECT COUNT(k1_id) FROM kd01 WHERE k1_user = '".$_POST['user']."' AND k1_pass = '".$_POST['pass']."'"); $sum1 = mysql_result($sql1,0); if ($sum1 == 1) { $query = mysql_query("SELECT * FROM kd01 WHERE k1_user = '".$_POST['user']."' AND k1_pass = '".$_POST['pass']."'") or die('Select ist fehlgeschlagen!'); $kunde1 = mysql_fetch_array($query); $user = $kunde1['k1_idnr']; session_register('user'); } } include ("01_basics/01_abfrage_custom.php"); if ($DeleteFromBasket == 'Löschen') { $delete = mysql_query("DELETE FROM kd04 WHERE k4_id='".$nArtikel_ID."' LIMIT 1"); $DeleteFromBasket = ''; $nArtikel_ID = ''; } if ($bestellen == 'Bestellung abschicken') { $sql1 = mysql_query("SELECT COUNT(k4_id) FROM kd04 WHERE k4_k1id = '".$kndnr."'"); $sum1 = mysql_result($sql1,0); if ($sum1 > 0) { $adr1 = ''; if ($rowc->k1_firma != '') { $adr1 = $rowc->k1_firma.'
'; } $adr1 = $adr1.$rowc->k1_name1.' '.$rowc->k1_name2.'
'; $adr1 = $adr1.$rowc->k1_strasse.'
'; $adr1 = $adr1.$rowc->k1_plz.' '.$rowc->k1_stadt.'
'; $adr1 = $adr1.$rowc->k1_land; $insert = mysql_query("INSERT INTO kd02 SET k2_k1id = '".$kndnr."', k2_adr1 = '".$adr1."', k2_wie = '".$wie."', k2_email = '".$rowc->k1_email1."', k2_summe1 = '".$summe."', k2_summe2 = '".$summe_versand."'"); $vid1 = mysql_insert_id(); $vid2 = auto_idnr_bestellung($vid1); $update = mysql_query("UPDATE kd02 SET k2_idnr = '".$vid2."' WHERE k2_id='".$vid1."' LIMIT 1"); $bid = $vid2; $best = "SELECT * FROM kd04 WHERE k4_k1id = '".$kndnr."'"; $kauf = mysql_query($best, $verbindung); $a = 0; while($row6 = mysql_fetch_array($kauf)) { $insert = mysql_query("INSERT INTO kd03 SET k3_k1id = '".$kndnr."', k3_k2id = '".$vid2."', k3_name = '".$row6['k4_name']."', k3_d1id = '".$row6['k4_d1id']."', k3_d2id = '".$row6['k4_d2id']."', k3_d3id = '".$row6['k4_d3id']."', k3_d4id = '".$row6['k4_d4id']."', k3_d5id = '".$row6['k4_d5id']."', k3_d6id = '".$row6['k4_d6id']."', k3_menge = '".$row6['k4_menge']."', k3_preis = '".$row6['k4_preis']."', k3_ware = '".$row6['k4_ware']."'"); $array_del[$a] = $row6['k4_id']; $a = $a+1; } $x = 0; for($x>0;$x<$a;$x++) { $delete = mysql_query("DELETE FROM kd04 WHERE k4_id='".$array_del[$x]."' LIMIT 1"); } } } if ($_GET['page'] == '101' OR $_GET['page'] == '') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '102') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '103') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '104') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'event') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '1011' OR $_GET['page'] == '1012') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '1013') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == '1014') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'artikel') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'news') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'wkorb') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'best') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'fertig') { include("01_basics/01_abfrage01.php"); } if ($_GET['page'] == 'such') { include("01_basics/01_abfrage_such.php"); } include("02_designs/01a_start.php"); include("02_designs/01b_head.php"); include("02_designs/02_tab01.php"); include("02_designs/01c_end.php"); ?>