PHP forum_check_global_setting_name示例

示例#1

文件： forum.inc.php 项目： richstokoe/BeehiveForum

function forum_save_global_settings($forum_settings_array)
{
    if (!is_array($forum_settings_array)) {
        return false;
    }
    if (!($db = db::get())) {
        return false;
    }
    foreach ($forum_settings_array as $setting_name => $setting_value) {
        if (forum_check_global_setting_name($setting_name)) {
            $setting_name = $db->escape($setting_name);
            $setting_value = $db->escape($setting_value);
            $sql = "INSERT INTO FORUM_SETTINGS (FID, SNAME, SVALUE) ";
            $sql .= "VALUES ('0', '{$setting_name}', '{$setting_value}') ";
            $sql .= "ON DUPLICATE KEY UPDATE SVALUE = VALUES(SVALUE)";
            if (!$db->query($sql)) {
                return false;
            }
        }
    }
    return true;
}

示例#2

文件： source13873.php 项目： bjork/php-compat-info

function forum_save_default_settings($forum_settings_array)
{
    if (!is_array($forum_settings_array)) {
        return false;
    }
    if (!($db_forum_save_default_settings = db_connect())) {
        return false;
    }
    foreach ($forum_settings_array as $sname => $svalue) {
        if (forum_check_global_setting_name($sname)) {
            $sname = db_escape_string($sname);
            $svalue = db_escape_string($svalue);
            $sql = "SELECT SVALUE FROM FORUM_SETTINGS WHERE FID = '0' ";
            $sql .= "AND SNAME = '{$sname}'";
            if (!($result = db_query($sql, $db_forum_save_default_settings))) {
                return false;
            }
            if (db_num_rows($result) > 0) {
                $sql = "UPDATE LOW_PRIORITY FORUM_SETTINGS SET SVALUE = '{$svalue}' WHERE FID = '0' ";
                $sql .= "AND SNAME = '{$sname}'";
                if (!($result = db_query($sql, $db_forum_save_default_settings))) {
                    return false;
                }
            } else {
                $sql = "INSERT INTO FORUM_SETTINGS (FID, SNAME, SVALUE) ";
                $sql .= "VALUES ('0', '{$sname}', '{$svalue}')";
                if (!($result = db_query($sql, $db_forum_save_default_settings))) {
                    return false;
                }
            }
        }
    }
    return true;
}