<?php if (!defined('IDIR')) { die; }
/*======================================================================*\
|| #################################################################### ||
|| # vBulletin
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2010 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbsupport.org/forum/index.php | http://www.vbsupport.org/forum/index.php # ||
|| #################################################################### ||
\*======================================================================*/
/**
* snitz_006 Import Post module
*
* @package			ImpEx.snitz
* @version			$Revision: 2066 $
* @author			Jerry Hutchings <jerry.hutchings@vbulletin.com>
* @checkedout		$Name$
* @date				$Date: 2008-08-11 12:48:24 -0500 (Mon, 11 Aug 2008) $
* @copyright		http://www.vbsupport.org/forum/index.php
*
*/
class snitz_006 extends snitz_000
{
	var $_dependent 	= '005';

	function snitz_006(&$displayobject)
	{
		$this->_modulestring = $displayobject->phrases['import_post'];
	}

	function init(&$sessionobject, &$displayobject, &$Db_target, &$Db_source)
	{
		if ($this->check_order($sessionobject,$this->_dependent))
		{
			if ($this->_restart)
			{
				if ($this->restart($sessionobject, $displayobject, $Db_target, $Db_source,'clear_imported_posts'))
				{
					$displayobject->display_now("<h4>{$displayobject->phrases['post_restart_ok']}</h4>");
					$this->_restart = true;
				}
				else
				{
					$sessionobject->add_error(substr(get_class($this) , -3), $displayobject->phrases['post_restart_failed'], $displayobject->phrases['check_db_permissions']);
				}
			}

			// Start up the table
			$displayobject->update_basic('title', $displayobject->phrases['import_post']);
			$displayobject->update_html($displayobject->do_form_header('index',substr(get_class($this) , -3)));
			$displayobject->update_html($displayobject->make_hidden_code(substr(get_class($this) , -3),'WORKING'));
			$displayobject->update_html($displayobject->make_table_header($displayobject->phrases['import_post']));

			// Ask some questions
			$displayobject->update_html($displayobject->make_input_code($displayobject->phrases['posts_per_page'],'perpage',2000));

			// End the table
			$displayobject->update_html($displayobject->do_form_footer($displayobject->phrases['continue'],$displayobject->phrases['reset']));

			// Reset/Setup counters for this
			$sessionobject->add_session_var(substr(get_class($this) , -3) . '_objects_done', '0');
			$sessionobject->add_session_var(substr(get_class($this) , -3) . '_objects_failed', '0');
			$sessionobject->add_session_var('startat','0');
			$sessionobject->add_session_var('nonarchivefinished','FALSE');
		}
		else
		{
			// Dependant has not been run
			$displayobject->update_html($displayobject->do_form_header('index',''));
			$displayobject->update_html($displayobject->make_description("<p>{$displayobject->phrases['dependant_on']}<i><b> " . $sessionobject->get_module_title($this->_dependent) . "</b> {$displayobject->phrases['cant_run']}</i> ."));
			$displayobject->update_html($displayobject->do_form_footer($displayobject->phrases['continue'], ''));
			$sessionobject->set_session_var(substr(get_class($this) , -3),'FALSE');
			$sessionobject->set_session_var('module','000');
		}
	}

	function resume(&$sessionobject, &$displayobject, &$Db_target, &$Db_source)
	{
		// Set up working variables.
		$displayobject->update_basic('displaymodules','FALSE');
		$target_database_type	= $sessionobject->get_session_var('targetdatabasetype');
		$target_table_prefix	= $sessionobject->get_session_var('targettableprefix');
		$source_database_type	= $sessionobject->get_session_var('sourcedatabasetype');
		$source_table_prefix	= $sessionobject->get_session_var('sourcetableprefix');

		// Per page vars
		$start_at			= $sessionobject->get_session_var('startat');
		$per_page			= $sessionobject->get_session_var('perpage');
		$class_num			= substr(get_class($this) , -3);
		$idcache 			= new ImpExCache($Db_target, $target_database_type, $target_table_prefix);
		$post_object 		= new ImpExData($Db_target, $sessionobject, 'post');

		// Start the timing
		if(!$sessionobject->get_session_var($class_num . '_start'))
		{
			$sessionobject->timing($class_num ,'start' ,$sessionobject->get_session_var('autosubmit'));
		}

        if($sessionobject->get_session_var('nonarchivefinished') == 'FALSE') # NOW DO THE NORMAL POSTS
        {
            // Get an array of post details
			// TODO: get_details for new SQL
            $post_array     = $this->get_snitz_post_details($Db_source, $source_database_type, $source_table_prefix, $start_at, $per_page);

            // Display count and pass time
            $displayobject->display_now("<h4>{$displayobject->phrases['importing']} regular " . count($post_array) . " {$displayobject->phrases['posts']}</h4><p><b>{$displayobject->phrases['from']}</b> : " . $start_at . " ::  <b>{$displayobject->phrases['to']}</b> : " . ($start_at + count($post_array)) . "</p>");

            foreach ($post_array as $post_id => $post_details)
            {
                $try = (phpversion() < '5' ? $post_object : clone($post_object));

                // Mandatory
                $try->set_value('mandatory', 'threadid',			$idcache->get_id('thread', $post_details['TOPIC_ID']));
                $try->set_value('mandatory', 'userid',				$idcache->get_id('user', $post_details['R_AUTHOR']));
                $try->set_value('mandatory', 'importthreadid',		$post_details['TOPIC_ID']);

                // Non Mandatory
                $try->set_value('nonmandatory', 'parentid',			'0');
                $try->set_value('nonmandatory', 'username',         $idcache->get_id('username', $post_details['R_AUTHOR']));
                $try->set_value('nonmandatory', 'dateline',			$this->time_to_stamp($post_details['R_DATE']));
                $try->set_value('nonmandatory', 'pagetext',			$this->snitz_html($this->html_2_bb($post_details['R_MESSAGE'])));
                $try->set_value('nonmandatory', 'showsignature',	$post_details['R_SIG']);
                $try->set_value('nonmandatory', 'ipaddress',		$post_details['R_IP']);
                $try->set_value('nonmandatory', 'visible',			$post_details['R_STATUS']);
                $try->set_value('nonmandatory', 'allowsmilie',		'1');
		$try->set_value('nonmandatory', 'importpostid',		$post_details['REPLY_ID']);
		
                // Check if post object is valid
                if($try->is_valid())
                {
                    if($try->import_post($Db_target, $target_database_type, $target_table_prefix))
                    {
                        $displayobject->display_now('<br /><span class="isucc"><b>' . $try->how_complete() . '%</b></span> ' . $displayobject->phrases['post'] . ' -> ' . $try->get_value('nonmandatory','username'));
                        $sessionobject->add_session_var($class_num . '_objects_done',intval($sessionobject->get_session_var($class_num . '_objects_done')) + 1 );
                    }
                    else
                    {
                        $sessionobject->set_session_var($class_num . '_objects_failed',$sessionobject->get_session_var($class_num. '_objects_failed') + 1 );
                        $sessionobject->add_error($post_details['REPLY_ID'], $displayobject->phrases['post_not_imported'], $displayobject->phrases['post_not_imported_rem']);
                        $displayobject->display_now("<br />{$displayobject->phrases['failed']} :: {$displayobject->phrases['post_not_imported']}");
                    }
                }
                else
                {
                    $sessionobject->set_session_var($class_num . '_objects_failed',$sessionobject->get_session_var($class_num. '_objects_failed') + 1 );
                }
                unset($try);
            }// End foreach

            // Check for page end
            if (count($post_array) == 0 OR count($post_array) < $per_page)
            {
                $sessionobject->add_session_var('nonarchivefinished','TRUE');
                $sessionobject->add_session_var('startat','0');
                $sessionobject->add_session_var('postdone','0');
            }
            else 
            {
				$sessionobject->set_session_var('startat',$start_at+$per_page);
            }
        }
        else # NOW DO THE ARCHIVE POSTS
        {
            // Get an array of post details
            $post_array     = $this->get_snitz_archive_post_details($Db_source, $source_database_type, $source_table_prefix, $start_at, $per_page);

            // Display count and pass time
            $displayobject->display_now("<h4>{$displayobject->phrases['importing']} archive " . count($post_array) . " {$displayobject->phrases['posts']}</h4><p><b>{$displayobject->phrases['from']}</b> : " . $start_at . " ::  <b>{$displayobject->phrases['to']}</b> : " . ($start_at + count($post_array)) . "</p>");

            foreach ($post_array as $post_id => $post_details)
            {
                $try = (phpversion() < '5' ? $post_object : clone($post_object));

                // Mandatory
                $try->set_value('mandatory', 'threadid',			$idcache->get_id('thread', $post_details['TOPIC_ID']));
                $try->set_value('mandatory', 'userid',				$idcache->get_id('user', $post_details['R_AUTHOR']));
                $try->set_value('mandatory', 'importthreadid',		$post_details['TOPIC_ID']);

                // Non Mandatory
                $try->set_value('nonmandatory', 'parentid',			'0');
                $try->set_value('nonmandatory', 'username',			$idcache->get_id('username', $post_details['R_AUTHOR']));
                $try->set_value('nonmandatory', 'dateline',			$this->time_to_stamp($post_details['R_DATE']));
                $try->set_value('nonmandatory', 'pagetext',			$this->snitz_html($this->html_2_bb($post_details['R_MESSAGE'])));
                $try->set_value('nonmandatory', 'showsignature',    $post_details['R_SIG']);
                $try->set_value('nonmandatory', 'ipaddress',        $post_details['R_IP']);
                $try->set_value('nonmandatory', 'visible',			$post_details['R_STATUS']);
                $try->set_value('nonmandatory', 'allowsmilie',		'1');
				$try->set_value('nonmandatory', 'importpostid',		$post_details['REPLY_ID']);	
		
                // Check if post object is valid
                if($try->is_valid())
                {
                    if($try->import_post($Db_target, $target_database_type, $target_table_prefix))
                    {
                        $displayobject->display_now('<br /><span class="isucc"><b>' . $try->how_complete() . '%</b></span> ' . $displayobject->phrases['post'] . ' -> ' . $user_name_array["$post_details[R_AUTHOR]"]);
                        $sessionobject->add_session_var($class_num . '_objects_done',intval($sessionobject->get_session_var($class_num . '_objects_done')) + 1 );
                    }
                    else
                    {
                        $sessionobject->set_session_var($class_num . '_objects_failed',$sessionobject->get_session_var($class_num. '_objects_failed') + 1 );
                        $sessionobject->add_error($post_details['REPLY_ID'], $displayobject->phrases['post_not_imported'], $displayobject->phrases['post_not_imported_rem']);
                        $displayobject->display_now("<br />{$displayobject->phrases['failed']} :: {$displayobject->phrases['post_not_imported']}");
                    }
                }
                else
                {
                    $displayobject->display_now("<br />{$displayobject->phrases['invalid_object']}" . $try->_failedon);
                    $sessionobject->set_session_var($class_num . '_objects_failed',$sessionobject->get_session_var($class_num. '_objects_failed') + 1 );
                }
                unset($try);
            }// End foreach

            // The real end
			if (count($post_array) == 0 OR count($post_array) < $per_page)
			{
                $sessionobject->timing($class_num,'stop', $sessionobject->get_session_var('autosubmit'));
                $sessionobject->remove_session_var($class_num . '_start');

                $displayobject->display_now($displayobject->phrases['updating_parent_id']);

                if ($this->update_post_parent_ids($Db_target, $target_database_type, $target_table_prefix))
                {
                    $displayobject->display_now($displayobject->phrases['successful']);
                }
                else
                {
                    $displayobject->display_now($displayobject->phrases['failed']);
                }

                $displayobject->update_html($displayobject->module_finished(
                    "{$displayobject->phrases['import']} {$displayobject->phrases['posts']}",
                    $sessionobject->return_stats($class_num, '_time_taken'),
                    $sessionobject->return_stats($class_num, '_objects_done'),
                    $sessionobject->return_stats($class_num, '_objects_failed')
                ));

                $sessionobject->set_session_var($class_num ,'FINISHED');
                $sessionobject->set_session_var('import_post','done');
                $sessionobject->set_session_var('module','000');
                $sessionobject->set_session_var('autosubmit','0');
            }

			$sessionobject->set_session_var('startat',$start_at+$per_page);
        }// Else Archive

		$displayobject->update_html($displayobject->print_redirect('index.php',$sessionobject->get_session_var('pagespeed')));
	}// End resume
}//End Class
# Autogenerated on : May 20, 2004, 12:45 am
# By ImpEx-generator 1.0.
/*======================================================================*\
|| ####################################################################
|| # NulleD By - FintMax
|| # CVS: $RCSfile$ - $Revision: 2066 $
|| ####################################################################
\*======================================================================*/
?>
