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.~
aktuális könyvtár:/home/ebonnhu1/cvteszt/_inc_BI_Based_BI_ViewTable.~
___0 #
___1 # /********************************************************************************/
___2 #
___3 # -------------------------------
___4 # 2016.02.11
___5 # { 1}. //$h=split(':',$fid);
___6 #
___7 # 2016.03.11
___8 #
___9 # 2016.05.17
__10 #
__11 #
__12 # /********************************************************************************/
__13 #
__14 # //echo("~~goon:$_POST[goon]/$_GET[goon]/~~~:$_POST[Desc]/$_GET[Desc]/~~~~Export:$_POST[Export]/$_GET[Export]/~~~<hr>");
__15 #
__16 # $url1="BiViewTable.php?&tabla=".$_GET[tabla];
__17 #
__18 #
__19 # if (isset($_GET[Qusr_kod]) and $_GET[Qusr_kod]<>"") {
__20 # $usr_kod=$_GET[Qusr_kod];
__21 # include("Qjegy_ini.~~");
__22 # // include("bilib_multi.~");
__23 # // $database = $_GET[databasename]; // Database Name
__24 #
__25 # $kapcsolat=mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");
__26 #
__27 #
__28 #
__29 # //include("gvarlist.php");
__30 # if ( ! $kapcsolat )
__31 #
__32 # mysql_select_db( $database )
__33 # or die ( "Nem lehet megnyitni".mysql_errno() );
__34 #
__35 # @mysql_query('SET CHARACTER SET latin2');
__36 # @mysql_query("SET NAMES 'latin2'");
__37 #
__38 #
__39 # }
__40 # if (isset($_GET[databasename])) {
__41 # include("bilib.ini");
__42 # // include("bilib_multi.~");
__43 # $database = $_GET[databasename]; // Database Name
__44 #
__45 # $kapcsolat=mysql_connect($server, $db_user, $db_pass) or died("Database Connect Error");
__46 #
__47 #
__48 #
__49 # //include("gvarlist.php");
__50 # if ( ! $kapcsolat )
__51 #
__52 # mysql_select_db( $database )
__53 # or die ( "Nem lehet megnyitni".mysql_errno() );
__54 #
__55 # @mysql_query('SET CHARACTER SET latin2');
__56 # @mysql_query("SET NAMES 'latin2'");
__57 # }
__58 #
__59 # $alma="???";
__60 # 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]; }
__61 #
__62 # //?//if (isset($_GET[bimod])) { $_GET[Desc]="*"; $_GET[biord]="wid";}
__63 #
__64 # if (isset($_GET[goon])) $_POST[goon]=$_GET[goon];
__65 #
__66 # //?//
__67 # //if (isset($_POST[Desc]) and $_POST[Desc]=="" ) unset($_GET[Desc]);
__68 # //
__69 #
__70 # //if (isset($_GET[Desc]) and $_GET[Desc]="Y" ) $_SESSION[Desc]="Y"; else unset($_SESSION[Desc]);
__71 #
__72 # //?//
__73 # if (isset($_GET[Desc])) {
__74 # $_POST[Desc]=$_GET[Desc];
__75 # if (!isset($_GET[biord])) $_GET[biord]="wid";
__76 # }
__77 #
__78 # if (isset($_POST[Desc])) {
__79 # if ($_POST[Desc]=="Y")$_SESSION[Desc]="Y"; else unset($_SESSION[Desc]);
__80 # }
__81 #
__82 #
__83 # if (isset($_GET[Bis])) $_POST[Bis]=$_GET[Bis];
__84 # if (isset($_GET[Export])) $_POST[Export]=$_GET[Export];
__85 #
__86 # if (isset($_POST[dump])) {
__87 # if(isset($_SESSION[dump])) unset($_SESSION[dump]); else $_SESSION[dump]="Y";
__88 # }
__89 #
__90 # if (isset($_POST[WhereSave]) and isset($_POST[wherememo]) and $_POST[wherememo]<>"" ) {
__91 # //wid / widarc / usr_kod / szoveg / archiv / future / sql_memo / sql_parancs / sql_title / sql_jpg / logtime /
__92 # $keres = "select * from qj_sql where szoveg= 'WhereSave' and sql_parancs='$_POST[Bis]' and sql_title='$_GET[tabla]'";
__93 #
__94 # $nurL=mysql_num_rows($eredmeny);
__95 # if ($nurL==0) {
__96 # $newrec = "INSERT INTO `qj_sql`
__97 # ( `usr_kod`,`szoveg`,`sql_memo`,`sql_parancs`,`sql_title`
__98 # ) VALUES
__99 # ( '$_SESSION[Qusr_kod]','WhereSave','$_POST[wherememo]','$_POST[Bis]','$_GET[tabla]'
_100 # )";
_101 # mysql_query($newrec) or die($newrec." Hiba az insertben");
_102 # echo '<script>
_103 # alert("MENTVE!'.$_POST[Bis].'");
_104 # </script>';
_105 # }
_106 # }
_107 #
_108 # if (isset($_GET[biord])) $_POST[biord]=$_GET[biord];
_109 # if (isset($_GET[Limit])) $_POST[Limit]=$_GET[Limit];
_110 # if (!isset($_POST[Limit])) $_POST[Limit]=50;
_111 #
_112 # if (!isset($_SESSION[frame1])) $_SESSION[frame1]="adatframe";
_113 # if (!isset($_SESSION[frame2])) $_SESSION[frame2]="infoframe";
_114 #
_115 # if (isset($_POST[frame1])){ $frame1=$_POST[frame1]; $_SESSION[frame1]=$frame1;} else $frame1=$_SESSION[frame1];
_116 # if (isset($_POST[frame2])){ $frame2=$_POST[frame2]; $_SESSION[frame2]=$frame2;} else $frame2=$_SESSION[frame2];
_117 #
_118 # if (isset($_POST[frame])){ $frame=$_POST[frame]; $_SESSION[frame]=$frame;} else $frame=$_SESSION[frame];
_119 #
_120 # if ($frame1<>"") $frame1T=" target=$frame1 "; else $frame1T="";
_121 # if ($frame2<>"") $frame2T=" target=$frame2 "; else $frame2T="";
_122 # if ($frame<>"") $frameT=" target=$frame "; else $frameT="";
_123 #
_124 # //$_POST[Bis]=trim($_POST[Bis]);
_125 # if (isset($_GET[sql])) {
_126 # $_POST[Bis]=str_replace("!"," ",$_GET[sql]);
_127 # }
_128 #
_129 # //$url1="Bic_ViewTable.php?&tabla=".$_GET[tabla];
_130 #
_131 # //if (isset($_GET[dbname])) $url1.="&dbname=".$_GET[dbname];
_132 # $url2="bisqlupd.php?&sqlfile=&wjid=-1";
_133 #
_134 # echo("");
_135 #
_136 # if (isset($_GET[szin])) $szin=" bgcolor='$_GET[szin]' "; else $szin=" bgcolor='#DBE6E0' ";
_137 # if (isset($_GET[short])) $short=$_GET[short]; else $short="";
_138 #
_139 # //painting.png
_140 # ?>
_141 #
_142 # <BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
_143 # <FORM name=cimform <?php echo($frameT); ?> action='' method='post'>
_144 # <font color=green size=+3>ViewTable</font>
_145 # <a target=infoframe href='BI_ViewWhere.php'
_146 #
_147 #
_148 #
_149 # onchange=this.form.submit(); return true name='submit'>
_150 #
_151 #
_152 #
_153 # TYPE='text' NAME='frame' size=15 STYLE='color : blue; background-color:aqua; font-size: 14px; font-weight: bold;'
_154 # value='<?php echo($frame); ?>'
_155 # >
_156 #
_157 #
_158 # onchange=this.form.submit(); return true name='reset'>
_159 #
_160 # <br>
_161 #
_162 #
_163 # <INPUT
_164 # TYPE='text' NAME='Bis' size=140
_165 # STYLE='color : red; background-color:beige; font-size: 12px; font-weight: bold;'
_166 # value='<?php if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
_167 # >
_168 #
_169 # <br>
_170 #
_171 # <INPUT TYPE='CHECKBOX' NAME='Export' Title='' value=''
_172 #
_173 #
_174 # <INPUT TYPE='CHECKBOX' NAME='dump' Title='' value=''
_175 # > Dump
_176 #
_177 # <INPUT TYPE='CHECKBOX' NAME='sqlexport' Title='' value=''
_178 # > SQL
_179 #
_180 # <INPUT TYPE='CHECKBOX' NAME='sqlinsert' Title='' value=''
_181 # > INSERT
_182 #
_183 # <INPUT TYPE='CHECKBOX' NAME='WhereSave' Title='' value=''
_184 # > WhereSave
_185 #
_186 # Limit:
_187 #
_188 # TYPE='text' NAME='Limit' size=5 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_189 # value='<?php if (isset($_POST[Limit])) echo($_POST[Limit]); ?>'
_190 # >
_191 #
_192 #
_193 #
_194 # <INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value='Y'
_195 # <? if (isset($_SESSION[Desc])) echo(' CHECKED '); ?>
_196 # > Sorrend
_197 # <!--- Keres:
_198 # <INPUT TYPE='CHECKBOX' NAME='Torol' Title='' value=''
_199 #
_200 #
_201 # <INPUT TYPE='hidden' NAME='tabla' value='<? echo($_GET[tabla]); ?>'
_202 # >
_203 # <br>
_204 # <?php
_205 #
_206 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_207 # echo("<INPUT TYPE='text' NAME='frame1' size=8 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_208 # value='$frame1'> ");
_209 # echo("<INPUT TYPE='text' NAME='frame2' size=8 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_210 # value='$frame2'>");
_211 # echo("
_212 # <INPUT TYPE='text' NAME='wherememo' size=20 STYLE='color : red; background-color:beige; font-size: 14px; font-weight: bold;'
_213 # value=''><hr>
_214 # ");
_215 # }
_216 #
_217 # $Viewpar="";
_218 # $Limit=" Limit ".$_POST[Limit];
_219 # //// IDEIGLENES /// <b>$alma</b><hr>
_220 # //$_POST[Desc]="Y";
_221 #
_222 # if (isset($_POST[Del])) $Viewpar.="&Del=Y";
_223 # //if (isset($_POST[Desc])) $Viewpar.="&Desc=Y";
_224 # //if (isset($_POST[Export])) { $Viewpar.="&Export=Y"; $Limit=""; }
_225 # if (isset($_POST[Export])) $Viewpar.="&Export=Y";
_226 # if (isset($_POST[Last])) $Viewpar.="&Last=".$_POST[Last];
_227 # if (isset($_POST[Limit])) $Viewpar.="&Limit=".$_POST[Limit];
_228 # if (isset($_POST[Bis])) $Viewpar.="&Bis=".trim($_POST[Bis]);
_229 # if (isset($_POST[Modate])) $Viewpar.="&Modate=".$_POST[Modate];
_230 #
_231 # $ParHead="";
_232 # $export=false;
_233 # $tabla=$_GET["tabla"];
_234 # //?//$biord="";
_235 #
_236 # // echo "<script language = javascript>";
_237 # // echo "alert('".$Viewpar."');";
_238 # // echo "</script>";
_239 #
_240 # //echo "<script language = javascript>";
_241 #
_242 # //echo "</script>";
_243 #
_244 # $_SESSION['sqlfile']=$tabla;
_245 #
_246 # //echo("<a target=NEWframe href='bisqlupd.php?&sqlfile=&wjid=-1'
_247 #
_248 #
_249 # if (isset($_POST[Last])) {
_250 #
_251 # }
_252 #
_253 # if (isset($_POST[Desc])) {
_254 #
_255 # }
_256 #
_257 # if (isset($_POST["biord"])) {
_258 # $biord= " order by ".$_POST["biord"];
_259 # if (isset($_SESSION[Desc])) {
_260 #
_261 # $biord.=" DESC";
_262 # }
_263 # }
_264 #
_265 # //?//if (isset($_GET[dbname])) $biord="";
_266 #
_267 # if (isset($_POST[Del])) {
_268 #
_269 # $Viewpar.="&Del=*";
_270 # }
_271 #
_272 # if (isset($_POST[Export])) {
_273 #
_274 # $export=true;
_275 # }
_276 #
_277 # ECHO('<html>
_278 # <title>'. $tabla.' </title>
_279 # ');
_280 #
_281 # if ($export==false)
_282 # $ee="<table BORDER=1 bgcolor=silver ><tr><td></td>";
_283 # else
_284 # $ee="<table BORDER=1 bgcolor=silver ><tr>";
_285 #
_286 # $fullRec="CONCAT_WS(";
_287 # $vesszo="";
_288 # $fid='';
_289 #
_290 # $mezok='';
_291 #
_292 # $eredmeny = mysql_query('show fields from '.$tabla);
_293 #
_294 # while ($row =mysql_fetch_row($eredmeny))
_295 # {
_296 # $fid.=$row[0] . ":";
_297 # $mezok.=$row[0] . " / ";
_298 #
_299 # if ($export==false) {
_300 # //
_301 #
_302 # //if (isset($_SESSION[Desc])) $Desc="&Desc=Y"; else $Desc="";
_303 # //if (isset($_POST[Desc])) $Desc="&Desc=Y"; else $Desc="";
_304 #
_305 # $ee .= '<td with=50><b><a href="'.$url1.'&biord='.$row[0].$Viewpar.$Desc.'">'.$row[0].'</a></b></td>';
_306 # } else
_307 # $ee .= '<td with=50><b>'.$row[0].'</b></td>';
_308 # $fullRec.=$vesszo."(".$row[0].")";
_309 # $vesszo=",'/', ";
_310 # }
_311 #
_312 # $full=$fullRec.")";
_313 #
_314 # $fullRec.=") as full";
_315 # $fid.="full:";
_316 #
_317 # if (isset($_POST[Bis]) and $_POST[Bis]<>"") $wer=" Where INSTR((".$full."),'".($_POST[Bis])."') "; else $wer="";
_318 #
_319 # if (strpos('?'.$fid,"deleted")>0) $totolve="deleted=0";
_320 # if (strpos('?'.$fid,"torolve")>0) $totolve="torolve=0";
_321 #
_322 # if (isset($_POST[Del])) {
_323 #
_324 # if ($wer<>"")
_325 # $wer.= " and ".$totolve;
_326 # else
_327 # $wer.= " Where ".$totolve;
_328 # }
_329 #
_330 # if (isset($_POST[Modate])) {
_331 #
_332 # if (strpos('?'.$fid,"sync_date")>0)
_333 # $datumscan="INSTR((sync_date),'".($_POST[Modate])."') ";
_334 # else
_335 # $datumscan="INSTR((".$full."),'".($_POST[Modate])."') ";
_336 #
_337 # if ($wer<>"")
_338 # $wer.= " and " .$datumscan;
_339 # else
_340 # $wer.= " Where ".$datumscan;
_341 #
_342 # }
_343 #
_344 # if (isset($_POST[Last]) and strpos("?".$fid,"sync_id")>0) {
_345 #
_346 # if ($wer<>"")
_347 # $wer.= " and sync_id=".$_POST[Last];
_348 # else
_349 # $wer.= " Where sync_id=".$_POST[Last];
_350 # }
_351 #
_352 #
_353 # $ee .= '</tr>';
_354 #
_355 # if (substr($_POST[Bis],0,2)=="//" and strlen($_POST[Bis])>4) {
_356 #
_357 # $sqlwer= str_replace("~", "'",substr($_POST[Bis],2,strlen($_POST[Bis])-2));
_358 # // Use of the count parameter is available as of PHP 5.0.0
_359 # //$str = str_replace("ll", "", "good golly miss molly!", $count);
_360 # //echo $count; // 2
_361 #
_362 #
_363 # // echo "<script language = javascript>";
_364 # // echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
_365 # // echo "</script>";
_366 #
_367 #
_368 #
_369 # if (isset($_POST[Torol])) {
_370 # $keres = "Delete FROM " . $tabla . " where ".$sqlwer;
_371 # //?//if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_372 # $retval = mysql_query( $keres );
_373 # }
_374 #
_375 # $keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
_376 #
_377 # print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
_378 #
_379 # $nurL=mysql_num_rows($eredmeny);
_380 # $nur=$nurL;
_381 # $Limit="";
_382 # //?//$biord="";
_383 #
_384 # // echo("<hr>then<hr>");
_385 #
_386 # ////////
_387 # } else {
_388 # ////////
_389 #
_390 # // echo("<hr>else<hr>");
_391 #
_392 # if (isset($_POST[Torol])) {
_393 # $keres = "Delete FROM " . $tabla . $wer . $biord . $Limit;
_394 # //?//if (isset($_SESSION['Dump'])) echo("<hr>".$keres."<hr>");
_395 # $retval = mysql_query( $keres );
_396 # }
_397 #
_398 # /* ?????
_399 # if ($wer=="") {
_400 #
_401 # }
_402 # */
_403 #
_404 # // echo("~>>>~~/$wer/~~~~/$tabla/~~~/$biord/~~~~~/$Limit/~~~~~~~~~~~~~~~~~~~");
_405 #
_406 # $keres = "SELECT * FROM " . $tabla . $wer . $biord;
_407 #
_408 # $nurL=mysql_num_rows($eredmeny);
_409 # $keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
_410 #
_411 # $nur=mysql_num_rows($eredmeny);
_412 #
_413 # }
_414 #
_415 #
_416 #
_417 #
_418 # ///////////////////////////////////
_419 # //echo("<hr>".$keres."<hr>");
_420 # ///////////////////////////////////
_421 #
_422 # if ($nurL<1001) $Limit="";
_423 #
_424 #
_425 # '</font></b><hr>';
_426 #
_427 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_428 # $head.='<FONT size=+1 color=RED>DUMP</font><br>';
_429 #
_430 # $head.=$mezok.'<hr>';
_431 #
_432 #
_433 # }
_434 #
_435 # $head=$head.'<b>'.($tabla).
_436 # '</b> Reccount:<b> '.$nurL.
_437 # '</b> <font color=blue> <b>'.$biord.
_438 # '</b> <b>'.$Limit.
_439 # '</b></font><br></table>';
_440 #
_441 # if (!$nur) {
_442 #
_443 # $ee =$head.$ee. '</table>';
_444 # echo($ee);
_445 #
_446 #
_447 #
_448 # exit;
_449 # }
_450 #
_451 #
_452 #
_453 # if (isset($_POST[sqlexport]) or isset($_POST[sqlinsert]) )
_454 # {
_455 #
_456 # $i=0;
_457 #
_458 #
_459 #
_460 # //$h=split(':',$fid);
_461 # $h=preg_split('/[: -]/',$fid);
_462 #
_463 #
_464 #
_465 # if (isset($_POST[sqlinsert])) {
_466 #
_467 # //$h=split(':',$fid);
_468 # $h=preg_split('/[: -]/',$fid);
_469 #
_470 #
_471 # $keres = "SELECT * FROM " . $tabla ;
_472 #
_473 # $nurR=mysql_num_rows($eredmeny);
_474 #
_475 # $darabol=intval($nurR/5000)+1;
_476 #
_477 # echo ("<Hr>~~$tabla~/field:$fmax/~~~~$nurR/$darabol~~~~~~~~SQL EXPORT START~~~~~~~$myFile~~~~~~~<br>");
_478 #
_479 # for($j=0;$j<$fmax;$j++)
_480 # {
_481 # echo("~$h[$j]~/$j/~<br>");
_482 # }
_483 #
_484 # for ($di=0;$di<$darabol;$di++) {
_485 # $di1=$di*5000;
_486 # //$di2=$di*5000 + 4999;
_487 # $di2=4999;
_488 # $div=$di1+4999;
_489 #
_490 #
_491 # $keres = "SELECT * FROM " . $tabla . " limit $di1,$di2 " ;
_492 #
_493 #
_494 # $myFile = $_SESSION['sqlfile'].date("Ymd_His")."_".$di1."_".$div."._view.SQL";
_495 #
_496 # $files[$di] = $myFile;
_497 # $zipname =$_SESSION['sqlfile'].date("Ymd_His")."._view.zip";
_498 #
_499 # $fh = fopen($myFile, 'w') or die("can't open file");
_500 #
_501 # echo ("~~~~~~~~$keres~~~~~~~~~~~~$myFile~~~~~~~<br>");
_502 #
_503 #
_504 # while ($row =mysql_fetch_row($eredmeny))
_505 # {
_506 #
_507 # ++$i;
_508 #
_509 # $parancs = "INSERT INTO ".$_GET[tabla]. " ";
_510 #
_511 # $vesszo='';
_512 # $mezok="(";
_513 # $adatok="(";
_514 #
_515 # for($j=0;$j<$fmax;$j++)
_516 #
_517 # {
_518 # // $parancs .=$vesszo.$h[$j]."='".$row[$j]."' ";
_519 # if (trim($row[$j])<>"" and $row[$j]<>"0000-00-00 00:00:00" and $row[$j]<>"0" ) {
_520 # $mezok .=$vesszo."`".$h[$j]."`" ;
_521 # $adatok .=$vesszo." '".trim($row[$j])."'";
_522 # $vesszo=', ';
_523 # }
_524 # }
_525 #
_526 # //Fatal error: Maximum execution time of 120 seconds exceeded in /home/bbinfohu/public_html/2015_BBinfo/_inc_BI_Based/_BI_ViewTable.inc //on line 426
_527 #
_528 # $parancs .= $mezok." ) VALUES ".CHR(10). $adatok." );" ;
_529 #
_530 # // $stringData=htmlspecialchars($parancs).CHR(10);
_531 # // echo (htmlspecialchars($parancs).'<br>');
_532 # $stringData=$parancs.CHR(10);
_533 # // echo ($parancs.'<br>');
_534 # // echo ($i.'/');
_535 #
_536 # if (intval($i/250)*250==$i) echo ($i.'<br>');
_537 #
_538 # //::
_539 # fwrite($fh, $stringData);
_540 #
_541 # }
_542 #
_543 #
_544 # echo ("<br>~~~~~~$nur/$i~~~~~~~~~~SQL EXPORT END~~~~~~~$myFile~~~~~~~<hr>");
_545 # fclose($fh);
_546 #
_547 #
_548 # }
_549 #
_550 # $zipname=$myFile;
_551 #
_552 # //include("../../_inc_BI_Based/_BI_sqlZIP.inc");
_553 #
_554 # } else {
_555 #
_556 # $myFile = $_SESSION['sqlfile'].date("Ymd_His")."_$di($dim)"."_view.SQL";
_557 # $fh = fopen($myFile, 'w') or die("can't open file");
_558 #
_559 #
_560 # //$h=split(':',$fid);
_561 # $h=preg_split('/[: -]/',$fid);
_562 #
_563 #
_564 #
_565 # echo ($fid.'<hr>');
_566 #
_567 #
_568 # while ($row =mysql_fetch_row($eredmeny))
_569 # {
_570 #
_571 # $parancs = "REPLACE INTO ".$_GET[tabla]. " ";
_572 #
_573 # $vesszo='';
_574 # $mezok="(";
_575 # $adatok="(";
_576 #
_577 # for($j=1;$j<$SQLmax;$j++)
_578 #
_579 # {
_580 #
_581 # // $parancs .=$vesszo.$h[$j]."='".$row[$j]."' ";
_582 # $mezok .=$vesszo."`".$h[$j]."`" ;
_583 # $adatok .=$vesszo." '".$row[$j]."'";
_584 # $vesszo=', ';
_585 #
_586 # }
_587 #
_588 # $parancs .= $mezok." ) VALUES ".CHR(10). $adatok." );" ;
_589 #
_590 # // $stringData=htmlspecialchars($parancs).CHR(10);
_591 # // echo (htmlspecialchars($parancs).'<br>');
_592 # $stringData=$parancs.CHR(10);
_593 # echo ($parancs.'<br>');
_594 #
_595 # fwrite($fh, $stringData);
_596 #
_597 # }
_598 #
_599 # echo ("<br>~~~~~~$nur/$i~~~~~~~~~~SQL EXPORT END~~~~~~~$myFile~~~~~~~<hr>");
_600 # fclose($fh);
_601 #
_602 # $zipname=$myFile;
_603 #
_604 # include("../../_inc_BI_Based/_BI_sqlZIP.inc");
_605 #
_606 # }
_607 #
_608 # exit;
_609 #
_610 # /*echo "<script language = javascript>
_611 # window.open('BiCopyTable.php?tabla=qj_sql&submenu=".$_POST[submenu]."', $frame1);
_612 # </script>"; */
_613 # }
_614 #
_615 #
_616 # $ii=0;
_617 #
_618 # //$h=split(':',$fid);
_619 # $h=preg_split('/[: -]/',$fid);
_620 #
_621 # $e= $head.$ee;
_622 #
_623 #
_624 # if ($nur>1000) $nur=1000;
_625 #
_626 #
_627 # for($i=0;$i<$nur;$i++) {
_628 #
_629 # $r=mysql_fetch_row($eredmeny);
_630 #
_631 # $ii++;
_632 # // $e .= '<tr bgcolor="#A7C2B3"><td bgcolor=gold>'.$i.'</td>';
_633 # $e .= "'<tr $szin>"; #color="#A7C2B3"
_634 #
_635 # IF ($_SESSION[login]=="BI(c)")
_636 # $szek_kod="<a target=infoframe href='QJ_sqlJEGY.php?¶ncs=Update!qj_jegy!$set!$wer'>$egy_sor[szek_kod]</a>";
_637 # else $szek_kod=$egy_sor[szek_kod];
_638 # /*
_639 # if ($export==false)
_640 # $e .= '<td>
_641 # <A '. $frame1T .' STYLE="{vlink : gold}" target=adatframe
_642 # href="_Q_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
_643 # <IMG width=20 height=20 SRC="../../_Screen_Based/edit.png" border=0></a>
_644 # ';
_645 # */
_646 #
_647 # $set="set!archiv=~?~,!".
_648 # "szoveg=~?~,!arkategoria=~?~,!".
_649 # "QJ_sor_n=~?~,!QJ_sor_s=~?~,!".
_650 # "QJ_sor_o=~?~,!QJ_sor_h=~?~!";
_651 #
_652 # $wer="where!&wjid=$r[0]";
_653 #
_654 # if ($export==false)
_655 # $e .= "<td>
_656 # <A $frame1T
_657 # href='QJ_sqlJEGY.php?¶ncs=Update!$tabla!$set!$wer'>
_658 # <IMG width=20 height=20 SRC='../../_Screen_Based/sql.png' border=0></a>
_659 # ";
_660 #
_661 # if ($export==false)
_662 # $e .= '
_663 # <A '. $frame2T .'
_664 # href="BI_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
_665 # <IMG width=20 height=20 SRC="../../_Screen_Based/edit.png" border=0></a>
_666 # </td>';
_667 #
_668 # for($j=0,$k=0;$j<count($r);$j++) {
_669 #
_670 # if ($short<>""){
_671 # if (strlen($r[$j])>50) $adat=substr($r[$j],0,50)."..."; else $adat=$r[$j];
_672 #
_673 #
_674 #
_675 #
_676 #
_677 # $e .= '<td with=50> '.$adat.' </td>';
_678 # } else {
_679 # $e .= '<td with=50> '.$r[$j].' </td>';
_680 # }
_681 # }
_682 # $e .= '</tr>';
_683 #
_684 # if ($ii==50 and $export==false) {
_685 # $e .= '</table>';
_686 # echo($e);
_687 # $ii=0;
_688 # $e=$ee;
_689 # }
_690 #
_691 # }
_692 #
_693 # $e .= '</table>';
_694 # echo($e);
_695 #
_696 # echo($e);
_697 #
_698 # //mysql_free_result ($eredmeny);
_699 # //
_700 # if(isset($_SESSION[dump]) and $_SESSION[dump]=="Y") {
_701 # include ("../../_inc_QJ_Based/_Q_varlist.php");
_702 # }
_703 #
_704 # // --------- > include ("../../_inc_QJ_Based/_Q_varlist.php");
_705 #
_706 # ///////
_707 # /// BiViewTable.php /// 2009.09.07. 10:58:30
_708 # ?>
_709 #
_710 # </body>