=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; } } // copy all item codes from stock_master into item_codes $sql = "SELECT `stock_id`,`description`,`category_id` FROM ".$pref."stock_master"; $result = db_query($sql); if (!$result) { display_error(_("Cannot select stock identificators") .':
'. db_error_msg($db)); return false; } else { while ($row = db_fetch_assoc($result)) { $sql = "INSERT IGNORE " .$pref."item_codes (`item_code`,`stock_id`,`description`,`category_id`) VALUES('".$row['stock_id']."','".$row['stock_id']."','" .$row['description']."','".$row['category_id']."')"; $res2 = db_query($sql); if (!$res2) { display_error(_("Cannot insert stock id into item_codes") .':
'. db_error_msg($db)); return false; } } } // remove obsolete bank_trans_types table // (DROP queries are skipped during non-forced upgrade) $sql = "DROP TABLE IF EXISTS `0_bank_trans_types`"; db_query($sql); 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) { if (check_table($pref, 'item_codes')) return false; if (check_table($pref, 'company', 'foreign_codes')) return false; return true; } }; $install = new fa2_1; ?>