<?php if(!defined('__ZBXE__')) exit();
$output->query_id = "comment.getTotalCommentList";
$output->action = "select";
$output->column_type["comment_srl"] = "number";
$output->column_type["module_srl"] = "number";
$output->column_type["document_srl"] = "number";
$output->column_type["parent_srl"] = "number";
$output->column_type["is_secret"] = "char";
$output->column_type["content"] = "bigtext";
$output->column_type["voted_count"] = "number";
$output->column_type["blamed_count"] = "number";
$output->column_type["notify_message"] = "char";
$output->column_type["password"] = "varchar";
$output->column_type["user_id"] = "varchar";
$output->column_type["user_name"] = "varchar";
$output->column_type["nick_name"] = "varchar";
$output->column_type["member_srl"] = "number";
$output->column_type["email_address"] = "varchar";
$output->column_type["homepage"] = "varchar";
$output->column_type["uploaded_count"] = "number";
$output->column_type["regdate"] = "date";
$output->column_type["last_update"] = "date";
$output->column_type["ipaddress"] = "varchar";
$output->column_type["list_order"] = "number";
$output->tables = array( "comments"=>"comments", );
$output->_tables = array( "comments"=>"comments", );
$output->columns = array ( array("name"=>"*","alias"=>""),
 );
$output->conditions = array ( array("pipe"=>"",
"condition"=>array(array("column"=>"module_srl", "value"=>$args->s_module_srl,"pipe"=>"","operation"=>"in",),
array("column"=>"module_srl", "value"=>$args->exclude_module_srl,"pipe"=>"and","operation"=>"notin",),
)),
array("pipe"=>"and",
"condition"=>array(array("column"=>"content", "value"=>$args->s_content,"pipe"=>"or","operation"=>"like",),
array("column"=>"user_name", "value"=>$args->s_user_name,"pipe"=>"or","operation"=>"like",),
array("column"=>"nick_name", "value"=>$args->s_nick_name,"pipe"=>"or","operation"=>"like",),
array("column"=>"email_address", "value"=>$args->s_email_address,"pipe"=>"or","operation"=>"like",),
array("column"=>"homepage", "value"=>$args->s_homepage,"pipe"=>"or","operation"=>"like",),
array("column"=>"member_srl", "value"=>$args->s_member_srl,"pipe"=>"or","operation"=>"equal",),
array("column"=>"regdate", "value"=>$args->s_regdate,"pipe"=>"or","operation"=>"like_prefix",),
array("column"=>"last_update", "value"=>$args->s_last_upate,"pipe"=>"or","operation"=>"like_prefix",),
array("column"=>"ipaddress", "value"=>$args->s_ipaddress,"pipe"=>"or","operation"=>"like_prefix",),
)),
 );
$output->order = array(array($args->sort_index?$args->sort_index:"list_order",in_array($args->asc,array("asc","desc"))?$args->asc:("asc"?"asc":"asc")),);
$output->list_count = array("var"=>"list_count", "value"=>$args->list_count?$args->list_count:"20");
$output->page_count = array("var"=>"page_count", "value"=>$args->page_count?$args->page_count:"20");
$output->page = array("var"=>"page", "value"=>$args->page?$args->page:"");
return $output; ?>