/**
* Create a new config field.
*
* @param $config_key
* @param $config_title
* @param $config_value
* @param $config_description
* @param $config_group_id
* @param $config_sort_order
* @param $config_use_function
* @param $config_set_function
*/
static function create_config_field($config_key, $config_title, $config_value, $config_description, $config_group_id, $config_sort_order, $config_use_function, $config_set_function)
{
$query = 'INSERT INTO ' . TABLE_CONFIGURATION . ' (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values (:configTitle:, :configKey:, :configValue:, :configDescription:, :configGroupID:, :configSortOrder:, :configUseFunction:, :configSetFunction:, now())';
$query = bind_vars($query, ':configTitle:', $config_title);
$query = bind_vars($query, ':configKey:', $config_key);
$query = bind_vars($query, ':configValue:', $config_value);
$query = bind_vars($query, ':configDescription:', $config_description);
$query = bind_vars($query, ':configGroupID:', $config_group_id);
$query = bind_vars($query, ':configSortOrder:', $config_sort_order);
$query = bind_vars($query, ':configUseFunction:', $config_use_function);
$query = bind_vars($query, ':configSetFunction:', $config_set_function);
tep_db_query($query);
}
/**
* @param $customers_id
* @return bool
*/
public static function login_user($customers_id)
{
$query = "SELECT * FROM " . TABLE_CUSTOMERS . " WHERE `customers_id` = :customersID";
$query = bind_vars($query, ':customersID', $customers_id);
$customer = tep_db_fetch_array(tep_db_query($query));
if (!empty($customer['customers_id'])) {
$_SESSION['customer_id'] = $customer['customers_id'];
$_SESSION['customer_default_address_id'] = $customer['customers_default_address_id'];
$_SESSION['customers_authorization'] = $customer['customers_authorization'];
$_SESSION['customer_first_name'] = $customer['customers_firstname'];
$_SESSION['customer_last_name'] = $customer['customers_lastname'];
$query = "UPDATE " . TABLE_CUSTOMERS_INFO . " SET customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 WHERE customers_info_id = :customersID";
$query = bind_vars($query, ':customersID', $_SESSION['customer_id']);
tep_db_query($query);
$_SESSION['cart']->restore_contents();
return true;
}
return false;
}
