QJ_falUPD.inc

---

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