include "../include.php"; if ($posting) { if (isset($_POST['order'])) { $counter = 1; foreach ($_POST['order'] as $link_id) { db_query('UPDATE spotlight SET precedence = ' . $counter . ' WHERE id = ' . $link_id); $counter++; } die(drawSpotlight()); } else { $id = db_enter('spotlight', 'title url precedence'); if ($uploading && file_ext($_FILES["userfile"]['name']) == 'jpg') { define('DIRECTORY_ROOT', $_SERVER['DOCUMENT_ROOT']); define('DIRECTORY_WRITE', '/uploads'); $image = format_image($_FILES["userfile"]["tmp_name"], 'jpg'); $image = format_image_resize($image, 320, 320); file_put('/uploads/spotlight/' . $id . '.jpg', $image); } url_change(); } } elseif (!empty($_GET['id']) && url_action('delete')) { db_query('DELETE FROM spotlight WHERE id = ' . $_GET['id']); url_query_drop('action,id'); } drawTop(); ?> <table cellspacing="1" class="left draggable spotlight"> <thead> <?php echo drawHeaderRow(false, 5, "new", "#bottom"); ?>
} } 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');
include '../include.php'; if ($posting) { //debug(); //check to make sure email not already assigned to an active user if (!$editing && ($id = db_grab('SELECT id FROM users WHERE is_active = 1 AND email = "' . $_POST['email'] . '"'))) { url_change('view.php?id=' . $id); } langTranslatePost('bio,title'); if (!getOption('languages')) { $_POST['language_id'] = 1; } if ($uploading) { $_POST['image_large'] = format_image_resize(file_get_uploaded('image_large'), 240); $_POST['image_medium'] = format_image_resize($_POST['image_large'], 135); $_POST['image_small'] = format_image_resize($_POST['image_large'], 50); } //check for long distance codes if (getOption('staff_ldcode')) { if ($_POST['officeID'] == 1) { if (!url_id() || !db_grab('SELECT longDistanceCode FROM users WHERE id = ' . url_id())) { //user doesn't have a long distance code but needs one if (!($code = db_grab('SELECT l.code FROM ldcodes l WHERE (SELECT COUNT(*) FROM users u WHERE u.longDistanceCode = l.code AND u.is_active = 1) = 0'))) { error_hande('out of codes', 'the intranet is out of long distance codes to assign to new users, such as for ' . $_POST['firstname'] . ' ' . $_POST['lastname']); } else { $_POST['longDistanceCode'] = $code; } } } } $id = db_save('users');