.-.-.-.-.-

<?php
/****************************************************************************************
* LiveZilla functions.index.inc.php
* 
* Copyright 2017 LiveZilla GmbH
* All rights reserved.
* LiveZilla is a registered trademark.
* 
* Improper changes to this file may cause critical errors.
***************************************************************************************/

if(!defined("IN_LIVEZILLA"))
	die();

class ServerPage
{
    static function GetFileIssues(&$_configFolderWriteable,$_updateRequired)
    {
        global $LZLANG;
        $message = "";

if(!file_exists(FILE_CONFIG))
            return '';

$directories = array(PATH_CONFIG,PATH_LOCALIZATION,PATH_UPLOADS,PATH_LOG,PATH_STATS,PATH_STATS."day/",PATH_STATS."month/",PATH_STATS."year/");
 if(!$_updateRequired)
 foreach($directories as $dir)
 {
 $result = IOStruct::IsWriteable($dir);
 if(!$result)
 {
 if($dir == PATH_CONFIG)
 {
 //$_configFolderWriteable = false;
 //$message .= 'No write access ' . $dir . ' ';
 }
 else
 $message .= "No write access " . $dir . " ";
 }
 }

if(!empty($message))
 $message = '<tr><td></td><td>Write Access:' . $message . ' <a class="index-button index-button-red" href="https://chat.livezilla.net/knowledge-base/troubleshooting/set-file-permissions-chmod/" target="_blank">'.$LZLANG["index_fix_problem"].'</a></td></tr>';

if(Communication::GetScheme() != SCHEME_HTTP_SECURE)
 $message .= "<tr><td></td><td>Insecure connection (HTTP): Please change to HTTPS, some functions (Notifications, PWA App installation) are not available under HTTP.</td></tr>";

if(!$_updateRequired && file_exists(FOLDER_INSTALLER))
        {
            if(isset($_GET["remove_install"]))
            {
                @unlink(FOLDER_INSTALLER . "/installer_o1.gif");
                @unlink(FOLDER_INSTALLER . "/installer_o2.gif");
                @unlink(FOLDER_INSTALLER . "/installer_o1_thumb.png");
                @unlink(FOLDER_INSTALLER . "/installer_o2_thumb.png");
                @unlink(FOLDER_INSTALLER . "/install.php");
                @rmdir(FOLDER_INSTALLER);
            }

if(function_exists("clearstatcache"))
                clearstatcache();

if(file_exists(FOLDER_INSTALLER))
 {
 $message .= "<tr><td></td><td>Installer Folder: For security reasons, please delete install folder immediately.";

if(isset($_GET["remove_install"]))
 $message .= " Can't delete folder, please remove manually.";
 else
 $message .= " <div><a class=\"index-button index-button-red\" href=\"./index.php?remove_install=1\">REMOVE</a></div>";

$message .= "</td></tr>";
 }
 }

if(empty($message))
 $message = '<tr><td></td><td>Write Access</td></tr>';

return $message;
    }

static function GetMySQLIssues(&$_updateRequired,&$_databaseVersion)
    {
        $error="";
        if(!empty(Server::$Configuration->File["gl_db_host"]))
        {
            require(LIVEZILLA_PATH . "_lib/functions.internal.man.inc.php");
            ServerManager::ValidateDatabase(true,$_updateRequired,$_databaseVersion);

if(DBManager::$Connected)
            {
                $ids = array();

$result = DBManager::Execute(true, "SELECT * FROM `" . DB_PREFIX . DATABASE_INFO . "`");
                while($row = DBManager::FetchArray($result))
                {
                    $ids[] = $row["chat_id"];
                    $ids[] = $row["ticket_id"];
                }

$result = DBManager::Execute(true, "SELECT * FROM `" . DB_PREFIX . DATABASE_TICKETS . "` ORDER BY `id` DESC LIMIT 1");
                if($row = DBManager::FetchArray($result))
                {
                    $ids[] = $row["id"];
                }

$result = DBManager::Execute(true, "SELECT * FROM `" . DB_PREFIX . DATABASE_CHAT_ARCHIVE . "` WHERE `chat_type` = 1 ORDER BY `chat_id` DESC LIMIT 1");
                if($row = DBManager::FetchArray($result))
                {
                    $ids[] = $row["chat_id"];
                }

if(count($ids) == 4)
 {
 if($ids[0] < $ids[3])
 Logging::DatabaseLog($error = "Invalid chat info data. ". $ids[0] . " < " . $ids[3]);

if($ids[1] < $ids[2])
 Logging::DatabaseLog($error = "Invalid ticket info data. ". $ids[1] . " < " . $ids[2]);
 }
 else if(count($ids) > 4)
 Logging::DatabaseLog($error = "Multiple info rows detected.");
 }
 }

if(!function_exists("mysqli_real_escape_string"))
            $error = "mysqli PHP extension is not available.";

if(empty($error))
 return '<tr><td></td><td>MySQL</td></tr>';
 else
 return '<tr><td></td><td>MySQL:' . $error .'</td></tr>';
 }

static function GetPhpVersion()
 {
 $message = '<tr><td></td><td>PHP '.Str::Cut(@phpversion(),20,true).'</td></tr>';
 if(!Server::CheckPhpVersion(PHP_NEEDED_MAJOR,PHP_NEEDED_MINOR,PHP_NEEDED_BUILD))
 $message = '<tr><td></td><td>PHP-Version:' . str_replace("",PHP_NEEDED_MAJOR . "." . PHP_NEEDED_MINOR . "." . PHP_NEEDED_BUILD,"LiveZilla requires PHP  or greater. Installed version is " . @phpversion()) . '.</td></tr>';
 return $message;
 }

static function GetDisabledFunctions()
    {
        Server::InitDataBlock(array("INTERNAL","GROUPS"));
        $message = "";

if(!class_exists('Phar'))
 $message .= "Missing PHP extension: PHAR LiveZilla requires the PHP extension PHAR to be installed and enabled. Please add the PHAR extension to your PHP configuration (php.ini). ";
 if(!function_exists("file_get_contents"))
 $message .= "Disabled function: file_get_contents LiveZilla requires the PHP function file_get_contents to be activated. ";
 if(!function_exists("fsockopen"))
 $message .= "Disabled function: fsockopen LiveZilla requires the PHP function fsockopen to be activated in order to send and receive emails and to send PUSH Messages to APPs. ";
 if(!function_exists("iconv_mime_decode"))
 $message .= "Missing PHP extension: ICONV LiveZilla requires the PHP extension ICONV to parse incoming emails. Please add the ICONV package to your PHP configuration (php.ini). ";
 if(!function_exists("mb_detect_encoding"))
 $message .= "Missing PHP extension: mbstring LiveZilla requires the PHP extension mbstring to parse incoming emails. Please add the mbstring package to your PHP configuration (php.ini). ";
 if(!function_exists("utf8_encode"))
 $message .= "Missing PHP extension: xml LiveZilla requires the PHP extension xml. Please add the xml package to your PHP configuration (php.ini). ";
 if(!function_exists("gd_info"))
 $message .= "Missing PHP extension: GD Image. LiveZilla requires the PHP extension GD Image to create dynamic graphics. Please add the GD package to your PHP configuration (php.ini). ";

if(!function_exists('curl_init'))
 $message .= "curl_init LiveZilla requires CURL to be activated in order to send PUSH Messages to APPs and to send/receive Social Media updates. Please add the CURL package (extension=php_curl.dll) to your PHP configuration (php.ini). ";

if(!empty(Server::$Configuration->File["gl_ldap"]) && !function_exists("ldap_connect"))
 $message .= "Missing PHP extension: LDAP LiveZilla requires the PHP extension LDAP to authenticate against directories. Please add the LDAP package (extension=php_ldap.dll) to your PHP configuration (php.ini). ";

$ml = @ini_get('memory_limit');
 if($ml != null && $ml !== false)
 {
 $ml = IOStruct::ToBytes($ml);
 if($ml != -1 && is_numeric($ml) && $ml > 1000000)
 {
 if($ml < 100000000)
 $message .= "Possibly not enough memory: ".ini_get('memory_limit').". In order to process emails with larger attachments, LiveZilla may require more memory. Please increase the PHP memory_limit on your webserver to 96M or 256M. Your webhosting company will assist you. ";
 }
 }

if(!empty(Server::$Configuration->File["gl_mpm"]) && function_exists('curl_init'))
 {
 $result = Server::CallURL(CONFIG_LIVEZILLA_PUSH . "validate.php");
 if($result != "CONNECTION_SUCCESSFUL")
 $message .= "Can't connect (CURL) to push server ".CONFIG_LIVEZILLA_PUSH." on Port 443. Blocked by firewall or missing Open SSL package (extension=php_openssl.dll). Outgoing connection to push server is required in order to send PUSH Messages to APPs. ";
 }

if(empty($message))
 $message = '<tr><td></td><td>Configuration</td></tr>';
 else
 $message = '<tr><td></td><td>Configuration:' . $message .'</td></tr>';

$message .= '<tr id="warning-filter" style="display:none;"><td></td><td>Filter:<div>Ups, you are banned. There\'s a filter that locks you out so you can\'t see the Chat Widget. You can remove the filter under: LiveZilla Operator Console -> Filters (Shield Icon)</div></td></tr>';
 $message .= '<tr id="warning-cf" style="display:none;"><td></td><td>Cloudflare:<div>It seems that you are using Cloudflare. Some Cloudflare functions are not compatible with real-time apps like LiveZilla. Please exclude LiveZilla from Cloudflare if you face problems.</div></td></tr>';
 $message .= '<tr id="header_frame_options" style="display:none;"><td></td><td>Header conflict:Server side header \'X-Frame-Options: SAMEORIGIN\' prevents the use of mobile apps. Please deactivate header to use LiveZilla APPs.</td></tr>';

$fu = (!Is::Null(@ini_get("upload_max_filesize")))?ini_get("upload_max_filesize"):'??';
        $pu = (!Is::Null(@ini_get("post_max_size")))?ini_get("post_max_size"):'??';

$message .= '<tr><td></td><td>File Uploadspost_max_size: '.$pu.' upload_max_filesize: '.$fu.'</td></tr>';

return $message;
    }

static function Repair()
 {
 if(DBManager::$Connected)
 {
 DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_INFO . "` WHERE `version` NOT LIKE '%.%.%.%'");
 $versions = array();
 $result = DBManager::Execute(true, "SELECT * FROM `" . DB_PREFIX . DATABASE_INFO . "` ORDER BY `version` DESC");
 if($result)
 {
 while($row = DBManager::FetchArray($result))
 {
 $versions[] = $row["version"];
 }
 if(count($versions)>1)
 {
 Logging::DebugLog("INVALID VERSIONS FOUND: " . serialize($versions));
 for($i=1;$i<count($versions);$i++)
 {
 Logging::DebugLog("REMOVE " . $versions[$i]);
 DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_INFO . "` WHERE `version` = '" . DBManager::RealEscape($versions[$i]) . "' LIMIT 1");
 }
 }
 }
 }
 }
}
?>

/home2/wtmwscom/public_html/livezila/_language/../_lib/functions.index.inc.php