India's most trusted online survey platform, connecting consumers with market research opportunities since 2021.
Our Mission
At Relevant Reflex, we bridge the gap between Indian consumers and global market research companies. Our mission is to provide a trustworthy platform where your opinions matter and are fairly compensated.
We believe that every voice deserves to be heard, and every opinion has value. That's why we've created a secure, user-friendly platform that makes it easy for people across India to participate in market research and earn money for their time and insights.
Why We Started
Founded in 2021, Relevant Reflex was born out of the need for a reliable, India-focused survey platform. We saw too many people getting frustrated with unreliable survey sites that didn't pay or weren't relevant to the Indian market.
Our Impact in Numbers
Since our launch, we've grown to become India's leading survey platform
50,000+
Active Members
Registered users earning money with surveys
₹25,00,000+
Total Paid Out
Cumulative rewards paid to our members
2,50,000+
Surveys Completed
Successful survey completions by our members
98%
Satisfaction Rate
Members who recommend us to friends
Our Core Values
These principles guide everything we do at Relevant Reflex
Trust & Security
We protect your data with bank-level security and never share your personal information without consent. Your privacy is our priority.
Fair Compensation
Every survey you complete is fairly compensated. We ensure timely payments and transparent reward structures.
Member-Centric
Our members are at the center of everything we do. We continuously improve our platform based on your feedback.
Innovation
We're constantly evolving our platform with new features and better user experiences to serve you better.
Community
We've built more than a platform - we've built a community of engaged Indian consumers making their voices heard.
Local Focus
We understand the Indian market and provide surveys that are relevant to local consumers and culture.
Ready to Share Your Opinions?
Join thousands of Indians who are earning money with their valuable insights!
-------------------- END OF FILE --------------------
### FILE 2: admin-auth.php
- Type: PHP
- Size: 21.52 KB
- Path: .
- Name: admin-auth.php
------------------------------------------------------------
pdo = $db->getConnection();
} catch (Exception $e) {
logError('Admin auth database connection failed: ' . $e->getMessage());
throw new Exception('Database connection failed');
}
}
public function login($username, $password, $rememberMe = false) {
try {
// Find admin user
$stmt = $this->pdo->prepare("
SELECT id, username, email, password, full_name, role, status
FROM admin_users
WHERE (username = ? OR email = ?) AND status = 'active'
");
$stmt->execute([$username, $username]);
$admin = $stmt->fetch();
if (!$admin || !verifyPassword($password, $admin['password'])) {
logError('Admin login failed', ['username' => $username]);
return false;
}
// Create session
session_start();
session_regenerate_id(true);
$_SESSION['admin_logged_in'] = true;
$_SESSION['admin_id'] = $admin['id'];
$_SESSION['admin_username'] = $admin['username'];
$_SESSION['admin_full_name'] = $admin['full_name'];
$_SESSION['admin_role'] = $admin['role'];
$_SESSION['admin_login_time'] = time();
// Update last login
$stmt = $this->pdo->prepare("UPDATE admin_users SET last_login = NOW() WHERE id = ?");
$stmt->execute([$admin['id']]);
// Handle remember me
if ($rememberMe) {
$token = generateSecureToken();
$expires = date('Y-m-d H:i:s', strtotime('+30 days'));
$stmt = $this->pdo->prepare("
INSERT INTO admin_sessions (admin_id, session_token, expires_at)
VALUES (?, ?, ?)
ON DUPLICATE KEY UPDATE session_token = ?, expires_at = ?
");
$stmt->execute([$admin['id'], $token, $expires, $token, $expires]);
setcookie('admin_remember_token', $token, strtotime('+30 days'), '/', '', true, true);
}
logError('Admin login successful', [
'admin_id' => $admin['id'],
'username' => $admin['username'],
'role' => $admin['role']
]);
return true;
} catch (Exception $e) {
logError('Admin login error', ['username' => $username, 'error' => $e->getMessage()]);
return false;
}
}
public function logout() {
session_start();
if (isset($_SESSION['admin_id'])) {
logError('Admin logout', ['admin_id' => $_SESSION['admin_id']]);
}
// Clear remember token
if (isset($_COOKIE['admin_remember_token'])) {
try {
$stmt = $this->pdo->prepare("DELETE FROM admin_sessions WHERE session_token = ?");
$stmt->execute([$_COOKIE['admin_remember_token']]);
} catch (Exception $e) {
logError('Error clearing admin remember token', ['error' => $e->getMessage()]);
}
setcookie('admin_remember_token', '', time() - 3600, '/', '', true, true);
}
// Clear session
$_SESSION = [];
session_destroy();
header('Location: support.php');
exit;
}
public function isLoggedIn() {
session_start();
if (isset($_SESSION['admin_logged_in']) && $_SESSION['admin_logged_in'] === true) {
return true;
}
// Check remember me token
if (isset($_COOKIE['admin_remember_token'])) {
return $this->checkRememberToken($_COOKIE['admin_remember_token']);
}
return false;
}
private function checkRememberToken($token) {
try {
$stmt = $this->pdo->prepare("
SELECT au.id, au.username, au.full_name, au.role
FROM admin_sessions ass
JOIN admin_users au ON ass.admin_id = au.id
WHERE ass.session_token = ? AND ass.expires_at > NOW() AND au.status = 'active'
");
$stmt->execute([$token]);
$session = $stmt->fetch();
if ($session) {
// Restore session
$_SESSION['admin_logged_in'] = true;
$_SESSION['admin_id'] = $session['id'];
$_SESSION['admin_username'] = $session['username'];
$_SESSION['admin_full_name'] = $session['full_name'];
$_SESSION['admin_role'] = $session['role'];
$_SESSION['admin_login_time'] = time();
// Update last login
$stmt = $this->pdo->prepare("UPDATE admin_users SET last_login = NOW() WHERE id = ?");
$stmt->execute([$session['id']]);
return true;
} else {
// Invalid or expired token - delete it
setcookie('admin_remember_token', '', time() - 3600, '/', '', true, true);
}
} catch (Exception $e) {
logError('Error checking admin remember token', ['error' => $e->getMessage()]);
}
return false;
}
public function requireAdmin() {
if (!$this->isLoggedIn()) {
header('Location: support.php');
exit;
}
}
public function getCurrentAdmin() {
if (!$this->isLoggedIn()) {
return null;
}
session_start();
return [
'id' => $_SESSION['admin_id'],
'username' => $_SESSION['admin_username'],
'full_name' => $_SESSION['admin_full_name'],
'role' => $_SESSION['admin_role']
];
}
public function createAdmin($username, $email, $password, $fullName, $role = 'admin') {
try {
// Check if username or email already exists
$stmt = $this->pdo->prepare("SELECT id FROM admin_users WHERE username = ? OR email = ?");
$stmt->execute([$username, $email]);
if ($stmt->fetch()) {
return false;
}
// Create admin user
$hashedPassword = hashPassword($password);
$stmt = $this->pdo->prepare("
INSERT INTO admin_users (username, email, password, full_name, role, status)
VALUES (?, ?, ?, ?, ?, 'active')
");
$result = $stmt->execute([$username, $email, $hashedPassword, $fullName, $role]);
if ($result) {
logError('Admin user created', [
'username' => $username,
'email' => $email,
'role' => $role
]);
}
return $result;
} catch (Exception $e) {
logError('Error creating admin user', ['username' => $username, 'error' => $e->getMessage()]);
return false;
}
}
// SUPPORT TICKET METHODS
public function getAllTickets($status = null, $priority = null, $limit = 50, $offset = 0) {
try {
$where = "1=1";
$params = [];
if ($status) {
$where .= " AND st.status = ?";
$params[] = $status;
}
if ($priority) {
$where .= " AND st.priority = ?";
$params[] = $priority;
}
$stmt = $this->pdo->prepare("
SELECT st.*, u.email as user_email,
au.full_name as assigned_admin_name,
(SELECT COUNT(*) FROM support_messages sm WHERE sm.ticket_id = st.id) as message_count
FROM support_tickets st
LEFT JOIN users u ON st.user_id = u.id
LEFT JOIN admin_users au ON st.assigned_to = au.id
WHERE $where
ORDER BY st.created_at DESC
LIMIT $limit OFFSET $offset
");
$stmt->execute($params);
return $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching tickets', ['error' => $e->getMessage()]);
return [];
}
}
public function getTicketStats() {
try {
$stmt = $this->pdo->query("
SELECT
COUNT(*) as total,
SUM(CASE WHEN status = 'open' THEN 1 ELSE 0 END) as open,
SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending,
SUM(CASE WHEN status = 'resolved' THEN 1 ELSE 0 END) as resolved,
SUM(CASE WHEN status = 'closed' THEN 1 ELSE 0 END) as closed
FROM support_tickets
");
return $stmt->fetch();
} catch (Exception $e) {
logError('Error fetching ticket stats', ['error' => $e->getMessage()]);
return ['total' => 0, 'open' => 0, 'pending' => 0, 'resolved' => 0, 'closed' => 0];
}
}
public function getTicketById($ticketId) {
try {
$stmt = $this->pdo->prepare("
SELECT st.*, u.email as user_email, u.gender, u.date_of_birth, u.postcode,
au.full_name as assigned_admin_name
FROM support_tickets st
LEFT JOIN users u ON st.user_id = u.id
LEFT JOIN admin_users au ON st.assigned_to = au.id
WHERE st.id = ?
");
$stmt->execute([$ticketId]);
return $stmt->fetch();
} catch (Exception $e) {
logError('Error fetching ticket', ['ticket_id' => $ticketId, 'error' => $e->getMessage()]);
return null;
}
}
public function getTicketMessages($ticketId, $includeInternal = false) {
try {
$where = $includeInternal ? "1=1" : "is_internal = 0";
$stmt = $this->pdo->prepare("
SELECT sm.*,
CASE
WHEN sm.sender_type = 'user' THEN u.email
WHEN sm.sender_type = 'admin' THEN au.full_name
END as sender_name
FROM support_messages sm
LEFT JOIN users u ON sm.sender_type = 'user' AND sm.sender_id = u.id
LEFT JOIN admin_users au ON sm.sender_type = 'admin' AND sm.sender_id = au.id
WHERE sm.ticket_id = ? AND $where
ORDER BY sm.created_at ASC
");
$stmt->execute([$ticketId]);
return $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching ticket messages', ['ticket_id' => $ticketId, 'error' => $e->getMessage()]);
return [];
}
}
public function updateTicketStatus($ticketId, $status, $adminId) {
try {
$stmt = $this->pdo->prepare("
UPDATE support_tickets
SET status = ?, resolved_at = CASE WHEN ? = 'resolved' COLLATE utf8mb4_unicode_ci THEN NOW() ELSE resolved_at END
WHERE id = ?
");
$result = $stmt->execute([$status, $status, $ticketId]);
if ($result) {
logError('Ticket status updated', [
'ticket_id' => $ticketId,
'status' => $status,
'admin_id' => $adminId
]);
}
return $result;
} catch (Exception $e) {
logError('Error updating ticket status', ['ticket_id' => $ticketId, 'error' => $e->getMessage()]);
return false;
}
}
public function assignTicket($ticketId, $adminId) {
try {
$stmt = $this->pdo->prepare("UPDATE support_tickets SET assigned_to = ?, updated_at = NOW() WHERE id = ?");
return $stmt->execute([$adminId, $ticketId]);
} catch (Exception $e) {
logError('Error assigning ticket', ['ticket_id' => $ticketId, 'admin_id' => $adminId, 'error' => $e->getMessage()]);
return false;
}
}
public function addTicketReply($ticketId, $message, $adminId, $isInternal = false) {
try {
$stmt = $this->pdo->prepare("
INSERT INTO support_messages (ticket_id, sender_type, sender_id, message, is_internal)
VALUES (?, 'admin', ?, ?, ?)
");
$result = $stmt->execute([$ticketId, $adminId, $message, $isInternal]);
if ($result) {
// Update ticket timestamp
$stmt = $this->pdo->prepare("UPDATE support_tickets SET updated_at = NOW() WHERE id = ?");
$stmt->execute([$ticketId]);
}
return $result;
} catch (Exception $e) {
logError('Error adding ticket reply', ['ticket_id' => $ticketId, 'admin_id' => $adminId, 'error' => $e->getMessage()]);
return false;
}
}
public function getAdminUsers() {
try {
$stmt = $this->pdo->prepare("SELECT id, username, full_name, role FROM admin_users WHERE status = 'active' ORDER BY full_name");
$stmt->execute();
return $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching admin users', ['error' => $e->getMessage()]);
return [];
}
}
// REDEMPTION MANAGEMENT METHODS
public function getAllRedemptions($status = null, $dateFilter = null, $limit = 50, $offset = 0) {
try {
$where = "1=1";
$params = [];
if ($status && $status !== 'all') {
$where .= " AND rr.status = ?";
$params[] = $status;
}
if ($dateFilter) {
switch ($dateFilter) {
case 'today':
$where .= " AND DATE(rr.created_at) = CURDATE()";
break;
case 'yesterday':
$where .= " AND DATE(rr.created_at) = DATE_SUB(CURDATE(), INTERVAL 1 DAY)";
break;
case 'this_week':
$where .= " AND rr.created_at >= DATE_SUB(NOW(), INTERVAL 7 DAY)";
break;
case 'this_month':
$where .= " AND rr.created_at >= DATE_SUB(NOW(), INTERVAL 30 DAY)";
break;
}
}
$stmt = $this->pdo->prepare("
SELECT rr.*,
u.email as user_email,
au.full_name as processed_by_name,
(SELECT COUNT(*) FROM redemption_requests WHERE user_id = rr.user_id) as user_total_redemptions
FROM redemption_requests rr
LEFT JOIN users u ON rr.user_id = u.id
LEFT JOIN admin_users au ON rr.processed_by = au.id
WHERE $where
ORDER BY rr.created_at DESC
LIMIT $limit OFFSET $offset
");
$stmt->execute($params);
return $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching redemptions', ['error' => $e->getMessage()]);
return [];
}
}
public function getRedemptionStats() {
try {
$stmt = $this->pdo->query("
SELECT
COUNT(*) as total,
SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending,
SUM(CASE WHEN status = 'processing' THEN 1 ELSE 0 END) as processing,
SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) as completed,
SUM(CASE WHEN status = 'failed' THEN 1 ELSE 0 END) as failed,
SUM(CASE WHEN status = 'cancelled' THEN 1 ELSE 0 END) as cancelled,
SUM(CASE WHEN status = 'pending' THEN amount_inr ELSE 0 END) as pending_amount,
SUM(CASE WHEN status IN ('processing', 'completed') THEN amount_inr ELSE 0 END) as processed_amount
FROM redemption_requests
");
return $stmt->fetch();
} catch (Exception $e) {
logError('Error fetching redemption stats', ['error' => $e->getMessage()]);
return [
'total' => 0, 'pending' => 0, 'processing' => 0, 'completed' => 0,
'failed' => 0, 'cancelled' => 0, 'pending_amount' => 0, 'processed_amount' => 0
];
}
}
public function updateRedemptionStatus($redemptionId, $status, $adminNotes, $adminId) {
try {
$this->pdo->beginTransaction();
// Get redemption details
$stmt = $this->pdo->prepare("SELECT * FROM redemption_requests WHERE id = ?");
$stmt->execute([$redemptionId]);
$redemption = $stmt->fetch();
if (!$redemption) {
throw new Exception('Redemption request not found');
}
// Update redemption status
$stmt = $this->pdo->prepare("
UPDATE redemption_requests
SET status = ?, admin_notes = ?, processed_by = ?, processed_at = NOW(), updated_at = NOW()
WHERE id = ?
");
$stmt->execute([$status, $adminNotes, $adminId, $redemptionId]);
// Update point transaction status
$stmt = $this->pdo->prepare("
UPDATE point_transactions
SET status = ?
WHERE reference_id = ? AND transaction_type = 'redeemed'
");
$stmt->execute([$status, $redemption['request_id']]);
// If status is failed or cancelled, refund the points
if (in_array($status, ['failed', 'cancelled'])) {
$stmt = $this->pdo->prepare("
UPDATE user_points
SET points = points + ?, total_redeemed = total_redeemed - ?
WHERE user_id = ?
");
$stmt->execute([$redemption['points_redeemed'], $redemption['points_redeemed'], $redemption['user_id']]);
// Add refund transaction
$refundDescription = "Refund for {$status} redemption request - " . $redemption['request_id'];
$stmt = $this->pdo->prepare("
INSERT INTO point_transactions (user_id, transaction_type, points, source, description, reference_id)
VALUES (?, 'earned', ?, 'refund', ?, ?)
");
$stmt->execute([$redemption['user_id'], $redemption['points_redeemed'], $refundDescription, $redemption['request_id']]);
}
$this->pdo->commit();
logError('Redemption status updated', [
'redemption_id' => $redemptionId,
'request_id' => $redemption['request_id'],
'old_status' => $redemption['status'],
'new_status' => $status,
'admin_id' => $adminId,
'admin_notes' => $adminNotes
]);
return true;
} catch (Exception $e) {
$this->pdo->rollback();
logError('Error updating redemption status', [
'redemption_id' => $redemptionId,
'error' => $e->getMessage()
]);
return false;
}
}
public function getRedemptionById($redemptionId) {
try {
$stmt = $this->pdo->prepare("
SELECT rr.*,
u.email as user_email, u.gender, u.date_of_birth, u.postcode,
au.full_name as processed_by_name,
up.points as user_current_points,
up.total_earned, up.total_redeemed
FROM redemption_requests rr
LEFT JOIN users u ON rr.user_id = u.id
LEFT JOIN admin_users au ON rr.processed_by = au.id
LEFT JOIN user_points up ON rr.user_id = up.user_id
WHERE rr.id = ?
");
$stmt->execute([$redemptionId]);
return $stmt->fetch();
} catch (Exception $e) {
logError('Error fetching redemption', ['redemption_id' => $redemptionId, 'error' => $e->getMessage()]);
return null;
}
}
public function getRecentRedemptions($limit = 5) {
try {
$stmt = $this->pdo->prepare("
SELECT rr.request_id, rr.amount_inr, rr.status, rr.created_at, u.email as user_email
FROM redemption_requests rr
LEFT JOIN users u ON rr.user_id = u.id
ORDER BY rr.created_at DESC
LIMIT ?
");
$stmt->execute([$limit]);
return $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching recent redemptions', ['error' => $e->getMessage()]);
return [];
}
}
}
// Utility functions
function adminJsonResponse($success, $message, $data = null) {
header('Content-Type: application/json');
echo json_encode([
'success' => $success,
'message' => $message,
'data' => $data
]);
exit;
}
?>
-------------------- END OF FILE --------------------
### FILE 3: articles.php
- Type: PHP
- Size: 26.31 KB
- Path: .
- Name: articles.php
------------------------------------------------------------
Articles & Tips - Relevant Reflex | Maximize Your Survey Earnings
Articles & Tips
Expert advice, tips, and insights to help you maximize your earnings with online surveys in India.
Paid Online Surveys in India: How to Spot Genuine Websites
In the bustling online world of India, paid online surveys have become a popular means for individuals to earn extra income conveniently. Companies and market research firms value the opinions of Indian consumers, and this has led to numerous opportunities to participate in paid surveys. However, with the rise in demand for such opportunities, fraudulent websites have also emerged, preying on unsuspecting individuals.
Learn the key indicators of legitimate survey platforms and avoid falling victim to scams. Essential reading for anyone starting with online surveys in India.
Key Points:
Thorough Research is Key: Look for platforms with strong online presence and positive reviews from Indian users.
Seek Transparent Websites: Legitimate sites provide clear contact information and company details.
Avoid Upfront Fees: Reputable sites never charge registration fees.
Check Payment Methods: Verify that payment methods are reputable and suitable for India.
December 10, 2024 | Tips & Tricks
5 Ways to Maximize Your Survey Earnings
Practical strategies to increase your monthly survey income. From profile optimization to timing your survey participation.
Quick Tips:
Complete your profile 100%
Join multiple legitimate platforms
Check for surveys daily
Be honest in your responses
Participate in profiling surveys
December 5, 2024 | Getting Started
Complete Guide for Survey Beginners in India
Everything you need to know to get started with online surveys in India. From registration to your first payout.
What You'll Learn:
How to choose the right survey sites
Setting up your profile for success
Understanding survey types and rewards
Payment methods available in India
November 28, 2024 | Maximize Earnings
Realistic Earning Expectations from Surveys
Set proper expectations about survey earnings in India. Learn what's realistic and how to achieve consistent monthly income.
Expected Earnings:
Beginners: ₹500-₹1,500/month
Active users: ₹2,000-₹4,000/month
Expert users: ₹5,000+/month
Time investment: 1-2 hours daily
November 20, 2024 | India Specific
Best Survey Platforms for Indian Users
Comprehensive review of survey platforms that work best for Indian users, with focus on payment methods and survey availability.
Top Platforms for Indians:
Relevant Reflex (Our platform)
Swagbucks India
Toluna India
ySense (formerly ClixSense)
November 15, 2024 | Tips & Tricks
Time Management Tips for Survey Takers
Learn how to efficiently manage your time while taking surveys. Balance survey participation with your daily routine.
Time Management Tips:
Set specific times for survey participation
Use mobile apps for on-the-go surveys
Prioritize higher-paying surveys
Don't force yourself to qualify for every survey
Ready to Start Your Survey Journey?
Apply these tips and start earning with legitimate online surveys today!
Account approval is typically instant after email verification. You can start taking surveys immediately after verifying your email address.
When do I get paid for completed surveys?
Payments are processed according to each survey provider's schedule. Most rewards are credited within 2-5 business days after survey completion.
Why was I disqualified from a survey?
Survey disqualifications happen when your profile doesn't match the target demographic. This is normal and helps ensure survey quality. Keep trying - there are surveys for all profiles!
How can I increase my survey opportunities?
Complete your profile thoroughly, answer profiling questions honestly, and check your dashboard regularly for new opportunities.
Is Relevant Reflex really free to join?
Yes! Joining Relevant Reflex is completely free. We never charge fees to our members. Legitimate survey companies pay YOU for your opinions, not the other way around.
-------------------- END OF FILE --------------------
### FILE 7: dashboard.php
- Type: PHP
- Size: 43.06 KB
- Path: .
- Name: dashboard.php
------------------------------------------------------------
redirectToLogin('Session expired. Please log in again.');
}
// Initialize database
try {
$db = new Database();
$pdo = $db->getConnection();
} catch (Exception $e) {
logError('Database connection failed in dashboard.php: ' . $e->getMessage());
die('System error. Please try again later.');
}
// Award onboarding points if not already awarded
if (!$user['onboarding_points_awarded']) {
try {
$pdo->beginTransaction();
// Add onboarding points
$stmt = $pdo->prepare("INSERT INTO user_points (user_id, points, total_earned) VALUES (?, 10.00, 10.00) ON DUPLICATE KEY UPDATE points = points + 10.00, total_earned = total_earned + 10.00");
$stmt->execute([$user['id']]);
// Add transaction record
$stmt = $pdo->prepare("INSERT INTO point_transactions (user_id, transaction_type, points, source, description) VALUES (?, 'earned', 10.00, 'onboarding', 'Welcome bonus for joining Relevant Reflex')");
$stmt->execute([$user['id']]);
// Mark as awarded
$stmt = $pdo->prepare("UPDATE users SET onboarding_points_awarded = 1 WHERE id = ?");
$stmt->execute([$user['id']]);
$pdo->commit();
logError('Onboarding points awarded', ['user_id' => $user['id'], 'points' => 10]);
// Refresh user data to reflect changes
$user = getCurrentUser();
} catch (Exception $e) {
$pdo->rollback();
logError('Error awarding onboarding points', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
}
// Get user points
$userPoints = ['points' => 0, 'total_earned' => 0, 'total_redeemed' => 0];
try {
$stmt = $pdo->prepare("SELECT points, total_earned, total_redeemed FROM user_points WHERE user_id = ?");
$stmt->execute([$user['id']]);
$pointsData = $stmt->fetch();
if ($pointsData) {
$userPoints = $pointsData;
}
} catch (Exception $e) {
logError('Error fetching user points', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Get profiler completion status
$profilerSections = [
'personal_background' => 'Personal Background',
'household_family' => 'Household & Family',
'shopping_lifestyle' => 'Shopping & Lifestyle',
'technology_digital' => 'Technology & Digital',
'travel_transportation' => 'Travel & Transportation',
'health_fitness' => 'Health & Fitness',
'entertainment_media' => 'Entertainment & Media',
'food_dining' => 'Food & Dining',
'financial_services' => 'Financial Services',
'communication_payments' => 'Communication & Payments'
];
$profilerCompletion = [];
try {
$stmt = $pdo->prepare("SELECT section, completion_percentage, is_completed, points_awarded FROM profiler_completion WHERE user_id = ?");
$stmt->execute([$user['id']]);
while ($row = $stmt->fetch()) {
$profilerCompletion[$row['section']] = $row;
}
} catch (Exception $e) {
logError('Error fetching profiler completion', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Get mobile verification status
$mobileVerified = false;
$mobileNumber = '';
try {
$stmt = $pdo->prepare("SELECT mobile_number, is_verified FROM mobile_verifications WHERE user_id = ?");
$stmt->execute([$user['id']]);
$mobileData = $stmt->fetch();
if ($mobileData) {
$mobileVerified = $mobileData['is_verified'];
$mobileNumber = $mobileData['mobile_number'];
}
} catch (Exception $e) {
logError('Error fetching mobile verification', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Get UPI ID from profiler
$upiId = '';
try {
$stmt = $pdo->prepare("SELECT response FROM user_profiler WHERE user_id = ? AND section = 'profile' AND question_id = 'upi_id'");
$stmt->execute([$user['id']]);
$upiData = $stmt->fetch();
if ($upiData) {
$upiId = json_decode($upiData['response'], true);
}
} catch (Exception $e) {
logError('Error fetching UPI ID', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Handle UPI ID update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update_upi') {
$newUpiId = isset($_POST['upi_id']) ? sanitize($_POST['upi_id']) : '';
if (!empty($newUpiId) && preg_match('/^[\w\.-]+@[\w\.-]+$/', $newUpiId)) {
try {
$stmt = $pdo->prepare("INSERT INTO user_profiler (user_id, section, question_id, response) VALUES (?, 'profile', 'upi_id', ?) ON DUPLICATE KEY UPDATE response = ?, updated_at = NOW()");
$upiJson = json_encode($newUpiId);
$stmt->execute([$user['id'], $upiJson, $upiJson]);
$upiId = $newUpiId;
$success_message = "UPI ID updated successfully!";
} catch (Exception $e) {
logError('Error updating UPI ID', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
$error_message = "Error updating UPI ID. Please try again.";
}
} else {
$error_message = "Please enter a valid UPI ID (e.g., yourname@paytm).";
}
}
// Get user's support tickets for the support section
$userTickets = [];
try {
$stmt = $pdo->prepare("
SELECT st.*,
(SELECT COUNT(*) FROM support_messages sm WHERE sm.ticket_id = st.id) as message_count,
(SELECT sm.created_at FROM support_messages sm WHERE sm.ticket_id = st.id ORDER BY sm.created_at DESC LIMIT 1) as last_reply
FROM support_tickets st
WHERE st.user_id = ?
ORDER BY st.created_at DESC
LIMIT 10
");
$stmt->execute([$user['id']]);
$userTickets = $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching user tickets', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Get user's recent redemption requests
$userRedemptions = [];
try {
$stmt = $pdo->prepare("
SELECT * FROM redemption_requests
WHERE user_id = ?
ORDER BY created_at DESC
LIMIT 5
");
$stmt->execute([$user['id']]);
$userRedemptions = $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching user redemptions', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
}
// Calculate account age
$joinDate = new DateTime($user['created_at']);
$now = new DateTime();
$accountAge = $now->diff($joinDate);
$joinDateFormatted = $joinDate->format('M Y');
?>
Dashboard - Relevant Reflex
Welcome to Your Survey Dashboard!
Complete your profile, earn points, and participate in paid surveys from trusted research companies.
Earn up to 50 points by completing all profile sections
Redeem Rewards
Convert your points to cash rewards via UPI
Need Help?
Get support for any questions or issues
Available Surveys
Complete Your Profile First!
To receive targeted survey invitations, please complete all sections in the "Know Me Better" profiler. This helps us match you with relevant surveys that fit your demographics and interests.
Current Progress: / sections completed
Know Me Better Complete All Sections to Earn 50 Points!
Help us understand you better to send more relevant survey opportunities. Each completed section earns you 5 points!
Mobile Verification
Your mobile number is verified!
Verify your mobile number to receive survey notifications and earn 10 points.
When you signup, DO NOT provide fake details. Provide your correct details including your gender, age, occupation, company, region etc. Since online paid surveys are sent to almost all age and gender categories and profile types, when you fake your profile, you might not get what you usually get for your actual profile.
Complete Profiler Surveys
Provide as many details as possible about you in the profiler section. This includes your gaming profile, income range, automobile assets, real estate assets, electronics you own and so on. When you attend more profiler surveys, you get more and more surveys related to all these. When you have only a generic profile and not completed the profiler surveys, you will get only those surveys which are based on age and gender.
Choose Languages You Know
Choose the languages that you know. Some people try surveys in other languages. Since you can't translate and understand all languages, you might end up taking more time on the survey than usual duration. When you take such a long duration on any survey, the system might mark you as a fraudulent user.
Be Patient
When you get screened out of many surveys, it means that the survey is not meant for your profile. This also means that there will be surveys targeting you in the future. So, KEEP PARTICIPATING in as many surveys as possible.
Log In Daily
Login every day to see if you have any surveys. Check your mail daily to know if you have any survey invitations. When you don't check the mail or login daily, other users will complete those surveys sooner and you might not get a chance to complete the survey.
Important Guidelines
Avoid Survey Fraud
Never use automated tools, VPNs, or provide inconsistent answers. This can result in account suspension and loss of rewards.
One Account Per Person
Maintain only one account per person. Multiple accounts from the same household or IP address may result in disqualification.
Complete Surveys Promptly
Don't leave surveys incomplete for long periods. Complete them in a reasonable timeframe to maintain your quality score.
Understanding Survey Types
Opinion Surveys
Share your thoughts on products, services, brands, and current topics. These are the most common type of surveys.
5-20 minutes
Product Testing
Test products at home and provide detailed feedback. Higher rewards but limited availability.
1-2 weeks
Focus Groups
Join group discussions on specific topics. These offer the highest rewards but are invitation-only.
1-2 hours
Profile Surveys
Complete these to help us match you with more relevant surveys. Essential for maximizing opportunities.
2-5 minutes
Success Stories from Our Members
Real experiences from real people earning with Relevant Reflex
"Earned ₹15,000 in 6 months"
"I follow all the tips mentioned here and consistently earn ₹2,500-₹3,000 per month. The key is patience and honesty in responses."
- Rajesh K., Software Engineer, Mumbai
"Perfect for students"
"As a college student, this platform helps me earn pocket money. I complete surveys between classes and have earned ₹8,000 so far."
- Priya S., Student, Delhi
"Reliable side income"
"Been using Relevant Reflex for over a year. It's become a reliable source of extra income for my family. Highly recommended!"
- Sneha M., Homemaker, Bangalore
Need Help Getting Started?
Our support team is here to help you succeed with online surveys!
Security Notice: This password reset link will expire in 2 hours for your security. If you don\'t reset your password within this time, you\'ll need to request a new reset link.
If the button above doesn\'t work, you can also copy and paste this link into your browser:
Join thousands of Indians who are making extra income by sharing their opinions. Get paid for participating in market research surveys from top companies.
Welcome to Relevant Reflex ("we," "our," or "us"). We are committed to protecting your privacy and ensuring the security of your personal information. This Privacy Policy explains how we collect, use, disclose, and safeguard your information when you use our online survey platform and related services.
Key Principle: We believe in transparency and will never sell your personal data to third parties for marketing purposes.
By using our services, you agree to the collection and use of information in accordance with this Privacy Policy. If you disagree with any part of this policy, please do not use our services.
2. Information We Collect
2.1 Personal Information
We collect the following types of personal information:
Registration Information: Name, email address, date of birth, gender, postal code
Profile Information: Occupation, income range, interests, preferences, household information
Survey Responses: Your answers to survey questions and research studies
Communication Data: Messages you send to our support team
2.2 Technical Information
IP address and location data
Browser type and version
Device information (type, operating system)
Usage data (pages visited, time spent, click patterns)
Cookies and similar tracking technologies
2.3 Financial Information
For payment processing, we may collect:
Payment method preferences
Bank account details (for direct transfers)
PayPal account information
3. How We Use Your Information
3.1 Primary Uses
Survey Matching: To match you with relevant survey opportunities based on your demographics and interests
Account Management: To create and maintain your account, process registrations, and provide customer support
Payment Processing: To calculate, process, and distribute rewards for completed surveys
Communication: To send you survey invitations, account updates, and important service announcements
3.2 Secondary Uses
To improve our platform and user experience
To prevent fraud and maintain platform security
To comply with legal obligations and regulatory requirements
To conduct internal research and analytics
Legal Basis: We process your data based on consent, legitimate interests, contract performance, and legal obligations as per applicable Indian data protection laws.
4. Information Sharing and Disclosure
4.1 Survey Partners
We may share anonymized or aggregated survey data with our research partners and clients. Individual responses are never linked to personal identifiers without explicit consent.
4.2 Service Providers
We work with trusted third-party service providers who assist us with:
Payment processing
Email delivery services
Data hosting and security
Customer support platforms
4.3 Legal Requirements
We may disclose your information if required by law, court order, or to:
Comply with legal processes
Protect our rights and property
Prevent fraud or security threats
Protect the safety of our users
4.4 Business Transfers
In the event of a merger, acquisition, or sale of assets, your information may be transferred as part of the business transaction.
5. Data Security
5.1 Security Measures
We implement industry-standard security measures to protect your information:
SSL encryption for all data transmissions
Secure database storage with access controls
Regular security audits and updates
Employee training on data protection
Multi-factor authentication for admin access
5.2 Data Breach Response
In the unlikely event of a data breach, we will:
Notify affected users within 72 hours
Report to relevant authorities as required
Take immediate steps to secure the breach
Provide guidance on protective measures
6. Your Rights and Choices
Under applicable data protection laws, you have the following rights:
6.1 Access and Portability
Request a copy of your personal data
Download your data in a portable format
View your survey history and earnings
6.2 Correction and Updates
Update your profile information
Correct inaccurate data
Modify communication preferences
6.3 Deletion and Restriction
Request deletion of your account and data
Restrict processing of certain information
Object to specific uses of your data
Exercise Your Rights: To exercise any of these rights, contact us at privacy@relevantreflex.com or through your account settings.
7. Cookies and Tracking Technologies
7.1 Types of Cookies We Use
Essential Cookies: Required for basic platform functionality
Performance Cookies: Help us analyze platform usage and improve performance
Functional Cookies: Remember your preferences and settings
Targeting Cookies: Used to deliver relevant survey opportunities
7.2 Cookie Management
You can control cookies through your browser settings. However, disabling certain cookies may limit platform functionality.
8. Data Retention
We retain your information for the following periods:
Active Accounts: Data retained while account is active
Inactive Accounts: Data retained for 2 years after last activity
Survey Data: Anonymized responses may be retained for research purposes
Financial Records: Retained for 7 years as per legal requirements
Marketing Communications: Until you unsubscribe
9. Children's Privacy
Our services are not intended for individuals under 18 years of age. We do not knowingly collect personal information from children. If we discover that we have collected information from a child, we will delete it immediately.
Parents or guardians who believe their child has provided information to us should contact us immediately.
10. International Data Transfers
While we primarily operate within India, some of our service providers may be located internationally. When we transfer data outside India, we ensure:
Adequate protection through contractual safeguards
Compliance with applicable data transfer regulations
Use of standard contractual clauses where required
11. Changes to This Privacy Policy
We may update this Privacy Policy periodically to reflect changes in our practices or applicable laws. We will:
Notify users of material changes via email
Post updates on our website
Provide a clear summary of changes
Allow reasonable time for review before changes take effect
Continued use of our services after policy updates constitutes acceptance of the changes.
12. Contact Us
If you have questions about this Privacy Policy or our data practices, please contact us:
Welcome to Relevant Reflex!
These Terms and Conditions ("Terms") govern your use of our online survey platform and related services. Please read them carefully.
1Acceptance of Terms
By using Relevant Reflex's services, you acknowledge that you have read, understood, and agree to be bound by these Terms, as well as our Privacy Policy.
If you do not agree with any part of these terms, you must not use our services. Your continued use of the platform constitutes acceptance of any modifications to these Terms.
2Eligibility
2.1 Age Requirement
You must be at least 18 years old to use our services. By registering, you represent and warrant that you meet this age requirement.
2.2 Geographic Requirement
You must be a resident of India to participate in our surveys and receive rewards. This helps us provide relevant survey opportunities and comply with local regulations.
2.3 Account Limitations
You may only maintain one account with Relevant Reflex. Multiple accounts from the same individual are prohibited and may result in account suspension.
3Account Registration and Security
3.1 Account Responsibility
You are responsible for:
Maintaining the confidentiality of your account information
All activities that occur under your account
Notifying us immediately of any unauthorized use
Ensuring your login credentials are secure
3.2 Accurate Information
You agree to provide accurate and up-to-date information during registration and throughout your use of our services. False or misleading information may result in account termination.
3.3 Account Verification
You must verify your email address and may be required to provide additional verification for account security or compliance purposes.
4Survey Participation
4.1 Honest Responses
You agree to provide honest and thoughtful responses to surveys. Quality responses are essential for meaningful research.
4.2 Survey Qualification
We reserve the right to disqualify you from a survey if we detect:
Fraudulent or inconsistent responses
Use of automated tools or bots
Excessively fast completion times
Random or nonsensical answers
4.3 Survey Availability
Survey opportunities are based on your demographic profile and survey requirements. We cannot guarantee specific numbers or types of surveys.
Important: Completion of a survey does not guarantee reward if disqualified for quality reasons. We maintain strict quality standards to ensure valuable research data.
5Rewards and Payments
5.1 Reward Distribution
Rewards will be issued as per the terms specified for each survey. Typical processing times are:
Survey validation: 1-5 business days
Payment processing: 3-7 business days
Bank transfer: 2-3 additional business days
5.2 Reward Modifications
We reserve the right to modify, suspend, or terminate the reward system at any time with reasonable notice to members.
5.3 Reward Restrictions
Unless specified otherwise:
Rewards are non-transferable between accounts
Rewards cannot be exchanged for cash in all cases
Minimum payout thresholds may apply
Payment methods may be limited based on location
5.4 Tax Responsibilities
You are responsible for reporting and paying any applicable taxes on rewards received. We may provide necessary documentation for tax purposes.
6Intellectual Property
6.1 Platform Content
All content on our website, including text, graphics, logos, images, and software, is the property of Relevant Reflex or its licensors and is protected by copyright laws.
6.2 Usage Restrictions
You may not:
Use, reproduce, or distribute our content without express written permission
Modify or create derivative works from our platform
Reverse engineer any part of our services
Use our trademarks or branding without authorization
6.3 User-Generated Content
By providing survey responses and feedback, you grant us a non-exclusive, royalty-free license to use this information for research and platform improvement purposes.
7Prohibited Conduct
You agree NOT to engage in any of the following activities:
7.1 Technical Violations
Use automated means (bots, scripts) to access our services or complete surveys
Attempt to interfere with the proper functioning of our website
Circumvent any security measures or access controls
Use VPNs or proxy services to mask your location
7.2 Identity and Fraud
Impersonate any person or entity
Create multiple accounts
Provide false personal information
Share account credentials with others
7.3 Legal Violations
Engage in any activity that violates applicable law or regulation
Violate the rights of other users or third parties
Transmit harmful, threatening, or offensive content
Engage in harassment or discrimination
Enforcement: Violation of these terms may result in immediate account suspension or termination, forfeiture of rewards, and potential legal action.
8Termination
8.1 Termination by Us
We reserve the right to suspend or terminate your account at our discretion, without notice, for:
Violation of these Terms
Fraudulent activity
Extended inactivity (24+ months)
Legal or regulatory requirements
8.2 Termination by You
You may terminate your account at any time by:
Using the account deletion option in your settings
Contacting our support team
Sending a written request to support@relevantreflex.com
8.3 Effects of Termination
Upon termination:
Your access to the platform will be immediately revoked
Pending rewards may be forfeited (depending on circumstances)
Your personal data will be handled according to our Privacy Policy
Certain provisions of these Terms will survive termination
9Limitation of Liability
9.1 Service Disclaimer
Our services are provided "as is" without warranties of any kind. We do not guarantee:
Uninterrupted or error-free service
Specific survey availability or earnings
Compatibility with all devices or browsers
Accuracy of third-party content
9.2 Liability Limitations
Relevant Reflex is not liable for any indirect, incidental, special, or consequential damages, including:
Loss of profits or earnings
Business interruption
Data loss or corruption
Emotional distress
9.3 Maximum Liability
Our total liability for any claim arising from these Terms shall not exceed the amount paid to you in the past 12 months, or ₹1,000, whichever is greater.
10Indemnification
You agree to indemnify and hold Relevant Reflex harmless from any claims, losses, or damages arising from:
Your use of our services
Violation of these Terms
Violation of any law or regulation
Infringement of third-party rights
Your survey responses or other content
11Privacy Policy
Your privacy is important to us. Our Privacy Policy explains how we collect, use, and protect your information. By using our services, you also agree to our Privacy Policy.
Key privacy principles:
We never sell your personal data to third parties
Your survey responses are anonymized for research
You control your data and can request deletion
We use industry-standard security measures
12Changes to Terms
12.1 Modification Process
We may modify these Terms at any time. When we make changes, we will:
Update the "Last Modified" date
Notify active users via email
Provide a summary of significant changes
Allow reasonable time for review (minimum 30 days for material changes)
12.2 Acceptance of Changes
Continued use of our services after changes constitutes acceptance of the modified Terms. If you disagree with changes, you should terminate your account before they take effect.
13Governing Law and Jurisdiction
13.1 Applicable Law
These Terms are governed by the laws of India, without regard to conflict of law principles.
13.2 Jurisdiction
Any disputes shall be subject to the exclusive jurisdiction of the courts in Tamil Nadu, India.
13.3 Dispute Resolution
Before pursuing legal action, we encourage users to:
Contact our support team to resolve issues
Allow 30 days for resolution attempts
Consider mediation for complex disputes
14Contact Information
If you have questions about these Terms, please contact us:
Our support ticket system is designed to provide you with efficient, trackable help for any issues or questions you may have. Each ticket gets a unique number and goes through a structured process to ensure nothing gets missed.
How to Create a Support Ticket
Login to your account - Visit your dashboard
Go to Support section - Click "Support" in the navigation
Fill out the form - Provide subject and detailed description
Every support ticket goes through different statuses as our team works to resolve your issue. Here's what each status means:
🟡 OPEN
What it means: Your ticket has been received and is waiting for our support team to review it.
What happens next: A support agent will review your issue and respond with initial guidance or questions.
Can you reply? ✅ Yes, you can add more information anytime.
🔵 PENDING
What it means: Our support team has responded and is waiting for your reply or action.
What happens next: Please check your email and dashboard for our response. We may need more information or be waiting for you to try a suggested solution.
Can you reply? ✅ Yes, please respond to keep the conversation going.
🟢 RESOLVED
What it means: Our team believes your issue has been solved, but we want to make sure!
What happens next: Please test the solution and let us know if it worked. If the issue persists, just reply and we'll reopen the ticket.
Can you reply? ✅ Yes, you can confirm the fix worked or report if issues continue.
🔴 CLOSED
What it means: Your issue has been completely resolved and the ticket is archived.
What happens next: Nothing! Your issue is solved. If you have a new problem, please create a new ticket.
Can you reply? ❌ No, closed tickets cannot be reopened. Please create a new ticket for new issues.
Priority Levels
When creating a ticket, choose the priority level that best matches your situation:
🟢 LOWGeneral Questions
24-48 hours
Use for: How-to questions, feature requests, general inquiries
🟡 MEDIUMStandard Issues
12-24 hours
Use for: Account issues, survey problems, payment questions
🟠 HIGHUrgent Problems
4-8 hours
Use for: Cannot access account, missing payments, data issues
🔴 URGENTCritical Issues
1-2 hours
Use for: Security concerns, service outages, data loss
Typical Workflow
📧 Example: "I can't access my account"
Day 1 - You create ticket
🟡 OPEN "I can't log in to my account"
Day 1 - We respond (4 hours later)
🔵 PENDING "Can you try resetting your password? Click here..."
Day 2 - You reply
🔵 PENDING "I tried but didn't receive the reset email"
Day 2 - We investigate and fix
🟢 RESOLVED "Found the issue - email was blocked. Fixed it and reset your password to: [new password]"
Day 2 - You confirm
🟢 RESOLVED "Perfect! I can log in now. Thank you!"
Day 3 - We close ticket
🔴 CLOSED Issue resolved successfully.
Response Times
We strive to respond to all tickets promptly. Our target response times are:
🕐 Business Hours
Monday-Friday: 9:00 AM - 6:00 PM IST Saturday: 10:00 AM - 4:00 PM IST Sunday: Closed (emergency only)
🚀 Response Goals
Urgent: Within 2 hours High: Within 8 hours Medium: Within 24 hours Low: Within 48 hours
Pro Tip
Response times are for first response. Complex issues may require multiple exchanges, but we'll keep you updated on progress throughout the resolution process.
Best Practices
✅ DO
Be specific - Include error messages, screenshots
One issue per ticket - Don't combine multiple problems
Choose correct priority - Be honest about urgency
Respond promptly - Reply to our questions quickly
Provide context - When did it start? What changed?
Be patient - Allow time for investigation
❌ DON'T
Create duplicate tickets - One ticket per issue
Mark everything urgent - Saves urgent for real emergencies
Leave out details - More info = faster resolution
Use inappropriate channels - Keep support in tickets
Get impatient - Quality takes time
Close tickets too early - Make sure it's really fixed
Good Ticket Examples
🎯 GOOD Example
Subject: Cannot complete survey ID #12345 - browser crashes
Priority: Medium
Description: "Hi, I'm trying to complete survey #12345 'Shopping Preferences' but on question 8 (the one about brands), my browser (Chrome v91 on Windows 10) crashes and closes. This has happened 3 times now. I've tried clearing my cache and using incognito mode, but same issue. I need to complete this survey by Friday to get the reward. Screenshots attached."
Why this is good: Specific survey ID, exact problem description, browser details, steps already tried, deadline mentioned, screenshots included.
❌ POOR Example
Subject: Survey not working
Priority: Urgent
Description: "Your surveys don't work. Fix it."
Why this is poor: No specific details, wrong priority level, no context, rude tone, impossible to diagnose.
Frequently Asked Questions
Q: Can I reply to a resolved ticket?
A: Yes! If the solution didn't work or you have follow-up questions, just reply to the resolved ticket. We'll reopen it and continue helping.
Q: What happens if I don't respond to a pending ticket?
A: We'll wait 7 days for your response. After that, we'll send a reminder. If there's no response after 14 days, we'll mark it as resolved.
Q: Can I change the priority of my ticket?
A: You can mention in a reply if urgency has changed, but our support team manages priority levels based on actual impact and urgency.
Q: How do I know when you reply to my ticket?
A: You'll receive an email notification and can also check your dashboard support section for updates.
Q: Can I call for support instead?
A: We primarily use tickets to ensure nothing gets lost and maintain quality records. For complex issues, our team may schedule a call as part of the resolution process.
-------------------- END OF FILE --------------------
### FILE 29: update-ticket-status.php
- Type: PHP
- Size: 2.93 KB
- Path: .
- Name: update-ticket-status.php
------------------------------------------------------------
isLoggedIn()) {
throw new Exception('Admin authentication required');
}
// Only handle POST requests
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
throw new Exception('Only POST requests allowed');
}
$admin = $auth->getCurrentAdmin();
$ticketId = isset($_POST['ticket_id']) ? intval($_POST['ticket_id']) : 0;
$status = isset($_POST['status']) ? trim($_POST['status']) : '';
// Validate input
if ($ticketId <= 0) {
throw new Exception('Invalid ticket ID');
}
if (empty($status)) {
throw new Exception('Status is required');
}
$validStatuses = ['open', 'pending', 'resolved', 'closed'];
if (!in_array($status, $validStatuses)) {
throw new Exception('Invalid status. Must be: ' . implode(', ', $validStatuses));
}
// Database update
$db = new Database();
$pdo = $db->getConnection();
// Get current ticket info
$stmt = $pdo->prepare("SELECT id, ticket_number, status FROM support_tickets WHERE id = ?");
$stmt->execute([$ticketId]);
$ticket = $stmt->fetch();
if (!$ticket) {
throw new Exception('Ticket not found');
}
// Update status
$stmt = $pdo->prepare("
UPDATE support_tickets
SET status = ?,
resolved_at = CASE WHEN ? = 'resolved' THEN NOW() ELSE resolved_at END,
updated_at = NOW()
WHERE id = ?
");
$result = $stmt->execute([$status, $status, $ticketId]);
if (!$result || $stmt->rowCount() === 0) {
throw new Exception('Failed to update ticket status');
}
// Log the success
logError('Ticket status updated successfully', [
'ticket_id' => $ticketId,
'ticket_number' => $ticket['ticket_number'],
'old_status' => $ticket['status'],
'new_status' => $status,
'admin_id' => $admin['id'],
'admin_username' => $admin['username']
]);
// Return success
echo json_encode([
'success' => true,
'message' => 'Status updated successfully',
'ticket_id' => $ticketId,
'ticket_number' => $ticket['ticket_number'],
'old_status' => $ticket['status'],
'new_status' => $status,
'updated_by' => $admin['full_name']
]);
} catch (Exception $e) {
// Return error
echo json_encode([
'success' => false,
'message' => $e->getMessage(),
'debug_info' => [
'ticket_id' => $ticketId ?? 'not_provided',
'status' => $status ?? 'not_provided',
'admin_logged_in' => $auth->isLoggedIn(),
'request_method' => $_SERVER['REQUEST_METHOD']
]
]);
}
?>
-------------------- END OF FILE --------------------
### FILE 30: user-support.php
- Type: PHP
- Size: 25.41 KB
- Path: .
- Name: user-support.php
------------------------------------------------------------
redirectToLogin('Session expired. Please log in again.');
}
// Initialize database
try {
$db = new Database();
$pdo = $db->getConnection();
} catch (Exception $e) {
logError('Database connection failed in user-support.php: ' . $e->getMessage());
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
jsonResponse(false, 'System error. Please try again later.');
} else {
die('System error. Please try again later.');
}
}
// Handle POST request - Create new ticket
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !isset($_GET['ticket'])) {
$subject = isset($_POST['subject']) ? sanitize($_POST['subject']) : '';
$message = isset($_POST['message']) ? trim($_POST['message']) : '';
$priority = isset($_POST['priority']) ? sanitize($_POST['priority']) : 'medium';
// Validation
if (empty($subject) || empty($message)) {
jsonResponse(false, 'Subject and message are required.');
}
if (strlen($subject) > 255) {
jsonResponse(false, 'Subject must be 255 characters or less.');
}
if (strlen($message) > 5000) {
jsonResponse(false, 'Message must be 5000 characters or less.');
}
if (!in_array($priority, ['low', 'medium', 'high', 'urgent'])) {
$priority = 'medium';
}
try {
$pdo->beginTransaction();
// Generate unique ticket number
$ticketNumber = 'TKT-' . date('Ymd') . '-' . strtoupper(substr(uniqid(), -4));
// Check if ticket number already exists (very unlikely but let's be safe)
$stmt = $pdo->prepare("SELECT id FROM support_tickets WHERE ticket_number = ?");
$stmt->execute([$ticketNumber]);
if ($stmt->fetch()) {
// Generate a new one if it exists
$ticketNumber = 'TKT-' . date('Ymd') . '-' . strtoupper(substr(uniqid(), -6));
}
// Insert support ticket
$stmt = $pdo->prepare("
INSERT INTO support_tickets (ticket_number, user_id, subject, status, priority)
VALUES (?, ?, ?, 'open', ?)
");
$stmt->execute([$ticketNumber, $user['id'], $subject, $priority]);
$ticketId = $pdo->lastInsertId();
// Insert initial message
$stmt = $pdo->prepare("
INSERT INTO support_messages (ticket_id, sender_type, sender_id, message)
VALUES (?, 'user', ?, ?)
");
$stmt->execute([$ticketId, $user['id'], $message]);
$pdo->commit();
logError('Support ticket created', [
'ticket_number' => $ticketNumber,
'user_id' => $user['id'],
'subject' => $subject,
'priority' => $priority
]);
jsonResponse(true, 'Support ticket created successfully.', ['ticket_number' => $ticketNumber]);
} catch (Exception $e) {
$pdo->rollBack();
logError('Error creating support ticket', ['user_id' => $user['id'], 'error' => $e->getMessage()]);
jsonResponse(false, 'Failed to create support ticket. Please try again.');
}
}
// Handle GET request - View specific ticket
if (isset($_GET['ticket'])) {
$ticketNumber = sanitize($_GET['ticket']);
try {
// Get ticket details
$stmt = $pdo->prepare("
SELECT st.*, au.full_name as assigned_to_name
FROM support_tickets st
LEFT JOIN admin_users au ON st.assigned_to = au.id
WHERE st.ticket_number = ? AND st.user_id = ?
");
$stmt->execute([$ticketNumber, $user['id']]);
$ticket = $stmt->fetch();
if (!$ticket) {
header('Location: dashboard.php#support');
exit;
}
// Get all messages for this ticket
$stmt = $pdo->prepare("
SELECT sm.*,
CASE
WHEN sm.sender_type = 'user' THEN u.email
WHEN sm.sender_type = 'admin' THEN au.full_name
END as sender_name
FROM support_messages sm
LEFT JOIN users u ON sm.sender_type = 'user' AND sm.sender_id = u.id
LEFT JOIN admin_users au ON sm.sender_type = 'admin' AND sm.sender_id = au.id
WHERE sm.ticket_id = ? AND sm.is_internal = 0
ORDER BY sm.created_at ASC
");
$stmt->execute([$ticket['id']]);
$messages = $stmt->fetchAll();
} catch (Exception $e) {
logError('Error fetching ticket details', ['ticket_number' => $ticketNumber, 'error' => $e->getMessage()]);
header('Location: dashboard.php#support');
exit;
}
}
// Handle POST request for adding reply to existing ticket
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_GET['ticket'])) {
$ticketNumber = sanitize($_GET['ticket']);
$message = isset($_POST['reply']) ? trim($_POST['reply']) : '';
if (empty($message)) {
jsonResponse(false, 'Reply message is required.');
}
if (strlen($message) > 5000) {
jsonResponse(false, 'Reply must be 5000 characters or less.');
}
try {
// Verify ticket belongs to user and is not closed
$stmt = $pdo->prepare("SELECT id, status FROM support_tickets WHERE ticket_number = ? AND user_id = ?");
$stmt->execute([$ticketNumber, $user['id']]);
$ticket = $stmt->fetch();
if (!$ticket) {
jsonResponse(false, 'Ticket not found.');
}
if ($ticket['status'] === 'closed') {
jsonResponse(false, 'Cannot reply to a closed ticket.');
}
// Insert reply
$stmt = $pdo->prepare("
INSERT INTO support_messages (ticket_id, sender_type, sender_id, message)
VALUES (?, 'user', ?, ?)
");
$stmt->execute([$ticket['id'], $user['id'], $message]);
// Update ticket status to 'open' if it was 'resolved'
if ($ticket['status'] === 'resolved') {
$stmt = $pdo->prepare("UPDATE support_tickets SET status = 'open', updated_at = NOW() WHERE id = ?");
$stmt->execute([$ticket['id']]);
}
logError('Support ticket reply added', [
'ticket_number' => $ticketNumber,
'user_id' => $user['id']
]);
jsonResponse(true, 'Reply added successfully.');
} catch (Exception $e) {
logError('Error adding ticket reply', ['ticket_number' => $ticketNumber, 'error' => $e->getMessage()]);
jsonResponse(false, 'Failed to add reply. Please try again.');
}
}
// If we're here, it means we're displaying a specific ticket or the form
?>
<?php echo isset($ticket) ? 'Support Ticket #' . htmlspecialchars($ticket['ticket_number']) : 'Create Support Ticket'; ?> - Relevant Reflex
Ticket #
Status:
Priority:
Created:
Assigned to:
You
(Support Team)
Add Reply
This ticket has been closed. If you need further assistance, please create a new ticket.
Create Support Ticket
Tell us how we can help you. Our support team will respond as soon as possible.
Response Times
Low: 2-3 business days
Medium: 1-2 business days
High: 4-8 hours
Urgent: 1-2 hours
Alternative Contact
For urgent matters, you can also email us directly:
support@relevantreflex.com
Success!
-------------------- END OF FILE --------------------
### FILE 31: verify.php
- Type: PHP
- Size: 11.35 KB
- Path: .
- Name: verify.php
------------------------------------------------------------
getConnection();
// Start transaction
$pdo->beginTransaction();
// Find the verification token
$stmt = $pdo->prepare("
SELECT ev.user_id, ev.expires_at, u.email, u.email_verified
FROM email_verifications ev
JOIN users u ON ev.user_id = u.id
WHERE ev.token = ?
AND ev.expires_at > NOW()
");
$stmt->execute([$token]);
$verification = $stmt->fetch();
if (!$verification) {
// Check if token exists but is expired
$stmt = $pdo->prepare("
SELECT ev.expires_at, u.email
FROM email_verifications ev
JOIN users u ON ev.user_id = u.id
WHERE ev.token = ?
");
$stmt->execute([$token]);
$expiredToken = $stmt->fetch();
if ($expiredToken) {
showVerificationPage(false, 'Verification Link Expired', 'This verification link has expired. Please register again to receive a new verification email.');
} else {
showVerificationPage(false, 'Invalid Verification Link', 'This verification link is invalid or has already been used. If you need a new verification email, please register again.');
}
}
// Check if email is already verified
if ($verification['email_verified']) {
showVerificationPage(true, 'Email Already Verified', 'Your email has already been verified. You can now log in to your account.');
}
// Update user status
$stmt = $pdo->prepare("
UPDATE users
SET email_verified = 1, status = 'active', updated_at = NOW()
WHERE id = ?
");
$stmt->execute([$verification['user_id']]);
// Delete used verification token
$stmt = $pdo->prepare("DELETE FROM email_verifications WHERE token = ?");
$stmt->execute([$token]);
// Commit transaction
$pdo->commit();
// Log successful verification
logError('Email verification successful', [
'user_id' => $verification['user_id'],
'email' => $verification['email']
]);
showVerificationPage(true, 'Email Verified Successfully!', 'Your email has been verified successfully. Your account is now active and you can start taking surveys.');
} catch (PDOException $e) {
// Rollback transaction on error
if ($pdo->inTransaction()) {
$pdo->rollback();
}
logError('Database error during email verification', [
'error' => $e->getMessage(),
'token' => substr($token, 0, 10) . '...' // Log partial token for debugging
]);
showVerificationPage(false, 'Verification Failed', 'We encountered a system error while verifying your email. Please try again later or contact support.');
} catch (Exception $e) {
// Rollback transaction on error
if ($pdo->inTransaction()) {
$pdo->rollback();
}
logError('General error during email verification', [
'error' => $e->getMessage(),
'token' => substr($token, 0, 10) . '...'
]);
showVerificationPage(false, 'Verification Failed', 'An unexpected error occurred. Please try again later or contact support.');
}
function showVerificationPage($success, $title, $message) {
$statusClass = $success ? 'success' : 'error';
$statusColor = $success ? '#28a745' : '#dc3545';
$iconClass = $success ? 'fa-check-circle' : 'fa-exclamation-triangle';
?>
<?php echo htmlspecialchars($title); ?> - Relevant Reflex
