public function tasktypes($args) { $this->vars["pagename"] = "Adminstration :: Task Types"; $p = PermissionHandler::getInstance(); if (!$p->allowedto(PermissionHandler::PERM_MANAGE_TASKTYPES)) { Utils::error("You don't have permission to create task types."); return; } if (isset($_POST["action"])) { switch ($_POST["action"]) { case "create": if (isset($_POST["tasktype"]) && !empty($_POST["tasktype"])) { $tasktype = new TaskType(); $tasktype->name = $_POST["tasktype"]; $tasktype->created = date("Y-m-d H:i:s"); $tasktype->save(); } else { Utils::error("No task type entered to create."); return; } break; case "delete": if (isset($_POST["tasktypes"]) && !empty($_POST["tasktypes"])) { $q = Doctrine_Query::create()->delete("TaskType"); foreach ($_POST["tasktypes"] as $task => $status) { if ($status == "on") { $q->orWhere("id = ?", $task); } } $q->execute(); Utils::success("Task types successfully deleted."); } else { Utils::error("No task types selected to delete."); } break; default: // THIS SHOULD NOT HAPPEN! D: break; } } $this->vars["tasktypes"] = Doctrine_Query::create()->from("TaskType")->fetchArray(); }
function doPopulateDatabase() { // Check for a config file, if it doesn't exist go through the steps to create it. if (!file_exists(dirname(__FILE__) . '/config.php')) { header("Location: " . $_SERVER["SCRIPT_NAME"] . "?do=step1"); return; } require_once dirname(__FILE__) . "/config.php"; require_once dirname(__FILE__) . "/fwork/lib/Doctrine/Doctrine.php"; spl_autoload_register(array("Doctrine", "autoload")); Doctrine_Manager::connection($config["database"]["dsn"]); Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_TBLNAME_FORMAT, $config["database"]["prefix"] . "%s"); Doctrine::createTablesFromModels(dirname(__FILE__) . "/models"); $time = date("Y-m-d H:i:s"); // roles $role_admin = new Role(); $role_admin->name = "Admin"; $role_admin->auth = 0xffffffff; $role_admin->created = $time; $role_admin->save(); $role_staff = new Role(); $role_staff->name = "Staff"; $role_staff->auth = 0x7c700; $role_staff->created = $time; $role_staff->save(); $role_guest = new Role(); $role_guest->name = "Guest"; $role_guest->auth = 0x0; $role_guest->created = $time; $role_guest->save(); // staff $staff = new Staff(); $staff->nickname = "admin"; $staff->setPassword("admin"); $staff->Role = $role_admin; $staff->admin = true; $staff->comment = "Administrator"; $staff->created = $time; $staff->save(); // task types $tasktypes = array('Raw Cap', 'Translate', 'Time', 'Translation Check', 'Typeset', 'Edit', 'Encode', 'Quality Check', 'Karaoke', 'Miscellaneous', 'Translate Signs', 'Release'); foreach ($tasktypes as $key => $name) { $tasktype = new TaskType(); $tasktype->name = $name; $tasktype->created = $time; $tasktype->save(); $tasktypes[$key] = $tasktype; } // template $template = new Template(); $template->name = "Default"; $template->model = $tasktypes[0]->id . ":0->" . $tasktypes[1]->id . ":0; " . $tasktypes[0]->id . ":0->" . $tasktypes[10]->id . ":0; " . $tasktypes[10]->id . ":0->" . $tasktypes[4]->id . ":0; " . $tasktypes[4]->id . ":0->" . $tasktypes[3]->id . ":0; " . $tasktypes[1]->id . ":0->" . $tasktypes[2]->id . ":0; " . $tasktypes[1]->id . ":0->" . $tasktypes[3]->id . ":0; " . $tasktypes[3]->id . ":0->" . $tasktypes[5]->id . ":0; " . $tasktypes[5]->id . ":0->" . $tasktypes[6]->id . ":0; " . $tasktypes[6]->id . ":0->" . $tasktypes[7]->id . ":0; " . $tasktypes[7]->id . ":0->" . $tasktypes[11]->id . ":0; " . $tasktypes[2]->id . ":0->" . $tasktypes[5]->id . ":0; "; $template->created = $time; $template->save(); // settings $settings = array('site.gzip' => true, 'site.gentime' => true); foreach ($settings as $name => $value) { $setting = new Setting(); $setting->name = $name; $setting->value = $value; $setting->save(); unset($setting); } echo <<<EOS <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> \t<title>Frac :: Install</title> \t<meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> </head> <body> \t<h2>Frac Installer</h2> \t<p>Table data populated successfully. You may now proceed to your <a href="./">Frac installation</a>. The username and password are "admin".</p> </body> </html> EOS; }