Bi-Dir

QJ_reCOPY.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #4://$sqlfileINP="qj_musor";
Line #5://$sqlfileOUT="qj_musor";
Line #6:if (isset($_GET[inp])) $sqlfileINP=$_GET[inp];
Line #7:if (isset($_GET[out])) $sqlfileOUT=$_GET[out];
Line #8:
Line #9:if (isset($_POST[inp])) $sqlfileINP=$_POST[inp];
Line #10:if (isset($_POST[out])) $sqlfileOUT=$_POST[out];
Line #11:
Line #12:$sqlfile=$sqlfileINP;
Line #13:
Line #14:
Line #15://if (isset($_POST[dupla])) echo("DUPLA<hr>");
Line #16://include ("gvarlist.php");
Line #17:
Line #18:
Line #19:if ($wjid==-1 or isset($_POST[dupla]))
Line #20:{
Line #21:
Line #22:$sqlfile =$sqlfileOUT;
Line #23:$sqlfileINP=$sqlfileOUT;
Line #24:
Line #25:$newcim = "INSERT INTO `$sqlfile`
Line #26:( `usr_kod`
Line #27:) VALUES
Line #28:( '$_SESSION[Qusr_kod]'
Line #29:)";
Line #30:mysql_query($newcim) or die($newcim." Hiba azi nsertben");
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:echo('<SCRIPT Language="Javascript">
Line #40:
Line #41:///////////////////////////////////////
Line #42://window.open("QJ_musorCREATE.php?&submenu='.$submenu.'", "infoframe");
Line #43:///////////////////////////////////////
Line #44:
Line #45:</script>');
Line #46:
Line #47:}
Line #48:
Line #49:
Line #50:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #51:
Line #52:$fid='';
Line #53:
Line #54:
Line #55:while ($row =mysql_fetch_row($eredmeny))
Line #56:{
Line #57:
Line #58: $fid.=$row[0] . ":";
Line #59:}
Line #60:
Line #61:
Line #62:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #63:
Line #64://BI_alert($keres);
Line #65:
Line #66:
Line #67:
Line #68:
Line #69:$h=split(':',$fid);
Line #70:$nur=count($h)-1;
Line #71:
Line #72:
Line #73:
Line #74:if ($_POST[W] or isset($_POST[dupla]))
Line #75:{
Line #76:
Line #77:if (isset($_POST[dupla])) echo("DUPLA<hr>");
Line #78:
Line #79:$W=$_POST[W];
Line #80:
Line #81:$parancs = "UPDATE ".$sqlfile." SET ";
Line #82:
Line #83:$vesszo='';
Line #84:$dk='';
Line #85:
Line #86:for($j=1;$j<$nur;$j++)
Line #87:
Line #88:{
Line #89:
Line #90: if (isset($_POST[dupla]) and $h[$j]=="datum" and isset($_SESSION[musor_ujho]))
Line #91: $W[$j]=$_SESSION[musor_ujho];
Line #92: if (isset($_POST[dupla]) and $h[$j]=="datum_evho" and isset($_SESSION[musor_ujevho]))
Line #93: $W[$j]=$_SESSION[musor_ujevho];
Line #94:
Line #95: if (isset($_POST[dupla]) and $h[$j]=="usr_kod" ) $W[$j]=$_SESSION[Qusr_kod];
Line #96:
Line #97: if (isset($_POST[dupla]) and $h[$j]=="last_index") $W[$j]=0;
Line #98: if (isset($_POST[dupla]) and $h[$j]=="datum_url") $W[$j]=$dk;
Line #99: if (isset($_POST[dupla]) and $h[$j]=="szoveg") $submenu=$W[$j];
Line #100: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") {
Line #101: $dk=$W[$j];
Line #102: $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #103: }
Line #104: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #105: $vesszo=', ';
Line #106:
Line #107:}
Line #108:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #109:
Line #110://BI_alert($parancs);
Line #111:
Line #112:
Line #113:
Line #114: echo ($parancs.'<br>'.mysql_error().'<br>');
Line #115:
Line #116: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #117:
Line #118:
Line #119:
Line #120:
Line #121:
Line #122://window.open("QQ_submenu.php?&submenu='.$submenu.'", "infoframe");
Line #123:
Line #124:echo("<SCRIPT>
Line #125:window.open('BiViewTable.php?&bimod=y&tabla=".$_GET[out]."&sql=//szoveg=~".$submenu."~', 'sframe');
Line #126:</script>");
Line #127:
Line #128: }
Line #129:
Line #130:
Line #131://echo("<a href=javascript:history.back()>Vissza...</a>");
Line #132:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #133:
Line #134:
Line #135:$bup="<FORM name=orderby action='QJ_reCOPY.php?&wjid=$wjid&inp=$sqlfileINP&out=$sqlfileOUT' method='post'>";
Line #136:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #137:$bup.="<td align=left>";
Line #138:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'></td>";
Line #139:$bup.="<td align=center colspan=4><b>$sqlfile / WID:$wjid</b>";
Line #140:$bup.="<input type='hidden' value='$h[0]' name='Wjid'></td>";
Line #141:
Line #142:$bup.="</td></tr><tr>";
Line #143:
Line #144://BI_alert($bup);
Line #145:
Line #146:$r=mysql_fetch_row($eredmeny);
Line #147:
Line #148:$tr="</tr><tr>";
Line #149:$tr="";
Line #150:$colspan="";
Line #151:$size=5;
Line #152:
Line #153:for($j=1;$j<$nur;$j++)
Line #154:
Line #155:{
Line #156:
Line #157: $bum='W['.$j.']';
Line #158:
Line #159: if (strpos($h[$j],"_url")>0) $ir=false; else $ir=true;
Line #160: if (strpos($h[$j],"_datum")>0) $ir=false;
Line #161: if (strpos($h[$j],"_keszlet")>0) $ir=false;
Line #162: if (strpos($h[$j],"_height")>0) $ir=false;
Line #163: if (strpos($h[$j],"_with")>0) $ir=false;
Line #164: if ($h[$j]=="alapar1") { $tr=""; $size=5; $colspan="";}
Line #165: if ($h[$j]=="AFA") { $tr="</tr><tr>"; }
Line #166: if ($h[$j]=="datum") { $tr=""; $size=20; $colspan=" colspan=3 ";}
Line #167: if ($h[$j]=="sql_memodatum_kod") { $tr="</tr><tr>"; }
Line #168: if ($h[$j]=="erkezesi") { $tr="</tr><tr>"; }
Line #169: if ($h[$j]=="datum_fej") { $tr="</tr><tr>"; }
Line #170: if ($h[$j]=="cim") { $size=50; $colspan=" colspan=16 ";}
Line #171: if ($h[$j]=="datum") { $size=50; $colspan=" colspan=16 ";}
Line #172:
Line #173: if ($ir==true) {
Line #174: if (strpos('?'.$h[$j],"memo")>0 or
Line #175: strpos('?'.$h[$j],"parancs")>0
Line #176: )
Line #177: $bup.="<tr><td align=right>".$h[$j]."</td><td colspan=10>
Line #178: <TEXTAREA NAME = '$bum' COLS = 50 ROWS = 10
Line #179: style='background-color:#EDE275; font-size:20px;'>$r[$j]</TEXTAREA>
Line #180: </td></tr>";
Line #181:
Line #182: else
Line #183: $bup.="<td align=right>".$h[$j]."</td><td $colspan >
Line #184: <input $ronly type='text' size=$size value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #185: }
Line #186:
Line #187: if ($h[$j]=="erkezesi") { $tr=""; }
Line #188:
Line #189:}
Line #190:
Line #191:$bup.="</tr></table></form>";
Line #192:
Line #193:echo($bup);
Line #194:
Line #195:?>