<?php
function bb_get_list_thread_reactions()
{
//Ki?m tra Cookie, n?u ko ??ng nh?p thì tr? v? false
$cookie_username=isset(Configs::$_['user_data']['user_id'])?Configs::$_['user_data']['user_id']:'';
if(Configs::$_['user_data']['user_id']=='GUEST')
{
echo responseData('{}','no');die();
}
$thread_id=addslashes(getPost('thread_id',''));
if(!isset($thread_id[4]))
{
echo responseData('{}','no');die();
}
$queryStr='';
$queryStr.="select a.*,c.username,b.image_path,b.title as reaction_title,b.text_color as reaction_color from bb_post_reactions_data as a join bb_reaction_data as b ON a.reaction_id=b.reaction_id ";
$queryStr.=" join user_mst as c ON a.user_id=c.user_id ";
$queryStr.=" where a.type='thread' AND a.post_id='".$thread_id."' ";
$queryStr.=" order by a.ent_dt desc";
$db=new Database();
$result=$db->query($queryStr);
echo responseData($result,'no');die();
}
|