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