Warning: include(QJ_start.php): failed to open stream: No such file or directory in /home/ebonnhu1/cvteszt/_inc_BI_Based/biedit.php on line 1
Warning: include(): Failed opening 'QJ_start.php' for inclusion (include_path='.:/opt/remi/php56/root/usr/share/pear:/opt/remi/php56/root/usr/share/php:/usr/share/pear:/usr/share/php') in /home/ebonnhu1/cvteszt/_inc_BI_Based/biedit.php on line 1
SWC-BiEdit
_BI_sqlRECopy_20160107.inc
aktuális könyvtár:/home/ebonnhu1/cvteszt/_inc_BI_Based_BI_sqlRECopy_20160107.inc
___0 # <?php include("QJ_start.php"); //_inc_BI// 2012.10.28. 18:38:38 // 2015.04.29. 8:27:50
___1 #
___2 # $szin=" bgcolor='gold' ";
___3 #
___4 # if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
___5 #
___6 # if (isset($_GET[sqlfile])) $sqlfile=$_GET[sqlfile]; else
___7 # if (isset($_GET[tabla])) $sqlfile=$_GET[tabla]; else
___8 # if (isset($_POST[tabla])) $sqlfile=$_POST[tabla];
___9 #
__10 # if (isset($_POST[Qszin]) and $_POST[Qszin]=="yellow" ) $Qszin="silver"; else $Qszin="yellow";
__11 #
__12 # //BI_alert($sqlfile);
__13 #
__14 # $szin=" bgcolor='".$Qszin."' ";
__15 # if (isset($_POST[dupla])) $szin=" bgcolor='aqua' ";
__16 #
__17 # if ($wjid==-1 or isset($_POST[dupla]))
__18 # {
__19 #
__20 # $szin=" bgcolor='aqua' ";
__21 #
__22 #
__23 # $newcim = "INSERT INTO `$sqlfile`
__24 # ( `usr_kod`
__25 # ) VALUES
__26 # ( '$_SESSION[Qusr_kod]'
__27 # )";
__28 # mysql_query($newcim) or die($newcim."Hiba a $sqlfile insertben");
__29 #
__30 # $keres = "SELECT * FROM `$sqlfile` order by wid DESC";
__31 # $csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
__32 #
__33 # $cim_sor = mysql_fetch_array( $csor );
__34 # $wjid=$cim_sor[wid];
__35 # }
__36 #
__37 # $eredmeny = mysql_query('show fields from '.$sqlfile);
__38 # $fid='';
__39 #
__40 # while ($row =mysql_fetch_row($eredmeny))
__41 # {
__42 # $fid.=$row[0] . ":";
__43 # }
__44 #
__45 # $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
__46 #
__47 #
__48 # $h=split(':',$fid);
__49 # $nur=count($h)-1;
__50 #
__51 # if ($_POST[W] or isset($_POST[dupla]))
__52 # {
__53 #
__54 #
__55 # $W=$_POST[W];
__56 # $parancs = "UPDATE ".$sqlfile." SET ";
__57 # $vesszo='';
__58 #
__59 # for($j=1;$j<$nur;$j++)
__60 # {
__61 #
__62 # if (isset($_POST[dupla]) and $h[$j]=="datum_kod") $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
__63 # $adat=str_replace("'","~",$W[$j]);
__64 # // $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
__65 # $parancs .=$vesszo.$h[$j]."='".$adat."' ";
__66 # $vesszo=', ';
__67 # }
__68 # $parancs .= " WHERE wid ='$wjid' LIMIT 1" ;
__69 #
__70 # //BI_alert($parancs);
__71 #
__72 #
__73 #
__74 # // echo ($parancs.'<br>'.mysql_error().'<br>');
__75 # $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
__76 #
__77 # }
__78 #
__79 # $Qkeres = "SELECT wid FROM " . $sqlfile;
__80 #
__81 # $nurL=mysql_num_rows($Qeredmeny);
__82 #
__83 # //?//echo("<a href=javascript:window.close()><font color=blue size=+4>Vissza...</a>");
__84 #
__85 # $bup="<FORM name=orderby action='BI_sqlRECopy.php?&wjid=$wjid&tabla=$sqlfile&sqlfile=$sqlfile' method='post'>";
__86 # //$bup="<FORM name=orderby action='../".$_SESSION['Qpath']."/BI_sqlRECopy.php?&wjid=$wjid&tabla=$sqlfile&sqlfile=$sqlfile' method='post'>";
__87 #
__88 # $bup.="<table border=1 $szin>";
__89 # //$bup.="<td align=left >";
__90 # $bup.="<tr><td align=right><input type='submit' value='>>>> Ment >>>>' name='submit'>
__91 # </td>";
__92 # $bup.="<td ><b><font color=blue size=+1> $sqlfile:<font color=blue size=+2>$wjid</font><font color=red size=+2>/$nurL</font></b>";
__93 # $bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
__94 # $bup.="<input type='hidden' value='$Qszin' name='Qszin'>";
__95 #
__96 # $bup.="
__97 #
__98 # $bup.="</table>
__99 # <table border=1 align=left $szin>";
_100 #
_101 # $r=mysql_fetch_row($eredmeny);
_102 #
_103 # $tr="</tr><tr>";
_104 # $colspan="";
_105 #
_106 # $trDB=0;
_107 # $tdSize=10;
_108 # if (strpos($szin,'silver')>0) $szin2=" bgcolor='gold' "; else $szin2=" bgcolor='LightCyan' "; // " bgcolor='".$Qszin."' ";
_109 #
_110 #
_111 # for($j=1;$j<$nur;$j++)
_112 #
_113 # {
_114 #
_115 # $bum='W['.$j.']';
_116 #
_117 #
_118 # if (strpos($h[$j],"memo")>0 or strpos($h[$j],"parancs")>0 or $SLEN>50 or strpos('?'.$h[$j],"sql_")>0 or
_119 # strpos($h[$j],"_Title")>0 or strpos($h[$j],"_jpg")>0) $tarea="Y"; else $tarea="N";
_120 #
_121 # if (strpos('?'.$h[$j],"datum")>0) $tfont="<font color=red>"; else $tfont="<font>";
_122 # if (strpos('?'.$h[$j],"cim")>0) $tfont="<font color=green>";
_123 #
_124 # if ($SLEN>3 or $trDB>2 or $tarea=="Y" OR !isset($_SESSION[dump]))
_125 # {
_126 # $tr="</tr></table><table border=1 $szin><tr>"; // <table border=1><td>??????</td></table> <td bgcolor=aqua>$SLEN/$trDB/$tarea</td> <td > </td>"; align=center
_127 # $trDB=0;
_128 # if ($SLEN<10) $tdSize=20; else $tdSize=50;
_129 # $colspan="";
_130 # }else {
_131 # $tr="";
_132 # ++$trDB;
_133 # $tdSize=10;
_134 # $colspan=" width=10 ";
_135 # }
_136 # //?//if (strpos($h[$j],"memo")>0 or strpos($h[$j],"parancs")>0 or $SLEN>30 or strpos('?'.$h[$j],"sql_")>0 or $tarea
_137 # //?// strpos($h[$j],"_Title")>0 or strpos($h[$j],"_jpg")>0) { align=right
_138 # //?// <div style="width:50px;overflow: hidden;">
_139 # //?// <span>A long string more than 50px wide</span>
_140 # //?// </div>
_141 # //?// td {
_142 # //?// width: 30px
_143 # //?// max-width: 30px;
_144 # //?// overflow: hidden;
_145 # //?// }
_146 # /*
_147 # <style type="text/css">
_148 #
_149 # table {
_150 # border-collapse: collapse;
_151 # margin: 20px 100px;
_152 # }
_153 #
_154 # td {
_155 # width: 100px;
_156 # height: 93px;
_157 # font: 8pt verdana;
_158 # text-align: center;
_159 # margin: 0px;
_160 # padding: 1px;
_161 # }
_162 #
_163 # td.normal {
_164 # background: #eef;
_165 # }
_166 #
_167 # td.outlined {
_168 # border: 1px black solid;
_169 # background: #efe;
_170 # }
_171 #
_172 # a.block:link {
_173 # display: block;
_174 # width: 100%;
_175 # height: 100%;
_176 # color: black;
_177 # text-decoration: none;
_178 # }
_179 #
_180 # a.block:visited {
_181 # display: block;
_182 # width: 100%;
_183 # height: 100%;
_184 # color: black;
_185 # text-decoration: none;
_186 # }
_187 #
_188 # a.block:hover {
_189 # color: white;
_190 # background: black;
_191 # }
_192 #
_193 # </style>
_194 # */
_195 # if ($tarea=="Y") {
_196 # if ($SLEN<100) $Arow=1; else $Arow=5;
_197 # $bup.=$tr."<tr><td bgcolor=$Fszin ><div style='width:150px;'> $tfont<b>".$h[$j].
_198 # "</b></font></div></td><td bgcolor=Pink><textarea style='font: 12pt verdana; background-color: Pink;' rows=$Arow cols=100 name='".$bum."'>".$r[$j]."</textarea></td>";
_199 # $trDB=100;
_200 # } else {
_201 # //?// $bup.="<td align=right width=10 bgcolor=silver>$tdSize ".$h[$j]."</td><td $colspan bgcolor=aqua >$SLEN / $colspan <input $ronly type='text' size=$tdSize value='".$r[$j]."' name='".$bum."'></td>".$tr;
_202 # $bup.=$tr."<td $szin2><div style='width:150px;'> $tfont<b>".$h[$j].
_203 # "</b></font></div></td><td $colspan ><input $ronly type='text' size=$tdSize value='".$r[$j]."' name='".$bum."'></td>";
_204 # }
_205 # }
_206 # $bup.="</tr></table></form>";
_207 # echo($bup);
_208 # //?//echo("<a href=javascript:window.close()><font color=blue size=+4>Vissza...</a>");
_209 # ?>