for the admin search I'm stuck
I guess the part that needs to be moded is:
$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.catagory_status from " . TABLE_NEWSDESK_CATEGORIES . " c, " . TABLE_NEWSDESK_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' and cd.categories_name like '%" . $HTTP_GET_VARS['search'] . "%' order by c.sort_order, cd.categories_name");
} else {
$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.catagory_status from " . TABLE_NEWSDESK_CATEGORIES . " c, " . TABLE_NEWSDESK_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $languages_id . "' order by c.sort_order, cd.categories_name");}
I have tried this:
$categories_query = tep_db_query("select c.newsdesk_id, cd.categories_name, c.language_id, c.newsdesk_article_name, c.newsdesk_article_description, c.newsdesk_article_shorttext from " . TABLE_NEWSDESK_CATEGORIES . " c, " . TABLE_NEWSDESK_DESCRIPTION . " cd where cd.language_id = '" . $languages_id . "' and cd.categories_name like '%" . $HTTP_GET_VARS['search'] . "%' or cd.newsdesk_article_name like '%" . $HTTP_GET_VARS['search'] . "%' or cd.newsdesk_article_description like '%" . $HTTP_GET_VARS['search'] . "%' or cd.newsdesk_article_shorttext like '%" . $HTTP_GET_VARS['search'] . "% order by c.sort_order, cd.categories_name");
I'm not far I think but can't get it yet...
if anyone has allready worked on it...