';
echo $category;
echo '
'.$title.'
'; if ($id_blog_user > 0) { $sql = 'select screen_name '; $sql .= ' from blog_mas_user '; $sql .= ' where id_user = '.$id_blog_user; $sql_result2 = mysql($database_name,$sql); if (mysql_num_rows($sql_result2) > 0) echo '( By: '.mysql_result($sql_result2, 0, 'screen_name' ).' )
'; } echo '';
echo '
';
echo '
';
echo ''.nl2br($text_intro).'
';
if (strlen($photo) > 0)
echo ''.nl2br($text_main).'
( '.date("l dS F Y", $date_publish).' )
'; if (( $id_blog_user > 0) && ($id_blog_user == $_COOKIE['c_id_user'])) echo ' [ EDIT ]'; } } else echo 'RECORD NOT FOUND'; echo ''; //record hit if ($_GET['prev'] != 'on') { $sql = 'update blog_mas_discus'; $sql .= ' set stat_hits = stat_hits + 1 '; $sql .= ' where s_ind_state = 1'; $sql .= ' and id_discus = '.intval( $_GET['idx']); mysql($database_name,$sql); } if ($yn_discus) { echo 'DISCUSS
';
echo html_comments();
}
function html_comments()
{
global $database_name;
$sql = 'select c.id_comment, c.memo_comment, UNIX_TIMESTAMP(c.datetime_of_record) as date_publish ';
$sql .= ' ,u.screen_name, u.town, u.ind_coutry ';
$sql .= ' from blog_coment c, blog_mas_user u ';
$sql .= ' where c.ind_state <= 2';
$sql .= ' and c.yn_approved = 1';
$sql .= ' and c.id_discus = '.intval( $_GET['idx']);
$sql .= ' and c.id_user = u.id_user';
$sql .= ' order by id_comment ';
// $sql .= ' limit 7';
$sql_result = mysql($database_name,$sql);
for ($i=0; $i < mysql_num_rows($sql_result); $i++){
$id_comment = mysql_result($sql_result, $i, 'id_comment' );
$memo_comment = mysql_result($sql_result, $i, 'memo_comment' );
$screen_name = mysql_result($sql_result, $i, 'screen_name' );
$town = mysql_result($sql_result, $i, 'town' );
$date_publish = mysql_result($sql_result, $i, 'date_publish' );
echo ''.$screen_name.' says:
'; echo nl2br( htmlentities($memo_comment)); echo '( '.date("l dS F Y", $date_publish).' ) [ #'.($i+1).' ]
'; } } function html_article_preview( $id_discus, $title) { return ' '.$title.' '; } ?>