<?php
defined('_JEXEC') OR die('Access Denied!');
### © 2006-2020 Joobi. All rights reserved.
### license GNU GPLv3 , link https://joobi.org

require_once( JNEWSPATH_CLASS . 'class.tableupdate.php');

 class jNews_Update {

	var $local = null;
	var $compsList = null;
	var $compDetails = null;
	var $compHome = null;
	var $versionsList = null;
	var $newVersion = false;
	var $latest = null;
	var $currentComponent = null;
	var $otherComponent = null;
	var $needUpdate = null;
	var $needAdd = null;
	var $needRemove = null;
	var $path = null;

	 function doUpdate() {
		return true;
	}


	public static function checkAcajoom(){
	 	static $acaExist = null;
	 	if (is_bool($acaExist)) return $acaExist;
	 	$db = JFactory::getDBO();
	 	static $resultAcajoom = null;
	 	if (empty($resultAcajoom)) {
		 	$queryshow= "SHOW TABLES LIKE '%#__acajoom%'";
			$db->setQuery($queryshow);
			$loadResultArray = $db->loadObjectList();
			$resultAcajoom = jnews::convertObjectList2Array( $loadResultArray );

			if (empty($resultAcajoom)) return false;
			 $query = " SELECT `akey` FROM `#__acajoom_xonfig` ";
			 $db->setQuery( $query );
			 $result = $db->loadResult();
			 $acaExist= ( !empty($result) ) ? true : false;
	 	}
	 	return $acaExist;
	 }

	function checkAcaUpdate(){
	 	static $isUpdate = null;
		if (is_bool($isUpdate)) return $isUpdate;
			$db = JFactory::getDBO();
			$query = " SELECT `A`.`id` FROM `#__jnews_lists` AS `A`, `#__acajoom_lists` AS `B` ";
			$query .= " WHERE `A`.`id` = `B`.`id`";
		 	$db->setQuery( $query );
		 	//get just one result
		 	$result = $db->loadResult();
	 		$isUpdate = ( !empty($result) ) ? true : false;
	 	return $isUpdate;
	} 
}