Visiteurs uniques : ☆67046

Technical Documentation - Changelogs

18/04/2025 > Booking Form - Version Public

Main features

  • Kayak booking (single and double)
  • Automatic real-time price calculation
  • User management (logged in/not logged in)
  • Promo code application (5% discount)
  • Return bus priority option (+2.5€/person)
  • Dynamic price details display
  • Visual confirmation after booking

Technical characteristics

Frontend

  • HTML5/CSS3 responsive
  • JavaScript for dynamic calculations
  • Real-time field validation

Backend

  • PHP for data processing
  • MySQL for booking storage
  • Unique promo code management

Security

  • XSS protection htmlspecialchars
  • Server-side validation
  • Secure transaction handling

9/04/2025 > Guest Book - Version Public

Main features

  • Displays only validated testimonials (status = 1)
  • Presents testimonials in a responsive grid
  • Includes photos associated with testimonials
  • Displays author information with their avatar
  • Elegantly formats testimonials with visual effects
  • Contains no editing buttons or functionality
  • Accessible without login

Technical characteristics

Design

  • Responsive and modern
  • Subtle animations
  • Decorative icons

Content

  • Member avatars
  • Visible publication date
  • Formatted quotes

Security

  • XSS protection htmlspecialchars
  • No modification interaction
  • Clean error handling

9/04/2025 > Guest Book - moderation Admin

Status management

  • Pending posts (status=0) - Visible only to admins
  • Validated posts (status=1) - Visible to all users
  • Normal users see only their own unvalidated posts

Permissions and security SECURITY

  • Strict rights verification before any modification/deletion
  • Automatic self-validation for posts created by admins
  • Protection against unauthorized deletion
  • Ownership verification before deletion
  • Protection against ID manipulation attacks
  • Media file cleanup after deletion

Administrator interface

Visual elements

  • Moderation panel visible only to admins
  • "Pending" badge on unvalidated posts
  • Colored border for pending posts

Features

  • Pending posts counter
  • Quick validation buttons
  • Status filters (All/Validated/Pending)

9/04/2025 > Moderation workflow

  1. User submits a post (status=0 by default)
  2. Admin receives notification (counter + badge)
  3. Admin can :
    • Validate the post (status=1)
    • Leave it pending
    • Delete it with justification
  4. User is notified if their post is validated or rejected

Moderation functions

  • validate action for administrators
  • unvalidate action to disapprove a post
  • Strict admin rights verification

Filtering system Admin

  • ?action=show&show=all : All posts (admin) or only validated + own posts (user)
  • ?action=show&show=pending : Pending posts (admin only)
  • ?action=show&show=validated : Validated posts only

Enhanced security SECURITY

  • Validation of show parameters
  • Permission verification for each filter
  • Use of prepared queries
  • Centralized error handling

Technical optimizations TECH

  • Dynamic SQL query with construction based on filter
  • Differentiated permission management (admins vs non-admins)
  • Modular structure for adding new filters
  • Centralized filtering logic

18/04/2025 > Booking Management Admin

Promotion management

  • Promo codes - Generation of unique codes (PROMO5)
  • Usage tracking - Tracking of used codes
  • Thresholds at €100/€200 for additional bonuses

Database STRUCTURE

  • Table promotion_codes with expiration date management
  • Relationship with reservation_kayak table via foreign key
  • Storage of additional options (bus priority)
  • Priority Bus checkbox with binary management (0/1) in database

27/03/2025 > News Management

News Function Admin

  • Addition reserved for admins
  • Mandatory/optional fields
  • SQL protection (prepared queries)

Display and other Public

  • Addition of generic in main menu
  • Sort by descending date
  • alt and title attributes for accessibility
  • Optional "Read more" link

User management Admin

  • Complete user account management
  • User search and filtering
  • Status visualization (admin/banned)
  • User reputation system

Available actions Admin

  • Complete editing : Modify all user information
  • Ban/Unban : Account suspension management
  • Toggle Admin : Grant/revoke admin rights
  • Reset Password : Password reset
  • Deletion : Permanent account deletion

Security SECURITY

  • Permission verification before any action
  • Protection against SQL injections
  • Output escaping (htmlspecialchars)
  • Confirmations before critical actions

27/03/2025 > Message management Admin

  • Complete user message management
  • Advanced sorting and filtering system
  • Status visualization (answered/pending)
  • Cancellation request tracking
  • Beginning of admin response panel

Available actions Admin

  • Message response : Sending official responses
  • Mark as processed : Status change
  • Filter by type : Normal messages vs cancellations
  • Pagination : Navigation in results
  • History : Consultation of previous responses

Security SECURITY

  • CSRF protection for all actions
  • Strict permission validation
  • User input filtering
  • Administrative action logging
  • Output escaping (XSS)

Interface UI/UX

  • Tabs for intuitive navigation
  • Dedicated modal for responses
  • Immediate visual feedback
  • Highlighting of urgent messages
  • Responsive design (mobile/desktop)