chore: add uploads directory to gitignore to prevent tracking user-uploaded files

- Changed album title to white color
- Added text-shadow to album title for better contrast over images
- Changed album description to white color
- Added text-shadow to album description for readability
- Ensures text is visible regardless of cover image darkness

.gitignore

@@ -1,6 +1,5 @@
 .env
 /vendor/
 .htaccess
-/uploads/
-
-/uploads/pop/
+/assets/uploads/gallery/
+/assets/uploads/

.htaccess

@@ -37,6 +37,7 @@ RewriteRule ^member_info$ src/pages/memberships/member_info.php [L]
 RewriteRule ^bookings$ src/pages/bookings/bookings.php [L]
 RewriteRule ^campsites$ src/pages/bookings/campsites.php [L]
 RewriteRule ^campsite_booking$ src/pages/bookings/campsite_booking.php [L]
+RewriteRule ^add_campsite$ src/pages/add_campsite.php [L]
 RewriteRule ^trips$ src/pages/bookings/trips.php [L]
 RewriteRule ^trip-details$ src/pages/bookings/trip-details.php [L]
 RewriteRule ^course_details$ src/pages/bookings/course_details.php [L]
@@ -50,6 +51,12 @@ RewriteRule ^payment_confirmation$ src/pages/shop/payment_confirmation.php [L]
 RewriteRule ^confirm$ src/pages/shop/confirm.php [L]
 RewriteRule ^confirm2$ src/pages/shop/confirm2.php [L]
 
+# === GALLERY PAGES ===
+RewriteRule ^gallery$ src/pages/gallery/gallery.php [L]
+RewriteRule ^create_album$ src/pages/gallery/create_album.php [L]
+RewriteRule ^edit_album$ src/pages/gallery/create_album.php [L]
+RewriteRule ^view_album$ src/pages/gallery/view_album.php [L]
+
 # === EVENTS & BLOG PAGES ===
 RewriteRule ^events$ src/pages/events/events.php [L]
 RewriteRule ^blog$ src/pages/events/blog.php [L]
@@ -76,13 +83,14 @@ RewriteRule ^view_indemnity$ src/pages/other/view_indemnity.php [L]
 RewriteRule ^admin_members$ src/admin/admin_members.php [L]
 RewriteRule ^admin_payments$ src/admin/admin_payments.php [L]
 RewriteRule ^admin_web_users$ src/admin/admin_web_users.php [L]
+RewriteRule ^admin_events$ src/admin/admin_events.php [L]
 RewriteRule ^admin_course_bookings$ src/admin/admin_course_bookings.php [L]
 RewriteRule ^admin_camp_bookings$ src/admin/admin_camp_bookings.php [L]
 RewriteRule ^admin_trip_bookings$ src/admin/admin_trip_bookings.php [L]
 RewriteRule ^admin_visitors$ src/admin/admin_visitors.php [L]
 RewriteRule ^admin_efts$ src/admin/admin_efts.php [L]
-RewriteRule ^add_campsite$ src/admin/add_campsite.php [L]
 RewriteRule ^admin_trips$ src/admin/admin_trips.php [L]
+RewriteRule ^manage_events$ src/admin/manage_events.php [L]
 RewriteRule ^manage_trips$ src/admin/manage_trips.php [L]
 
 # === API/AJAX ENDPOINTS ===
@@ -114,8 +122,16 @@ RewriteRule ^upload_profile_picture$ src/processors/upload_profile_picture.php [
 RewriteRule ^send_reset_link$ src/processors/send_reset_link.php [L]
 RewriteRule ^logout$ src/processors/logout.php [L]
 RewriteRule ^process_trip$ src/processors/process_trip.php [L]
+RewriteRule ^process_event$ src/admin/process_event.php [L]
 RewriteRule ^toggle_trip_published$ src/processors/toggle_trip_published.php [L]
+RewriteRule ^toggle_event_published$ src/admin/toggle_event_published.php [L]
 RewriteRule ^delete_trip$ src/processors/delete_trip.php [L]
+RewriteRule ^delete_event$ src/admin/delete_event.php [L]
+RewriteRule ^save_album$ src/processors/save_album.php [L]
+RewriteRule ^update_album$ src/processors/update_album.php [L]
+RewriteRule ^delete_album$ src/processors/delete_album.php [L]
+RewriteRule ^delete_photo$ src/processors/delete_photo.php [L]
+RewriteRule ^get_album_photos$ src/processors/get_album_photos.php [L]
 
 </IfModule>
 

docs/EVENTS_ADMIN_SYSTEM.md

@@ -0,0 +1,176 @@
+# Events Management Admin System
+
+## Overview
+A complete admin system for managing events on the 4WDCSA website, following the same patterns as the trip management system.
+
+## Files Created
+
+### 1. `/src/admin/manage_events.php`
+**Purpose**: Form for creating and editing events
+
+**Features**:
+- Create new events form
+- Edit existing events form
+- Fields:
+  - Event Name (required)
+  - Event Type (required) - e.g., Workshop, Training, Rally
+  - Location (required)
+  - Date (required)
+  - Time (required)
+  - Feature/Category (required) - e.g., Off-Road Training, Social Event
+  - Description (required) - Full text description
+  - Event Image (required for new, optional for updates)
+  - Promotional Image (optional) - Displayed when users click "View Promo"
+  - Published Status (checkbox) - Controls visibility on website
+
+**Technical Details**:
+- AJAX form submission to `process_event` endpoint
+- Image upload with validation
+- CSRF token protection
+- Responsive Bootstrap grid layout (col-md-6 fields)
+- Success/error message display with auto-redirect
+
+### 2. `/src/admin/process_event.php`
+**Purpose**: Backend endpoint for handling event CRUD operations
+
+**Endpoints**:
+- `POST /process_event` - Create/Update event
+- `GET /process_event?action=delete&event_id={id}` - Delete event
+
+**Features**:
+- Create new events with image uploads
+- Update existing events with optional image replacement
+- Delete events and associated image files
+- CSRF token validation
+- Image type validation (JPEG, PNG, GIF, WebP)
+- File organization in `/assets/images/events/`
+- Automatic timestamp management (created_at, updated_at)
+- User tracking (created_by stores admin user_id)
+
+**Image Handling**:
+- Main event image: Stored with unique ID prefix
+- Promo image: Stored with `_promo_` prefix
+- Both uploaded to `/assets/images/events/`
+
+### 3. `/src/admin/admin_events.php`
+**Purpose**: Admin dashboard for managing all events
+
+**Features**:
+- List all events with sortable columns
+- Real-time search/filter across all columns
+- Create new event button
+- Edit event link for each row
+- Delete event with confirmation dialog
+- Status badges (Published/Draft)
+- Responsive table with alternating row colors
+- Rounded corners on even rows
+
+**Sortable Columns**:
+- Event Name
+- Type
+- Location
+- Date
+- Status
+
+**Actions**:
+- Edit - Redirects to manage_events.php with event_id
+- Delete - Removes event and associated files
+
+## Database Schema Changes
+
+### Migration File: `/docs/migrations/001_add_events_tracking_columns.sql`
+
+**Columns Added to events table**:
+- `created_by` (int) - References user who created the event
+- `published` (tinyint(1)) - Boolean flag for publication status (default 0/false)
+- `created_at` (timestamp) - Automatic timestamp when event is created
+- `updated_at` (timestamp) - Automatic timestamp updated on modification
+
+**Indexes Added**:
+- `idx_date` - For sorting and filtering by date
+- `idx_published` - For filtering published/draft events
+- `idx_created_by` - For tracking who created events
+
+## Design Patterns
+
+### Follows Trip Management System Architecture
+- Same form layout and styling (`.comment-form.bgc-lighter`)
+- Same table styling with sortable headers and filters
+- Same image upload and validation patterns
+- AJAX submission with success/error messaging
+- Auto-redirect on successful operation
+
+### Image Organization
+```
+/assets/images/events/
+├── {unique_id}_{original_filename}.jpg (event images)
+└── {unique_id}_promo_{original_filename}.jpg (promo images)
+```
+
+### Front-end Integration
+The existing `/src/pages/events/events.php` displays published events:
+- Shows event image, name, location, date, time
+- Feature description and full description
+- "View Promo" button displays promotional image in modal
+
+## Usage Workflow
+
+### Creating an Event
+1. Navigate to `/src/admin/manage_events.php`
+2. Fill in all required fields
+3. Upload event image
+4. Optionally upload promotional image
+5. Check "Publish Event" if ready to display
+6. Submit form via AJAX
+7. Redirected to admin_events.php list view
+
+### Editing an Event
+1. Click "Edit" button on admin_events.php
+2. Modify any fields
+3. Image upload is optional - existing image retained if not changed
+4. Update timestamps and user tracking automatic
+5. Submit form
+6. Redirected back to list view
+
+### Deleting an Event
+1. Click "Delete" button on admin_events.php
+2. Confirm deletion in dialog
+3. Event and associated image files removed from server
+4. Page automatically refreshes
+
+### Publishing/Unpublishing
+- Toggle "Publish Event" checkbox before saving
+- Only published events appear on `/src/pages/events/events.php`
+- Draft events hidden from public view
+
+## Security Features
+
+1. **CSRF Token Protection**: All forms include CSRF token validation
+2. **Admin-only Access**: `checkAdmin()` function validates user permissions
+3. **File Validation**: Image type checking (JPEG, PNG, GIF, WebP)
+4. **SQL Injection Prevention**: Prepared statements with parameter binding
+5. **XSS Prevention**: `htmlspecialchars()` used for output escaping
+
+## Styling Classes
+
+**Form Container**: `.comment-form.bgc-lighter.z-1.rel.mb-30.rmb-55`
+**Action Buttons**: `.btn-edit`, `.btn-delete`
+**Status Badges**: `.badge.badge-published`, `.badge.badge-draft`
+**Tables**: Uses sortable header styling with visual sort indicators
+
+## Browser Compatibility
+
+- Modern browsers with AJAX/Fetch API support
+- JavaScript enabled required for filtering and sorting
+- File input accepts image MIME types
+
+## Future Enhancement Opportunities
+
+1. Bulk event operations (bulk delete, publish multiple)
+2. Event categories/tags system
+3. Event capacity limits with registrations
+4. Email notifications for published events
+5. Event calendar view
+6. Event image gallery (multiple images per event)
+7. Recurring events support
+8. Event attendee tracking

docs/MEMBERSHIP_DUPLICATE_PREVENTION.md

@@ -0,0 +1,86 @@
+# Membership Application Duplicate Prevention
+
+## Overview
+Implemented comprehensive validation to prevent users from submitting multiple membership applications or creating multiple membership fee records. Each user can have exactly one application and one membership fee record. Individual payments are tracked separately in the payments/efts table.
+
+## Architecture
+
+```
+User (1) ---> Membership Application (1) ---> Membership Fee (1) ---> Multiple Payments/EFTs
+```
+
+- **Membership Application**: Stores user details and application information (one per user)
+- **Membership Fee**: Stores the total fee amount and dates (one per user, linked to application)
+- **Payments/EFTs**: Tracks individual payment transactions for the membership fee (many per fee)
+
+## Changes Made
+
+### 1. Database Level Protection
+**File:** `docs/migrations/002_add_unique_constraints_membership.sql`
+
+- Added `UNIQUE` constraint on `membership_application.user_id` - ensures each user can only have one application
+- Added `UNIQUE` constraint on `membership_fees.user_id` - ensures each user can only have one membership fee record
+- Cleans up any duplicate records before adding constraints
+
+### 2. Application Level Validation
+**File:** `src/processors/process_application.php`
+
+Added pre-submission checks:
+- Check if user already has a membership application in the database
+- Check if user already has a membership fee record
+- Return clear error message if either check fails
+- Catch database constraint violations and provide user-friendly message
+
+**File:** `src/config/functions.php`
+
+- Improved `checkMembershipApplication()` to set session message before redirecting
+- Message displayed: "You have already submitted a membership application."
+
+### 3. Error Handling
+If a user somehow bypasses checks:
+- Server validates before processing
+- Returns HTTP 400 error with JSON response
+- User sees clear message directing them to support or check email
+- Database constraints prevent data corruption (duplicate key violation)
+
+## User Flow
+
+1. **First Visit to Application Page:**
+   - `checkMembershipApplication()` checks database
+   - If no application exists, shows form
+   - If application exists, redirects to `membership_details.php`
+
+2. **Form Submission:**
+   - Server checks for existing application
+   - Server checks for existing membership fee
+   - If checks pass, inserts application and fee in transaction
+   - On success, redirects to indemnity page
+   - On error, returns JSON error response
+
+3. **Payment Process:**
+   - Individual payment records are created in payments/efts table
+   - Multiple payments can be made against the single membership_fee record
+   - Payment status is tracked independently from application
+
+## Testing Recommendations
+
+1. Test creating a membership application - should succeed
+2. Try applying again - should be redirected to membership_details
+3. Try submitting the form multiple times rapidly - should fail on 2nd attempt
+4. Verify payments can be made against the single membership fee record
+5. Check database constraints: `SHOW INDEX FROM membership_application;` and `SHOW INDEX FROM membership_fees;`
+
+## Database Constraints
+
+```sql
+-- One application per user
+ALTER TABLE membership_application 
+ADD CONSTRAINT uk_membership_application_user_id UNIQUE (user_id);
+
+-- One membership fee record per user
+ALTER TABLE membership_fees 
+ADD CONSTRAINT uk_membership_fees_user_id UNIQUE (user_id);
+```
+
+## Backwards Compatibility
+The migration script cleans up any existing duplicate records before adding constraints, ensuring no data loss.

docs/PHOTO_GALLERY_IMPLEMENTATION.md

@@ -0,0 +1,494 @@
+# Photo Gallery Feature - Complete Implementation
+
+## Overview
+The Photo Gallery feature allows 4WDCSA members to create, manage, and view photo albums with a carousel interface for browsing and a lightbox viewer for detailed photo viewing.
+
+## Database Schema
+
+### photo_albums table
+```sql
+- album_id (INT, PK, AUTO_INCREMENT)
+- user_id (INT, FK to users)
+- title (VARCHAR 255, NOT NULL)
+- description (TEXT, nullable)
+- cover_image (VARCHAR 500, nullable - stores file path)
+- created_at (TIMESTAMP)
+- updated_at (TIMESTAMP)
+- UNIQUE INDEX on user_id (one album per user for now, can be modified)
+- INDEX on created_at for sorting
+```
+
+### photos table
+```sql
+- photo_id (INT, PK, AUTO_INCREMENT)
+- album_id (INT, FK to photo_albums, CASCADE DELETE)
+- file_path (VARCHAR 500, NOT NULL)
+- caption (VARCHAR 500, nullable)
+- display_order (INT, default 0)
+- created_at (TIMESTAMP)
+- INDEX on album_id for quick lookups
+- INDEX on display_order for sorting
+```
+
+## File Structure
+
+### Pages (Public-Facing)
+- `src/pages/gallery/gallery.php` - Main carousel view of all albums
+- `src/pages/gallery/view_album.php` - Detailed album view with photo grid and lightbox
+- `src/pages/gallery/create_album.php` - Form to create new albums and upload initial photos
+
+### Processors (Backend Logic)
+- `src/processors/save_album.php` - Creates new album and handles initial photo uploads
+- `src/processors/update_album.php` - Updates album metadata and handles additional photo uploads
+- `src/processors/delete_album.php` - Deletes entire album with all photos and files
+- `src/processors/delete_photo.php` - Deletes individual photos from album
+- `src/processors/get_album_photos.php` - API endpoint returning album photos as JSON
+
+### Styling
+All styling is embedded in each PHP file using `<style>` tags for consistency with existing pattern.
+
+## Features
+
+### Gallery View (gallery.php)
+**Purpose**: Display all photo albums in a carousel format
+
+**Features**:
+- Bootstrap carousel with Previous/Next buttons
+- Album cards showing:
+  - Cover image
+  - Album title
+  - Description
+  - Creator avatar and name
+  - Photo count
+  - "View Album" button
+- "Create Album" button (visible to all members)
+- Empty state message for members with no albums
+- Responsive design for mobile/tablet/desktop
+
+**Access Control**:
+- Members-only (redirects non-members to membership page)
+- Verified membership required
+
+### Album Detail View (view_album.php)
+**Purpose**: Display all photos from a single album with lightbox viewer
+
+**Features**:
+- Album header with:
+  - Creator information (avatar, name)
+  - Album title and description
+  - Photo count
+  - "Edit Album" button (visible only to album owner)
+- Responsive photo grid layout
+- Click any photo to open lightbox viewer
+- Lightbox features:
+  - Full-screen image display
+  - Previous/Next navigation buttons
+  - Caption display
+  - Keyboard navigation:
+    - Arrow Left: Previous photo
+    - Arrow Right: Next photo
+    - Escape: Close lightbox
+  - Close button (X)
+- Empty state message with "Add Photos" link for album owner
+- "Back to Gallery" button at bottom
+
+**Access Control**:
+- Public albums visible to all members
+- Edit button visible only to album owner
+
+### Create/Edit Album (create_album.php)
+**Purpose**: Create new albums or edit existing albums with photo uploads
+
+**Features**:
+- Album title input (required, validates with validateName())
+- Description textarea (optional, max 500 characters)
+- Drag-and-drop file upload area
+- File selection click-to-upload
+- Selected files list showing filename and size
+- Photo grid showing existing photos (edit mode only)
+- Delete button on each existing photo
+- Delete album button (edit mode only)
+- Submit and Cancel buttons
+
+**File Upload Validation**:
+- Allowed formats: JPG, PNG, GIF, WEBP
+- Max file size: 5MB per image
+- Validates MIME type and file size
+- Generates unique filenames with uniqid()
+- Stores in `/assets/uploads/gallery/{album_id}/`
+
+**Form Behavior**:
+- Create mode: Only allows setting album metadata and initial photos
+- Edit mode: Shows existing photos, allows adding new photos, allows editing metadata
+- First uploaded photo becomes cover image (auto-selected)
+- Photos can be deleted before submission (edit mode)
+- Form prepopulation on edit (title, description, existing photos)
+
+**Access Control**:
+- Members-only
+- Edit form checks album ownership before allowing edits
+- Redirect to gallery if not owner of album being edited
+
+## API Endpoints
+
+### GET /get_album_photos
+Returns JSON array of photos for an album
+
+**Parameters**:
+- `id`: Album ID (GET parameter)
+
+**Response**:
+```json
+[
+  {
+    "photo_id": 1,
+    "file_path": "/assets/uploads/gallery/1/photo_abc123.jpg",
+    "caption": "Sample photo",
+    "display_order": 1
+  }
+]
+```
+
+**Access Control**: Members-only, owner of album only
+
+### POST /delete_photo
+Deletes a photo and updates album cover if needed
+
+**Parameters**:
+- `photo_id`: Photo ID (POST)
+- `csrf_token`: CSRF token (POST)
+
+**Response**: 
+```json
+{ "success": true }
+```
+
+**Side Effects**:
+- Deletes photo file from disk
+- Removes photo from database
+- Updates album cover image if deleted photo was cover
+- Sets cover to first remaining photo or NULL if no photos left
+
+**Access Control**: Members-only, owner of album only
+
+## Workflow Examples
+
+### Creating an Album
+1. User clicks "Create Album" button on gallery page
+2. Navigates to create_album.php
+3. Enters album title (required) and description (optional)
+4. Drags and drops or selects multiple photo files
+5. Clicks "Create Album" button
+6. save_album.php:
+   - Creates album directory: `/assets/uploads/gallery/{album_id}/`
+   - Validates each photo (mime type, file size)
+   - Moves photos to album directory with unique names
+   - Sets first photo as cover_image
+   - Inserts album record and photo records in transaction
+   - Redirects to view_album page for newly created album
+
+### Editing an Album
+1. User clicks "Edit Album" button on album view page
+2. Navigates to create_album.php?id={album_id}
+3. Form prepopulates with current album data
+4. Existing photos displayed in grid with delete buttons
+5. Can add more photos by uploading new files
+6. Clicks "Update Album" button
+7. update_album.php:
+   - Verifies ownership
+   - Updates album metadata
+   - Validates and uploads any new photos
+   - Appends new photos to existing ones (doesn't overwrite)
+   - Redirects back to view_album
+
+### Deleting a Photo
+1. User clicks delete (X) button on photo in edit form
+2. JavaScript shows confirmation dialog
+3. Sends POST to delete_photo with photo_id and csrf_token
+4. delete_photo.php:
+   - Verifies ownership through album
+   - Deletes file from disk
+   - Removes from database
+   - Updates cover_image if needed
+   - Returns JSON success response
+5. Page reloads to show updated photo list
+
+### Deleting an Album
+1. User clicks "Delete Album" button in edit form
+2. JavaScript shows confirmation dialog
+3. Navigates to delete_album.php?id={album_id}
+4. delete_album.php:
+   - Verifies ownership
+   - Deletes all photo files from disk
+   - Deletes all photo records from database
+   - Deletes album directory
+   - Deletes album record
+   - Redirects to gallery page
+
+## URL Routing (.htaccess)
+
+```
+/gallery → src/pages/gallery/gallery.php
+/create_album → src/pages/gallery/create_album.php
+/edit_album → src/pages/gallery/create_album.php (id parameter determines mode)
+/view_album → src/pages/gallery/view_album.php
+/save_album → src/processors/save_album.php (POST only)
+/update_album → src/processors/update_album.php (POST only)
+/delete_album → src/processors/delete_album.php (GET with id parameter)
+/delete_photo → src/processors/delete_photo.php (POST only)
+/get_album_photos → src/processors/get_album_photos.php (GET with id parameter)
+```
+
+## Security Features
+
+### Authentication
+- All pages check for `$_SESSION['user_id']`
+- Non-members redirected to membership page
+- Non-authenticated users redirected to login
+
+### Authorization
+- Album ownership verified before allowing edits
+- Album ownership verified before allowing deletes
+- Only album owner can edit or delete photos
+- Only album owner can see edit buttons
+
+### Data Validation
+- Album title validated with validateName() function
+- Description length limited to 500 characters
+- File uploads validated for:
+  - MIME type (only image formats allowed)
+  - File size (max 5MB)
+  - File extension check
+- Filename sanitized with uniqid() to prevent conflicts
+
+### CSRF Protection
+- All forms include csrf_token
+- Processors validate CSRF token before processing
+- POST-only operations protected
+
+### Transaction Safety
+- Album creation uses transaction
+  - Creates directory
+  - Inserts album record
+  - Inserts photo records
+  - Commits all or rolls back all on error
+- Handles cleanup on failure:
+  - Deletes partial uploads
+  - Removes album directory
+  - Removes album record from database
+
+## Error Handling
+
+### Validation Errors
+- File too large: "File too large: {filename}"
+- Invalid file type: "Invalid file type: {filename}"
+- Missing album title: "Album title is required and must be valid"
+- Description too long: "Description must be 500 characters or less"
+
+### Permission Errors
+- Not authenticated: Redirects to login
+- Not a member: Redirects to membership page
+- Not album owner: Returns 403 Forbidden with error message
+- Album not found: Returns 404 with redirect to gallery
+
+### Upload Errors
+- Directory creation failure: "Failed to create album directory"
+- File move failure: "Failed to upload: {filename}"
+- Database insert failure: HTTP 400 with error message
+
+### Recovery
+- All upload errors trigger transaction rollback
+- Partial files cleaned up on failure
+- Album record deleted if transaction fails
+- Directory removed if transaction fails
+
+## Testing Checklist
+
+### Album Creation
+- [ ] Create album with title only
+- [ ] Create album with title and description
+- [ ] Upload single photo to new album
+- [ ] Upload multiple photos to new album
+- [ ] Verify first photo becomes cover
+- [ ] Verify files stored in correct directory
+- [ ] Verify album appears in carousel
+
+### Album Editing
+- [ ] Edit album title
+- [ ] Edit album description
+- [ ] Add photos to existing album
+- [ ] Add many photos at once (10+)
+- [ ] Delete photos from album
+- [ ] Delete last photo (cover updates to NULL)
+- [ ] Delete album cover, verify new cover assigned
+- [ ] Verify edit unavailable for non-owner
+
+### Album Viewing
+- [ ] View album as owner
+- [ ] View album as other member
+- [ ] View album with many photos
+- [ ] Photo grid responsive on mobile
+- [ ] Photo grid responsive on tablet
+- [ ] All photos display correct captions
+
+### Lightbox
+- [ ] Open lightbox from first photo
+- [ ] Open lightbox from middle photo
+- [ ] Open lightbox from last photo
+- [ ] Next button navigates forward
+- [ ] Previous button navigates backward
+- [ ] Next button wraps to first photo from last
+- [ ] Previous button wraps to last photo from first
+- [ ] Arrow key navigation works
+- [ ] Escape key closes lightbox
+- [ ] Click X button closes lightbox
+- [ ] Photo caption displays correctly
+
+### Gallery Page
+- [ ] Carousel displays all albums
+- [ ] Previous/Next buttons work
+- [ ] Album cards show cover image
+- [ ] Album cards show correct photo count
+- [ ] Create Album button visible
+- [ ] Create Album button navigates correctly
+- [ ] Edit button visible only to owner
+- [ ] Empty gallery state shows correct message
+- [ ] Empty gallery has Create Album link
+
+### Access Control
+- [ ] Non-members cannot access gallery
+- [ ] Non-members cannot create albums
+- [ ] Non-members cannot edit albums
+- [ ] Users cannot edit others' albums
+- [ ] Users cannot delete others' albums
+- [ ] Users cannot delete others' photos
+
+### File Uploads
+- [ ] JPG files accepted
+- [ ] PNG files accepted
+- [ ] GIF files accepted
+- [ ] WEBP files accepted
+- [ ] BMP files rejected
+- [ ] ZIP files rejected
+- [ ] Files over 5MB rejected
+- [ ] Files exactly 5MB accepted
+- [ ] Drag and drop upload works
+- [ ] Click-to-upload works
+
+### Database
+- [ ] Albums table has correct structure
+- [ ] Photos table has correct structure
+- [ ] Foreign keys work correctly
+- [ ] Cascade delete removes photos when album deleted
+- [ ] Unique constraint prevents duplicate user ownership
+- [ ] Indexes created for performance
+
+### Navigation
+- [ ] Gallery link appears in Members Area menu
+- [ ] Gallery link visible only for logged-in users
+- [ ] Gallery link locked (with icon) for non-members
+- [ ] "View Album" button navigates to album detail
+- [ ] "Edit Album" button navigates to edit form
+- [ ] "Back to Gallery" button returns to gallery
+- [ ] "Add Photos" link in empty album goes to edit form
+
+## Future Enhancements
+
+### Possible Features
+1. Multiple albums per user (modify UNIQUE constraint)
+2. Album visibility settings (private/members-only/public)
+3. Album categories/tags
+4. Photo ordering/reordering in album
+5. Photo batch operations (delete multiple, move between albums)
+6. Album sharing/collaboration
+7. Photo comments/ratings
+8. Admin gallery management
+9. Automatic image optimization/compression
+10. Photo metadata preservation (EXIF)
+11. Album archives/export
+12. Photo search across all albums
+
+### Schema Changes Required
+- Remove UNIQUE constraint on user_id to allow multiple albums per user
+- Add visibility enum field to photo_albums
+- Add category_id FK to photo_albums
+- Add user_id to photos for future permission model
+- Add updated_at timestamps to photos for tracking
+
+## Deployment Notes
+
+### Pre-Deployment
+1. Run migration 003 to create tables
+2. Create `/assets/uploads/gallery/` directory with proper permissions
+3. Ensure PHP can write to upload directory (755 or 777)
+4. Test file upload with valid and invalid files
+
+### Post-Deployment
+1. Verify gallery link appears in header menu
+2. Test creating first album in production
+3. Test file uploads with various image formats
+4. Monitor disk space usage for uploads
+5. Set up automated cleanup for orphaned files (if needed)
+
+### Permissions
+```
+/assets/uploads/gallery/
+  Permissions: 755 (rwxr-xr-x)
+  Owner: web server user
+  
+Individual album directories:
+  Permissions: 755 (rwxr-xr-x)
+  Created automatically by application
+  
+Photo files:
+  Permissions: 644 (rw-r--r--)
+  Created automatically by application
+```
+
+### Backups
+- Include `/assets/uploads/gallery/` in backup routine
+- Include `photo_albums` and `photos` tables in database backups
+- Consider separate backup for large image files
+
+## Known Limitations
+
+1. **One album per user**: Current schema design with UNIQUE constraint on user_id allows only one album per user. Can be modified if multiple albums per user needed.
+
+2. **No album visibility control**: All member albums are visible to all members. Could add privacy settings in future.
+
+3. **No photo ordering UI**: Photos ordered by display_order but no UI to reorder them. Captions show filename by default.
+
+4. **No album categories**: All albums mixed in one carousel. Could add filtering/categories.
+
+5. **Image optimization**: No automatic compression/optimization. Large images stored as-is.
+
+6. **No EXIF data**: Photo metadata stripped during upload. Could preserve orientation/metadata.
+
+## Troubleshooting
+
+### Photos not uploading
+- Check `/assets/uploads/gallery/` exists and is writable
+- Verify file sizes under 5MB
+- Confirm image MIME types are jpeg, png, gif, or webp
+- Check PHP error logs for upload errors
+
+### Album cover not updating
+- Verify cover_image field in database
+- Check if photo file path stored correctly
+- Confirm image file exists on disk
+
+### Lightbox not opening
+- Check browser console for JavaScript errors
+- Verify image paths are accessible
+- Confirm file URLs accessible directly
+
+### Permission denied errors
+- Check album owner verification logic
+- Verify CSRF tokens being passed correctly
+- Confirm user_id matches in session
+
+### Memory issues with large uploads
+- Reduce PHP memory_limit if needed
+- Split large batches of photos into smaller uploads
+- Consider image optimization/compression
+

docs/migrations/001_add_events_tracking_columns.sql

@@ -0,0 +1,14 @@
+-- Events Table Migration
+-- Add missing columns to events table for proper tracking and publishing control
+
+-- Add columns if they don't exist (using ALTER IGNORE for compatibility)
+ALTER TABLE `events` 
+ADD COLUMN `created_by` int DEFAULT NULL AFTER `promo`,
+ADD COLUMN `published` tinyint(1) DEFAULT 0 AFTER `created_by`,
+ADD COLUMN `created_at` timestamp DEFAULT CURRENT_TIMESTAMP AFTER `published`,
+ADD COLUMN `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `created_at`;
+
+-- Add indexes for better query performance
+ALTER TABLE `events` ADD INDEX `idx_date` (`date`);
+ALTER TABLE `events` ADD INDEX `idx_published` (`published`);
+ALTER TABLE `events` ADD INDEX `idx_created_by` (`created_by`);

docs/migrations/002_add_unique_constraints_membership.sql

@@ -0,0 +1,37 @@
+-- Migration: Add UNIQUE constraints to prevent duplicate membership applications and fees
+-- Date: 2025-12-05
+-- Purpose: Ensure each user can only have one application and one membership fee record
+-- Note: Individual payments are tracked in the payments/efts table, not here
+
+-- Add UNIQUE constraint to membership_application table
+-- First, delete any duplicate applications keeping the most recent one
+DELETE FROM membership_application
+WHERE application_id NOT IN (
+    SELECT MAX(application_id) 
+    FROM (
+        SELECT application_id 
+        FROM membership_application
+    ) tmp
+    GROUP BY user_id
+);
+
+-- Add UNIQUE constraint on user_id in membership_application
+ALTER TABLE membership_application 
+ADD CONSTRAINT uk_membership_application_user_id UNIQUE (user_id);
+
+-- Add UNIQUE constraint to membership_fees table
+-- First, delete any duplicate fees keeping the most recent one
+DELETE FROM membership_fees
+WHERE fee_id NOT IN (
+    SELECT MAX(fee_id) 
+    FROM (
+        SELECT fee_id 
+        FROM membership_fees
+    ) tmp
+    GROUP BY user_id
+);
+
+-- Add UNIQUE constraint on user_id in membership_fees
+ALTER TABLE membership_fees 
+ADD CONSTRAINT uk_membership_fees_user_id UNIQUE (user_id);
+

docs/migrations/003_create_photo_gallery_tables.sql

@@ -0,0 +1,30 @@
+-- Migration: Create photo gallery tables for member photo albums
+-- Date: 2025-12-05
+-- Purpose: Allow members to create albums and upload photos to share with the community
+
+-- Create photo_albums table
+CREATE TABLE IF NOT EXISTS photo_albums (
+    album_id INT PRIMARY KEY AUTO_INCREMENT,
+    user_id INT NOT NULL,
+    title VARCHAR(255) NOT NULL,
+    description TEXT,
+    cover_image VARCHAR(255),
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
+    INDEX idx_user_id (user_id),
+    INDEX idx_created_at (created_at)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+
+-- Create photos table
+CREATE TABLE IF NOT EXISTS photos (
+    photo_id INT PRIMARY KEY AUTO_INCREMENT,
+    album_id INT NOT NULL,
+    file_path VARCHAR(255) NOT NULL,
+    caption VARCHAR(255),
+    display_order INT DEFAULT 0,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    FOREIGN KEY (album_id) REFERENCES photo_albums(album_id) ON DELETE CASCADE,
+    INDEX idx_album_id (album_id),
+    INDEX idx_display_order (display_order)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

header.php

@@ -283,6 +283,7 @@ if ($headerStyle === 'light') {
                                                 <ul>
                                                     <li><a href="admin_web_users">Website Users</a></li>
                                                     <li><a href="admin_members">4WDCSA Members</a></li>
+                                                    <li><a href="admin_events">Manage Events</a></li>
                                                     <li><a href="admin_trips">Manage Trips</a></li>
                                                     <li><a href="admin_trip_bookings">Trip Bookings</a></li>
                                                     <li><a href="admin_course_bookings">Course Bookings</a></li>
@@ -295,15 +296,23 @@ if ($headerStyle === 'light') {
                                             </li>
                                         <?php } ?>
                                         <li><a href="contact">Contact</a></li>
-                                        <?php if ($is_member) : ?>
+                                        <?php if ($is_logged_in) : ?>
                                             <li class="dropdown"><a href="#">Members Area</a>
                                                 <ul>
-                                                    <li><a href="#">Coming Soon!</a></li>
+                                                    <?php
+                                                    if (getUserMemberStatus($_SESSION['user_id'])) {
+                                                        echo "<li><a href=\"campsites\">Campsites Directory</a></li>";
+                                                        echo "<li><a href=\"gallery\">Photo Gallery</a></li>";
+                                                    } else { 
+                                                        echo "<li><a href=\"membership\">Campsites Directory</a><i class='fal fa-lock'></i></li>";
+                                                        echo "<li><a href=\"membership\">Photo Gallery</a><i class='fal fa-lock'></i></li>";
+                                                    } 
+                                                    ?>
                                                 </ul>
                                             </li>
-                                        <?php endif; ?>
+                                        
 
-                                        <?php if ($is_logged_in) : ?>
+                                        
                                             <li class="dropdown"><a href="#">My Account</a>
                                                 <ul>
                                                     <li><a href="account_settings">Account Settings</a></li>

src/admin/admin_events.php

@@ -0,0 +1,361 @@
+<?php
+$headerStyle = 'light';
+$rootPath = dirname(dirname(__DIR__));
+include_once($rootPath . '/header.php');
+checkAdmin();
+
+// Fetch all events
+$events_query = "
+    SELECT 
+        event_id, name, type, location, date, published
+    FROM events
+    ORDER BY date DESC
+";
+
+$result = $conn->query($events_query);
+$events = [];
+if ($result && $result->num_rows > 0) {
+    while ($row = $result->fetch_assoc()) {
+        $events[] = $row;
+    }
+}
+?>
+
+<style>
+    table {
+        width: 100%;
+        border-collapse: separate;
+        border-spacing: 0;
+        margin: 10px 0;
+    }
+
+    thead th {
+        cursor: pointer;
+        text-align: left;
+        padding: 10px;
+        font-weight: bold;
+        position: relative;
+    }
+
+    thead th::after {
+        content: '\25B2';
+        /* Up arrow */
+        font-size: 0.8em;
+        position: absolute;
+        right: 10px;
+        opacity: 0;
+        transition: opacity 0.2s;
+    }
+
+    thead th.asc::after {
+        content: '\25B2';
+        /* Up arrow */
+        opacity: 1;
+    }
+
+    thead th.desc::after {
+        content: '\25BC';
+        /* Down arrow */
+        opacity: 1;
+    }
+
+    tbody tr:nth-child(odd) {
+        background-color: transparent;
+    }
+
+    tbody tr:nth-child(even) {
+        background-color: rgb(255, 255, 255);
+        border-radius: 10px;
+    }
+
+    tbody td {
+        padding: 10px;
+    }
+
+    tbody tr:nth-child(even) td:first-child {
+        border-top-left-radius: 10px;
+        border-bottom-left-radius: 10px;
+    }
+
+    tbody tr:nth-child(even) td:last-child {
+        border-top-right-radius: 10px;
+        border-bottom-right-radius: 10px;
+    }
+
+    .filter-input {
+        width: 100%;
+        padding: 10px;
+        font-size: 16px;
+        background-color: rgb(255, 255, 255);
+        border-radius: 25px;
+        margin-bottom: 15px;
+    }
+
+    .btn {
+        display: inline-block;
+        padding: 6px 12px;
+        margin: 2px;
+        font-size: 14px;
+        border-radius: 5px;
+        text-decoration: none;
+        border: none;
+        cursor: pointer;
+        transition: all 0.2s;
+    }
+
+    .btn-sm {
+        padding: 4px 8px;
+        font-size: 12px;
+    }
+
+    .btn-primary {
+        background-color: #007bff;
+        color: white;
+    }
+
+    .btn-primary:hover {
+        background-color: #0056b3;
+    }
+
+    .btn-success {
+        background-color: #28a745;
+        color: white;
+    }
+
+    .btn-success:hover {
+        background-color: #218838;
+    }
+
+    .btn-warning {
+        background-color: #ffc107;
+        color: black;
+    }
+
+    .btn-warning:hover {
+        background-color: #e0a800;
+    }
+
+    .btn-danger {
+        background-color: #dc3545;
+        color: white;
+    }
+
+    .btn-danger:hover {
+        background-color: #c82333;
+    }
+
+    .badge {
+        display: inline-block;
+        padding: 4px 8px;
+        border-radius: 4px;
+        font-size: 12px;
+        font-weight: bold;
+    }
+
+    .bg-success {
+        background-color: #28a745;
+        color: white;
+    }
+
+    .bg-warning {
+        background-color: #ffc107;
+        color: black;
+    }
+</style>
+
+<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
+<script>
+    $(document).ready(function() {
+        // Sorting functionality
+        const table = document.querySelector('table');
+        if (table) {
+            const headers = table.querySelectorAll('thead th');
+            const rows = Array.from(table.querySelectorAll('tbody tr'));
+
+            headers.forEach((header, index) => {
+                header.addEventListener('click', () => {
+                    const sortedRows = rows.sort((a, b) => {
+                        const aText = a.cells[index].textContent.trim().toLowerCase();
+                        const bText = b.cells[index].textContent.trim().toLowerCase();
+
+                        if (aText < bText) return -1;
+                        if (aText > bText) return 1;
+                        return 0;
+                    });
+
+                    if (header.classList.contains('asc')) {
+                        header.classList.remove('asc');
+                        header.classList.add('desc');
+                        sortedRows.reverse();
+                    } else {
+                        headers.forEach(h => h.classList.remove('asc', 'desc'));
+                        header.classList.add('asc');
+                    }
+
+                    const tbody = table.querySelector('tbody');
+                    tbody.innerHTML = '';
+                    sortedRows.forEach(row => tbody.appendChild(row));
+                });
+            });
+
+            // Filter functionality
+            const filterInput = document.querySelector('.filter-input');
+            if (filterInput) {
+                filterInput.addEventListener('input', function() {
+                    const filterValue = filterInput.value.trim().toLowerCase();
+                    rows.forEach(row => {
+                        const rowText = row.textContent.trim().toLowerCase();
+                        row.style.display = rowText.includes(filterValue) ? '' : 'none';
+                    });
+                });
+            }
+        }
+
+        // Publish/Unpublish toggle
+        $('.toggle-publish').on('click', function() {
+            var eventId = $(this).data('event-id');
+            var button = $(this);
+            var row = button.closest('tr');
+
+            $.ajax({
+                url: 'toggle_event_published',
+                type: 'POST',
+                data: {
+                    event_id: eventId
+                },
+                dataType: 'json',
+                complete: function(xhr, status) {
+                    // Handle all response codes
+                    try {
+                        var response = JSON.parse(xhr.responseText);
+                        
+                        if (response.status === 'success') {
+                            if (response.published == 1) {
+                                button.removeClass('btn-success').addClass('btn-warning');
+                                button.find('i').removeClass('fa-eye').addClass('fa-eye-slash');
+                                button.attr('title', 'Unpublish');
+                                row.find('td:nth-child(5)').html('<span class="badge bg-success">Published</span>');
+                            } else {
+                                button.removeClass('btn-warning').addClass('btn-success');
+                                button.find('i').removeClass('fa-eye-slash').addClass('fa-eye');
+                                button.attr('title', 'Publish');
+                                row.find('td:nth-child(5)').html('<span class="badge bg-warning">Draft</span>');
+                            }
+                        } else {
+                            alert('Error: ' + response.message);
+                        }
+                    } catch (e) {
+                        alert('Error updating event status. Response: ' + xhr.responseText);
+                    }
+                }
+            });
+        });
+
+        // Delete event
+        $('.delete-event').on('click', function() {
+            if (!confirm('Are you sure you want to delete this event? This action cannot be undone.')) {
+                return false;
+            }
+
+            var eventId = $(this).data('event-id');
+            var button = $(this);
+            var row = button.closest('tr');
+
+            $.ajax({
+                url: 'delete_event',
+                type: 'POST',
+                data: {
+                    event_id: eventId
+                },
+                dataType: 'json',
+                success: function(response) {
+                    if (response.status === 'success') {
+                        row.fadeOut(300, function() {
+                            $(this).remove();
+                        });
+                    } else {
+                        alert('Error: ' + response.message);
+                    }
+                },
+                error: function() {
+                    alert('Error deleting event');
+                }
+            });
+        });
+    });
+</script>
+
+<?php
+    $pageTitle = 'Manage Events';
+    $breadcrumbs = [['Home' => 'index'], [$pageTitle => '']];
+    require_once($rootPath . '/components/banner.php');
+?>
+
+<?php
+    $pageTitle = 'Manage Events';
+    $breadcrumbs = [['Home' => 'index'], [$pageTitle => '']];
+    require_once($rootPath . '/components/banner.php');
+?>
+
+<!-- Events Management Area start -->
+<section class="events-management-area py-100 rel z-1">
+    <div class="container">
+        <div class="row mb-30">
+            <div class="col-lg-12">
+                <a href="manage_events" class="theme-btn style-two">+ Create New Event</a>
+            </div>
+        </div>
+
+        <?php
+        if (!empty($events)) {
+            echo '<div class="row">
+                    <div class="col-lg-12">
+                        <div class="form-group mb-20">
+                            <input type="text" class="filter-input" placeholder="Search events...">
+                        </div>
+                        <table>
+                            <thead>
+                                <tr>
+                                    <th>Event Name</th>
+                                    <th>Type</th>
+                                    <th>Location</th>
+                                    <th>Date</th>
+                                    <th>Status</th>
+                                    <th>Actions</th>
+                                </tr>
+                            </thead>
+                            <tbody>';
+            foreach ($events as $event) {
+                $publishButtonText = $event['published'] == 1 ? 'Unpublish' : 'Publish';
+                $publishButtonClass = $event['published'] == 1 ? 'btn-warning' : 'btn-success';
+                echo '<tr>
+                        <td><strong>' . htmlspecialchars($event['name']) . '</strong></td>
+                        <td>' . htmlspecialchars($event['type']) . '</td>
+                        <td>' . htmlspecialchars($event['location']) . '</td>
+                        <td>' . convertDate($event['date']) . '</td>
+                        <td>' . ($event['published'] == 1 ? '<span class="badge bg-success">Published</span>' : '<span class="badge bg-warning">Draft</span>') . '</td>
+                        <td>
+                            <a href="manage_events?event_id=' . $event['event_id'] . '" class="btn btn-sm btn-primary" title="Edit">
+                                <i class="far fa-edit"></i>
+                            </a>
+                            <button class="btn btn-sm ' . $publishButtonClass . ' toggle-publish" data-event-id="' . $event['event_id'] . '" title="' . $publishButtonText . '">
+                                <i class="far fa-' . ($event['published'] == 1 ? 'eye-slash' : 'eye') . '"></i>
+                            </button>
+                            <button class="btn btn-sm btn-danger delete-event" data-event-id="' . $event['event_id'] . '" title="Delete">
+                                <i class="far fa-trash"></i>
+                            </button>
+                        </td>
+                    </tr>';
+            }
+            echo '</tbody></table>';
+            echo '</div>';
+            echo '</div>';
+        } else {
+            echo '<p>No events found. <a href="manage_events">Create one</a></p>';
+        }
+        ?>
+    </div>
+</section>
+<!-- Events Management Area end -->
+
+<?php include_once($rootPath . '/components/insta_footer.php'); ?>

src/admin/delete_event.php

@@ -0,0 +1,46 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+include_once($rootPath . '/header.php');
+checkAdmin();
+
+header('Content-Type: application/json');
+
+$event_id = $_POST['event_id'] ?? null;
+
+if (!$event_id) {
+    echo json_encode(['status' => 'error', 'message' => 'Event ID is required']);
+    exit;
+}
+
+// Get event details to delete associated files
+$stmt = $conn->prepare("SELECT image, promo FROM events WHERE event_id = ?");
+$stmt->bind_param("i", $event_id);
+$stmt->execute();
+$result = $stmt->get_result();
+
+if ($result->num_rows > 0) {
+    $event = $result->fetch_assoc();
+    
+    // Delete image files
+    if ($event['image'] && file_exists($rootPath . '/' . $event['image'])) {
+        unlink($rootPath . '/' . $event['image']);
+    }
+    if ($event['promo'] && file_exists($rootPath . '/' . $event['promo'])) {
+        unlink($rootPath . '/' . $event['promo']);
+    }
+    
+    // Delete from database
+    $delete_stmt = $conn->prepare("DELETE FROM events WHERE event_id = ?");
+    $delete_stmt->bind_param("i", $event_id);
+    
+    if ($delete_stmt->execute()) {
+        echo json_encode(['status' => 'success', 'message' => 'Event deleted successfully']);
+    } else {
+        echo json_encode(['status' => 'error', 'message' => 'Failed to delete event']);
+    }
+    $delete_stmt->close();
+} else {
+    echo json_encode(['status' => 'error', 'message' => 'Event not found']);
+}
+
+$stmt->close();

src/admin/manage_events.php

@@ -0,0 +1,173 @@
+<?php
+$headerStyle = 'light';
+$rootPath = dirname(dirname(__DIR__));
+include_once($rootPath . '/header.php');
+checkAdmin();
+
+$event_id = $_GET['event_id'] ?? null;
+$event = null;
+
+// If editing an existing event, fetch its data
+if ($event_id) {
+    $stmt = $conn->prepare("SELECT * FROM events WHERE event_id = ?");
+    $stmt->bind_param("i", $event_id);
+    $stmt->execute();
+    $result = $stmt->get_result();
+    if ($result->num_rows > 0) {
+        $event = $result->fetch_assoc();
+    }
+    $stmt->close();
+}
+?>
+
+<?php
+    $pageTitle = $event ? 'Edit Event' : 'Create New Event';
+    $breadcrumbs = [['Home' => 'index'], ['Admin' => 'admin_events'], [$pageTitle => '']];
+    require_once($rootPath . '/components/banner.php');
+?>
+
+<!-- Event Manager Area start -->
+<section class="event-manager-area py-100 rel z-1">
+    <div class="container">
+        <div class="row">
+            <div class="col-lg-12">
+                <div class="comment-form bgc-lighter z-1 rel mb-30 rmb-55">
+                    <form id="eventForm" enctype="multipart/form-data" method="POST" action="process_event">
+                        <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
+                        <?php if ($event): ?>
+                            <input type="hidden" name="event_id" value="<?php echo $event['event_id']; ?>">
+                        <?php endif; ?>
+                        
+                        <div class="section-title py-20">
+                            <h2><?php echo $event ? 'Edit Event: ' . htmlspecialchars($event['name']) : 'Create New Event'; ?></h2>
+                            <div id="responseMessage"></div>
+                        </div>
+
+                        <!-- Event Information -->
+                        <div class="row mt-35">
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="name">Event Name *</label>
+                                    <input type="text" id="name" name="name" class="form-control" value="<?php echo $event ? htmlspecialchars($event['name']) : ''; ?>" required>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="type">Event Type *</label>
+                                    <input type="text" id="type" name="type" class="form-control" value="<?php echo $event ? htmlspecialchars($event['type']) : ''; ?>" placeholder="e.g., Workshop, Training, Rally" required>
+                                </div>
+                            </div>
+
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="location">Location *</label>
+                                    <input type="text" id="location" name="location" class="form-control" value="<?php echo $event ? htmlspecialchars($event['location']) : ''; ?>" required>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="date">Date *</label>
+                                    <input type="date" id="date" name="date" class="form-control" value="<?php echo $event ? $event['date'] : ''; ?>" required>
+                                </div>
+                            </div>
+
+                            <!-- Time -->
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="time">Time *</label>
+                                    <input type="time" id="time" name="time" class="form-control" value="<?php echo $event ? $event['time'] : ''; ?>" required>
+                                </div>
+                            </div>
+
+                            <!-- Feature/Category -->
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="feature">Feature/Category *</label>
+                                    <input type="text" id="feature" name="feature" class="form-control" value="<?php echo $event ? htmlspecialchars($event['feature']) : ''; ?>" placeholder="e.g., Off-Road Training, Social Event" required>
+                                </div>
+                            </div>
+
+                            <!-- Descriptions -->
+                            <div class="col-md-12">
+                                <div class="form-group">
+                                    <label for="description">Description *</label>
+                                    <textarea id="description" name="description" class="form-control" rows="6" required><?php echo $event ? htmlspecialchars($event['description']) : ''; ?></textarea>
+                                </div>
+                            </div>
+
+                            <!-- Image Upload -->
+                            <div class="col-md-12 mt-20">
+                                <div class="form-group">
+                                    <label for="image">Event Image *</label>
+                                    <input type="file" id="image" name="image" class="form-control" accept="image/*" <?php echo !$event ? 'required' : ''; ?>>
+                                    <?php if ($event && $event['image']): ?>
+                                        <small class="text-info d-block mt-2">Current image: <img src="<?php echo $event['image']; ?>" alt="Event Image" style="max-width: 200px; margin-top: 10px;"></small>
+                                    <?php endif; ?>
+                                </div>
+                            </div>
+
+                            <!-- Promo Image Upload -->
+                            <div class="col-md-12 mt-20">
+                                <div class="form-group">
+                                    <label for="promo">Promotional Image</label>
+                                    <input type="file" id="promo" name="promo" class="form-control" accept="image/*">
+                                    <small class="text-muted">This image will be displayed when users click "View Promo"</small>
+                                    <?php if ($event && $event['promo']): ?>
+                                        <small class="text-info d-block mt-2">Current promo: <img src="<?php echo $event['promo']; ?>" alt="Promo Image" style="max-width: 200px; margin-top: 10px;"></small>
+                                    <?php endif; ?>
+                                </div>
+                            </div>
+
+                            <div class="col-md-12 mt-20">
+                                <div class="form-group mb-0">
+                                    <button type="submit" class="theme-btn style-two" style="width:100%;">
+                                        <?php echo $event ? 'Update Event' : 'Create Event'; ?>
+                                    </button>
+                                </div>
+                            </div>
+                        </div>
+                    </form>
+                </div>
+            </div>
+        </div>
+    </div>
+</section>
+<!-- Event Manager Area end -->
+
+<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
+<script>
+    $(document).ready(function() {
+        $('#eventForm').on('submit', function(event) {
+            event.preventDefault();
+            
+            var formData = new FormData(this);
+            
+            $.ajax({
+                url: 'process_event',
+                type: 'POST',
+                data: formData,
+                contentType: false,
+                processData: false,
+                dataType: 'json',
+                success: function(response) {
+                    if (response.status === 'success') {
+                        $('#responseMessage').html('<div class="alert alert-success">' + response.message + '</div>');
+                        setTimeout(function() {
+                            window.location.href = 'admin_events';
+                        }, 2000);
+                    } else {
+                        $('#responseMessage').html('<div class="alert alert-danger">' + response.message + '</div>');
+                        console.error('Server error:', response.message);
+                    }
+                },
+                error: function(xhr, status, error) {
+                    console.log('AJAX Error:', error);
+                    console.log('Response:', xhr.responseText);
+                    $('#responseMessage').html('<div class="alert alert-danger">Error creating/updating event: ' + error + '</div>');
+                }
+            });
+        });
+    });
+</script>
+
+<?php include_once($rootPath . '/components/insta_footer.php'); ?>

src/admin/process_event.php

@@ -0,0 +1,193 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+include_once($rootPath . '/header.php');
+checkAdmin();
+
+header('Content-Type: application/json');
+
+// Handle delete action
+if ($_GET['action'] ?? null === 'delete') {
+    $event_id = $_GET['event_id'] ?? null;
+    
+    if (!$event_id) {
+        echo json_encode(['status' => 'error', 'message' => 'Event ID is required']);
+        exit;
+    }
+    
+    // Get event details to delete associated files
+    $stmt = $conn->prepare("SELECT image, promo FROM events WHERE event_id = ?");
+    $stmt->bind_param("i", $event_id);
+    $stmt->execute();
+    $result = $stmt->get_result();
+    
+    if ($result->num_rows > 0) {
+        $event = $result->fetch_assoc();
+        
+        // Delete image files
+        if ($event['image'] && file_exists($rootPath . '/' . $event['image'])) {
+            unlink($rootPath . '/' . $event['image']);
+        }
+        if ($event['promo'] && file_exists($rootPath . '/' . $event['promo'])) {
+            unlink($rootPath . '/' . $event['promo']);
+        }
+        
+        // Delete from database
+        $delete_stmt = $conn->prepare("DELETE FROM events WHERE event_id = ?");
+        $delete_stmt->bind_param("i", $event_id);
+        
+        if ($delete_stmt->execute()) {
+            echo json_encode(['status' => 'success', 'message' => 'Event deleted successfully']);
+        } else {
+            echo json_encode(['status' => 'error', 'message' => 'Failed to delete event']);
+        }
+        $delete_stmt->close();
+    } else {
+        echo json_encode(['status' => 'error', 'message' => 'Event not found']);
+    }
+    $stmt->close();
+    exit;
+}
+
+// Check CSRF token
+if (!isset($_POST['csrf_token']) || !verifyCsrfToken($_POST['csrf_token'])) {
+    echo json_encode(['status' => 'error', 'message' => 'CSRF token validation failed']);
+    exit;
+}
+
+$event_id = $_POST['event_id'] ?? null;
+$name = $_POST['name'] ?? null;
+$type = $_POST['type'] ?? null;
+$location = $_POST['location'] ?? null;
+$date = $_POST['date'] ?? null;
+$time = $_POST['time'] ?? null;
+$feature = $_POST['feature'] ?? null;
+$description = $_POST['description'] ?? null;
+
+// Validate required fields
+if (!$name || !$type || !$location || !$date || !$time || !$feature || !$description) {
+    echo json_encode(['status' => 'error', 'message' => 'All required fields must be filled']);
+    exit;
+}
+
+// Handle image upload
+$image_path = null;
+if (!empty($_FILES['image']['name'])) {
+    $upload_dir = $rootPath . '/assets/images/events/';
+    if (!is_dir($upload_dir)) {
+        mkdir($upload_dir, 0755, true);
+    }
+    
+    $file_name = uniqid() . '_' . basename($_FILES['image']['name']);
+    $target_file = $upload_dir . $file_name;
+    $file_type = mime_content_type($_FILES['image']['tmp_name']);
+    
+    // Validate image file
+    $allowed_types = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+    if (!in_array($file_type, $allowed_types)) {
+        echo json_encode(['status' => 'error', 'message' => 'Invalid image file type. Only JPEG, PNG, GIF, and WebP are allowed']);
+        exit;
+    }
+    
+    if (move_uploaded_file($_FILES['image']['tmp_name'], $target_file)) {
+        $image_path = 'assets/images/events/' . $file_name;
+    } else {
+        echo json_encode(['status' => 'error', 'message' => 'Failed to upload image']);
+        exit;
+    }
+} else if (!$event_id) {
+    echo json_encode(['status' => 'error', 'message' => 'Image is required for new events']);
+    exit;
+}
+
+// Handle promo image upload
+$promo_path = null;
+if (!empty($_FILES['promo']['name'])) {
+    $upload_dir = $rootPath . '/assets/images/events/';
+    if (!is_dir($upload_dir)) {
+        mkdir($upload_dir, 0755, true);
+    }
+    
+    $file_name = uniqid() . '_promo_' . basename($_FILES['promo']['name']);
+    $target_file = $upload_dir . $file_name;
+    $file_type = mime_content_type($_FILES['promo']['tmp_name']);
+    
+    // Validate image file
+    $allowed_types = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+    if (!in_array($file_type, $allowed_types)) {
+        echo json_encode(['status' => 'error', 'message' => 'Invalid promo image file type. Only JPEG, PNG, GIF, and WebP are allowed']);
+        exit;
+    }
+    
+    if (move_uploaded_file($_FILES['promo']['tmp_name'], $target_file)) {
+        $promo_path = 'assets/images/events/' . $file_name;
+    }
+}
+
+try {
+    if ($event_id) {
+        // Update existing event
+        $update_fields = [
+            'name' => $name,
+            'type' => $type,
+            'location' => $location,
+            'date' => $date,
+            'time' => $time,
+            'feature' => $feature,
+            'description' => $description,
+            'updated_at' => date('Y-m-d H:i:s')
+        ];
+        
+        if ($image_path) {
+            $update_fields['image'] = $image_path;
+        }
+        if ($promo_path) {
+            $update_fields['promo'] = $promo_path;
+        }
+        
+        $set_clause = implode(', ', array_map(function($key) {
+            return $key . ' = ?';
+        }, array_keys($update_fields)));
+        
+        $values = array_values($update_fields);
+        $values[] = $event_id;
+        
+        $stmt = $conn->prepare("UPDATE events SET $set_clause WHERE event_id = ?");
+        
+        // Build type string for bind_param
+        $type_str = str_repeat('s', count($update_fields)) . 'i';
+        $stmt->bind_param($type_str, ...$values);
+        
+        if ($stmt->execute()) {
+            echo json_encode(['status' => 'success', 'message' => 'Event updated successfully']);
+        } else {
+            echo json_encode(['status' => 'error', 'message' => 'Failed to update event: ' . $stmt->error]);
+        }
+    } else {
+        // Create new event
+        if (!$image_path) {
+            echo json_encode(['status' => 'error', 'message' => 'Image is required for new events']);
+            exit;
+        }
+        
+        $promo_path = $promo_path ?? 'assets/images/events/default-promo.jpg';
+        
+        $stmt = $conn->prepare("
+            INSERT INTO events (name, type, location, date, time, feature, description, image, promo, created_by)
+            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
+        ");
+        
+        $created_by = $_SESSION['user_id'] ?? 0;
+        
+        $stmt->bind_param('sssssssssi', $name, $type, $location, $date, $time, $feature, $description, $image_path, $promo_path, $created_by);
+        
+        if ($stmt->execute()) {
+            echo json_encode(['status' => 'success', 'message' => 'Event created successfully']);
+        } else {
+            echo json_encode(['status' => 'error', 'message' => 'Failed to create event: ' . $stmt->error]);
+        }
+    }
+    
+    $stmt->close();
+} catch (Exception $e) {
+    echo json_encode(['status' => 'error', 'message' => 'An error occurred: ' . $e->getMessage()]);
+}

src/admin/toggle_event_published.php

@@ -0,0 +1,75 @@
+<?php
+// Set JSON header FIRST before any includes that might output
+header('Content-Type: application/json');
+header('Cache-Control: no-cache, no-store, must-revalidate');
+header('Pragma: no-cache');
+header('Expires: 0');
+
+// Clean any output buffers before including header
+while (ob_get_level() > 0) {
+    ob_end_clean();
+}
+
+$rootPath = dirname(dirname(__DIR__));
+include_once($rootPath . '/header.php');
+checkAdmin();
+
+// Clean output buffer again in case header.php added content
+ob_clean();
+
+$event_id = $_POST['event_id'] ?? null;
+
+if (!$event_id) {
+    http_response_code(400);
+    echo json_encode(['status' => 'error', 'message' => 'Event ID is required']);
+    exit;
+}
+
+try {
+    // Get current published status
+    $stmt = $conn->prepare("SELECT published FROM events WHERE event_id = ?");
+    if (!$stmt) {
+        throw new Exception("Prepare failed: " . $conn->error);
+    }
+    
+    $stmt->bind_param("i", $event_id);
+    $stmt->execute();
+    $result = $stmt->get_result();
+
+    if ($result->num_rows === 0) {
+        http_response_code(404);
+        echo json_encode(['status' => 'error', 'message' => 'Event not found']);
+        $stmt->close();
+        exit;
+    }
+
+    $event = $result->fetch_assoc();
+    $new_status = $event['published'] == 1 ? 0 : 1;
+    $stmt->close();
+
+    // Update published status
+    $update_stmt = $conn->prepare("UPDATE events SET published = ?, updated_at = NOW() WHERE event_id = ?");
+    if (!$update_stmt) {
+        throw new Exception("Prepare failed: " . $conn->error);
+    }
+    
+    $update_stmt->bind_param("ii", $new_status, $event_id);
+
+    if ($update_stmt->execute()) {
+        ob_clean(); // Clean any buffered output before sending JSON
+        http_response_code(200);
+        echo json_encode([
+            'status' => 'success',
+            'message' => $new_status == 1 ? 'Event published' : 'Event unpublished',
+            'published' => $new_status
+        ]);
+    } else {
+        throw new Exception("Update failed: " . $update_stmt->error);
+    }
+    $update_stmt->close();
+} catch (Exception $e) {
+    ob_clean(); // Clean any buffered output before sending JSON
+    http_response_code(500);
+    echo json_encode(['status' => 'error', 'message' => 'Database error: ' . $e->getMessage()]);
+}
+

src/api/get_campsites.php

@@ -6,7 +6,16 @@ include_once('../config/functions.php');
 $conn = openDatabaseConnection();
 
 $stmt = $conn->prepare("SELECT 
-            c.*,
+            c.id,
+            c.name,
+            c.description,
+            c.website,
+            c.telephone,
+            c.latitude,
+            c.longitude,
+            c.thumbnail,
+            c.country,
+            c.province,
             u.first_name,
             u.last_name,
             u.profile_pic
@@ -26,6 +35,8 @@ while ($row = $result->fetch_assoc()) {
         'latitude' => $row['latitude'],
         'longitude' => $row['longitude'],
         'thumbnail' => $row['thumbnail'],
+        'country' => $row['country'],
+        'province' => $row['province'],
         'user' => [
             'first_name' => $row['first_name'],
             'last_name' => $row['last_name'],

src/config/functions.php

@@ -1434,6 +1434,10 @@ function checkMembershipApplication($user_id)
 
     // Check if the record exists and redirect
     if ($count > 0) {
+        // Set a session message before redirecting
+        if (!isset($_SESSION['message'])) {
+            $_SESSION['message'] = 'You have already submitted a membership application.';
+        }
         header("Location: membership_details.php");
         exit();
     }
@@ -2195,8 +2199,8 @@ function validateName($name, $minLength = 2, $maxLength = 100) {
         return false;
     }
     
-    // Only allow letters, spaces, hyphens, and apostrophes
-    if (!preg_match('/^[a-zA-Z\s\'-]+$/', $name)) {
+    // Allow letters, numbers, spaces, hyphens, and apostrophes
+    if (!preg_match('/^[a-zA-Z0-9\s\'-]+$/', $name)) {
         return false;
     }
     

src/pages/add_campsite.php

@@ -0,0 +1,118 @@
+<?php 
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+include_once($rootPath . '/src/config/connection.php');
+include_once($rootPath . '/src/config/functions.php');
+
+session_start();
+$user_id = $_SESSION['user_id'] ?? null;
+
+// CSRF Token Validation
+if (!isset($_POST['csrf_token']) || !validateCSRFToken($_POST['csrf_token'])) {
+    http_response_code(403);
+    die('Security token validation failed. Please try again.');
+}
+
+// campsites.php
+$conn = openDatabaseConnection();
+
+// Get text inputs
+$name = validateName($_POST['name'] ?? '') ?: '';
+$desc = isset($_POST['description']) ? htmlspecialchars($_POST['description'], ENT_QUOTES, 'UTF-8') : '';
+$country = isset($_POST['country']) ? htmlspecialchars($_POST['country'], ENT_QUOTES, 'UTF-8') : '';
+$province = isset($_POST['province']) ? htmlspecialchars($_POST['province'], ENT_QUOTES, 'UTF-8') : '';
+$lat = isset($_POST['latitude']) ? floatval($_POST['latitude']) : 0.0;
+$lng = isset($_POST['longitude']) ? floatval($_POST['longitude']) : 0.0;
+$website = isset($_POST['website']) ? filter_var($_POST['website'], FILTER_VALIDATE_URL) : '';
+$telephone = validatePhoneNumber($_POST['telephone'] ?? '') ?: '';
+
+if (empty($name)) {
+    http_response_code(400);
+    die('Campsite name is required.');
+}
+
+// Handle file upload
+$thumbnailPath = null;
+if (isset($_FILES['thumbnail']) && $_FILES['thumbnail']['error'] !== UPLOAD_ERR_NO_FILE) {
+    // Validate file using hardened validation function
+    $validationResult = validateFileUpload($_FILES['thumbnail'], 'profile_picture');
+    
+    if ($validationResult === false) {
+        http_response_code(400);
+        die('Invalid thumbnail image. Only JPG, JPEG, PNG, GIF, and WEBP images under 5MB are allowed.');
+    }
+    
+    $uploadDir = $rootPath . "/assets/uploads/campsites/";
+    if (!is_dir($uploadDir)) {
+        mkdir($uploadDir, 0755, true);
+    }
+    
+    if (!is_writable($uploadDir)) {
+        http_response_code(500);
+        die('Upload directory is not writable.');
+    }
+    
+    $randomFilename = $validationResult['filename'];
+    $targetFile = $uploadDir . $randomFilename;
+    
+    if (move_uploaded_file($_FILES["thumbnail"]["tmp_name"], $targetFile)) {
+        chmod($targetFile, 0644);
+        $thumbnailPath = "assets/uploads/campsites/" . $randomFilename;
+    } else {
+        http_response_code(500);
+        die('Failed to move uploaded file.');
+    }
+}
+
+$id = isset($_POST['id']) ? intval($_POST['id']) : 0;
+
+if ($id > 0) {
+  // Verify ownership - check if the campsite belongs to the current user
+  $ownerCheckStmt = $conn->prepare("SELECT user_id FROM campsites WHERE id = ?");
+  $ownerCheckStmt->bind_param("i", $id);
+  $ownerCheckStmt->execute();
+  $ownerResult = $ownerCheckStmt->get_result();
+  
+  if ($ownerResult->num_rows === 0) {
+    http_response_code(404);
+    die('Campsite not found.');
+  }
+  
+  $ownerRow = $ownerResult->fetch_assoc();
+  if ($ownerRow['user_id'] != $user_id) {
+    http_response_code(403);
+    die('You do not have permission to edit this campsite. Only the owner can make changes.');
+  }
+  
+  $ownerCheckStmt->close();
+  
+  // UPDATE
+  if ($thumbnailPath) {
+    $stmt = $conn->prepare("UPDATE campsites SET name=?, description=?, country=?, province=?, latitude=?, longitude=?, website=?, telephone=?, thumbnail=? WHERE id=?");
+    $stmt->bind_param("ssssddsssi", $name, $desc, $country, $province, $lat, $lng, $website, $telephone, $thumbnailPath, $id);
+  } else {
+    $stmt = $conn->prepare("UPDATE campsites SET name=?, description=?, country=?, province=?, latitude=?, longitude=?, website=?, telephone=? WHERE id=?");
+    $stmt->bind_param("ssssddssi", $name, $desc, $country, $province, $lat, $lng, $website, $telephone, $id);
+  }
+  
+  // Log the action
+  auditLog($user_id, 'CAMPSITE_UPDATE', 'campsites', $id, ['name' => $name]);
+} else {
+  // INSERT
+  $stmt = $conn->prepare("INSERT INTO campsites (name, description, country, province, latitude, longitude, website, telephone, thumbnail, user_id)
+                        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
+  $stmt->bind_param("ssssddsssi", $name, $desc, $country, $province, $lat, $lng, $website, $telephone, $thumbnailPath, $user_id);
+  
+  // Log the action
+  auditLog($user_id, 'CAMPSITE_CREATE', 'campsites', 0, ['name' => $name]);
+}
+
+if (!$stmt->execute()) {
+    http_response_code(500);
+    die('Database error: ' . $stmt->error);
+}
+
+$stmt->close();
+
+header("Location: campsites");
+?>

src/pages/bookings/campsites.php

@@ -3,6 +3,18 @@ $headerStyle = 'light';
 $rootPath = dirname(dirname(dirname(__DIR__)));
 include_once($rootPath . '/header.php');
 
+// Check if user has active membership
+if (!isset($_SESSION['user_id'])) {
+    header('Location: login');
+    exit;
+}
+
+$is_member = getUserMemberStatus($_SESSION['user_id']);
+if (!$is_member) {
+    header('Location: index');
+    exit;
+}
+
 $conn = openDatabaseConnection();
 $stmt = $conn->prepare("SELECT * FROM campsites");
 $stmt->execute();
@@ -17,104 +29,526 @@ while ($row = $result->fetch_assoc()) {
     #map {
         height: 600px;
         width: 100%;
+        position: relative;
     }
 
-    .gm-style .info-box {
-        max-width: 250px;
+    /* Center pin overlay */
+    .map-center-pin {
+        position: absolute;
+        top: 50%;
+        left: 50%;
+        transform: translate(-50%, -100%);
+        z-index: 10;
+        pointer-events: none;
+        font-size: 48px;
     }
 
-    .info-box img {
-        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.3);
-    
+    /* Location mode indicator */
+    .location-mode-indicator {
+        position: absolute;
+        top: 20px;
+        left: 20px;
+        background: #4CAF50;
+        color: white;
+        padding: 12px 20px;
+        border-radius: 6px;
+        z-index: 11;
+        font-weight: 500;
+        display: none;
+    }
+
+    /* Confirm location button */
+    .confirm-location-btn {
+        position: absolute;
+        bottom: 20px;
+        left: 50%;
+        transform: translateX(-50%);
+        background: #4CAF50;
+        color: white;
+        padding: 12px 30px;
+        border: none;
+        border-radius: 6px;
+        cursor: pointer;
+        font-weight: 500;
+        z-index: 11;
+        display: none;
+    }
+
+    .confirm-location-btn:hover {
+        background: #45a049;
+    }
+
+    .cancel-location-btn {
+        position: absolute;
+        bottom: 20px;
+        left: 20px;
+        background: #f44336;
+        color: white;
+        padding: 12px 30px;
+        border: none;
+        border-radius: 6px;
+        cursor: pointer;
+        font-weight: 500;
+        z-index: 11;
+        display: none;
+    }
+
+    .cancel-location-btn:hover {
+        background: #da190b;
+    }
+
+    /* Form styling to match manage_trips */
+    .campsite-form-container {
+        background: #f9f9f7;
+        border: 1px solid #d8d8d8;
+        border-radius: 10px;
+        padding: 30px;
+        margin: 20px 0;
+        display: none;
+    }
+
+    .campsite-form-container h5 {
+        color: #2c3e50;
+        font-weight: 600;
+        margin-bottom: 30px;
+        font-size: 1.5rem;
+    }
+
+    .campsite-form-container .form-group {
+        margin-bottom: 20px;
+    }
+
+    .campsite-form-container label {
+        font-weight: 500;
+        color: #34495e;
+        margin-bottom: 8px;
+        display: block;
+    }
+
+    .campsite-form-container .form-control {
+        width: 100%;
+        padding: 10px;
+        border: 1px solid #ddd;
+        border-radius: 6px;
+        font-size: 14px;
+    }
+
+    .campsite-form-container .form-control:focus {
+        border-color: #4CAF50;
+        box-shadow: 0 0 0 0.2rem rgba(76, 175, 80, 0.25);
+        outline: none;
+    }
+
+    .campsite-form-container .form-control select {
+        cursor: pointer;
+    }
+
+    .campsite-form-container .btn {
+        border-radius: 6px;
+        font-weight: 500;
+        padding: 10px 20px;
+    }
+
+    /* Table styling to match admin trips */
+    .campsites-table {
+        width: 100%;
+        border-collapse: separate;
+        border-spacing: 0;
+        margin: 10px 0;
+    }
+
+    .campsites-table thead th {
+        cursor: pointer;
+        text-align: left;
+        padding: 10px;
+        font-weight: bold;
+        position: relative;
+    }
+
+    .campsites-table thead th::after {
+        content: '\25B2';
+        font-size: 0.8em;
+        position: absolute;
+        right: 10px;
+        opacity: 0;
+        transition: opacity 0.2s;
+    }
+
+    .campsites-table thead th.asc::after {
+        content: '\25B2';
+        opacity: 1;
+    }
+
+    .campsites-table thead th.desc::after {
+        content: '\25BC';
+        opacity: 1;
+    }
+
+    .campsites-table tbody tr:nth-child(odd) {
+        background-color: transparent;
+    }
+
+    .campsites-table tbody tr:nth-child(even) {
+        background-color: rgb(255, 255, 255);
+        border-radius: 10px;
+    }
+
+    .campsites-table tbody td {
+        padding: 10px;
+    }
+
+    .campsites-table tbody tr:nth-child(even) td:first-child {
+        border-top-left-radius: 10px;
+        border-bottom-left-radius: 10px;
+    }
+
+    .campsites-table tbody tr:nth-child(even) td:last-child {
+        border-top-right-radius: 10px;
+        border-bottom-right-radius: 10px;
+    }
+
+    .filter-input {
+        width: 100%;
+        padding: 10px;
+        font-size: 16px;
+        background-color: rgb(255, 255, 255);
+        border-radius: 25px;
+        margin-bottom: 20px;
+        border: 1px solid #ddd;
+    }
+
+    .campsite-group {
+        color: #484848;
+        background: #f9f9f7;
+        border: 1px solid #d8d8d8;
+        border-radius: 10px;
+        margin-top: 15px;
+        margin-bottom: 15px;
+        padding: 10px;
+    }
 </style>
 
 <?php
-    $pageTitle = 'Campsites';
-    $breadcrumbs = [['Home' => 'index.php']];
-    require_once($rootPath . '/components/banner.php');
+$pageTitle = 'Campsites Directory';
+$breadcrumbs = [['Home' => 'index.php']];
+require_once($rootPath . '/components/banner.php');
 ?>
 
-<!-- Tour List Area start -->
-<section class="tour-list-page py-100 rel z-1">
+<section class="tour-list-page py-100 rel">
     <div class="container">
         <div class="row">
             <div class="col-lg-12">
+                <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 20px;">
+                    <h3>Campsites Map</h3>
+                    <button class="theme-btn" id="toggleFormBtn" onclick="startLocationMode()">
+                        <i class="far fa-plus"></i> Add Campsite
+                    </button>
+                </div>
+                <p style="color: #666; margin-bottom: 15px;">Click on a marker to view details, or use the "Add Campsite" button to add a new location.</p>
+
+                <!-- Map with location mode UI -->
+                <div style="position: relative; margin-bottom: 20px;">
+                    <div id="map" style="width: 100%; height: 500px;"></div>
+                    
+                    <!-- Location Mode Indicator -->
+                    <div class="location-mode-indicator">
+                        📍 Position the map center pin over your campsite location
+                    </div>
+                    
+                    <!-- Confirm and Cancel Buttons -->
+                    <button type="button" class="confirm-location-btn" onclick="confirmLocation()">
+                        ✓ Confirm Location
+                    </button>
+                    <button type="button" class="cancel-location-btn" onclick="cancelLocationMode()">
+                        ✕ Cancel
+                    </button>
+                </div>
+
+                <!-- Collapsible Campsite Form -->
+                <div class="campsite-form-container" id="campsiteFormContainer">
+                    <h5>Add New Campsite</h5>
+                    <form id="addCampsiteForm" method="POST" action="add_campsite" enctype="multipart/form-data">
+                        <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
+                        <input type="hidden" name="latitude" id="latitude">
+                        <input type="hidden" name="longitude" id="longitude">
+                        
+                        <div class="row mt-35">
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="campsite_name">Campsite Name *</label>
+                                    <input type="text" id="campsite_name" class="form-control" name="name" required>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="countrySelect">Country *</label>
+                                    <select id="countrySelect" class="form-control" name="country" required>
+                                        <option value="">-- Select Country --</option>
+                                        <option value="South Africa">South Africa</option>
+                                        <option value="Botswana">Botswana</option>
+                                        <option value="Eswatini">Eswatini</option>
+                                        <option value="Lesotho">Lesotho</option>
+                                        <option value="Namibia">Namibia</option>
+                                        <option value="Zimbabwe">Zimbabwe</option>
+                                        <option value="Other">Other</option>
+                                    </select>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="provinceSelect">Province *</label>
+                                    <select id="provinceSelect" class="form-control" name="province" required>
+                                        <option value="">-- Select Province --</option>
+                                        <option value="Eastern Cape">Eastern Cape</option>
+                                        <option value="Free State">Free State</option>
+                                        <option value="Gauteng">Gauteng</option>
+                                        <option value="KwaZulu-Natal">KwaZulu-Natal</option>
+                                        <option value="Limpopo">Limpopo</option>
+                                        <option value="Mpumalanga">Mpumalanga</option>
+                                        <option value="Northern Cape">Northern Cape</option>
+                                        <option value="North West">North West</option>
+                                        <option value="Western Cape">Western Cape</option>
+                                        <option value="Other">Other</option>
+                                    </select>
+                                </div>
+                            </div>
+                            <div class="col-md-12">
+                                <div class="form-group">
+                                    <label for="campsite_description">Description</label>
+                                    <textarea id="campsite_description" class="form-control" name="description" rows="3"></textarea>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="campsite_website">Booking URL</label>
+                                    <input type="url" id="campsite_website" class="form-control" name="website">
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="campsite_phone">Phone Number</label>
+                                    <input type="text" id="campsite_phone" class="form-control" name="telephone">
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="latitude_display">Latitude</label>
+                                    <input type="text" id="latitude_display" class="form-control" readonly>
+                                </div>
+                            </div>
+                            <div class="col-md-6">
+                                <div class="form-group">
+                                    <label for="longitude_display">Longitude</label>
+                                    <input type="text" id="longitude_display" class="form-control" readonly>
+                                </div>
+                            </div>
+                            <div class="col-md-12">
+                                <div class="form-group">
+                                    <label for="campsite_thumbnail">Thumbnail Image</label>
+                                    <input type="file" id="campsite_thumbnail" class="form-control" name="thumbnail" accept="image/*">
+                                </div>
+                            </div>
+                            <div class="col-md-12">
+                                <div class="form-group mb-0">
+                                    <button class="theme-btn style-two" type="submit" style="width: 100%; margin-right: 10px;">Save Campsite</button>
+                                    <button class="theme-btn" type="button" onclick="toggleCampsiteForm()" style="width: 100%; margin-top: 10px;">Cancel</button>
+                                </div>
+                            </div>
+                        </div>
+                    </form>
+                </div>
+
+                <!-- Campsites Table -->
+                <div style="margin-top: 40px;">
+                    <h4 style="margin-bottom: 20px;">All Campsites</h4>
+                    <input type="text" class="filter-input" id="campsitesFilter" placeholder="Filter results...">
+                    <div class="table-responsive">
+                        <table class="campsites-table">
+                            <thead class="table-light">
+                                <tr>
+                                    <th>Name</th>
+                                    <th>Description</th>
+                                    <th>Booking Website</th>
+                                    <th>Phone</th>
+                                    <th>Added By</th>
+                                    <th>Actions</th>
+                                </tr>
+                            </thead>
+                            <tbody id="campsitesTableBody">
+                                <!-- Populated by JavaScript -->
+                            </tbody>
+                        </table>
+                    </div>
+                </div>
 
-                <div id="map" style="width: 100%; height: 500px;"></div>
-                <!-- Add Campsite Modal -->
-                
             </div>
         </div>
     </div>
 </section>
-<div class="modal fade" id="addCampsiteModal" tabindex="-1">
-                    <div class="modal-dialog">
-                        <form id="addCampsiteForm" method="POST" action="add_campsite" enctype="multipart/form-data">
-                            <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
-                            <div class="modal-content">
-                                <div class="modal-header">
-                                    <h5 class="modal-title">Add Campsite</h5>
-                                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
-                                </div>
-                                <div class="modal-body">
-                                    <input type="hidden" name="latitude" id="latitude">
-                                    <input type="hidden" name="longitude" id="longitude">
-                                    <div class="mb-3">
-                                        <label class="form-label">Campsite Name</label>
-                                        <input type="text" class="form-control" name="name" required>
-                                    </div>
-                                    <div class="mb-3">
-                                        <label class="form-label">Description</label>
-                                        <textarea class="form-control" name="description" rows="3"></textarea>
-                                    </div>
-                                    <div class="mb-3">
-                                        <label class="form-label">Booking URL</label>
-                                        <input type="url" class="form-control" name="website">
-                                    </div>
-                                    <div class="mb-3">
-                                        <label class="form-label">Phone Number</label>
-                                        <input type="text" class="form-control" name="telephone">
-                                    </div>
-                                    <div class="mb-3">
-                                        <label class="form-label">Thumbnail Image</label>
-                                        <input type="file" class="form-control" name="thumbnail" accept="image/*">
-                                    </div>
-                                </div>
-                                <div class="modal-footer">
-                                    <button class="btn btn-primary" type="submit">Save Campsite</button>
-                                    <button class="btn btn-secondary" type="button" data-bs-dismiss="modal">Cancel</button>
-                                </div>
-                            </div>
-                        </form>
 
-                    </div>
-                </div>
 <script>
     let map;
+    let centerPinMarker;
+    let isLocationMode = false;
+    const currentUserId = <?php echo $_SESSION['user_id']; ?>;
     const campsites = <?php echo json_encode($campsites); ?>;
 
+    function startLocationMode() {
+        if (isLocationMode) return;
+        
+        isLocationMode = true;
+        
+        // Show location mode UI elements
+        document.querySelector(".location-mode-indicator").style.display = "block";
+        document.querySelector(".confirm-location-btn").style.display = "block";
+        document.querySelector(".cancel-location-btn").style.display = "block";
+        document.getElementById("toggleFormBtn").disabled = true;
+        
+        // Create invisible marker at map center
+        const mapCenter = map.getCenter();
+        centerPinMarker = new google.maps.Marker({
+            position: mapCenter,
+            map: map,
+            title: "Campsite Location",
+            draggable: true,
+            icon: 'http://maps.google.com/mapfiles/ms/icons/red-dot.png'
+        });
+        
+        // Update coordinates when marker is dragged
+        centerPinMarker.addListener('drag', function() {
+            const position = centerPinMarker.getPosition();
+            updateCoordinatesDisplay(position.lat(), position.lng());
+        });
+        
+        // Set initial coordinates
+        updateCoordinatesDisplay(mapCenter.lat(), mapCenter.lng());
+        
+        // Update coordinates when map is moved
+        const moveListener = map.addListener('center_changed', function() {
+            const mapCenter = map.getCenter();
+            centerPinMarker.setPosition(mapCenter);
+            updateCoordinatesDisplay(mapCenter.lat(), mapCenter.lng());
+        });
+        
+        // Store listener for cleanup
+        window.mapMoveListener = moveListener;
+    }
+
+    function updateCoordinatesDisplay(lat, lng) {
+        document.getElementById("latitude").value = lat;
+        document.getElementById("longitude").value = lng;
+        document.getElementById("latitude_display").value = lat.toFixed(6);
+        document.getElementById("longitude_display").value = lng.toFixed(6);
+    }
+
+    function confirmLocation() {
+        if (!isLocationMode) return;
+        
+        isLocationMode = false;
+        
+        // Hide location mode UI elements
+        document.querySelector(".location-mode-indicator").style.display = "none";
+        document.querySelector(".confirm-location-btn").style.display = "none";
+        document.querySelector(".cancel-location-btn").style.display = "none";
+        document.getElementById("toggleFormBtn").disabled = false;
+        
+        // Remove map move listener
+        if (window.mapMoveListener) {
+            google.maps.event.removeListener(window.mapMoveListener);
+        }
+        
+        // Remove the center marker
+        if (centerPinMarker) {
+            centerPinMarker.setMap(null);
+            centerPinMarker = null;
+        }
+        
+        // Reset form fields and show form (for new campsite only)
+        resetFormForNewCampsite();
+        document.getElementById("campsiteFormContainer").style.display = "block";
+        document.getElementById("campsiteFormContainer").scrollIntoView({ behavior: 'smooth', block: 'nearest' });
+    }
+
+    function cancelLocationMode() {
+        if (!isLocationMode) return;
+        
+        isLocationMode = false;
+        
+        // Hide location mode UI elements
+        document.querySelector(".location-mode-indicator").style.display = "none";
+        document.querySelector(".confirm-location-btn").style.display = "none";
+        document.querySelector(".cancel-location-btn").style.display = "none";
+        document.getElementById("toggleFormBtn").disabled = false;
+        
+        // Remove map move listener
+        if (window.mapMoveListener) {
+            google.maps.event.removeListener(window.mapMoveListener);
+        }
+        
+        // Remove the center marker
+        if (centerPinMarker) {
+            centerPinMarker.setMap(null);
+            centerPinMarker = null;
+        }
+    }
+
+    function toggleCampsiteForm() {
+        if (isLocationMode) return;
+        
+        const container = document.getElementById("campsiteFormContainer");
+        container.style.display = container.style.display === "none" ? "block" : "none";
+        if (container.style.display === "block") {
+            container.scrollIntoView({ behavior: 'smooth', block: 'nearest' });
+        }
+    }
+
+    function resetFormForNewCampsite() {
+        // This is called when confirming location for a NEW campsite
+        // Only clears text fields and removes ID, but keeps country/province selections
+        document.querySelector("#addCampsiteForm input[name='name']").value = '';
+        document.querySelector("#addCampsiteForm textarea[name='description']").value = '';
+        document.querySelector("#addCampsiteForm input[name='website']").value = '';
+        document.querySelector("#addCampsiteForm input[name='telephone']").value = '';
+        
+        // Remove the ID input if it exists
+        let idInput = document.querySelector("#addCampsiteForm input[name='id']");
+        if (idInput) {
+            idInput.remove();
+        }
+        
+        // Change form heading
+        document.querySelector("#campsiteFormContainer h5").textContent = "Add New Campsite";
+    }
+
+    function resetForm() {
+        // This is called when canceling the form - fully resets everything
+        document.querySelector("#campsiteFormContainer h5").textContent = "Add New Campsite";
+        
+        // Clear the form completely
+        document.getElementById("addCampsiteForm").reset();
+        
+        // Remove the ID input if it exists
+        let idInput = document.querySelector("#addCampsiteForm input[name='id']");
+        if (idInput) {
+            idInput.remove();
+        }
+        
+        // Clear coordinate displays
+        document.getElementById("latitude_display").value = '';
+        document.getElementById("longitude_display").value = '';
+    }
+
     function initMap() {
         map = new google.maps.Map(document.getElementById("map"), {
             center: {
                 lat: -28.0,
                 lng: 24.0
-            }, // SA center
+            },
             zoom: 6,
         });
 
-        map.addListener("click", function(e) {
-            const lat = e.latLng.lat();
-            const lng = e.latLng.lng();
-
-            document.getElementById("latitude").value = lat;
-            document.getElementById("longitude").value = lng;
-
-            const addModal = new bootstrap.Modal(document.getElementById("addCampsiteModal"));
-            addModal.show();
-        });
-
         // Load existing campsites from PHP
-        fetch("get_campsites.php")
+        fetch("get_campsites")
             .then(response => response.json())
             .then(data => {
                 data.forEach(site => {
@@ -133,7 +567,7 @@ while ($row = $result->fetch_assoc()) {
                     ${site.description ? site.description + "<br>" : ""}
                     ${site.website ? `<a href="${site.website}" target="_blank">Visit Website</a><br>` : ""}
                     ${site.telephone ? `Phone: ${site.telephone}<br>` : ""}
-                    ${site.thumbnail ? `<img src="${site.thumbnail}" style="width: 100%; max-width: 200px; border-radius: 8px; margin-top: 5px;">` : ""}
+                    ${site.thumbnail ? `<img src="${site.thumbnail}" style="width: 100%; max-width: 200px; border-radius: 8px; margin-top: 5px; box-shadow: 0 2px 8px rgba(0, 0, 0, 0.3);">` : ""}
                     ${site.user && site.user.first_name ? `
                         <div class="user-info mt-2 d-flex align-items-center">
                             <img src="${site.user.profile_pic}" style="width: 40px; height: 40px; border-radius: 50%; object-fit: cover; margin-right: 10px;">
@@ -156,40 +590,177 @@ while ($row = $result->fetch_assoc()) {
                         infowindow.open(map, marker);
                     });
                 });
+
+                // Populate the table
+                populateCampsitesTable(data);
             })
             .catch(err => console.error("Failed to load campsites:", err));
     }
 
+    function populateCampsitesTable(campsites) {
+        const tableBody = document.getElementById("campsitesTableBody");
+        tableBody.innerHTML = ""; // Clear existing rows
 
+        if (campsites.length === 0) {
+            tableBody.innerHTML = `
+                <tr>
+                    <td colspan="6" class="text-center text-muted" style="padding: 30px;">
+                        No campsites added yet. Click on the map to add one!
+                    </td>
+                </tr>
+            `;
+            return;
+        }
 
+        // Group campsites by country and province
+        const groupedByCountryAndProvince = {};
+        campsites.forEach(site => {
+            const country = site.country || 'Unknown Country';
+            const province = site.province || 'Unknown Province';
+            
+            if (!groupedByCountryAndProvince[country]) {
+                groupedByCountryAndProvince[country] = {};
+            }
+            if (!groupedByCountryAndProvince[country][province]) {
+                groupedByCountryAndProvince[country][province] = [];
+            }
+            groupedByCountryAndProvince[country][province].push(site);
+        });
+
+        // Sort countries alphabetically
+        const sortedCountries = Object.keys(groupedByCountryAndProvince).sort();
+
+        // Populate table with grouped data
+        sortedCountries.forEach(country => {
+            // Sort provinces alphabetically for this country
+            const sortedProvinces = Object.keys(groupedByCountryAndProvince[country]).sort();
+
+            sortedProvinces.forEach(province => {
+                // Add province group header
+                const groupRow = document.createElement("tr");
+                groupRow.innerHTML = `
+                    <td colspan="6" style="font-weight: 600; padding: 10px 8px; background-color: #f0f0f0;">
+                        <i class="fas fa-globe" style="color: #2196F3; margin-right: 8px;"></i>${country} - ${province}
+                    </td>
+                `;
+                tableBody.appendChild(groupRow);
+
+                // Add campsite rows for this province
+                groupedByCountryAndProvince[country][province].forEach(site => {
+                    const row = document.createElement("tr");
+                    const userName = site.user && site.user.first_name 
+                        ? `${site.user.first_name} ${site.user.last_name}` 
+                        : "Unknown";
+                    
+                    // Only show edit button if current user is the owner
+                    const editButtonHTML = site.user_id == currentUserId 
+                        ? `<button class="btn btn-sm btn-warning" onclick='editCampsite(${JSON.stringify(site)})'>Edit</button>` 
+                        : '';
+
+                    row.innerHTML = `
+                        <td><strong>${site.name}</strong></td>
+                        <td>${site.description ? site.description.substring(0, 50) + (site.description.length > 50 ? '...' : '') : '-'}</td>
+                        <td>${site.website ? `<a href="${site.website}" target="_blank" class="link-primary">Visit</a>` : '-'}</td>
+                        <td>${site.telephone || '-'}</td>
+                        <td><small>${userName}</small></td>
+                        <td>
+                            ${editButtonHTML}
+                            <a href="https://www.google.com/maps/dir/?api=1&destination=${site.latitude},${site.longitude}" target="_blank" class="btn btn-sm btn-outline-primary">Directions</a>
+                        </td>
+                    `;
+                    tableBody.appendChild(row);
+                });
+            });
+        });
+    }
 
     function editCampsite(site) {
-        // Pre-fill form
-        document.querySelector("#addCampsiteForm input[name='name']").value = site.name;
-        document.querySelector("#addCampsiteForm textarea[name='description']").value = site.description || "";
-        document.querySelector("#addCampsiteForm input[name='website']").value = site.website || "";
-        document.querySelector("#addCampsiteForm input[name='telephone']").value = site.telephone || "";
-        document.querySelector("#addCampsiteForm input[name='latitude']").value = site.latitude;
-        document.querySelector("#addCampsiteForm input[name='longitude']").value = site.longitude;
+        // Change form heading to indicate editing
+        document.querySelector("#campsiteFormContainer h5").textContent = "Edit Campsite";
+        
+        // Pre-fill form with a slight delay to ensure DOM is ready
+        setTimeout(() => {
+            document.querySelector("#addCampsiteForm input[name='name']").value = site.name;
+            document.querySelector("#addCampsiteForm textarea[name='description']").value = site.description || "";
+            document.querySelector("#addCampsiteForm input[name='website']").value = site.website || "";
+            document.querySelector("#addCampsiteForm input[name='telephone']").value = site.telephone || "";
+            document.querySelector("#addCampsiteForm input[name='latitude']").value = site.latitude;
+            document.querySelector("#addCampsiteForm input[name='longitude']").value = site.longitude;
+            document.getElementById("latitude_display").value = parseFloat(site.latitude).toFixed(6);
+            document.getElementById("longitude_display").value = parseFloat(site.longitude).toFixed(6);
+            
+            // Set country and province LAST to ensure they stick
+            document.querySelector("#addCampsiteForm select[name='country']").value = site.country || '';
+            document.querySelector("#addCampsiteForm select[name='province']").value = site.province || '';
 
-        // Add hidden ID input
-        let idInput = document.querySelector("#addCampsiteForm input[name='id']");
-        if (!idInput) {
-            idInput = document.createElement("input");
-            idInput.type = "hidden";
-            idInput.name = "id";
-            document.querySelector("#addCampsiteForm").appendChild(idInput);
-        }
-        idInput.value = site.id;
+            // Add hidden ID input
+            let idInput = document.querySelector("#addCampsiteForm input[name='id']");
+            if (!idInput) {
+                idInput = document.createElement("input");
+                idInput.type = "hidden";
+                idInput.name = "id";
+                document.querySelector("#addCampsiteForm").appendChild(idInput);
+            }
+            idInput.value = site.id;
+        }, 0);
 
-        // Show the modal
-        const addModal = new bootstrap.Modal(document.getElementById("addCampsiteModal"));
-        addModal.show();
+        // Show the form container
+        document.getElementById("campsiteFormContainer").style.display = "block";
+        document.getElementById("campsiteFormContainer").scrollIntoView({ behavior: 'smooth', block: 'nearest' });
     }
+
+    function filterCampsites() {
+        const filterInput = document.getElementById("campsitesFilter");
+        const filterValue = filterInput.value.toLowerCase();
+        const tableBody = document.getElementById("campsitesTableBody");
+        const rows = tableBody.getElementsByTagName("tr");
+        
+        let visibleRows = 0;
+        
+        for (let i = 0; i < rows.length; i++) {
+            const row = rows[i];
+            const text = row.textContent.toLowerCase();
+            
+            // Show rows that match the filter or are group headers
+            if (text.includes(filterValue) || row.innerHTML.includes('fas fa-globe')) {
+                row.style.display = "";
+                if (row.innerHTML.includes('fas fa-globe') === false) {
+                    visibleRows++;
+                }
+            } else {
+                row.style.display = "none";
+            }
+        }
+        
+        // Hide group headers if no campsites match in that group
+        for (let i = 0; i < rows.length; i++) {
+            const row = rows[i];
+            if (row.innerHTML.includes('fas fa-globe')) {
+                // Check if next visible row is also a header
+                let hasVisibleChildren = false;
+                for (let j = i + 1; j < rows.length; j++) {
+                    if (rows[j].style.display !== "none") {
+                        if (!rows[j].innerHTML.includes('fas fa-globe')) {
+                            hasVisibleChildren = true;
+                        }
+                        break;
+                    }
+                }
+                row.style.display = hasVisibleChildren ? "" : "none";
+            }
+        }
+    }
+
+    // Add filter event listener when page loads
+    document.addEventListener("DOMContentLoaded", function() {
+        const filterInput = document.getElementById("campsitesFilter");
+        if (filterInput) {
+            filterInput.addEventListener("keyup", filterCampsites);
+        }
+    });
 </script>
 
 <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyC-JuvnbUYc8WGjQBFFVZtKiv5_bFJoWLU&callback=initMap" async defer></script>
-<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
 
 
-<?php include_once(dirname(dirname(dirname(__DIR__))) . '/components/insta_footer.php'); ?>
+<?php include_once(dirname(dirname(dirname(__DIR__))) . '/components/insta_footer.php'); ?>

src/pages/events/events.php

@@ -90,8 +90,8 @@ include_once($rootPath . '/header.php');
                 </div>
 
                 <?php
-                // Query to retrieve upcoming events
-                $stmt = $conn->prepare("SELECT event_id, date, time, name, image, description, feature, location, type, promo FROM events WHERE date > CURDATE() ORDER BY date ASC");
+                // Query to retrieve upcoming published events only
+                $stmt = $conn->prepare("SELECT event_id, date, time, name, image, description, feature, location, type, promo FROM events WHERE date > CURDATE() AND published = 1 ORDER BY date ASC");
                 $stmt->execute();
                 $result = $stmt->get_result();
 

src/pages/gallery/create_album.php

@@ -0,0 +1,455 @@
+<?php
+$headerStyle = 'light';
+$rootPath = dirname(dirname(dirname(__DIR__)));
+include_once($rootPath . '/header.php');
+
+// Check if user has active membership
+if (!isset($_SESSION['user_id'])) {
+    header('Location: login');
+    exit;
+}
+
+$is_member = getUserMemberStatus($_SESSION['user_id']);
+if (!$is_member) {
+    header('Location: index');
+    exit;
+}
+
+$conn = openDatabaseConnection();
+$album = null;
+
+// Check if editing existing album
+$album_id = isset($_GET['id']) ? intval($_GET['id']) : 0;
+if ($album_id > 0) {
+    $stmt = $conn->prepare("SELECT * FROM photo_albums WHERE album_id = ? AND user_id = ?");
+    $stmt->bind_param("ii", $album_id, $_SESSION['user_id']);
+    $stmt->execute();
+    $result = $stmt->get_result();
+    
+    if ($result->num_rows > 0) {
+        $album = $result->fetch_assoc();
+    }
+    $stmt->close();
+    
+    if (!$album) {
+        $conn->close();
+        header('Location: gallery');
+        exit;
+    }
+}
+
+$conn->close();
+
+$pageTitle = $album ? 'Edit Album' : 'Create Album';
+$breadcrumbs = [['Home' => 'index.php'], ['Gallery' => 'gallery']];
+require_once($rootPath . '/components/banner.php');
+?>
+
+<style>
+    .form-container {
+        background: #f9f9f7;
+        border: 1px solid #d8d8d8;
+        border-radius: 10px;
+        padding: 40px;
+        max-width: 600px;
+        margin: 0 auto;
+    }
+
+    .form-group {
+        margin-bottom: 25px;
+    }
+
+    .form-group label {
+        display: block;
+        font-weight: 600;
+        color: #2c3e50;
+        margin-bottom: 8px;
+    }
+
+    .form-group input[type="text"],
+    .form-group textarea {
+        width: 100%;
+        padding: 12px;
+        border: 1px solid #ddd;
+        border-radius: 6px;
+        font-size: 14px;
+        font-family: inherit;
+    }
+
+    .form-group input[type="text"]:focus,
+    .form-group textarea:focus {
+        outline: none;
+        border-color: #667eea;
+        box-shadow: 0 0 0 3px rgba(102, 126, 234, 0.1);
+    }
+
+    .form-group textarea {
+        resize: vertical;
+        min-height: 120px;
+    }
+
+    .form-actions {
+        display: flex;
+        gap: 10px;
+        margin-top: 30px;
+    }
+
+    .form-actions button,
+    .form-actions a {
+        flex: 1;
+        padding: 12px 20px;
+        border: none;
+        border-radius: 6px;
+        font-size: 14px;
+        font-weight: 600;
+        cursor: pointer;
+        text-decoration: none;
+        text-align: center;
+        transition: background 0.3s;
+    }
+
+    .btn-submit {
+        background: #667eea;
+        color: white;
+    }
+
+    .btn-submit:hover {
+        background: #764ba2;
+    }
+
+    .btn-cancel {
+        background: #ddd;
+        color: #333;
+    }
+
+    .btn-cancel:hover {
+        background: #ccc;
+    }
+
+    .photos-section {
+        margin-top: 40px;
+        padding-top: 40px;
+        border-top: 2px solid #d8d8d8;
+    }
+
+    .photos-grid {
+        display: grid;
+        grid-template-columns: repeat(auto-fill, minmax(150px, 1fr));
+        gap: 15px;
+        margin-top: 15px;
+    }
+
+    .photo-item-edit {
+        position: relative;
+        aspect-ratio: 1;
+        border-radius: 8px;
+        overflow: hidden;
+        background: white;
+        border: 1px solid #ddd;
+    }
+
+    .photo-item-edit img {
+        width: 100%;
+        height: 100%;
+        object-fit: cover;
+    }
+
+    .photo-delete-btn {
+        position: absolute;
+        top: 5px;
+        right: 5px;
+        background: #f44336;
+        color: white;
+        border: none;
+        border-radius: 50%;
+        width: 30px;
+        height: 30px;
+        cursor: pointer;
+        font-size: 18px;
+        display: flex;
+        align-items: center;
+        justify-content: center;
+        transition: background 0.3s;
+    }
+
+    .photo-delete-btn:hover {
+        background: #d32f2f;
+    }
+
+    .upload-area {
+        border: 2px dashed #667eea;
+        border-radius: 8px;
+        padding: 30px;
+        text-align: center;
+        cursor: pointer;
+        transition: background 0.3s;
+    }
+
+    .upload-area:hover {
+        background: rgba(102, 126, 234, 0.05);
+    }
+
+    .upload-area.dragover {
+        background: rgba(102, 126, 234, 0.1);
+        border-color: #764ba2;
+    }
+
+    .upload-input {
+        display: none;
+    }
+
+    .upload-text {
+        color: #667eea;
+        font-weight: 500;
+    }
+
+    .helper-text {
+        font-size: 0.9rem;
+        color: #999;
+        margin-top: 5px;
+    }
+
+    .cover-preview-area {
+        margin-bottom: 15px;
+    }
+
+    .current-cover {
+        border-radius: 8px;
+        overflow: hidden;
+        margin-bottom: 15px;
+    }
+
+    .current-cover img {
+        width: 100%;
+        max-height: 250px;
+        object-fit: cover;
+        display: block;
+    }
+
+    #coverUploadArea {
+        cursor: pointer;
+    }
+</style>
+
+<section class="tour-list-page py-100 rel">
+    <div class="container">
+        <div class="row">
+            <div class="col-lg-12">
+                <div class="form-container">
+                    <h2 style="margin-top: 0; color: #2c3e50;"><?php echo $album ? 'Edit Album' : 'Create Album'; ?></h2>
+                    
+                    <form id="albumForm" method="POST" action="<?php echo $album ? 'update_album' : 'save_album'; ?>" enctype="multipart/form-data">
+                        <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
+                        <?php if ($album): ?>
+                            <input type="hidden" name="album_id" value="<?php echo $album['album_id']; ?>">
+                        <?php endif; ?>
+
+                        <div class="form-group">
+                            <label for="title">Album Title *</label>
+                            <input type="text" id="title" name="title" required value="<?php echo $album ? htmlspecialchars($album['title']) : ''; ?>">
+                        </div>
+
+                        <div class="form-group">
+                            <label for="description">Description</label>
+                            <textarea id="description" name="description" placeholder="Add a description for your album..."><?php echo $album ? htmlspecialchars($album['description']) : ''; ?></textarea>
+                            <div class="helper-text">Optional: Share details about when, where, or why you created this album</div>
+                        </div>
+
+                        <div class="form-group">
+                            <label for="cover_image">Album Cover Image</label>
+                            <div class="cover-preview-area">
+                                <?php if ($album && $album['cover_image']): ?>
+                                    <div class="current-cover">
+                                        <img id="currentCoverImg" src="<?php echo htmlspecialchars($album['cover_image']); ?>" alt="Current cover">
+                                        <p style="margin-top: 10px; font-size: 0.9rem; color: #666;">Current cover image</p>
+                                    </div>
+                                <?php else: ?>
+                                    <div id="currentCoverImg" style="width: 100%; height: 200px; background: #f0f0f0; border-radius: 6px; display: flex; align-items: center; justify-content: center; color: #999; margin-bottom: 15px;">No cover image yet</div>
+                                <?php endif; ?>
+                            </div>
+                            <div class="upload-area" id="coverUploadArea" style="margin-top: 15px;">
+                                <input type="file" id="cover_image" name="cover_image" accept="image/*" class="upload-input">
+                                <div style="font-size: 1.5rem; margin-bottom: 10px;">🖼️</div>
+                                <p class="upload-text">Click to select cover image</p>
+                                <div class="helper-text">Image will be used as album thumbnail. Recommended: Square image (500x500px or larger)</div>
+                            </div>
+                            <div id="coverFileName" style="margin-top: 10px;"></div>
+                        </div>
+
+                        <?php if ($album): ?>
+                            <div class="photos-section">
+                                <h4>Photos in Album</h4>
+                                <div class="photos-grid" id="photosGrid">
+                                    <!-- Photos will be loaded here -->
+                                </div>
+                            </div>
+                        <?php endif; ?>
+
+                        <div class="form-group">
+                            <label for="photos">Upload Photos</label>
+                            <div class="upload-area" id="uploadArea">
+                                <input type="file" id="photos" name="photos[]" multiple accept="image/*" class="upload-input">
+                                <div style="font-size: 2rem; margin-bottom: 10px;">📸</div>
+                                <p class="upload-text">Drag and drop photos here or click to select</p>
+                                <div class="helper-text">Supports JPG, PNG, GIF, WEBP. Max 5MB per image</div>
+                            </div>
+                        </div>
+
+                        <div id="fileList" style="margin-top: 15px;"></div>
+
+                        <div class="form-actions">
+                            <button type="submit" class="btn-submit">
+                                <?php echo $album ? 'Update Album' : 'Create Album'; ?>
+                            </button>
+                            <a href="gallery" class="btn-cancel">Cancel</a>
+                        </div>
+                    </form>
+
+                    <?php if ($album): ?>
+                        <div style="margin-top: 40px; padding-top: 40px; border-top: 2px solid #d8d8d8;">
+                            <button type="button" onclick="deleteAlbum(<?php echo $album['album_id']; ?>)" class="btn-delete" style="background: #f44336; color: white; padding: 10px 20px; border: none; border-radius: 6px; cursor: pointer; width: 100%;">
+                                <i class="far fa-trash"></i> Delete Album
+                            </button>
+                        </div>
+                    <?php endif; ?>
+                </div>
+            </div>
+        </div>
+    </div>
+</section>
+
+<script>
+    const uploadArea = document.getElementById('uploadArea');
+    const fileInput = document.getElementById('photos');
+    const fileList = document.getElementById('fileList');
+    const coverUploadArea = document.getElementById('coverUploadArea');
+    const coverImageInput = document.getElementById('cover_image');
+    const coverFileName = document.getElementById('coverFileName');
+
+    // Cover image handling
+    coverUploadArea.addEventListener('click', () => {
+        coverImageInput.click();
+    });
+
+    coverImageInput.addEventListener('change', (e) => {
+        if (e.target.files.length > 0) {
+            const file = e.target.files[0];
+            const reader = new FileReader();
+            
+            reader.onload = (event) => {
+                const preview = document.getElementById('currentCoverImg');
+                if (preview.tagName === 'IMG') {
+                    preview.src = event.target.result;
+                } else {
+                    const img = document.createElement('img');
+                    img.src = event.target.result;
+                    img.alt = 'Cover preview';
+                    preview.replaceWith(img);
+                    img.id = 'currentCoverImg';
+                }
+            };
+            
+            reader.readAsDataURL(file);
+            
+            coverFileName.innerHTML = '<p style="color: #667eea; font-weight: 500;">Selected: ' + file.name + ' (' + (file.size / 1024 / 1024).toFixed(2) + ' MB)</p>';
+        }
+    });
+
+    // Drag and drop for cover
+    coverUploadArea.addEventListener('dragover', (e) => {
+        e.preventDefault();
+        coverUploadArea.classList.add('dragover');
+    });
+
+    coverUploadArea.addEventListener('dragleave', () => {
+        coverUploadArea.classList.remove('dragover');
+    });
+
+    coverUploadArea.addEventListener('drop', (e) => {
+        e.preventDefault();
+        coverUploadArea.classList.remove('dragover');
+        if (e.dataTransfer.files.length > 0) {
+            coverImageInput.files = e.dataTransfer.files;
+            const event = new Event('change', { bubbles: true });
+            coverImageInput.dispatchEvent(event);
+        }
+    });
+
+    // Regular photos drag and drop
+    uploadArea.addEventListener('dragover', (e) => {
+        e.preventDefault();
+        uploadArea.classList.add('dragover');
+    });
+
+    uploadArea.addEventListener('dragleave', () => {
+        uploadArea.classList.remove('dragover');
+    });
+
+    uploadArea.addEventListener('drop', (e) => {
+        e.preventDefault();
+        uploadArea.classList.remove('dragover');
+        fileInput.files = e.dataTransfer.files;
+        updateFileList();
+    });
+
+    uploadArea.addEventListener('click', () => {
+        fileInput.click();
+    });
+
+    fileInput.addEventListener('change', updateFileList);
+
+    function updateFileList() {
+        fileList.innerHTML = '';
+        if (fileInput.files.length > 0) {
+            fileList.innerHTML = '<p style="color: #667eea; font-weight: 500; margin-bottom: 10px;">Selected files:</p>';
+            const ul = document.createElement('ul');
+            ul.style.margin = '0';
+            ul.style.paddingLeft = '20px';
+            
+            for (let file of fileInput.files) {
+                const li = document.createElement('li');
+                li.textContent = file.name + ' (' + (file.size / 1024 / 1024).toFixed(2) + ' MB)';
+                li.style.color = '#666';
+                li.style.marginBottom = '5px';
+                ul.appendChild(li);
+            }
+            fileList.appendChild(ul);
+        }
+    }
+
+    function deleteAlbum(albumId) {
+        if (confirm('Are you sure you want to delete this album and all its photos? This action cannot be undone.')) {
+            window.location.href = 'delete_album?id=' + albumId;
+        }
+    }
+
+    // Load existing photos if editing
+    <?php if ($album): ?>
+        fetch('get_album_photos?id=<?php echo $album['album_id']; ?>')
+            .then(r => r.json())
+            .then(photos => {
+                const grid = document.getElementById('photosGrid');
+                photos.forEach(photo => {
+                    const div = document.createElement('div');
+                    div.className = 'photo-item-edit';
+                    div.innerHTML = `
+                        <img src="${photo.file_path}" alt="Photo">
+                        <button type="button" class="photo-delete-btn" onclick="deletePhoto(${photo.photo_id})">✕</button>
+                    `;
+                    grid.appendChild(div);
+                });
+            });
+
+        function deletePhoto(photoId) {
+            if (confirm('Delete this photo?')) {
+                fetch('delete_photo', {
+                    method: 'POST',
+                    headers: {'Content-Type': 'application/x-www-form-urlencoded'},
+                    body: 'photo_id=' + photoId + '&csrf_token=<?php echo generateCSRFToken(); ?>'
+                }).then(() => location.reload());
+            }
+        }
+    <?php endif; ?>
+</script>
+
+<?php include_once(dirname(dirname(dirname(__DIR__))) . '/components/insta_footer.php'); ?>

src/pages/gallery/gallery.php

@@ -0,0 +1,319 @@
+<?php
+$headerStyle = 'light';
+$rootPath = dirname(dirname(dirname(__DIR__)));
+include_once($rootPath . '/header.php');
+
+// Check if user has active membership
+if (!isset($_SESSION['user_id'])) {
+    header('Location: login');
+    exit;
+}
+
+$is_member = getUserMemberStatus($_SESSION['user_id']);
+if (!$is_member) {
+    header('Location: index');
+    exit;
+}
+
+$conn = openDatabaseConnection();
+$current_user_id = $_SESSION['user_id'];
+
+// Fetch all albums with creator information
+$albums_query = "
+    SELECT 
+        pa.album_id,
+        pa.title,
+        pa.description,
+        pa.cover_image,
+        pa.created_at,
+        u.user_id,
+        u.first_name,
+        u.last_name,
+        u.profile_pic,
+        COUNT(p.photo_id) as photo_count
+    FROM photo_albums pa
+    INNER JOIN users u ON pa.user_id = u.user_id
+    LEFT JOIN photos p ON pa.album_id = p.album_id
+    GROUP BY pa.album_id
+    ORDER BY pa.created_at DESC
+";
+
+$result = $conn->query($albums_query);
+$albums = [];
+if ($result && $result->num_rows > 0) {
+    while ($row = $result->fetch_assoc()) {
+        $albums[] = $row;
+    }
+}
+
+$conn->close();
+?>
+
+<style>
+    .gallery-grid {
+        display: grid;
+        grid-template-columns: repeat(auto-fill, minmax(280px, 1fr));
+        gap: 24px;
+        margin: 30px 0;
+    }
+
+    .album-card {
+        position: relative;
+        border-radius: 12px;
+        overflow: hidden;
+        background: white;
+        box-shadow: 0 2px 12px rgba(0, 0, 0, 0.08);
+        transition: all 0.3s ease;
+        display: flex;
+        flex-direction: column;
+        height: 100%;
+    }
+
+    .album-card:hover {
+        transform: translateY(-8px);
+        box-shadow: 0 8px 24px rgba(0, 0, 0, 0.15);
+    }
+
+    .album-image-wrapper {
+        position: relative;
+        width: 100%;
+        aspect-ratio: 16 / 10;
+        overflow: hidden;
+        background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
+    }
+
+    .album-image-wrapper img {
+        width: 100%;
+        height: 100%;
+        object-fit: cover;
+        transition: transform 0.3s ease;
+    }
+
+    .album-card:hover .album-image-wrapper img {
+        transform: scale(1.05);
+    }
+
+    .album-image-wrapper .no-image {
+        width: 100%;
+        height: 100%;
+        display: flex;
+        align-items: center;
+        justify-content: center;
+        font-size: 2.5rem;
+        color: rgba(255, 255, 255, 0.6);
+    }
+
+    .album-footer {
+        padding: 16px;
+        background: white;
+        display: flex;
+        flex-direction: column;
+        gap: 12px;
+        flex-grow: 1;
+    }
+
+    .album-title {
+        font-size: 1.1rem;
+        font-weight: 700;
+        color: #2c3e50;
+        margin: 0;
+        white-space: nowrap;
+        overflow: hidden;
+        text-overflow: ellipsis;
+    }
+
+    .album-meta-row {
+        display: flex;
+        align-items: center;
+        justify-content: space-between;
+        gap: 8px;
+    }
+
+    .album-creator-info {
+        display: flex;
+        align-items: center;
+        gap: 8px;
+        min-width: 0;
+        flex: 1;
+    }
+
+    .album-creator-avatar {
+        width: 28px;
+        height: 28px;
+        border-radius: 50%;
+        object-fit: cover;
+        flex-shrink: 0;
+    }
+
+    .album-creator-name {
+        font-size: 0.8rem;
+        color: #666;
+        white-space: nowrap;
+        overflow: hidden;
+        text-overflow: ellipsis;
+    }
+
+    .album-photo-count {
+        font-size: 0.8rem;
+        color: #999;
+        flex-shrink: 0;
+    }
+
+    .album-actions {
+        display: flex;
+        gap: 8px;
+        margin-top: auto;
+    }
+
+    .album-view-btn {
+        flex: 1;
+        padding: 8px 12px;
+        background: #667eea;
+        color: white;
+        border: none;
+        border-radius: 30px;
+        font-size: 0.85rem;
+        font-weight: 600;
+        cursor: pointer;
+        transition: background 0.3s;
+        text-decoration: none;
+        text-align: center;
+        display: block;
+    }
+
+    .album-view-btn:hover {
+        background: #764ba2;
+        text-decoration: none;
+        color: white;
+    }
+
+    .album-edit-btn {
+        padding: 8px 12px;
+        background: white;
+        color: #667eea;
+        border: 1px solid #667eea;
+        border-radius: 6px;
+        font-size: 0.85rem;
+        font-weight: 600;
+        cursor: pointer;
+        transition: all 0.3s;
+        text-decoration: none;
+        display: inline-block;
+        text-align: center;
+    }
+
+    .album-edit-btn:hover {
+        background: #667eea;
+        color: white;
+        text-decoration: none;
+    }
+
+    .create-album-btn {
+        display: inline-flex;
+        align-items: center;
+        gap: 8px;
+        margin-bottom: 30px;
+    }
+
+    .no-albums {
+        text-align: center;
+        padding: 80px 20px;
+        background: #f9f9f7;
+        border-radius: 10px;
+        color: #999;
+    }
+
+    .no-albums-icon {
+        font-size: 3rem;
+        margin-bottom: 20px;
+        color: #ddd;
+    }
+
+    .no-albums p {
+        font-size: 1.1rem;
+        margin-bottom: 20px;
+        color: #666;
+    }
+
+    .no-albums .theme-btn {
+        display: inline-block;
+    }
+</style>
+
+<?php
+$pageTitle = 'Photo Gallery';
+$breadcrumbs = [['Home' => 'index.php'], ['Members Area' => '#']];
+require_once($rootPath . '/components/banner.php');
+?>
+
+<section class="tour-list-page py-100 rel">
+    <div class="container">
+        <div class="row">
+            <div class="col-lg-12">
+                <div style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 30px;">
+                    <h2 style="margin: 0;">Member Photo Gallery</h2>
+                    <a href="create_album" class="theme-btn create-album-btn">
+                        <i class="far fa-plus"></i> Create Album
+                    </a>
+                </div>
+
+                <?php if (count($albums) > 0): ?>
+                    <div class="gallery-grid">
+                        <?php foreach ($albums as $album): ?>
+                            <div class="album-card">
+                                <div class="album-image-wrapper">
+                                    <?php if ($album['cover_image']): ?>
+                                        <img src="<?php echo htmlspecialchars($album['cover_image']); ?>" alt="<?php echo htmlspecialchars($album['title']); ?>">
+                                    <?php else: ?>
+                                        <div class="no-image">
+                                            <i class="far fa-image"></i>
+                                        </div>
+                                    <?php endif; ?>
+                                </div>
+
+                                <div class="album-footer">
+                                    <h3 class="album-title" title="<?php echo htmlspecialchars($album['title']); ?>">
+                                        <?php echo htmlspecialchars($album['title']); ?>
+                                    </h3>
+
+                                    <div class="album-meta-row">
+                                        <div class="album-creator-info">
+                                            <img src="<?php echo htmlspecialchars($album['profile_pic']); ?>" alt="<?php echo htmlspecialchars($album['first_name']); ?>" class="album-creator-avatar">
+                                            <span class="album-creator-name">
+                                                <?php echo htmlspecialchars($album['first_name'] . ' ' . $album['last_name']); ?>
+                                            </span>
+                                        </div>
+                                        <span class="album-photo-count">
+                                            <?php echo $album['photo_count']; ?> photo<?php echo $album['photo_count'] !== 1 ? 's' : ''; ?>
+                                        </span>
+                                    </div>
+
+                                    <div class="album-actions">
+                                        <a href="view_album?id=<?php echo $album['album_id']; ?>" class="album-view-btn">
+                                            View
+                                        </a>
+                                        <?php if ($album['user_id'] == $current_user_id): ?>
+                                            <a href="edit_album?id=<?php echo $album['album_id']; ?>" class="album-edit-btn">
+                                                <i class="far fa-edit"></i>
+                                            </a>
+                                        <?php endif; ?>
+                                    </div>
+                                </div>
+                            </div>
+                        <?php endforeach; ?>
+                    </div>
+                <?php else: ?>
+                    <div class="no-albums">
+                        <div class="no-albums-icon">
+                            <i class="far fa-image"></i>
+                        </div>
+                        <p>No photo albums yet. Be the first to create one!</p>
+                        <a href="create_album" class="theme-btn">Create Album</a>
+                    </div>
+                <?php endif; ?>
+            </div>
+        </div>
+    </div>
+</section>
+
+<?php include_once(dirname(dirname(dirname(__DIR__))) . '/components/insta_footer.php'); ?>

src/pages/gallery/view_album.php

@@ -0,0 +1,384 @@
+<?php
+$headerStyle = 'light';
+$rootPath = dirname(dirname(dirname(__DIR__)));
+include_once($rootPath . '/header.php');
+
+// Check if user has active membership
+if (!isset($_SESSION['user_id'])) {
+    header('Location: login');
+    exit;
+}
+
+$is_member = getUserMemberStatus($_SESSION['user_id']);
+if (!$is_member) {
+    header('Location: index');
+    exit;
+}
+
+$conn = openDatabaseConnection();
+$album_id = isset($_GET['id']) ? intval($_GET['id']) : 0;
+
+if ($album_id === 0) {
+    header('Location: gallery');
+    exit;
+}
+
+// Fetch album details
+$album_query = "
+    SELECT 
+        pa.album_id,
+        pa.title,
+        pa.description,
+        pa.cover_image,
+        pa.created_at,
+        pa.user_id,
+        u.first_name,
+        u.last_name,
+        u.profile_pic
+    FROM photo_albums pa
+    INNER JOIN users u ON pa.user_id = u.user_id
+    WHERE pa.album_id = ?
+";
+
+$stmt = $conn->prepare($album_query);
+$stmt->bind_param("i", $album_id);
+$stmt->execute();
+$album_result = $stmt->get_result();
+
+if ($album_result->num_rows === 0) {
+    $stmt->close();
+    $conn->close();
+    header('Location: gallery');
+    exit;
+}
+
+$album = $album_result->fetch_assoc();
+$stmt->close();
+
+// Fetch all photos in the album
+$photos_query = "
+    SELECT photo_id, file_path, caption, display_order
+    FROM photos
+    WHERE album_id = ?
+    ORDER BY display_order ASC
+";
+
+$stmt = $conn->prepare($photos_query);
+$stmt->bind_param("i", $album_id);
+$stmt->execute();
+$photos_result = $stmt->get_result();
+
+$photos = [];
+if ($photos_result && $photos_result->num_rows > 0) {
+    while ($row = $photos_result->fetch_assoc()) {
+        $photos[] = $row;
+    }
+}
+
+$stmt->close();
+$conn->close();
+?>
+
+<style>
+    .album-header {
+        background-size: cover;
+        background-position: center;
+        background-repeat: no-repeat;
+        color: white;
+        padding: 60px 20px;
+        margin-bottom: 40px;
+        border-radius: 10px;
+        position: relative;
+        overflow: hidden;
+    }
+
+    .album-header::before {
+        content: '';
+        position: absolute;
+        top: 0;
+        left: 0;
+        right: 0;
+        bottom: 0;
+        background: rgba(0, 0, 0, 0.5);
+        z-index: 1;
+    }
+
+    .album-header-content {
+        display: flex;
+        align-items: center;
+        gap: 20px;
+        position: relative;
+        z-index: 2;
+    }
+
+    .album-creator-info {
+        display: flex;
+        align-items: center;
+        gap: 12px;
+        margin-top: 15px;
+    }
+
+    .album-creator-avatar {
+        width: 50px;
+        height: 50px;
+        border-radius: 50%;
+        object-fit: cover;
+        border: 3px solid white;
+    }
+
+    .creator-details {
+        display: flex;
+        flex-direction: column;
+    }
+
+    .creator-details span:first-child {
+        font-weight: 600;
+        font-size: 1rem;
+    }
+
+    .creator-details span:last-child {
+        font-size: 0.9rem;
+        opacity: 0.9;
+    }
+
+    .photo-gallery {
+        display: grid;
+        grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));
+        gap: 20px;
+        margin-bottom: 40px;
+    }
+
+    .photo-item {
+        position: relative;
+        overflow: hidden;
+        border-radius: 8px;
+        cursor: pointer;
+        aspect-ratio: 1;
+        transition: transform 0.3s;
+    }
+
+    .photo-item:hover {
+        transform: scale(1.05);
+    }
+
+    .photo-item img {
+        width: 100%;
+        height: 100%;
+        object-fit: cover;
+        display: block;
+    }
+
+    .photo-overlay {
+        position: absolute;
+        top: 0;
+        left: 0;
+        right: 0;
+        bottom: 0;
+        background: rgba(0,0,0,0.5);
+        display: flex;
+        align-items: center;
+        justify-content: center;
+        opacity: 0;
+        transition: opacity 0.3s;
+    }
+
+    .photo-item:hover .photo-overlay {
+        opacity: 1;
+    }
+
+    .photo-caption {
+        color: white;
+        text-align: center;
+        font-weight: 500;
+        max-width: 90%;
+    }
+
+    .lightbox {
+        display: none;
+        position: fixed;
+        top: 0;
+        left: 0;
+        right: 0;
+        bottom: 0;
+        background: rgba(0,0,0,0.9);
+        z-index: 1000;
+        align-items: center;
+        justify-content: center;
+    }
+
+    .lightbox.active {
+        display: flex;
+    }
+
+    .lightbox-content {
+        position: relative;
+        max-width: 90vw;
+        max-height: 90vh;
+    }
+
+    .lightbox-image {
+        max-width: 100%;
+        max-height: 90vh;
+        object-fit: contain;
+    }
+
+    .lightbox-close {
+        position: absolute;
+        top: 20px;
+        right: 20px;
+        color: white;
+        font-size: 2rem;
+        cursor: pointer;
+        background: none;
+        border: none;
+        z-index: 1001;
+    }
+
+    .lightbox-nav {
+        position: absolute;
+        top: 50%;
+        transform: translateY(-50%);
+        color: white;
+        font-size: 2rem;
+        cursor: pointer;
+        background: rgba(0,0,0,0.5);
+        border: none;
+        padding: 20px;
+        z-index: 1001;
+    }
+
+    .lightbox-prev {
+        left: 20px;
+    }
+
+    .lightbox-next {
+        right: 20px;
+    }
+
+    .back-link {
+        margin-bottom: 20px;
+        display: inline-block;
+    }
+
+    .no-photos {
+        text-align: center;
+        padding: 60px 20px;
+        color: #999;
+    }
+
+    .edit-album-btn {
+        margin-left: 10px;
+    }
+</style>
+
+<?php
+$pageTitle = htmlspecialchars($album['title']);
+$breadcrumbs = [['Home' => 'index.php'], ['Gallery' => 'gallery'], [$album['title'] => '#']];
+require_once($rootPath . '/components/banner.php');
+?>
+
+<section class="tour-list-page py-100 rel">
+    <div class="container">
+        <div class="row">
+            <div class="col-lg-12">
+                <a href="gallery" class="back-link" style="color: #667eea; text-decoration: none;">
+                    <i class="far fa-arrow-left"></i> Back to Gallery
+                </a>
+
+                <div class="album-header" <?php if ($album['cover_image']): ?>style="background-image: url('<?php echo htmlspecialchars($album['cover_image']); ?>');"<?php endif; ?>>
+                    <div class="album-header-content px-2">
+                        <div style="flex: 1;">
+                            <h2 style="margin: 0; margin-bottom: 10px; color: white; text-shadow: 2px 2px 4px rgba(0,0,0,0.5);"><?php echo htmlspecialchars($album['title']); ?></h2>
+                            <?php if ($album['description']): ?>
+                                <p style="margin: 0 0 15px 0; font-size: 1rem; opacity: 0.95; color: white; text-shadow: 1px 1px 3px rgba(0,0,0,0.5);">
+                                    <?php echo htmlspecialchars($album['description']); ?>
+                                </p>
+                            <?php endif; ?>
+                            
+                            <div class="album-creator-info">
+                                <img src="<?php echo htmlspecialchars($album['profile_pic']); ?>" alt="<?php echo htmlspecialchars($album['first_name']); ?>" class="album-creator-avatar">
+                                <div class="creator-details">
+                                    <span><?php echo htmlspecialchars($album['first_name'] . ' ' . $album['last_name']); ?></span>
+                                    <span><?php echo date('F j, Y', strtotime($album['created_at'])); ?></span>
+                                </div>
+                            </div>
+                        </div>
+                        <?php if ($album['user_id'] == $_SESSION['user_id']): ?>
+                            <div>
+                                <a href="edit_album?id=<?php echo $album['album_id']; ?>" class="theme-btn" style="background: white; color: #667eea; border: none;">
+                                    <i class="far fa-edit"></i> Edit Album
+                                </a>
+                            </div>
+                        <?php endif; ?>
+                    </div>
+                </div>
+
+                <?php if (count($photos) > 0): ?>
+                    <div class="photo-gallery">
+                        <?php foreach ($photos as $index => $photo): ?>
+                            <div class="photo-item" onclick="openLightbox(<?php echo $index; ?>)">
+                                <img src="<?php echo htmlspecialchars($photo['file_path']); ?>" alt="<?php echo htmlspecialchars($photo['caption'] ?? 'Photo'); ?>">
+                                <?php if ($photo['caption']): ?>
+                                    <div class="photo-overlay">
+                                        <div class="photo-caption"><?php echo htmlspecialchars($photo['caption']); ?></div>
+                                    </div>
+                                <?php endif; ?>
+                            </div>
+                        <?php endforeach; ?>
+                    </div>
+
+                    <!-- Lightbox -->
+                    <div id="lightbox" class="lightbox">
+                        <button class="lightbox-close" onclick="closeLightbox()">✕</button>
+                        <div class="lightbox-content">
+                            <img id="lightboxImage" class="lightbox-image" src="" alt="">
+                            <?php if (count($photos) > 1): ?>
+                                <button class="lightbox-nav lightbox-prev" onclick="changeLightboxImage(-1)">❮</button>
+                                <button class="lightbox-nav lightbox-next" onclick="changeLightboxImage(1)">❯</button>
+                            <?php endif; ?>
+                        </div>
+                    </div>
+                <?php else: ?>
+                    <div class="no-photos">
+                        <i class="far fa-image" style="font-size: 4rem; color: #ddd; margin-bottom: 20px; display: block;"></i>
+                        <p>No photos in this album yet.</p>
+                        <?php if ($album['user_id'] == $_SESSION['user_id']): ?>
+                            <a href="edit_album?id=<?php echo $album['album_id']; ?>" class="theme-btn">Add Photos</a>
+                        <?php endif; ?>
+                    </div>
+                <?php endif; ?>
+            </div>
+        </div>
+    </div>
+</section>
+
+<script>
+    let currentPhotoIndex = 0;
+    const photos = <?php echo json_encode(array_column($photos, 'file_path')); ?>;
+
+    function openLightbox(index) {
+        currentPhotoIndex = index;
+        document.getElementById('lightbox').classList.add('active');
+        document.getElementById('lightboxImage').src = photos[currentPhotoIndex];
+    }
+
+    function closeLightbox() {
+        document.getElementById('lightbox').classList.remove('active');
+    }
+
+    function changeLightboxImage(direction) {
+        currentPhotoIndex += direction;
+        if (currentPhotoIndex < 0) currentPhotoIndex = photos.length - 1;
+        if (currentPhotoIndex >= photos.length) currentPhotoIndex = 0;
+        document.getElementById('lightboxImage').src = photos[currentPhotoIndex];
+    }
+
+    // Close lightbox on escape key
+    document.addEventListener('keydown', (e) => {
+        if (e.key === 'Escape') closeLightbox();
+        if (e.key === 'ArrowLeft') changeLightboxImage(-1);
+        if (e.key === 'ArrowRight') changeLightboxImage(1);
+    });
+</script>
+
+<?php include_once(dirname(dirname(dirname(__DIR__))) . '/components/insta_footer.php'); ?>

src/pages/memberships/renew_membership.php

@@ -9,7 +9,7 @@ $eft_id = strtoupper("SUBS " . date("Y") . " " . getLastName($user_id));
 $status = 'AWAITING PAYMENT';
 $description = 'Membership Fees ' . date("Y") . " " . getLastName($user_id);
 
-$payment_amount = 2500; // Assuming a fixed membership fee, adjust as needed
+$payment_amount = 2600; // Assuming a fixed membership fee, adjust as needed
 $payment_date = date('Y-m-d');
 $membership_start_date = date('Y-01-01');
 $membership_end_date = date('Y-12-31');

src/processors/delete_album.php

@@ -0,0 +1,95 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+require_once($rootPath . '/src/config/session.php');
+require_once($rootPath . '/src/config/connection.php');
+
+if (!isset($_SESSION['user_id'])) {
+    http_response_code(403);
+    exit('Forbidden');
+}
+
+$album_id = intval($_GET['id'] ?? 0);
+
+if (!$album_id) {
+    http_response_code(400);
+    exit('Album ID is required');
+}
+
+// Verify ownership
+$albumCheck = $conn->prepare("SELECT user_id FROM photo_albums WHERE album_id = ?");
+$albumCheck->bind_param("i", $album_id);
+$albumCheck->execute();
+$albumResult = $albumCheck->get_result();
+
+if ($albumResult->num_rows === 0) {
+    $conn->close();
+    http_response_code(404);
+    header('Location: gallery');
+    exit;
+}
+
+$album = $albumResult->fetch_assoc();
+if ($album['user_id'] !== $_SESSION['user_id']) {
+    $conn->close();
+    http_response_code(403);
+    header('Location: gallery');
+    exit;
+}
+$albumCheck->close();
+
+try {
+    // Start transaction
+    $conn->begin_transaction();
+
+    // Get all photos for this album
+    $photoStmt = $conn->prepare("SELECT file_path FROM photos WHERE album_id = ?");
+    $photoStmt->bind_param("i", $album_id);
+    $photoStmt->execute();
+    $photoResult = $photoStmt->get_result();
+
+    // Delete photo files
+    while ($photo = $photoResult->fetch_assoc()) {
+        $photoPath = $_SERVER['DOCUMENT_ROOT'] . $photo['file_path'];
+        if (file_exists($photoPath)) {
+            unlink($photoPath);
+        }
+    }
+    $photoStmt->close();
+
+    // Delete photos from database (cascade should handle this)
+    $deletePhotosStmt = $conn->prepare("DELETE FROM photos WHERE album_id = ?");
+    $deletePhotosStmt->bind_param("i", $album_id);
+    $deletePhotosStmt->execute();
+    $deletePhotosStmt->close();
+
+    // Delete album from database
+    $deleteAlbumStmt = $conn->prepare("DELETE FROM photo_albums WHERE album_id = ?");
+    $deleteAlbumStmt->bind_param("i", $album_id);
+    $deleteAlbumStmt->execute();
+    $deleteAlbumStmt->close();
+
+    // Delete album directory
+    $albumDir = $rootPath . '/assets/uploads/gallery/' . $album_id;
+    if (is_dir($albumDir)) {
+        rmdir($albumDir);
+    }
+
+    // Commit transaction
+    $conn->commit();
+    $conn->close();
+
+    // Redirect to gallery
+    header('Location: gallery');
+    exit;
+
+} catch (Exception $e) {
+    // Rollback on error
+    $conn->rollback();
+    $conn->close();
+
+    http_response_code(400);
+    echo 'Error deleting album: ' . htmlspecialchars($e->getMessage());
+    exit;
+}
+?>

src/processors/delete_photo.php

@@ -0,0 +1,113 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+require_once($rootPath . '/src/config/session.php');
+require_once($rootPath . '/src/config/connection.php');
+require_once($rootPath . '/src/config/functions.php');
+
+if (!isset($_SESSION['user_id']) || $_SERVER['REQUEST_METHOD'] !== 'POST') {
+    http_response_code(403);
+    exit(json_encode(['error' => 'Forbidden']));
+}
+
+// Validate CSRF token
+if (!isset($_POST['csrf_token']) || !validateCSRFToken($_POST['csrf_token'])) {
+    http_response_code(400);
+    exit(json_encode(['error' => 'Invalid request']));
+}
+
+$photo_id = intval($_POST['photo_id'] ?? 0);
+$user_id = $_SESSION['user_id'];
+
+if (!$photo_id) {
+    http_response_code(400);
+    exit(json_encode(['error' => 'Photo ID is required']));
+}
+
+// Get photo and verify ownership through album
+$photoStmt = $conn->prepare("
+    SELECT p.photo_id, p.album_id, p.file_path, a.user_id 
+    FROM photos p 
+    JOIN photo_albums a ON p.album_id = a.album_id 
+    WHERE p.photo_id = ?
+");
+$photoStmt->bind_param("i", $photo_id);
+$photoStmt->execute();
+$photoResult = $photoStmt->get_result();
+
+if ($photoResult->num_rows === 0) {
+    $conn->close();
+    http_response_code(404);
+    exit(json_encode(['error' => 'Photo not found']));
+}
+
+$photo = $photoResult->fetch_assoc();
+if ($photo['user_id'] !== $user_id) {
+    $conn->close();
+    http_response_code(403);
+    exit(json_encode(['error' => 'You do not have permission to delete this photo']));
+}
+$photoStmt->close();
+
+try {
+    // Delete photo from filesystem
+    $photoPath = $_SERVER['DOCUMENT_ROOT'] . $photo['file_path'];
+    if (file_exists($photoPath)) {
+        unlink($photoPath);
+    }
+
+    // Delete from database
+    $deleteStmt = $conn->prepare("DELETE FROM photos WHERE photo_id = ?");
+    $deleteStmt->bind_param("i", $photo_id);
+    $deleteStmt->execute();
+    $deleteStmt->close();
+
+    // Update album's cover image if this was the cover
+    $albumCheck = $conn->prepare("SELECT cover_image FROM photo_albums WHERE album_id = ?");
+    $albumCheck->bind_param("i", $photo['album_id']);
+    $albumCheck->execute();
+    $albumResult = $albumCheck->get_result();
+    $album = $albumResult->fetch_assoc();
+    $albumCheck->close();
+
+    if ($album['cover_image'] === $photo['file_path']) {
+        // Set new cover to first remaining photo
+        $newCoverStmt = $conn->prepare("
+            SELECT file_path FROM photos 
+            WHERE album_id = ? 
+            ORDER BY display_order ASC 
+            LIMIT 1
+        ");
+        $newCoverStmt->bind_param("i", $photo['album_id']);
+        $newCoverStmt->execute();
+        $newCoverResult = $newCoverStmt->get_result();
+
+        if ($newCoverResult->num_rows > 0) {
+            $newCover = $newCoverResult->fetch_assoc();
+            $updateCoverStmt = $conn->prepare("UPDATE photo_albums SET cover_image = ? WHERE album_id = ?");
+            $updateCoverStmt->bind_param("si", $newCover['file_path'], $photo['album_id']);
+            $updateCoverStmt->execute();
+            $updateCoverStmt->close();
+        } else {
+            // No more photos, clear cover image
+            $clearCoverStmt = $conn->prepare("UPDATE photo_albums SET cover_image = NULL WHERE album_id = ?");
+            $clearCoverStmt->bind_param("i", $photo['album_id']);
+            $clearCoverStmt->execute();
+            $clearCoverStmt->close();
+        }
+        $newCoverStmt->close();
+    }
+
+    $conn->close();
+
+    header('Content-Type: application/json');
+    echo json_encode(['success' => true]);
+    exit;
+
+} catch (Exception $e) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => $e->getMessage()]);
+    exit;
+}
+?>

src/processors/get_album_photos.php

@@ -0,0 +1,57 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+require_once($rootPath . '/src/config/session.php');
+require_once($rootPath . '/src/config/connection.php');
+
+if (!isset($_SESSION['user_id'])) {
+    http_response_code(403);
+    exit(json_encode(['error' => 'Unauthorized']));
+}
+
+$album_id = intval($_GET['id'] ?? 0);
+
+if (!$album_id) {
+    http_response_code(400);
+    exit(json_encode(['error' => 'Album ID is required']));
+}
+
+// Verify album exists and user has access
+$albumCheck = $conn->prepare("SELECT user_id FROM photo_albums WHERE album_id = ?");
+$albumCheck->bind_param("i", $album_id);
+$albumCheck->execute();
+$albumResult = $albumCheck->get_result();
+
+if ($albumResult->num_rows === 0) {
+    $conn->close();
+    http_response_code(404);
+    exit(json_encode(['error' => 'Album not found']));
+}
+
+$album = $albumResult->fetch_assoc();
+// Allow viewing own albums or public albums (owner is a member)
+if ($album['user_id'] !== $_SESSION['user_id']) {
+    // For now, only allow owners to edit
+    $conn->close();
+    http_response_code(403);
+    exit(json_encode(['error' => 'Unauthorized']));
+}
+$albumCheck->close();
+
+// Get photos
+$photoStmt = $conn->prepare("SELECT photo_id, file_path, caption, display_order FROM photos WHERE album_id = ? ORDER BY display_order ASC");
+$photoStmt->bind_param("i", $album_id);
+$photoStmt->execute();
+$photoResult = $photoStmt->get_result();
+
+$photos = [];
+while ($photo = $photoResult->fetch_assoc()) {
+    $photos[] = $photo;
+}
+$photoStmt->close();
+
+$conn->close();
+
+header('Content-Type: application/json');
+echo json_encode($photos);
+?>

src/processors/process_application.php

@@ -18,6 +18,40 @@ if ($_SERVER['REQUEST_METHOD'] === 'POST') {
         die('Security token validation failed. Please try again.');
     }
 
+    // Check if user already has a membership application
+    $check_stmt = $conn->prepare("SELECT COUNT(*) as count FROM membership_application WHERE user_id = ?");
+    $check_stmt->bind_param("i", $user_id);
+    $check_stmt->execute();
+    $check_result = $check_stmt->get_result();
+    $check_row = $check_result->fetch_assoc();
+    $check_stmt->close();
+
+    if ($check_row['count'] > 0) {
+        http_response_code(400);
+        echo json_encode([
+            'status' => 'error',
+            'message' => 'You have already submitted a membership application. Please check your email for membership details.'
+        ]);
+        exit;
+    }
+
+    // Check if user already has a membership fee record
+    $fee_check_stmt = $conn->prepare("SELECT COUNT(*) as count FROM membership_fees WHERE user_id = ?");
+    $fee_check_stmt->bind_param("i", $user_id);
+    $fee_check_stmt->execute();
+    $fee_result = $fee_check_stmt->get_result();
+    $fee_row = $fee_result->fetch_assoc();
+    $fee_check_stmt->close();
+
+    if ($fee_row['count'] > 0) {
+        http_response_code(400);
+        echo json_encode([
+            'status' => 'error',
+            'message' => 'You already have a membership fee record. Please contact support if you need to update your application.'
+        ]);
+        exit;
+    }
+
     // Get all the form fields with validation
     $first_name = validateName($_POST['first_name'] ?? '');
     if ($first_name === false) {
@@ -188,11 +222,20 @@ if ($_SERVER['REQUEST_METHOD'] === 'POST') {
         // Rollback the transaction in case of error
         $conn->rollback();
 
-        // Error response
-        $response = [
-            'status' => 'error',
-            'message' => 'Error: ' . $e->getMessage()
-        ];
+        // Check for duplicate key error
+        $errorMessage = $e->getMessage();
+        if (strpos($errorMessage, 'Duplicate') !== false || strpos($errorMessage, '1062') !== false) {
+            $response = [
+                'status' => 'error',
+                'message' => 'You have already submitted a membership application. Please check your email for membership details.'
+            ];
+        } else {
+            // Error response
+            $response = [
+                'status' => 'error',
+                'message' => 'Error: ' . $errorMessage
+            ];
+        }
     }
 
     // Return the response in JSON format

src/processors/save_album.php

@@ -0,0 +1,183 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+require_once($rootPath . '/src/config/session.php');
+require_once($rootPath . '/src/config/connection.php');
+require_once($rootPath . '/src/config/functions.php');
+
+if (!isset($_SESSION['user_id']) || $_SERVER['REQUEST_METHOD'] !== 'POST') {
+    http_response_code(403);
+    exit('Forbidden');
+}
+
+// Validate CSRF token
+if (!isset($_POST['csrf_token']) || !validateCSRFToken($_POST['csrf_token'])) {
+    http_response_code(400);
+    exit('Invalid request');
+}
+
+$title = trim($_POST['title'] ?? '');
+$description = trim($_POST['description'] ?? '');
+$user_id = $_SESSION['user_id'];
+
+// Validate inputs
+if (empty($title) || !validateName($title)) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => 'Album title is required and must be valid']);
+    exit;
+}
+
+if (!empty($description) && strlen($description) > 500) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => 'Description must be 500 characters or less']);
+    exit;
+}
+
+// Create album directory
+$album_id = null;
+$cover_image = null;
+
+try {
+    // Start transaction
+    $conn->begin_transaction();
+
+    // Insert album record
+    $stmt = $conn->prepare("INSERT INTO photo_albums (user_id, title, description, created_at, updated_at) VALUES (?, ?, ?, NOW(), NOW())");
+    $stmt->bind_param("iss", $user_id, $title, $description);
+    $stmt->execute();
+    $album_id = $conn->insert_id;
+    $stmt->close();
+
+    // Create album directory
+    $albumDir = $rootPath . '/assets/uploads/gallery/' . $album_id;
+    if (!is_dir($albumDir)) {
+        if (!mkdir($albumDir, 0755, true)) {
+            throw new Exception('Failed to create album directory');
+        }
+    }
+
+    // Handle cover image upload
+    $coverImagePath = null;
+    if (isset($_FILES['cover_image']) && $_FILES['cover_image']['error'] !== UPLOAD_ERR_NO_FILE) {
+        $allowedMimes = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+        $maxSize = 5 * 1024 * 1024; // 5MB
+
+        $fileName = $_FILES['cover_image']['name'];
+        $fileTmpName = $_FILES['cover_image']['tmp_name'];
+        $fileSize = $_FILES['cover_image']['size'];
+        $fileMime = mime_content_type($fileTmpName);
+
+        // Validate file
+        if (!in_array($fileMime, $allowedMimes)) {
+            throw new Exception('Invalid cover image file type');
+        }
+
+        if ($fileSize > $maxSize) {
+            throw new Exception('Cover image file too large (max 5MB)');
+        }
+
+        // Generate unique filename
+        $ext = pathinfo($fileName, PATHINFO_EXTENSION);
+        $newFileName = 'cover_' . uniqid() . '.' . $ext;
+        $filePath = $albumDir . '/' . $newFileName;
+        $coverImagePath = '/assets/uploads/gallery/' . $album_id . '/' . $newFileName;
+
+        if (!move_uploaded_file($fileTmpName, $filePath)) {
+            throw new Exception('Failed to upload cover image');
+        }
+
+        // Update cover image in album record
+        $updateCover = $conn->prepare("UPDATE photo_albums SET cover_image = ? WHERE album_id = ?");
+        $updateCover->bind_param("si", $coverImagePath, $album_id);
+        $updateCover->execute();
+        $updateCover->close();
+    }
+
+    // Handle photo uploads
+    if (isset($_FILES['photos']) && $_FILES['photos']['error'][0] !== UPLOAD_ERR_NO_FILE) {
+        $allowedMimes = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+        $maxSize = 5 * 1024 * 1024; // 5MB
+
+        $displayOrder = 1;
+        $firstPhoto = true;
+
+        for ($i = 0; $i < count($_FILES['photos']['name']); $i++) {
+            if ($_FILES['photos']['error'][$i] !== UPLOAD_ERR_OK) {
+                continue;
+            }
+
+            $fileName = $_FILES['photos']['name'][$i];
+            $fileTmpName = $_FILES['photos']['tmp_name'][$i];
+            $fileSize = $_FILES['photos']['size'][$i];
+            $fileMime = mime_content_type($fileTmpName);
+
+            // Validate file
+            if (!in_array($fileMime, $allowedMimes)) {
+                throw new Exception('Invalid file type: ' . $fileName);
+            }
+
+            if ($fileSize > $maxSize) {
+                throw new Exception('File too large: ' . $fileName);
+            }
+
+            // Generate unique filename
+            $ext = pathinfo($fileName, PATHINFO_EXTENSION);
+            $newFileName = uniqid('photo_') . '.' . $ext;
+            $filePath = $albumDir . '/' . $newFileName;
+            $relativePath = '/assets/uploads/gallery/' . $album_id . '/' . $newFileName;
+
+            if (!move_uploaded_file($fileTmpName, $filePath)) {
+                throw new Exception('Failed to upload: ' . $fileName);
+            }
+
+            // Set first photo as cover if no cover image was uploaded
+            if ($firstPhoto && !$coverImagePath) {
+                $updateCover = $conn->prepare("UPDATE photo_albums SET cover_image = ? WHERE album_id = ?");
+                $updateCover->bind_param("si", $relativePath, $album_id);
+                $updateCover->execute();
+                $updateCover->close();
+                $firstPhoto = false;
+            }
+
+            // Insert photo record
+            $caption = $fileName; // Default caption is filename
+            $photoStmt = $conn->prepare("INSERT INTO photos (album_id, file_path, caption, display_order, created_at) VALUES (?, ?, ?, ?, NOW())");
+            $photoStmt->bind_param("issi", $album_id, $relativePath, $caption, $displayOrder);
+            $photoStmt->execute();
+            $photoStmt->close();
+
+            $displayOrder++;
+        }
+    }
+
+    // Commit transaction
+    $conn->commit();
+    $conn->close();
+
+    // Redirect to view album
+    header('Location: view_album?id=' . $album_id);
+    exit;
+
+} catch (Exception $e) {
+    // Rollback on error
+    $conn->rollback();
+    $conn->close();
+
+    // Clean up partially uploaded files
+    if ($album_id) {
+        $albumDir = $rootPath . '/assets/uploads/gallery/' . $album_id;
+        if (is_dir($albumDir)) {
+            array_map('unlink', glob($albumDir . '/*'));
+            rmdir($albumDir);
+        }
+        // Delete album record (will cascade delete photos)
+        $conn->query("DELETE FROM photo_albums WHERE album_id = " . intval($album_id));
+    }
+
+    http_response_code(400);
+    echo json_encode(['error' => $e->getMessage()]);
+    exit;
+}
+?>

src/processors/update_album.php

@@ -0,0 +1,205 @@
+<?php
+$rootPath = dirname(dirname(__DIR__));
+require_once($rootPath . '/src/config/env.php');
+require_once($rootPath . '/src/config/session.php');
+require_once($rootPath . '/src/config/connection.php');
+require_once($rootPath . '/src/config/functions.php');
+
+if (!isset($_SESSION['user_id']) || $_SERVER['REQUEST_METHOD'] !== 'POST') {
+    http_response_code(403);
+    exit('Forbidden');
+}
+
+// Validate CSRF token
+if (!isset($_POST['csrf_token']) || !validateCSRFToken($_POST['csrf_token'])) {
+    http_response_code(400);
+    exit('Invalid request');
+}
+
+$album_id = intval($_POST['album_id'] ?? 0);
+$title = trim($_POST['title'] ?? '');
+$description = trim($_POST['description'] ?? '');
+$user_id = $_SESSION['user_id'];
+
+if (!$album_id) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => 'Album ID is required']);
+    exit;
+}
+
+// Verify ownership
+$ownerCheck = $conn->prepare("SELECT user_id FROM photo_albums WHERE album_id = ?");
+$ownerCheck->bind_param("i", $album_id);
+$ownerCheck->execute();
+$ownerResult = $ownerCheck->get_result();
+
+if ($ownerResult->num_rows === 0) {
+    $conn->close();
+    http_response_code(404);
+    echo json_encode(['error' => 'Album not found']);
+    exit;
+}
+
+$owner = $ownerResult->fetch_assoc();
+if ($owner['user_id'] !== $user_id) {
+    $conn->close();
+    http_response_code(403);
+    echo json_encode(['error' => 'You do not have permission to edit this album']);
+    exit;
+}
+$ownerCheck->close();
+
+// Validate inputs
+if (empty($title) || !validateName($title)) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => 'Album title is required and must be valid']);
+    exit;
+}
+
+if (!empty($description) && strlen($description) > 500) {
+    $conn->close();
+    http_response_code(400);
+    echo json_encode(['error' => 'Description must be 500 characters or less']);
+    exit;
+}
+
+try {
+    // Start transaction
+    $conn->begin_transaction();
+
+    // Update album
+    $updateStmt = $conn->prepare("UPDATE photo_albums SET title = ?, description = ?, updated_at = NOW() WHERE album_id = ?");
+    $updateStmt->bind_param("ssi", $title, $description, $album_id);
+    $updateStmt->execute();
+    $updateStmt->close();
+
+    // Handle cover image upload if provided
+    if (isset($_FILES['cover_image']) && $_FILES['cover_image']['error'] !== UPLOAD_ERR_NO_FILE) {
+        $allowedMimes = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+        $maxSize = 5 * 1024 * 1024; // 5MB
+
+        $fileName = $_FILES['cover_image']['name'];
+        $fileTmpName = $_FILES['cover_image']['tmp_name'];
+        $fileSize = $_FILES['cover_image']['size'];
+        $fileMime = mime_content_type($fileTmpName);
+
+        // Validate file
+        if (!in_array($fileMime, $allowedMimes)) {
+            throw new Exception('Invalid cover image file type');
+        }
+
+        if ($fileSize > $maxSize) {
+            throw new Exception('Cover image file too large (max 5MB)');
+        }
+
+        $albumDir = $rootPath . '/assets/uploads/gallery/' . $album_id;
+
+        // Delete old cover if it exists
+        $oldCoverStmt = $conn->prepare("SELECT cover_image FROM photo_albums WHERE album_id = ?");
+        $oldCoverStmt->bind_param("i", $album_id);
+        $oldCoverStmt->execute();
+        $oldCoverResult = $oldCoverStmt->get_result();
+        if ($oldCoverResult->num_rows > 0) {
+            $oldCover = $oldCoverResult->fetch_assoc();
+            if ($oldCover['cover_image']) {
+                $oldCoverPath = $_SERVER['DOCUMENT_ROOT'] . $oldCover['cover_image'];
+                if (file_exists($oldCoverPath)) {
+                    unlink($oldCoverPath);
+                }
+            }
+        }
+        $oldCoverStmt->close();
+
+        // Generate unique filename
+        $ext = pathinfo($fileName, PATHINFO_EXTENSION);
+        $newFileName = 'cover_' . uniqid() . '.' . $ext;
+        $filePath = $albumDir . '/' . $newFileName;
+        $coverImagePath = '/assets/uploads/gallery/' . $album_id . '/' . $newFileName;
+
+        if (!move_uploaded_file($fileTmpName, $filePath)) {
+            throw new Exception('Failed to upload cover image');
+        }
+
+        // Update cover image in album record
+        $updateCover = $conn->prepare("UPDATE photo_albums SET cover_image = ? WHERE album_id = ?");
+        $updateCover->bind_param("si", $coverImagePath, $album_id);
+        $updateCover->execute();
+        $updateCover->close();
+    }
+
+    // Handle photo uploads if any
+    if (isset($_FILES['photos']) && $_FILES['photos']['error'][0] !== UPLOAD_ERR_NO_FILE) {
+        $allowedMimes = ['image/jpeg', 'image/png', 'image/gif', 'image/webp'];
+        $maxSize = 5 * 1024 * 1024; // 5MB
+
+        $albumDir = $rootPath . '/assets/uploads/gallery/' . $album_id;
+        
+        // Get current max display order
+        $orderStmt = $conn->prepare("SELECT MAX(display_order) as max_order FROM photos WHERE album_id = ?");
+        $orderStmt->bind_param("i", $album_id);
+        $orderStmt->execute();
+        $orderResult = $orderStmt->get_result();
+        $orderRow = $orderResult->fetch_assoc();
+        $displayOrder = ($orderRow['max_order'] ?? 0) + 1;
+        $orderStmt->close();
+
+        for ($i = 0; $i < count($_FILES['photos']['name']); $i++) {
+            if ($_FILES['photos']['error'][$i] !== UPLOAD_ERR_OK) {
+                continue;
+            }
+
+            $fileName = $_FILES['photos']['name'][$i];
+            $fileTmpName = $_FILES['photos']['tmp_name'][$i];
+            $fileSize = $_FILES['photos']['size'][$i];
+            $fileMime = mime_content_type($fileTmpName);
+
+            // Validate file
+            if (!in_array($fileMime, $allowedMimes)) {
+                throw new Exception('Invalid file type: ' . $fileName);
+            }
+
+            if ($fileSize > $maxSize) {
+                throw new Exception('File too large: ' . $fileName);
+            }
+
+            // Generate unique filename
+            $ext = pathinfo($fileName, PATHINFO_EXTENSION);
+            $newFileName = uniqid('photo_') . '.' . $ext;
+            $filePath = $albumDir . '/' . $newFileName;
+            $relativePath = '/assets/uploads/gallery/' . $album_id . '/' . $newFileName;
+
+            if (!move_uploaded_file($fileTmpName, $filePath)) {
+                throw new Exception('Failed to upload: ' . $fileName);
+            }
+
+            // Insert photo record
+            $caption = $fileName; // Default caption is filename
+            $photoStmt = $conn->prepare("INSERT INTO photos (album_id, file_path, caption, display_order, created_at) VALUES (?, ?, ?, ?, NOW())");
+            $photoStmt->bind_param("issi", $album_id, $relativePath, $caption, $displayOrder);
+            $photoStmt->execute();
+            $photoStmt->close();
+
+            $displayOrder++;
+        }
+    }
+
+    // Commit transaction
+    $conn->commit();
+    $conn->close();
+
+    // Redirect back to album view
+    header('Location: view_album?id=' . $album_id);
+    exit;
+
+} catch (Exception $e) {
+    // Rollback on error
+    $conn->rollback();
+    $conn->close();
+
+    http_response_code(400);
+    echo json_encode(['error' => $e->getMessage()]);
+    exit;
+}
+?>