This page is restricted access.
'); + + if ( $session->auth_level < USER_LEVEL_ADMIN ) + redirect(makeUrlNS('Special', 'Login/' . $paths->page, 'level=' . USER_LEVEL_ADMIN, true), '', '', 0); + + $session->theme = 'admin'; + $session->style = 'default'; + $template = false; + unset($GLOBALS['template']); + unset($template); + $GLOBALS['template'] = new template(); + $template =& $GLOBALS['template']; + + $template->header(); + ?> + Add or remove forums, control user permissions, and check forum statistics. +
+ Decir configuration+
|
+ + nslist['Admin'] . 'DecirIndex'; + list($page_id, $namespace) = RenderMan::strToPageID($module); + $page = new PageProcessor($page_id, $namespace); + $page->send(); + ?> + | +
It looks like your administration session is invalid or you are not authorized to access this administration page. Please re-authenticate to continue.
'; + return; + } + + $show_main_menu = true; + + if ( isset($_POST['act']) ) + { + switch ( $_POST['act'] ) + { + case "create": + case "create_finish": + + // Do we have any categories yet? + $q = $db->sql_query('SELECT forum_id, forum_name FROM ' . table_prefix . 'decir_forums WHERE forum_type = ' . FORUM_CATEGORY . ';'); + if ( !$q ) + $db->_die('Decir admin_forums.php retrieving category count'); + $need_category = ( $db->numrows() < 1 ); + $cats = array(); + if ( !$need_category ) + { + while ( list($cat_id, $cat_name) = $db->fetchrow_num() ) + { + $cats[ $cat_id ] = $cat_name; + } + } + + $db->free_result(); + + if ( $_POST['act'] == 'create_finish' ) + { + $errors = array(); + $forum_type = intval($_POST['forum_type']); + if ( $forum_type != FORUM_FORUM && $forum_type != FORUM_CATEGORY ) + $errors[] = 'Invalid forum type. X.X'; + $forum_name = trim($_POST['forum_name']); + if ( empty($forum_name) ) + $errors[] = 'Please enter a name for this forum.'; + $forum_desc = ''; + $forum_parent = 0; + if ( $forum_type == FORUM_FORUM ) + { + $forum_desc = trim($_POST['forum_desc']); + if ( empty($forum_desc) ) + $errors[] = 'Please enter a description for this forum.'; + $forum_parent = intval($_POST['forum_parent']); + if ( !isset($cats[$forum_parent]) ) + $errors[] = 'Invalid parent category'; + } + if ( count($errors) > 0 ) + { + // Errors encountered - bounce form back to the user + $show_main_menu = false; + $form = new Decir_Admin_SmartForm_Forum(DECIR_ADMIN_MODE_CREATE); + $form->forum_name = $forum_name; + $form->forum_desc = $forum_desc; + $form->forum_type = $forum_type; + $form->need_category = $need_category; + $form->category_list = $cats; + echo $form->html(); + break; + } + // All checks passed. Create forum. + $forum_name_db = $db->escape($forum_name); + $forum_desc_db = $db->escape($forum_desc); + $sql = 'INSERT INTO ' . table_prefix . "decir_forums(forum_name, forum_desc, forum_type, parent, num_topics, num_posts) VALUES\n" + . " ( '$forum_name_db', '$forum_desc_db', $forum_type, $forum_parent, 0, 0 );"; + if ( $db->sql_query($sql) ) + { + $forum_name = htmlspecialchars($forum_name); + $type = ( $forum_type == FORUM_FORUM ) ? 'forum' : 'category'; + echo "It looks like your administration session is invalid or you are not authorized to access this administration page. Please re-authenticate to continue.
'; + return; + } + + // + // Obtain forum statistics + // + + // Number of users + $q = $db->sql_query('SELECT COUNT(user_id)-1 AS num_users FROM ' . table_prefix . 'users;'); + if ( !$q ) + $db->_die(); + + $row = $db->fetchrow(); + $db->free_result(); + $num_users = $row['num_users']; + + // Number of posts + $q = $db->sql_query('SELECT COUNT(post_id) AS num_posts FROM ' . table_prefix . 'decir_posts;'); + if ( !$q ) + $db->_die(); + + $row = $db->fetchrow(); + $db->free_result(); + $num_posts = $row['num_posts']; + + // Board start date + $date = intval( getConfig('decir_install_date') ); + if ( !$date ) + { + $date = time(); + setConfig('decir_install_date', $date); + } + $start_date = date('F d, Y h:i a', $date); + + // Average posts per day + $board_age_days = round( ( time() / ( 60*60*24 ) ) - ( $date / ( 60*60*24 ) ) ); + if ( $board_age_days < 1 ) + { + $avg_posts = $num_posts; + } + else + { + $avg_posts = $num_posts / $board_age_days; + } + + echo 'Thank you for choosing Decir as your forum solution. From this panel you can control every aspect of your forum\'s behavior and appearance. If you need support + for Decir, you can visit the Enano support forums.
'; + echo '| Board statistics | +|||
|---|---|---|---|
| Number of users: | +{$num_users} | + +Number of posts: | +{$num_posts} | +
| Board started: | +{$start_date} ({$board_age_days} days ago) | + +Average posts per day: | +{$avg_posts} | +
Decir installation error: can\'t load schema file'; + return false; + } + + // Variables + $schema = str_replace('{{TABLE_PREFIX}}', table_prefix, $schema); + + $schema = explode("\n", $schema); + + foreach ( $schema as $i => $sql ) + { + $query =& $schema[$i]; + $t = trim($query); + if ( empty($t) || preg_match('/^(\#|--)/i', $t) ) + { + unset($schema[$i]); + unset($query); + } + } + + $schema = array_values($schema); + $schema = implode("\n", $schema); + $schema = explode(";\n", $schema); + + foreach ( $schema as $i => $sql ) + { + $query =& $schema[$i]; + if ( substr($query, ( strlen($query) - 1 ), 1 ) != ';' ) + { + $query .= ';'; + } + } + + foreach ( $schema as $sql ) + { + $q = $db->sql_query($sql); + if ( !$q ) + { + echo '
Decir installation failed: ' . $db->get_error() . ''; + return false; + } + } + + return true; +} + if ( $v = getConfig('decir_version') ) { $mode = 'upgrade'; @@ -32,30 +88,46 @@ $page = ( isset($_POST['step']) && in_array($_POST['step'], array('welcome', 'install', 'finish')) ) ? $_POST['step'] : 'welcome'; -$template->header(); - -switch($page) +if ( $page == 'finish' ) +{ + require('forum_index.php'); +} +else { - case 'welcome': - ?> -
Before you can use your forum, we'll need to run a few database queries to get the forum set up.
- - - - header(); + + switch($page) + { + case 'welcome': + ?> +Before you can use your forum, we'll need to run a few database queries to get the forum set up.
+ + +Decir has been successfully installed.
+ + footer(); + } -$template->footer(); - diff -r 6eea55374f5b -r 3f66ec435f08 decir/install.sql --- a/decir/install.sql Wed Oct 24 18:30:03 2007 -0400 +++ b/decir/install.sql Tue Nov 13 19:39:50 2007 -0500 @@ -1,4 +1,4 @@ -CREATE TABLE decir_forums( +CREATE TABLE {{TABLE_PREFIX}}decir_forums( forum_id int(12) unsigned NOT NULL auto_increment, forum_type tinyint(2) unsigned NOT NULL DEFAULT 1, forum_name varchar(255) NOT NULL, @@ -13,7 +13,7 @@ forum_extra text, PRIMARY KEY ( forum_id ) ); -CREATE TABLE decir_topics( +CREATE TABLE {{TABLE_PREFIX}}decir_topics( topic_id int(15) unsigned NOT NULL auto_increment, forum_id int(12) unsigned NOT NULL, topic_title varchar(255) NOT NULL, @@ -26,9 +26,11 @@ topic_deleted tinyint(1) NOT NULL DEFAULT 0, topic_deletor int(12) DEFAULT NULL, topic_delete_reason varchar(255) DEFAULT NULL, + num_views bigint(21) UNSIGNED NOT NULL DEFAULT 0, + last_post bigint(18) UNSIGNED NOT NULL, PRIMARY KEY ( topic_id ) ); -CREATE TABLE decir_posts( +CREATE TABLE {{TABLE_PREFIX}}decir_posts( post_id bigint(18) unsigned NOT NULL auto_increment, topic_id bigint(15) unsigned NOT NULL, poster_id int(12) unsigned NOT NULL, @@ -41,13 +43,13 @@ post_deleted tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY ( post_id ) ); -CREATE TABLE decir_posts_text( +CREATE TABLE {{TABLE_PREFIX}}decir_posts_text( post_id bigint(18) unsigned NOT NULL, post_text longtext NOT NULL, bbcode_uid varchar(10) NOT NULL, PRIMARY KEY ( post_id ) ); -CREATE TABLE decir_hits( +CREATE TABLE {{TABLE_PREFIX}}decir_hits( hit_id bigint(21) unsigned NOT NULL auto_increment, user_id int(12) unsigned NOT NULL DEFAULT 1, topic_id bigint(15) unsigned NOT NULL, diff -r 6eea55374f5b -r 3f66ec435f08 decir/posting.php --- a/decir/posting.php Wed Oct 24 18:30:03 2007 -0400 +++ b/decir/posting.php Tue Nov 13 19:39:50 2007 -0500 @@ -317,6 +317,7 @@ echo ''; echo ''; +decir_show_footers(); $template->footer(); ?> diff -r 6eea55374f5b -r 3f66ec435f08 decir/viewforum.php --- a/decir/viewforum.php Wed Oct 24 18:30:03 2007 -0400 +++ b/decir/viewforum.php Tue Nov 13 19:39:50 2007 -0500 @@ -22,7 +22,8 @@ if(empty($fid)) { echo 'Invalid forum ID
'; - $template->footer(); + decir_show_footers(); +$template->footer(); return; } @@ -123,6 +124,7 @@ echo ''; } +decir_show_footers(); $template->footer(); ?> diff -r 6eea55374f5b -r 3f66ec435f08 decir/viewtopic.php --- a/decir/viewtopic.php Wed Oct 24 18:30:03 2007 -0400 +++ b/decir/viewtopic.php Tue Nov 13 19:39:50 2007 -0500 @@ -11,7 +11,7 @@ * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details. */ - + require('common.php'); require('bbcode.php'); require('functions_viewtopic.php'); @@ -27,7 +27,8 @@ { $template->header(); echo 'Invalid topic ID
'; - $template->footer(); + decir_show_footers(); +$template->footer(); return; } @@ -48,7 +49,8 @@ { $template->header(); echo 'Invalid topic ID
'; - $template->footer(); + decir_show_footers(); +$template->footer(); return; } } @@ -192,6 +194,7 @@ $q = $db->sql_query('INSERT INTO '.table_prefix."decir_hits(user_id, topic_id, timestamp) VALUES($session->user_id, $tid, $time);"); $q = $db->sql_query('UPDATE '.table_prefix."decir_topics SET num_views = num_views + 1 WHERE topic_id = $tid;"); +decir_show_footers(); $template->footer(); ?> diff -r 6eea55374f5b -r 3f66ec435f08 plugins/Decir.php --- a/plugins/Decir.php Wed Oct 24 18:30:03 2007 -0400 +++ b/plugins/Decir.php Tue Nov 13 19:39:50 2007 -0500 @@ -33,6 +33,8 @@ )); '); +require( DECIR_ROOT . '/admincp/admin_base.php' ); + function decir_early_init(&$paths, &$session) { $paths->addAdminNode('Decir forum configuration', 'General settings', 'DecirGeneral'); @@ -52,6 +54,7 @@ if ( getConfig('decir_version') != ENANO_DECIR_VERSION || isset($_POST['do_install_finish']) ) { + chdir(DECIR_ROOT); require(DECIR_ROOT . '/install.php'); return false; } @@ -84,10 +87,4 @@ } -function page_Admin_DecirGeneral() -{ - global $db, $session, $paths, $template, $plugins; if($session->auth_level < USER_LEVEL_ADMIN || $session->user_level < USER_LEVEL_ADMIN) { header('Location: '.makeUrl($paths->nslist['Special'].'Administration'.urlSeparator.'noheaders')); die('Hacking attempt'); } - echo 'Hello world!'; -} - ?>