QB_cimUP.inc

---

Line #0:<?php
Line #1:
Line #2:// include("gvarlist.php");
Line #3:
Line #4:if (isset($_POST[Quick])) {
Line #5:
Line #6:$ipos=strpos($_POST[Quick],"##");
Line #7:
Line #8:if ($ipos>0) {
Line #9:$_GET[wjid]=substr($_POST[Quick],$ipos+2,strlen($_POST[Quick])-$ipos+1);
Line #10:$_GET[sqlfile]="qj_cimtar";
Line #11:} else {
Line #12:echo "<script>
Line #13:
Line #14: window.open('QJ_kijelol.php', 'sframe');
Line #15: </script>";
Line #16:exit;
Line #17:
Line #18:}
Line #19:
Line #20:}
Line #21:
Line #22:if (isset($_POST[vevoElo])) {
Line #23:
Line #24:$wjid=substr($_POST[Quick],$ipos+2,strlen($_POST[Quick])-$ipos+1);
Line #25:
Line #26:echo "<script>
Line #27: window.open('QJ_elojegyzesek.php?&vevo=".$wjid."', 'sframe');
Line #28: </script>";
Line #29:
Line #30:exit;
Line #31:
Line #32:}
Line #33:
Line #34:if (isset($_POST[vevoElad])) {
Line #35:
Line #36:$wjid=substr($_POST[Quick],$ipos+2,strlen($_POST[Quick])-$ipos+1);
Line #37:
Line #38:echo "<script>
Line #39: window.open('QJ_eladasok.php?&vevo=".$wjid."', 'sframe');
Line #40: </script>";
Line #41:
Line #42:exit;
Line #43:
Line #44:}
Line #45:
Line #46:
Line #47:$_SESSION['QJ_call']="QJ_kijelol.php";
Line #48:
Line #49:
Line #50:
Line #51:
Line #52:
Line #53:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=-1;
Line #54:
Line #55:$sqlfile=$_GET[sqlfile];
Line #56://include ("gvarlist.php");
Line #57:
Line #58:
Line #59:$new=false;
Line #60:if ($wjid==-1 or $wjid==0)
Line #61:{
Line #62:$new=true;
Line #63:
Line #64:$keres = "SELECT * FROM qj_cimtar WHERE usr_kod='*DEL' or nev='' limit 1" ;
Line #65:
Line #66:$nur=mysql_num_rows($csor);
Line #67:
Line #68:
Line #69:
Line #70:$ido=time();
Line #71:if ($nur==0) {
Line #72:$newcim = "INSERT INTO `$sqlfile`
Line #73:( `usr_kod`,`uzenet`
Line #74:) VALUES
Line #75:( '$_SESSION[Qusr_kod]','$ido'
Line #76:)";
Line #77:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #78:
Line #79:$keres = "SELECT * FROM qj_cimtar where uzenet='$ido' limit 1";
Line #80:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #81:
Line #82:}
Line #83:
Line #84:$cim_sor = mysql_fetch_array( $csor );
Line #85:$wjid=$cim_sor[wid];
Line #86:
Line #87://$ip = $_SERVER["REMOTE_ADDR"];
Line #88:
Line #89:$parancs = "UPDATE qj_cimtar SET ";
Line #90:$parancs .= " nev='',uzenet='',usr_kod='$_SESSION[Qusr_kod]' ,logtime=now() WHERE wid='$wjid' LIMIT 1" ;
Line #91:
Line #92:
Line #93:
Line #94:
Line #95:}
Line #96:
Line #97:
Line #98:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #99:
Line #100:$fid='';
Line #101:
Line #102:
Line #103:while ($row =mysql_fetch_row($eredmeny))
Line #104:{
Line #105:
Line #106: $fid.=$row[0] . ":";
Line #107:}
Line #108:
Line #109:
Line #110:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #111:
Line #112://BI_alert($keres);
Line #113:
Line #114:
Line #115:
Line #116:
Line #117:$h=split(':',$fid);
Line #118:$nur=count($h)-1;
Line #119:
Line #120:
Line #121:
Line #122:if ($_POST[W])
Line #123:{
Line #124:
Line #125:$W=$_POST[W];
Line #126:
Line #127:$parancs = "UPDATE ".$sqlfile." SET ";
Line #128:
Line #129:$vesszo='';
Line #130:
Line #131:for($j=1;$j<$nur;$j++)
Line #132:
Line #133:{
Line #134:
Line #135: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #136: $vesszo=', ';
Line #137:
Line #138:}
Line #139:
Line #140:$parancs .= " ,usr_kod='$_SESSION[Qusr_kod]' ,logtime=now() WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #141:
Line #142:if (isset($_POST[DEL])) {
Line #143:
Line #144:$parancs = "UPDATE qj_cimtar SET usr_kod='*DEL' ,logtime=now() WHERE wid ='$wjid' LIMIT 1" ;
Line #145:}
Line #146:
Line #147://BI_alert($parancs);
Line #148:
Line #149:if (isset($_POST[kosar])) {
Line #150:echo "<script language = javascript>";
Line #151:echo "window.open('QJ_kijelol.php', 'sframe');";
Line #152:echo "</script>";
Line #153:exit;
Line #154:}
Line #155:
Line #156:
Line #157:if (!isset($_POST[vissza]))
Line #158:
Line #159:
Line #160:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #161:
Line #162: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #163:
Line #164:
Line #165:
Line #166:
Line #167:
Line #168:$_SESSION['cimind']=$wjid;
Line #169:$_SESSION['last_cimind']=$wjid;
Line #170:
Line #171:
Line #172:echo "<script language = javascript>";
Line #173:if (!isset($_POST[vissza]) and !isset($_POST[DEL]))
Line #174:echo "window.open('QJ_kijelol.php', 'sframe');";
Line #175:else
Line #176:echo "window.open('QJ_cimtar.php', 'sframe');";
Line #177:echo "</script>";
Line #178:
Line #179: }
Line #180:
Line #181:$JegyRno="SELECT wid FROM qj_jegy where vevo_kod='$wjid'";
Line #182:
Line #183:$Jrno=mysql_num_rows($RnoQ);
Line #184:
Line #185:
Line #186:
Line #187:$fej="<center><font color=red>RNo:$wjid&nbsp;&nbsp;</font>
Line #188:
Line #189:
Line #190://echo("<a href=".$_SESSION['QJ_call'].">Vissza...</a><br>");
Line #191:
Line #192:$bup="<FORM name=orderby action='QJ_cimUP.php?&sqlfile=$sqlfile&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #193:$bup.="<table border=1 valign=top align=center bgcolor='gold'>";
Line #194:$bup.="<td align=left>";
Line #195:
Line #196:$bup.="<td align=center colspan=3>$fej
Line #197:
Line #198:
Line #199:";
Line #200:
Line #201:
Line #202:
Line #203:
Line #204:
Line #205:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #206:$bup.="</td></tr>";
Line #207:
Line #208://BI_alert($bup);
Line #209:
Line #210:$r=mysql_fetch_row($eredmeny);
Line #211:
Line #212://BI_alert($nur);
Line #213:
Line #214:for($j=1;$j<$nur;$j++)
Line #215:
Line #216:{
Line #217:
Line #218: $bum='W['.$j.']';
Line #219:
Line #220: if ($new==true) $r[$j]="";
Line #221: if (strpos($h[$j],"_kod")>0 or
Line #222: strpos($h[$j],"time")>0 ) $ronly="readonly style='background-color: silver;'"; else $ronly="";
Line #223:
Line #224:
Line #225: $nincs="Y";
Line #226:
Line #227:
Line #228:
Line #229: if ($h[$j]=="usr_kod" or
Line #230: $h[$j]=="csoport_kod" or
Line #231: $h[$j]=="logtime" or
Line #232: $h[$j]=="email_cim") $nincs="N";
Line #233:
Line #234:if ($h[$j]=="nev" and strpos("?".$r[$j],"*")>0)
Line #235:
Line #236: $r[$j]= str_replace("*", "",$r[$j]);
Line #237:
Line #238:// $bup.=$bum.'/';
Line #239:
Line #240:// $bup .= '<td with=50>&nbsp;'.$h[$j].'&nbsp;</td>';
Line #241:
Line #242:
Line #243: if ($h[$j]=="nev")
Line #244:
Line #245: <input $ronly type='text' size=80 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #246: if ($h[$j]=="uzenet")
Line #247:
Line #248: <input $ronly type='text' size=80 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #249:
Line #250: if ($h[$j]=="irsz")
Line #251:
Line #252: if ($h[$j]=="telepules")
Line #253: $bup3b="<td><input $ronly type='text' size=26 value='".$r[$j]."' name='".$bum."'></td>";
Line #254: if ($h[$j]=="cim")
Line #255: $bup3c="<td><input $ronly type='text' size=36 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #256:
Line #257: if ($h[$j]=="telszam")
Line #258: $bup4="<tr><td align=right>Telefon</td><td colspan=3>
Line #259: <input $ronly type='text' size=80 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #260:
Line #261: if ($h[$j]=="email_cim")
Line #262:
Line #263: <input $ronly type='text' size=80 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #264:
Line #265:// $bup.="<tr><td align=right>".$h[$j]."</td><td><input $ronly type='text' size=50 value='".$r[$j]."' name='".$bum."'></td></tr>";
Line #266:
Line #267:}
Line #268:
Line #269: $bup .= $bup1.$bup2.$bup4.$bup5.$bup3a.$bup3b.$bup3c;
Line #270:
Line #271:
Line #272://BI_alert($bup);
Line #273:
Line #274:$bup.="</table></form>";
Line #275:
Line #276:echo($bup);
Line #277:
Line #278:
Line #279:
Line #280:
Line #281:
Line #282:
Line #283:
Line #284:
Line #285: function Bi_back($bi_msg)
Line #286: ////////
Line #287: {
Line #288:
Line #289:// history.go(-1)
Line #290:// history.back(2);
Line #291://echo('<SCRIPT LANGUAGE="JavaScript">alert("'.$bi_msg.'"); history.go(-2); </script>');
Line #292:echo('<SCRIPT LANGUAGE="JavaScript"> history.go(-2); </script>');
Line #293:
Line #294: }
Line #295:
Line #296:
Line #297:?>