x-tools / xtools

     * @param  Page page

     * @return string[] each entry with keys 'log_action', 'log_type' and 'timestamp'.

     */

    public function getLogEvents(Page $page)

    {

        $loggingTable = $page->getProject()->getTableName('logging', 'logindex');

        $sql = "SELECT log_action, log_type, log_timestamp AS 'timestamp'

                FROM $loggingTable

                WHERE log_namespace = '" . $page->getNamespace() . "'

                AND log_title = :title AND log_timestamp > 1

                AND log_type IN ('delete', 'move', 'protect', 'stable')";

        $title = str_replace(' ', '_', $page->getTitle());

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

        $resultQuery->bindParam(':title', $title);

        $resultQuery->execute();

        return $resultQuery->fetchAll();

    }

}

     * @param User $user

     * @return array

     */

    public function getBlocksReceived(Project $project, User $user)

    {

        $loggingTable = $this->getTableName($project->getDatabaseName(), 'logging', 'logindex');

        $sql = "SELECT log_action, log_timestamp, log_params FROM $loggingTable

                WHERE log_type = 'block'

                AND log_action IN ('block', 'reblock', 'unblock')

                AND log_timestamp > 0

                AND log_title = :username

                AND log_namespace = 2

                ORDER BY log_timestamp ASC";

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

        $username = str_replace(' ', '_', $user->getUsername());

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

        $resultQuery->execute();

        return $resultQuery->fetchAll();

    }

    /**

     * Get a user's total edit count on all projects.