class DataObjects_Members extends DB_DataObject
{
	var $__table = 'members';
	var $id;
	var $handle;
	var $male;
	var $orient;
	var $age;
	var $country;
	var $city;
	var $desc_personal;
	var $desc_status;
	var $desc_looking;
	var $pic;
	var $pic_status;
	var $is_online;
	var $cts;
	var $inbox;
	var $sentbox;
	var $archbox;
	var $binbox;
	var $history;
	var $profback;
	var $frontpage;
	//var $postcode;
    

        function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('DataObjects_Members',$k,$v); }

    function table() {
        return array(
            	'id'			=> DB_DATAOBJECT_INT,
		'handle'		=> DB_DATAOBJECT_STR,
		'orient'		=> DB_DATAOBJECT_INT,
                'male'			=> DB_DATAOBJECT_INT,
		'country'		=> DB_DATAOBJECT_INT,
		'city'			=> DB_DATAOBJECT_INT,
		'age'			=> DB_DATAOBJECT_INT,
                'desc_personal'		=> DB_DATAOBJECT_STR + DB_DATAOBJECT_TXT,
		'desc_status'		=> DB_DATAOBJECT_INT,
		'desc_looking'		=> DB_DATAOBJECT_STR + DB_DATAOBJECT_TXT,
        	'pic'			=> DB_DATAOBJECT_STR,
		'pic_status'		=> DB_DATAOBJECT_INT,
		'is_online'		=> DB_DATAOBJECT_INT,
		'cts'			=> DB_DATAOBJECT_INT,
		'inbox'			=> DB_DATAOBJECT_STR,
		'sentbox'		=> DB_DATAOBJECT_STR,
		'archbox'		=> DB_DATAOBJECT_STR,
		'binbox'		=> DB_DATAOBJECT_STR,
		'history'		=> DB_DATAOBJECT_STR,
		'profback'		=> DB_DATAOBJECT_STR,
		'frontpage'		=> DB_DATAOBJECT_STR
        );
    }

	function getLastOn()
	{
		if ($this->is_online == '1') {
			return '<span style="font-weight:bold;">online now</span>';
		} else {
			$mlp = $this->getLink('id', 'liveuser_perm_users', 'perm_user_id');
			$mla = $mlp->getLink('auth_user_id', 'liveuser_users', 'auth_user_id');
			$ll = $mla->lastlogin;
			if (strlen($ll)) {
				$llp = sscanf($ll, '%04u%02u%02u%02u%02u%02u');
				$lls = vsprintf('%04u-%02u-%02u %02u:%02u:%02u', $llp);
				$ds = new Date_Span();
				$ds->setFromDateDiff(new Date($lls), new Date());
				$dsd = floor($ds->toDays());
				$dsi = $ds->format('%C');
				$dss = '<span style="font-weight:bold;">' . ($dsd < 1 ? 'today' : ($dsd == 1 ? 'yesterday' : $dsd . ' days ago')) . '</span>';
				return 'last online: ' . $dss;
			} else {
				return '<span style="font-weight:bold;">new member</span>';
			}
		}
	}
}

$mobj =& DB_DataObject::factory('members');