+ $sql_extra = " AND ((`profile`.`name` LIKE '%$search%') OR
+ (`user`.`nickname` LIKE '%$search%') OR
+ (`profile`.`pdesc` LIKE '%$search%') OR
+ (`profile`.`locality` LIKE '%$search%') OR
+ (`profile`.`region` LIKE '%$search%') OR
+ (`profile`.`country-name` LIKE '%$search%') OR
+ (`profile`.`gender` LIKE '%$search%') OR
+ (`profile`.`marital` LIKE '%$search%') OR
+ (`profile`.`sexual` LIKE '%$search%') OR
+ (`profile`.`about` LIKE '%$search%') OR
+ (`profile`.`romance` LIKE '%$search%') OR
+ (`profile`.`work` LIKE '%$search%') OR
+ (`profile`.`education` LIKE '%$search%') OR
+ (`profile`.`pub_keywords` LIKE '%$search%') OR
+ (`profile`.`prv_keywords` LIKE '%$search%'))";
+ }
+
+ $publish = ((Config::get('system','publish_all')) ? '' : " AND `publish` = 1 " );