|
@@ -166,7 +166,7 @@ discard block |
|
|
block discarded – undo |
|
166
|
166
|
$query_where = array(); |
|
167
|
167
|
$query_params = $search_data['params']; |
|
168
|
168
|
|
|
169
|
|
- if( $smcFunc['db_title'] == "PostgreSQL") |
|
|
169
|
+ if ($smcFunc['db_title'] == "PostgreSQL") |
|
170
|
170
|
$modSettings['search_simple_fulltext'] = true; |
|
171
|
171
|
|
|
172
|
172
|
if ($query_params['id_search']) |
|
@@ -209,7 +209,7 @@ discard block |
|
|
block discarded – undo |
|
209
|
209
|
|
|
210
|
210
|
if (!empty($modSettings['search_simple_fulltext'])) |
|
211
|
211
|
{ |
|
212
|
|
- if($smcFunc['db_title'] == "PostgreSQL") |
|
|
212
|
+ if ($smcFunc['db_title'] == "PostgreSQL") |
|
213
|
213
|
{ |
|
214
|
214
|
$language_ftx = $smcFunc['db_search_language'](); |
|
215
|
215
|
|
|
@@ -227,7 +227,7 @@ discard block |
|
|
block discarded – undo |
|
227
|
227
|
// remove any indexed words that are used in the complex body search terms |
|
228
|
228
|
$words['indexed_words'] = array_diff($words['indexed_words'], $words['complex_words']); |
|
229
|
229
|
|
|
230
|
|
- if($smcFunc['db_title'] == "PostgreSQL"){ |
|
|
230
|
+ if ($smcFunc['db_title'] == "PostgreSQL") { |
|
231
|
231
|
$row = 0; |
|
232
|
232
|
foreach ($words['indexed_words'] as $fulltextWord) { |
|
233
|
233
|
$query_params['boolean_match'] .= ($row <> 0 ? '&' : ''); |
|
@@ -243,7 +243,7 @@ discard block |
|
|
block discarded – undo |
|
243
|
243
|
|
|
244
|
244
|
// if we have bool terms to search, add them in |
|
245
|
245
|
if ($query_params['boolean_match']) { |
|
246
|
|
- if($smcFunc['db_title'] == "PostgreSQL") |
|
|
246
|
+ if ($smcFunc['db_title'] == "PostgreSQL") |
|
247
|
247
|
{ |
|
248
|
248
|
$language_ftx = $smcFunc['db_search_language'](); |
|
249
|
249
|
|
|
@@ -256,7 +256,7 @@ discard block |
|
|
block discarded – undo |
|
256
|
256
|
|
|
257
|
257
|
} |
|
258
|
258
|
|
|
259
|
|
- $ignoreRequest = $smcFunc['db_search_query']('insert_into_log_messages_fulltext', ($smcFunc['db_support_ignore'] ? ( ' |
|
|
259
|
+ $ignoreRequest = $smcFunc['db_search_query']('insert_into_log_messages_fulltext', ($smcFunc['db_support_ignore'] ? (' |
|
260
|
260
|
INSERT IGNORE INTO {db_prefix}' . $search_data['insert_into'] . ' |
|
261
|
261
|
(' . implode(', ', array_keys($query_select)) . ')') : '') . ' |
|
262
|
262
|
SELECT ' . implode(', ', $query_select) . ' |