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;
}