function cs_redirectmsg($message, $id = 0, $icon = 0)
{
global $cs_lang, $cs_logs, $cs_main;
$sql = cs_sql_error();
$php = $cs_logs['php_errors'];
if (!empty($cs_main['debug']) && (!empty($sql) || !empty($php))) {
$message = $cs_lang['error'] . cs_html_br(1);
$icon = 'alert';
if (!empty($sql)) {
$message .= '<div id="errors">' . '<strong>SQL -></strong> ' . $sql . '</div>';
}
if (!empty($php)) {
$message .= '<div id="errors">' . $php . '</div>';
}
}
$_SESSION['message'] = $message;
if (!empty($id) || !empty($icon)) {
$_SESSION['messageadd'] = $icon . ',' . $id;
}
}
function cs_sql_version($cs_file)
{
global $cs_db;
$sql_infos = array('data_free' => 0, 'data_size' => 0, 'index_size' => 0, 'tables' => 0, 'names' => array());
$sql_infos['type'] = 'PostgreSQL (pgsql)';
$sql_infos['host'] = pg_host($cs_db['con']) or cs_error_sql($cs_file, 'cs_sql_version', cs_sql_error());
if (function_exists('pg_version')) {
$pg_infos = pg_version($cs_db['con']) or cs_error_sql($cs_file, 'cs_sql_version', cs_sql_error());
}
$sql_infos['encoding'] = pg_client_encoding($cs_db['con']);
$sql_infos['client'] = isset($pg_infos['client']) ? $pg_infos['client'] : '-';
$sql_infos['server'] = isset($pg_infos['server_version']) ? $pg_infos['server_version'] : '-';
if ($sql_infos['server'] == '-') {
$found = cs_sql_query($cs_file, 'SELECT VERSION()', 1);
preg_match('=[\\d|.]+=', $found['more'][0]['version'], $matches, PREG_OFFSET_CAPTURE);
$sql_infos['server'] = isset($matches[0][0]) ? $matches[0][0] : $found['more'][0]['version'];
}
return $sql_infos;
}
function cs_sql_version($cs_file)
{
global $cs_db;
$subtype = empty($cs_db['subtype']) ? 'myisam' : strtolower($cs_db['subtype']);
$sql_infos = array('data_free' => 0, 'data_size' => 0, 'index_size' => 0, 'tables' => 0, 'names' => array());
$sql_query = "SHOW TABLE STATUS LIKE '" . cs_sql_escape($cs_db['prefix'] . '_') . "%'";
$sql_data = mysqli_query($cs_db['con'], $sql_query) or cs_error_sql($cs_file, 'cs_sql_version', cs_sql_error(0, $sql_query));
while ($row = mysqli_fetch_assoc($sql_data)) {
$sql_infos['data_size'] += $row['Data_length'];
$sql_infos['index_size'] += $row['Index_length'];
$sql_infos['data_free'] += $subtype == 'innodb' ? 0 : $row['Data_free'];
$sql_infos['tables']++;
$sql_infos['names'][] .= $row['Name'];
}
mysqli_free_result($sql_data);
cs_log_sql($cs_file, $sql_query);
$sql_infos['encoding'] = mysqli_character_set_name($cs_db['con']);
$sql_infos['type'] = 'MySQL (mysqli)';
$sql_infos['subtype'] = empty($cs_db['subtype']) ? 'myisam' : $cs_db['subtype'];
$sql_infos['client'] = mysqli_get_client_info();
$sql_infos['host'] = mysqli_get_host_info($cs_db['con']) or cs_error_sql($cs_file, 'cs_sql_version', cs_sql_error());
$sql_infos['server'] = mysqli_get_server_info($cs_db['con']) or cs_error_sql($cs_file, 'cs_sql_version', cs_sql_error());
return $sql_infos;
}
function cs_sql_update($cs_file, $sql_table, $sql_cells, $sql_content, $sql_id, $sql_where = 0, $sql_log = 1)
{
global $cs_db;
settype($sql_id, 'integer');
$max = count($sql_cells);
$set = ' SET ';
for ($run = 0; $run < $max; $run++) {
$set .= $sql_cells[$run] . '=' . $cs_db['con']->quote((string) $sql_content[$run]);
if ($run != $max - 1) {
$set .= ', ';
}
}
$sql_update = 'UPDATE ' . $cs_db['prefix'] . '_' . $sql_table . $set . ' WHERE ';
if (empty($sql_where)) {
$sql_update .= $sql_table . '_id = ' . $sql_id;
} else {
$sql_update .= $sql_where;
}
if (!$cs_db['con']->query($sql_update)) {
cs_error_sql($cs_file, 'cs_sql_update', cs_sql_error(0, $sql_update));
}
cs_log_sql($cs_file, $sql_update, $sql_log);
}
function cs_sql_update($cs_file, $sql_table, $sql_cells, $sql_content, $sql_id, $sql_where = 0, $sql_log = 1)
{
global $cs_db;
settype($sql_id, 'integer');
$max = count($sql_cells);
$set = ' SET ';
for ($run = 0; $run < $max; $run++) {
$set .= $sql_cells[$run] . "='" . str_replace("'", "''", (string) $sql_content[$run]);
if ($run != $max - 1) {
$set .= "', ";
}
}
$set .= "' ";
$sql_update = 'UPDATE ' . $cs_db['prefix'] . '_' . $sql_table . $set . ' WHERE ';
if (empty($sql_where)) {
$sql_update .= $sql_table . '_id = ' . $sql_id;
} else {
$sql_update .= $sql_where;
}
sqlsrv_query($cs_db['con'], $sql_update) or cs_error_sql($cs_file, 'cs_sql_update', cs_sql_error(0, $sql_update));
cs_log_sql($cs_file, $sql_update, $sql_log);
}
function cs_sql_version($cs_file)
{
global $cs_db;
$version = $cs_db['con']->version();
$sql_infos = array('data_free' => 0, 'data_size' => 0, 'index_size' => 0, 'tables' => 0, 'names' => array());
$sql_infos['type'] = 'SQLite 3 (sqlite3)';
$sql_infos['host'] = 'localhost';
$sql_infos['client'] = $version['versionString'];
$sql_infos['server'] = $version['versionString'];
$sql_infos['encoding'] = 'default';
$sql_query = 'SELECT COUNT(*) FROM sqlite_master WHERE type = \'table\' AND name LIKE \'' . $cs_db['prefix'] . '_%\'';
$sql_query = str_replace('{pre}', $cs_db['prefix'], $sql_query);
if (!($sql_data = $cs_db['con']->query($sql_query))) {
cs_error_sql($cs_file, 'cs_sql_count', cs_sql_error(0, $sql_query));
} else {
$sql_result = $sql_data->fetcharray(SQLITE3_NUM);
$sql_infos['tables'] = $sql_result[0];
$sql_infos['data_size'] = filesize($cs_db['name']);
}
cs_log_sql($cs_file, $sql_query);
return $sql_infos;
}
