Breaking News

Movie Listing

#newborder { border: 1px dotted #ededed; } #newborder td:hover { border: 1px dotted #87BC2E; background-color: #dedede; }

“;
$orderby = “n.created”;
//$sql = “SELECT n.nid, n.title, $orderby, u.name, u.uid FROM {users} u, {node} n INNER JOIN {video} v ON n.vid = v.vid WHERE u.uid=n.uid AND n.type = ‘video’ AND n.status = 1 AND n.moderate = 0 ORDER BY $orderby DESC”;

$sql = db_rewrite_sql(“SELECT n.nid, n.title, i.iid, u.uid, u.name, n.created FROM {node} n LEFT JOIN image_attach i ON n.nid=i.nid INNER JOIN {users} u ON n.uid = u.uid WHERE n.type = ‘movie’ AND n.status = 1 ORDER BY $orderby DESC”);
// $result = db_query($sql, $qid);

$result = pager_query($sql, variable_get(‘default_nodes_main’, $records));

while ($node = db_fetch_object($result)) {
$node = node_load($node->nid);

$output = “”;
if($node->iid > 0) {
$images = node_load($node->iid);
$output = image_display($images, ‘thumbnail’);
}

//$row[] = “

nid}/play’>{$node->title}
“.format_date($node->created).”
By “.l($node->name,’user/’.$node->uid).”
“;

$row[] = “

$output
“.l($node->title, ‘node/’. $node->nid, $node->comment_count ? array(‘title’ => format_plural($node->comment_count, ‘1 comment’, ‘%count comments’)) : ”).”
“.$node->field_release_date[0][‘value’].”
“.$node->field_stars[0][‘value’].”
“;

if($counter%$columns == 0 && $counter>0) {
$allRows[] = $row;
$row = array();
}
$counter++;
}

if(empty($allRows) || !empty($row)) {
$allRows[] = $row;
}
//echo “

“;
//print_r($allRows);
echo theme(‘table’, $header, $allRows,array(“width”=>”100%”,”cellpadding”=>5,”id”=>”newborder”));
echo theme(‘pager’, NULL, variable_get(‘default_nodes_main’, $records));
*/
?>


#newborder { border: 1px dotted #ededed; } #newborder td:hover { border: 1px dotted #87BC2E; background-color: #dedede; }

“;
$orderby = “n.created”;
//$sql = “SELECT n.nid, n.title, $orderby, u.name, u.uid FROM {users} u, {node} n INNER JOIN {video} v ON n.vid = v.vid WHERE u.uid=n.uid AND n.type = ‘video’ AND n.status = 1 AND n.moderate = 0 ORDER BY $orderby DESC”;

$sql = db_rewrite_sql(“SELECT n.nid, n.title, i.iid, u.uid, u.name, n.created FROM {node} n LEFT JOIN image_attach i ON n.nid=i.nid INNER JOIN {users} u ON n.uid = u.uid WHERE n.type = ‘movie’ AND n.status = 1 ORDER BY $orderby DESC”);
// $result = db_query($sql, $qid);

$result = pager_query($sql, variable_get(‘default_nodes_main’, $records));

while ($node = db_fetch_object($result)) {
$node = node_load($node->nid);

$output = “”;
if($node->iid > 0) {
$images = node_load($node->iid);
$output = image_display($images, ‘thumbnail’);
}

//$row[] = “

nid}/play’>{$node->title}
“.format_date($node->created).”
By “.l($node->name,’user/’.$node->uid).”
“;

$row[] = “

$output
“.l($node->title, ‘node/’. $node->nid, $node->comment_count ? array(‘title’ => format_plural($node->comment_count, ‘1 comment’, ‘%count comments’)) : ”).”
“.$node->field_release_date[0][‘value’].”
“.$node->field_stars[0][‘value’].”
“;

if($counter%$columns == 0 && $counter>0) {
$allRows[] = $row;
$row = array();
}
$counter++;
}

if(empty($allRows) || !empty($row)) {
$allRows[] = $row;
}
//echo “

“;
//print_r($allRows);
echo theme(‘table’, $header, $allRows,array(“width”=>”100%”,”cellpadding”=>5,”id”=>”newborder”));
echo theme(‘pager’, NULL, variable_get(‘default_nodes_main’, $records));
*/
?>