-
Notifications
You must be signed in to change notification settings - Fork 3
/
myreviews.php
105 lines (87 loc) · 3.96 KB
/
myreviews.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php
/*******************************************************************\
* CashbackEngine v2.1
* http://www.CashbackEngine.net
*
* Copyright (c) 2010-2014 CashbackEngine Software. All rights reserved.
* ------------ CashbackEngine IS NOT FREE SOFTWARE --------------
\*******************************************************************/
session_start();
require_once("inc/auth.inc.php");
require_once("inc/config.inc.php");
$retailer_id = (int)$_GET['id'];
if (isset($_GET['act']) && $_GET['act'] == "del")
{
$del_query = "DELETE FROM cashbackengine_reviews WHERE user_id='$userid' AND retailer_id='$retailer_id'";
if (smart_mysql_query($del_query))
{
header("Location: myreviews.php?msg=deleted");
exit();
}
}
$query = "SELECT cashbackengine_reviews.*, cashbackengine_retailers.* FROM cashbackengine_reviews cashbackengine_reviews, cashbackengine_retailers cashbackengine_retailers WHERE cashbackengine_reviews.user_id='$userid' AND cashbackengine_reviews.retailer_id=cashbackengine_retailers.retailer_id AND cashbackengine_retailers.status='active' ORDER BY cashbackengine_retailers.title ASC";
$result = smart_mysql_query($query);
$total = mysql_num_rows($result);
/////////////// Page config ///////////////
$PAGE_TITLE = CBE1_MYREVIEWS_TITLE;
require_once ("inc/header.inc.php");
?>
<h1><?php echo CBE1_MYREVIEWS_TITLE; ?></h1>
<?php if (isset($_GET['msg']) && $_GET['msg'] != "") { ?>
<div class="success_msg">
<?php
switch ($_GET['msg'])
{
case "deleted": echo CBE1_MYREVIEWS_DELETED; break;
}
?>
</div>
<?php } ?>
<table align="center" class="btb" width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<th width="40%"><?php echo CBE1_MYREVIEWS_STORE; ?></th>
<th width="10%"><?php echo CBE1_MYREVIEWS_RATING; ?></th>
<th width="15%"><?php echo CBE1_MYREVIEWS_DATE; ?></th>
<th width="10%"><?php echo CBE1_MYREVIEWS_STATUS; ?></th>
<th width="5%"></th>
</tr>
<?php
$cc = 0;
$query_reviews = "SELECT *, DATE_FORMAT(added, '%e %b %Y') AS date_added FROM cashbackengine_reviews WHERE user_id='$userid' ORDER BY added DESC";
$result_reviews = smart_mysql_query($query_reviews);
$total_reviews = mysql_num_rows($result_reviews);
if ($total_reviews > 0) {
?>
<p><?php echo CBE1_MYREVIEWS_TEXT; ?></p>
<?php while ($row_reviews = mysql_fetch_array($result_reviews)) { $cc++; ?>
<tr>
<td valign="middle" align="left"><a href="<?php echo GetRetailerLink($row_reviews['retailer_id'], GetStoreName($row_reviews['retailer_id'])); ?>"><?php echo GetStoreName($row_reviews['retailer_id']); ?></a></td>
<td valign="middle" align="center"><img src="<?php echo SITE_URL; ?>images/icons/rating-<?php echo $row_reviews['rating']; ?>.gif" /></td>
<td valign="middle" align="center"><?php echo $row_reviews['date_added']; ?></td>
<td valign="middle" align="center">
<?php
switch ($row_reviews['status'])
{
case "pending": echo "<span class='pending_s'>awaiting review</span>"; break;
case "active": echo "<span class='active_s'>".$row_reviews['status']."</span>"; break;
case "inactive": echo "<span class='inactive_s'>".$row_reviews['status']."</span>"; break;
default: echo "<span class='default_status'>".$row_reviews['status']."</span>"; break;
}
?>
</td>
<td valign="middle" align="center"><a href="#" onclick="if (confirm('<?php echo CBE1_MYREVIEWS_DELETE; ?>') )location.href='/myreviews.php?act=del&id=<?php echo $row_reviews['retailer_id']; ?>'" title="Delete"><img src="images/delete.gif" border="0" alt="Delete" /></a></td>
</tr>
<tr>
<td class="review_brd" colspan="5" align="left" valign="top">
<div class="myreview">
<b><?php echo $row_reviews['review_title']; ?></b>
<p><?php echo $row_reviews['review']; ?></p>
</div>
</td>
</tr>
<?php } ?>
<?php }else{ ?>
<tr height="30"><td colspan="5" align="center"><?php echo CBE1_MYREVIEWS_NO; ?></td></tr>
<?php } ?>
</table>
<?php require_once ("inc/footer.inc.php"); ?>