QQ_berletSZINKRON.php

---

Line #0:<?php include("QJ_start.php");
Line #1://////////////////////////////////
Line #2://??? QJ_EFforgat.php
Line #3://////////////////////////////////
Line #4:// echo("<H1>EXIT!!!</H1>");
Line #5://exit;
Line #6:
Line #7:
Line #8://?//
Line #9:
Line #10:
Line #11:
Line #12:if (isset($_GET['musor_kod'])) {
Line #13: $wer="datum_kod='".$_GET['musor_kod']. "'";
Line #14:}
Line #15:
Line #16:$keres = "SELECT * FROM qj_musor where ".$wer;
Line #17:
Line #18:
Line #19:$nur=mysql_num_rows($eredmeny);
Line #20:$musor=mysql_fetch_array($eredmeny);
Line #21:
Line #22:
Line #23:echo("<center><i>".$musor[helyszin]."</i><br>".$musor[datum]." **** ");
Line #24:echo($musor[cim].$musor[datum_kod]."</center>");
Line #25:
Line #26:$helyszin_kod=$musor[hely_kod];
Line #27:$datum_kod=$musor[datum_kod];
Line #28:
Line #29:
Line #30:$berlet_kod=$musor[berlet_Azonosito];
Line #31://///////////////////////////////////////////////////////////////
Line #32:
Line #33:
Line #34:$cim_kod=$musor[cim_kod];
Line #35:
Line #36:$keres = "SELECT * FROM qj_musor where datum_kod='$berlet_kod'";
Line #37:
Line #38:
Line #39:$musor=mysql_fetch_array($eredmeny);
Line #40:
Line #41:
Line #42://
Line #43:if (isset($_SESSION['Dump'])) echo("<center><i>".$musor[helyszin]."</i><br>".$musor[datum_kod]." //////// ");
Line #44://
Line #45:echo($musor[cim]."</center>");
Line #46:
Line #47:
Line #48:$eredmeny = mysql_query('show fields from qj_jegy');
Line #49:
Line #50:$fid='';
Line #51:
Line #52:while ($row =mysql_fetch_row($eredmeny))
Line #53:{
Line #54:
Line #55: $fid.=$row[0] . ":";
Line #56:}
Line #57:
Line #58:$h=split(':',$fid);
Line #59:$nur=count($h)-1;
Line #60:
Line #61:
Line #62:
Line #63:$keres = "SELECT * FROM qj_jegy WHERE datum_kod='".$berlet_kod."' ORDER BY szek_kod";
Line #64:
Line #65:
Line #66:
Line #67:
Line #68://
Line #69:if (isset($_SESSION['Dump'])) echo $keres."<hr>";
Line #70:
Line #71://echo "<table border=1><tr>";
Line #72:
Line #73://echo"<tr>";
Line #74:
Line #75://echo"<td align=right >.</td>";
Line #76:
Line #77:for($j=0;$j<$nur;$j++)
Line #78:
Line #79:{
Line #80://echo"<td align=right >$h[$j]</td>";
Line #81:}
Line #82:
Line #83://echo"</tr>";
Line #84:
Line #85:$i=0;
Line #86:
Line #87:
Line #88:
Line #89:
Line #90:$e="";
Line #91:
Line #92:
Line #93:while ($row =mysql_fetch_row($eredmeny))
Line #94:{
Line #95:
Line #96:$e.="<tr>";
Line #97:++$i;
Line #98:$e.="<td align=right >$i</td>";
Line #99:$sql="REPLACE INTO `qj_jegy` VALUES (";
Line #100:
Line #101:$vesszo="'";
Line #102:for($j=0;$j<$nur;$j++)
Line #103:
Line #104:{
Line #105:$e.="<td align=right >$row[$j]</td>";
Line #106:$sql.=$vesszo.$row[$j]."'";
Line #107:$vesszo=", ' ";
Line #108:}
Line #109:
Line #110:$sql.=")";
Line #111:
Line #112://ECHO($sql."<hr>");
Line #113:
Line #114:$e.="</tr>";
Line #115:
Line #116:
Line #117:$keres = "SELECT * FROM qj_jegy WHERE datum='".$row[7]."' and szek_kod='".$row[7]."' ORDER BY szek_kod";
Line #118:
Line #119:
Line #120:
Line #121:}
Line #122:
Line #123:
Line #124://include ("gvarlist.php");
Line #125:
Line #126://echo($e);
Line #127://echo "</table>";
Line #128:
Line #129://$keres = "SELECT * FROM qj_jegy WHERE datum_kod='".$berlet_kod."' ORDER BY szek_kod";
Line #130:$keres = "SELECT * FROM qj_jegy WHERE datum_kod='".$berlet_kod."' and
Line #131:
Line #132:$keres = "SELECT * FROM qj_jegy WHERE datum_kod='".$berlet_kod."' and
Line #133:
Line #134://
Line #135:if (isset($_SESSION['Dump'])) echo $keres."<hr>";
Line #136://?//
Line #137:
Line #138:$jo=0;
Line #139:
Line #140:
Line #141: $result = mysql_query($keres);
Line #142:
Line #143: $id_field="wid";
Line #144: $hiba = 0;
Line #145:
Line #146:while ($original_record = mysql_fetch_assoc($result)) {
Line #147:
Line #148: // insert the new record and get the new auto_increment id
Line #149:// mysql_query("INSERT INTO qj_jegy (`{$id_field}`) VALUES (NULL)");
Line #150:// $newid = mysql_insert_id();
Line #151:
Line #152: // generate the query to update the new record with the previous values
Line #153: $query = "UPDATE qj_jegy SET ";
Line #154:
Line #155: foreach ($original_record as $key => $value) {
Line #156:
Line #157: if ($key == "datum_kod") $value=$datum_kod;
Line #158: if ($key == "cim_kod") $value=$cim_kod;
Line #159:// if ($key == "ar") $value=$value/4;
Line #160: if ($key == "ar") $value=0;
Line #161:
Line #162:
Line #163:// if ($key == "statusz") $value="B.H.";
Line #164: if ($key == "berlet_kod") $value=$berlet_kod;
Line #165: if ($key == "bizonylatszam") {
Line #166:
Line #167: if ($value<>"") $value="BH:".$value;
Line #168:
Line #169: }
Line #170:
Line #171:
Line #172: if ($key == "szek_kod") { $szek_kod=$value; }
Line #173:///
Line #174: if ($key != $id_field) {
Line #175:
Line #176: $query .= '`'.$key.'` = "'.str_replace('"','\"',$value).'", ';
Line #177: }
Line #178: }
Line #179: $query = substr($query,0,strlen($query)-2); # lop off the extra trailing comma
Line #180: $query .= " WHERE datum_kod='".$datum_kod."' and szek_kod='".$szek_kod."'";
Line #181:
Line #182://
Line #183:if (isset($_SESSION['Dump'])) echo $query."<hr>";
Line #184:
Line #185:$dupla = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and
Line #186:
Line #187:
Line #188:
Line #189: $talal = mysql_query($dupla);
Line #190: $nurD=mysql_num_rows($talal);
Line #191:
Line #192:if (isset($_SESSION['Dump'])) echo $dupla."<hr>";
Line #193:
Line #194:if ($nurD>0) {
Line #195: $jsor=mysql_fetch_array($talal);
Line #196://?//if (isset($_SESSION['Dump']))
Line #197:
Line #198: $query=$dupla;
Line #199: ++$hiba;
Line #200:}
Line #201:
Line #202:
Line #203:$dupla = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and szek_kod='".$szek_kod."' LIMIT 1";
Line #204:
Line #205: $talal = mysql_query($dupla);
Line #206:
Line #207: $nur=mysql_num_rows($talal);
Line #208:
Line #209: if ($nur==0) {
Line #210:mysql_query("INSERT INTO qj_jegy (`datum_kod`,`szek_kod`) VALUES ('$datum_kod','$szek_kod')");
Line #211:
Line #212: $newid = mysql_insert_id();
Line #213:
Line #214:}
Line #215:
Line #216:
Line #217:
Line #218:
Line #219:
Line #220:if ($nurD==0) { ++$jo; mysql_query($query); }
Line #221:
Line #222:
Line #223:}
Line #224:
Line #225:if ($hiba>0)
Line #226:
Line #227:else
Line #228:
Line #229:
Line #230:?>