i want to add a dropdown in the registration form so I choose teh "select" field type. but when i go to profile/search.php it doesn't show the dropdown for the created field but multiselect. how do i fix it?
$user_handler =& xoops_gethandler('user');
$criteria = new CriteriaCompo(new Criteria('source_language[i]', $ads->getVar('ads_lang1[i]')));
$criteria->add(new Criteria('target_language[i]', $ads->getVar('ads_lang2[i]')));
$users = $user_handler->getList($criteria);
unset($criteria);
$user_list = array_keys($users);
global $xoopsDB;
$sql = "
SELECT * FROM ".$xoopsDB->prefix('xoopsnotifications')."
LEFT JOIN ".$xoopsDB->prefix('user_profile')."
ON not_uid = profileid
WHERE
not_modid = '".intVal($mod_id)."' AND
not_itemid = '0' AND
not_category = 'global' AND
not_event = 'new_ads' AND
source_language = ".$xoopsDB->quoteString($ads->getVar('ads_lang1'))." AND
target_language = ".$xoopsDB->quoteString($ads->getVar('ads_lang2'));
$result = $xoopsDB->query($sql);
$user_handler =& xoops_gethandler('user');
$criteria = new CriteriaCompo(new Criteria('source_language', $ads->getVar('ads_lang1')));
$criteria->add(new Criteria('target_language', $ads->getVar('ads_lang2')));
$users = $user_handler->getList($criteria);
unset($criteria);
$user_list = array_keys($users);
$module_handler =& xoops_gethandler('module');
$module = $module_handler->getByDirname('ads');//change ads to the name of the module
$module_id = $module->getVar('mid');
$not_handler =& xoops_gethandler('notification');
$not_handler->subscribe($category, $item_id, $events, $mode, $module_id, $user_id);
global $xoopsDB;
$sql = "
SELECT * FROM ".$xoopsDB->prefix('xoopsnotifications')."
LEFT JOIN ".$xoopsDB->prefix('user_profile')."
ON not_uid = profileid
WHERE
not_modid = '".intVal($mod_id)."' AND
not_itemid = '0' AND
not_category = 'global' AND
not_event = 'new_ads' AND
source_language = ".$xoopsDB->quoteString($ads->getVar('ads_lang1'))." AND
target_language = ".$xoopsDB->quoteString($ads->getVar('ads_lang2'));
$result = $xoopsDB->query($sql);
$user_list = array();
while($row = $xoopsDB->fetchArray($result)){
$user_list[] = $row['not_uid'];
}
$notification_handler->triggerEvent('global', 0, 'new_ads', $tags, $user_list);