<h2>File Contents: /home/planet5/www/4xpips.net/secure/data/.upgrade.s1rjgv-unpack/amember/library/Am/copy_of_Lite.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/4xpips.net/secure/data/.upgrade.s1rjgv-unpack/amember/library/Am/copy_of_Lite.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

define(&#039;PS_DELIMITER&#039;, &#039;|&#039;);
define(&#039;PS_UNDEF_MARKER&#039;, &#039;!&#039;);

/**
 * Run aMember-related functions without including of entire
 * aMember API stack. Please do not use these functions
 * within aMember itself!
 * 
 * @package Am_Lite
 */
class Am_Lite
{

    const PAID = &#039;paid&#039;;
    const FREE = &#039;free&#039;;
    const ANY = &#039;any&#039;;
    const ONLY_LOGIN = &#039;only_login&#039;;
    const ACTIVE = &#039;active&#039;;
    const EXPIRED = &#039;expired&#039;;
    const MAX_SQL_DATE = &#039;2037-12-31&#039;;
    const SESSION_NAME = &#039;PHPSESSID&#039;;

    protected static $_instance = null;
    protected $_db_config = null;
    protected $_db = null;
    protected $_session = null;
    protected $usePHPSessions = false;
    protected $useExceptions = false;

    protected function __construct()
    {
        $this-&gt;getDbConfig(); // Read possible defines in config.php
        if (ini_get(&#039;suhosin.session.encrypt&#039;) || $this-&gt;getConfigValue(&#039;session_storage&#039;)==&#039;php&#039;)
            $this-&gt;initPHPSession();
    }

    protected function initPHPSession()
    {
        $this-&gt;usePHPSessions = true;
        if (headers_sent())
        {
            $this-&gt;error(&quot;Please move &lt;b&gt;require &#039;Lite.php&#039;&lt;/b&gt; line to the top of your file. It should be placed before any html code or php output.&quot;);
        }
        session_name($this-&gt;getSessionName());
        session_start();
    }

    /**
     *
     * @return Am_Lite
     */
    static public function getInstance()
    {
        if (is_null(self::$_instance))
        {
            self::$_instance = new self;
        }
        return self::$_instance;
    }

    public function setUseExceptions($flag)
    {
        $this-&gt;useExceptions = (bool) $flag;
    }

    public function isLoggedIn()
    {
        return $this-&gt;hasIdentity();
    }

    public function getUsername()
    {
        return $this-&gt;getUserField(&#039;login&#039;);
    }

    public function getName()
    {
        if ($this-&gt;hasIdentity())
        {
            return sprintf(&quot;%s %s&quot;, $this-&gt;getUserField(&#039;name_f&#039;), $this-&gt;getUserField(&#039;name_l&#039;));
        }
        else
        {
            return null;
        }
    }

    public function getEmail()
    {
        return $this-&gt;getUserField(&#039;email&#039;);
    }

    public function getLogoutURL()
    {
        return $this-&gt;getConfigValue(&#039;root_surl&#039;) . &#039;/login/logout&#039;;
    }

    public function getProfileURL()
    {
        return $this-&gt;getConfigValue(&#039;root_surl&#039;) . &#039;/profile&#039;;
    }

    public function getLoginURL($redirect = null)
    {
        $params = array();

        if ($redirect)
            $params[&#039;amember_redirect_url&#039;] = $redirect;

        if (array_key_exists(&#039;_lang&#039;, $_GET) &amp;&amp; $_GET[&#039;_lang&#039;])
            $params[&#039;_lang&#039;] = $_GET[&#039;_lang&#039;];

        $query = http_build_query($params);
        return $this-&gt;getConfigValue(&#039;root_surl&#039;)
            . &#039;/login/index&#039;
            . ($query ? &#039;?&#039; . $query : &#039;&#039;);
    }

    public function getSignupURL()
    {
        return $this-&gt;getConfigValue(&#039;root_surl&#039;) . &#039;/signup&#039;;
    }

    public function renderLoginForm($redirect = null)
    {
        return &#039;&lt;form method=&quot;POST&quot; action=&quot;&#039;
            . $this-&gt;getLoginURL($redirect)
            . &#039;&quot;&gt;&#039;
            . &#039;&lt;label for=&quot;form-amember_login&quot;&gt;E-Mail Address or Username&lt;/label&gt;&#039;
            . &#039;&lt;input type=&quot;text&quot; name=&quot;amember_login&quot; id=&quot;form-amember_login&quot; /&gt;&#039;
            . &#039;&lt;label for=&quot;form-amember_pass&quot;&gt;Password&lt;/label&gt;&#039;
            . &#039;&lt;input type=&quot;password&quot; name=&quot;amember_pass&quot; id=&quot;form-amember_pass&quot; /&gt;&#039;
            . &#039;&lt;input type=&quot;submit&quot; value=&quot;Login&quot; /&gt;&#039;
            . &#039;&lt;/form&gt;&#039;;
    }

    function getRootURL()
    {
        return $this-&gt;getConfigValue(&quot;root_url&quot;);
    }

    /**
     * Retrieve logged-in user
     *
     * @return array|null
     */
    public function getUser()
    {
        return $this-&gt;getIdentity();
    }

    /**
     * Check if user logged in and have required subscription
     * otherwise redirect to login page or no-access page
     * 
     * @param int|array $require product_id or array of product_id or 
     * one of special const self::PAID, self:FREE, self::ANY, self::ONLY_LOGIN
     * @param string $title description of protected content, 
     * it will be shown at no-access page
     */
    public function checkAccess($require, $title = &#039;&#039;)
    {
        if (!$this-&gt;hasIdentity())
        {
            header(&quot;Location: &quot; . $this-&gt;getLoginURL(
                ((isset($_SERVER[&#039;HTTPS&#039;]) &amp;&amp; $_SERVER[&#039;HTTPS&#039;] &amp;&amp; $_SERVER[&#039;HTTPS&#039;] != &#039;off&#039;) ? &#039;https://&#039; : &#039;http://&#039;) .
                $_SERVER[&#039;HTTP_HOST&#039;] . $_SERVER[&#039;REQUEST_URI&#039;]));
            exit;
        }

        if (self::ONLY_LOGIN != $require &amp;&amp; !$this-&gt;haveSubscriptions($require))
        {
            $params = array(
                &#039;id&#039; =&gt; $require,
                &#039;title&#039; =&gt; $title
            );

            header(&quot;Location: &quot; . $this-&gt;getRootURL() . &#039;/no-access/lite?&#039; . http_build_query($params));
            exit;
        }
    }

    /**
     * Whether logged-in user have active subscription or not
     *
     * @param int|array $search
     * @return bool
     */
    public function haveSubscriptions($search = self::ANY)
    {
        if ($this-&gt;hasIdentity())
        {
            $accessRecors = $this-&gt;_filterNotActiveAccess($this-&gt;_getAccessRecords($search));
            return (bool) count($accessRecors);
        }
        else
        {
            return false;
        }
    }

    /**
     * Whether logged-in user had active subscription or not
     *
     * @param int|array $search
     * @return bool
     */
    public function hadSubscriptions($search = self::ANY)
    {
        if ($this-&gt;hasIdentity())
        {
            $accessRecors = $this-&gt;_getAccessRecords($search);
            return (bool) count($accessRecors);
        }
        else
        {
            return false;
        }
    }

    /**
     * Retrieve max expire date for selected products
     * for logged-in user
     *
     * @param &lt;type&gt; $search
     * @return string|null date in SQL format YY-mm-dd
     */
    public function getExpire($search = self::ANY)
    {
        $expire = null;
        if ($this-&gt;hasIdentity())
        {
            $accessRecors = $this-&gt;_getAccessRecords($search);
            foreach ($accessRecors as $access)
            {
                if ($access[&#039;expire_date&#039;] &gt; $expire)
                {
                    $expire = $access[&#039;expire_date&#039;];
                }
            }
        }
        return $expire;
    }

    /**
     * Retrieve the earliest begin date for selected products
     * for logged-in user
     *
     * @param &lt;type&gt; $search
     * @return string|null date in SQL format YY-mm-dd
     */
    public function getBegin($search = self::ANY)
    {
        $begin = self::MAX_SQL_DATE;
        if ($this-&gt;hasIdentity())
        {
            $accessRecors = $this-&gt;_getAccessRecords($search);
            foreach ($accessRecors as $access)
            {
                if ($access[&#039;begin_date&#039;] &lt; $begin)
                {
                    $begin = $access[&#039;begin_date&#039;];
                }
            }
        }
        return $begin == self::MAX_SQL_DATE ? null : $begin;
    }

    /**
     * Retrieve payments for logged-in user
     *
     * @return array
     */
    public function getPayments()
    {
        $result = array();
        if ($this-&gt;hasIdentity())
        {
            $user_id = $this-&gt;getUserField(&#039;user_id&#039;);
            $res = $this-&gt;query(
                &#039;SELECT * FROM ?_invoice_payment
                        WHERE user_id=?&#039;, $user_id);
            foreach ($res as $p_rec)
            {
                $result[] = $p_rec;
            }
        }
        return $result;
    }

    public function getUserLinks()
    {
        $sess = $this-&gt;getSession();
        return $sess[&#039;amember&#039;][&#039;amember_links&#039;];
    }

    /**
     * Retrieve access records for logged-in user
     *
     * @return array
     */
    public function getAccess()
    {
        return $this-&gt;hasIdentity() ?
            $this-&gt;_getAccessRecords(self::ANY) :
            array();
    }

    public function getAccessCache()
    {
        return $this-&gt;hasIdentity() ?
            $this-&gt;_getAccessCache($this-&gt;getUserField(&#039;user_id&#039;)) :
            array();
    }

    public function isUserActive()
    {
        $access_cache = $this-&gt;getAccessCache();
        foreach ($access_cache as $r)
        {
            if ($r[&#039;status&#039;] == self::ACTIVE)
                return true;
        }
        return false;
    }

    public function getProducts()
    {
        $products = array();
        $res = $this-&gt;query(&quot;SELECT product_id, title
            FROM ?_product
            ORDER BY 0+sort_order, title&quot;);
        foreach ($res as $r)
        {
            $products[$r[&#039;product_id&#039;]] = $r[&#039;title&#039;];
        }
        return $products;
    }

    public function getCategories()
    {
        $ret = $parents = array();
        $sql = &quot;SELECT product_category_id,
                parent_id, title, code
                FROM ?_product_category
                ORDER BY parent_id, 0+sort_order&quot;;
        $rows = $this-&gt;query($sql);

        foreach ($rows as $id =&gt; $r)
        {
            $parents[$r[&#039;product_category_id&#039;]] = $r;
            $title = $r[&#039;title&#039;];
            $parent_id = $r[&#039;parent_id&#039;];
            while ($parent_id)
            {
                $parent = $parents[$parent_id];
                $title = $parent[&#039;title&#039;] . &#039;/&#039; . $title;
                $parent_id = $parent[&#039;parent_id&#039;];
            }
            $ret[$r[&#039;product_category_id&#039;]] = $title;
        }
        return $ret;
    }

    /**
     * Retrieve array of product ids that is member of specific category
     *
     * @param int|array $category_id
     * @return array
     */
    public function getCategoryProducts($category_id)
    {
        $result = array();

        $rows = $this-&gt;query(&quot;SELECT product_id FROM ?_product_product_category
            WHERE product_category_id IN (?)&quot;, (array)$category_id);

        foreach ($rows as $row)
            $result[] = $row[&#039;product_id&#039;];

        return $result;
    }

    /**
     * Remove not active access from array
     *
     * @param array $access
     * @return array
     */
    protected function _filterNotActiveAccess($access)
    {
        $now = date(&#039;Y-m-d&#039;);
        foreach ($access as $k =&gt; $v)
        {
            if ($v[&#039;begin_date&#039;] &gt; $now || $v[&#039;expire_date&#039;] &lt; $now)
            {
                unset($access[$k]);
            }
        }
        return $access;
    }

    /**
     * Remove active access from array
     *
     * @param array $access
     * @return array
     */
    protected function _filterActiveAccess($access)
    {
        $now = date(&#039;Y-m-d&#039;);
        foreach ($access as $k =&gt; $v)
        {
            if ($v[&#039;begin_date&#039;] &lt;= $now &amp;&amp; $v[&#039;expire_date&#039;] &gt;= $now)
            {
                unset($access[$k]);
            }
        }
        return $access;
    }

    protected function _getAccessCache($user_id)
    {
        $sql = &quot;SELECT * FROM ?_access_cache where user_id =?&quot;;
        $res = $this-&gt;query($sql, $user_id);
        $result = array();
        foreach ($res as $r)
        {
            $result[] = $r;
        }
        return $result;
    }

    protected function _getAccessRecords($search)
    {
        $result = array();
        $user_id = $this-&gt;getUserField(&#039;user_id&#039;);
        $args = func_get_args();
        if (count($args) == 1 &amp;&amp; !is_array($args[0]))
        {
            switch ($args[0])
            {
                case self::ANY :
                    $sql = &quot;SELECT * FROM ?_access WHERE user_id=?&quot;;
                    break;
                case self::PAID :
                    $sql = &quot;SELECT a.* FROM ?_access a
                            LEFT JOIN ?_invoice_payment p
                            USING(invoice_payment_id)
                            WHERE p.amount&gt;0 AND a.user_id=?&quot;;
                    break;
                case self::FREE :
                    $sql = &quot;SELECT a.* FROM ?_access a
                            LEFT JOIN ?_invoice_payment p
                            USING(invoice_payment_id)
                            WHERE (p.amount=0 OR p.amount IS NULL) AND a.user_id=?&quot;;
                    break;
                default:
                    $sql = sprintf(&quot;SELECT * FROM ?_access WHERE user_id=?
                            AND product_id=&#039;%d&#039;&quot;, $args[0]);
            }
        }
        else
        {
            $p_ids = is_array($args[0]) ? $args[0] : $args;
            $p_ids = array_map(&#039;intval&#039;, $p_ids);

            $sql = sprintf(&quot;SELECT * FROM ?_access WHERE user_id=?
                    AND product_id IN (%s)&quot;, implode(&#039;,&#039;, $p_ids));
        }

        $res = $this-&gt;query($sql, $user_id);
        foreach ($res as $a_rec)
        {
            $result[] = $a_rec;
        }

        return $result;
    }

    /**
     *
     * @return PDO
     */
    protected function getDb()
    {
        if (is_null($this-&gt;_db))
        {
            $config = $this-&gt;getDbConfig();

            try
            {
                $this-&gt;_db = new PDO(
                        sprintf(&#039;mysql:host=%s;dbname=%s&#039;, $config[&#039;host&#039;], $config[&#039;db&#039;]
                        ), $config[&#039;user&#039;], $config[&#039;pass&#039;]
                );
                $this-&gt;_db-&gt;query(&quot;SET NAMES UTF8&quot;);
            }
            catch (Exception $e)
            {
                $this-&gt;error($e);
            }
        }

        return $this-&gt;_db;
    }

    /**
     * Execute SQL query
     *
     * @param string $sql
     * @return PDOStatement
     */
    protected function query($sql, $args = null)
    {
        $db_config = $this-&gt;getDbConfig();
        $sql = preg_replace(&#039;/(\s)\?_([a-z0-9_]+)\b/&#039;, &#039;\1&#039; . $db_config[&#039;prefix&#039;] . &#039;\2&#039;, $sql);
        $argv = func_get_args();
        $argc = func_num_args();

        for ($i = 1; $i &lt; $argc; $i++) //skip first value, it is $sql
        {
            $arg = $argv[$i];
            if (is_array($arg))
            {
                $arg = implode(&#039;,&#039;, array_map(array($this-&gt;getDb(), &#039;quote&#039;), $arg));
            }
            elseif (is_null($arg))
            {
                $arg = &#039;NULL&#039;;
            }
            else
            {
                $arg = $this-&gt;getDb()-&gt;quote($arg);
            }

            $sql = preg_replace(&#039;/\?/&#039;, $arg, $sql, 1); // $arg is already quoted
        }

        $statement = $this-&gt;getDb()-&gt;query($sql);
        if (!$statement)
        {
            $errorInfo = $this-&gt;getDb()-&gt;errorInfo();
            $this-&gt;error($errorInfo[2]);
        }
        $statement-&gt;setFetchMode(PDO::FETCH_ASSOC);

        return $statement;
    }

    protected function getDbConfig()
    {
        if (is_null($this-&gt;_db_config))
        {
            $file = dirname(__FILE__) . &#039;/../../application/configs/config.php&#039;;
            if (!file_exists($file))
            {
                $this-&gt;error(&#039;Can not find file with aMember config&#039;);
            }
            $config = @include($file);
            if (!is_array($config))
            {
                $this-&gt;error(&#039;aMember config should return array&#039;);
            }
            $this-&gt;_db_config = $config[&#039;db&#039;][&#039;mysql&#039;];
        }
        return $this-&gt;_db_config;
    }

    protected function getConfig()
    {
        $res = $this-&gt;query(&quot;SELECT config FROM ?_config WHERE name=&#039;default&#039;&quot;);
        $config = $res-&gt;fetch();
        return unserialize($config[&#039;config&#039;]);
    }

    protected function getConfigValue($name)
    {
        $config = $this-&gt;getConfig();
        return isset($config[$name]) ? $config[$name] : null;
    }

    protected function hasIdentity()
    {
        $session = $this-&gt;getSession();
        return @isset($session[&#039;amember_auth&#039;][&#039;user&#039;]);
    }

    protected function getIdentity()
    {
        if ($this-&gt;hasIdentity())
        {
            $session = $this-&gt;getSession();
            return $session[&#039;amember_auth&#039;][&#039;user&#039;];
        }
        else
        {
            return null;
        }
    }

    protected function getUserField($name)
    {
        if ($this-&gt;hasIdentity())
        {
            $user = $this-&gt;getIdentity();
            return $user[$name];
        }
        else
        {
            return null;
        }
    }

    protected function getPHPSession()
    {
        $this-&gt;_session = $_SESSION;
        $this-&gt;processStartupMetadata($this-&gt;_session);
        return $this-&gt;_session;
    }

    protected function getSession()
    {
        if ($this-&gt;usePHPSessions)
        {
            return $this-&gt;getPHPSession();
        }
        if (is_null($this-&gt;_session))
        {
            $session_id = @$_COOKIE[$this-&gt;getSessionName()];
            if ($session_id)
            {
                /** @var $res PDOStatement */
                $res = $this-&gt;query(
                    sprintf(&quot;SELECT * FROM ?_session WHERE id=? AND (%s - modified) &lt; lifetime&quot;, time()), $session_id);

                $session = $res-&gt;fetch();
                $this-&gt;_session = $session ?
                    $this-&gt;unserializeSession($session[&#039;data&#039;]) :
                    array();
            }
            else
            {
                $this-&gt;_session = array();
            }
            $this-&gt;processStartupMetadata($this-&gt;_session);
        }
        return $this-&gt;_session;
    }

    /**
     * remove expired namespaces and variables
     *
     * @see Zend_Session::_processStartupMetadataGlobal
     * @param array $session 
     */
    protected function processStartupMetadata(&amp;$session)
    {
        if (isset($session[&#039;__ZF&#039;]))
        {
            foreach ($session[&#039;__ZF&#039;] as $namespace =&gt; $namespace_metadata)
            {
                // Expire Namespace by Time (ENT)
                if (isset($namespace_metadata[&#039;ENT&#039;]) &amp;&amp; ($namespace_metadata[&#039;ENT&#039;] &gt; 0) &amp;&amp; (time() &gt; $namespace_metadata[&#039;ENT&#039;]))
                {
                    unset($session[$namespace]);
                    unset($session[&#039;__ZF&#039;][$namespace]);
                }

                // Expire Namespace Variables by Time (ENVT)
                if (isset($namespace_metadata[&#039;ENVT&#039;]))
                {
                    foreach ($namespace_metadata[&#039;ENVT&#039;] as $variable =&gt; $time)
                    {
                        if (time() &gt; $time)
                        {
                            unset($session[$namespace][$variable]);
                            unset($session[&#039;__ZF&#039;][$namespace][&#039;ENVT&#039;][$variable]);
                        }
                    }
                    if (empty($session[&#039;__ZF&#039;][$namespace][&#039;ENVT&#039;]))
                    {
                        unset($session[&#039;__ZF&#039;][$namespace][&#039;ENVT&#039;]);
                    }
                }
            }
        }
    }

    /**
     *
     * @param string $data session encoded
     * @return array
     */
    function unserializeSession($str)
    {
        $str = (string) $str;

        $endptr = strlen($str);
        $p = 0;

        $serialized = &#039;&#039;;
        $items = 0;
        $level = 0;

        while ($p &lt; $endptr)
        {
            $q = $p;
            while ($str[$q] != PS_DELIMITER)
                if (++$q &gt;= $endptr)
                    break 2;

            if ($str[$p] == PS_UNDEF_MARKER)
            {
                $p++;
                $has_value = false;
            }
            else
            {
                $has_value = true;
            }

            $name = substr($str, $p, $q - $p);
            $q++;

            $serialized .= &#039;s:&#039; . strlen($name) . &#039;:&quot;&#039; . $name . &#039;&quot;;&#039;;

            if ($has_value)
            {
                for (;;)
                {
                    $p = $q;
                    switch ($str[$q])
                    {
                        case &#039;N&#039;: /* null */
                        case &#039;b&#039;: /* boolean */
                        case &#039;i&#039;: /* integer */
                        case &#039;d&#039;: /* decimal */
                            do
                                $q++;
                            while (($q &lt; $endptr) &amp;&amp; ($str[$q] != &#039;;&#039;));
                            $q++;
                            $serialized .= substr($str, $p, $q - $p);
                            if ($level == 0)
                                break 2;
                            break;
                        case &#039;R&#039;: /* reference  */
                            $q+= 2;
                            for ($id = &#039;&#039;; ($q &lt; $endptr) &amp;&amp; ($str[$q] != &#039;;&#039;); $q++)
                                $id .= $str[$q];
                            $q++;
                            $serialized .= &#039;R:&#039; . ($id + 1) . &#039;;&#039;; /* increment pointer because of outer array */
                            if ($level == 0)
                                break 2;
                            break;
                        case &#039;s&#039;: /* string */
                            $q+=2;
                            for ($length = &#039;&#039;; ($q &lt; $endptr) &amp;&amp; ($str[$q] != &#039;:&#039;); $q++)
                                $length .= $str[$q];
                            $q+=2;
                            $q+= (int) $length + 2;
                            $serialized .= substr($str, $p, $q - $p);
                            if ($level == 0)
                                break 2;
                            break;
                        case &#039;a&#039;: /* array */
                        case &#039;O&#039;: /* object */
                            do
                                $q++;
                            while (($q &lt; $endptr) &amp;&amp; ($str[$q] != &#039;{&#039;));
                            $q++;
                            $level++;
                            $serialized .= substr($str, $p, $q - $p);
                            break;
                        case &#039;}&#039;: /* end of array|object */
                            $q++;
                            $serialized .= substr($str, $p, $q - $p);
                            if (--$level == 0)
                                break 2;
                            break;
                        default:
                            return false;
                    }
                }
            } else
            {
                $serialized .= &#039;N;&#039;;
                $q+= 2;
            }
            $items++;
            $p = $q;
        }
        return @unserialize(&#039;a:&#039; . $items . &#039;:{&#039; . $serialized . &#039;}&#039;);
    }

    /**
     * @return Name of aMember&#039;s session variable.
     */
    protected function getSessionName()
    {
        if (defined(&#039;AM_SESSION_NAME&#039;) &amp;&amp; AM_SESSION_NAME)
            return AM_SESSION_NAME;
        else
            return self::SESSION_NAME;
    }

    protected function error($msgOrException)
    {
        $msg = is_string($msgOrException) ? $msgOrException : $msgOrException-&gt;getMessage();
        $exception = is_string($msgOrException) ? new Exception($msgOrException) : $msgOrException;

        if ($this-&gt;useExceptions)
        {
            throw $exception;
        }
        else
        {
            trigger_error($msg, E_USER_ERROR);
        }
    }

}

/*
 * Init Am_Lite 
 * see constructor for more details;
 */

Am_Lite::getInstance();
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2F4xpips.net%2Fsecure%2Fdata%2F.upgrade.s1rjgv-unpack%2Famember%2Flibrary%2FAm'>⬅ Back to Directory</a>