QJ_jogEDIT.inc
Line #0:<?php
Line #1:$wjid=$_GET[wjid];
Line #2:$sqlfile=$_SESSION['sqlfile'];
Line #3:$sqlfile="temaop";
Line #4:
Line #5:$prgcall=$_SESSION['prgcall'];
Line #6:$prgframe=$_SESSION['prgframe'];
Line #7:
Line #8:if ($wjid==-1 or $wjid==-2)
Line #9:{
Line #10:
Line #11:if ($wjid==-2) {
Line #12:
Line #13:$newcim = "INSERT INTO `$sqlfile`
Line #14:( `usr_kod`
Line #15:) VALUES
Line #16:( '$_SESSION[Qusr_kod]'
Line #17:)";
Line #18:echo ($newcim);
Line #19:} else {
Line #20:$newcim = "INSERT INTO `$sqlfile`
Line #21:( `usr_kod`,`regdate`
Line #22:) VALUES
Line #23:( '$_SESSION[Qusr_kod]',now()
Line #24:)";
Line #25:}
Line #26:
Line #27:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #28:
Line #29://if ($wjid==-2) exit;
Line #30://include ("gvarlist.php");
Line #31:
Line #32:$keres = "SELECT * FROM $sqlfile order by wid DESC";
Line #33:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #34:
Line #35:$cim_sor = mysql_fetch_array( $csor );
Line #36:$wjid=$cim_sor[wid];
Line #37:
Line #38:}
Line #39:
Line #40:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #41:
Line #42:$fid='';
Line #43:
Line #44:
Line #45:while ($row =mysql_fetch_row($eredmeny))
Line #46:{
Line #47:
Line #48: $fid.=$row[0] . ":";
Line #49:}
Line #50:
Line #51:
Line #52:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #53:
Line #54://BI_alert($keres);
Line #55:
Line #56:
Line #57:
Line #58:
Line #59:$h=split(':',$fid);
Line #60:$nur=count($h)-1;
Line #61:
Line #62:
Line #63:
Line #64:if ($_POST[W])
Line #65:{
Line #66:
Line #67:$W=$_POST[W];
Line #68:
Line #69:$parancs = "UPDATE ".$sqlfile." SET logtime=now(), ";
Line #70:
Line #71:$vesszo='';
Line #72:$mail="";
Line #73:
Line #74:for($j=1;$j<$nur;$j++)
Line #75:
Line #76:{
Line #77:
Line #78:
Line #79: if (strpos('?'.$h[$j],"login")>0 and $W[$j]<>"BI(c)")
Line #80: $mail="bene.istvan@maxin.hu";
Line #81:
Line #82:
Line #83: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #84: $vesszo=', ';
Line #85:
Line #86:}
Line #87:$parancs .= ", logtime=now() WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #88:
Line #89://BI_alert($parancs);
Line #90:
Line #91:if ($mail<>"")
Line #92:{
Line #93:$fejlec = "From: ".$_SESSION[Qusr_kod]." \n";
Line #94:$fejlec .= "Mime-Version: 1.0\n";
Line #95:$fejlec .= "Content-Type: text/html; charset=iso-8859-2\n";
Line #96:mail("$mail", $_SESSION[Qusr_kod]."-eMemo:$wjid", "$parancs", $fejlec);
Line #97:
Line #98:echo "<script language = javascript>";
Line #99:
Line #100:echo "</script>";
Line #101:
Line #102:}
Line #103:
Line #104:
Line #105:
Line #106:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #107:
Line #108: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #109:
Line #110:
Line #111:
Line #112:
Line #113:
Line #114://$_SESSION['cimind']=$wjid;
Line #115:
Line #116:
Line #117:echo "<script language = javascript>";
Line #118:echo "window.open('".$prgcall."', '".$prgframe."');";
Line #119:///////echo "document.location='exit.php';";
Line #120:echo "document.location='QJ_falaz.php';";
Line #121:echo "</script>";
Line #122:
Line #123:
Line #124: }
Line #125:
Line #126:
Line #127:
Line #128:
Line #129:
Line #130:$bup="<FORM name=orderby action='QJ_falUPD.php?&sqlfile=$sqlfile&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #131:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #132:$bup.="<td align=left>";
Line #133:
Line #134:$bup.="<td align=center>RecNo:$wjid";
Line #135:$bup.='
Line #136: <a target=infoframe href="QJ_attach.php?&wjid='.$wjid.'&tabla=ml_szoba">
Line #137: <img src="../_Screen/attachment.png" border=0></a>';
Line #138:
Line #139:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #140:$bup.="</td></tr>";
Line #141:
Line #142://BI_alert($bup);
Line #143:
Line #144:$r=mysql_fetch_row($eredmeny);
Line #145:
Line #146://BI_alert($nur);
Line #147:
Line #148:for($j=1;$j<$nur;$j++)
Line #149:
Line #150:{
Line #151:
Line #152: $bum='W['.$j.']';
Line #153:
Line #154: if (strpos('?'.$h[$j],"_kod")>0 or
Line #155: strpos('?'.$h[$j],"time")>0 or
Line #156: strpos('?'.$h[$j],"login")>0 or
Line #157: strpos('?'.$h[$j],"date")>0
Line #158: ) $ronly="readonly style='background-color:silver; '"; else $ronly="";
Line #159:
Line #160: if (strpos('?'.$h[$j],"usr_kod")>0 ) $value="MK12"; else $value=trim($r[$j]);
Line #161: if (strpos('?'.$h[$j],"login")>0 ) $value=$_SESSION['login']; else $value=trim($r[$j]);
Line #162: if (strpos('?'.$h[$j],"url_kod")>0 ) $url=trim($r[$j]);
Line #163:// $bup.=$bum.'/';
Line #164:
Line #165:// $bup .= '<td with=50> '.$h[$j].' </td>';
Line #166:
Line #167:
Line #168: if (strpos('?'.$h[$j],"memo")>0)
Line #169:
Line #170: $bup.="<tr><td align=right>".$h[$j]."</td><td>
Line #171: <TEXTAREA NAME = '$bum' COLS = 50 ROWS = 10 style='background-color:#EDE275; font-size:20px;'>$value</TEXTAREA>
Line #172: </td></tr>";
Line #173:
Line #174: else
Line #175:
Line #176: $bup.="<tr><td align=right>".$h[$j]."</td><td><input $ronly type='text' size=50 value='".$value."' name='".$bum."'></td></tr>";
Line #177:
Line #178:}
Line #179:
Line #180:
Line #181://BI_alert($bup);
Line #182:
Line #183:$bup.="</table></form>";
Line #184:
Line #185:echo($bup);
Line #186:
Line #187:
Line #188://ECHO("<br><img src='./FalS/".$url."' border=0 >");
Line #189:
Line #190:if ($url=="") $url="ures.gif";
Line #191:
Line #192: echo "<script language = javascript>";
Line #193:// echo "alert('QJ_imgVIEW.php?&url=./FalS/".$url."');";
Line #194: echo "window.open('QJ_imgVIEW.php?&url=./FalS/".$url."', 'infoframe');";
Line #195: echo "</script>";
Line #196:
Line #197:
Line #198:
Line #199:
Line #200:
Line #201: function Bi_back($bi_msg)
Line #202: ////////
Line #203: {
Line #204:
Line #205:// history.go(-1)
Line #206:// history.back(2);
Line #207://echo('<SCRIPT LANGUAGE="JavaScript">alert("'.$bi_msg.'"); history.go(-2); </script>');
Line #208:echo('<SCRIPT LANGUAGE="JavaScript"> history.go(-2); </script>');
Line #209:
Line #210: }
Line #211:
Line #212:
Line #213:?>