drupalcode.com

• View documentation
• List references

Definition

_abuse_load_reports($type, $oid)
abuse/abuse.module, line 1005

Code

<?php
function _abuse_load_reports($type, $oid) {
  $reports = array();
  $result = db_query("SELECT a.*, ar.reason AS report_reason, u.name AS registered_name, u.uid FROM {abuse} a INNER JOIN {abuse_reasons} ar ON a.reason = CAST(ar.arid AS CHAR) INNER JOIN {users} u ON u.uid = a.uid WHERE a.type = '%s' AND a.oid = %d", $type, $oid);
  while ($report = db_fetch_object($result)) {
    $report->name = $report->uid ? $report->registered_name : $report->name;
    $reports[] = $report;
  }
  return $reports;
}
?>