SQL_search.full

---

Line #0:<?
Line #1:
Line #2:
Line #3:$_SESSION["scanBI"] = "a";
Line #4:
Line #5:
Line #6://if (!isset($_GET[mod]) and isset($_SESSION[CIM_sorrend])) $_GET[mod]=$_SESSION[CIM_sorrend];
Line #7:
Line #8://if (!isset($_SESSION[CIM_sorrend])) $_SESSION[CIM_sorrend]="nev";
Line #9:
Line #10://if (isset($_GET[mod])) BI_alert("*".$_SESSION[CIM_sorrend]);
Line #11://if (!isset($_GET[mod])) BI_alert("?".$_SESSION[CIM_sorrend]);
Line #12:
Line #13:
Line #14:if (!isset($_SESSION[CIM_sorrend])) $_SESSION[CIM_sorrend]="nev";
Line #15:
Line #16:if (isset($_GET[mod])) $_SESSION[CIM_sorrend]=$_GET[mod];
Line #17:$CIM_sorrend=$_SESSION[CIM_sorrend];
Line #18:
Line #19:
Line #20:if (!isset($_SESSION[CIM_goon])) $_POST[goon]=="?";
Line #21:
Line #22://if (isset($_POST[goon]) and $_POST[goon]=="goon" )
Line #23:if (isset($_POST[goon]))
Line #24:$_SESSION[CIM_goon]=$_POST[goon];
Line #25:
Line #26:
Line #27:
Line #28:
Line #29://if (isset($_POST[goon]) and $_POST[goon]<>"goon" )
Line #30://unset($_SESSION[CIM_goon]);
Line #31:
Line #32:
Line #33://include("QJ_varlist.php");
Line #34:
Line #35:if (!isset($_SESSION[CIM_DESC])) $_SESSION[CIM_DESC]="";
Line #36:if (isset($_POST[Desc])) {
Line #37:if ($_SESSION[CIM_DESC]=="*" )
Line #38:$_SESSION[CIM_DESC]=""; else $_SESSION[CIM_DESC]="*";
Line #39:}
Line #40:if (isset($_POST[delete])) {
Line #41:$_GET[value]="";
Line #42:$_SESSION["BI_user_ker"]="";
Line #43:$_SESSION["BI_taj_ker"]="";
Line #44:$_POST[user_ker]="";
Line #45:$_POST[taj_ker]="";
Line #46:}
Line #47:
Line #48:if (isset($_GET[value])){
Line #49://BI_alert("*".$_GET[value]."*");
Line #50:
Line #51:$_SESSION["BI_user_ker"]=$_GET[value];
Line #52:}
Line #53:
Line #54:
Line #55: $BI_user_ker= str_replace("~"," ",$_SESSION[BI_user_ker]);
Line #56:
Line #57:
Line #58:if (isset($_POST[Puser]) and $_POST[Puser]<>"*"){
Line #59:
Line #60:
Line #61:$sql="select * FROM qj_cimtar where wid='".$_POST[Puser]."'";
Line #62:
Line #63:
Line #64:$_SESSION["QJ_cimtarSQL"]=$sql;
Line #65:
Line #66://?//echo ($sql."<hr>");
Line #67:
Line #68:$sor = mysql_fetch_array($stid);
Line #69:
Line #70:$wjid = $sor[wid];
Line #71:$nev = $sor[nev];
Line #72:$telepules = $sor[telepules];
Line #73:$cim = $sor[cim];
Line #74:$telszam= $sor[telszam];
Line #75:$uzenet= $sor[uzenet];
Line #76:$item =$nev.", ".$telepules.", ".$telepules.", ".$telszam.", ".$uzenet;
Line #77:
Line #78:$BI_user_ker=$sor[$CIM_sorrend];
Line #79:
Line #80://$_SESSION["BI_user_ker"] = $nev ;
Line #81://$_SESSION["CIM_sorrend"]=="nev";
Line #82:
Line #83://$_POST[user_ker]=$_SESSION["BI_user_ker"];
Line #84:// echo "<script language = javascript>";
Line #85:
Line #86:// echo "parent.location.href='index.php'";
Line #87://echo 'window.location.href = "QJ_cimtar.php"';
Line #88:// echo "</script>";
Line #89:
Line #90://exit;
Line #91:
Line #92:}
Line #93:
Line #94:
Line #95:?>
Line #96:<table cellspacing="0" cellpadding="0" align="center" width="100%">
Line #97:<tr ><td >
Line #98:<table width="100%">
Line #99:<tr ><td>
Line #100:
Line #101:
Line #102:<table class="contentpaneopen">
Line #103:<tr>
Line #104:<td valign="top">
Line #105:<form name="search" method="POST" action="QJ_cimtar.php" onsubmit="return nullCheck(this)">
Line #106:<table bgcolor="#A7C2B3" cellpadding="2" cellspacing="2" width=100%">
Line #107:<tr>
Line #108:<td nowrap>
Line #109:
Line #110:</td>
Line #111:<td bgcolor="#DBE6E0">
Line #112:
Line #113:
Line #114:<?PHP
Line #115:
Line #116:
Line #117:
Line #118:IF ($CIM_sorrend=="nev") $sel=" SELECTED "; else $sel="";
Line #119:
Line #120:
Line #121:IF ($CIM_sorrend=="telepules") $sel=" SELECTED "; else $sel="";
Line #122:
Line #123:
Line #124:IF ($CIM_sorrend=="telszam") $sel=" SELECTED "; else $sel="";
Line #125:
Line #126:
Line #127:IF ($CIM_sorrend=="uzenet") $sel=" SELECTED "; else $sel="";
Line #128:
Line #129:
Line #130:
Line #131:?>
Line #132:
Line #133:</select>
Line #134:
Line #135:
Line #136:
Line #137:
Line #138:
Line #139:" value="" name=CHAR_len >
Line #140:
Line #141:
Line #142:
Line #143: <INPUT TYPE='radio' NAME='goon' value='goon' <?if ($goon=="goon") echo(" CHECKED ");?>
Line #144: onclick=this.form.submit(); return true name='goon'
Line #145: >Tartalom ...
Line #146:
Line #147: <INPUT TYPE='radio' NAME='goon' value='?' <?if ($goon=="?") echo(" CHECKED "); ?>
Line #148: onclick=this.form.submit(); return true name='goon'
Line #149:
Line #150:
Line #151:
Line #152:
Line #153:
Line #154:<?PHP
Line #155:
Line #156:/*IF ($CIM_sorrend=="taj")
Line #157: echo "<script>alert('?taj');CheckLen(search.taj_ker,30,'taj');</script>";
Line #158:IF ($CIM_sorrend=="nev")
Line #159: echo "<script>alert('?nev');CheckLen(search.user_ker,30,'nev');</script>";
Line #160:*/
Line #161:
Line #162:?>
Line #163:
Line #164:</td></tr>
Line #165:
Line #166:<?php
Line #167:
Line #168:IF ($CIM_sorrend=="nev")
Line #169:$fullRec =" INSTR((CONCAT_WS(nev,'/', telepules,'/', cim,'/', telszam,'/', uzenet)),'".$BI_user_ker."')";
Line #170:
Line #171:IF ($CIM_sorrend=="telepules")
Line #172:$fullRec =" INSTR((CONCAT_WS(telepules,'/',nev,'/', cim,'/', telszam,'/', uzenet)),'".$BI_user_ker."')";
Line #173:
Line #174:IF ($CIM_sorrend=="telszam")
Line #175:$fullRec =" INSTR((CONCAT_WS(telszam,'/', nev,'/', telepules,'/', cim,'/', uzenet)),'".$BI_user_ker."')";
Line #176:
Line #177:IF ($CIM_sorrend=="uzenet")
Line #178:$fullRec =" INSTR((CONCAT_WS(uzenet,'/', nev,'/', telepules,'/', cim,'/', telszam)),'".$BI_user_ker."')";
Line #179:
Line #180:if ($goon=="goon")
Line #181:$sql2="select * FROM qj_cimtar where $fullRec order by $CIM_sorrend $_SESSION[CALL_ord]";
Line #182:else
Line #183:$sql2="select * FROM qj_cimtar where $CIM_sorrend LIKE '$BI_user_ker%' order by $CIM_sorrend $_SESSION[CALL_ord]";
Line #184:
Line #185://if ( !isset($_SESSION[CIM_sorrend]) or !isset($_SESSION[$_SESSION[BI_user_ker]]))
Line #186://$sql2="select * FROM qj_cimtar order by wid";
Line #187:
Line #188:
Line #189:
Line #190:$nurL=mysql_num_rows($stid2);
Line #191:
Line #192: echo "<script language = javascript>";
Line #193: echo "document.search.CHAR_len.value = ".$nurL.";";
Line #194: echo "</script>";
Line #195:
Line #196:
Line #197:
Line #198:
Line #199://SELECT LOWER(CONCAT_WS(title,description)) AS concatenated WHERE concatenated LIKE '%searchterm%'
Line #200://SELECT LOWER(CONCAT_WS(title,description)) AS concatenated WHERE concatenated LIKE LOWER('%SearchTerm%')
Line #201:
Line #202:if ($goon=="goon")
Line #203:$sql="select * FROM qj_cimtar where $fullRec order by $CIM_sorrend limit 15 $_SESSION[CALL_ord]";
Line #204:ELSE
Line #205:$sql="select * FROM qj_cimtar where $CIM_sorrend LIKE '$BI_user_ker%' order by $CIM_sorrend $_SESSION[CALL_ord] limit 15";
Line #206:
Line #207://if ( !isset($_SESSION[CIM_sorrend]) or !isset($_SESSION[$_SESSION[BI_user_ker]]))
Line #208://$sql="select * FROM qj_cimtar order by wid limit 15 ";
Line #209:
Line #210:
Line #211:$_SESSION["QJ_cimtarSQL"]=$sql;
Line #212:
Line #213://?// echo($sql."<hr>");
Line #214:
Line #215:if ($BI_user_ker!="") {
Line #216:
Line #217://echo($sql."<hr>");
Line #218:
Line #219:
Line #220:
Line #221:if ($nurL>15) $m=15; else $m=$nurL;
Line #222:
Line #223:
Line #224:onclick=this.form.submit(); return true name="Puser">';
Line #225:
Line #226:
Line #227://echo "<script>var customarray=new Array();</script>";
Line #228:while ($sor = mysql_fetch_array($stid)) {
Line #229:$wjid = $sor[wid];
Line #230:$nev = $sor[nev];
Line #231:$telepules = $sor[telepules];
Line #232:$cim = $sor[cim];
Line #233:$telszam= $sor[telszam];
Line #234:$uzenet= $sor[uzenet];
Line #235:$item =$nev.", ".$telepules.", ".$cim.", ".$telszam.", ".$uzenet;
Line #236:
Line #237:
Line #238:IF ($CIM_sorrend=="nev")
Line #239:$item =$nev.", ".$telepules.", ".$cim.", ".$telszam.", ".$uzenet;
Line #240:IF ($CIM_sorrend=="telepules")
Line #241:$item =$telepules.", ".$cim.", ".$nev.", ".$telszam.", ".$uzenet;
Line #242:IF ($CIM_sorrend=="telszam")
Line #243:$item =$telszam.", ".$nev.", ".$telepules.", ".$cim.", ".$uzenet;
Line #244:IF ($CIM_sorrend=="uzenet")
Line #245:$item =$uzenet.", ".$telszam.", ".$nev.", ".$telepules.", ".$cim;
Line #246:
Line #247:
Line #248:$e.="<option value='$wjid'>$item</option>";
Line #249:}
Line #250:
Line #251:
Line #252:
Line #253:
Line #254:
Line #255:$e.='</select>';
Line #256:
Line #257:
Line #258:} else {
Line #259://echo "<script>var customarray=new Array();</script>";
Line #260://$e="";
Line #261:}
Line #262://onclick="return nullCheck(this)"
Line #263:
Line #264:?>
Line #265:
Line #266:<tr>
Line #267:<td nowrap rowspan=2>
Line #268:<B><? print $talalat; ?> </B>
Line #269:</td>
Line #270:<td bgcolor="#DBE6E0" >
Line #271:<!--<input type="text" autocomplete='off' name="user_ker" id='tdu' maxlength="50" size="50"
Line #272:onkeyup="return firstChar(this, event.keyCode)">-->
Line #273:
Line #274:onclick="this.form.submit(); return true name='user_ok'"
Line #275:onkeyup="CheckLen(search.user_ker,500,'nev')"
Line #276:
Line #277:value="<?php print $BI_user_ker; ?>" maxlength="50" size="50">
Line #278:
Line #279:<input type="hidden" name="user_uid" id='uuid' value="<?php print $uid; ?>">
Line #280:&nbsp;&nbsp;&nbsp;
Line #281:
Line #282: TYPE='submit' NAME='submit'
Line #283:
Line #284:
Line #285:
Line #286:</td>
Line #287:</tr>
Line #288:<tr>
Line #289:
Line #290:<script>
Line #291:document.search.user_ker.focus();
Line #292://document.search.user_ker.focus();
Line #293:document.search.user_ker.value = "<?php print $BI_user_ker; ?>";
Line #294://var obj = actb(document.getElementById('tdu'),customarray);
Line #295:</script>
Line #296:
Line #297:
Line #298:<td bgcolor="#DBE6E0">
Line #299:
Line #300:
Line #301:</td>
Line #302:</tr>
Line #303:
Line #304:</table>
Line #305:
Line #306:</form>
Line #307:
Line #308:<SCRIPT LANGUAGE="JavaScript">
Line #309:
Line #310:
Line #311: function CheckLen(input,max,hiv){
Line #312:
Line #313:// if(input.value.length>max){
Line #314:
Line #315:// input.value = input.value.substring(0,input.value.length-1);
Line #316:// }
Line #317:
Line #318:// document.search.CHAR_len.value = input.value.length;
Line #319://alert(hiv+ " / " + input.value);
Line #320:
Line #321://window.location.href = "QJ_cimtar.php?&value=" + input.value+"&mod=" + hiv;
Line #322:
Line #323:window.location.href = "QJ_cimtar.php?&value=" + input.value;
Line #324:
Line #325://document.search.user_ker.focus();
Line #326:
Line #327: }
Line #328:
Line #329:
Line #330:function nullCheck(){
Line #331:
Line #332:
Line #333:if (document.search.szempont.value == "nev") {
Line #334:// document.search.CHAR_len.value = search.user_ker.value.length;
Line #335://CheckLen(search.user_ker,30);
Line #336:
Line #337: if (document.search.user_ker.value == "")
Line #338: {
Line #339:
Line #340: return false;
Line #341: }
Line #342:}
Line #343:else if (document.search.szempont.value == "taj") {
Line #344:// document.search.CHAR_len.value = search.taj_ker.value.length;
Line #345://CheckLen(search.taj_ker,30);
Line #346: if (document.search.taj_ker.value == "")
Line #347: {
Line #348:
Line #349: return false;
Line #350: }
Line #351: }
Line #352:}
Line #353:
Line #354:
Line #355:function modCheck (field) {
Line #356:
Line #357://if (document.search.szempont.value == "nev")
Line #358:document.search.user_ker.focus();
Line #359:
Line #360://{
Line #361://alert(document.search.szempont.value+'***NEV***');
Line #362://document.search.taj_ker.value = "alma";
Line #363://CheckLen(search.taj_ker,30);
Line #364://document.search.taj_ker.focus();
Line #365://document.search.taj_ker.value = "<?php print $char; ?>";
Line #366://var obj = actb(document.getElementById('tjk'),customarray);
Line #367:
Line #368://}
Line #369://else if (document.search.szempont.value == "taj") {
Line #370://alert(document.search.szempont.value+'***TAJ***');
Line #371://document.search.user_ker.value = "dio";
Line #372://CheckLen(search.user_ker,30);
Line #373://document.search.user_ker.focus();
Line #374:// document.search.CHAR_len.value = search.user_ker.value.length;
Line #375:
Line #376://}
Line #377:
Line #378:
Line #379://?//alert(field.value+" ---- ");
Line #380:
Line #381:if (field.value != "") {
Line #382: window.location.href = "QJ_cimtar.php?&mod=" + field.value;
Line #383: }
Line #384:
Line #385:}
Line #386:function firstChar(field, key) {
Line #387:
Line #388: alert(String.fromCharCode(key));
Line #389: var alphaExp = /[a-zA-Z]/;
Line #390: var numExp = /[0-9]/;
Line #391://if (String.fromCharCode(key).match(/[a-zA-Z]/)) {
Line #392: if (field.value.length <= 1 && field.value!=" ") {
Line #393: window.location.href = "QJ_cimtar.php?&char=" + field.value;
Line #394: document.search.user_ker.focus();
Line #395: } else {
Line #396: return false;
Line #397: }
Line #398:// } else {
Line #399:// return false;
Line #400:// }
Line #401:}
Line #402:function firstNum(field, key) {
Line #403:
Line #404: alert(String.fromCharCode(key));
Line #405: var alphaExp = /[a-zA-Z]/;
Line #406: var numExp = /[0-9]/;
Line #407:if (String.fromCharCode(key).match(/[0-9]/)) {
Line #408: if (field.value.length <= 1 && field.value!=" ") {
Line #409: window.location.href = "QJ_cimtar.php?&char=" + field.value;
Line #410: document.search.taj_ker.focus();
Line #411: } else {
Line #412: return false;
Line #413: }
Line #414: } else {
Line #415: return false;
Line #416: }
Line #417:}
Line #418:// -->
Line #419:</SCRIPT>
Line #420:
Line #421:
Line #422:<?php
Line #423:
Line #424:?>
Line #425: