SMARTKABIR - COMPLETE SITE PACKAGE
==================================

This package is your original project with every update applied, in the order delivered.

UPLOAD
- Upload everything in this folder to your site (public_html), replacing the old files.
- connectdb.php is NOT included. Keep the connectdb.php already on your server (it holds your database
  details). connectdb.php.example is a template if you need a new one: rename it and enter your details.
- Do not upload the old database dump; use database-final.sql instead (see DATABASE).

DATABASE
- New database: import database-final.sql in phpMyAdmin (it creates every table and column).
- Existing database with data: do not drop it. Check that these exist, and add any missing one:
    admin_note       column in subscribers   (ALTER TABLE subscribers ADD COLUMN admin_note text NULL;)
    last_payment_date column in events      (ALTER TABLE events ADD COLUMN last_payment_date date NULL;)
    image            column in events        (ALTER TABLE events ADD COLUMN image varchar(255) NULL;)
    tables: birthday_log, member_accounts, event_registration_items, event_config, event_tickets,
            event_registrations, events, mail_campaigns, mail_queue
  The easiest check: Admin > Events > Check installation.

SETTINGS (Admin > General and Admin > Birthdays)
- Admin email, mailer email, admin name, admin password (change it from admin/admin).
- Download Link (General): full https:// address for the welcome email.
- SMS (Birthdays): API key and approved sender ID.
- Birthday cron: birthday-cron.php, run daily by cPanel or cron-job.org (see cpanel-cron-setup.txt).

MEMBER PROFILE + DEFAULT HEADER (new in this version)
- Member information form: member-profile.html (WordPress block, posts to sent.php) and the member profile
  (/member/) use the same 30 questions, with photo and NID uploads.
- Existing database: run add-member-profile-fields.sql once (adds the new member columns).
- Default header: Admin > General > "Default header image". It is used at the top of event pages that have no
  image of their own, and at the top of the member profile.

ADMIN SETTINGS (Admin > General)
- Logo, favicon (browser tab icon), default header and default footer images: upload and save.
  The header and footer show on all admin pages except the Spreadsheet; the default footer also shows on
  event pages and the member profile. An event with its own header image uses that instead of the default.
- Member number prefix (for example SSC86-): new member numbers are the prefix followed by the ID. Empty = 1, 2, 3 ...
  Members who already have a number keep it.
- Facebook Messenger (page name or address) and WhatsApp number: buttons at the bottom-right of the member profile.

ADMIN MENU
- Home; Setting (General, Payment, Birthday, Email, Autoresponder); Module (Member: Edit, View all,
  Spreadsheet, Import excel; Event: Events); Logout.

KNOWN NOTES
- download.php and unsub.php include banners.php, which was not in your original upload. Create an empty
  banners.php (<?php ?>) in the site root if those pages report a missing file.
- Member area: https://YOURSITE/member/ (login, register, profile).
- The admin Edit, Spreadsheet and Excel pages still use the earlier question list; the new member fields are
  saved and emailed, but are not yet shown in those admin pages (next step).
- Event pages: https://YOURSITE/event.php?e=ID.