@@ -113,31 +113,31 @@ |
||
| 113 | 113 | // Handle Input "Search in main fields" |
| 114 | 114 | if ($searchfields != '') { |
| 115 | 115 | |
| 116 | - /*start search by TV. Added Rising13*/ |
|
| 117 | - $tbl_site_tmplvar_contentvalues = $modx->getFullTableName('site_tmplvar_contentvalues'); |
|
| 118 | - $articul_query = "SELECT `contentid` FROM {$tbl_site_tmplvar_contentvalues} WHERE `value` LIKE '%{$searchfields}%'"; |
|
| 119 | - $articul_result = $modx->db->query($articul_query); |
|
| 120 | - $articul_id_array = $modx->db->makeArray($articul_result); |
|
| 121 | - if(count($articul_id_array)>0){ |
|
| 122 | - $articul_id = ''; |
|
| 123 | - $i = 1; |
|
| 124 | - foreach( $articul_id_array as $articul ) { |
|
| 125 | - $articul_id.=$articul['contentid']; |
|
| 126 | - if($i !== count($articul_id_array)){ |
|
| 127 | - $articul_id.=','; |
|
| 128 | - } |
|
| 129 | - $i++; |
|
| 130 | - } |
|
| 131 | - $articul_id_query = " OR sc.id IN ({$articul_id})"; |
|
| 132 | - }else{ |
|
| 133 | - $articul_id_query = ''; |
|
| 134 | - } |
|
| 135 | - /*end search by TV*/ |
|
| 116 | + /*start search by TV. Added Rising13*/ |
|
| 117 | + $tbl_site_tmplvar_contentvalues = $modx->getFullTableName('site_tmplvar_contentvalues'); |
|
| 118 | + $articul_query = "SELECT `contentid` FROM {$tbl_site_tmplvar_contentvalues} WHERE `value` LIKE '%{$searchfields}%'"; |
|
| 119 | + $articul_result = $modx->db->query($articul_query); |
|
| 120 | + $articul_id_array = $modx->db->makeArray($articul_result); |
|
| 121 | + if(count($articul_id_array)>0){ |
|
| 122 | + $articul_id = ''; |
|
| 123 | + $i = 1; |
|
| 124 | + foreach( $articul_id_array as $articul ) { |
|
| 125 | + $articul_id.=$articul['contentid']; |
|
| 126 | + if($i !== count($articul_id_array)){ |
|
| 127 | + $articul_id.=','; |
|
| 128 | + } |
|
| 129 | + $i++; |
|
| 130 | + } |
|
| 131 | + $articul_id_query = " OR sc.id IN ({$articul_id})"; |
|
| 132 | + }else{ |
|
| 133 | + $articul_id_query = ''; |
|
| 134 | + } |
|
| 135 | + /*end search by TV*/ |
|
| 136 | 136 | |
| 137 | 137 | if (ctype_digit($searchfields)) { |
| 138 | 138 | $sqladd .= "sc.id='{$searchfields}'"; |
| 139 | 139 | if (strlen($searchfields) > 3) { |
| 140 | - $sqladd .= $articul_id_query;//search by TV |
|
| 140 | + $sqladd .= $articul_id_query;//search by TV |
|
| 141 | 141 | $sqladd .= " OR sc.pagetitle LIKE '%{$searchfields}%'"; |
| 142 | 142 | } |
| 143 | 143 | } |