Exemplo n.º 1
0
/**
 * Check if the specified field exists in a given table
 * @param string $p_field_name a database field name
 * @param string $p_table_name a valid database table name
 * @return bool indicating whether the field exists
 */
function db_field_exists($p_field_name, $p_table_name)
{
    global $g_db;
    $columns = db_field_names($p_table_name);
    return in_array($p_field_name, $columns);
}
Exemplo n.º 2
0
/**
 * Check if the specified field exists in a given table
 * @param string $p_field_name A database field name.
 * @param string $p_table_name A valid database table name.
 * @return boolean indicating whether the field exists
 */
function db_field_exists($p_field_name, $p_table_name)
{
    $t_columns = db_field_names($p_table_name);
    # ADOdb oci8 driver works with uppercase column names, and as of 5.19 does
    # not provide a way to force them to lowercase
    if (db_is_oracle()) {
        $p_field_name = strtoupper($p_field_name);
    }
    return in_array($p_field_name, $t_columns);
}
Exemplo n.º 3
0
# --------------------------------------------------------
require_once 'core.php';
$t_core_path = config_get('core_path');
require_once $t_core_path . 'icon_api.php';
auth_reauthenticate();
access_ensure_global_level(config_get('manage_user_threshold'));
$f_sort = gpc_get_string('sort', 'username');
$f_dir = gpc_get_string('dir', 'ASC');
$f_hide = gpc_get_bool('hide');
$f_save = gpc_get_bool('save');
$f_prefix = strtoupper(gpc_get_string('prefix', config_get('default_manage_user_prefix')));
$t_user_table = config_get('mantis_user_table');
$t_cookie_name = config_get('manage_cookie');
$t_lock_image = '<img src="' . config_get('icon_path') . 'protected.gif" width="8" height="15" border="0" alt="' . lang_get('protected') . '" />';
# Clean up the form variables
if (!in_array($f_sort, db_field_names($t_user_table))) {
    $c_sort = 'username';
} else {
    $c_sort = addslashes($f_sort);
}
if ($f_dir == 'ASC') {
    $c_dir = 'ASC';
} else {
    $c_dir = 'DESC';
}
if ($f_hide == 0) {
    # a 0 will turn it off
    $c_hide = 0;
} else {
    # anything else (including 'on') will turn it on
    $c_hide = 1;
Exemplo n.º 4
0
/**
 * Check if the specified field exists in a given table
 * @param string $p_field_name A database field name.
 * @param string $p_table_name A valid database table name.
 * @return boolean indicating whether the field exists
 */
function db_field_exists($p_field_name, $p_table_name)
{
    $t_columns = db_field_names($p_table_name);
    return in_array($p_field_name, $t_columns);
}