| 413 |
$field_key = $element['#columns'][0]; |
$field_key = $element['#columns'][0]; |
| 414 |
if (!empty($element['#default_value'][$field_key])) { |
if (!empty($element['#default_value'][$field_key])) { |
| 415 |
$vid = $element['#default_value'][$field_key]; |
$vid = $element['#default_value'][$field_key]; |
| 416 |
|
$args[] = $vid; |
| 417 |
$row = db_fetch_object(db_query(db_rewrite_sql(" |
$row = db_fetch_object(db_query(db_rewrite_sql(" |
| 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", 'node_revisions', 'vid', $vid), $vid)); |
WHERE r.vid = %d", 'node_revisions', 'vid', $args), $args)); |
| 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 .']'; |
| 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", 'node_revisions', 'vid', $vid), $vid)); |
$args[] = $vid; |
| 778 |
|
$nid = db_result(db_query(db_rewrite_sql("SELECT nid from {node_revisions} WHERE vid = %d", 'node_revisions', 'vid', $args), $args)); |
| 779 |
return $nid; |
return $nid; |
| 780 |
} |
} |
| 781 |
|
|
| 785 |
$nid = revision_nid_from_vid($vid); |
$nid = revision_nid_from_vid($vid); |
| 786 |
} |
} |
| 787 |
if (!isset($max_vid_for_nids[$nid])) { |
if (!isset($max_vid_for_nids[$nid])) { |
| 788 |
$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)); |
$args[] = $nid; |
| 789 |
|
$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', $args), $args)); |
| 790 |
} |
} |
| 791 |
return ($max_vid_for_nids[$nid] == $vid); |
return ($max_vid_for_nids[$nid] == $vid); |
| 792 |
} |
} |