diff --git a/Scripts/CentOS-Web/admin/content.php b/Scripts/CentOS-Web/admin/content.php
deleted file mode 100644
index a2b05ca..0000000
--- a/Scripts/CentOS-Web/admin/content.php
+++ /dev/null
@@ -1,187 +0,0 @@
-<?php
-/***
- * Content Template
- *
- */
-
-//-----------/* Show error if called directly */
-
- if ( basename( $_SERVER['PHP_SELF'] ) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php">this instead</a>.</h3>';
- exit;
- }
-
-//-----------/* Sanitize URL variables */
-
- foreach ( $_GET as $key => $value )
- {
- if ( sanitize_url_var($key) )
- {
- $url[$key] = $value;
- }
- }
-
-//----------/* Page Selector */
-
- if ( isset( $url['page'] ) )
- {
- switch ( $url['page'] )
- {
- case 'entries':
- /* Build relation between "Entries" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case "add":
- $page = 'p_entries_add.php';
- break;
-
- case "update":
- $page = 'p_entries_update.php';
- break;
- }
- }
- else
- {
- $page = 'p_entries.php';
- }
- break;
-
- case 'pages':
- // Just if user has admin rights.
- if ( is_user('administrator') )
- {
- /* Build relation between "Pages" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case 'add':
- $page = 'p_pages_add.php';
- break;
-
- case 'update':
- $page = 'p_pages_update.php';
- break;
- }
- }
- else
- {
- $page = 'p_pages.php';
- }
- }
- break;
-
- case 'categories':
- // Just if user has admin rights.
- if ( is_user('administrator') )
- {
- /* Build relation between "Categories" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case 'add':
- $page = 'p_categories_add.php';
- break;
- case 'update':
- $page = 'p_categories_update.php';
- break;
- case 'tree':
- $page = 'p_categories_tree.php';
- break;
- }
- }
- else
- {
- $page = 'p_categories.php';
- }
- }
- break;
-
- case 'comments':
- // Just if user has admin rights.
- if ( is_user('administrator') )
- {
- /* Build relation between "Links" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case 'add':
- $page = 'p_comments_add.php';
- break;
- case 'update':
- $page = 'p_comments_update.php';
- break;
- }
- }
- else
- {
- $page = 'p_comments.php';
- }
- }
- break;
-
- case 'links':
- // Just if user has admin rights.
- if ( is_user('administrator') )
- {
- /* Build relation between "Links" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case 'add':
- $page = 'p_links_add.php';
- break;
- }
- }
- else
- {
- $page = 'p_links.php';
- }
- }
- break;
-
- case 'users':
- // Just if user has admin rights.
- if ( is_user('administrator') )
- {
- /* Build relation between "Links" sublinks and its pages */
- if ( isset($url['action'] ) )
- {
- switch ( $url['action'] )
- {
- case 'add':
- $page = 'p_users_add.php';
- break;
- }
- }
- else
- {
- $page = 'p_users.php';
- }
- }
- break;
-
- default:
- $page = 'p_index.php';
- break;
- }
- }
- else
- {
- $page = 'p_index.php';
- }
-
-//--------/* Verify file before include it
-
- if ( file_exists( ABSPATH . 'admin/' . $page ) )
- {
- include (ABSPATH . 'admin/' . $page );
- }
-?>
diff --git a/Scripts/CentOS-Web/admin/footer.php b/Scripts/CentOS-Web/admin/footer.php
deleted file mode 100644
index 8b06438..0000000
--- a/Scripts/CentOS-Web/admin/footer.php
+++ /dev/null
@@ -1,35 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php">this instead</a>.</h3>';
- exit;
- }
-?>
- </div>
-
- </div>
-
- <div id="footer">
-
- <?php echo show_sublinks(); ?>
-
- <?php echo show_mainlinks(); ?>
-
- <div class="pageline_dark"> </div>
-
- <div class="credits">
-
- <p class="right"></p>
-
- <p><?php echo ucfirst(translate('credits_on_footer_1')); ?></p>
-
- </div>
-
- </div>
-
- </body>
-
-</html>
diff --git a/Scripts/CentOS-Web/admin/header.php b/Scripts/CentOS-Web/admin/header.php
deleted file mode 100644
index 6cbcc7a..0000000
--- a/Scripts/CentOS-Web/admin/header.php
+++ /dev/null
@@ -1,50 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php">this instead</a>.</h3>';
- exit;
- }
-?>
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
-<html>
-
-<head>
- <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
- <title>Admin :: <?php echo HTML_TITLE ?></title>
- <link rel="stylesheet" type="text/css" charset="utf-8" media="all" href="style.css">
-</head>
-
-<body>
-
-<div id="header">
-
- <div class="adminlinks">
-
- <?php echo ucfirst($_SESSION['cn']); ?> [ <a href="<?php echo BASEURL ?>"><?php echo ucfirst(translate('go back'))?></a> | <a href="?action=logout"><?php echo ucfirst(translate('logout'))?></a> ]
-
- </div>
-
- <div id="logo">
-
- <img src="<?php echo BASEURL ?>contents/images/logo.png" alt="">
- <span class="logo_text"><?php echo ucfirst(translate( LANGUAGE )) ?></span>
-
- </div>
-
-
-
- <div class="pageline_dark"> </div>
-
- <?php echo show_mainlinks(); ?>
-
- <?php echo show_sublinks(); ?>
-
-</div>
-
-<div id="content">
-
- <div class="columnl">
-
diff --git a/Scripts/CentOS-Web/admin/img/header-background.png b/Scripts/CentOS-Web/admin/img/header-background.png
deleted file mode 100755
index ff2a7b0..0000000
Binary files a/Scripts/CentOS-Web/admin/img/header-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/html-background.png b/Scripts/CentOS-Web/admin/img/html-background.png
deleted file mode 100755
index 30f7d70..0000000
Binary files a/Scripts/CentOS-Web/admin/img/html-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-blue.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-blue.png
deleted file mode 100755
index 7a816cf..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-blue.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-gray.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-gray.png
deleted file mode 100755
index 43d1a55..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-gray.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-green.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-green.png
deleted file mode 100755
index f4ca7ca..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-green.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-orange.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-orange.png
deleted file mode 100755
index 25a57b5..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-orange.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-red.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-red.png
deleted file mode 100755
index 2dfcf09..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-red.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/moin-msg-bg-violet.png b/Scripts/CentOS-Web/admin/img/moin-msg-bg-violet.png
deleted file mode 100755
index 657824d..0000000
Binary files a/Scripts/CentOS-Web/admin/img/moin-msg-bg-violet.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/ul.png b/Scripts/CentOS-Web/admin/img/ul.png
deleted file mode 100755
index fd89ccd..0000000
Binary files a/Scripts/CentOS-Web/admin/img/ul.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/img/ul2.png b/Scripts/CentOS-Web/admin/img/ul2.png
deleted file mode 100644
index 467b107..0000000
Binary files a/Scripts/CentOS-Web/admin/img/ul2.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/admin/includes/classes/db_postgresql.php b/Scripts/CentOS-Web/admin/includes/classes/db_postgresql.php
deleted file mode 100644
index 515493a..0000000
--- a/Scripts/CentOS-Web/admin/includes/classes/db_postgresql.php
+++ /dev/null
@@ -1,64 +0,0 @@
-<?php
-/**
- * Database Access (PostgreSQL)
- *
- * @category Database
- * @package CentOS-News
- * @author Alain Reguera Delgado <alain.reguera@gmail.com>
- * @copyright 2009 - CentOS Artwork SIG.
- * @license GPL
- */
-
-class DB_PostgreSQL
-{
-
- var $dbconn;
-
-//---- Initialize class
-
- function __construct()
- {
- $conn_string = 'user=' . DB_USERNAME . ' password=' . DB_PASSWORD . ' dbname=' . DB_DBNAME;
- $this->dbconn = pg_connect($conn_string) or die("Could not connect");
- }
-
-//---- Am I connected ?
-
- function check_connection()
- {
- if (pg_connection_status($this->dbconn) === PGSQL_CONNECTION_OK )
- {
- return translate('connected');
- }
- else
- {
- return translate('disconnected');
- }
-
- }
-
-//---- Query
-
- function query( $sql_string )
- {
- $result = pg_query( $this->dbconn, $sql_string );
-
- return $result;
- }
-
-//---- Class Destructor
-
- function __destruct()
- {
-
- if (pg_connection_status($this->dbconn))
- {
- pg_close($this->dbconn);
- }
-
- }
-
-}
-
-$db = new DB_PostgreSQL;
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/classes/ldap.php b/Scripts/CentOS-Web/admin/includes/classes/ldap.php
deleted file mode 100644
index 5fe83f3..0000000
--- a/Scripts/CentOS-Web/admin/includes/classes/ldap.php
+++ /dev/null
@@ -1,572 +0,0 @@
-<?php
-/**
- * LDAP Access
- *
- * @category Logic
- * @package CentOS-News
- * @author Alain Reguera Delgado <alain.reguera@gmail.com>
- * @copyright 2009 - CentOS Artwork SIG.
- * @license GPL
- */
-
-class LDAP
-{
-
- var $ldapconn;
- var $ldapbind;
-
- // LDAP Filter Attributes
- var $filter_attrb = array();
- var $filter_type = array();
- var $filter_clean = array();
-
-//-----------/* Class initializations
-
- function __construct()
- {
- // Open connection against ldap server
- $this->ldapconn = ldap_connect(LDAP_HOST,LDAP_PORT) or die("Could not connect to " . LDAP_HOST . ".");
-
- // Set protocol version to use
- ldap_set_option($this->ldapconn, LDAP_OPT_PROTOCOL_VERSION, 3) or die("Could not connect to server through LDAPv3.");
-
- // Bind
- $this->ldapbind = ldap_bind( $this->ldapconn, LDAP_ROOTDN, LDAP_ROOTPW );
-
- // Initialize ldap filter attributes
- $this->filter_attrb['cn'] = 'cn';
- $this->filter_attrb['uid'] = 'uid';
- $this->filter_attrb['employeetype'] = ucfirst(translate('employeetype'));
- $this->filter_attrb['preferredlanguage'] = ucfirst(translate('language'));
-
- // Initialize ldap filter Types
- $this->filter_type['='] = '=';
- $this->filter_type['~='] = '~=';
-
- // Initialize ldap filter default
- $this->filter_clean['attrb'] = 'preferredlanguage';
- $this->filter_clean['type'] = '=';
- $this->filter_clean['value'] = LANGUAGE;
- }
-
-//----------- Get entries from ldap server
-
- function get_entries( $filter )
- {
- // Return entries just if filter valid
- $search = ldap_search($this->ldapconn,LDAP_DN,$filter);
- $entries = ldap_get_entries($this->ldapconn,$search);
- return $entries;
- }
-
-//----------// Validate filter value input
- // Sanitize filter pattern - Attributes
-
- function is_valid( $name , $value )
- {
- switch ( $name )
- {
- case 'uid':
- $pattern = '/^([a-z0-9_]|\-|\.)+@(([a-z0-9_]|\-)+\.)+([a-z]{2,6})?$/';
- break;
-
- case 'preferredlanguage':
- $pattern = '/^[a-zA-Z]{2}$/';
- break;
-
- case 'filtertype':
- $pattern = '/^(=|~=)$/';
- break;
-
- case 'employeetype':
- $pattern = '/^(writer|administrator)$/';
- break;
-
- default:
- $pattern = '/^[a-zA-Z0-9_áéíóñúàçèé ]+$/';
- break;
- }
-
- if ( isset( $pattern ) && preg_match( $pattern , $value ))
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
-//---------- Check filter attributes */
-
- function sanitize_filter_attribute()
- {
- $dirty = array();
- $clean = array();
-
- // Initialize dirty attribute
- $dirty['attrb'] = $this->filter_clean['attrb'];
-
- // Initialize clean attribute
- $clean['attrb'] = $this->filter_clean['attrb'];
-
- // Recover dirty attribute values from filter form
- if ( isset( $_POST['attribute'] ) )
- {
- $dirty['attrb'] = $_POST['attribute'];
- }
-
- // Check dirty attribute
- if ( array_key_exists( $dirty['attrb'], $this->filter_attrb ) )
- {
- // Attribute is not dirty any more. It passed validation.
- $clean['attrb'] = $dirty['attrb'];
- }
-
- return $clean['attrb'];
- }
-
-//---------- Check filter types
-
- function sanitize_filter_type()
- {
- $dirty = array();
- $clean = array();
-
- $dirty['type'] = $this->filter_clean['type'];
- $clear['type'] = $this->filter_clean['type'];
-
- // Recover dirty type values from filter form
- if ( isset( $_POST['type'] ) )
- {
- $dirty['type'] = $_POST['type'];
- }
- else
- {
- $dirty['type'] = $this->filter_clean['type'];
- }
-
- // Check dirty types
- if ( array_key_exists( $dirty['type'], $this->filter_type ) )
- {
- // Type is not dirty any more. It passed validation.
- $clean['type'] = $dirty['type'];
- }
-
- return $clean['type'];
- }
-
-//---------- Sanitize filter value
-
- function sanitize_filter_value()
- {
- $dirty = array();
- $clean = array();
-
- $dirty['value'] = $this->filter_clean['value'];
- $clean['value'] = $this->filter_clean['value'];
-
- // Recover dirty value from filter form
- if ( isset( $_POST['value'] ) )
- {
- $dirty['value'] = $_POST['value'];
- }
-
- // Sanitize dirty value, based on supplied attribe
- $name = $this->sanitize_filter_attribute();
- $value = $dirty['value'];
-
- if ( $this->is_valid( $name, $value ) )
- {
- // Value is not dirty any more. It passed validation.
- $clean['value'] = $value;
- }
-
- return $clean['value'];
- }
-
-//---------- Build ldap form filter
-
- function show_filter()
- {
- $clean = array();
-
- $clean['attrb'] = $this->sanitize_filter_attribute();
- $clean['type'] = $this->sanitize_filter_type();
- $clean['value'] = $this->sanitize_filter_value();
-
- // Start html form
- $html = '<div class="filter">';
- $html .= '<form name="filter" method="post" action="">';
-
- // Build html form fileds. Start with some text
- $html .= ucfirst(translate('filtering by')) . ': ';
-
- // Build attributes' select form field
- $html .= get_user_attrSelector();
-
- // Build types' select form field
- $html .= '<select name="type">';
- foreach ($this->filter_type as $key => $value)
- {
- if ($clean['type'] == $key )
- {
- $html .= '<option selected value="'.$key.'">' . $value . '</option>';
- }
- else
- {
- $html .= '<option value="'.$key.'">' . $value . '</option>';
- }
- }
- $html .= '</select>';
-
- // Build value's text form field
- $html .= '<input type="text" name="value" value="'.$clean['value'].'">';
-
- // Build submit form button
- $html .= '<input type="submit" name="submit_filter" value="'.ucfirst(translate('filter')).'">';
-
- // End html form
- $html .= '</form>';
- $html .= '</div>';
-
- return $html;
- }
-
-//---------- Build ldap filter string
-
- function build_filter_string()
- {
- $clean['attrb'] = $this->sanitize_filter_attribute();
- $clean['type'] = $this->sanitize_filter_type();
- $clean['value'] = $this->sanitize_filter_value();
-
- return $clean['attrb'] . $clean['type'] . $clean['value'];
-
- }
-
-//----------- Check uniqueness of uid attribute */
-
- function is_uid_present( $uid )
- {
- // Verify that uid entry's value be unique
- $filter = 'uid=' . $uid;
- $entry = $this->get_entries($filter);
-
- if ( $uid != '' && $entry['count'] == 1 )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
-//---------- Prepare userPassword
-
- function prepare_userpassword( $userpassword )
- {
- $dirty['userpassword'] = $userpassword;
-
- switch ( LDAP_PASSHASH )
- {
- case '{MD5}':
- $clean['userpassword'] = LDAP_PASSHASH . base64_encode( pack( 'H*', md5( $dirty['userpassword'] ) ) );
- break;
-
- case '{SHA}':
- $clean['userpassword'] = LDAP_PASSHASH . base64_encode( pack( 'H*', sha1( $dirty['userpassword'] ) ) );
- break;
- }
-
- return $clean['userpassword'];
- }
-
-//-----------/* Verify modifiable attributes
- /* Description : Generally used to redifine entry's input keys and values,
- /* based on is_valid() */
- /* $entry : is an array with entry's keys and values. */
-
- function sanitize_entry( $entry )
- {
- // Define attributes that can be modified
- $fields = array('uid', 'cn','userpassword','displayname','preferredlanguage','employeetype');
-
- // Verify and validate entry's attributes
- foreach ( $fields as $key )
- {
- if ( isset( $entry[$key] ) && $this->is_valid( $key, $entry[$key] ) )
- {
- // Values that reach this point may be concider "clean".
- $clean['entry'][$key] = $entry[$key];
- }
- }
-
- // Return clean entry array or false
- if ( isset( $clean['entry'] ) && is_array( $clean['entry'] ) )
- {
- return $clean['entry'];
- }
- else
- {
- return false;
- }
- }
-
-//----------/* Initialize useradd values.
- /* Description: Used in the useradd form page to initiate form values.
- /* $attribute : is an array with the related attributes to check. */
-
- function init_useradd_values( $attributes )
- {
- foreach ( $attributes as $key )
- {
- if ( ! isset( $_POST[$key] ) )
- {
- $entry[$key] = '';
- }
- else
- {
- if ( isset( $_POST[$key] ) && $this->is_valid($key, $_POST[$key]) )
- {
- $entry[$key] = $_POST[$key];
- }
- else
- {
- $entry[$key] = '';
- }
- }
- }
- return $entry;
- }
-
-//----------/* Initialize useradmin values and do action if submited
- /* values are different from the actual one.
- /* Description: used in the p_users.php to initiate form values.
- /* $id : is the name of the form identification.
- /* $attribute : is an array with the related attributes to check. */
-
- function init_useradmin_values( $entry, $attributes, $action )
- {
-
- // First loop to match b in x[b]
- for ($i = 0; $i < $entry['count']; $i++)
- {
- if ( isset( $_POST['uid'][$i] ))
- {
- // Define entry id
- $entry_new['uid'] = $entry[$i]['uid'][0];
-
- // Initialize entry cn
- // Needed to update sn in the background.
- $entry_new['cn'] = $entry[$i]['cn'][0];
-
- // Second loop to match x in x[b]
- foreach ( $attributes as $key )
- {
- // Reset entry value based on input
- if ( isset( $_POST[$key][$i] ) )
- {
- // Check it is a valid value
- if ( $this->is_valid( $key, $_POST[$key][$i] ) )
- {
- // ... and that it is different from the actual one
- if ( $_POST[$key][$i] != $entry[$i][$key][0] )
- {
-
- $entry_new[$key] = $_POST[$key][$i];
-
- // Prepare userPassword.
- // SECURITY: this attribute value should never
- // be verified with the previous one. If
- // verification is done you are providing a
- // way to "guess" the user password by trying
- // passwords until someone reject to update.
- // Not to critic but if you guess it at the
- // first try ;). Keep it unverifiable please.
- if ( $key == 'userpassword' )
- {
- $newpasswd = $this->prepare_userpassword($_POST[$key][$i]);
- $entry_new[$key] = $newpasswd;
- }
- }
- }
- }
- }
- }
-
- // Do action if pressent
- if ( isset( $entry_new ) )
- {
- $message = $this->do_action( $entry_new, $action );
- }
- else
- {
- $message = show_message(ucfirst(translate('nothing to do')), 'orange');
- }
- }
-
- return $message;
- }
-
-//-----------/* Do actions (udpate|delete|add)
- /* $entry : is an array with the entry's key and value information.
- /* $action : is an string telling what to do with the $entry.
- /* Description : Actions are applied to just one entry at the same time. */
- /* The returned value is a message telling what happend with
- the action requested.*/
-
- function do_action( $entry, $action )
- {
- // Define Entry's DN
- if ( isset( $entry['uid'] ) && $this->is_valid( 'uid', $entry['uid'] ) )
- {
- $dn = 'uid=' . $entry['uid'] . ',' . LDAP_DN;
- }
- else
- {
- $message = show_message(ucfirst(translate('a valid uid is required')),'orange');
- return $message;
- }
-
- // Define possible actions
- $possible_actions = '/^(add|update|delete)$/';
- if ( ! preg_match( $possible_actions, $action ) )
- {
- // There is nothing to do here so exit to finish action intention.
- $message = show_message(ucfirst(translate('invalid action')), 'red');
- return $message;
- }
-
- // Define what to do in each action's case
- switch ( $action )
- {
- case 'update':
-
- // If there are valid values then do the update action.
- if ( is_array( $entry ) )
- {
- // Update sn attribute
- $entry['sn'] = preg_replace('/^([a-zA-Z0-9_]+ ?)/','', $entry['cn']);
- if ( $entry['sn'] == '' )
- {
- $message = show_message(ucfirst(translate('invalid cn')), 'orange');
- return $message;
- }
-
- if (ldap_modify($this->ldapconn, $dn, $entry))
- {
- $message = show_message(ucfirst(translate('data was updated successfully')), 'green');
- }
- else
- {
- $message = show_message(ucfirst(translate('data was not updated')), 'orange');
- }
- }
- break;
-
- // Delete Entry
- case 'delete':
-
- // Delete Entry
- if ( is_array( $entry ) )
- {
- if ( ldap_delete( $this->ldapconn, $dn ) )
- {
- $message = show_message(ucfirst(translate('data was deleted successfully')), 'green');
- }
- else
- {
- $message = show_message(ucfirst(translate('data was not deleted')), 'orange');
- }
- }
- break;
-
- // Add Entry
- case 'add':
-
- // Verify uid presence
- if ( $this->is_uid_present( $entry['uid'] ) )
- {
- // Abort this action commitment.
- $message = show_message(ucfirst(translate('user identifier already exists')), 'orange');
- return $message;
- }
-
- // Define and validate required attributes
- $require_attrs = array('uid', 'userpassword', 'cn', 'displayname', 'preferredlanguage', 'employeetype');
- foreach ( $require_attrs as $key )
- {
- if ( !isset($entry[$key]) || ! $this->is_valid($key, $entry[$key]))
- {
- $message = show_message(ucfirst(translate('the field')) .' '. translate($key) .' ' . translate('requires a valid value') , 'orange');
- return $message;
- }
- }
-
- // Prepare userPassword and other attributes.
- $entry['userpassword'] = $this->prepare_userpassword($entry['userpassword']);
- $entry['objectclass'] = 'inetOrgPerson';
- $entry['sn'] = preg_replace('/^([a-zA-Z0-9_]+ ?)/','', $entry['cn']);
- if ( $entry['sn'] == '' )
- {
- $message = show_message(ucfirst(translate('invalid cn')), 'orange');
- return $message;
- }
- $entry['mail'] = $entry['uid'];
-
- // If there are valid values then do the add action.
- if ( ldap_add( $this->ldapconn, $dn, $entry ) )
- {
- $message = show_message(ucfirst(translate('user added successfully')), 'green');
- }
- else
- {
- $message = show_message(ucfirst(translate('user was not added')), 'orange');
- }
- break;
- }
-
- return $message;
- }
-
-//-------------------/* Rename entry dn */
-
- function rename_dn( $olddn, $newdn, $newparent, $deleteoldrdn )
- {
- ldap_rename($this->ldapconn, $olddn, $newdn, $newparent, $deleteoldrdn );
-
- return true;
- }
-
-//-----------/* Display useradmin information
- /* Description : Used in p_users.php
- /* $entries : is an array with the entries' keys and values. */
-
- function show_useradmin_info( $entries )
- {
- $html = '<ul>';
- $html .= '<li>LDAP Host: ' . LDAP_HOST . '</li>';
- $html .= '<li>Domain Component (dc): ' . LDAP_DN . '</li>';
- $html .= '<li>' . $this->show_filter() .'</li>';
- $html .= '<li>' . ucfirst(translate('results')) . ': '. $entries['count']; '</li>';
- $html .= '</ul>';
-
- return $html;
- }
-
-//-------------------/* Close connection */
-
- function __destruct()
- {
- if ( isset( $this->ldapconn ) )
- {
- ldap_unbind( $this->ldapconn );
- }
- }
-
-}
-
-$ldap = new LDAP;
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/functions/auth.php b/Scripts/CentOS-Web/admin/includes/functions/auth.php
deleted file mode 100644
index 1b1279f..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/auth.php
+++ /dev/null
@@ -1,140 +0,0 @@
-<?php
-/**
- * Authentication and authorization
- *
- * @category Logic
- * @package CentOS-News
- * @author Alain Reguera Delgado <alain.reguera@gmail.com>
- * @copyright 2009 - CentOS Artwork SIG.
- * @license GPL
- */
-
-//--------------Authentication stuff--------------
-
- session_start();
-
-//--------------/* Verify Admin access rights */
-
- function check_adminaccess()
- {
- /* Verify session */
- if (!isset($_SESSION['employeetype']))
- {
- header('Location: '. BASEURL .'admin/login.php');
- }
- }
-
- /* Check User Access */
- function check_useraccess()
- {
- $timeout = 60 * 30; // In seconds, i.e. 30 minutes.
- $fingerprint = md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT']);
- $redirect_to = BASEURL . 'admin/login.php?loggedout=true';
-
- /* Destroy session if ... */
- if (isset($_SESSION['last_active']) && $_SESSION['last_active'] < (time()-$timeout)
- || (isset($_SESSION['fingerprint']) && $_SESSION['fingerprint']!=$fingerprint)
- || isset($_GET['action']) && $_GET['action'] == 'logout')
- {
-
- setcookie(session_name(), '', time()-3600, '/');
- session_destroy();
- header("Location: $redirect_to");
- }
-
- /* Regenerate session */
- session_regenerate_id();
-
- /* Increase session lifetime */
- $_SESSION['last_active'] = time();
-
- /* Rebuild session fingerprint */
- $_SESSION['fingerprint'] = $fingerprint;
-
- }
-
- /* Verify username and password */
- function login()
- {
- require_once(ABSPATH . 'admin/includes/classes/ldap.php');
- $ldap = new LDAP;
-
- /* Inicialize variables */
- $login = array();
- $login['username'] = '';
- $login['password'] = '';
-
- /* Validate username input */
- if (isset($_POST['username']))
- {
- $mail_pattern = '/^([a-z0-9+_]|\-|\.)+@(([a-z0-9_]|\-)+\.)+[a-z]{2,6}$/';
- if (preg_match( $mail_pattern,$_POST['username']))
- {
- $login['username'] = $_POST['username'];
- }
- }
-
- /* Validate password input */
- if (isset($_POST['password']))
- {
- $login['password'] = $ldap->prepare_userpassword($_POST['password']);
- }
-
- /* Query LDAP directory looking for username AND password */
- $search = $ldap->get_entries('(&(uid=' . $login['username'] . ')(&(userpassword=' . $login['password'] . ')))');
-
- /* Build user's session if match */
- if ($search['count'] == 1)
- {
- /* Set session information */
- $_SESSION['uid'] = $search[0]['uid'][0];
- $_SESSION['cn'] = $search[0]['cn'][0];
- $_SESSION['employeetype'] = $search[0]['employeetype'][0];
-
- /* Set session lasttime access */
- $_SESSION['last_active'] = time();
-
- /* Set session fingerprint */
- $fingerprint = md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT']);
- $_SESSION['fingerprint'] = $fingerprint;
-
- /* Redirect to frontpage */
- header("Location: " . BASEURL);
-
- return 0;
- }
- else if ($search['count'] > 1)
- {
- // Login Failed: There are duplicates in the ldap directory database
- return 002;
- }
- else
- {
- // Login Failed: There is no coincidece in the search
- return '001';
- }
- }
-
- // User links
- function get_auth_userlinks()
- {
-
- $html = '<ul>' . "\n";
-
- if (isset($_SESSION['cn']))
- {
- $html .= '<li><strong>' . $_SESSION['cn'] . '</strong> (<a href="?action=logout">' . ucfirst(translate("logout")) . '</a>)</li>' . "\n";
- $html .= '<li><a href="admin/index.php">' . ucfirst(translate("admin")) . '</a></li>' . "\n";
- }
- else
- {
- $html .= '<li><a href="admin/login.php">' . ucfirst(translate("login")) . '</a></li>' . "\n";
- }
-
- $html .= '</ul>' . "\n";
-
- return $html;
-
- }
-
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/functions/categories.php b/Scripts/CentOS-Web/admin/includes/functions/categories.php
deleted file mode 100644
index a6ebe11..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/categories.php
+++ /dev/null
@@ -1,363 +0,0 @@
-<?php
-/**
- * Categories related functions
- *
- */
-
-
-//--------/* Get Category Name */
-
-function get_category_name( $category_id )
-{
- global $db;
- if ( preg_match('/^[0-9]+$/', $category_id ) )
- {
- $category_id = pg_escape_string( $category_id );
- $sql_string = "SELECT name, parent FROM categories WHERE id=" . $category_id . ";";
- $source = $db->query( $sql_string );
- $category = pg_fetch_array($source);
-
- if ( ! $category['name'] )
- {
- $category['name'] = 'No';
- }
- }
-
- return $category['name'];
-}
-
-//-------/* Get Admin Categories Selector
- /* (used in category administration) */
-
-function get_category_selector( $category_id = null, $category_parent_id = null, $type = 'insert' )
-{
- global $db;
-
- $sql_string = "SELECT id, name, parent FROM categories;";
- $rows = $db->query( $sql_string );
-
- $html = '<select name="parent">';
- $html .= '<option value="0"> </option>';
-
- while ( $row = pg_fetch_array( $rows ) )
- {
- switch ($type)
- {
- case 'update':
- if ( isset( $category_id ) && $row['id'] != $category_id )
- {
- if ( isset( $category_parent_id ) && $row['id'] == $category_parent_id )
- {
- $html .= '<option selected value="'.$row['id'].'">'.$row['name'].'</option>';
- }
- else
- {
- $html .= '<option value="'.$row['id'].'">'.$row['name'].'</option>';
- }
- }
- break;
-
- default:
- $html .= '<option value="'.$row['id'].'">'.$row['name'].'</option>';
- break;
-
- }
-
- }
-
- $html .= '</select>';
-
- return $html;
-}
-
-//-------/* Get Admin Categories Form
-
-function get_categories_admin_form( $rows )
-{
- $html = '<form action="" method="post" name="categories_admin">';
- $html .= '<div class="action alignr">';
- $html .= show_action_field('delete');
- $html .= '<input type="submit" name="categoriesadmin" value="' . ucfirst(translate('accept')). '" />';
- $html .= '</div>';
-
- $html .= '<table>';
- $html .= '<tr>';
- $html .= '<th class="firstcol"></th>';
- $html .= '<th style="width:200px">' . ucfirst(translate('name')) . '</th>';
- $html .= '<th style="width:200px">' . ucfirst(translate('parent category')) . '</th>';
- $html .= '<th>' . ucfirst(translate('description')) . '</th>';
- $html .= '</tr>';
-
- // Loop throuh rows
- while ( $row = pg_fetch_array($rows) )
- {
- $html .= '<tr>';
- $html .= '<td><input type="checkbox" name="id['.$row['id'].']" value="'.$row['id'].'" /></td>';
- $html .= '<td><a href="?page=categories&action=update&id='.$row['id'].'">'.$row['name'].'</a></td>';
- $html .= '<td class="alignc">'. get_category_name($row['id']) .'</td>';
- $html .= '<td>'.$row['description'].'</td>';
- $html .= '</tr>';
- }
-
- $html .= '</table>';
-
- $html .= '<div class="action alignr">';
- $html .= '<input type="submit" name="categoriesadmin" value="' . ucfirst(translate('accept')). '" />';
- $html .= '</div>';
- $html .= '</form>';
-
- return $html;
-}
-
-//-------/* Get Add Categories Form
-
-function get_categories_add_form()
-{
- $html = '<div class="formfields">';
- $html .= '<form action="" method="post" name="categories_add">';
- $html .= '<ul>';
- $html .= '<li class="description">' . translate('Name') . '</li>';
- $html .= '<li class="value"><input type="text" name="name" value="" size="30" /></li>';
- $html .= '<li class="description">' . ucfirst( translate('parent category') ) . '</li>';
- $html .= '<li class="value">' . get_category_selector() . '</li>';
- $html .= '<li class="description">' . translate('Description') . '</li>';
- $html .= '<li class="value"><textarea name="description" cols="50" rows="6"></textarea></li>';
- $html .= '<li class="submit"><input type="submit" name="add_categories" value="'. ucfirst(translate('add')) .'" /></li>';
- $html .= '</ul>';
- $html .= '<input type="hidden" name="action" value="add" />';
- $html .= '</form>';
- $html .= '</div>';
-
- return $html;
-}
-
-//-------/* Get Update Categories Form
-
-function get_categories_update_form()
-{
- global $db;
-
- if ( sanitize_url_var( 'id' ) )
- {
- $clean['id'] = $_GET['id'];
- $sql_string = "SELECT id, name, parent, description FROM categories WHERE id=" . $clean['id'] . ";";
- $row = $db->query( $sql_string );
-
- if ( $row !== false )
- {
- $row = pg_fetch_array($row);
-
- $html = '<div class="formfields">';
- $html .= '<form action="" method="post" name="categories_update">';
- $html .= '<ul>';
- $html .= '<li class="description">' . translate('Name') . '</li>';
- $html .= '<li class="value"><input type="text" name="name" value="' . $row['name'] . '" size="30" /></li>';
- $html .= '<li class="description">' . ucfirst(translate('parent category')) . '</li>';
- $html .= '<li class="value">'. get_category_selector( $row['id'], $row['parent'], 'update').'</li>';
- $html .= '<li class="description">' . translate('Description') . '</li>';
- $html .= '<li class="value"><textarea name="description" cols="50" rows="6">'. $row['description'] .'</textarea></li>';
- $html .= '<li class="submit"><input type="submit" name="update_categories" value="'. ucfirst(translate('update')) .'" /></li>';
- $html .= '</ul>';
- $html .= '<input type="hidden" name="action" value="update" />';
- $html .= '</form>';
- $html .= '</div>';
- }
- else
- {
- $html = show_message( ucfirst( translate("the category doesn't exist") ) , 'orange');
- }
- }
- else
- {
- $html = show_message( ucfirst( translate('nothing to do') ) , 'orange');
- }
-
- return $html;
-}
-
-//-------/* Administrate Categories
-
-function admin_categories()
-{
- global $db;
-
- $fields = array('id', 'name', 'parent', 'description');
- $counter = 0;
-
- // Define action to do
- if (isset($_POST['action']) && preg_match('/^(update|delete|add)$/', $_POST['action']))
- {
- $action = $_POST['action'];
-
- switch ( $action )
- {
- case 'update':
-
- // Initialize FORM variables
- foreach ( $fields as $key )
- {
- if ( isset( $_POST[$key] ) && $_POST[$key] != '' )
- {
- $clean[$key] = pg_escape_string($_POST[$key]);
- }
- else
- {
- $clean[$key] = '';
- }
- }
-
-
- // Required fields
- if ( $clean['name'] == '' )
- {
- $message = show_message(ucfirst(translate('field name can not be empty')),'orange');
- return $message;
- }
-
- // Verify and redifine category indentification
- if ( sanitize_url_var( 'id' ) )
- {
- $clean['id'] = $_GET['id'];
- }
-
-
- // Build sql string for updating
- $sql_string = "UPDATE categories SET name='" . $clean['name'] . "', description='" . $clean['description'] . "' WHERE id=" . $clean['id'] . ";";
-echo $sql_string;
- // Execute UPDATE action
- $db->query( $sql_string );
-
- // Define message for successful action
- $message = show_message( ucfirst( translate('data was updated successfully' ) ), 'green');
-
- break;
-
- case 'delete':
-
- if ( isset( $_POST['id'] ) )
- {
- foreach ( $_POST['id'] as $key )
- {
- if ( preg_match( '/^[0-9]+$/', $key ) )
- {
- // Check for dependencies for actual category id
- // ...
-
- // Build SQL string for deleting
- $sql_string = "DELETE FROM categories WHERE id=" . $key . ";";
-
- // Execute DELETE action
- if ( $db->query( $sql_string ) )
- {
- $counter++;
- }
- }
- else
- {
- // Build message for failed action
- $message = show_message(ucfirst(translate('id value is incorrect')));
- return $message;
- }
- }
-
- // Build message for successful action (with plural distinction)
- if ( $counter > 1 )
- {
- $message = $counter . ' ' . translate('records deleted successfully');
- }
- else
- {
- $message = $counter . ' ' . translate('record deleted successfully');
- }
- $message = show_message( $message, 'green');
- }
- break;
-
- case 'add':
-
- $fields = array('name', 'parent', 'description');
-
- // Initialize and prepare input values for db insertion
- foreach ( $fields as $key)
- {
- if ( isset( $_POST[$key] ) )
- {
- $clean[$key] = pg_escape_string($_POST[$key]);
- }
- else
- {
- $clean[$key] = '';
- }
- }
-
- // Required fields
- if ( $clean['name'] == '' )
- {
- $message = show_message(ucfirst(translate('field name can not be empty')),'orange');
- return $message;
- }
-
- // Build sql string for inserting
- $sql_string = "INSERT INTO categories (name, parent, description)
- VALUES ('".$clean['name']."', '" . $clean['parent']. "', '" .$clean['description']."');";
-
- // Execute INSERT action
- if ( $db->query( $sql_string ) )
- {
- // Build message for successful action
- $message = show_message(ucfirst(translate('category was added successfully')),'green');
- }
- else
- {
- // Build message for failed action
- $message = show_message(ucfirst(translate('category was not added')),'orange');
- }
- break;
- }
-
- // Define default informative message if no action is present
- if ( ! isset( $message ) )
- {
- $message = show_message(ucfirst(translate('nothing to do')), 'orange');
- }
-
- // Return informative action message
- return $message;
-
- }
-
- // Return false if no action is present
- return false;
-}
-
-
-//--------/* Get Category Tree */
-
-function get_category_tree( $parent = 0, $linkto = 'default' )
-{
-
- global $db;
- $sql_string = "SELECT id, name, parent FROM categories WHERE parent = ". $parent ." ORDER BY name;";
- $categories = $db->query($sql_string);
- $html = '';
-
- $html .= '<ul class="category_tree">';
- while ( $row = pg_fetch_array($categories) )
- {
- switch ( $linkto )
- {
- case 'admin':
- $html .= '<li><a href="?page=categories&action=update&id='.$row['id'].'">' . $row['name'] . '</a></li>';
- break;
-
- default:
- $html .= '<li><a href="?page=posts&sort=categories&id='.$row['id'].'">' . $row['name'] . '</a></li>';
- break;
-
- }
- $html .= get_category_tree( $row['id'] , $linkto );
- }
- $html .= '</ul>';
-
- return $html;
-}
diff --git a/Scripts/CentOS-Web/admin/includes/functions/html.php b/Scripts/CentOS-Web/admin/includes/functions/html.php
deleted file mode 100644
index 187fad5..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/html.php
+++ /dev/null
@@ -1,47 +0,0 @@
-<?php
-/***
- * Function collection for html admin needs
- *
- * ...
- */
-
-//-----------/* Show admonition
- /* Description: Useful to show actions results */
- /* $message : is an string with the message itself */
- /* $severity : may be green, orange, red, violet or blue */
-
- function show_message( $message , $severity = 'blue' )
- {
-
- $html = '<div class="message lm ' . $severity . '">';
- $html .= $message;
- $html .= '</div>';
-
- return $html;
- }
-
-//-------/* Show action selector form field
-
- function show_action_field( $action = 'default' )
- {
- $html = ucfirst(translate('action')) . ': <select name="action">';
- switch ( $action )
- {
- case 'update':
- $html .= '<option value="update">' . ucfirst(translate('update')) . '</option>';
- break;
-
- case 'delete':
- $html .= '<option value="delete">' . ucfirst(translate('delete')) . '</option>';
- break;
-
- default:
- $html .= '<option value="update">' . ucfirst(translate('update')) . '</option>';
- $html .= '<option value="delete">' . ucfirst(translate('delete')) . '</option>';
- }
- $html .= '</select>';
-
- return $html;
-
- }
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/functions/links.php b/Scripts/CentOS-Web/admin/includes/functions/links.php
deleted file mode 100644
index 5546d8f..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/links.php
+++ /dev/null
@@ -1,165 +0,0 @@
-<?php
-/***
- * Mainlinks used in administratoristration interface
- *
- * @param show_mainlink();
- * @param control link visibility/availability.
- */
-
- function show_mainlinks()
- {
-
- //--------------------/* Initialize Link Array */
-
- $link = array();
-
- // User should have writer access to see the following links.
- if ( is_user('writer') || is_user('administrator') )
- {
- $link['entries'] = ucfirst(translate('entries'));
- }
-
- // User should have administrator rights to see the following links.
- if ( is_user('administrator') )
- {
- $link['pages'] = ucfirst(translate('pages'));
- $link['categories'] = ucfirst(translate('categories'));
- $link['comments'] = ucfirst(translate('comments'));
- $link['links'] = ucfirst(translate('links'));
- $link['users'] = ucfirst(translate('users'));
- }
-
- //-----------/* Sanitize URL variables */
-
- if ( sanitize_url_var('page') )
- {
- $url['page'] = $_GET['page'];
- }
-
- //--------------------/* Build html links */
-
- $html = '<ul class="mainlinks">';
-
- if ( isset($url['page'] ) )
- {
- $html .= '<li><a href="index.php">'. strtoupper(translate('home')) . '</a></li>';
- }
- else
- {
- $html .= '<li class="current"><a href="index.php">'. strtoupper(translate('home')) . '</a></li>';
- }
-
- foreach ($link as $key => $value)
- {
- if ( isset($url['page']) && $url['page'] == $key)
- {
- $value = translate(strtolower($key));
- $html .= '<li class="current"><a href="?page='.$key.'">' . strtoupper($value). '</a></li>';
- }
- else
- {
- $value = translate(strtolower($key));
- $html .= '<li><a href="?page='.$key.'">' . strtoupper($value). '</a></li>';
- }
- }
-
- $html .= '</ul>';
-
- return $html;
- }
-
-/***
- * Sublinks used in the administratoristration interface
- *
- * @param show_sublink();
- * @param control link visibility/availability.
- */
-
-function show_sublinks()
-{
-
-//-----------/* Initialize Link Array */
-
- $link = array();
-
- $link['entries'] = ucfirst(translate('entries'));
- $link['pages'] = ucfirst(translate('pages'));
- $link['categories'] = ucfirst(translate('categories'));
- $link['links'] = ucfirst(translate('links'));
- $link['users'] = ucfirst(translate('users'));
-
-//-----------/* Sanitize URL variables */
-
- if ( sanitize_url_var('page') )
- {
- $url['page'] = $_GET['page'];
- }
-
-//-----------/* Build html links */
-
- $html = '<div class="sublinks">';
- $html .= '<ul>';
-
-if ( isset( $url['page'] ) )
-{
- switch ($url['page'])
- {
-
- case 'entries':
- if ( is_user('writer') == 'true' || is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=entries">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('entries')) . '</a></li>';
- $html .= '<li><a href="?page=entries&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('entry')) . '</a></li>';
- }
- break;
-
- case 'pages':
- if ( is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=pages">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('pages')) . '</a></li>';
- $html .= '<li><a href="?page=pages&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('page')) . '</a></li>';
- }
- break;
-
- case 'categories':
- if ( is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=categories">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('categories')) . '</a></li>';
- $html .= '<li><a href="?page=categories&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('category')) . '</a></li>';
- $html .= '<li><a href="?page=categories&action=tree">' . ucfirst(translate(strtolower('category tree'))) . '</a></li>';
- }
- break;
-
- case 'comments':
- if ( is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=comments">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('comments')) . '</a></li>';
- $html .= '<li><a href="?page=comments&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('comment')) . '</a></li>';
- }
- break;
-
- case 'links':
- if ( is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=links">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('links')) . '</a></li>';
- $html .= '<li><a href="?page=links&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('link')) . '</a></li>';
- }
- break;
-
- case 'users':
- if ( is_user('administrator') == 'true' )
- {
- $html .= '<li><a href="?page=users">' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('users')) . '</a></li>';
- $html .= '<li><a href="?page=users&action=add">' . ucfirst(translate(strtolower('add'))) . ' ' . translate(strtolower('user')) . '</a></li>';
- }
- break;
-
- }
- }
-
- $html .= '</ul>';
- $html .= '</div>';
-
- return $html;
- }
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/functions/url.php b/Scripts/CentOS-Web/admin/includes/functions/url.php
deleted file mode 100644
index 570f521..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/url.php
+++ /dev/null
@@ -1,53 +0,0 @@
-<?php
-/***
- * URL's functions
- *
- */
-
-
-//-----------/* Sanitize URL variables */
-
- function sanitize_url_var( $name )
- {
- if ( ! preg_match( '/^(page|action|id)$/', $name ) )
- {
- return false;
- }
-
- switch ( $name )
- {
- case 'page':
- if ( isset($_GET[$name]) && preg_match( '/^(users|pages|categories|comments|entries|links)$/', $_GET[$name] ) )
- {
- return true;
- }
- else
- {
- return false;
- }
- break;
-
- case 'action':
- if ( isset( $_GET[$name] ) && preg_match( '/^(update|add|tree|logout)$/', $_GET[$name] ) )
- {
- return true;
- }
- else
- {
- return false;
- }
- break;
-
- case 'id':
- if ( isset( $_GET[$name] ) && preg_match( '/^[0-9]+$/', $_GET[$name] ) )
- {
- return true;
- }
- else
- {
- return false;
- }
- break;
- }
- }
-?>
diff --git a/Scripts/CentOS-Web/admin/includes/functions/users.php b/Scripts/CentOS-Web/admin/includes/functions/users.php
deleted file mode 100644
index 78abe8f..0000000
--- a/Scripts/CentOS-Web/admin/includes/functions/users.php
+++ /dev/null
@@ -1,189 +0,0 @@
-<?php
-/**
- * User related functions
- *
- */
-
-
-//---------------------/* Define user's roles */
-
- function get_user_roles()
- {
- // First array value ("writer" in this case) define the default value.
- $employeetype = array('writer', 'administrator');
-
- return $employeetype;
- }
-
-//---------------------/* Define user's attributes */
-
- function get_user_attributes()
- {
- $attributes = array('dn', 'objectclass', 'uid', 'employeetype',
- 'sn', 'preferredlanguage', 'userpassword',
- 'displayname', 'mail', 'cn');
-
- return $attributes;
- }
-
-//---------------------/* Define user's languages */
-
- function get_user_languages()
- {
- $languages = array('en' => 'English',
- 'es' => 'Español',
- 'fr' => 'Français');
-
- return $languages;
- }
-
-//---------------------/* Determine user's role */
-
- function is_user( $role )
- {
- if ( $_SESSION['employeetype'] == $role )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
-//---------------------/* User Role-Selector */
-
-function get_user_roleSelector( $id = '', $entry_value = '' )
-{
- $employeetypes = get_user_roles();
-
- if ( ! is_int($id) )
- {
- $html = '<select name="employeetype">';
- }
- else
- {
- $html = '<select name="employeetype['. $id . ']">';
- }
-
- foreach ($employeetypes as $value )
- {
- if ( $entry_value <> '' && $value == $entry_value )
- {
- $html .= '<option selected value="'.$value.'">'.ucfirst(translate($value)).'</option>';
- }
- else
- {
- $html .= '<option value="'.$value.'">'.ucfirst(translate($value)).'</option>';
- }
- }
-
- $html .= '</select>';
-
- return $html;
-}
-
-//---------------------/* User Attribute-Selector */
-
-function get_user_attrSelector( $attr = '/(uid|cn|preferredlanguage|employeetype)/' )
-{
- global $ldap;
-
- $clean['attrb'] = $ldap->sanitize_filter_attribute();
-
- $attributes = get_user_attributes();
-
- $html = '<select name="attribute">';
-
- foreach ( $attributes as $value )
- {
- if ( preg_match ( $attr, $value ) )
- {
- if ( $clean['attrb'] == $value )
- {
- $html .= '<option selected value="'.$value.'">' . ucfirst(translate($value)) . '</option>';
- }
- else
- {
- $html .= '<option value="'.$value.'">' . ucfirst(translate($value)) . '</option>';
- }
- }
-
- }
-
- $html .= '</select>';
-
- return $html;
-}
-
-//---------------------/* User Language-Selector */
-
-function get_user_langSelector( $id = '', $entry_value = '' )
-{
- $languages = get_user_languages();
-
- if ( isset($id) && is_int($id) )
- {
- $html = '<select name="preferredlanguage['. $id . ']">';
- }
- else
- {
- $html = '<select name="preferredlanguage">';
- }
-
- foreach ($languages as $key => $value )
- {
- if ( ( $entry_value <> '' && $key == $entry_value ) || ( $id == '' && $entry_value == '' && $key == LANGUAGE ) )
- {
- $html .= '<option selected value="'.$key.'">'.ucfirst(translate($value)).'</option>';
- }
- else
- {
- $html .= '<option value="'.$key.'">'.ucfirst(translate($value)).'</option>';
- }
- }
-
- $html .= '</select>';
-
- return $html;
-}
-
-//-------/* Build useradd's form */
-
-function show_useradd_form( $entry )
-{
- $html = '<div class="formfields">';
- $html .= '<form name="useradd" action="" method="post">';
-
- $html .= '<ul>';
- $html .= '<li class="description">' . ucfirst(translate('uid')) .':</li>';
- $html .= '<li class="value"><input type="text" name="uid" value="' . $entry['uid'] . '" size="30" /> ' . ucfirst(translate('ex')) . '. john@example.com</li>';
- $html .= '<li class="description">' . ucfirst(translate('password')) . ':</li>';
- $html .= '<li class="value"><input type="password" name="userpassword" value="" size="30" /></li>';
- $html .= '<li class="description">'. ucfirst(translate('cn')) . ':</li>';
- $html .= '<li class="value"><input type="text" name="cn" value="' . $entry['cn'] . '" size="30" /></li>';
- $html .= '<li class="description">'. ucfirst(translate('displayname')) . ':</li>';
- $html .= '<li class="value"><input type="text" name="displayname" value="' . $entry['displayname'] . '" size="30" /></li>';
- $html .= '<li class="description">'. ucfirst(translate('preferredlanguage')) . ':</li>';
- $html .= '<li class="value">' . get_user_langSelector() . '</li>';
- $html .= '<li class="description">' . ucfirst(translate('employeetype')) . ':</li>';
- $html .= '<li class="value">'. get_user_roleSelector() . '</li>';
- $html .= '<li class="submit"><input type="submit" name="useradd" value="' . ucfirst(translate('add')) . '" /></li>';
- $html .= '</ul>';
-
- $html .= '</form>';
- $html .= '</div>';
-
- return $html;
-}
-
-//-------/* Show useradmin form
-
- function show_useradmin_form()
- {
-
-
-
- }
-
-?>
diff --git a/Scripts/CentOS-Web/admin/index.php b/Scripts/CentOS-Web/admin/index.php
deleted file mode 100644
index 2f8814f..0000000
--- a/Scripts/CentOS-Web/admin/index.php
+++ /dev/null
@@ -1,25 +0,0 @@
-<?php
-
- require_once('../config.php');
- require_once(ABSPATH . 'admin/includes/functions/auth.php');
- check_adminaccess();
- check_useraccess();
- require_once(ABSPATH . 'includes/translations/'.LANGUAGE.'.php');
- require_once(ABSPATH . 'admin/includes/classes/ldap.php');
- require_once(ABSPATH . 'admin/includes/classes/db_postgresql.php');
- require_once(ABSPATH . 'admin/includes/functions/categories.php');
- require_once(ABSPATH . 'admin/includes/functions/users.php');
- require_once(ABSPATH . 'admin/includes/functions/url.php');
- require_once(ABSPATH . 'admin/includes/functions/links.php');
- require_once(ABSPATH . 'admin/includes/functions/html.php');
-
- // Header template
- include("header.php");
-
- // Content template
- include("content.php");
-
- // Footer template
- include("footer.php");
-
-?>
diff --git a/Scripts/CentOS-Web/admin/login.php b/Scripts/CentOS-Web/admin/login.php
deleted file mode 100644
index 1a90302..0000000
--- a/Scripts/CentOS-Web/admin/login.php
+++ /dev/null
@@ -1,107 +0,0 @@
-<?php
-/***
- * Login page
- *
- */
-
-require_once('../config.php');
-require_once('../includes/translations/' . LANGUAGE . '.php');
-require_once('includes/functions/auth.php');
-
-// If session is active redirect back to baseurl.
-if (isset($_SESSION['employeetype']))
-{
- header('Location: ' . BASEURL );
-}
-
-
-/* Check Login */
-$message = '';
-if (isset($_POST['username']) && isset($_POST['password']) && !isset($_SESSION['employeetype']))
-{
- $message = login();
-
- if ($message <> 0)
- {
- $message = '<div class="message lm orange">' . ucfirst(translate($message)) . '</div>';
- }
- else
- {
- header('Location: index.php');
- }
-}
-?>
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
-<html>
-<head>
- <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
- <title>Admin :: <?php echo HTML_TITLE ?></title>
- <link rel="stylesheet" type="text/css" charset="utf-8" media="all" href="style.css">
- <script type="text/javascript">
- function focusit() {
- document.getElementById('username').focus();
- }
- window.onload = focusit;
- </script>
-
-</head>
-
-<body>
-
- <div id="header">
- <div id="logo">
-
- <a href="<?php echo BASEURL ?>">
-
- <img src="../contents/images/logo.png" alt="">
- <span class="logo_text"><?php echo ucfirst(translate(LANGUAGE))?></span>
-
- </a>
-
- </div>
- </div>
-
- <div class="pageline" style="border-color: #6FA4DF;"></div>
-
- <div id="content" style="padding-left: 1em;">
-
- <h1><?php echo ucfirst(translate('login')) ?></h1>
-
- <?php if (isset($message) && $message <> '') {; echo $message; } ?>
-
- <form name="login" method="post" action="">
- <table style="border: 0;">
- <tr>
- <td style="border:none; width: 1%; text-align: right;"><strong><?php echo ucfirst(translate('username')); ?>:</strong></td>
- <td style="border:none"><input id="username" type="text" name="username" size="30"> (<?php echo ucfirst(translate('ex')); ?>. john@example.com)</td>
- </tr>
- <tr>
- <td style="border: none;"><strong><?php echo ucfirst(translate('password'));?>:</strong></td>
- <td style="border: none;"><input type="password" name="password" size="30"></td>
- </tr>
- <tr>
- <td style="border: none;"></td>
- <td style="border: none;"><input type="submit" name="submit" value="<?php echo ucfirst(translate('login')) ?>"></td>
- </tr>
- </table>
- </form>
-
- </div>
- </div>
-
-
- <div id="footer">
-
- <div class="pageline" style="border-color: #6FA4DF;"></div>
- <div class="credits">
-
- <p class="right"></p>
-
- <p><?php echo ucfirst(translate('credits_on_footer_1'))?></p>
-
- </div>
-
- </div>
-
-<body>
-</html>
diff --git a/Scripts/CentOS-Web/admin/p_categories.php b/Scripts/CentOS-Web/admin/p_categories.php
deleted file mode 100644
index f6ef325..0000000
--- a/Scripts/CentOS-Web/admin/p_categories.php
+++ /dev/null
@@ -1,34 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=categories&a=cat">this instead</a>.</h3>';
- exit;
- }
-
-//----- Admin categories
-
- $message = admin_categories();
-
-//----- Get Row
-
- $sql_string = "SELECT id, name, parent, description FROM categories ORDER BY name;";
- $rows = $db->query( $sql_string );
-
-//----- Show action results
-
- if ( isset( $message ) )
- {
- echo $message;
- }
-?>
-
-
-
-<h1><?php echo ucfirst(translate(strtolower('admin')))?> <?php echo translate(strtolower('categories'))?></h1>
-
-<hr />
-<?php echo get_categories_admin_form( $rows ) ?>
-<hr />
diff --git a/Scripts/CentOS-Web/admin/p_categories_add.php b/Scripts/CentOS-Web/admin/p_categories_add.php
deleted file mode 100644
index 011261e..0000000
--- a/Scripts/CentOS-Web/admin/p_categories_add.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=categories">this instead</a>.</h3>';
- exit;
- }
-
-//---- Do action and grab results
-
- if (isset($_POST['action']))
- {
- $message = admin_categories();
- if (isset($message))
- {
- echo $message;
- }
- }
-
-?>
-
-<h1><?php echo ucfirst(translate(strtolower('add')))?> <?php echo translate(strtolower('category'))?></h1>
-
-<?php echo get_categories_add_form(); ?>
diff --git a/Scripts/CentOS-Web/admin/p_categories_tree.php b/Scripts/CentOS-Web/admin/p_categories_tree.php
deleted file mode 100644
index 9745922..0000000
--- a/Scripts/CentOS-Web/admin/p_categories_tree.php
+++ /dev/null
@@ -1,15 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=categories">this instead</a>.</h3>';
- exit;
- }
-
-?>
-
-<h1><?php echo ucfirst(translate(strtolower('category tree')))?></h1>
-
-<?php echo get_category_tree( '0', 'admin'); ?>
diff --git a/Scripts/CentOS-Web/admin/p_categories_update.php b/Scripts/CentOS-Web/admin/p_categories_update.php
deleted file mode 100644
index 77012ce..0000000
--- a/Scripts/CentOS-Web/admin/p_categories_update.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=categories">this instead</a>.</h3>';
- exit;
- }
-
-//---- Do action and grab results
-
- if (isset($_POST['action']))
- {
- $message = admin_categories();
- if (isset($message))
- {
- echo $message;
- }
- }
-
-?>
-
-<h1><?php echo ucfirst(translate(strtolower('update')))?> <?php echo translate(strtolower('category'))?></h1>
-
-<?php echo get_categories_update_form(); ?>
diff --git a/Scripts/CentOS-Web/admin/p_comments.php b/Scripts/CentOS-Web/admin/p_comments.php
deleted file mode 100644
index 89270dc..0000000
--- a/Scripts/CentOS-Web/admin/p_comments.php
+++ /dev/null
@@ -1,30 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?page=comments">this instead</a>.</h3>';
- exit;
- }
-
-//----- Admin categories
-
-
-//----- Get Row
-
-
-//----- Show action results
-
- if ( isset( $message ) )
- {
- echo $message;
- }
-?>
-
-
-
-<h1><?php echo ucfirst(translate(strtolower('admin')))?> <?php echo translate(strtolower('comments'))?></h1>
-
-<hr />
-<hr />
diff --git a/Scripts/CentOS-Web/admin/p_entries.php b/Scripts/CentOS-Web/admin/p_entries.php
deleted file mode 100644
index be30f7b..0000000
--- a/Scripts/CentOS-Web/admin/p_entries.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=entries">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate(strtolower('admin')))?> <?php echo translate(strtolower('entries'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_entries_add.php b/Scripts/CentOS-Web/admin/p_entries_add.php
deleted file mode 100644
index dd9ab86..0000000
--- a/Scripts/CentOS-Web/admin/p_entries_add.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=entries&a=add">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate('add')) . ' ' . translate('entry')?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_entries_update.php b/Scripts/CentOS-Web/admin/p_entries_update.php
deleted file mode 100644
index ae7d74f..0000000
--- a/Scripts/CentOS-Web/admin/p_entries_update.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=entries">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate(strtolower('update')))?> <?php echo translate(strtolower('entry'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_index.php b/Scripts/CentOS-Web/admin/p_index.php
deleted file mode 100644
index c609f84..0000000
--- a/Scripts/CentOS-Web/admin/p_index.php
+++ /dev/null
@@ -1,17 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1>
- <?php echo ucfirst(translate(strtolower('hello')))?>
- <?php echo preg_replace('/ .*$/','',$_SESSION['cn'])?>
-</h1>
-
-<p><strong>Database Status:</strong> <?php echo $db->check_connection();?></p>
-<p><?php echo ucfirst(translate(strtolower('admin_info_1')))?></p>
diff --git a/Scripts/CentOS-Web/admin/p_links.php b/Scripts/CentOS-Web/admin/p_links.php
deleted file mode 100644
index f0a3144..0000000
--- a/Scripts/CentOS-Web/admin/p_links.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=links">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate(strtolower('admin')))?> <?php echo translate(strtolower('links'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_links_add.php b/Scripts/CentOS-Web/admin/p_links_add.php
deleted file mode 100644
index bbdad5d..0000000
--- a/Scripts/CentOS-Web/admin/p_links_add.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=links">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate('add'))?> <?php echo translate('link') ?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_pages.php b/Scripts/CentOS-Web/admin/p_pages.php
deleted file mode 100644
index 0266e00..0000000
--- a/Scripts/CentOS-Web/admin/p_pages.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=pages">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate(strtolower('admin')))?> <?php echo translate(strtolower('pages'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_pages_add.php b/Scripts/CentOS-Web/admin/p_pages_add.php
deleted file mode 100644
index 9c5b616..0000000
--- a/Scripts/CentOS-Web/admin/p_pages_add.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=pages&a=add">this instead</a>.</h3>';
- exit;
- }
-?>
-<h1><?php echo ucfirst(translate(strtolower('add')))?> <?php echo translate(strtolower('page'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_pages_update.php b/Scripts/CentOS-Web/admin/p_pages_update.php
deleted file mode 100644
index 11f1c32..0000000
--- a/Scripts/CentOS-Web/admin/p_pages_update.php
+++ /dev/null
@@ -1,12 +0,0 @@
-<?php
-//--------------------/* Show error if called directly */
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=pages">this instead</a>.</h3>';
- exit;
- }
-?>
-
-<h1><?php echo ucfirst(translate(strtolower('update')))?> <?php echo translate(strtolower('page'))?></h1>
diff --git a/Scripts/CentOS-Web/admin/p_users.php b/Scripts/CentOS-Web/admin/p_users.php
deleted file mode 100644
index 2a37577..0000000
--- a/Scripts/CentOS-Web/admin/p_users.php
+++ /dev/null
@@ -1,134 +0,0 @@
-<?php
-/***
- * Useradmin page.
- *
- * This page sumarize the actions needed to administer users into LDAP
- * directory server's database.
- *
- * --
- * 2009 (c) Alain Reguera Delgado <al@ciget.cienfuegos.cu>
- * Released under GPL lisence (http://www.fsf.org/licensing/licenses/gpl.txt)
- */
-
-
-//-------------/* Show error if this page is called directly.
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=users">this instead</a>.</h3>';
- exit;
- }
-
-//------------|* Define filter.
-
- $filter = $ldap->build_filter_string();
-
-/*------------|* Initialize entry values. */
-
- $entries = $ldap->get_entries( $filter );
-
-/*------------|* Do Action if POST
- *
- * Description : Actions take place entry by entry. Just one
- * entry at the same time. Actually two actions are supported
- * (update,delete). */
-
- if ( isset( $_POST['useradmin'] ) )
- {
- // Define useradmin attributes.
- $fields = array('cn', 'userpassword', 'displayname', 'preferredlanguage', 'employeetype');
-
- // Recover action to do.
- $action = $_POST['action'];
-
- // Reinitialize entries values based on input and do action if present
- $message = $ldap->init_useradmin_values( $entries, $fields, $action );
-
-
- // Reload entry value to reflect changes immediately
- $entries = $ldap->get_entries( $filter );
- }
-
-//------------/* Display useradmin action results
-
- if ( isset( $message ) )
- {
- echo $message;
- }
-
-//------------/* Display useradmin title
-
- echo '<h1>' . ucfirst(translate(strtolower('admin'))) . ' ' . translate(strtolower('users')) . '</h1>';
-
-//------------/* Display useradmin form
-
-?>
-
-<form name="ldapusers" action="" method="post">
-
- <p><?php echo $ldap->show_useradmin_info( $entries ) ?></p>
-
- <hr/>
-
- <div class="action alignr">
-
- <?php echo show_action_field(); ?>
-
- <input type="submit" name="useradmin" value="<?php echo ucfirst(translate('accept'))?>" />
-
- </div>
-
- <table class="ldapusers">
-
- <tr>
-
- <th> </th>
-
- <th><?php echo ucfirst(translate('uid'))?></th>
-
- <th><?php echo ucfirst(translate('userpassword'))?></th>
-
- <th><?php echo ucfirst(translate('cn'))?></th>
-
- <th><?php echo ucfirst(translate('displayname'))?></th>
-
- <th><?php echo ucfirst(translate('preferredlanguage'))?></th>
-
- <th><?php echo ucfirst(translate('employeetype'))?></th>
-
-
- </tr>
-
-<?php for ($i=0; $i<$entries['count']; $i++) { ?>
- <tr>
- <td align="center"><input type="checkbox" name="uid[<?php echo $i ?>]" value="<?php echo $entries[$i]['uid'][0]; ?>" /></td>
- <td align="center"><?php echo $entries[$i]['uid'][0]; ?></td>
-
-
- <td align="center"><input type="password" name="userpassword[<?php echo $i ?>]" value="<?php echo $entries[$i]['userpassword'][0]; ?>" size="20" /></td>
-
- <td align="center"><input type="text" name="cn[<?php echo $i ?>]" value="<?php echo $entries[$i]['cn'][0]; ?>" size="20" /></td>
-
- <td align="center"><input type="text" name="displayname[<?php echo $i ?>]" value="<?php echo $entries[$i]['displayname'][0]; ?>" size="10" /></td>
-
- <td align="center" style="padding: 0.5em;">
- <?php echo get_user_langSelector($i,$entries[$i]['preferredlanguage'][0])?>
- </td>
-
- <td align="center" style="padding: 0.5em;">
- <?php echo get_user_roleSelector($i,$entries[$i]['employeetype'][0])?>
- </td>
-
- </tr>
- <?php } ?>
-
- </table>
-
- <div class="action alignr">
-
- <input type="submit" name="useradmin" value="<?php echo ucfirst(translate('accept'))?>" />
-
- </div>
-
-</form>
diff --git a/Scripts/CentOS-Web/admin/p_users_add.php b/Scripts/CentOS-Web/admin/p_users_add.php
deleted file mode 100644
index ff49658..0000000
--- a/Scripts/CentOS-Web/admin/p_users_add.php
+++ /dev/null
@@ -1,49 +0,0 @@
-<?php
-/***
- * Useradd page.
- *
- * This page sumarize the actions needed to add users into LDAP
- * directory server's database.
- *
- * --
- * 2009 (c) Alain Reguera Delgado <al@ciget.cienfuegos.cu>
- * Released under GPL lisence (http://www.fsf.org/licensing/licenses/gpl.txt)
- */
-
-//------------/* Show error if this page is called directly.
-
- if ( basename($_SERVER['PHP_SELF']) <> 'index.php')
- {
- echo '<h3>Sorry, this page can\'t be served directly. ';
- echo 'Try <a href="index.php?p=users&a=add">this instead</a>.</h3>';
- exit;
- }
-
-//------------/* Initialize entry values.
-
- $fields = array('uid', 'userpassword', 'cn', 'employeetype', 'preferredlanguage', 'displayname');
- $entry = $ldap->init_useradd_values( $fields );
-
-//------------/* Do Action if POST
-
- if ( isset( $_POST['useradd'] ) )
- {
- $message = $ldap->do_action( $entry, 'add' );
- }
-
-//------------/* Display useradd action results
-
- if ( isset($message) )
- {
- echo $message;
- }
-
-//------------/* Display useradd title
-
- echo '<h1>' . ucfirst(translate('add')) . ' ' . translate('user') . '</h1>';
-
-//------------/* Display useradd form
-
- echo show_useradd_form( $entry );
-
-?>
diff --git a/Scripts/CentOS-Web/admin/style.css b/Scripts/CentOS-Web/admin/style.css
deleted file mode 100644
index a99e426..0000000
--- a/Scripts/CentOS-Web/admin/style.css
+++ /dev/null
@@ -1,662 +0,0 @@
-/***
- * Style used in some server responses.
- *
- * -- CentOS Artwork SIG.
- * http://projects.centos.org/trac/artwork/wiki/WebServerCustomization
- */
-
-html {
- background-color: #FFF;
- background-image: url(img/html-background.png);
- font-family: "DejaVu Sans", "Liberation Sans", sans-serif;
- font-size: 0.85em;
- line-height: 1.25em;
- margin: 0 4% 0 4%; /* <- with 4% of left and right margin */
- }
-
-body {
- background: #FFF;
- border-width: 10px;
- border-style: solid;
- border-color: #FFF;
- padding:0;
- margin: 0;
- }
-
-/* RSS */
-
-#header .rss {
- float:right;
- padding: 0;
- margin: 0;
- margin-right: 1em;
- border: none;
-}
-
-/* Links */
-
-a:link { text-decoration: none; color: #204C8D }
-a:hover { text-decoration: underline; color: green; }
-a:active { text-decoration: underline; color: green; }
-a:visited { text-decoration: none; color: #204C8D; }
-a:visited:hover { text-decoration: underline; color: green; }
-
-#footer .credits a:link { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee }
-#footer .credits a:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-#footer .credits a:active { border-bottom: 1px dotted #eee; text-decoration: underline; color: #eee; }
-#footer .credits a:visited { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee; }
-#footer .credits a:visited:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-
-#header .adminlinks a:link { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee }
-#header .adminlinks a:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-#header .adminlinks a:active { border-bottom: 1px dotted #eee; text-decoration: underline; color: #eee; }
-#header .adminlinks a:visited { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee; }
-#header .adminlinks a:visited:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-
-/* Alignment */
-
-.floatr { float: right; }
-.floatl { float: left; }
-.alignr { text-align: right; }
-.alignl { text-align: left; }
-.alignc { text-align: center; }
-
-/* Lists */
-
-#content ul,
-#content ol {
- padding-left: 1.9em;
- margin-left: 3em;
- margin-bottom: 1em;
- }
-
-#content ul {
- list-style: url("img/ul.png") circle;
- }
-
-#content ol {
- list-style-image: none !important;
- }
-
-#content ul li {
- padding-left: 0em;
- margin-bottom: 0.3em;
- }
-
-#content ol li {
- padding-left: 0em;
- margin-bottom: 0.3em;
- }
-
-#content ul ul,
-#content ul ol,
-#content ol ul,
-#content ol ol {
- margin-left: 0.5em;
- margin-top: 0.3em;
- }
-
-#content ul li p,
-#content ol li p {
- margin-bottom: 0.3em;
- line-height: 1.5em;
- margin-left: 0 !important;
- }
-
-/* Tables */
-
-#content table {
- margin: 0;
- margin-top: 0.5em;
- margin-bottom: 0.5em;
- border-collapse: collapse;
- clear: both;
- border-width: 1px;
- border-style: solid;
- border-color: #EDEDED;
- width: 100%;
- }
-
-#content th {
- background: #f8f8f8;
- padding: 0.5em;
- border-width: 1px;
- border-style: solid;
- border-color: #CCC;
- }
-
-#content th.firstcol {
- width: 1%;
-}
-
-#content td {
- border-width: 1px;
- border-style: solid;
- border-color: #CCC;
- padding: 0.5em;
- }
-
-
-/* Presentation */
-
-#header {
- background-color: #204C8D;
- background-image: url(img/header-background.png);
- color: #fff;
- }
-
-#header div.people_info {
- float: right;
- padding: 0.3em 10% 1.2em 1.2em;
- padding-right: 10%;
- text-align: center;
- }
-
-#header .adminlinks {
- float:right;
- margin: 0.5em;
- text-align: right;
- font-size: 0.8em;
- color: #eee;
-}
-
-#logo {
- color: #fff;
- padding: 10px;
- width: 500px;
- }
-
-#logo img {
- border: none;
-}
-
-#logo .logo_text{
- font-size: 1.7em;
- color: #fff;
- margin-top: -50px;
- float:left;
- margin-left: 260px;
- text-align:left;
-}
-
-/* Ads */
-
-.googlecontent {
- clear: right;
- margin: 0;
-}
-
-/* Page lines */
-
-.pageline_dark {
- border: 1px solid #31629b;
- clear: both;
- margin:0;
- padding:0;
-}
-
-.pageline {
- border-bottom:2px solid #cad9ee;
- clear: both;
- margin:0;
- padding:0;
-}
-
-.pageline_soft {
- border: 1px solid #fff;
- clear: both;
- margin:0;
- padding:0;
-}
-
-/* Mainlinks */
-
-.mainlinks {
- display: block;
- padding: 0;
- padding-left: 20px;
- margin: 0;
- font-size: 0.8em;
- background-color: #2b4f80;
- height: 23px;
- border-bottom: 2px solid #6fa4df;
- }
-
-.mainlinks li {
- float: left;
- display: inline;
- white-space: nowrap;
- font-weight: bold;
- padding:0;
- padding-top:3px;
- padding-bottom:3px;
- }
-
-.mainlinks li a {
- /* To cover the box area as linkable */
- padding: 10px;
- padding-top: 4px;
- padding-bottom: 4px;
- border-right: 1px solid #25456f;
- border-left: 1px solid #31629b;
- }
-
-.mainlinks a,
-.mainlinks a:visited {
- color: #BDD3FB;
- text-decoration: none;
- }
-
-.mainlinks li.current a {
- color: #25456f;
- border-right: 1px solid #fff;
- border-left: 1px solid #fff;
- text-decoration: none;
- }
-
-.mainlinks li:hover {
- background-color: #436595;
- padding-bottom: 3px;
- }
-
-.mainlinks li:hover a {
- color: #BDD3FB;
- text-decoration: none;
- }
-
-.mainlinks li:hover a:active { color:#BDD3FB; background-color:#436595; text-decoration:none;}
-.mainlinks li a:active { color:#BDD3FB; background-color:#436595; text-decoration:none;}
-
-.mainlinks li.current,
-.mainlinks li.current:hover,
-.mainlinks li.current:hover a,
-.mainlinks li.current:active a {
- color: #25456f;
- background: #f6f9ff;
- padding-bottom: 5px;
- }
-
-/* Sublinks */
-
-.sublinks {
- display: block;
- margin:0;
- padding: 0.8em;
- white-space: nowrap;
- background: #f6f9ff;
- border-bottom:2px solid #cad9ee;
- color: #000;
- }
-.sublinks ul {
- margin: 0;
- padding: 0;
-}
-.sublinks li {
- display: inline;
- border-right: 1px dotted #6fa4df;
- padding-left:0.8em;
- padding-right:0.8em;
- }
-
-.sublinks li:last-child {
- border-right: none;
-}
-
-/* Entries pager */
-
-#content .entrypager {
- border-top: 1px solid #f8f8f8;
- padding-top: 10px;
- clear: both;
-}
-
-#content .entrypager span {
- display: inline;
- font-size: 0.9em;
-}
-
-/* Content */
-
-#content .columnl {
- display: block;
- background-color: #fff;
- margin: 0;
- padding-right: 20px;
- padding-left: 20px;
- padding-bottom: 2em;
- }
-
-#content .columnr div.center { text-align: center; }
-
-#content .columnr div.last {
- border-top: 1px solid #fff;
- border-bottom: none;
-}
-
-#content .columnr p.first {
- border-top: none;
-}
-
-#content h1 {
- color: #333;
- line-height: 1em;
- margin: 0px;
- margin-bottom: 1em;
- margin-top: 1em;
- padding: 0px;
-}
-
-#content h2,
-#content h3,
-#content h4,
-#content h5,
-#content h6 {
- color: #333;
- line-height: 0.7em;
- margin: 0px;
- margin-bottom: 1em;
- padding: 0px;
- }
-
-#content tt {
- font-family: "DejaVu Sans Mono", "Liberation Sans Mono", monospace;
-}
-
-#content {
- clear:both;
- padding-left:0px;
- padding-right:0px;
-}
-
-#content p {
- color: #333;
- line-height: 1.5em;
- margin: 0;
- padding: 0;
- margin-bottom: 1em;
- margin-top: 1em;
-}
-
-#content pre {
- font-size: 1.4em;
- border-width: 1px;
- border-style: solid;
- border-color: #E5E5E5;
- border-left-width: 4px;
- white-space: pre;
- background: #FFFAE9;
- overflow: auto;
- padding: 1em;
-}
-
-#content hr {
- margin-top: 1em;
- margin-bottom: 1em;
- padding: 0;
- border: 1px solid #f8f8f8;
- }
-
-.promoblock {
- display: block;
- float:left;
- padding: 0;
- padding-left: 1em;
- padding-right: 0.5em;
- margin-top: 0.5em;
- margin-bottom: 0.5em;
- border-left: 2px dotted #cad9ee;
- height: 200px;
- font-size: 0.8em;
-}
-
-.promoblock p {
- padding: 0em;
- line-height: 1.5em;
- margin: 0em;
- margin-bottom: 1em;
-}
-
-.promoblock.col1,
-.promoblock.col2,
-.promoblock.col3 { width: 20%;}
-.promoblock.col4 { width: 30%; }
-
-.promoblock.first { border-left: none;}
-
-#content div.post p.info {
- font-size: 0.8em;
- margin-top: -1em !important;
-}
-
-#content div.post.first p.info {
- margin-top: -2em !important;
-}
-
-#content .post {
- margin-top: 1em;
- padding-top: 1em;
-}
-
-#content .post.first {
- border-bottom: 1px solid #f8f8f8;
-}
-
-
-#content .post.first h2 {
- font-size: 2em;
-}
-
-/* Content - Forms */
-
-#content form {
- margin: 0;
- padding: 0;
- display: inline;
-}
-
-div.formfields {
- border-top: 1px solid #f8f8f8;
- border-bottom: 1px solid #f8f8f8;
-}
-
-div.formfields ul {
- margin-left: 0px !important;
- padding-left: 0px !important;
-}
-
-div.formfields li {
-
- list-style: none;
-}
-
-div.formfields li.description {
- font-weight: bold;
- text-align: right;
- width: 180px;
- padding-top: 5px;
-}
-
-div.formfields li.value {
- margin-left: 190px;
- margin-top: -25px;
-}
-
-div.formfields li.submit {
- margin-top: 25px;
- margin-left: 190px;
-}
-
-#header input[type="submit"],
-#header input[type="text"] {
- border-width: 2px;
- border-style: solid;
- border-color: #204C8D;
- background-color: #3B71B8;
- color: #FFFFFF;
- display: inline;
- text-decoration: none;
- padding: 1px;
- padding-left: 4px;
- padding-right: 4px;
- }
-
-#header input[type="submit"] {
- font-weight: bold;
- cursor: pointer;
- font-size: 0.8em;
-}
-
-#header input[type="text"] {
- font-size: 0.85em;
- display: inline;
- padding: 2px;
- padding-left: 4px;
- border: 2px solid #204C8D;
- background-color: #EDF4FF;
- color: #204C8D;
- width: 130px;
-}
-#header select {
- font-size: 0.8em;
- border-width: 2px;
- border-style: solid;
- border-color: #204C8D;
- background-color: #3B71B8;
- color: #FFFFFF;
- cursor: pointer;
- display: inline;
- font-weight: bold;
- text-decoration: none;
- padding: 1px;
- }
-
-.input {
- /* does strange effect to button (text size becomes bigger when clicking)
- font-size: 1em;
- font-family: Arial, Lucida Grande, sans-serif;
- */
- }
-
-textarea {
- font-size: 1em;
- font-family: "DejaVu Sans Mono", "Liberation Mono", monospace;
- }
-
-.disabled {
- color: gray;
- }
-
-/* Admonitions */
-
-.lm {
- background-color: #ECECEC;
- background-image: url("img/moin-msg-bg-gray.png");
- width: -10px;
- border-width: 1px;
- border-style: solid;
- border-color: #CFCFCF;
- border-left-width: 4px;
- padding: 1em !important;
- }
-
-.lm.red {
- border-color: #E0B7B7;
- background-color: #FFECEC;
- background-image: url("img/moin-msg-bg-red.png");
- }
-
-.lm.green {
- border-color: #D6F6D2;
- background-color: #EEFFEC;
- background-image: url("img/moin-msg-bg-green.png");
- }
-
-.lm.violet {
- border-color: #F6D2F6;
- background-color: #FFECFF;
- background-image: url("img/moin-msg-bg-violet.png");
- }
-
-.lm.blue {
- border-color: #D2E0F6;
- background-color: #ECF4FF;
- background-image: url("img/moin-msg-bg-blue.png");
- }
-
-.lm.orange {
- border-color: #F6E7D2;
- background-color: #FFF8EC;
- background-image: url("img/moin-msg-bg-orange.png");
- }
-
-.message {
- margin-top: 2em;
- margin-right: 20%;
- margin-bottom: 2em;
- margin-left: 20%;
- padding-top: 1em;
- padding-right: 1em;
- padding-bottom: 1em;
- padding-left: 1.5em;
- border-width: 0;
- border-top-width: 4px;
- border-top-style: solid;
- border-bottom-width: 4px;
- border-bottom-style: solid;
- text-align: center;
- font-weight: bold;
- }
-
-.message pre {
- font-weight: normal !important;
- text-align: left !important;
- font-size: 1em !important;
-
-}
-/* Footer */
-
-#footer {
- background-color: #204C8D;
- background-image: url(img/header-background.png);
- margin-top: 1em;
- clear:both;
- }
-
-#footer p {
- font-size: small;
- margin: 5px;
- }
-
-#footer .mainlinks {
- border-bottom: none;
- height: 23px;
- }
-
-#footer .mainlinks li {
- padding-top: 4px;
- padding-bottom: 2px;
-}
-
-#footer .mainlinks li.current {
- margin-top: -3px;
- padding-bottom: 3px;
- padding-top: 6px;
-}
-
-
-#footer .sublinks {
- border-top:2px solid #cad9ee;
- border-bottom-color: #6FA4DF;
- }
-
-#footer .credits {
- color: #eee;
- font-size: small;
- padding: 1em;
- }
-
-#footer .credits p.right {
- float: right;
- padding-left: 15em;
- text-align: right;
-}
diff --git a/Scripts/CentOS-Web/config.php b/Scripts/CentOS-Web/config.php
deleted file mode 100755
index 583ec83..0000000
--- a/Scripts/CentOS-Web/config.php
+++ /dev/null
@@ -1,59 +0,0 @@
-<?php
-/***
- * CentOS-News configuration files.
- *
- */
-
- /* HTTP */
- define('BASEURL', 'http://localhost/~al/cnus/trunk/');
-
- /* HTML */
- define('HTML_TITLE', 'CentOS Español');
-
- /* LANGUAGE */
- define('LANGUAGE', 'es');
-
- /* LDAP */
- define('LDAP_HOST', 'localhost');
- define('LDAP_PORT', '389');
- define('LDAP_DN', 'ou=people,dc=example,dc=com');
- define('LDAP_ROOTDN', 'cn=manager,dc=example,dc=com');
- define('LDAP_ROOTPW', 'ldap.Example28.InLife');
- define('LDAP_PASSHASH', '{MD5}'); // Ex. {MD5}, {SHA}
- define('LDAP_FILTER_ATT', 'preferredlanguage');
- define('LDAP_FILTER_TYPE', '=');
- define('LDAP_FILTER_VALUE', LANGUAGE);
-
- /* DATABASE
-
- In order to this configuration to take effect, you need to commit the
- following steps:
-
- 1. Get into PostgreSQL as superuser and create a database to store the
- tables used by this application.
-
- 2. Build database from predifined SQL commands.
-
- 3. Create the user you'll use to connect to PostgreSQL.
- (Ex. createuser -P -d cnus )
-
- 4. Add, to the created user, access to authenticate in the PostgreSQL
- host base authentication file (var/lib/pgsql/pg_hba.conf).
-
- For example:
-
- # TYPE DATABASE USER CIDR-ADDRESS METHOD
- local cnus cnus md5
-
- 5. Reload PostgreSQL service (Ex. service postgresql reload)
-
- */
- define('DB_USERNAME', 'cnus'); // Username
- define('DB_PASSWORD', 'www.Cnus'); // Password
- define('DB_DBNAME', 'cnus'); // Database name
-
-
-//--- stop editing here!
-
-define('ABSPATH', dirname(__FILE__) . '/');
-?>
diff --git a/Scripts/CentOS-Web/contents/content.php b/Scripts/CentOS-Web/contents/content.php
deleted file mode 100644
index 3032b7c..0000000
--- a/Scripts/CentOS-Web/contents/content.php
+++ /dev/null
@@ -1,43 +0,0 @@
-<div id="content">
-
- <?php echo get_html_sidebar(); ?>
-
- <div class="columnl">
-
- <hr />
-
-<?php
-/***
- * Content Template
- */
-
-// Get page content
-// NOTE: For testing purposes I'll use an array. This should
-// be replaced by database entries.
-$page = array();
-
-$page[1] = '<h1>Donaciones</h1><p>Esta es la pagina de las donaciones</p>';
-$page[2] = '<h1>Documentacion</h1><p>Esta es la pagina de la documentacion.</p>';
-$page[3] = '<h1>Wiki</h1><p>Esta es la pagina de la wiki.</p>';
-$page[4] = '<h1>Foros</h1>Esta es la pagina de los foros.</p>';
-
-// Initialize variables
-if ( isset($_GET['p']) ) {
-
- // If $_GET['p'] is set the content shown is the pages one.
- $id = htmlspecialchars($_GET['p']);
-
- echo $page[$id];
-}
-else
-{
- // If $_GET['p'] is not set the content shown is the entries's loop.
- echo get_html_err();
-}
-
-// Validate id value
-
-?>
-
-</div>
-</div>
diff --git a/Scripts/CentOS-Web/contents/footer.php b/Scripts/CentOS-Web/contents/footer.php
deleted file mode 100644
index b902f6e..0000000
--- a/Scripts/CentOS-Web/contents/footer.php
+++ /dev/null
@@ -1,20 +0,0 @@
-<?php echo get_html_promo(); ?>
-
-<div id="footer">
-
-<?php echo get_html_mainlinks(); ?>
-
-<div class="pageline_dark"> </div>
-
- <div class="credits">
-
- <p class="right"></p>
-
- <p><?php echo ucfirst(translate('credits_on_footer_1')); ?></p>
-
- </div>
-
-</div>
-
-</body>
-</html>
diff --git a/Scripts/CentOS-Web/contents/header.php b/Scripts/CentOS-Web/contents/header.php
deleted file mode 100644
index 1a1aa72..0000000
--- a/Scripts/CentOS-Web/contents/header.php
+++ /dev/null
@@ -1,32 +0,0 @@
-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
-<html>
-
-<head>
- <meta http-equiv="Content-Type" content="text/html;charset=utf-8">
- <title><?php echo HTML_TITLE ?></title>
- <link rel="stylesheet" type="text/css" charset="utf-8" media="all" href="contents/style.css">
-</head>
-
-<body>
-<div id="header">
-
- <div class="adminlinks">
-<!--
- <div class="googlecontent">
- <img src="http://localhost/googleads.png" alt="">
- </div>
--->
- <?php echo get_html_searchform(); ?>
- </div>
- <div id="logo">
- <a href="">
- <img src="contents/images/logo.png" alt="">
- <span class="logo_text"><?php echo ucfirst(translate( LANGUAGE ))?></span>
- </a>
- </div>
-
- <div class="pageline_dark"> </div>
- <a href=""><img class="rss" src="contents/images/rss.png" alt="rss"></a>
- <?php echo get_html_mainlinks(); ?>
- </div>
-
diff --git a/Scripts/CentOS-Web/contents/images/h1-background.png b/Scripts/CentOS-Web/contents/images/h1-background.png
deleted file mode 100755
index 966b7ed..0000000
Binary files a/Scripts/CentOS-Web/contents/images/h1-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/h2-background.png b/Scripts/CentOS-Web/contents/images/h2-background.png
deleted file mode 100755
index 7966dc0..0000000
Binary files a/Scripts/CentOS-Web/contents/images/h2-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/header-background.png b/Scripts/CentOS-Web/contents/images/header-background.png
deleted file mode 100755
index ff2a7b0..0000000
Binary files a/Scripts/CentOS-Web/contents/images/header-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/html-background.png b/Scripts/CentOS-Web/contents/images/html-background.png
deleted file mode 100755
index 30f7d70..0000000
Binary files a/Scripts/CentOS-Web/contents/images/html-background.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/layeredTech_logo08.gif b/Scripts/CentOS-Web/contents/images/layeredTech_logo08.gif
deleted file mode 100755
index c31ec0b..0000000
Binary files a/Scripts/CentOS-Web/contents/images/layeredTech_logo08.gif and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/logo.png b/Scripts/CentOS-Web/contents/images/logo.png
deleted file mode 100644
index 4828ae2..0000000
Binary files a/Scripts/CentOS-Web/contents/images/logo.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/release-promo.png b/Scripts/CentOS-Web/contents/images/release-promo.png
deleted file mode 100644
index a4221c7..0000000
Binary files a/Scripts/CentOS-Web/contents/images/release-promo.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/rss.png b/Scripts/CentOS-Web/contents/images/rss.png
deleted file mode 100644
index 79767ef..0000000
Binary files a/Scripts/CentOS-Web/contents/images/rss.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/ul.png b/Scripts/CentOS-Web/contents/images/ul.png
deleted file mode 100755
index fd89ccd..0000000
Binary files a/Scripts/CentOS-Web/contents/images/ul.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/ul2.png b/Scripts/CentOS-Web/contents/images/ul2.png
deleted file mode 100644
index 467b107..0000000
Binary files a/Scripts/CentOS-Web/contents/images/ul2.png and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/images/xpressbannew_240.gif b/Scripts/CentOS-Web/contents/images/xpressbannew_240.gif
deleted file mode 100644
index dfdf197..0000000
Binary files a/Scripts/CentOS-Web/contents/images/xpressbannew_240.gif and /dev/null differ
diff --git a/Scripts/CentOS-Web/contents/sidebar.php b/Scripts/CentOS-Web/contents/sidebar.php
deleted file mode 100644
index 11e3b77..0000000
--- a/Scripts/CentOS-Web/contents/sidebar.php
+++ /dev/null
@@ -1,35 +0,0 @@
-<div class="columnr">
-
- <div class="row_promo first center"><a href=""><img src="contents/images/release-promo.png" alt="promo"></a></div>
-
- <div class="row">
-
- <h4><?php echo strtoupper(translate('categories'))?></h4>
- <?php echo get_category_tree() ?>
- </div>
-
- <div class="row">
- <h4><?php echo strtoupper(translate('archive'))?></h4>
- <ul>
- <li><a href="">2009</a></li>
- <li><a href="">2008</a></li>
- <li><a href="">2007</a></li>
- </ul>
- </div>
-
- <div class="row">
- <h4><?php echo strtoupper(translate('links'))?></h4>
- <ul>
- <li><a href="">...</a></li>
- <li><a href="">...</a></li>
- <li><a href="">...</a></li>
- </ul>
- </div>
-
- <div class="row">
- <?php echo get_auth_userlinks(); ?>
- </div>
-
- <div class="last"></div>
-
-</div>
diff --git a/Scripts/CentOS-Web/contents/single.php b/Scripts/CentOS-Web/contents/single.php
deleted file mode 100644
index bebb7e4..0000000
--- a/Scripts/CentOS-Web/contents/single.php
+++ /dev/null
@@ -1,43 +0,0 @@
-<div id="content">
-
-<?php
-/***
- * Content Template
- */
-
-
-// Initialize variables
-if ( isset($_GET['p']) ) {
-
- $id = $_GET['p'];
- $file = "pages/p_$id.php";
-
- // Check file
- if (file_exists($file))
- {
- if (is_readable($file))
- {
- include($file);
- }
- else {
- echo "<p>The page $id isn't readable!</p>";
- }
-
- }
- else {
- echo "<p>The page $id doesn't exist!</p>";
- }
-
-}
-else {
-
- $id = 0;
- include("pages/p_index.php");
-
-}
-
-// Validate id value
-
-?>
-
-</div>
diff --git a/Scripts/CentOS-Web/contents/style.css b/Scripts/CentOS-Web/contents/style.css
deleted file mode 100644
index 58888cd..0000000
--- a/Scripts/CentOS-Web/contents/style.css
+++ /dev/null
@@ -1,554 +0,0 @@
-/***
- * Style used in some server responses.
- *
- * -- CentOS Artwork SIG.
- * http://projects.centos.org/trac/artwork/wiki/WebServerCustomization
- */
-
-html {
- background-color: #FFF;
- background-image: url(images/html-background.png);
- font-family: "DejaVu Sans", "Liberation Sans", sans-serif;
- font-size: 0.85em;
- line-height: 1.25em;
- margin: 0 4% 0 4%; /* <- with 4% of left and right margin */
- }
-
-body {
- background: #FFF;
- border-width: 10px;
- border-style: solid;
- border-color: #FFF;
- padding:0;
- margin: 0;
- }
-
-/* RSS */
-
-#header .rss {
- float:right;
- padding: 0;
- margin: 0;
- margin-right: 1em;
- border: none;
-}
-
-/* Links */
-
-a:link { text-decoration: none; color: #204C8D }
-a:hover { text-decoration: underline; color: green; }
-a:active { text-decoration: underline; color: green; }
-a:visited { text-decoration: none; color: #204C8D; }
-a:visited:hover { text-decoration: underline; color: green; }
-
-#footer .credits a:link { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee }
-#footer .credits a:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-#footer .credits a:active { border-bottom: 1px dotted #eee; text-decoration: underline; color: #eee; }
-#footer .credits a:visited { border-bottom: 1px dotted #eee; text-decoration: none; color: #eee; }
-#footer .credits a:visited:hover { border-bottom: 1px dotted #eee; text-decoration: underline; color: #fff; }
-
-/* Alignment */
-
-.floatr { float: right; }
-.floatl { float: left; }
-
-/* Lists */
-
-#content ul,
-#content ol {
- padding-left: 1.9em;
- margin-left: 3em;
- margin-bottom: 1em;
- }
-
-#content ul {
- list-style: url("images/ul.png") circle;
- }
-
-#content ol {
- list-style-image: none !important;
- }
-
-#content ul li {
- padding-left: 0em;
- margin-bottom: 0.3em;
- }
-
-#content ol li {
- padding-left: 0em;
- margin-bottom: 0.3em;
- }
-
-#content ul ul,
-#content ul ol,
-#content ol ul,
-#content ol ol {
- margin-left: 0.5em;
- margin-top: 0.3em;
- }
-
-#content ul li p,
-#content ol li p {
- margin-bottom: 0.3em;
- line-height: 1.5em;
- margin-left: 0 !important;
- }
-
-/* Tables */
-
-#content table {
- width: 100%;
- font-size: inherit;
- }
-
-#content th {
- padding-left: 5px;
- padding-right: 5px;
- }
-
-#content th {
- background-image: url(images/h2-background.png);
- }
-
-/* Presentation */
-
-#header {
- background-color: #204C8D;
- background-image: url(images/header-background.png);
- color: #fff;
- }
-
-#header div.people_info {
- float: right;
- padding: 0.3em 10% 1.2em 1.2em;
- padding-right: 10%;
- text-align: center;
- }
-
-#header .adminlinks {
- float:right;
- margin: 0.5em;
- text-align: right;
- font-size: 0.9em;
- color: #eee;
-}
-
-#header .adminlinks a {
- margin-left: 0.5em;
- margin-right: 0.5em;
-}
-
-#logo {
- color: #fff;
- padding: 10px;
- width: 500px;
- }
-
-#logo img {
- border: none;
-}
-
-#logo .logo_text{
- font-size: 1.7em;
- color: #fff;
- margin-top: -50px;
- float:left;
- margin-left: 260px;
- text-align:left;
-}
-
-/* Ads */
-
-.googlecontent {
- clear: right;
- margin: 0;
-}
-
-/* Page lines */
-
-.pageline_dark {
- border: 1px solid #31629b;
- clear: both;
- margin:0;
- padding:0;
-}
-
-.pageline {
- border-bottom:2px solid #cad9ee;
- clear: both;
- margin:0;
- padding:0;
-}
-
-.pageline_soft {
- border: 1px solid #fff;
- clear: both;
- margin:0;
- padding:0;
-}
-
-/* Mainlinks */
-
-.mainlinks {
- display: block;
- padding: 0;
- padding-left: 20px;
- margin: 0;
- font-size: 0.8em;
- background-color: #2b4f80;
- height: 23px;
- border-bottom: 2px solid #6fa4df;
- }
-
-.mainlinks li {
- float: left;
- display: inline;
- white-space: nowrap;
- font-weight: bold;
- padding:0;
- padding-top:3px;
- padding-bottom:3px;
- }
-
-.mainlinks li a {
- /* To cover the box area as linkable */
- padding: 10px;
- padding-top: 4px;
- padding-bottom: 4px;
- border-right: 1px solid #25456f;
- border-left: 1px solid #31629b;
- }
-
-.mainlinks a,
-.mainlinks a:visited {
- color: #BDD3FB;
- text-decoration: none;
- }
-
-.mainlinks li.current a {
- color: #25456f;
- border-right: 1px solid #fff;
- border-left: 1px solid #fff;
- text-decoration: none;
- }
-
-.mainlinks li:hover {
- background-color: #436595;
- padding-bottom: 3px;
- }
-
-.mainlinks li:hover a {
- color: #BDD3FB;
- text-decoration: none;
- }
-
-.mainlinks li:hover a:active { color:#BDD3FB; background-color:#436595; text-decoration:none;}
-.mainlinks li a:active { color:#BDD3FB; background-color:#436595; text-decoration:none;}
-
-.mainlinks li.current,
-.mainlinks li.current:hover,
-.mainlinks li.current:hover a,
-.mainlinks li.current:active a {
- color: #25456f;
- background-color: #fff;
- padding-bottom: 5px;
- }
-
-/* Entries pager */
-
-#content .entrypager {
- border-top: 1px solid #f8f8f8;
- clear: both;
-}
-
-#content .entrypager span {
- display: inline;
- font-size: 0.9em;
- padding: 1em;
-}
-
-/* Content */
-
-#content .columnl {
- display: block;
- background-color: #fff;
- margin: 0;
- margin-right: 300px;
- padding: 20px;
- }
-
-#content .columnr {
- display: block;
- width: 300px;
- float:right;
- background: #f6f9ff;
- border: 1px solid #a0bbe1;
- margin-bottom: 1em;
- }
-
-#content .columnr div {
- margin: 0;
- padding: 1em;
- font-size: 0.9em;
- }
-
-#content .columnr a {
- font-weight: bold;
-}
-
-#content .columnr div.row,
-#content .columnr div.row_search,
-#content .columnr div.row_download,
-#content .columnr div.row_promo,
-#content .columnr div.row_release,
-#content .columnr div.row_user,
-#content .columnr div.row_sponsor,
-#content .columnr div.row_subscribe {
- border-top: 1px solid #fff;
- border-bottom: 1px solid #cad9ee;
-}
-
-#content .columnr div ul {
- margin: 0;
- list-style: url("images/ul2.png") circle;
-}
-
-#content .columnr div.row_promo img {
- padding: 5px;
- background: #fff;
- border: 1px solid #a0bbe1;
-}
-
-#content .columnr div.center { text-align: center; }
-
-#content .columnr div.last {
- border-top: 1px solid #fff;
- border-bottom: none;
-}
-
-#content .columnr p.first {
- border-top: none;
-}
-
-#content h1 {
- color: #333;
- line-height: 1em;
- margin: 0px;
- margin-bottom: 1em;
- padding: 0px;
-}
-
-#content h2,
-#content h3,
-#content h4,
-#content h5,
-#content h6 {
- color: #333;
- line-height: 0.7em;
- margin: 0px;
- margin-bottom: 1em;
- padding: 0px;
- }
-
-#content tt {
- font-family: "DejaVu Sans Mono", "Liberation Sans Mono", monospace;
-}
-
-#content {
- clear:both;
- padding: 1em;
- background: #fff;
-}
-
-#content p {
- color: #333;
- line-height: 1.5em;
- margin: 0;
- padding: 0;
- margin-bottom: 1em;
- margin-top: 1em;
-}
-
-#content pre {
- font-size: 1.4em;
- border-width: 1px;
- border-style: solid;
- border-color: #E5E5E5;
- border-left-width: 4px;
- white-space: pre;
- background: #FFFAE9;
- overflow: auto;
- padding: 1em;
-}
-
-#content hr {
- margin-top: 1em;
- margin-bottom: 1em;
- padding: 0;
- border: 1px solid #f8f8f8;
- }
-
-.promoblock {
- display: block;
- float:left;
- padding: 0;
- padding-left: 1em;
- padding-right: 0.5em;
- margin-top: 0.5em;
- margin-bottom: 0.5em;
- border-left: 2px dotted #cad9ee;
- height: 150px;
- font-size: 0.8em;
- width: 20%;
-}
-
-.promoblock p {
- padding: 0em;
- line-height: 1.5em;
- margin: 0em;
- margin-bottom: 1em;
-}
-
-.promoblock.last { width: 30%; }
-
-.promoblock.first { border-left: none;}
-
-#content div.post p.info {
- font-size: 0.8em;
- margin-top: -1em !important;
-}
-
-#content div.post.first p.info {
- margin-top: -2em !important;
-}
-
-#content .post {
- margin-top: 1em;
- padding-top: 1em;
-}
-
-#content .post.first {
- border-bottom: 1px solid #f8f8f8;
-}
-
-
-#content .post.first h2 {
- font-size: 2em;
-}
-
-/* Content - Forms */
-
-form {
- margin: 0;
- padding: 0;
- display: inline;
-}
-
-#header input[type="submit"],
-#header input[type="text"] {
- border-width: 2px;
- border-style: solid;
- border-color: #204C8D;
- background-color: #3B71B8;
- color: #FFFFFF;
- display: inline;
- text-decoration: none;
- padding: 1px;
- padding-left: 4px;
- padding-right: 4px;
- }
-
-#header input[type="submit"] {
- font-weight: bold;
- cursor: pointer;
- font-size: 0.8em;
-}
-
-#header input[type="text"] {
- font-size: 0.85em;
- margin-right: 2px;
- display: inline;
- padding: 2px;
- padding-left: 4px;
- border: 2px solid #204C8D;
- background-color: #EDF4FF;
- color: #204C8D;
- width: 130px;
-}
-#header select {
- font-size: 0.8em;
- border-width: 2px;
- border-style: solid;
- border-color: #204C8D;
- background-color: #3B71B8;
- color: #FFFFFF;
- cursor: pointer;
- display: inline;
- font-weight: bold;
- text-decoration: none;
- padding: 1px;
- }
-
-.input {
- /* does strange effect to button (text size becomes bigger when clicking)
- font-size: 1em;
- font-family: Arial, Lucida Grande, sans-serif;
- */
- }
-
-textarea {
- font-size: 1.4em;
- font-family: "DejaVu Sans Mono", "Liberation Mono", monospace;
- }
-
-.disabled {
- color: gray;
- }
-
-/* Footer */
-
-#footer {
- background-color: #204C8D;
- background-image: url(images/header-background.png);
- margin-top: 1em;
- clear:both;
- }
-
-#footer p {
- font-size: small;
- margin: 5px;
- }
-
-#footer .mainlinks {
- border-top: 2px solid #6fa4df;
- border-bottom: none;
- height: 23px;
- }
-
-#footer .mainlinks li {
- padding-bottom: 3px;
-}
-
-#footer .mainlinks li.current {
- margin-top: -3px;
- padding-bottom: 3px;
- padding-top: 6px;
-}
-
-
-#footer .sublinks {
- border-top:2px solid #cad9ee;
- border-bottom: none;
- }
-
-#footer .credits {
- color: #eee;
- font-size: small;
- padding: 1em;
- }
-
-#footer .credits p.right {
- float: right;
- padding-left: 15em;
- text-align: right;
-}
diff --git a/Scripts/CentOS-Web/includes/functions/html.php b/Scripts/CentOS-Web/includes/functions/html.php
deleted file mode 100644
index fe7cc4a..0000000
--- a/Scripts/CentOS-Web/includes/functions/html.php
+++ /dev/null
@@ -1,132 +0,0 @@
-<?php
-
-/*
- * HTML Functions
- *
- */
-
-// Display header template
-function get_html_header()
-{
- require_once(ABSPATH . 'contents/header.php');
-}
-// Display content template
-function get_html_content()
-{
- require_once(ABSPATH . 'contents/content.php');
-}
-// Display sidebar template
-function get_html_sidebar()
-{
- require_once(ABSPATH . 'contents/sidebar.php');
-}
-// Display footer template
-function get_html_footer()
-{
- require_once(ABSPATH . 'contents/footer.php');
-}
-
-// Display Mainlinks (to Pages)
-function get_html_mainlinks()
-{
-
- $mainlinks = array ();
- $mainlinks[1] = 'donaciones';
- $mainlinks[2] = 'documentacion';
- $mainlinks[3] = 'wiki';
- $mainlinks[4] = 'foros';
-
- $html = '<ul class="mainlinks">' . "\n";
-
- if (!isset($_GET['p']))
- {
-
- $html .= '<li class="current"><a href="index.php">' . strtoupper(translate('home')) . '</a></li>' . "\n";
-
- }
- else
- {
- $html .= '<li><a href="index.php">' . strtoupper(translate('home')) . '</a></li>' . "\n";
- }
-
- foreach ($mainlinks as $key => $value)
- {
- if (isset($_GET['p']) && $_GET['p'] == $key)
- {
- $html .= '<li class="current"><a href="?p='.$key.'">' . strtoupper($value). "</a></li>" . "\n";
- }
- else
- {
- $html .= '<li><a href="?p='.$key.'">' . strtoupper($value). "</a></li>" . "\n";
- }
- }
-
-$html .= '</ul>' . "\n";
-return $html;
-
-}
-
- // Display promotions
-function get_html_promo()
-{
- $promotion = array();
- $promotion['CentOS-5 Releases'] = 'Information about CentOS-5 releases will be displayed here. <a href="">Read more ...</a>';
- $promotion['CentOS-4 Releases'] = 'Information about CentOS-5 releases will be displayed here. <a href="">Read more ...</a>';
- $promotion['CentOS-3 Releases'] = 'Information about CentOS-5 releases will be displayed here. <a href="">Read more ...</a>';
- $promotion['CentOS-2 Releases'] = 'Information about CentOS-5 releases will be displayed here. <a href="">Read more ...</a>';
-
- $counter = 0;
- $last_promotion = count($promotion) -1;
-
- echo '<div class="pageline"></div>' . "\n";
-
- foreach ( $promotion as $key => $value )
- {
-
- // Set first promoblock
- switch ($counter)
- {
- case 0:
- $html = '<div class="promoblock first">';
- break;
-
- case $last_promotion:
- $html .= '<div class="promoblock last">';
- break;
-
- default:
- $html .= '<div class="promoblock">';
- }
-
- $html .= '<h3>' . $key . '</h3>' . "\n";
- $html .= '<p>' . $value . '</p>' . "\n";
- $html .= '</div>';
-
- $counter++;
- }
-
-return $html;
-
-}
-
-function get_html_searchform()
-{
- $html = '<div class="searchform">';
- $html .= '<form action="" method="post">';
- $html .= '<input id="searchinput" type="text" name="search" value="" onfocus="searchChange(this)" onblur="searchBlur(this)">';
- $html .= '<input type="submit" value="'.ucfirst(translate('find')).'">';
- $html .= '</form>';
- $html .= '</div>';
-
- return $html;
-}
-
-// Build 404 page not found error
-function get_html_err($err_id = '404', $err_msg = 'Page not found', $err_descrip = '')
-{
- $html = '<h1>' . $err_id . ': ' . ucfirst($err_msg) . '</h1>' . "\n";
- $html .= '<p>' . $err_descrip. '</p>';
- return $html;
-}
-
-?>
diff --git a/Scripts/CentOS-Web/includes/translations/en.php b/Scripts/CentOS-Web/includes/translations/en.php
deleted file mode 100644
index 7616ba6..0000000
--- a/Scripts/CentOS-Web/includes/translations/en.php
+++ /dev/null
@@ -1,42 +0,0 @@
-<?php
-/**
- * Language : English
- * Language-code: en
- * Description : English Translation
- *
- * Alain Reguera Delgado <al@ciget.cienfuegos.cu>
- */
-
- function translate($word)
- {
-
- $translation = array('' => '',
- // Admonition translations
- // LDAP translations
- 'uid' => 'User ID',
- 'cn' => 'Full Name',
- 'preferredlanguage' => 'Language',
- 'employeetype'=>'privileges',
- 'displayname'=>'nickname',
- 'userpassword'=>'password',
- // Others
- 'go back' => 'go back',
- 'default_f' => 'default',
- 'default_m' => 'default',
- 'en' => 'English',
- 'credits_on_footer_1' => 'The CentOS Project - '.date('Y').' | "Linux" is a registered trademark of Linus Torvalds. All other trademarks are property of their respective owners.',
- ''=>'');
-
- // if $word hasn't a translation here, return it.
- if ( array_key_exists($word, $translation))
- {
- $translation[$word] = $translation[$word];
- return $translation[$word];
- }
- else
- {
- return $word;
- }
- }
-
-?>
diff --git a/Scripts/CentOS-Web/includes/translations/es.php b/Scripts/CentOS-Web/includes/translations/es.php
deleted file mode 100644
index 0057d1c..0000000
--- a/Scripts/CentOS-Web/includes/translations/es.php
+++ /dev/null
@@ -1,162 +0,0 @@
-<?php
-/**
- * Language : Spanish
- * Language-code: es
- * Description : Spanish Translation
- *
- * Alain Reguera Delgado <al@ciget.cienfuegos.cu>
- */
-
- function translate($word)
- {
- $translation = array();
- $translation = array('change' => 'cambiar',
- // Errores Messages
- '001' => 'nombre de usuario o contraseña incorrecta!',
- '002' => 'Se encontraron valores duplicados en el directorio LDAP para el campo uid',
- 'a valid uid is required' => 'se requiere un identificador único de usuario',
- 'the field' => 'el campo',
- 'invalid action' => 'acción no soportada',
- 'user added successfully' => 'el usuario fue adicionado satisfactoriamente',
- 'is required' => 'es obligatorio',
- 'requires a valid value' => 'tiene un valor incorrecto',
- 'incorrect value in the field' => 'valor incorrecto en el campo',
- 'user identifier already exists' => 'el identificador único de usuario ya existe',
- 'successful update' => 'actualización satisfactoria',
- 'update failed' => 'actualización fallida',
- 'nothing to do' => 'nada que hacer',
- 'data was removed successfully' => 'los datos fueron eliminados satisfactoriamente',
- 'data was deleted successfully' => 'los datos fueron eliminados satisfactoriamente',
- 'data was updated successfully' => 'los datos fueron actualizados satisfactoriamente',
- 'data was not removed' => 'los datos no fueron eliminados',
- "the category dosn't exist" => "la categoría no existe",
- 'data was not updated' => 'los datos no fueron actualizados',
- 'field name can not be empty' => 'El campo nombre no puede estar vacío',
- 'id value is incorrect' => 'El valor del campo Id es incorrecto',
- 'record deleted successfully' => 'registro eliminado satisfactoriamente',
- 'records deleted successfully' => 'registros eliminados satisfactoriamente',
- 'category was added successfully' => 'la categoría fue adicionada satisfactoriamente',
- 'category was not added' => 'la categoría no fue adicionada',
- 'invalid cn' => 'valor incorrecto en el campo nombre común' ,
- 'page not found' => 'página no encontrada' ,
- // LDAP attributes
- 'cn' => 'nombre común',
- 'mail' => 'correo',
- 'uid' => 'identificador único',
- 'preferredlanguage' => 'Idioma preferido',
- 'displayname' => 'Apodo',
- 'userpassword' => 'Contraseña',
- 'employeetype' => 'tipo de empleo',
- // Database error messages
- 'connected' => 'conectado',
- 'Field name can not be empty' => 'El campo Nombre no puede estar vacío',
- 'name' => 'nombre',
- 'description' => 'descripción',
- 'disconnected' => 'desconectado',
- // Non error messages below
- 'home' => 'inicio',
- 'edit' => 'Editar',
- 'delete' => 'eliminar',
- 'es' => 'Español',
- 'download' => 'descargas',
- 'links' => 'enlaces',
- 'comments' => 'comentarios',
- 'comment' => 'comentario',
- 'link' => 'enlace',
- 'parent category' => 'categoría padre',
- 'group' => 'grupo',
- 'default_f' => 'predeterminada',
- 'default_m' => 'predeterminado',
- 'none' => 'ninguno',
- 'administrator' => 'administrador',
- 'writer' => 'escritor',
- 'find' => 'Buscar',
- 'archive' => 'archivo',
- 'hello' => 'hola',
- 'actions' => 'acciones',
- 'action' => 'acción',
- 'accept' => 'aceptar',
- 'remove' => 'eliminar',
- 'user' => 'usuario',
- 'logout' => 'salir',
- 'filter' => 'filtrar',
- 'contactus' => 'contáctenos',
- 'news' => 'noticias',
- 'administration' => 'administración',
- 'admin' => 'administrar',
- 'support' => 'soporte',
- 'write' => 'escribir',
- 'ex' => 'ej',
- 'information' => 'información',
- 'events' => 'eventos',
- 'mailinglists' => 'listas de correo',
- 'bugs' => 'bugs',
- 'help' => 'ayuda',
- 'documentation' => 'documentación',
- 'faqs' => 'faqs',
- 'forums' => 'foros',
- 'wiki' => 'wiki',
- 'donate' => 'donaciones',
- 'language' => 'idioma',
- 'languages' => 'idiomas',
- 'permissions' => 'permisos',
- 'go' => 'ir',
- 'login' => 'entrar',
- 'bugs' => 'errores',
- 'hi' => 'hola',
- 'powered by' => 'soportado por',
- 'register' => 'registrar cuenta nueva',
- 'newaccount' => 'cuenta nueva',
- 'lostpwd' => 'perdió su contraseña ?',
- 'previous entries' => 'Entradas anteriores',
- 'next entries' => 'Entradas siguientes',
- 'update' => 'Actualizar',
- 'first' => 'primero',
- 'last' => 'ultimo',
- 'password' => 'contraseña',
- 'categories' => 'categorías',
- 'category' => 'categoría',
- 'category tree' => 'Árbol de categorías',
- 'hierarchy' => 'jerarquía',
- 'close' => 'cerrar',
- 'session' => 'sesión',
- 'view' => 'ver',
- 'go back to' => 'regresar al',
- 'go back' => 'regresar',
- 'site' => 'sitio',
- 'add' => 'adicionar',
- 'years' => 'años',
- 'permissions' => 'permisos',
- 'note' => 'nota',
- 'news' => 'noticias',
- 'user' => 'usuario',
- 'welcome' => 'bienvenido',
- 'search results' => 'Resultados de la búsqueda',
- 'results' => 'resultados',
- 'looking in' => 'buscando en',
- 'filtering by' => 'filtrando por',
- 'admin_info_1' => 'esta aplicación te permitirá administrar el portal.',
- 'entry' => 'entrada',
- 'page' => 'página',
- 'users' => 'usuarios',
- 'entries' => 'entradas',
- 'portal administration' => 'Administración del portal',
- 'pages' => 'páginas',
- 'sponsors' => 'patrocinadores',
- 'search' => 'buscar',
- 'credits_on_footer_1' => 'The CentOS Project - '.date('Y').' | "Linux" es una marca registrada de Linus Torvalds. Todas las otras marcas comerciales son propiedad de sus respectivos dueños.',
- 'username' => 'usuario' );
-
- // if $word hasn't a translation here, return it.
- if ( array_key_exists($word, $translation))
- {
- $translation[$word] = $translation[$word];
- return $translation[$word];
- }
- else
- {
- return $word;
- }
-
-}
-?>
diff --git a/Scripts/CentOS-Web/index.php b/Scripts/CentOS-Web/index.php
deleted file mode 100755
index b585d0b..0000000
--- a/Scripts/CentOS-Web/index.php
+++ /dev/null
@@ -1,25 +0,0 @@
-<?php
-
-/***
- * Includes.
- * ------------------------------------
- */
-
-require_once('config.php');
-require_once(ABSPATH . 'admin/includes/functions/auth.php');
-check_useraccess();
-require_once(ABSPATH . 'includes/functions/html.php');
-require_once(ABSPATH . 'includes/translations/'.LANGUAGE.'.php');
-require_once(ABSPATH . 'admin/includes/classes/ldap.php');
-require_once(ABSPATH . 'admin/includes/classes/db_postgresql.php');
-require_once(ABSPATH . 'admin/includes/functions/categories.php');
-
-/***
- * Template index.
- * ------------------------------------
- */
-
-echo get_html_header();
-echo get_html_content();
-echo get_html_footer();
-?>
diff --git a/Scripts/Newbb2Phpbb/GPL b/Scripts/Newbb2Phpbb/GPL
deleted file mode 100755
index 5b6e7c6..0000000
--- a/Scripts/Newbb2Phpbb/GPL
+++ /dev/null
@@ -1,340 +0,0 @@
- GNU GENERAL PUBLIC LICENSE
- Version 2, June 1991
-
- Copyright (C) 1989, 1991 Free Software Foundation, Inc.
- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
- Everyone is permitted to copy and distribute verbatim copies
- of this license document, but changing it is not allowed.
-
- Preamble
-
- The licenses for most software are designed to take away your
-freedom to share and change it. By contrast, the GNU General Public
-License is intended to guarantee your freedom to share and change free
-software--to make sure the software is free for all its users. This
-General Public License applies to most of the Free Software
-Foundation's software and to any other program whose authors commit to
-using it. (Some other Free Software Foundation software is covered by
-the GNU Library General Public License instead.) You can apply it to
-your programs, too.
-
- When we speak of free software, we are referring to freedom, not
-price. Our General Public Licenses are designed to make sure that you
-have the freedom to distribute copies of free software (and charge for
-this service if you wish), that you receive source code or can get it
-if you want it, that you can change the software or use pieces of it
-in new free programs; and that you know you can do these things.
-
- To protect your rights, we need to make restrictions that forbid
-anyone to deny you these rights or to ask you to surrender the rights.
-These restrictions translate to certain responsibilities for you if you
-distribute copies of the software, or if you modify it.
-
- For example, if you distribute copies of such a program, whether
-gratis or for a fee, you must give the recipients all the rights that
-you have. You must make sure that they, too, receive or can get the
-source code. And you must show them these terms so they know their
-rights.
-
- We protect your rights with two steps: (1) copyright the software, and
-(2) offer you this license which gives you legal permission to copy,
-distribute and/or modify the software.
-
- Also, for each author's protection and ours, we want to make certain
-that everyone understands that there is no warranty for this free
-software. If the software is modified by someone else and passed on, we
-want its recipients to know that what they have is not the original, so
-that any problems introduced by others will not reflect on the original
-authors' reputations.
-
- Finally, any free program is threatened constantly by software
-patents. We wish to avoid the danger that redistributors of a free
-program will individually obtain patent licenses, in effect making the
-program proprietary. To prevent this, we have made it clear that any
-patent must be licensed for everyone's free use or not licensed at all.
-
- The precise terms and conditions for copying, distribution and
-modification follow.
-
- GNU GENERAL PUBLIC LICENSE
- TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
-
- 0. This License applies to any program or other work which contains
-a notice placed by the copyright holder saying it may be distributed
-under the terms of this General Public License. The "Program", below,
-refers to any such program or work, and a "work based on the Program"
-means either the Program or any derivative work under copyright law:
-that is to say, a work containing the Program or a portion of it,
-either verbatim or with modifications and/or translated into another
-language. (Hereinafter, translation is included without limitation in
-the term "modification".) Each licensee is addressed as "you".
-
-Activities other than copying, distribution and modification are not
-covered by this License; they are outside its scope. The act of
-running the Program is not restricted, and the output from the Program
-is covered only if its contents constitute a work based on the
-Program (independent of having been made by running the Program).
-Whether that is true depends on what the Program does.
-
- 1. You may copy and distribute verbatim copies of the Program's
-source code as you receive it, in any medium, provided that you
-conspicuously and appropriately publish on each copy an appropriate
-copyright notice and disclaimer of warranty; keep intact all the
-notices that refer to this License and to the absence of any warranty;
-and give any other recipients of the Program a copy of this License
-along with the Program.
-
-You may charge a fee for the physical act of transferring a copy, and
-you may at your option offer warranty protection in exchange for a fee.
-
- 2. You may modify your copy or copies of the Program or any portion
-of it, thus forming a work based on the Program, and copy and
-distribute such modifications or work under the terms of Section 1
-above, provided that you also meet all of these conditions:
-
- a) You must cause the modified files to carry prominent notices
- stating that you changed the files and the date of any change.
-
- b) You must cause any work that you distribute or publish, that in
- whole or in part contains or is derived from the Program or any
- part thereof, to be licensed as a whole at no charge to all third
- parties under the terms of this License.
-
- c) If the modified program normally reads commands interactively
- when run, you must cause it, when started running for such
- interactive use in the most ordinary way, to print or display an
- announcement including an appropriate copyright notice and a
- notice that there is no warranty (or else, saying that you provide
- a warranty) and that users may redistribute the program under
- these conditions, and telling the user how to view a copy of this
- License. (Exception: if the Program itself is interactive but
- does not normally print such an announcement, your work based on
- the Program is not required to print an announcement.)
-
-These requirements apply to the modified work as a whole. If
-identifiable sections of that work are not derived from the Program,
-and can be reasonably considered independent and separate works in
-themselves, then this License, and its terms, do not apply to those
-sections when you distribute them as separate works. But when you
-distribute the same sections as part of a whole which is a work based
-on the Program, the distribution of the whole must be on the terms of
-this License, whose permissions for other licensees extend to the
-entire whole, and thus to each and every part regardless of who wrote it.
-
-Thus, it is not the intent of this section to claim rights or contest
-your rights to work written entirely by you; rather, the intent is to
-exercise the right to control the distribution of derivative or
-collective works based on the Program.
-
-In addition, mere aggregation of another work not based on the Program
-with the Program (or with a work based on the Program) on a volume of
-a storage or distribution medium does not bring the other work under
-the scope of this License.
-
- 3. You may copy and distribute the Program (or a work based on it,
-under Section 2) in object code or executable form under the terms of
-Sections 1 and 2 above provided that you also do one of the following:
-
- a) Accompany it with the complete corresponding machine-readable
- source code, which must be distributed under the terms of Sections
- 1 and 2 above on a medium customarily used for software interchange; or,
-
- b) Accompany it with a written offer, valid for at least three
- years, to give any third party, for a charge no more than your
- cost of physically performing source distribution, a complete
- machine-readable copy of the corresponding source code, to be
- distributed under the terms of Sections 1 and 2 above on a medium
- customarily used for software interchange; or,
-
- c) Accompany it with the information you received as to the offer
- to distribute corresponding source code. (This alternative is
- allowed only for noncommercial distribution and only if you
- received the program in object code or executable form with such
- an offer, in accord with Subsection b above.)
-
-The source code for a work means the preferred form of the work for
-making modifications to it. For an executable work, complete source
-code means all the source code for all modules it contains, plus any
-associated interface definition files, plus the scripts used to
-control compilation and installation of the executable. However, as a
-special exception, the source code distributed need not include
-anything that is normally distributed (in either source or binary
-form) with the major components (compiler, kernel, and so on) of the
-operating system on which the executable runs, unless that component
-itself accompanies the executable.
-
-If distribution of executable or object code is made by offering
-access to copy from a designated place, then offering equivalent
-access to copy the source code from the same place counts as
-distribution of the source code, even though third parties are not
-compelled to copy the source along with the object code.
-
- 4. You may not copy, modify, sublicense, or distribute the Program
-except as expressly provided under this License. Any attempt
-otherwise to copy, modify, sublicense or distribute the Program is
-void, and will automatically terminate your rights under this License.
-However, parties who have received copies, or rights, from you under
-this License will not have their licenses terminated so long as such
-parties remain in full compliance.
-
- 5. You are not required to accept this License, since you have not
-signed it. However, nothing else grants you permission to modify or
-distribute the Program or its derivative works. These actions are
-prohibited by law if you do not accept this License. Therefore, by
-modifying or distributing the Program (or any work based on the
-Program), you indicate your acceptance of this License to do so, and
-all its terms and conditions for copying, distributing or modifying
-the Program or works based on it.
-
- 6. Each time you redistribute the Program (or any work based on the
-Program), the recipient automatically receives a license from the
-original licensor to copy, distribute or modify the Program subject to
-these terms and conditions. You may not impose any further
-restrictions on the recipients' exercise of the rights granted herein.
-You are not responsible for enforcing compliance by third parties to
-this License.
-
- 7. If, as a consequence of a court judgment or allegation of patent
-infringement or for any other reason (not limited to patent issues),
-conditions are imposed on you (whether by court order, agreement or
-otherwise) that contradict the conditions of this License, they do not
-excuse you from the conditions of this License. If you cannot
-distribute so as to satisfy simultaneously your obligations under this
-License and any other pertinent obligations, then as a consequence you
-may not distribute the Program at all. For example, if a patent
-license would not permit royalty-free redistribution of the Program by
-all those who receive copies directly or indirectly through you, then
-the only way you could satisfy both it and this License would be to
-refrain entirely from distribution of the Program.
-
-If any portion of this section is held invalid or unenforceable under
-any particular circumstance, the balance of the section is intended to
-apply and the section as a whole is intended to apply in other
-circumstances.
-
-It is not the purpose of this section to induce you to infringe any
-patents or other property right claims or to contest validity of any
-such claims; this section has the sole purpose of protecting the
-integrity of the free software distribution system, which is
-implemented by public license practices. Many people have made
-generous contributions to the wide range of software distributed
-through that system in reliance on consistent application of that
-system; it is up to the author/donor to decide if he or she is willing
-to distribute software through any other system and a licensee cannot
-impose that choice.
-
-This section is intended to make thoroughly clear what is believed to
-be a consequence of the rest of this License.
-
- 8. If the distribution and/or use of the Program is restricted in
-certain countries either by patents or by copyrighted interfaces, the
-original copyright holder who places the Program under this License
-may add an explicit geographical distribution limitation excluding
-those countries, so that distribution is permitted only in or among
-countries not thus excluded. In such case, this License incorporates
-the limitation as if written in the body of this License.
-
- 9. The Free Software Foundation may publish revised and/or new versions
-of the General Public License from time to time. Such new versions will
-be similar in spirit to the present version, but may differ in detail to
-address new problems or concerns.
-
-Each version is given a distinguishing version number. If the Program
-specifies a version number of this License which applies to it and "any
-later version", you have the option of following the terms and conditions
-either of that version or of any later version published by the Free
-Software Foundation. If the Program does not specify a version number of
-this License, you may choose any version ever published by the Free Software
-Foundation.
-
- 10. If you wish to incorporate parts of the Program into other free
-programs whose distribution conditions are different, write to the author
-to ask for permission. For software which is copyrighted by the Free
-Software Foundation, write to the Free Software Foundation; we sometimes
-make exceptions for this. Our decision will be guided by the two goals
-of preserving the free status of all derivatives of our free software and
-of promoting the sharing and reuse of software generally.
-
- NO WARRANTY
-
- 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY
-FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN
-OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES
-PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
-OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
-MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS
-TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE
-PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING,
-REPAIR OR CORRECTION.
-
- 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
-WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
-REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
-INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING
-OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED
-TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY
-YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER
-PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE
-POSSIBILITY OF SUCH DAMAGES.
-
- END OF TERMS AND CONDITIONS
-
- How to Apply These Terms to Your New Programs
-
- If you develop a new program, and you want it to be of the greatest
-possible use to the public, the best way to achieve this is to make it
-free software which everyone can redistribute and change under these terms.
-
- To do so, attach the following notices to the program. It is safest
-to attach them to the start of each source file to most effectively
-convey the exclusion of warranty; and each file should have at least
-the "copyright" line and a pointer to where the full notice is found.
-
- <one line to give the program's name and a brief idea of what it does.>
- Copyright (C) <year> <name of author>
-
- This program is free software; you can redistribute it and/or modify
- it under the terms of the GNU General Public License as published by
- the Free Software Foundation; either version 2 of the License, or
- (at your option) any later version.
-
- 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 more details.
-
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-
-
-Also add information on how to contact you by electronic and paper mail.
-
-If the program is interactive, make it output a short notice like this
-when it starts in an interactive mode:
-
- Gnomovision version 69, Copyright (C) year name of author
- Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
- This is free software, and you are welcome to redistribute it
- under certain conditions; type `show c' for details.
-
-The hypothetical commands `show w' and `show c' should show the appropriate
-parts of the General Public License. Of course, the commands you use may
-be called something other than `show w' and `show c'; they could even be
-mouse-clicks or menu items--whatever suits your program.
-
-You should also get your employer (if you work as a programmer) or your
-school, if any, to sign a "copyright disclaimer" for the program, if
-necessary. Here is a sample; alter the names:
-
- Yoyodyne, Inc., hereby disclaims all copyright interest in the program
- `Gnomovision' (which makes passes at compilers) written by James Hacker.
-
- <signature of Ty Coon>, 1 April 1989
- Ty Coon, President of Vice
-
-This General Public License does not permit incorporating your program into
-proprietary programs. If your program is a subroutine library, you may
-consider it more useful to permit linking proprietary applications with the
-library. If this is what you want to do, use the GNU Library General
-Public License instead of this License.
diff --git a/Scripts/Newbb2Phpbb/classes/db_mysql.php b/Scripts/Newbb2Phpbb/classes/db_mysql.php
deleted file mode 100755
index 60c9893..0000000
--- a/Scripts/Newbb2Phpbb/classes/db_mysql.php
+++ /dev/null
@@ -1,208 +0,0 @@
-<?php
-/***
- * Database Access (MySQL)
- *
- * Provides default database access values, and functions used to
- * access data in both newbb and phpBB.
- *
- * --
- * Alain Reguera Delgado <alain.reguera@gmail.com>
- ***/
-
-class DB_MYSQL
-{
- public $db_conn;
-
- public $db_host;
- public $db_user;
- public $db_pass;
- public $db_xoops_db;
- public $db_xoops_tbl;
- public $db_phpbb_db;
- public $db_phpbb_tbl;
-
- /***
- * Class Construct
- ***/
-
- function __construct()
- {
- // Initialize configuration values
- $this->db_host = 'localhost';
- $this->db_user = 'root';
- $this->db_pass = '';
- $this->db_xoops_db = 'xoops';
- $this->db_xoops_tbl = 'xoops_';
- $this->db_phpbb_db = 'phpBB';
- $this->db_phpbb_tbl = 'phpbb_';
-
- // Reinitialize configuration values
- $config = array('db_host', 'db_user', 'db_pass', 'db_xoops_db',
- 'db_xoops_tbl', 'db_phpbb_db', 'db_phpbb_tbl');
-
- foreach ( $config as $param )
- {
- if ( ! isset( $_SESSION[$param] ) )
- {
- $_SESSION[$param] = $this->$param;
- }
-
- $_SESSION[$param] = isset($_POST[$param])?$_POST[$param]:$_SESSION[$param];
-
- $this->$param = $_SESSION[$param];
- }
- }
-
- /***
- * Connect
- */
- function connect()
- {
- // Connect to MySQL database
- $this->db_conn = mysql_connect( $this->db_host,
- $this->db_user,
- $this->db_pass );
- if ( $this->db_conn )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * DB Configuration
- */
- function get_configForm( $disabled = '' )
- {
- $htmlblock = array();
-
- array_push( $htmlblock,
- // Common DB Configuration
- '<h2>Common DB configuration:</h2>',
- '<dl>',
- '<dt>Server: </dt>',
- '<dd><input type="text" name="db_host" value="'.$this->db_host.'" '.$disabled.' /></dd>',
-
- '<dt>Username:</dt>',
- '<dd><input type="text" name="db_user" value="'.$this->db_user.'" '.$disabled.' /></dd>',
-
- '<dt>Password:</dt>',
- '<dd><input type="password" name="db_pass" value="'.$this->db_pass.'" '.$disabled.' /></dd>',
- '</dl>',
-
- // Xoops Configuration
- '<h2>Xoops configuration:</h2>',
- '<dl>',
- '<dt>Xoops database name:</dt>',
- '<dd><input type="text" name="db_xoops_db" value="'.$this->db_xoops_db.'" '.$disabled.' /></dd>',
-
- '<dt>Xoops table prefix:</dt>',
- '<dd><input type="text" name="db_xoops_tbl" value="'.$this->db_xoops_tbl.'" '.$disabled.' /></dd>',
-
- '</dl>',
-
- // phpBB Configuration
- '<h2>phpBB configuration:</h2>',
- '<dl>',
- '<dt>Phpbb database name:</dt>',
- '<dd><input type="text" name="db_phpbb_db" value="'.$this->db_phpbb_db.'" '.$disabled.' /></dd>',
-
- '<dt>Phpbb table prefix:</dt>',
- '<dd><input type="text" name="db_phpbb_tbl" value="'.$this->db_phpbb_tbl.'" '.$disabled.' /></dd>',
- '</dl>');
-
- return $htmlblock;
- }
-
- /***
- * Query
- */
- function query( $sql )
- {
- $this->connect();
- $result = mysql_query( $sql, $this->db_conn );
- if ( $result )
- {
- return $result;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Check existance
- */
- function check_existance( $name )
- {
-
- switch ( $name )
- {
- case 'phpbb':
- $check_dbname = $this->db_phpbb_db;
- $check_suffix = $this->db_phpbb_tbl;
- $check_tables = array('users', 'forums', 'topics', 'posts');
- break;
-
- case 'xoops':
- $check_dbname = $this->db_xoops_db;
- $check_suffix = $this->db_xoops_tbl;
- $check_tables = array('users', 'bb_forums', 'bb_topics', 'bb_posts', 'bb_posts_text');
- break;
- }
-
- $error = 0;
- $table_list = array();
-
- // Check database existance
- if ( ! mysql_select_db( $check_dbname ) )
- {
- $error++;
- }
-
- // Check tables existance
- else
- {
- $sql = 'SHOW TABLES FROM ' . $check_dbname . ';';
- $result = $this->query( $sql );
- while ( $row = mysql_fetch_row ($result) )
- {
- array_push($table_list, $row[0]);
- }
-
- foreach ($check_tables as $tablename)
- {
- $tablename = $check_suffix . $tablename;
- if (in_array($tablename, $table_list) === false )
- {
- $error++;
- }
- }
- }
-
- if ( $error == 0 )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Class Destruct
- ***/
-
- function disconnect()
- {
- mysql_close( $this->db_conn );
- }
-}
-
-$db = new DB_MYSQL;
-?>
diff --git a/Scripts/Newbb2Phpbb/classes/html.php b/Scripts/Newbb2Phpbb/classes/html.php
deleted file mode 100755
index 6c85f07..0000000
--- a/Scripts/Newbb2Phpbb/classes/html.php
+++ /dev/null
@@ -1,132 +0,0 @@
-<?php
-/***
- * HTML - Used to htmlblock html code.
- */
-
-class HTML
-{
-
- /***
- * Format html htmlblock
- */
- function format_htmlblock( $htmlblock = array() )
- {
- $html_formatted = '';
-
- // Define amount of tabs
- $tabs = array(0 => '',
- 1 => "\t",
- 2 => "\t\t",
- 3 => "\t\t\t",
- 4 => "\t\t\t\t",
- 5 => "\t\t\t\t\t");
-
- // Define indententaion level by tags
- $levels = array('/<\/?html/' => 0,
- '/<\/?(body|head)( .+|>)/' => 1,
- '/<\/?(title)( .+|>)/' => 2,
- '/<\/?(br|hr) \/>/' => 2,
- '/<\/?(p|pre|table|dl|ul|ol|div|h[1-9]|form|link)( .+|>)/' => 3,
- '/<\/?(li|dt|dd|span|select|option|tr)( .+|>)/' => 4,
- '/<\/?(th|td)( .+|>)/' => 5);
-
- // Set line level, line by line
- foreach ( $htmlblock as $line )
- {
- foreach ( $levels as $tag => $level )
- {
- if ( preg_match( $tag, $line ) )
- {
- $html_formatted .= $tabs[$level] . $line . "\n";
- }
-
- }
- }
-
- return $html_formatted;
- }
-
- /***
- * Format messages
- *
- * $message : the message text itself.
- * $color : grey|green|orange|blue|violet|red
- * if no color is specified grey color is assumed as default
- */
- function format_message( $message = 'Empty', $color = '' )
- {
- // Validate color to be used
- $valid_colors = array('grey', 'green', 'orange', 'violet', 'blue', 'red');
- if ( ! in_array( $color, $valid_colors ) )
- {
- $color = '';
- }
-
- // Build message html
- $html = '<div class="message lm ' . $color . '">' . strtoupper($message) . '</div>';
-
- return $html;
- }
-
- /***
- * Where is my position in the migration ?
- * ----------------------------------------------------
- * It is somehow a breadcrumb of where you are in the migration process.
- */
- function get_stepPosition()
- {
- // Define migration process stepts
- $steps = array(0 => 'Configuration',
- 1 => 'Verification',
- 2 => 'Migration',
- 3 => 'Reset Passwords');
-
- $position = isset( $_POST['step'] )?$_POST['step']:0;
-
- $htmlblock = array('<ul class="sublinks">');
-
- foreach ( $steps as $key => $value )
- {
- if ( $position == $key)
- {
- array_push($htmlblock,'<li class="current">'. $value.'</li>');
- }
- else
- {
- array_push($htmlblock,'<li>'. $value.'</li>');
- }
- }
-
- array_push( $htmlblock, '</ul>');
-
- return $htmlblock;
- }
-
- /***
- * Navibar
- */
- function get_navibar()
- {
- global $db;
-
- $htmlblock = array('<ul class="navibar">');
-
- if ( isset($_GET['p']) && $_GET['p'] == 'help' )
- {
- array_push($htmlblock, '<li><a href="index.php">Main</a></li>');
- array_push($htmlblock, '<li class="current"><a href="?p=help">Help</a></li>');
- }
- else
- {
- array_push($htmlblock, '<li class="current"><a href="index.php">Main</a></li>');
- array_push($htmlblock, '<li><a href="?p=help">Help</a></li>');
- }
-
- array_push( $htmlblock, '</ul>');
-
- return $htmlblock;
- }
-}
-
-$html = new HTML;
-?>
diff --git a/Scripts/Newbb2Phpbb/classes/ldap.php b/Scripts/Newbb2Phpbb/classes/ldap.php
deleted file mode 100755
index 63d78b0..0000000
--- a/Scripts/Newbb2Phpbb/classes/ldap.php
+++ /dev/null
@@ -1,321 +0,0 @@
-<?php
-/***
- * LDAP Access
- *
- * --
- * Alain Reguera Delgado <alain.reguera@gmail.com>
- ***/
-
-class LDAP
-{
- public $this_conn;
- public $this_host;
- public $this_port;
- public $this_rootdn;
- public $this_rootpw;
- public $this_authschema;
- public $this_basedn;
-
- /***
- * Class initialization
- */
- function __construct()
- {
- // Initialize configuration values
- $this->ldap_host = 'localhost';
- $this->ldap_port = '389';
- $this->ldap_rootdn = 'cn=manager,dc=example,dc=com';
- $this->ldap_rootpw = '';
- $this->ldap_authschema = '{MD5}';
- $this->ldap_basedn = 'ou=people,dc=example,dc=com';
-
- // Reinitialize configuration values
- $config = array('ldap_host', 'ldap_port', 'ldap_rootdn',
- 'ldap_rootpw', 'ldap_authschema','ldap_basedn');
-
- foreach ( $config as $param )
- {
- if ( ! isset($_SESSION[$param] ) )
- {
- $_SESSION[$param] = $this->$param;
- }
-
- $_SESSION[$param] = isset($_POST[$param])?$_POST[$param]:$_SESSION[$param];
-
- $this->$param = $_SESSION[$param];
- }
-
- // Open connection against ldap server
- if ( $this->ldap_host && $this->ldap_port )
- {
- $this->ldap_conn = ldap_connect( $this->ldap_host, $this->ldap_port );
- }
-
- // Set protocol version to use LDAPv3
- ldap_set_option( $this->ldap_conn, LDAP_OPT_PROTOCOL_VERSION, 3);
- }
-
- /***
- * LDAP configuration
- */
- function get_configForm( $disabled = "" )
- {
- $htmlblock = array();
-
- array_push( $htmlblock,
-
- '<h2>LDAP configuration:</h2>', '<dl>',
-
- '<dt>Host:</dt>',
- '<dd><input type="text" name="ldap_host" value="'. $this->ldap_host . '" ' . $disabled . ' /></dd>',
-
- '<dt>Port:</dt>',
- '<dd><input type="text" name="ldap_port" value="' . $this->ldap_port.'" ' . $disabled . ' /></dd>',
-
- '<dt>Bind DN:</dt>',
- '<dd><input type="text" name="ldap_rootdn" value="'. $this->ldap_rootdn .'" size="50" ' . $disabled . ' /></dd>',
-
- '<dt>Base DN: </dt>',
- '<dd><input type="text" name="ldap_basedn" value="' . $this->ldap_basedn . '" size="50" ' . $disabled . ' /></dd>',
-
- '<dt>Bind Password: </dt>',
- '<dd><input type="password" name="ldap_rootpw" value="' . $this->ldap_rootpw.'" ' . $disabled . ' /></dd>',
-
-
- '<dt>Schema: </dt>',
- '<dd>',
- '<select name="ldap_authschema" ' . $disabled . '>',
- '<option value="{MD5}">{MD5}</option>',
- '<option value="{SHA}">{SHA}</option>',
- '</select>',
- '</dd>',
-
- '</dl>');
-
- return $htmlblock;
- }
-
-
- /***
- * Verify configuration
- */
- function verify_configuration()
- {
-
- }
-
- /***
- * Bind to LDAP server
- */
- function do_bind()
- {
- return ldap_bind( $this->ldap_conn, $this->ldap_rootdn, $this->ldap_rootpw );
- }
-
- /***
- * Verify LDAP uid's value uniqness
- */
- function is_uid_present( $uid )
- {
- $filter = 'uid=' . $uid;
- $result = ldap_search( $this->ldap_conn, $this->ldap_basedn, $filter);
- $entry = ldap_get_entries( $this->ldap_conn, $result);
-
- if ( $uid != '' && $entry['count'] == 1 )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Prepare LDAP userPassword attribute
- */
- function prepare_userpassword( $userpassword )
- {
- $dirty['userpassword'] = $userpassword;
- $clean['userpassword'] = '';
-
- switch ( $this->ldap_authschema )
- {
- case '{MD5}':
- $clean['userpassword'] = '{MD5}' . base64_encode( pack( 'H*', md5( $dirty['userpassword'] ) ) );
- break;
-
- case '{SHA}':
- $clean['userpassword'] = '{SHA}' . base64_encode( pack( 'H*', sha1( $dirty['userpassword'] ) ) );
- break;
- }
-
- return $clean['userpassword'];
- }
-
-
- /***
- * Add User
- */
- function add_User( $entry )
- {
- $this_entry = array();
-
- // Define user DN
- $dn = 'uid=' . $entry['email'] . ',' . $this->ldap_basedn;
-
- // Remove user if exists
- if ( $this->is_uid_present( $entry['uname'] ) === true )
- {
- $this->delete_User( $entry );
- }
-
- // Prepare userPassword and other attributes for insertion in LDAP directory.
- $this_entry['objectclass'] = 'inetOrgPerson';
- $this_entry['cn'] = $entry['name'];
- $this_entry['mail'] = $entry['email'];
- $this_entry['userpassword'] = $this->prepare_userpassword($entry['pass']);
- $this_entry['sn'] = preg_replace('/^([a-zA-Z0-9_]+ ?)/','', $this_entry['cn']);
- $this_entry['uid'][0] = $this_entry['mail'];
- $this_entry['uid'][1] = $entry['uname'];
- $this_entry['displayname'] = $entry['uname'];
- $this_entry['employeetype'] = 'writer';
- $this_entry['preferredlanguage'] = 'en';
-
- if ( $this->do_bind() && ldap_add( $this->ldap_conn, $dn, $this_entry ))
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Delete User
- */
- function delete_User( $entry )
- {
- // Define user DN
- $dn = 'uid=' . $entry['email'] . ',' . $this->ldap_basedn;
-
- if ( $this->do_bind() && ldap_delete( $this->ldap_conn, $dn ) )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Update LDAP userPassword only.
- */
- function update_userPassword( $dn, $userPassword )
- {
- $entry = array('userpassword' => $userPassword );
-
- if ( $this->do_bind() && ldap_modify( $this->ldap_conn, $dn, $entry) )
- {
- return true;
- }
- else
- {
- return false;
- }
- }
-
- /***
- * Get LDAP user list
- * ----------------------------------------------------
- * 1. Show a form with a list of all users inserted from xoops.users table.
- * 2. Generate random passwords for each user and codify them into
- * userPassword format.
- * 3. Real passwords are not displayed.
- */
- function get_userList()
- {
- global $newbb_to_phpbb;
- global $mail;
-
- // Get users from LDAP server
- $filter = 'objectclass=inetorgperson';
- $result = ldap_search( $this->ldap_conn, $this->ldap_basedn, $filter);
- $users = ldap_get_entries( $this->ldap_conn, $result );
-
- $htmlblock = array('<p>'.$users['count'].' password(s) reset under: <code>'.$this->ldap_basedn.'</code></p>',
- '<table border="1">',
- '<tr>',
- '<th>DN</th>',
- '<th>CN</th>',
- '<th>NewPass</th>',
- '<th>userPassword</th>',
- '<th>Password Updated</th>',
- '<th>Email Notification</th>',
- '</tr>');
-
- for ($i = 0; $i < $users['count']; $i++)
- {
- // Reset userPassword value in a random manner
- $newPassword = $newbb_to_phpbb->get_randomPass();
- $userPassword = $this->prepare_userpassword($newPassword);
-
- array_push($htmlblock, '<tr>',
- '<td>' . $users[$i]['dn'] . '</td>',
- '<td>' . $users[$i]['cn'][0] . '</td>',
- '<td>' . $newPassword . '</td>',
- '<td>' . $userPassword . '</td>');
-
- // Update LDAP userPassword field
- if ( $this->update_userPassword( $users[$i]['dn'], $userPassword ) === true )
- {
- array_push($htmlblock,'<td class="center">YES</td>');
- }
- else
- {
- array_push($htmlblock,'<td class="center">NO</td>');
- }
-
- // Send email notification
- $info = array('mailto' => $users[$i]['mail'][0],
- 'cn' => $users[$i]['cn'][0],
- 'dn' => $users[$i]['dn'],
- 'uid1' => $users[$i]['uid'][0],
- 'uid2' => $users[$i]['uid'][1],
- 'sn' => $users[$i]['sn'][0],
- 'employeetype' => $users[$i]['employeetype'][0],
- 'preferredlanguage' => $users[$i]['preferredlanguage'][0],
- 'displayname' => $users[$i]['displayname'][0],
- 'userpassword' => $newPassword);
- if ( $mail->send( $info ) === true )
- {
- array_push($htmlblock,'<td class="center">SENT</td>');
- }
- else
- {
- array_push($htmlblock,'<td class="center">NOT SENT</td>');
- }
- array_push($htmlblock,'</tr>');
- }
-
- array_push($htmlblock,'</table>');
-
- return $htmlblock;
- }
-
- /***
- * Class destruct
- */
- function __destruct()
- {
- if ( isset( $this->ldap_conn ) )
- {
- ldap_unbind( $this->ldap_conn );
- }
- }
-}
-
-$ldap = new LDAP;
-?>
diff --git a/Scripts/Newbb2Phpbb/classes/mail.php b/Scripts/Newbb2Phpbb/classes/mail.php
deleted file mode 100755
index ead6bfc..0000000
--- a/Scripts/Newbb2Phpbb/classes/mail.php
+++ /dev/null
@@ -1,157 +0,0 @@
-<?php
-/***
- * Mail
- */
-
-class MAIL
-{
-
- public $notification;
- public $notification_subject;
- public $notification_message;
-
- /***
- * Class constructor
- */
-
- function __construct()
- {
- // Initialize variables with default values
- $this->notification = 'NO';
- $this->notification_subject = '[CentOS Forum] User account notification.';
- $this->notification_message = "Dear =USER_FIRST_NAME=,
-
-The CentOS Forums (http://centos.org/forums/) were migrated from
-Xoops+CBB(newbb) to phpBB3 and the user accounts were moved to an LDAP
-server. As consequence your user account is now on that LDAP server.
-
-In order to make this happen, it was needed to reset your account
-password. Your password(userPassword) is here with the rest of your
-user account information.
-
-The following LDAP entry has the information of your user account:
-
- dn: =DN=
- uid: =UID1=
- uid: =UID2=
- userPassword: =PASS=
- mail: =MAIL=
- cn: =CN=
- sn: =SN=
- employeeType: =TYPE=
-preferredLanguage: =LANG=
- displayName: =DISPLAYNAME=
-
-With this migration we are preparing the ground to unify all CentOS
-user accounts into a common place. If you need to authenticate
-somewhere under centos.org domain use any of your uids and the
-password provided above.
-
-Best Regards,
---
-The CentOS Team";
-
- // Reinitialize variables with form values
- $config = array('notification', 'notification_subject', 'notification_message');
- foreach ( $config as $param )
- {
- if ( ! isset($_SESSION[$param]))
- {
- $_SESSION[$param] = $this->$param;
- }
-
- $_SESSION[$param] = isset($_POST[$param])?$_POST[$param]:$_SESSION[$param];
-
- $this->$param = $_SESSION[$param];
- }
- }
-
- /***
- * Send
- * -------
- * $info is an array with the following indexes:
- * - mailto
- * - name
- * - dn
- * - newpass
- */
-
- function send( $info )
- {
- // Do replacements in message template
- $this->notification_message = preg_replace('/=MAIL=/', $info['mailto'],$this->notification_message);
- $this->notification_message = preg_replace('/=DN=/', $info['dn'],$this->notification_message);
- $this->notification_message = preg_replace('/=UID1=/', $info['uid1'],$this->notification_message);
- $this->notification_message = preg_replace('/=UID2=/', $info['uid2'],$this->notification_message);
- $this->notification_message = preg_replace('/=PASS=/', $info['userpassword'],$this->notification_message);
- $this->notification_message = preg_replace('/=CN=/', $info['cn'],$this->notification_message);
- $this->notification_message = preg_replace('/=SN=/', $info['sn'],$this->notification_message);
- $this->notification_message = preg_replace('/=TYPE=/', $info['employeetype'],$this->notification_message);
- $this->notification_message = preg_replace('/=LANG=/', $info['preferredlanguage'],$this->notification_message);
- $this->notification_message = preg_replace('/=DISPLAYNAME=/',$info['displayname'],$this->notification_message);
- $this->notification_message = preg_replace('/=USER_FIRST_NAME=/', preg_replace('/ .+$/','',$info['cn']), $this->notification_message);
-
- $to = $info['mailto'];
- $subject = $this->notification_subject;
- $message = $this->notification_message;
- $headers = 'From: webmaster';
- $extra_params = '-fwebmaster';
- if ( $this->notification == 'YES' )
- {
- return mail( $to, $subject, $message, $headers, $extra_params );
- }
- }
-
- /***
- * Send notification ?
- * Show form selector
- */
-
- function get_configForm( $disabled = '' )
- {
- $htmlblock = array('<h2>Mail Notification:</h2>','<dl>');
-
- // Mail template
- array_push($htmlblock,
-
- '<dt>Subject:</dt>',
- '<dd><input name="notification_subject" size="70" '.$disabled.' value="'.$this->notification_subject.'" /></dd>',
-
- '<dt>Message:</dt>',
- '<dd><textarea name="notification_message" cols="70" rows="15" '.$disabled.'>'.$this->notification_message.'</textarea></dd>',
-
- '<dt>Send notifications ?:</dt>',
- '<dd><select name="notification" '.$disabled.'>');
-
- if ( $this->notification == 'YES' )
- {
- array_push($htmlblock,
- '<option value="NO">NO</option>',
- '<option value="YES" selected="selected">YES</option>');
- }
- else
- {
- array_push ( $htmlblock,
- '<option value="NO" selected="selected">NO</option>',
- '<option value="YES">YES</option>');
- }
-
- array_push($htmlblock, '</select><span class="description"><strong>Use it with care!</strong></span></dd>');
-
- array_push($htmlblock, '</dl>');
-
- return $htmlblock;
- }
-
- /***
- * Class destructor
- */
-
- function __destruct()
- {
-
- }
-}
-
-$mail = new MAIL;
-?>
diff --git a/Scripts/Newbb2Phpbb/classes/newbb_to_phpbb.php b/Scripts/Newbb2Phpbb/classes/newbb_to_phpbb.php
deleted file mode 100755
index 2eb5e64..0000000
--- a/Scripts/Newbb2Phpbb/classes/newbb_to_phpbb.php
+++ /dev/null
@@ -1,424 +0,0 @@
-<?php
-/***
- * Convert Xoops + CBB (newbb) to phpBB
- *
- * --
- * Alain Reguera Delgado <alain.reguera@gmail.com>
- ***/
-
-
-class NEWBB_TO_PHPBB
-{
-
- /***
- * Class Construct
- * ----------------------------------------------------
- */
- function __construct()
- {
- // Initialize session
- session_start();
-
- // Check action: usedefaults
- if ( isset( $_GET['action'] ) && $_GET['action'] == 'restore' )
- {
- // Unset session values
- session_unset();
-
- // Reload page
- header('Location: index.php');
- }
- }
-
- /***
- * Verify Configuration
- *
- * This verification is needed to be sure new information entered
- * is valid.
- */
- function config_verification( $next_step )
- {
- global $db;
- global $ldap;
- global $html;
-
- $htmlblock = array();
- $error = 0;
-
- // Verify LDAP bind
- if ( $ldap->do_bind() )
- {
- array_push($htmlblock, $html->format_message('LDAP Configuration is correct', 'green'));
- }
- else
- {
- array_push( $htmlblock, $html->format_message('LDAP Configuration is incorrect', 'orange'));
- $error++;
- }
-
- // Verify Database
- if ( $db->connect() === true )
- {
- array_push( $htmlblock, $html->format_message('Common DB Configuration is correct', 'green'));
-
- // Verify XOOPS database and table
- if ( $db->check_existance('xoops') === true )
- {
- array_push( $htmlblock, $html->format_message('Xoops configuration is correct', 'green'));
- }
- else
- {
- array_push( $htmlblock, $html->format_message('Xoops configuration is incorrect', 'orange'));
- $error++;
- }
-
- // Verify PHPBB database and table
- if ( $db->check_existance('phpbb') === true )
- {
- array_push( $htmlblock, $html->format_message('phpBB configuration is correct', 'green'));
- }
- else
- {
- array_push( $htmlblock, $html->format_message('phpBB configuration is incorrect', 'orange'));
- $error++;
- }
- }
- else
- {
- array_push( $htmlblock, $html->format_message('Common DB Configuration is incorrect', 'orange'));
- $error++;
- }
-
- // Add action button
- if ( $error == 0 )
- {
- $next_step++;
- array_push( $htmlblock,
- '<p class="action right">
- <input type="hidden" name="step" value="'.$next_step.'" />
- <input type="submit" name="Next" value="Next" />
- </p>');
- }
- else
- {
- array_push($htmlblock, '<p class="action left"><img src="img/previous.png" alt="Previous" /><a href="index.php">Check your configuration</a></p>');
- }
-
- return $html->format_htmlblock($htmlblock);
- }
-
- /***
- * Groups
- *
- * All users in xoops.users will be inserted into phpBB.users
- * using the REGISTERED group (group_id = 2). Forums administrators should
- * be redifined after migration.
- */
-
- /***
- * Users
- *
- * Basic fields are copied from xoops.users to phpBB.users.
- *
- * Password field should be redifined by the user in order to get logged in
- * after the migration.
- *
- * If LDAP authentication is used the directory structure should be design
- * to receive uid and userPassword attributes. In this case the migration
- * should be focused from xoops.users to LDAP directory not phpBB.users.
- *
- * The LDAP registration process is (as my understanding): 1. Add an entry
- * for the user in the LDAP directory. 2. Add an entry for the user in the
- * DB (this is automatically done by phpBB). This is needed to relate user
- * against user specific information like topics, posts, etc.
- *
- * As we are using LDAP server for users. This function use php's ldap
- * extension to add users into LDAP directory. If the user do no exist in
- * the Database but in LDAP server, phpBB will automatically insert a
- * record for that user in the phpBB.user table. It is needed to relate
- * user identity to posts, topics, etc .
- *
- * User passwords need to be reseted and a notification could be send to each
- * user telling the new password set. This is requiered because the
- * password codification used in newbb, phpbb and LDAP is different.
- *
- * The structure of LDAP user entries was built with rfc2377 in mind.
- */
- function copy_Users()
- {
- global $ldap;
- global $db;
-
- $htmlblock = array('<h2>Users</h2>','<ul>');
-
- // Remove phpBB.users. Number 52 seems to be the greatest user_id
- // value when no user has been created.
-
- array_push($htmlblock,'<li>Cleanning up ... </li>');
-
- $sql = sprintf('DELETE FROM %s.%susers WHERE user_id > 52;',
- $db->db_phpbb_db,
- $db->db_phpbb_tbl );
- $db->query( $sql );
-
- // Add users into LDAP directory
-
- array_push($htmlblock,'<li>Copying ... </li>');
-
- $sql = sprintf("SELECT uname,
- name,
- email,
- pass
- FROM %s.%susers WHERE uid > 1",
- $db->db_xoops_db,
- $db->db_xoops_tbl );
-
- $result = $db->query( $sql );
-
- $counter = 0;
-
- while ( $entry = mysql_fetch_array( $result ) )
- {
- // Add xoops.users into LDAP directory
- if ( $ldap->add_User( $entry ) === true )
- {
- $counter++;
- }
- }
-
- array_push($htmlblock,'<li>'. $counter .' user(s) copied successfully.</li>','</ul>');
-
- return $htmlblock;
- }
-
- /***
- * Categories
- *
- * Not copied. In phpBB there is no category.
- */
-
- /***
- * Copy Forum
- */
- function copy_Forums()
- {
- global $db;
-
- $htmlblock = array('<h2>Forums</h2>', '<ul>');
-
- // Clean up Forums
-
- array_push( $htmlblock, '<li>Cleanning up ... </li>' );
-
- $sql = sprintf("TRUNCATE %s.%sforums;",
- $db->db_phpbb_db,
- $db->db_phpbb_tbl );
-
- $db->query( $sql );
-
- // Copy Forums
-
- array_push($htmlblock,'<li>Copying ... </li>');
-
- $sql = sprintf("INSERT INTO %s.%sforums (forum_name,
- forum_desc,
- forum_topics,
- forum_topics_real,
- forum_type,
- forum_posts) SELECT forum_name,
- forum_desc,
- forum_topics,
- forum_topics,
- (SELECT 1 AS forum_type),
- forum_posts FROM %s.%sbb_forums;",
- $db->db_phpbb_db, $db->db_phpbb_tbl,
- $db->db_xoops_db, $db->db_xoops_tbl);
-
- $db->query( $sql );
-
- // Get forums recently added and update their order, ownership, and type.
-
- $sql = sprintf('SELECT forum_id, left_id, right_id FROM %s.%sforums;',
- $db->db_phpbb_db,
- $db->db_phpbb_tbl );
-
- $result = $db->query( $sql );
-
- // Sanitize forum's order one by one
-
- $left_id = 1;
- $right_id = 2;
- $counter = 0;
-
- while ( $row = mysql_fetch_array( $result ) )
- {
- $sql = sprintf("UPDATE %s.%sforums SET left_id = %d, right_id = %d WHERE forum_id = %d;",
- $db->db_phpbb_db,
- $db->db_phpbb_tbl,
- $left_id,
- $right_id,
- $row['forum_id']);
-
- $db->query( $sql );
-
- $left_id = $left_id + 2;
- $right_id = $left_id + 1;
-
- // Counter
-
- $counter++;
- }
-
- // Get amount of forums copied.
- array_push( $htmlblock, '<li>' . $counter . ' forum(s) copied successfully.</li>', '</ul>');
-
- return $htmlblock;
- }
-
- /***
- * Topics
- *
- * When doing Topic copying the user used will be administrator. This means
- * that all topics and posts after migration will be own by the
- * administrator user.
- */
- function copy_Topics()
- {
- global $db;
-
- $htmlblock = array('<h2>Topics</h2>','<ul>');
-
- // Claen up topics
-
- array_push( $htmlblock, '<li>Cleanning up ... </li>' );
-
- $sql = sprintf("TRUNCATE %s.%stopics;",
- $db->db_phpbb_db,
- $db->db_phpbb_tbl );
-
- $db->query( $sql );
-
- // Copy topics
-
- array_push( $htmlblock, '<li>Copying ... </li>' );
-
- $sql = sprintf("INSERT INTO %s.%stopics (forum_id,
- topic_title,
- topic_time,
- topic_last_post_time,
- topic_views,
- topic_last_poster_id,
- topic_poster,
- topic_replies,
- topic_replies_real) SELECT forum_id,
- topic_title,
- topic_time,
- topic_time,
- topic_views,
- (SELECT 2 AS last_poster_id),
- (SELECT 2 AS last_poster_id),
- topic_replies,
- topic_replies
- FROM %s.%sbb_topics",
- $db->db_phpbb_db, $db->db_phpbb_tbl,
- $db->db_xoops_db, $db->db_xoops_tbl );
-
- $db->query( $sql );
-
- array_push( $htmlblock, '<li>' . mysql_affected_rows() . ' topic(s) copied successfully.</li>', '</ul>' );
-
- return $htmlblock;
- }
-
- /***
- * Posts
- */
- function copy_Posts()
- {
- global $db;
-
- $htmlblock = array('<h2>Posts</h2>','<ul>');
-
- // Clean Up posts
-
- array_push($htmlblock,'<li>Cleanning up ... </li>');
-
- $sql = sprintf("TRUNCATE %s.%sposts;", $db->db_phpbb_db, $db->db_phpbb_tbl);
-
- $db->query( $sql );
-
- // Copy Posts
-
- array_push( $htmlblock, '<li>Copying ... </li>');
-
- $sql = sprintf("INSERT INTO %s.%sposts (topic_id,
- forum_id,
- poster_id,
- post_time,
- post_subject,
- post_text) SELECT t1.topic_id,
- t1.forum_id,
- (SELECT 2 AS poster_id),
- t1.post_time,
- t1.subject,
- t2.post_text
- FROM %s.%sbb_posts t1
- LEFT JOIN %s.%sbb_posts_text t2
- ON t2.post_id = t1.post_id;",
- $db->db_phpbb_db, $db->db_phpbb_tbl,
- $db->db_xoops_db, $db->db_xoops_tbl,
- $db->db_xoops_db, $db->db_xoops_tbl);
-
- $db->query( $sql );
-
- array_push( $htmlblock, '<li>' . mysql_affected_rows() .' posts(s) copied successfully.</li>', '</ul>');
-
- return $htmlblock;
- }
-
- /***
- * Generate random password
- */
- function get_randomPass()
- {
- // Add lower case letters
- $seed = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h',
- 'i', 'j', 'k', 'i', 'l', 'm', 'n', 'o',
- 'p', 'q', 'r', 's', 't', 'u', 'v', 'x',
- 'y', 'z');
-
- // Add upper case letters
- foreach ( $seed as $value )
- {
- array_push( $seed, strtoupper($value) );
- }
-
- // Add numbers
- array_push( $seed, '1', '2', '3', '4', '5', '6', '7', '8', '9', '0' );
-
- // Use some symbols chars
- array_push( $seed, '!', '@', '#', '$', '%', '=', '/','+' );
-
- // Build password based on seed
- $userPassword = '';
- $passwordLength = 20;
- for ($i = 0; $i < $passwordLength; $i++)
- {
- $userPassword = $userPassword . $seed[array_rand($seed)];
- }
-
- return $userPassword;
- }
-
- /***
- * Class Destruct
- * ----------------------------------------------------
- */
-
- function __destruct()
- {
- }
-}
-
-$newbb_to_phpbb = new NEWBB_TO_PHPBB;
-?>
diff --git a/Scripts/Newbb2Phpbb/contents/content.php b/Scripts/Newbb2Phpbb/contents/content.php
deleted file mode 100755
index b1cbb49..0000000
--- a/Scripts/Newbb2Phpbb/contents/content.php
+++ /dev/null
@@ -1,17 +0,0 @@
-<?php
-
- // Content
- $action = isset($_GET['p'])?$_GET['p']:'';
- $action = strtolower( $action );
- switch ( $action )
- {
- case 'help';
- $page = 'p_help.php';
- break;
-
- default:
- $page = 'p_main.php';
- }
-
- require_once('contents/' . $page);
-?>
diff --git a/Scripts/Newbb2Phpbb/contents/footer.php b/Scripts/Newbb2Phpbb/contents/footer.php
deleted file mode 100755
index 0c54f0d..0000000
--- a/Scripts/Newbb2Phpbb/contents/footer.php
+++ /dev/null
@@ -1,6 +0,0 @@
-<?php
- array_push($htmlblock,'</div>',
- '<div id="footer"></div>',
- '</body>',
- '</html>');
-?>
diff --git a/Scripts/Newbb2Phpbb/contents/header.php b/Scripts/Newbb2Phpbb/contents/header.php
deleted file mode 100755
index 9b9851d..0000000
--- a/Scripts/Newbb2Phpbb/contents/header.php
+++ /dev/null
@@ -1,27 +0,0 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-<?php
- $htmlblock = array('<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">',
- '<head>',
- '<meta http-equiv="content-type" content="text/html; charset=UTF-8">',
- '<title>newbb to phpbb :: Migrating Xoops+CBB(newbb) to phpBB</title>',
- '<link rel="stylesheet" href="style.css" type="text/css" media="screen" />',
- '</head>',
- '<body>',
- '<div id="header">',
- '<h1>newbb to phpbb</h1>',
- '<p class="description">Migrating from Xoops+CBB(newbb) to phpBB+LDAP</p>');
-
- # Navigation bar
- $htmlblock = array_merge($htmlblock, $html->get_navibar());
-
- array_push($htmlblock, '<div class="pageline">','</div>');
- array_push($htmlblock, '</div>');
-
- // Where am I in the migration process ?
- if ( ! isset($_GET['p'] ) )
- {
- $htmlblock = array_merge($htmlblock, $html->get_stepPosition());
- }
-
- array_push($htmlblock,'<div id="page">');
-?>
diff --git a/Scripts/Newbb2Phpbb/contents/p_help.php b/Scripts/Newbb2Phpbb/contents/p_help.php
deleted file mode 100755
index 111af2e..0000000
--- a/Scripts/Newbb2Phpbb/contents/p_help.php
+++ /dev/null
@@ -1,36 +0,0 @@
-<?php
-
-$lisence = "<pre>
- newbb to phpbb :: Migrating from Xoops+CBB(newbb) to phpBB+LDAP
- Copyright (C) 2009 Alain Reguera Delgado
-
- This program is free software; you can redistribute it and/or modify
- it under the terms of the GNU General Public License as published by
- the Free Software Foundation; either version 2 of the License, or
- (at your option) any later version.
-
- 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 more details.
-
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
-</pre>";
-
-array_push($htmlblock,'<h1>Help</h1>', '<hr />',
- '<h2>About</h2>',
- '<p><strong>newbb to phpbb</strong> do two things mainly:</p>',
- '<ol>',
- '<li>Migrate users from Xoops to LDAP.</li>',
- '<li>Migrate Forums, Topics, and Posts from Xoops\' CBB module (a.k.a newbb) to phpBB3.</li>',
- '</ol>',
- '<p>Documentation works are in the <a href="http://wiki.centos.org/WebsiteVer2/forums/newbb_to_phpbb">project\'s page.</a></p>',
- '<h2>Authors</h2>',
- '<ul>',
- '<li>Alain Reguera Delgado <a href="mailto:alain.reguera@gmail.com"><alain.reguera@gmail.com></a> (maintainer)</li>',
- '<li>Marcus Moeller < ? ></li>',
- '</ul>',
- '<h2>Lisence</h2>',
- $lisence);
diff --git a/Scripts/Newbb2Phpbb/contents/p_main.php b/Scripts/Newbb2Phpbb/contents/p_main.php
deleted file mode 100755
index 75f66c9..0000000
--- a/Scripts/Newbb2Phpbb/contents/p_main.php
+++ /dev/null
@@ -1,59 +0,0 @@
-<?php
-/***
- * p_convert.php:
- *
- */
-
- $next_step = isset($_POST['step'])?$_POST['step']:0;
- array_push($htmlblock,'<form action="" method="post">');
- // Configuration
- if ( $next_step == 0 )
- {
- $next_step++;
- array_push($htmlblock,'<h1>Configuration</h1>', '<hr />');
- $htmlblock = array_merge($htmlblock,$ldap->get_configForm());
- $htmlblock = array_merge($htmlblock,$db->get_configForm());
- $htmlblock = array_merge($htmlblock,$mail->get_configForm());
-
- array_push($htmlblock, '<p class="action right">',
- '<span class="floatl"><img src="img/reload.png" alt="Reload" /><a href="?action=restore">Reload default configuration</a></span>
- <input type="hidden" name="step" value="'.$next_step.'" />',
- '<span><input type="submit" name="Next" value="Verify Configuration" /></span>',
- '</p>');
- }
-
- // Verification
- else if ( $next_step == 1 )
- {
- array_push($htmlblock,'<h1>Verification</h1>',
- '<hr />',
- $newbb_to_phpbb->config_verification( $next_step ));
- }
-
- // Migration
- else if ( $next_step == 2 )
- {
- array_push($htmlblock,'<h1>Migration</h1>', '<hr />');
- $htmlblock = array_merge($htmlblock, $newbb_to_phpbb->copy_Forums(),
- $newbb_to_phpbb->copy_Users(),
- $newbb_to_phpbb->copy_Topics(),
- $newbb_to_phpbb->copy_Posts());
- $next_step++;
- array_push($htmlblock,'<p class="action right">
- <input type="hidden" name="step" value="'.$next_step.'" />
- <input type="submit" name="Next" value="Next" />
- </p>');
- }
-
- // Reset Passwords
- else if ( $next_step == 3 )
- {
- $next_step++;
- array_push($htmlblock,'<h1>Reset Passwords</h1>', '<hr />');
- $htmlblock = array_merge($htmlblock, $ldap->get_userList());
- array_push($htmlblock,'<p class="action right"><strong>That\'s all!</strong> <img src="img/smile.png" alt="smile" /></p>');
- }
-
- array_push($htmlblock,'</form>');
-
-?>
diff --git a/Scripts/Newbb2Phpbb/img/header-bg.png b/Scripts/Newbb2Phpbb/img/header-bg.png
deleted file mode 100755
index ff2a7b0..0000000
Binary files a/Scripts/Newbb2Phpbb/img/header-bg.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/html-bg.png b/Scripts/Newbb2Phpbb/img/html-bg.png
deleted file mode 100755
index 30f7d70..0000000
Binary files a/Scripts/Newbb2Phpbb/img/html-bg.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-blue.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-blue.png
deleted file mode 100755
index 7a816cf..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-blue.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-gray.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-gray.png
deleted file mode 100755
index 43d1a55..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-gray.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-green.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-green.png
deleted file mode 100755
index f4ca7ca..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-green.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-orange.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-orange.png
deleted file mode 100755
index 25a57b5..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-orange.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-red.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-red.png
deleted file mode 100755
index 2dfcf09..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-red.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/moin-msg-bg-violet.png b/Scripts/Newbb2Phpbb/img/moin-msg-bg-violet.png
deleted file mode 100755
index 657824d..0000000
Binary files a/Scripts/Newbb2Phpbb/img/moin-msg-bg-violet.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/navibartop-bg.png b/Scripts/Newbb2Phpbb/img/navibartop-bg.png
deleted file mode 100755
index 936da33..0000000
Binary files a/Scripts/Newbb2Phpbb/img/navibartop-bg.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/navibartop-hover-bg.png b/Scripts/Newbb2Phpbb/img/navibartop-hover-bg.png
deleted file mode 100755
index 1d5596e..0000000
Binary files a/Scripts/Newbb2Phpbb/img/navibartop-hover-bg.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/previous.png b/Scripts/Newbb2Phpbb/img/previous.png
deleted file mode 100644
index d3bc514..0000000
Binary files a/Scripts/Newbb2Phpbb/img/previous.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/reload.png b/Scripts/Newbb2Phpbb/img/reload.png
deleted file mode 100644
index e46da27..0000000
Binary files a/Scripts/Newbb2Phpbb/img/reload.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/img/smile.png b/Scripts/Newbb2Phpbb/img/smile.png
deleted file mode 100755
index 44cc239..0000000
Binary files a/Scripts/Newbb2Phpbb/img/smile.png and /dev/null differ
diff --git a/Scripts/Newbb2Phpbb/index.php b/Scripts/Newbb2Phpbb/index.php
deleted file mode 100755
index 58d93dc..0000000
--- a/Scripts/Newbb2Phpbb/index.php
+++ /dev/null
@@ -1,13 +0,0 @@
-<?php
- require_once('classes/newbb_to_phpbb.php');
- require_once('classes/ldap.php');
- require_once('classes/db_mysql.php');
- require_once('classes/html.php');
- require_once('classes/mail.php');
-
- require_once('contents/header.php');
- require_once('contents/content.php');
- require_once('contents/footer.php');
-
- echo $html->format_htmlblock( $htmlblock );
-?>
diff --git a/Scripts/Newbb2Phpbb/schemas/newbb-mysql.sql b/Scripts/Newbb2Phpbb/schemas/newbb-mysql.sql
deleted file mode 100755
index a3f14f6..0000000
--- a/Scripts/Newbb2Phpbb/schemas/newbb-mysql.sql
+++ /dev/null
@@ -1,311 +0,0 @@
--- phpMyAdmin SQL Dump
--- version 2.6.4-pl4
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: May 07, 2006 at 01:26 PM
--- Server version: 5.0.16
--- PHP Version: 5.1.0
---
--- CBB 3.04
---
---
--- Database: `cbb`
---
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_archive`
---
-
-CREATE TABLE `bb_archive` (
- `topic_id` int(8) unsigned NOT NULL default '0',
- `post_id` int(10) unsigned NOT NULL default '0',
- `post_text` text NOT NULL
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_attachments`
---
-
-CREATE TABLE `bb_attachments` (
- `attach_id` int(8) unsigned NOT NULL auto_increment,
- `post_id` int(10) unsigned NOT NULL default '0',
- `name_saved` varchar(255) NOT NULL default '',
- `name_disp` varchar(255) NOT NULL default '',
- `mimetype` varchar(255) NOT NULL default '',
- `online` tinyint(1) unsigned NOT NULL default '1',
- `attach_time` int(10) unsigned NOT NULL default '0',
- `download` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`attach_id`),
- KEY `post_id` (`post_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_categories`
---
-
-CREATE TABLE `bb_categories` (
- `cat_id` smallint(3) unsigned NOT NULL auto_increment,
- `cat_image` varchar(50) NOT NULL default '',
- `cat_title` varchar(100) NOT NULL default '',
- `cat_description` text NOT NULL,
- `cat_order` smallint(3) unsigned NOT NULL default '0',
- `cat_url` varchar(255) NOT NULL default '',
- PRIMARY KEY (`cat_id`),
- KEY `cat_order` (`cat_order`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_digest`
---
-
-CREATE TABLE `bb_digest` (
- `digest_id` int(8) unsigned NOT NULL auto_increment,
- `digest_time` int(10) unsigned NOT NULL default '0',
- `digest_content` text,
- PRIMARY KEY (`digest_id`),
- KEY `digest_time` (`digest_time`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_forums`
---
-
-CREATE TABLE `bb_forums` (
- `forum_id` smallint(4) unsigned NOT NULL auto_increment,
- `forum_name` varchar(150) NOT NULL default '',
- `forum_desc` text,
- `parent_forum` smallint(4) unsigned NOT NULL default '0',
- `forum_moderator` varchar(255) NOT NULL default '',
- `forum_topics` int(8) unsigned NOT NULL default '0',
- `forum_posts` int(10) unsigned NOT NULL default '0',
- `forum_last_post_id` int(10) unsigned NOT NULL default '0',
- `cat_id` smallint(3) unsigned NOT NULL default '0',
- `forum_type` tinyint(1) unsigned NOT NULL default '0',
- `allow_html` tinyint(1) unsigned NOT NULL default '1',
- `allow_sig` tinyint(1) unsigned NOT NULL default '1',
- `allow_subject_prefix` tinyint(1) unsigned NOT NULL default '0',
- `hot_threshold` tinyint(3) unsigned NOT NULL default '10',
- `forum_order` smallint(4) unsigned NOT NULL default '0',
-# `allow_attachments` tinyint(1) unsigned NOT NULL default '1',
- `attach_maxkb` smallint(3) unsigned NOT NULL default '1000',
- `attach_ext` varchar(255) NOT NULL default '',
- `allow_polls` tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (`forum_id`),
- KEY `forum_last_post_id` (`forum_last_post_id`),
- KEY `cat_forum` (`cat_id`,`forum_order`),
- KEY `forum_order` (`forum_order`),
- KEY `cat_id` (`cat_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_moderates`
---
-
-CREATE TABLE `bb_moderates` (
- `mod_id` int(10) unsigned NOT NULL auto_increment,
- `mod_start` int(10) unsigned NOT NULL default '0',
- `mod_end` int(10) unsigned NOT NULL default '0',
- `mod_desc` varchar(255) NOT NULL default '',
- `uid` int(10) unsigned NOT NULL default '0',
- `ip` varchar(32) NOT NULL default '',
- `forum_id` smallint(4) unsigned NOT NULL default '0',
- PRIMARY KEY (`mod_id`),
- KEY `uid` (`uid`),
- KEY `mod_end` (`mod_end`),
- KEY `forum_id` (`forum_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_online`
---
-
-CREATE TABLE `bb_online` (
- `online_forum` int(10) unsigned NOT NULL default '0',
- `online_topic` int(8) unsigned NOT NULL default '0',
- `online_uid` int(10) unsigned NOT NULL default '0',
- `online_uname` varchar(255) NOT NULL default '',
- `online_ip` varchar(32) NOT NULL default '',
- `online_updated` int(10) unsigned NOT NULL default '0',
- KEY `online_forum` (`online_forum`),
- KEY `online_topic` (`online_topic`),
- KEY `online_updated` (`online_updated`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_posts`
---
-
-CREATE TABLE `bb_posts` (
- `post_id` int(10) unsigned NOT NULL auto_increment,
- `pid` int(10) unsigned NOT NULL default '0',
- `topic_id` int(8) unsigned NOT NULL default '0',
- `forum_id` smallint(4) unsigned NOT NULL default '0',
- `post_time` int(10) unsigned NOT NULL default '0',
- `uid` int(10) unsigned NOT NULL default '0',
- `poster_name` varchar(255) NOT NULL default '',
- `poster_ip` int(11) NOT NULL default '0',
- `subject` varchar(255) NOT NULL default '',
- `dohtml` tinyint(1) unsigned NOT NULL default '0',
- `dosmiley` tinyint(1) unsigned NOT NULL default '1',
- `doxcode` tinyint(1) unsigned NOT NULL default '1',
- `dobr` tinyint(1) unsigned NOT NULL default '1',
- `doimage` tinyint(1) unsigned NOT NULL default '1',
- `icon` varchar(25) NOT NULL default '',
- `attachsig` tinyint(1) unsigned NOT NULL default '0',
- `approved` smallint(2) NOT NULL default '1',
- `post_karma` int(10) unsigned NOT NULL default '0',
- `attachment` text,
- `require_reply` tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (`post_id`),
- KEY `uid` (`uid`),
- KEY `pid` (`pid`),
- KEY `forum_id` (`forum_id`),
- KEY `topic_id` (`topic_id`),
- KEY `subject` (`subject`(40)),
- KEY `forumid_uid` (`forum_id`,`uid`),
- KEY `topicid_uid` (`topic_id`,`uid`),
- KEY `post_time` (`post_time`),
- KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
- FULLTEXT KEY `search` (`subject`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_posts_text`
---
-
-CREATE TABLE `bb_posts_text` (
- `post_id` int(10) unsigned NOT NULL default '0',
- `post_text` text,
- `post_edit` text,
- PRIMARY KEY (`post_id`),
- FULLTEXT KEY `search` (`post_text`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_reads_forum`
---
-
-CREATE TABLE `bb_reads_forum` (
- `read_id` int(10) unsigned NOT NULL auto_increment,
- `uid` int(10) unsigned NOT NULL default '0',
- `read_time` int(10) unsigned NOT NULL default '0',
- `read_item` smallint(4) unsigned NOT NULL default '0',
- `post_id` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`read_id`),
- KEY `uid` (`uid`),
- KEY `read_item` (`read_item`),
- KEY `post_id` (`post_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_reads_topic`
---
-
-CREATE TABLE `bb_reads_topic` (
- `read_id` int(10) unsigned NOT NULL auto_increment,
- `uid` int(10) unsigned NOT NULL default '0',
- `read_time` int(10) unsigned NOT NULL default '0',
- `read_item` int(8) unsigned NOT NULL default '0',
- `post_id` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`read_id`),
- KEY `uid` (`uid`),
- KEY `read_item` (`read_item`),
- KEY `post_id` (`post_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_report`
---
-
-CREATE TABLE `bb_report` (
- `report_id` int(8) unsigned NOT NULL auto_increment,
- `post_id` int(10) unsigned NOT NULL default '0',
- `reporter_uid` int(10) unsigned NOT NULL default '0',
- `reporter_ip` int(11) NOT NULL default '0',
- `report_time` int(10) unsigned NOT NULL default '0',
- `report_text` varchar(255) NOT NULL default '',
- `report_result` tinyint(1) unsigned NOT NULL default '0',
- `report_memo` varchar(255) NOT NULL default '',
- PRIMARY KEY (`report_id`),
- KEY `post_id` (`post_id`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_topics`
---
-
-CREATE TABLE `bb_topics` (
- `topic_id` int(8) unsigned NOT NULL auto_increment,
- `topic_title` varchar(255) NOT NULL default '',
- `topic_poster` int(10) unsigned NOT NULL default '0',
- `topic_time` int(10) unsigned NOT NULL default '0',
- `topic_views` int(10) unsigned NOT NULL default '0',
- `topic_replies` mediumint(8) unsigned NOT NULL default '0',
- `topic_last_post_id` int(8) unsigned NOT NULL default '0',
- `forum_id` smallint(4) unsigned NOT NULL default '0',
- `topic_status` tinyint(1) unsigned NOT NULL default '0',
- `topic_subject` smallint(3) unsigned NOT NULL default '0',
- `topic_sticky` tinyint(1) unsigned NOT NULL default '0',
- `topic_digest` tinyint(1) unsigned NOT NULL default '0',
- `digest_time` int(10) unsigned NOT NULL default '0',
- `approved` tinyint(2) NOT NULL default '1',
- `poster_name` varchar(255) NOT NULL default '',
- `rating` double(6,4) NOT NULL default '0.0000',
- `votes` int(11) unsigned NOT NULL default '0',
- `topic_haspoll` tinyint(1) unsigned NOT NULL default '0',
- `poll_id` mediumint(8) unsigned NOT NULL default '0',
- PRIMARY KEY (`topic_id`),
- KEY `forum_id` (`forum_id`),
- KEY `topic_last_post_id` (`topic_last_post_id`),
- KEY `topic_poster` (`topic_poster`),
- KEY `topic_forum` (`topic_id`,`forum_id`),
- KEY `topic_sticky` (`topic_sticky`),
- KEY `topic_digest` (`topic_digest`),
- KEY `digest_time` (`digest_time`)
-) TYPE=MyISAM;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `bb_votedata`
---
-
-CREATE TABLE `bb_votedata` (
- `ratingid` int(11) unsigned NOT NULL auto_increment,
- `topic_id` int(8) unsigned NOT NULL default '0',
- `ratinguser` int(10) unsigned NOT NULL default '0',
- `rating` tinyint(3) unsigned NOT NULL default '0',
- `ratinghostname` varchar(60) NOT NULL default '',
- `ratingtimestamp` int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (`ratingid`),
- KEY `ratinguser` (`ratinguser`),
- KEY `ratinghostname` (`ratinghostname`),
- KEY `topic_id` (`topic_id`)
-) TYPE=MyISAM;
diff --git a/Scripts/Newbb2Phpbb/schemas/phpBB3_mysql_41_schema.sql b/Scripts/Newbb2Phpbb/schemas/phpBB3_mysql_41_schema.sql
deleted file mode 100755
index ad25ef5..0000000
--- a/Scripts/Newbb2Phpbb/schemas/phpBB3_mysql_41_schema.sql
+++ /dev/null
@@ -1,1003 +0,0 @@
-#
-# $Id: mysql_41_schema.sql 9129 2008-11-27 13:44:24Z acydburn $
-#
-
-# Table: 'phpbb_attachments'
-CREATE TABLE phpbb_attachments (
- attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- physical_filename varchar(255) DEFAULT '' NOT NULL,
- real_filename varchar(255) DEFAULT '' NOT NULL,
- download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- attach_comment text NOT NULL,
- extension varchar(100) DEFAULT '' NOT NULL,
- mimetype varchar(100) DEFAULT '' NOT NULL,
- filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
- filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
- thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (attach_id),
- KEY filetime (filetime),
- KEY post_msg_id (post_msg_id),
- KEY topic_id (topic_id),
- KEY poster_id (poster_id),
- KEY is_orphan (is_orphan)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_acl_groups'
-CREATE TABLE phpbb_acl_groups (
- group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_setting tinyint(2) DEFAULT '0' NOT NULL,
- KEY group_id (group_id),
- KEY auth_opt_id (auth_option_id),
- KEY auth_role_id (auth_role_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_acl_options'
-CREATE TABLE phpbb_acl_options (
- auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- auth_option varchar(50) DEFAULT '' NOT NULL,
- is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (auth_option_id),
- KEY auth_option (auth_option)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_acl_roles'
-CREATE TABLE phpbb_acl_roles (
- role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- role_name varchar(255) DEFAULT '' NOT NULL,
- role_description text NOT NULL,
- role_type varchar(10) DEFAULT '' NOT NULL,
- role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (role_id),
- KEY role_type (role_type),
- KEY role_order (role_order)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_acl_roles_data'
-CREATE TABLE phpbb_acl_roles_data (
- role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_setting tinyint(2) DEFAULT '0' NOT NULL,
- PRIMARY KEY (role_id, auth_option_id),
- KEY ath_op_id (auth_option_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_acl_users'
-CREATE TABLE phpbb_acl_users (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- auth_setting tinyint(2) DEFAULT '0' NOT NULL,
- KEY user_id (user_id),
- KEY auth_option_id (auth_option_id),
- KEY auth_role_id (auth_role_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_banlist'
-CREATE TABLE phpbb_banlist (
- ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- ban_ip varchar(40) DEFAULT '' NOT NULL,
- ban_email varchar(100) DEFAULT '' NOT NULL,
- ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
- ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
- ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- ban_reason varchar(255) DEFAULT '' NOT NULL,
- ban_give_reason varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (ban_id),
- KEY ban_end (ban_end),
- KEY ban_user (ban_userid, ban_exclude),
- KEY ban_email (ban_email, ban_exclude),
- KEY ban_ip (ban_ip, ban_exclude)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_bbcodes'
-CREATE TABLE phpbb_bbcodes (
- bbcode_id tinyint(3) DEFAULT '0' NOT NULL,
- bbcode_tag varchar(16) DEFAULT '' NOT NULL,
- bbcode_helpline varchar(255) DEFAULT '' NOT NULL,
- display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- bbcode_match text NOT NULL,
- bbcode_tpl mediumtext NOT NULL,
- first_pass_match mediumtext NOT NULL,
- first_pass_replace mediumtext NOT NULL,
- second_pass_match mediumtext NOT NULL,
- second_pass_replace mediumtext NOT NULL,
- PRIMARY KEY (bbcode_id),
- KEY display_on_post (display_on_posting)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_bookmarks'
-CREATE TABLE phpbb_bookmarks (
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (topic_id, user_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_bots'
-CREATE TABLE phpbb_bots (
- bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- bot_name varchar(255) DEFAULT '' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- bot_agent varchar(255) DEFAULT '' NOT NULL,
- bot_ip varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (bot_id),
- KEY bot_active (bot_active)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_config'
-CREATE TABLE phpbb_config (
- config_name varchar(255) DEFAULT '' NOT NULL,
- config_value varchar(255) DEFAULT '' NOT NULL,
- is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (config_name),
- KEY is_dynamic (is_dynamic)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_confirm'
-CREATE TABLE phpbb_confirm (
- confirm_id char(32) DEFAULT '' NOT NULL,
- session_id char(32) DEFAULT '' NOT NULL,
- confirm_type tinyint(3) DEFAULT '0' NOT NULL,
- code varchar(8) DEFAULT '' NOT NULL,
- seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (session_id, confirm_id),
- KEY confirm_type (confirm_type)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_disallow'
-CREATE TABLE phpbb_disallow (
- disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- disallow_username varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (disallow_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_drafts'
-CREATE TABLE phpbb_drafts (
- draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- draft_subject varchar(255) DEFAULT '' NOT NULL,
- draft_message mediumtext NOT NULL,
- PRIMARY KEY (draft_id),
- KEY save_time (save_time)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_extensions'
-CREATE TABLE phpbb_extensions (
- extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- extension varchar(100) DEFAULT '' NOT NULL,
- PRIMARY KEY (extension_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_extension_groups'
-CREATE TABLE phpbb_extension_groups (
- group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- group_name varchar(255) DEFAULT '' NOT NULL,
- cat_id tinyint(2) DEFAULT '0' NOT NULL,
- allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- upload_icon varchar(255) DEFAULT '' NOT NULL,
- max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
- allowed_forums text NOT NULL,
- allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (group_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_forums'
-CREATE TABLE phpbb_forums (
- forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_parents mediumtext NOT NULL,
- forum_name varchar(255) DEFAULT '' NOT NULL,
- forum_desc text NOT NULL,
- forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
- forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
- forum_desc_uid varchar(8) DEFAULT '' NOT NULL,
- forum_link varchar(255) DEFAULT '' NOT NULL,
- forum_password varchar(40) DEFAULT '' NOT NULL,
- forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_image varchar(255) DEFAULT '' NOT NULL,
- forum_rules text NOT NULL,
- forum_rules_link varchar(255) DEFAULT '' NOT NULL,
- forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL,
- forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
- forum_rules_uid varchar(8) DEFAULT '' NOT NULL,
- forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
- forum_type tinyint(4) DEFAULT '0' NOT NULL,
- forum_status tinyint(4) DEFAULT '0' NOT NULL,
- forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_last_post_subject varchar(255) DEFAULT '' NOT NULL,
- forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,
- forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
- forum_flags tinyint(4) DEFAULT '32' NOT NULL,
- display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
- prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (forum_id),
- KEY left_right_id (left_id, right_id),
- KEY forum_lastpost_id (forum_last_post_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_forums_access'
-CREATE TABLE phpbb_forums_access (
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- session_id char(32) DEFAULT '' NOT NULL,
- PRIMARY KEY (forum_id, user_id, session_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_forums_track'
-CREATE TABLE phpbb_forums_track (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (user_id, forum_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_forums_watch'
-CREATE TABLE phpbb_forums_watch (
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- KEY forum_id (forum_id),
- KEY user_id (user_id),
- KEY notify_stat (notify_status)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_groups'
-CREATE TABLE phpbb_groups (
- group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- group_type tinyint(4) DEFAULT '1' NOT NULL,
- group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- group_name varchar(255) DEFAULT '' NOT NULL,
- group_desc text NOT NULL,
- group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,
- group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
- group_desc_uid varchar(8) DEFAULT '' NOT NULL,
- group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- group_avatar varchar(255) DEFAULT '' NOT NULL,
- group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
- group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_colour varchar(6) DEFAULT '' NOT NULL,
- group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- PRIMARY KEY (group_id),
- KEY group_legend_name (group_legend, group_name)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_icons'
-CREATE TABLE phpbb_icons (
- icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- icons_url varchar(255) DEFAULT '' NOT NULL,
- icons_width tinyint(4) DEFAULT '0' NOT NULL,
- icons_height tinyint(4) DEFAULT '0' NOT NULL,
- icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- PRIMARY KEY (icons_id),
- KEY display_on_posting (display_on_posting)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_lang'
-CREATE TABLE phpbb_lang (
- lang_id tinyint(4) NOT NULL auto_increment,
- lang_iso varchar(30) DEFAULT '' NOT NULL,
- lang_dir varchar(30) DEFAULT '' NOT NULL,
- lang_english_name varchar(100) DEFAULT '' NOT NULL,
- lang_local_name varchar(255) DEFAULT '' NOT NULL,
- lang_author varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (lang_id),
- KEY lang_iso (lang_iso)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_log'
-CREATE TABLE phpbb_log (
- log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- log_type tinyint(4) DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- log_ip varchar(40) DEFAULT '' NOT NULL,
- log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- log_operation text NOT NULL,
- log_data mediumtext NOT NULL,
- PRIMARY KEY (log_id),
- KEY log_type (log_type),
- KEY forum_id (forum_id),
- KEY topic_id (topic_id),
- KEY reportee_id (reportee_id),
- KEY user_id (user_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_moderator_cache'
-CREATE TABLE phpbb_moderator_cache (
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- username varchar(255) DEFAULT '' NOT NULL,
- group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_name varchar(255) DEFAULT '' NOT NULL,
- display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- KEY disp_idx (display_on_index),
- KEY forum_id (forum_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_modules'
-CREATE TABLE phpbb_modules (
- module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- module_basename varchar(255) DEFAULT '' NOT NULL,
- module_class varchar(10) DEFAULT '' NOT NULL,
- parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- module_langname varchar(255) DEFAULT '' NOT NULL,
- module_mode varchar(255) DEFAULT '' NOT NULL,
- module_auth varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (module_id),
- KEY left_right_id (left_id, right_id),
- KEY module_enabled (module_enabled),
- KEY class_left_id (module_class, left_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_poll_options'
-CREATE TABLE phpbb_poll_options (
- poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poll_option_text text NOT NULL,
- poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- KEY poll_opt_id (poll_option_id),
- KEY topic_id (topic_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_poll_votes'
-CREATE TABLE phpbb_poll_votes (
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
- vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- vote_user_ip varchar(40) DEFAULT '' NOT NULL,
- KEY topic_id (topic_id),
- KEY vote_user_id (vote_user_id),
- KEY vote_user_ip (vote_user_ip)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_posts'
-CREATE TABLE phpbb_posts (
- post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poster_ip varchar(40) DEFAULT '' NOT NULL,
- post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- post_username varchar(255) DEFAULT '' NOT NULL,
- post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
- post_text mediumtext NOT NULL,
- post_checksum varchar(32) DEFAULT '' NOT NULL,
- post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
- bbcode_uid varchar(8) DEFAULT '' NOT NULL,
- post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- post_edit_reason varchar(255) DEFAULT '' NOT NULL,
- post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (post_id),
- KEY forum_id (forum_id),
- KEY topic_id (topic_id),
- KEY poster_ip (poster_ip),
- KEY poster_id (poster_id),
- KEY post_approved (post_approved),
- KEY tid_post_time (topic_id, post_time)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_privmsgs'
-CREATE TABLE phpbb_privmsgs (
- msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- author_ip varchar(40) DEFAULT '' NOT NULL,
- message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- message_subject varchar(255) DEFAULT '' NOT NULL,
- message_text mediumtext NOT NULL,
- message_edit_reason varchar(255) DEFAULT '' NOT NULL,
- message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
- bbcode_uid varchar(8) DEFAULT '' NOT NULL,
- message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- to_address text NOT NULL,
- bcc_address text NOT NULL,
- PRIMARY KEY (msg_id),
- KEY author_ip (author_ip),
- KEY message_time (message_time),
- KEY author_id (author_id),
- KEY root_level (root_level)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_privmsgs_folder'
-CREATE TABLE phpbb_privmsgs_folder (
- folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- folder_name varchar(255) DEFAULT '' NOT NULL,
- pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (folder_id),
- KEY user_id (user_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_privmsgs_rules'
-CREATE TABLE phpbb_privmsgs_rules (
- rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_string varchar(255) DEFAULT '' NOT NULL,
- rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rule_folder_id int(11) DEFAULT '0' NOT NULL,
- PRIMARY KEY (rule_id),
- KEY user_id (user_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_privmsgs_to'
-CREATE TABLE phpbb_privmsgs_to (
- msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- folder_id int(11) DEFAULT '0' NOT NULL,
- KEY msg_id (msg_id),
- KEY author_id (author_id),
- KEY usr_flder_id (user_id, folder_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_profile_fields'
-CREATE TABLE phpbb_profile_fields (
- field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- field_name varchar(255) DEFAULT '' NOT NULL,
- field_type tinyint(4) DEFAULT '0' NOT NULL,
- field_ident varchar(20) DEFAULT '' NOT NULL,
- field_length varchar(20) DEFAULT '' NOT NULL,
- field_minlen varchar(255) DEFAULT '' NOT NULL,
- field_maxlen varchar(255) DEFAULT '' NOT NULL,
- field_novalue varchar(255) DEFAULT '' NOT NULL,
- field_default_value varchar(255) DEFAULT '' NOT NULL,
- field_validation varchar(20) DEFAULT '' NOT NULL,
- field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (field_id),
- KEY fld_type (field_type),
- KEY fld_ordr (field_order)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_profile_fields_data'
-CREATE TABLE phpbb_profile_fields_data (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (user_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_profile_fields_lang'
-CREATE TABLE phpbb_profile_fields_lang (
- field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- field_type tinyint(4) DEFAULT '0' NOT NULL,
- lang_value varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (field_id, lang_id, option_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_profile_lang'
-CREATE TABLE phpbb_profile_lang (
- field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- lang_name varchar(255) DEFAULT '' NOT NULL,
- lang_explain text NOT NULL,
- lang_default_value varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (field_id, lang_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_ranks'
-CREATE TABLE phpbb_ranks (
- rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- rank_title varchar(255) DEFAULT '' NOT NULL,
- rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- rank_image varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (rank_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_reports'
-CREATE TABLE phpbb_reports (
- report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- report_text mediumtext NOT NULL,
- PRIMARY KEY (report_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_reports_reasons'
-CREATE TABLE phpbb_reports_reasons (
- reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
- reason_title varchar(255) DEFAULT '' NOT NULL,
- reason_description mediumtext NOT NULL,
- reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (reason_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_search_results'
-CREATE TABLE phpbb_search_results (
- search_key varchar(32) DEFAULT '' NOT NULL,
- search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- search_keywords mediumtext NOT NULL,
- search_authors mediumtext NOT NULL,
- PRIMARY KEY (search_key)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_search_wordlist'
-CREATE TABLE phpbb_search_wordlist (
- word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- word_text varchar(255) DEFAULT '' NOT NULL,
- word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (word_id),
- UNIQUE wrd_txt (word_text),
- KEY wrd_cnt (word_count)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_search_wordmatch'
-CREATE TABLE phpbb_search_wordmatch (
- post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- UNIQUE unq_mtch (word_id, post_id, title_match),
- KEY word_id (word_id),
- KEY post_id (post_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_sessions'
-CREATE TABLE phpbb_sessions (
- session_id char(32) DEFAULT '' NOT NULL,
- session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
- session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
- session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- session_ip varchar(40) DEFAULT '' NOT NULL,
- session_browser varchar(150) DEFAULT '' NOT NULL,
- session_forwarded_for varchar(255) DEFAULT '' NOT NULL,
- session_page varchar(255) DEFAULT '' NOT NULL,
- session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (session_id),
- KEY session_time (session_time),
- KEY session_user_id (session_user_id),
- KEY session_fid (session_forum_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_sessions_keys'
-CREATE TABLE phpbb_sessions_keys (
- key_id char(32) DEFAULT '' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- last_ip varchar(40) DEFAULT '' NOT NULL,
- last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (key_id, user_id),
- KEY last_login (last_login)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_sitelist'
-CREATE TABLE phpbb_sitelist (
- site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- site_ip varchar(40) DEFAULT '' NOT NULL,
- site_hostname varchar(255) DEFAULT '' NOT NULL,
- ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (site_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_smilies'
-CREATE TABLE phpbb_smilies (
- smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- code varchar(50) DEFAULT '' NOT NULL,
- emotion varchar(50) DEFAULT '' NOT NULL,
- smiley_url varchar(50) DEFAULT '' NOT NULL,
- smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- PRIMARY KEY (smiley_id),
- KEY display_on_post (display_on_posting)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles'
-CREATE TABLE phpbb_styles (
- style_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- style_name varchar(255) DEFAULT '' NOT NULL,
- style_copyright varchar(255) DEFAULT '' NOT NULL,
- style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (style_id),
- UNIQUE style_name (style_name),
- KEY template_id (template_id),
- KEY theme_id (theme_id),
- KEY imageset_id (imageset_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles_template'
-CREATE TABLE phpbb_styles_template (
- template_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- template_name varchar(255) DEFAULT '' NOT NULL,
- template_copyright varchar(255) DEFAULT '' NOT NULL,
- template_path varchar(100) DEFAULT '' NOT NULL,
- bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL,
- template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
- template_inherit_path varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (template_id),
- UNIQUE tmplte_nm (template_name)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles_template_data'
-CREATE TABLE phpbb_styles_template_data (
- template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- template_filename varchar(100) DEFAULT '' NOT NULL,
- template_included text NOT NULL,
- template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
- template_data mediumtext NOT NULL,
- KEY tid (template_id),
- KEY tfn (template_filename)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles_theme'
-CREATE TABLE phpbb_styles_theme (
- theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- theme_name varchar(255) DEFAULT '' NOT NULL,
- theme_copyright varchar(255) DEFAULT '' NOT NULL,
- theme_path varchar(100) DEFAULT '' NOT NULL,
- theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
- theme_data mediumtext NOT NULL,
- PRIMARY KEY (theme_id),
- UNIQUE theme_name (theme_name)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles_imageset'
-CREATE TABLE phpbb_styles_imageset (
- imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- imageset_name varchar(255) DEFAULT '' NOT NULL,
- imageset_copyright varchar(255) DEFAULT '' NOT NULL,
- imageset_path varchar(100) DEFAULT '' NOT NULL,
- PRIMARY KEY (imageset_id),
- UNIQUE imgset_nm (imageset_name)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_styles_imageset_data'
-CREATE TABLE phpbb_styles_imageset_data (
- image_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- image_name varchar(200) DEFAULT '' NOT NULL,
- image_filename varchar(200) DEFAULT '' NOT NULL,
- image_lang varchar(30) DEFAULT '' NOT NULL,
- image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (image_id),
- KEY i_d (imageset_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_topics'
-CREATE TABLE phpbb_topics (
- topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- topic_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
- topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
- topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_status tinyint(3) DEFAULT '0' NOT NULL,
- topic_type tinyint(3) DEFAULT '0' NOT NULL,
- topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_first_poster_name varchar(255) DEFAULT '' NOT NULL,
- topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL,
- topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_last_poster_name varchar(255) DEFAULT '' NOT NULL,
- topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL,
- topic_last_post_subject varchar(255) DEFAULT '' NOT NULL,
- topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poll_title varchar(255) DEFAULT '' NOT NULL,
- poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
- poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
- poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
- poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
- poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (topic_id),
- KEY forum_id (forum_id),
- KEY forum_id_type (forum_id, topic_type),
- KEY last_post_time (topic_last_post_time),
- KEY topic_approved (topic_approved),
- KEY forum_appr_last (forum_id, topic_approved, topic_last_post_id),
- KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_topics_track'
-CREATE TABLE phpbb_topics_track (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (user_id, topic_id),
- KEY forum_id (forum_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_topics_posted'
-CREATE TABLE phpbb_topics_posted (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (user_id, topic_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_topics_watch'
-CREATE TABLE phpbb_topics_watch (
- topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- KEY topic_id (topic_id),
- KEY user_id (user_id),
- KEY notify_stat (notify_status)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_user_group'
-CREATE TABLE phpbb_user_group (
- group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- KEY group_id (group_id),
- KEY user_id (user_id),
- KEY group_leader (group_leader)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_users'
-CREATE TABLE phpbb_users (
- user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- user_type tinyint(2) DEFAULT '0' NOT NULL,
- group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
- user_permissions mediumtext NOT NULL,
- user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_ip varchar(40) DEFAULT '' NOT NULL,
- user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
- username varchar(255) DEFAULT '' NOT NULL,
- username_clean varchar(255) DEFAULT '' NOT NULL,
- user_password varchar(40) DEFAULT '' NOT NULL,
- user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- user_email varchar(100) DEFAULT '' NOT NULL,
- user_email_hash bigint(20) DEFAULT '0' NOT NULL,
- user_birthday varchar(10) DEFAULT '' NOT NULL,
- user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_lastpage varchar(200) DEFAULT '' NOT NULL,
- user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
- user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_warnings tinyint(4) DEFAULT '0' NOT NULL,
- user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
- user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
- user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_lang varchar(30) DEFAULT '' NOT NULL,
- user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
- user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,
- user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- user_colour varchar(6) DEFAULT '' NOT NULL,
- user_new_privmsg int(4) DEFAULT '0' NOT NULL,
- user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
- user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- user_full_folder int(11) DEFAULT '-3' NOT NULL,
- user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
- user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL,
- user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL,
- user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL,
- user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL,
- user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
- user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
- user_options int(11) UNSIGNED DEFAULT '895' NOT NULL,
- user_avatar varchar(255) DEFAULT '' NOT NULL,
- user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
- user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
- user_sig mediumtext NOT NULL,
- user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
- user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
- user_from varchar(100) DEFAULT '' NOT NULL,
- user_icq varchar(15) DEFAULT '' NOT NULL,
- user_aim varchar(255) DEFAULT '' NOT NULL,
- user_yim varchar(255) DEFAULT '' NOT NULL,
- user_msnm varchar(255) DEFAULT '' NOT NULL,
- user_jabber varchar(255) DEFAULT '' NOT NULL,
- user_website varchar(200) DEFAULT '' NOT NULL,
- user_occ text NOT NULL,
- user_interests text NOT NULL,
- user_actkey varchar(32) DEFAULT '' NOT NULL,
- user_newpasswd varchar(40) DEFAULT '' NOT NULL,
- user_form_salt varchar(32) DEFAULT '' NOT NULL,
- PRIMARY KEY (user_id),
- KEY user_birthday (user_birthday),
- KEY user_email_hash (user_email_hash),
- KEY user_type (user_type),
- UNIQUE username_clean (username_clean)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_warnings'
-CREATE TABLE phpbb_warnings (
- warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (warning_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_words'
-CREATE TABLE phpbb_words (
- word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
- word varchar(255) DEFAULT '' NOT NULL,
- replacement varchar(255) DEFAULT '' NOT NULL,
- PRIMARY KEY (word_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
-# Table: 'phpbb_zebra'
-CREATE TABLE phpbb_zebra (
- user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
- PRIMARY KEY (user_id, zebra_id)
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-
diff --git a/Scripts/Newbb2Phpbb/schemas/xoops_mysql_schema.sql b/Scripts/Newbb2Phpbb/schemas/xoops_mysql_schema.sql
deleted file mode 100755
index ae6b895..0000000
--- a/Scripts/Newbb2Phpbb/schemas/xoops_mysql_schema.sql
+++ /dev/null
@@ -1,570 +0,0 @@
-#
-# Table structure for table `avatar`
-#
-
-CREATE TABLE avatar (
- avatar_id mediumint(8) unsigned NOT NULL auto_increment,
- avatar_file varchar(30) NOT NULL default '',
- avatar_name varchar(100) NOT NULL default '',
- avatar_mimetype varchar(30) NOT NULL default '',
- avatar_created int(10) NOT NULL default '0',
- avatar_display tinyint(1) unsigned NOT NULL default '0',
- avatar_weight smallint(5) unsigned NOT NULL default '0',
- avatar_type char(1) NOT NULL default '',
- PRIMARY KEY (avatar_id),
- KEY avatar_type (avatar_type, avatar_display)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `avatar_user_link`
-#
-
-CREATE TABLE avatar_user_link (
- avatar_id mediumint(8) unsigned NOT NULL default '0',
- user_id mediumint(8) unsigned NOT NULL default '0',
- KEY avatar_user_id (avatar_id,user_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `banner`
-#
-
-CREATE TABLE banner (
- bid smallint(5) unsigned NOT NULL auto_increment,
- cid tinyint(3) unsigned NOT NULL default '0',
- imptotal mediumint(8) unsigned NOT NULL default '0',
- impmade mediumint(8) unsigned NOT NULL default '0',
- clicks mediumint(8) unsigned NOT NULL default '0',
- imageurl varchar(255) NOT NULL default '',
- clickurl varchar(255) NOT NULL default '',
- date int(10) NOT NULL default '0',
- htmlbanner tinyint(1) NOT NULL default '0',
- htmlcode text,
- PRIMARY KEY (bid),
- KEY idxbannercid (cid),
- KEY idxbannerbidcid (bid,cid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `bannerclient`
-#
-
-CREATE TABLE bannerclient (
- cid smallint(5) unsigned NOT NULL auto_increment,
- name varchar(60) NOT NULL default '',
- contact varchar(60) NOT NULL default '',
- email varchar(60) NOT NULL default '',
- login varchar(10) NOT NULL default '',
- passwd varchar(10) NOT NULL default '',
- extrainfo text,
- PRIMARY KEY (cid),
- KEY login (login)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `bannerfinish`
-#
-
-CREATE TABLE bannerfinish (
- bid smallint(5) unsigned NOT NULL auto_increment,
- cid smallint(5) unsigned NOT NULL default '0',
- impressions mediumint(8) unsigned NOT NULL default '0',
- clicks mediumint(8) unsigned NOT NULL default '0',
- datestart int(10) unsigned NOT NULL default '0',
- dateend int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (bid),
- KEY cid (cid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `block_module_link`
-#
-
-CREATE TABLE block_module_link (
- block_id mediumint(8) unsigned NOT NULL default '0',
- module_id smallint(5) NOT NULL default '0',
- PRIMARY KEY (`module_id`, `block_id`)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `comments`
-#
-
-CREATE TABLE xoopscomments (
- com_id mediumint(8) unsigned NOT NULL auto_increment,
- com_pid mediumint(8) unsigned NOT NULL default '0',
- com_rootid mediumint(8) unsigned NOT NULL default '0',
- com_modid smallint(5) unsigned NOT NULL default '0',
- com_itemid mediumint(8) unsigned NOT NULL default '0',
- com_icon varchar(25) NOT NULL default '',
- com_created int(10) unsigned NOT NULL default '0',
- com_modified int(10) unsigned NOT NULL default '0',
- com_uid mediumint(8) unsigned NOT NULL default '0',
- com_ip varchar(15) NOT NULL default '',
- com_title varchar(255) NOT NULL default '',
- com_text text,
- com_sig tinyint(1) unsigned NOT NULL default '0',
- com_status tinyint(1) unsigned NOT NULL default '0',
- com_exparams varchar(255) NOT NULL default '',
- dohtml tinyint(1) unsigned NOT NULL default '0',
- dosmiley tinyint(1) unsigned NOT NULL default '0',
- doxcode tinyint(1) unsigned NOT NULL default '0',
- doimage tinyint(1) unsigned NOT NULL default '0',
- dobr tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (com_id),
- KEY com_pid (com_pid),
- KEY com_itemid (com_itemid),
- KEY com_uid (com_uid),
- KEY com_title (com_title(40))
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-# RMV-NOTIFY
-# Table structure for table `notifications`
-#
-
-CREATE TABLE xoopsnotifications (
- not_id mediumint(8) unsigned NOT NULL auto_increment,
- not_modid smallint(5) unsigned NOT NULL default '0',
- not_itemid mediumint(8) unsigned NOT NULL default '0',
- not_category varchar(30) NOT NULL default '',
- not_event varchar(30) NOT NULL default '',
- not_uid mediumint(8) unsigned NOT NULL default '0',
- not_mode tinyint(1) NOT NULL default 0,
- PRIMARY KEY (not_id),
- KEY not_modid (not_modid),
- KEY not_itemid (not_itemid),
- KEY not_class (not_category),
- KEY not_uid (not_uid),
- KEY not_event (not_event)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `config`
-#
-
-CREATE TABLE config (
- conf_id smallint(5) unsigned NOT NULL auto_increment,
- conf_modid smallint(5) unsigned NOT NULL default '0',
- conf_catid smallint(5) unsigned NOT NULL default '0',
- conf_name varchar(25) NOT NULL default '',
- conf_title varchar(255) NOT NULL default '',
- conf_value text,
- conf_desc varchar(255) NOT NULL default '',
- conf_formtype varchar(15) NOT NULL default '',
- conf_valuetype varchar(10) NOT NULL default '',
- conf_order smallint(5) unsigned NOT NULL default '0',
- PRIMARY KEY (conf_id),
- KEY conf_mod_cat_id (conf_modid, conf_catid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `configcategory`
-#
-
-CREATE TABLE configcategory (
- confcat_id smallint(5) unsigned NOT NULL auto_increment,
- confcat_name varchar(255) NOT NULL default '',
- confcat_order smallint(5) unsigned NOT NULL default '0',
- PRIMARY KEY (confcat_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `configoption`
-#
-
-CREATE TABLE configoption (
- confop_id mediumint(8) unsigned NOT NULL auto_increment,
- confop_name varchar(255) NOT NULL default '',
- confop_value varchar(255) NOT NULL default '',
- conf_id smallint(5) unsigned NOT NULL default '0',
- PRIMARY KEY (confop_id),
- KEY conf_id (conf_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `groups`
-#
-
-CREATE TABLE groups (
- groupid smallint(5) unsigned NOT NULL auto_increment,
- name varchar(50) NOT NULL default '',
- description text,
- group_type varchar(10) NOT NULL default '',
- PRIMARY KEY (groupid),
- KEY group_type (group_type)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `group_permission`
-#
-
-CREATE TABLE group_permission (
- gperm_id int(10) unsigned NOT NULL auto_increment,
- gperm_groupid smallint(5) unsigned NOT NULL default '0',
- gperm_itemid mediumint(8) unsigned NOT NULL default '0',
- gperm_modid mediumint(5) unsigned NOT NULL default '0',
- gperm_name varchar(50) NOT NULL default '',
- PRIMARY KEY (gperm_id),
- KEY groupid (gperm_groupid),
- KEY itemid (gperm_itemid),
- KEY gperm_modid (gperm_modid,gperm_name(10))
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-
-#
-# Table structure for table `groups_users_link`
-#
-
-CREATE TABLE groups_users_link (
- linkid mediumint(8) unsigned NOT NULL auto_increment,
- groupid smallint(5) unsigned NOT NULL default '0',
- uid mediumint(8) unsigned NOT NULL default '0',
- PRIMARY KEY (linkid),
- KEY groupid_uid (groupid,uid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `image`
-#
-
-CREATE TABLE image (
- image_id mediumint(8) unsigned NOT NULL auto_increment,
- image_name varchar(30) NOT NULL default '',
- image_nicename varchar(255) NOT NULL default '',
- image_mimetype varchar(30) NOT NULL default '',
- image_created int(10) unsigned NOT NULL default '0',
- image_display tinyint(1) unsigned NOT NULL default '0',
- image_weight smallint(5) unsigned NOT NULL default '0',
- imgcat_id smallint(5) unsigned NOT NULL default '0',
- PRIMARY KEY (image_id),
- KEY imgcat_id (imgcat_id),
- KEY image_display (image_display)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `imagebody`
-#
-
-CREATE TABLE imagebody (
- image_id mediumint(8) unsigned NOT NULL default '0',
- image_body mediumblob,
- KEY image_id (image_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `imagecategory`
-#
-
-CREATE TABLE imagecategory (
- imgcat_id smallint(5) unsigned NOT NULL auto_increment,
- imgcat_name varchar(100) NOT NULL default '',
- imgcat_maxsize int(8) unsigned NOT NULL default '0',
- imgcat_maxwidth smallint(3) unsigned NOT NULL default '0',
- imgcat_maxheight smallint(3) unsigned NOT NULL default '0',
- imgcat_display tinyint(1) unsigned NOT NULL default '0',
- imgcat_weight smallint(3) unsigned NOT NULL default '0',
- imgcat_type char(1) NOT NULL default '',
- imgcat_storetype varchar(5) NOT NULL default '',
- PRIMARY KEY (imgcat_id),
- KEY imgcat_display (imgcat_display)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-
-#
-# Table structure for table `imgset`
-#
-
-CREATE TABLE imgset (
- imgset_id smallint(5) unsigned NOT NULL auto_increment,
- imgset_name varchar(50) NOT NULL default '',
- imgset_refid mediumint(8) unsigned NOT NULL default '0',
- PRIMARY KEY (imgset_id),
- KEY imgset_refid (imgset_refid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `imgset_tplset_link`
-#
-
-CREATE TABLE imgset_tplset_link (
- imgset_id smallint(5) unsigned NOT NULL default '0',
- tplset_name varchar(50) NOT NULL default '',
- KEY tplset_name (tplset_name(10))
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `imgsetimg`
-#
-
-CREATE TABLE imgsetimg (
- imgsetimg_id mediumint(8) unsigned NOT NULL auto_increment,
- imgsetimg_file varchar(50) NOT NULL default '',
- imgsetimg_body blob,
- imgsetimg_imgset smallint(5) unsigned NOT NULL default '0',
- PRIMARY KEY (imgsetimg_id),
- KEY imgsetimg_imgset (imgsetimg_imgset)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `modules`
-#
-
-CREATE TABLE modules (
- mid smallint(5) unsigned NOT NULL auto_increment,
- name varchar(150) NOT NULL default '',
- version smallint(5) unsigned NOT NULL default '100',
- last_update int(10) unsigned NOT NULL default '0',
- weight smallint(3) unsigned NOT NULL default '0',
- isactive tinyint(1) unsigned NOT NULL default '0',
- dirname varchar(25) NOT NULL default '',
- hasmain tinyint(1) unsigned NOT NULL default '0',
- hasadmin tinyint(1) unsigned NOT NULL default '0',
- hassearch tinyint(1) unsigned NOT NULL default '0',
- hasconfig tinyint(1) unsigned NOT NULL default '0',
- hascomments tinyint(1) unsigned NOT NULL default '0',
- hasnotification tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (mid),
- KEY hasmain (hasmain),
- KEY hasadmin (hasadmin),
- KEY hassearch (hassearch),
- KEY hasnotification (hasnotification),
- KEY dirname (dirname),
- KEY name (name(15))
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `newblocks`
-#
-
-CREATE TABLE newblocks (
- bid mediumint(8) unsigned NOT NULL auto_increment,
- mid smallint(5) unsigned NOT NULL default '0',
- func_num tinyint(3) unsigned NOT NULL default '0',
- options varchar(255) NOT NULL default '',
- name varchar(150) NOT NULL default '',
- title varchar(255) NOT NULL default '',
- content text,
- side tinyint(1) unsigned NOT NULL default '0',
- weight smallint(5) unsigned NOT NULL default '0',
- visible tinyint(1) unsigned NOT NULL default '0',
- block_type char(1) NOT NULL default '',
- c_type char(1) NOT NULL default '',
- isactive tinyint(1) unsigned NOT NULL default '0',
- dirname varchar(50) NOT NULL default '',
- func_file varchar(50) NOT NULL default '',
- show_func varchar(50) NOT NULL default '',
- edit_func varchar(50) NOT NULL default '',
- template varchar(50) NOT NULL default '',
- bcachetime int(10) unsigned NOT NULL default '0',
- last_modified int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (bid),
- KEY mid (mid),
- KEY visible (visible),
- KEY isactive_visible_mid (isactive,visible,mid),
- KEY mid_funcnum (mid,func_num)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `online`
-#
-
-CREATE TABLE online (
- online_uid mediumint(8) unsigned NOT NULL default '0',
- online_uname varchar(25) NOT NULL default '',
- online_updated int(10) unsigned NOT NULL default '0',
- online_module smallint(5) unsigned NOT NULL default '0',
- online_ip varchar(15) NOT NULL default '',
- KEY online_module (online_module)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `priv_msgs`
-#
-
-CREATE TABLE priv_msgs (
- msg_id mediumint(8) unsigned NOT NULL auto_increment,
- msg_image varchar(100) default NULL,
- subject varchar(255) NOT NULL default '',
- from_userid mediumint(8) unsigned NOT NULL default '0',
- to_userid mediumint(8) unsigned NOT NULL default '0',
- msg_time int(10) unsigned NOT NULL default '0',
- msg_text text,
- read_msg tinyint(1) unsigned NOT NULL default '0',
- PRIMARY KEY (msg_id),
- KEY to_userid (to_userid),
- KEY touseridreadmsg (to_userid,read_msg),
- KEY msgidfromuserid (msg_id,from_userid)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `ranks`
-#
-
-CREATE TABLE ranks (
- rank_id smallint(5) unsigned NOT NULL auto_increment,
- rank_title varchar(50) NOT NULL default '',
- rank_min mediumint(8) unsigned NOT NULL default '0',
- rank_max mediumint(8) unsigned NOT NULL default '0',
- rank_special tinyint(1) unsigned NOT NULL default '0',
- rank_image varchar(255) default NULL,
- PRIMARY KEY (rank_id),
- KEY rank_min (rank_min),
- KEY rank_max (rank_max),
- KEY rankminrankmaxranspecial (rank_min,rank_max,rank_special),
- KEY rankspecial (rank_special)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `session`
-#
-
-CREATE TABLE session (
- sess_id varchar(32) NOT NULL default '',
- sess_updated int(10) unsigned NOT NULL default '0',
- sess_ip varchar(15) NOT NULL default '',
- sess_data text,
- PRIMARY KEY (sess_id),
- KEY updated (sess_updated)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `smiles`
-#
-
-CREATE TABLE smiles (
- id smallint(5) unsigned NOT NULL auto_increment,
- code varchar(50) NOT NULL default '',
- smile_url varchar(100) NOT NULL default '',
- emotion varchar(75) NOT NULL default '',
- display tinyint(1) NOT NULL default '0',
- PRIMARY KEY (id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `tplset`
-#
-
-CREATE TABLE tplset (
- tplset_id int(7) unsigned NOT NULL auto_increment,
- tplset_name varchar(50) NOT NULL default '',
- tplset_desc varchar(255) NOT NULL default '',
- tplset_credits text,
- tplset_created int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (tplset_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `tplfile`
-#
-
-CREATE TABLE tplfile (
- tpl_id mediumint(7) unsigned NOT NULL auto_increment,
- tpl_refid smallint(5) unsigned NOT NULL default '0',
- tpl_module varchar(25) NOT NULL default '',
- tpl_tplset varchar(50) NOT NULL default '',
- tpl_file varchar(50) NOT NULL default '',
- tpl_desc varchar(255) NOT NULL default '',
- tpl_lastmodified int(10) unsigned NOT NULL default '0',
- tpl_lastimported int(10) unsigned NOT NULL default '0',
- tpl_type varchar(20) NOT NULL default '',
- PRIMARY KEY (tpl_id),
- KEY tpl_refid (tpl_refid,tpl_type),
- KEY tpl_tplset (tpl_tplset,tpl_file(10))
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `tplsource`
-#
-
-CREATE TABLE tplsource (
- tpl_id mediumint(7) unsigned NOT NULL default '0',
- tpl_source mediumtext,
- KEY tpl_id (tpl_id)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-# Table structure for table `users`
-#
-
-CREATE TABLE users (
- uid mediumint(8) unsigned NOT NULL auto_increment,
- name varchar(60) NOT NULL default '',
- uname varchar(25) NOT NULL default '',
- email varchar(60) NOT NULL default '',
- url varchar(100) NOT NULL default '',
- user_avatar varchar(30) NOT NULL default 'blank.gif',
- user_regdate int(10) unsigned NOT NULL default '0',
- user_icq varchar(15) NOT NULL default '',
- user_from varchar(100) NOT NULL default '',
- user_sig tinytext,
- user_viewemail tinyint(1) unsigned NOT NULL default '0',
- actkey varchar(8) NOT NULL default '',
- user_aim varchar(18) NOT NULL default '',
- user_yim varchar(25) NOT NULL default '',
- user_msnm varchar(100) NOT NULL default '',
- pass varchar(32) NOT NULL default '',
- posts mediumint(8) unsigned NOT NULL default '0',
- attachsig tinyint(1) unsigned NOT NULL default '0',
- rank smallint(5) unsigned NOT NULL default '0',
- level tinyint(3) unsigned NOT NULL default '1',
- theme varchar(100) NOT NULL default '',
- timezone_offset float(3,1) NOT NULL default '0.0',
- last_login int(10) unsigned NOT NULL default '0',
- umode varchar(10) NOT NULL default '',
- uorder tinyint(1) unsigned NOT NULL default '0',
- notify_method tinyint(1) NOT NULL default '1',
- notify_mode tinyint(1) NOT NULL default '0',
- user_occ varchar(100) NOT NULL default '',
- bio tinytext,
- user_intrest varchar(150) NOT NULL default '',
- user_mailok tinyint(1) unsigned NOT NULL default '1',
- PRIMARY KEY (uid),
- KEY uname (uname),
- KEY email (email),
- KEY uiduname (uid,uname),
- KEY unamepass (uname,pass)
-) TYPE=MyISAM;
-# --------------------------------------------------------
-
-#
-# Table structure for table `cache_model`
-#
-
-CREATE TABLE cache_model (
- `cache_key` varchar(64) NOT NULL default '',
- `cache_expires` int(10) unsigned NOT NULL default '0',
- `cache_data` text,
-
- PRIMARY KEY (`cache_key`),
- KEY `cache_expires` (`cache_expires`)
-) TYPE=MyISAM;
-# --------------------------------------------------------
diff --git a/Scripts/Newbb2Phpbb/style.css b/Scripts/Newbb2Phpbb/style.css
deleted file mode 100755
index 6c13dba..0000000
--- a/Scripts/Newbb2Phpbb/style.css
+++ /dev/null
@@ -1,323 +0,0 @@
-/*
- * Convert Xoops + CBB (newbb) to phpBB
- * Style Sheet.
- *
- */
-
-html {
- background-image:url(img/html-bg.png);
- background-color: #FFF;
- font-family: "DejaVu Sans", "Liberation Sans", sans-serif;
- font-size: 0.85em;
- line-height: 1.25em;
- /* margin: 0; /* <- full screen */
- /* margin: 0 1% 0 1%; /* <- with 1% of left and right margin */
- /* margin: 0 2% 0 2%; /* <- with 2% of left and right margin */
- margin: 0 4% 0 4%; /* <- with 4% of left and right margin */
- /* margin: 0 10% 0 10%; /* <- with 10% of left and right margin */
- }
-
-body {
- background: #FFF;
- border-width: 10px;
- border-style: solid;
- border-color: #FFF;
- padding:0;
- margin:0;
- }
-
-/* Links */
-
-a:link { text-decoration: none; color: #204C8D; }
-a:hover { text-decoration: underline; color: green; }
-a:active { text-decoration: underline; color: green; }
-a:visited { text-decoration: none; color: #204C8D; }
-a:visited:hover { text-decoration: underline; color: green; }
-a.nonexistent, a.badinterwiki { color: gray; }
-
-/* Header */
-
-#header {
- margin:0;
- padding-top: 1em;
- background-color: #204C8D;
- background-image: url("img/header-bg.png");
- line-height: 1.0em;
- border:none;
- }
-
-#header h1 {
- color: #fff;
- margin: 0;
- line-height: 1.7em;
- text-align: center;
- margin-bottom: 0;
-}
-
-#header p.description {
- color: #fff;
- text-align: center;
- margin: 0;
- font-size: 0.9em;
-
-}
-
-/* Sublinks */
-
-.sublinks {
- clear: both;
- display: block;
- margin: 0;
- white-space: nowrap;
- background: #EDF4FF;
- font-size: 0.9em;
- padding: 0.5em;
- padding-left: 20px;
- border-top: 1px solid #ddd;
- border-bottom: 2px dotted #628ECA;
- }
-
-.sublinks li {
- display: inline;
- padding: 0;
- margin-right: 5px;
- }
-
-.sublinks li.current {
- font-weight: bold;
-}
-
-.sublinks li:after {
- margin-left: 5px;
- content: " » ";
- }
-
-.sublinks li:last-child:after {
- content: "";
- }
-
-
-/* Page */
-
-#page {
- padding-top: 1em;
- padding-right: 20px;
- padding-bottom: 0;
- padding-left: 20px;
- background: #FFF;
-}
-
-dd span.description {
- margin-left: 0.5em;
-}
-
-.navibar {
- /* Problem: clear: right; aligns nicely right of
- * logo, but lets it float high in the header,
- * disconnected from ground */
- clear: both;
- display: block;
- height: 20px;
- padding: 0;
- padding-left: 20px;
- margin: 0;
- font-size: 0.9em;
-
- /* For avoiding a gap between navibar and pageline
- * on IE */
- zoom: 1;
- }
-
-.navibar li {
- display: inline;
- white-space: nowrap;
- padding-top: 5px;
- padding-bottom: 5px;
- border-width: 1px;
- border-style: solid;
- border-color: #628ECA;
- background-color: #FFF;
- background-image: url("img/navibartop-bg.png");
- background-position: left top;
- background-repeat: repeat-x;
- }
-
-.navibar li a {
- /* To cover the box area as linkable */
- padding: 8px;
- padding-top: 4px;
- padding-bottom: 5px;
- }
-
-.navibar a, .navibar a:visited {
- color: #204C8D;
- text-decoration: none;
- }
-
-.navibar li.current a {
- color: #FFFFFF;
- text-decoration: none;
- font-weight: bold;
- }
-
-.navibar li:hover {
- background-color: #628ECA;
- background-image: url("img/navibartop-hover-bg.png");
- background-position: left top;
- background-repeat: repeat-x;
- }
-
-.navibar li:hover a {
- color: #FFFFFF;
- text-decoration: none;
- }
-
-.navibar li.current,
-.navibar li.current:hover,
-.navibar li.current:hover a,
-.navibar li.current:active a {
- color: #FFFFFF;
- background-color: #628ECA;
- background-image: url("img/navibartop-hover-bg.png");
- background-position: left top;
- background-repeat: repeat-x;
- }
-
-/* Alignment */
-
-.right { text-align: right; }
-.left { text-align: left; }
-.center { text-align: center; }
-
-.floatr { float:right; }
-.floatl { float:left; }
-
-/* Lists */
-
-dl {
- clear: both;
- }
-
-dt {
- float: left;;
- width: 200px;
- padding-top: 3px;
- padding-right: 1em;
- text-align: right;
- }
-
-/* Form */
-
-textarea {
- padding: 3px;
- padding-left: 0.5em;
-}
-
-/* Tables */
-
-td {
- font-size: 0.85em;
- padding: 0.5em;
- font-family: monospace;
-}
-
-th {
- padding: 0.5em;
- font-size: 0.85em;
- font-family: monospace;
- background: #f8f8f8;
-}
-
-#footer{
- background: #fafafa;
- padding: 3px;
- margin-top: 1em;
-}
-
-/* Messages */
-
-.lm {
- background-color: #ECECEC;
- background-image: url("img/moin-msg-bg-gray.png");
- width: -10px;
- border-width: 1px;
- border-style: solid;
- border-color: #CFCFCF;
- border-left-width: 4px;
- padding: 1em !important;
- }
-
-.lm.red {
- border-color: #E0B7B7;
- background-color: #FFECEC;
- background-image: url("img/moin-msg-bg-red.png");
- }
-.lm.green {
- border-color: #D6F6D2;
- background-color: #EEFFEC;
- background-image: url("img/moin-msg-bg-green.png");
- }
-
-.lm.violet {
- border-color: #F6D2F6;
- background-color: #FFECFF;
- background-image: url("img/moin-msg-bg-violet.png");
- }
-
-.lm.blue {
- border-color: #D2E0F6;
- background-color: #ECF4FF;
- background-image: url("img/moin-msg-bg-blue.png");
- }
-
-.lm.orange {
- border-color: #F6E7D2;
- background-color: #FFF8EC;
- background-image: url("img/moin-msg-bg-orange.png");
- }
-
-.message {
- margin-left: 20%;
- margin-right: 20%;
- margin-bottom: 0.5em;
- padding-top: 1em;
- padding-bottom: 1em;
- padding-left: 1.5em;
- border-width: 0;
- border-top-width: 4px;
- border-top-style: solid;
- border-bottom-width: 4px;
- border-bottom-style: solid;
- text-align: center;
- font-weight: bold;
- }
-
-/* Misc */
-
-.pageline {
- clear: both;
- margin: 0;
- padding: 0;
- width: 100%;
- /* sync these values, line-height is needed for IE */
- height: 5px;
- line-height: 5px;
- background: #628ECA;
- }
-
-.action {
- background: #f8f8f8;
- padding: 1em;
- margin-bottom: 0;
-
-}
-
-.action span {
- margin-top: 5px;
-}
-
-.action img {
- vertical-align: top;
- margin-right: 0.5em;
- border: none;
-}