}
//connect .. for check
$SQL = new SSQL($dbserver, $dbuser, $dbpass, $dbname);
include_once '../includes/usr.php';
include_once '../includes/functions_alternative.php';
$usrcp = new usrcp();
$user_salt = substr(kleeja_base64_encode(pack("H*", sha1(mt_rand()))), 0, 7);
$user_pass = $usrcp->kleeja_hash_password($_POST['password'] . $user_salt);
$user_name = $SQL->escape($_POST['username']);
$user_mail = $SQL->escape($_POST['email']);
$config_sitename = $SQL->escape($_POST['sitename']);
$config_siteurl = $SQL->escape($_POST['siteurl']);
$config_sitemail = $SQL->escape($_POST['sitemail']);
$config_style = $SQL->escape($_POST['style']);
$config_urls_type = in_array($_POST['urls_type'], array('id', 'filename', 'direct')) ? $_POST['urls_type'] : 'id';
$clean_name = $usrcp->cleanusername($SQL->escape($user_name));
/// ok .. we will get sqls now ..
include 'includes/install_sqls.php';
include 'includes/default_values.php';
$err = $dots = 0;
$errors = '';
//do important alter before
$SQL->query($install_sqls['ALTER_DATABASE_UTF']);
$sqls_done = $sql_err = array();
foreach ($install_sqls as $name => $sql_content) {
if ($name == 'DROP_TABLES' || $name == 'ALTER_DATABASE_UTF') {
continue;
}
if ($SQL->query($sql_content)) {
if ($name == 'call') {
$sqls_done[] = $lang['INST_CRT_CALL'];
function update_clean_name()
{
global $SQL, $dbprefix, $_path, $lang;
include_once $_path . 'includes/usr.php';
$usrcp = new usrcp();
$last_id_was = 0;
$user_per_refresh = 100;
$is = isset($_GET['is_us']) ? intval($_GET['is_us']) : 0;
$num_users = isset($_GET['num_users']) ? intval($_GET['num_users']) : 0;
$loop = isset($_GET['loop']) ? intval($_GET['loop']) + 1 : 1;
$query = array('SELECT' => 'COUNT(id) AS total_users', 'FROM' => "{$dbprefix}users");
$result = $SQL->build($query);
if ($is == 0) {
$result = $SQL->build($query);
$num_users = 0;
$n_fetch = $SQL->fetch_array($result);
$num_users = $n_fetch['total_users'];
}
$query = array('SELECT' => 'id, clean_name, name', 'FROM' => "{$dbprefix}users", 'WHERE' => 'id > ' . $is, 'ORDER BY' => 'id ASC', 'LIMIT' => $user_per_refresh);
$result = $SQL->build($query);
while ($row = $SQL->fetch_array($result)) {
$last_id_was = $row['id'];
if ($row['clean_name'] == '') {
$update_query = array('UPDATE' => "{$dbprefix}users", 'SET' => "clean_name = '" . $SQL->escape($usrcp->cleanusername($row['name'])) . "'", 'WHERE' => "id=" . $row['id']);
$SQL->build($update_query);
}
}
$SQL->freeresult($result);
global $update_msgs_arr;
$update_msgs_arr[] = '<span style="color:green;">' . $lang['RC6_1_CNV_CLEAN_NAMES'] . ' [ <strong>' . $loop . ' -> ' . ceil($num_users / $user_per_refresh) . '</strong> ] </span>';
if ($num_users > $last_id_was) {
$url = 'update.php?step=update_now&complet_up_func=1&action_file_do=' . htmlspecialchars($_GET['action_file_do']) . '&is_us=' . $last_id_was . '&num_users=' . $num_users . '&loop=' . $loop . '&lang=' . htmlspecialchars($_GET['lang']);
echo '<meta http-equiv="refresh" content="4; url=' . $url . '" />';
}
}
