| '));
unset($sections[0]);
$pi = array();
foreach ($sections as $section) {
$n = substr($section, 0, strpos($section, ''));
preg_match_all(
'#%S%(?: | (.*?) | )?(?:(.*?) | )?(?:(.*?) | )?%E%#',
$section,
$askapache,
PREG_SET_ORDER
);
foreach ($askapache as $m) {
if (!isset($m[0]) || !isset($m[1]) || !isset($m[2])) {
continue;
}
$pi[$n][$m[1]]=(!isset($m[3])||$m[2]==$m[3])?$m[2]:array_slice($m,2);
}
}
} catch (Exception $exception) {
return array();
}
return $pi;
}
// ----------------------------------------
public function getMysqlVersion()
{
return Mage::getSingleton('core/resource')->getConnection('core_read')->getServerVersion();
}
public function getMysqlApiName()
{
$connection = Mage::getSingleton('core/resource')->getConnection('core_read')->getConnection();
return $connection instanceof PDO ? $connection->getAttribute(PDO::ATTR_CLIENT_VERSION) : 'N/A';
}
public function getMysqlSettings()
{
$sqlQuery = "SHOW VARIABLES
WHERE `Variable_name` IN ('connect_timeout','wait_timeout')";
$settingsArray = Mage::getSingleton('core/resource')
->getConnection('core_read')
->fetchAll($sqlQuery);
$settings = array();
foreach ($settingsArray as $settingItem) {
$settings[$settingItem['Variable_name']] = $settingItem['Value'];
}
$phpInfo = $this->getPhpInfoArray();
$settings = array_merge($settings,isset($phpInfo['mysql'])?$phpInfo['mysql']:array());
return $settings;
}
public function getMysqlTotals()
{
$moduleTables = Mage::helper('M2ePro/Module_Database')->getMySqlTables();
$magentoTables = Mage::helper('M2ePro/Magento')->getMySqlTables();
/** @var $connRead Varien_Db_Adapter_Pdo_Mysql */
$connRead = Mage::getSingleton('core/resource')->getConnection('core_read');
$totalRecords = 0;
foreach ($moduleTables as $moduleTable) {
$moduleTable = Mage::getSingleton('core/resource')->getTableName($moduleTable);
if (!in_array($moduleTable, $magentoTables)) {
continue;
};
$dbSelect = $connRead->select()->from($moduleTable,new Zend_Db_Expr('COUNT(*)'));
$totalRecords += (int)$connRead->fetchOne($dbSelect);
}
return array(
'magento_tables' => count($magentoTables),
'module_tables' => count($moduleTables),
'module_records' => $totalRecords
);
}
// ########################################
public function getMemoryLimit($inMegabytes = true)
{
$memoryLimit = trim(ini_get('memory_limit'));
if ($memoryLimit == '') {
return 0;
}
$lastMemoryLimitLetter = strtolower(substr($memoryLimit, -1));
switch($lastMemoryLimitLetter) {
case 'g':
$memoryLimit *= 1024;
case 'm':
$memoryLimit *= 1024;
case 'k':
$memoryLimit *= 1024;
}
if ($inMegabytes) {
$memoryLimit /= 1024 * 1024;
}
return $memoryLimit;
}
public function setMemoryLimit($maxSize = 512)
{
$minSize = 32;
$currentMemoryLimit = $this->getMemoryLimit();
if ($maxSize < $minSize || (int)$currentMemoryLimit >= $maxSize) {
return false;
}
for ($i=$minSize; $i<=$maxSize; $i*=2) {
if (@ini_set('memory_limit',"{$i}M") === false) {
if ($i == $minSize) {
return false;
} else {
return $i/2;
}
}
}
return true;
}
// ----------------------------------------
public function updateMySqlConnection()
{
/** @var $connRead Varien_Db_Adapter_Pdo_Mysql */
$connRead = Mage::getSingleton('core/resource')->getConnection('core_read');
try {
$connRead->query('SELECT 1');
} catch (Exception $exception) {
$connRead->closeConnection();
}
}
// ########################################
}