=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;
?>