Heray-Was-Here
Server : LiteSpeed
System : Linux uk-fast-web1372.main-hosting.eu 4.18.0-553.121.1.lve.el8.x86_64 #1 SMP Thu Apr 30 16:40:41 UTC 2026 x86_64
User : u390967363 ( 390967363)
PHP Version : 8.2.30
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
Directory :  /home/u390967363/domains/aibenproperties.com/public_html/app/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home/u390967363/domains/aibenproperties.com/public_html/app/debug_alloc_info.php
<?php
require_once 'includes/db.php';

$allocation_id = 45;

// Get allocation and property info
$stmt = $pdo->prepare('
    SELECT a.*, p.title as property_title, p.price as property_price 
    FROM allocations a 
    LEFT JOIN properties p ON a.property_id = p.id 
    WHERE a.id = ?
');
$stmt->execute([$allocation_id]);
$alloc = $stmt->fetch(PDO::FETCH_ASSOC);

print_r($alloc);

// Get deal info if any
if (!empty($alloc['deal_id'])) {
    $stmt = $pdo->prepare('SELECT * FROM deals WHERE id = ?');
    $stmt->execute([$alloc['deal_id']]);
    print_r($stmt->fetch(PDO::FETCH_ASSOC));
}

// Check how many payments exist for this allocation
$stmt = $pdo->prepare('SELECT id, amount, status FROM payments WHERE allocation_id = ?');
$stmt->execute([$allocation_id]);
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));

Hry