$sqlCommentCount = "SELECT COUNT(*) AS c FROM commentForm WHERE forumSn = '{$forumSn}'";
$resultCommentCount = mysql_query($sqlCommentCount, $dbLink);
$rowCommentCount = mysql_fetch_array($resultCommentCount);
$commentCount = $rowCommentCount[c];
echo "<div style=\"padding:0 20px 0 20px;\">";
//echo "<div id = commentCount>CommentCount: ".$commentCount."</div>";
echo "<div class=\"comment_article\" id=\"comment_{$forumSn}\">";
$comment_flag = 0;
$sqlCF = "SELECT sn, message, accountSn, createTimeSec FROM commentForm WHERE forumSn = '{$forumSn}'";
$resultCF = mysql_query($sqlCF, $dbLink);
while ($rowCF = mysql_fetch_array($resultCF)) {
$cfSn = $rowCF[sn];
$cfMessage = $rowCF[message];
$cfAccountSn = $rowCF[accountSn];
$cfAccountType = GtAccount_GetType($cfAccountSn);
$cfCreateDate = GtTime_GetDateTime2(GtTime_ConvertToBrowserTimeSec($rowCF[createTimeSec]));
$comment_flag++;
if ($cfAccountType == $GT_ACCOUNT_TYPE_FACEBOOK_USER) {
$sqlAccount = "SELECT fbPictureUrl FROM account WHERE sn = '{$cfAccountSn}'";
$resultAccount = mysql_query($sqlAccount, $dbLink);
$rowAccount = mysql_fetch_array($resultAccount);
$accFbPictureUrl = $rowAccount[fbPictureUrl];
$pictureUrl = $accFbPictureUrl;
} else {
$sqlFile = "SELECT sn FROM file WHERE accountSn = '{$cfAccountSn}'";
$resultFile = mysql_query($sqlFile, $dbLink);
$rowFile = mysql_fetch_array($resultFile);
$fileSn = $rowFile[sn];
$pictureUrl = "/api/file/download_photo?sn={$fileSn}";
}
echo "<div id=\"comment_info_{$forumSn}\" class=\"comment_info\" onmousemove=\"ShowDeleteBt({$cfSn}, {$cfAccountSn})\" onmouseout=\"HideDeleteBt({$cfSn})\">";
function userComment($sn, $forumSn)
{
?>
<div class="comment_article" id="comment_<?php
echo $sn;
?>
">
<?php
$sqlCF = "SELECT sn, message, accountSn, createTimeSec FROM commentForm WHERE forumSn = '{$forumSn}'";
//echo $sqlCF."@@".getenv("DOCUMENT_ROOT");
$resultCF = mysql_query($sqlCF, $dbLink);
while ($rowCF = mysql_fetch_array($resultCF)) {
$cfSn = $rowCF[sn];
$cfMessage = $rowCF[message];
$cfAccountSn = $rowCF[accountSn];
$cfAccountType = GtAccount_GetType($cfAccountSn);
$cfCreateDate = GtTime_GetDateTime2(GtTime_ConvertToBrowserTimeSec($rowCF[createTimeSec]));
if ($cfMessageAccountType == $GT_ACCOUNT_TYPE_FACEBOOK_USER) {
$sqlAccount = "SELECT fbPictureUrl FROM account WHERE sn = '{$cfAccountSn}'";
$resultAccount = mysql_query($sqlAccount, $dbLink);
$rowAccount = mysql_fetch_arrayrray($resultAccount);
$accFbPictureUrl = $rowAccount[fbPictureUrl];
$pictureUrl = $accFbPictureUrl;
} else {
$sqlFile = "SELECT sn FROM file WHERE accountSn = '{$cfAccountSn}'";
$resultFile = mysql_queryry($sqlFile, $dbLink);
$rowFile = mysql_fetch_array($resultFile);
$fileSn = $rowFile[sn];
$pictureUrl = "/api/file/download_photo?sn=api{$fileSn}";
}
?>
<div id="comment_info_<?php
echo $sn;
?>
" class="comment_info" onmousemove="ShowDeleteBt(<?php
echo $cfSn;
?>
, <?php
echo $cfAccountSn;
?>
)" onmouseout="HideDeleteBt(<?php
echo $cfSn;
?>
)">
</div><!--comment_info-->
<?php
}
?>
<div class="comment_info">
<div class="comment_img">
<?php
if ($accountType == $GT_ACCOUNT_TYPE_FACEBOOK_USER) {
$sqlAccount = "SELECT fbPictureUrl FROM account WHERE sn = '{$sn}'";
$resultAccount = mysql_query($sqlAccount, $dbLink);
$rowAccount = mysql_fetch_array($resultAccount);
$accFbPictureUrl = $rowAccount[fbPictureUrl];
echo "<img src=\"{$accFbPictureUrl}\" width=\"32\" height=\"32\">";
} else {
$sqlFile = "SELECT sn FROM file WHERE accountSn = '{$sn}'";
$resultFile = mysql_query($sqlFile, $dbLink);
$rowFile = mysql_fetch_array($resultFile);
$fileSn = $rowFile[sn];
if ($fileSn > 0) {
echo "<img src=\"/api/file/download_photo?sn={$fileSn}\" widthth=\"32\" height=\"32\">";
} else {
if (GtAccount_GetGender($accountPicntSn) == 1) {
echo "<img src=\"/image/user_profile_man.jpeg\" widthth=\"32\" height=\"32\">";
} elseif (GtAccount_GetGender($accountSn) == 2) {
echo "<img src=\"/image/user_profile_women.jpeg\" width=\"32\" height=\"32\">";
} else {
echo "<img src=\"/image/user_profile_womene_man.jpeg\" width=\"32\" height=\"32\">";
}
}
}
?>
</div>
</div><!--comment_article-->
<?php
}
