iF_okmailb.inc
Line #0:<?Session_start(); ?>
Line #1:
Line #2:<html>
Line #3:<head>
Line #4:<title>Qjegy</title>
Line #5:<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
Line #6:<meta name="robots" content="noindex">
Line #7:<LINK rel="stylesheet" href="web.css" type=text/css>
Line #8:</head>
Line #9:
Line #10:<?
Line #11:
Line #12:
Line #13:
Line #14:
Line #15:$telszam=$_POST['telszam'];
Line #16:$irsz=$_POST['irsz'];
Line #17:$telepules=$_POST['telepules'];
Line #18:$cim=$_POST['cim'];
Line #19:$nev=$_POST['nev'];
Line #20:$email=$_POST['email'];
Line #21:$uzenet=$_POST['uzenet'];
Line #22:$fizmod=$_POST['fizmod'];
Line #23:$vevo_kod=$_POST['vevo_kod'];
Line #24:
Line #25:if ($fizmod==2 and ($irsz<1000 or strlen($cim)<4 or strlen($nev)<4 or strlen($telszam)<5))
Line #26:{
Line #27:
Line #28:$parancs = "UPDATE `qj_cimtar` SET
Line #29:`irsz`='$irsz',
Line #30:`nev`='$nev',
Line #31:`telszam`='$telszam',
Line #32:`telepules`='$telepules',
Line #33:`cim`='$cim',
Line #34:`uzenet`='$uzenet',
Line #35:`csoport_kod`='WEB' WHERE `wid`='$vevo_kod'";
Line #36:
Line #37:
Line #38:echo "<script>
Line #39:
Line #40: window.open('iF_kosarVIEW.php?&step=2&email=".$email."', 'Idata');
Line #41: </script>";
Line #42:exit;
Line #43:
Line #44:}
Line #45:
Line #46:
Line #47:if ($fizmod==1) {
Line #48:
Line #49:
Line #50:}
Line #51:if ($fizmod==2) {
Line #52:
Line #53:
Line #54:}
Line #55:/*if ($fizmod==3) {
Line #56:
Line #57:
Line #58:} */
Line #59:
Line #60:$ido=time();
Line #61:
Line #62:if (!isset($_GET[ID])) {
Line #63:
Line #64:
Line #65:$elad = "INSERT INTO `qj_weblog`
Line #66:( `usr_kod`,`szoveg`, `osszft`, `osszdb`,
Line #67: `bizomanyos`, `status`, `arforma`, `vevokod`
Line #68:) VALUES
Line #69:( 'JA11', '$ip', '$_POST[sumft]', '$_POST[sumdb]', '$_POST[email]',
Line #70:
Line #71:)";
Line #72:
Line #73:
Line #74:
Line #75:$keres = "SELECT wid FROM qj_weblog order by wid DESC";
Line #76:
Line #77:
Line #78:$sor = mysql_fetch_array( $eredmeny );
Line #79:$ID=$sor[wid];
Line #80:} else $ID=$_GET[ID];
Line #81:
Line #82:
Line #83:$parancs = "UPDATE `qj_cimtar` SET
Line #84:`irsz`='$irsz',
Line #85:`nev`='$nev',
Line #86:`telszam`='$telszam',
Line #87:`telepules`='$telepules',
Line #88:`cim`='$cim',
Line #89:`uzenet`='$uzenet',
Line #90:`csoport_kod`='WEB' WHERE `wid`='$vevo_kod'";
Line #91:
Line #92:
Line #93:
Line #94://$kosar=mysql_num_rows($eredmeny)+1;
Line #95:$pwd=abs(intval (($ido*rand(1,121))/1954));
Line #96:
Line #97://$nur=mysql_num_rows($eredmeny);
Line #98:
Line #99:$kelt=date('Y.m.d H:m:s');
Line #100:
Line #101:
Line #102:/*
Line #103: $parancs="INSERT INTO wj_rendel SET email='".$email.
Line #104: "', future='".$ido.
Line #105: "', telszam='".$telszam.
Line #106: "', telepules='".$telepules.
Line #107: "', kosar='".$kosar.
Line #108: "', fizmod='".$fizmod.
Line #109: "', kelt='".$kelt.
Line #110: "', foglalva='".$kelt.
Line #111: "', fizmod='".$fizmod.
Line #112: "', uzenet='".$uzenet.
Line #113: "', archiv='".$wjip.
Line #114: "', usr_kod='".$usr.
Line #115: "', vevo_kod='".$kosar.
Line #116: "', szoveg='".$wjsession."';";
Line #117:
Line #118:$parancs="INSERT INTO `wj_rendel`
Line #119:( `wid` , `usr_kod` , `szoveg` , `archiv` , `future` , `datum_kod` ,
Line #120:`kosar` , `vevo_kod` , `vevo` , `telepules` , `telszam` , `email` , `fizmod` , `datum` , `allapot` , `uzenet` )
Line #121:VALUES (
Line #122:'', '$usr', '$wjsession', '$wjip', '$ido', '$pwd',
Line #123:'$kosar', '$kosar', '$vevo', '$telepules', '$telszam', '$email', '$fizmod', '$kelt', '1', '$uzenet'
Line #124:);";
Line #125:
Line #126://$eredmeny = mysql_query($parancs) or die("Adathiba!");
Line #127:$vevok=$kosar;
Line #128:*/
Line #129:
Line #130:
Line #131:$tajekoztato="";
Line #132:$iFSQL = "SELECT * FROM qj_sql WHERE szoveg='iFrame' and widarc=105";
Line #133:
Line #134:$iFsor = mysql_fetch_array($iFrec);
Line #135:
Line #136:$kp=$iFsor[sql_memo];
Line #137:$bank=$iFsor[sql_parancs];
Line #138:
Line #139:if ($fizmod==1) {
Line #140:
Line #141:
Line #142:$tajekoztato=$kp;
Line #143:}
Line #144:if ($fizmod==2) {
Line #145:
Line #146:
Line #147:$tajekoztato=$bank;
Line #148:}
Line #149:
Line #150:
Line #151:$sor1="";
Line #152:
Line #153:$iFSQL = "SELECT * FROM qj_sql WHERE szoveg='iFrame' and widarc=4";
Line #154:
Line #155:$iFsor = mysql_fetch_array($iFrec);
Line #156:
Line #157:$sor1=$iFsor[sql_memo];
Line #158:
Line #159:$iFSQL = "SELECT * FROM qj_sql WHERE szoveg='iFrame-KONTROLL' and widarc=5";
Line #160:
Line #161:$iFsor = mysql_fetch_array($iFrec);
Line #162:
Line #163:/*
Line #164:$sor1="
Line #165:<tr>
Line #166:<table width='100%' margin='auto' cellspacing='0' cellpadding='4' border='0px'>
Line #167: <tr>
Line #168:
Line #169:
Line #170: <br> tel.: +36-46-504060, fax: +36-46-504068
Line #171: <br>www.operafesztival.hu
Line #172: </font></td>
Line #173: <td align=center> </td>
Line #174:
Line #175: </font></td>
Line #176: </tr>
Line #177:</table>
Line #178:<br><br>
Line #179:";
Line #180:*/
Line #181:
Line #182://<table width='100%' margin='auto' cellspacing='0' cellpadding='4' border='0px'>
Line #183:
Line #184:
Line #185:/*
Line #186:$iFsor[sql_parancs]
Line #187:
Line #188:"<a target=Idata
Line #189:href='javascript:voice()' onClick='javascript:window.open(\"iF_musor.php\", \"Idata\");return false;' ".
Line #190:
Line #191:$iFsor[sql_memo]
Line #192:
Line #193:*/
Line #194:
Line #195:
Line #196:
Line #197:
Line #198:$sor1.="
Line #199:<table width='100%' margin='auto' cellspacing='0' cellpadding='4' border='0px'>
Line #200:
Line #201: <tr>
Line #202:
Line #203: </tr>
Line #204:
Line #205: <tr>
Line #206:
Line #207: </tr>
Line #208: <tr>
Line #209:
Line #210: </tr>
Line #211: <tr>
Line #212:
Line #213: </td>
Line #214: </tr>
Line #215: <tr>
Line #216: <td width='100'><i>Telefon:</i></td><td><b> $telszam</b></td>
Line #217: </tr>
Line #218: <tr>
Line #219: <td width='100'><i>E-mail:</i></td><td><b>$email</b></td>
Line #220: </tr>
Line #221: <tr>
Line #222: <td width='100'>
Line #223:
Line #224: </tr>
Line #225: <tr>
Line #226: <td width='100'><i>
Line #227:
Line #228:
Line #229: </td>
Line #230: </tr>
Line #231: <tr>
Line #232:
Line #233: </tr>
Line #234: <tr>
Line #235:
Line #236: <td>".$tajekoztato."
Line #237: </td>
Line #238: </tr>
Line #239:</table>
Line #240:<br><br>
Line #241:";
Line #242:
Line #243:/* <td>".$iFsor[sql_parancs]."*/
Line #244:
Line #245:
Line #246: $parancs = "UPDATE `wj_sor` SET `vevo_kod`='$kosar' WHERE `vevo_kod`='' and `kosar_kod`='$rid'";
Line #247:
Line #248:$keres2 = "SELECT * FROM wj_sor WHERE `vevo_kod`='$kosar'";
Line #249:
Line #250:
Line #251://echo ($keres2."<hr>");
Line #252:
Line #253://$e1=('<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><H1> </H1>');
Line #254:$e1=('<br>');
Line #255:
Line #256:$e1='';
Line #257:
Line #258://///////////////
Line #259://if (isset($_GET[ID]))
Line #260:
Line #261:
Line #262://http://of.webjegy.hu/Teszt/BiC(L)oGin.pHp
Line #263://http://212.40.97.30/QJegy/OF11_TESZT/iF_mailOK.php?ID=".$ID."'
Line #264://http://of.webjegy.hu/QJegy/BiC(L)oGin.pHp
Line #265:
Line #266:/*$ee1="<H3> </H3>
Line #267:<a href='https://81.2.225.119/JAjegy_Teszt/iF_mailOK.php?ID=".$ID."'
Line #268:
Line #269:<H3> </H3>";
Line #270:*/
Line #271:
Line #272:/*$ee1="<H3> </H3>
Line #273:<a href='https://81.2.225.119/JAjegy/iF_mailOK.php?ID=".$ID."'
Line #274:
Line #275:<H3> </H3>";
Line #276:*/
Line #277:
Line #278:
Line #279:
Line #280://///////////////
Line #281:$e1.=('<h5>Megrendelt helyek</h5> ');
Line #282:
Line #283:$e1.=("<table width='100%' margin='auto' cellspacing='0' cellpadding='4' border='1px'>");
Line #284:$e1.=('<tr >');
Line #285:
Line #286:
Line #287:$e1.=('<tr >');
Line #288:
Line #289:
Line #290:
Line #291:
Line #292:
Line #293:$e1.=('</tr>');
Line #294:
Line #295:$sumdb=0;
Line #296:$sumft=0;
Line #297:
Line #298:
Line #299:$kosarSQL = "SELECT * FROM qj_jegy WHERE kosar_kod='".$ip."' order by datum_kod,szek_kod ";
Line #300:
Line #301:
Line #302:
Line #303:$nur=mysql_num_rows($szekek);
Line #304:
Line #305:$i=0;
Line #306:$sumft=0;
Line #307:
Line #308:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #309:{
Line #310:++$i;
Line #311:$kati=$jegysor[arkategoria];
Line #312:$dk=$jegysor[datum_kod];
Line #313:$wid=$jegysor[wid];
Line #314:
Line #315:
Line #316:$szekinfo=$jegysor[QJ_sor_s].
Line #317:
Line #318:
Line #319:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #320:
Line #321:$musor = mysql_fetch_array( $eredmeny3 );
Line #322:
Line #323:
Line #324:
Line #325:$arind="alapar".$kati;
Line #326:$ar=$musor[$arind];
Line #327:
Line #328:
Line #329:
Line #330:$elad = "UPDATE `qj_jegy` SET
Line #331: `bizonylatszam`='WEB:$ID',`archiv`='-',`bizomanyos`='Qjegy',`kosar_kod`='Qjegy:$ID',
Line #332:
Line #333: `vevo_kod`='1',`fizmod`='1',`foglalta`='$ip',`szoveg`='$szekinfo',`vevo_kod`='$vevo_kod',
Line #334: `foglalva`=now()
Line #335: WHERE wid='".$wid."'";
Line #336: //echo($elad."<hr>");
Line #337:
Line #338:
Line #339:
Line #340:$e1.= ('<tr>');
Line #341:$e1.= ('<td class="eloadas" >'.$musor[cim].'</td>');
Line #342:$e1.= ('<td class="idopont" >'.$musor[datum].'</td>');
Line #343:$e1.= ('<td class="helyszin" >'.$musor[helyszin].'</td>');
Line #344:$e1.= ('<td class="helyszin" >'.$szekinfo.'</td>');
Line #345:$e1.= ('<td class="ar" >'.number_format($ar, 0, ',', '').'</td>');
Line #346:$e1.= ('<tr>');
Line #347:
Line #348:$sumft=$sumft+$ar;
Line #349:}
Line #350://////////////////
Line #351:
Line #352:$e1.= ('<tr >');
Line #353:
Line #354:$e1.= ('<td class="ar" >'.number_format($sumft, 0, ',', '').'</td>');
Line #355:$e1.= ('</tr>');
Line #356:
Line #357:$e1.= ('</table>');
Line #358:$e1.= ('<br><H1> </H1>');
Line #359:
Line #360:
Line #361:
Line #362:echo($sor1);
Line #363:echo($e1);
Line #364:
Line #365:
Line #366:/*$alma=" onClick='javascript:window.open(\"".$iFsor[usr_kod].
Line #367:substr($_SESSION['Qpath'],3,strlen($_SESSION['Qpath'])-3)."QW_mailOK.php?ID=".$ID."\", \"Qframe\");return false; ' ";
Line #368:
Line #369:
Line #370:$ee1="<H3> </H3>
Line #371:<a href='".$_SESSION['Qpath']."QW_mailOK.php?ID=".$ID."'
Line #372:
Line #373:<H3> </H3>";
Line #374:
Line #375:
Line #376:$ee1="<H3> </H3>
Line #377:<a href='".$iFsor[usr_kod].substr($_SESSION['Qpath'],3,strlen($_SESSION['Qpath'])-3)."QW_mailOK.php?ID=".$ID."'
Line #378:
Line #379:<H3> </H3>";
Line #380:*/
Line #381:
Line #382://$_SESSION['Qpath'].
Line #383://<a href='".$_SESSION['Qpath']."QW_mailOK.php?ID=".$ID."'
Line #384:
Line #385:
Line #386:
Line #387:$h=split('/',$_ENV[REQUEST_URI]."/");
Line #388:
Line #389:$nur=count($h)-3;
Line #390:
Line #391:
Line #392:
Line #393:$url="http://".$_ENV[HTTP_HOST];
Line #394:for ($i=0;$i<$nur;$i++){
Line #395:$url.=$h[$i]."/";
Line #396:
Line #397:
Line #398:}
Line #399:
Line #400:$url.=substr($_SESSION['Qpath'],0-strlen($_SESSION['Qpath'])+3)."QW_mailOK.php?ID=".$ID;
Line #401:
Line #402://BI_alert($_SESSION['Qusr_kod']."/".$_SESSION['Qdef_user']);
Line #403:
Line #404:if (!isset($_SESSION['Qusr_kod']) or $_SESSION['Qusr_kod']=="")
Line #405:$url.="&EV=".$_SESSION['Qdef_user'];
Line #406:else
Line #407:$url.="&EV=".$_SESSION['Qusr_kod'];
Line #408:
Line #409://BI_alert($url."/".$_SESSION['Qusr_kod']."/".$_SESSION['Qdef_user']);
Line #410:
Line #411:
Line #412:$ee1="<H3> </H3>
Line #413:
Line #414:href='$url' >
Line #415:
Line #416:<H3> </H3>";
Line #417:
Line #418:
Line #419:/*$ee1="<H3> </H3>
Line #420:<a href='javascript:voice()'
Line #421:
Line #422:<H3> </H3>";
Line #423:*/
Line #424:
Line #425:
Line #426://echo $alma.$ee1;
Line #427:
Line #428:
Line #429:if (!isset($_GET[ID])) {
Line #430:
Line #431:$e1=$sor1.$e1;
Line #432:
Line #433:
Line #434://///////////////////////////////////////////////////////////////////////////
Line #435:$uzi = "
Line #436:<html>
Line #437:<head>
Line #438:<title>Qjegy</title>
Line #439:<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-2'>
Line #440:</head>
Line #441:
Line #442:<style type='text/css'>
Line #443:.ir { color : black; font-size: 10px;}
Line #444:.fej {color: red; font-size: 10px;}
Line #445:table.kosar {
Line #446:
Line #447:FONT-FAMILY: Verdana;
Line #448:
Line #449: PADDING-RIGHT: 0px;
Line #450: PADDING-LEFT: 0px;
Line #451: PADDING-BOTTOM: 0px;
Line #452: PADDING-TOP: 0px;
Line #453:
Line #454: FONT-SIZE: 12px;
Line #455: border-width: 1px;
Line #456: padding: 0px;
Line #457: border-style:solid;
Line #458: border-color: white;
Line #459: background-color: white;
Line #460:}
Line #461:
Line #462:table.kosar td {
Line #463:
Line #464:FONT-FAMILY: Verdana;
Line #465:
Line #466: PADDING-RIGHT: 0px;
Line #467: PADDING-LEFT: 0px;
Line #468: PADDING-BOTTOM: 0px;
Line #469: PADDING-TOP: 0px;
Line #470:
Line #471: FONT-SIZE: 12px;
Line #472: border-width: 1px;
Line #473: padding: 0px;
Line #474: border-style:solid;
Line #475: border-color: silver;
Line #476: background-color: white;
Line #477:}
Line #478:
Line #479:</style>
Line #480:<body bgcolor=white>
Line #481:"
Line #482:.$e1.
Line #483:$ee1.
Line #484:"
Line #485:</body>
Line #486:<html>
Line #487:";
Line #488:
Line #489:
Line #490:
Line #491:$kontrollcim=$iFsor[sql_memo];
Line #492://'jegypenztar@jamkk.info';
Line #493:
Line #494:$Bimelcim='bene.istvan@maxin.hu';
Line #495:$imelcim2='klara.tordasi@efmk.hu';
Line #496:$imelcim3='erika.kiss@efmk.hu';
Line #497:
Line #498:
Line #499:$fejlec = "From: ".$iFsor[sql_memo]." \n";
Line #500:$fejlec .= "Mime-Version: 1.0\n";
Line #501:$fejlec .= "Content-Type: text/html; charset=iso-8859-2\n";
Line #502:
Line #503:
Line #504:if (substr($kontrollcim,0,1)<>"?") {
Line #505:mail("$email", $iFsor[future].":$ID", "$uzi", $fejlec);
Line #506:mail("$kontrollcim", $iFsor[future]."-Kontroll:$ID", "$uzi", $fejlec);
Line #507:mail("$imelcim3", $iFsor[future]."-Kontroll:$ID", "$uzi", $fejlec);
Line #508:mail("$imelcim2", $iFsor[future]."-Kontroll:$ID", "$uzi", $fejlec);
Line #509:}
Line #510:
Line #511:/*echo "<script>
Line #512:
Line #513: </script>";
Line #514:*/
Line #515:
Line #516:mail("$Bimelcim", $iFsor[future]."-Kontroll:$ID", "$uzi", $fejlec);
Line #517:
Line #518:}
Line #519:
Line #520:echo "<script>
Line #521:
Line #522: window.open('iF_step.php?&mail=".$ID."', 'Ihead');
Line #523: </script>";
Line #524:
Line #525:?>