function update($VAR)
{
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
}
function update($VAR)
{
$this->newsletter_construct();
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
}
function update($VAR)
{
$this->construct();
# provisioning data;
if (!empty($VAR['product_host_provision_plugin_data'])) {
$VAR['service_host_provision_plugin_data'] = $VAR['product_host_provision_plugin_data'];
$s = serialize($VAR['service_host_provision_plugin_data']);
}
# product plugin data;
if (!empty($VAR['product_prod_plugin_data'])) {
$VAR['service_prod_plugin_data'] = $VAR['product_prod_plugin_data'];
}
# check if any changes were made that calls for edit queue status
$queue = true;
# get the previous data
$db =& DB();
$sql = 'SELECT * FROM ' . AGILE_DB_PREFIX . 'service WHERE
id = ' . $db->qstr($VAR['service_id']) . ' AND
site_id = ' . $db->qstr(DEFAULT_SITE);
$rs = $db->Execute($sql);
if (!empty($VAR['queue_force'])) {
$queue = false;
} elseif (!empty($VAR['service_host_provision_plugin_data'])) {
# compare username
if ($rs->fields['host_username'] != $VAR['service_host_username']) {
$VAR['service_queue'] = 'edit';
# compare password
} elseif ($rs->fields['host_password'] != $VAR['service_host_password']) {
$VAR['service_queue'] = 'edit';
# compare ip
} elseif (!empty($VAR['service_host_ip']) && $rs->fields['host_ip'] != $VAR['service_host_ip']) {
$VAR['service_queue'] = 'edit';
# compare plugin data
} elseif ($rs->fields['host_provision_plugin_data'] != $s) {
$VAR['service_queue'] = 'edit';
} else {
# suspend/unsuspend
if ($VAR['service_active'] == 0 && $VAR['service_active'] != $rs->fields['active']) {
$VAR['service_queue'] = 'inactive';
} elseif ($VAR['service_active'] == 1 && $VAR['service_active'] != $rs->fields['active']) {
$VAR['service_queue'] = 'active';
} else {
$VAR['service_queue'] = $rs->fields['queue'];
$queue = false;
}
}
} else {
# suspend/unsuspend
if ($VAR['service_active'] == 0 && $VAR['service_active'] != $rs->fields['active']) {
$VAR['service_queue'] = 'inactive';
} elseif ($VAR['service_active'] == 1 && $VAR['service_active'] != $rs->fields['active']) {
$VAR['service_queue'] = 'active';
} else {
$VAR['service_queue'] = $rs->fields['queue'];
$queue = false;
}
}
# update record
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
# Run queue now
if ($queue) {
$this->queue_one($VAR['service_id'], false);
return true;
}
}
function update($VAR)
{
global $C_list, $C_debug;
if (!$this->checkLimits()) {
return false;
}
// check account limits
// validate the tax_id
global $VAR;
require_once PATH_MODULES . 'tax/tax.inc.php';
$taxObj = new tax();
$tax_arr = @$VAR['account_admin_tax_id'];
if (is_array($tax_arr)) {
foreach ($tax_arr as $country_id => $tax_id) {
if ($country_id == $VAR['account_admin_country_id']) {
$exempt = @$VAR["account_tax_id_exempt"][$country_id];
if (!($txRs = $taxObj->TaxIdsValidate($country_id, $tax_id, $exempt))) {
$this->validated = false;
global $C_translate;
$this->val_error[] = array('field' => 'account_admin_tax_id', 'field_trans' => $taxObj->errField, 'error' => $C_translate->translate('validate_general', "", ""));
}
if ($exempt) {
$VAR['account_admin_tax_id'] = false;
} else {
$VAR['account_admin_tax_id'] = $tax_id;
}
}
}
}
####################################################################
### Get required static_Vars and validate them... return an array
### w/ ALL errors...
####################################################################
require_once PATH_CORE . 'static_var.inc.php';
$static_var = new CORE_static_var();
if (!isset($this->val_error)) {
$this->val_error = false;
}
$all_error = $static_var->validate_form('account', $this->val_error);
if ($all_error != false && gettype($all_error) == 'array') {
$this->validated = false;
} else {
$this->validated = true;
}
####################################################################
# 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', $all_error);
# set the page to be loaded
if (!defined("FORCE_PAGE")) {
define('FORCE_PAGE', $VAR['_page_current']);
}
return;
}
### Get the old username ( for db mapping )
$db =& DB();
$sql = 'SELECT username FROM ' . AGILE_DB_PREFIX . 'account WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . ' AND
id = ' . $db->qstr($VAR['account_admin_id']);
$result = $db->Execute($sql);
if ($result->RecordCount() > 0) {
$old_username = $result->fields['username'];
}
### Update the password:
$update_password = false;
if (!empty($VAR['_password'])) {
$VAR['account_admin_password'] = $VAR['_password'];
/* check if new password is ok */
if ($C_list->is_installed('account_password_history')) {
include_once PATH_MODULES . 'account_password_history/account_password_history.inc.php';
$accountHistory = new account_password_history();
if (!$accountHistory->getIsPasswordOk($VAR['account_admin_id'], $VAR['account_admin_password'], false)) {
$C_debug->alert("The password you have selected has been used recently and cannot be used again at this time for security purposes.");
unset($VAR['account_admin_password']);
} else {
$update_password = true;
}
}
}
### Update the record
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$ok = $db->update($VAR, $this, $type);
if ($ok) {
/* password logging class */
if ($update_password && is_object($accountHistory)) {
$accountHistory->setNewPassword($VAR['account_admin_id'], $VAR["account_admin_password"], false);
}
### Update the static vars:
$static_var->update($VAR, 'account', $VAR['account_admin_id']);
### Do any db_mapping
if ($C_list->is_installed('db_mapping')) {
include_once PATH_MODULES . 'db_mapping/db_mapping.inc.php';
$db_map = new db_mapping();
if (!empty($VAR['account_admin_password'])) {
$db_map->plaintext_password = $VAR['account_admin_password'];
} else {
$db_map->plaintext_password = false;
}
$db_map->account_edit($VAR['account_admin_id'], $old_username);
}
// remove login lock
if ($VAR['account_admin_status']) {
$db =& DB();
$delrs = $db->Execute($sql = sqlDelete($db, "login_lock", "account_id={$VAR['account_admin_id']}"));
$delrs = $db->Execute($sql = sqlDelete($db, "login_log", "account_id={$VAR['account_admin_id']} AND status=0"));
}
return true;
}
}
function update($VAR)
{
global $_FILES;
####################################################################
### Validate the thumbnail upoad:
if (isset($_FILES['upload_file1']) && $_FILES['upload_file1']['size'] > 0) {
$VAR['product_cat_thumbnail'] = "cat_thmb_" . $_FILES['upload_file1']['name'];
} elseif ($VAR['delthumb'] == 1) {
$VAR['product_cat_thumbnail'] = "";
}
### Validate the image upoad:
if (isset($_FILES['upload_file2']) && $_FILES['upload_file2']['size'] > 0) {
$VAR['product_cat_image'] = "cat_img_" . $_FILES['upload_file2']['name'];
} elseif ($VAR['delimg'] == 1) {
$VAR['product_cat_image'] = "";
}
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$result = $db->update($VAR, $this, $type);
####################################################################
### Copy the image(s)
if ($result) {
### Copy 1ST file upoad:
if (isset($_FILES['upload_file1']) && $_FILES['upload_file1']['size'] > 0) {
copy($_FILES['upload_file1']['tmp_name'], PATH_IMAGES . "cat_thmb_" . $_FILES['upload_file1']['name']);
}
### Copy the 2ND file upoad:
if (isset($_FILES['upload_file2']) && $_FILES['upload_file2']['size'] > 0) {
copy($_FILES['upload_file2']['tmp_name'], PATH_IMAGES . "cat_img_" . $_FILES['upload_file2']['name']);
}
}
}
function update($VAR)
{
global $_FILES;
$imgarr = array('jpeg', 'jpg', 'gif', 'bmp', 'tif', 'tiff', 'png');
if (isset($_FILES['upload_file1']) && $_FILES['upload_file1']['size'] > 0) {
for ($i = 0; $i < count($imgarr); $i++) {
if (eregi($imgarr[$i] . '$', $_FILES['upload_file1']['name'])) {
$filename = eregi_replace(',', '', 'prod_thmb_' . @$VAR["id"] . "." . $imgarr[$i]);
$i = 10;
}
}
} elseif (@$VAR['delimg'] == 1) {
$filename = "";
}
### Validate the thumbnail upoad:
if (isset($filename)) {
$VAR['product_thumbnail'] = $filename;
}
$this->product_construct();
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$result = $db->update($VAR, $this, $type);
### Copy the thumbnail
if ($result && isset($filename)) {
### Copy 1ST file upoad:
copy($_FILES['upload_file1']['tmp_name'], PATH_IMAGES . "" . $filename);
}
}
function update($VAR)
{
####################################################################
### Get required static_Vars and validate them... return an array
### w/ ALL errors...
####################################################################
require_once PATH_CORE . 'static_var.inc.php';
$static_var = new CORE_static_var();
if (!isset($this->val_error)) {
$this->val_error = false;
}
$all_error = $static_var->validate_form('affiliate', $this->val_error);
if ($all_error != false && gettype($all_error) == 'array') {
$this->validated = false;
} else {
$this->validated = true;
}
####################################################################
# 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', $all_error);
# set the page to be loaded
if (!defined("FORCE_PAGE")) {
define('FORCE_PAGE', $VAR['_page_current']);
}
return;
}
# special handling for the affiliate data array
if (isset($VAR['affiliate_plugin_data']) && is_array($VAR['affiliate_plugin_data'])) {
while (list($key, $val) = each($VAR['affiliate_plugin_data'])) {
if (get_magic_quotes_gpc()) {
$VAR['affiliate_plugin_data']["{$key}"] = htmlentities(stripcslashes($val), ENT_QUOTES);
}
}
}
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
### Update the static vars:
$static_var->update($VAR, 'affiliate', $VAR['affiliate_id']);
}
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 update($VAR)
{
// delete assoc faxdata records
$this->associated_DELETE[] = array('table' => 'voip_fax_data', 'field' => 'fax_id');
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
}
function update($VAR)
{
$this->construct();
$db =& DB();
# get current department
$rs = $db->Execute(sqlSelect($db, "ticket", "ticket_department_id", "id=::" . $VAR['ticket_id'] . "::"));
@($old_ticket_department_id = $rs->fields[0]);
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
# if the ticket was moved to a new department, send email notice to staff members
if ($old_ticket_department_id != $VAR['ticket_department_id']) {
$this->send_staff_emails($VAR['ticket_id'], SESS_ACCOUNT, $old_ticket_department_id, 'change');
}
}
function update($VAR)
{
global $VAR;
### Check that user is logged in:
if (SESS_LOGGED != '1') {
echo "Sorry, you must be logged in!";
}
/* check for sub account */
$issubaccount = false;
if (!empty($VAR['account_id']) && $VAR['account_id'] != SESS_ACCOUNT) {
if ($this->isParentAccount($VAR['account_id'])) {
$VAR['id'] = $VAR['account_id'];
global $smarty;
$issubaccount = true;
} else {
return false;
}
} else {
$VAR['id'] = SESS_ACCOUNT;
$VAR['account_id'] = SESS_ACCOUNT;
}
$VAR['account_date_last'] = time();
// validate the tax_id
require_once PATH_MODULES . 'tax/tax.inc.php';
$taxObj = new tax();
$tax_arr = @$VAR['account_tax_id'];
if (is_array($tax_arr)) {
foreach ($tax_arr as $country_id => $tax_id) {
if ($country_id == $VAR['cid']) {
$exempt = @$VAR["account_tax_id_exempt"][$country_id];
if (!($txRs = $taxObj->TaxIdsValidate($country_id, $tax_id, $exempt))) {
$this->validated = false;
global $C_translate;
$this->val_error[] = array('field' => 'account_tax_id', 'field_trans' => $taxObj->errField, 'error' => $C_translate->translate('validate_general', "", ""));
}
if ($exempt) {
$VAR['account_tax_id'] = false;
} else {
$VAR['account_tax_id'] = $tax_id;
}
}
}
}
####################################################################
### Get required static_Vars and validate them... return an array
### w/ ALL errors...
####################################################################
require_once PATH_CORE . 'static_var.inc.php';
$static_var = new CORE_static_var();
if (!isset($this->val_error)) {
$this->val_error = false;
}
$all_error = $static_var->validate_form('account', $this->val_error);
if ($all_error != false && gettype($all_error) == 'array') {
$this->validated = false;
} else {
$this->validated = true;
}
####################################################################
# 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', $all_error);
# set the page to be loaded
if (!defined("FORCE_PAGE")) {
define('FORCE_PAGE', $VAR['_page_current']);
}
return;
}
### Change password
$password_changed = false;
if (isset($VAR['account_password']) && $VAR['account_password'] != "") {
if (isset($VAR['confirm_password']) && $VAR['account_password'] == $VAR['confirm_password']) {
$password = $VAR['account_password'];
unset($VAR['account_password']);
@($VAR["account_password"] = $password);
### Alert: the password has been changed!
global $C_debug, $C_translate;
$C_debug->alert($C_translate->translate('password_changed', 'account', ''));
$password_changed = true;
/* check if new password is ok */
global $C_list;
if ($C_list->is_installed('account_password_history')) {
include_once PATH_MODULES . 'account_password_history/account_password_history.inc.php';
$accountHistory = new account_password_history();
if (!$accountHistory->getIsPasswordOk(SESS_ACCOUNT, $VAR['account_password'], false)) {
$C_debug->alert("The password you have selected has been used recently and cannot be used again at this time for security purposes.");
unset($VAR["account_password"]);
$password_changed = false;
}
}
} else {
### ERROR: The passwords provided do not match!
global $C_debug, $C_translate;
$C_debug->alert($C_translate->translate('password_change_match', 'account', ''));
unset($VAR["account_password"]);
}
} else {
unset($VAR["account_password"]);
}
### Change theme
if (isset($VAR['tid']) && $VAR['tid'] != "") {
@($VAR["account_theme_id"] = $VAR['tid']);
}
### Change Language
if (isset($VAR['lid']) && $VAR['lid'] != "") {
@($VAR["account_language_id"] = $VAR['lid']);
}
### Change country
if (isset($VAR['cid']) && $VAR['cid'] != "") {
@($VAR["account_country_id"] = $VAR['cid']);
}
### Change currency
if (isset($VAR['cyid']) && $VAR['cyid'] != "") {
@($VAR["account_currency_id"] = $VAR['cyid']);
}
### Get the old username ( for db mapping )
$db =& DB();
$sql = 'SELECT username FROM ' . AGILE_DB_PREFIX . 'account WHERE
site_id = ' . $db->qstr(DEFAULT_SITE) . ' AND
id = ' . $db->qstr(SESS_ACCOUNT);
$result = $db->Execute($sql);
if ($result->RecordCount() > 0) {
$old_username = $result->fields['username'];
}
### Update the record
$this->account_construct();
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
/* password logging class */
if ($password_changed && is_object($accountHistory)) {
$accountHistory->setNewPassword(SESS_ACCOUNT, $VAR['account_password'], false);
}
### Update the static vars:
$static_var->update($VAR, 'account', SESS_ACCOUNT);
### Do any db_mapping
global $C_list;
if ($C_list->is_installed('db_mapping')) {
include_once PATH_MODULES . 'db_mapping/db_mapping.inc.php';
$db_map = new db_mapping();
if (!empty($password)) {
$db_map->plaintext_password = $password;
} else {
$db_map->plaintext_password = false;
}
$db_map->account_edit(SESS_ACCOUNT, $old_username);
}
/* update groups for subaccount */
if ($issubaccount) {
$db =& DB();
$db->Execute(sqlDelete($db, "account_group", "group_id>2 and \n\t\t\t\t(service_id is null or service_id=0 or service_id='') \n\t\t\t\tand account_id=" . $db->qstr($VAR['account_id'])));
if (!empty($VAR['groups'])) {
global $C_auth;
foreach ($VAR['groups'] as $gid => $val) {
if ($gid == $val && $C_auth->auth_group_by_id($gid)) {
$fields = array('account_id' => $VAR['account_id'], 'group_id' => $gid, 'active' => 1, 'date_orig' => time());
$db->Execute(sqlInsert($db, "account_group", $fields));
}
}
}
}
}
function update($VAR)
{
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
if ($db->update($VAR, $this, $type)) {
### Update the static vars:
require_once PATH_CORE . 'static_var.inc.php';
$static_var = new CORE_static_var();
$static_var->update($VAR, 'newsletter_subscriber', $VAR['id']);
}
}
function update($VAR)
{
# Validate the files
for ($i = 1; $i <= 12; $i++) {
if (isset($_FILES['upload_file' . $i]) && $_FILES['upload_file' . $i]['size'] > 0) {
$VAR['campaign_type' . $i] = $_FILES['upload_file' . $i]['type'];
$VAR['campaign_file' . $i] = $_FILES['upload_file' . $i]['name'];
}
}
# Store the record
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$rs = $db->update($VAR, $this, $type);
### Copy the files
if ($rs) {
for ($i = 1; $i <= 12; $i++) {
if (isset($_FILES['upload_file' . $i]) && $_FILES['upload_file' . $i]['size'] > 0) {
if (!copy($_FILES['upload_file' . $i]['tmp_name'], PATH_FILES . 'campaign_' . $VAR['campaign_id'] . '_' . $i . '.dat')) {
### ERROR:
}
}
}
}
}
function update($VAR)
{
global $C_translate, $C_debug;
$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'] . '/';
}
}
### Change the .htaccess data
if (isset($VAR['htaccess_dir_path']) && $VAR['htaccess_dir_path'] != '') {
################################################################
### VERIFY LOCAL PATH & WRITABILITY!
@($filename = $VAR['htaccess_dir_path'] . '.htaccess');
@($php_filename = $VAR['htaccess_dir_path'] . 'htaccess_index.php');
@($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)) {
### GENERATE THE EXCLUDE LIST
$exclude_list = $this->exclude_list();
$nl = "\n";
/*
$data = $this->htaccess_extra .
'RewriteEngine on' . $nl .
'RewriteRule ^(.*)/.*$ - [L]' . $nl .
'RewriteRule ' .
'' . $exclude_list . '$ ' .
'htaccess_index.php' .
'?_HTACCESS_ID='.$id.'&_HTACCESS_DIR_ID='.$VAR["htaccess_dir_id"];
*/
$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=' . $VAR["htaccess_dir_id"];
### Set the .htaccess var for the db
$VAR['htaccess_dir_htaccess'] = $data;
} else {
## 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']);
}
return;
}
### Update the db record
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$dir = $db->update($VAR, $this, $type);
if ($dir != false) {
### UPDATE THE LOCAL .HTACCESS FILE
$fp = fopen($filename, "w+");
fwrite($fp, $data);
fclose($fp);
### UPDATE THE LOCAL htaccess_index.php
$data = $this->create_php();
$fp = fopen($php_filename, "w+");
fwrite($fp, $data);
fclose($fp);
}
}
function update($VAR)
{
$type = "update";
$this->method["{$type}"] = split(",", $this->method["{$type}"]);
$db = new CORE_database();
$result = $db->update($VAR, $this, $type);
if ($result) {
$id = $VAR['htaccess_id'];
# Update the php index file for the Apache mod_auth_remote module:
$GroupArray = '';
for ($i = 0; $i < count($VAR['htaccess_group_avail']); $i++) {
if ($i > 0) {
$GroupArray .= ',';
}
$GroupArray .= $VAR['htaccess_group_avail'][$i];
}
$data = '<?php
$Status = ' . @$VAR['htaccess_status'] . ';
$GroupArray = Array(' . $GroupArray . ');
if($Status != "1") { header(\'WWW-Authenticate: Basic realm="Failed"\'); header("HTTP/1.0 401 Unauthorized"); exit; }
include_once("../../../config.inc.php");
require_once(PATH_ADODB . "adodb.inc.php");
require_once(PATH_CORE . "database.inc.php");
require_once(PATH_MODULES. "htaccess/mod_auth_remote.inc.php");
?>';
# add dir:
$dir = PATH_FILES . 'htaccess_' . $id;
if (!is_dir($dir)) {
mkdir($dir, '755');
}
$file = PATH_FILES . 'htaccess_' . $id . '/index.php';
$fp = fopen($file, "w+");
fputs($fp, $data);
fclose($fp);
}
}
function update($VAR)
{
$this->static_page_category_construct();
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
}
function update($VAR)
{
#remove any group ids <= 1001 from the VAR array:
global $C_debug, $C_auth;
$id_list = '';
if (isset($VAR["delete_id"])) {
$id = explode(',', $VAR["delete_id"]);
} elseif (isset($VAR["id"])) {
$id = explode(',', $VAR["id"]);
}
for ($i = 0; $i < count($id); $i++) {
if (!empty($id[$i]) && $id[$i] > 1001) {
if ($i == 0) {
$id_list .= $id[$i];
} else {
$id_list .= ',' . $id[$i];
}
# Check if group allowed:
if (!$C_auth->auth_group_by_id($id[$i])) {
$C_debug->alert('The selected group cannot be modified as your account is not authorized for it.');
return;
}
} else {
$C_debug->alert('The selected group is part of the CORE and cannot be edited.');
return;
}
}
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
}
function update($VAR)
{
global $C_translate, $C_debug;
/* load database object */
$db = new CORE_database();
$this->construct();
$type = "update";
/* conditional fields for cc/eft */
$dbx =& DB();
$rs = $dbx->Execute(sqlSelect($dbx, "account_billing", "card_type,id,checkout_plugin_id", "id=::{$VAR['id']}::"));
if (!$rs || !$rs->RecordCount()) {
return false;
}
$billing_id = $rs->fields['id'];
$checkout_plugin_id = $rs->fields['checkout_plugin_id'];
if ($rs->fields['card_type'] == 'eft') {
/* EFT */
$this->method["{$type}"] = $db->ignore_fields(array('card_exp_month', 'card_exp_year', 'card_num'), $this->method["{$type}"]);
/* last four */
@($VAR['account_billing_card_num4'] = substr($VAR['account_billing_eft_check_acct'], strlen($VAR['account_billing_eft_check_acct']) - 4, 4));
} else {
/* CC */
# Validate the exp date
if (mktime(0, 0, 0, $VAR['account_billing_card_exp_month'], date('d'), $VAR['account_billing_card_exp_year']) <= time()) {
$msg = $C_translate->translate('val_exp', 'account_billing', '');
$C_debug->alert($msg);
return false;
}
# Validate the card against the card type
include_once PATH_CORE . 'validate.inc.php';
$validate = new CORE_validate();
if (!$validate->validate_cc(@$VAR['account_billing_card_num'], 'card_num', @$VAR['account_billing_card_type'], false)) {
$msg = $C_translate->translate('val_cc', 'account_billing', '');
$C_debug->alert($msg);
return false;
}
$this->method["{$type}"] = $db->ignore_fields(array('eft_trn', 'eft_check_acct'), $this->method["{$type}"]);
/* last four */
@($VAR['account_billing_card_num4'] = substr($VAR['account_billing_card_num'], strlen($VAR['account_billing_card_num']) - 4, 4));
}
if ($db->update($VAR, $this, $type)) {
# Update any invoices using this billing record
$dba =& DB();
$sql = "UPDATE " . AGILE_DB_PREFIX . "invoice SET\n\t\t\t\t\t\tcheckout_plugin_id \t= " . $dba->qstr($checkout_plugin_id) . "\n\t\t\t\t\t\tWHERE site_id\t\t\t\t= " . $dba->qstr(DEFAULT_SITE) . "\n\t\t\t\t\t\tAND account_billing_id\t= " . $dba->qstr($billing_id);
$result = $dba->Execute($sql);
return true;
}
return false;
}
function update($VAR)
{
$type = "update";
$this->method["{$type}"] = explode(",", $this->method["{$type}"]);
$db = new CORE_database();
$db->update($VAR, $this, $type);
# update the voip_sip table fields
$db =& DB();
$rs = $db->Execute(sqlSelect($db, "voip_did", "did", "id=::" . $VAR['id'] . "::"));
#echo "<pre>".print_r($VAR,true)."</pre>";
$f[0]['username'] = $VAR['sip_username'];
$f[1]['secret'] = $VAR['sip_secret'];
$f[2]['qualify'] = $VAR['sip_qualify'];
$f[3]['mailbox'] = $VAR['sip_mailbox'];
$f[4]['incominglimit'] = $VAR['sip_incominglimit'];
$f[5]['dtmfmode'] = $VAR['sip_dtmfmode'];
$f[6]['canreinvite'] = $VAR['sip_canreinvite'];
$f[7]['callerid'] = $VAR['sip_callerid'];
$f[8]['nat'] = $VAR['sip_nat'];
for ($i = 0; $i < 9; $i++) {
#echo "<pre>".print_r($f[$i],true)."</pre>";
$k = key($f[$i]);
$v = $f[$i][$k];
if (empty($v)) {
$sql = "DELETE FROM " . AGILE_DB_PREFIX . "voip_sip WHERE sip=" . $db->qstr($rs->fields['did']) . " and keyword=" . $db->qstr($k) . " and site_id=" . DEFAULT_SITE;
} else {
$rs2 = $db->Execute(sqlSelect($db, "voip_sip", "id", "sip=::" . $rs->fields['did'] . ":: AND keyword=::" . $k . "::"));
if ($rs2 && $rs2->fields[0] > 0) {
$sql = "UPDATE " . AGILE_DB_PREFIX . "voip_sip SET data=" . $db->qstr($v) . " WHERE sip=" . $db->qstr($rs->fields['did']) . " and keyword=" . $db->qstr($k) . " and site_id=" . DEFAULT_SITE;
} else {
$flds['data'] = $v;
$flds['keyword'] = $k;
$flds['sip'] = $rs->fields['did'];
$sql = sqlInsert($db, "voip_sip", $flds);
# $sql = "INSERT INTO ".AGILE_DB_PREFIX."voip_sip SET data=".$db->qstr($v)." WHERE sip=".$db->qstr($rs->fields['did'])." and keyword=".$db->qstr($k)." and site_id=".DEFAULT_SITE;
}
}
if (!$db->Execute($sql)) {
echo $db->ErrorMsg();
}
}
}
