Bi-Dir

QQ_TERKEP_szekupl.inc

Line #0:<?php include("QJ_start.php"); /*Qjegy2013v3.0-inc */
Line #1:
Line #2:if (!isset($_GET["konyvtar"])) $konyvtar=getcwd(); else $konyvtar=$_GET["konyvtar"];
Line #3:if (isset($_POST["konyvtar"])) $konyvtar=$_POST["konyvtar"];
Line #4:
Line #5:if (isset($_POST["jEXPORT"])) {
Line #6:
Line #7:BI_alert("Jegy EXPORT INSERT E_qj_jegy SELECT * FROM qj_jegy ");
Line #8:
Line #9:$sel = "DROP TABLE E_qj_jegy ";
Line #10:$sql=mysql_query($sel);
Line #11:$sel = "CREATE TABLE E_qj_jegy LIKE qj_jegy ";
Line #12:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #13:$sel = "INSERT E_qj_jegy SELECT * FROM qj_jegy ";
Line #14:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #15:}
Line #16:
Line #17:
Line #18:if (isset($_POST["jIMPORT"])) {
Line #19:
Line #20:BI_alert("Jegy IMPORT INSERT qj_jegy SELECT * FROM E_qj_jegy");
Line #21:
Line #22:$sel = "DROP TABLE qj_jegy ";
Line #23:$sql=mysql_query($sel);
Line #24:$sel = "CREATE TABLE qj_jegy LIKE E_qj_jegy ";
Line #25:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #26:$sel = "INSERT qj_jegy SELECT * FROM E_qj_jegy ";
Line #27:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #28:}
Line #29:
Line #30:
Line #31:if (isset($_POST["sIMPORT"])) {
Line #32:
Line #33:BI_alert("Szek IMPORT INSERT qj_szek SELECT * FROM E_qj_szek");
Line #34:
Line #35:$sel = "DROP TABLE qj_szek ";
Line #36:$sql=mysql_query($sel);
Line #37:
Line #38:$sel = "CREATE TABLE qj_szek LIKE E_qj_szek ";
Line #39:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #40:$sel = "INSERT qj_szek SELECT * FROM E_qj_szek ";
Line #41:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #42:
Line #43:}
Line #44:
Line #45:
Line #46:if (isset($_POST["sTEMP"])) {
Line #47:
Line #48://BI_alert("Szek IMPORT INSERT qj_temp SELECT * FROM E_qj_szek");
Line #49:BI_alert("Szek IMPORT INSERT qj_temp SELECT * FROM qj_sql");
Line #50:
Line #51:$sel = "DROP TABLE qj_temp ";
Line #52:$sql=mysql_query($sel);
Line #53:
Line #54://$sel = "CREATE TABLE qj_temp LIKE E_qj_szek ";
Line #55:$sel = "CREATE TABLE qj_temp LIKE qj_sql ";
Line #56:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #57://$sel = "INSERT qj_szek SELECT * FROM E_qj_szek ";
Line #58://$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #59:
Line #60:}
Line #61:
Line #62:
Line #63:if (isset($_POST["sMASZK"])) {
Line #64:
Line #65://BI_alert("Szek IMPORT INSERT qj_temp SELECT * FROM E_qj_szek");
Line #66:BI_alert("qj_maszk IMPORT INSERT qj_maszk SELECT * FROM qj_sql");
Line #67:
Line #68:$sel = "DROP TABLE qj_maszk ";
Line #69:$sql=mysql_query($sel);
Line #70:
Line #71://$sel = "CREATE TABLE qj_temp LIKE E_qj_szek ";
Line #72:$sel = "CREATE TABLE qj_maszk LIKE qj_sql ";
Line #73:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #74://$sel = "INSERT qj_szek SELECT * FROM E_qj_szek ";
Line #75://$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #76:
Line #77:}
Line #78:
Line #79:
Line #80:
Line #81:if (isset($_POST["sEXPORT"])) {
Line #82:
Line #83:BI_alert("EXPORT INSERT E_qj_szek SELECT * FROM qj_szek ");
Line #84:
Line #85:$sel = "DROP TABLE E_qj_szek ";
Line #86:$sql=mysql_query($sel);
Line #87:
Line #88:
Line #89:$sel = "CREATE TABLE E_qj_szek LIKE qj_szek ";
Line #90:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #91:$sel = "INSERT E_qj_szek SELECT * FROM qj_szek ";
Line #92:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #93:
Line #94:/*
Line #95:
Line #96:$sql="TRUNCATE TABLE `qj_szek`";
Line #97:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #98:
Line #99:$sql="TRUNCATE TABLE `qj_jegy`";
Line #100:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #101:
Line #102:$sql="TRUNCATE TABLE `qj_archive`";
Line #103:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #104:
Line #105:$sql="TRUNCATE TABLE `qj_jlog`";
Line #106:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #107:*/
Line #108:
Line #109:}
Line #110:
Line #111:?>
Line #112:
Line #113:
Line #114: <FORM name=orderby action='' method='POST' > <table width=100% border=1>
Line #115: <tr><td bgcolor=red>
Line #116:
Line #117: </td><td>
Line #118:
Line #119: </td><td bgcolor=red>
Line #120: <input type='submit' value='qj_temp CREATE' TITLE='INSERT qj_temp SELECT * FROM qj_sql ' name='sTEMP'>
Line #121: </td></tr><tr><td bgcolor=red>
Line #122: <input type='submit' value='Jegy EXPORT' TITLE='INSERT E_qj_jegy SELECT * FROM qj_jegy ' name='jEXPORT'>
Line #123: </td><td>
Line #124: <input type='submit' value='Jegy IMPORT' TITLE='INSERT qj_jegy SELECT * FROM E_qj_jegy ' name='jIMPORT'>
Line #125: </td><td bgcolor=red>
Line #126: <input type='submit' value='qj_maszk CREATE' TITLE='INSERT qj_maszk SELECT * FROM qj_sql ' name='sMASZK'>
Line #127: </td></tr><tr><td>
Line #128:
Line #129: </td><td>
Line #130:
Line #131: </td><td>
Line #132:
Line #133: </td></tr><tr bgcolor=silver><td colspan=3>
Line #134:
Line #135: </td></tr><tr bgcolor=silver><td colspan=2>
Line #136:
Line #137: </td><td>
Line #138:
Line #139: </td></tr></table>
Line #140:
Line #141:<?php
Line #142:/// <input type='hidden' value='TRUNC' name='TRUNC'>
Line #143:
Line #144://$konyvtar = $_POST['konyvtar'];
Line #145://include("../BiLib/bisql.php");
Line #146:
Line #147:
Line #148:
Line #149:
Line #150:
Line #151:Chdir($konyvtar);
Line #152:
Line #153://include("BIcGvar.php");
Line #154:
Line #155:$ind=strrpos($konyvtar,"/");
Line #156:
Line #157:if ($ind<15) $rest=""; else $rest = substr($konyvtar, $ind-strlen($konyvtar));
Line #158:
Line #159:if ($k_azon = opendir($konyvtar)) {
Line #160:
Line #161:
Line #162://echo "<hr>Path:".$ind."/".$rest;
Line #163:
Line #164: $I=0;
Line #165:
Line #166: while (false !== ($fajl = readdir($k_azon))) {
Line #167: $I++;
Line #168: $tomb[$I] = $fajl;
Line #169:
Line #170:// if ($fajl != "." && $fajl != "..") {
Line #171:// echo "$fajl<br>";
Line #172:// }
Line #173:
Line #174: }
Line #175:
Line #176:sort ($tomb);
Line #177:echo('<table width=600 height=40 border=1 text=black bgcolor=yellow><font color="black">');
Line #178:
Line #179: $xx=0;
Line #180:$szures=".upl";
Line #181:if (isset($_POST["szures"])) $szures=$_POST["szures"];
Line #182:
Line #183:
Line #184:
Line #185:for ($j= 0; $j < $I; $j++) {
Line #186:
Line #187: $entry = $tomb[$j];
Line #188:
Line #189: $helyszin_kod=substr($entry,8);
Line #190:
Line #191:$SQLszek = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod."' ORDER BY szek_kod";
Line #192:
Line #193:
Line #194:$nur=mysql_num_rows($szekek);
Line #195:
Line #196: $szuki=1;
Line #197:
Line #198: if (!empty($szures)) {
Line #199:
Line #200: $szuki=strpos("?".strtolower($entry), strtolower($szures));
Line #201: }
Line #202:
Line #203: if ($entry != ".." and $entry != "." ) {
Line #204: $meret = filesize($entry);
Line #205: $ido = date ("Y-m-d H:i:s.", filemtime($entry));
Line #206: }
Line #207: else {
Line #208: $meret = "directory";
Line #209: $ido = $konyvtar;
Line #210: $szuki=0;
Line #211:
Line #212: }
Line #213:
Line #214: if ($szuki>0) {
Line #215:
Line #216: $helyszin_kod=substr($entry,0,8);
Line #217:
Line #218:$SQLszek = "SELECT * FROM qj_musor WHERE hely_kod='".$helyszin_kod."'";
Line #219:
Line #220:
Line #221:$nur=mysql_num_rows($szekek);
Line #222:
Line #223:$musor = mysql_fetch_array( $szekek );
Line #224:
Line #225:
Line #226:$SQLszek = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod."' ORDER BY szek_kod";
Line #227:
Line #228:
Line #229:$nur=mysql_num_rows($szekek);
Line #230:
Line #231:
Line #232: $xx=$xx+1;
Line #233: echo '<tr><td ALIGN="right"><font color="black">'.$xx.'</td><td ALIGN="right">';
Line #234: echo '<a href="QQ_szekindex.php?&in='.$entry.'"><img border=0 src="../_Screen/sql.png" ></td><td ALIGN="right">';
Line #235: echo $entry."</td><td> ".$ido.'</td><td ALIGN="right">'.$meret."</td>";
Line #236: echo '<td ALIGN="right">'.$musor[helyszin]."</td>";
Line #237:
Line #238:
Line #239: echo "</font></tr>";
Line #240: }
Line #241:}
Line #242:
Line #243:
Line #244: echo('</table>');
Line #245:
Line #246: closedir($k_azon);
Line #247:
Line #248:}
Line #249:
Line #250:?>
Line #251: