QJ_musorEDIT.inc

---

Line #0:<?php
Line #1:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #2:$sqlfile="qj_musor";
Line #3:
Line #4:
Line #5: $mentve="";
Line #6://include ("gvarlist.php");
Line #7:
Line #8:
Line #9:if ($wjid==-1 or isset($_POST[dupla]))
Line #10:{
Line #11:
Line #12:$newcim = "INSERT INTO `$sqlfile`
Line #13:( `usr_kod`
Line #14:) VALUES
Line #15:( '$_SESSION[Qusr_kod]'
Line #16:)";
Line #17:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #18:
Line #19:$keres = "SELECT * FROM `$sqlfile` order by wid DESC";
Line #20:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #21:
Line #22:$cim_sor = mysql_fetch_array( $csor );
Line #23:$wjid=$cim_sor[wid];
Line #24:}
Line #25:
Line #26:
Line #27:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #28:
Line #29:$fid='';
Line #30:
Line #31:
Line #32:while ($row =mysql_fetch_row($eredmeny))
Line #33:{
Line #34:
Line #35: $fid.=$row[0] . ":";
Line #36:}
Line #37:
Line #38:
Line #39:if (isset( $_SESSION[evad]))
Line #40:
Line #41:
Line #42:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #43:
Line #44://BI_alert($keres);
Line #45:
Line #46:
Line #47:
Line #48:
Line #49:$h=split(':',$fid);
Line #50:$nur=count($h)-1;
Line #51:
Line #52:
Line #53:
Line #54:if ($_POST[W] or isset($_POST[dupla]))
Line #55:{
Line #56:
Line #57:$W=$_POST[W];
Line #58:
Line #59:$parancs = "UPDATE ".$sqlfile." SET ";
Line #60:
Line #61:$vesszo='';
Line #62:
Line #63:for($j=1;$j<$nur;$j++)
Line #64:
Line #65:{
Line #66:
Line #67:
Line #68:// if (isset($_POST[dupla]) and isset( $_SESSION[evad]) and $h[$j]=="szoveg" and $W[$j]=="" )
Line #69: if (isset( $_SESSION[evad]) and $h[$j]=="szoveg" and $W[$j]=="" )
Line #70:
Line #71:
Line #72: if (isset($_POST[dupla]) and $h[$j]=="usr_kod") $W[$j]=$_SESSION[Qusr_kod];
Line #73: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #74: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #75: $vesszo=', ';
Line #76:
Line #77:}
Line #78:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #79:
Line #80://BI_alert($parancs);
Line #81:
Line #82:
Line #83:
Line #84:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #85:
Line #86: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #87:
Line #88:
Line #89:
Line #90:
Line #91:$ido=date("H:i:s");
Line #92:$mentve="<font color=blue>Adatok mentve !!! $ido </font><br>";
Line #93:
Line #94:echo('<SCRIPT Language="Javascript">
Line #95:///////////////////////////////////////
Line #96:window.open("QJ_musorCREATEview.php", "infoframe");
Line #97:///////////////////////////////////////
Line #98:</script>');
Line #99:
Line #100:
Line #101: }
Line #102:
Line #103:
Line #104://echo("<a href=javascript:history.back()>Vissza...</a>");
Line #105://echo("<a href=javascript:window.close()>Vissza...</a>");
Line #106:
Line #107:
Line #108:$bup="<FORM name=orderby action='QJ_musorEDIT.php?&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #109:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #110:$bup.="<td align=left>";
Line #111:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'></td>";
Line #112:$bup.="<td align=center colspan=4><b>$sqlfile / WID:$wjid</b>";
Line #113:$bup.="<input type='hidden' value='$_GET[evad]' name='evad'>";
Line #114:$bup.="<input type='hidden' value='$h[0]' name='Wjid'> </td>";
Line #115:
Line #116:$bup.="<td align=center colspan=4><b>$mentve</b>";
Line #117:$bup.="</td></tr><tr>";
Line #118:
Line #119://BI_alert($bup);
Line #120:
Line #121:$r=mysql_fetch_row($eredmeny);
Line #122:
Line #123://BI_alert($nur);
Line #124:$tr="</tr><tr>";
Line #125:$tr="";
Line #126:$colspan="";
Line #127:$size=5;
Line #128:
Line #129:for($j=1;$j<$nur;$j++)
Line #130:
Line #131:{
Line #132:
Line #133: $bum='W['.$j.']';
Line #134:
Line #135: if (strpos($h[$j],"_url")>0) $ir=false; else $ir=true;
Line #136: if (strpos($h[$j],"_datum")>0) $ir=false;
Line #137: if (strpos($h[$j],"_keszlet")>0) $ir=false;
Line #138: if (strpos($h[$j],"_height")>0) $ir=false;
Line #139: if (strpos($h[$j],"_with")>0) $ir=false;
Line #140: if ($h[$j]=="alapar1") { $tr=""; $size=5; $colspan="";}
Line #141: if ($h[$j]=="AFA") { $size=10; $tr="</tr><tr>"; }
Line #142: if ($h[$j]=="datum") { $tr=""; $size=30; $colspan=" colspan=3 ";}
Line #143: if ($h[$j]=="future") { $size=5; $tr="</tr><tr>"; }
Line #144: if ($h[$j]=="berlet_mid") { $tr="</tr><tr>"; }
Line #145: if ($h[$j]=="Adoszam") { $size=15; $tr=""; }
Line #146:
Line #147:
Line #148: if ($h[$j]=="berlet_nev") { $size=20; $tr="</tr><tr>"; }
Line #149: if ($h[$j]=="alapar5") { $size=5; $tr="</tr><tr>"; $colspan="";}
Line #150: if ($h[$j]=="alapar6") { $size=5; $tr=""; }
Line #151: if ($h[$j]=="web") { $tr="</tr><tr>"; }
Line #152: if ($h[$j]=="datum_kod") { $size=10; $tr="</tr><tr>"; }
Line #153: if ($h[$j]=="jegy_col") { $size=5; $tr=""; $colspan="";}
Line #154:
Line #155: if ($h[$j]=="datum_fej") {$size=10; $tr="</tr><tr>"; }
Line #156: if ($h[$j]=="cim") { $size=50; $colspan=" colspan=16 ";}
Line #157:
Line #158:
Line #159:// if (strpos($h[$j],"_kod")>0 or
Line #160:// strpos($h[$j],"time")>0 ) $ronly="readonly"; else $ronly="";
Line #161:
Line #162:// $bup.=$bum.'/';
Line #163:
Line #164:// $bup .= '<td with=50>&nbsp;'.$h[$j].'&nbsp;</td>';
Line #165:
Line #166:
Line #167: if ($ir==true)
Line #168: $bup.="<td align=right>".$h[$j]."</td><td $colspan ><input $ronly type='text' size=$size value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #169:
Line #170: if ($h[$j]=="erkezesi") { $tr=""; }
Line #171:
Line #172:
Line #173:}
Line #174:
Line #175:
Line #176://BI_alert($bup);
Line #177:
Line #178:$bup.="</tr></table></form>";
Line #179:
Line #180:echo($bup);
Line #181:
Line #182:
Line #183:
Line #184: function Bi_back($bi_msg)
Line #185: ////////
Line #186: {
Line #187:
Line #188:// history.go(-1)
Line #189:// history.back(2);
Line #190://echo('<SCRIPT LANGUAGE="JavaScript">alert("'.$bi_msg.'"); history.go(-2); </script>');
Line #191:
Line #192://echo('<SCRIPT LANGUAGE="JavaScript"> history.go(-2); </script>');
Line #193:
Line #194://echo('< a href="javascript:window.opener='x';window.close();">Close< /a>');
Line #195:echo('<SCRIPT LANGUAGE="JavaScript"> window.opener="x"; window.close();</script>');
Line #196:
Line #197: }
Line #198:
Line #199:
Line #200:
Line #201:
Line #202:
Line #203:
Line #204:?>