QQ_szekINSERT.inc

---

Line #0:<?php
Line #1:
Line #2:if (isset($_SESSION['Dump'])) echo("QJEGY`2013v3.01 QQ_szekINSERT.inc *** ACTION =".$L_PHP." <hr>");
Line #3:
Line #4:$Sfilter='?';
Line #5:if (isset($_SESSION['Dump'])) include("../_inc_QJ/QQ_varlist.php");
Line #6:
Line #7:
Line #8:$hely_kod=$_GET[hely_kod];
Line #9:$datum_kod=$_GET[datum_kod];
Line #10:
Line #11:$sor_kod=$_GET[sor_kod];
Line #12:$tol=substr('000'.$_GET[tol],-3);
Line #13:
Line #14:$ig=$_GET[ig];
Line #15:$beszur=$_GET[beszur];
Line #16:
Line #17:$Qwer=str_replace("~","'", $_SESSION[Qwer]);
Line #18:
Line #19:$i=0;
Line #20:
Line #21:$parancs="SELECT * FROM qj_jegy where $Qwer hely_kod='$hely_kod' and datum_kod='$datum_kod' and left(szek_kod,3)='$sor_kod' and szek_kod>='$sor_kod/$tol' and szek_kod<='$sor_kod/$ig' ORDER BY szek_kod DESC";
Line #22:
Line #23:if (isset($_SESSION[QSQL_run])) unset($_SESSION[QSQL_run]); else $_SESSION[QSQL_run]=$parancs;
Line #24:
Line #25:
Line #26:
Line #27://if (isset($_SESSION['Dump']))
Line #28:echo ($sor."/".$_GET[kozep]."/".$_GET[oldal]."/".$parancs."<hr>");
Line #29:
Line #30:while ( $disC = mysql_fetch_array( $disQ )) {
Line #31:
Line #32: $wid=$disC[wid];
Line #33: $sz_kod=substr($disC[szek_kod],4,3);
Line #34: $sz_kod=$sz_kod+$beszur;
Line #35: $szek_kod=substr('000'.$sor_kod,-3)."/".substr('000'.$sz_kod,-3);
Line #36:
Line #37:$newrec = "UPDATE qj_jegy SET szek_kod='$szek_kod', logtime=logtime WHERE wid=".$wid. " Limit 1 " ;
Line #38:
Line #39: $vegrehajtva=" CONTROLL SQL".date("Y.m.d H:s:m");
Line #40:
Line #41:if (isset($_SESSION[QSQL_run])) {
Line #42: mysql_query($newrec) or die($newrec." Hiba");
Line #43:
Line #44:}
Line #45:
Line #46:++$i;
Line #47:echo ($i.". ".$vegrehajtva.$disC[szoveg]."/".$disC[szek_kod]."<br>".$newrec."<hr>");
Line #48:
Line #49:}
Line #50:
Line #51:
Line #52:if (isset($_SESSION[QSQL_run]))
Line #53:
Line #54:else
Line #55:echo ($i.". KONTROLL!<hr>");
Line #56:
Line #57:
Line #58:?>