QQ_szekFULLcopy.inc

---

Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:
Line #3:// echo("<H1>EXIT!!!</H1>");
Line #4://exit;
Line #5:
Line #6:if (!isset($_POST['submit'])) {
Line #7:
Line #8:echo("
Line #9: <FORM name=orderby action='QQ_szekFULLcopy.php' method='POST' >
Line #10:
Line #11:
Line #12:
Line #13:");
Line #14:exit;
Line #15:}
Line #16:
Line #17:if (isset($_SESSION['Dump'])) echo("QJEGY`2013v3.01 QQ_szekFULLcopy.inc *** ACTION =".$L_PHP." <hr>");
Line #18:$Sfilter='?';
Line #19:if (isset($_SESSION['Dump'])) include("../_inc_QJ/QQ_varlist.php");
Line #20:
Line #21:
Line #22:if (isset($_POST['IN_kod'])) {
Line #23: $wer="hely_kod='".$_POST['IN_kod']. "'";
Line #24:} else exit;
Line #25:
Line #26:
Line #27:if ($_POST['IN_kod']<>$_POST['OUT_kod']) {
Line #28:
Line #29:
Line #30:$keres = "SELECT * FROM qj_szek where ".$wer;
Line #31:
Line #32:
Line #33:$nur=mysql_num_rows($eredmeny);
Line #34:$musor=mysql_fetch_array($eredmeny);
Line #35:
Line #36:echo("<center><i>".$musor[hely_kod]."</i><br>".$musor[datum]." **** ");
Line #37:echo($musor[cim].$musor[datum_kod]."</center>");
Line #38:
Line #39:$keres = "SELECT * FROM qj_szek where ".$wer;
Line #40:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #41:$i=0;
Line #42:
Line #43:$result = mysql_query($keres);
Line #44:$id_field="wid";
Line #45:
Line #46:while ($original_record = mysql_fetch_assoc($result) ) {
Line #47: ++$i;
Line #48:
Line #49:// insert the new record and get the new auto_increment id
Line #50:// mysql_query("INSERT INTO qj_jegy (`{$id_field}`) VALUES (NULL)");
Line #51:// $newid = mysql_insert_id();
Line #52:
Line #53: // generate the query to update the new record with the previous values
Line #54: $query = "UPDATE qj_szek SET ";
Line #55: foreach ($original_record as $key => $value) {
Line #56:
Line #57: if ($key == "hely_kod") $value=$_POST[OUT_kod];
Line #58: if ($key == "szek_kod") $szek_kod=$value;
Line #59:
Line #60: if ($key != $id_field) {
Line #61:
Line #62: $query .= '`'.$key.'` = "'.str_replace('"','\"',$value).'", ';
Line #63: }
Line #64: }
Line #65:
Line #66: $query = substr($query,0,strlen($query)-2); # lop off the extra trailing comma
Line #67: $query .= " WHERE hely_kod='".$_POST[OUT_kod]."' and szek_kod='".$szek_kod."'";
Line #68:
Line #69:
Line #70:if (isset($_SESSION['Dump'])) echo $i.": ".$query."<hr>";
Line #71:
Line #72:$dupla = "SELECT * FROM qj_szek WHERE hely_kod='".$_POST[OUT_kod]."' and szek_kod='".$szek_kod."' LIMIT 1";
Line #73:
Line #74:
Line #75: $talal = mysql_query($dupla);
Line #76:
Line #77: $nur=mysql_num_rows($talal);
Line #78:
Line #79: if ($nur==0) {
Line #80: $ins="INSERT INTO qj_szek (`hely_kod`,`szek_kod`) VALUES ('$_POST[OUT_kod]','$szek_kod')";
Line #81: mysql_query($ins);
Line #82: $newid = mysql_insert_id();
Line #83: if (isset($_SESSION['Dump'])) echo $newid."/".$ins."<hr>";
Line #84:}
Line #85:
Line #86: mysql_query($query);
Line #87:
Line #88:}
Line #89:
Line #90:
Line #91:
Line #92:// $query = "UPDATE qj_szek SET statusz='',bizomanyos='', ar=0, vevo_kod=0, bizonylatszam='',dupla='DEL*' WHERE statusz='DEL*'";
Line #93:// mysql_query($query);
Line #94:
Line #95:
Line #96:
Line #97:
Line #98:
Line #99:
Line #100:
Line #101:?>