} } 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"]); } }