function coloreditor($data, $color_name) { global $dbh; global $client; $insertvalues = ''; foreach ($data as $name => $value) { $insertvalues .= "('" . mysqli_real_escape_string($dbh, $name) . "', '" . mysqli_real_escape_string($dbh, $value) . "', '" . mysqli_real_escape_string($dbh, $color_name) . "'),"; } $insertvalues = rtrim($insertvalues, ','); if (!empty($insertvalues)) { $sql = "replace into `cometchat_colors` (`color_key`,`color_value`, `color`) values " . $insertvalues; $query = mysqli_query($dbh, $sql); } removeCachedSettings($client . 'cometchat_color'); if (is_dir(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'writable' . DIRECTORY_SEPARATOR . 'cache' . DIRECTORY_SEPARATOR . $client)) { clearcache(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'writable' . DIRECTORY_SEPARATOR . 'cache' . DIRECTORY_SEPARATOR . $client); } }
function setCachedSettings($key, $contents, $timeout = 60) { if (empty($contents) || empty($key)) { return false; } removeCachedSettings($key); $GLOBALS['settingscache']->set($key, $contents, $timeout); }
function removecolorprocess() { global $ts; global $client; $color = $_GET['data']; $color_array = array('standard', 'glass', 'facebook', 'hangout', 'synergy'); if (!in_array($color, $color_array) && !empty($color)) { $sql = "delete from `cometchat_colors` where `color` = '" . mysqli_real_escape_string($GLOBALS['dbh'], $color) . "'"; mysqli_query($GLOBALS['dbh'], $sql); removeCachedSettings($client . 'cometchat_color'); $_SESSION['cometchat']['error'] = 'Color scheme deleted successfully'; } else { $_SESSION['cometchat']['error'] = 'Sorry, this color scheme cannot be deleted. Please manually remove the theme from the "themes/color" folder.'; } header("Location:?module=themes&ts={$ts}"); }
function uploadlanguageprocess() { global $ts; global $dbh; global $client; $sql = ""; $cumulative_rows = 0; $error = ''; if (!empty($_FILES["file"]["size"])) { if ($_FILES["file"]["error"] > 0) { $error = "Language corrupted. Please try again."; } else { if ($newlanguage = mb_unserialize(file_get_contents($_FILES['file']['tmp_name']))) { $sql = ""; $cumulative_rows = 0; foreach ($newlanguage as $code => $langdata) { foreach ($langdata as $type => $addondata) { foreach ($addondata as $name => $lang_keys) { foreach ($lang_keys as $lang_key => $lang_text) { $sql .= "insert into `cometchat_languages` set `lang_key` = '" . mysqli_real_escape_string($dbh, $lang_key) . "', `lang_text` = '" . mysqli_real_escape_string($dbh, $lang_text) . "', `code` = '" . mysqli_real_escape_string($dbh, $code) . "', `type` = '" . mysqli_real_escape_string($dbh, $type) . "', `name` = '" . mysqli_real_escape_string($dbh, $name) . "' on duplicate key update `lang_key` = '" . mysqli_real_escape_string($dbh, $lang_key) . "', `lang_text` = '" . mysqli_real_escape_string($dbh, $lang_text) . "', `code` = '" . mysqli_real_escape_string($dbh, $code) . "', `type` = '" . mysqli_real_escape_string($dbh, $type) . "', `name` = '" . mysqli_real_escape_string($dbh, $name) . "';"; } } } } if (mysqli_multi_query($GLOBALS['dbh'], $sql)) { do { $cumulative_rows += mysqli_affected_rows($GLOBALS['dbh']); } while (mysqli_more_results($GLOBALS['dbh']) && mysqli_next_result($GLOBALS['dbh'])); } } else { $error = "Invalid language file."; } } } else { $error = "Language not found. Please try again."; } if (!empty($error)) { $_SESSION['cometchat']['error'] = $error; header("Location: ?module=language&action=uploadlanguage&ts={$ts}"); exit; } $_SESSION['cometchat']['error'] = 'Language added successfully'; removeCachedSettings($client . 'cometchat_language'); header("Location: ?module=language&ts={$ts}"); exit; }