WhatsApp Channel Guidelines
Do's
- Be respectful to all members
- Share relevant content only
- Use appropriate language
- Follow admin instructions
Don'ts
- No spamming or flooding
- No inappropriate content
- No external promotions
- No harassment of any kind
getConnection(); // Get user data from session $username = $_SESSION['username']; $email = $_SESSION['email']; $tier = $_SESSION['tier']; $package = $_SESSION['package']; $balance = $_SESSION['balance']; $total_deposits = $_SESSION['total_deposits']; $total_withdrawals = $_SESSION['total_withdrawals']; $rewards = $_SESSION['rewards']; $earnings = $total_deposits - $total_withdrawals; // Fetch WhatsApp channels from database $channels_query = "SELECT * FROM whatsapp_channels WHERE is_active = 1 ORDER BY channel_type"; $channels_stmt = $db->prepare($channels_query); $channels_stmt->execute(); $channels = $channels_stmt->fetchAll(PDO::FETCH_ASSOC); // Fetch FAQs from database $faqs_query = "SELECT * FROM faqs WHERE is_active = 1 ORDER BY category, id"; $faqs_stmt = $db->prepare($faqs_query); $faqs_stmt->execute(); $faqs = $faqs_stmt->fetchAll(PDO::FETCH_ASSOC); // Handle support ticket submission if ($_POST && isset($_POST['submit_ticket'])) { $issue_type = $_POST['issue_type']; $subject = $_POST['subject']; $description = $_POST['description']; $ticket_number = 'TKT' . date('Ymd') . rand(1000, 9999); $ticket_query = "INSERT INTO support_tickets (user_id, ticket_number, issue_type, subject, description) VALUES (:user_id, :ticket_number, :issue_type, :subject, :description)"; $ticket_stmt = $db->prepare($ticket_query); $ticket_stmt->bindParam(':user_id', $_SESSION['user_id']); $ticket_stmt->bindParam(':ticket_number', $ticket_number); $ticket_stmt->bindParam(':issue_type', $issue_type); $ticket_stmt->bindParam(':subject', $subject); $ticket_stmt->bindParam(':description', $description); if ($ticket_stmt->execute()) { $ticket_success = "Support ticket submitted successfully! Ticket ID: " . $ticket_number; } else { $ticket_error = "Error submitting support ticket. Please try again."; } } // Check user's active tickets $active_tickets_query = "SELECT COUNT(*) as active_count FROM support_tickets WHERE user_id = :user_id AND status IN ('open', 'in_progress')"; $active_tickets_stmt = $db->prepare($active_tickets_query); $active_tickets_stmt->bindParam(':user_id', $_SESSION['user_id']); $active_tickets_stmt->execute(); $active_tickets = $active_tickets_stmt->fetch(PDO::FETCH_ASSOC); ?>