$_POST['store_email'] = load_config_value('COMPANY_EMAIL'); } if (!isset($_POST['store_website'])) { $_POST['store_website'] = load_config_value('COMPANY_WEBSITE'); } if (!isset($_POST['store_telephone1'])) { $_POST['store_telephone1'] = load_config_value('COMPANY_TELEPHONE1'); } if (!isset($_POST['store_telephone2'])) { $_POST['store_telephone2'] = load_config_value('COMPANY_TELEPHONE2'); } if (!isset($_POST['store_fax'])) { $_POST['store_fax'] = load_config_value('COMPANY_FAX'); } if (!isset($_POST['store_default_currency'])) { $_POST['store_default_currency'] = load_config_value('DEFAULT_CURRENCY'); } if (isset($_POST['submit'])) { $store_id = db_prepare_input($_POST['store_id']); $store_name = db_prepare_input($_POST['store_name']); $store_address1 = db_prepare_input($_POST['store_address1']); $store_address2 = db_prepare_input($_POST['store_address2']); $store_city_town = db_prepare_input($_POST['store_city_town']); $store_zone = db_prepare_input($_POST['store_zone']); $store_postal_code = db_prepare_input($_POST['store_postal_code']); $store_country = db_prepare_input($_POST['store_country']); $store_email = db_prepare_input($_POST['store_email']); $store_website = db_prepare_input($_POST['store_website']); $store_telephone1 = db_prepare_input($_POST['store_telephone1']); $store_telephone2 = db_prepare_input($_POST['store_telephone2']); $store_fax = db_prepare_input($_POST['store_fax']);
function best_acct_guess($id, $keyword, $default) { global $db; $pulldown = ''; $best_guess = load_config_value($default); if (!$best_guess) { $sql = "select c.id \r\n\t\tfrom " . DB_PREFIX . "chart_of_accounts c inner join " . DB_PREFIX . "chart_of_accounts_types t on c.account_type = t.id\r\n\t\twhere t.id = " . $id . " and c.description like '%" . $keyword . "%' limit 1"; $result = $db->Execute($sql); if ($result->RecordCount() == 0) { // no record found, fetch at first account of specified type $result = $db->Execute("select id from " . DB_PREFIX . "chart_of_accounts where account_type = " . $id . " order by id"); } $best_guess = $result->fields['id']; } return $best_guess; }