Block("DATA"); $now_date = date("Y-m-d"); $sql = "SELECT $db_table_trainer_article.*,$db_table_trainer_article_stats.TOTAL_REPLY,$db_table_trainer_article_stats.TOTAL_VIEW FROM $db_table_trainer_article LEFT JOIN $db_table_trainer_article_stats ON ($db_table_trainer_article.ARTICLE_ID = $db_table_trainer_article_stats.ARTICLE_ID) $other_sql ORDER BY $order_by limit $start_loop,$cfg_list_per_page"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $article_id = $row[ARTICLE_ID]; $sql2 = "SELECT USERNAME FROM $db_table_trainer WHERE ID = '$row[TRAINER_ID]'"; $result2 = mysql_query($sql2); while($row2 = mysql_fetch_array($result2)) { $name_show = "$row2[USERNAME]"; } mysql_free_result($result2); $last_update = ""; $sql2 = "SELECT DATE_ADD FROM $db_table_comment WHERE (CATEGORY = 'article' AND CONTENT_ID = '$article_id') ORDER BY DATE_ADD DESC LIMIT 0,1"; $result2 = mysql_query($sql2); while($row2 = mysql_fetch_array($result2)) { $last_update = Convert_YMDHMS_2_DMYHM_Name($row2[DATE_ADD]); } mysql_free_result($result2); if ($bgcolor == "#F9F9F9") { $bgcolor = "#FFFFF9"; } else { $bgcolor = "#F9F9F9"; } $allow_view = ""; if ($row[ALLOW_VIEW] == "member") { $allow_view = ""; } $icon_hot = ""; if ($row[TOTAL_VIEW] > $cfg_int_content_hot) { $icon_hot = ""; } $icon_new = ""; if (DateDiff($row[DATE_ADD],$now_date) < $cfg_int_content_new) { $icon_new = ""; } $article_privilege = $row["ARTICLE_PRIVILEGE"]; $article_extra = $row["ARTICLE_EXTRA"]; $icon_extra = ""; $arr_icon_extra = preg_split ("/,/",$article_privilege . $article_extra, -1, PREG_SPLIT_NO_EMPTY); foreach ($arr_icon_extra as $strTemp) { $icon_extra .= " "; } # Rating $rating_show = ""; $sql2 = "SELECT * FROM $db_table_trainer_article_stats WHERE ARTICLE_ID = '$article_id' LIMIT 0,1"; $result2 = mysql_query($sql2); while($row2 = mysql_fetch_array($result2)) { $total_view = $row2[TOTAL_VIEW]; $poll_Y = $row2[POLL_Y]; $poll_N = $row2[POLL_N]; } mysql_free_result($result2); $total_poll = $poll_Y + $poll_N; $poll_percent_Y = 0; $poll_percent_N = 0; if ($poll_Y > 0) { $poll_percent_Y = round(sprintf ("%.02f",(100 / $total_poll) * $poll_Y)); } if ($poll_N > 0) { $poll_percent_N = round(sprintf ("%.02f",(100 / $total_poll) * $poll_N)); } $rating_show = << $poll_percent_Y%  $poll_percent_N%  SiXhEaD; # /Rating $data = array( 'bgcolor' => $bgcolor, 'article_id' => $article_id, 'article_topic' => $row[ARTICLE_TOPIC], 'name_show' => $name_show, 'allow_view' => $allow_view, 'total_reply' => $row[TOTAL_REPLY], 'total_view' => $row[TOTAL_VIEW], 'last_update' => $last_update, 'icon_hot' => $icon_hot, 'icon_new' => $icon_new, 'icon_extra' => $icon_extra, 'rating_show' => $rating_show, ); $tp->Apply($data); } mysql_free_result($result); if ($trainer_id) { $sql = "SELECT * FROM $db_table_trainer WHERE ID = $trainer_id"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $fname = $row[FNAME]; $lname = $row[LNAME]; $category_name = "บทความโดย $fname $lname"; } mysql_free_result($result); } else { $sql = "SELECT * FROM $db_table_trainer_article_category WHERE CATEGORY_ID = '$category_id'"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $category_name = $row[CATEGORY_NAME]; } mysql_free_result($result); } mysql_close($db); # /Split Page $select_sort = " "; $select_sort = preg_replace("/&sort=$sort'/", "&sort=$sort'selected", $select_sort); $tp->Mix(); $HTML = $tp->Data(); $HTML = preg_replace("/\\$(\w+)/e","$$1",$HTML); echo $HTML; exit; ob_end_flush(); #### end of program #### ##################################################################### #### Start sub program. Don't touch anything below #### ?>