$_SESSION['user_id'] = $id; if ($id == 1) { $_SESSION['superuser'] = true; } // check if they have any project folders $q = new myQuery("SELECT project_id FROM project_user WHERE user_id={$id}"); if ($q->get_num_rows() == 0) { $notes = my_clean("{$res['firstname']} {$res['lastname']} ({$res['email']}) first project"); $projname = my_clean("{$res['firstname']} {$res['lastname']} Project"); $q = new myQuery("INSERT INTO project (user_id, name, dt, notes) VALUES ({$id}, '{$projname}', NOW(), '{$notes}')"); $new_proj_id = $q->get_insert_id(); $mydir = IMAGEBASEDIR . $new_proj_id; if ($new_proj_id > 1 && !mkdir($mydir, DIRPERMS)) { $return['error'] = true; $return['errorText'] .= '<li>Your default image directory could not be created</li>'; $q->set_query("DELETE FROM project WHERE id={$new_proj_id}"); } else { mkdir($mydir . '/.tmp', DIRPERMS); mkdir($mydir . '/.trash', DIRPERMS); copy(DOC_ROOT . '/include/examples/_female_avg.jpg', $mydir . '/_female_avg.jpg'); copy(DOC_ROOT . '/include/examples/_female_avg.tem', $mydir . '/_female_avg.tem'); copy(DOC_ROOT . '/include/examples/_male_avg.jpg', $mydir . '/_male_avg.jpg'); copy(DOC_ROOT . '/include/examples/_male_avg.tem', $mydir . '/_male_avg.tem'); $q = new myQuery("INSERT INTO project_user (project_id, user_id) VALUES ({$new_proj_id}, {$id})"); $q = new myQuery("INSERT INTO (user_id, pref, prefval) VALUES ({$id}, 'default_project', {$new_proj_id})"); } } // set remember cookie if ($_POST['login_keep']) { // set cookie to expire in a year setcookie('user_id', $id, time() + 60 * 60 * 24 * 365, '/', $_SERVER['SERVER_NAME']);
<?php // delete a default template from the database require_once $_SERVER['DOCUMENT_ROOT'] . '/include/main_func.php'; auth(); $return = array('error' => false, 'errorText' => ''); $user = $_SESSION['user_id']; // check if user has permission to delete this template $tem_id = intval($_POST['id']); $q = new myQuery("SELECT COUNT(*) as c FROM tem WHERE user_id={$user} AND id={$tem_id} AND id>1"); if ($q->get_one() == 0) { $return['error'] = true; $return['errorText'] = 'You do not have permission to delete this template.'; header('Content-Type: application/json'); echo json_encode($return); exit; } $q = new myQuery("DELETE FROM tem WHERE id={$tem_id};"); $return['tem_deleted'] = $q->get_affected_rows(); if ($return['tem_deleted'] == 0) { $return['error'] = true; $return['errorText'] = "Template {$tem_id} was not deleted."; } else { $q->set_query("DELETE FROM point WHERE tem_id={$tem_id};"); $return['points_deleted'] = $q->get_affected_rows(); $q->set_query("DELETE FROM line WHERE tem_id={$tem_id};"); $return['lines_deleted'] = $q->get_affected_rows(); } scriptReturn($return); exit;
} else { if (!mkdir($mydir, DIRPERMS)) { throw new Exception("<li>{$new_proj_id} could not be created</li>"); } else { mkdir($mydir . '/.tmp', DIRPERMS); mkdir($mydir . '/.trash', DIRPERMS); copy(DOC_ROOT . '/include/examples/_female_avg.jpg', $mydir . '/_female_avg.jpg'); copy(DOC_ROOT . '/include/examples/_female_avg.tem', $mydir . '/_female_avg.tem'); copy(DOC_ROOT . '/include/examples/_male_avg.jpg', $mydir . '/_male_avg.jpg'); copy(DOC_ROOT . '/include/examples/_male_avg.tem', $mydir . '/_male_avg.tem'); copy(DOC_ROOT . '/include/examples/webmorph_template_batchAvg.txt', $mydir . '/_batchAvg_template.txt'); copy(DOC_ROOT . '/include/examples/webmorph_template_batchTrans.txt', $mydir . '/_batchTrans_template.txt'); copy(DOC_ROOT . '/include/examples/webmorph_template_batchEdit.txt', $mydir . '/_batchEdit_template.txt'); $return['project'] = $new_proj_id; $q = new myQuery("INSERT INTO project_user (project_id, user_id) VALUES ({$new_proj_id}, {$user})"); $q->set_query("INSERT INTO img (user_id, dt, project_id, name, width, height) " . "VALUES ({$user}, NOW(), {$new_proj_id}, '/_female_avg.jpg', 1350, 1800), " . " ({$user}, NOW(), {$new_proj_id}, '/_male_avg.jpg', 1350, 1800)"); $_SESSION['projects'][] = $new_proj_id; } } } catch (Exception $e) { $return['error'] = true; $return['errorText'] .= $e->getMessage(); } scriptReturn($return); exit; /* DROP TABLE IF EXISTS project; CREATE TABLE project ( id INT(11) NOT NULL AUTO_INCREMENT, user_id INT(8) UNSIGNED, name VARCHAR(32) NOT NULL,