function __construct()
{
parent::__construct();
$this->setTableName('t_nc_facebook');
$this->setPrimaryKey('pk_fb_api_id');
$this->setFields(array('pk_fb_api_id', 'fb_api_secret', 'fb_status', 'fb_connection'));
}
/**
* Set data related to t_currency table
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_currency');
$this->setPrimaryKey('pk_c_code');
$this->setFields(array('pk_c_code', 's_name', 's_description', 'b_enabled'));
}
/**
* Set data related to t_country_stats table
*
* @access public
* @since 2.4
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_country_stats');
$this->setPrimaryKey('fk_c_country_code');
$this->setFields(array('fk_c_country_code', 'i_num_items'));
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_seller_ratings');
$this->setPrimaryKey('pk_i_seller_id');
$this->setFields(array('pk_i_seller_id', 'pk_i_user_id', 'vote_given'));
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_mark_as_sold');
$this->setPrimaryKey('pk_sold_id');
$this->setFields(array('pk_sold_id'));
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_facebook_user');
$this->setPrimaryKey('fk_i_user_id');
$this->setFields(array('fk_i_user_id', 'facebook_user_id'));
}
/**
* Set data related to t_city_stats table
*
* @access public
* @since 2.4
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_city_stats');
$this->setPrimaryKey('fk_i_city_id');
$this->setFields(array('fk_i_city_id', 'i_num_items'));
}
public function __construct()
{
parent::__construct();
$this->MAP_ARR = array("id" => 'id', "username" => 'username', "money" => 'money', "add_time" => 'add_time', "mem" => 'mem');
$this->MAP_TYPE = array('id' => FIELD_TYPE_AUTO, 'money' => FIELD_TYPE_INT, 'add_time' => FIELD_TYPE_DATETIME);
$this->_TABLE = DBPRE . 'money_out';
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_subscriber');
$this->setPrimaryKey('pk_subs_id');
$this->setFields(array('pk_subs_id', 'subs_email'));
}
function __construct()
{
parent::__construct();
$this->id_column = 'status_id';
$this->table_fields = array('status_category', 'status_name');
$this->table = 'statuses';
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_latest_searches');
$array_fields = array('d_date', 's_search');
$this->setFields($array_fields);
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_paid_ads');
$this->setPrimaryKey('pk_paid_ads_id');
$this->setFields(array('pk_paid_ads_id'));
}
/**
* Set data related to t_alerts_sent table
*/
public function __construct()
{
parent::__construct();
$this->setTableName('t_alerts_sent');
$this->setPrimaryKey('d_date');
$this->setFields(array('d_date', 'i_num_alerts_sent'));
}
public function __construct()
{
parent::__construct();
$this->MAP_ARR = array("name" => 'name', "value" => 'value');
$this->MAP_TYPE = array();
$this->_TABLE = DBPRE . 'setting';
}
/**
* Set data related to t_item_stats table
*/
public function __construct()
{
parent::__construct();
$this->setTableName('t_item_stats');
$this->setPrimaryKey('fk_i_item_id');
$this->setFields(array('fk_i_item_id', 'i_num_views', 'i_num_spam', 'i_num_repeated', 'i_num_bad_classified', 'i_num_offensive', 'i_num_expired', 'i_num_premium_views', 'dt_date'));
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_log');
$array_fields = array('dt_date', 's_section', 's_action', 'fk_i_id', 's_data', 's_ip', 's_who', 'fk_i_who_id');
$this->setFields($array_fields);
}
public function __construct()
{
parent::__construct();
$this->MAP_ARR = array('id' => 'id', 'name' => 'name', 'group_id' => 'group_id', 'upid' => 'upid', 'describe' => 'describe', 'price' => 'price', 'month_flag' => 'month_flag', 'pause_flag' => 'pause_flag', 'show_price' => 'show_price');
$this->MAP_TYPE = array('id' => FIELD_TYPE_INT | FIELD_TYPE_AUTO, 'group_id' => FIELD_TYPE_INT, 'upid' => FIELD_TYPE_INT, 'price' => FIELD_TYPE_INT, 'month_flag' => FIELD_TYPE_INT, 'pause_flag' => FIELD_TYPE_INT, 'show_price' => FIELD_TYPE_INT);
$this->_TABLE = 'mproduct';
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_paypal');
$this->setPrimaryKey('pk_pp_username');
$this->setFields(array('pk_pp_username', 'pp_password', 'pp_signature', 'pp_server', 'pp_status'));
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_region');
$this->setPrimaryKey('pk_i_id');
$this->setFields( array('pk_i_id', 'fk_c_country_code', 's_name', 'b_active', 's_slug') );
}
/**
* Set data related to t_meta_fields table
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_meta_fields');
$this->setPrimaryKey('pk_i_id');
$this->setFields(array('pk_i_id', 's_name', 'e_type', 'b_required', 'b_searchable', 's_slug', 's_options'));
}
/**
* Set data related to t_city_area table
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_city_area');
$this->setPrimaryKey('pk_i_id');
$this->setFields(array('pk_i_id', 'fk_i_city_id', 's_name'));
}
public function __construct()
{
parent::__construct();
$this->MAP_ARR = array("id" => 'id', "admin" => 'admin', "operate" => 'operate', "operate_object" => 'operate_object', 'operate_time' => 'operate_time', 'mem' => 'mem', 'mem2' => 'mem2');
$this->MAP_TYPE = array('id' => FIELD_TYPE_INT | FIELD_TYPE_AUTO, 'operate_time' => FIELD_TYPE_DATETIME);
$this->_TABLE = DBPRE . 'operate_log';
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_user_email_tmp');
$this->setPrimaryKey('fk_i_user_id');
$this->setFields(array('fk_i_user_id', 's_new_email', 'dt_date'));
}
function __construct()
{
parent::__construct();
$this->setTableName('t_nc_offer_item');
$this->setPrimaryKey('pk_o_id');
$this->setFields(array('pk_o_id', 'fk_user_id', 'fk_item_id', 'o_date_time', 'o_detail'));
}
public function __construct($expired = false)
{
$this->city_areas = array();
$this->cities = array();
$this->regions = array();
$this->countries = array();
$this->categories = array();
$this->conditions = array();
$this->fields = array();
$this->tables[] = sprintf('%st_item_description as d, %st_category_description as cd', DB_TABLE_PREFIX, DB_TABLE_PREFIX);
$this->order();
$this->limit();
$this->results_per_page = 10;
if (!$expired) {
$this->addTable(sprintf('%st_category', DB_TABLE_PREFIX));
$this->addConditions(sprintf("%st_item.b_active = 1 ", DB_TABLE_PREFIX));
$this->addConditions(sprintf("%st_item.b_enabled = 1 ", DB_TABLE_PREFIX));
$this->addConditions(sprintf("%st_item.b_spam = 0", DB_TABLE_PREFIX));
$this->addConditions(sprintf(" (%st_item.b_premium = 1 || %st_category.i_expiration_days = 0 ||TIMESTAMPDIFF(DAY,%st_item.dt_pub_date,'%s') < %st_category.i_expiration_days) ", DB_TABLE_PREFIX, DB_TABLE_PREFIX, DB_TABLE_PREFIX, date('Y-m-d H:i:s'), DB_TABLE_PREFIX));
$this->addConditions(sprintf("%st_category.b_enabled = 1", DB_TABLE_PREFIX));
$this->addConditions(sprintf("%st_category.pk_i_id = %st_item.fk_i_category_id", DB_TABLE_PREFIX, DB_TABLE_PREFIX));
}
$this->total_results = null;
parent::__construct();
}
public function __construct()
{
parent::__construct();
$this->MAP_ARR = array("name" => 'name', "host" => 'host', "port" => 'port', "passwd" => 'passwd', 'nickname' => 'nickname');
$this->MAP_TYPE = array('port' => FIELD_TYPE_INT);
$this->_TABLE = DBPRE . 'nodes';
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_widget');
$this->setPrimaryKey('pk_i_id');
$this->setFields(array('pk_i_id', 's_description', 's_location', 'e_kind', 's_content'));
}
/**
* Set data related to t_item_resource table
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_item_resource');
$this->setPrimaryKey('pk_i_id');
$this->setFields(array('pk_i_id', 'fk_i_item_id', 's_name', 's_extension', 's_content_type', 's_path'));
}
/**
* Set data related to t_item table
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_item');
$this->setPrimaryKey('pk_i_id');
$array_fields = array(
'pk_i_id',
'fk_i_user_id',
'fk_i_category_id',
'dt_pub_date',
'dt_mod_date',
'f_price',
'i_price',
'fk_c_currency_code',
's_contact_name',
's_contact_email',
'b_premium',
's_ip',
'b_enabled',
'b_active',
'b_spam',
's_secret',
'b_show_email',
'dt_expiration'
);
$this->setFields($array_fields);
}
/**
*
*/
function __construct()
{
parent::__construct();
$this->setTableName('t_country');
$this->setPrimaryKey('pk_c_code');
$this->setFields(array('pk_c_code', 's_name', 's_slug'));
}
