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
BiC_ViewTable_Based.inc
aktuális könyvtár:/home/ebonnhu1/cvteszt/_inc_BI_BasedBiC_ViewTable_Based.inc
___0 # <?php // include("QJ_start.php");
___1 #
___2 # if (isset($_GET[sql]) and !isset($_POST[Bis])){
___3 # $_GET[sql]= str_replace("!", " ",$_GET[sql]);
___4 # $_GET[Bis]=$_GET[sql];
___5 # // echo $_GET[sql]."<hr>";
___6 # }
___7 #
___8 # $url1="BiViewTable.php?&tabla=".$_GET[tabla];
___9 #
__10 # if (isset($_GET[dbname])) {
__11 # include("bilib.ini");
__12 # $database = $_GET[dbname]; // Database Name
__13 #
__14 # $kapcsolat=mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");
__15 #
__16 #
__17 #
__18 # //include("gvarlist.php");
__19 # if ( ! $kapcsolat )
__20 #
__21 # mysql_select_db( $database )
__22 # or die ( "Nem lehet megnyitni".mysql_errno() );
__23 #
__24 # @mysql_query('SET CHARACTER SET latin2');
__25 # @mysql_query("SET NAMES 'latin2'");
__26 # }
__27 #
__28 # if (isset($_GET[bimod])) { $_GET[Desc]="*"; $_GET[biord]="wid";}
__29 #
__30 # if (isset($_GET[goon])) $_POST[goon]=$_GET[goon];
__31 # if (isset($_GET[Desc])) $_POST[Desc]=$_GET[Desc];
__32 # if (isset($_GET[Bis])) $_POST[Bis]=$_GET[Bis];
__33 # if (isset($_GET[Export])) $_POST[Export]=$_GET[Export];
__34 # if (isset($_GET[biord])) $_POST[biord]=$_GET[biord];
__35 # if (isset($_GET[Limit])) $_POST[Limit]=$_GET[Limit];
__36 # if (!isset($_POST[Limit])) $_POST[Limit]=50;
__37 #
__38 # $_POST[Bis]=trim($_POST[Bis]);
__39 #
__40 #
__41 #
__42 # //$url1="Bic_ViewTable.php?&tabla=".$_GET[tabla];
__43 #
__44 # //if (isset($_GET[dbname])) $url1.="&dbname=".$_GET[dbname];
__45 # $url2="bisqlupd.php?&sqlfile=&wjid=-1";
__46 #
__47 # ?>
__48 #
__49 # <BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
__50 #
__51 # <FORM name=cimform action='' method='post'>
__52 # <INPUT
__53 # TYPE='text' NAME='Bis' size=100
__54 # STYLE='{color : red; background-color:beige; font-size: 14px; font-weight: bold;'
__55 # value='<?php if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
__56 # >
__57 #
__58 # <br>
__59 #
__60 # onchange=this.form.submit(); return true name='Bis'>
__61 #
__62 # <INPUT TYPE='CHECKBOX' NAME='Export' Title='' value=''
__63 #
__64 #
__65 # Limit:
__66 #
__67 # TYPE='text' NAME='Limit' size=5 STYLE='{color : red; background-color:beige; font-size: 14px; font-weight: bold;'
__68 # value='<?php if (isset($_POST[Limit])) echo($_POST[Limit]); ?>'
__69 # >
__70 #
__71 # <INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
__72 # <? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
__73 # > Sorrend<?if (isset($_POST[Desc])) echo("(S)");?>
__74 # Keres:
__75 # <INPUT TYPE='CHECKBOX' NAME='Torol' Title='' value=''
__76 #
__77 #
__78 # <INPUT TYPE='hidden' NAME='tabla' value='<? echo($_GET[tabla]); ?>'
__79 # >
__80 # <br>
__81 # <?
__82 #
__83 # $Viewpar="";
__84 # $Limit=" Limit ".$_POST[Limit];
__85 # //// IDEIGLENES ///
__86 # //$_POST[Desc]="Y";
__87 #
__88 # if (isset($_POST[Del])) $Viewpar.="&Del=Y";
__89 # if (isset($_POST[Desc])) $Viewpar.="&Desc=Y";
__90 # //if (isset($_POST[Export])) { $Viewpar.="&Export=Y"; $Limit=""; }
__91 # if (isset($_POST[Export])) $Viewpar.="&Export=Y";
__92 # if (isset($_POST[Last])) $Viewpar.="&Last=".$_POST[Last];
__93 # if (isset($_POST[Limit])) $Viewpar.="&Limit=".$_POST[Limit];
__94 # if (isset($_POST[Bis])) $Viewpar.="&Bis=".trim($_POST[Bis]);
__95 # if (isset($_POST[Modate])) $Viewpar.="&Modate=".$_POST[Modate];
__96 #
__97 # $ParHead="";
__98 # $export=false;
__99 # $tabla=$_GET["tabla"];
_100 # $biord="";
_101 #
_102 # // echo "<script language = javascript>";
_103 # // echo "alert('".$Viewpar."');";
_104 # // echo "</script>";
_105 #
_106 # //echo "<script language = javascript>";
_107 #
_108 # //echo "</script>";
_109 #
_110 # $_SESSION['sqlfile']=$tabla;
_111 #
_112 # //echo("<a target=NEWframe href='bisqlupd.php?&sqlfile=&wjid=-1'
_113 #
_114 #
_115 # if (isset($_POST[Last])) {
_116 #
_117 # }
_118 #
_119 # if (isset($_POST[Desc])) {
_120 #
_121 # }
_122 #
_123 # if (isset($_POST["biord"])) {
_124 # $biord= " order by ".$_POST["biord"];
_125 # if (isset($_POST[Desc])) {
_126 #
_127 # $biord.=" DESC";
_128 # }
_129 # }
_130 #
_131 # if (isset($_GET[dbname])) $biord="";
_132 #
_133 # if (isset($_POST[Del])) {
_134 #
_135 # $Viewpar.="&Del=*";
_136 # }
_137 #
_138 # if (isset($_POST[Export])) {
_139 #
_140 # $export=true;
_141 # }
_142 #
_143 # ECHO('<html>
_144 # <title>'. $tabla.' </title>
_145 # ');
_146 #
_147 # if ($export==false)
_148 # $ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr><td></td>';
_149 # else
_150 # $ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr>';
_151 #
_152 # $fullRec="CONCAT_WS(";
_153 # $vesszo="";
_154 # $fid='';
_155 #
_156 # $eredmeny = mysql_query('show fields from '.$tabla);
_157 #
_158 # while ($row =mysql_fetch_row($eredmeny))
_159 # {
_160 # $fid.=$row[0] . ":";
_161 #
_162 # if ($export==false)
_163 # $ee .= '<td with=50><b><a href="'.$url1.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
_164 # else
_165 # $ee .= '<td with=50><b>'.$row[0].'</b></td>';
_166 #
_167 #
_168 # $fullRec.=$vesszo."(".$row[0].")";
_169 # $vesszo=",'/', ";
_170 #
_171 # }
_172 #
_173 # $full=$fullRec.")";
_174 #
_175 # $fullRec.=") as full";
_176 # $fid.="full:";
_177 #
_178 # if (isset($_POST[Bis]) and $_POST[Bis]<>"") $wer=" Where INSTR((".$full."),'".($_POST[Bis])."') "; else $wer="";
_179 #
_180 # if (strpos('?'.$fid,"deleted")>0) $totolve="deleted=0";
_181 # if (strpos('?'.$fid,"torolve")>0) $totolve="torolve=0";
_182 #
_183 # if (isset($_POST[Del])) {
_184 #
_185 # if ($wer<>"")
_186 # $wer.= " and ".$totolve;
_187 # else
_188 # $wer.= " Where ".$totolve;
_189 # }
_190 #
_191 # if (isset($_POST[Modate])) {
_192 #
_193 # if (strpos('?'.$fid,"sync_date")>0)
_194 # $datumscan="INSTR((sync_date),'".($_POST[Modate])."') ";
_195 # else
_196 # $datumscan="INSTR((".$full."),'".($_POST[Modate])."') ";
_197 #
_198 # if ($wer<>"")
_199 # $wer.= " and " .$datumscan;
_200 # else
_201 # $wer.= " Where ".$datumscan;
_202 #
_203 # }
_204 #
_205 # if (isset($_POST[Last]) and strpos("?".$fid,"sync_id")>0) {
_206 #
_207 # if ($wer<>"")
_208 # $wer.= " and sync_id=".$_POST[Last];
_209 # else
_210 # $wer.= " Where sync_id=".$_POST[Last];
_211 # }
_212 #
_213 #
_214 # $ee .= '</tr>';
_215 #
_216 #
_217 # if (substr($_POST[Bis],0,2)=="//" and strlen($_POST[Bis])>4) {
_218 #
_219 # // $sqlwer= str_replace("~", "'",$_POST[Bis]);
_220 # $sqlwer= str_replace("~", "'",substr($_POST[Bis],2,strlen($_POST[Bis])-2));
_221 # $sqlwer= str_replace("!", " ",$sqlwer);
_222 # // Use of the count parameter is available as of PHP 5.0.0
_223 # //$str = str_replace("ll", "", "good golly miss molly!", $count);
_224 # //echo $count; // 2
_225 #
_226 #
_227 # // echo "<script language = javascript>";
_228 # // echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
_229 # // echo "</script>";
_230 #
_231 #
_232 #
_233 # if (isset($_POST[Torol])) {
_234 # $keres = "Delete FROM " . $tabla . " where ".$sqlwer;
_235 # //?//
_236 # if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_237 # $retval = mysql_query( $keres );
_238 # }
_239 #
_240 # $keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
_241 #
_242 # print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
_243 #
_244 # $nurL=mysql_num_rows($eredmeny);
_245 # $nur=$nurL;
_246 # $Limit="";
_247 # $biord="";
_248 #
_249 # ////////
_250 # } else {
_251 # ////////
_252 #
_253 # if (isset($_POST[Torol])) {
_254 # $keres = "Delete FROM " . $tabla . $wer . $biord . $Limit;
_255 # //?//
_256 # if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_257 # $retval = mysql_query( $keres );
_258 # }
_259 #
_260 # $keres = "SELECT * FROM " . $tabla . $wer . $biord;
_261 #
_262 # $nurL=mysql_num_rows($eredmeny);
_263 # $keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
_264 #
_265 # $nur=mysql_num_rows($eredmeny);
_266 #
_267 #
_268 #
_269 # }
_270 #
_271 #
_272 #
_273 #
_274 # ///////////////////////////////////
_275 # //echo("<hr>".$keres."<hr>");
_276 # ///////////////////////////////////
_277 #
_278 # if ($nurL<1001) $Limit="";
_279 #
_280 #
_281 # '</font></b><hr>';
_282 #
_283 # $head=$head.'<b>'.($tabla).
_284 # '</b> Reccount:<b> '.$nurL.
_285 # '</b> <font color=blue> <b>'.$biord.
_286 # '</b> <b>'.$Limit.
_287 # '</b></font><br></table>';
_288 #
_289 # if (!$nur) {
_290 #
_291 # $ee =$head.$ee. '</table>';
_292 # echo($ee);
_293 #
_294 #
_295 #
_296 # exit;
_297 # }
_298 #
_299 # $ii=0;
_300 #
_301 # $h=split(':',$fid);
_302 #
_303 # $e= $head.$ee;
_304 #
_305 #
_306 # if ($nur>1000) $nur=1000;
_307 #
_308 #
_309 # for($i=0;$i<$nur;$i++) {
_310 #
_311 # $r=mysql_fetch_row($eredmeny);
_312 #
_313 # $ii++;
_314 # // $e .= '<tr bgcolor="#A7C2B3"><td bgcolor=gold>'.$i.'</td>';
_315 # $e .= '<tr bgcolor="#A7C2B3">';
_316 #
_317 # if ($export==false)
_318 # $e .= '<td>
_319 # <A STYLE="{vlink : gold}" target=infoframe
_320 # href="BI_ediTable.php?&wjid='.$r[0].'&sqlfile='.$tabla.'">
_321 # <IMG width=20 height=20 SRC="../../_Screen_Based/edit.png" border=0></a>
_322 # ';
_323 #
_324 # if ($export==false)
_325 # $e .= '
_326 # <A STYLE="{vlink : gold}" target=infoframe
_327 # href="BI_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
_328 # <IMG width=20 height=20 SRC="../../_Screen_Based/plus.ico" border=0></a>
_329 # </td>';
_330 #
_331 # for($j=0,$k=0;$j<count($r);$j++) {
_332 # $e .= '<td with=50> '.htmlspecialchars($r[$j]).' </td>';
_333 # }
_334 # $e .= '</tr>';
_335 #
_336 # if ($ii==50 and $export==false) {
_337 # $e .= '</table>';
_338 # echo($e);
_339 # $ii=0;
_340 # $e=$ee;
_341 # }
_342 #
_343 # }
_344 #
_345 # $e .= '</table>';
_346 # echo($e);
_347 #
_348 # echo($e);
_349 #
_350 # //mysql_free_result ($eredmeny);
_351 # //include ("gvarlist.php");
_352 # ///////
_353 # /// BiViewTable.php /// 2009.09.07. 10:58:30
_354 # ?>
_355 #
_356 # </body>