SMF2_1

Complexity

Total Complexity

15

Size/Duplication

Total Lines	110
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getDbName()	0	3	1
A	fetchLikes()	0	20	2
A	setDefines()	0	5	2
A	getVersion()	0	3	1
A	getPrefix()	0	6	1
A	getTableTest()	0	3	1
A	fetchSetting()	0	13	3
A	getName()	0	3	1
A	getAttachmentDirs()	0	21	3

<?php
/**
 * @name      OpenImporter
 * @copyright OpenImporter contributors
 * @license   BSD https://opensource.org/licenses/BSD-3-Clause
 *
 * @version 1.0
 */

/**
 * Class SMF2_1
 */
class SMF2_1 extends Importers\AbstractSourceImporter
{
	protected $setting_file = '/Settings.php';

	protected $smf_attach_folders = null;

	public function getName()
	{
		return 'SMF2_1';
	}

	public function getVersion()
	{
		return 'ElkArte 1.0';
	}

	public function setDefines()
	{
		if (!defined('SMF'))
		{
			define('SMF', 1);
		}
	}

	public function getPrefix()
	{
		$db_name = $this->getDbName();
		$db_prefix = $this->fetchSetting('db_prefix');

		return '`' . $db_name . '`.' . $db_prefix;
	}

	public function getDbName()
	{
		return $this->fetchSetting('db_name');
	}

	public function getTableTest()
	{
		return 'members';
	}

	public function fetchSetting($name)
	{
		static $content = null;

		if ($content === null)
		{
			$content = file_get_contents($this->path . '/Settings.php');
		}

		$match = array();
		preg_match('~\$' . $name . '\s*=\s*\'(.*?)\';~', $content, $match);

		return isset($match[1]) ? $match[1] : '';
	}

	/**
	 * Read the attachment directory structure from the source db
	 *
	 * @return array|null
	 */
	public function getAttachmentDirs()
	{
		if ($this->smf_attach_folders === null)
		{
			$from_prefix = $this->config->from_prefix;

			$request = $this->db->query("
				SELECT value
				FROM {$from_prefix}settings
				WHERE variable='attachmentUploadDir';");
			list ($smf_attachments_dir) = $this->db->fetch_row($request);

			$this->smf_attach_folders = @unserialize($smf_attachments_dir);

			if (!is_array($this->smf_attach_folders))
			{
				$this->smf_attach_folders = array(1 => $smf_attachments_dir);
			}
		}

		return $this->smf_attach_folders;
	}

	/**
	 * Import likes from the 2.1 table
	 *
	 * @return array
	 */
	public function fetchLikes()
	{
		$from_prefix = $this->config->from_prefix;

		$request = $this->db->query("
			SELECT l.id_member, l.content_id AS id_msg, m.id_member AS id_poster, l.like_time AS like_timestamp
			FROM {$from_prefix}user_likes AS l
				INNER JOIN {$from_prefix}messages AS m ON (m.id_msg = l.content_id)
			WHERE content_type = 'msg'");
		$return = array();
		while ($row = $this->db->fetch_assoc($request))
			$return[] = array(
				'id_member' => $row['id_member'],
				'id_msg' => $row['id_msg'],
				'id_poster' => $row['id_poster'],
				'like_timestamp' => $row['like_timestamp'],
			);
		$this->db->free_result($request);

		return $return;
	}
}

/**
 * Copy attachments from the source to our destination
 *
 * @param array $row
 * @param \OpenImporter\Database $db
 * @param string $from_prefix
 * @param string $attachmentUploadDir
 */
function moveAttachment(&$row, $db, $from_prefix, $attachmentUploadDir)
{
	static $smf_folders = null;

	// We need to know where the attachments are located
	if ($smf_folders === null)
	{
		$request = $db->query("
			SELECT value
			FROM {$from_prefix}settings
			WHERE variable='attachmentUploadDir';");
		list ($smf_attachments_dir) = $db->fetch_row($request);

		$smf_folders = @unserialize($smf_attachments_dir);

		if (!is_array($smf_folders))
		{
			$smf_folders = array(1 => $smf_attachments_dir);
		}
	}

	// If something is broken, better try to account for it as well.
	if (isset($smf_folders[$row['id_folder']]))
	{
		$smf_attachments_dir = $smf_folders[$row['id_folder']];
	}
	else
	{
		$smf_attachments_dir = $smf_folders[1];
	}

	// Missing the file hash ... create one
	if (empty($row['file_hash']))
	{
		$row['file_hash'] = createAttachmentFileHash($row['filename']);
		$source_file = $row['filename'];
	}
	else
	{
		$source_file = $row['id_attach'] . '_' . $row['file_hash'] . '.dat';
	}

	// Copy it over
	copy_file($smf_attachments_dir . '/' . $source_file, $attachmentUploadDir . '/' . $row['id_attach'] . '_' . $row['file_hash'] . '.elk');
}

/**
 * @param array $row
 * @param \OpenImporter\Database $db
 * @param string $from_prefix
 */
function cust_fields(&$row, $db, $from_prefix)
{
	$request = $db->query("
		SELECT variable, value
		FROM {$from_prefix}themes
		WHERE id_member = $row[id_member]");

	while ($profile = $db->fetch_assoc($request))
	{
		if ($profile['variable'] === 'cust_loca')
			$row['location'] = $profile['value'];

		if ($profile['variable'] === 'cust_gender')
		{
			if ($profile['value'] === 'Male')
				$row['gender'] = 1;
			if ($profile['value'] === 'Female')
				$row['gender'] = 2;
		}
	}
	$db->free_result($request);
}