|
dolibarr 24.0.0-beta
|
Upgrade some data. More...
Go to the source code of this file.
Functions | |
| migrate_paiements_orphelins_1 ($db, $langs, $conf) | |
| Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL) | |
| migrate_paiements_orphelins_2 ($db, $langs, $conf) | |
| Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL) | |
| migrate_contracts_det ($db, $langs, $conf) | |
| Update the contracts (Contract Management + Contract Detail) | |
| migrate_links_transfert ($db, $langs, $conf) | |
| Function to migrate links into llx_bank_url. | |
| migrate_contracts_date1 ($db, $langs, $conf) | |
| Update missing Contract Dates. | |
| migrate_contracts_date2 ($db, $langs, $conf) | |
| Update contracts with date min real if service date is lower. | |
| migrate_contracts_date3 ($db, $langs, $conf) | |
| Mise a jour des dates de creation de contrat. | |
| migrate_contracts_open ($db, $langs, $conf) | |
| Reopen the contracts that have at least one line that is not closed (/completed). | |
| migrate_paiementfourn_facturefourn ($db, $langs, $conf) | |
| Factures fournisseurs. | |
| migrate_price_facture ($db, $langs, $conf) | |
| Update total of invoice lines. | |
| migrate_price_propal ($db, $langs, $conf) | |
| Update total of proposal lines. | |
| migrate_price_contrat ($db, $langs, $conf) | |
| Update total of contract lines. | |
| migrate_price_commande ($db, $langs, $conf) | |
| Update total of sales order lines. | |
| migrate_price_commande_fournisseur ($db, $langs, $conf) | |
| Update total of purchase order lines. | |
| migrate_modeles ($db, $langs, $conf) | |
| Mise a jour des modeles selectionnes. | |
| migrate_commande_expedition ($db, $langs, $conf) | |
| Relations between the Shipping and Client Order in the table llx_co_exp. | |
| migrate_commande_livraison ($db, $langs, $conf) | |
| Correspondence of the deliveries and the Customer Orders in the table llx_co_liv. | |
| migrate_detail_livraison ($db, $langs, $conf) | |
| Migrate the Order Details in the Delivery Details. | |
| migrate_stocks ($db, $langs, $conf) | |
| Migration of the stock field in the Products table. | |
| migrate_menus ($db, $langs, $conf) | |
| Migration of menus (use only 1 table instead of 3) 2.6 -> 2.7. | |
| migrate_commande_deliveryaddress ($db, $langs, $conf) | |
| Migration du champ fk_adresse_livraison dans expedition 2.6 -> 2.7. | |
| migrate_restore_missing_links ($db, $langs, $conf) | |
Migration du champ fk_remise_except dans llx_facturedet doit correspondre a Link in llx_societe_remise_except to llx_facturedet | |
| migrate_project_user_resp ($db, $langs, $conf) | |
| Migration du champ fk_user_resp de llx_projet vers llx_element_contact. | |
| migrate_project_task_actors ($db, $langs, $conf) | |
| Migration de la table llx_projet_task_actors vers llx_element_contact. | |
| migrate_relationship_tables ($db, $langs, $conf, $table, $fk_source, $sourcetype, $fk_target, $targettype) | |
| Migration des tables de relation. | |
| migrate_element_time ($db, $langs, $conf) | |
| Migrate duration in seconds. | |
| migrate_customerorder_shipping ($db, $langs, $conf) | |
| Migrate order ref_customer and date_delivery fields to llx_expedition. | |
| migrate_shipping_delivery ($db, $langs, $conf) | |
| Migrate link stored into fk_expedition into llx_element_element. | |
| migrate_shipping_delivery2 ($db, $langs, $conf) | |
| We try to complete field ref_customer and date_delivery that are empty into llx_livraison. | |
| migrate_actioncomm_element ($db, $langs, $conf) | |
| Migrate link stored into fk_xxxx into fk_element and elementtype. | |
| migrate_mode_reglement ($db, $langs, $conf) | |
| Migrate link stored into fk_mode_reglement. | |
| migrate_clean_association ($db, $langs, $conf) | |
| Delete duplicates in table categorie_association. | |
| migrate_categorie_association ($db, $langs, $conf) | |
| Migrate categorie association. | |
| migrate_event_assignement ($db, $langs, $conf) | |
| Migrate event assignment to owner. | |
| migrate_event_assignement_contact ($db, $langs, $conf) | |
| Migrate event assignment to owner. | |
| migrate_reset_blocked_log ($db, $langs, $conf) | |
| Migrate to reset the blocked log for V7+ algorithm. | |
| migrate_remise_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_societe_remise. | |
| migrate_remise_except_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_societe_remise_except. | |
| migrate_user_rights_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_user_rights. | |
| migrate_usergroup_rights_entity ($db, $langs, $conf) | |
| Migrate to add entity value into llx_usergroup_rights. | |
| migrate_rename_directories ($db, $langs, $conf, $oldname, $newname) | |
| Migration directory. | |
| migrate_delete_old_files ($db, $langs, $conf) | |
| Delete deprecated files. | |
| migrate_delete_old_dir ($db, $langs, $conf) | |
| Remove deprecated directories. | |
| migrate_reload_modules ($db, $langs, $conf, $listofmodule=array(), $force=0) | |
| Disable/Re-enable features modules. | |
| migrate_reload_menu ($db, $langs, $conf) | |
| Reload SQL menu file (if dynamic menus, if modified by version) | |
| migrate_productlot_path () | |
| Migrate file from old path to new one for lot path. | |
| migrate_user_photospath () | |
| Migrate file from old path to new one for users. | |
| migrate_user_photospath2 () | |
| Migrate file from old path users/99/file.jpg into users/99/photos/file.jpg. | |
| migrate_holiday_path () | |
| Migrate file from old path to new one for users. | |
| migrate_users_socialnetworks () | |
| Migrate users fields facebook and co to socialnetworks. | |
| migrate_members_socialnetworks () | |
| Migrate members fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_contacts_socialnetworks () | |
| Migrate contacts fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_thirdparties_socialnetworks () | |
| Migrate thirdparties fields facebook and co to socialnetworks Can be called only when version is 10.0. | |
| migrate_export_import_profiles ($mode='export') | |
| Migrate export and import profiles to fix field name that was renamed. | |
| migrate_contractdet_rank () | |
| Migrate Rank into contract line. | |
| migrate_invoice_export_models () | |
| Invoice exports been shifted (facture_1 => facture_0, facture_2 => facture_1) in version 20, shift export models accordingly. | |
| migrate_accountingbookkeeping (int $entity) | |
| Migrate Ref in bookkeeping lines. | |
| migrate_apiresttokens () | |
| Migrate API key in oauth_token table. | |
| migrate_blockedlog_add_hmac_key () | |
| Add the HMAC key for blockedlog v2+ Note that this is used on old version only. | |
Variables | |
| if($db !==null && $db->connected) if( $ret | migrate_paiements )($db, $langs, $conf) |
| Records payment links for an invoice in a join table (link n<-->n for payments<-->invoices) | |
Upgrade some data.
Definition in file upgrade2.php.
| migrate_accountingbookkeeping | ( | int | $entity | ) |
Migrate Ref in bookkeeping lines.
| int | $entity | Entity id |
Definition at line 5485 of file upgrade2.php.
References $db, dol_mktime(), dol_print_error(), dolibarr_set_const(), and getDolGlobalString().
| migrate_actioncomm_element | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_xxxx into fk_element and elementtype.
Definition at line 3405 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_apiresttokens | ( | ) |
Migrate API key in oauth_token table.
Definition at line 5552 of file upgrade2.php.
References $conf, $db, dol_now(), dol_print_error(), dolDecrypt(), dolEncrypt(), and getDolUserInt().
| migrate_blockedlog_add_hmac_key | ( | ) |
Add the HMAC key for blockedlog v2+ Note that this is used on old version only.
It stores the HMAC with old method but it will be automatically converted in new storing method once on version of blockedlog 3.0.0
Definition at line 5641 of file upgrade2.php.
References $conf, $db, dol_print_error(), dolDecrypt(), dolibarr_set_const(), and getDolGlobalString().
| migrate_categorie_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate categorie association.
Definition at line 3629 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_clean_association | ( | $db, | |
| $langs, | |||
| $conf ) |
Delete duplicates in table categorie_association.
Definition at line 3554 of file upgrade2.php.
References $db, and dolibarr_install_syslog().
| migrate_commande_deliveryaddress | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_adresse_livraison dans expedition 2.6 -> 2.7.
Definition at line 2593 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_expedition | ( | $db, | |
| $langs, | |||
| $conf ) |
Relations between the Shipping and Client Order in the table llx_co_exp.
Definition at line 2217 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_commande_livraison | ( | $db, | |
| $langs, | |||
| $conf ) |
Correspondence of the deliveries and the Customer Orders in the table llx_co_liv.
Definition at line 2282 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_contacts_socialnetworks | ( | ) |
Migrate contacts fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 5098 of file upgrade2.php.
References $db, and dol_print_error().
| migrate_contractdet_rank | ( | ) |
Migrate Rank into contract line.
Definition at line 5355 of file upgrade2.php.
References $db, and dol_print_error().
| migrate_contracts_date1 | ( | $db, | |
| $langs, | |||
| $conf ) |
Update missing Contract Dates.
Definition at line 1406 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_date2 | ( | $db, | |
| $langs, | |||
| $conf ) |
Update contracts with date min real if service date is lower.
Definition at line 1448 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_date3 | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des dates de creation de contrat.
Definition at line 1516 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_det | ( | $db, | |
| $langs, | |||
| $conf ) |
Update the contracts (Contract Management + Contract Detail)
Definition at line 1247 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_contracts_open | ( | $db, | |
| $langs, | |||
| $conf ) |
Reopen the contracts that have at least one line that is not closed (/completed).
Definition at line 1546 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_customerorder_shipping | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate order ref_customer and date_delivery fields to llx_expedition.
Definition at line 3153 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_delete_old_dir | ( | $db, | |
| $langs, | |||
| $conf ) |
Remove deprecated directories.
Definition at line 4350 of file upgrade2.php.
References dol_delete_dir_recursive(), and dolibarr_install_syslog().
| migrate_delete_old_files | ( | $db, | |
| $langs, | |||
| $conf ) |
Delete deprecated files.
Definition at line 4239 of file upgrade2.php.
References dol_delete_file(), and dolibarr_install_syslog().
| migrate_detail_livraison | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate the Order Details in the Delivery Details.
Definition at line 2362 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_element_time | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate duration in seconds.
Definition at line 3048 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignment to owner.
Definition at line 3695 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_event_assignement_contact | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate event assignment to owner.
Definition at line 3761 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_export_import_profiles | ( | $mode = 'export' | ) |
Migrate export and import profiles to fix field name that was renamed.
| string | $mode | 'export' or 'import' |
Definition at line 5286 of file upgrade2.php.
References $db, and dol_print_error().
| migrate_holiday_path | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4815 of file upgrade2.php.
References $conf, $db, dol_copy(), dol_is_dir(), dol_is_file(), dol_mkdir(), dol_osencode(), and get_exdir().
| migrate_invoice_export_models | ( | ) |
Invoice exports been shifted (facture_1 => facture_0, facture_2 => facture_1) in version 20, shift export models accordingly.
Definition at line 5412 of file upgrade2.php.
References $db, dol_print_error(), dolibarr_set_const(), getDolGlobalInt(), getDolGlobalString(), and versioncompare().
| migrate_links_transfert | ( | $db, | |
| $langs, | |||
| $conf ) |
Function to migrate links into llx_bank_url.
Definition at line 1332 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_members_socialnetworks | ( | ) |
Migrate members fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 5006 of file upgrade2.php.
References $db, and dol_print_error().
| migrate_menus | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration of menus (use only 1 table instead of 3) 2.6 -> 2.7.
Definition at line 2526 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_mode_reglement | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_mode_reglement.
Definition at line 3464 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_modeles | ( | $db, | |
| $langs, | |||
| $conf ) |
Mise a jour des modeles selectionnes.
Definition at line 2159 of file upgrade2.php.
References $db, dol_print_error(), dolibarr_install_syslog(), isModEnabled(), ModelePDFCommandes\liste_modeles(), ModelePdfExpedition\liste_modeles(), and ModelePDFFactures\liste_modeles().
| migrate_paiementfourn_facturefourn | ( | $db, | |
| $langs, | |||
| $conf ) |
Factures fournisseurs.
Definition at line 1609 of file upgrade2.php.
References $db, amount, and dolibarr_install_syslog().
| migrate_paiements_orphelins_1 | ( | $db, | |
| $langs, | |||
| $conf ) |
Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL)
Definition at line 1013 of file upgrade2.php.
References $db, dol_print_error(), dolibarr_install_syslog(), and getDolGlobalInt().
| migrate_paiements_orphelins_2 | ( | $db, | |
| $langs, | |||
| $conf ) |
Repair orphan payments (lost relations due to bugs) Query to check if there are still orphans: select * from llx_paiement as p left join llx_paiement_facture as pf on pf.fk_paiement=p.rowid WHERE pf.rowid IS NULL AND (p.fk_facture = 0 OR p.fk_facture IS NULL)
Definition at line 1123 of file upgrade2.php.
References $db, dol_print_error(), dolibarr_install_syslog(), and getDolGlobalInt().
| migrate_price_commande | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of sales order lines.
Definition at line 1975 of file upgrade2.php.
References $conf, $db, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_commande_fournisseur | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of purchase order lines.
Definition at line 2066 of file upgrade2.php.
References $conf, $db, $mysoc, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_contrat | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of contract lines.
Definition at line 1891 of file upgrade2.php.
References $conf, $db, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_facture | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of invoice lines.
Definition at line 1705 of file upgrade2.php.
References $conf, $db, calcul_price_total(), and dolibarr_install_syslog().
| migrate_price_propal | ( | $db, | |
| $langs, | |||
| $conf ) |
Update total of proposal lines.
Definition at line 1810 of file upgrade2.php.
References $conf, $db, calcul_price_total(), and dolibarr_install_syslog().
| migrate_productlot_path | ( | ) |
Migrate file from old path to new one for lot path.
Definition at line 4571 of file upgrade2.php.
References $conf, $db, dol_is_dir(), dol_move_dir(), get_exdir(), and string.
| migrate_project_task_actors | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration de la table llx_projet_task_actors vers llx_element_contact.
Definition at line 2887 of file upgrade2.php.
References $db, dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_project_user_resp | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_user_resp de llx_projet vers llx_element_contact.
Definition at line 2806 of file upgrade2.php.
References $db, dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_relationship_tables | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $table, | |||
| $fk_source, | |||
| $sourcetype, | |||
| $fk_target, | |||
| $targettype ) |
Migration des tables de relation.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| string | $table | Table name |
| string | $fk_source | Id of element source (name of field) |
| string | $sourcetype | Type of element source |
| string | $fk_target | Id of element target |
| string | $targettype | Type of element target |
Definition at line 2969 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_reload_menu | ( | $db, | |
| $langs, | |||
| $conf ) |
Reload SQL menu file (if dynamic menus, if modified by version)
Definition at line 4534 of file upgrade2.php.
References $conf, dolibarr_install_syslog(), getDolGlobalString(), and run_sql().
| migrate_reload_modules | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $listofmodule = array(), | |||
| $force = 0 ) |
Disable/Re-enable features modules.
We must do this when internal menu of module or permissions has changed or when triggers have moved.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| array<string,'noboxes'|'menuonly'|'newboxdefonly'|'forceactivate'> | $listofmodule List of modules, like array('MODULE_KEY_NAME'=>$reloadmode, ...) | |
| int<0,1> | $force 1=Reload module even if not already loaded |
Definition at line 4395 of file upgrade2.php.
References $db, dol_include_once(), dolibarr_install_syslog(), and isModEnabled().
| migrate_remise_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_societe_remise.
Definition at line 3927 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_remise_except_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_societe_remise_except.
Definition at line 3993 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_rename_directories | ( | $db, | |
| $langs, | |||
| $conf, | |||
| $oldname, | |||
| $newname ) |
Migration directory.
| DoliDB | $db | Database handler |
| Translate | $langs | Object langs |
| Conf | $conf | Object conf |
| string | $oldname | Old name (relative to DOL_DATA_ROOT) |
| string | $newname | New name (relative to DOL_DATA_ROOT) |
Definition at line 4217 of file upgrade2.php.
References dolCopyDir(), and dolibarr_install_syslog().
| migrate_reset_blocked_log | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to reset the blocked log for V7+ algorithm.
Definition at line 3828 of file upgrade2.php.
References $db, $object, dol_now(), dol_print_error(), and dolibarr_install_syslog().
| migrate_restore_missing_links | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration du champ fk_remise_except dans llx_facturedet doit correspondre a Link in llx_societe_remise_except to llx_facturedet
Definition at line 2663 of file upgrade2.php.
References $db, dol_print_error(), dolibarr_install_syslog(), and versioncompare().
| migrate_shipping_delivery | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate link stored into fk_expedition into llx_element_element.
Definition at line 3237 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_shipping_delivery2 | ( | $db, | |
| $langs, | |||
| $conf ) |
We try to complete field ref_customer and date_delivery that are empty into llx_livraison.
We set them with value from llx_expedition.
Definition at line 3332 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_stocks | ( | $db, | |
| $langs, | |||
| $conf ) |
Migration of the stock field in the Products table.
Definition at line 2464 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_thirdparties_socialnetworks | ( | ) |
Migrate thirdparties fields facebook and co to socialnetworks Can be called only when version is 10.0.
Definition at line 5194 of file upgrade2.php.
References $db, and dol_print_error().
| migrate_user_photospath | ( | ) |
Migrate file from old path to new one for users.
Definition at line 4633 of file upgrade2.php.
References $conf, $db, dol_copy(), dol_is_dir(), dol_is_file(), dol_mkdir(), dol_osencode(), and get_exdir().
| migrate_user_photospath2 | ( | ) |
Migrate file from old path users/99/file.jpg into users/99/photos/file.jpg.
Definition at line 4722 of file upgrade2.php.
References $db, dol_copy(), dol_is_dir(), dol_is_file(), dol_mkdir(), and dol_osencode().
| migrate_user_rights_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_user_rights.
Definition at line 4085 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_usergroup_rights_entity | ( | $db, | |
| $langs, | |||
| $conf ) |
Migrate to add entity value into llx_usergroup_rights.
Definition at line 4150 of file upgrade2.php.
References $db, dol_print_error(), and dolibarr_install_syslog().
| migrate_users_socialnetworks | ( | ) |
Migrate users fields facebook and co to socialnetworks.
Can be called only when version is 10.0.* or lower. Fields does not exists after.
Definition at line 4915 of file upgrade2.php.
References $db, and dol_print_error().