function show($params) {
     $char = Character::find()->where(array('guid' => $params['guid']))->realm($params['rid'])->first();
     $events = Event::find()->where(array('target_class' => 'Character', 'target_dbid' => $params['rid'], 'target_id' => $params['guid']));
     $cheats = CheatLogEntry::find()->realm($params['rid'])->where(array('guid' => $params['guid']));
     if ($char->guid == $params['guid']) {
         $this->render(array(
             'character' => $char,
             'events_count' => $events->count(),
             'cheats_count' => $cheats->count()
         ));
     } else {
         $this->render_error('404');
     }
 }
    function index($params){     
        if(empty($params['realm_id']))
            $params['realm_id'] = Realm::find()->first()->id;

        if(!isset($params['order'])){
            $params['order'] = 'alarm_time DESC';
        }
        
        if(isset($params['checktype']) && $params['checktype'] == 'all')
            unset($params['checktype']);
        
        $realms = Realm::find()->available()->all();
        $realmnames = array();
        foreach($realms as $r){
            $realmnames[$r->id] = $r->name;
        }
        
        $cheatconfig = CheatConfigEntry::find()->realm($params['realm_id'])->all();
        
        $reasons = array('' => 'all');
        foreach($cheatconfig as $cc){
            $reasons[(string)$cc->checktype] = $cc->description;
        }
        
        $log_entries = CheatLogEntry::find()
                ->where($params)
                ->realm($params['realm_id'])
                ->order($params['order']);

        if(isset($params['page'])) $log_entries->page($params['page']);
        
        $data = array(
            'log_entries' => $log_entries->all(),
            'log_entries_count' => $log_entries->count(),
            'realmnames' => $realmnames,
            'realmid' => $params['realm_id'],
            'reasons' => $reasons
        );
        
        if(!isset($params['partial'])){
            $this->render($data);
        } else {
            $this->render_partial('cheatlog', $data);
        }
    }