<?php
if (!defined('ARTICLEMS')) {
	header('HTTP/1.0 403 Forbidden');
	die;
}

class baseclass{}

class mediaclass{

    var $id = 0;
    var $url = '';

}

class articlemscore{

	var $version = '2.0';
	var $server  = array();           // $_SERVER array
	var $get     = array();           // $_GET array
	var $post    = array();           // $_POST array
	var $cookie  = array();           // $_COOKIE array
	var $files   = array();           // $_FILES array
	var $user    = array();           // Logged in user
	var $sets    = array();

	var $time;                        // The current Unix time int
	var $ip;                          // The user's IP address string
	var $agent;                       // The browser's user agent string
	var $self;                        // Alias for $PHP_SELF string
	var $db;                          // Database object object
	var $pre;                         // Database table prefix

	var $logintime = 31622400; //1 Year

    var $_pagetree = array();
    var $pagetree = array(); //sorted by title, parent.  for use with <select>
    var $PageTree = array(); //directly from database.
    var $Pages = array(); //Page id's, sorted by title
    var $_categorytree = array();
    var $categorytree = array(); //sorted by title, parent.  for use with <select>

    var $CategoryTree = array(); //directly from database.
	var $Categories = array(); //Category id's, sorted by title

    var $site_location = '/';
    var $site_name;
    var $default_skin;
    var $default_group_id;

    var $message='';

	/**
	 * Returns contents of url into string
	 */
	function readUrl($url){

	    $filehandle = @fopen($url,"r");

	    if (!$filehandle){
	        return '';
	    }
	    $contents = '';
	    while (!feof($filehandle)) { //is there more to read?
	        $contents .= fread($filehandle, 1024); //read the file in 1 kb portions
	    }
	    fclose($filehandle);
	    return $contents;
	}

    function update_tag_list($new_tags, $old_tags, $section_id=-1){

        if ($section_id == -1){
            $section_id = $this->section_id;
        }

        if (!is_array($new_tags)){
            $new_tags = array();
        }
        if (!is_array($old_tags)){
            $old_tags = array();
        }


        $tags = $this->load_option("_TAGS_", $section_id);
        $new_tags = array_map('trim', $new_tags);
        $new_tags = array_unique($new_tags);

        $old_tags = array_map('trim', $old_tags);
        $old_tags = array_unique($old_tags);


        foreach ($new_tags as $tag){
            if (trim($tag)){
                $tags[$tag] = isset($tags[$tag])? (intval($tags[$tag]) + 1) : 1;
            }
        }


        foreach ($old_tags as $tag){
            if (!intval($tags[$tag])){
                unset($tags[$tag]);
            }
            else{
                if (trim($tag))
                $tags[$tag] =  intval($tags[$tag]) - 1;

                if (intval($tags[$tag]) == 0){
                    unset($tags[$tag]);
                }
            }
        }
      //  print_r($tags);
      //  exit;
        $this->save_option("_TAGS_", $tags,0, $section_id);

    }

    function show_message($s){
        $this->_message = $s;
    }

    //backwards compatibility
    function showmessage($s){
        $this->show_message($s);
    }

	/**
	 * Gets active users, and filters out all inactive
	 *
	 **/
	function updateActiveUsers(){

		$OnMembers = 0;
		$OnTotal = 0;
		$oldtime = $this->time - (60*15); //15 minutes

	    $this->db->query("REPLACE INTO {$this->pre}active SET
							active_id = {$this->user['user_id']},
							active_time = $this->time,
							active_ip = '$this->ip',
							active_user_agent = '$this->agent',
							active_session = '{$this->session['id']}'");


		$query = $this->db->query("SELECT active_id, active_time FROM {$this->pre}active ORDER BY active_time DESC");

		$oldusers = array();
		while ($row = $this->db->nqfetch($query)){
			if ($row['active_time'] < $oldtime) {  //old users, delete from active
				$oldusers[] = 'user_id=' . $row['active_id'];
			}
			else{
				$OnTotal++;
				if ($row['active_id'] != GUEST_ID) {
					 $OnMembers++;
				}
			}
		}

		if ($oldusers) {
			$oldusers = implode(' OR ', $oldusers);
			$this->db->query('DELETE FROM ' . $this->pre . 'active WHERE active_time < ' . $oldtime);
		}

		if ($OnTotal > $this->sets['mostonline']) {
			$this->sets['mostonline']     = $OnTotal;
			$this->sets['mostonlinetime'] = $this->time;
			$this->save_sets();
		}

		$OnGuests = $OnTotal - $OnMembers;

		return array(
			'members' => $OnMembers,
			'guests'  => $OnGuests,
			'total'  => $OnTotal
		);
	}


    function request_uri(){

        if($_SERVER['REQUEST_URI']){
            return $_SERVER['REQUEST_URI'];
        }

        //IIS with ISAPI_REWRITE  (XXX untested)
        if($_SERVER['HTTP_X_REWRITE_URL']){
            return $_SERVER['HTTP_X_REWRITE_URL'];
        }
        $result = $_SERVER['SCRIPT_NAME'];
        if($_SERVER['QUERY_STRING']){
            $result .= '?'.$_SERVER['QUERY_STRING'];
        }
        return $result;
    }

	/**
	 * Constructor
	 **/
	function articlemscore(){

	}

	/**
	 * Sets up $_GET variables:
	 * 'example.com/example.html' : $_GET['p'] = 'example'
	 * 'example.com/example/' : $_GET['a'] = 'example'
	 * 'example.com/example/2/' : $_GET['a'] = 'example'; $_GET['page'] = 2
	 * 'example.com/example/sub.html' : $_GET['a'] = 'example'; $_GET['p'] = 'sub'
	 * 'example.com/example/sub1/sub2.html' : $_GET['a'] = 'example'; $_GET['c1'] = 'sub1'; $_GET['p'] = 'sub2'
	 * 'example.com/example/sub1/sub2/sub3.html' : $_GET['a'] = 'example'; $_GET['c1'] = 'sub1'; $_GET['c2'] = 'sub2'; $_GET['p'] = 'sub3'
	 */
	function setupGetVariables(){

		$navString = $this->request_uri(); // Returns "/Mod_rewrite/edit/1/"

        $this->section = '';
        $this->section_skin = '';

        $this->section_id = 1;
        $this->current_section = 1;
        foreach ($this->Sections as $Section){
            if ($Section->id > 1){
                if (strpos($navString.'/', $this->relpath.$Section->url.'/') === 0){
                    $this->relpath .= $Section->url.'/';
                    $this->section_id = $Section->id;
                    $this->current_section = $Section->id;
                }
            }
        }

		$navString = ereg_replace("^{$this->relpath}", "", $navString);
		$navString = ereg_replace("/$", "", $navString);

        $this->url_query_string = '';
        $qm = strpos($navString, '?');

        if ($qm !== false){
            $this->url_query_string = substr($navString, $qm);
            $navString = substr($navString, 0, $qm);
        }

		$parts = explode('/', $navString); // Break into an array
		$matches = array();

        if (!$parts[sizeof($parts)-1]){
            unset($parts[sizeof($parts)-1]);
        }

        $this->url_pagination_base = $parts[0];
        $this->Pagination->url_base = &$this->url_pagination_base;

		if (trim($parts[0]) != ''){

		   if ($parts[0][0] == '?'){ //homepage with parameters
                $this->url_pagination_base = '';
		   		return;
		   }
		   elseif(($parts[0] == 'index.php') or (substr($parts[0],0,10) == 'index.php?')){ //homepage with index.php
                $this->url_pagination_base = '';
		   		return;
		   }
		   elseif (preg_match("/(.*?)\.{$this->settings['url_extension']}($|\?|&)/i", $parts[0],$matches)){
		        $this->get['p'] = real_addslashes(urldecode($matches[1])); //custom page
		    }
		    else{
                if ((sizeof($parts) == 1) and (preg_match("/^[0-9]+$/i", $parts[0]))){
                    $this->get['page'] = intval($parts[0]);
                    $this->url_pagination_base = '';
                }
                else{
		          $this->get['a'] = real_addslashes(urldecode($parts[0])); //1st category, or standalone plugin
                }

		    }
		}

		//all deeper parts
		for ($i = 1;$i<sizeof($parts);$i++){
		    if (preg_match("/(.*)\.(.*)/i", $parts[$i])){  // xx.yy
		        if (preg_match("/(.*?)\.{$this->settings['url_extension']}($|\?|&)/i", $parts[$i],$matches)){

		        	if ($matches[1] != 'index'){
		        		$this->get['p'] = real_addslashes(urldecode($matches[1]));  //specific article
		        	}
		        }
		        else{
		            $this->get['p'] = real_addslashes(urldecode($parts[$i]));  //something else..
		        }
		    }
		    else{ // xx/

                if ($i == (sizeof($parts)-1)){
                    if (preg_match("/^[0-9]+$/i", $parts[$i])){
                        $this->get['page'] = intval($parts[$i]);
                        continue;
                    }
                }
		    	$a = preg_split("/(.*?)(\?|&)/",$parts[$i]);
        		if ($a[0]){
		    		$this->get['c'.($i)] = real_addslashes(urldecode(($a[0])));  //category
        		}
		    }
            $this->url_pagination_base .= '/'.$parts[$i];
		}

        if ($this->url_pagination_base){
            $this->url_pagination_base .= '/';
        }
        $this->url_pagination_base = $this->relpath.$this->url_pagination_base;

        $this->Pagination->current_page = 1;
        if ($this->get['page']){
            $this->Pagination->current_page = max(1, intval($this->get['page']));
        }
	}

	/**
	 * Logs a user in from a cookie
	 */
	function login_from_cookie(){

        $user = array();
		if(isset($this->cookie[$this->pre . 'user']) && isset($this->cookie[$this->pre . 'pass'])){
			$cookie_user = intval($this->cookie[$this->pre . 'user']);
			$cookie_pass = addslashes($this->cookie[$this->pre . 'pass']);
			$user = $this->db->fetch("SELECT m.*,  g.group_perms, g.group_name FROM {$this->pre}users m, {$this->pre}amsgroups g WHERE m.user_parent_id=0 AND m.user_id='{$cookie_user}' AND m.user_password='{$cookie_pass}' AND  g.group_id=m.user_amsgroup");

		}
		elseif (isset($this->session['user']) && isset($this->session['pass'])){
			$session_user = intval($this->session['user']);
			$session_pass = addslashes($this->session['pass']);
			$user = $this->db->fetch("SELECT m.*, g.group_perms, g.group_name FROM {$this->pre}users m, {$this->pre}amsgroups g WHERE m.user_parent_id=0 AND m.user_id='{$session_user}' AND m.user_password='{$session_pass}' g.group_id=m.user_amsgroup");
		}

		if ( (!$user) or ($user['user_amsgroup'] == 1)){ //select guest
			$user = $this->db->fetch("SELECT m.*, g.group_perms, g.group_name FROM {$this->pre}users m, {$this->pre}amsgroups g WHERE m.user_parent_id=0 AND m.user_id = ".GUEST_ID." AND g.group_id=m.user_amsgroup");
		}

		return $user;
	}


    function load_skin($section_id=-1, $skin_name=''){

        if ($section_id > 0){
            $this->section_id = $section_id;
        }

        if ($skin_name){
            $this->user['user_amsskin'] = $skin_name;
            $this->skin = $skin_name; //the saved skin, or the default skin if no skin selected
        }
        else{

            if ($this->section_id > 1){ //load skin for specific section (not 0), user has not custom choice here

                $this->load_section($this->section_id);
                $skin_section = $this->Sections[$this->section_id]->skin;
             //   $this->Categories = &$this->Sections[$this->section_id]->Categories;

                $this->skin = $skin_section; //the saved skin, or the default skin if no skin selected

                $query = $this->db->fetch("SELECT * FROM {$this->pre}amsskins WHERE skin_name = '".real_addslashes($this->skin)."'");
                $this->load_skin_sets($query);
                $this->load_url_paths();
                $this->settings['collaboration_model'] = $this->Sections[$this->section_id]->collaboration_model;
          //      $this->plugins = &$this->section_plugins[$this->section_id];
                return;
            }

            $saved_skin_choice = $this->User->skin;
            if (isset($this->get['user_skin'])){  //user changed skin
                $this->session[$this->pre.'user_skin'] = $this->get['user_skin'];
                $this->User->skin = $this->session[$this->pre.'user_skin'];
                $this->db_settings['cache_output'] = 0;
            }
            elseif ( isset($this->session[$this->pre.'user_skin'])){  // skin set in session
                $this->User->skin = $this->session[$this->pre.'user_skin'];
                $this->db_settings['cache_output'] = 0;
            }

            $this->user['user_amsskin'] = $this->User->skin;
            $this->skin = $this->user['user_amsskin']; //the saved skin, or the default skin if no skin selected

        }
        $query = $this->db->fetch("SELECT * FROM {$this->pre}amsskins WHERE skin_name = '".real_addslashes($this->skin)."'");
        $reset_to_default = 0;
        if (!isset($query['skin_name'])){
            $reset_to_default = 1;
        }
        else{
            if ( (!$query['skin_state'])  and (!$this->perms->auth('is_admin'))){ //only admin can change to skin that is locked
                $reset_to_default = 1;
            }
        }
        if ($reset_to_default){  //select default skin again, current choice is no longer available
            unset($this->session[$this->pre.'user_skin']);
            $query = $this->db->fetch("SELECT * FROM {$this->pre}amsskins WHERE skin_name = '".real_addslashes($this->settings['default_skin'])."' LIMIT 1"); //default skin
            if (!isset($query['skin_name'])){
                $query = $this->db->fetch("SELECT * FROM {$this->pre}amsskins WHERE skin_state = 1 LIMIT 1"); //just select whatever skin is enabled
            }
            $this->skin = $query['skin_name'];
            $this->User->skin = $query['skin_name'];
            $this->user['user_amsskin'] = $this->User->skin;
        }
        if (!defined('ARTICLEMS_ADMIN')) {
            $this->Sections[$this->section_id]->skin = $this->skin; //XXX
        }

        $this->load_url_paths();
        $this->load_skin_sets($query);
    }

    function random_loop($num, $min, $max){
       $rand[0] = mt_rand($min, $max);

       for($i = 1; $i<$num; $i++){
            $counter = 0;
           do{
                $counter++;
                if ($counter>100){
                  //  break;
                }
               $check = true;
               if (($max-$min)>($num-$counter)){
                    $rand[$i] = mt_rand($min, $max);

                    for($ii = 0; $ii < (count($rand)-1); $ii++){
                        if($rand[$i] == $rand[$ii] && $check){
                           $check = false;
                           break;
                       }
                   }
                }
           }while (!$check);
       }
       return $rand;
    }

	function get_server_load(){

        return $this->db_settings['server_load'];
	}

    function add_hook($hook, $function_name, $priority=5){

        $priority = 10 - $priority; //so that higher priority is more important

        if (!isset($this->hooks[$hook])){
            $this->hooks[$hook] = array();
            $this->hooks[$hook][] = array($function_name, $priority);
        }
        else{  //already a hook for this action, add it to correct spot depending on priority
            $added = 0;

            for ($i=0; $i<sizeof($this->hooks[$hook]); $i++){
                if ($this->hooks[$hook][$i][1] > $priority){
                    array_splice($this->hooks[$hook], $i, 0, 0);
                    $this->hooks[$hook][$i] = array($function_name, $priority);
                    $added = 1;
                    break;
                }
            }

           if (!$added){
                $this->hooks[$hook][] = array($function_name, $priority);
            }
        }
    }

    function execute_hooks($hook){

        global $Plugins;
        if (isset($this->hooks[$hook])){

            foreach ($this->hooks[$hook] as $hookitem){

                $s = explode('.',$hookitem[0]);
                if (!isset($Plugins->{$s[0]})){
                    $p = 'plugin_'.$s[0];
                    $Plugins->{$s[0]} = new $p($this);
                }
                $Plugins->{$s[0]}->{$s[1]}();
            }
        }
    }

    function execute_hooks_params($hook, $params){

        global $Plugins;
        if (isset($this->hooks[$hook])){

            foreach ($this->hooks[$hook] as $hookitem){

                $s = explode('.',$hookitem[0]);
                if (!isset($Plugins->{$s[0]})){
                    $p = 'plugin_'.$s[0];
                    $Plugins->{$s[0]} = new $p($this);
                }
                if ($params){
                    $Plugins{$s[0]}->{$s[1]}($params);
                }
                else{
                    $Plugins->{$s[0]}->{$s[1]}();
                }
            }
        }
    }

    function generatePassword ($length = 8){

      // start with a blank password
      $password = "";

      // define possible characters
      $possible = "0123456789bcdfghjkmnpqrstvwxyz";

      // set up a counter
      $i = 0;

      // add random characters to $password until $length is reached
      while ($i < $length) {

        // pick a random character from the possible ones
        $char = substr($possible, mt_rand(0, strlen($possible)-1), 1);

        // we don't want this character if it's already in the password
        if (!strstr($password, $char)) {
          $password .= $char;
          $i++;
        }
      }
      return $password;
    }

    function load_skin_sets(&$row){

        $this->skin_settings = unserialize($row['skin_sets']);
        if (!is_array($this->skin_settings)){
            $this->skin_settings = array();
        }

        $this->skin_settings['allow_pennames'] = (isset($this->skin_settings['allow_pennames'])? $this->skin_settings['allow_pennames']: 0);
        $this->skin_settings['articles_use_wysiwyg'] = (isset($this->skin_settings['articles_use_wysiwyg'])? $this->skin_settings['articles_use_wysiwyg']: 1);
        $this->skin_settings['articles_allow_drafts'] = (isset($this->skin_settings['articles_allow_drafts'])? $this->skin_settings['articles_allow_drafts']: 1);
        $this->skin_settings['articles_review_active'] = (isset($this->skin_settings['articles_review_active'])? $this->skin_settings['articles_review_active']: 0);

        $this->skin_settings['article_order'] = (isset($this->skin_settings['article_order'])? $this->skin_settings['article_order']: 'date');
        $this->skin_settings['article_order_dir'] = (isset($this->skin_settings['article_order_dir'])? $this->skin_settings['article_order_dir']: 'DESC');
        $this->skin_settings['comments_order_dir'] = (isset($this->skin_settings['comments_order_dir'])? $this->skin_settings['comments_order_dir']: 'ASC');

        $this->skin_settings['image_invalid_m'] = (isset($this->skin_settings['image_invalid_m'])? $this->skin_settings['image_invalid_m']: 'Invalid Image');
        $this->skin_settings['file_invalid_m'] = (isset($this->skin_settings['file_invalid_m'])? $this->skin_settings['file_invalid_m']: 'Invalid File');

        $this->skin_settings['articles_invalid_file_message'] = (isset($this->skin_settings['articles_invalid_file_message'])? $this->skin_settings['articles_invalid_file_message']: 'Invalid file');
        $this->skin_settings['articles_invalid_image_message'] = (isset($this->skin_settings['articles_invalid_image_message'])? $this->skin_settings['articles_invalid_image_message']: 'Invalid Image');

        $this->skin_settings['articles_decline_duplicate'] = (isset($this->skin_settings['articles_decline_duplicate'])? $this->skin_settings['articles_decline_duplicate']: 0);
        $this->skin_settings['articles_decline_duplicate_message'] = (isset($this->skin_settings['articles_decline_duplicate_message'])? $this->skin_settings['articles_decline_duplicate_message']: 'An article with the same title has already been submitted to this category.');
        $this->skin_settings['articles_invalid_category_message'] = (isset($this->skin_settings['articles_invalid_category_message'])? $this->skin_settings['articles_invalid_category_message']: 'Please select a category.');
        $this->skin_settings['articles_article_length_min'] = (isset($this->skin_settings['articles_article_length_min'])? $this->skin_settings['articles_article_length_min']: 50);
        $this->skin_settings['articles_article_length_max'] = (isset($this->skin_settings['articles_article_length_max'])? $this->skin_settings['articles_article_length_max']: -1);
        $this->skin_settings['articles_article_message'] = (isset($this->skin_settings['articles_article_message'])? $this->skin_settings['articles_article_message']: 'Article is too short.');
        $this->skin_settings['articles_about_length_min'] = (isset($this->skin_settings['articles_about_length_min'])? $this->skin_settings['articles_about_length_min']: 5);
        $this->skin_settings['articles_about_length_max'] = (isset($this->skin_settings['articles_about_length_max'])? $this->skin_settings['articles_about_length_max']: -1);
        $this->skin_settings['articles_about_message'] = (isset($this->skin_settings['articles_about_message'])? $this->skin_settings['articles_about_message']: 'About Author text is too short.');
        $this->skin_settings['articles_summary_length_min'] = (isset($this->skin_settings['articles_summary_length_min'])? $this->skin_settings['articles_summary_length_min']: -1);
        $this->skin_settings['articles_summary_length_max'] = (isset($this->skin_settings['articles_summary_length_max'])? $this->skin_settings['articles_summary_length_max']: 150);
        $this->skin_settings['articles_summary_message'] = (isset($this->skin_settings['articles_summary_message'])? $this->skin_settings['articles_summary_message']: 'Summary is too short.');
        $this->skin_settings['articles_title_length_min'] = (isset($this->skin_settings['articles_title_length_min'])? $this->skin_settings['articles_title_length_min']: 4);
        $this->skin_settings['articles_title_message'] = (isset($this->skin_settings['articles_title_message'])? $this->skin_settings['articles_title_message']: 'Title is too short.');
        $this->skin_settings['articles_keywords_length_min'] = (isset($this->skin_settings['articles_keywords_length_min'])? $this->skin_settings['articles_keywords_length_min']: -1);
        $this->skin_settings['articles_keywords_length_max'] = (isset($this->skin_settings['articles_keywords_length_max'])? $this->skin_settings['articles_keywords_length_max']: -1);
        $this->skin_settings['articles_keywords_message'] = (isset($this->skin_settings['articles_keywords_message'])? $this->skin_settings['articles_keywords_message']: 'Keywords is too short.');
        $this->skin_settings['articles_custom_settings'] = (isset($row['skin_settings_articlesubmit'])? $row['skin_settings_articlesubmit']: '');

        $this->skin_settings['articles_summary_filter_unsafe'] = (isset($this->skin_settings['articles_summary_filter_unsafe'])? $this->skin_settings['articles_summary_filter_unsafe']: 1);
        $this->skin_settings['articles_article_filter_unsafe'] = (isset($this->skin_settings['articles_article_filter_unsafe'])? $this->skin_settings['articles_article_filter_unsafe']: 1);
        $this->skin_settings['articles_about_filter_unsafe'] = (isset($this->skin_settings['articles_about_filter_unsafe'])? $this->skin_settings['articles_about_filter_unsafe']: 1);
        $this->skin_settings['articles_keywords_filter_unsafe'] = (isset($this->skin_settings['articles_keywords_filter_unsafe'])? $this->skin_settings['articles_keywords_filter_unsafe']: 1);
        $this->skin_settings['articles_keywords_field_name'] = (isset($this->skin_settings['articles_keywords_field_name'])? $this->skin_settings['articles_keywords_field_name']: 'keywords');

        $this->skin_settings['articles_custom_string_field_name'] = (isset($this->skin_settings['articles_custom_string_field_name'])? $this->skin_settings['articles_custom_string_field_name']: 'custom_string');
        $this->skin_settings['articles_custom_string_filter_unsafe'] = (isset($this->skin_settings['articles_custom_string_filter_unsafe'])? $this->skin_settings['articles_custom_string_filter_unsafe']: 1);
        $this->skin_settings['articles_custom_string_required'] = (isset($this->skin_settings['articles_custom_string_required'])? $this->skin_settings['articles_custom_string_required']: 0);
        $this->skin_settings['articles_custom_string_message'] = (isset($this->skin_settings['articles_custom_string_message'])? $this->skin_settings['articles_custom_string_message']: 'This field is required.');

        $this->skin_settings['articles_custom_number_field_name'] = (isset($this->skin_settings['articles_custom_number_field_name'])? $this->skin_settings['articles_custom_number_field_name']: 'custom_number');
        $this->skin_settings['articles_custom_number_required'] = (isset($this->skin_settings['articles_custom_number_required'])? $this->skin_settings['articles_custom_number_required']: 0);
        $this->skin_settings['articles_custom_number_message'] = (isset($this->skin_settings['articles_custom_number_message'])? $this->skin_settings['articles_custom_number_message']: 'This field is required.');

        $this->skin_settings['articles_article_tags'] = (isset($this->skin_settings['articles_article_tags'])? $this->skin_settings['articles_article_tags']: 'ALL');
        $this->skin_settings['articles_about_tags'] = (isset($this->skin_settings['articles_about_tags'])? $this->skin_settings['articles_about_tags']: 'ALL');
        $this->skin_settings['articles_summary_tags'] = (isset($this->skin_settings['articles_summary_tags'])? $this->skin_settings['articles_summary_tags']: '<i>');
        $this->skin_settings['articles_keywords_tags'] = (isset($this->skin_settings['articles_keywords_tags'])? $this->skin_settings['articles_keywords_tags']: 'ALL');

        $this->skin_settings['usercp_invalid_email_m'] = (isset($this->skin_settings['usercp_invalid_email_m'])? $this->skin_settings['usercp_invalid_email_m']: 'Invalid Email.');
        $this->skin_settings['usercp_invalid_avatar_m'] = (isset($this->skin_settings['usercp_invalid_avatar_m'])? $this->skin_settings['usercp_invalid_avatar_m']: 'Invalid Avatar Image.');
        $this->skin_settings['usercp_invalid_picture_m'] = (isset($this->skin_settings['usercp_invalid_picture_m'])? $this->skin_settings['usercp_invalid_picture_m']: 'Invalid Picture Image.');
        $this->skin_settings['usercp_invalid_birthday_m'] = (isset($this->skin_settings['usercp_invalid_birthday_m'])? $this->skin_settings['usercp_invalid_birthday_m']: 'Invalid Date for birthday.');
        $this->skin_settings['usercp_custom_settings'] = (isset($row['skin_settings_usercp'])? $row['skin_settings_usercp']: '');

        $this->skin_settings['usercp_image_avatar_max_size'] = (isset($this->skin_settings['usercp_image_avatar_max_size'])? $this->skin_settings['usercp_image_avatar_max_size']: 30720); //30kb
        $this->skin_settings['usercp_image_avatar_filetypes'] = (isset($this->skin_settings['usercp_image_avatar_filetypes'])? $this->skin_settings['usercp_image_avatar_filetypes']: 'jpg;gif;png;swf');
        $this->skin_settings['usercp_image_picture_max_size'] = (isset($this->skin_settings['usercp_image_picture_max_size'])? $this->skin_settings['usercp_image_picture_max_size']: 61440); //60kb
        $this->skin_settings['usercp_image_picture_filetypes'] = (isset($this->skin_settings['usercp_image_picture_filetypes'])? $this->skin_settings['usercp_image_picture_filetypes']: 'jpg;gif;png;swf');

        $this->skin_settings['login_invalid_password_m'] = (isset($this->skin_settings['login_invalid_password_m'])? $this->skin_settings['login_invalid_password_m']: 'Invalid Username/Password.');
        $this->skin_settings['login_unconfirmed_m'] = (isset($this->skin_settings['login_unconfirmed_m'])? $this->skin_settings['login_unconfirmed_m']: 'Your account is not yet activated, you must click the link in the welcome email.');
        $this->skin_settings['registration_duplicate_name_m'] = (isset($this->skin_settings['registration_duplicate_name_m'])? $this->skin_settings['registration_duplicate_name_m']: 'An user with that name already exists.');
        $this->skin_settings['registration_duplicate_email_m'] = (isset($this->skin_settings['registration_duplicate_email_m'])? $this->skin_settings['registration_duplicate_email_m']: 'An user with that email already exists.');
        $this->skin_settings['registration_invalid_email_m'] = (isset($this->skin_settings['registration_invalid_email_m'])? $this->skin_settings['registration_invalid_email_m']: 'Please enter a valid email address.');
        $this->skin_settings['registration_minimum_password_length'] = (isset($this->skin_settings['registration_minimum_password_length'])? $this->skin_settings['registration_minimum_password_length']: 6);
        $this->skin_settings['registration_minimum_password_length_m'] = (isset($this->skin_settings['registration_minimum_password_length_m'])? $this->skin_settings['registration_minimum_password_length_m']: 'Passwords must be at least 6 characters long.');
        $this->skin_settings['registration_passwords_dont_match_m'] = (isset($this->skin_settings['registration_passwords_dont_match_m'])? $this->skin_settings['registration_passwords_dont_match_m']: 'Passwords don\'t match.');
        $this->skin_settings['registration_minimum_username_length'] = (isset($this->skin_settings['registration_minimum_username_length'])? $this->skin_settings['registration_minimum_username_length']: 1);
        $this->skin_settings['registration_minimum_username_length_m'] = (isset($this->skin_settings['registration_minimum_username_length_m'])? $this->skin_settings['registration_minimum_username_length_m']: 'Please enter your username.');
        $this->skin_settings['registration_custom_settings'] = (isset($row['skin_settings_registration'])? $row['skin_settings_registration']: '');

        $this->skin_settings['comments_text_length_min'] = (isset($this->skin_settings['comments_text_length_min'])? $this->skin_settings['comments_text_length_min']: 2);
        $this->skin_settings['comments_text_length_max'] = (isset($this->skin_settings['comments_text_length_max'])? $this->skin_settings['comments_text_length_max']: -1);
        $this->skin_settings['comments_text_message'] = (isset($this->skin_settings['comments_text_message'])? $this->skin_settings['comments_text_message']: 'Invalid comment text.');
        $this->skin_settings['comments_text_filter_unsafe'] = (isset($this->skin_settings['comments_text_filter_unsafe'])? $this->skin_settings['comments_text_filter_unsafe']: 1);
        $this->skin_settings['comments_text_tags'] = (isset($this->skin_settings['comments_text_tags'])? $this->skin_settings['comments_text_tags']: '<a>');
        $this->skin_settings['comments_require_author_name'] = (isset($this->skin_settings['comments_require_author_name'])? $this->skin_settings['comments_require_author_name']: 0);
        $this->skin_settings['comments_require_author_name_m'] = (isset($this->skin_settings['comments_require_author_name_m'])? $this->skin_settings['comments_require_author_name_m']: 'Please enter your name.');
        $this->skin_settings['comments_require_email'] = (isset($this->skin_settings['comments_require_email'])? $this->skin_settings['comments_require_email']: 0);
        $this->skin_settings['comments_require_email_m'] = (isset($this->skin_settings['comments_require_email_m'])? $this->skin_settings['comments_require_email_m']: 'Please enter your email.');
        $this->skin_settings['comments_custom_settings'] = (isset($row['skin_settings_commentsubmit'])? $row['skin_settings_commentsubmit']: '');

        $this->skin_settings['usercp_bio_length_min'] = (isset($this->skin_settings['usercp_bio_length_min'])? $this->skin_settings['usercp_bio_length_min']: -1);
        $this->skin_settings['usercp_bio_length_max'] = (isset($this->skin_settings['usercp_bio_length_max'])? $this->skin_settings['usercp_bio_length_max']: -1);
        $this->skin_settings['usercp_bio_message'] = (isset($this->skin_settings['usercp_bio_message'])? $this->skin_settings['usercp_bio_message']: 'Please enter your bio.');
        $this->skin_settings['usercp_bio_tags'] = (isset($this->skin_settings['usercp_bio_tags'])? $this->skin_settings['usercp_bio_tags']: '<a><b><i><strong><em><img><u>');
        $this->skin_settings['usercp_bio_filter_unsafe'] = (isset($this->skin_settings['usercp_bio_filter_unsafe'])? $this->skin_settings['usercp_bio_filter_unsafe']: 1);

        $this->skin_settings['image_verification_m'] = (isset($this->skin_settings['image_verification_m'])? $this->skin_settings['image_verification_m']: 'You must enter the verification code');

        $this->skin_settings['date_format'] = (isset($this->skin_settings['date_format'])? $this->skin_settings['date_format']: 'D, j M Y');
        $this->skin_settings['time_format'] = (isset($this->skin_settings['time_format'])? $this->skin_settings['time_format']: 'g:i A');
        $this->skin_settings['articles_per_page'] = isset($this->skin_settings['articles_per_page'])? $this->skin_settings['articles_per_page']: 10;
        $this->skin_settings['articles_per_feed'] = isset($this->skin_settings['articles_per_feed'])? $this->skin_settings['articles_per_feed']: 10;
        $this->skin_settings['members_per_page'] = isset($this->skin_settings['members_per_page'])? $this->skin_settings['members_per_page']: 10;
        $this->skin_settings['media_per_page'] = isset($this->skin_settings['media_per_page'])? $this->skin_settings['media_per_page']: 10;
        $this->skin_settings['include_subcategories'] = isset($this->skin_settings['include_subcategories'])? $this->skin_settings['include_subcategories']: 0;

        $this->skin_settings['email_subscribe_approve'] = (isset($this->skin_settings['email_subscribe_approve'])? $this->skin_settings['email_subscribe_approve']: 1);
        $this->skin_settings['email_subscribe_approve_skip'] = (isset($this->skin_settings['email_subscribe_approve_skip'])? $this->skin_settings['email_subscribe_approve_skip']: 0);
        $this->skin_settings['email_subscribe_reject'] = (isset($this->skin_settings['email_subscribe_reject'])? $this->skin_settings['email_subscribe_reject']: 1);
        $this->skin_settings['email_subscribe_comment_added'] = (isset($this->skin_settings['email_subscribe_comment_added'])? $this->skin_settings['email_subscribe_comment_added']: 1);
        $this->skin_settings['email_subscribe_article_modification'] = (isset($this->skin_settings['email_subscribe_article_modification'])? $this->skin_settings['email_subscribe_article_modification']: 1);

    }

    function add_error_message($message, $element='', $critital_error=0){

        if (!$this->error_messages){
            $this->error_messages = array();
        }

        $this->error_messages[] = array($message, $element);

        if ($critital_error){
            $this->error_messages_critical = 1;
        }

    }

    function load_plugins(){

        global $Plugins;

        if (!is_array($this->plugins)){
            $this->plugins = array();
        }



        foreach ($this->plugins as $plugin_name=>$val){

            if ($this->installed_plugins[$plugin_name] and $val){ //if plugin is installed

                $this->_current_plugin = $plugin_name;

                if (!$Plugins->{$plugin_name}){
                    $autoload = 1;
                    include 'plugins/'.$plugin_name.'/'.$plugin_name.'.php';
                    $p = 'plugin_'.$plugin_name;
                    if ($autoload){
                        $Plugins->{$plugin_name} = new $p($this);
                    }
                }
            }
        }

    }

    function load_url_paths(){


        $this->Url->feed = $this->relpath.'latest/?fmt=rss';
        $this->Url->relpath_abs = $this->relpath_abs;
        $this->Url->rootpath_abs = $this->rootpath_abs;

        $this->Url->submit = $this->relpath.$this->settings['url_submit'].'/';

        $this->Url->tags = $this->relpath.$this->settings['url_tags'].'/';
        $this->Url->edit_article = $this->relpath.$this->settings['url_edit_article'].'/';
        $this->Url->login = $this->relpath_main.$this->settings['url_login'].'/';
        $this->Url->login_abs = $this->settings['site_location'].$this->relpath_main.$this->settings['url_login'].'/';
        $this->Url->pwreset = $this->relpath_main.$this->settings['url_pwreset'].'/';
        $this->Url->logout = $this->Url->login.'?s=out';
        $this->Url->register = $this->relpath_main.$this->settings['url_register'].'/';
        $this->Url->search = $this->relpath.$this->settings['url_search'].'/';

        if ($this->Sections[$this->section_id]->settings['custom_usercp']){
            $this->Url->usercp = $this->relpath.$this->settings['url_usercp'].'/';
        }
        else{
            $this->Url->usercp = $this->relpath_main.$this->settings['url_usercp'].'/';
        }
        if ($this->Sections[$this->section_id]->settings['custom_profile']){
            $this->Url->profile = $this->relpath.$this->settings['url_profile'].'/';
        }
        else{
            $this->Url->profile = $this->relpath_main.$this->settings['url_profile'].'/';
        }

        $this->Url->preferences = $this->relpath.$this->settings['url_userpreferences'].'/';
        $this->Url->members = $this->relpath_main.$this->settings['url_memberlist'].'/';
        $this->Url->verification = $this->relpath_main.$this->settings['url_verification'].'/';
        $this->Url->media = $this->relpath.$this->settings['url_media'].'/';

        $this->Url->domain = $this->settings['site_location'];
        $this->Url->relpath = $this->relpath;
        $this->Url->root = $this->rootpath;
        $this->Url->files = $this->Url->root.'uploads/files/';
        $this->Url->images = $this->Url->root.'uploads/images/';
        $this->Url->images_abs = $this->rootpath_abs.'uploads/images/';
        $this->Url->files_abs = $this->rootpath_abs.'uploads/files/';
        $this->Url->images_rel = 'uploads/images/';
        $this->Url->files_rel = 'uploads/files/';

    }

    function load_section($section_id=0){

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        $this->section_id = $section_id;

        if ($this->section_id > 1){
            $this->pre_section = $this->pre . 's'. $this->section_id . '_';

            $row = $this->db->fetch("SELECT skin_sets FROM {$this->pre}amsskins WHERE skin_name = '".real_addslashes($this->Sections[1]->skin)."'");

            $skin_settings_main = unserialize($row['skin_sets']);
            if (!is_array($skin_settings_main)){
                $skin_settings_main = array();
            }

            $this->skin_settings_usercp_main = (isset($skin_settings_main['usercp_custom_fields'])? $skin_settings_main['usercp_custom_fields']: '');

        }
        $this->relpath = $this->Sections[$section_id]->relpath;

        $plugins = $this->Sections[$section_id]->plugins;
        if (!is_array($plugins)){
            $plugins = array();
        }
        $this->plugins = $plugins;

        $this->installed_plugins = $this->Sections[$section_id]->installed_plugins;
        if (!is_array($this->installed_plugins)){
            $this->installed_plugins = array();
        }

        $this->Sections[$section_id]->article_views = array();
        $_blockq_q = $this->db->query("SELECT block_name FROM {$this->pre}blocks
                      WHERE  block_active = 1 AND block_type = 0 AND block_set = 'articleview'
                AND (block_owner = '{$this->Sections[$section_id]->skin}' OR block_owner LIKE '_plugin_s{$section_id}_%')");

        while ($_blockq = $this->db->nqfetch($_blockq_q)){
            $this->Sections[$section_id]->article_views[] = $_blockq['block_name'];
        }

        $this->load_autoload_options();
        $this->clear_options_cache();

        $this->Stats = new baseclass();

        $this->Stats->article_count = (isset($this->Sections[$section_id]->stats['article_count'])? $this->Sections[$section_id]->stats['article_count']: 0);
        $this->Stats->article_count_pending = (isset($this->Sections[$section_id]->stats['article_count_pending'])? $this->Sections[$section_id]->stats['article_count_pending']: 0);
        $this->Stats->article_count_declined = (isset($this->Sections[$section_id]->stats['article_count_declined'])? $this->Sections[$section_id]->stats['article_count_declined']: 0);
        $this->Stats->article_count_draft = (isset($this->Sections[$section_id]->stats['article_count_draft'])? $this->Sections[$section_id]->stats['article_count_draft']: 0);
        $this->Stats->category_count = (isset($this->Sections[$section_id]->stats['category_count'])? $this->Sections[$section_id]->stats['category_count']: 0);
        $this->Stats->category_count_inclusive = (isset($this->Sections[$section_id]->stats['category_count_inclusive'])? $this->Sections[$section_id]->stats['category_count_inclusive']: 0);
        $this->Stats->user_count = (isset($this->Sections[$section_id]->stats['user_count'])? $this->Sections[$section_id]->stats['user_count']: 0);
        $this->Stats->comment_count = (isset($this->Sections[$section_id]->stats['comment_count'])? $this->Sections[$section_id]->stats['comment_count']: 0);
        $this->Stats->comment_count_pending = (isset($this->Sections[$section_id]->stats['comment_count_pending'])? $this->Sections[$section_id]->stats['comment_count_pending']: 0);
        $this->Stats->comment_count_declined = (isset($this->Sections[$section_id]->stats['comment_count_declined'])? $this->Sections[$section_id]->stats['comment_count_declined']: 0);

        $this->Categories = $this->Sections[$this->section_id]->Categories;
        $this->CategoryTree = $this->Sections[$this->section_id]->CategoryTree;
        $this->Pages = &$this->Sections[$this->section_id]->Pages;
        $this->PageTree = &$this->Sections[$this->section_id]->PageTree;
    }

    function load_sections(){

        $this->Sections = array();

        $q = $this->db->query("SELECT * FROM {$this->pre}sections WHERE section_state > 0");
        while ($row = $this->db->nqfetch($q)){

            $this->Sections[$row['section_id']] = new baseclass();
            $this->Sections[$row['section_id']]->id = $row['section_id'];
            $this->Sections[$row['section_id']]->name = $row['section_name'];
            $this->Sections[$row['section_id']]->state = $row['section_state'];
            $this->Sections[$row['section_id']]->skin = $row['section_skin'];
            $this->Sections[$row['section_id']]->url = $row['section_url'];
            if ($row['section_id'] == 1){
                $this->Sections[$row['section_id']]->relpath = $this->relpath_main;
            }
            else{
                $this->Sections[$row['section_id']]->relpath = $this->relpath_main . $row['section_url'].'/';
            }
            $this->Sections[$row['section_id']]->perms = unserialize($row['section_perms']);
            $plugins = unserialize($row['section_plugins']);
            if (!is_array($plugins)){
                $plugins = array();
            }
            if (!is_array($plugins['installed_plugins'])){
                $plugins['installed_plugins'] = array();
            }
            if (!is_array($plugins['active_plugins'])){
                $plugins['active_plugins'] = array();
            }
            $this->Sections[$row['section_id']]->installed_plugins = $plugins['installed_plugins'];
            $this->Sections[$row['section_id']]->plugins = $plugins['active_plugins'];
            $this->Sections[$row['section_id']]->settings = unserialize($row['section_settings']);
            if (!is_array($this->Sections[$row['section_id']]->settings)){
                $this->Sections[$row['section_id']]->settings = array();
            }
            $this->Sections[$row['section_id']]->stats = unserialize($row['section_stats']);
            $this->Sections[$row['section_id']]->collaboration_model = $row['section_collaboration_model'];
        }
        $this->Sections[1]->skin = $this->settings['default_skin'];
        $this->Sections[1]->relpath = $this->relpath_main;


        if (false and isset($this->options['CategoryTree']) and ($this->options['CategoryTree'])){
            $this->CategoryTree = &$this->options['CategoryTree'];
            $this->Categories = &$this->options['Categories'];
            $this->categorytree = &$this->options['categorytree_by_id'];
        }
        else{

            foreach($this->Sections as $Section){

                $this->CategoryTree = array();

                $this->_categorytree = array();
                $this->categorytree = array();
                $this->categorytree = $this->getCategoryTree(0, $Section->id);

                $this->Sections[$Section->id]->Categories = array();

                for ($i=0; $i<sizeof($this->categorytree); $i++){

                    $this->CategoryTree[$this->categorytree[$i]['category_id']] = new baseclass();
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->title = $this->categorytree[$i]['category_title'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->level = $this->categorytree[$i]['category_level'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->urltitle = $this->categorytree[$i]['category_urltitle'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->id = $this->categorytree[$i]['category_id'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->parent_id = $this->categorytree[$i]['category_parent_id'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->parentid = &$this->CategoryTree[$this->categorytree[$i]['category_id']]->parent_id; //backwards compatibility
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->description = $this->categorytree[$i]['category_description'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->meta = $this->categorytree[$i]['category_meta'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->image = $this->categorytree[$i]['category_image'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->_perms = ($this->categorytree[$i]['category_perms']? unserialize($this->categorytree[$i]['category_perms']): array());
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->_moderators = ($this->categorytree[$i]['category_moderators']? unserialize($this->categorytree[$i]['category_moderators']): array());

                    $set = unserialize($this->categorytree[$i]['category_sets']);
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->sub_category_count = $set['sub_category_count'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->sub_category_count_inclusive = $set['sub_category_count_inclusive'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->article_count = $set['article_count'];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->article_count_inclusive = $set['article_count_inclusive'];

                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->Parent = &$this->CategoryTree[$this->categorytree[$i]['category_parent_id']];
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->section_id = $Section->id;
                }

                $Section->Categories = array();

                for ($i=0; $i<sizeof($this->categorytree); $i++){
                    $Cat = &$this->CategoryTree[$this->categorytree[$i]['category_id']];
                    $s = $Cat->urltitle;
                    $parent_id = $Cat->parent_id;
                    $t = 0;
                    while ($parent_id > 0){
                        $t++;
                        if ($t>500){
                            exit('BROKEN CATEGORY TREE');
                            break;
                        }
                        $Cat = &$Cat->Parent;
                        $parent_id = $Cat->parent_id;
                        $s = $Cat->urltitle.'/'.$s;
                    }

                    $cat_url = $Section->relpath.$s.'/';
                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->url = $cat_url;

                    $this->CategoryTree[$this->categorytree[$i]['category_id']]->url_feed = $cat_url.'?fmt=rss';
                    $this->Sections[$Section->id]->Categories[] = $this->CategoryTree[$this->categorytree[$i]['category_id']];

                }

                $this->Sections[$Section->id]->CategoryTree = $this->CategoryTree;
            }

            unset($this->_categorytree);

      //      $this->save_option('CategoryTree',$this->CategoryTree, 1);
         //   $this->save_option('Categories',$this->Categories, 1);
            unset($this->categorytree);
        }

        if (false and isset($this->options['PageTree']) and ($this->options['PageTree'])){
            $this->PageTree = &$this->options['PageTree'];
            $this->Pages = &$this->options['Pages'];
        //    $this->pagetree = &$this->options['pagetree_by_id'];
        }
        else{

            foreach($this->Sections as $Section){

                $this->PageTree = array();
                $this->_pagetree = array();
                $this->pagetree = array();
                $this->pagetree = $this->getPageTree(0, $Section->id);

                $Section->Pages = array();
                for ($i=0; $i<sizeof($this->pagetree); $i++){
                    $this->PageTree[$this->pagetree[$i]['page_id']] = new baseclass();
                    $this->PageTree[$this->pagetree[$i]['page_id']]->id = $this->pagetree[$i]['page_id'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->level = $this->pagetree[$i]['page_level'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->sets = unserialize($this->pagetree[$i]['page_sets']);
                    $this->PageTree[$this->pagetree[$i]['page_id']]->title = $this->pagetree[$i]['page_title'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->parent_id = $this->pagetree[$i]['page_parent_id'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->urltitle = $this->pagetree[$i]['page_url'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->allow_comments = (isset($this->PageTree[$this->pagetree[$i]['page_id']]->sets['allow_comments'])? $this->PageTree[$this->pagetree[$i]['page_id']]->sets['allow_comments']: 0);

                    $this->PageTree[$this->pagetree[$i]['page_id']]->date = $this->pagetree[$i]['page_date2'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->time = $this->pagetree[$i]['page_datetime'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->url = $this->relpath.$this->pagetree[$i]['page_url'].'.'.$this->settings['url_extension'];
                    $this->PageTree[$this->pagetree[$i]['page_id']]->Parent = &$this->PageTree[$this->pagetree[$i]['page_parent_id']];

                    $this->Sections[$Section->id]->Pages[] = $this->PageTree[$this->pagetree[$i]['page_id']];
                }

                $this->Sections[$Section->id]->PageTree = $this->PageTree;
            }
            unset( $this->_pages);


          //  $this->save_option('PageTree',$this->PageTree, 1);
          //  $this->save_option('Pages',$this->Pages, 1);
          //  $this->save_option('pagetree_by_id',$this->pagetree, 1);

            unset($this->_pagetree);
            unset($this->pagetree);
        }

    }

	/**
	* Loads Settings
	 */
    function loadSettings(&$row){

        global $Plugins;
        $Plugins = new baseclass();
		$this->time    = time();
		$this->query   = isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : null;
		$this->ip      = addslashes($_SERVER['REMOTE_ADDR']);
		$this->agent   = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : null;
		$this->self    = $_SERVER['PHP_SELF'];
		$this->server  = $_SERVER;
		$this->get     = $_GET;
		$this->post    = $_POST;
		$this->cookie  = $_COOKIE;
		$this->files   = $_FILES;
		$this->session = &$_SESSION;
        $this->cookie_path = $this->db_settings['cookie_path'];
        $this->logintime = ($this->db_settings['login_time']? $this->db_settings['login_time']: (60*60*24*300) );
        $this->server_load = $this->get_server_load();
        $this->bypass_cms = 0;
        $this->bypass_parent = 0;
        $this->dollar = '$';

        $this->pre_section = $this->pre;
    	$this->settings = unserialize($row['settings_settings']);

        $this->sets = unserialize($row['settings_sets']);
        $this->adminsets = unserialize($row['settings_adminsets']);
        if (!is_array($this->adminsets)){
            $this->adminsets = array();
        }
        $this->adminsets['admin_skin'] = isset($this->adminsets['admin_skin'])? $this->adminsets['admin_skin']: 'default';
        $this->adminsets['admin_section'] = isset($this->adminsets['admin_section'])? $this->adminsets['admin_section']: 1;

        $this->copyright = 'Powered by <a href="http://www.articlems.com/">ArticleMS</a> from <a href="http://www.articletrader.com">ArticleTrader</a>';
        $this->settings['site_name'] = (isset($this->settings['site_name'])? $this->settings['site_name']: 'ArticleMS');
        $this->site_name = $this->settings['site_name'];
        $this->settings['sitename'] = $this->settings['site_name']; //backwards support

        $this->meta_includes = '';
        $this->title = $this->site_name;
        $this->link_includes = '';
        $this->css_includes = '';
        $this->js_includes = '';
        $this->style_includes = '';
        $this->javascript = '';
        $this->jquery_ready = '';
        $this->headerextra = '';
        $this->js_include_array = array();
        $this->css_include_array = array();
        $this->stylesheet = 'styles.css';
        $this->start_body_includes = '';
        $this->end_body_includes = '';
        $this->output_header = 'Content-Type:text/html; charset=UTF-8';

        $this->settings['mod_rewrite'] = (isset($this->settings['mod_rewrite'])? $this->settings['mod_rewrite']: '1');
        $this->settings['site_name'] = (isset($this->settings['site_name'])? $this->settings['site_name']: 'ArticleMS');
        $this->settings['site_location'] = (isset($this->settings['site_location'])? $this->settings['site_location']: 'http://'.$_SERVER['HTTP_HOST']);
        $this->settings['sitelocation'] = $this->settings['site_location'];

        $this->settings['email_verification'] = (isset($this->settings['email_verification'])? $this->settings['email_verification']: 0);

        $this->settings['use_wysiwyg_pages'] = (isset($this->settings['use_wysiwyg_pages'])? $this->settings['use_wysiwyg_pages']: 1);

        $this->settings['relpath'] = (isset($this->settings['relpath'])? $this->settings['relpath']: '/');
        $this->settings['version'] = (isset($this->settings['version'])? $this->settings['version']: $this->version);
        $this->version = $this->settings['version'];
        $this->relpath = $this->settings['relpath'];
        $this->rootpath = $this->relpath;

        if (!$this->settings['mod_rewrite']){
            $this->relpath .= 'index.php/';
        }
        $this->relpath_main =  $this->relpath;

        $this->relpath_abs = $this->settings['site_location'].$this->relpath;
        $this->rootpath_abs = $this->settings['site_location'].$this->rootpath;
        $this->sitepath = $this->settings['site_location'].$this->rootpath;
        $this->filepath = $this->rootpath.'uploads/files/';
        $this->imagepath = $this->rootpath.'uploads/images/';
        $this->settings['default_skin'] = (isset($this->settings['default_skin'])? $this->settings['default_skin']: 'default');
        $this->settings['default_group_id'] = (isset($this->settings['default_group_id'])? $this->settings['default_group_id']: 3);
        $this->default_group_id = &$this->settings['default_group_id'];

		$this->settings['number_of_rows_articles'] = isset($this->settings['number_of_rows_articles'])? $this->settings['number_of_rows_articles']: 10;

        $this->settings['collaboration_model'] = (isset($this->settings['collaboration_model'])? $this->settings['collaboration_model']: 'closed');

		$this->settings['use_cron'] = (isset($this->settings['use_cron'])? $this->settings['use_cron']: 0);
		$this->settings['use_cron_test'] = (isset($this->settings['use_cron_test'])? $this->settings['use_cron_test']: 0);

		$this->settings['email_reply_to'] = (isset($this->settings['email_reply_to']))? $this->settings['email_reply_to']: 'noreply@example.com';

        $this->settings['email_subscribe_welcome'] = (isset($this->settings['email_subscribe_welcome'])? $this->settings['email_subscribe_welcome']: 0);
        $this->settings['email_debug'] = (isset($this->settings['email_debug'])? $this->settings['email_debug']: 0);

        $this->settings['site_email'] = (isset($this->settings['site_email'])? $this->settings['site_email']: 'admin@example.com');
        $this->settings['errors_notify_level'] = (isset($this->settings['errors_notify_level'])? $this->settings['errors_notify_level']: 1);
        $this->settings['errors_debug_mode'] = (isset($this->settings['errors_debug_mode'])? $this->settings['errors_debug_mode']: 1);

        $this->settings['image_max_size'] = (isset($this->settings['image_max_size'])? $this->settings['image_max_size']: 61440);
        $this->settings['image_allowed_extensions'] = (isset($this->settings['image_allowed_extensions'])? $this->settings['image_allowed_extensions']: 'jpg;gif;png');

        $this->settings['image_thumbnail_width'] = (isset($this->settings['image_thumbnail_width'])? $this->settings['image_thumbnail_width']: 200);
        $this->settings['image_thumbnail_height'] = (isset($this->settings['image_thumbnail_height'])? $this->settings['image_thumbnail_height']: 200);

        $this->settings['file_max_size'] = (isset($this->settings['file_max_size'])? $this->settings['file_max_size']: 5242880);
        $this->settings['file_allowed_extensions'] = (isset($this->settings['file_allowed_extensions'])? $this->settings['file_allowed_extensions']: 'zip;gz;tar;txt;doc');

        $this->settings['gzip_compression'] = (isset($this->settings['gzip_compression'])? $this->settings['gzip_compression']: '0');
        if ($this->settings['gzip_compression']){
        	ob_start("ob_gzhandler");
        }

        $this->settings['image_verification_recaptcha'] = (isset($this->settings['image_verification_recaptcha'])? $this->settings['image_verification_recaptcha']: 0);
        if ($this->settings['image_verification_recaptcha']){
            require('lib/recaptcha/recaptchalib.php');
        }

        $this->settings['image_verification_recaptcha_public_key'] = (isset($this->settings['image_verification_recaptcha_public_key'])? $this->settings['image_verification_recaptcha_public_key']: '');
        $this->recaptcha_public_key = $this->settings['image_verification_recaptcha_public_key'];
        $this->settings['image_verification_recaptcha_private_key'] = (isset($this->settings['image_verification_recaptcha_private_key'])? $this->settings['image_verification_recaptcha_private_key']: '');
        $this->recaptcha_private_key = $this->settings['image_verification_recaptcha_private_key'];
        $this->settings['image_verification_register'] = (isset($this->settings['image_verification_register'])? $this->settings['image_verification_register']: '');
        $this->settings['image_verification_login'] = (isset($this->settings['image_verification_login'])? $this->settings['image_verification_login']: '');

        $this->settings['comments_avatar'] = (isset($this->settings['comments_avatar'])? $this->settings['comments_avatar']: '');

        $this->settings['url_extension'] = (isset($this->db_settings['url_extension'])? $this->db_settings['url_extension']: 'html');
        $this->settings['url_submit'] = (isset($this->settings['url_submit'])? $this->settings['url_submit']: 'submit');
        $this->settings['url_login'] = (isset($this->settings['url_login'])? $this->settings['url_login']: 'login');
        $this->settings['url_pwreset'] = (isset($this->settings['url_pwreset'])? $this->settings['url_pwreset']: 'pwreset');
        $this->settings['url_register'] = (isset($this->settings['url_register'])? $this->settings['url_register']: 'register');
        $this->settings['url_search'] = (isset($this->settings['url_search'])? $this->settings['url_search']: 'search');
        $this->settings['url_tags'] = (isset($this->settings['url_tags'])? $this->settings['url_tags']: 'tags');
        $this->settings['url_usercp'] = (isset($this->settings['url_usercp'])? $this->settings['url_usercp']: 'usercp');
        $this->settings['url_userpreferences'] = (isset($this->settings['url_userpreferences'])? $this->settings['url_userpreferences']: 'prefs');
        $this->settings['url_profile'] = (isset($this->settings['url_profile'])? $this->settings['url_profile']: 'profile');
        $this->settings['url_profile_structure'] = (isset($this->settings['url_profile_structure'])? $this->settings['url_profile_structure']: '%user_name%-');
        $this->settings['url_edit_article'] = (isset($this->settings['url_edit_article'])? $this->settings['url_edit_article']: 'edit');
        $this->settings['url_articleview'] = (isset($this->settings['url_articleview'])? $this->settings['url_articleview']: 'view');
        $this->settings['url_verification'] = (isset($this->settings['url_verification'])? $this->settings['url_verification']: 'verify');
        $this->settings['url_email_unsubscribe'] = (isset($this->settings['url_email_unsubscribe'])? $this->settings['url_email_unsubscribe']: 'unsubscribe');
        $this->settings['url_memberlist'] = (isset($this->settings['url_memberlist'])? $this->settings['url_memberlist']: 'members');
        $this->settings['url_media'] = (isset($this->settings['url_media'])? $this->settings['url_media']: 'media');
        $this->settings['url_comment_feeds'] = (isset($this->settings['url_comment_feeds'])? $this->settings['url_comment_feeds']: 'comment_feeds');

        $groupq = $this->db->query("SELECT group_id, group_name FROM {$this->pre}amsgroups");
		$this->group_names = array();
		while ($grouprow = $this->db->nqfetch($groupq)){
			$this->group_names[$grouprow['group_id']] = $grouprow['group_name'];
		}

        $this->Url = new baseclass();
        $this->Url->site = $this->settings['site_location'];

        $this->load_sections();
        $this->include_js('jquery.js');
        $this->include_js('articlems.js');

    }

    function include_js($js, $use_full_path=0){

        if (!$use_full_path){
            $js = "{$this->rootpath}js/{$js}";
        }

        if (!in_array($js, $this->js_include_array)){
            $this->js_include_array[] = $js;
        }
    }
    function include_css($css, $use_full_path=0){

        if (!$use_full_path){
            $css = "{$this->rootpath}skins/{$this->skin}/{$css}";
        }
        elseif ($use_full_path == 1){
            $css = "{$this->rootpath}{$css}";
        }
        if (!in_array($css, $this->css_include_array)){
            $this->css_include_array[] = $css;
        }
    }

    function delete_option($option_name){

        $q = $this->db->query("DELETE FROM {$this->pre}options WHERE option_name = '".addslashes($option_name)."' LIMIT 1");
    }

    function save_option($option_name, $option_value, $autoload=-1, $section_id=-1){

        if ($section_id == -1){
            $section_id = $this->section_id;
        }

        $autoload = intval($autoload);
        $q = $this->db->query("SELECT option_id, option_autoload FROM {$this->pre}options WHERE option_section_id = $section_id AND option_name = '".addslashes($option_name)."' LIMIT 1");
        if ($row = $this->db->nqfetch($q)){

            if ($autoload == -1){
                $autoload = intval($row['option_autoload']);
            }

            $q_update = $this->db->query("UPDATE {$this->pre}options SET
                                            option_value = '".addslashes(serialize($option_value))."',
                                            option_autoload = {$autoload}
                                            WHERE option_id = {$row['option_id']} LIMIT 1");
        }
        else{
            if ($autoload == -1){
                $autoload = 0;
            }
            $q_insert = $this->db->query("INSERT INTO {$this->pre}options SET
                                            option_name = '".addslashes($option_name)."',
                                            option_value = '".addslashes(serialize($option_value))."',
                                            option_section_id = $section_id,
                                            option_autoload = {$autoload}");
        }

        $this->options[$option_name] = unserialize(serialize($option_value));  //store copy of the object
    }

    function load_option($option_name, $section_id=-1){


        if ($section_id == -1){
            $section_id = $this->section_id;

            if (isset($this->options[$option_name])){
                return $this->options[$option_name];
            }
        }

        $q = $this->db->query("SELECT option_value FROM {$this->pre}options WHERE option_section_id = $section_id AND option_name = '".addslashes($option_name)."' LIMIT 1");
        if ($row = $this->db->nqfetch($q)){

            $result = unserialize($row['option_value']);
            if (($section_id == 0) or ($section_id == $this->section_id)){
                $this->options[$option_name] = $result;
            }
            return $result;
        }
        else{
            return null;
        }
    }

    function load_autoload_options(){

        $this->options = array();
        $q = $this->db->query("SELECT option_name, option_value FROM {$this->pre}options WHERE (option_section_id = 0 OR option_section_id = {$this->section_id}) AND option_autoload = 1");
        while ($row = $this->db->nqfetch($q)){

            $this->options[$row['option_name']] = unserialize($row['option_value']);
        }
    }

    function clear_options_cache(){

        $this->delete_option('CategoryTree');
        $this->delete_option('Categories');
  //      $this->delete_option('categorytree_by_id');
        $this->delete_option('PageTree');
        $this->delete_option('Pages');
   //     $this->delete_option('pagetree_by_id');
    }

    //here for backwards compatibility
	function mbdate($time = 0, $useToday = true){

		if (!$time) {
			$time = $this->time;
		}
		$this->tz_adjust = 0;

		$date_format = 'j M Y';
		$time_format = ' ';

		if (!$useToday) {
			$date = gmdate($date_format, $time);
		} else if ($date_format) {
			$date = gmdate($date_format, $time);
			$today = gmdate($date_format, $this->time + $this->tz_adjust);
			$yesterday = gmdate($date_format, ($this->time - DAY_IN_SECONDS) + $this->tz_adjust);

			if ($today == $date) {
				$date = 'Today';
			} elseif ($yesterday == $date) {
				$date = 'Yesterday';
			}
		} else {
			$date = '';
		}

		return $date . gmdate($time_format, $time);
	}

    function getUsers($whereq, $orderq='', $limit=10){

        if (!$whereq){
            $whereq = '1=1';
        }
        if ($orderq){
            $orderq =  "ORDER BY {$orderq} ";
        }

        $q = $this->db->query("SELECT * FROM {$this->pre}users WHERE $whereq AND user_id > 1 $orderq LIMIT $limit");

        $result = array();
        while ($row = $this->db->nqfetch($q)){

            $u = new userclass($this);

            $this->_getUser($row, $u);
            $result[] = $u;
        }
        return $result;
    }

    function getUser($whereq){

        if (preg_match("/^[0-9]+$/i", $whereq)){  //get user by id
            $whereq = 'user_id = '.intval($whereq);
        }

        if (!$whereq){
          //  $whereq = '1=1';
        }

		$row = $this->db->fetch("SELECT * FROM {$this->pre}users WHERE $whereq AND user_id > 1 LIMIT 1");

        if (!$row['user_id']){
            return false;
        }

		$result = new userclass($this);

		$this->_getUser($row, $result);

		return $result;
    }

    //Loads user row (mysql array) into supplied Class
    function _getUser($userrow, &$Userclass){

    	$Userclass->title = $userrow['user_title'];
    	$Userclass->name = $userrow['user_name'];
    	$Userclass->skin = $userrow['user_amsskin'];
    	if (!$Userclass->skin){
    		$Userclass->skin = $this->settings['default_skin'];
    	}

        $Userclass->main_account = ($userrow['user_parent_id'] == 0);

    	$url = $this->settings['url_profile_structure'];
    	$url = str_replace('%user_name%',$this->generateUrl($userrow['user_name']),$url);
    	$url =  $this->rootpath.$this->settings['url_profile'].'/'.$url.$userrow['user_id'].'.'.$this->settings['url_extension'];

        $verification_code = $userrow['user_verification_code'];
        if (!$verification_code){
            $verification_code = substr(md5($userrow['user_id'].$userrow['user_password']),0,8);
        }
        $Userclass->verification_code = $verification_code;

    	if ($userrow['user_id'] > 1){

			$Userclass->url_profile = $url;
			$Userclass->url_profile_abs = $this->Url->site.$Userclass->url_profile;

            $Userclass->url_usercp = $this->relpath_main.$this->settings['url_usercp'].($Userclass->main_account? '/':'/?penname='.$userrow['user_id']);
            $Userclass->url_usercp_abs = $this->Url->site.$Userclass->url_usercp;
            $Userclass->url_preferences = $this->Url->site.$this->relpath.$this->settings['url_userpreferences'].'/';
            $Userclass->url_preferences_abs = $Userclass->url_preferences;

            $Userclass->url_verification = $this->Url->site.$this->relpath.$this->settings['url_verification'].'/?id='.$userrow['user_id'].'&verify='.urlencode($verification_code);
            $Userclass->url_unsubscribe_newsletter = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=newsletter';
            $Userclass->url_unsubscribe_approve = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=approve';
            $Userclass->url_unsubscribe_reject = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=decline';
            $Userclass->url_unsubscribe_allow_contact = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=contact';
            $Userclass->url_unsubscribe_comments = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=comments';
            $Userclass->url_unsubscribe_moderate = $this->Url->site.$this->relpath.$this->settings['url_email_unsubscribe'].'/?id='.$userrow['user_id'].'&pw='.urlencode($verification_code).'&type=moderate';
    	}
    	else{  //guest
            $Userclass->url_profile = '';
            $Userclass->url_usercp = '';
            $Userclass->url_preferences = '';
            $Userclass->url_verification = '';
            $Userclass->url_unsubscribe_newsletter = '';
            $Userclass->url_unsubscribe_approve = '';
            $Userclass->url_unsubscribe_reject = '';
            $Userclass->url_unsubscribe_allow_contact = '';
            $Userclass->url_unsubscribe_comments = '';
            $Userclass->url_unsubscribe_moderate = '';
    	}

    	$Userclass->row = $userrow;
    	$Userclass->id = $userrow['user_id'];
    	$Userclass->parent_id = $userrow['user_parent_id'];
    	$Userclass->main_account_id = $userrow['user_parent_id']? $userrow['user_parent_id']: $userrow['user_id'];

        $column = 'user_article_count';
        if ($this->section_id > 1){
            $column = 'user_article_count_s'.$this->section_id;
        }
    	$Userclass->article_count = $userrow[$column];

    	$Userclass->group = $this->group_names[$userrow['user_amsgroup']];
    	$Userclass->group_id = $userrow['user_amsgroup'];
    	$Userclass->email = $userrow['user_email'];
    	$Userclass->settings = unserialize($userrow['user_settings']);
    	$Userclass->preferences = unserialize($userrow['user_preferences']);

        if (is_array($Userclass->preferences)){
    	   $Userclass->preferences = $Userclass->preferences[$this->section_id];
        }
        else{
            $Userclass->preferences = array();
        }
        $Userclass->options = unserialize($userrow['user_options']);
        if (!is_array($Userclass->options)){
            $Userclass->options = array();
        }

        $Userclass->collaboration_model = '';
        if ($this->settings['collaboration_model']){
            $Userclass->preferences['collaboration_model'] = ($Userclass->preferences['collaboration_model'])? $Userclass->preferences['collaboration_model']: $this->settings['collaboration_model'];
            $Userclass->collaboration_model = $Userclass->preferences['collaboration_model'];
        }

        $Userclass->ip = long2ip($userrow['user_ip']);

        $Userclass->moderated_article_list = isset($Userclass->settings['moderated_article_list'])? $Userclass->settings['moderated_article_list']: array();
        $Userclass->moderated_articles = is_array($Userclass->moderated_articles[$this->section_id])? $Userclass->moderated_articles[$this->section_id]: array();

    	$Userclass->settings['email_subscribe_newsletter'] = isset($Userclass->settings['email_subscribe_newsletter'])? $Userclass->settings['email_subscribe_newsletter']: 1;
		$Userclass->email_subscribe_newsletter = $Userclass->settings['email_subscribe_newsletter'];

    	$Userclass->settings['email_allow_contact'] = isset($Userclass->settings['email_allow_contact'])? $Userclass->settings['email_allow_contact']: 1;
		$Userclass->email_allow_contact = $Userclass->settings['email_allow_contact'];

    	$Userclass->preferences['email_subscribe_approve'] = isset($Userclass->preferences['email_subscribe_approve'])? $Userclass->preferences['email_subscribe_approve']: 1;
    	$Userclass->email_subscribe_approve = $Userclass->preferences['email_subscribe_approve'];

        $Userclass->preferences['email_subscribe_article_modification'] = isset($Userclass->preferences['email_subscribe_article_modification'])? $Userclass->preferences['email_subscribe_article_modification']: 1;
        $Userclass->email_subscribe_article_modification = $Userclass->preferences['email_subscribe_article_modification'];

        $Userclass->preferences['email_subscribe_comment_added'] = isset($Userclass->preferences['email_subscribe_comment_added'])? $Userclass->preferences['email_subscribe_comment_added']: 1;
        $Userclass->email_subscribe_comment_added = $Userclass->preferences['email_subscribe_comment_added'];

    	$Userclass->preferences['email_subscribe_reject'] = isset($Userclass->preferences['email_subscribe_reject'])? $Userclass->preferences['email_subscribe_reject']: 1;
    	$Userclass->email_subscribe_reject = $Userclass->preferences['email_subscribe_reject'];

        $Userclass->preferences['email_subscribe_moderate'] = isset($Userclass->preferences['email_subscribe_moderate'])? $Userclass->preferences['email_subscribe_moderate']: 1;
        $Userclass->email_subscribe_moderate = $Userclass->preferences['email_subscribe_moderate'];

        $Userclass->preferences['email_subscribe_comments'] = isset($Userclass->preferences['email_subscribe_comments'])? $Userclass->preferences['email_subscribe_comments']: 1;
        $Userclass->email_subscribe_comments = $Userclass->preferences['email_subscribe_comments'];

    	$Userclass->homepage = $userrow['user_homepage'];
    	$Userclass->birthday = $userrow['user_birthday'];

        if ($userrow['user_registered']){
    	   $Userclass->joined = $userrow['user_registered'];
        }
        else{ //backwards compatibility
            $Userclass->joined = $this->mbdate($userrow['user_joined']);
        }
        $Userclass->registered = &$Userclass->joined;
        $Userclass->bio = $userrow['user_bio'];

    	$Userclass->custom_fields = unserialize($userrow['user_custom_fields']);

        if ($this->section_id > 1){
            $this->get_custom_fields($this->skin_settings_usercp_main, $Userclass);
        }
        $this->get_custom_fields($this->skin_settings['usercp_custom_fields'], $Userclass);

        $this->execute_hooks('hook.getuser', $Userclass);
    }

    function validate_email($email){

        if (!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$/i", $email)) {
            return false;
        }
        return true;
    }

	//Return true if name starts with character and only characters, digits and underscore
	function validate_identifier($s){
	    if(!eregi("^[a-zA-Z]+[_a-zA-Z0-9]+$", $s)) {
	        return false;
	    } else {
	        return true;
	    }
	}

    function clean_name($s){

        $s = strip_tags(str_replace('.php','',$s));
        $s = str_replace(array(' ','?','=','&',';','<','>','*','%','$','#','!','"',"'"),'',$s);
        return $s;
    }

    //Author Alan Reddan Silverarm Solutions
    //Date 27/01/2005
    //Function that works well with images.
    //It takes the image and reduces its size to best fit. i.e If you have an image
    //that is 200 X 100 and you want a thumbnail of 75 X 50,
    //it first resizes the image to 100 X 50
    //and then takes out a portion 75 X 50 from then center of the input image.
    //So loads of image information is retained.
    //The corollary also holds if your input image is 100 X 200
    //it first resizes image to 75 X 150 and then takes out a
    //portion 75 X 75 from the centre
    // The advantage here is that function decides on whether
    //resize is by width or height itself.
    //it also decides whether to use the height or the width as the base start point
    //in the case that athumbnail is rectangular

    function resize_then_crop( $filein, $fileout, $imagethumbsize_w, $imagethumbsize_h){

        $red = "255";
        $green = "255";
        $blue = "255";
        // Get new dimensions

       if(preg_match("/.jpg/i", "$filein")) {
           $format = 'image/jpeg';
       }
       if (preg_match("/.gif/i", "$filein")) {
           $format = 'image/gif';
       }
       if(preg_match("/.png/i", "$filein")){
           $format = 'image/png';
       }

       switch($format){
           case 'image/jpeg':
                $image = imagecreatefromjpeg($filein);
                break;
           case 'image/gif';
                $image = imagecreatefromgif($filein);
                break;
           case 'image/png':
                $image = imagecreatefrompng($filein);
                break;
           default:
                return false;
       }

        $width = $imagethumbsize_w ;
        $height = $imagethumbsize_h ;
        list($width_orig, $height_orig) = getimagesize($filein);

        if ($width_orig < $height_orig) {
          $height = ($imagethumbsize_w / $width_orig) * $height_orig;
        } else {
            $width = ($imagethumbsize_h / $height_orig) * $width_orig;
        }

        if ($width < $imagethumbsize_w){ //if the width is smaller than supplied thumbnail size

            $width = $imagethumbsize_w;
            $height = ($imagethumbsize_w/ $width_orig) * $height_orig;;
        }

        if ($height < $imagethumbsize_h){ //if the height is smaller than supplied thumbnail size

            $height = $imagethumbsize_h;
            $width = ($imagethumbsize_h / $height_orig) * $width_orig;
        }

        $thumb = imagecreatetruecolor($width , $height);
        $bgcolor = imagecolorallocate($thumb, $red, $green, $blue);
        ImageFilledRectangle($thumb, 0, 0, $width, $height, $bgcolor);
        imagealphablending($thumb, true);

        imagecopyresampled($thumb, $image, 0, 0, 0, 0, $width, $height, $width_orig, $height_orig);
        $thumb2 = imagecreatetruecolor($imagethumbsize_w , $imagethumbsize_h);
        // true color for best quality
        $bgcolor = imagecolorallocate($thumb2, $red, $green, $blue);
        ImageFilledRectangle($thumb2, 0, 0, $imagethumbsize_w , $imagethumbsize_h , 0);
        imagealphablending($thumb2, true);

        $w1 =($width/2) - ($imagethumbsize_w/2);
        $h1 = ($height/2) - ($imagethumbsize_h/2);

        imagecopyresampled($thumb2, $thumb, 0,0, $w1, $h1,  $imagethumbsize_w , $imagethumbsize_h ,$imagethumbsize_w, $imagethumbsize_h);

        if ($fileout != ""){
            imagegif($thumb2, $fileout); //write to file
        }
        return true;
    }


    function upload_image($file, $image_name, $max_file_size, $allowed_types, $options=0){

        if ($this->files[$file]['size'] > $max_file_size) {
            $this->_reason = 'File too large';
            return 0;
        }

        $image_name = $this->clean_name($image_name);

        $ext = strtolower(end(explode('.', $this->files[$file]['name'])));

        if ( !in_array($ext, $allowed_types)) {
            $this->_reason = 'Invalid file type';
            return 0;
        }

        //--Make sure file is valid image, and not some malicious php script..
        $result_array = @getimagesize($this->files[$file]['tmp_name']);

        if ( ($result_array == false) or (strpos($this->files[$file]['name'], '.php') !== false)) {
            $this->_reason = 'File is not a valid image file';
            return 0;
        }
        //---

        $user_id = $this->User->id;
        if (is_array($options) and $options['user_id']){
            $user_id = $options['user_id'];
        }

        if (is_dir($this->Url->images_rel . "u_{$user_id}")){
            $result = 1;
        }
        else{
            $oldumask = umask(0);
            $result = mkdir($this->Url->images_rel . "u_{$user_id}", 0777);
            umask($oldumask);
        }

        if (!$result){
            $this->_reason = 'Cannot Create Directory';
            return 0;
        }

        $i=0;

        $ext = strrchr($image_name, ".");
        $image_name = str_replace($ext, '', $image_name);
        $original_name = $image_name;
        while (true){
            $i++;
            if ($i>500){
                break;
            }
            $q = $this->db->query("SELECT media_id FROM {$this->pre}media WHERE
                        media_url = '".real_addslashes($this->Url->images . "u_{$user_id}/" . $image_name . $ext)."' LIMIT 1");
            if ($row = $this->db->nqfetch($q)){
                $image_name = $original_name . '_' . $i;
            }
            else{
                break;
            }

        }
        $image_name = $image_name . $ext;

        $destination = $this->Url->images_rel . "u_{$user_id}/" . $image_name;
        $destination_thumb = $this->Url->images_rel . "u_{$user_id}/thumb_" . $image_name;

        if (!copy ($this->files[$file]['tmp_name'], $destination)){
            $this->_reason = 'Could not copy';
            return 0;
        }

        $last_id = 0;
        $media_title = $image_name;
        $media_caption = $image_name;
        if (is_array($options) and $options){
            if ($options['title']){
                $media_title = $options['title'];
            }
            $media_caption = $options['caption'];
        }

        $width = $result_array[0];
        $height = $result_array[1];

        $thumb_width = min($width, $this->settings['image_thumbnail_width']);
        $thumb_height = min($height, $this->settings['image_thumbnail_height']);

        $thumb = $this->resize_then_crop($destination, $destination_thumb, $thumb_width, $thumb_height);
        $sets = array();
        $sets['width'] = $result_array[0];
        $sets['height'] = $result_array[1];

        if ($thumb){
            $sets['thumbnail'] = $this->Url->images . "u_{$user_id}/thumb_" . $image_name;
            $sets['thumbnail_width'] = $thumb_width;
            $sets['thumbnail_height'] = $thumb_height;
        }


        $q = $this->db->query("INSERT INTO {$this->pre}media SET
                                media_user_id = {$user_id},
                                media_title = '".real_addslashes($media_title)."',
                                media_caption = '".real_addslashes($media_caption)."',
                                media_url = '".real_addslashes($this->Url->images . "u_{$user_id}/" . $image_name)."',
                                media_type = 'image',
                                media_sets = '".real_addslashes(serialize($sets))."',
                                media_date = NOW(),
                                media_state = 1");

        $last_id = $this->db->last_insert_id();

        return $last_id;
    }

    function upload_file($file, $media_name, $max_file_size, $allowed_types, $options=0){

        if ($this->files[$file]['size'] > $max_file_size) {
            $this->_reason = 'File too large';
            return 0;
        }

        $media_name = $this->clean_name($media_name);

        $ext = strtolower(end(explode('.', $this->files[$file]['name'])));

        if ( !in_array($ext, $allowed_types)) {
            $this->_reason = 'Invalid file type';
            return 0;
        }

        $user_id = $this->User->id;
        if (is_array($options) and $options['user_id']){
            $user_id = $options['user_id'];
        }

        if (is_dir($this->Url->files_rel . "u_{$user_id}")){
            $result = 1;
        }
        else{
            $oldumask = umask(0);
            $result = mkdir($this->Url->files_rel . "u_{$user_id}", 0777);
            umask($oldumask);
        }

        if (!$result){
            $this->_reason = 'Cannot Create Directory';
            return 0;
        }

        $i=0;
        $original_name = $media_name;
        $ext = strrchr($media_name, ".");
        $media_name = str_replace($ext, '', $media_name);
        $original_name = $media_name;
        while (true){
            $i++;
            if ($i>500){
                break;
            }
            $q = $this->db->query("SELECT media_id FROM {$this->pre}media WHERE
                        media_url = '".real_addslashes($this->Url->files . "u_{$user_id}/" . $media_name . $ext)."' LIMIT 1");
            if ($row = $this->db->nqfetch($q)){
                $media_name = $original_name . '_' . $i;
            }
            else{
                break;
            }

        }
        $media_name = $media_name . $ext;

        $destination = $this->Url->files_rel . "u_{$user_id}/" . $media_name;

        if (!copy ($this->files[$file]['tmp_name'], $destination)){
            $this->_reason = 'Could not copy';
            return 0;
        }

        $last_id = 0;
        $media_title = $media_name;
        $media_caption = $media_name;
        if (is_array($options) and $options){
            if ($options['title']){
                $media_title = $options['title'];
            }
            $media_caption = $options['caption'];
        }

        $sets = array();

        $q = $this->db->query("INSERT INTO {$this->pre}media SET
                                media_user_id = {$user_id},
                                media_title = '".real_addslashes($media_title)."',
                                media_caption = '".real_addslashes($media_caption)."',
                                media_url = '".real_addslashes($this->Url->files . "u_{$user_id}/" . $media_name)."',
                                media_type = 'file',
                                media_sets = '".real_addslashes(serialize($sets))."',
                                media_date = NOW(),
                                media_state = 1");

        $last_id = $this->db->last_insert_id();

        return $last_id;
    }

    function get_tag_list($section_id=-1){

        if ($section_id == -1){
            $section_id = $this->section_id;
        }
        $tag_list = $this->load_option("_TAGS_", $section_id);
        if (!is_array($tag_list)){
            return array();
        }

        $result = array();
        foreach ($tag_list as $tag=>$count){

          if ($count <= 0){
            continue;
          }
          $v = array();
          $v['tag'] = $tag;
          $v['count'] = $count;
          $result[] = $v;

        }

        return $result;
    }

    function add_article_rating(&$Article, $rating, $force_add_rating=0){

        if ( ($force_add_rating) or ($this->perms->auth('can_submit', 'ratings') and $Article->state == ARTICLE_STATE_ACTIVE)){

            $rating = intval($rating);

            if ($rating >= 0){

                $q = $this->db->fetch("SELECT * FROM {$this->pre_section}ratings WHERE
                    rating_article_id = {$Article->id} AND rating_ip = INET_ATON('".$this->getIp()."') LIMIT 1");

                if ($q){ //already voted
                    $Article->vote_result = -2;
                }
                else{

                    $this->_cancel = 0;
                    $this->execute_hooks_params('function.add_article_rating.before', array($Article, $rating));

                    if ($this->_cancel){
                        $this->_cancel = 0;
                        return 1;
                    }

                    $this->db->query("INSERT INTO {$this->pre_section}ratings SET
                            rating_rating = $rating,
                            rating_ip = INET_ATON('".$this->getIp()."'),
                            rating_user_id = {$this->User->id},
                            rating_date = NOW(),
                            rating_article_id = {$Article->id}");

                    $q = $this->db->fetch("SELECT (SUM(rating_rating) / COUNT(rating_id)) AS newrating FROM {$this->pre_section}ratings WHERE
                        rating_article_id = {$Article->id} LIMIT 1");

                    $rating = $q['newrating'];
                    $this->db->query("UPDATE {$this->pre_section}articles SET
                            article_rating = $rating
                            WHERE article_id = {$Article->id} LIMIT 1");

                    $Article->rating = number_format($rating, 1, '.', '');

                    $this->execute_hooks_params('function.add_article_rating.after', array(&$Article, $rating));

                    return 1;
                }
                return 1;
            }
            else{
                return -2;
            }
        }

        return -1;

    }

    function log_article_view(&$Article, $force_log=0){

        if ($this->get['comment_fmt'] == 'rss'){
            return;
        }

        if (!$force_log){
            $log_view = 0;
            if ($this->db_settings['log_stats']){
                $log_view = 1;
                if (($this->user_is_bot) and ($this->db_settings['log_stats'] != 2)){
                    $log_view = 0;
                }
            }
        }
        else{
            $log_view = 1;
        }

        if ($log_view){

            $this->db->query("INSERT DELAYED INTO {$this->pre_section}articleviews SET
                        view_ip = INET_ATON('".$this->getIp()."'),
                        view_user_id = {$this->User->id},
                        view_date = NOW(),
                        view_user_agent = '{$this->server['HTTP_USER_AGENT']}',
                        view_referer = '{$this->server['HTTP_REFERER']}',
                        view_article_id = {$Article->id}");

            if ($this->server_load <= 1.4){  //only track view count if load is under control (mostly used for sorting anyhow, stats is still tracked above)
                    $articleresult = $this->db->query("UPDATE  {$this->pre_section}articles SET
                                    article_view_count = ".(intval($Article->view_count) + 1)."
                                    WHERE article_id = {$Article->id}
                                     LIMIT 1");
            }
        }


    }

    function getCategoryTree($id, $section_id=0) {

        static $level = 0;
        $level ++;

        $prefix = $this->get_section_prefix($section_id);

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        $rs = $this->db->query("SELECT * FROM {$prefix}categories WHERE category_parent_id = $id ORDER BY category_title");
        while ($row = $this->db->nqfetch($rs)) {
            $row['category_level'] = $level;
            $row['category_section_id'] = $section_id;
            $this->_categorytree[] = $row;
            $this->getCategoryTree($row['category_id'], $section_id);
        }
        $level --;
        return $this->_categorytree;
    }

    function getPageTree($id, $section_id=0) {

        static $pagelevel = 0;

        $prefix = $this->get_section_prefix($section_id);

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        $pagelevel ++;
        $rs = $this->db->query("SELECT page_id, page_title, page_parent_id, page_sets, page_url, DATE_FORMAT(page_date, '%b %D %Y') AS page_date2, DATE_FORMAT(page_date, '%r') AS page_datetime
                             FROM {$prefix}pages
                            WHERE page_parent_id = $id AND page_active = 1 ORDER BY page_title");
        while ($row = $this->db->nqfetch($rs)) {
            $row['page_level'] = $pagelevel;
            $row['page_section_id'] = $section_id;
            $this->_pagetree[] = $row;
            $this->getPageTree($row['page_id'], $section_id);
        }
        $pagelevel --;
        return $this->_pagetree;
    }

	function select_day($day=-1){
		$i   = 1;
		$out = "<option value=\"00\"></option>\n";

		while ($i <= 31){
			$out .= "<option value=\"$i\"" . (($i == $day) ? ' selected="selected"' : null) . ">$i</option>\n";
			$i++;
		}
		return $out;
	}

	function select_month($mon=-1, $month_names=null){
		$i   = 1;
		$out = null;

        if ($month_names){
            $month = $month_names;
        }
        else{
		  $month = array(
			'00' => '',
			'1'  => 'January',
			'2'  => 'February',
			'3'  => 'March',
			'4'  => 'April',
			'5'  => 'May',
			'6'  => 'June',
			'7'  => 'July',
			'8'  => 'August',
			'9'  => 'September',
			'10' => 'October',
			'11' => 'November',
			'12' => 'December'
		  );
        }

		foreach ($month as $digit => $name){
			$out .= "<option value=\"$digit\"" . (($digit == $mon) ? ' selected="selected"' : null) . ">$name</option>\n";
		}

		return $out;
	}

	function select_year($year=-1){
		$thisyear = gmdate("Y", time());
		$i        = $thisyear;
		$out      = "<option value='0000'></option>\n";

		while ($i >= $thisyear-100)	{
			$out .= "<option value=\"$i\"" . (($i == $year) ? ' selected="selected"' : null) . ">$i</option>\n";
			$i--;
		}
		return $out;
	}

    function clear_block_cache($cache_type, $cache_block_id=0){

        if ($cache_block_id){
            $q = $this->db->query("DELETE FROM {$this->pre}block_cache  WHERE
                                cache_block_id = ".intval($cache_block_id)."");
        }
        else{
            $q = $this->db->query("DELETE FROM {$this->pre}block_cache  WHERE
                                cache_expiration_type = ".intval($cache_type)."");
        }

    }

	function refresh_user_article_count($userid, $section_id=-1){

		$q = $this->db->fetch("SELECT count(*) as articlecount FROM {$this->pre_section}articles WHERE article_state = ".ARTICLE_STATE_ACTIVE." AND article_author_id = $userid");

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        $column = 'user_article_count';
        if ($section_id > 1){
            $column = 'user_article_count_s'.$section_id;
        }
		$q_update = $this->db->query("UPDATE {$this->pre}users SET {$column} = {$q['articlecount']} WHERE user_id = $userid LIMIT 1");

        $this->clear_block_cache(2); //clear all cache that expires when new article is added

	}

    function refresh_stats($force=0, $section_id=-1){

		if ( ($this->settings['use_cron']) and (!$force) ){
			return;                                   //use cron job to update
		}

		if (($this->db_settings['manual_stats']) or ($this->db_settings['integrate_mercury'])){
			if ($force != 1){  //manual force, not cron job force
				return;
			}
		}

        if ($section_id > 0){
            $this->load_section($section_id);
        }
        else{
            $section_id = $this->section_id;
        }
        $this->clear_options_cache();

		for ($i=0; $i<sizeof($this->Categories); $i++){

			$id = $this->Categories[$i]->id;

			//get sub categories
			$q = $this->db->fetch("SELECT count(*) as cat_count FROM {$this->pre_section}categories WHERE category_parent_id = $id");

			$this->Categories[$i]->sub_category_count = $q['cat_count'];
			$this->Categories[$i]->sub_category_count_inclusive = $q['cat_count'];

			//get articles
            $prefix = $this->get_section_prefix($this->Categories[$i]->section_id);
			$q = $this->db->fetch("SELECT count(*) as art_count FROM {$prefix}articles WHERE article_state = ".ARTICLE_STATE_ACTIVE." AND article_category_id = $id");

			$this->Categories[$i]->article_count = $q['art_count'];
			$this->Categories[$i]->article_count_inclusive = $q['art_count'];
		}

		for ($i=0; $i<sizeof($this->Categories); $i++){

			if ($this->Categories[$i]->parent_id > 0){

				$cat_count = $this->Categories[$i]->sub_category_count;
				$art_count = $this->Categories[$i]->article_count;
				$t = $this->Categories[$i]->parent_id;
				while ($t > 0){

					$this->CategoryTree[$t]->sub_category_count_inclusive += $cat_count;
					$this->CategoryTree[$t]->article_count_inclusive += $art_count;

					$t = $this->CategoryTree[$t]->parent_id;
				}
			}
		}

        $category_count = 0;
		for ($i=0; $i<sizeof($this->Categories); $i++){

            if ($this->Categories[$i]->parent_id == 0){
                $category_count++;
            }
			$id = $this->Categories[$i]->id;
			$q = $this->db->fetch("SELECT category_sets FROM {$this->pre_section}categories WHERE category_id = $id");
			$set = unserialize($q['category_sets']);

			$set['sub_category_count'] = $this->Categories[$i]->sub_category_count;
			$set['sub_category_count_inclusive'] = $this->Categories[$i]->sub_category_count_inclusive;
			$set['article_count'] = $this->Categories[$i]->article_count;
			$set['article_count_inclusive'] = $this->Categories[$i]->article_count_inclusive;

			$q = $this->db->query("UPDATE {$this->pre_section}categories SET
							category_sets = '".addslashes(serialize($set))."'
							WHERE category_id = $id");
		}

		$category_count_inclusive = sizeof($this->Categories);

		$q = $this->db->fetch("SELECT count(*) as art_count FROM {$this->pre_section}articles WHERE article_state = ".ARTICLE_STATE_ACTIVE."");
		$article_count = $q['art_count'];
        $q = $this->db->fetch("SELECT count(*) as art_count FROM {$this->pre_section}articles WHERE article_state = ".ARTICLE_STATE_PENDING."");
        $article_count_pending = $q['art_count'];
        $q = $this->db->fetch("SELECT count(*) as art_count FROM {$this->pre_section}articles WHERE article_state = ".ARTICLE_STATE_DECLINED."");
        $article_count_declined = $q['art_count'];
        $q = $this->db->fetch("SELECT count(*) as art_count FROM {$this->pre_section}articles WHERE article_state = ".ARTICLE_STATE_DRAFT."");
        $article_count_draft = $q['art_count'];

        $q = $this->db->fetch("SELECT count(*) as comment_count FROM {$this->pre_section}comments WHERE comment_state = ".COMMENT_STATE_ACTIVE."");
        $comment_count = $q['comment_count'];
        $q = $this->db->fetch("SELECT count(*) as comment_count FROM {$this->pre_section}comments WHERE comment_state = ".COMMENT_STATE_PENDING."");
        $comment_count_pending = $q['comment_count'];
        $q = $this->db->fetch("SELECT count(*) as comment_count FROM {$this->pre_section}comments WHERE comment_state = ".COMMENT_STATE_DECLINED."");
        $comment_count_declined = $q['comment_count'];

		$q = $this->db->fetch("SELECT count(*) as user_count FROM {$this->pre}users");
		$user_count = $q['user_count'];

		$set = array();
		$set['category_count'] = $category_count;
		$set['category_count_inclusive'] = $category_count_inclusive;
		$set['article_count'] = $article_count;
		$set['article_count_pending'] = $article_count_pending;
		$set['article_count_declined'] = $article_count_declined;
		$set['article_count_draft'] = $article_count_draft;
		$set['comment_count'] = $comment_count;
		$set['comment_count_pending'] = $comment_count_pending;
		$set['comment_count_declined'] = $comment_count_declined;
		$set['user_count'] = $user_count;

		$q = $this->db->query("UPDATE {$this->pre}sections SET
						section_stats = '".addslashes(serialize($set))."'
                        WHERE section_id = {$section_id} LIMIT 1");

	}

    function apply_pending_article_revision($revision_article_id, $article_state, $send_email=-1){

        global $Article;
        global $Email;

        $Articles = $this->getArticles("article_id = {$revision_article_id}",'',1,2); //XXXX
        $Article = $Articles[0];

        if ($Article->id == $Article->main_id){  //this article was not a pending revision article
            return false;
        }

        $Main_Articles = $this->getArticles("article_id = {$revision_article_id}",'',1,2, $Article->Category->section_id);
        $Main_Article = $Main_Articles[0];
        $original_editor_id = $Main_Article->row['article_editor_id'];
        $main_article_state = $Main_Article->state;

        $Article->id = $Article->main_id;
        $prefix = $this->get_section_prefix($Article->Category->section_id);

        if ($article_state == ARTICLE_STATE_ACTIVE){

            $Article->state = ARTICLE_STATE_ACTIVE;
            $Article->save(2, 0);

            //The editor is not the logged in admin user, but the original article editor, so correct that
            $this->db->query("UPDATE {$prefix}articles SET  article_editor_id = '{$original_editor_id}' WHERE
                            article_id = {$Article->main_id}  LIMIT 1");

            //now remove the duplicate revision entry (the 'main' article will now be the same as this 'revision' article)
            $this->db->query("DELETE FROM {$prefix}articles WHERE
                            article_id = $revision_article_id AND article_parent_id = {$Article->main_id} LIMIT 1");

            if ($send_email == -1){  //use default
                $send_email = (($Article->Author->id > 1) and ($Article->Author->preferences['email_subscribe_approve']));
            }
            if ($send_email){
               // $this->send_email('approved');
            }
            return 1;

        }
        else{
            $this->db->query("UPDATE {$prefix}articles SET
                            article_state = $article_state WHERE
                            article_id = $revision_article_id AND article_parent_id = {$Article->main_id} LIMIT 1");


            if (($article_state == ARTICLE_STATE_DECLINED) or ($article_state == ARTICLE_STATE_DECLINED_AUTHOR)){
                if ($send_email == -1){  //use default
                    $send_email = (($Article->Author->id > 1) and ($Article->Author->settings['email_subscribe_reject']));
                }
                if ($send_email){
                   // $this->send_email('rejected');
                }
            }

        }
        return 1;

    }


    function getComments($whereq, $orderq='', $limit=10, $return_all=0, $section_id=-1){

        global $Article;
        global $Blocks;
        global $Category;
        global $Comment;
        global $Comment_items;
        global $Plugins;

        if ($orderq){
            $orderq = " ORDER BY {$orderq} ";
        }

        if ($limit){
            $limit = " LIMIT {$limit} ";
        }

        if ($section_id == -1){
            $section_id = $this->section_id;
        }

        if (!$return_all){
            $return_all = ' AND comment_state = 1 ';
        }

        if (!$whereq){
            $whereq = ' 1 = 1 ';
        }

        $q = $this->db->query("SELECT * FROM {$this->pre_section}comments, {$this->pre}users
                            WHERE user_id = comment_author_id AND $whereq $return_all
                                $orderq $limit");

        $result = array();
        $i = 0;
        while ($row = $this->db->nqfetch($q)){

            $comment_item = new baseclass();

            $i++;
            $comment_item->id = $row['comment_id'];
            $comment_item->type = $row['comment_type'];
            $comment_item->topic = $row['comment_topic'];
            $comment_item->parent_id = $row['comment_parent_id'];
            $comment_item->ip = long2ip($row['comment_ip']);
            $comment_item->index = $i;
            $comment_item->state = $row['comment_state'];
            if ($comment_item->state == 0){
                $comment_item->reviewcount++;
            }
            $comment_item->approved = $row['comment_state'];
            $comment_item->author_name = $row['comment_author_name'];
            $comment_item->author_email = $row['comment_author_email'];
            $comment_item->text = $row['comment_text'];
            $comment_item->text = $this->nl2br($comment_item->text);
            $comment_item->user_id = $row['comment_author_id'];

            $comment_item->date = date($this->skin_settings['date_format'],strtotime($row['comment_date']));
            $comment_item->date_r = date('r',strtotime($row['comment_date']));
            $comment_item->time = date($this->skin_settings['time_format'],strtotime($row['comment_date']));

            $comment_item->Author = new userclass($this);
            $this->_getUser($row, $comment_item->Author);
            if (!$comment_item->author_name){
                $comment_item->author_name = $comment_item->Author->name;
            }
            if (!$comment_item->author_email){
                $comment_item->author_email = $comment_item->Author->email;
            }

            $comment_item->custom_fields = array();
            $this->get_custom_fields($this->skin_settings['comments_custom_fields'], $comment_item);

            $result[] = $comment_item;
        }

        return $result;
    }

    function getMedia($whereq, $orderq='', $limit=1, $return_all=0){

        if ($orderq){
            $orderq = " ORDER BY {$orderq} ";
        }

        $q = $this->db->query("SELECT * FROM {$this->pre}media WHERE
                    $whereq $orderq LIMIT $limit");

        $Items = new baseclass();
        $result = array();
        while ($row = $this->db->nqfetch($q)){

            $Media = new baseclass();
            $Media->row = $row;
            $Media->id = $row['media_id'];
            $Media->title = $row['media_title'];
            $Media->caption = $row['media_caption'];
            $Media->type = $row['media_type'];
            $Media->state = $row['media_state'];
            $Media->url = $this->Url->site . $row['media_url'];
            $Media->url_edit = '?id='.$row['media_id'];
            $Media->user_id = $row['media_user_id'];
            $Media->Owner = &$this->User; //cannot load owner here, can cause recursive loading with custom fields

            $Media->date = date($this->skin_settings['date_format'],strtotime($row['media_date']));
            $Media->date_r = date('r',strtotime($row['media_date']));
            $Media->time = date($this->skin_settings['time_format'],strtotime($row['media_date']));

            $Media->sets = unserialize($row['media_sets']);
            $Media->custom_fields = unserialize($row['media_custom_fields']);
            $Media->saved_fields = unserialize($row['media_saved_fields']);

            if ($Media->sets['thumbnail']){
                $Media->url_thumbnail = $Media->sets['thumbnail'];
            }
            else{
                $Media->url_thumbnail = $Media->url;
            }
            $result[] = $Media;
        }

        return $result;
    }

    function getArticle($wherequery, $return_all=0, $limit_to_section=-1){

        if ($wherequery == 0){
            return false;
        }

        if (preg_match("/^[0-9]+$/i", $wherequery)){
            $wherequery = ' article_id = '.intval($wherequery);
        }

        $result = $this->getArticles($wherequery, '',1,$return_all, $limit_to_section);
        if (isset($result[0])){
            return $result[0];
        }
        return false;
    }

    function get_section_prefix($section_id=-1){

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        if ($section_id <= 1){ //articles from the default (current) section
            $prefix = $this->pre_section;
        }
        else{  //articles from specific section

            $prefix = $this->pre . 's' . $section_id . '_';
        }

        return $prefix;
    }

    function getArticles($wherequery='', $orderquery='', $limit=10, $return_all=0, $limit_to_section=-1, $calculate_total=0){

    	$limitstate = ' article_state = '.ARTICLE_STATE_ACTIVE.' ';
        $include_revisions = ($return_all == 2);
    	if ($return_all){

            if ($include_revisions){
                $limitstate = ' 1=1 ';
            }
            else{
    		  $limitstate = '  article_parent_id = 0  '; //every state except for revisions
            }
    	}
        $prefix = $this->get_section_prefix($limit_to_section);

    	if ($wherequery){
    		$wherequery = ' AND '.$wherequery;
    	}
    	if ($orderquery){
    		$orderquery = ' ORDER BY '.$orderquery;
    	}

    	if ($limit){
            if ($limit < 0){
      		      $limit = ' LIMIT '.max(1, intval($limit));
            }
            else{
                $limit = ' LIMIT '.$limit;
            }
    	}
    	else{
    		$limit = '';
    	}

        $articleresult = $this->db->query("SELECT * FROM {$prefix}articles
								INNER JOIN  {$this->pre}users ON user_id = article_author_id
                                WHERE  $limitstate
                                $wherequery $orderquery $limit");
		$result = array();

		while ($articlerow = $this->db->nqfetch($articleresult )){

			$result[] = new articleclass($this);
			$this->_getArticle($articlerow,$result[sizeof($result)-1], 1);
		}

        if ($calculate_total){

            $resultcount = $this->db->fetch("SELECT COUNT(*) AS found_rows FROM {$prefix}articles
                                            WHERE  $limitstate $wherequery ");
            return array($result, $resultcount['found_rows']);
        }

		return $result;
    }

    function get_article_items($wherequery='', $orderquery='', $limit=10, $return_all=0, $limit_to_section=-1){

        global $Items;
        global $Article;

        $Items = new baseclass();
        $Articles = $this->getArticles($wherequery, $orderquery, $limit, $return_all, $limit_to_section, 1);
        $Items->Articles = $Articles[0];
        $Items->count = $Articles[1];

        if (preg_match("/^[0-9]+$/i", $limit)){
            $Items->start = 1;
        }
        else{ // LIMIT 3, 10
            $Items->start = intval(substr($limit, 0, strpos($limit, ',')));
        }

    }

    function nl2br_if_plain_text($s){

         if (! ( strpos(' '.$s,'<p>') or strpos(' '.$s,'</p>')
            or strpos(' '.$s,'<br>') or strpos(' '.$s,'<br />') ) ){

            return $this->nl2br($s);
        }

        return $s; //already has break tags
    }

	function nl2br($string) {

        return str_replace(array("\r\n", "\r", "\n"), "<br />", $string);
	}
    function br2nl($string) {

        return str_ireplace(array("<br />", "<br>", "<br >", "<br/>"), "\n", $string);
    }

	function _getArticle($articlerow, &$ArticleClass, $resolve_editor=false){

			$Article = &$ArticleClass;
			$Article->id = $articlerow['article_id'];
          	$Article->parent_id = $articlerow['article_parent_id'];
            $Article->main_id = ($Article->parent_id? $Article->parent_id: $Article->id);
          	$Article->text = $articlerow['article_text'];
          	$Article->row = $articlerow;

            $Article->title = $articlerow['article_title'];
            $Article->author_id = $articlerow['article_author_id'];
            $Article->Author = new userclass($this);
            $this->_getUser($articlerow, $Article->Author);
            $Article->about = $articlerow['article_about'];
            $Article->summary = $articlerow['article_summary'];
            $Article->state = $articlerow['article_state'];
            $Article->featured_state = $articlerow['article_featured_state'];

            // __music__ __free_food__ __celestial_m_bluh_ __a_m_b__
            // __tag1__ __tag2__ __die_woord_en_not__ __tag4__
            $tags  = trim($articlerow['article_tags']);
            $tags = str_replace('_m_','-',$tags);
            $tags = str_replace('__ __',', ',$tags);
            $tags = str_replace('__','',$tags);
            $Article->tags = str_replace('_',' ',  $tags);

            $Article->ip = long2ip($articlerow['article_ip']);
            $Article->Category = $this->CategoryTree[$articlerow['article_category_id']];

            $Article->date = date($this->skin_settings['date_format'],strtotime($articlerow['article_date']));
            $Article->date_r = date('r',strtotime($articlerow['article_date']));
            $Article->time = date($this->skin_settings['time_format'],strtotime($articlerow['article_date']));

            $Article->editor_id = $articlerow['article_editor_id'];
            if ($articlerow['article_editor_id']){ //was edited at some time
                $Article->edit_date = date($this->skin_settings['date_format'],strtotime($articlerow['article_edit_date']));
                $Article->edit_time = date($this->skin_settings['time_format'],strtotime($articlerow['article_edit_date']));
                if ($resolve_editor){
                    if ($articlerow['article_editor_id'] == $Article->Author->id){
                        $Article->Editor = &$Article->Author;
                    }
                    else{ //editor was a different user
                        $Article->Editor = &$this->getUser($Article->editor_id);
                    }
                }
            }
            else{
                $Article->editor_id = $Article->Author->id;
                $Article->edit_date = $Article->date;
                $Article->edit_time = $Article->time;
                if ($resolve_editor){
                    $Article->Editor = &$Article->Author;
                }
            }

            $Article->view_count = $articlerow['article_view_count'];

            $Article->custom_fields = unserialize($articlerow['article_custom_fields']);
            if (!is_array($Article->custom_fields)){
                $Article->custom_fields = array();
            }
            $Article->options = unserialize($articlerow['article_options']);
            if (!is_array($Article->options)){
                $Article->options = array();
            }

            $Article->urltitle = $articlerow['article_urltitle'];
            $Article->view = array();
            $Article->view_encoded = array();

        	$Article->url = $Article->Category->url.$Article->urltitle.'.'.$this->settings['url_extension'];
            $Article->url_edit = $this->Sections[$Article->Category->section_id]->relpath.$this->settings['url_edit_article'].'/?id='.$Article->id;

            $Article->view = array();
            if (is_array($this->Sections[$Article->Category->section_id]->article_views)){
                foreach ($this->Sections[$Article->Category->section_id]->article_views as $view){
                    $Article->view[$view] = $this->Sections[$Article->Category->section_id]->relpath.$this->settings['url_articleview'].'/'.urlencode($view).'-'.$Article->id.'.'.$this->settings['url_extension'];
                }
            }

            $Article->url_abs = $this->Url->domain.$Article->url;
            $Article->url_edit_abs = $this->Url->domain.$Article->url_edit;
            $Article->url_comment_feed = $this->Sections[$Article->Category->section_id]->relpath.$this->settings['url_comment_feeds'].'/?id='.$Article->id.'&fmt=rss';
            $Article->url_comment_feed = $this->Url->domain.$Article->url_comment_feed;

            $Article->rating = number_format($articlerow['article_rating'], 1, '.', '');
            $Article->comment_count = intval($articlerow['article_comment_count']);

            $Article->collaboration_model = '';
            if ($Article->parent_id != 0){
                $Main_Article = $this->getArticles("article_id = {$Article->parent_id}",'',1,2,-2);
                $Main_Article = $Main_Article[0];
                $Article->settings = $Main_Article->settings;
                $Article->collaboration_model = $Main_Article->collaboration_model;
            }
            else{

                $Article->settings = unserialize($articlerow['article_settings']);
                if ($this->settings['collaboration_model']){
                    if ($Article->settings['collaboration_model']){
                        $Article->collaboration_model = $Article->settings['collaboration_model'];
                    }
                    else{
                        $Article->collaboration_model = $Article->Author->collaboration_model;
                    }
                }
            }

            if (!is_array($Article->settings)){
                $Article->settings = array();
            }
            $Article->allow_comments = isset($Article->settings['allow_comments'])? $Article->settings['allow_comments']: 1;
            $Article->settings['allow_comments'] = &$Article->allow_comments;

            $Article->moderators = isset($Article->settings['moderators'])? $Article->settings['moderators']: array();

            $Article->settings['collaboration_model'] = &$Article->collaboration_model;

            //custom fields
            if ($this->skin_settings['articles_keywords_field_name']) $Article->{$this->skin_settings['articles_keywords_field_name']} = $articlerow['article_keywords'];
            if ($this->skin_settings['articles_custom_number_field_name']) $Article->{$this->skin_settings['articles_custom_number_field_name']} = $articlerow['article_custom_float'];
            if ($this->skin_settings['articles_custom_string_field_name']) $Article->{$this->skin_settings['articles_custom_string_field_name']} = $articlerow['article_custom_string'];

            $this->get_custom_fields($this->skin_settings['articles_custom_fields'], $Article);

            $this->execute_hooks('hook.getarticle', $ArticleClass);

    }

    function invite_author_to_article($author_id, $check_perms=1){

        global $Article;

        $user = $this->getUser($author_id);
        $author_id = $user->main_account_id;

        if (!$author_id){
            return -5;
        }

        if ($check_perms and(!$Article->auth('is_owner'))){
            return -2;
        }

        if ($author_id == $Article->Author->main_id){ //cannot add self as co-author
            return -3;
        }

        if (!in_array($author_id, $Article->moderators)){
            $Article->settings['moderators'][] = $author_id;

            $new_user = $this->getUser($author_id);

            if (!is_array($new_user->moderated_article_list[$this->section_id])){
                $new_user->moderated_article_list[$this->section_id] = array();
            }
            $new_user->moderated_article_list[$this->section_id][] = $Article->id;
            $new_user->settings['moderated_article_list'] = $new_user->moderated_article_list;
            $this->db->query("UPDATE {$this->pre}users SET
                    user_settings = '".real_addslashes(serialize($new_user->settings))."'
                    WHERE user_id = {$author_id} LIMIT 1");


            $this->db->query("UPDATE {$this->pre_section}articles SET
                    article_settings = '".real_addslashes(serialize($Article->settings))."'
                    WHERE article_id = {$Article->main_id} LIMIT 1");

            $this->Recipient = $this->getUser($author_id);
            $this->send_email('invite_author');

            return 1;
        }

        return -4;
    }

    function getPennameList($selected_id=0){
        $pennames = $this->getUsers('user_parent_id = '.$this->User->main_account_id, '', 100);
        $main_user = $this->getUser($this->User->main_account_id);

        $result = '<option value="'.$main_user->id.'">'.$main_user->name.'</option>';
        foreach ($pennames as $penname){
            $result .= '<option value="'.$penname->id.'" '.($penname->id == $selected_id? 'selected':'').'>'.$penname->name.'</option>';
        }

        return $result;

    }

    function getPageList($selectedPageId=0, $skipTop=0, $section_id=-1, $include_all=0, $selectedSectionId=0){

        $result = '';

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        if (!$skipTop){
            $section_name = '['.$this->Sections[$section_id]->name.']';

            $selected = '';
            if (!$selectedPageId and ($selectedSectionId == $section_id)){
                $selected = ' selected ';
            }
            $result = '<option value=\'section_'.$section_id.'\' '.$selected.'>'.$section_name."</option>\n";
        }

        foreach ($this->Sections[$section_id]->Pages as $tree){

            if (!$include_all and !$tree->sets['showinmenu']){
                continue;
            }
            $selected = ($selectedPageId == $tree->id? ' selected': '');
            if ($selectedPageId == -1){
                $selected = ' selected';
            }
            $result .= '<option  value=\''.$tree->id.'\''.$selected.'>'.str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', $tree->level -1).'&nbsp;&nbsp;'.$tree->title."</option>\n";
        }
        return $result;
    }

    /**
     * Get Selected Categories in Array (From top to bottom)
     *
     * @param int $id Selected Category ID
     * @return array Selected Categories
     */
     //function get_selected_category_list(){
    function getSelectedCategoryList($id){

        $result = array();
        $row = $this->db->fetch("SELECT category_id, category_title, category_parent_id FROM {$this->pre_section}categories WHERE category_id = $id");
        while ($row['category_parent_id']>0) {
            $result[] = $row['category_title'];
            $row = $this->db->fetch("SELECT category_id, category_title, category_parent_id FROM {$this->pre_section}categories WHERE category_id = ".$row['category_parent_id']."");
        }
        $result[] = $row['category_title'];

       $result = array_reverse($result);
       return $result;
    }

    function get_custom_fields($fields, &$parent, $use_post_data=0){

        if (!is_array($parent->custom_fields)){
            $parent->custom_fields = array();
        }
        if (!is_array($fields)){
            return;
        }
        foreach($fields as $field){

            $parent->{$field['name']} = isset($parent->custom_fields[$field['name']])? $parent->custom_fields[$field['name']]: '';
            if ($use_post_data){
                if (isset($this->post[$field['name']])){

                    switch($field['type']){
                        case 'textinput':
                             $parent->{$field['name']} = stripslashes($this->post[$field['name']]);
                             if ($field['filter_unsafe']){
                                $parent->{$field['name']} = $this->safehtml->parse($parent->{$field['name']});
                             }
                             $parent->custom_fields[$field['name']] = $parent->{$field['name']};
                             break;
                        case 'textarea':
                             $parent->{$field['name']} = stripslashes($this->post[$field['name']]);
                             if ($field['allowed_tags'] != 'ALL'){
                                $parent->{$field['name']} = strip_tags($parent->{$field['name']}, $fields['allowed_tags']);
                             }
                             if ($field['filter_unsafe']){
                                $parent->{$field['name']} = $this->safehtml->parse($parent->{$field['name']});
                             }
                             $parent->custom_fields[$field['name']] = $parent->{$field['name']};
                             break;
                        case 'dropdown':
                                $parent->{$field['name']} = stripslashes($this->post[$field['name']]);
                                $parent->custom_fields[$field['name']] = $parent->{$field['name']};
                                break;
                        case 'checkbox':
                                $parent->{$field['name']} = isset($this->post[$field['name']])? 1: 0;
                                $parent->custom_fields[$field['name']] = $parent->{$field['name']};
                                break;
                        case 'image':
                                $media = $this->getMedia('media_type = \'image\' AND media_id = '.intval($this->post[$field['name']]));
                                $media_id = 0;
                                if ($media){
                                    $media = $media[0];
                                    $media_id = $media->id;
                                }
                                $parent->{$field['name']} = $media;
                                $parent->custom_fields[$field['name']] = $media_id;
                                break;

                        case 'file':
                                $media = $this->getMedia('media_type = \'file\' AND media_id = '.intval($this->post[$field['name']]));
                                $media_id = 0;
                                if ($media){
                                    $media = $media[0];
                                    $media_id = $media->id;
                                }
                                $parent->{$field['name']} = $media;
                                $parent->custom_fields[$field['name']] = $media_id;
                                break;
                        default: break;
                    }

                }
                else{  //no data posted, check if field is required, otherwise ignore (ie keep the current value)
                    if ($field['required']){
                        $parent->{$field['name']} = '';
                    }
                }
            }

            switch($field['type']){
                case 'textinput':
                     $parent->{'input_'.$field['name']} = '<input type=text id="'.$field['name'].'" name="'.$field['name'].'" value="'.htmlentities($parent->custom_fields[$field['name']], ENT_COMPAT, 'UTF-8').'">';
                     break;
                case 'textarea':
                     $parent->{'input_'.$field['name']} = '<textarea id="'.$field['name'].'" name="'.$field['name'].'">'.htmlentities($parent->custom_fields[$field['name']], ENT_COMPAT, 'UTF-8').'</textarea>';
                     break;
                case 'dropdown':
                        $indices = explode("\n", $field['values_index']);
                        $values = explode("\n", $field['values']);
                        $parent->{'input_'.$field['name']} = '<select id="'.$field['name'].'" name="'.$field['name'].'">';
                        for($i=0; $i < min(count($indices), count($values)); $i++){
                            $parent->{'input_'.$field['name']} .= '<option value="'.htmlentities($indices[$i], ENT_COMPAT, 'UTF-8').'" '.($parent->custom_fields[$field['name']] == $indices[$i]? 'selected': '').'">'.htmlentities($values[$i], ENT_COMPAT, 'UTF-8').'</option>';
                        }
                        $parent->{'input_'.$field['name']} .= '</select>';
                        break;
                case 'checkbox':
                        $parent->{'input_'.$field['name']} = '<input type=checkbox id="'.$field['name'].'" name="'.$field['name'].'"'.($parent->custom_fields[$field['name']]? 'checked':'').'>';
                        break;
                case 'image':
                        $value = '';
                        $media_id = 0;

                        $media = $this->getMedia('media_type = \'image\' AND media_id = '.intval($parent->custom_fields[$field['name']]));
                        $media_id = 0;
                        if ($media){
                            $media = $media[0];
                            $media_id = $media->id;
                        }
                        $parent->{$field['name']} = $media;

                        if ($media_id){
                            $value = '<img src="'.$media->url.'"> <a class="media_lib" href="#here" title="Remove" onclick="remove_media(\''.$field['name'].'\')">[x]</a>';
                        }
                        $parent->{'input_'.$field['name']} = '<input type=hidden id="'.$field['name'].'" name="'.$field['name'].'" value="'.$media_id.'">';
                        $parent->{'input_'.$field['name']} .= '<a class="add_media" href="'.$this->Url->media.'?i='.$field['name'].'">Upload Image</a>';
                        $parent->{'input_'.$field['name']} .= '<div id="input_'.$field['name'].'">'.$value.'</div>';

                        break;
                case 'file':
                        $value = '';
                        $media_id = 0;

                        $media = $this->getMedia('media_type = \'file\' AND media_id = '.intval($parent->custom_fields[$field['name']]));
                        $media_id = 0;
                        if ($media){
                            $media = $media[0];
                            $media_id = $media->id;
                        }
                        $parent->{$field['name']} = $media;

                        if ($media_id){
                            $value = '<a href="'.$media->url.'">'.$media->title.'</a> <a class="media_lib" href="#here" title="Remove" onclick="remove_media(\''.$field['name'].'\')">[x]</a>';
                        }
                        $parent->{'input_'.$field['name']} = '<input type=hidden id="'.$field['name'].'" name="'.$field['name'].'" value="'.$media_id.'">';
                        $parent->{'input_'.$field['name']} .= '<a class="add_media" href="'.$this->Url->media.'?type=files&i='.$field['name'].'">Upload File</a>';
                        $parent->{'input_'.$field['name']} .= '<div id="input_'.$field['name'].'">'.$value.'</div>';

                        break;
                default: break;
            }
        }

    }

	/**
	 * Get Categories for use in html 'select'
	 */
    function getCategoryList($selectedCategoryId=0, $skipTop=0, $section_id=-1){

        $result = '';

        if ($section_id <= 0){
            $section_id = $this->section_id;
        }

        if (!$skipTop){
             $selected = '';

             $section_name = '['.$this->Sections[$section_id]->name.']';
             $result = '<option value=\'section_'.$section_id.'\' '.$selected.'>'.$section_name."</option>\n";
        }

        foreach ($this->Sections[$section_id]->Categories as $tree){

            $disabled = '';
            $selected = ($selectedCategoryId == $tree->id? ' selected': '');
            if ($selectedCategoryId == -1){
                $selected = ' selected';
            }
            $result .= '<option '.$disabled.' value=\''.$tree->id.'\''.$selected.'>'.str_repeat('&nbsp;&nbsp;&nbsp;&nbsp;', $tree->level -1).'&nbsp;&nbsp;'.$tree->title."</option>\n";
        }
        return $result;
    }

    /*
        Paul's Simple Diff Algorithm v 0.1
        (C) Paul Butler 2007 <http://www.paulbutler.org/>
        May be used and distributed under the zlib/libpng license.

        This code is intended for learning purposes; it was written with short
        code taking priority over performance. It could be used in a practical
        application, but there are a few ways it could be optimized.

        Given two arrays, the function diff will return an array of the changes.
        I won't describe the format of the array, but it will be obvious
        if you use print_r() on the result of a diff on some test data.

        htmlDiff is a wrapper for the diff command, it takes two strings and
        returns the differences in HTML. The tags used are <ins> and <del>,
        which can easily be styled with CSS.
    */
    function diff($old, $new){

            if (!isset($maxlen)){
                $maxlen = 0;
            }

            foreach($old as $oindex => $ovalue){
                    $nkeys = array_keys($new, $ovalue);
                    foreach($nkeys as $nindex){
                            $matrix[$oindex][$nindex] = isset($matrix[$oindex - 1][$nindex - 1]) ?
                                    $matrix[$oindex - 1][$nindex - 1] + 1 : 1;
                            if($matrix[$oindex][$nindex] > $maxlen){
                                    $maxlen = $matrix[$oindex][$nindex];
                                    $omax = $oindex + 1 - $maxlen;
                                    $nmax = $nindex + 1 - $maxlen;
                            }
                    }
            }
            if($maxlen == 0) return array(array('d'=>$old, 'i'=>$new));
            return array_merge(
                    $this->diff(array_slice($old, 0, $omax), array_slice($new, 0, $nmax)),
                    array_slice($new, $nmax, $maxlen),
                    $this->diff(array_slice($old, $omax + $maxlen), array_slice($new, $nmax + $maxlen)));
    }

    function htmlDiff($old, $new){

            $ret = '';
            $diff = $this->diff(explode(' ', $old), explode(' ', $new));
            foreach($diff as $k){
                    if(is_array($k))
                            $ret .= (!empty($k['d'])?"<del>".implode(' ',$k['d'])."</del> ":'').
                                    (!empty($k['i'])?"<ins>".implode(' ',$k['i'])."</ins> ":'');
                    else $ret .= $k . ' ';
            }
            return $ret;
    }

    function cleanupDiff($diff){

        foreach ($diff as $key=>$val){
            if(is_array($val)){
                if (($val['d']) or ($val['i'])){
                }
                else{
                    unset($diff[$key]);
                }
            }
            else{
                unset($diff[$key]);
            }
        }

        return $diff;
    }

    function rollback( $new, $diff){

        $old = explode(' ',$new);
        $offset = -1;
        foreach ($diff as $key=>$value) {
            array_splice ($old , $key+$offset , count($diff[$key]['i']) , $diff[$key]['d']);
            $offset += count($diff[$key]['d']) -1;
        }
        $old = implode(' ',$old);

        return $old;
    }

    function getIp(){

          if( isset( $_SERVER ['HTTP_X_FORWARDED_FOR'] ) ){
             $ip = $_SERVER ['HTTP_X_FORWARDED_FOR'];
          }elseif( isset( $_SERVER ['HTTP_VIA'] ) ){
              $ip = $_SERVER ['HTTP_VIA'];
          }elseif( isset( $_SERVER ['REMOTE_ADDR'] ) ){
              $ip = $_SERVER ['REMOTE_ADDR'];
          }else{
              $ip = "Unknown" ;
          }
          return long2ip(ip2long($ip)); //clears invalid ip addresses
    }

    function refresh_article_comment_count($article_id){

        $q = $this->db->fetch("SELECT comment_type FROM {$this->pre_section}comments WHERE
         comment_topic = ".intval($article_id)." LIMIT 1");

        if ($q['comment_type'] != 'articles'){
            return;
        }

        $q = $this->db->fetch("SELECT COUNT(*) AS comment_count FROM {$this->pre_section}comments WHERE
            comment_type = 'articles' AND comment_topic = ".intval($article_id)."
           AND comment_state = ".COMMENT_STATE_ACTIVE."");

        $q_update = $this->db->query("UPDATE {$this->pre_section}articles SET
            article_comment_count = ".intval($q['comment_count'])." WHERE
            article_id = ".intval($article_id)." LIMIT 1");

    }

	/**
	 * Returns list of installed skins for use in 'Select' html box
	 */
    function getSkinList($selectedSkin='', $includeall=0){

        if ($includeall){
            $result  = $this->db->query("SELECT skin_name FROM {$this->pre}amsskins");
        }
        else{
            $result  = $this->db->query("SELECT skin_name FROM {$this->pre}amsskins WHERE skin_state = 1");
        }

        $text = '';
        while ($row = $this->db->nqfetch($result)){
            $text .= '<option value=\''.$row['skin_name'].'\''.($row['skin_name'] == $selectedSkin? ' selected': '').'>'.htmlentities($row['skin_name'], ENT_COMPAT, 'UTF-8')."\n";
        }
        if (!$text){  //if all skins is disabled, just choose default
            $text = '<option value=\'default\'>'.htmlentities('default', ENT_COMPAT, 'UTF-8')."\n";
        }

		return $text;
    }

	/**
	 * Returns list of groups for use in 'Select' html box
	 */
    function getGroupList($selectedGroupId=''){
        $result  = $this->db->query("SELECT group_name, group_id FROM {$this->pre}amsgroups
                                      WHERE group_id > 0");

        $text = '';
        while ($row = $this->db->nqfetch($result)){
            $text .= '<option value=\''.$row['group_id'].'\''.($row['group_id'] == $selectedGroupId? ' selected': '').'>'.htmlentities($row['group_name'], ENT_COMPAT, 'UTF-8')."\n";
        }
		return $text;
    }

	function customurlencode($url){
	    $url = strtolower($url);
	    $url = urlencode($url);
	    $url=str_replace("+","-",$url);
	    return $url;
	}
	function customurldecode($url){
	    $url=str_replace("-"," ",$url);
	    return $url;
	}

    function json_encode($data){

        include_once './lib/json/JSON.php';
        $value = new Services_JSON();
        return $value->encode($data);

    }

    function mail_2($to, $subject, $message, $from, $sendcopy=0){

    	mail($to, $subject, $message, "From: $from\n");
    	if ($sendcopy){
    		mail($this->settings['site_email'], $subject, $message, "From: $from\n");
    	}
    }

    function send_email($email_template, $to='', $force_send_now=0, $owner=''){

		global $Article;
		global $Email;
        global $Plugins;

        $Email->cancel = 0;

        if (!$owner){
            $owner = $this->skin;
        }

        if (($email_template == 'rejected') or ($email_template == 'approved')){
            $this->Recipient = &$Article->Author;

    		$this->reason = '';
    		if ($this->message_decline_id > 0){

    			$_messageq = $this->db->fetch("SELECT * from {$this->pre}email_messages WHERE
                                            message_id = {$this->message_decline_id}
                                            AND message_owner = '{$owner}' LIMIT 1");
    			$this->reason = $_messageq['message_text'];
    		}
    		elseif ($this->message_decline_id == -1){
    			$this->reason = $this->message_decline_custom;
    		}
    		elseif ($this->message_decline_id === '0'){ //no email
    			return;
    		}

    		if (!$to){
    			if ($Article->Author->id < 2){ //guest
    				return;
    			}
    			$to = $Article->Author->row['user_email'];
    		}
        }

        if (!$to){
            $to = $this->Recipient->email;

            if (!$to){ //invalid email
                return;
            }
        }

        $_emailtemplateresult = $this->db->query("SELECT * FROM {$this->pre}email_templates WHERE
                                                template_name = '$email_template'
                                                AND template_owner = '{$owner}'");

        if ($_emailrow = $this->db->nqfetch($_emailtemplateresult)){

            eval ($_emailrow['template_php']);
            $r = eval($this->formattemplate('Email',$this->escape_templates($_emailrow['template_html']),1));

            $Email->message = $r;
        }

        if (!$Email->cancel){
        	$Email->to = $to;
        	$send_now = !$this->settings['use_cron'];
            if ($force_send_now){
                $send_now = 1;
            }
        	return $Email->send_mail($send_now);
        }
    }

    function send_welcome_email($to_id){

        $_newuserq = $this->db->fetch("SELECT * FROM {$this->pre}users WHERE user_id = ".intval($to_id)."");
        $this->Recipient = new UserClass($this);
        $this->_getUser($_newuserq, $this->Recipient);

        $this->NewUser = &$this->Recipient; //backwards compatibility
        $this->Recipient->password = '';
        if (isset($this->post['passA'])){
            $this->Recipient->password = $this->post['passA'];
        }

        $this->send_email('welcome', $this->Recipient->email, 1);
        return $this->Recipient;
    }


    function mail($to, $subject, $message, $headers='', $log=0){

        return @mail($to, $subject, $message, $headers);
    }

    function decode($s, $stripslashes=false){
        $url = $this->get[$s];
        $url=str_replace("-"," ",$url);

        if ($stripslashes){
            return stripslashes($url);
        }
        else{
            return $url;
        }
    }

    /**
     * Function to use php includes in the templates
     * Reads include file into a variable
     *
     * @param string $filename name of include file
     * @return string contents
     */
	function get_include_contents($filename) {
	   if (is_file($filename)) {
	       ob_start();
	       include $filename;
	       $contents = ob_get_contents();
	       ob_end_clean();
	       return $contents;
	   }
	   return false;
	}

    /**
     * Generate an Url from the title (replacing spaces with '-' etc)
     *
     * @param string $title
     * @return string url	*/
    function generateUrl($title){
        $title = trim($title);
        $title = str_replace(',',' ',$title);
        $title = str_replace('\'','',$title);
        $title = str_replace('(',' ',$title);
        $title = str_replace(')',' ',$title);
        $title = str_replace('?','',$title);
        $title = str_replace('!','',$title);
        $title = str_replace('`','',$title);
        $title = str_replace(' : ','-',$title);
        $title = str_replace(': ','-',$title);
        $title = str_replace(' :','-',$title);
        $title = str_replace(':','-',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('"','',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('�','',$title);
        $title = str_replace('�','-',$title);
        $title = str_replace('�','-',$title);

        $title = str_replace('�','e',$title);
        $title = str_replace('�','e',$title);

        $title = str_replace('�','e',$title);
        $title = str_replace('�','e',$title);
        $title = str_replace('�','e',$title);
        $title = str_replace('�','e',$title);
        $title = str_replace('�','e',$title);

        $title = str_replace('�','c',$title);
        $title = str_replace('�','c',$title);


        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);
        $title = str_replace('�','a',$title);

        $title = str_replace('�','i',$title);
        $title = str_replace('�','i',$title);
        $title = str_replace('�','i',$title);
        $title = str_replace('�','i',$title);
        $title = str_replace('�','i',$title);
        $title = str_replace('�','i',$title);

        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);
        $title = str_replace('�','o',$title);

        $title = str_replace('�','u',$title);
        $title = str_replace('�','u',$title);
        $title = str_replace('�','u',$title);
        $title = str_replace('�','u',$title);

        $title = str_replace('�','c',$title);
        $title = str_replace('�','c',$title);

        $title = str_replace('�','p',$title);
        $title = str_replace('�','n',$title);
        $title = str_replace('�','y',$title);
        $title = str_replace('�','p',$title);
        $title = str_replace('�','y',$title);
        $title = str_replace('�','y',$title);
        $title = str_replace('�','d',$title);
        $title = str_replace('�',' ',$title);

        $title = str_replace('&',' and ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('....',' ',$title);
        $title = str_replace('...',' ',$title);
        $title = str_replace('..',' ',$title);
        $title = str_replace('�',' ',$title);
        $title = str_replace(' - ',' ',$title);
        $title = str_replace('--',' ',$title);

        $title = str_replace('/',' ',$title);
        $title = str_replace('\\',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);
        $title = str_replace('  ',' ',$title);

        $title = trim($title);

        if (substr($title, -1,1) == '.'){
            $title = substr($title, 0, strlen($title)-1);
        }

        $title = trim($title);
        return $this->customurlencode($title);
    }

    /**
     * Make first letter of every word in sentance uppercase
     *
     * @param string $string Unformattted String
     * @param bool $stripfirst
     * @return string Formatted String
     **/
    function formatTitle($string, $stripfirst = false){
        if ($stripfirst){
            $string = stripslashes($string);
        }
        $words = split(" ", $string);
        $newwords = array();

        foreach ($words as $word){
            $word = strtolower($word);
            $word = ucfirst($word);
            array_push($newwords, $word);
        }
        return htmlspecialchars(stripslashes(join(" ", $newwords)));
    }


	/**
	 * Handles {if} statements in template
	 *
	 * @return string escaped template files
	 **/
	function parse_if_code($condition, $code, $falseCode = ''){

    	global $Profile;
    	global $Member;
        global $Items;
    	global $Page;
        global $Article;
        global $Category;
        global $Blocks;
        global $Searchresults;
        global $Search;
        global $Media;

        global $Comment;
        global $Comment_items;
        global $Plugins;

        $c = $code;

		$condition = stripslashes($condition);

		$code = str_replace('\"','"',$code);
		$falseCode = str_replace('\"','"',$falseCode);

		if (eval('return ('.$condition.');')){

			return $this->escape_templates($code,1);
		}
		else{
			if ($falseCode) {
				// Strip off the {else1}
				$falseCode = substr($falseCode, 7);
			}
			return $this->escape_templates($falseCode,1);
		}
	}

	function formatOutput($s,$y){
		static $__index;

    	global $Profile;
    	global $Member;
        global $Items;
    	global $Page;
        global $Article;
        global $Media;
        global $Category;
        global $Blocks;
        global $Searchresults;
        global $Search;
        global $Comment;
        global $Comment_items;
        global $Plugins;
		$__index++;

        $t = explode('|',$y);// modifyer chaining
        foreach ($t as $index=>$y){

    		//handle {$variable|@function}

    		if ($y[0] == '@'){

    			$y = substr($y,1);
    			$y = str_replace(':',',',$y);
    			$func = preg_replace('/^([a-zA-Z0-9_]*)/', '\\1(\''.$s.'\'', $y);
    			$func = $func.')';

    			if(!function_exists(substr($func,0,strpos($func,'(')))){
    				return '<!-- UNKNOWN FUNCTION: '.$func.'-->';
    			}
                $field_name = '__custom_'.$__index;
                $this->{"__custom_{$__index}"} =  eval("return {$y}(\$s);");

    		}
    		else{
    			$func = preg_replace('/^([a-zA-Z0-9_]*)/', '\\1(\''.$s.'\'', $y);
    			$func = 'mod_'.$func.')';

    			if(!method_exists($this->Modifiers, substr($func,0,strpos($func,'(')))){
    				return '<!-- UNKNOWN METHOD: '.$func.'-->';
    			}
                $field_name = '__custom_'.$__index;

                $this->{"__custom_{$__index}"} =  $this->Modifiers->{"mod_{$y}"}($s);
    		}
            $s = $this->$field_name;
        }

		return '$this->__custom_'.$__index;
	}

	function handle_section($condition, $code){

        global $Profile;
        global $Member;
        global $Items;
        global $Page;
        global $Media;
        global $Article;
        global $Category;
        global $Blocks;
        global $Searchresults;
        global $Search;
        global $Comment;
        global $Comment_items;
        global $Plugins;

		$matches = array();

		$index = preg_match('/name=(\$[a-zA-Z0-9_>\-]*)/',$condition,$matches);
		$index = $matches[1];

		$loop = preg_match('/loop=(.*)(\s*)/',$condition,$matches);
        if (isset($matches[1])){
		  $loop = $matches[1];
        }
        else{
            $loop = '$_loop';
        }

        $val = preg_match('/val=(.*)(\s*)/',$condition,$matches);
        if (isset($matches[1])){
            $val = $matches[1];
        }
        else{
            $val = '$_val';
        }

        $code = str_replace('\"','"',$code);

		$loop = eval('return '.$loop.';');  //$this->something

		$result = '';

        $counter = 1;

        if (!is_array($loop)){
            return '';
        }

        foreach ($loop as $k=>$value){

            if (is_string($k)){
                $k = "'".addslashes($k)."'";
            }

            $loop_code = str_replace('{'.$index.'}', $k, $code);

            $loop_code = str_replace($index.']', $k.']', $loop_code);
            $loop_code = str_replace($index.' ', $k.' ', $loop_code);
            $loop_code = str_replace($index.'|', $k.'|', $loop_code);
            $loop_code = str_replace($index.')', $k.')', $loop_code);
            $loop_code = str_replace($index.'+', $k.'+', $loop_code);
            $loop_code = str_replace($index.'-', $k.'-', $loop_code);
            $loop_code = str_replace($index.'%', $k.'%', $loop_code);
            $loop_code = str_replace($index.'}', $k.'}', $loop_code);
            $loop_code = str_replace($index.'}', $k.'-', $loop_code);
            $loop_code = str_replace($index.'}', $k.'>', $loop_code);
            $loop_code = str_replace($index."\n", $k."\n", $loop_code);
            $loop_code = str_replace($index."\r", $k."\r", $loop_code);

            $loop_code = str_replace('{$counter}', $counter, $loop_code);
            $loop_code = str_replace('$counter]', $counter.']', $loop_code);
            $loop_code = str_replace('$counter]', $counter.']', $loop_code);
            $loop_code = str_replace('$counter ', $counter.' ', $loop_code);
            $loop_code = str_replace('$counter|', $counter.'|', $loop_code);
            $loop_code = str_replace('$counter)', $counter.')', $loop_code);
            $loop_code = str_replace('$counter+', $counter.'+', $loop_code);
            $loop_code = str_replace('$counter-', $counter.'-', $loop_code);
            $loop_code = str_replace('$counter%', $counter.'%', $loop_code);
            $loop_code = str_replace('$counter}', $counter.'}', $loop_code);
            $loop_code = str_replace('$counter}', $counter.'-', $loop_code);
            $loop_code = str_replace('$counter}', $counter.'>', $loop_code);
            $loop_code = str_replace("$counter\n", "$counter\n", $loop_code);
            $loop_code = str_replace("$counter\r", "$counter\r", $loop_code);

            $result .= $this->escape_templates($loop_code,1);

            $counter += 1;
        }
        return $result;
	}

    function nested_ifs($code){

        if (!isset($this->_max_nested)){
            $this->_max_nested = 0;
        }
        $s = $code;
        $if_start = 0;
        $counter = -1;
        $endif_start = 0;
        $i = 0;
        $max = 0;

         while (strpos($s,'{if ', $if_start) !== false){
            $endif_start = strpos($s,'{/if}', $if_start);
            if ($endif_start === false){
                break;
            }
            $i++;
            if ($i>2000){

                assert(false);
                break;
            }

            while ( (strpos($s,'{if ', $if_start)!== false) and (strpos($s,'{if ', $if_start) < $endif_start)){

                $counter++;
                if ($counter > $this->_max_nested){
                    $this->_max_nested = $counter;
                }
                $if_start = strpos($s,'{if ', $if_start);

                $s = substr_replace($s, '{if'.$counter, $if_start, 3);

                $if_start += 1;

                if ((strpos($s,'{else}', $if_start) !== false) and (strpos($s,'{else}', $if_start) < strpos($s,'{/if', $if_start))){

                    if (strpos($s,'{else}', $if_start) < strpos($s,'{if ', $if_start)){
                        $s = substr_replace($s, '{else'.$counter.'}', strpos($s,'{else}', $if_start), 6);
                    }
                }

            }
            $endif_start = $if_start;  //end if is next
            while ((strpos($s,'{/if}', $if_start) !== false) and (strpos($s,'{if ', $if_start) !== false) and (strpos($s,'{/if}', $if_start) < strpos($s,'{if ', $if_start))){

                //if there is else before if
                if ((strpos($s,'{else}', $if_start) !== false) and (strpos($s,'{else}', $if_start) < strpos($s,'{/if', $if_start))){
                    $s = substr_replace($s, '{else'.$counter.'}', strpos($s,'{else}', $if_start), 6);
                }
                $if_start = strpos($s,'{/if}', $if_start);
                $s = substr_replace($s, '{/if'.$counter.'}', $if_start, 5);

                $counter--;
                $if_start += 1;
            }
            if ((strpos($s,'{else}', $if_start) !== false) and (strpos($s,'{else}', $if_start) < strpos($s,'{if', $if_start))){
                $s = substr_replace($s, '{else'.$counter.'}', strpos($s,'{else}', $if_start), 6);
            }
            if (strpos($s,'{if ', $if_start) === false){

                while (strpos($s,'{/if}', $if_start) !== false){

                    if ((strpos($s,'{else}', $if_start) !== false) and (strpos($s,'{else}', $if_start) < strpos($s,'{/if', $if_start))){
                        $s = substr_replace($s, '{else'.$counter.'}', strpos($s,'{else}', $if_start), 6);
                    }
                    $if_start = strpos($s,'{/if}', $if_start);

                    $s = substr_replace($s, '{/if'.$counter.'}', $if_start, 5);

                    $counter--;
                    $if_start += 1;
                }

                if ($counter != -1){
                    $set = ($this->errors_template['parentset']? $this->errors_template['parentset']: $this->errors_template['name']);
                    exit ("Template Parse Error: There is an unclosed {if} or {else} tag in the template \"{$set} - {$this->errors_template['name']}\"");
                }
                assert($counter == -1);
                break;
            }
        }

        return $s;
    }

     function formatOutputCallback($matches){
            global $Profile;
            global $Member;
            global $Items;
            global $Page;
            global $Media;
            global $Article;
            global $Category;
            global $Blocks;
            global $Searchresults;
            global $Search;
            global $Comment;
            global $Comment_items;
            global $Plugins;

            return $this->formatOutput(eval('return '.$matches[1].';'), $matches[2]);
     }

    function escape_templates($templates,$skipslashes=0){

    	global $Profile;
    	global $Member;
        global $Items;
    	global $Page;
        global $Media;
        global $Article;
        global $Category;
        global $Blocks;
        global $Searchresults;
        global $Search;
        global $Comment;
        global $Comment_items;
        global $Plugins;

		//Template Comments {*smarty style*}
   		$templates = preg_replace('/\{\*(.*?)\*\}/', '', $templates);

   		$templates = $this->nested_ifs($templates);

        //{section}
		$templates = preg_replace('/\{section(.*?)\}(.*?)\{\/section\}/se', '$this->handle_section(\'\\1\', \'\\2\')', $templates);

   		//{if} {else}
        for ($i=0; $i<=$this->_max_nested; $i++){
   		   $templates = preg_replace('/\{if'.$i.' (.*?)\}(.*?)(\{else'.$i.'\}(.*?))?\{\/if'.$i.'\}/se', '$this->parse_if_code(\'\\1\', \'\\2\', \'\\3\')', $templates);
        }

        //variable substitution and formatting
		$templates = preg_replace_callback('/\{([\[\]\$0-9a-zA-Z_\'"\>\- \s]*?)\|(.*?)\}/', array( &$this, 'formatOutputCallback'), $templates);

    	if ($skipslashes){
    		return $templates;
    	}
    	else{
        	return str_replace(array('\\', '"', '\\$'), array('\\\\', '\\"', '\\\\$'), $templates);
    	}
    }


	/**
	 * Returns template with name in html comments
	 **/
	function formattemplate($templatename, $templatetext,$suppresscomments=0){

        $suppresscomments = 1;
        if ($suppresscomments){
		    return "return \"{$templatetext}\r\n\";";
        }
        else{
		    return "return \"<!-- $templatename -->\r\n{$templatetext}\r\n<!-- /$templatename -->\r\n\";";
        }
	}


	/**
	 * Updates last registered member stats in forum sets
	 * This is only for integration with mercuryboard
	 */
	function update_forum_sets($username, $lastmemberid, $usercount){

		if (!$this->db_settings['integrate_mercury']){
			return;
		}
		$q = $this->db->fetch("SELECT settings_data FROM {$this->pre}settings");

		$sets = unserialize($q['settings_data']);

		$sets['last_member'] = $username;
		$sets['last_member_id'] = $lastmemberid;
		$sets['members'] = $usercount;

		$sets = addslashes(serialize($sets));
		$this->db->query("UPDATE {$this->pre}settings SET settings_data='$sets'");
	}

	/**
	 * Saves all data in the $this->sets array to the database
	 **/
	function save_sets(){

        $this->clear_options_cache();

		$sets = addslashes(serialize($this->sets));
		$this->db->query("UPDATE {$this->pre}amssettings SET settings_sets='$sets'");
	}


}

?>