<?php

$sortDirection = fRequest::getValid('dir', array('desc', 'asc'));
    if(empty($sortDirection)){
        $sortDirection = 'asc';
    }

    $result = $db->query('SELECT * FROM box_event_log_view ORDER BY %s ' . $sortDirection . ' LIMIT %i OFFSET (%i)',
            $sortBy,
            $showPerPage,
            ($pageNumber -1)*$showPerPage
    );