관리-도구

편집 파일: class.phpbb.php

<?php
/** 
 * phpBB Class.
 *
 * This class is used to interact with phpBB forum
 *
 * @package classes
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: class.phpbb.php 4824 2006-10-23 21:01:28Z drbyte $
 */

if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

class phpBB extends base {
      var $debug = false;
      var $db_phpbb;
      var $phpBB=array();
      var $dir_phpbb='';

function phpBB() {
      $this->debug= (defined('PHPBB_DEBUG_MODE') && strtoupper(PHPBB_DEBUG_MODE)=='ON') ? (defined('PHPBB_DEBUG_IP') && (PHPBB_DEBUG_IP == '' || PHPBB_DEBUG_IP == $_SERVER['REMOTE_ADDR'] || strstr(EXCLUDE_ADMIN_IP_FOR_MAINTENANCE, $_SERVER['REMOTE_ADDR'])) ? true : false ) : false;
      $this->phpBB = Array();
      $this->phpBB['installed']=false;
      if (PHPBB_LINKS_ENABLED =='true') {  // if disabled in Zen Cart admin, don't do any checks for phpBB
        $this->get_phpBB_info();
      
//        global $db;
//        $this->db_phpbb = $db;

$this->db_phpbb = new queryFactory();
        $connect_status = $this->db_phpbb->connect($this->phpBB['dbhost'], $this->phpBB['dbuser'], $this->phpBB['dbpasswd'], $this->phpBB['dbname'], USE_PCONNECT, false);

$this->check_connect();
 $this->set_status();
 } elseif ($this->debug==true) {
 echo "phpBB connection disabled in Admin ";
 }
 if ($this->debug==true) echo ' YOU CAN IGNORE THE FOLLOWING "Cannot send session cache limited - headers already sent..." errors, as they are a result of the above debug output. ';
 }

function get_phpBB_info() {
      $this->phpBB['db_installed']=false;
      $this->phpBB['files_installed']=false;
      $this->phpBB['phpbb_path']='';
      $this->phpBB['phpbb_url']='';

//@TODO: $cleaned = preg_replace('/\//',DIRECTORY_SEPARATOR,$string);

$this->dir_phpbb = str_replace(array('\\', '//'), '/', DIR_WS_PHPBB ); // convert slashes

if (substr($this->dir_phpbb,-1)!='/') $this->dir_phpbb .= '/'; // ensure has a trailing slash
 if ($this->debug==true) echo 'dir='.$this->dir_phpbb.' ';

//check if file exists
 if (@file_exists($this->dir_phpbb . 'config.php')) {
 $this->phpBB['files_installed'] = true;
 if ($this->debug==true) echo "files_installed = true ";
 // if exists, also store it for future use
 $this->phpBB['phpbb_path'] = $this->dir_phpbb;
 if ($this->debug==true) echo 'phpbb_path='. $this->dir_phpbb . ' ';

// find phpbb table prefix without including file:
 $lines = array();
 $lines = @file($this->phpBB['phpbb_path']. 'config.php');
 foreach($lines as $line) { // read the configure.php file for specific variables
 if ($this->debug==true && strlen($line)>3 && substr($line,0,2)!='//' && !strstr($line,'$dbpasswd')) echo 'CONFIG.PHP-->'.$line.' ';
 if (substr($line,0,1)!='$') continue;
 if (substr_count($line,'"')>1) $delim='"';
 if (substr_count($line,"'")>1) $delim="'"; // determine whether single or double quotes used in this line.
 $def_string=array();
 $def_string=explode($delim,trim($line));
 if (substr($line,0,7)=='$dbhost') $this->phpBB['dbhost'] = $def_string[1];
 if (substr($line,0,7)=='$dbname') $this->phpBB['dbname'] = $def_string[1];
 if (substr($line,0,7)=='$dbuser') $this->phpBB['dbuser'] = $def_string[1];
 if (substr($line,0,9)=='$dbpasswd') $this->phpBB['dbpasswd'] = $def_string[1];
 if (substr($line,0,13)=='$table_prefix') $this->phpBB['table_prefix'] = $def_string[1];
 }//end foreach $line
 // find phpbb table-names without INCLUDEing file:
 if (@file_exists($this->phpBB['phpbb_path'] . 'includes/constants.php')) {
 $lines = array();
 $lines = @file($this->phpBB['phpbb_path']. 'includes/constants.php');
 if (is_array($lines)) {
 foreach($lines as $line) { // read the configure.php file for specific variables
 if (substr_count($line,'define(')<1) continue;
 if ($this->debug==true && strlen($line)>3 && substr($line,0,1)!='/') echo 'CONSTANTS.PHP-->'.$line.' ';
 if (substr_count($line,'"')>1) $delim='"';
 if (substr_count($line,"'")>1) $delim="'"; // determine whether single or double quotes used in this line.
 $def_string=array();
 $def_string=explode($delim,$line);
 if ($def_string[1]=='USERS_TABLE') $this->phpBB['users_table'] = $this->phpBB['table_prefix'] . $def_string[3];
 if ($def_string[1]=='USER_GROUP_TABLE') $this->phpBB['user_group_table'] = $this->phpBB['table_prefix'] . $def_string[3];
 if ($def_string[1]=='GROUPS_TABLE') $this->phpBB['groups_table'] = $this->phpBB['table_prefix'] . $def_string[3];
 if ($def_string[1]=='CONFIG_TABLE') $this->phpBB['config_table'] = $this->phpBB['table_prefix'] . $def_string[3];
 }//end foreach of $line
 }
 } else {
 $this->phpBB['files_installed'] = false;
 }
 if ($this->debug==true) {
 echo 'prefix='.$this->phpBB['table_prefix'].' ';
 echo 'dbname='.$this->phpBB['dbname'].' ';
 echo 'dbuser='.$this->phpBB['dbuser'].' ';
 echo 'dbhost='.$this->phpBB['dbhost'].' ';
 echo 'dbpasswd='.$this->phpBB['dbpasswd'].' ';
 echo 'users_table='.$this->phpBB['users_table'].' ';
 echo 'user_group_table='.$this->phpBB['user_group_table'].' ';
 echo 'groups_table='.$this->phpBB['groups_table'].' ';
 echo 'config_table='.$this->phpBB['config_table'].' ';
 }

}//endif @file_exists
    }

function set_status() {
      //calculate the path from root of server for absolute path info
      $script_filename = $_SERVER['PATH_TRANSLATED'];
      if (empty($script_filename)) $script_filename = $_SERVER['SCRIPT_FILENAME'];
      $script_filename = str_replace(array('\\', '//'), '/', $script_filename);  //convert slashes

if ($this->debug==true) echo "script-filename=".$script_filename.' ';
 if ($this->debug==true) echo "link_enabled_admin_status=".PHPBB_LINKS_ENABLED.' ';

if ( ($this->phpBB['db_installed']) && ($this->phpBB['files_installed']) && (PHPBB_LINKS_ENABLED=='true')) {
 //good so far. now let's check for relative path access so we can successfully "include" the config.php file when needed.
 if ($this->debug==true) echo "ok, now let's check relative paths ";
 if ($this->debug==true) echo 'docroot='.$_SERVER['DOCUMENT_ROOT'].' ';
 if ($this->debug==true) echo 'phpself='.$_SERVER['PHP_SELF'].' ';
 $this->phpBB['phpbb_url'] = str_replace(array($_SERVER['DOCUMENT_ROOT'],substr($script_filename,0,strpos($script_filename,$_SERVER['PHP_SELF']))),'',$this->phpBB['phpbb_path']);
 $this->phpBB['installed'] = true;
 if ($this->debug==true) echo 'URL='.$this->phpBB['phpbb_url'].' ';
 //if neither of the relative paths validate, the function still returns false for 'installed'.
 }
 if ($this->debug==true && $this->phpBB['installed']==false) echo "FAILURE: phpBB NOT activated ";
 // will use $phpBB->phpBB['installed'] to check for suitability of calling phpBB in the future.
 }

function phpbb_create_account($nick, $password, $email_address) {
      if ($this->phpBB['installed'] != true || !zen_not_null($password) || !zen_not_null($email_address) || !zen_not_null($nick)) return false;
      if ($this->phpbb_check_for_duplicate_email($email_address) == 'already_exists') {
//        $this->phpbb_change_email($old_email, $email_address);
      } else {
        $sql = "select max(user_id) as total from " . $this->phpBB['users_table'];
        $phpbb_users = $this->db_phpbb->Execute($sql);
        $user_id = ($phpbb_users->fields['total'] + 1);
        $sql = "insert into " . $this->phpBB['users_table'] . "
                (user_id, username, user_password, user_email, user_regdate)
                values
                ('" . (int)$user_id . "', '" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() ."')";
        $this->db_phpbb->Execute($sql);
//could do a check here to see if Insert_ID() matches $user_id...

// @TODO: MySQL5

$sql = "INSERT INTO " . $this->phpBB['groups_table'] . " (group_name, group_description, group_single_user, group_moderator)
                VALUES (0, 'Personal User', 1, 0)";
        $this->db_phpbb->Execute($sql);
        $group_id = $this->db_phpbb->Insert_ID();
        $sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending)
                VALUES ($user_id, $group_id, 0)";
        $this->db_phpbb->Execute($sql);
        //might optionally send an extra email welcoming them to the phpBB forum, reminding them of their nickname?
      }
    }

function phpbb_check_for_duplicate_nick($nick='') {
      if ($this->phpBB['installed'] != true || empty($nick)) return false;
      $status='';
      $sql = "select * from " . $this->phpBB['users_table'] . " where username = '" . $nick . "'";
      //echo $sql;
      $phpbb_users = $this->db_phpbb->Execute($sql);
      //echo "count=".$phpbb_users->RecordCount();
      if ($phpbb_users->RecordCount() > 0 ) {
        $status='already_exists';
      }
      return $status;
    }

function phpbb_check_for_duplicate_email($email_address) {
      if ($this->phpBB['installed'] != true) return false;
      $status='';
      $sql = "select * from " . $this->phpBB['users_table'] . " where user_email = '" . $email_address . "'";
      $phpbb_users = $this->db_phpbb->Execute($sql);
      if ($phpbb_users->RecordCount() > 0 ) {
        $status='already_exists';
      }
      return $status;
    }

function phpbb_change_password($nick, $newpassword) {
      if ($this->phpBB['installed'] != true || !zen_not_null($nick) || $nick == '') return false;
        $sql = "update " . $this->phpBB['users_table'] . " set user_password='" . MD5($newpassword) . "'
                where username = '" . $nick . "'";
        $phpbb_users = $this->db_phpbb->Execute($sql);
    }

function phpbb_change_email($old_email, $email_address) {
    // before utilizing this function, we should do an MD5 password validation first
      if ($this->phpBB['installed'] != true || !zen_not_null($email_address) || $email_address == '') return false;
        $sql = "update " . $this->phpBB['users_table'] . " set user_email='" . $email_address . "'
                where user_email = '" . $old_email . "'";
        $phpbb_users = $this->db_phpbb->Execute($sql);
    }

function phpbb_change_nick($old_nick, $new_nick) {
    // before utilizing this function, we should do an MD5 password validation first
      if ($this->phpBB['installed'] != true || !zen_not_null($nick) || $nick == '') return false;
        $sql = "update " . $this->phpBB['users_table'] . " set username='" . $new_nick . "'
                where username = '" . $old_nick . "'";
        $phpbb_users = $this->db_phpbb->Execute($sql);
    }

}
?>