QJ_earCOPY.inc

---

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #3:if (isset($_GET[wnew])) $wnew=$_GET[wnew]; else $wnew=$_POST[wnew];
Line #4:$sqlfile="qj_ear";
Line #5:
Line #6://if (isset($_POST[dupla])) echo("DUPLA<hr>");
Line #7://include ("gvarlist.php");
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:
Line #28:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #29:
Line #30:$fid='';
Line #31:
Line #32:
Line #33:while ($row =mysql_fetch_row($eredmeny))
Line #34:{
Line #35:
Line #36: $fid.=$row[0] . ":";
Line #37:}
Line #38:
Line #39:
Line #40:$keres = "SELECT * FROM qj_ear WHERE wid=".$wjid;
Line #41:
Line #42://BI_alert($keres);
Line #43:
Line #44:
Line #45:
Line #46:
Line #47:$h=split(':',$fid);
Line #48:$nur=count($h)-1;
Line #49:
Line #50:if ($_POST[W] or isset($_POST[dupla]))
Line #51:{
Line #52:
Line #53:if (isset($_POST[dupla])) echo("DUPLA<hr>");
Line #54:
Line #55:$W=$_POST[W];
Line #56:
Line #57:$parancs = "UPDATE qj_ear SET ";
Line #58:
Line #59:$vesszo='';
Line #60:$dk='';
Line #61:
Line #62:for($j=1;$j<$nur;$j++)
Line #63:
Line #64:{
Line #65:
Line #66:
Line #67: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") {
Line #68: $dk=$W[$j];
Line #69: $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #70: if (isset($_GET[wnew])) $W[$j]=$_GET[wnew];
Line #71: }
Line #72: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #73: $vesszo=', ';
Line #74:
Line #75:}
Line #76:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #77:
Line #78:
Line #79:
Line #80: echo ($parancs.'<br>'.mysql_error().'<br>');
Line #81:
Line #82: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #83:
Line #84:
Line #85:/*echo('<SCRIPT Language="Javascript">
Line #86:///////////////////////////////////////
Line #87:window.open("QJ_musorCREATEview.php", "infoframe");
Line #88:///////////////////////////////////////
Line #89:</script>');*/
Line #90:
Line #91: }
Line #92:
Line #93:
Line #94://echo("<a href=javascript:history.back()>Vissza...</a>");
Line #95:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #96:
Line #97:$bup="<FORM name=orderby action='QJ_earCOPY.php?&wnew=$wnew&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #98:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #99:$bup.="<td align=left>";
Line #100:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'></td>";
Line #101:$bup.="<td align=center colspan=4><b>$sqlfile / WID:$wjid</b>";
Line #102:$bup.="<input type='hidden' value='$h[0]' name='Wjid'></td>";
Line #103:
Line #104:$bup.="</td></tr><tr>";
Line #105:
Line #106://BI_alert($bup);
Line #107:
Line #108:$r=mysql_fetch_row($eredmeny);
Line #109:
Line #110://BI_alert($nur);
Line #111:$tr="</tr><tr>";
Line #112:$tr="";
Line #113:$colspan="";
Line #114:$size=15;
Line #115:
Line #116:for($j=1;$j<$nur;$j++)
Line #117:
Line #118:{
Line #119:
Line #120: $bum='W['.$j.']';
Line #121:
Line #122: if (strpos($h[$j],"_url")>0) $ir=false; else $ir=true;
Line #123: if (strpos($h[$j],"_datum")>0) $ir=false;
Line #124: if (strpos($h[$j],"_keszlet")>0) $ir=false;
Line #125: if (strpos($h[$j],"_height")>0) $ir=false;
Line #126: if (strpos($h[$j],"_with")>0) $ir=false;
Line #127: if ($h[$j]=="alapar1") { $tr=""; $size=5; $colspan="";}
Line #128: if ($h[$j]=="AFA") { $tr="</tr><tr>"; }
Line #129: if ($h[$j]=="datum") { $tr=""; $size=20; $colspan=" colspan=3 ";}
Line #130: if ($h[$j]=="datum_kod") { $tr="</tr><tr>"; }
Line #131: if ($h[$j]=="future") { $tr="</tr><tr>"; }
Line #132: if ($h[$j]=="erkezesi") { $tr="</tr><tr>"; }
Line #133: if ($h[$j]=="datum_fej") { $tr="</tr><tr>"; }
Line #134: if ($h[$j]=="cim") { $size=50; $colspan=" colspan=16 ";}
Line #135: if ($h[$j]=="datum") { $size=50; $colspan=" colspan=16 ";}
Line #136:
Line #137: if ($ir==true)
Line #138: $bup.="<td align=right>".$h[$j]."</td><td $colspan ><input $ronly type='text' size=$size value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #139:
Line #140: if ($h[$j]=="erkezesi") { $tr=""; }
Line #141:
Line #142:}
Line #143:
Line #144:$bup.="</tr></table></form>";
Line #145:
Line #146:echo($bup);
Line #147:
Line #148:
Line #149:?>