require_once __DIR__ . '/database_config.php';
require_once __DIR__ . '/Database.php';

/* ----------------------------- DB Bootstrap ----------------------------- */
if (!defined('DATABASE_HOST')) {
    die('FATAL: database_config.php missing DATABASE_* constants.');
}

$database = new Database(
    DATABASE_HOST,
    DATABASE_USERNAME,
    DATABASE_PASSWORD,
    DATABASE_NAME
);

if (!$database) {
    die('FATAL: $database not initialized.');
}

/* ----------------------------- Request Vars ----------------------------- */
$viewerId   = isset($_SESSION['id']) ? (int)$_SESSION['id'] : 0;
$viewerName = isset($_SESSION['name']) ? (string)$_SESSION['name'] : 'Guest';

$post_number = isset($_GET['id']) ? preg_replace('/\D+/', '', (string)$_GET['id']) : '';
$ownerId     = isset($_GET['OwnerId']) ? (int)$_GET['OwnerId'] : 0;

if ($post_number === '') {
    die('Missing post id');
}

$baseImg = "http://sfbay.metropolitanclassifieds.com/";

/* -------------------------- Fetch Listing Record ------------------------- */
$qry_urgent = "
    SELECT ad_posted.*,
           user_registration.pk_id AS reg_pk_id,
           user_registration.firstname,
           user_registration.lastname,
           user_registration.city AS reg_city,
           user_registration.state AS reg_state,
           user_registration.ProfilePicture,
           user_registration.dob_year,
           user_registration.dob_month,
           user_registration.dob_day
    FROM ad_posted
    LEFT JOIN user_registration ON user_registration.pk_id = ad_posted.user_id
    WHERE ad_posted.category = 'mentowoman'
      AND ad_posted.post_number = '" . $database->sanitize($post_number) . "'
    LIMIT 1
";
$qry_data = $database->fetch_one_data($qry_urgent);

if (!is_array($qry_data) || empty($qry_data)) {
    die('Listing not found.');
}

/* Use ownerId from URL if provided; otherwise derive from ad record */
if ($ownerId <= 0 && !empty($qry_data['user_id'])) {
    $ownerId = (int)$qry_data['user_id'];
}

/* ------------------------------ View Tracking ----------------------------- */
if ($viewerId > 0 && $ownerId > 0) {
    $database->insert_to_database('ViewProfileHistory', array(
        'ProfileViewOf' => $ownerId,
        'ProfileViewBy' => $viewerId,
        'ActionType'    => 'View',
        'ViewDateTime'  => date('Y-m-d H:i:s')
    ));
}

/* ----------------------------- Sidebar Users ----------------------------- */
$users = array();
if ($viewerId > 0) {
    $users = $database->get_array_rs(
        "SELECT * FROM user_registration
         WHERE pk_id != '" . $database->sanitize($viewerId) . "'
         ORDER BY pk_id DESC
         LIMIT 15"
    );
}

/* ----------------------------- Images / Gallery --------------------------- */
$profileImg = "default.png";
if (!empty($qry_data['image_filename'])) {
    $profileImg = $baseImg . ltrim($qry_data['image_filename'], '/');
}

$photos = array();
for ($i = 2; $i <= 26; $i++) {
    $key = 'image_filename' . $i;
    if (!empty($qry_data[$key])) {
        $photos[] = $baseImg . ltrim($qry_data[$key], '/');
    }
}

/* ------------------------------ Activity Info ---------------------------- */
$last_activity = array();
if ($ownerId > 0) {
    $last_activity = $database->fetch_one_data(
        "SELECT UNIX_TIMESTAMP(ViewDateTime) AS last_active_ts
         FROM ViewProfileHistory
         WHERE ProfileViewBy = '" . $database->sanitize($ownerId) . "'
         ORDER BY ViewDateTime DESC
         LIMIT 1"
    );
    if (!is_array($last_activity)) $last_activity = array();
}

/* ------------------------------- Helpers -------------------------------- */
function timespan($seconds, $time = '')
{
    if (!is_numeric($time)) $time = time();
    $seconds = ($time <= $seconds) ? 1 : ($time - $seconds);

    $years = floor($seconds / (365.25 * 24 * 60 * 60));
    if ($years > 0) return ($years == 1) ? 'a year ago' : $years . ' years ago';

    $months = floor($seconds / ((365.25 / 12) * 24 * 60 * 60));
    if ($months > 0) return ($months == 1) ? 'a month ago' : $months . ' months ago';

    $weeks = floor($seconds / (7 * 24 * 60 * 60));
    if ($weeks > 0) return ($weeks == 1) ? 'a week ago' : $weeks . ' weeks ago';

    $days = floor($seconds / (24 * 60 * 60));
    if ($days > 0) return ($days == 1) ? 'Yesterday' : $days . ' days ago';

    $hours = floor($seconds / (60 * 60));
    if ($hours > 0) return ($hours == 1) ? 'an hour ago' : $hours . ' hours ago';

    $minutes = floor($seconds / 60);
    if ($minutes > 0) return ($minutes == 1) ? 'a minute ago' : $minutes . ' minutes ago';

    return 'Today';
}

function GetAge($yy = "1970", $mm = "-01", $dd = "-01")
{
    $curMonth = (int)date("m");
    $curDay   = (int)date("j");
    $curYear  = (int)date("Y");

    $yy = (int)$yy;
    $mm = (int)$mm;
    $dd = (int)$dd;

    $age = $curYear - $yy;
    if ($curMonth < $mm || ($curMonth == $mm && $curDay < $dd)) $age--;
    return $age;
}

$fullName = trim(($qry_data['firstname'] ?? '') . ' ' . ($qry_data['lastname'] ?? ''));
$age = (!empty($qry_data['dob_year']) ? GetAge($qry_data['dob_year'], $qry_data['dob_month'], $qry_data['dob_day']) : '');
$city = $qry_data['reg_city'] ?? ($qry_data['city'] ?? '');
$state = $qry_data['reg_state'] ?? ($qry_data['state'] ?? '');
$lastSeen = (!empty($last_activity['last_active_ts']) ? timespan((int)$last_activity['last_active_ts']) : 'Unknown');

$title = $qry_data['title'] ?? 'Profile';
$desc  = $qry_data['description'] ?? '';
$lookingFor = $qry_data['description_lookingfor'] ?? '';

/* For message link, use the profile owner pk_id if present */
$chatUserId = !empty($qry_data['reg_pk_id']) ? (int)$qry_data['reg_pk_id'] : $ownerId;
?>
<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1" />
  <title><br />
<b>Warning</b>:  Undefined variable $title in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>213</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>213</b><br />
 | Metropolitan Classifieds</title>

  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.0.47/jquery.fancybox.min.css" />
  <link rel="stylesheet" href="font-awesome-4.6.3/css/font-awesome.min.css">

  <style>
    :root{
      --brand:#cc0000;
      --brand2:#ff4d4d;
      --bg:#ffffff;
      --panel:#ffffff;
      --text:#111827;
      --muted:#6b7280;
      --line:#e5e7eb;
      --shadow: 0 10px 30px rgba(17,24,39,.08);
      --radius: 16px;
    }
    *{ box-sizing:border-box; }
    body{
      margin:0;
      font-family: Arial, Helvetica, sans-serif;
      background: var(--bg);
      color: var(--text);
    }
    a{ color: var(--brand); text-decoration:none; }
    a:hover{ text-decoration:underline; }
    .wrap{
      max-width: 1200px;
      margin: 0 auto;
      padding: 16px;
    }
    .topbar{
      position: sticky;
      top:0;
      z-index: 50;
      background: rgba(255,255,255,.9);
      backdrop-filter: blur(10px);
      border-bottom: 1px solid var(--line);
    }
    .topbar-inner{
      max-width: 1200px;
      margin: 0 auto;
      padding: 12px 16px;
      display:flex;
      align-items:center;
      justify-content:space-between;
      gap: 12px;
    }
    .brand{
      display:flex;
      align-items:center;
      gap:10px;
      color: inherit;
      text-decoration:none;
      font-weight: 900;
      letter-spacing: -.4px;
    }
    .logo{
      width: 42px;
      height: 42px;
      border-radius: 12px;
      background: linear-gradient(135deg, var(--brand), var(--brand2));
      color:#fff;
      display:grid;
      place-items:center;
      font-weight: 900;
    }
    .meta{
      display:flex;
      gap: 10px;
      align-items:center;
      flex-wrap: wrap;
      justify-content:flex-end;
    }
    .pill{
      border: 1px solid var(--line);
      background: #fff;
      color: var(--muted);
      padding: 8px 10px;
      border-radius: 999px;
      font-size: 12px;
    }
    .btn{
      border:0;
      background: linear-gradient(135deg, var(--brand), var(--brand2));
      color:#fff;
      padding: 10px 12px;
      border-radius: 999px;
      font-weight: 800;
      cursor:pointer;
    }
    .btn.ghost{
      background:#fff;
      color: var(--text);
      border: 1px solid var(--line);
    }
    .layout{
      display:grid;
      grid-template-columns: 260px 1fr 220px;
      gap: 14px;
      align-items:start;
      margin-top: 14px;
    }
    @media (max-width: 1060px){
      .layout{ grid-template-columns: 1fr; }
    }
    .card{
      background: var(--panel);
      border: 1px solid var(--line);
      border-radius: var(--radius);
      box-shadow: var(--shadow);
    }
    .card .hd{
      padding: 12px 12px 0;
      font-weight: 900;
      color: var(--brand);
    }
    .card .bd{ padding: 12px; }
    .navlist a{ display:block; padding: 8px 0; border-bottom:1px solid var(--line); color: var(--text); }
    .navlist a:last-child{ border-bottom:0; }
    .profile{
      padding: 14px;
    }
    .profile-top{
      display:grid;
      grid-template-columns: 260px 1fr;
      gap: 14px;
      align-items:start;
    }
    @media (max-width: 720px){
      .profile-top{ grid-template-columns: 1fr; }
    }
    .photo{
      border: 1px solid var(--line);
      border-radius: 14px;
      overflow:hidden;
      background:#fafafa;
    }
    .photo img{
      width: 100%;
      height: 240px;
      object-fit: cover;
      display:block;
    }
    .title{
      margin:0;
      font-size: 22px;
      letter-spacing: -.3px;
    }
    .subline{
      margin-top: 6px;
      color: var(--muted);
      font-size: 13px;
    }
    .actions{
      display:flex;
      gap:10px;
      flex-wrap: wrap;
      margin-top: 12px;
    }
    .section{
      margin-top: 14px;
      padding: 14px;
      border-top: 1px solid var(--line);
    }
    .section h3{
      margin:0 0 10px;
      font-size: 16px;
      color: var(--brand);
    }
    .kv{
      display:grid;
      grid-template-columns: 160px 1fr;
      gap: 8px 12px;
      font-size: 14px;
    }
    .kv div:nth-child(odd){ color: var(--muted); }
    .text{
      color:#1f2937;
      line-height: 1.45;
      font-size: 14px;
      white-space: pre-wrap;
    }

    /* Gallery */
    .gallery{
      display:grid;
      grid-template-columns: repeat(3, minmax(0, 1fr));
      gap: 12px;
    }
    @media (max-width: 900px){ .gallery{ grid-template-columns: repeat(2, minmax(0, 1fr)); } }
    @media (max-width: 520px){ .gallery{ grid-template-columns: 1fr; } }
    .gitem{
      border: 1px solid var(--line);
      border-radius: 14px;
      overflow:hidden;
      background:#fff;
    }
    .gitem img{
      width:100%;
      height: 190px;
      object-fit: cover;
      display:block;
      background:#f3f4f6;
    }

    /* Chat list */
    .chatrow{
      display:flex;
      gap:10px;
      padding: 10px 12px;
      border-bottom: 1px solid var(--line);
      align-items:center;
      color: var(--text);
      text-decoration:none;
    }
    .chatrow:last-child{ border-bottom:0; }
    .chatrow img{
      width: 38px;
      height: 38px;
      border-radius: 10px;
      border: 1px solid var(--line);
      object-fit: cover;
      background:#fafafa;
    }
    .chatrow .nm{ font-weight: 800; font-size: 13px; }
    .chatrow .ct{ color: var(--muted); font-size: 12px; margin-top:2px; }
    .foot{
      color: var(--muted);
      font-size: 12px;
      padding: 14px 0 4px;
      text-align:center;
    }
  </style>

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/fancybox/3.0.47/jquery.fancybox.min.js"></script>
</head>

<body>

<header class="topbar">
  <div class="topbar-inner">
    <a class="brand" href="/">
      <div class="logo">M</div>
      <div>Metropolitan Classifieds</div>
    </a>
    <div class="meta">
      <span class="pill"><br />
<b>Warning</b>:  Undefined variable $viewerName in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>461</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>461</b><br />
</span>
      <br />
<b>Warning</b>:  Undefined variable $viewerId in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>462</b><br />
        <a class="btn ghost" href="login.php">Login</a>
            <a class="btn" href="/show_mentowoman.php">Back to Results</a>
    </div>
  </div>
</header>

<div class="wrap">
  <div class="layout">

    <!-- Left: quick links -->
    <aside class="card">
      <div class="hd">Menu</div>
      <div class="bd navlist">
        <a href="/show_mentowoman.php">Man Seeking Woman</a>
        <a href="/show_mantoman.php">Man Seeking Man</a>
        <a href="/show_womantoman.php">Woman Seeking Man</a>
        <a href="/show_womantowoman.php">Woman Seeking Woman</a>
        <a href="/show_casual.php">Casual</a>
        <a href="/SearchProfiles.php">Search Profiles</a>
      </div>
    </aside>

    <!-- Center: profile -->
    <main class="card">
      <div class="profile">

        <div class="profile-top">
          <div class="photo">
            <a data-fancybox="profile" href="<br />
<b>Warning</b>:  Undefined variable $profileImg in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>494</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>494</b><br />
">
              <img src="<br />
<b>Warning</b>:  Undefined variable $profileImg in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>495</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>495</b><br />
" alt="Profile photo">
            </a>
          </div>

          <div>
            <h1 class="title"><br />
<b>Warning</b>:  Undefined variable $fullName in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>500</b><br />
<br />
<b>Warning</b>:  Undefined variable $fullName in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>500</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>500</b><br />
</h1>
            <div class="subline">
              <br />
<b>Warning</b>:  Undefined variable $age in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>502</b><br />
                <br />
<b>Warning</b>:  Undefined variable $age in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>503</b><br />
0 years old
                            <br />
<b>Warning</b>:  Undefined variable $city in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>505</b><br />
<br />
<b>Warning</b>:  Undefined variable $state in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>505</b><br />
              <br />
<b>Warning</b>:  Undefined variable $lastSeen in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>509</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>509</b><br />
 • Last activity:             </div>

            <div class="actions">
              <br />
<b>Warning</b>:  Undefined variable $chatUserId in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>513</b><br />
              <a class="btn ghost" href="/show_mentowoman.php"><i class="fa fa-arrow-left"></i> Back</a>
            </div>
          </div>
        </div>

        <div class="section">
          <h3>Listing Details</h3>
          <div class="kv">
            <div>Category</div><div></div>
            <div>Title</div><div></div>
            <div>Location</div><div></div>
            <div>Posted</div><div></div>
          </div>
        </div>

        <div class="section">
          <h3>About</h3>
          <div class="text"><br />
<b>Warning</b>:  Undefined variable $desc in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>535</b><br />
<br />
<b>Deprecated</b>:  htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>535</b><br />
</div>
        </div>

        <br />
<b>Warning</b>:  Undefined variable $lookingFor in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>538</b><br />
<br />
<b>Deprecated</b>:  trim(): Passing null to parameter #1 ($string) of type string is deprecated in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>538</b><br />

        
        
      </div>

      <div class="foot">© 2026 Metropolitan Classifieds</div>
    </main>

    <!-- Right: chat sidebar (only when logged in) -->
    <aside class="card">
      <div class="hd">Nearby Users</div>
      <div class="bd" style="padding:0;">
        <br />
<b>Warning</b>:  Undefined variable $viewerId in <b>/home/ck36l2nqi40p/public_html/mentowoman_ads.php</b> on line <b>590</b><br />
          <div style="padding:12px;color:var(--muted);font-size:13px;">
            Login to see the chat list.
          </div>
              </div>
    </aside>

  </div>
</div>

</body>
<script>'undefined'=== typeof _trfq || (window._trfq = []);'undefined'=== typeof _trfd && (window._trfd=[]),_trfd.push({'tccl.baseHost':'secureserver.net'},{'ap':'cpbh-mt'},{'server':'p3plmcpnl499705'},{'dcenter':'p3'},{'cp_id':'7414653'},{'cp_cache':''},{'cp_cl':'8'}) // Monitoring performance to make your website faster. If you want to opt-out, please contact web hosting support.</script><script src='https://img1.wsimg.com/traffic-assets/js/tccl.min.js'></script></html>