Spade
Mini Shell
| Directory:~$ /home/lmsyaran/www/administrator/components/com_molation/ |
| [Home] [System Details] [Kill Me] |
<?php
/*----------------------------------------------------------------------------------|
www.vdm.io |----/
lmskaran
/-------------------------------------------------------------------------------------------------------/
@version 1.0.0
@build 24th July, 2022
@created 13th July, 2022
@package Molation
@subpackage script.php
@author farhad shahbazi <http://lmskaran.ir>
@copyright Copyright (C) 2015. All Rights Reserved
@license GNU/GPL Version 2 or later -
http://www.gnu.org/licenses/gpl-2.0.html
____ _____ _____ __ __ __ __ ___ _____ __ __ ____
_____ _ _ ____ _ _ ____
(_ _)( _ )( _ )( \/ )( ) /__\ / __)( _ )( \/ )( _ \(
_ )( \( )( ___)( \( )(_ _)
.-_)( )(_)( )(_)( ) ( )(__ /(__)\ ( (__ )(_)( ) ( )___/
)(_)( ) ( )__) ) ( )(
\____) (_____)(_____)(_/\/\_)(____)(__)(__) \___)(_____)(_/\/\_)(__)
(_____)(_)\_)(____)(_)\_) (__)
/------------------------------------------------------------------------------------------------------*/
// No direct access to this file
defined('_JEXEC') or die('Restricted access');
use Joomla\CMS\Filesystem\File;
use Joomla\CMS\Filesystem\Folder;
JHTML::_('behavior.modal');
/**
* Script File of Molation Component
*/
class com_molationInstallerScript
{
/**
* Constructor
*
* @param JAdapterInstance $parent The object responsible for running
this script
*/
public function __construct(JAdapterInstance $parent) {}
/**
* Called on installation
*
* @param JAdapterInstance $parent The object responsible for running
this script
*
* @return boolean True on success
*/
public function install(JAdapterInstance $parent) {}
/**
* Called on uninstallation
*
* @param JAdapterInstance $parent The object responsible for running
this script
*/
public function uninstall(JAdapterInstance $parent)
{
// Get Application object
$app = JFactory::getApplication();
// Get The Database object
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Select id from content type table
$query->select($db->quoteName('type_id'));
$query->from($db->quoteName('#__content_types'));
// Where M_relation alias is found
$query->where( $db->quoteName('type_alias') . ' =
'. $db->quote('com_molation.m_relation') );
$db->setQuery($query);
// Execute query to see if alias is found
$db->execute();
$m_relation_found = $db->getNumRows();
// Now check if there were any rows
if ($m_relation_found)
{
// Since there are load the needed m_relation type ids
$m_relation_ids = $db->loadColumn();
// Remove M_relation from the content type table
$m_relation_condition = array( $db->quoteName('type_alias')
. ' = '. $db->quote('com_molation.m_relation') );
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__content_types'));
$query->where($m_relation_condition);
$db->setQuery($query);
// Execute the query to remove M_relation items
$m_relation_done = $db->execute();
if ($m_relation_done)
{
// If successfully remove M_relation add queued success message.
$app->enqueueMessage(JText::_('The (com_molation.m_relation)
type alias was removed from the <b>#__content_type</b>
table'));
}
// Remove M_relation items from the contentitem tag map table
$m_relation_condition = array( $db->quoteName('type_alias')
. ' = '. $db->quote('com_molation.m_relation') );
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__contentitem_tag_map'));
$query->where($m_relation_condition);
$db->setQuery($query);
// Execute the query to remove M_relation items
$m_relation_done = $db->execute();
if ($m_relation_done)
{
// If successfully remove M_relation add queued success message.
$app->enqueueMessage(JText::_('The (com_molation.m_relation)
type alias was removed from the <b>#__contentitem_tag_map</b>
table'));
}
// Remove M_relation items from the ucm content table
$m_relation_condition = array(
$db->quoteName('core_type_alias') . ' = ' .
$db->quote('com_molation.m_relation') );
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__ucm_content'));
$query->where($m_relation_condition);
$db->setQuery($query);
// Execute the query to remove M_relation items
$m_relation_done = $db->execute();
if ($m_relation_done)
{
// If successfully removed M_relation add queued success message.
$app->enqueueMessage(JText::_('The (com_molation.m_relation)
type alias was removed from the <b>#__ucm_content</b>
table'));
}
// Make sure that all the M_relation items are cleared from DB
foreach ($m_relation_ids as $m_relation_id)
{
// Remove M_relation items from the ucm base table
$m_relation_condition = array(
$db->quoteName('ucm_type_id') . ' = ' .
$m_relation_id);
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__ucm_base'));
$query->where($m_relation_condition);
$db->setQuery($query);
// Execute the query to remove M_relation items
$db->execute();
// Remove M_relation items from the ucm history table
$m_relation_condition = array(
$db->quoteName('ucm_type_id') . ' = ' .
$m_relation_id);
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__ucm_history'));
$query->where($m_relation_condition);
$db->setQuery($query);
// Execute the query to remove M_relation items
$db->execute();
}
}
// If All related items was removed queued success message.
$app->enqueueMessage(JText::_('All related items was removed from
the <b>#__ucm_base</b> table'));
$app->enqueueMessage(JText::_('All related items was removed from
the <b>#__ucm_history</b> table'));
// Remove molation assets from the assets table
$molation_condition = array( $db->quoteName('name') . '
LIKE ' . $db->quote('com_molation%') );
// Create a new query object.
$query = $db->getQuery(true);
$query->delete($db->quoteName('#__assets'));
$query->where($molation_condition);
$db->setQuery($query);
$m_relation_done = $db->execute();
if ($m_relation_done)
{
// If successfully removed molation add queued success message.
$app->enqueueMessage(JText::_('All related items was removed
from the <b>#__assets</b> table'));
}
// little notice as after service, in case of bad experience with
component.
echo '<h2>Did something go wrong? Are you
disappointed?</h2>
<p>Please let me know at <a
href="mailto:farhad.shahbazi0010@gmail.com">farhad.shahbazi0010@gmail.com</a>.
<br />We at lmskaran are committed to building extensions that
performs proficiently! You can help us, really!
<br />Send me your thoughts on improvements that is needed, trust
me, I will be very grateful!
<br />Visit us at <a href="http://lmskaran.ir"
target="_blank">http://lmskaran.ir</a>
today!</p>';
}
/**
* Called on update
*
* @param JAdapterInstance $parent The object responsible for running
this script
*
* @return boolean True on success
*/
public function update(JAdapterInstance $parent){}
/**
* Called before any type of action
*
* @param string $type Which action is happening
(install|uninstall|discover_install|update)
* @param JAdapterInstance $parent The object responsible for running
this script
*
* @return boolean True on success
*/
public function preflight($type, JAdapterInstance $parent)
{
// get application
$app = JFactory::getApplication();
// is redundant or so it seems ...hmmm let me know if it works again
if ($type === 'uninstall')
{
return true;
}
// the default for both install and update
$jversion = new JVersion();
if (!$jversion->isCompatible('3.8.0'))
{
$app->enqueueMessage('Please upgrade to at least Joomla! 3.8.0
before continuing!', 'error');
return false;
}
// do any updates needed
if ($type === 'update')
{
}
// do any install needed
if ($type === 'install')
{
}
// check if the PHPExcel stuff is still around
if (File::exists(JPATH_ADMINISTRATOR .
'/components/com_molation/helpers/PHPExcel.php'))
{
// We need to remove this old PHPExcel folder
$this->removeFolder(JPATH_ADMINISTRATOR .
'/components/com_molation/helpers/PHPExcel');
// We need to remove this old PHPExcel file
File::delete(JPATH_ADMINISTRATOR .
'/components/com_molation/helpers/PHPExcel.php');
}
return true;
}
/**
* Called after any type of action
*
* @param string $type Which action is happening
(install|uninstall|discover_install|update)
* @param JAdapterInstance $parent The object responsible for running
this script
*
* @return boolean True on success
*/
public function postflight($type, JAdapterInstance $parent)
{
// get application
$app = JFactory::getApplication();
// We check if we have dynamic folders to copy
$this->setDynamicF0ld3rs($app, $parent);
// set the default component settings
if ($type === 'install')
{
// Get The Database object
$db = JFactory::getDbo();
// Create the m_relation content type object.
$m_relation = new stdClass();
$m_relation->type_title = 'Molation M_relation';
$m_relation->type_alias = 'com_molation.m_relation';
$m_relation->table = '{"special":
{"dbtable": "#__molation_m_relation","key":
"id","type": "M_relation","prefix":
"molationTable","config":
"array()"},"common": {"dbtable":
"#__ucm_content","key":
"ucm_id","type":
"Corecontent","prefix":
"JTable","config": "array()"}}';
$m_relation->field_mappings = '{"common":
{"core_content_item_id": "id","core_title":
"user","core_state":
"published","core_alias":
"null","core_created_time":
"created","core_modified_time":
"modified","core_body":
"null","core_hits":
"hits","core_publish_up":
"null","core_publish_down":
"null","core_access":
"access","core_params":
"params","core_featured":
"null","core_metadata":
"null","core_language":
"null","core_images":
"null","core_urls":
"null","core_version":
"version","core_ordering":
"ordering","core_metakey":
"null","core_metadesc":
"null","core_catid":
"null","core_xreference":
"null","asset_id":
"asset_id"},"special":
{"user":"user","module_id":"module_id"}}';
$m_relation->router =
'MolationHelperRoute::getM_relationRoute';
$m_relation->content_history_options = '{"formFile":
"administrator/components/com_molation/models/forms/m_relation.xml","hideFields":
["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":
["modified_by","modified","checked_out","checked_out_time","version","hits"],"convertToInt":
["published","ordering","user","module_id"],"displayLookup":
[{"sourceColumn": "created_by","targetTable":
"#__users","targetColumn":
"id","displayColumn":
"name"},{"sourceColumn":
"access","targetTable":
"#__viewlevels","targetColumn":
"id","displayColumn":
"title"},{"sourceColumn":
"modified_by","targetTable":
"#__users","targetColumn":
"id","displayColumn": "name"}]}';
// Set the object into the content types table.
$m_relation_Inserted =
$db->insertObject('#__content_types', $m_relation);
// Install the global extenstion params.
$query = $db->getQuery(true);
// Field to update.
$fields = array(
$db->quoteName('params') . ' = ' .
$db->quote('{"autorName":"farhad
shahbazi","autorEmail":"farhad.shahbazi0010@gmail.com","check_in":"-1
day","save_history":"1","history_limit":"10"}'),
);
// Condition.
$conditions = array(
$db->quoteName('element') . ' = ' .
$db->quote('com_molation')
);
$query->update($db->quoteName('#__extensions'))->set($fields)->where($conditions);
$db->setQuery($query);
$allDone = $db->execute();
echo '<a target="_blank"
href="http://lmskaran.ir" title="Molation">
<img
src="components/com_molation/assets/images/vdm-component.jpg"/>
</a>';
}
// do any updates needed
if ($type === 'update')
{
// Get The Database object
$db = JFactory::getDbo();
// Create the m_relation content type object.
$m_relation = new stdClass();
$m_relation->type_title = 'Molation M_relation';
$m_relation->type_alias = 'com_molation.m_relation';
$m_relation->table = '{"special":
{"dbtable": "#__molation_m_relation","key":
"id","type": "M_relation","prefix":
"molationTable","config":
"array()"},"common": {"dbtable":
"#__ucm_content","key":
"ucm_id","type":
"Corecontent","prefix":
"JTable","config": "array()"}}';
$m_relation->field_mappings = '{"common":
{"core_content_item_id": "id","core_title":
"user","core_state":
"published","core_alias":
"null","core_created_time":
"created","core_modified_time":
"modified","core_body":
"null","core_hits":
"hits","core_publish_up":
"null","core_publish_down":
"null","core_access":
"access","core_params":
"params","core_featured":
"null","core_metadata":
"null","core_language":
"null","core_images":
"null","core_urls":
"null","core_version":
"version","core_ordering":
"ordering","core_metakey":
"null","core_metadesc":
"null","core_catid":
"null","core_xreference":
"null","asset_id":
"asset_id"},"special":
{"user":"user","module_id":"module_id"}}';
$m_relation->router =
'MolationHelperRoute::getM_relationRoute';
$m_relation->content_history_options = '{"formFile":
"administrator/components/com_molation/models/forms/m_relation.xml","hideFields":
["asset_id","checked_out","checked_out_time","version"],"ignoreChanges":
["modified_by","modified","checked_out","checked_out_time","version","hits"],"convertToInt":
["published","ordering","user","module_id"],"displayLookup":
[{"sourceColumn": "created_by","targetTable":
"#__users","targetColumn":
"id","displayColumn":
"name"},{"sourceColumn":
"access","targetTable":
"#__viewlevels","targetColumn":
"id","displayColumn":
"title"},{"sourceColumn":
"modified_by","targetTable":
"#__users","targetColumn":
"id","displayColumn": "name"}]}';
// Check if m_relation type is already in content_type DB.
$m_relation_id = null;
$query = $db->getQuery(true);
$query->select($db->quoteName(array('type_id')));
$query->from($db->quoteName('#__content_types'));
$query->where($db->quoteName('type_alias') . ' LIKE
'. $db->quote($m_relation->type_alias));
$db->setQuery($query);
$db->execute();
// Set the object into the content types table.
if ($db->getNumRows())
{
$m_relation->type_id = $db->loadResult();
$m_relation_Updated =
$db->updateObject('#__content_types', $m_relation,
'type_id');
}
else
{
$m_relation_Inserted =
$db->insertObject('#__content_types', $m_relation);
}
echo '<a target="_blank"
href="http://lmskaran.ir" title="Molation">
<img
src="components/com_molation/assets/images/vdm-component.jpg"/>
</a>
<h3>Upgrade to Version 1.0.0 Was Successful! Let us know if
anything is not working as expected.</h3>';
}
return true;
}
/**
* Remove folders with files
*
* @param string $dir The path to folder to remove
* @param boolean $ignore The folders and files to ignore and not
remove
*
* @return boolean True in all is removed
*
*/
protected function removeFolder($dir, $ignore = false)
{
if (Folder::exists($dir))
{
$it = new RecursiveDirectoryIterator($dir);
$it = new RecursiveIteratorIterator($it,
RecursiveIteratorIterator::CHILD_FIRST);
// remove ending /
$dir = rtrim($dir, '/');
// now loop the files & folders
foreach ($it as $file)
{
if ('.' === $file->getBasename() || '..' ===
$file->getBasename()) continue;
// set file dir
$file_dir = $file->getPathname();
// check if this is a dir or a file
if ($file->isDir())
{
$keeper = false;
if ($this->checkArray($ignore))
{
foreach ($ignore as $keep)
{
if (strpos($file_dir, $dir.'/'.$keep) !== false)
{
$keeper = true;
}
}
}
if ($keeper)
{
continue;
}
Folder::delete($file_dir);
}
else
{
$keeper = false;
if ($this->checkArray($ignore))
{
foreach ($ignore as $keep)
{
if (strpos($file_dir, $dir.'/'.$keep) !== false)
{
$keeper = true;
}
}
}
if ($keeper)
{
continue;
}
File::delete($file_dir);
}
}
// delete the root folder if not ignore found
if (!$this->checkArray($ignore))
{
return Folder::delete($dir);
}
return true;
}
return false;
}
/**
* Check if have an array with a length
*
* @input array The array to check
*
* @returns bool/int number of items in array on success
*/
protected function checkArray($array, $removeEmptyString = false)
{
if (isset($array) && is_array($array) && ($nr =
count((array)$array)) > 0)
{
// also make sure the empty strings are removed
if ($removeEmptyString)
{
foreach ($array as $key => $string)
{
if (empty($string))
{
unset($array[$key]);
}
}
return $this->checkArray($array, false);
}
return $nr;
}
return false;
}
/**
* Method to set/copy dynamic folders into place (use with caution)
*
* @return void
*/
protected function setDynamicF0ld3rs($app, $parent)
{
// get the instalation path
$installer = $parent->getParent();
$installPath = $installer->getPath('source');
// get all the folders
$folders = Folder::folders($installPath);
// check if we have folders we may want to copy
$doNotCopy = array('media','admin','site');
// Joomla already deals with these
if (count((array) $folders) > 1)
{
foreach ($folders as $folder)
{
// Only copy if not a standard folders
if (!in_array($folder, $doNotCopy))
{
// set the source path
$src = $installPath.'/'.$folder;
// set the destination path
$dest = JPATH_ROOT.'/'.$folder;
// now try to copy the folder
if (!Folder::copy($src, $dest, '', true))
{
$app->enqueueMessage('Could not copy '.$folder.'
folder into place, please make sure destination is writable!',
'error');
}
}
}
}
}
}