/** * 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; }