OScommerce expert to fix DB errors, HTML/Javascript, Automated email to Admin+Customer (POP3 issue) & other issues

BUDGET US$ 50 Prefer coder to have production server Basically, want to upgrade code to PHP 7.XX. PRIORITY is to get DB working first before doing other points 1/ FIX: DB error Site does not load See: error-message -------------------------------------------------------- Warning: mysqli_connect(): (HY000/1044): Access denied for user 'XYZ'@'localhost' to database 'ABC' in /ABC/admin/includes/functions/[login to view URL] on line 25 Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in /ABC/admin/includes/functions/[login to view URL] on line 32 Unable to connect to database server! -------------------------------------------------------- 2/ FIX: CUSTOMER & ADMIN to get auto-email Already coded but suddenly stopped working few years ago. Should require little work Currently using POP3. Use SMTP instead? Prefer POP3 solution unless good reason 3/ IMPLEMENT additional fields at top of report (auto-email to ADMIN, /print-order page. NOT apply to auto-email to Customer See: automated-email-to-admin automated-email-to-customer Date: Time: User IP address: Browser Agent: Order No: Subject: [see 4 below for details] ACTUAL BODY TEXT CONTENT OF EMAIL UNCHANGED, ALREADY CODED BACKGROUND: (Already coded, stopped working) A/ Admin gets 1 email at 2 stages: - 1st: when customer successfully onClick SUBMIT form (/[login to view URL]) - 2nd: after successful payment (Paypal is processor) B/ /[login to view URL] only shows report ONCE (after payment successful) . No report generated after onClick SUBMIT C/ Customer same as B/ 4/ IMPLEMENT: auto-email to Admin AND /[login to view URL]) have subject title containing certain customer input Not already coded See: automated-email-to-admin automated-email-to-customer Format: ORDER SCAN / DISPATCHED #echo["order_number"]: echo[Product class1] nbsp& echo([payslip_dates]) {Product class2] "p60_taxcode" [Product class3] ["p45_dlday"] "-" echo("employer_name") "/" echo["droptitle"] nbsp& echo["fname"] nbsp& echo("lname") If Null input, no output shown (if customer has ordered a product from each of three product classes (Payslips, P60, P45), subject title will show eg): -------------------------------------------------------------- ORDER SCAN / DISPATCHED #19678: Payslips (1/12/2018,1/1/2019) P60 (2018/19**) P45 (15/10/2019) - ABC Limited / Miss Jane Smith -------------------------------------------------------------- BACKGROUND: A/ variables are from /[login to view URL]: id="order_number" id="employer_name" id="payslip_dates" id="droptitle" id="fname id="lname" id="p60_taxcode" id="p45_dlday" Need to determine product class (3 classes): Product class1 is "Payslips" Product class2 is "P60" Product class3 is "P45" B/ How to map (ID="p60_taxcode") to relevant tax year? (eg "1185L" should map to "2018/19" etc) eg p60_taxcode = "1185L" etc is initialized but corresponding tax year (ie "2018/19") is not So need to map relevant tax year to p60_taxcode See: map-tax-year-to-taxcode 5/ FIX: HTML/Javascript issue on form (/[login to view URL]). Not working see: JS-HMTL-not-working Already coded but stopped Javascript features stopped working few years ago. Should require little work 6/ REMOVE funny symbol (want £ instead) & garbage from form & homepage See: remove-symbol-formpage remove-garbage 7/ FIX: After payment (Paypal is processor), should re-direct to 'Thank you. Order confirmed' page Already coded Currently, after payment, redirects back to 'Payment Options' page so customer unsure if payment successful or not 8/ REMOVE pre-populated text from field in auto-email (submitted details) to: Admin, /print-order, Customer See: remove-pre-populated-text-in-submitted-details New code required. Applies for auto-email to: - Admin - Customer - /[login to view URL] Currently, pre-populated text is include in field of submitted details when customer made no input. Submitted details should include only customer input. If no customer input, field is empty