<?php

/*
OneLobby
Copyright (C) 2007 Peter Goodman, Geoffrey Goodman

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/

class WallPostsDefinition extends FAModelDefinition 
{
	
	var $_constraints = array(
		'body' => '/.+/',
	);
	
	function getField($field, $insert = FALSE) 
	{
		$prefix = !$insert ? 'wp.' : '';
		return "$prefix$field";
	}
	
	function getPrimaryKey() 
	{
		return 'post_id';
	}
	
	function getTable() {
		return 'k4_wall_posts';
	}
	
	function getSelectFields() 
	{
		return "wp.*, u.name AS poster_name";
	}
	
	function getSelectGroupby() 
	{
		return 'wp.post_id';
	}
	
	function getSelectTables() 
	{
		return 'k4_wall_posts wp LEFT JOIN k4_users u ON wp.poster_id=u.user_id';
	}
}

?>