function fetch_item_type_r($s_item_type)
{
$query = "SELECT ifnull(stlv.value, description) as description, image \n\tFROM s_item_type\n\tLEFT JOIN s_table_language_var stlv\n\t\t\tON stlv.language = '" . get_opendb_site_language() . "' AND\n\t\t\tstlv.tablename = 's_item_type' AND\n\t\t\tstlv.columnname = 'description' AND\n\t\t\tstlv.key1 = s_item_type \n\tWHERE s_item_type = '{$s_item_type}'";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
$found = db_fetch_assoc($result);
db_free_result($result);
return $found;
} else {
return FALSE;
}
}
function fetch_status_type_r($s_status_type)
{
$query = "SELECT sst.s_status_type, IFNULL(stlv.value, sst.description) AS description, sst.img, " . "sst.delete_ind, sst.change_owner_ind, sst.borrow_ind, sst.status_comment_ind, sst.hidden_ind, sst.default_ind, sst.closed_ind ";
$query .= " FROM s_status_type sst " . "LEFT JOIN s_table_language_var stlv\n\t\t\tON stlv.language = '" . get_opendb_site_language() . "' AND\n\t\t\tstlv.tablename = 's_status_type' AND\n\t\t\tstlv.columnname = 'description' AND\n\t\t\tstlv.key1 = sst.s_status_type " . "WHERE sst.s_status_type = '{$s_status_type}' " . "LIMIT 0,1";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
$found = db_fetch_assoc($result);
db_free_result($result);
return $found;
} else {
return FALSE;
}
}
function fetch_user_r($uid)
{
$query = "SELECT u.user_id, \n\t\t\tu.fullname, \n\t\t\tu.user_role,\n\t\t\tIFNULL(stlv.value, sr.description) AS role_description, \n\t\t\tu.language, \n\t\t\tu.theme, \n\t\t\tu.email_addr, \n\t\t\tu.lastvisit,\n\t\t\tu.active_ind \n\tFROM (user u, s_role sr) \n\tLEFT JOIN s_table_language_var stlv\n\tON stlv.language = '" . get_opendb_site_language() . "' AND\n\tstlv.tablename = 's_role' AND\n\tstlv.columnname = 'description' AND\n\tstlv.key1 = sr.role_name\n\tWHERE u.user_role = sr.role_name \n\t\tAND u.user_id = '" . $uid . "'";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
$found = db_fetch_assoc($result);
db_free_result($result);
return $found;
}
return FALSE;
}
function get_theme_img_search_dir_list()
{
$theme = get_opendb_site_theme();
$language = strtolower(get_opendb_site_language());
$dirPath = array();
if (strlen($theme) > 0 && strlen($language) > 0) {
$dirPath[] = "images/{$theme}/{$language}";
}
if (strlen($theme) > 0) {
$dirPath[] = "images/{$theme}";
}
if (strlen($language) > 0) {
$dirPath[] = "images/default/{$language}";
}
$dirPath[] = "images/default/images";
$dirPath[] = "images";
return $dirPath;
}
function fetch_site_plugin_input_field_r($site_type, $field)
{
$query = "SELECT order_no, field, description, IFNULL(stlv.value, prompt) AS prompt, field_type, default_value, refresh_mask " . "FROM s_site_plugin_input_field " . "LEFT JOIN s_table_language_var stlv\n\t\t\tON stlv.language = '" . get_opendb_site_language() . "' AND\n\t\t\tstlv.tablename = 's_site_plugin_input_field' AND\n\t\t\tstlv.columnname = 'prompt' AND\n\t\t\tstlv.key1 = site_type AND\n\t\t\tstlv.key2 = field " . "WHERE site_type = '" . $site_type . "' AND field = '{$field}'";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
$found = db_fetch_assoc($result);
db_free_result($result);
return $found;
} else {
return FALSE;
}
}
/**
* @param $mode - One of 'query' or 'edit'.
*
* In 'query' mode, will restrict what records
*/
function fetch_address_type_attribute_type_rs($s_address_type, $mode = 'query', $order_by = FALSE)
{
$query = "SELECT sadt.s_address_type, " . "saatr.s_attribute_type, " . "saatr.order_no, " . "if(length(IFNULL(stlv.value,saatr.prompt))>0,IFNULL(stlv.value,saatr.prompt),IFNULL(stlv2.value,sat.prompt)) as prompt, " . "sat.display_type, " . "sat.display_type_arg1," . "sat.display_type_arg2," . "sat.display_type_arg3," . "sat.display_type_arg4," . "sat.display_type_arg5," . "sat.input_type," . "sat.input_type_arg1," . "sat.input_type_arg2," . "sat.input_type_arg3," . "sat.input_type_arg4," . "sat.input_type_arg5," . "sat.listing_link_ind ";
if ($mode == 'update') {
$query .= ", 'N' as compulsory_ind ";
}
$query .= "FROM\t(s_addr_attribute_type_rltshp saatr, " . "s_attribute_type sat, " . "s_address_type sadt) " . "LEFT JOIN s_table_language_var stlv\n\t\t\tON stlv.language = '" . get_opendb_site_language() . "' AND\n\t\t\tstlv.tablename = 's_addr_attribute_type_rltshp' AND\n\t\t\tstlv.columnname = 'prompt' AND\n\t\t\tstlv.key1 = saatr.s_address_type AND\n\t\t\tstlv.key2 = saatr.s_attribute_type AND\n\t\t\tstlv.key3 = saatr.order_no " . "LEFT JOIN s_table_language_var stlv2\n\t\t\tON stlv2.language = '" . get_opendb_site_language() . "' AND\n\t\t\tstlv2.tablename = 's_attribute_type' AND\n\t\t\tstlv2.columnname = 'prompt' AND\n\t\t\tstlv2.key1 = sat.s_attribute_type " . "WHERE sadt.s_address_type = '" . $s_address_type . "' AND " . "saatr.s_address_type = sadt.s_address_type AND " . "sat.s_attribute_type = saatr.s_attribute_type ";
if ($mode == 'update') {
// do not close for display purposes, only update
$query .= "AND sadt.closed_ind <> 'Y' AND saatr.closed_ind <> 'Y'";
}
if ($order_by) {
$query .= "order by saatr.s_address_type ASC, saatr.order_no ASC";
}
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
return $result;
} else {
return FALSE;
}
}
function fetch_attribute_type_r($s_attribute_type)
{
$query = "SELECT sat.s_attribute_type," . "IFNULL(stlv.value, sat.prompt) AS prompt," . "IFNULL(stlv2.value, sat.description) AS description," . "sat.display_type, " . "sat.display_type_arg1," . "sat.display_type_arg2," . "sat.display_type_arg3," . "sat.display_type_arg4," . "sat.display_type_arg5," . "sat.input_type," . "sat.input_type_arg1," . "sat.input_type_arg2," . "sat.input_type_arg3," . "sat.input_type_arg4," . "sat.input_type_arg5," . "sat.listing_link_ind," . "sat.s_field_type, " . "sat.lookup_attribute_ind, " . "sat.multi_attribute_ind, " . "sat.file_attribute_ind " . "FROM\ts_attribute_type sat " . "LEFT JOIN s_table_language_var stlv ON\n\t\t\t\tstlv.language = '" . get_opendb_site_language() . "' AND\n\t\t\t\tstlv.tablename = 's_attribute_type' AND\n\t\t\t\tstlv.columnname = 'prompt' AND\n\t\t\t\tstlv.key1 = sat.s_attribute_type " . "LEFT JOIN s_table_language_var stlv2 ON\n\t\t\t\tstlv2.language = '" . get_opendb_site_language() . "' AND\n\t\t\t\tstlv2.tablename = 's_attribute_type' AND\n\t\t\t\tstlv2.columnname = 'description' AND\n\t\t\t\tstlv2.key1 = sat.s_attribute_type " . "WHERE\tsat.s_attribute_type = '" . $s_attribute_type . "'";
$result = db_query($query);
if ($result && db_num_rows($result) > 0) {
$record_r = db_fetch_assoc($result);
db_free_result($result);
return $record_r;
} else {
return FALSE;
}
}
