function saveTokenInDB($conn, $token)
{
if (!checkUnique($conn, $token)) {
return false;
}
$stmt = $conn->prepare("insert into users (token, firstVisit, lastVisit) VALUES(?, NOW(), NOW())");
if (!$stmt) {
printError();
}
if ($stmt->bind_param("s", $token)) {
if ($stmt->execute()) {
return true;
} else {
printError();
}
} else {
printError();
}
}
} else {
if ($createTables) {
echo gettext('Done with table update');
} else {
echo gettext('Done with table update with errors');
}
}
echo "</h3>";
checkUnique($tbl_administrators, array('valid' => 0, 'user' => 0));
checkUnique($tbl_albums, array('folder' => 0));
checkUnique($tbl_images, array('albumid' => 0, 'filename' => 0));
checkUnique($tbl_options, array('name' => 0, 'ownerid' => 0, 'theme' => 0));
checkUnique($tbl_news_categories, array('titlelink' => 0));
checkUnique($tbl_news, array('titlelink' => 0));
checkUnique($tbl_pages, array('titlelink' => 0));
checkUnique($tbl_tags, array('name' => 0));
// set defaults on any options that need it
setupLog(gettext("Done with database creation and update"));
if ($prevRel = getOption('zenphoto_release')) {
setupLog(sprintf(gettext("Previous Release was %s"), $prevRel), true);
}
require dirname(__FILE__) . '/setup-option-defaults.php';
if ($debug == 'base64') {
// update zenpage codeblocks--remove the base64 encoding
$sql = 'SELECT `id`, `codeblock` FROM ' . prefix('news') . ' WHERE `codeblock` NOT REGEXP "^a:[0-9]+:{"';
$result = query_full_array($sql, false);
if (is_array($result)) {
foreach ($result as $row) {
$codeblock = base64_decode($row['codeblock']);
$sql = 'UPDATE ' . prefix('news') . ' SET `codeblock`=' . db_quote($codeblock) . ' WHERE `id`=' . $row['id'];
query($sql);
$str = '';
for ($i = 0; $i < $len; $i++) {
$str .= substr($pool, mt_rand(0, strlen($pool) - 1), 1);
}
return $str;
break;
case 'unique':
return md5(uniqid(mt_rand()));
break;
}
}
//create userprofile url
$nospacename = $_POST['username'];
// need to create singleword for user profileurl
$createprofileurl = str_replace(" ", "", $nospacename);
if ($_POST['username'] != '' && $_POST['password'] != '' && $_POST['password'] == $_POST['password_confirmed'] && $_POST['email'] != '' && valid_email($_POST['email']) == TRUE && checkUnique('Username', $_POST['username']) == TRUE && checkUnique('Email', $_POST['email']) == TRUE) {
$db->query = "INSERT INTO users (Username , Password, Email, Active, Level_access, Random_key, userprofile) VALUES ('" . mysql_real_escape_string($_POST['username']) . "', '" . mysql_real_escape_string(md5($_POST['password'])) . "', '" . mysql_real_escape_string($_POST['email']) . "', '1', '3', '" . random_string('alnum', 32) . "', '{$createprofileurl}') ";
$resultbaseurl = mysql_query($db->query) or die(mysql_error());
} else {
$error = 'There is an error with the registration data. Either the username and/or email address are already taken or the password comfirmation is different from the password entered.';
}
echo '<h1>Setup is complete.</h1>';
echo 'Go to ';
?>
<a href="<?php
echo LLFOLDER;
?>
controlpanel/login/login.php">Control Panel Login</a><?php
}
// closes if installed pressed
?>
loadForm();
} elseif ($action == 'autoload') {
autoloadForm();
} elseif ($action == 'mail') {
mailForm();
} elseif ($action == 'dbmail') {
saveToDB();
mailForm();
} elseif ($action == 'submit') {
saveToDB();
} elseif ($action == 'delete') {
deleteForm();
} elseif ($action == 'updatebyid') {
updateFormById();
} elseif ($action == 'unique') {
checkUnique();
} else {
echo "Action Not Recognized";
}
exit;
function autoloadForm()
{
$dataPost = $_POST;
printArray($dataPost);
}
function loadForm()
{
$dataPost = $_POST;
if (isset($dataPost["frmID"])) {
$sForm = $dataPost["frmID"];
unset($dataPost["frmID"]);
