x-tools / xtools

     * @param string $username The username to find.

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

     */

    public function getEditCount($databaseName, $username)

    {

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

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

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

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

        $resultQuery->execute();

        return $resultQuery->fetchColumn();

    }

    /**

     * Get group names of the given user.

     * @param $userid The ID of the user to search for.

     * @return bool|string Expiry of active block or false

     */

    public function getBlockExpiry($databaseName, $userid)

    {

        $ipblocksTable = $this->getTableName($databaseName, 'ipblocks');

        $sql = "SELECT ipb_expiry

                FROM $ipblocksTable

                WHERE ipb_user = :userid

                LIMIT 1";

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

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

        $resultQuery->execute();

        return $resultQuery->fetchColumn();

    }

    /**

     * Count the number of pages created by a user.