input['do_login'] && $ifthd->core->cache['usessions'] ) { $killed = 0; $to_cache = array(); foreach( $ifthd->core->cache['usessions'] as $usid => $usdata ) { if ( $usdata['s_time'] < ( time() - ( 60 * 60 ) ) ) { $killed = 1; } else { $to_cache[ $usid ] = $usdata; } } $ifthd->core->add_cache( 'usessions', $to_cache, 1 ); } #============================= # The Good Stuff #============================= if ( $ifthd->input['do_login'] ) { $ifthd->member = do_login(); } else { $ifthd->member = load_session(); } if ( $ifthd->input['do'] ) { require_once "./up_". $ifthd->input['do'] ."/index.php"; $run_class = 'up_'. $ifthd->input['do']; $run = new $run_class(); $run->ifthd =& $ifthd; $run->auto_run(); } else { show_main(); } #============================= # Da Functions #============================= function show_main() { global $ifthd; set_steps( 'Upgrade Trellis Desk', array( 0 => 'Introduction' ) ); set_titles( array( 0 => 'Welcome to Trellis Desk' ) ); $content = ""; $remote_check = 0; if ( ini_get('allow_url_fopen') ) { $context = stream_context_create( array( 'http' => array( 'timeout' => 5 ) ) ); $version_check = file_get_contents( 'http://core.accord5.com/trellis/version_check.php?type=text', null, $context ); if ( intval( $version_check ) > VER_NUM ) { $version_txt = "There is a newer version of Trellis Desk available for download. We recommended downloading the latest version before continuing the upgrade."; } else { $version_txt = "It looks like you have the latest version of Trellis Desk downloaded"; $remote_check = 1; } } else { $version_txt = "Due to your PHP's security settings, we were unable to check for the latest version of Trellis Desk. We recommend checking the Trellis Desk product page to make sure you have the latest version."; $remote_check = 1; } $content .= "

About the Upgrade Center

Hello and welcome to the Trellis Desk Upgrade Center. The Upgrade Center will guide you through the upgrade process to the latest version of Trellis Desk. We highly recommend that you backup all files and databases before continuing. On behalf of ACCORD5, we thank you for choosing and supporting Trellis Desk.

Upgrade History

"; $ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'upg_history', 'order' => array( 'verid' => 'DESC' ), ) ); $ifthd->core->db->execute(); $row_count = 0; // Initialize for Security while( $u = $ifthd->core->db->fetch_row() ) { if ( ! $our_ver ) { $our_ver = $u['verid']; } $row_count ++; ( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med'; $u['date'] = $ifthd->ift_date( $u['date'], '', 0, 0, 1 ); $content .= ""; } if ( $our_ver < VER_NUM ) { $upgrades = array( '10031234', '10032251', '10040026', '10140041', '10240108', '10340062', '10440094' ); while( list( , $upgrade ) = each( $upgrades ) ) { if ( $next_upgrade ) { if ( $upgrade < $next_upgrade && $upgrade > $our_ver ) { $next_upgrade = $upgrade; } } else { if ( $upgrade > $our_ver ) { $next_upgrade = $upgrade; } } } if ( ! file_exists( "./up_". $next_upgrade ."/index.php" ) ) { $error = "Could not find required upgrade file './up_". $next_upgrade ."/index.php'."; $next_upgrade = 0; } $version_txt .= " (not installed)."; } else { $alert = "Trellis Desk is up-do-date!"; $version_txt .= "."; } if ( $next_upgrade && $remote_check ) { $version_txt .= " Click the button below to begin the upgrade process."; } $content .= "

ID	Name	Date	User
{$u['verid']}	{$u['verhuman']}	{$u['date']}	{$u['username']}

Version Check

Your Version: ". VER_HUM ." (". VER_NUM .")

". $version_txt ."

"; if ( $next_upgrade ) { $content .= "

Begin Upgrade!

"; } if ( $error ) $error = "

{$error}

"; if ( $alert ) $alert = "

{$alert}

"; do_output( $error . $alert . $content, 0 ); } function do_login() { global $ifthd; if ( ! $ifthd->input['username'] ) { show_login( 'Please enter a username.' ); } if ( ! $ifthd->input['password'] ) { show_login( 'Please enter a password.' ); } $ifthd->core->db->construct( array( 'select' => array( 'id', 'name', 'password', 'pass_salt', 'mgroup' ), 'from' => 'members', 'where' => array( 'name|lower', '=', strtolower( $ifthd->input['username'] ) ), 'limit' => array( 0, 1 ), ) ); $ifthd->core->db->execute(); if ( ! $ifthd->core->db->get_num_rows() ) { show_login( 'Username / password combination incorrect.' ); } $mem = $ifthd->core->db->fetch_row(); if ( sha1( md5( $ifthd->input['password'] . $mem['pass_salt'] ) ) == $mem['password'] ) { if ( $mem['mgroup'] != 4 ) { show_login( 'You do not have permission to access the Upgrade Center.' ); } $new_session = md5( 'u' . time() . $mem['id'] . uniqid( rand(), true ) ); $to_cache[ $new_session ] = array( 's_id' => $new_session, 's_mid' => $mem['id'], 's_mname' => $mem['name'], 's_ipadd' => $ifthd->input['ip_address'], 's_time' => time(), ); $ifthd->core->add_cache( 'usessions', $to_cache ); $ifthd->set_cookie( 'upgsid', $new_session, time() + ( 60 * 60 ) ); return $mem; } else { show_login( 'Username / password combination incorrect.' ); } } function load_session() { global $ifthd; if ( $upg_sid = $ifthd->get_cookie( 'upgsid' ) ) { if ( ! $ifthd->core->cache['usessions'][ $upg_sid ] ) { show_login(); } if ( $ifthd->core->cache['usessions'][ $upg_sid ]['s_time'] < ( time() - ( 60 * 60 ) ) ) { show_login(); } if ( $ifthd->core->cache['usessions'][ $upg_sid ]['s_ipadd'] != $ifthd->input['ip_address'] ) { show_login(); } $ifthd->core->db->construct( array( 'select' => array( 'id', 'name', 'mgroup' ), 'from' => 'members', 'where' => array( 'id', '=', $ifthd->core->cache['usessions'][ $upg_sid ]['s_mid'] ), 'limit' => array( 0, 1 ), ) ); $ifthd->core->db->execute(); if ( ! $ifthd->core->db->get_num_rows() ) { show_login(); } $mem = $ifthd->core->db->fetch_row(); if ( $mem['mgroup'] != 4 ) { show_login( 'You do not have permission to access the Upgrade Center.' ); } return $mem; } else { show_login(); } } function show_login($error='') { global $ifthd; $ifthd->delete_cookie( 'upgsid' ); set_steps( 'Upgrade Trellis Desk', array( 0 => 'Login' ) ); set_titles( array( 0 => 'Login to the Upgrade Center' ) ); $content = ""; if ( $error ) $content .= "

{$error}

"; $content .= ""; do_output( $content, 0 ); } function do_output($content, $step=0) { global $ifthd; $wrapper = << Trellis Desk :: Upgrade Center

Upgrade Center

Upgrade your Trellis Desk installation to the latest available version.

<% STEPS %>

View product documentation

<% TITLE %>

<% CONTENT %>

EOF; $wrapper = str_replace( "<% STEPS %>" , build_steps_list($step) , $wrapper ); $wrapper = str_replace( "<% TITLE %>" , get_page_title($step) , $wrapper ); $wrapper = str_replace( "<% CONTENT %>" , $content , $wrapper ); $wrapper = str_replace( "<% VERSION %>" , VER_HUM , $wrapper ); $wrapper = str_replace( "<% YEAR %>" , date('Y') , $wrapper ); header ('Content-type: text/html; charset=utf-8'); print $wrapper; $ifthd->core->shut_down(); exit(); } function set_steps($our_category, $our_steps) { global $category, $steps; $category = $our_category; $steps = $our_steps; } function set_titles($our_titles) { global $titles; $titles = $our_titles; } function build_steps_list($step) { global $category, $input, $steps; $html = '

'. $category .'

". $name ."
". $name ."

'; return $html; } function get_page_title($step) { global $titles; return $titles[ $step ]; } class td_parser { function startElement($parser, $name, $attr) { $this->xml_current_element = $name; $my_var = 'xml_'. $name; $this->$my_var = ""; } function endElement($parser, $name) { $elements = array( 'tname', 'tcontent' ); $elementsb = array( 'sk_name', 'sk_img_dir', 'sk_author', 'sk_author_email', 'sk_author_web', 'sk_notes', 'sk_css' ); if( strcmp( $name, "template" ) == 0 ) { while ( list( , $element ) = each( $elements ) ) { $my_var = 'xml_'. $element; $temp[ $element ] = base64_decode( preg_replace( "/\s/", "", $this->$my_var ) ); } $this->xml_templates[] = $temp; $this->xml_tname = ""; $this->xml_tcontent = ""; } if( strcmp( $name, "skin_info" ) == 0 ) { while ( list( , $element ) = each( $elementsb ) ) { $my_var = 'xml_'. $element; $this->xml_skin_info[ $element ] = base64_decode( preg_replace( "/\s/", "", $this->$my_var ) ); } } } function characterData($parser, $data) { $elements = array( 'tname', 'tcontent', 'sk_name', 'sk_img_dir', 'sk_author', 'sk_author_email', 'sk_author_web', 'sk_notes', 'sk_css' ); while ( list( , $element ) = each( $elements ) ) { if( $this->xml_current_element == $element ) { $my_var = 'xml_'. $element; $this->$my_var .= $data; } } } function parseFile($xml_file) { $this->xml_skin_info = array(); $this->xml_templates = array(); $xml_parser = xml_parser_create(); xml_set_object( $xml_parser, $this ); xml_set_element_handler($xml_parser, "startElement", "endElement"); xml_set_character_data_handler($xml_parser, "characterData"); xml_parser_set_option($xml_parser, XML_OPTION_CASE_FOLDING, false); if( !( $fp = fopen( $xml_file, "r" ) ) ) { die("Cannot open ". $xml_file); } while( ( $data = fread( $fp, 4096 ) ) ) { if( !xml_parse( $xml_parser, $data, feof($fp) ) ) { die( sprintf("XML error at line %d column %d ", xml_get_current_line_number($xml_parser), xml_get_current_column_number($xml_parser) ) ); } } xml_parser_free($xml_parser); return array( $this->xml_skin_info, $this->xml_templates ); } } ?>