// *******************************************************************
// include/review_add.php
// *******************************************************************
$html = $table2 . "
| " . $review_add_24;
$html .= " |
";
echo whattable("100%","center","",$html);
unset($html);
$get = sql_query("
select
*
from
$tb_links
where
ID='$SiteID'
");
$get_rows = sql_fetch_array($get);
if(!isset($submit_review)){
$html = $table2 . "";
$html .= " " . $review_add_23;
$html .= " " . $get_rows[SiteName] . " |
";
}
echo table("100%","center","",$html);
unset($html);
if(isset($submit_review)){
unset($error);
$get_specs = sql_query("
select
*
from
$tb_specs
where
ID='1'
");
$spec = sql_fetch_array($get_specs);
if(strlen($ReviewTitle) > $spec["ReviewTitleMax"]){
$error = 1;
$review_title_error = 1;
}
if(strlen($ReviewTitle) < $spec["ReviewTitleMin"]){
$error = 1;
$review_title_error = 1;
}
if(strlen($Reviewer) > $spec["ReviewerMax"]){
$error = 1;
$reviewer_error = 1;
}
if(strlen($Reviewer) < $spec["ReviewerMin"]){
$error = 1;
$reviewer_error = 1;
}
if(strlen($Review) < $spec["ReviewMin"]){
$error = 1;
$review_error = 1;
}
if(strlen($Review) > $spec["ReviewMax"]){
$error = 1;
$review_error = 1;
}
if(!ereg($spec["ReviewerEmailSpec"], $ReviewerEmail)){
$error = 1;
$reviewer_email_error = 1;
}
if(!isset($error)){
$insert = sql_query("
insert into $tb_reviews (
ID,
SiteID,
ReviewTitle,
Review,
Reviewer,
ReviewerEmail,
ReviewerURL,
Rating,
Status,
Added
) values (
'',
'$SiteID',
'$ReviewTitle',
'$Review',
'$Reviewer',
'$ReviewerEmail',
'$ReviewerURL',
'$Rating',
'New',
now()
)
");
$html = $table2 . " " . $review_add_1;
$html .= "
" . $review_add_2 . stripslashes($ReviewTitle);
$html .= "
" . $review_add_3 . $Reviewer;
$html .= "
" . $review_add_4 . stripslashes($Review);
$html .= "
" . $review_add_5 . $Rating;
$html .= "
" . $review_add_6 . $ReviewerEmail;
$html .= "
|
";
} else {
$html = $table2 . "";
$html .= " ";
$html .= $review_add_7 . "
|
";
}
}
echo table("98%","center","",$html);
unset($html);
if(!isset($submit_review) || isset($error)){
$html = "";
}
echo table("100%","center","",$html);
unset($html);
?>