/[drupal]/contributions/modules/moviereview/moviereview.module
ViewVC logotype

Diff of /contributions/modules/moviereview/moviereview.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.6.2.4, Mon May 15 23:35:20 2006 UTC revision 1.6.2.5, Sun May 28 23:34:48 2006 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: moviereview.module,v 1.8 2006/05/15 23:34:18 emiliano Exp $  // $Id: moviereview.module,v 1.6.2.4 2006/05/15 23:35:20 emiliano Exp $
3    
4  // Adapted by Emiliano <emiliano@webinteligente.com.br>  // Adapted by Emiliano <emiliano@webinteligente.com.br>
5  // from bookreview module written by Jeremy Andrews <jeremy@kerneltrap.org>  // from bookreview module written by Jeremy Andrews <jeremy@kerneltrap.org>
# Line 48  function moviereview_node_info() { Line 48  function moviereview_node_info() {
48    
49  function moviereview_insert($node) {  function moviereview_insert($node) {
50    
51    db_query("INSERT INTO {moviereview} (nid, movietitle, release, tvseries, cover, genre, director, writer, runtime, country, language, imdb, media, price, rating, review, location) VALUES (%d, '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, '%s', '%s')", $node->nid, $node->movietitle,  $node->release,  $node->tvseries, $node->cover, $node->genre,  $node->director,  $node->writer,  $node->runtime,  $node->country, $node->language,  $node->imdb,  $node->media,  $node->price,  $node->rating, $node->review, $node->location);    db_query("INSERT INTO {moviereview} (nid, movietitle, releaseyear, tvseries, cover, genre, director, writer, runtime, country, language, imdb, media, price, rating, review, location) VALUES (%d, '%s', '%s', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, '%s', '%s')", $node->nid, $node->movietitle,  $node->releaseyear,  $node->tvseries, $node->cover, $node->genre,  $node->director,  $node->writer,  $node->runtime,  $node->country, $node->language,  $node->imdb,  $node->media,  $node->price,  $node->rating, $node->review, $node->location);
52    
53    for ($i = 0; $i < $node->numactors; $i++) {    for ($i = 0; $i < $node->numactors; $i++) {
54      $actor = "actor-$i";      $actor = "actor-$i";
# Line 87  function moviereview_load($node) { Line 87  function moviereview_load($node) {
87    
88  function moviereview_update($node) {  function moviereview_update($node) {
89    
90    db_query("UPDATE {moviereview} SET movietitle = '%s', release = '%s', tvseries = '%d', cover = '%s', genre = '%s', director = '%s', writer = '%s', runtime = '%s', country = '%s', language = '%s', imdb = '%s', media = '%s', price = '%s', rating = '%d', review = '%s', location = '%s' WHERE nid = %d", $node->movietitle,  $node->release,  $node->tvseries, $node->cover, $node->genre,  $node->director,  $node->writer,  $node->runtime,  $node->country, $node->language,  $node->imdb,  $node->media,  $node->price,  $node->rating, $node->review, $node->location, $node->nid);    db_query("UPDATE {moviereview} SET movietitle = '%s', releaseyear = '%s', tvseries = '%d', cover = '%s', genre = '%s', director = '%s', writer = '%s', runtime = '%s', country = '%s', language = '%s', imdb = '%s', media = '%s', price = '%s', rating = '%d', review = '%s', location = '%s' WHERE nid = %d", $node->movietitle,  $node->releaseyear,  $node->tvseries, $node->cover, $node->genre,  $node->director,  $node->writer,  $node->runtime,  $node->country, $node->language,  $node->imdb,  $node->media,  $node->price,  $node->rating, $node->review, $node->location, $node->nid);
91    
92    db_query("DELETE FROM {moviereview_actors} WHERE nid = %d", $node->nid);    db_query("DELETE FROM {moviereview_actors} WHERE nid = %d", $node->nid);
93    for ($i = 0; $i < $node->numactors; $i++) {    for ($i = 0; $i < $node->numactors; $i++) {
# Line 219  function moviereview_form(&$node) { Line 219  function moviereview_form(&$node) {
219  //    '#prefix' => '<div id="moviereview-form">',  //    '#prefix' => '<div id="moviereview-form">',
220  //  );  //  );
221    
222    $form['release'] = array(    $form['releaseyear'] = array(
223      '#type' => 'textfield',      '#type' => 'textfield',
224      '#title' => t('Release year'),      '#title' => t('Release year'),
225      '#default_value' => $node->release,      '#default_value' => $node->releaseyear,
226      '#size' => 4,      '#size' => 4,
227      '#maxlength' => 255,      '#maxlength' => 255,
228      '#description' => t('The year the movie was released.  (Format:  YYYY).'),      '#description' => t('The year the movie was released.  (Format:  YYYY).'),
# Line 548  function moviereview_overview() { Line 548  function moviereview_overview() {
548    
549  function theme_moviereview_list() {  function theme_moviereview_list() {
550    
551    $header = array('&nbsp;', array('data' => t('Title'), 'field' => 'n.title', 'sort' => 'asc', 'width' => '40%'), array('data' => t('Year'), 'field' => 'm.release', '', 'width' => '20%'), array('data' => t('Rating'), 'field' => 'm.rating', '', 'width' => '20%'));    $header = array('&nbsp;', array('data' => t('Title'), 'field' => 'n.title', 'sort' => 'asc', 'width' => '40%'), array('data' => t('Year'), 'field' => 'm.releaseyear', '', 'width' => '20%'), array('data' => t('Rating'), 'field' => 'm.rating', '', 'width' => '20%'));
552    
553    $sql = db_rewrite_sql('SELECT DISTINCT(n.nid), n.title, m.movietitle, m.cover, m.director, m.genre, m.release, m.runtime, m.rating, m.imdb, m.price FROM {moviereview} m INNER JOIN {node} n ON m.nid = n.nid WHERE n.status = 1');    $sql = db_rewrite_sql('SELECT DISTINCT(n.nid), n.title, m.movietitle, m.cover, m.director, m.genre, m.releaseyear, m.runtime, m.rating, m.imdb, m.price FROM {moviereview} m INNER JOIN {node} n ON m.nid = n.nid WHERE n.status = 1');
554    $sql .= tablesort_sql($header);    $sql .= tablesort_sql($header);
555    $result = pager_query($sql, 20);    $result = pager_query($sql, 20);
556    
# Line 580  function theme_moviereview_list() { Line 580  function theme_moviereview_list() {
580      if ($node->director) {      if ($node->director) {
581        $output .= t('<b>Directed by:</b> %director', array('%director' => $node->director)) .'<br />';        $output .= t('<b>Directed by:</b> %director', array('%director' => $node->director)) .'<br />';
582      }      }
583      if ($node->release) {      if ($node->releaseyear) {
584        $output .= t('<b>Year:</b> %release', array('%release' => $node->release)) .'<br />';        $output .= t('<b>Year:</b> %releaseyear', array('%releaseyear' => $node->releaseyear)) .'<br />';
585      }      }
586      if ($node->runtime) {      if ($node->runtime) {
587        $output .= t('<b>Runtime:</b> %runtime', array('%runtime' => $node->runtime)) .'<br />';        $output .= t('<b>Runtime:</b> %runtime', array('%runtime' => $node->runtime)) .'<br />';
# Line 683  function theme_moviereview_content(&$nod Line 683  function theme_moviereview_content(&$nod
683      }      }
684    }    }
685    
686    if($node->release) {    if($node->releaseyear) {
687      $output .= "    <div class=\"label2\">". t('Year') .": </div><div class=\"content2\">". $node->release ."</div>\n";      $output .= "    <div class=\"label2\">". t('Year') .": </div><div class=\"content2\">". $node->releaseyear ."</div>\n";
688    }    }
689    if($node->country) {    if($node->country) {
690      $output .= "    <div class=\"label2\">". t('Country') .": </div><div class=\"content2\">". $node->country ."</div>\n";      $output .= "    <div class=\"label2\">". t('Country') .": </div><div class=\"content2\">". $node->country ."</div>\n";
Legend:
Removed from v.1.6.2.4  
changed lines
  Added in v.1.6.2.5
  ViewVC Help
Powered by ViewVC 1.1.2