$db->ex("CREATE INDEX tag_id ON tag2task (tag_id)");
$db->ex("CREATE INDEX task_id ON tag2task (task_id)");
$db->ex("CREATE TABLE lists (\r\n id INTEGER PRIMARY KEY,\r\n name VARCHAR(50) NOT NULL\r\n) ");
} catch (Exception $e) {
exitMessage("<b>Error:</b> " . htmlarray($e->getMessage()));
}
}
createDefaultList($db);
} elseif ($ver == $lastVer) {
exitMessage("Installed version (v{$ver}) does not require database update.");
} else {
if (!in_array($ver, array('1.1', '1.2'))) {
exitMessage("Can not update database. Unsupported version (v{$ver}).");
}
if (!isset($_POST['update'])) {
exitMessage("Update database v{$ver} <form method=post><input type=hidden name=update value=1><input type=submit value=' Update '></form>");
}
# update process
if ($ver == '1.2') {
update_12_13($db, $dbtype);
} elseif ($ver == '1.1') {
update_11_12($db, $dbtype);
update_12_13($db, $dbtype);
}
}
echo "Done<br><br> <b>Attention!</b> Delete this file for security reasons.";
printFooter();
function get_ver($db, $dbtype)
{
if (!$db->table_exists('todolist')) {
return '';
$db->ex("CREATE INDEX tag2task_list_id ON {$db->prefix}tag2task (list_id)");
/* for tagcloud */
} catch (Exception $e) {
exitMessage("<b>Error:</b> " . htmlarray($e->getMessage()));
}
}
# create default list
$db->ex("INSERT INTO {$db->prefix}lists (uuid,name,d_created) VALUES (?,?,?)", array(generateUUID(), 'Todo', time()));
} elseif ($ver == $lastVer) {
exitMessage("Installed version does not require database update.");
} else {
if (!in_array($ver, array('1.1', '1.2', '1.3.0', '1.3.1'))) {
exitMessage("Can not update. Unsupported database version ({$ver}).");
}
if (!isset($_POST['update'])) {
exitMessage("Update database v{$ver}\r\n\t\t<form name=frm method=post><input type=hidden name=update value=1><input type=hidden name=tz value=-1><input type=submit value=' Update '></form>\r\n\t\t<script type=\"text/javascript\">var tz = -1 * (new Date()).getTimezoneOffset(); document.frm.tz.value = tz;</script>\r\n\t\t");
}
# update process
if ($ver == '1.3.1') {
update_131_14($db, $dbtype);
}
if ($ver == '1.3.0') {
update_130_131($db, $dbtype);
update_131_14($db, $dbtype);
}
if ($ver == '1.2') {
update_12_13($db, $dbtype);
update_130_131($db, $dbtype);
update_131_14($db, $dbtype);
} elseif ($ver == '1.1') {
update_11_12($db, $dbtype);
}
}
# create default list
$db->ex("INSERT INTO {$db->prefix}lists (uuid,name,d_created) VALUES (?,?,?)", array(generateUUID(), 'Todo', time()));
// create default user - for multi user support
$uuid = generateUUID();
$db->ex("INSERT INTO {$db->prefix}users (id, uuid, username, password, email, d_created, role) VALUES (1, '" . $uuid . "', 'admin', '" . hashPassword('admin', $uuid) . "', '*****@*****.**', " . time() . ", '1')");
} elseif ($ver == YTT_VERSION) {
exitMessage("Installed version does not require database update.");
} else {
if (!in_array($ver, array('mtt1.1', 'mtt1.2', 'mtt1.3.0', 'mtt1.3.1', 'mtt1.4'))) {
exitMessage("Can not update. Unsupported database version ({$ver}).");
}
if (!isset($_POST['update'])) {
exitMessage('Update database v' . $ver . '
<form name="frm"" method="post"><input type="hidden" name="update" value="1"><input type="hidden" name="tz" value="-1"><input type="submit" value=" Update "></form>
<script type="text/javascript">var tz = -1 * (new Date()).getTimezoneOffset(); document.frm.tz.value = tz;</script>
');
}
# update process
if ($ver == 'mtt1.4') {
update_14_15($db, $dbtype);
}
if ($ver == 'mtt1.3.1') {
update_131_14($db, $dbtype);
}
if ($ver == 'mtt1.3.0') {
update_130_131($db, $dbtype);
update_131_14($db, $dbtype);
}
if ($ver == 'mtt1.2') {
update_12_13($db, $dbtype);
function abortTaskman($message = '')
{
echo "taskman aborted!\n";
exitMessage($message, 1);
}
@ini_set('display_errors', 1);
}
$opt = getopt('f:Th', ['taskfile:', 'tasks', 'help', 'version']);
if (isset($opt['h']) || isset($opt['help'])) {
$usage = <<<HELP
usage: taskman [-f taskfile] {options} <target> [<args>]
Options:
-f, --taskfile Use FILE as the taskfile
-T, --tasks Display the tasks with descriptions, then exit
--version Display the program version
HELP;
exitMessage($usage);
}
if (isset($opt['version'])) {
exitMessage("This is Taskman v" . Taskman\VERSION);
}
try {
if (isset($opt['f'])) {
$taskfile = $opt['f'];
} elseif (isset($opt['taskfile'])) {
$taskfile = $opt['taskfile'];
} else {
$taskfile = null;
}
if ($taskfile) {
if (!is_readable($taskfile)) {
abortTaskman("No Taskfile found (looking for: {$taskfile})");
}
if (is_file($taskfile)) {
require $taskfile;
