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_ViewTable_20151020.inc
aktuális könyvtár:/home/ebonnhu1/cvteszt/_inc_BI_Based_BI_ViewTable_20151020.inc
___0 # <?php // include("QJ_start.php");
___1 #
___2 #
___3 # $url1="BiViewTable.php?&tabla=".$_GET[tabla];
___4 #
___5 # if (isset($_GET[dbname])) {
___6 # include("bilib.ini");
___7 # $database = $_GET[dbname]; // Database Name
___8 #
___9 # $kapcsolat=mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");
__10 #
__11 #
__12 #
__13 # //include("gvarlist.php");
__14 # if ( ! $kapcsolat )
__15 #
__16 # mysql_select_db( $database )
__17 # or die ( "Nem lehet megnyitni".mysql_errno() );
__18 #
__19 # @mysql_query('SET CHARACTER SET latin2');
__20 # @mysql_query("SET NAMES 'latin2'");
__21 # }
__22 #
__23 # $alma="???";
__24 # if (isset($_POST[Bis])) {$alma=$_POST[Bis]."=P:Bis/".$_GET[Bis]."=G:Bis/G:sql=".$_GET[sql]; $_GET[Bis]=$_POST[Bis]; $_GET[sql]=$_POST[Bis]; }
__25 #
__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 #
__35 # if (isset($_POST[dump])) {
__36 # if(isset($_SESSION[dump])) unset($_SESSION[dump]); else $_SESSION[dump]="Y";
__37 # }
__38 #
__39 # if (isset($_POST[WhereSave]) and isset($_POST[wherememo]) and $_POST[wherememo]<>"" ) {
__40 # //wid / widarc / usr_kod / szoveg / archiv / future / sql_memo / sql_parancs / sql_title / sql_jpg / logtime /
__41 # $keres = "select * from qj_sql where szoveg= 'WhereSave' and sql_parancs='$_POST[Bis]' and sql_title='$_GET[tabla]'";
__42 #
__43 # $nurL=mysql_num_rows($eredmeny);
__44 # if ($nurL==0) {
__45 # $newrec = "INSERT INTO `qj_sql`
__46 # ( `usr_kod`,`szoveg`,`sql_memo`,`sql_parancs`,`sql_title`
__47 # ) VALUES
__48 # ( '$_SESSION[Qusr_kod]','WhereSave','$_POST[wherememo]','$_POST[Bis]','$_GET[tabla]'
__49 # )";
__50 # mysql_query($newrec) or die($newrec." Hiba az insertben");
__51 # echo '<script>
__52 # alert("MENTVE!'.$_POST[Bis].'");
__53 # </script>';
__54 # }
__55 # }
__56 #
__57 # if (isset($_GET[biord])) $_POST[biord]=$_GET[biord];
__58 # if (isset($_GET[Limit])) $_POST[Limit]=$_GET[Limit];
__59 # if (!isset($_POST[Limit])) $_POST[Limit]=50;
__60 #
__61 # if (!isset($_SESSION[frame1])) $_SESSION[frame1]="adatframe";
__62 # if (!isset($_SESSION[frame2])) $_SESSION[frame2]="infoframe";
__63 #
__64 #
__65 # if (isset($_POST[frame1])){ $frame1=$_POST[frame1]; $_SESSION[frame1]=$frame1;} else $frame1=$_SESSION[frame1];
__66 # if (isset($_POST[frame2])){ $frame2=$_POST[frame2]; $_SESSION[frame2]=$frame2;} else $frame2=$_SESSION[frame2];
__67 #
__68 # if ($frame1<>"") $frame1T=" target=$frame1 "; else $frame1T="";
__69 # if ($frame2<>"") $frame2T=" target=$frame2 "; else $frame2T="";
__70 #
__71 #
__72 #
__73 # //$_POST[Bis]=trim($_POST[Bis]);
__74 # if (isset($_GET[sql])) {
__75 # $_POST[Bis]=str_replace("!"," ",$_GET[sql]);
__76 # }
__77 #
__78 # //$url1="Bic_ViewTable.php?&tabla=".$_GET[tabla];
__79 #
__80 # //if (isset($_GET[dbname])) $url1.="&dbname=".$_GET[dbname];
__81 # $url2="bisqlupd.php?&sqlfile=&wjid=-1";
__82 #
__83 #
__84 #
__85 # echo("");
__86 #
__87 # ?>
__88 #
__89 # <BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
__90 # <FORM name=cimform action='' method='post'>
__91 #
__92 # <a target=infoframe href='BI_ViewWhere.php'
__93 #
__94 #
__95 #
__96 # onchange=this.form.submit(); return true name='submit'><br>
__97 #
__98 #
__99 # <INPUT
_100 # TYPE='text' NAME='Bis' size=50
_101 # STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_102 # value='<?php if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
_103 # >
_104 #
_105 # <br>
_106 #
_107 # <INPUT TYPE='CHECKBOX' NAME='Export' Title='' value=''
_108 #
_109 #
_110 # <INPUT TYPE='CHECKBOX' NAME='dump' Title='' value=''
_111 # > Dump
_112 #
_113 # <INPUT TYPE='CHECKBOX' NAME='sqlexport' Title='' value=''
_114 # > SQL
_115 #
_116 # <INPUT TYPE='CHECKBOX' NAME='WhereSave' Title='' value=''
_117 # > WhereSave
_118 #
_119 # Limit:
_120 #
_121 # TYPE='text' NAME='Limit' size=5 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_122 # value='<?php if (isset($_POST[Limit])) echo($_POST[Limit]); ?>'
_123 # >
_124 #
_125 #
_126 #
_127 # <INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
_128 # <? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
_129 # > Sorrend<?if (isset($_POST[Desc])) echo("(S)");?>
_130 # <!--- Keres:
_131 # <INPUT TYPE='CHECKBOX' NAME='Torol' Title='' value=''
_132 #
_133 #
_134 # <INPUT TYPE='hidden' NAME='tabla' value='<? echo($_GET[tabla]); ?>'
_135 # >
_136 # <br>
_137 # <?php
_138 #
_139 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_140 # echo("<INPUT TYPE='text' NAME='frame1' size=8 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_141 # value='$frame1'> ");
_142 # echo("<INPUT TYPE='text' NAME='frame2' size=8 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_143 # value='$frame2'>");
_144 # echo("
_145 # <INPUT TYPE='text' NAME='wherememo' size=20 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_146 # value=''><hr>
_147 # ");
_148 # }
_149 #
_150 # $Viewpar="";
_151 # $Limit=" Limit ".$_POST[Limit];
_152 # //// IDEIGLENES /// <b>$alma</b><hr>
_153 # //$_POST[Desc]="Y";
_154 #
_155 # if (isset($_POST[Del])) $Viewpar.="&Del=Y";
_156 # if (isset($_POST[Desc])) $Viewpar.="&Desc=Y";
_157 # //if (isset($_POST[Export])) { $Viewpar.="&Export=Y"; $Limit=""; }
_158 # if (isset($_POST[Export])) $Viewpar.="&Export=Y";
_159 # if (isset($_POST[Last])) $Viewpar.="&Last=".$_POST[Last];
_160 # if (isset($_POST[Limit])) $Viewpar.="&Limit=".$_POST[Limit];
_161 # if (isset($_POST[Bis])) $Viewpar.="&Bis=".trim($_POST[Bis]);
_162 # if (isset($_POST[Modate])) $Viewpar.="&Modate=".$_POST[Modate];
_163 #
_164 # $ParHead="";
_165 # $export=false;
_166 # $tabla=$_GET["tabla"];
_167 # $biord="";
_168 #
_169 # // echo "<script language = javascript>";
_170 # // echo "alert('".$Viewpar."');";
_171 # // echo "</script>";
_172 #
_173 # //echo "<script language = javascript>";
_174 #
_175 # //echo "</script>";
_176 #
_177 # $_SESSION['sqlfile']=$tabla;
_178 #
_179 # //echo("<a target=NEWframe href='bisqlupd.php?&sqlfile=&wjid=-1'
_180 #
_181 #
_182 # if (isset($_POST[Last])) {
_183 #
_184 # }
_185 #
_186 # if (isset($_POST[Desc])) {
_187 #
_188 # }
_189 #
_190 # if (isset($_POST["biord"])) {
_191 # $biord= " order by ".$_POST["biord"];
_192 # if (isset($_POST[Desc])) {
_193 #
_194 # $biord.=" DESC";
_195 # }
_196 # }
_197 #
_198 # if (isset($_GET[dbname])) $biord="";
_199 #
_200 # if (isset($_POST[Del])) {
_201 #
_202 # $Viewpar.="&Del=*";
_203 # }
_204 #
_205 # if (isset($_POST[Export])) {
_206 #
_207 # $export=true;
_208 # }
_209 #
_210 # ECHO('<html>
_211 # <title>'. $tabla.' </title>
_212 # ');
_213 #
_214 # if ($export==false)
_215 # $ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr><td></td>';
_216 # else
_217 # $ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr>';
_218 #
_219 # $fullRec="CONCAT_WS(";
_220 # $vesszo="";
_221 # $fid='';
_222 #
_223 # $mezok='';
_224 #
_225 # $eredmeny = mysql_query('show fields from '.$tabla);
_226 #
_227 # while ($row =mysql_fetch_row($eredmeny))
_228 # {
_229 # $fid.=$row[0] . ":";
_230 # $mezok.=$row[0] . " / ";
_231 #
_232 # if ($export==false)
_233 # $ee .= '<td with=50><b><a href="'.$url1.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
_234 # else
_235 # $ee .= '<td with=50><b>'.$row[0].'</b></td>';
_236 #
_237 #
_238 # $fullRec.=$vesszo."(".$row[0].")";
_239 # $vesszo=",'/', ";
_240 #
_241 # }
_242 #
_243 # $full=$fullRec.")";
_244 #
_245 # $fullRec.=") as full";
_246 # $fid.="full:";
_247 #
_248 # if (isset($_POST[Bis]) and $_POST[Bis]<>"") $wer=" Where INSTR((".$full."),'".($_POST[Bis])."') "; else $wer="";
_249 #
_250 # if (strpos('?'.$fid,"deleted")>0) $totolve="deleted=0";
_251 # if (strpos('?'.$fid,"torolve")>0) $totolve="torolve=0";
_252 #
_253 # if (isset($_POST[Del])) {
_254 #
_255 # if ($wer<>"")
_256 # $wer.= " and ".$totolve;
_257 # else
_258 # $wer.= " Where ".$totolve;
_259 # }
_260 #
_261 # if (isset($_POST[Modate])) {
_262 #
_263 # if (strpos('?'.$fid,"sync_date")>0)
_264 # $datumscan="INSTR((sync_date),'".($_POST[Modate])."') ";
_265 # else
_266 # $datumscan="INSTR((".$full."),'".($_POST[Modate])."') ";
_267 #
_268 # if ($wer<>"")
_269 # $wer.= " and " .$datumscan;
_270 # else
_271 # $wer.= " Where ".$datumscan;
_272 #
_273 # }
_274 #
_275 # if (isset($_POST[Last]) and strpos("?".$fid,"sync_id")>0) {
_276 #
_277 # if ($wer<>"")
_278 # $wer.= " and sync_id=".$_POST[Last];
_279 # else
_280 # $wer.= " Where sync_id=".$_POST[Last];
_281 # }
_282 #
_283 #
_284 # $ee .= '</tr>';
_285 #
_286 # if (substr($_POST[Bis],0,2)=="//" and strlen($_POST[Bis])>4) {
_287 #
_288 # $sqlwer= str_replace("~", "'",substr($_POST[Bis],2,strlen($_POST[Bis])-2));
_289 # // Use of the count parameter is available as of PHP 5.0.0
_290 # //$str = str_replace("ll", "", "good golly miss molly!", $count);
_291 # //echo $count; // 2
_292 #
_293 #
_294 # // echo "<script language = javascript>";
_295 # // echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
_296 # // echo "</script>";
_297 #
_298 #
_299 #
_300 # if (isset($_POST[Torol])) {
_301 # $keres = "Delete FROM " . $tabla . " where ".$sqlwer;
_302 # //?//if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_303 # $retval = mysql_query( $keres );
_304 # }
_305 #
_306 # $keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
_307 #
_308 # print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
_309 #
_310 # $nurL=mysql_num_rows($eredmeny);
_311 # $nur=$nurL;
_312 # $Limit="";
_313 # $biord="";
_314 #
_315 # // echo("<hr>then<hr>");
_316 #
_317 # ////////
_318 # } else {
_319 # ////////
_320 #
_321 # // echo("<hr>else<hr>");
_322 #
_323 # if (isset($_POST[Torol])) {
_324 # $keres = "Delete FROM " . $tabla . $wer . $biord . $Limit;
_325 # //?//if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_326 # $retval = mysql_query( $keres );
_327 # }
_328 #
_329 # if ($wer=="") {
_330 #
_331 # }
_332 #
_333 # // echo("~>>>~~/$wer/~~~~/$tabla/~~~/$biord/~~~~~/$Limit/~~~~~~~~~~~~~~~~~~~");
_334 #
_335 # $keres = "SELECT * FROM " . $tabla . $wer . $biord;
_336 #
_337 # $nurL=mysql_num_rows($eredmeny);
_338 # $keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
_339 #
_340 # $nur=mysql_num_rows($eredmeny);
_341 #
_342 # }
_343 #
_344 #
_345 #
_346 #
_347 # ///////////////////////////////////
_348 # //echo("<hr>".$keres."<hr>");
_349 # ///////////////////////////////////
_350 #
_351 # if ($nurL<1001) $Limit="";
_352 #
_353 #
_354 # '</font></b><hr>';
_355 #
_356 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_357 # $head.='<FONT size=+1 color=RED>DUMP</font><br>';
_358 #
_359 # $head.=$mezok.'<hr>';
_360 #
_361 #
_362 # }
_363 #
_364 # $head=$head.'<b>'.($tabla).
_365 # '</b> Reccount:<b> '.$nurL.
_366 # '</b> <font color=blue> <b>'.$biord.
_367 # '</b> <b>'.$Limit.
_368 # '</b></font><br></table>';
_369 #
_370 # if (!$nur) {
_371 #
_372 # $ee =$head.$ee. '</table>';
_373 # echo($ee);
_374 #
_375 #
_376 #
_377 # exit;
_378 # }
_379 #
_380 #
_381 #
_382 # if (isset($_POST[sqlexport]))
_383 # {
_384 #
_385 # $myFile = $_SESSION['sqlfile'].date("Ymd_His")."_view.SQL";
_386 # $fh = fopen($myFile, 'w') or die("can't open file");
_387 #
_388 # echo ("<Hr>~~~~~~~~~~~~~~~~SQL EXPORT START~~~~~~~$myFile~~~~~~~<br>");
_389 # $h=split(':',$fid);
_390 #
_391 #
_392 # while ($row =mysql_fetch_row($eredmeny))
_393 # {
_394 #
_395 # $parancs = "REPLACE INTO ".$_GET[tabla]. " ";
_396 #
_397 # $vesszo='';
_398 # $mezok="(";
_399 # $adatok="(";
_400 #
_401 # for($j=1;$j<$nur;$j++)
_402 #
_403 # {
_404 #
_405 # // $parancs .=$vesszo.$h[$j]."='".$row[$j]."' ";
_406 # $mezok .=$vesszo."`".$h[$j]."`" ;
_407 # $adatok .=$vesszo." '".$row[$j]."'";
_408 # $vesszo=', ';
_409 #
_410 # }
_411 #
_412 # $parancs .= $mezok." ) VALUES ".CHR(10). $adatok." );" ;
_413 #
_414 # $stringData=htmlspecialchars($parancs).CHR(10);
_415 # echo (htmlspecialchars($parancs).'<br>');
_416 #
_417 # fwrite($fh, $stringData);
_418 #
_419 #
_420 # }
_421 #
_422 #
_423 # fclose($fh);
_424 #
_425 #
_426 # echo ('<br>~~~~~~~~~~~~~~~~SQL EXPORT END~~~~~~~~~~~~~~<hr>');
_427 #
_428 # exit;
_429 #
_430 #
_431 # /*echo "<script language = javascript>
_432 # window.open('BiCopyTable.php?tabla=qj_sql&submenu=".$_POST[submenu]."', $frame1);
_433 # </script>"; */
_434 # }
_435 #
_436 #
_437 # $ii=0;
_438 #
_439 # $h=split(':',$fid);
_440 #
_441 # $e= $head.$ee;
_442 #
_443 #
_444 # if ($nur>1000) $nur=1000;
_445 #
_446 #
_447 # for($i=0;$i<$nur;$i++) {
_448 #
_449 # $r=mysql_fetch_row($eredmeny);
_450 #
_451 # $ii++;
_452 # // $e .= '<tr bgcolor="#A7C2B3"><td bgcolor=gold>'.$i.'</td>';
_453 # $e .= '<tr bgcolor="#A7C2B3">';
_454 #
_455 # IF ($_SESSION[login]=="BI(c)")
_456 # $szek_kod="<a target=infoframe href='QJ_sqlJEGY.php?¶ncs=Update!qj_jegy!$set!$wer'>$egy_sor[szek_kod]</a>";
_457 # else $szek_kod=$egy_sor[szek_kod];
_458 # /*
_459 # if ($export==false)
_460 # $e .= '<td>
_461 # <A '. $frame1T .' STYLE="{vlink : gold}" target=adatframe
_462 # href="_Q_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
_463 # <IMG width=20 height=20 SRC="../_Screen/edit.png" border=0></a>
_464 # ';
_465 # */
_466 #
_467 # $set="set!archiv=~?~,!".
_468 # "szoveg=~?~,!arkategoria=~?~,!".
_469 # "QJ_sor_n=~?~,!QJ_sor_s=~?~,!".
_470 # "QJ_sor_o=~?~,!QJ_sor_h=~?~!";
_471 #
_472 # $wer="where!&wjid=$r[0]";
_473 #
_474 # if ($export==false)
_475 # $e .= "<td>
_476 # <A $frame1T
_477 # href='QJ_sqlJEGY.php?¶ncs=Update!$tabla!$set!$wer'>
_478 # <IMG width=20 height=20 SRC='../_Screen/sql.png' border=0></a>
_479 # ";
_480 #
_481 # if ($export==false)
_482 # $e .= '
_483 # <A '. $frame2T .'
_484 # href="BI_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
_485 # <IMG width=20 height=20 SRC="../_Screen/edit.png" border=0></a>
_486 # </td>';
_487 #
_488 # for($j=0,$k=0;$j<count($r);$j++) {
_489 #
_490 # $e .= '<td with=50> '.$r[$j].' </td>';
_491 #
_492 # }
_493 # $e .= '</tr>';
_494 #
_495 # if ($ii==50 and $export==false) {
_496 # $e .= '</table>';
_497 # echo($e);
_498 # $ii=0;
_499 # $e=$ee;
_500 # }
_501 #
_502 # }
_503 #
_504 # $e .= '</table>';
_505 # echo($e);
_506 #
_507 # echo($e);
_508 #
_509 # //mysql_free_result ($eredmeny);
_510 # //
_511 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_512 # include ("../../_inc_QJ_Based/_Q_varlist.php");
_513 # }
_514 #
_515 # ///////
_516 # /// BiViewTable.php /// 2009.09.07. 10:58:30
_517 # ?>
_518 #
_519 # </body>