web4ik

function imageLoaded(field_id, data){
   var txtarea = document.getElementById(field_id);
   var txtval = txtarea.value;
   var pos = getCaretPos(txtarea);
   txtarea.value = txtval.substring(0,pos) + ' [IMG]'+data+'[/IMG] ' + txtval.substring(pos,txtval.length);
   return;
}

 
   var txtval = txtarea.value;
 

         $sql = "SELECT r.*,
			 u.nickname as nickname,
			 u.login as login,c.id as cid					
 
                 FROM cms_ratings r
                                LEFT JOIN cms_comments c ON c.target_id=$target_id AND r.item_id=c.id
				LEFT JOIN cms_users u ON u.id = r.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                         WHERE item_id=$id ";

 $sql = "SELECT r.*,
			 u.nickname as nickname,
			 u.login as login,c.id as cid					
 
                FROM cms_ratings r
                LEFT JOIN cms_users c ON item_id=$target_id AND r.item_id=c.id
				LEFT JOIN cms_users u ON u.id = r.user_id
 
                         WHERE target = 'comment' AND item_id=$id LIMIT 20";

 
Код PHP:
        $sql = "SELECT r.*,
			 u.nickname as nickname,
			 u.login as login,c.id as cid					
 
                FROM cms_ratings r
                LEFT JOIN cms_users c ON item_id=$target_id AND r.item_id=c.id
				LEFT JOIN cms_users u ON u.id = r.user_id
 
                         WHERE target = 'comment' AND item_id=$id LIMIT 20";
 

 
<?php
/******************************************************************************/
//                                                                            //
//                           InstantCMS v1.10.4                               //
//                        http://instantcms.ru/                           //
//                                                                            //
//                   written by InstantCMS Team, 2007-2014                    //
//                produced by InstantSoft, (www.instantsoft.ru)               //
//                                                                            //
//                        LICENSED BY GNU/GPL v2                              //
//                                                                            //
/******************************************************************************/
 
	define('PATH', $_SERVER['DOCUMENT_ROOT']);
	include(PATH.'/core/ajax/ajax_core.php');
 
    $do         = cmsCore::request('action', 'str', 'add');
    $target     = cmsCore::request('target', 'str', '');
    $target_id  = cmsCore::request('target_id', 'int', 0);
    $comment_id = cmsCore::request('id', 'int', 0);
 
    if ($do == 'view' && !$comment_id) { cmsCore::halt(); }
 
    cmsCore::loadModel('comments');
    $model = new cms_model_comments();
 
    // Проверяем включен ли компонент
    if(!$inCore->isComponentEnable('comments')) { cmsCore::halt(); }
 
    if ($do=='view'){
 
	$inCore = cmsCore::getInstance();
	$inDB   = cmsDatabase::getInstance();
	$inUser = cmsUser::getInstance(); 
 
     $spyer = $model->getRating($comment_id,$target_id);
 
	cmsPage::initTemplate('components', 'com_comments_history')->        
            assign('do', $do)->
            assign('spyer', $spyer)->    
            assign('is_user', $inUser->id)->      
            display('com_comments_history.tpl');
 
	cmsCore::halt();
}
?>
 

cmsPage::initTemplate('components', 'com_comments_history.tpl')->

/* -------------------------------------------------------------------------- */
 
    // Получаем список смайлов
    public static function getSmiles()
    {
        if ($handle = opendir(PATH . '/images/smilies'))
        {
            while (false !== ($file = readdir($handle)))
            {
                if ($file != '.' && $file != '..' && mb_strstr($file, '.gif'))
                {
                    $smiles[] = $file;
                }
            }
 
            closedir($handle);
        }
 
        return $smiles;
    }
 
/* -------------------------------------------------------------------------- */

public static function getSmiles($for_field_id)
    {
   $html = '<div class="usr_msg_smilebox" id="smilespanel" style="display:none">';
    $dir = '/static/smiles/';
    if ($handle = opendir(PATH.$dir)) {
        while (false !== ($file = readdir($handle))) {
            if ($file != '.' && $file != '..' && strstr($file, '.gif')){
                 $tag = str_replace('.gif', '', $file);
                 $smiles[$tag] = $file;
            }
        }
        closedir($handle);
    ksort($files);
    foreach($files as $tag => $file) {
             $html .= '<a href="javascript:addSmile(\''.$tag.'\', \''.$for_field_id.'\');"><img src="'.$dir.$file.'" border="0" /></a> ';
    }
    }
    $html .= '</div>';
    return $smiles;
}