function nextImg($name)
{
// get next imgname from uploads table
$img_query = new myQuery(sprintf("INSERT INTO img (user_id, dt, name) \n VALUES ('%d', NOW(), '%s')\n ON DUPLICATE KEY UPDATE\n user_id='%d', dt=NOW()", $_SESSION['user_id'], str_replace(array('///', '//'), '/', $name), $_SESSION['user_id']));
$img_id = $img_query->get_insert_id();
return $img_id;
}
private function _nextImg()
{
$exp_path = explode("/", $this->getUserPath());
$project_id = $exp_path[0];
unset($exp_path[0]);
$name = "/" . implode("/", $exp_path);
// get next id from uploads table
$img_query = new myQuery(sprintf("INSERT INTO img (user_id, dt, name, project_id) \n VALUES ('%d', NOW(), '%s', '%s')\n ON DUPLICATE KEY UPDATE\n user_id='%d', dt=NOW()", $_SESSION['user_id'], $name, $project_id, $_SESSION['user_id']));
$this->_id = $img_query->get_insert_id();
return $this->_id;
}
} else {
if ($hash == $hash_check) {
$return['user'] = $id;
$q = new myQuery("INSERT INTO login (user_id, logintime) VALUES ({$id}, NOW())");
// set session variables
$_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})");
}
header('Content-Type: application/json');
echo json_encode($return);
exit;
}
}
$dp1 = intval($_POST['delinPts'][0]);
$dp2 = intval($_POST['delinPts'][1]);
$dp3 = intval($_POST['delinPts'][2]);
$q = new myQuery(sprintf('REPLACE INTO tem (id, user_id, name, notes, public,
3ptdelin1, 3ptdelin2, 3ptdelin3,
align_pt1, align_pt2, width, height)
VALUES (%s, %d, "%s", "%s", 0,
%d, %d, %d,
%d, %d, %s, %s)', $_POST['id'], $user, $_POST['name'], $_POST['notes'], $dp1, $dp2, $dp3, $dp1, $dp2, $_POST['width'], $_POST['height']));
$return['query'] = $q->get_query();
$tem_id = $_POST['id'] == 'NULL' ? $q->get_insert_id() : $_POST['id'];
$return['tem_id'] = $tem_id;
if (count($_POST['tem'])) {
$q = new myQuery("DELETE FROM point WHERE tem_id={$tem_id};");
$tem_query = array();
foreach ($_POST['tem'] as $i => $t) {
//$tem_query[] = sprintf('(%d, %d, %f, %f, "%s")',
// $tem_id, $i, $t['x'], $t['y'], my_clean($t['name'])
//);
$x = intval($t['x']);
$y = intval($t['y']);
$q = new myQuery("INSERT INTO point (tem_id, n, x, y) VALUES ({$tem_id}, {$i}, {$x}, {$y});");
}
}
if (count($_POST['lines'])) {
$q = new myQuery("DELETE FROM line WHERE tem_id={$tem_id};");
