/******************************************************************************
DSB: Dating Site Builder
===============================================================================
File: qa.php
File Version: 2.0
Software by: Etown21 (http://www.etown21.com)
Copyright by: Etown21 (http://www.etown21.com)
Support at: http://www.etown21.com/forum
*******************************************************************************
* See the "softwarelicense.txt" file for details of the DSB license. *
******************************************************************************/
session_cache_limiter('nocache');
session_start();
require_once("includes/templates.inc.php");
require_once("includes/site_functions.inc.php");
require_once("includes/vars.inc.php");
db_connect(_DBHOSTNAME_,_DBUSERNAME_,_DBPASSWORD_,_DBNAME_,_PCONN_);
check_login_member($access_matrix['qa'][0]);
set_location($_messages['core'][172]);
if (isset($_SESSION['topass']) && !empty($_SESSION['topass'])) {
$topass=$_SESSION['topass'];
$_SESSION['topass']="";
}
$message=((isset($topass['message'])) ? ($topass['message']) : (""));
$tpl=new phemplate(_TPLPATH_.get_my_template().'/','remove_nonjs');
$nextlink="";
$prevlink="";
$question="";
$answer="";
$name="";
$message="";
$error=false;
if (isset($_GET['qa_id']) && !empty($_GET['qa_id'])) {
$qa_id=$_GET['qa_id'];
}
$query="SELECT min(qa_id),max(qa_id) FROM qa a WHERE question<>'' AND answer<>''";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
if (mysql_num_rows($res)) {
list($min_id,$max_id)=mysql_fetch_row($res);
} else {
$error=true;
$message=$_messages['core'][173];
}
if (!$error) {
if (!isset($qa_id) && empty($qa_id)) {
$qa_id=$min_id;
}
if ($qa_id<$max_id) {
$query="SELECT min(qa_id) FROM qa a WHERE qa_id>'$qa_id' AND question<>'' AND answer<>''";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
if (mysql_num_rows($res)) {
$nextlink="".$_messages['core'][174]."";
}
}
if ($qa_id>$min_id) {
$query="SELECT max(qa_id) FROM qa a WHERE qa_id<'$qa_id' AND question<>'' AND answer<>''";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
if (mysql_num_rows($res)) {
$prevlink="".$_messages['core'][175]."";
}
}
$query="SELECT a.question,a.answer,b.name FROM qa a LEFT JOIN user_details b ON a.fk_user_id=b.fk_user_id WHERE a.qa_id='$qa_id'";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
if (mysql_num_rows($res)) {
list($question,$answer,$name)=mysql_fetch_row($res);
}
if (empty($name)) {
$name=$_messages['core'][61];
}
}
$tpl->set_file('middlecontent','qa.html');
$tpl->set_var('question',$question);
$tpl->set_var('answer',$answer);
$tpl->set_var('name',htmlentities(stripslashes($name)));
$tpl->set_var('prevlink',$prevlink);
$tpl->set_var('nextlink',$nextlink);
$middle_content=$tpl->process('','middlecontent',TPL_FINISH | TPL_INCLUDE);
$title=$_messages['core'][176];
include('content_left.php');
include('content_right.php');
include('content_frame.php');
?>