diff options
| author | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2007-01-03 17:20:52 +0000 |
|---|---|---|
| committer | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2007-01-03 17:20:52 +0000 |
| commit | 45c0491dcf41c537595fdb465625aee806c9f390 (patch) | |
| tree | 80c4d79685ff61bff8b51fe88da9cf8ea9eb96c4 /video.module | |
| parent | 59acb1f54903724e15eed28e47b568f6054442f2 (diff) | |
| download | video-45c0491dcf41c537595fdb465625aee806c9f390.tar.gz video-45c0491dcf41c537595fdb465625aee806c9f390.tar.bz2 | |
Added support for postgresql.
Diffstat (limited to 'video.module')
| -rw-r--r-- | video.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/video.module b/video.module index 1f1f811..c906261 100644 --- a/video.module +++ b/video.module @@ -753,7 +753,7 @@ function video_block_list($delta = 0) { $orderby = 'RAND()'; break; } - return node_title_list(db_query_range(db_rewrite_sql("SELECT n.nid, n.title FROM {node} n INNER JOIN {video} v ON n.vid = v.vid WHERE n.type = 'video' AND n.status = 1 AND n.moderate = 0 ORDER BY $orderby DESC"),0, $count)); + return node_title_list(db_query_range(db_rewrite_sql("SELECT n.nid, n.title, $orderby FROM {node} n INNER JOIN {video} v ON n.vid = v.vid WHERE n.type = 'video' AND n.status = 1 AND n.moderate = 0 ORDER BY $orderby DESC"),0, $count)); } /**************************************************** |