QQ_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");
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");
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");
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:
Line #47:if (isset($_POST["sEXPORT"])) {
Line #48:
Line #49:BI_alert("EXPORT");
Line #50:
Line #51:$sel = "DROP TABLE E_qj_szek ";
Line #52:$sql=mysql_query($sel);
Line #53:
Line #54:
Line #55:$sel = "CREATE TABLE E_qj_szek LIKE qj_szek ";
Line #56:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #57:$sel = "INSERT E_qj_szek SELECT * FROM qj_szek ";
Line #58:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #59:
Line #60:/*
Line #61:
Line #62:$sql="TRUNCATE TABLE `qj_szek`";
Line #63:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #64:
Line #65:$sql="TRUNCATE TABLE `qj_jegy`";
Line #66:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #67:
Line #68:$sql="TRUNCATE TABLE `qj_archive`";
Line #69:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #70:
Line #71:$sql="TRUNCATE TABLE `qj_jlog`";
Line #72:mysql_query($sql) or die ($sql." Qjegy2010 hiba ! ".mysql_error());
Line #73:*/
Line #74:
Line #75:}
Line #76:
Line #77:?>
Line #78:
Line #79: <FORM name=orderby action='QQ_szekupl.php' method='POST' >
Line #80:
Line #81:
Line #82:
Line #83:
Line #84:
Line #85: <input type='submit' value='Jegy EXPORT' name='jEXPORT'>
Line #86: <input type='submit' value='Jegy IMPORT' name='jIMPORT'>
Line #87: <input type='submit' value='Jegy UNDO' name='jUNDO'><BR>
Line #88:
Line #89:
Line #90:
Line #91:
Line #92:
Line #93:<?php
Line #94:/// <input type='hidden' value='TRUNC' name='TRUNC'>
Line #95:
Line #96://$konyvtar = $_POST['konyvtar'];
Line #97://include("../BiLib/bisql.php");
Line #98:
Line #99:
Line #100:
Line #101:
Line #102:
Line #103:Chdir($konyvtar);
Line #104:
Line #105://include("BIcGvar.php");
Line #106:
Line #107:$ind=strrpos($konyvtar,"/");
Line #108:
Line #109:if ($ind<15) $rest=""; else $rest = substr($konyvtar, $ind-strlen($konyvtar));
Line #110:
Line #111:if ($k_azon = opendir($konyvtar)) {
Line #112:
Line #113:
Line #114://echo "<hr>Path:".$ind."/".$rest;
Line #115:
Line #116: $I=0;
Line #117:
Line #118: while (false !== ($fajl = readdir($k_azon))) {
Line #119: $I++;
Line #120: $tomb[$I] = $fajl;
Line #121:
Line #122:// if ($fajl != "." && $fajl != "..") {
Line #123:// echo "$fajl<br>";
Line #124:// }
Line #125:
Line #126: }
Line #127:
Line #128:sort ($tomb);
Line #129:echo('<table width=600 height=40 border=1 text=black bgcolor=yellow><font color="black">');
Line #130:
Line #131: $xx=0;
Line #132:$szures=".upl";
Line #133:if (isset($_POST["szures"])) $szures=$_POST["szures"];
Line #134:
Line #135:
Line #136:
Line #137:for ($j= 0; $j < $I; $j++) {
Line #138:
Line #139: $entry = $tomb[$j];
Line #140:
Line #141: $helyszin_kod=substr($entry,8);
Line #142:
Line #143:$SQLszek = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod."' ORDER BY szek_kod";
Line #144:
Line #145:
Line #146:$nur=mysql_num_rows($szekek);
Line #147:
Line #148: $szuki=1;
Line #149:
Line #150: if (!empty($szures)) {
Line #151:
Line #152: $szuki=strpos("?".strtolower($entry), strtolower($szures));
Line #153: }
Line #154:
Line #155: if ($entry != ".." and $entry != "." ) {
Line #156: $meret = filesize($entry);
Line #157: $ido = date ("Y-m-d H:i:s.", filemtime($entry));
Line #158: }
Line #159: else {
Line #160: $meret = "directory";
Line #161: $ido = $konyvtar;
Line #162: $szuki=0;
Line #163:
Line #164: }
Line #165:
Line #166: if ($szuki>0) {
Line #167:
Line #168: $helyszin_kod=substr($entry,0,8);
Line #169:
Line #170:$SQLszek = "SELECT * FROM qj_musor WHERE hely_kod='".$helyszin_kod."'";
Line #171:
Line #172:
Line #173:$nur=mysql_num_rows($szekek);
Line #174:
Line #175:$musor = mysql_fetch_array( $szekek );
Line #176:
Line #177:
Line #178:$SQLszek = "SELECT * FROM qj_szek WHERE hely_kod='".$helyszin_kod."' ORDER BY szek_kod";
Line #179:
Line #180:
Line #181:$nur=mysql_num_rows($szekek);
Line #182:
Line #183:
Line #184: $xx=$xx+1;
Line #185: echo '<tr><td ALIGN="right"><font color="black">'.$xx.'</td><td ALIGN="right">';
Line #186: echo '<a href="QQ_szekindex.php?&in='.$entry.'"><img border=0 src="../_Screen/sql.png" ></td><td ALIGN="right">';
Line #187: echo $entry."</td><td> ".$ido.'</td><td ALIGN="right">'.$meret."</td>";
Line #188: echo '<td ALIGN="right">'.$musor[helyszin]."</td>";
Line #189:
Line #190:
Line #191: echo "</font></tr>";
Line #192: }
Line #193:}
Line #194:
Line #195:
Line #196: echo('</table>');
Line #197:
Line #198: closedir($k_azon);
Line #199:
Line #200:}
Line #201:
Line #202:?>
Line #203: