You are right .
If search in many rows ,server will be killed.
Once I want to search in posts , I agree that it's better search in search_words .
But it's better that add % in like statement,it will not increase load of server , and makes it easier to search..
1 2016-08-05 09:11
Re: search bug and how to correction. (3 replies, posted in PunBB 1.4 bug reports)
2 2016-08-04 09:45
Topic: Simplified Chinese language package of quadric_image_assistant (0 replies, posted in PunBB 1.4 additions)
quadric_image_assistant
pun_attachment
I can't attache to this post , in face I can't attache any file to post .
Why I have't the privilege ?
3 2016-08-04 09:35
Topic: search bug and how to correction. (3 replies, posted in PunBB 1.4 bug reports)
punbb version : 1.44 - 1.3
post message is : 123abc
serarch : 123
result: can't find the post ,search did't work.
serarch : abc
result: can't find the post ,search did't work.
serarch : 123abc
result: can find the post ,search work coreectly.
-----------------------------------------------------------------------------------
reason:
search sql statement ,like lack % .
-----------------------------------------------------------------------------------
correction:
file name: punbase/include/search_functions.php
position: 105
replace : 'WHERE' => 'w.word LIKE \''.$forum_db->escape(str_replace('*', '%', $cur_word)).'\''
with : 'WHERE' => 'w.word LIKE \'%'.$forum_db->escape(str_replace('*', '', $cur_word)).'%\''
can you read it ? my english is poor.
By the way , this account is't mine .
I have mail like xxx@163.com , xxx@mail2world.com ,but I can't rgister a forum account .
How difficult to register it is !
if this is your account ,please email to 191682430@163.com .