select(
array('db' => $config[txtSQL_dbname],
'table' => $qTable,
'where' => array("id = $wb_id") ));
$wb_category=$lista[0]["wb_category"];
$wb_id=$lista[0]["id"];
$wb_topic=$lista[0]["wb_topic"];
$wb_detail=$lista[0]["wb_detail"];
$wb_sender=$lista[0]["wb_sender"];
$wb_ismember=$lista[0]["wb_ismember"]; //ผู้ตั้งกระทู้เป็น member
$wb_email=$lista[0]["wb_email"];
$wb_visitor=$lista[0]["wb_visitor"];
$wb_picture=$lista[0]["wb_picture"];
$wb_picturestyle=$lista[0]["wb_picstyle"];
$wb_date=$lista[0]["wb_date"];
$wb_time=$lista[0]["wb_time"];
$wb_ip=$lista[0]["wb_ip"];
$wb_status=$lista[0]["wb_status"];
$answer[$ans] = sprintf("Q%04d",$wb_id)." - ".$wb_sender." [".$wb_date."]";
$answerid[$ans] = "Q".$wb_id;
$ans++;
//เปลี่ยน tag ให้เป็นคำที่ต้องการ ( < เปลี่ยนเป็น [ เพื่อนำไปใช้ในการตอบ)
$wb_detailForQuote=rewind_tag($wb_detail);
// ตรวจสอบรูปแบบการแสดง IP Address
switch ($config[showip]) {
case "ALL" : $wb_ip = $wb_ip; break;
case "BAN" : $wb_ip = substr($wb_ip,0,strrpos($wb_ip,".")).".*"; break;
case "NONE": $wb_ip = ""; break;
default : $wb_ip = $wb_ip;
}
if(strlen($wb_email)>1){
$is_sender="
$wb_sender $imgmember 
";
}
else{
$is_sender="
$wb_sender";
}
// อ่านข้อมูลจากตารางสมาชิกขึ้นมาแสดง
$imgmember="";
$member_OK=0;
if($wb_ismember==1){
$listmember= $sql->select(
array('db' => $config[txtSQL_dbname],
'table' => $config[txtSQL_tbmember],
'where' => array("member_user = $wb_sender") ));
if(sizeof($listmember)>=1){
$member_id=$listmember[0]["id"];
$mbNo = sprintf("%04d",$member_id);
$member_user=$listmember[0]["member_user"];
$member_alias=$listmember[0]["member_displayname"];
$member_sex=$listmember[0]["member_sex"];
$member_icq=$listmember[0]["member_icq"];
$member_email=$listmember[0]["member_email"];
$member_urlname=$listmember[0]["member_urlname"];
$member_url=$listmember[0]["member_url"];
$member_signature=$listmember[0]["member_signature"];
$member_post=$listmember[0]["member_post"];
$member_reply=$listmember[0]["member_reply"];
$member_status=$listmember[0]["member_status"];
if($member_sex=="M") $imgmember="
";
if($member_sex=="F") $imgmember="
";
$member_OK=1;
if(strlen($member_email)>1){
$is_sender="
$member_alias $imgmember ";
}
}
}
//กรอบสี่เหลี่ยมธรรมดา
echo "
";
echo "
\n";
echo "\n";
echo "| \n";
echo "$wb_topic | \n";
echo "";
echo " ";
echo " | ";
echo "";
if(substr($wb_picture,-3,3)=="swf"){ //ถ้ามีไฟล์ flash ให้แสดงด้วย
$size = getimagesize("$config[dataDir]/imagefiles/$wb_picture");
echo "";
echo " \n";
echo " ";
echo "  ดาวน์โหลดไฟล์ : $wb_picture ขนาด : ".sprintf("%.2f",$size)." KB \n";
echo " ";
echo "  \n";
echo "
";
if($member_OK && strlen($member_signature)>1) {
echo "
";
echo $member_signature;
}
echo " | | \n";
echo "\n";
echo "\n";
echo "\n";
echo " \n";
if($member_OK) {
echo " ";
if($member_url!="- - -") echo " ";
echo " (post: $member_post reply: $member_reply)";
}
echo " | \n";
echo "$is_sender $wb_ip [ $wb_date เวลา $wb_time ]";
if($wb_status!=2) echo " ตอบคำถามนี้ | \n";
echo " \n";
echo " \n";
echo " | |
\n";
echo "
\n";
if(!$visitOK){
$sql->update(
array('db' => $config[txtSQL_dbname],
'table' => $qTable,
'where' => array("id = ".$wb_id),
'values' => array('wb_visitor' => ($wb_visitor+1)) ));
}
echo "
"; //***************************************************************************************
// ลิสต์รายการคำตอบขึ้นมาแสดง
$lista=$sql->select(
array('db' => $config[txtSQL_dbname],
'table' => $rTable,
'where' => array("reply_questionno = $wb_id") ));
for($i=0; $i
select(
array('db' => $config[txtSQL_dbname],
'table' => $rTable,
'where' => array("id = $reply_answer") ));
$showanswer[0] = "R".$listanswer[0]["id"];
$showanswer[1] = sprintf("#%04d",$listanswer[0]["id"])." - " .$listanswer[0]["reply_sender"]." [".$listanswer[0]["reply_date"]."]";
}elseif(substr($reply_answer,0,1)=="Q"){
$reply_answer=substr($reply_answer,1);
$listanswer=$sql->select(
array('db' => $config[txtSQL_dbname],
'table' => $qTable,
'where' => array("id = $reply_answer") ));
$showanswer[0] = "Q".$listanswer[0]["id"];
$showanswer[1] = sprintf("Q%04d",$listanswer[0]["id"])." - " .$listanswer[0]["wb_sender"]." [".$listanswer[0]["wb_date"]."]";
}
//เปลี่ยน tag ให้เป็นคำที่ต้องการ ( < เปลี่ยนเป็น [ เพื่อนำไปใช้ในการตอบ)
$reply_detailForQuote=rewind_tag($reply_detail);
// ตรวจสอบรูปแบบการแสดง IP Address
switch ($config[showip]) {
case "ALL" : $reply_ip = $reply_ip; break;
case "BAN" : $reply_ip = substr($reply_ip,0,strrpos($reply_ip,".")).".*"; break;
case "NONE": $reply_ip = ""; break;
default : $reply_ip = $reply_ip;
}
if(strlen($reply_email)>1){
$is_reply="$reply_sender $imgmember ";
}
else{
$is_reply="$reply_sender";
}
// อ่านข้อมูลจากตารางสมาชิกขึ้นมาแสดง
$imgmember="";
$member_OK=0;
if($reply_ismember==1){
$listmember=$sql->select(
array('db' => $config[txtSQL_dbname],
'table' => $config[txtSQL_tbmember],
'where' => array("member_user = $reply_sender") ));
if(sizeof($listmember)>=1){
$member_id=$listmember[0]["id"];
$mbNo = sprintf("%04d",$member_id);
$member_user=$listmember[0]["member_user"];
$member_sex=$listmember[0]["member_sex"];
$member_alias=$listmember[0]["member_displayname"];
$member_icq=$listmember[0]["member_icq"];
$member_email=$listmember[0]["member_email"];
$member_urlname=$listmember[0]["member_urlname"];
$member_url=$listmember[0]["member_url"];
$member_signature=$listmember[0]["member_signature"];
$member_post=$listmember[0]["member_post"];
$member_reply=$listmember[0]["member_reply"];
$member_status=$listmember[0]["member_status"];
if($member_sex=="M") $imgmember="";
if($member_sex=="F") $imgmember="";
$member_OK=1;
if(strlen($member_email)>1){
$is_reply="$member_alias $imgmember ";
}
}
}
echo "";
echo "\n";
echo "\n";
echo "\n";
echo "| ตอบ : $showanswer[1] ";
echo " | \n";
echo "\n";
if(substr($reply_picture,-3,3)=="swf"){ //ถ้ามีไฟล์ flash ให้แสดงด้วย
$size = getimagesize("$config[dataDir]/imagefiles/$reply_picture");
echo "";
echo " \n";
echo " ";
echo " ดาวน์โหลดไฟล์ : $reply_picture ขนาด : ".sprintf("%.2f",$size)." KB \n";
echo " ";
echo "  ";
echo "
";
if($member_OK && strlen($member_signature)>1) {
echo "
";
echo $member_signature;
}
echo " | \n";
echo " \n";
echo "\n";
echo "| $is_reply $reply_ip [ $reply_date เวลา $reply_time ] ผู้ตอบที่ ".($i+1)."/#".sprintf("%04d",$reply_id);
if($wb_status!=2) echo " เขียนตอบคำตอบนี้";
echo " | \n\n";
if($member_OK) {
echo " ";
if($member_url!="- - -") echo " ";
}
echo " | \n";
echo " |
|
\n";
}
$sql->disconnect();
?>