x-tools / xtools

     * @param string $username The username to find.

     * @return int

     */

    public function getId($databaseName, $username)

    {

        $cacheKey = $this->getCacheKey(func_get_args(), 'user_id');

        if ($this->cache->hasItem($cacheKey)) {

            return $this->cache->getItem($cacheKey)->get();

        }

        $userTable = $this->getTableName($databaseName, 'user');

        $sql = "SELECT user_id FROM $userTable WHERE user_name = :username LIMIT 1";

        $resultQuery = $this->getProjectsConnection()->prepare($sql);

        $resultQuery->bindParam('username', $username);

        $resultQuery->execute();

        $userId = (int)$resultQuery->fetchColumn();

        // Cache for 10 minutes and return.

        $this->setCache($cacheKey, $userId);

        return $userId;

    }

    /**

     * Get the user's registration date.

     * @param string $username The username to find.

     * @return string|null As returned by the database.

     */

    public function getRegistrationDate($databaseName, $username)

    {

        $cacheKey = $this->getCacheKey(func_get_args(), 'user_registration');

        if ($this->cache->hasItem($cacheKey)) {

            return $this->cache->getItem($cacheKey)->get();

        }

        $userTable = $this->getTableName($databaseName, 'user');

        $sql = "SELECT user_registration FROM $userTable WHERE user_name = :username LIMIT 1";

        $resultQuery = $this->getProjectsConnection()->prepare($sql);

        $resultQuery->bindParam('username', $username);

        $resultQuery->execute();

        $registrationDate = $resultQuery->fetchColumn();

        // Cache and return.

        $this->setCache($cacheKey, $registrationDate);

        return $registrationDate;

    }

    /**

     * Get the user's (system) edit count.