static function __install()
{
$sql = SQL::current();
$sql->query("CREATE TABLE IF NOT EXISTS __types (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100) DEFAULT '',\n description TEXT,\n color VARCHAR(6) DEFAULT '0A0A0A'\n clean VARCHAR(100) DEFAULT '',\n url VARCHAR(100) DEFAULT '',\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __extensions (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100) DEFAULT '',\n clean VARCHAR(100) DEFAULT '',\n url VARCHAR(100) DEFAULT '',\n type_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __versions (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n number VARCHAR(100) DEFAULT '',\n description TEXT,\n compatible TEXT,\n tags TEXT,\n filename VARCHAR(100) DEFAULT '',\n image VARCHAR(100) DEFAULT '',\n loves INTEGER DEFAULT 0,\n downloads INTEGER DEFAULT 0,\n extension_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __loves (\n version_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n PRIMARY KEY (version_id, user_id)\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __notes (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n body LONGTEXT,\n version_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
Group::add_permission("add_type", "Add Type");
Group::add_permission("add_extension", "Add Extension");
Group::add_permission("add_note", "Add Note");
Group::add_permission("edit_type", "Edit Type");
Group::add_permission("edit_extension", "Edit Extension");
Group::add_permission("edit_note", "Edit Note");
Group::add_permission("edit_own_extension", "Edit Own Extension");
Group::add_permission("edit_own_note", "Edit Own Note");
Group::add_permission("delete_type", "Delete Type");
Group::add_permission("delete_extension", "Delete Extension");
Group::add_permission("delete_note", "Delete Note");
Group::add_permission("delete_own_extension", "Delete Own Extension");
Group::add_permission("delete_own_note", "Delete Own Note");
Group::add_permission("code_in_extensions", "Can Use HTML In Extensions");
Group::add_permission("code_in_notes", "Can Use HTML In Notes");
Group::add_permission("love_extension", "Love Extensions");
}
static function __install()
{
$config = Config::current();
$config->set("last_aggregation", 0);
$config->set("aggregate_every", 30);
$config->set("disable_aggregation", false);
$config->set("aggregates", array());
Group::add_permission("add_aggregate", "Add Aggregate");
Group::add_permission("edit_aggregate", "Edit Aggregate");
Group::add_permission("delete_aggregate", "Delete Aggregate");
}
static function __install()
{
$sql = SQL::current();
$sql->query("CREATE TABLE IF NOT EXISTS __comments (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n body LONGTEXT,\n author VARCHAR(250) DEFAULT '',\n author_url VARCHAR(128) DEFAULT '',\n author_email VARCHAR(128) DEFAULT '',\n author_ip INTEGER DEFAULT '0',\n author_agent VARCHAR(255) DEFAULT '',\n status VARCHAR(32) default 'denied',\n signature VARCHAR(32) DEFAULT '',\n post_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT NULL,\n updated_at DATETIME DEFAULT NULL\n ) DEFAULT CHARSET=utf8");
$config = Config::current();
$config->set("default_comment_status", "denied");
$config->set("allowed_comment_html", array("strong", "em", "blockquote", "code", "pre", "a"));
$config->set("comments_per_page", 25);
$config->set("defensio_api_key", null);
$config->set("auto_reload_comments", 30);
$config->set("enable_reload_comments", false);
Group::add_permission("add_comment", "Add Comments");
Group::add_permission("add_comment_private", "Add Comments to Private Posts");
Group::add_permission("edit_comment", "Edit Comments");
Group::add_permission("edit_own_comment", "Edit Own Comments");
Group::add_permission("delete_comment", "Delete Comments");
Group::add_permission("delete_own_comment", "Delete Own Comments");
Group::add_permission("code_in_comments", "Can Use HTML In Comments");
}
static function __install()
{
$sql = SQL::current();
$sql->query("CREATE TABLE IF NOT EXISTS __milestones (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100) DEFAULT '',\n description TEXT,\n due DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __tickets (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n title VARCHAR(100) DEFAULT '',\n description LONGTEXT,\n state VARCHAR(100) DEFAULT 'new',\n clean VARCHAR(100) DEFAULT '',\n url VARCHAR(100) DEFAULT '',\n milestone_id INTEGER DEFAULT 0,\n owner_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __revisions (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n body LONGTEXT,\n changes TEXT,\n ticket_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
Group::add_permission("add_milestone", "Add Milestone");
Group::add_permission("add_ticket", "Add Ticket");
Group::add_permission("add_revision", "Add Revision");
Group::add_permission("edit_milestone", "Edit Milestone");
Group::add_permission("edit_ticket", "Edit Ticket");
Group::add_permission("edit_revision", "Edit Revision");
Group::add_permission("edit_own_ticket", "Edit Own Ticket");
Group::add_permission("edit_own_revision", "Edit Own Revision");
Group::add_permission("delete_milestone", "Delete Milestone");
Group::add_permission("delete_ticket", "Delete Ticket");
Group::add_permission("delete_revision", "Delete Revision");
Group::add_permission("delete_own_ticket", "Delete Own Ticket");
Group::add_permission("delete_own_revision", "Delete Own Revision");
Group::add_permission("code_in_revisions", "Can Use HTML In Revisions");
}
static function __install()
{
$sql = SQL::current();
$sql->query("CREATE TABLE IF NOT EXISTS __forums (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100) DEFAULT '',\n description TEXT,\n `order` INTEGER DEFAULT 0,\n clean VARCHAR(100) DEFAULT '',\n url VARCHAR(100) DEFAULT ''\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __messages (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n body LONGTEXT,\n topic_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
$sql->query("CREATE TABLE IF NOT EXISTS __topics (\n id INTEGER PRIMARY KEY AUTO_INCREMENT,\n title VARCHAR(100) DEFAULT '',\n description LONGTEXT,\n clean VARCHAR(100) DEFAULT '',\n url VARCHAR(100) DEFAULT '',\n view_count INTEGER DEFAULT 0,\n forum_id INTEGER DEFAULT 0,\n user_id INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT '0000-00-00 00:00:00',\n updated_at DATETIME DEFAULT '0000-00-00 00:00:00'\n ) DEFAULT CHARSET=utf8");
Group::add_permission("add_forum", "Add Forum");
Group::add_permission("add_topic", "Add Topic");
Group::add_permission("add_message", "Add Message");
Group::add_permission("edit_forum", "Edit Forum");
Group::add_permission("edit_topic", "Edit Topic");
Group::add_permission("edit_message", "Edit Message");
Group::add_permission("edit_own_topic", "Edit Own Topic");
Group::add_permission("edit_own_message", "Edit Own Message");
Group::add_permission("delete_forum", "Delete Forum");
Group::add_permission("delete_topic", "Delete Topic");
Group::add_permission("delete_message", "Delete Message");
Group::add_permission("delete_own_topic", "Delete Own Topic");
Group::add_permission("delete_own_message", "Delete Own Message");
Group::add_permission("code_in_topics", "Can Use HTML In Topics");
Group::add_permission("code_in_messages", "Can Use HTML In Messages");
}
static function __install()
{
Category::installCategorize();
Group::add_permission("manage_categorize", "Manage Categories");
Route::current()->add("category/(name)/", "category");
}
static function __install()
{
Group::add_permission("submit_article", "Submit Aritcles");
Route::current()->add("submit/", "submit");
}
static function install()
{
SQL::current()->query("CREATE TABLE IF NOT EXISTS __likes (\n id INTEGER(10) NOT NULL AUTO_INCREMENT,\n post_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n timestamp DATETIME DEFAULT NULL,\n session_hash VARCHAR(32) NOT NULL,\n PRIMARY KEY (id),\n KEY key_post_id (post_id),\n UNIQUE key_post_id_sh_pair (post_id, session_hash)\n ) DEFAULT CHARSET=utf8");
Group::add_permission("like_post", "Like Posts");
Group::add_permission("unlike_post", "Unlike Posts");
$likeText = array(0 => "You like this.", 1 => "You and 1 other like this.", 2 => "You and %NUM% other like this.", 3 => "Be the first to like.", 4 => "1 person likes this.", 5 => "%NUM% people like this.", 6 => "Like", 7 => "Unlike");
$config = Config::current();
$set = array($config->set("module_like", array("showOnFront" => true, "likeWithText" => false, "likeImage" => $config->chyrp_url . "/modules/likes/images/like.png", "likeText" => $likeText)));
}
