// *******************************************************************
// admin/reviews.php
// *******************************************************************
include("../include/config.php");
include("../include/functions.php");
include("../include/common.php");
$language = $gl["Language"];
include("../include/lang/$language.php");
include("../include/session.php");
session_start();
?>
=$adm_body?>
if(isset($validate_review) && isset($ID)){
if($action=="validate"){
$update = sql_query("
update
$tb_reviews
set
Status='Show',
ReviewTitle='$ReviewTitle',
Review='$Review',
Reviewer='$Reviewer',
ReviewerURL='$ReviewerURL',
ReviewerEmail='$ReviewerEmail'
where
ID='$ID'
");
}
if($action=="hide"){
$update = sql_query("
update
$tb_reviews
set
Status='Hide',
ReviewTitle='$ReviewTitle',
Review='$Review',
Reviewer='$Reviewer',
ReviewerURL='$ReviewerURL',
ReviewerEmail='$ReviewerEmail'
where
ID='$ID'
");
}
if($action == "delete"){
$update = sql_query("
delete from
$tb_reviews
where
ID='$ID'
");
}
?>
}
if(isset($ID) && !isset($validate_review)){
$get_review = sql_query("
select
*
from
$tb_reviews
where
ID='$ID'
");
$rows = sql_fetch_array($get_review);
?>
}
if(
!isset($ID) &&
!isset($validate_review) &&
!isset($SiteID)
){
?>
$get_reviews = sql_query("
select
*
from
$tb_reviews
where
Status='New'
");
if(sql_num_rows($get_reviews)>0){
while($rows = sql_fetch_array($get_reviews)){
?>
$gsn = sql_query("
select
SiteName
from
$tb_links
where
ID='$rows[SiteID]'
");
$gsnr = sql_fetch_array($gsn);
echo $gsnr[SiteName];
?>
=$rows[ReviewTitle]?>
Validate
}
} else {
?>
Sorry, no site reviews to validate. Go Back
}
?>
}
if(isset($SiteID)){
?>
$get_reviews = sql_query("
select
*
from
$tb_reviews
where
SiteID='$SiteID'
and
Status='Show'
or
Status='Hide'
");
if(sql_num_rows($get_reviews)>0){
while($rows = sql_fetch_array($get_reviews)){
?>
$gsn = sql_query("
select
SiteName
from
$tb_links
where
ID='$rows[SiteID]'
");
$gsnr = sql_fetch_array($gsn);
echo $gsnr[SiteName];
?>
=$rows[ReviewTitle]?>
=$rows[Status]?>
Validate
}
} else {
?>
Sorry, no site reviews for this site.
<-- Back
}
?>
}
?>