You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
89 lines
2.8 KiB
89 lines
2.8 KiB
4 months ago
|
<?php
|
||
|
|
/*********************************************************************************
|
||
|
|
* The contents of this file are subject to the SugarCRM Public License Version 1.1.2
|
||
|
|
* ("License"); You may not use this file except in compliance with the
|
||
|
|
* License. You may obtain a copy of the License at http://www.sugarcrm.com/SPL
|
||
|
|
* Software distributed under the License is distributed on an "AS IS" basis,
|
||
|
|
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
|
||
|
|
* the specific language governing rights and limitations under the License.
|
||
|
|
* The Original Code is: SugarCRM Open Source
|
||
|
|
* The Initial Developer of the Original Code is SugarCRM, Inc.
|
||
|
|
* Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.;
|
||
|
|
* All Rights Reserved.
|
||
|
|
* Contributor(s): ______________________________________.
|
||
|
|
********************************************************************************/
|
||
|
|
|
||
|
|
require_once('database/DatabaseConnection.php');
|
||
|
|
include_once('config.php');
|
||
|
|
require_once('include/logging.php');
|
||
|
|
require_once('include/database/PearDatabase.php');
|
||
|
|
require_once('data/SugarBean.php');
|
||
|
|
//include_once('modules/MessageBoard/includes/template.php');
|
||
|
|
include_once('modules/MessageBoard/mods/phpbb_fetch_all/posts.php');
|
||
|
|
include_once('modules/MessageBoard/mods/phpbb_fetch_all/common.php');
|
||
|
|
//include_once('modules/MessageBoard/includes/functions.php');
|
||
|
|
//include_once('modules/MessageBoard/includes/bbcode.php');
|
||
|
|
include_once('modules/MessageBoard/db/mysql.php');
|
||
|
|
|
||
|
|
class MessageBoard extends SugarBean {
|
||
|
|
var $topic_title;
|
||
|
|
var $forum_name;
|
||
|
|
var $username;
|
||
|
|
var $topic_replies;
|
||
|
|
var $post_time;
|
||
|
|
var $table_name = "MessageBoard";
|
||
|
|
var $object_name = "MessageBoard";
|
||
|
|
var $new_schema = true;
|
||
|
|
var $column_fields = Array(
|
||
|
|
"topic_title",
|
||
|
|
"forum_name",
|
||
|
|
"username",
|
||
|
|
"topic_replies",
|
||
|
|
"post_time");
|
||
|
|
|
||
|
|
var $list_fields = Array('topic_id','post_id','topic_title', 'forum_name', 'username', 'topic_replies' , 'post_time');
|
||
|
|
|
||
|
|
function MessageBoard() {
|
||
|
|
$this->log = LoggerManager::getLogger('messageboard');
|
||
|
|
$this->db = new PearDatabase();
|
||
|
|
}
|
||
|
|
|
||
|
|
function create_tables () {
|
||
|
|
$query = 'CREATE TABLE '.$this->table_name.' ( ';
|
||
|
|
$query .='id char(36) NOT NULL';
|
||
|
|
$query .=', date_entered datetime NOT NULL';
|
||
|
|
$query .=', description text';
|
||
|
|
$query .=', deleted bool NOT NULL default 0';
|
||
|
|
$query .=', converted bool NOT NULL default 0';
|
||
|
|
$query .=', PRIMARY KEY ( id ) )';
|
||
|
|
|
||
|
|
$this->log->info($query);
|
||
|
|
|
||
|
|
mysql_query($query);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
function drop_tables () {
|
||
|
|
$query = 'DROP TABLE IF EXISTS '.$this->table_name;
|
||
|
|
|
||
|
|
$this->log->info($query);
|
||
|
|
|
||
|
|
mysql_query($query);
|
||
|
|
}
|
||
|
|
|
||
|
|
// This method is used to provide backward compatibility with old data that was prefixed with http://
|
||
|
|
// We now automatically prefix http://
|
||
|
|
function remove_redundant_http()
|
||
|
|
{
|
||
|
|
if(eregi("http://", $this->website))
|
||
|
|
{
|
||
|
|
$this->website = substr($this->website, 7);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|