nid; } $sql = db_rewrite_sql("SELECT cr.rid, crn.created FROM {node} n INNER JOIN {custom_reviews} cr on n.nid = cr.nid INNER JOIN {node} crn on cr.rid = crn.nid WHERE n.nid = ".(int)$node. " ORDER BY crn.created DESC "); //echo "sql: $sql,
id: ".$node; die(". jee"); $result = pager_query($sql, $limit); $review_list = array(); while ($row = db_fetch_object($result)) { $review_list[] = $row->rid; } return $review_list; } function _custom_review_node_reviews() { $max = 10; $output = ''; $id = arg(1); $node_info = array(); if (is_numeric($id)) { $pagetype = arg(0); switch ($pagetype) { case 'node': $reviews = _custom_review_get_reviews($id, $max); if (is_array($reviews)) $cnt = 0; foreach($reviews as $item) { $output .= node_view(node_load(array('nid' => $item)), false, false, false); $cnt++; if ($cnt >= $max) break; } break; } } $output .= theme('pager', NULL, $max); return $output; }