}
}
echo '</ul>';
//fix table data
echo draw_h3('Fix Table Data');
echo '<ul>';
//null passwords
db_query('UPDATE users SET language_id = 1');
db_query('UPDATE users SET email = "*****@*****.**" WHERE id = 1');
echo draw_li('passwords have been nulled');
//fix images
$users = db_table('SELECT id, image_large FROM users WHERE image_large IS NOT NULL');
foreach ($users as $u) {
db_query('UPDATE users SET
image_medium = ' . format_binary(format_image_resize($u['image_large'], 135)) . ',
image_small = ' . format_binary(format_image_resize($u['image_large'], 50)) . '
WHERE id = ' . $u['id']);
}
echo draw_li('images have been fixed');
//pages url should only be page name
db_query('UPDATE pages SET is_active = 1');
$pages = db_table('SELECT id, url FROM pages WHERE url LIKE "%/%"');
if ($pages) {
foreach ($pages as $p) {
$pageparts = explode('/', $p['url']);
$p['url'] = trim($pageparts[count($pageparts) - 1]);
db_query('UPDATE pages SET url = "' . $p['url'] . '" WHERE id = ' . $p['id']);
}
echo draw_li('corrected ' . count($pages) . ' pages');
} else {
echo draw_li('pages are all correct');
function db_enter($table, $fields, $index = "id")
{
global $editing, $language, $user;
$fields = explode(" ", $fields);
foreach ($fields as $field) {
if ($field == "password") {
//binary password
if ($editing) {
$query1[] = $field . " = PWDENCRYPT('" . $_POST[$field] . "')";
} else {
$query1[] = $field;
$query2[] = $field . " = PWDENCRYPT('" . $_POST[$field] . "')";
}
} elseif (substr($field, 0, 1) == "#") {
//numeric
$field = substr($field, 1);
if (empty($_POST[$field])) {
$_POST[$field] = "NULL";
}
if ($editing) {
$query1[] = $field . " = " . $_POST[$field];
} else {
$query1[] = $field;
$query2[] = $_POST[$field];
}
} elseif (substr($field, 0, 1) == "*") {
//date
$field = substr($field, 1);
if (isset($_POST["no" . $field])) {
if ($editing) {
$query1[] = $field . " = NULL";
} else {
$query1[] = $field;
$query2[] = "NULL";
}
} else {
if ($editing) {
$query1[] = $field . " = " . format_post_date($field);
} else {
$query1[] = $field;
$query2[] = format_post_date($field);
}
}
} elseif (substr($field, 0, 1) == "@") {
//file
$field = substr($field, 1);
if (isset($_POST[$field])) {
//file posting is optional, from a php point of view
if ($editing) {
$query1[] = $field . " = " . format_binary($_POST[$field]);
} else {
$query1[] = $field;
$query2[] = format_binary($_POST[$field]);
}
}
} elseif (substr($field, 0, 1) == "|") {
//html
$field = substr($field, 1);
if (isset($_POST[$field])) {
if ($editing) {
$query1[] = $field . " = " . format_html($_POST[$field]);
} else {
$query1[] = $field;
$query2[] = "'" . format_html($_POST[$field]) . "'";
}
}
} else {
//text
$_POST[$field] = trim($_POST[$field]);
$_POST[$field] = empty($_POST[$field]) ? "NULL" : "'" . $_POST[$field] . "'";
if ($editing) {
$query1[] = $table . '.' . $field . " = " . $_POST[$field];
} else {
$query1[] = $table . '.' . $field;
$query2[] = $_POST[$field];
}
}
}
if ($editing) {
$query1[] = "updatedOn = GETDATE()";
if (isset($_POST["updatedBy"])) {
$query1[] = "updatedBy = " . $_POST["updatedBy"];
} else {
$query1[] = "updatedBy = " . $user["id"];
}
db_query("UPDATE " . $table . " SET " . implode(", ", $query1) . " WHERE " . $index . " = " . $_GET["id"]);
return $_GET["id"];
} else {
$query1[] = "createdOn";
$query2[] = "GETDATE()";
$query1[] = "createdBy";
$query2[] = isset($_POST["createdBy"]) ? $_POST["createdBy"] : $user["id"];
$query1[] = "isActive";
$query2[] = 1;
$r = db_query("INSERT INTO " . $table . " ( " . implode(", ", $query1) . " ) VALUES ( " . implode(", ", $query2) . ")");
return $r;
}
}
<?php
include "../include.php";
$docs = db_query("SELECT id, title FROM docs");
while ($d = db_fetch($docs)) {
$ftitle = $root . "data/docs/data/" . $d["id"] . ".dat";
if ($file = @file_get_contents($ftitle)) {
echo $d["title"] . " size is " . format_size(strlen($file));
echo " (" . format_file_size($ftitle) . ")<br>";
db_query("UPDATE docs SET content = " . format_binary($file) . " WHERE id = " . $d["id"]);
echo strlen(format_binary($file)) . "<hr>";
} else {
db_query("UPDATE docs SET is_active = 0 WHERE id = " . $d["id"]);
}
}
