<?php namespace PHPMaker2020\Alliance; ?>
<?php

/**
 * Table class for wp_wpl_users
 */
class wp_wpl_users extends DbTable
{
	protected $SqlFrom = "";
	protected $SqlSelect = "";
	protected $SqlSelectList = "";
	protected $SqlWhere = "";
	protected $SqlGroupBy = "";
	protected $SqlHaving = "";
	protected $SqlOrderBy = "";
	public $UseSessionForListSql = TRUE;

	// Column CSS classes
	public $LeftColumnClass = "col-sm-2 col-form-label ew-label";
	public $RightColumnClass = "col-sm-10";
	public $OffsetColumnClass = "col-sm-10 offset-sm-2";
	public $TableLeftColumnClass = "w-col-2";

	// Export
	public $ExportDoc;

	// Fields
	public $id;
	public $membership_name;
	public $membership_id;
	public $membership_type;
	public $_index;
	public $access_propertywizard;
	public $access_propertyshow;
	public $access_propertylisting;
	public $access_profilewizard;
	public $access_confirm;
	public $access_propertymanager;
	public $access_delete;
	public $access_public_profile;
	public $access_change_user;
	public $access_receive_notifications;
	public $first_name;
	public $last_name;
	public $about;
	public $company_name;
	public $company_address;
	public $website;
	public $main_email;
	public $secondary_email;
	public $sex;
	public $tel;
	public $fax;
	public $mobile;
	public $languages;
	public $location1_id;
	public $location2_id;
	public $location3_id;
	public $location4_id;
	public $location5_id;
	public $location6_id;
	public $location7_id;
	public $location1_name;
	public $location2_name;
	public $location3_name;
	public $location4_name;
	public $location5_name;
	public $location6_name;
	public $location7_name;
	public $show_address;
	public $zip_id;
	public $zip_name;
	public $maccess_num_prop;
	public $maccess_num_feat;
	public $maccess_num_hot;
	public $maccess_num_pic;
	public $maccess_period;
	public $maccess_price;
	public $maccess_price_unit;
	public $maccess_lrestrict;
	public $maccess_listings;
	public $maccess_ptrestrict;
	public $maccess_property_types;
	public $maccess_renewable;
	public $maccess_renewal_price;
	public $maccess_renewal_price_unit;
	public $maccess_upgradable;
	public $maccess_upgradable_to;
	public $maccess_short_description;
	public $maccess_long_description;
	public $maccess_wpl_color;
	public $expired;
	public $expiry_date;
	public $textsearch;
	public $location_text;
	public $rendered;
	public $last_modified_time_stamp;
	public $profile_picture;
	public $company_logo;
	public $maccess_lrestrict_pshow;
	public $maccess_ptrestrict_pshow;
	public $maccess_listings_pshow;
	public $maccess_property_types_pshow;
	public $maccess_lrestrict_plisting;
	public $maccess_ptrestrict_plisting;
	public $maccess_listings_plisting;
	public $maccess_property_types_plisting;
	public $access_clone;
	public $access_propertystats;
	public $maccess_crm;
	public $online_status;
	public $access_CRM;
	public $crm_selected_fields;
	public $crm_cookies;
	public $rendered_en_us;
	public $textsearch_en_us;
	public $rendered_fr_fr;
	public $textsearch_fr_fr;

	// Constructor
	public function __construct()
	{
		global $Language, $CurrentLanguage;
		parent::__construct();

		// Language object
		if (!isset($Language))
			$Language = new Language();
		$this->TableVar = 'wp_wpl_users';
		$this->TableName = 'wp_wpl_users';
		$this->TableType = 'TABLE';

		// Update Table
		$this->UpdateTable = "`wp_wpl_users`";
		$this->Dbid = 'DB';
		$this->ExportAll = TRUE;
		$this->ExportPageBreakCount = 0; // Page break per every n record (PDF only)
		$this->ExportPageOrientation = "portrait"; // Page orientation (PDF only)
		$this->ExportPageSize = "a4"; // Page size (PDF only)
		$this->ExportExcelPageOrientation = \PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::ORIENTATION_DEFAULT; // Page orientation (PhpSpreadsheet only)
		$this->ExportExcelPageSize = \PhpOffice\PhpSpreadsheet\Worksheet\PageSetup::PAPERSIZE_A4; // Page size (PhpSpreadsheet only)
		$this->ExportWordPageOrientation = "portrait"; // Page orientation (PHPWord only)
		$this->ExportWordColumnWidth = NULL; // Cell width (PHPWord only)
		$this->DetailAdd = FALSE; // Allow detail add
		$this->DetailEdit = FALSE; // Allow detail edit
		$this->DetailView = FALSE; // Allow detail view
		$this->ShowMultipleDetails = FALSE; // Show multiple details
		$this->GridAddRowCount = 5;
		$this->AllowAddDeleteRow = TRUE; // Allow add/delete row
		$this->UserIDAllowSecurity = Config("DEFAULT_USER_ID_ALLOW_SECURITY"); // Default User ID allowed permissions
		$this->BasicSearch = new BasicSearch($this->TableVar);

		// id
		$this->id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_id', 'id', '`id`', '`id`', 3, 10, -1, FALSE, '`id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'NO');
		$this->id->IsAutoIncrement = TRUE; // Autoincrement field
		$this->id->IsPrimaryKey = TRUE; // Primary key field
		$this->id->Sortable = TRUE; // Allow sort
		$this->id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['id'] = &$this->id;

		// membership_name
		$this->membership_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_membership_name', 'membership_name', '`membership_name`', '`membership_name`', 200, 255, -1, FALSE, '`membership_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->membership_name->Sortable = TRUE; // Allow sort
		$this->fields['membership_name'] = &$this->membership_name;

		// membership_id
		$this->membership_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_membership_id', 'membership_id', '`membership_id`', '`membership_id`', 3, 10, -1, FALSE, '`membership_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->membership_id->Sortable = TRUE; // Allow sort
		$this->membership_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['membership_id'] = &$this->membership_id;

		// membership_type
		$this->membership_type = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_membership_type', 'membership_type', '`membership_type`', '`membership_type`', 200, 10, -1, FALSE, '`membership_type`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->membership_type->Sortable = TRUE; // Allow sort
		$this->fields['membership_type'] = &$this->membership_type;

		// index
		$this->_index = new DbField('wp_wpl_users', 'wp_wpl_users', 'x__index', 'index', '`index`', '`index`', 4, 5, -1, FALSE, '`index`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->_index->Nullable = FALSE; // NOT NULL field
		$this->_index->Required = TRUE; // Required field
		$this->_index->Sortable = TRUE; // Allow sort
		$this->_index->DefaultErrorMessage = $Language->phrase("IncorrectFloat");
		$this->fields['index'] = &$this->_index;

		// access_propertywizard
		$this->access_propertywizard = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_propertywizard', 'access_propertywizard', '`access_propertywizard`', '`access_propertywizard`', 16, 4, -1, FALSE, '`access_propertywizard`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_propertywizard->Nullable = FALSE; // NOT NULL field
		$this->access_propertywizard->Required = TRUE; // Required field
		$this->access_propertywizard->Sortable = TRUE; // Allow sort
		$this->access_propertywizard->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_propertywizard'] = &$this->access_propertywizard;

		// access_propertyshow
		$this->access_propertyshow = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_propertyshow', 'access_propertyshow', '`access_propertyshow`', '`access_propertyshow`', 16, 4, -1, FALSE, '`access_propertyshow`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_propertyshow->Nullable = FALSE; // NOT NULL field
		$this->access_propertyshow->Required = TRUE; // Required field
		$this->access_propertyshow->Sortable = TRUE; // Allow sort
		$this->access_propertyshow->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_propertyshow'] = &$this->access_propertyshow;

		// access_propertylisting
		$this->access_propertylisting = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_propertylisting', 'access_propertylisting', '`access_propertylisting`', '`access_propertylisting`', 16, 4, -1, FALSE, '`access_propertylisting`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_propertylisting->Nullable = FALSE; // NOT NULL field
		$this->access_propertylisting->Required = TRUE; // Required field
		$this->access_propertylisting->Sortable = TRUE; // Allow sort
		$this->access_propertylisting->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_propertylisting'] = &$this->access_propertylisting;

		// access_profilewizard
		$this->access_profilewizard = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_profilewizard', 'access_profilewizard', '`access_profilewizard`', '`access_profilewizard`', 16, 4, -1, FALSE, '`access_profilewizard`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_profilewizard->Nullable = FALSE; // NOT NULL field
		$this->access_profilewizard->Required = TRUE; // Required field
		$this->access_profilewizard->Sortable = TRUE; // Allow sort
		$this->access_profilewizard->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_profilewizard'] = &$this->access_profilewizard;

		// access_confirm
		$this->access_confirm = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_confirm', 'access_confirm', '`access_confirm`', '`access_confirm`', 16, 4, -1, FALSE, '`access_confirm`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_confirm->Nullable = FALSE; // NOT NULL field
		$this->access_confirm->Required = TRUE; // Required field
		$this->access_confirm->Sortable = TRUE; // Allow sort
		$this->access_confirm->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_confirm'] = &$this->access_confirm;

		// access_propertymanager
		$this->access_propertymanager = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_propertymanager', 'access_propertymanager', '`access_propertymanager`', '`access_propertymanager`', 16, 4, -1, FALSE, '`access_propertymanager`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_propertymanager->Nullable = FALSE; // NOT NULL field
		$this->access_propertymanager->Required = TRUE; // Required field
		$this->access_propertymanager->Sortable = TRUE; // Allow sort
		$this->access_propertymanager->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_propertymanager'] = &$this->access_propertymanager;

		// access_delete
		$this->access_delete = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_delete', 'access_delete', '`access_delete`', '`access_delete`', 16, 4, -1, FALSE, '`access_delete`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_delete->Nullable = FALSE; // NOT NULL field
		$this->access_delete->Required = TRUE; // Required field
		$this->access_delete->Sortable = TRUE; // Allow sort
		$this->access_delete->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_delete'] = &$this->access_delete;

		// access_public_profile
		$this->access_public_profile = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_public_profile', 'access_public_profile', '`access_public_profile`', '`access_public_profile`', 16, 4, -1, FALSE, '`access_public_profile`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_public_profile->Nullable = FALSE; // NOT NULL field
		$this->access_public_profile->Required = TRUE; // Required field
		$this->access_public_profile->Sortable = TRUE; // Allow sort
		$this->access_public_profile->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_public_profile'] = &$this->access_public_profile;

		// access_change_user
		$this->access_change_user = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_change_user', 'access_change_user', '`access_change_user`', '`access_change_user`', 16, 4, -1, FALSE, '`access_change_user`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_change_user->Nullable = FALSE; // NOT NULL field
		$this->access_change_user->Required = TRUE; // Required field
		$this->access_change_user->Sortable = TRUE; // Allow sort
		$this->access_change_user->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_change_user'] = &$this->access_change_user;

		// access_receive_notifications
		$this->access_receive_notifications = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_receive_notifications', 'access_receive_notifications', '`access_receive_notifications`', '`access_receive_notifications`', 16, 4, -1, FALSE, '`access_receive_notifications`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_receive_notifications->Nullable = FALSE; // NOT NULL field
		$this->access_receive_notifications->Required = TRUE; // Required field
		$this->access_receive_notifications->Sortable = TRUE; // Allow sort
		$this->access_receive_notifications->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_receive_notifications'] = &$this->access_receive_notifications;

		// first_name
		$this->first_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_first_name', 'first_name', '`first_name`', '`first_name`', 200, 255, -1, FALSE, '`first_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->first_name->Sortable = TRUE; // Allow sort
		$this->fields['first_name'] = &$this->first_name;

		// last_name
		$this->last_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_last_name', 'last_name', '`last_name`', '`last_name`', 200, 255, -1, FALSE, '`last_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->last_name->Sortable = TRUE; // Allow sort
		$this->fields['last_name'] = &$this->last_name;

		// about
		$this->about = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_about', 'about', '`about`', '`about`', 201, 65535, -1, FALSE, '`about`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->about->Sortable = TRUE; // Allow sort
		$this->fields['about'] = &$this->about;

		// company_name
		$this->company_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_company_name', 'company_name', '`company_name`', '`company_name`', 200, 255, -1, FALSE, '`company_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->company_name->Sortable = TRUE; // Allow sort
		$this->fields['company_name'] = &$this->company_name;

		// company_address
		$this->company_address = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_company_address', 'company_address', '`company_address`', '`company_address`', 200, 255, -1, FALSE, '`company_address`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->company_address->Sortable = TRUE; // Allow sort
		$this->fields['company_address'] = &$this->company_address;

		// website
		$this->website = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_website', 'website', '`website`', '`website`', 200, 255, -1, FALSE, '`website`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->website->Sortable = TRUE; // Allow sort
		$this->fields['website'] = &$this->website;

		// main_email
		$this->main_email = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_main_email', 'main_email', '`main_email`', '`main_email`', 200, 255, -1, FALSE, '`main_email`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->main_email->Sortable = TRUE; // Allow sort
		$this->fields['main_email'] = &$this->main_email;

		// secondary_email
		$this->secondary_email = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_secondary_email', 'secondary_email', '`secondary_email`', '`secondary_email`', 200, 255, -1, FALSE, '`secondary_email`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->secondary_email->Sortable = TRUE; // Allow sort
		$this->fields['secondary_email'] = &$this->secondary_email;

		// sex
		$this->sex = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_sex', 'sex', '`sex`', '`sex`', 16, 4, -1, FALSE, '`sex`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->sex->Sortable = TRUE; // Allow sort
		$this->sex->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['sex'] = &$this->sex;

		// tel
		$this->tel = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_tel', 'tel', '`tel`', '`tel`', 200, 20, -1, FALSE, '`tel`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->tel->Sortable = TRUE; // Allow sort
		$this->fields['tel'] = &$this->tel;

		// fax
		$this->fax = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_fax', 'fax', '`fax`', '`fax`', 200, 20, -1, FALSE, '`fax`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->fax->Sortable = TRUE; // Allow sort
		$this->fields['fax'] = &$this->fax;

		// mobile
		$this->mobile = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_mobile', 'mobile', '`mobile`', '`mobile`', 200, 20, -1, FALSE, '`mobile`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->mobile->Sortable = TRUE; // Allow sort
		$this->fields['mobile'] = &$this->mobile;

		// languages
		$this->languages = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_languages', 'languages', '`languages`', '`languages`', 201, 65535, -1, FALSE, '`languages`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->languages->Sortable = TRUE; // Allow sort
		$this->fields['languages'] = &$this->languages;

		// location1_id
		$this->location1_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location1_id', 'location1_id', '`location1_id`', '`location1_id`', 3, 11, -1, FALSE, '`location1_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location1_id->Nullable = FALSE; // NOT NULL field
		$this->location1_id->Required = TRUE; // Required field
		$this->location1_id->Sortable = TRUE; // Allow sort
		$this->location1_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location1_id'] = &$this->location1_id;

		// location2_id
		$this->location2_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location2_id', 'location2_id', '`location2_id`', '`location2_id`', 3, 11, -1, FALSE, '`location2_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location2_id->Nullable = FALSE; // NOT NULL field
		$this->location2_id->Required = TRUE; // Required field
		$this->location2_id->Sortable = TRUE; // Allow sort
		$this->location2_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location2_id'] = &$this->location2_id;

		// location3_id
		$this->location3_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location3_id', 'location3_id', '`location3_id`', '`location3_id`', 3, 11, -1, FALSE, '`location3_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location3_id->Nullable = FALSE; // NOT NULL field
		$this->location3_id->Required = TRUE; // Required field
		$this->location3_id->Sortable = TRUE; // Allow sort
		$this->location3_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location3_id'] = &$this->location3_id;

		// location4_id
		$this->location4_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location4_id', 'location4_id', '`location4_id`', '`location4_id`', 3, 11, -1, FALSE, '`location4_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location4_id->Nullable = FALSE; // NOT NULL field
		$this->location4_id->Required = TRUE; // Required field
		$this->location4_id->Sortable = TRUE; // Allow sort
		$this->location4_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location4_id'] = &$this->location4_id;

		// location5_id
		$this->location5_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location5_id', 'location5_id', '`location5_id`', '`location5_id`', 3, 11, -1, FALSE, '`location5_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location5_id->Nullable = FALSE; // NOT NULL field
		$this->location5_id->Required = TRUE; // Required field
		$this->location5_id->Sortable = TRUE; // Allow sort
		$this->location5_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location5_id'] = &$this->location5_id;

		// location6_id
		$this->location6_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location6_id', 'location6_id', '`location6_id`', '`location6_id`', 3, 11, -1, FALSE, '`location6_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location6_id->Nullable = FALSE; // NOT NULL field
		$this->location6_id->Required = TRUE; // Required field
		$this->location6_id->Sortable = TRUE; // Allow sort
		$this->location6_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location6_id'] = &$this->location6_id;

		// location7_id
		$this->location7_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location7_id', 'location7_id', '`location7_id`', '`location7_id`', 3, 11, -1, FALSE, '`location7_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location7_id->Nullable = FALSE; // NOT NULL field
		$this->location7_id->Required = TRUE; // Required field
		$this->location7_id->Sortable = TRUE; // Allow sort
		$this->location7_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['location7_id'] = &$this->location7_id;

		// location1_name
		$this->location1_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location1_name', 'location1_name', '`location1_name`', '`location1_name`', 200, 50, -1, FALSE, '`location1_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location1_name->Sortable = TRUE; // Allow sort
		$this->fields['location1_name'] = &$this->location1_name;

		// location2_name
		$this->location2_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location2_name', 'location2_name', '`location2_name`', '`location2_name`', 200, 50, -1, FALSE, '`location2_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location2_name->Sortable = TRUE; // Allow sort
		$this->fields['location2_name'] = &$this->location2_name;

		// location3_name
		$this->location3_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location3_name', 'location3_name', '`location3_name`', '`location3_name`', 200, 50, -1, FALSE, '`location3_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location3_name->Sortable = TRUE; // Allow sort
		$this->fields['location3_name'] = &$this->location3_name;

		// location4_name
		$this->location4_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location4_name', 'location4_name', '`location4_name`', '`location4_name`', 200, 50, -1, FALSE, '`location4_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location4_name->Sortable = TRUE; // Allow sort
		$this->fields['location4_name'] = &$this->location4_name;

		// location5_name
		$this->location5_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location5_name', 'location5_name', '`location5_name`', '`location5_name`', 200, 50, -1, FALSE, '`location5_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location5_name->Sortable = TRUE; // Allow sort
		$this->fields['location5_name'] = &$this->location5_name;

		// location6_name
		$this->location6_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location6_name', 'location6_name', '`location6_name`', '`location6_name`', 200, 50, -1, FALSE, '`location6_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location6_name->Sortable = TRUE; // Allow sort
		$this->fields['location6_name'] = &$this->location6_name;

		// location7_name
		$this->location7_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location7_name', 'location7_name', '`location7_name`', '`location7_name`', 200, 50, -1, FALSE, '`location7_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location7_name->Sortable = TRUE; // Allow sort
		$this->fields['location7_name'] = &$this->location7_name;

		// show_address
		$this->show_address = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_show_address', 'show_address', '`show_address`', '`show_address`', 16, 4, -1, FALSE, '`show_address`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->show_address->Nullable = FALSE; // NOT NULL field
		$this->show_address->Required = TRUE; // Required field
		$this->show_address->Sortable = TRUE; // Allow sort
		$this->show_address->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['show_address'] = &$this->show_address;

		// zip_id
		$this->zip_id = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_zip_id', 'zip_id', '`zip_id`', '`zip_id`', 3, 11, -1, FALSE, '`zip_id`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->zip_id->Nullable = FALSE; // NOT NULL field
		$this->zip_id->Required = TRUE; // Required field
		$this->zip_id->Sortable = TRUE; // Allow sort
		$this->zip_id->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['zip_id'] = &$this->zip_id;

		// zip_name
		$this->zip_name = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_zip_name', 'zip_name', '`zip_name`', '`zip_name`', 200, 20, -1, FALSE, '`zip_name`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->zip_name->Sortable = TRUE; // Allow sort
		$this->fields['zip_name'] = &$this->zip_name;

		// maccess_num_prop
		$this->maccess_num_prop = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_num_prop', 'maccess_num_prop', '`maccess_num_prop`', '`maccess_num_prop`', 3, 10, -1, FALSE, '`maccess_num_prop`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_num_prop->Sortable = TRUE; // Allow sort
		$this->maccess_num_prop->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_num_prop'] = &$this->maccess_num_prop;

		// maccess_num_feat
		$this->maccess_num_feat = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_num_feat', 'maccess_num_feat', '`maccess_num_feat`', '`maccess_num_feat`', 3, 10, -1, FALSE, '`maccess_num_feat`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_num_feat->Sortable = TRUE; // Allow sort
		$this->maccess_num_feat->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_num_feat'] = &$this->maccess_num_feat;

		// maccess_num_hot
		$this->maccess_num_hot = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_num_hot', 'maccess_num_hot', '`maccess_num_hot`', '`maccess_num_hot`', 3, 10, -1, FALSE, '`maccess_num_hot`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_num_hot->Sortable = TRUE; // Allow sort
		$this->maccess_num_hot->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_num_hot'] = &$this->maccess_num_hot;

		// maccess_num_pic
		$this->maccess_num_pic = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_num_pic', 'maccess_num_pic', '`maccess_num_pic`', '`maccess_num_pic`', 3, 10, -1, FALSE, '`maccess_num_pic`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_num_pic->Sortable = TRUE; // Allow sort
		$this->maccess_num_pic->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_num_pic'] = &$this->maccess_num_pic;

		// maccess_period
		$this->maccess_period = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_period', 'maccess_period', '`maccess_period`', '`maccess_period`', 3, 10, -1, FALSE, '`maccess_period`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_period->Sortable = TRUE; // Allow sort
		$this->maccess_period->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_period'] = &$this->maccess_period;

		// maccess_price
		$this->maccess_price = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_price', 'maccess_price', '`maccess_price`', '`maccess_price`', 5, 22, -1, FALSE, '`maccess_price`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_price->Sortable = TRUE; // Allow sort
		$this->maccess_price->DefaultErrorMessage = $Language->phrase("IncorrectFloat");
		$this->fields['maccess_price'] = &$this->maccess_price;

		// maccess_price_unit
		$this->maccess_price_unit = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_price_unit', 'maccess_price_unit', '`maccess_price_unit`', '`maccess_price_unit`', 3, 10, -1, FALSE, '`maccess_price_unit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_price_unit->Sortable = TRUE; // Allow sort
		$this->maccess_price_unit->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_price_unit'] = &$this->maccess_price_unit;

		// maccess_lrestrict
		$this->maccess_lrestrict = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_lrestrict', 'maccess_lrestrict', '`maccess_lrestrict`', '`maccess_lrestrict`', 3, 4, -1, FALSE, '`maccess_lrestrict`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_lrestrict->Sortable = TRUE; // Allow sort
		$this->maccess_lrestrict->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_lrestrict'] = &$this->maccess_lrestrict;

		// maccess_listings
		$this->maccess_listings = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_listings', 'maccess_listings', '`maccess_listings`', '`maccess_listings`', 200, 255, -1, FALSE, '`maccess_listings`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_listings->Sortable = TRUE; // Allow sort
		$this->fields['maccess_listings'] = &$this->maccess_listings;

		// maccess_ptrestrict
		$this->maccess_ptrestrict = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_ptrestrict', 'maccess_ptrestrict', '`maccess_ptrestrict`', '`maccess_ptrestrict`', 3, 4, -1, FALSE, '`maccess_ptrestrict`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_ptrestrict->Sortable = TRUE; // Allow sort
		$this->maccess_ptrestrict->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_ptrestrict'] = &$this->maccess_ptrestrict;

		// maccess_property_types
		$this->maccess_property_types = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_property_types', 'maccess_property_types', '`maccess_property_types`', '`maccess_property_types`', 200, 255, -1, FALSE, '`maccess_property_types`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_property_types->Sortable = TRUE; // Allow sort
		$this->fields['maccess_property_types'] = &$this->maccess_property_types;

		// maccess_renewable
		$this->maccess_renewable = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_renewable', 'maccess_renewable', '`maccess_renewable`', '`maccess_renewable`', 3, 4, -1, FALSE, '`maccess_renewable`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_renewable->Sortable = TRUE; // Allow sort
		$this->maccess_renewable->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_renewable'] = &$this->maccess_renewable;

		// maccess_renewal_price
		$this->maccess_renewal_price = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_renewal_price', 'maccess_renewal_price', '`maccess_renewal_price`', '`maccess_renewal_price`', 5, 22, -1, FALSE, '`maccess_renewal_price`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_renewal_price->Sortable = TRUE; // Allow sort
		$this->maccess_renewal_price->DefaultErrorMessage = $Language->phrase("IncorrectFloat");
		$this->fields['maccess_renewal_price'] = &$this->maccess_renewal_price;

		// maccess_renewal_price_unit
		$this->maccess_renewal_price_unit = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_renewal_price_unit', 'maccess_renewal_price_unit', '`maccess_renewal_price_unit`', '`maccess_renewal_price_unit`', 3, 11, -1, FALSE, '`maccess_renewal_price_unit`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_renewal_price_unit->Sortable = TRUE; // Allow sort
		$this->maccess_renewal_price_unit->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_renewal_price_unit'] = &$this->maccess_renewal_price_unit;

		// maccess_upgradable
		$this->maccess_upgradable = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_upgradable', 'maccess_upgradable', '`maccess_upgradable`', '`maccess_upgradable`', 3, 4, -1, FALSE, '`maccess_upgradable`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_upgradable->Sortable = TRUE; // Allow sort
		$this->maccess_upgradable->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_upgradable'] = &$this->maccess_upgradable;

		// maccess_upgradable_to
		$this->maccess_upgradable_to = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_upgradable_to', 'maccess_upgradable_to', '`maccess_upgradable_to`', '`maccess_upgradable_to`', 201, 65535, -1, FALSE, '`maccess_upgradable_to`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->maccess_upgradable_to->Sortable = TRUE; // Allow sort
		$this->fields['maccess_upgradable_to'] = &$this->maccess_upgradable_to;

		// maccess_short_description
		$this->maccess_short_description = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_short_description', 'maccess_short_description', '`maccess_short_description`', '`maccess_short_description`', 201, 65535, -1, FALSE, '`maccess_short_description`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->maccess_short_description->Sortable = TRUE; // Allow sort
		$this->fields['maccess_short_description'] = &$this->maccess_short_description;

		// maccess_long_description
		$this->maccess_long_description = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_long_description', 'maccess_long_description', '`maccess_long_description`', '`maccess_long_description`', 201, 65535, -1, FALSE, '`maccess_long_description`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->maccess_long_description->Sortable = TRUE; // Allow sort
		$this->fields['maccess_long_description'] = &$this->maccess_long_description;

		// maccess_wpl_color
		$this->maccess_wpl_color = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_wpl_color', 'maccess_wpl_color', '`maccess_wpl_color`', '`maccess_wpl_color`', 200, 10, -1, FALSE, '`maccess_wpl_color`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_wpl_color->Sortable = TRUE; // Allow sort
		$this->fields['maccess_wpl_color'] = &$this->maccess_wpl_color;

		// expired
		$this->expired = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_expired', 'expired', '`expired`', '`expired`', 16, 4, -1, FALSE, '`expired`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->expired->Nullable = FALSE; // NOT NULL field
		$this->expired->Required = TRUE; // Required field
		$this->expired->Sortable = TRUE; // Allow sort
		$this->expired->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['expired'] = &$this->expired;

		// expiry_date
		$this->expiry_date = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_expiry_date', 'expiry_date', '`expiry_date`', CastDateFieldForLike("`expiry_date`", 0, "DB"), 135, 19, 0, FALSE, '`expiry_date`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->expiry_date->Sortable = TRUE; // Allow sort
		$this->expiry_date->DefaultErrorMessage = str_replace("%s", $GLOBALS["DATE_FORMAT"], $Language->phrase("IncorrectDate"));
		$this->fields['expiry_date'] = &$this->expiry_date;

		// textsearch
		$this->textsearch = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_textsearch', 'textsearch', '`textsearch`', '`textsearch`', 201, 65535, -1, FALSE, '`textsearch`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->textsearch->Sortable = TRUE; // Allow sort
		$this->fields['textsearch'] = &$this->textsearch;

		// location_text
		$this->location_text = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_location_text', 'location_text', '`location_text`', '`location_text`', 200, 255, -1, FALSE, '`location_text`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->location_text->Sortable = TRUE; // Allow sort
		$this->fields['location_text'] = &$this->location_text;

		// rendered
		$this->rendered = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_rendered', 'rendered', '`rendered`', '`rendered`', 201, 65535, -1, FALSE, '`rendered`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->rendered->Sortable = TRUE; // Allow sort
		$this->fields['rendered'] = &$this->rendered;

		// last_modified_time_stamp
		$this->last_modified_time_stamp = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_last_modified_time_stamp', 'last_modified_time_stamp', '`last_modified_time_stamp`', CastDateFieldForLike("`last_modified_time_stamp`", 0, "DB"), 135, 19, 0, FALSE, '`last_modified_time_stamp`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->last_modified_time_stamp->Sortable = TRUE; // Allow sort
		$this->last_modified_time_stamp->DefaultErrorMessage = str_replace("%s", $GLOBALS["DATE_FORMAT"], $Language->phrase("IncorrectDate"));
		$this->fields['last_modified_time_stamp'] = &$this->last_modified_time_stamp;

		// profile_picture
		$this->profile_picture = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_profile_picture', 'profile_picture', '`profile_picture`', '`profile_picture`', 200, 255, -1, FALSE, '`profile_picture`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->profile_picture->Sortable = TRUE; // Allow sort
		$this->fields['profile_picture'] = &$this->profile_picture;

		// company_logo
		$this->company_logo = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_company_logo', 'company_logo', '`company_logo`', '`company_logo`', 200, 255, -1, FALSE, '`company_logo`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->company_logo->Sortable = TRUE; // Allow sort
		$this->fields['company_logo'] = &$this->company_logo;

		// maccess_lrestrict_pshow
		$this->maccess_lrestrict_pshow = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_lrestrict_pshow', 'maccess_lrestrict_pshow', '`maccess_lrestrict_pshow`', '`maccess_lrestrict_pshow`', 3, 4, -1, FALSE, '`maccess_lrestrict_pshow`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_lrestrict_pshow->Sortable = TRUE; // Allow sort
		$this->maccess_lrestrict_pshow->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_lrestrict_pshow'] = &$this->maccess_lrestrict_pshow;

		// maccess_ptrestrict_pshow
		$this->maccess_ptrestrict_pshow = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_ptrestrict_pshow', 'maccess_ptrestrict_pshow', '`maccess_ptrestrict_pshow`', '`maccess_ptrestrict_pshow`', 3, 4, -1, FALSE, '`maccess_ptrestrict_pshow`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_ptrestrict_pshow->Sortable = TRUE; // Allow sort
		$this->maccess_ptrestrict_pshow->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_ptrestrict_pshow'] = &$this->maccess_ptrestrict_pshow;

		// maccess_listings_pshow
		$this->maccess_listings_pshow = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_listings_pshow', 'maccess_listings_pshow', '`maccess_listings_pshow`', '`maccess_listings_pshow`', 200, 255, -1, FALSE, '`maccess_listings_pshow`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_listings_pshow->Sortable = TRUE; // Allow sort
		$this->fields['maccess_listings_pshow'] = &$this->maccess_listings_pshow;

		// maccess_property_types_pshow
		$this->maccess_property_types_pshow = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_property_types_pshow', 'maccess_property_types_pshow', '`maccess_property_types_pshow`', '`maccess_property_types_pshow`', 200, 255, -1, FALSE, '`maccess_property_types_pshow`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_property_types_pshow->Sortable = TRUE; // Allow sort
		$this->fields['maccess_property_types_pshow'] = &$this->maccess_property_types_pshow;

		// maccess_lrestrict_plisting
		$this->maccess_lrestrict_plisting = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_lrestrict_plisting', 'maccess_lrestrict_plisting', '`maccess_lrestrict_plisting`', '`maccess_lrestrict_plisting`', 3, 4, -1, FALSE, '`maccess_lrestrict_plisting`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_lrestrict_plisting->Sortable = TRUE; // Allow sort
		$this->maccess_lrestrict_plisting->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_lrestrict_plisting'] = &$this->maccess_lrestrict_plisting;

		// maccess_ptrestrict_plisting
		$this->maccess_ptrestrict_plisting = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_ptrestrict_plisting', 'maccess_ptrestrict_plisting', '`maccess_ptrestrict_plisting`', '`maccess_ptrestrict_plisting`', 3, 4, -1, FALSE, '`maccess_ptrestrict_plisting`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_ptrestrict_plisting->Sortable = TRUE; // Allow sort
		$this->maccess_ptrestrict_plisting->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['maccess_ptrestrict_plisting'] = &$this->maccess_ptrestrict_plisting;

		// maccess_listings_plisting
		$this->maccess_listings_plisting = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_listings_plisting', 'maccess_listings_plisting', '`maccess_listings_plisting`', '`maccess_listings_plisting`', 200, 255, -1, FALSE, '`maccess_listings_plisting`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_listings_plisting->Sortable = TRUE; // Allow sort
		$this->fields['maccess_listings_plisting'] = &$this->maccess_listings_plisting;

		// maccess_property_types_plisting
		$this->maccess_property_types_plisting = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_property_types_plisting', 'maccess_property_types_plisting', '`maccess_property_types_plisting`', '`maccess_property_types_plisting`', 200, 255, -1, FALSE, '`maccess_property_types_plisting`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->maccess_property_types_plisting->Sortable = TRUE; // Allow sort
		$this->fields['maccess_property_types_plisting'] = &$this->maccess_property_types_plisting;

		// access_clone
		$this->access_clone = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_clone', 'access_clone', '`access_clone`', '`access_clone`', 16, 4, -1, FALSE, '`access_clone`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_clone->Nullable = FALSE; // NOT NULL field
		$this->access_clone->Required = TRUE; // Required field
		$this->access_clone->Sortable = TRUE; // Allow sort
		$this->access_clone->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_clone'] = &$this->access_clone;

		// access_propertystats
		$this->access_propertystats = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_propertystats', 'access_propertystats', '`access_propertystats`', '`access_propertystats`', 16, 4, -1, FALSE, '`access_propertystats`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_propertystats->Nullable = FALSE; // NOT NULL field
		$this->access_propertystats->Required = TRUE; // Required field
		$this->access_propertystats->Sortable = TRUE; // Allow sort
		$this->access_propertystats->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_propertystats'] = &$this->access_propertystats;

		// maccess_crm
		$this->maccess_crm = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_maccess_crm', 'maccess_crm', '`maccess_crm`', '`maccess_crm`', 201, 65535, -1, FALSE, '`maccess_crm`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->maccess_crm->Sortable = TRUE; // Allow sort
		$this->fields['maccess_crm'] = &$this->maccess_crm;

		// online_status
		$this->online_status = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_online_status', 'online_status', '`online_status`', '`online_status`', 200, 50, -1, FALSE, '`online_status`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->online_status->Nullable = FALSE; // NOT NULL field
		$this->online_status->Required = TRUE; // Required field
		$this->online_status->Sortable = TRUE; // Allow sort
		$this->fields['online_status'] = &$this->online_status;

		// access_CRM
		$this->access_CRM = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_access_CRM', 'access_CRM', '`access_CRM`', '`access_CRM`', 16, 4, -1, FALSE, '`access_CRM`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXT');
		$this->access_CRM->Nullable = FALSE; // NOT NULL field
		$this->access_CRM->Required = TRUE; // Required field
		$this->access_CRM->Sortable = TRUE; // Allow sort
		$this->access_CRM->DefaultErrorMessage = $Language->phrase("IncorrectInteger");
		$this->fields['access_CRM'] = &$this->access_CRM;

		// crm_selected_fields
		$this->crm_selected_fields = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_crm_selected_fields', 'crm_selected_fields', '`crm_selected_fields`', '`crm_selected_fields`', 201, 65535, -1, FALSE, '`crm_selected_fields`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->crm_selected_fields->Sortable = TRUE; // Allow sort
		$this->fields['crm_selected_fields'] = &$this->crm_selected_fields;

		// crm_cookies
		$this->crm_cookies = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_crm_cookies', 'crm_cookies', '`crm_cookies`', '`crm_cookies`', 201, 65535, -1, FALSE, '`crm_cookies`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->crm_cookies->Sortable = TRUE; // Allow sort
		$this->fields['crm_cookies'] = &$this->crm_cookies;

		// rendered_en_us
		$this->rendered_en_us = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_rendered_en_us', 'rendered_en_us', '`rendered_en_us`', '`rendered_en_us`', 201, 65535, -1, FALSE, '`rendered_en_us`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->rendered_en_us->Sortable = TRUE; // Allow sort
		$this->fields['rendered_en_us'] = &$this->rendered_en_us;

		// textsearch_en_us
		$this->textsearch_en_us = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_textsearch_en_us', 'textsearch_en_us', '`textsearch_en_us`', '`textsearch_en_us`', 201, 65535, -1, FALSE, '`textsearch_en_us`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->textsearch_en_us->Sortable = TRUE; // Allow sort
		$this->fields['textsearch_en_us'] = &$this->textsearch_en_us;

		// rendered_fr_fr
		$this->rendered_fr_fr = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_rendered_fr_fr', 'rendered_fr_fr', '`rendered_fr_fr`', '`rendered_fr_fr`', 201, 65535, -1, FALSE, '`rendered_fr_fr`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->rendered_fr_fr->Sortable = TRUE; // Allow sort
		$this->fields['rendered_fr_fr'] = &$this->rendered_fr_fr;

		// textsearch_fr_fr
		$this->textsearch_fr_fr = new DbField('wp_wpl_users', 'wp_wpl_users', 'x_textsearch_fr_fr', 'textsearch_fr_fr', '`textsearch_fr_fr`', '`textsearch_fr_fr`', 201, 65535, -1, FALSE, '`textsearch_fr_fr`', FALSE, FALSE, FALSE, 'FORMATTED TEXT', 'TEXTAREA');
		$this->textsearch_fr_fr->Sortable = TRUE; // Allow sort
		$this->fields['textsearch_fr_fr'] = &$this->textsearch_fr_fr;
	}

	// Field Visibility
	public function getFieldVisibility($fldParm)
	{
		global $Security;
		return $this->$fldParm->Visible; // Returns original value
	}

	// Set left column class (must be predefined col-*-* classes of Bootstrap grid system)
	function setLeftColumnClass($class)
	{
		if (preg_match('/^col\-(\w+)\-(\d+)$/', $class, $match)) {
			$this->LeftColumnClass = $class . " col-form-label ew-label";
			$this->RightColumnClass = "col-" . $match[1] . "-" . strval(12 - (int)$match[2]);
			$this->OffsetColumnClass = $this->RightColumnClass . " " . str_replace("col-", "offset-", $class);
			$this->TableLeftColumnClass = preg_replace('/^col-\w+-(\d+)$/', "w-col-$1", $class); // Change to w-col-*
		}
	}

	// Multiple column sort
	public function updateSort(&$fld, $ctrl)
	{
		if ($this->CurrentOrder == $fld->Name) {
			$sortField = $fld->Expression;
			$lastSort = $fld->getSort();
			if ($this->CurrentOrderType == "ASC" || $this->CurrentOrderType == "DESC") {
				$thisSort = $this->CurrentOrderType;
			} else {
				$thisSort = ($lastSort == "ASC") ? "DESC" : "ASC";
			}
			$fld->setSort($thisSort);
			if ($ctrl) {
				$orderBy = $this->getSessionOrderBy();
				if (ContainsString($orderBy, $sortField . " " . $lastSort)) {
					$orderBy = str_replace($sortField . " " . $lastSort, $sortField . " " . $thisSort, $orderBy);
				} else {
					if ($orderBy != "")
						$orderBy .= ", ";
					$orderBy .= $sortField . " " . $thisSort;
				}
				$this->setSessionOrderBy($orderBy); // Save to Session
			} else {
				$this->setSessionOrderBy($sortField . " " . $thisSort); // Save to Session
			}
		} else {
			if (!$ctrl)
				$fld->setSort("");
		}
	}

	// Table level SQL
	public function getSqlFrom() // From
	{
		return ($this->SqlFrom != "") ? $this->SqlFrom : "`wp_wpl_users`";
	}
	public function sqlFrom() // For backward compatibility
	{
		return $this->getSqlFrom();
	}
	public function setSqlFrom($v)
	{
		$this->SqlFrom = $v;
	}
	public function getSqlSelect() // Select
	{
		return ($this->SqlSelect != "") ? $this->SqlSelect : "SELECT * FROM " . $this->getSqlFrom();
	}
	public function sqlSelect() // For backward compatibility
	{
		return $this->getSqlSelect();
	}
	public function setSqlSelect($v)
	{
		$this->SqlSelect = $v;
	}
	public function getSqlWhere() // Where
	{
		$where = ($this->SqlWhere != "") ? $this->SqlWhere : "";
		$this->TableFilter = "";
		AddFilter($where, $this->TableFilter);
		return $where;
	}
	public function sqlWhere() // For backward compatibility
	{
		return $this->getSqlWhere();
	}
	public function setSqlWhere($v)
	{
		$this->SqlWhere = $v;
	}
	public function getSqlGroupBy() // Group By
	{
		return ($this->SqlGroupBy != "") ? $this->SqlGroupBy : "";
	}
	public function sqlGroupBy() // For backward compatibility
	{
		return $this->getSqlGroupBy();
	}
	public function setSqlGroupBy($v)
	{
		$this->SqlGroupBy = $v;
	}
	public function getSqlHaving() // Having
	{
		return ($this->SqlHaving != "") ? $this->SqlHaving : "";
	}
	public function sqlHaving() // For backward compatibility
	{
		return $this->getSqlHaving();
	}
	public function setSqlHaving($v)
	{
		$this->SqlHaving = $v;
	}
	public function getSqlOrderBy() // Order By
	{
		return ($this->SqlOrderBy != "") ? $this->SqlOrderBy : "";
	}
	public function sqlOrderBy() // For backward compatibility
	{
		return $this->getSqlOrderBy();
	}
	public function setSqlOrderBy($v)
	{
		$this->SqlOrderBy = $v;
	}

	// Apply User ID filters
	public function applyUserIDFilters($filter, $id = "")
	{
		return $filter;
	}

	// Check if User ID security allows view all
	public function userIDAllow($id = "")
	{
		$allow = $this->UserIDAllowSecurity;
		switch ($id) {
			case "add":
			case "copy":
			case "gridadd":
			case "register":
			case "addopt":
				return (($allow & 1) == 1);
			case "edit":
			case "gridedit":
			case "update":
			case "changepwd":
			case "forgotpwd":
				return (($allow & 4) == 4);
			case "delete":
				return (($allow & 2) == 2);
			case "view":
				return (($allow & 32) == 32);
			case "search":
				return (($allow & 64) == 64);
			case "lookup":
				return (($allow & 256) == 256);
			default:
				return (($allow & 8) == 8);
		}
	}

	// Get recordset
	public function getRecordset($sql, $rowcnt = -1, $offset = -1)
	{
		$conn = $this->getConnection();
		$conn->raiseErrorFn = Config("ERROR_FUNC");
		$rs = $conn->selectLimit($sql, $rowcnt, $offset);
		$conn->raiseErrorFn = "";
		return $rs;
	}

	// Get record count
	public function getRecordCount($sql, $c = NULL)
	{
		$cnt = -1;
		$rs = NULL;
		$sql = preg_replace('/\/\*BeginOrderBy\*\/[\s\S]+\/\*EndOrderBy\*\//', "", $sql); // Remove ORDER BY clause (MSSQL)
		$pattern = '/^SELECT\s([\s\S]+)\sFROM\s/i';

		// Skip Custom View / SubQuery / SELECT DISTINCT / ORDER BY
		if (($this->TableType == 'TABLE' || $this->TableType == 'VIEW' || $this->TableType == 'LINKTABLE') &&
			preg_match($pattern, $sql) && !preg_match('/\(\s*(SELECT[^)]+)\)/i', $sql) &&
			!preg_match('/^\s*select\s+distinct\s+/i', $sql) && !preg_match('/\s+order\s+by\s+/i', $sql)) {
			$sqlwrk = "SELECT COUNT(*) FROM " . preg_replace($pattern, "", $sql);
		} else {
			$sqlwrk = "SELECT COUNT(*) FROM (" . $sql . ") COUNT_TABLE";
		}
		$conn = $c ?: $this->getConnection();
		if ($rs = $conn->execute($sqlwrk)) {
			if (!$rs->EOF && $rs->FieldCount() > 0) {
				$cnt = $rs->fields[0];
				$rs->close();
			}
			return (int)$cnt;
		}

		// Unable to get count, get record count directly
		if ($rs = $conn->execute($sql)) {
			$cnt = $rs->RecordCount();
			$rs->close();
			return (int)$cnt;
		}
		return $cnt;
	}

	// Get SQL
	public function getSql($where, $orderBy = "")
	{
		return BuildSelectSql($this->getSqlSelect(), $this->getSqlWhere(),
			$this->getSqlGroupBy(), $this->getSqlHaving(), $this->getSqlOrderBy(),
			$where, $orderBy);
	}

	// Table SQL
	public function getCurrentSql()
	{
		$filter = $this->CurrentFilter;
		$filter = $this->applyUserIDFilters($filter);
		$sort = $this->getSessionOrderBy();
		return $this->getSql($filter, $sort);
	}

	// Table SQL with List page filter
	public function getListSql()
	{
		$filter = $this->UseSessionForListSql ? $this->getSessionWhere() : "";
		AddFilter($filter, $this->CurrentFilter);
		$filter = $this->applyUserIDFilters($filter);
		$this->Recordset_Selecting($filter);
		$select = $this->getSqlSelect();
		$sort = $this->UseSessionForListSql ? $this->getSessionOrderBy() : "";
		return BuildSelectSql($select, $this->getSqlWhere(), $this->getSqlGroupBy(),
			$this->getSqlHaving(), $this->getSqlOrderBy(), $filter, $sort);
	}

	// Get ORDER BY clause
	public function getOrderBy()
	{
		$sort = $this->getSessionOrderBy();
		return BuildSelectSql("", "", "", "", $this->getSqlOrderBy(), "", $sort);
	}

	// Get record count based on filter (for detail record count in master table pages)
	public function loadRecordCount($filter)
	{
		$origFilter = $this->CurrentFilter;
		$this->CurrentFilter = $filter;
		$this->Recordset_Selecting($this->CurrentFilter);
		$select = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlSelect() : "SELECT * FROM " . $this->getSqlFrom();
		$groupBy = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlGroupBy() : "";
		$having = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlHaving() : "";
		$sql = BuildSelectSql($select, $this->getSqlWhere(), $groupBy, $having, "", $this->CurrentFilter, "");
		$cnt = $this->getRecordCount($sql);
		$this->CurrentFilter = $origFilter;
		return $cnt;
	}

	// Get record count (for current List page)
	public function listRecordCount()
	{
		$filter = $this->getSessionWhere();
		AddFilter($filter, $this->CurrentFilter);
		$filter = $this->applyUserIDFilters($filter);
		$this->Recordset_Selecting($filter);
		$select = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlSelect() : "SELECT * FROM " . $this->getSqlFrom();
		$groupBy = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlGroupBy() : "";
		$having = $this->TableType == 'CUSTOMVIEW' ? $this->getSqlHaving() : "";
		$sql = BuildSelectSql($select, $this->getSqlWhere(), $groupBy, $having, "", $filter, "");
		$cnt = $this->getRecordCount($sql);
		return $cnt;
	}

	// INSERT statement
	protected function insertSql(&$rs)
	{
		$names = "";
		$values = "";
		foreach ($rs as $name => $value) {
			if (!isset($this->fields[$name]) || $this->fields[$name]->IsCustom)
				continue;
			$names .= $this->fields[$name]->Expression . ",";
			$values .= QuotedValue($value, $this->fields[$name]->DataType, $this->Dbid) . ",";
		}
		$names = preg_replace('/,+$/', "", $names);
		$values = preg_replace('/,+$/', "", $values);
		return "INSERT INTO " . $this->UpdateTable . " (" . $names . ") VALUES (" . $values . ")";
	}

	// Insert
	public function insert(&$rs)
	{
		$conn = $this->getConnection();
		$success = $conn->execute($this->insertSql($rs));
		if ($success) {

			// Get insert id if necessary
			$this->id->setDbValue($conn->insert_ID());
			$rs['id'] = $this->id->DbValue;
		}
		return $success;
	}

	// UPDATE statement
	protected function updateSql(&$rs, $where = "", $curfilter = TRUE)
	{
		$sql = "UPDATE " . $this->UpdateTable . " SET ";
		foreach ($rs as $name => $value) {
			if (!isset($this->fields[$name]) || $this->fields[$name]->IsCustom || $this->fields[$name]->IsAutoIncrement)
				continue;
			$sql .= $this->fields[$name]->Expression . "=";
			$sql .= QuotedValue($value, $this->fields[$name]->DataType, $this->Dbid) . ",";
		}
		$sql = preg_replace('/,+$/', "", $sql);
		$filter = ($curfilter) ? $this->CurrentFilter : "";
		if (is_array($where))
			$where = $this->arrayToFilter($where);
		AddFilter($filter, $where);
		if ($filter != "")
			$sql .= " WHERE " . $filter;
		return $sql;
	}

	// Update
	public function update(&$rs, $where = "", $rsold = NULL, $curfilter = TRUE)
	{
		$conn = $this->getConnection();
		$success = $conn->execute($this->updateSql($rs, $where, $curfilter));
		return $success;
	}

	// DELETE statement
	protected function deleteSql(&$rs, $where = "", $curfilter = TRUE)
	{
		$sql = "DELETE FROM " . $this->UpdateTable . " WHERE ";
		if (is_array($where))
			$where = $this->arrayToFilter($where);
		if ($rs) {
			if (array_key_exists('id', $rs))
				AddFilter($where, QuotedName('id', $this->Dbid) . '=' . QuotedValue($rs['id'], $this->id->DataType, $this->Dbid));
		}
		$filter = ($curfilter) ? $this->CurrentFilter : "";
		AddFilter($filter, $where);
		if ($filter != "")
			$sql .= $filter;
		else
			$sql .= "0=1"; // Avoid delete
		return $sql;
	}

	// Delete
	public function delete(&$rs, $where = "", $curfilter = FALSE)
	{
		$success = TRUE;
		$conn = $this->getConnection();
		if ($success)
			$success = $conn->execute($this->deleteSql($rs, $where, $curfilter));
		return $success;
	}

	// Load DbValue from recordset or array
	protected function loadDbValues(&$rs)
	{
		if (!$rs || !is_array($rs) && $rs->EOF)
			return;
		$row = is_array($rs) ? $rs : $rs->fields;
		$this->id->DbValue = $row['id'];
		$this->membership_name->DbValue = $row['membership_name'];
		$this->membership_id->DbValue = $row['membership_id'];
		$this->membership_type->DbValue = $row['membership_type'];
		$this->_index->DbValue = $row['index'];
		$this->access_propertywizard->DbValue = $row['access_propertywizard'];
		$this->access_propertyshow->DbValue = $row['access_propertyshow'];
		$this->access_propertylisting->DbValue = $row['access_propertylisting'];
		$this->access_profilewizard->DbValue = $row['access_profilewizard'];
		$this->access_confirm->DbValue = $row['access_confirm'];
		$this->access_propertymanager->DbValue = $row['access_propertymanager'];
		$this->access_delete->DbValue = $row['access_delete'];
		$this->access_public_profile->DbValue = $row['access_public_profile'];
		$this->access_change_user->DbValue = $row['access_change_user'];
		$this->access_receive_notifications->DbValue = $row['access_receive_notifications'];
		$this->first_name->DbValue = $row['first_name'];
		$this->last_name->DbValue = $row['last_name'];
		$this->about->DbValue = $row['about'];
		$this->company_name->DbValue = $row['company_name'];
		$this->company_address->DbValue = $row['company_address'];
		$this->website->DbValue = $row['website'];
		$this->main_email->DbValue = $row['main_email'];
		$this->secondary_email->DbValue = $row['secondary_email'];
		$this->sex->DbValue = $row['sex'];
		$this->tel->DbValue = $row['tel'];
		$this->fax->DbValue = $row['fax'];
		$this->mobile->DbValue = $row['mobile'];
		$this->languages->DbValue = $row['languages'];
		$this->location1_id->DbValue = $row['location1_id'];
		$this->location2_id->DbValue = $row['location2_id'];
		$this->location3_id->DbValue = $row['location3_id'];
		$this->location4_id->DbValue = $row['location4_id'];
		$this->location5_id->DbValue = $row['location5_id'];
		$this->location6_id->DbValue = $row['location6_id'];
		$this->location7_id->DbValue = $row['location7_id'];
		$this->location1_name->DbValue = $row['location1_name'];
		$this->location2_name->DbValue = $row['location2_name'];
		$this->location3_name->DbValue = $row['location3_name'];
		$this->location4_name->DbValue = $row['location4_name'];
		$this->location5_name->DbValue = $row['location5_name'];
		$this->location6_name->DbValue = $row['location6_name'];
		$this->location7_name->DbValue = $row['location7_name'];
		$this->show_address->DbValue = $row['show_address'];
		$this->zip_id->DbValue = $row['zip_id'];
		$this->zip_name->DbValue = $row['zip_name'];
		$this->maccess_num_prop->DbValue = $row['maccess_num_prop'];
		$this->maccess_num_feat->DbValue = $row['maccess_num_feat'];
		$this->maccess_num_hot->DbValue = $row['maccess_num_hot'];
		$this->maccess_num_pic->DbValue = $row['maccess_num_pic'];
		$this->maccess_period->DbValue = $row['maccess_period'];
		$this->maccess_price->DbValue = $row['maccess_price'];
		$this->maccess_price_unit->DbValue = $row['maccess_price_unit'];
		$this->maccess_lrestrict->DbValue = $row['maccess_lrestrict'];
		$this->maccess_listings->DbValue = $row['maccess_listings'];
		$this->maccess_ptrestrict->DbValue = $row['maccess_ptrestrict'];
		$this->maccess_property_types->DbValue = $row['maccess_property_types'];
		$this->maccess_renewable->DbValue = $row['maccess_renewable'];
		$this->maccess_renewal_price->DbValue = $row['maccess_renewal_price'];
		$this->maccess_renewal_price_unit->DbValue = $row['maccess_renewal_price_unit'];
		$this->maccess_upgradable->DbValue = $row['maccess_upgradable'];
		$this->maccess_upgradable_to->DbValue = $row['maccess_upgradable_to'];
		$this->maccess_short_description->DbValue = $row['maccess_short_description'];
		$this->maccess_long_description->DbValue = $row['maccess_long_description'];
		$this->maccess_wpl_color->DbValue = $row['maccess_wpl_color'];
		$this->expired->DbValue = $row['expired'];
		$this->expiry_date->DbValue = $row['expiry_date'];
		$this->textsearch->DbValue = $row['textsearch'];
		$this->location_text->DbValue = $row['location_text'];
		$this->rendered->DbValue = $row['rendered'];
		$this->last_modified_time_stamp->DbValue = $row['last_modified_time_stamp'];
		$this->profile_picture->DbValue = $row['profile_picture'];
		$this->company_logo->DbValue = $row['company_logo'];
		$this->maccess_lrestrict_pshow->DbValue = $row['maccess_lrestrict_pshow'];
		$this->maccess_ptrestrict_pshow->DbValue = $row['maccess_ptrestrict_pshow'];
		$this->maccess_listings_pshow->DbValue = $row['maccess_listings_pshow'];
		$this->maccess_property_types_pshow->DbValue = $row['maccess_property_types_pshow'];
		$this->maccess_lrestrict_plisting->DbValue = $row['maccess_lrestrict_plisting'];
		$this->maccess_ptrestrict_plisting->DbValue = $row['maccess_ptrestrict_plisting'];
		$this->maccess_listings_plisting->DbValue = $row['maccess_listings_plisting'];
		$this->maccess_property_types_plisting->DbValue = $row['maccess_property_types_plisting'];
		$this->access_clone->DbValue = $row['access_clone'];
		$this->access_propertystats->DbValue = $row['access_propertystats'];
		$this->maccess_crm->DbValue = $row['maccess_crm'];
		$this->online_status->DbValue = $row['online_status'];
		$this->access_CRM->DbValue = $row['access_CRM'];
		$this->crm_selected_fields->DbValue = $row['crm_selected_fields'];
		$this->crm_cookies->DbValue = $row['crm_cookies'];
		$this->rendered_en_us->DbValue = $row['rendered_en_us'];
		$this->textsearch_en_us->DbValue = $row['textsearch_en_us'];
		$this->rendered_fr_fr->DbValue = $row['rendered_fr_fr'];
		$this->textsearch_fr_fr->DbValue = $row['textsearch_fr_fr'];
	}

	// Delete uploaded files
	public function deleteUploadedFiles($row)
	{
		$this->loadDbValues($row);
	}

	// Record filter WHERE clause
	protected function sqlKeyFilter()
	{
		return "`id` = @id@";
	}

	// Get record filter
	public function getRecordFilter($row = NULL)
	{
		$keyFilter = $this->sqlKeyFilter();
		if (is_array($row))
			$val = array_key_exists('id', $row) ? $row['id'] : NULL;
		else
			$val = $this->id->OldValue !== NULL ? $this->id->OldValue : $this->id->CurrentValue;
		if (!is_numeric($val))
			return "0=1"; // Invalid key
		if ($val == NULL)
			return "0=1"; // Invalid key
		else
			$keyFilter = str_replace("@id@", AdjustSql($val, $this->Dbid), $keyFilter); // Replace key value
		return $keyFilter;
	}

	// Return page URL
	public function getReturnUrl()
	{
		$name = PROJECT_NAME . "_" . $this->TableVar . "_" . Config("TABLE_RETURN_URL");

		// Get referer URL automatically
		if (ServerVar("HTTP_REFERER") != "" && ReferPageName() != CurrentPageName() && ReferPageName() != "login.php") // Referer not same page or login page
			$_SESSION[$name] = ServerVar("HTTP_REFERER"); // Save to Session
		if (@$_SESSION[$name] != "") {
			return $_SESSION[$name];
		} else {
			return "wp_wpl_userslist.php";
		}
	}
	public function setReturnUrl($v)
	{
		$_SESSION[PROJECT_NAME . "_" . $this->TableVar . "_" . Config("TABLE_RETURN_URL")] = $v;
	}

	// Get modal caption
	public function getModalCaption($pageName)
	{
		global $Language;
		if ($pageName == "wp_wpl_usersview.php")
			return $Language->phrase("View");
		elseif ($pageName == "wp_wpl_usersedit.php")
			return $Language->phrase("Edit");
		elseif ($pageName == "wp_wpl_usersadd.php")
			return $Language->phrase("Add");
		else
			return "";
	}

	// List URL
	public function getListUrl()
	{
		return "wp_wpl_userslist.php";
	}

	// View URL
	public function getViewUrl($parm = "")
	{
		if ($parm != "")
			$url = $this->keyUrl("wp_wpl_usersview.php", $this->getUrlParm($parm));
		else
			$url = $this->keyUrl("wp_wpl_usersview.php", $this->getUrlParm(Config("TABLE_SHOW_DETAIL") . "="));
		return $this->addMasterUrl($url);
	}

	// Add URL
	public function getAddUrl($parm = "")
	{
		if ($parm != "")
			$url = "wp_wpl_usersadd.php?" . $this->getUrlParm($parm);
		else
			$url = "wp_wpl_usersadd.php";
		return $this->addMasterUrl($url);
	}

	// Edit URL
	public function getEditUrl($parm = "")
	{
		$url = $this->keyUrl("wp_wpl_usersedit.php", $this->getUrlParm($parm));
		return $this->addMasterUrl($url);
	}

	// Inline edit URL
	public function getInlineEditUrl()
	{
		$url = $this->keyUrl(CurrentPageName(), $this->getUrlParm("action=edit"));
		return $this->addMasterUrl($url);
	}

	// Copy URL
	public function getCopyUrl($parm = "")
	{
		$url = $this->keyUrl("wp_wpl_usersadd.php", $this->getUrlParm($parm));
		return $this->addMasterUrl($url);
	}

	// Inline copy URL
	public function getInlineCopyUrl()
	{
		$url = $this->keyUrl(CurrentPageName(), $this->getUrlParm("action=copy"));
		return $this->addMasterUrl($url);
	}

	// Delete URL
	public function getDeleteUrl()
	{
		return $this->keyUrl("wp_wpl_usersdelete.php", $this->getUrlParm());
	}

	// Add master url
	public function addMasterUrl($url)
	{
		return $url;
	}
	public function keyToJson($htmlEncode = FALSE)
	{
		$json = "";
		$json .= "id:" . JsonEncode($this->id->CurrentValue, "number");
		$json = "{" . $json . "}";
		if ($htmlEncode)
			$json = HtmlEncode($json);
		return $json;
	}

	// Add key value to URL
	public function keyUrl($url, $parm = "")
	{
		$url = $url . "?";
		if ($parm != "")
			$url .= $parm . "&";
		if ($this->id->CurrentValue != NULL) {
			$url .= "id=" . urlencode($this->id->CurrentValue);
		} else {
			return "javascript:ew.alert(ew.language.phrase('InvalidRecord'));";
		}
		return $url;
	}

	// Sort URL
	public function sortUrl(&$fld)
	{
		if ($this->CurrentAction || $this->isExport() ||
			in_array($fld->Type, [128, 204, 205])) { // Unsortable data type
				return "";
		} elseif ($fld->Sortable) {
			$urlParm = $this->getUrlParm("order=" . urlencode($fld->Name) . "&amp;ordertype=" . $fld->reverseSort());
			return $this->addMasterUrl(CurrentPageName() . "?" . $urlParm);
		} else {
			return "";
		}
	}

	// Get record keys from Post/Get/Session
	public function getRecordKeys()
	{
		$arKeys = [];
		$arKey = [];
		if (Param("key_m") !== NULL) {
			$arKeys = Param("key_m");
			$cnt = count($arKeys);
		} else {
			if (Param("id") !== NULL)
				$arKeys[] = Param("id");
			elseif (IsApi() && Key(0) !== NULL)
				$arKeys[] = Key(0);
			elseif (IsApi() && Route(2) !== NULL)
				$arKeys[] = Route(2);
			else
				$arKeys = NULL; // Do not setup

			//return $arKeys; // Do not return yet, so the values will also be checked by the following code
		}

		// Check keys
		$ar = [];
		if (is_array($arKeys)) {
			foreach ($arKeys as $key) {
				if (!is_numeric($key))
					continue;
				$ar[] = $key;
			}
		}
		return $ar;
	}

	// Get filter from record keys
	public function getFilterFromRecordKeys($setCurrent = TRUE)
	{
		$arKeys = $this->getRecordKeys();
		$keyFilter = "";
		foreach ($arKeys as $key) {
			if ($keyFilter != "") $keyFilter .= " OR ";
			if ($setCurrent)
				$this->id->CurrentValue = $key;
			else
				$this->id->OldValue = $key;
			$keyFilter .= "(" . $this->getRecordFilter() . ")";
		}
		return $keyFilter;
	}

	// Load rows based on filter
	public function &loadRs($filter)
	{

		// Set up filter (WHERE Clause)
		$sql = $this->getSql($filter);
		$conn = $this->getConnection();
		$rs = $conn->execute($sql);
		return $rs;
	}

	// Load row values from recordset
	public function loadListRowValues(&$rs)
	{
		$this->id->setDbValue($rs->fields('id'));
		$this->membership_name->setDbValue($rs->fields('membership_name'));
		$this->membership_id->setDbValue($rs->fields('membership_id'));
		$this->membership_type->setDbValue($rs->fields('membership_type'));
		$this->_index->setDbValue($rs->fields('index'));
		$this->access_propertywizard->setDbValue($rs->fields('access_propertywizard'));
		$this->access_propertyshow->setDbValue($rs->fields('access_propertyshow'));
		$this->access_propertylisting->setDbValue($rs->fields('access_propertylisting'));
		$this->access_profilewizard->setDbValue($rs->fields('access_profilewizard'));
		$this->access_confirm->setDbValue($rs->fields('access_confirm'));
		$this->access_propertymanager->setDbValue($rs->fields('access_propertymanager'));
		$this->access_delete->setDbValue($rs->fields('access_delete'));
		$this->access_public_profile->setDbValue($rs->fields('access_public_profile'));
		$this->access_change_user->setDbValue($rs->fields('access_change_user'));
		$this->access_receive_notifications->setDbValue($rs->fields('access_receive_notifications'));
		$this->first_name->setDbValue($rs->fields('first_name'));
		$this->last_name->setDbValue($rs->fields('last_name'));
		$this->about->setDbValue($rs->fields('about'));
		$this->company_name->setDbValue($rs->fields('company_name'));
		$this->company_address->setDbValue($rs->fields('company_address'));
		$this->website->setDbValue($rs->fields('website'));
		$this->main_email->setDbValue($rs->fields('main_email'));
		$this->secondary_email->setDbValue($rs->fields('secondary_email'));
		$this->sex->setDbValue($rs->fields('sex'));
		$this->tel->setDbValue($rs->fields('tel'));
		$this->fax->setDbValue($rs->fields('fax'));
		$this->mobile->setDbValue($rs->fields('mobile'));
		$this->languages->setDbValue($rs->fields('languages'));
		$this->location1_id->setDbValue($rs->fields('location1_id'));
		$this->location2_id->setDbValue($rs->fields('location2_id'));
		$this->location3_id->setDbValue($rs->fields('location3_id'));
		$this->location4_id->setDbValue($rs->fields('location4_id'));
		$this->location5_id->setDbValue($rs->fields('location5_id'));
		$this->location6_id->setDbValue($rs->fields('location6_id'));
		$this->location7_id->setDbValue($rs->fields('location7_id'));
		$this->location1_name->setDbValue($rs->fields('location1_name'));
		$this->location2_name->setDbValue($rs->fields('location2_name'));
		$this->location3_name->setDbValue($rs->fields('location3_name'));
		$this->location4_name->setDbValue($rs->fields('location4_name'));
		$this->location5_name->setDbValue($rs->fields('location5_name'));
		$this->location6_name->setDbValue($rs->fields('location6_name'));
		$this->location7_name->setDbValue($rs->fields('location7_name'));
		$this->show_address->setDbValue($rs->fields('show_address'));
		$this->zip_id->setDbValue($rs->fields('zip_id'));
		$this->zip_name->setDbValue($rs->fields('zip_name'));
		$this->maccess_num_prop->setDbValue($rs->fields('maccess_num_prop'));
		$this->maccess_num_feat->setDbValue($rs->fields('maccess_num_feat'));
		$this->maccess_num_hot->setDbValue($rs->fields('maccess_num_hot'));
		$this->maccess_num_pic->setDbValue($rs->fields('maccess_num_pic'));
		$this->maccess_period->setDbValue($rs->fields('maccess_period'));
		$this->maccess_price->setDbValue($rs->fields('maccess_price'));
		$this->maccess_price_unit->setDbValue($rs->fields('maccess_price_unit'));
		$this->maccess_lrestrict->setDbValue($rs->fields('maccess_lrestrict'));
		$this->maccess_listings->setDbValue($rs->fields('maccess_listings'));
		$this->maccess_ptrestrict->setDbValue($rs->fields('maccess_ptrestrict'));
		$this->maccess_property_types->setDbValue($rs->fields('maccess_property_types'));
		$this->maccess_renewable->setDbValue($rs->fields('maccess_renewable'));
		$this->maccess_renewal_price->setDbValue($rs->fields('maccess_renewal_price'));
		$this->maccess_renewal_price_unit->setDbValue($rs->fields('maccess_renewal_price_unit'));
		$this->maccess_upgradable->setDbValue($rs->fields('maccess_upgradable'));
		$this->maccess_upgradable_to->setDbValue($rs->fields('maccess_upgradable_to'));
		$this->maccess_short_description->setDbValue($rs->fields('maccess_short_description'));
		$this->maccess_long_description->setDbValue($rs->fields('maccess_long_description'));
		$this->maccess_wpl_color->setDbValue($rs->fields('maccess_wpl_color'));
		$this->expired->setDbValue($rs->fields('expired'));
		$this->expiry_date->setDbValue($rs->fields('expiry_date'));
		$this->textsearch->setDbValue($rs->fields('textsearch'));
		$this->location_text->setDbValue($rs->fields('location_text'));
		$this->rendered->setDbValue($rs->fields('rendered'));
		$this->last_modified_time_stamp->setDbValue($rs->fields('last_modified_time_stamp'));
		$this->profile_picture->setDbValue($rs->fields('profile_picture'));
		$this->company_logo->setDbValue($rs->fields('company_logo'));
		$this->maccess_lrestrict_pshow->setDbValue($rs->fields('maccess_lrestrict_pshow'));
		$this->maccess_ptrestrict_pshow->setDbValue($rs->fields('maccess_ptrestrict_pshow'));
		$this->maccess_listings_pshow->setDbValue($rs->fields('maccess_listings_pshow'));
		$this->maccess_property_types_pshow->setDbValue($rs->fields('maccess_property_types_pshow'));
		$this->maccess_lrestrict_plisting->setDbValue($rs->fields('maccess_lrestrict_plisting'));
		$this->maccess_ptrestrict_plisting->setDbValue($rs->fields('maccess_ptrestrict_plisting'));
		$this->maccess_listings_plisting->setDbValue($rs->fields('maccess_listings_plisting'));
		$this->maccess_property_types_plisting->setDbValue($rs->fields('maccess_property_types_plisting'));
		$this->access_clone->setDbValue($rs->fields('access_clone'));
		$this->access_propertystats->setDbValue($rs->fields('access_propertystats'));
		$this->maccess_crm->setDbValue($rs->fields('maccess_crm'));
		$this->online_status->setDbValue($rs->fields('online_status'));
		$this->access_CRM->setDbValue($rs->fields('access_CRM'));
		$this->crm_selected_fields->setDbValue($rs->fields('crm_selected_fields'));
		$this->crm_cookies->setDbValue($rs->fields('crm_cookies'));
		$this->rendered_en_us->setDbValue($rs->fields('rendered_en_us'));
		$this->textsearch_en_us->setDbValue($rs->fields('textsearch_en_us'));
		$this->rendered_fr_fr->setDbValue($rs->fields('rendered_fr_fr'));
		$this->textsearch_fr_fr->setDbValue($rs->fields('textsearch_fr_fr'));
	}

	// Render list row values
	public function renderListRow()
	{
		global $Security, $CurrentLanguage, $Language;

		// Call Row Rendering event
		$this->Row_Rendering();

		// Common render codes
		// id
		// membership_name
		// membership_id
		// membership_type
		// index
		// access_propertywizard
		// access_propertyshow
		// access_propertylisting
		// access_profilewizard
		// access_confirm
		// access_propertymanager
		// access_delete
		// access_public_profile
		// access_change_user
		// access_receive_notifications
		// first_name
		// last_name
		// about
		// company_name
		// company_address
		// website
		// main_email
		// secondary_email
		// sex
		// tel
		// fax
		// mobile
		// languages
		// location1_id
		// location2_id
		// location3_id
		// location4_id
		// location5_id
		// location6_id
		// location7_id
		// location1_name
		// location2_name
		// location3_name
		// location4_name
		// location5_name
		// location6_name
		// location7_name
		// show_address
		// zip_id
		// zip_name
		// maccess_num_prop
		// maccess_num_feat
		// maccess_num_hot
		// maccess_num_pic
		// maccess_period
		// maccess_price
		// maccess_price_unit
		// maccess_lrestrict
		// maccess_listings
		// maccess_ptrestrict
		// maccess_property_types
		// maccess_renewable
		// maccess_renewal_price
		// maccess_renewal_price_unit
		// maccess_upgradable
		// maccess_upgradable_to
		// maccess_short_description
		// maccess_long_description
		// maccess_wpl_color
		// expired
		// expiry_date
		// textsearch
		// location_text
		// rendered
		// last_modified_time_stamp
		// profile_picture
		// company_logo
		// maccess_lrestrict_pshow
		// maccess_ptrestrict_pshow
		// maccess_listings_pshow
		// maccess_property_types_pshow
		// maccess_lrestrict_plisting
		// maccess_ptrestrict_plisting
		// maccess_listings_plisting
		// maccess_property_types_plisting
		// access_clone
		// access_propertystats
		// maccess_crm
		// online_status
		// access_CRM
		// crm_selected_fields
		// crm_cookies
		// rendered_en_us
		// textsearch_en_us
		// rendered_fr_fr
		// textsearch_fr_fr
		// id

		$this->id->ViewValue = $this->id->CurrentValue;
		$this->id->ViewCustomAttributes = "";

		// membership_name
		$this->membership_name->ViewValue = $this->membership_name->CurrentValue;
		$this->membership_name->ViewCustomAttributes = "";

		// membership_id
		$this->membership_id->ViewValue = $this->membership_id->CurrentValue;
		$this->membership_id->ViewValue = FormatNumber($this->membership_id->ViewValue, 0, -2, -2, -2);
		$this->membership_id->ViewCustomAttributes = "";

		// membership_type
		$this->membership_type->ViewValue = $this->membership_type->CurrentValue;
		$this->membership_type->ViewCustomAttributes = "";

		// index
		$this->_index->ViewValue = $this->_index->CurrentValue;
		$this->_index->ViewValue = FormatNumber($this->_index->ViewValue, 2, -2, -2, -2);
		$this->_index->ViewCustomAttributes = "";

		// access_propertywizard
		$this->access_propertywizard->ViewValue = $this->access_propertywizard->CurrentValue;
		$this->access_propertywizard->ViewValue = FormatNumber($this->access_propertywizard->ViewValue, 0, -2, -2, -2);
		$this->access_propertywizard->ViewCustomAttributes = "";

		// access_propertyshow
		$this->access_propertyshow->ViewValue = $this->access_propertyshow->CurrentValue;
		$this->access_propertyshow->ViewValue = FormatNumber($this->access_propertyshow->ViewValue, 0, -2, -2, -2);
		$this->access_propertyshow->ViewCustomAttributes = "";

		// access_propertylisting
		$this->access_propertylisting->ViewValue = $this->access_propertylisting->CurrentValue;
		$this->access_propertylisting->ViewValue = FormatNumber($this->access_propertylisting->ViewValue, 0, -2, -2, -2);
		$this->access_propertylisting->ViewCustomAttributes = "";

		// access_profilewizard
		$this->access_profilewizard->ViewValue = $this->access_profilewizard->CurrentValue;
		$this->access_profilewizard->ViewValue = FormatNumber($this->access_profilewizard->ViewValue, 0, -2, -2, -2);
		$this->access_profilewizard->ViewCustomAttributes = "";

		// access_confirm
		$this->access_confirm->ViewValue = $this->access_confirm->CurrentValue;
		$this->access_confirm->ViewValue = FormatNumber($this->access_confirm->ViewValue, 0, -2, -2, -2);
		$this->access_confirm->ViewCustomAttributes = "";

		// access_propertymanager
		$this->access_propertymanager->ViewValue = $this->access_propertymanager->CurrentValue;
		$this->access_propertymanager->ViewValue = FormatNumber($this->access_propertymanager->ViewValue, 0, -2, -2, -2);
		$this->access_propertymanager->ViewCustomAttributes = "";

		// access_delete
		$this->access_delete->ViewValue = $this->access_delete->CurrentValue;
		$this->access_delete->ViewValue = FormatNumber($this->access_delete->ViewValue, 0, -2, -2, -2);
		$this->access_delete->ViewCustomAttributes = "";

		// access_public_profile
		$this->access_public_profile->ViewValue = $this->access_public_profile->CurrentValue;
		$this->access_public_profile->ViewValue = FormatNumber($this->access_public_profile->ViewValue, 0, -2, -2, -2);
		$this->access_public_profile->ViewCustomAttributes = "";

		// access_change_user
		$this->access_change_user->ViewValue = $this->access_change_user->CurrentValue;
		$this->access_change_user->ViewValue = FormatNumber($this->access_change_user->ViewValue, 0, -2, -2, -2);
		$this->access_change_user->ViewCustomAttributes = "";

		// access_receive_notifications
		$this->access_receive_notifications->ViewValue = $this->access_receive_notifications->CurrentValue;
		$this->access_receive_notifications->ViewValue = FormatNumber($this->access_receive_notifications->ViewValue, 0, -2, -2, -2);
		$this->access_receive_notifications->ViewCustomAttributes = "";

		// first_name
		$this->first_name->ViewValue = $this->first_name->CurrentValue;
		$this->first_name->ViewCustomAttributes = "";

		// last_name
		$this->last_name->ViewValue = $this->last_name->CurrentValue;
		$this->last_name->ViewCustomAttributes = "";

		// about
		$this->about->ViewValue = $this->about->CurrentValue;
		$this->about->ViewCustomAttributes = "";

		// company_name
		$this->company_name->ViewValue = $this->company_name->CurrentValue;
		$this->company_name->ViewCustomAttributes = "";

		// company_address
		$this->company_address->ViewValue = $this->company_address->CurrentValue;
		$this->company_address->ViewCustomAttributes = "";

		// website
		$this->website->ViewValue = $this->website->CurrentValue;
		$this->website->ViewCustomAttributes = "";

		// main_email
		$this->main_email->ViewValue = $this->main_email->CurrentValue;
		$this->main_email->ViewCustomAttributes = "";

		// secondary_email
		$this->secondary_email->ViewValue = $this->secondary_email->CurrentValue;
		$this->secondary_email->ViewCustomAttributes = "";

		// sex
		$this->sex->ViewValue = $this->sex->CurrentValue;
		$this->sex->ViewValue = FormatNumber($this->sex->ViewValue, 0, -2, -2, -2);
		$this->sex->ViewCustomAttributes = "";

		// tel
		$this->tel->ViewValue = $this->tel->CurrentValue;
		$this->tel->ViewCustomAttributes = "";

		// fax
		$this->fax->ViewValue = $this->fax->CurrentValue;
		$this->fax->ViewCustomAttributes = "";

		// mobile
		$this->mobile->ViewValue = $this->mobile->CurrentValue;
		$this->mobile->ViewCustomAttributes = "";

		// languages
		$this->languages->ViewValue = $this->languages->CurrentValue;
		$this->languages->ViewCustomAttributes = "";

		// location1_id
		$this->location1_id->ViewValue = $this->location1_id->CurrentValue;
		$this->location1_id->ViewValue = FormatNumber($this->location1_id->ViewValue, 0, -2, -2, -2);
		$this->location1_id->ViewCustomAttributes = "";

		// location2_id
		$this->location2_id->ViewValue = $this->location2_id->CurrentValue;
		$this->location2_id->ViewValue = FormatNumber($this->location2_id->ViewValue, 0, -2, -2, -2);
		$this->location2_id->ViewCustomAttributes = "";

		// location3_id
		$this->location3_id->ViewValue = $this->location3_id->CurrentValue;
		$this->location3_id->ViewValue = FormatNumber($this->location3_id->ViewValue, 0, -2, -2, -2);
		$this->location3_id->ViewCustomAttributes = "";

		// location4_id
		$this->location4_id->ViewValue = $this->location4_id->CurrentValue;
		$this->location4_id->ViewValue = FormatNumber($this->location4_id->ViewValue, 0, -2, -2, -2);
		$this->location4_id->ViewCustomAttributes = "";

		// location5_id
		$this->location5_id->ViewValue = $this->location5_id->CurrentValue;
		$this->location5_id->ViewValue = FormatNumber($this->location5_id->ViewValue, 0, -2, -2, -2);
		$this->location5_id->ViewCustomAttributes = "";

		// location6_id
		$this->location6_id->ViewValue = $this->location6_id->CurrentValue;
		$this->location6_id->ViewValue = FormatNumber($this->location6_id->ViewValue, 0, -2, -2, -2);
		$this->location6_id->ViewCustomAttributes = "";

		// location7_id
		$this->location7_id->ViewValue = $this->location7_id->CurrentValue;
		$this->location7_id->ViewValue = FormatNumber($this->location7_id->ViewValue, 0, -2, -2, -2);
		$this->location7_id->ViewCustomAttributes = "";

		// location1_name
		$this->location1_name->ViewValue = $this->location1_name->CurrentValue;
		$this->location1_name->ViewCustomAttributes = "";

		// location2_name
		$this->location2_name->ViewValue = $this->location2_name->CurrentValue;
		$this->location2_name->ViewCustomAttributes = "";

		// location3_name
		$this->location3_name->ViewValue = $this->location3_name->CurrentValue;
		$this->location3_name->ViewCustomAttributes = "";

		// location4_name
		$this->location4_name->ViewValue = $this->location4_name->CurrentValue;
		$this->location4_name->ViewCustomAttributes = "";

		// location5_name
		$this->location5_name->ViewValue = $this->location5_name->CurrentValue;
		$this->location5_name->ViewCustomAttributes = "";

		// location6_name
		$this->location6_name->ViewValue = $this->location6_name->CurrentValue;
		$this->location6_name->ViewCustomAttributes = "";

		// location7_name
		$this->location7_name->ViewValue = $this->location7_name->CurrentValue;
		$this->location7_name->ViewCustomAttributes = "";

		// show_address
		$this->show_address->ViewValue = $this->show_address->CurrentValue;
		$this->show_address->ViewValue = FormatNumber($this->show_address->ViewValue, 0, -2, -2, -2);
		$this->show_address->ViewCustomAttributes = "";

		// zip_id
		$this->zip_id->ViewValue = $this->zip_id->CurrentValue;
		$this->zip_id->ViewValue = FormatNumber($this->zip_id->ViewValue, 0, -2, -2, -2);
		$this->zip_id->ViewCustomAttributes = "";

		// zip_name
		$this->zip_name->ViewValue = $this->zip_name->CurrentValue;
		$this->zip_name->ViewCustomAttributes = "";

		// maccess_num_prop
		$this->maccess_num_prop->ViewValue = $this->maccess_num_prop->CurrentValue;
		$this->maccess_num_prop->ViewValue = FormatNumber($this->maccess_num_prop->ViewValue, 0, -2, -2, -2);
		$this->maccess_num_prop->ViewCustomAttributes = "";

		// maccess_num_feat
		$this->maccess_num_feat->ViewValue = $this->maccess_num_feat->CurrentValue;
		$this->maccess_num_feat->ViewValue = FormatNumber($this->maccess_num_feat->ViewValue, 0, -2, -2, -2);
		$this->maccess_num_feat->ViewCustomAttributes = "";

		// maccess_num_hot
		$this->maccess_num_hot->ViewValue = $this->maccess_num_hot->CurrentValue;
		$this->maccess_num_hot->ViewValue = FormatNumber($this->maccess_num_hot->ViewValue, 0, -2, -2, -2);
		$this->maccess_num_hot->ViewCustomAttributes = "";

		// maccess_num_pic
		$this->maccess_num_pic->ViewValue = $this->maccess_num_pic->CurrentValue;
		$this->maccess_num_pic->ViewValue = FormatNumber($this->maccess_num_pic->ViewValue, 0, -2, -2, -2);
		$this->maccess_num_pic->ViewCustomAttributes = "";

		// maccess_period
		$this->maccess_period->ViewValue = $this->maccess_period->CurrentValue;
		$this->maccess_period->ViewValue = FormatNumber($this->maccess_period->ViewValue, 0, -2, -2, -2);
		$this->maccess_period->ViewCustomAttributes = "";

		// maccess_price
		$this->maccess_price->ViewValue = $this->maccess_price->CurrentValue;
		$this->maccess_price->ViewValue = FormatNumber($this->maccess_price->ViewValue, 2, -2, -2, -2);
		$this->maccess_price->ViewCustomAttributes = "";

		// maccess_price_unit
		$this->maccess_price_unit->ViewValue = $this->maccess_price_unit->CurrentValue;
		$this->maccess_price_unit->ViewValue = FormatNumber($this->maccess_price_unit->ViewValue, 0, -2, -2, -2);
		$this->maccess_price_unit->ViewCustomAttributes = "";

		// maccess_lrestrict
		$this->maccess_lrestrict->ViewValue = $this->maccess_lrestrict->CurrentValue;
		$this->maccess_lrestrict->ViewValue = FormatNumber($this->maccess_lrestrict->ViewValue, 0, -2, -2, -2);
		$this->maccess_lrestrict->ViewCustomAttributes = "";

		// maccess_listings
		$this->maccess_listings->ViewValue = $this->maccess_listings->CurrentValue;
		$this->maccess_listings->ViewCustomAttributes = "";

		// maccess_ptrestrict
		$this->maccess_ptrestrict->ViewValue = $this->maccess_ptrestrict->CurrentValue;
		$this->maccess_ptrestrict->ViewValue = FormatNumber($this->maccess_ptrestrict->ViewValue, 0, -2, -2, -2);
		$this->maccess_ptrestrict->ViewCustomAttributes = "";

		// maccess_property_types
		$this->maccess_property_types->ViewValue = $this->maccess_property_types->CurrentValue;
		$this->maccess_property_types->ViewCustomAttributes = "";

		// maccess_renewable
		$this->maccess_renewable->ViewValue = $this->maccess_renewable->CurrentValue;
		$this->maccess_renewable->ViewValue = FormatNumber($this->maccess_renewable->ViewValue, 0, -2, -2, -2);
		$this->maccess_renewable->ViewCustomAttributes = "";

		// maccess_renewal_price
		$this->maccess_renewal_price->ViewValue = $this->maccess_renewal_price->CurrentValue;
		$this->maccess_renewal_price->ViewValue = FormatNumber($this->maccess_renewal_price->ViewValue, 2, -2, -2, -2);
		$this->maccess_renewal_price->ViewCustomAttributes = "";

		// maccess_renewal_price_unit
		$this->maccess_renewal_price_unit->ViewValue = $this->maccess_renewal_price_unit->CurrentValue;
		$this->maccess_renewal_price_unit->ViewValue = FormatNumber($this->maccess_renewal_price_unit->ViewValue, 0, -2, -2, -2);
		$this->maccess_renewal_price_unit->ViewCustomAttributes = "";

		// maccess_upgradable
		$this->maccess_upgradable->ViewValue = $this->maccess_upgradable->CurrentValue;
		$this->maccess_upgradable->ViewValue = FormatNumber($this->maccess_upgradable->ViewValue, 0, -2, -2, -2);
		$this->maccess_upgradable->ViewCustomAttributes = "";

		// maccess_upgradable_to
		$this->maccess_upgradable_to->ViewValue = $this->maccess_upgradable_to->CurrentValue;
		$this->maccess_upgradable_to->ViewCustomAttributes = "";

		// maccess_short_description
		$this->maccess_short_description->ViewValue = $this->maccess_short_description->CurrentValue;
		$this->maccess_short_description->ViewCustomAttributes = "";

		// maccess_long_description
		$this->maccess_long_description->ViewValue = $this->maccess_long_description->CurrentValue;
		$this->maccess_long_description->ViewCustomAttributes = "";

		// maccess_wpl_color
		$this->maccess_wpl_color->ViewValue = $this->maccess_wpl_color->CurrentValue;
		$this->maccess_wpl_color->ViewCustomAttributes = "";

		// expired
		$this->expired->ViewValue = $this->expired->CurrentValue;
		$this->expired->ViewValue = FormatNumber($this->expired->ViewValue, 0, -2, -2, -2);
		$this->expired->ViewCustomAttributes = "";

		// expiry_date
		$this->expiry_date->ViewValue = $this->expiry_date->CurrentValue;
		$this->expiry_date->ViewValue = FormatDateTime($this->expiry_date->ViewValue, 0);
		$this->expiry_date->ViewCustomAttributes = "";

		// textsearch
		$this->textsearch->ViewValue = $this->textsearch->CurrentValue;
		$this->textsearch->ViewCustomAttributes = "";

		// location_text
		$this->location_text->ViewValue = $this->location_text->CurrentValue;
		$this->location_text->ViewCustomAttributes = "";

		// rendered
		$this->rendered->ViewValue = $this->rendered->CurrentValue;
		$this->rendered->ViewCustomAttributes = "";

		// last_modified_time_stamp
		$this->last_modified_time_stamp->ViewValue = $this->last_modified_time_stamp->CurrentValue;
		$this->last_modified_time_stamp->ViewValue = FormatDateTime($this->last_modified_time_stamp->ViewValue, 0);
		$this->last_modified_time_stamp->ViewCustomAttributes = "";

		// profile_picture
		$this->profile_picture->ViewValue = $this->profile_picture->CurrentValue;
		$this->profile_picture->ViewCustomAttributes = "";

		// company_logo
		$this->company_logo->ViewValue = $this->company_logo->CurrentValue;
		$this->company_logo->ViewCustomAttributes = "";

		// maccess_lrestrict_pshow
		$this->maccess_lrestrict_pshow->ViewValue = $this->maccess_lrestrict_pshow->CurrentValue;
		$this->maccess_lrestrict_pshow->ViewValue = FormatNumber($this->maccess_lrestrict_pshow->ViewValue, 0, -2, -2, -2);
		$this->maccess_lrestrict_pshow->ViewCustomAttributes = "";

		// maccess_ptrestrict_pshow
		$this->maccess_ptrestrict_pshow->ViewValue = $this->maccess_ptrestrict_pshow->CurrentValue;
		$this->maccess_ptrestrict_pshow->ViewValue = FormatNumber($this->maccess_ptrestrict_pshow->ViewValue, 0, -2, -2, -2);
		$this->maccess_ptrestrict_pshow->ViewCustomAttributes = "";

		// maccess_listings_pshow
		$this->maccess_listings_pshow->ViewValue = $this->maccess_listings_pshow->CurrentValue;
		$this->maccess_listings_pshow->ViewCustomAttributes = "";

		// maccess_property_types_pshow
		$this->maccess_property_types_pshow->ViewValue = $this->maccess_property_types_pshow->CurrentValue;
		$this->maccess_property_types_pshow->ViewCustomAttributes = "";

		// maccess_lrestrict_plisting
		$this->maccess_lrestrict_plisting->ViewValue = $this->maccess_lrestrict_plisting->CurrentValue;
		$this->maccess_lrestrict_plisting->ViewValue = FormatNumber($this->maccess_lrestrict_plisting->ViewValue, 0, -2, -2, -2);
		$this->maccess_lrestrict_plisting->ViewCustomAttributes = "";

		// maccess_ptrestrict_plisting
		$this->maccess_ptrestrict_plisting->ViewValue = $this->maccess_ptrestrict_plisting->CurrentValue;
		$this->maccess_ptrestrict_plisting->ViewValue = FormatNumber($this->maccess_ptrestrict_plisting->ViewValue, 0, -2, -2, -2);
		$this->maccess_ptrestrict_plisting->ViewCustomAttributes = "";

		// maccess_listings_plisting
		$this->maccess_listings_plisting->ViewValue = $this->maccess_listings_plisting->CurrentValue;
		$this->maccess_listings_plisting->ViewCustomAttributes = "";

		// maccess_property_types_plisting
		$this->maccess_property_types_plisting->ViewValue = $this->maccess_property_types_plisting->CurrentValue;
		$this->maccess_property_types_plisting->ViewCustomAttributes = "";

		// access_clone
		$this->access_clone->ViewValue = $this->access_clone->CurrentValue;
		$this->access_clone->ViewValue = FormatNumber($this->access_clone->ViewValue, 0, -2, -2, -2);
		$this->access_clone->ViewCustomAttributes = "";

		// access_propertystats
		$this->access_propertystats->ViewValue = $this->access_propertystats->CurrentValue;
		$this->access_propertystats->ViewValue = FormatNumber($this->access_propertystats->ViewValue, 0, -2, -2, -2);
		$this->access_propertystats->ViewCustomAttributes = "";

		// maccess_crm
		$this->maccess_crm->ViewValue = $this->maccess_crm->CurrentValue;
		$this->maccess_crm->ViewCustomAttributes = "";

		// online_status
		$this->online_status->ViewValue = $this->online_status->CurrentValue;
		$this->online_status->ViewCustomAttributes = "";

		// access_CRM
		$this->access_CRM->ViewValue = $this->access_CRM->CurrentValue;
		$this->access_CRM->ViewValue = FormatNumber($this->access_CRM->ViewValue, 0, -2, -2, -2);
		$this->access_CRM->ViewCustomAttributes = "";

		// crm_selected_fields
		$this->crm_selected_fields->ViewValue = $this->crm_selected_fields->CurrentValue;
		$this->crm_selected_fields->ViewCustomAttributes = "";

		// crm_cookies
		$this->crm_cookies->ViewValue = $this->crm_cookies->CurrentValue;
		$this->crm_cookies->ViewCustomAttributes = "";

		// rendered_en_us
		$this->rendered_en_us->ViewValue = $this->rendered_en_us->CurrentValue;
		$this->rendered_en_us->ViewCustomAttributes = "";

		// textsearch_en_us
		$this->textsearch_en_us->ViewValue = $this->textsearch_en_us->CurrentValue;
		$this->textsearch_en_us->ViewCustomAttributes = "";

		// rendered_fr_fr
		$this->rendered_fr_fr->ViewValue = $this->rendered_fr_fr->CurrentValue;
		$this->rendered_fr_fr->ViewCustomAttributes = "";

		// textsearch_fr_fr
		$this->textsearch_fr_fr->ViewValue = $this->textsearch_fr_fr->CurrentValue;
		$this->textsearch_fr_fr->ViewCustomAttributes = "";

		// id
		$this->id->LinkCustomAttributes = "";
		$this->id->HrefValue = "";
		$this->id->TooltipValue = "";

		// membership_name
		$this->membership_name->LinkCustomAttributes = "";
		$this->membership_name->HrefValue = "";
		$this->membership_name->TooltipValue = "";

		// membership_id
		$this->membership_id->LinkCustomAttributes = "";
		$this->membership_id->HrefValue = "";
		$this->membership_id->TooltipValue = "";

		// membership_type
		$this->membership_type->LinkCustomAttributes = "";
		$this->membership_type->HrefValue = "";
		$this->membership_type->TooltipValue = "";

		// index
		$this->_index->LinkCustomAttributes = "";
		$this->_index->HrefValue = "";
		$this->_index->TooltipValue = "";

		// access_propertywizard
		$this->access_propertywizard->LinkCustomAttributes = "";
		$this->access_propertywizard->HrefValue = "";
		$this->access_propertywizard->TooltipValue = "";

		// access_propertyshow
		$this->access_propertyshow->LinkCustomAttributes = "";
		$this->access_propertyshow->HrefValue = "";
		$this->access_propertyshow->TooltipValue = "";

		// access_propertylisting
		$this->access_propertylisting->LinkCustomAttributes = "";
		$this->access_propertylisting->HrefValue = "";
		$this->access_propertylisting->TooltipValue = "";

		// access_profilewizard
		$this->access_profilewizard->LinkCustomAttributes = "";
		$this->access_profilewizard->HrefValue = "";
		$this->access_profilewizard->TooltipValue = "";

		// access_confirm
		$this->access_confirm->LinkCustomAttributes = "";
		$this->access_confirm->HrefValue = "";
		$this->access_confirm->TooltipValue = "";

		// access_propertymanager
		$this->access_propertymanager->LinkCustomAttributes = "";
		$this->access_propertymanager->HrefValue = "";
		$this->access_propertymanager->TooltipValue = "";

		// access_delete
		$this->access_delete->LinkCustomAttributes = "";
		$this->access_delete->HrefValue = "";
		$this->access_delete->TooltipValue = "";

		// access_public_profile
		$this->access_public_profile->LinkCustomAttributes = "";
		$this->access_public_profile->HrefValue = "";
		$this->access_public_profile->TooltipValue = "";

		// access_change_user
		$this->access_change_user->LinkCustomAttributes = "";
		$this->access_change_user->HrefValue = "";
		$this->access_change_user->TooltipValue = "";

		// access_receive_notifications
		$this->access_receive_notifications->LinkCustomAttributes = "";
		$this->access_receive_notifications->HrefValue = "";
		$this->access_receive_notifications->TooltipValue = "";

		// first_name
		$this->first_name->LinkCustomAttributes = "";
		$this->first_name->HrefValue = "";
		$this->first_name->TooltipValue = "";

		// last_name
		$this->last_name->LinkCustomAttributes = "";
		$this->last_name->HrefValue = "";
		$this->last_name->TooltipValue = "";

		// about
		$this->about->LinkCustomAttributes = "";
		$this->about->HrefValue = "";
		$this->about->TooltipValue = "";

		// company_name
		$this->company_name->LinkCustomAttributes = "";
		$this->company_name->HrefValue = "";
		$this->company_name->TooltipValue = "";

		// company_address
		$this->company_address->LinkCustomAttributes = "";
		$this->company_address->HrefValue = "";
		$this->company_address->TooltipValue = "";

		// website
		$this->website->LinkCustomAttributes = "";
		$this->website->HrefValue = "";
		$this->website->TooltipValue = "";

		// main_email
		$this->main_email->LinkCustomAttributes = "";
		$this->main_email->HrefValue = "";
		$this->main_email->TooltipValue = "";

		// secondary_email
		$this->secondary_email->LinkCustomAttributes = "";
		$this->secondary_email->HrefValue = "";
		$this->secondary_email->TooltipValue = "";

		// sex
		$this->sex->LinkCustomAttributes = "";
		$this->sex->HrefValue = "";
		$this->sex->TooltipValue = "";

		// tel
		$this->tel->LinkCustomAttributes = "";
		$this->tel->HrefValue = "";
		$this->tel->TooltipValue = "";

		// fax
		$this->fax->LinkCustomAttributes = "";
		$this->fax->HrefValue = "";
		$this->fax->TooltipValue = "";

		// mobile
		$this->mobile->LinkCustomAttributes = "";
		$this->mobile->HrefValue = "";
		$this->mobile->TooltipValue = "";

		// languages
		$this->languages->LinkCustomAttributes = "";
		$this->languages->HrefValue = "";
		$this->languages->TooltipValue = "";

		// location1_id
		$this->location1_id->LinkCustomAttributes = "";
		$this->location1_id->HrefValue = "";
		$this->location1_id->TooltipValue = "";

		// location2_id
		$this->location2_id->LinkCustomAttributes = "";
		$this->location2_id->HrefValue = "";
		$this->location2_id->TooltipValue = "";

		// location3_id
		$this->location3_id->LinkCustomAttributes = "";
		$this->location3_id->HrefValue = "";
		$this->location3_id->TooltipValue = "";

		// location4_id
		$this->location4_id->LinkCustomAttributes = "";
		$this->location4_id->HrefValue = "";
		$this->location4_id->TooltipValue = "";

		// location5_id
		$this->location5_id->LinkCustomAttributes = "";
		$this->location5_id->HrefValue = "";
		$this->location5_id->TooltipValue = "";

		// location6_id
		$this->location6_id->LinkCustomAttributes = "";
		$this->location6_id->HrefValue = "";
		$this->location6_id->TooltipValue = "";

		// location7_id
		$this->location7_id->LinkCustomAttributes = "";
		$this->location7_id->HrefValue = "";
		$this->location7_id->TooltipValue = "";

		// location1_name
		$this->location1_name->LinkCustomAttributes = "";
		$this->location1_name->HrefValue = "";
		$this->location1_name->TooltipValue = "";

		// location2_name
		$this->location2_name->LinkCustomAttributes = "";
		$this->location2_name->HrefValue = "";
		$this->location2_name->TooltipValue = "";

		// location3_name
		$this->location3_name->LinkCustomAttributes = "";
		$this->location3_name->HrefValue = "";
		$this->location3_name->TooltipValue = "";

		// location4_name
		$this->location4_name->LinkCustomAttributes = "";
		$this->location4_name->HrefValue = "";
		$this->location4_name->TooltipValue = "";

		// location5_name
		$this->location5_name->LinkCustomAttributes = "";
		$this->location5_name->HrefValue = "";
		$this->location5_name->TooltipValue = "";

		// location6_name
		$this->location6_name->LinkCustomAttributes = "";
		$this->location6_name->HrefValue = "";
		$this->location6_name->TooltipValue = "";

		// location7_name
		$this->location7_name->LinkCustomAttributes = "";
		$this->location7_name->HrefValue = "";
		$this->location7_name->TooltipValue = "";

		// show_address
		$this->show_address->LinkCustomAttributes = "";
		$this->show_address->HrefValue = "";
		$this->show_address->TooltipValue = "";

		// zip_id
		$this->zip_id->LinkCustomAttributes = "";
		$this->zip_id->HrefValue = "";
		$this->zip_id->TooltipValue = "";

		// zip_name
		$this->zip_name->LinkCustomAttributes = "";
		$this->zip_name->HrefValue = "";
		$this->zip_name->TooltipValue = "";

		// maccess_num_prop
		$this->maccess_num_prop->LinkCustomAttributes = "";
		$this->maccess_num_prop->HrefValue = "";
		$this->maccess_num_prop->TooltipValue = "";

		// maccess_num_feat
		$this->maccess_num_feat->LinkCustomAttributes = "";
		$this->maccess_num_feat->HrefValue = "";
		$this->maccess_num_feat->TooltipValue = "";

		// maccess_num_hot
		$this->maccess_num_hot->LinkCustomAttributes = "";
		$this->maccess_num_hot->HrefValue = "";
		$this->maccess_num_hot->TooltipValue = "";

		// maccess_num_pic
		$this->maccess_num_pic->LinkCustomAttributes = "";
		$this->maccess_num_pic->HrefValue = "";
		$this->maccess_num_pic->TooltipValue = "";

		// maccess_period
		$this->maccess_period->LinkCustomAttributes = "";
		$this->maccess_period->HrefValue = "";
		$this->maccess_period->TooltipValue = "";

		// maccess_price
		$this->maccess_price->LinkCustomAttributes = "";
		$this->maccess_price->HrefValue = "";
		$this->maccess_price->TooltipValue = "";

		// maccess_price_unit
		$this->maccess_price_unit->LinkCustomAttributes = "";
		$this->maccess_price_unit->HrefValue = "";
		$this->maccess_price_unit->TooltipValue = "";

		// maccess_lrestrict
		$this->maccess_lrestrict->LinkCustomAttributes = "";
		$this->maccess_lrestrict->HrefValue = "";
		$this->maccess_lrestrict->TooltipValue = "";

		// maccess_listings
		$this->maccess_listings->LinkCustomAttributes = "";
		$this->maccess_listings->HrefValue = "";
		$this->maccess_listings->TooltipValue = "";

		// maccess_ptrestrict
		$this->maccess_ptrestrict->LinkCustomAttributes = "";
		$this->maccess_ptrestrict->HrefValue = "";
		$this->maccess_ptrestrict->TooltipValue = "";

		// maccess_property_types
		$this->maccess_property_types->LinkCustomAttributes = "";
		$this->maccess_property_types->HrefValue = "";
		$this->maccess_property_types->TooltipValue = "";

		// maccess_renewable
		$this->maccess_renewable->LinkCustomAttributes = "";
		$this->maccess_renewable->HrefValue = "";
		$this->maccess_renewable->TooltipValue = "";

		// maccess_renewal_price
		$this->maccess_renewal_price->LinkCustomAttributes = "";
		$this->maccess_renewal_price->HrefValue = "";
		$this->maccess_renewal_price->TooltipValue = "";

		// maccess_renewal_price_unit
		$this->maccess_renewal_price_unit->LinkCustomAttributes = "";
		$this->maccess_renewal_price_unit->HrefValue = "";
		$this->maccess_renewal_price_unit->TooltipValue = "";

		// maccess_upgradable
		$this->maccess_upgradable->LinkCustomAttributes = "";
		$this->maccess_upgradable->HrefValue = "";
		$this->maccess_upgradable->TooltipValue = "";

		// maccess_upgradable_to
		$this->maccess_upgradable_to->LinkCustomAttributes = "";
		$this->maccess_upgradable_to->HrefValue = "";
		$this->maccess_upgradable_to->TooltipValue = "";

		// maccess_short_description
		$this->maccess_short_description->LinkCustomAttributes = "";
		$this->maccess_short_description->HrefValue = "";
		$this->maccess_short_description->TooltipValue = "";

		// maccess_long_description
		$this->maccess_long_description->LinkCustomAttributes = "";
		$this->maccess_long_description->HrefValue = "";
		$this->maccess_long_description->TooltipValue = "";

		// maccess_wpl_color
		$this->maccess_wpl_color->LinkCustomAttributes = "";
		$this->maccess_wpl_color->HrefValue = "";
		$this->maccess_wpl_color->TooltipValue = "";

		// expired
		$this->expired->LinkCustomAttributes = "";
		$this->expired->HrefValue = "";
		$this->expired->TooltipValue = "";

		// expiry_date
		$this->expiry_date->LinkCustomAttributes = "";
		$this->expiry_date->HrefValue = "";
		$this->expiry_date->TooltipValue = "";

		// textsearch
		$this->textsearch->LinkCustomAttributes = "";
		$this->textsearch->HrefValue = "";
		$this->textsearch->TooltipValue = "";

		// location_text
		$this->location_text->LinkCustomAttributes = "";
		$this->location_text->HrefValue = "";
		$this->location_text->TooltipValue = "";

		// rendered
		$this->rendered->LinkCustomAttributes = "";
		$this->rendered->HrefValue = "";
		$this->rendered->TooltipValue = "";

		// last_modified_time_stamp
		$this->last_modified_time_stamp->LinkCustomAttributes = "";
		$this->last_modified_time_stamp->HrefValue = "";
		$this->last_modified_time_stamp->TooltipValue = "";

		// profile_picture
		$this->profile_picture->LinkCustomAttributes = "";
		$this->profile_picture->HrefValue = "";
		$this->profile_picture->TooltipValue = "";

		// company_logo
		$this->company_logo->LinkCustomAttributes = "";
		$this->company_logo->HrefValue = "";
		$this->company_logo->TooltipValue = "";

		// maccess_lrestrict_pshow
		$this->maccess_lrestrict_pshow->LinkCustomAttributes = "";
		$this->maccess_lrestrict_pshow->HrefValue = "";
		$this->maccess_lrestrict_pshow->TooltipValue = "";

		// maccess_ptrestrict_pshow
		$this->maccess_ptrestrict_pshow->LinkCustomAttributes = "";
		$this->maccess_ptrestrict_pshow->HrefValue = "";
		$this->maccess_ptrestrict_pshow->TooltipValue = "";

		// maccess_listings_pshow
		$this->maccess_listings_pshow->LinkCustomAttributes = "";
		$this->maccess_listings_pshow->HrefValue = "";
		$this->maccess_listings_pshow->TooltipValue = "";

		// maccess_property_types_pshow
		$this->maccess_property_types_pshow->LinkCustomAttributes = "";
		$this->maccess_property_types_pshow->HrefValue = "";
		$this->maccess_property_types_pshow->TooltipValue = "";

		// maccess_lrestrict_plisting
		$this->maccess_lrestrict_plisting->LinkCustomAttributes = "";
		$this->maccess_lrestrict_plisting->HrefValue = "";
		$this->maccess_lrestrict_plisting->TooltipValue = "";

		// maccess_ptrestrict_plisting
		$this->maccess_ptrestrict_plisting->LinkCustomAttributes = "";
		$this->maccess_ptrestrict_plisting->HrefValue = "";
		$this->maccess_ptrestrict_plisting->TooltipValue = "";

		// maccess_listings_plisting
		$this->maccess_listings_plisting->LinkCustomAttributes = "";
		$this->maccess_listings_plisting->HrefValue = "";
		$this->maccess_listings_plisting->TooltipValue = "";

		// maccess_property_types_plisting
		$this->maccess_property_types_plisting->LinkCustomAttributes = "";
		$this->maccess_property_types_plisting->HrefValue = "";
		$this->maccess_property_types_plisting->TooltipValue = "";

		// access_clone
		$this->access_clone->LinkCustomAttributes = "";
		$this->access_clone->HrefValue = "";
		$this->access_clone->TooltipValue = "";

		// access_propertystats
		$this->access_propertystats->LinkCustomAttributes = "";
		$this->access_propertystats->HrefValue = "";
		$this->access_propertystats->TooltipValue = "";

		// maccess_crm
		$this->maccess_crm->LinkCustomAttributes = "";
		$this->maccess_crm->HrefValue = "";
		$this->maccess_crm->TooltipValue = "";

		// online_status
		$this->online_status->LinkCustomAttributes = "";
		$this->online_status->HrefValue = "";
		$this->online_status->TooltipValue = "";

		// access_CRM
		$this->access_CRM->LinkCustomAttributes = "";
		$this->access_CRM->HrefValue = "";
		$this->access_CRM->TooltipValue = "";

		// crm_selected_fields
		$this->crm_selected_fields->LinkCustomAttributes = "";
		$this->crm_selected_fields->HrefValue = "";
		$this->crm_selected_fields->TooltipValue = "";

		// crm_cookies
		$this->crm_cookies->LinkCustomAttributes = "";
		$this->crm_cookies->HrefValue = "";
		$this->crm_cookies->TooltipValue = "";

		// rendered_en_us
		$this->rendered_en_us->LinkCustomAttributes = "";
		$this->rendered_en_us->HrefValue = "";
		$this->rendered_en_us->TooltipValue = "";

		// textsearch_en_us
		$this->textsearch_en_us->LinkCustomAttributes = "";
		$this->textsearch_en_us->HrefValue = "";
		$this->textsearch_en_us->TooltipValue = "";

		// rendered_fr_fr
		$this->rendered_fr_fr->LinkCustomAttributes = "";
		$this->rendered_fr_fr->HrefValue = "";
		$this->rendered_fr_fr->TooltipValue = "";

		// textsearch_fr_fr
		$this->textsearch_fr_fr->LinkCustomAttributes = "";
		$this->textsearch_fr_fr->HrefValue = "";
		$this->textsearch_fr_fr->TooltipValue = "";

		// Call Row Rendered event
		$this->Row_Rendered();

		// Save data for Custom Template
		$this->Rows[] = $this->customTemplateFieldValues();
	}

	// Render edit row values
	public function renderEditRow()
	{
		global $Security, $CurrentLanguage, $Language;

		// Call Row Rendering event
		$this->Row_Rendering();

		// id
		$this->id->EditAttrs["class"] = "form-control";
		$this->id->EditCustomAttributes = "";
		$this->id->EditValue = $this->id->CurrentValue;
		$this->id->ViewCustomAttributes = "";

		// membership_name
		$this->membership_name->EditAttrs["class"] = "form-control";
		$this->membership_name->EditCustomAttributes = "";
		if (!$this->membership_name->Raw)
			$this->membership_name->CurrentValue = HtmlDecode($this->membership_name->CurrentValue);
		$this->membership_name->EditValue = $this->membership_name->CurrentValue;
		$this->membership_name->PlaceHolder = RemoveHtml($this->membership_name->caption());

		// membership_id
		$this->membership_id->EditAttrs["class"] = "form-control";
		$this->membership_id->EditCustomAttributes = "";
		$this->membership_id->EditValue = $this->membership_id->CurrentValue;
		$this->membership_id->PlaceHolder = RemoveHtml($this->membership_id->caption());

		// membership_type
		$this->membership_type->EditAttrs["class"] = "form-control";
		$this->membership_type->EditCustomAttributes = "";
		if (!$this->membership_type->Raw)
			$this->membership_type->CurrentValue = HtmlDecode($this->membership_type->CurrentValue);
		$this->membership_type->EditValue = $this->membership_type->CurrentValue;
		$this->membership_type->PlaceHolder = RemoveHtml($this->membership_type->caption());

		// index
		$this->_index->EditAttrs["class"] = "form-control";
		$this->_index->EditCustomAttributes = "";
		$this->_index->EditValue = $this->_index->CurrentValue;
		$this->_index->PlaceHolder = RemoveHtml($this->_index->caption());
		if (strval($this->_index->EditValue) != "" && is_numeric($this->_index->EditValue))
			$this->_index->EditValue = FormatNumber($this->_index->EditValue, -2, -2, -2, -2);
		

		// access_propertywizard
		$this->access_propertywizard->EditAttrs["class"] = "form-control";
		$this->access_propertywizard->EditCustomAttributes = "";
		$this->access_propertywizard->EditValue = $this->access_propertywizard->CurrentValue;
		$this->access_propertywizard->PlaceHolder = RemoveHtml($this->access_propertywizard->caption());

		// access_propertyshow
		$this->access_propertyshow->EditAttrs["class"] = "form-control";
		$this->access_propertyshow->EditCustomAttributes = "";
		$this->access_propertyshow->EditValue = $this->access_propertyshow->CurrentValue;
		$this->access_propertyshow->PlaceHolder = RemoveHtml($this->access_propertyshow->caption());

		// access_propertylisting
		$this->access_propertylisting->EditAttrs["class"] = "form-control";
		$this->access_propertylisting->EditCustomAttributes = "";
		$this->access_propertylisting->EditValue = $this->access_propertylisting->CurrentValue;
		$this->access_propertylisting->PlaceHolder = RemoveHtml($this->access_propertylisting->caption());

		// access_profilewizard
		$this->access_profilewizard->EditAttrs["class"] = "form-control";
		$this->access_profilewizard->EditCustomAttributes = "";
		$this->access_profilewizard->EditValue = $this->access_profilewizard->CurrentValue;
		$this->access_profilewizard->PlaceHolder = RemoveHtml($this->access_profilewizard->caption());

		// access_confirm
		$this->access_confirm->EditAttrs["class"] = "form-control";
		$this->access_confirm->EditCustomAttributes = "";
		$this->access_confirm->EditValue = $this->access_confirm->CurrentValue;
		$this->access_confirm->PlaceHolder = RemoveHtml($this->access_confirm->caption());

		// access_propertymanager
		$this->access_propertymanager->EditAttrs["class"] = "form-control";
		$this->access_propertymanager->EditCustomAttributes = "";
		$this->access_propertymanager->EditValue = $this->access_propertymanager->CurrentValue;
		$this->access_propertymanager->PlaceHolder = RemoveHtml($this->access_propertymanager->caption());

		// access_delete
		$this->access_delete->EditAttrs["class"] = "form-control";
		$this->access_delete->EditCustomAttributes = "";
		$this->access_delete->EditValue = $this->access_delete->CurrentValue;
		$this->access_delete->PlaceHolder = RemoveHtml($this->access_delete->caption());

		// access_public_profile
		$this->access_public_profile->EditAttrs["class"] = "form-control";
		$this->access_public_profile->EditCustomAttributes = "";
		$this->access_public_profile->EditValue = $this->access_public_profile->CurrentValue;
		$this->access_public_profile->PlaceHolder = RemoveHtml($this->access_public_profile->caption());

		// access_change_user
		$this->access_change_user->EditAttrs["class"] = "form-control";
		$this->access_change_user->EditCustomAttributes = "";
		$this->access_change_user->EditValue = $this->access_change_user->CurrentValue;
		$this->access_change_user->PlaceHolder = RemoveHtml($this->access_change_user->caption());

		// access_receive_notifications
		$this->access_receive_notifications->EditAttrs["class"] = "form-control";
		$this->access_receive_notifications->EditCustomAttributes = "";
		$this->access_receive_notifications->EditValue = $this->access_receive_notifications->CurrentValue;
		$this->access_receive_notifications->PlaceHolder = RemoveHtml($this->access_receive_notifications->caption());

		// first_name
		$this->first_name->EditAttrs["class"] = "form-control";
		$this->first_name->EditCustomAttributes = "";
		if (!$this->first_name->Raw)
			$this->first_name->CurrentValue = HtmlDecode($this->first_name->CurrentValue);
		$this->first_name->EditValue = $this->first_name->CurrentValue;
		$this->first_name->PlaceHolder = RemoveHtml($this->first_name->caption());

		// last_name
		$this->last_name->EditAttrs["class"] = "form-control";
		$this->last_name->EditCustomAttributes = "";
		if (!$this->last_name->Raw)
			$this->last_name->CurrentValue = HtmlDecode($this->last_name->CurrentValue);
		$this->last_name->EditValue = $this->last_name->CurrentValue;
		$this->last_name->PlaceHolder = RemoveHtml($this->last_name->caption());

		// about
		$this->about->EditAttrs["class"] = "form-control";
		$this->about->EditCustomAttributes = "";
		$this->about->EditValue = $this->about->CurrentValue;
		$this->about->PlaceHolder = RemoveHtml($this->about->caption());

		// company_name
		$this->company_name->EditAttrs["class"] = "form-control";
		$this->company_name->EditCustomAttributes = "";
		if (!$this->company_name->Raw)
			$this->company_name->CurrentValue = HtmlDecode($this->company_name->CurrentValue);
		$this->company_name->EditValue = $this->company_name->CurrentValue;
		$this->company_name->PlaceHolder = RemoveHtml($this->company_name->caption());

		// company_address
		$this->company_address->EditAttrs["class"] = "form-control";
		$this->company_address->EditCustomAttributes = "";
		if (!$this->company_address->Raw)
			$this->company_address->CurrentValue = HtmlDecode($this->company_address->CurrentValue);
		$this->company_address->EditValue = $this->company_address->CurrentValue;
		$this->company_address->PlaceHolder = RemoveHtml($this->company_address->caption());

		// website
		$this->website->EditAttrs["class"] = "form-control";
		$this->website->EditCustomAttributes = "";
		if (!$this->website->Raw)
			$this->website->CurrentValue = HtmlDecode($this->website->CurrentValue);
		$this->website->EditValue = $this->website->CurrentValue;
		$this->website->PlaceHolder = RemoveHtml($this->website->caption());

		// main_email
		$this->main_email->EditAttrs["class"] = "form-control";
		$this->main_email->EditCustomAttributes = "";
		if (!$this->main_email->Raw)
			$this->main_email->CurrentValue = HtmlDecode($this->main_email->CurrentValue);
		$this->main_email->EditValue = $this->main_email->CurrentValue;
		$this->main_email->PlaceHolder = RemoveHtml($this->main_email->caption());

		// secondary_email
		$this->secondary_email->EditAttrs["class"] = "form-control";
		$this->secondary_email->EditCustomAttributes = "";
		if (!$this->secondary_email->Raw)
			$this->secondary_email->CurrentValue = HtmlDecode($this->secondary_email->CurrentValue);
		$this->secondary_email->EditValue = $this->secondary_email->CurrentValue;
		$this->secondary_email->PlaceHolder = RemoveHtml($this->secondary_email->caption());

		// sex
		$this->sex->EditAttrs["class"] = "form-control";
		$this->sex->EditCustomAttributes = "";
		$this->sex->EditValue = $this->sex->CurrentValue;
		$this->sex->PlaceHolder = RemoveHtml($this->sex->caption());

		// tel
		$this->tel->EditAttrs["class"] = "form-control";
		$this->tel->EditCustomAttributes = "";
		if (!$this->tel->Raw)
			$this->tel->CurrentValue = HtmlDecode($this->tel->CurrentValue);
		$this->tel->EditValue = $this->tel->CurrentValue;
		$this->tel->PlaceHolder = RemoveHtml($this->tel->caption());

		// fax
		$this->fax->EditAttrs["class"] = "form-control";
		$this->fax->EditCustomAttributes = "";
		if (!$this->fax->Raw)
			$this->fax->CurrentValue = HtmlDecode($this->fax->CurrentValue);
		$this->fax->EditValue = $this->fax->CurrentValue;
		$this->fax->PlaceHolder = RemoveHtml($this->fax->caption());

		// mobile
		$this->mobile->EditAttrs["class"] = "form-control";
		$this->mobile->EditCustomAttributes = "";
		if (!$this->mobile->Raw)
			$this->mobile->CurrentValue = HtmlDecode($this->mobile->CurrentValue);
		$this->mobile->EditValue = $this->mobile->CurrentValue;
		$this->mobile->PlaceHolder = RemoveHtml($this->mobile->caption());

		// languages
		$this->languages->EditAttrs["class"] = "form-control";
		$this->languages->EditCustomAttributes = "";
		$this->languages->EditValue = $this->languages->CurrentValue;
		$this->languages->PlaceHolder = RemoveHtml($this->languages->caption());

		// location1_id
		$this->location1_id->EditAttrs["class"] = "form-control";
		$this->location1_id->EditCustomAttributes = "";
		$this->location1_id->EditValue = $this->location1_id->CurrentValue;
		$this->location1_id->PlaceHolder = RemoveHtml($this->location1_id->caption());

		// location2_id
		$this->location2_id->EditAttrs["class"] = "form-control";
		$this->location2_id->EditCustomAttributes = "";
		$this->location2_id->EditValue = $this->location2_id->CurrentValue;
		$this->location2_id->PlaceHolder = RemoveHtml($this->location2_id->caption());

		// location3_id
		$this->location3_id->EditAttrs["class"] = "form-control";
		$this->location3_id->EditCustomAttributes = "";
		$this->location3_id->EditValue = $this->location3_id->CurrentValue;
		$this->location3_id->PlaceHolder = RemoveHtml($this->location3_id->caption());

		// location4_id
		$this->location4_id->EditAttrs["class"] = "form-control";
		$this->location4_id->EditCustomAttributes = "";
		$this->location4_id->EditValue = $this->location4_id->CurrentValue;
		$this->location4_id->PlaceHolder = RemoveHtml($this->location4_id->caption());

		// location5_id
		$this->location5_id->EditAttrs["class"] = "form-control";
		$this->location5_id->EditCustomAttributes = "";
		$this->location5_id->EditValue = $this->location5_id->CurrentValue;
		$this->location5_id->PlaceHolder = RemoveHtml($this->location5_id->caption());

		// location6_id
		$this->location6_id->EditAttrs["class"] = "form-control";
		$this->location6_id->EditCustomAttributes = "";
		$this->location6_id->EditValue = $this->location6_id->CurrentValue;
		$this->location6_id->PlaceHolder = RemoveHtml($this->location6_id->caption());

		// location7_id
		$this->location7_id->EditAttrs["class"] = "form-control";
		$this->location7_id->EditCustomAttributes = "";
		$this->location7_id->EditValue = $this->location7_id->CurrentValue;
		$this->location7_id->PlaceHolder = RemoveHtml($this->location7_id->caption());

		// location1_name
		$this->location1_name->EditAttrs["class"] = "form-control";
		$this->location1_name->EditCustomAttributes = "";
		if (!$this->location1_name->Raw)
			$this->location1_name->CurrentValue = HtmlDecode($this->location1_name->CurrentValue);
		$this->location1_name->EditValue = $this->location1_name->CurrentValue;
		$this->location1_name->PlaceHolder = RemoveHtml($this->location1_name->caption());

		// location2_name
		$this->location2_name->EditAttrs["class"] = "form-control";
		$this->location2_name->EditCustomAttributes = "";
		if (!$this->location2_name->Raw)
			$this->location2_name->CurrentValue = HtmlDecode($this->location2_name->CurrentValue);
		$this->location2_name->EditValue = $this->location2_name->CurrentValue;
		$this->location2_name->PlaceHolder = RemoveHtml($this->location2_name->caption());

		// location3_name
		$this->location3_name->EditAttrs["class"] = "form-control";
		$this->location3_name->EditCustomAttributes = "";
		if (!$this->location3_name->Raw)
			$this->location3_name->CurrentValue = HtmlDecode($this->location3_name->CurrentValue);
		$this->location3_name->EditValue = $this->location3_name->CurrentValue;
		$this->location3_name->PlaceHolder = RemoveHtml($this->location3_name->caption());

		// location4_name
		$this->location4_name->EditAttrs["class"] = "form-control";
		$this->location4_name->EditCustomAttributes = "";
		if (!$this->location4_name->Raw)
			$this->location4_name->CurrentValue = HtmlDecode($this->location4_name->CurrentValue);
		$this->location4_name->EditValue = $this->location4_name->CurrentValue;
		$this->location4_name->PlaceHolder = RemoveHtml($this->location4_name->caption());

		// location5_name
		$this->location5_name->EditAttrs["class"] = "form-control";
		$this->location5_name->EditCustomAttributes = "";
		if (!$this->location5_name->Raw)
			$this->location5_name->CurrentValue = HtmlDecode($this->location5_name->CurrentValue);
		$this->location5_name->EditValue = $this->location5_name->CurrentValue;
		$this->location5_name->PlaceHolder = RemoveHtml($this->location5_name->caption());

		// location6_name
		$this->location6_name->EditAttrs["class"] = "form-control";
		$this->location6_name->EditCustomAttributes = "";
		if (!$this->location6_name->Raw)
			$this->location6_name->CurrentValue = HtmlDecode($this->location6_name->CurrentValue);
		$this->location6_name->EditValue = $this->location6_name->CurrentValue;
		$this->location6_name->PlaceHolder = RemoveHtml($this->location6_name->caption());

		// location7_name
		$this->location7_name->EditAttrs["class"] = "form-control";
		$this->location7_name->EditCustomAttributes = "";
		if (!$this->location7_name->Raw)
			$this->location7_name->CurrentValue = HtmlDecode($this->location7_name->CurrentValue);
		$this->location7_name->EditValue = $this->location7_name->CurrentValue;
		$this->location7_name->PlaceHolder = RemoveHtml($this->location7_name->caption());

		// show_address
		$this->show_address->EditAttrs["class"] = "form-control";
		$this->show_address->EditCustomAttributes = "";
		$this->show_address->EditValue = $this->show_address->CurrentValue;
		$this->show_address->PlaceHolder = RemoveHtml($this->show_address->caption());

		// zip_id
		$this->zip_id->EditAttrs["class"] = "form-control";
		$this->zip_id->EditCustomAttributes = "";
		$this->zip_id->EditValue = $this->zip_id->CurrentValue;
		$this->zip_id->PlaceHolder = RemoveHtml($this->zip_id->caption());

		// zip_name
		$this->zip_name->EditAttrs["class"] = "form-control";
		$this->zip_name->EditCustomAttributes = "";
		if (!$this->zip_name->Raw)
			$this->zip_name->CurrentValue = HtmlDecode($this->zip_name->CurrentValue);
		$this->zip_name->EditValue = $this->zip_name->CurrentValue;
		$this->zip_name->PlaceHolder = RemoveHtml($this->zip_name->caption());

		// maccess_num_prop
		$this->maccess_num_prop->EditAttrs["class"] = "form-control";
		$this->maccess_num_prop->EditCustomAttributes = "";
		$this->maccess_num_prop->EditValue = $this->maccess_num_prop->CurrentValue;
		$this->maccess_num_prop->PlaceHolder = RemoveHtml($this->maccess_num_prop->caption());

		// maccess_num_feat
		$this->maccess_num_feat->EditAttrs["class"] = "form-control";
		$this->maccess_num_feat->EditCustomAttributes = "";
		$this->maccess_num_feat->EditValue = $this->maccess_num_feat->CurrentValue;
		$this->maccess_num_feat->PlaceHolder = RemoveHtml($this->maccess_num_feat->caption());

		// maccess_num_hot
		$this->maccess_num_hot->EditAttrs["class"] = "form-control";
		$this->maccess_num_hot->EditCustomAttributes = "";
		$this->maccess_num_hot->EditValue = $this->maccess_num_hot->CurrentValue;
		$this->maccess_num_hot->PlaceHolder = RemoveHtml($this->maccess_num_hot->caption());

		// maccess_num_pic
		$this->maccess_num_pic->EditAttrs["class"] = "form-control";
		$this->maccess_num_pic->EditCustomAttributes = "";
		$this->maccess_num_pic->EditValue = $this->maccess_num_pic->CurrentValue;
		$this->maccess_num_pic->PlaceHolder = RemoveHtml($this->maccess_num_pic->caption());

		// maccess_period
		$this->maccess_period->EditAttrs["class"] = "form-control";
		$this->maccess_period->EditCustomAttributes = "";
		$this->maccess_period->EditValue = $this->maccess_period->CurrentValue;
		$this->maccess_period->PlaceHolder = RemoveHtml($this->maccess_period->caption());

		// maccess_price
		$this->maccess_price->EditAttrs["class"] = "form-control";
		$this->maccess_price->EditCustomAttributes = "";
		$this->maccess_price->EditValue = $this->maccess_price->CurrentValue;
		$this->maccess_price->PlaceHolder = RemoveHtml($this->maccess_price->caption());
		if (strval($this->maccess_price->EditValue) != "" && is_numeric($this->maccess_price->EditValue))
			$this->maccess_price->EditValue = FormatNumber($this->maccess_price->EditValue, -2, -2, -2, -2);
		

		// maccess_price_unit
		$this->maccess_price_unit->EditAttrs["class"] = "form-control";
		$this->maccess_price_unit->EditCustomAttributes = "";
		$this->maccess_price_unit->EditValue = $this->maccess_price_unit->CurrentValue;
		$this->maccess_price_unit->PlaceHolder = RemoveHtml($this->maccess_price_unit->caption());

		// maccess_lrestrict
		$this->maccess_lrestrict->EditAttrs["class"] = "form-control";
		$this->maccess_lrestrict->EditCustomAttributes = "";
		$this->maccess_lrestrict->EditValue = $this->maccess_lrestrict->CurrentValue;
		$this->maccess_lrestrict->PlaceHolder = RemoveHtml($this->maccess_lrestrict->caption());

		// maccess_listings
		$this->maccess_listings->EditAttrs["class"] = "form-control";
		$this->maccess_listings->EditCustomAttributes = "";
		if (!$this->maccess_listings->Raw)
			$this->maccess_listings->CurrentValue = HtmlDecode($this->maccess_listings->CurrentValue);
		$this->maccess_listings->EditValue = $this->maccess_listings->CurrentValue;
		$this->maccess_listings->PlaceHolder = RemoveHtml($this->maccess_listings->caption());

		// maccess_ptrestrict
		$this->maccess_ptrestrict->EditAttrs["class"] = "form-control";
		$this->maccess_ptrestrict->EditCustomAttributes = "";
		$this->maccess_ptrestrict->EditValue = $this->maccess_ptrestrict->CurrentValue;
		$this->maccess_ptrestrict->PlaceHolder = RemoveHtml($this->maccess_ptrestrict->caption());

		// maccess_property_types
		$this->maccess_property_types->EditAttrs["class"] = "form-control";
		$this->maccess_property_types->EditCustomAttributes = "";
		if (!$this->maccess_property_types->Raw)
			$this->maccess_property_types->CurrentValue = HtmlDecode($this->maccess_property_types->CurrentValue);
		$this->maccess_property_types->EditValue = $this->maccess_property_types->CurrentValue;
		$this->maccess_property_types->PlaceHolder = RemoveHtml($this->maccess_property_types->caption());

		// maccess_renewable
		$this->maccess_renewable->EditAttrs["class"] = "form-control";
		$this->maccess_renewable->EditCustomAttributes = "";
		$this->maccess_renewable->EditValue = $this->maccess_renewable->CurrentValue;
		$this->maccess_renewable->PlaceHolder = RemoveHtml($this->maccess_renewable->caption());

		// maccess_renewal_price
		$this->maccess_renewal_price->EditAttrs["class"] = "form-control";
		$this->maccess_renewal_price->EditCustomAttributes = "";
		$this->maccess_renewal_price->EditValue = $this->maccess_renewal_price->CurrentValue;
		$this->maccess_renewal_price->PlaceHolder = RemoveHtml($this->maccess_renewal_price->caption());
		if (strval($this->maccess_renewal_price->EditValue) != "" && is_numeric($this->maccess_renewal_price->EditValue))
			$this->maccess_renewal_price->EditValue = FormatNumber($this->maccess_renewal_price->EditValue, -2, -2, -2, -2);
		

		// maccess_renewal_price_unit
		$this->maccess_renewal_price_unit->EditAttrs["class"] = "form-control";
		$this->maccess_renewal_price_unit->EditCustomAttributes = "";
		$this->maccess_renewal_price_unit->EditValue = $this->maccess_renewal_price_unit->CurrentValue;
		$this->maccess_renewal_price_unit->PlaceHolder = RemoveHtml($this->maccess_renewal_price_unit->caption());

		// maccess_upgradable
		$this->maccess_upgradable->EditAttrs["class"] = "form-control";
		$this->maccess_upgradable->EditCustomAttributes = "";
		$this->maccess_upgradable->EditValue = $this->maccess_upgradable->CurrentValue;
		$this->maccess_upgradable->PlaceHolder = RemoveHtml($this->maccess_upgradable->caption());

		// maccess_upgradable_to
		$this->maccess_upgradable_to->EditAttrs["class"] = "form-control";
		$this->maccess_upgradable_to->EditCustomAttributes = "";
		$this->maccess_upgradable_to->EditValue = $this->maccess_upgradable_to->CurrentValue;
		$this->maccess_upgradable_to->PlaceHolder = RemoveHtml($this->maccess_upgradable_to->caption());

		// maccess_short_description
		$this->maccess_short_description->EditAttrs["class"] = "form-control";
		$this->maccess_short_description->EditCustomAttributes = "";
		$this->maccess_short_description->EditValue = $this->maccess_short_description->CurrentValue;
		$this->maccess_short_description->PlaceHolder = RemoveHtml($this->maccess_short_description->caption());

		// maccess_long_description
		$this->maccess_long_description->EditAttrs["class"] = "form-control";
		$this->maccess_long_description->EditCustomAttributes = "";
		$this->maccess_long_description->EditValue = $this->maccess_long_description->CurrentValue;
		$this->maccess_long_description->PlaceHolder = RemoveHtml($this->maccess_long_description->caption());

		// maccess_wpl_color
		$this->maccess_wpl_color->EditAttrs["class"] = "form-control";
		$this->maccess_wpl_color->EditCustomAttributes = "";
		if (!$this->maccess_wpl_color->Raw)
			$this->maccess_wpl_color->CurrentValue = HtmlDecode($this->maccess_wpl_color->CurrentValue);
		$this->maccess_wpl_color->EditValue = $this->maccess_wpl_color->CurrentValue;
		$this->maccess_wpl_color->PlaceHolder = RemoveHtml($this->maccess_wpl_color->caption());

		// expired
		$this->expired->EditAttrs["class"] = "form-control";
		$this->expired->EditCustomAttributes = "";
		$this->expired->EditValue = $this->expired->CurrentValue;
		$this->expired->PlaceHolder = RemoveHtml($this->expired->caption());

		// expiry_date
		$this->expiry_date->EditAttrs["class"] = "form-control";
		$this->expiry_date->EditCustomAttributes = "";
		$this->expiry_date->EditValue = FormatDateTime($this->expiry_date->CurrentValue, 8);
		$this->expiry_date->PlaceHolder = RemoveHtml($this->expiry_date->caption());

		// textsearch
		$this->textsearch->EditAttrs["class"] = "form-control";
		$this->textsearch->EditCustomAttributes = "";
		$this->textsearch->EditValue = $this->textsearch->CurrentValue;
		$this->textsearch->PlaceHolder = RemoveHtml($this->textsearch->caption());

		// location_text
		$this->location_text->EditAttrs["class"] = "form-control";
		$this->location_text->EditCustomAttributes = "";
		if (!$this->location_text->Raw)
			$this->location_text->CurrentValue = HtmlDecode($this->location_text->CurrentValue);
		$this->location_text->EditValue = $this->location_text->CurrentValue;
		$this->location_text->PlaceHolder = RemoveHtml($this->location_text->caption());

		// rendered
		$this->rendered->EditAttrs["class"] = "form-control";
		$this->rendered->EditCustomAttributes = "";
		$this->rendered->EditValue = $this->rendered->CurrentValue;
		$this->rendered->PlaceHolder = RemoveHtml($this->rendered->caption());

		// last_modified_time_stamp
		$this->last_modified_time_stamp->EditAttrs["class"] = "form-control";
		$this->last_modified_time_stamp->EditCustomAttributes = "";
		$this->last_modified_time_stamp->EditValue = FormatDateTime($this->last_modified_time_stamp->CurrentValue, 8);
		$this->last_modified_time_stamp->PlaceHolder = RemoveHtml($this->last_modified_time_stamp->caption());

		// profile_picture
		$this->profile_picture->EditAttrs["class"] = "form-control";
		$this->profile_picture->EditCustomAttributes = "";
		if (!$this->profile_picture->Raw)
			$this->profile_picture->CurrentValue = HtmlDecode($this->profile_picture->CurrentValue);
		$this->profile_picture->EditValue = $this->profile_picture->CurrentValue;
		$this->profile_picture->PlaceHolder = RemoveHtml($this->profile_picture->caption());

		// company_logo
		$this->company_logo->EditAttrs["class"] = "form-control";
		$this->company_logo->EditCustomAttributes = "";
		if (!$this->company_logo->Raw)
			$this->company_logo->CurrentValue = HtmlDecode($this->company_logo->CurrentValue);
		$this->company_logo->EditValue = $this->company_logo->CurrentValue;
		$this->company_logo->PlaceHolder = RemoveHtml($this->company_logo->caption());

		// maccess_lrestrict_pshow
		$this->maccess_lrestrict_pshow->EditAttrs["class"] = "form-control";
		$this->maccess_lrestrict_pshow->EditCustomAttributes = "";
		$this->maccess_lrestrict_pshow->EditValue = $this->maccess_lrestrict_pshow->CurrentValue;
		$this->maccess_lrestrict_pshow->PlaceHolder = RemoveHtml($this->maccess_lrestrict_pshow->caption());

		// maccess_ptrestrict_pshow
		$this->maccess_ptrestrict_pshow->EditAttrs["class"] = "form-control";
		$this->maccess_ptrestrict_pshow->EditCustomAttributes = "";
		$this->maccess_ptrestrict_pshow->EditValue = $this->maccess_ptrestrict_pshow->CurrentValue;
		$this->maccess_ptrestrict_pshow->PlaceHolder = RemoveHtml($this->maccess_ptrestrict_pshow->caption());

		// maccess_listings_pshow
		$this->maccess_listings_pshow->EditAttrs["class"] = "form-control";
		$this->maccess_listings_pshow->EditCustomAttributes = "";
		if (!$this->maccess_listings_pshow->Raw)
			$this->maccess_listings_pshow->CurrentValue = HtmlDecode($this->maccess_listings_pshow->CurrentValue);
		$this->maccess_listings_pshow->EditValue = $this->maccess_listings_pshow->CurrentValue;
		$this->maccess_listings_pshow->PlaceHolder = RemoveHtml($this->maccess_listings_pshow->caption());

		// maccess_property_types_pshow
		$this->maccess_property_types_pshow->EditAttrs["class"] = "form-control";
		$this->maccess_property_types_pshow->EditCustomAttributes = "";
		if (!$this->maccess_property_types_pshow->Raw)
			$this->maccess_property_types_pshow->CurrentValue = HtmlDecode($this->maccess_property_types_pshow->CurrentValue);
		$this->maccess_property_types_pshow->EditValue = $this->maccess_property_types_pshow->CurrentValue;
		$this->maccess_property_types_pshow->PlaceHolder = RemoveHtml($this->maccess_property_types_pshow->caption());

		// maccess_lrestrict_plisting
		$this->maccess_lrestrict_plisting->EditAttrs["class"] = "form-control";
		$this->maccess_lrestrict_plisting->EditCustomAttributes = "";
		$this->maccess_lrestrict_plisting->EditValue = $this->maccess_lrestrict_plisting->CurrentValue;
		$this->maccess_lrestrict_plisting->PlaceHolder = RemoveHtml($this->maccess_lrestrict_plisting->caption());

		// maccess_ptrestrict_plisting
		$this->maccess_ptrestrict_plisting->EditAttrs["class"] = "form-control";
		$this->maccess_ptrestrict_plisting->EditCustomAttributes = "";
		$this->maccess_ptrestrict_plisting->EditValue = $this->maccess_ptrestrict_plisting->CurrentValue;
		$this->maccess_ptrestrict_plisting->PlaceHolder = RemoveHtml($this->maccess_ptrestrict_plisting->caption());

		// maccess_listings_plisting
		$this->maccess_listings_plisting->EditAttrs["class"] = "form-control";
		$this->maccess_listings_plisting->EditCustomAttributes = "";
		if (!$this->maccess_listings_plisting->Raw)
			$this->maccess_listings_plisting->CurrentValue = HtmlDecode($this->maccess_listings_plisting->CurrentValue);
		$this->maccess_listings_plisting->EditValue = $this->maccess_listings_plisting->CurrentValue;
		$this->maccess_listings_plisting->PlaceHolder = RemoveHtml($this->maccess_listings_plisting->caption());

		// maccess_property_types_plisting
		$this->maccess_property_types_plisting->EditAttrs["class"] = "form-control";
		$this->maccess_property_types_plisting->EditCustomAttributes = "";
		if (!$this->maccess_property_types_plisting->Raw)
			$this->maccess_property_types_plisting->CurrentValue = HtmlDecode($this->maccess_property_types_plisting->CurrentValue);
		$this->maccess_property_types_plisting->EditValue = $this->maccess_property_types_plisting->CurrentValue;
		$this->maccess_property_types_plisting->PlaceHolder = RemoveHtml($this->maccess_property_types_plisting->caption());

		// access_clone
		$this->access_clone->EditAttrs["class"] = "form-control";
		$this->access_clone->EditCustomAttributes = "";
		$this->access_clone->EditValue = $this->access_clone->CurrentValue;
		$this->access_clone->PlaceHolder = RemoveHtml($this->access_clone->caption());

		// access_propertystats
		$this->access_propertystats->EditAttrs["class"] = "form-control";
		$this->access_propertystats->EditCustomAttributes = "";
		$this->access_propertystats->EditValue = $this->access_propertystats->CurrentValue;
		$this->access_propertystats->PlaceHolder = RemoveHtml($this->access_propertystats->caption());

		// maccess_crm
		$this->maccess_crm->EditAttrs["class"] = "form-control";
		$this->maccess_crm->EditCustomAttributes = "";
		$this->maccess_crm->EditValue = $this->maccess_crm->CurrentValue;
		$this->maccess_crm->PlaceHolder = RemoveHtml($this->maccess_crm->caption());

		// online_status
		$this->online_status->EditAttrs["class"] = "form-control";
		$this->online_status->EditCustomAttributes = "";
		if (!$this->online_status->Raw)
			$this->online_status->CurrentValue = HtmlDecode($this->online_status->CurrentValue);
		$this->online_status->EditValue = $this->online_status->CurrentValue;
		$this->online_status->PlaceHolder = RemoveHtml($this->online_status->caption());

		// access_CRM
		$this->access_CRM->EditAttrs["class"] = "form-control";
		$this->access_CRM->EditCustomAttributes = "";
		$this->access_CRM->EditValue = $this->access_CRM->CurrentValue;
		$this->access_CRM->PlaceHolder = RemoveHtml($this->access_CRM->caption());

		// crm_selected_fields
		$this->crm_selected_fields->EditAttrs["class"] = "form-control";
		$this->crm_selected_fields->EditCustomAttributes = "";
		$this->crm_selected_fields->EditValue = $this->crm_selected_fields->CurrentValue;
		$this->crm_selected_fields->PlaceHolder = RemoveHtml($this->crm_selected_fields->caption());

		// crm_cookies
		$this->crm_cookies->EditAttrs["class"] = "form-control";
		$this->crm_cookies->EditCustomAttributes = "";
		$this->crm_cookies->EditValue = $this->crm_cookies->CurrentValue;
		$this->crm_cookies->PlaceHolder = RemoveHtml($this->crm_cookies->caption());

		// rendered_en_us
		$this->rendered_en_us->EditAttrs["class"] = "form-control";
		$this->rendered_en_us->EditCustomAttributes = "";
		$this->rendered_en_us->EditValue = $this->rendered_en_us->CurrentValue;
		$this->rendered_en_us->PlaceHolder = RemoveHtml($this->rendered_en_us->caption());

		// textsearch_en_us
		$this->textsearch_en_us->EditAttrs["class"] = "form-control";
		$this->textsearch_en_us->EditCustomAttributes = "";
		$this->textsearch_en_us->EditValue = $this->textsearch_en_us->CurrentValue;
		$this->textsearch_en_us->PlaceHolder = RemoveHtml($this->textsearch_en_us->caption());

		// rendered_fr_fr
		$this->rendered_fr_fr->EditAttrs["class"] = "form-control";
		$this->rendered_fr_fr->EditCustomAttributes = "";
		$this->rendered_fr_fr->EditValue = $this->rendered_fr_fr->CurrentValue;
		$this->rendered_fr_fr->PlaceHolder = RemoveHtml($this->rendered_fr_fr->caption());

		// textsearch_fr_fr
		$this->textsearch_fr_fr->EditAttrs["class"] = "form-control";
		$this->textsearch_fr_fr->EditCustomAttributes = "";
		$this->textsearch_fr_fr->EditValue = $this->textsearch_fr_fr->CurrentValue;
		$this->textsearch_fr_fr->PlaceHolder = RemoveHtml($this->textsearch_fr_fr->caption());

		// Call Row Rendered event
		$this->Row_Rendered();
	}

	// Aggregate list row values
	public function aggregateListRowValues()
	{
	}

	// Aggregate list row (for rendering)
	public function aggregateListRow()
	{

		// Call Row Rendered event
		$this->Row_Rendered();
	}

	// Export data in HTML/CSV/Word/Excel/Email/PDF format
	public function exportDocument($doc, $recordset, $startRec = 1, $stopRec = 1, $exportPageType = "")
	{
		if (!$recordset || !$doc)
			return;
		if (!$doc->ExportCustom) {

			// Write header
			$doc->exportTableHeader();
			if ($doc->Horizontal) { // Horizontal format, write header
				$doc->beginExportRow();
				if ($exportPageType == "view") {
					$doc->exportCaption($this->id);
					$doc->exportCaption($this->membership_name);
					$doc->exportCaption($this->membership_id);
					$doc->exportCaption($this->membership_type);
					$doc->exportCaption($this->_index);
					$doc->exportCaption($this->access_propertywizard);
					$doc->exportCaption($this->access_propertyshow);
					$doc->exportCaption($this->access_propertylisting);
					$doc->exportCaption($this->access_profilewizard);
					$doc->exportCaption($this->access_confirm);
					$doc->exportCaption($this->access_propertymanager);
					$doc->exportCaption($this->access_delete);
					$doc->exportCaption($this->access_public_profile);
					$doc->exportCaption($this->access_change_user);
					$doc->exportCaption($this->access_receive_notifications);
					$doc->exportCaption($this->first_name);
					$doc->exportCaption($this->last_name);
					$doc->exportCaption($this->about);
					$doc->exportCaption($this->company_name);
					$doc->exportCaption($this->company_address);
					$doc->exportCaption($this->website);
					$doc->exportCaption($this->main_email);
					$doc->exportCaption($this->secondary_email);
					$doc->exportCaption($this->sex);
					$doc->exportCaption($this->tel);
					$doc->exportCaption($this->fax);
					$doc->exportCaption($this->mobile);
					$doc->exportCaption($this->languages);
					$doc->exportCaption($this->location1_id);
					$doc->exportCaption($this->location2_id);
					$doc->exportCaption($this->location3_id);
					$doc->exportCaption($this->location4_id);
					$doc->exportCaption($this->location5_id);
					$doc->exportCaption($this->location6_id);
					$doc->exportCaption($this->location7_id);
					$doc->exportCaption($this->location1_name);
					$doc->exportCaption($this->location2_name);
					$doc->exportCaption($this->location3_name);
					$doc->exportCaption($this->location4_name);
					$doc->exportCaption($this->location5_name);
					$doc->exportCaption($this->location6_name);
					$doc->exportCaption($this->location7_name);
					$doc->exportCaption($this->show_address);
					$doc->exportCaption($this->zip_id);
					$doc->exportCaption($this->zip_name);
					$doc->exportCaption($this->maccess_num_prop);
					$doc->exportCaption($this->maccess_num_feat);
					$doc->exportCaption($this->maccess_num_hot);
					$doc->exportCaption($this->maccess_num_pic);
					$doc->exportCaption($this->maccess_period);
					$doc->exportCaption($this->maccess_price);
					$doc->exportCaption($this->maccess_price_unit);
					$doc->exportCaption($this->maccess_lrestrict);
					$doc->exportCaption($this->maccess_listings);
					$doc->exportCaption($this->maccess_ptrestrict);
					$doc->exportCaption($this->maccess_property_types);
					$doc->exportCaption($this->maccess_renewable);
					$doc->exportCaption($this->maccess_renewal_price);
					$doc->exportCaption($this->maccess_renewal_price_unit);
					$doc->exportCaption($this->maccess_upgradable);
					$doc->exportCaption($this->maccess_upgradable_to);
					$doc->exportCaption($this->maccess_short_description);
					$doc->exportCaption($this->maccess_long_description);
					$doc->exportCaption($this->maccess_wpl_color);
					$doc->exportCaption($this->expired);
					$doc->exportCaption($this->expiry_date);
					$doc->exportCaption($this->textsearch);
					$doc->exportCaption($this->location_text);
					$doc->exportCaption($this->rendered);
					$doc->exportCaption($this->last_modified_time_stamp);
					$doc->exportCaption($this->profile_picture);
					$doc->exportCaption($this->company_logo);
					$doc->exportCaption($this->maccess_lrestrict_pshow);
					$doc->exportCaption($this->maccess_ptrestrict_pshow);
					$doc->exportCaption($this->maccess_listings_pshow);
					$doc->exportCaption($this->maccess_property_types_pshow);
					$doc->exportCaption($this->maccess_lrestrict_plisting);
					$doc->exportCaption($this->maccess_ptrestrict_plisting);
					$doc->exportCaption($this->maccess_listings_plisting);
					$doc->exportCaption($this->maccess_property_types_plisting);
					$doc->exportCaption($this->access_clone);
					$doc->exportCaption($this->access_propertystats);
					$doc->exportCaption($this->maccess_crm);
					$doc->exportCaption($this->online_status);
					$doc->exportCaption($this->access_CRM);
					$doc->exportCaption($this->crm_selected_fields);
					$doc->exportCaption($this->crm_cookies);
					$doc->exportCaption($this->rendered_en_us);
					$doc->exportCaption($this->textsearch_en_us);
					$doc->exportCaption($this->rendered_fr_fr);
					$doc->exportCaption($this->textsearch_fr_fr);
				} else {
					$doc->exportCaption($this->id);
					$doc->exportCaption($this->membership_name);
					$doc->exportCaption($this->membership_id);
					$doc->exportCaption($this->membership_type);
					$doc->exportCaption($this->_index);
					$doc->exportCaption($this->access_propertywizard);
					$doc->exportCaption($this->access_propertyshow);
					$doc->exportCaption($this->access_propertylisting);
					$doc->exportCaption($this->access_profilewizard);
					$doc->exportCaption($this->access_confirm);
					$doc->exportCaption($this->access_propertymanager);
					$doc->exportCaption($this->access_delete);
					$doc->exportCaption($this->access_public_profile);
					$doc->exportCaption($this->access_change_user);
					$doc->exportCaption($this->access_receive_notifications);
					$doc->exportCaption($this->first_name);
					$doc->exportCaption($this->last_name);
					$doc->exportCaption($this->company_name);
					$doc->exportCaption($this->company_address);
					$doc->exportCaption($this->website);
					$doc->exportCaption($this->main_email);
					$doc->exportCaption($this->secondary_email);
					$doc->exportCaption($this->sex);
					$doc->exportCaption($this->tel);
					$doc->exportCaption($this->fax);
					$doc->exportCaption($this->mobile);
					$doc->exportCaption($this->location1_id);
					$doc->exportCaption($this->location2_id);
					$doc->exportCaption($this->location3_id);
					$doc->exportCaption($this->location4_id);
					$doc->exportCaption($this->location5_id);
					$doc->exportCaption($this->location6_id);
					$doc->exportCaption($this->location7_id);
					$doc->exportCaption($this->location1_name);
					$doc->exportCaption($this->location2_name);
					$doc->exportCaption($this->location3_name);
					$doc->exportCaption($this->location4_name);
					$doc->exportCaption($this->location5_name);
					$doc->exportCaption($this->location6_name);
					$doc->exportCaption($this->location7_name);
					$doc->exportCaption($this->show_address);
					$doc->exportCaption($this->zip_id);
					$doc->exportCaption($this->zip_name);
					$doc->exportCaption($this->maccess_num_prop);
					$doc->exportCaption($this->maccess_num_feat);
					$doc->exportCaption($this->maccess_num_hot);
					$doc->exportCaption($this->maccess_num_pic);
					$doc->exportCaption($this->maccess_period);
					$doc->exportCaption($this->maccess_price);
					$doc->exportCaption($this->maccess_price_unit);
					$doc->exportCaption($this->maccess_lrestrict);
					$doc->exportCaption($this->maccess_listings);
					$doc->exportCaption($this->maccess_ptrestrict);
					$doc->exportCaption($this->maccess_property_types);
					$doc->exportCaption($this->maccess_renewable);
					$doc->exportCaption($this->maccess_renewal_price);
					$doc->exportCaption($this->maccess_renewal_price_unit);
					$doc->exportCaption($this->maccess_upgradable);
					$doc->exportCaption($this->maccess_wpl_color);
					$doc->exportCaption($this->expired);
					$doc->exportCaption($this->expiry_date);
					$doc->exportCaption($this->location_text);
					$doc->exportCaption($this->last_modified_time_stamp);
					$doc->exportCaption($this->profile_picture);
					$doc->exportCaption($this->company_logo);
					$doc->exportCaption($this->maccess_lrestrict_pshow);
					$doc->exportCaption($this->maccess_ptrestrict_pshow);
					$doc->exportCaption($this->maccess_listings_pshow);
					$doc->exportCaption($this->maccess_property_types_pshow);
					$doc->exportCaption($this->maccess_lrestrict_plisting);
					$doc->exportCaption($this->maccess_ptrestrict_plisting);
					$doc->exportCaption($this->maccess_listings_plisting);
					$doc->exportCaption($this->maccess_property_types_plisting);
					$doc->exportCaption($this->access_clone);
					$doc->exportCaption($this->access_propertystats);
					$doc->exportCaption($this->online_status);
					$doc->exportCaption($this->access_CRM);
				}
				$doc->endExportRow();
			}
		}

		// Move to first record
		$recCnt = $startRec - 1;
		if (!$recordset->EOF) {
			$recordset->moveFirst();
			if ($startRec > 1)
				$recordset->move($startRec - 1);
		}
		while (!$recordset->EOF && $recCnt < $stopRec) {
			$recCnt++;
			if ($recCnt >= $startRec) {
				$rowCnt = $recCnt - $startRec + 1;

				// Page break
				if ($this->ExportPageBreakCount > 0) {
					if ($rowCnt > 1 && ($rowCnt - 1) % $this->ExportPageBreakCount == 0)
						$doc->exportPageBreak();
				}
				$this->loadListRowValues($recordset);

				// Render row
				$this->RowType = ROWTYPE_VIEW; // Render view
				$this->resetAttributes();
				$this->renderListRow();
				if (!$doc->ExportCustom) {
					$doc->beginExportRow($rowCnt); // Allow CSS styles if enabled
					if ($exportPageType == "view") {
						$doc->exportField($this->id);
						$doc->exportField($this->membership_name);
						$doc->exportField($this->membership_id);
						$doc->exportField($this->membership_type);
						$doc->exportField($this->_index);
						$doc->exportField($this->access_propertywizard);
						$doc->exportField($this->access_propertyshow);
						$doc->exportField($this->access_propertylisting);
						$doc->exportField($this->access_profilewizard);
						$doc->exportField($this->access_confirm);
						$doc->exportField($this->access_propertymanager);
						$doc->exportField($this->access_delete);
						$doc->exportField($this->access_public_profile);
						$doc->exportField($this->access_change_user);
						$doc->exportField($this->access_receive_notifications);
						$doc->exportField($this->first_name);
						$doc->exportField($this->last_name);
						$doc->exportField($this->about);
						$doc->exportField($this->company_name);
						$doc->exportField($this->company_address);
						$doc->exportField($this->website);
						$doc->exportField($this->main_email);
						$doc->exportField($this->secondary_email);
						$doc->exportField($this->sex);
						$doc->exportField($this->tel);
						$doc->exportField($this->fax);
						$doc->exportField($this->mobile);
						$doc->exportField($this->languages);
						$doc->exportField($this->location1_id);
						$doc->exportField($this->location2_id);
						$doc->exportField($this->location3_id);
						$doc->exportField($this->location4_id);
						$doc->exportField($this->location5_id);
						$doc->exportField($this->location6_id);
						$doc->exportField($this->location7_id);
						$doc->exportField($this->location1_name);
						$doc->exportField($this->location2_name);
						$doc->exportField($this->location3_name);
						$doc->exportField($this->location4_name);
						$doc->exportField($this->location5_name);
						$doc->exportField($this->location6_name);
						$doc->exportField($this->location7_name);
						$doc->exportField($this->show_address);
						$doc->exportField($this->zip_id);
						$doc->exportField($this->zip_name);
						$doc->exportField($this->maccess_num_prop);
						$doc->exportField($this->maccess_num_feat);
						$doc->exportField($this->maccess_num_hot);
						$doc->exportField($this->maccess_num_pic);
						$doc->exportField($this->maccess_period);
						$doc->exportField($this->maccess_price);
						$doc->exportField($this->maccess_price_unit);
						$doc->exportField($this->maccess_lrestrict);
						$doc->exportField($this->maccess_listings);
						$doc->exportField($this->maccess_ptrestrict);
						$doc->exportField($this->maccess_property_types);
						$doc->exportField($this->maccess_renewable);
						$doc->exportField($this->maccess_renewal_price);
						$doc->exportField($this->maccess_renewal_price_unit);
						$doc->exportField($this->maccess_upgradable);
						$doc->exportField($this->maccess_upgradable_to);
						$doc->exportField($this->maccess_short_description);
						$doc->exportField($this->maccess_long_description);
						$doc->exportField($this->maccess_wpl_color);
						$doc->exportField($this->expired);
						$doc->exportField($this->expiry_date);
						$doc->exportField($this->textsearch);
						$doc->exportField($this->location_text);
						$doc->exportField($this->rendered);
						$doc->exportField($this->last_modified_time_stamp);
						$doc->exportField($this->profile_picture);
						$doc->exportField($this->company_logo);
						$doc->exportField($this->maccess_lrestrict_pshow);
						$doc->exportField($this->maccess_ptrestrict_pshow);
						$doc->exportField($this->maccess_listings_pshow);
						$doc->exportField($this->maccess_property_types_pshow);
						$doc->exportField($this->maccess_lrestrict_plisting);
						$doc->exportField($this->maccess_ptrestrict_plisting);
						$doc->exportField($this->maccess_listings_plisting);
						$doc->exportField($this->maccess_property_types_plisting);
						$doc->exportField($this->access_clone);
						$doc->exportField($this->access_propertystats);
						$doc->exportField($this->maccess_crm);
						$doc->exportField($this->online_status);
						$doc->exportField($this->access_CRM);
						$doc->exportField($this->crm_selected_fields);
						$doc->exportField($this->crm_cookies);
						$doc->exportField($this->rendered_en_us);
						$doc->exportField($this->textsearch_en_us);
						$doc->exportField($this->rendered_fr_fr);
						$doc->exportField($this->textsearch_fr_fr);
					} else {
						$doc->exportField($this->id);
						$doc->exportField($this->membership_name);
						$doc->exportField($this->membership_id);
						$doc->exportField($this->membership_type);
						$doc->exportField($this->_index);
						$doc->exportField($this->access_propertywizard);
						$doc->exportField($this->access_propertyshow);
						$doc->exportField($this->access_propertylisting);
						$doc->exportField($this->access_profilewizard);
						$doc->exportField($this->access_confirm);
						$doc->exportField($this->access_propertymanager);
						$doc->exportField($this->access_delete);
						$doc->exportField($this->access_public_profile);
						$doc->exportField($this->access_change_user);
						$doc->exportField($this->access_receive_notifications);
						$doc->exportField($this->first_name);
						$doc->exportField($this->last_name);
						$doc->exportField($this->company_name);
						$doc->exportField($this->company_address);
						$doc->exportField($this->website);
						$doc->exportField($this->main_email);
						$doc->exportField($this->secondary_email);
						$doc->exportField($this->sex);
						$doc->exportField($this->tel);
						$doc->exportField($this->fax);
						$doc->exportField($this->mobile);
						$doc->exportField($this->location1_id);
						$doc->exportField($this->location2_id);
						$doc->exportField($this->location3_id);
						$doc->exportField($this->location4_id);
						$doc->exportField($this->location5_id);
						$doc->exportField($this->location6_id);
						$doc->exportField($this->location7_id);
						$doc->exportField($this->location1_name);
						$doc->exportField($this->location2_name);
						$doc->exportField($this->location3_name);
						$doc->exportField($this->location4_name);
						$doc->exportField($this->location5_name);
						$doc->exportField($this->location6_name);
						$doc->exportField($this->location7_name);
						$doc->exportField($this->show_address);
						$doc->exportField($this->zip_id);
						$doc->exportField($this->zip_name);
						$doc->exportField($this->maccess_num_prop);
						$doc->exportField($this->maccess_num_feat);
						$doc->exportField($this->maccess_num_hot);
						$doc->exportField($this->maccess_num_pic);
						$doc->exportField($this->maccess_period);
						$doc->exportField($this->maccess_price);
						$doc->exportField($this->maccess_price_unit);
						$doc->exportField($this->maccess_lrestrict);
						$doc->exportField($this->maccess_listings);
						$doc->exportField($this->maccess_ptrestrict);
						$doc->exportField($this->maccess_property_types);
						$doc->exportField($this->maccess_renewable);
						$doc->exportField($this->maccess_renewal_price);
						$doc->exportField($this->maccess_renewal_price_unit);
						$doc->exportField($this->maccess_upgradable);
						$doc->exportField($this->maccess_wpl_color);
						$doc->exportField($this->expired);
						$doc->exportField($this->expiry_date);
						$doc->exportField($this->location_text);
						$doc->exportField($this->last_modified_time_stamp);
						$doc->exportField($this->profile_picture);
						$doc->exportField($this->company_logo);
						$doc->exportField($this->maccess_lrestrict_pshow);
						$doc->exportField($this->maccess_ptrestrict_pshow);
						$doc->exportField($this->maccess_listings_pshow);
						$doc->exportField($this->maccess_property_types_pshow);
						$doc->exportField($this->maccess_lrestrict_plisting);
						$doc->exportField($this->maccess_ptrestrict_plisting);
						$doc->exportField($this->maccess_listings_plisting);
						$doc->exportField($this->maccess_property_types_plisting);
						$doc->exportField($this->access_clone);
						$doc->exportField($this->access_propertystats);
						$doc->exportField($this->online_status);
						$doc->exportField($this->access_CRM);
					}
					$doc->endExportRow($rowCnt);
				}
			}

			// Call Row Export server event
			if ($doc->ExportCustom)
				$this->Row_Export($recordset->fields);
			$recordset->moveNext();
		}
		if (!$doc->ExportCustom) {
			$doc->exportTableFooter();
		}
	}

	// Get file data
	public function getFileData($fldparm, $key, $resize, $width = 0, $height = 0)
	{

		// No binary fields
		return FALSE;
	}

	// Table level events
	// Recordset Selecting event
	function Recordset_Selecting(&$filter) {

		// Enter your code here
	}

	// Recordset Selected event
	function Recordset_Selected(&$rs) {

		//echo "Recordset Selected";
	}

	// Recordset Search Validated event
	function Recordset_SearchValidated() {

		// Example:
		//$this->MyField1->AdvancedSearch->SearchValue = "your search criteria"; // Search value

	}

	// Recordset Searching event
	function Recordset_Searching(&$filter) {

		// Enter your code here
	}

	// Row_Selecting event
	function Row_Selecting(&$filter) {

		// Enter your code here
	}

	// Row Selected event
	function Row_Selected(&$rs) {

		//echo "Row Selected";
	}

	// Row Inserting event
	function Row_Inserting($rsold, &$rsnew) {

		// Enter your code here
		// To cancel, set return value to FALSE

		return TRUE;
	}

	// Row Inserted event
	function Row_Inserted($rsold, &$rsnew) {

		//echo "Row Inserted"
	}

	// Row Updating event
	function Row_Updating($rsold, &$rsnew) {

		// Enter your code here
		// To cancel, set return value to FALSE

		return TRUE;
	}

	// Row Updated event
	function Row_Updated($rsold, &$rsnew) {

		//echo "Row Updated";
	}

	// Row Update Conflict event
	function Row_UpdateConflict($rsold, &$rsnew) {

		// Enter your code here
		// To ignore conflict, set return value to FALSE

		return TRUE;
	}

	// Grid Inserting event
	function Grid_Inserting() {

		// Enter your code here
		// To reject grid insert, set return value to FALSE

		return TRUE;
	}

	// Grid Inserted event
	function Grid_Inserted($rsnew) {

		//echo "Grid Inserted";
	}

	// Grid Updating event
	function Grid_Updating($rsold) {

		// Enter your code here
		// To reject grid update, set return value to FALSE

		return TRUE;
	}

	// Grid Updated event
	function Grid_Updated($rsold, $rsnew) {

		//echo "Grid Updated";
	}

	// Row Deleting event
	function Row_Deleting(&$rs) {

		// Enter your code here
		// To cancel, set return value to False

		return TRUE;
	}

	// Row Deleted event
	function Row_Deleted(&$rs) {

		//echo "Row Deleted";
	}

	// Email Sending event
	function Email_Sending($email, &$args) {

		//var_dump($email); var_dump($args); exit();
		return TRUE;
	}

	// Lookup Selecting event
	function Lookup_Selecting($fld, &$filter) {

		//var_dump($fld->Name, $fld->Lookup, $filter); // Uncomment to view the filter
		// Enter your code here

	}

	// Row Rendering event
	function Row_Rendering() {

		// Enter your code here
	}

	// Row Rendered event
	function Row_Rendered() {

		// To view properties of field class, use:
		//var_dump($this-><FieldName>);

	}

	// User ID Filtering event
	function UserID_Filtering(&$filter) {

		// Enter your code here
	}
}
?>