QQ_musorFROMeloadas.inc

---

Line #0:<?php
Line #1:if (isset($_SESSION['Dump'])) echo("QJEGY`2013v3.01 QQ_musorFROMeloadas.inc *** ACTION =".$L_PHP." <hr>");
Line #2://if (isset($_SESSION['Dump'])) { include("../_inc_QJ/QQ_varlist.php"); }
Line #3:
Line #4://if (!isset($_SESSION['SEL_filename'])) $sqlfile="qj_musor"; else $sqlfile=$_SESSION['SEL_filename'];
Line #5:$sqlfile="qj_musor";
Line #6:
Line #7:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=-1;
Line #8:
Line #9:$keres = "SELECT * FROM $sqlfile WHERE cim_kod='$_POST[QS_cim]'" ;
Line #10:// archiv<>'*' and future<>'*' and NEM LEHET !!! MASZK IS 2014.06.26. 1:12:19
Line #11:$keres = "SELECT * FROM $sqlfile WHERE cim='$_POST[QS_cim]' order by wid DESC" ;
Line #12:if (isset($_SESSION['Dump'])) echo($keres."~~~~~~~~~~ <hr>");
Line #13:
Line #14:
Line #15:$disC = mysql_fetch_array( $csor );
Line #16:$nur=mysql_num_rows($csor);
Line #17:
Line #18:if ($nur<>0) $wjid=$disC[wid]; else $wjid=-1;
Line #19:if (isset($_SESSION['Dump'])) echo($disC[cim]."~~~~~$wjid~~~~~~~ <hr>");
Line #20:
Line #21:$new=false;
Line #22:if ($wjid==-1 or $wjid==0)
Line #23:{
Line #24:$new=true;
Line #25:
Line #26:$keres = "SELECT * FROM $sqlfile WHERE usr_kod='*DEL' limit 1" ;
Line #27:
Line #28:$nur=mysql_num_rows($csor);
Line #29:
Line #30:
Line #31:
Line #32:$ido=time();
Line #33:if ($nur==0) {
Line #34:$newcim = "INSERT INTO `$sqlfile`
Line #35:( `usr_kod`
Line #36:) VALUES
Line #37:( '*DEL'
Line #38:)";
Line #39:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #40:
Line #41:$keres = "SELECT * FROM $sqlfile order by wid DESC limit 1";
Line #42:$keres = "SELECT * FROM $sqlfile WHERE usr_kod='*DEL' limit 1" ;
Line #43:
Line #44://?//if (isset($_SESSION['Dump']))
Line #45:echo($keres."<hr>");
Line #46:
Line #47:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #48:
Line #49:}
Line #50:
Line #51:$cim_sor = mysql_fetch_array( $csor );
Line #52:$wjid=$cim_sor[wid];
Line #53:
Line #54:$parancs = "UPDATE $sqlfile SET ";
Line #55://$parancs .= " nev='',uzenet='',usr_kod='$_SESSION[Qusr_kod]' ,logtime=now() WHERE wid='$wjid' LIMIT 1" ;
Line #56:$parancs .= " usr_kod='$_SESSION[Qusr_kod]' ,logtime=now() WHERE wid='$wjid' LIMIT 1" ;
Line #57://?//
Line #58:if (isset($_SESSION['Dump'])) echo($parancs."<hr>");
Line #59:
Line #60:
Line #61:
Line #62:
Line #63:}
Line #64:
Line #65:
Line #66:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #67:
Line #68:$fid='';
Line #69:
Line #70:
Line #71:while ($row =mysql_fetch_row($eredmeny))
Line #72:{
Line #73:
Line #74: $fid.=$row[0] . ":";
Line #75:}
Line #76:
Line #77:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #78:
Line #79:
Line #80:$h=split(':',$fid);
Line #81:$nur=count($h)-1;
Line #82:
Line #83:
Line #84:
Line #85:if ($_POST[W])
Line #86:
Line #87:{
Line #88:
Line #89:$W=$_POST[W];
Line #90:
Line #91:$parancs = "UPDATE ".$sqlfile." SET ";
Line #92:
Line #93:$vesszo='';
Line #94:
Line #95:for($j=1;$j<$nur;$j++)
Line #96:
Line #97:{
Line #98:
Line #99: if ($h[$j]=="archiv") $W[$j]="";
Line #100: if ($h[$j]=="future") $W[$j]="";
Line #101:
Line #102: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #103: $vesszo=', ';
Line #104:
Line #105:}
Line #106:
Line #107:$parancs .= " ,usr_kod='$_SESSION[Qusr_kod]' WHERE wid ='$wjid' " ;
Line #108:
Line #109:if (isset($_POST[DEL])) {
Line #110:
Line #111:$parancs = "UPDATE $sqlfile SET usr_kod='*DEL' ,logtime=now() WHERE wid ='$wjid' LIMIT 1" ;
Line #112:}
Line #113:
Line #114:
Line #115://BI_alert($parancs);
Line #116:
Line #117:
Line #118://if (isset($_POST[kosar])) {
Line #119:echo "<script language = javascript>";
Line #120://echo "window.open('QJ_kijelol.php', 'infoframe');";
Line #121:
Line #122:echo("alert('//?//');");
Line #123:
Line #124://?//echo "window.open('QQ_submenu.php', 'infoframe');";
Line #125://?//echo "window.open('QQ_musorNAPTAR.php', 'sframe');";
Line #126:echo "</script>";
Line #127://exit;
Line #128://}
Line #129:
Line #130:
Line #131: mysql_query ($parancs) or die ($parancs." SQL HIBA ".mysql_error());
Line #132:
Line #133:if (isset($_SESSION['Dump'])) echo($parancs."+++++++++++<hr>");
Line #134:
Line #135: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #136:
Line #137:
Line #138:if (isset($_SESSION['Dump'])) echo($keres."---**** END**-----<hr>");
Line #139:
Line #140:
Line #141: }
Line #142:
Line #143:
Line #144:include('../_inc_QJ/QQ_musorUPDform.inc');
Line #145:
Line #146:?>