Hey all,

I would like to track number of views of each page, so i wrote:

class Page extends SiteTree {
	public static $db = array(
	    'Viewed' => 'Int'
	);
}
class Page_Controller extends ContentController {
	
public function init() {
parent::init();
      if ($this->ID) {
    	if (!Session::get('Visited_'.$this->ID)) {
        $page = DataObject::get_by_id('Page', $this->ID);
        
        if ($page) {
          $page->Viewed++;
          $page->writeToStage("Stage");
          $page->publish("Stage", "Live");
        }
      Session::set('Visited_'.$this->ID, true);
      }
    }
}

This solution works however i end up with huge amount of version copies (each for one view increment)

Is there any way to avoid versioning on save? Or is there a better solution?

Thanks,

I've got this (i used solution from forum module) :)

$this->Viewed++;
$SQL_numViews = Convert::raw2sql($this->Viewed);
DB::query("UPDATE Page_live SET Viewed = '$SQL_numViews' WHERE ID = $this->ID");

Well, i don't mind using sql, however this approach is database specific and might be broken. It might be a good idea to have function like unversionedWrite or write() with boolean param.

Or am i missing something? Any other ideas?

Thanks