function cinemaru_movie_get_list_custom_with_tag($offset, $limit, $tags_id, $auth_admin=0, $valid=0)

function cinemaru_movie_get_list_custom_with_tag($offset, $limit, $tags_id, $auth_admin=0, $valid=0, $sort=0)

<?php
function smarty_function_cinemaru_related_movie_get($param, &$smarty)
{
               :  
    $sql = 'SELECT  ' . $c2 . ' FROM ' . $xoopsDB->prefix($mydirname . '_movie') . ' AS m, ';
    $sql .= $xoopsDB->prefix($mydirname . '_tag_movie') . ' AS tm ';
    $sql .= ' WHERE tm.movie_id = m.id AND (';
    $tagarray = array();
    $tagarray = explode(',', $param[tag]);
               :  

<?php
function smarty_function_cinemaru_related_movie_get($param, &$smarty)
{
               :  
    $sql = 'SELECT DISTINCT ' . $c2 . ' FROM ' . $xoopsDB->prefix($mydirname . '_movie') . ' AS m, ';
    $sql .= $xoopsDB->prefix($mydirname . '_tag_movie') . ' AS tm ';
    $sql .= ' WHERE tm.movie_id = m.id AND (';
    $tagarray = array();
    $tagarray = explode(',', $param[tag]);
               :  

<?php
function smarty_function_cinemaru_related_movie_get($param, &$smarty)
{
    global $xoopsDB;
    global $mydirname;
    
    $columns = array(
		     'id', 'title', 'file', 'image_file', 'total_time', 'file_type',
		     'file_size', 'randam_code', 'desc', 'genre', 'valid', 'owner',
		     'counter', 'comment', 'comment_up_time', 'reg_time',
		     'mod_time', 'reg_user', 'mod_user'
		     );
    $c = array();
    foreach ($columns as $val) {
	$c[] = 'm.' . $val;
    }
    $c2 = join(', ', $c);
    
    $sql = 'SELECT DISTINCT ' . $c2 . ' FROM ' . $xoopsDB->prefix($mydirname . '_movie') . ' AS m, ';
    $sql .= $xoopsDB->prefix($mydirname . '_tag_movie') . ' AS tm ';
    $sql .= ' WHERE tm.movie_id = m.id';

    if( isset($param['tag']) ) {
        $tagarray = array();
	$tagarray = explode(',', $param['tag']);
	foreach( $tagarray as $val ) {
	   $haveTags[] = 'tm.tags_id = ' . intval($val);
	}
	$sql .= ' AND (' . implode( ' OR ', $haveTags ) . ') ';
    }

    $sql .= ' AND m.valid = 1';
    
    if( isset($param['own']) ) {
        $sql .= ' AND m.id <> ' . intval($param['own']);
    }
    $sql .= ' ORDER BY m.reg_time DESC, counter DESC';

    if( isset($param['limit']) && intval($param['limit']) >  0 ) {
       $sql .= ' LIMIT 0,' . intval($param['limit']);
    }
    $result = $xoopsDB->query($sql);
    
    $list = array();
    
    while ($row = $arr = $xoopsDB->fetchArray($result)) {
	$list[] = $row;
    }
    
    $smarty->assign( "relate_info", $list );
}
?>

<{cinemaru_related_movie_get own=$movie.id tag=$tagsid limit=20}>
<{foreach from="$relate_info" item="tags"}>
   <{$tags.title}>
   <img
    src="<{if $tags.image_file_url != ''}><{$tags.image_file_url|escape:"html"}><{elseif
    $tags.image_file}><{$xoops_url}>/uploads/<{$mydirname}>/image/<{$tags.image_file}><{else}><{$xoops_url}>/modules/<{$mydirname}>/images/no_image.png<{/if}>"
    width="150" height="112">
   <{$tags.desc}><br/>
<{/foreach}>

<{cinemaru_related_movie_get own=$movie.id tag=$tagsid}>
<{foreach from="$relate_info" item="tags"}>
   <{$tags.title}>
   <img
    src="<{if $tags.image_file_url != ''}><{$tags.image_file_url|escape:"html"}><{elseif
    $tags.image_file}><{$xoops_url}>/uploads/<{$mydirname}>/image/<{$tags.image_file}><{else}><{$xoops_url}>/modules/<{$mydirname}>/images/no_image.png<{/if}>"
    width="150" height="112">
   <{$tags.desc}><br/>
<{/foreach}>