| 1 |
<?php |
<?php |
| 2 |
// $Id: revisionreference.module 118 2008-06-03 23:40:41Z danielb $ |
// $Id: revisionreference.module,v 1.1.2.2 2008/06/19 21:16:35 danielb Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 418 |
SELECT r.nid, r.timestamp, r.title, u.name AS user |
SELECT r.nid, r.timestamp, r.title, u.name AS user |
| 419 |
FROM {node_revisions} r |
FROM {node_revisions} r |
| 420 |
LEFT JOIN {users} u ON r.uid = u.uid |
LEFT JOIN {users} u ON r.uid = u.uid |
| 421 |
WHERE r.vid = %d"), $vid)); |
WHERE r.vid = %d", 'node_revisions', 'vid', $vid), $vid)); |
| 422 |
|
|
| 423 |
$current = revisionreference_vid_is_current($row->vid, $row->nid); |
$current = revisionreference_vid_is_current($row->vid, $row->nid); |
| 424 |
$value = $row->title .' [nid:'. $row->nid .'] '. ($current ? '(CUR) ' : '') . date('m/d/Y h:m', $row->timestamp) .' by '. $row->user .' [vid:'. $vid .']'; |
$value = $row->title .' [nid:'. $row->nid .'] '. ($current ? '(CUR) ' : '') . date('m/d/Y h:m', $row->timestamp) .' by '. $row->user .' [vid:'. $vid .']'; |
| 612 |
LEFT JOIN {node} n ON r.nid = n.nid |
LEFT JOIN {node} n ON r.nid = n.nid |
| 613 |
LEFT JOIN {users} u ON r.uid = u.uid |
LEFT JOIN {users} u ON r.uid = u.uid |
| 614 |
WHERE ". $related_clause ." |
WHERE ". $related_clause ." |
| 615 |
ORDER BY n.title, n.vid"), $args); |
ORDER BY n.title, n.vid", 'node_revisions', 'vid', $args), $args); |
| 616 |
} |
} |
| 617 |
|
|
| 618 |
$rows = array(); |
$rows = array(); |
| 774 |
} |
} |
| 775 |
|
|
| 776 |
function revisionreference_nid_from_vid($vid) { |
function revisionreference_nid_from_vid($vid) { |
| 777 |
$nid = db_result(db_query(db_rewrite_sql("SELECT nid from {node_revisions} WHERE vid = %d"), $vid)); |
$nid = db_result(db_query(db_rewrite_sql("SELECT nid from {node_revisions} WHERE vid = %d", 'node_revisions', 'vid', $vid), $vid)); |
| 778 |
return $nid; |
return $nid; |
| 779 |
} |
} |
| 780 |
|
|
| 784 |
$nid = revision_nid_from_vid($vid); |
$nid = revision_nid_from_vid($vid); |
| 785 |
} |
} |
| 786 |
if (!isset($max_vid_for_nids[$nid])) { |
if (!isset($max_vid_for_nids[$nid])) { |
| 787 |
$max_vid_for_nids[$nid] = db_result(db_query(db_rewrite_sql("SELECT MAX(vid) AS vid from {node_revisions} WHERE nid = %d"), $nid)); |
$max_vid_for_nids[$nid] = db_result(db_query(db_rewrite_sql("SELECT MAX(vid) AS vid from {node_revisions} WHERE nid = %d", 'node_revisions', 'vid', $nid), $nid)); |
| 788 |
} |
} |
| 789 |
return ($max_vid_for_nids[$nid] == $vid); |
return ($max_vid_for_nids[$nid] == $vid); |
| 790 |
} |
} |