=4.0.4: UPDATE `0_bank_trans`, `0_bank_accounts` SET 0_bank_trans.bank_act=0_bank_accounts.id WHERE 0_bank_trans.bank_act=0_bank_accounts.account_code; */ $sql = "SELECT id, account_code FROM ".$pref."bank_accounts"; if(!($res = db_query($sql))) { display_error(_("Cannot retrieve bank accounts codes") .':
'. db_error_msg($db)); return false; } while ($acc = db_fetch($res)) { $sql = "UPDATE ".$pref."bank_trans SET bank_act='" .$acc['id']."' WHERE bank_act=".$acc['account_code']; if (db_query($sql)==false) { display_error(_("Cannot update bank transactions") .':
'. db_error_msg($db)); return false; } } return true; } // // Checking before install // function pre_check($pref) { return true; // true when ok, fail otherwise } // // Test if patch was applied before. // function installed($pref) { return !check_table($pref, 'item_codes'); } }; $install = new fa2_1; ?>