![]() Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory : /home/gositeme/domains/soundstudiopro.com/private_html/ |
<?php
session_start();
require_once 'config/database.php';
$event_id = $_GET['id'] ?? null;
// Check if this is an AJAX request
$isAjaxRequest = isset($_GET['page']) || (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && $_SERVER['HTTP_X_REQUESTED_WITH'] === 'XMLHttpRequest');
if (!$event_id) {
if ($isAjaxRequest) {
// For AJAX requests, return error content instead of redirecting
echo json_encode(['success' => false, 'error' => 'No event ID provided']);
exit;
} else {
header('Location: /events.php');
exit;
}
}
$pdo = getDBConnection();
$user_id = $_SESSION['user_id'] ?? null;
// Get event details
$stmt = $pdo->prepare("
SELECT
e.*,
u.name as creator_name,
u.profile_image as creator_image,
COUNT(DISTINCT ea.user_id) as attendee_count,
COUNT(DISTINCT el.user_id) as like_count,
COUNT(DISTINCT ec.id) as comment_count,
CASE WHEN ea2.user_id IS NOT NULL THEN ea2.status ELSE NULL END as user_rsvp_status
FROM events e
JOIN users u ON e.creator_id = u.id
LEFT JOIN event_attendees ea ON e.id = ea.event_id AND ea.status = 'attending'
LEFT JOIN event_likes el ON e.id = el.event_id
LEFT JOIN event_comments ec ON e.id = ec.event_id
LEFT JOIN event_attendees ea2 ON e.id = ea2.event_id AND ea2.user_id = ?
WHERE e.id = ? AND e.status = 'published'
GROUP BY e.id
");
$stmt->execute([$user_id, $event_id]);
$event = $stmt->fetch();
if (!$event) {
if ($isAjaxRequest) {
// For AJAX requests, return error content instead of redirecting
echo json_encode(['success' => false, 'error' => 'Event not found']);
exit;
} else {
header('Location: /events.php');
exit;
}
}
// Get attendees
$stmt = $pdo->prepare("
SELECT
ea.*,
u.name,
u.profile_image
FROM event_attendees ea
JOIN users u ON ea.user_id = u.id
WHERE ea.event_id = ?
ORDER BY ea.rsvp_date DESC
");
$stmt->execute([$event_id]);
$attendees = $stmt->fetchAll();
// Get comments
$stmt = $pdo->prepare("
SELECT
ec.*,
u.name,
u.profile_image
FROM event_comments ec
JOIN users u ON ec.user_id = u.id
WHERE ec.event_id = ?
ORDER BY ec.created_at DESC
");
$stmt->execute([$event_id]);
$comments = $stmt->fetchAll();
// Set page variables for header
$current_page = 'events';
$page_title = $event['title'] . ' - SoundStudioPro Events';
$page_description = $event['description'];
include 'includes/header.php';
// Helper functions
function formatEventDate($start_date, $end_date) {
$start = new DateTime($start_date);
$end = new DateTime($end_date);
if ($start->format('Y-m-d') === $end->format('Y-m-d')) {
return $start->format('l, F j, Y') . ' at ' . $start->format('g:i A');
} else {
return $start->format('l, F j, Y g:i A') . ' - ' . $end->format('l, F j, Y g:i A');
}
}
function getEventTypeIcon($event_type) {
$icons = [
'live_music' => 'fas fa-music',
'workshop' => 'fas fa-graduation-cap',
'networking' => 'fas fa-users',
'release_party' => 'fas fa-champagne-glasses',
'battle' => 'fas fa-trophy',
'open_mic' => 'fas fa-microphone',
'studio_session' => 'fas fa-record-vinyl',
'other' => 'fas fa-calendar'
];
return $icons[$event_type] ?? 'fas fa-calendar';
}
function getEventTypeColor($event_type) {
$colors = [
'live_music' => '#667eea',
'workshop' => '#48bb78',
'networking' => '#ed8936',
'release_party' => '#9f7aea',
'battle' => '#f56565',
'open_mic' => '#38b2ac',
'studio_session' => '#ed64a6',
'other' => '#a0aec0'
];
return $colors[$event_type] ?? '#a0aec0';
}
?>
<div class="event-details-container">
<!-- Event Header -->
<section class="event-header">
<div class="event-header-content">
<div class="event-breadcrumb">
<a href="/events.php"><i class="fas fa-arrow-left"></i> Back to Events</a>
</div>
<div class="event-title-section">
<div class="event-type-badge" style="background: <?= getEventTypeColor($event['event_type']) ?>">
<i class="<?= getEventTypeIcon($event['event_type']) ?>"></i>
<?= ucwords(str_replace('_', ' ', $event['event_type'])) ?>
</div>
<h1 class="event-title"><?= htmlspecialchars($event['title']) ?></h1>
<div class="event-creator">
<div class="creator-avatar">
<?= strtoupper(substr($event['creator_name'], 0, 1)) ?>
</div>
<div class="creator-info">
<span>Created by</span>
<a href="/artist_profile.php?id=<?= $event['creator_id'] ?>"><?= htmlspecialchars($event['creator_name']) ?></a>
</div>
</div>
</div>
</div>
</section>
<!-- Event Content -->
<section class="event-content">
<div class="event-main">
<div class="event-description">
<h2>About This Event</h2>
<p><?= nl2br(htmlspecialchars($event['description'])) ?></p>
</div>
<div class="event-details">
<h2>Event Details</h2>
<div class="details-grid">
<div class="detail-item">
<i class="fas fa-calendar"></i>
<div>
<strong>Date & Time</strong>
<span><?= formatEventDate($event['start_date'], $event['end_date']) ?></span>
</div>
</div>
<?php if ($event['location']): ?>
<div class="detail-item">
<i class="fas fa-map-marker-alt"></i>
<div>
<strong>Location</strong>
<span><?= htmlspecialchars($event['location']) ?></span>
</div>
</div>
<?php endif; ?>
<?php if ($event['venue_name']): ?>
<div class="detail-item">
<i class="fas fa-building"></i>
<div>
<strong>Venue</strong>
<span><?= htmlspecialchars($event['venue_name']) ?></span>
</div>
</div>
<?php endif; ?>
<?php if ($event['address']): ?>
<div class="detail-item">
<i class="fas fa-map"></i>
<div>
<strong>Address</strong>
<span><?= nl2br(htmlspecialchars($event['address'])) ?></span>
</div>
</div>
<?php endif; ?>
<div class="detail-item">
<i class="fas fa-ticket"></i>
<div>
<strong>Price</strong>
<span><?= $event['is_free'] ? 'Free' : '$' . number_format($event['ticket_price'], 2) ?></span>
</div>
</div>
<?php if ($event['max_attendees']): ?>
<div class="detail-item">
<i class="fas fa-users"></i>
<div>
<strong>Capacity</strong>
<span><?= $event['current_attendees'] ?> / <?= $event['max_attendees'] ?> spots filled</span>
</div>
</div>
<?php endif; ?>
</div>
</div>
<!-- Event Actions -->
<div class="event-actions">
<h2>Join This Event</h2>
<?php if ($user_id): ?>
<div class="action-buttons">
<button class="btn btn-primary" onclick="rsvpEvent(<?= $event['id'] ?>, 'attending')"
<?= $event['user_rsvp_status'] === 'attending' ? 'disabled' : '' ?>>
<i class="fas fa-check"></i>
<?= $event['user_rsvp_status'] === 'attending' ? 'Attending' : 'Attend' ?>
</button>
<button class="btn btn-secondary" onclick="rsvpEvent(<?= $event['id'] ?>, 'maybe')"
<?= $event['user_rsvp_status'] === 'maybe' ? 'disabled' : '' ?>>
<i class="fas fa-question"></i>
Maybe
</button>
<button class="btn btn-outline" onclick="likeEvent(<?= $event['id'] ?>)">
<i class="fas fa-heart"></i>
Like
</button>
<button class="btn btn-outline" onclick="shareEvent(<?= $event['id'] ?>)">
<i class="fas fa-share"></i>
Share
</button>
</div>
<?php else: ?>
<div class="login-prompt">
<p>Login to join this event and connect with other attendees!</p>
<a href="/auth/login_new.php" class="btn btn-primary">
<i class="fas fa-sign-in-alt"></i>
Login to Join
</a>
</div>
<?php endif; ?>
</div>
</div>
<div class="event-sidebar">
<!-- Attendees -->
<div class="sidebar-section">
<h3>Attendees (<?= $event['attendee_count'] ?>)</h3>
<div class="attendees-list">
<?php if (empty($attendees)): ?>
<p class="no-attendees">No attendees yet. Be the first to join!</p>
<?php else: ?>
<?php foreach ($attendees as $attendee): ?>
<div class="attendee-item">
<div class="attendee-avatar">
<?= strtoupper(substr($attendee['name'], 0, 1)) ?>
</div>
<div class="attendee-info">
<a href="/artist_profile.php?id=<?= $attendee['user_id'] ?>"><?= htmlspecialchars($attendee['name']) ?></a>
<span class="rsvp-status"><?= ucfirst($attendee['status']) ?></span>
</div>
</div>
<?php endforeach; ?>
<?php endif; ?>
</div>
</div>
<!-- Event Stats -->
<div class="sidebar-section">
<h3>Event Stats</h3>
<div class="stats-grid">
<div class="stat-item">
<i class="fas fa-users"></i>
<span><?= $event['attendee_count'] ?> attending</span>
</div>
<div class="stat-item">
<i class="fas fa-heart"></i>
<span><?= $event['like_count'] ?> likes</span>
</div>
<div class="stat-item">
<i class="fas fa-comment"></i>
<span><?= $event['comment_count'] ?> comments</span>
</div>
</div>
</div>
</div>
</section>
<!-- Comments Section -->
<section class="comments-section">
<h2>Comments (<?= count($comments) ?>)</h2>
<?php if ($user_id): ?>
<div class="comment-form">
<textarea id="commentText" placeholder="Share your thoughts about this event..."></textarea>
<button onclick="addComment(<?= $event['id'] ?>)" class="btn btn-primary">
<i class="fas fa-paper-plane"></i>
Post Comment
</button>
</div>
<?php endif; ?>
<div class="comments-list">
<?php if (empty($comments)): ?>
<p class="no-comments">No comments yet. Be the first to share your thoughts!</p>
<?php else: ?>
<?php foreach ($comments as $comment): ?>
<div class="comment-item">
<div class="comment-avatar">
<?= strtoupper(substr($comment['name'], 0, 1)) ?>
</div>
<div class="comment-content">
<div class="comment-header">
<a href="/artist_profile.php?id=<?= $comment['user_id'] ?>"><?= htmlspecialchars($comment['name']) ?></a>
<span class="comment-date"><?= date('M j, Y g:i A', strtotime($comment['created_at'])) ?></span>
</div>
<p><?= nl2br(htmlspecialchars($comment['comment'])) ?></p>
</div>
</div>
<?php endforeach; ?>
<?php endif; ?>
</div>
</section>
</div>
<style>
/* Event Details Container */
.event-details-container {
min-height: 100vh;
background: var(--bg-primary);
color: var(--text-primary);
width: 100%;
max-width: 100vw;
overflow-x: hidden;
}
/* Event Header */
.event-header {
padding: 4rem 0 2rem;
background: linear-gradient(135deg, rgba(102, 126, 234, 0.1) 0%, rgba(118, 75, 162, 0.1) 100%);
}
.event-header-content {
max-width: 1400px;
margin: 0 auto;
padding: 0 2rem;
width: 100%;
box-sizing: border-box;
}
.event-breadcrumb {
margin-bottom: 2rem;
}
.event-breadcrumb a {
color: #667eea;
text-decoration: none;
display: inline-flex;
align-items: center;
gap: 0.5rem;
font-weight: 600;
}
.event-breadcrumb a:hover {
text-decoration: underline;
}
.event-title-section {
text-align: center;
}
.event-type-badge {
display: inline-flex;
align-items: center;
gap: 0.5rem;
color: white;
padding: 0.5rem 1rem;
border-radius: 20px;
font-size: 0.9rem;
font-weight: 600;
margin-bottom: 1rem;
}
.event-title {
font-size: 3rem;
font-weight: 800;
margin-bottom: 2rem;
background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
background-clip: text;
-webkit-background-clip: text;
-webkit-text-fill-color: transparent;
}
.event-creator {
display: flex;
align-items: center;
justify-content: center;
gap: 1rem;
}
.creator-avatar {
width: 50px;
height: 50px;
background: linear-gradient(135deg, #667eea, #764ba2);
border-radius: 50%;
display: flex;
align-items: center;
justify-content: center;
color: white;
font-size: 1.5rem;
font-weight: 700;
}
.creator-info {
text-align: left;
}
.creator-info span {
display: block;
color: #a0aec0;
font-size: 0.9rem;
}
.creator-info a {
color: #667eea;
text-decoration: none;
font-weight: 600;
}
.creator-info a:hover {
text-decoration: underline;
}
/* Event Content */
.event-content {
max-width: 1400px;
margin: 0 auto;
padding: 4rem 2rem;
display: grid;
grid-template-columns: 1fr 400px;
gap: 3rem;
width: 100%;
box-sizing: border-box;
}
.event-main {
display: flex;
flex-direction: column;
gap: 2.5rem;
min-width: 0; /* Allow flex item to shrink */
}
.event-description h2,
.event-details h2,
.event-actions h2 {
font-size: 1.8rem;
margin-bottom: 1.5rem;
color: white;
}
.event-description p {
font-size: 1.1rem;
line-height: 1.8;
color: #a0aec0;
}
.details-grid {
display: grid;
grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));
gap: 1.5rem;
}
.detail-item {
display: flex;
align-items: flex-start;
gap: 1rem;
padding: 1.5rem;
background: rgba(255, 255, 255, 0.05);
border-radius: 12px;
border: 1px solid rgba(255, 255, 255, 0.1);
}
.detail-item i {
color: #667eea;
font-size: 1.2rem;
margin-top: 0.2rem;
}
.detail-item strong {
display: block;
margin-bottom: 0.5rem;
color: white;
}
.detail-item span {
color: #a0aec0;
line-height: 1.6;
}
/* Event Actions */
.action-buttons {
display: flex;
gap: 1rem;
flex-wrap: wrap;
}
.login-prompt {
text-align: center;
padding: 2rem;
background: rgba(255, 255, 255, 0.05);
border-radius: 12px;
border: 1px solid rgba(255, 255, 255, 0.1);
}
.login-prompt p {
margin-bottom: 1.5rem;
color: #a0aec0;
}
/* Sidebar */
.event-sidebar {
display: flex;
flex-direction: column;
gap: 2rem;
position: sticky;
top: 2rem;
height: fit-content;
}
.sidebar-section {
background: rgba(255, 255, 255, 0.05);
border: 1px solid rgba(255, 255, 255, 0.1);
border-radius: 16px;
padding: 2rem;
}
.sidebar-section h3 {
font-size: 1.3rem;
margin-bottom: 1.5rem;
color: white;
}
.attendees-list {
display: flex;
flex-direction: column;
gap: 1rem;
}
.attendee-item {
display: flex;
align-items: center;
gap: 1rem;
padding: 1rem;
background: rgba(255, 255, 255, 0.05);
border-radius: 12px;
transition: all 0.3s ease;
}
.attendee-item:hover {
background: rgba(102, 126, 234, 0.1);
}
.attendee-avatar {
width: 40px;
height: 40px;
background: linear-gradient(135deg, #667eea, #764ba2);
border-radius: 50%;
display: flex;
align-items: center;
justify-content: center;
color: white;
font-weight: 700;
}
.attendee-info a {
color: #667eea;
text-decoration: none;
font-weight: 600;
display: block;
}
.attendee-info a:hover {
text-decoration: underline;
}
.rsvp-status {
font-size: 0.8rem;
color: #a0aec0;
text-transform: uppercase;
}
.stats-grid {
display: grid;
gap: 1rem;
}
.stat-item {
display: flex;
align-items: center;
gap: 0.5rem;
color: #a0aec0;
}
.stat-item i {
color: #667eea;
}
/* Comments Section */
.comments-section {
max-width: 1400px;
margin: 0 auto;
padding: 4rem 2rem;
width: 100%;
box-sizing: border-box;
}
.comments-section h2 {
font-size: 1.8rem;
margin-bottom: 2rem;
color: white;
}
.comment-form {
margin-bottom: 3rem;
display: flex;
gap: 1rem;
align-items: flex-start;
}
.comment-form textarea {
flex: 1;
min-height: 100px;
padding: 1rem;
background: rgba(255, 255, 255, 0.05);
border: 1px solid rgba(255, 255, 255, 0.1);
border-radius: 12px;
color: white;
font-size: 1rem;
resize: vertical;
}
.comments-list {
display: flex;
flex-direction: column;
gap: 2rem;
}
.comment-item {
display: flex;
gap: 1rem;
padding: 1.5rem;
background: rgba(255, 255, 255, 0.05);
border-radius: 12px;
border: 1px solid rgba(255, 255, 255, 0.1);
}
.comment-avatar {
width: 50px;
height: 50px;
background: linear-gradient(135deg, #667eea, #764ba2);
border-radius: 50%;
display: flex;
align-items: center;
justify-content: center;
color: white;
font-weight: 700;
flex-shrink: 0;
}
.comment-content {
flex: 1;
}
.comment-header {
display: flex;
justify-content: space-between;
align-items: center;
margin-bottom: 0.5rem;
}
.comment-header a {
color: #667eea;
text-decoration: none;
font-weight: 600;
}
.comment-header a:hover {
text-decoration: underline;
}
.comment-date {
font-size: 0.9rem;
color: #a0aec0;
}
.comment-content p {
color: #a0aec0;
line-height: 1.6;
}
.no-attendees,
.no-comments {
text-align: center;
color: #a0aec0;
font-style: italic;
}
/* Buttons */
.btn {
padding: 0.8rem 1.5rem;
border: none;
border-radius: 12px;
font-weight: 600;
cursor: pointer;
transition: all 0.3s ease;
text-decoration: none;
display: inline-flex;
align-items: center;
gap: 0.5rem;
font-size: 0.9rem;
}
.btn-primary {
background: linear-gradient(135deg, #667eea, #764ba2);
color: white;
}
.btn-primary:hover {
transform: translateY(-2px);
box-shadow: 0 4px 16px rgba(102, 126, 234, 0.4);
}
.btn-secondary {
background: rgba(255, 255, 255, 0.1);
color: white;
border: 1px solid rgba(255, 255, 255, 0.2);
}
.btn-secondary:hover {
background: rgba(102, 126, 234, 0.2);
transform: translateY(-2px);
}
.btn-outline {
background: transparent;
color: #a0aec0;
border: 1px solid rgba(255, 255, 255, 0.2);
}
.btn-outline:hover {
color: white;
border-color: rgba(102, 126, 234, 0.5);
transform: translateY(-2px);
}
/* Global Layout Fixes */
* {
box-sizing: border-box;
}
body {
margin: 0;
padding: 0;
overflow-x: hidden;
}
/* Ensure proper centering */
.event-details-container {
display: flex;
flex-direction: column;
align-items: center;
}
.event-header,
.event-content,
.comments-section {
width: 100%;
}
/* Responsive Design */
@media (max-width: 1200px) {
.event-content {
grid-template-columns: 1fr 350px;
gap: 2rem;
}
}
@media (max-width: 1024px) {
.event-content {
grid-template-columns: 1fr;
gap: 2rem;
padding: 2rem 1rem;
}
.event-header-content {
padding: 0 1rem;
}
.comments-section {
padding: 2rem 1rem;
}
.details-grid {
grid-template-columns: 1fr;
}
}
@media (max-width: 768px) {
.event-title {
font-size: 2rem;
}
.action-buttons {
flex-direction: column;
}
.comment-form {
flex-direction: column;
}
.event-header {
padding: 2rem 0 1rem;
}
.event-content {
padding: 2rem 1rem;
}
.comments-section {
padding: 2rem 1rem;
}
}
</style>
<script>
function rsvpEvent(eventId, status) {
if (!<?= $user_id ? 'true' : 'false' ?>) {
// Use AJAX navigation to preserve global player
if (window.ajaxNavigation) {
window.ajaxNavigation.navigateToPage('/auth/login_new.php');
} else {
window.location.href = '/auth/login_new.php';
}
return;
}
fetch('/api_events.php', {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify({
action: 'rsvp',
event_id: eventId,
status: status
})
})
.then(response => response.json())
.then(data => {
if (data.success) {
location.reload();
} else {
alert('Error: ' + data.message);
}
})
.catch(error => {
console.error('Error:', error);
alert('An error occurred. Please try again.');
});
}
function likeEvent(eventId) {
if (!<?= $user_id ? 'true' : 'false' ?>) {
// Use AJAX navigation to preserve global player
if (window.ajaxNavigation) {
window.ajaxNavigation.navigateToPage('/auth/login_new.php');
} else {
window.location.href = '/auth/login_new.php';
}
return;
}
fetch('/api_events.php', {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify({
action: 'like',
event_id: eventId
})
})
.then(response => response.json())
.then(data => {
if (data.success) {
location.reload();
} else {
alert('Error: ' + data.message);
}
})
.catch(error => {
console.error('Error:', error);
alert('An error occurred. Please try again.');
});
}
function shareEvent(eventId) {
const url = window.location.href;
const title = '<?= htmlspecialchars($event['title']) ?>';
if (navigator.share) {
navigator.share({
title: title,
url: url
});
} else {
// Fallback: copy to clipboard
navigator.clipboard.writeText(url).then(() => {
alert('Event link copied to clipboard!');
});
}
}
function addComment(eventId) {
const commentText = document.getElementById('commentText').value.trim();
if (!commentText) {
alert('Please enter a comment');
return;
}
fetch('/api_events.php', {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify({
action: 'comment',
event_id: eventId,
comment: commentText
})
})
.then(response => response.json())
.then(data => {
if (data.success) {
location.reload();
} else {
alert('Error: ' + data.message);
}
})
.catch(error => {
console.error('Error:', error);
alert('An error occurred. Please try again.');
});
}
</script>
<?php include 'includes/footer.php'; ?>