<?php

class UserPoint {
	
	/** @TplVar("USER_POINT_FIELD") */
	private $field_name = "Points";
	
	/** 
	 * @Datasource
	 * @var TcnvSQL 
	 */
	private static $sql;


	/** @InterceptPostRow */
	public function postRow($action,$postrow){
		
		$postrow['POSTER_POINT'] = $this->getPoint($postrow['POSTER_ID']);
	}
	
	private function getPoint($user_id) {
		/* @var $sql TcnvSQL */
		$sql = self::$sql;
		
		$result_query = $sql->query("SELECT point FROM zs_user_point WHERE user=".$user_id);
		$result = $sql->feach_array($result_query);
		
		$point = $result[0];
		
		if(!isset ($point) || $point == "") $point = 0;
		return $point;
	}
}

?>