function forum_save_settings($forum_settings_array)
{
if (!is_array($forum_settings_array)) {
return false;
}
if (!($db = db::get())) {
return false;
}
if (!($table_prefix = get_table_prefix())) {
return false;
}
if (!($forum_fid = get_forum_fid())) {
return false;
}
foreach ($forum_settings_array as $setting_name => $setting_value) {
if (forum_check_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 ({$forum_fid}, '{$setting_name}', '{$setting_value}')";
$sql .= "ON DUPLICATE KEY UPDATE SVALUE = VALUES(SVALUE)";
if (!$db->query($sql)) {
return false;
}
}
}
return true;
}
function forum_save_settings($forum_settings_array)
{
if (!is_array($forum_settings_array)) {
return false;
}
if (!($db_forum_save_settings = db_connect())) {
return false;
}
if (!($table_data = get_table_prefix())) {
return false;
}
$forum_fid = $table_data['FID'];
foreach ($forum_settings_array as $sname => $svalue) {
if (forum_check_setting_name($sname)) {
$sname = db_escape_string($sname);
$svalue = db_escape_string($svalue);
$sql = "SELECT SVALUE FROM FORUM_SETTINGS WHERE FID = '{$forum_fid}' ";
$sql .= "AND SNAME = '{$sname}'";
if (!($result = db_query($sql, $db_forum_save_settings))) {
return false;
}
if (db_num_rows($result) > 0) {
$sql = "UPDATE LOW_PRIORITY FORUM_SETTINGS SET SVALUE = '{$svalue}' WHERE FID = '{$forum_fid}' ";
$sql .= "AND SNAME = '{$sname}'";
if (!($result = db_query($sql, $db_forum_save_settings))) {
return false;
}
} else {
$sql = "INSERT INTO FORUM_SETTINGS (FID, SNAME, SVALUE) ";
$sql .= "VALUES ({$forum_fid}, '{$sname}', '{$svalue}')";
if (!($result = db_query($sql, $db_forum_save_settings))) {
return false;
}
}
}
}
return true;
}
