$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;