function add($VAR)
{
$type = "add";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$group_id = $db->add($VAR, $this, $type);
# add the new group to the account_group table:
$db =& DB();
$record_id = $db->GenID(AGILE_DB_PREFIX . 'account_group_id');
$sql = "INSERT INTO " . AGILE_DB_PREFIX . "account_group SET\n\t\t\t\tid\t\t\t= " . $db->qstr($record_id) . ",\n\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . ", \n\t\t\t\tdate_orig\t= " . $db->qstr(time()) . ",\n\t\t\t\tdate_expire = " . $db->qstr('0') . ",\n\t\t\t\tgroup_id\t= " . $db->qstr($group_id) . ",\n\t\t\t\taccount_id\t= " . $db->qstr(SESS_ACCOUNT) . ",\n\t\t\t\tactive\t\t= " . $db->qstr(1);
$result = $db->Execute($sql);
if ($result === false) {
global $C_debug;
$C_debug->error('list.inc.php', 'select_groups', $db->ErrorMsg());
return;
}
# update the current user's authentication so the newly added group appears
# as available to them
global $C_auth;
$C_auth->auth_update();
return;
}
function update($VAR)
{
if ($VAR['setup_currency_id'] != DEFAULT_CURRENCY) {
$curr = true;
} else {
$curr = false;
}
# make sure the index.php file is not included at the end:
if (!empty($VAR['setup_ssl_url'])) {
$VAR['setup_ssl_url'] = eregi_replace('index.php', '', $VAR['setup_ssl_url']);
}
if (!empty($VAR['setup_nonssl_url'])) {
$VAR['setup_nonssl_url'] = eregi_replace('index.php', '', $VAR['setup_nonssl_url']);
}
# Validate trailing slash is on the end of the URL:
if (!empty($VAR['setup_ssl_url']) && !ereg('/$', $VAR['setup_ssl_url'])) {
$VAR['setup_ssl_url'] .= '/';
}
# Validate trailing slash is on the end of the URL:
if (!empty($VAR['setup_nonssl_url']) && !ereg('/$', $VAR['setup_nonssl_url'])) {
$VAR['setup_nonssl_url'] .= '/';
}
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$rs = $db->update($VAR, $this, $type);
if ($rs && $curr) {
/* Start: Update all sessions & accounts */
$db =& DB();
$sql = "UPDATE " . AGILE_DB_PREFIX . "session \n\t\t\t\t\tSET\n\t\t\t\t\tcurrency_id = " . $db->qstr($VAR['setup_currency_id']) . "\n\t\t\t\t\tWHERE\n\t\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t\t\tcurrency_id != " . $db->qstr($VAR['setup_currency_id']);
$rs = $db->Execute($sql);
$sql = "UPDATE " . AGILE_DB_PREFIX . "account \n\t\t\t\t\tSET\n\t\t\t\t\tcurrency_id = " . $db->qstr($VAR['setup_currency_id']) . "\n\t\t\t\t\tWHERE\n\t\t\t\t\tsite_id \t= " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t\t\tcurrency_id != " . $db->qstr($VAR['setup_currency_id']);
$rs = $db->Execute($sql);
/* End: SQL Insert Statement */
}
# Clear out the cache entry
if (defined("AGILE_CORE_CACHE_DIR") && AGILE_CORE_CACHE_DIR != '') {
$tfile = AGILE_CORE_CACHE_DIR . "core-setup";
if (file_exists($tfile)) {
unlink(AGILE_CORE_CACHE_DIR . "core-setup");
}
}
}
function add($VAR)
{
# defaults for 'recurring' product
if ($VAR["product_price_type"] == "1") {
$VAR['product_price_recurr_default'] = "1";
$VAR['product_price_recurr_type'] = "0";
$VAR['product_price_recurr_week'] = "1";
$VAR['product_price_recurr_weekday'] = "1";
# Set default recurring prices: (monthly only)
$db =& DB();
$sql = 'SELECT id FROM ' . AGILE_DB_PREFIX . 'group WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . ' AND
pricing = ' . $db->qstr('1');
$rs = $db->Execute($sql);
while (!$rs->EOF) {
$i = $rs->fields['id'];
$recur_price[0][$i]['price_base'] = '';
$recur_price[0][$i]['price_setup'] = '';
@($recur_price[1][$i]['price_base'] = $VAR['product_price_base']);
@($recur_price[1][$i]['price_setup'] = $VAR['product_price_setup']);
$recur_price[2][$i]['price_base'] = '';
$recur_price[2][$i]['price_setup'] = '';
$recur_price[3][$i]['price_base'] = '';
$recur_price[3][$i]['price_setup'] = '';
$recur_price[4][$i]['price_base'] = '';
$recur_price[4][$i]['price_setup'] = '';
$recur_price[5][$i]['price_base'] = '';
$recur_price[5][$i]['price_setup'] = '';
$rs->MoveNext();
}
$recur_price[0]['show'] = "0";
$recur_price[1]['show'] = "1";
$recur_price[2]['show'] = "0";
$recur_price[3]['show'] = "0";
$recur_price[4]['show'] = "0";
$recur_price[5]['show'] = "0";
@($VAR['product_price_group'] = $recur_price);
}
# Defaults for product groups:
$VAR['product_group_avail'] = array('0');
$this->product_construct();
$type = "add";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$result = $db->add($VAR, $this, $type);
# Create a translate record for this product:
if ($result) {
$db =& DB();
$id = $db->GenID(AGILE_DB_PREFIX . 'product_translate_id');
$sql = 'INSERT INTO ' . AGILE_DB_PREFIX . 'product_translate SET
site_id = ' . $db->qstr(DEFAULT_SITE) . ',
id = ' . $db->qstr($id) . ',
product_id = ' . $db->qstr($result) . ',
language_id = ' . $db->qstr(DEFAULT_LANGUAGE) . ',
name = ' . $db->qstr(@$VAR["translate_name"]) . ',
description_short = ' . $db->qstr(@$VAR["translate_description_short"]) . ',
description_full = ' . $db->qstr(@$VAR["translate_description_full"]);
$db->Execute($sql);
}
}
function add($VAR)
{
$type = "add";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$id = $db->add($VAR, $this, $type);
if ($id && !empty($VAR['faq_question'])) {
# Insert translation
$db =& DB();
$idx = $db->GenID(AGILE_DB_PREFIX . 'faq_translate_id');
$sql = "INSERT INTO\t" . AGILE_DB_PREFIX . "faq_translate\n\t\t\t\t\tSET\n\t\t\t\t\tsite_id = " . DEFAULT_SITE . ",\n\t\t\t\t\tid = {$idx},\n\t\t\t\t\tfaq_id = {$id},\n\t\t\t\t\tdate_orig = " . time() . ",\n\t\t\t\t\tdate_last = " . time() . ",\n\t\t\t\t\tlanguage_id = '" . DEFAULT_LANGUAGE . "',\n\t\t\t\t\tanswer = " . $db->qstr(@$VAR['faq_answer']) . ",\n\t\t\t\t\tquestion = " . $db->qstr(@$VAR['faq_question']);
$db->Execute($sql);
}
}
function delete($VAR)
{
$this->associated_DELETE[] = array('table' => 'invoice_commission', 'field' => 'affiliate_commission_id');
$db = new CORE_database();
$db->mass_delete($VAR, $this, "");
# Delete all associated discounts:
if (isset($VAR['id'])) {
$id = $VAR['id'];
for ($i = 0; $i < count($id); $i++) {
if ($id[$i] != '') {
$q = '%Affiliate Commission ID ' . $id[$i] . '%';
$db =& DB();
$sql = "DELETE FROM " . AGILE_DB_PREFIX . "discount WHERE\n\t\t\t\t\t\t notes LIKE " . $db->qstr($q) . " AND\n\t\t\t\t\t\t site_id = " . $db->qstr(DEFAULT_SITE);
$result = $db->Execute($sql);
}
}
} else {
$id = $VAR['delete_id'];
$q = '%Affiliate Commission ID ' . $id . '%';
$db =& DB();
$sql = "DELETE FROM " . AGILE_DB_PREFIX . "discount WHERE\n\t\t\t\tnotes LIKE " . $db->qstr($q) . " AND\n\t\t\t\tsite_id = " . $db->qstr(DEFAULT_SITE);
$result = $db->Execute($sql);
}
}
function add($VAR)
{
global $C_translate, $C_debug;
$VAR['htaccess_dir_htaccess'] = '# Error!';
$this->validated = true;
### Change the path...
if (isset($VAR['htaccess_dir_path']) && $VAR['htaccess_dir_path'] != '') {
# trim whitspaces
$VAR['htaccess_dir_path'] = trim($VAR['htaccess_dir_path']);
# replace all forward slashes with back slashes
$VAR['htaccess_dir_path'] = ereg_replace('\\\\', '/', $VAR['htaccess_dir_path']);
# add the final trailing slash if missing
if (!ereg('[/]$', $VAR['htaccess_dir_path'])) {
$VAR['htaccess_dir_path'] = $VAR['htaccess_dir_path'] . '/';
}
}
if (isset($VAR['htaccess_dir_path']) && $VAR['htaccess_dir_path'] != '') {
################################################################
### VERIFY LOCAL PATH & WRITABILITY!
@($filename = $VAR['htaccess_dir_path'] . '.htaccess');
@($id = $VAR['htaccess_dir_htaccess_id']);
$db =& DB();
$sql = 'SELECT name FROM ' . AGILE_DB_PREFIX . 'htaccess WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . ' AND
id = ' . $db->qstr($id);
$result = $db->Execute($sql);
@($name = $result->fields['name']);
### Check path
$path = $VAR['htaccess_dir_path'];
if (is_dir($path)) {
### Check if is writable!
if (!is_writable($path)) {
## Path not writable!
$this->validated = false;
$this->val_error[] = array('field' => 'none', 'field_trans' => $C_translate->translate('error', 'core', ""), 'error' => $C_translate->translate('path_auth', 'htaccess_dir', ""));
}
} else {
### Path broken!
$this->validated = false;
$this->val_error[] = array('field' => 'none', 'field_trans' => $C_translate->translate('error', 'core', ""), 'error' => $C_translate->translate('path_broke', 'htaccess_dir', ""));
}
}
####################################################################
### If validation was failed, skip the db insert &
### set the errors & origonal fields as Smarty objects,
### and change the page to be loaded.
####################################################################
if (!$this->validated) {
global $smarty;
# set the errors as a Smarty Object
$smarty->assign('form_validation', $this->val_error);
# set the page to be loaded
if (!defined("FORCE_PAGE")) {
define('FORCE_PAGE', $VAR['_page_current']);
}
return;
}
####################################################################
### Create the record/verify fields
$type = "add";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$dir_id = $db->add($VAR, $this, $type);
####################################################################
### Create the .htaccess file
if (isset($dir_id) && $dir_id > 0) {
### GENERATE THE EXCLUDE LIST
$exclude_list = $this->exclude_list();
### GENERATE THE .HTACCESS FILE
$nl = "\n";
$data = $this->htaccess_extra . 'RewriteEngine on' . $nl;
if (empty($VAR['htaccess_dir_recursive'])) {
$data .= 'RewriteRule ^(.*)/.*$ - [L]' . $nl;
}
$data .= 'RewriteRule ' . $exclude_list . '$ htaccess_index.php?_HTACCESS_ID=' . $id . '&_HTACCESS_DIR_ID=' . $dir_id;
### Update the db record
$db =& DB();
$sql = "UPDATE " . AGILE_DB_PREFIX . "htaccess_dir SET\n\t\t\t\t htaccess = " . $db->qstr($data) . " WHERE\n\t\t\t\t id = " . $db->qstr($dir_id) . " AND\n\t\t\t\t site_id = " . $db->qstr(DEFAULT_SITE);
$result = $db->Execute($sql);
### WRITE THE LOCAL .HTACCESS FILE
$fp = fopen($filename, "w+");
fwrite($fp, $data);
fclose($fp);
### WRITE THE htaccess_index.php FILE
$php_filename = $VAR['htaccess_dir_path'] . 'htaccess_index.php';
$data = $this->create_php();
$fp = fopen($php_filename, "w+");
fwrite($fp, $data);
fclose($fp);
}
}
function view($VAR)
{
global $smarty;
$this->construct();
$type = "view";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->view($VAR, $this, $type);
### Define the group mapping....
$id = @$VAR['id'];
### Get the variables for this map plugin:
$db =& DB();
$sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'db_mapping WHERE
id = ' . $db->qstr(@$VAR["id"]) . ' AND
site_id = ' . $db->qstr(DEFAULT_SITE);
$result = $db->Execute($sql);
### error reporting:
if ($result === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
return;
}
$file = $result->fields['map_file'];
$group_map = $result->fields['group_map'];
if ($group_map != '') {
$group_map = unserialize($group_map);
} else {
$group_map = array();
}
if ($file != '') {
include_once PATH_PLUGINS . 'db_mapping/' . $file . '.php';
eval('$_MAP = new map_' . strtoupper($file) . ';');
### If this map type is 'db' groups based:
if ($_MAP->map['group_type'] == 'db' || $_MAP->map['group_type'] == 'db-status') {
### Connect to the DB & get the groups:
$dbm = new db_mapping();
$db = $dbm->DB_connect($id, 'false');
eval('@$db_prefix = DB2_PREFIX' . strtoupper($file) . ';');
$sql = "SELECT * FROM " . $db_prefix . "" . $_MAP->map['group_map']['table'] . "\n\t\t\t\t\t\t\t ORDER BY " . $_MAP->map['group_map']['name'];
$db2 = $db->Execute($sql);
if ($db2 === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
$smarty->assign('db_mapping_result', $db->ErrorMsg());
return;
}
### get the remote groups...
if ($db2->RecordCount() > 0) {
$i = 0;
while (!$db2->EOF) {
$smart[$i]['id'] = $db2->fields[$_MAP->map['group_map']['id']];
$smart[$i]['name'] = $db2->fields[$_MAP->map['group_map']['name']];
$db2->MoveNext();
$i++;
}
### Get the local groups:
$db =& DB();
$sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'group WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . '
ORDER BY name';
$groups = $db->Execute($sql);
if ($groups === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
return;
}
if ($groups->RecordCount() > 0) {
$i = 0;
while (!$groups->EOF) {
$id = $groups->fields['id'];
$smartgr[$i]['id'] = $groups->fields['id'];
$smartgr[$i]['name'] = $groups->fields['name'];
for ($ii = 0; $ii < count($smart); $ii++) {
$rid = $smart[$ii]['id'];
$name = $smart[$ii]['name'];
$checked = false;
if (isset($group_map[$id][$rid]) && $group_map[$id][$rid] != false) {
$checked = true;
}
$smartgr[$i]['remote'][$ii]['id'] = $rid;
$smartgr[$i]['remote'][$ii]['name'] = $name;
$smartgr[$i]['remote'][$ii]['check'] = $checked;
}
$groups->MoveNext();
$i++;
}
### Define smarty vars
$smarty->assign('db_mapping_result', false);
$smarty->assign('db_mapping_template', 'db_mapping:group_map_' . $_MAP->map['group_type']);
$smarty->assign('db_mapping_groups', $smartgr);
} else {
global $C_translate;
$message = $C_translate->translate('no_local_groups', 'db_mapping', '');
$smarty->assign('db_mapping_result', $message);
}
} else {
global $C_translate;
$message = $C_translate->translate('no_remote_groups', 'db_mapping', '');
$smarty->assign('db_mapping_result', $message);
}
} elseif ($_MAP->map['group_type'] == 'status') {
### This is at 'status' based database map
### Get the local groups:
$db =& DB();
$sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'group WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . '
ORDER BY name';
$groups = $db->Execute($sql);
### error reporting:
if ($groups === false) {
global $C_debug;
$C_debug->error('db_mapping.inc.php', 'view', $db->ErrorMsg());
return;
}
if ($groups->RecordCount() > 0) {
$i = 0;
while (!$groups->EOF) {
$id = $groups->fields['id'];
$smart[$i]['id'] = $groups->fields['id'];
$smart[$i]['name'] = $groups->fields['name'];
@($smart[$i]['value'] = $group_map[$id]);
$groups->MoveNext();
$i++;
}
}
### Assign the smarty vars:
$smarty->assign('db_mapping_result', false);
$smarty->assign('db_mapping_template', 'db_mapping:group_map_status');
$smarty->assign('db_mapping_groups', $smart);
} else {
### No group mapping for this database map
global $C_translate;
$message = $C_translate->translate('no_group_mapping', 'db_mapping', '');
$smarty->assign('db_mapping_result', $message);
}
} else {
global $C_translate;
$message = $C_translate->translate('file_error', 'db_mapping', '');
$smarty->assign('db_mapping_result', $message);
}
}
