Tutti gli utilizzi della funzione <b>tablesort_sql </b>in Drupal 6

tablesort_sql($header, $before = '')

modules\comment\comment.admin.inc (60): $result = pager_query('SELECT c.subject, c.nid, c.cid, c.comment, c.timestamp, c.status, c.name, c.homepage, u.name AS registered_name, u.uid, n.title as node_title FROM {comments} c INNER JOIN {users} u ON u.uid = c.uid INNER JOIN {node} n ON n.nid = c.nid WHERE c.status = %d'. tablesort_sql($form['header']['#value']), 50, 0, NULL, $status);

modules\dblog\dblog.admin.inc (66): $tablesort = tablesort_sql($header);

modules\dblog\dblog.admin.inc (111): $result = pager_query("SELECT COUNT(wid) AS count, message, variables FROM {watchdog} WHERE type = '%s' GROUP BY message, variables ". tablesort_sql($header), 30, 0, "SELECT COUNT(DISTINCT(message)) FROM {watchdog} WHERE type = '%s'", $type);

modules\forum\forum.module (575): $sql .= tablesort_sql($forum_topic_list_header, 'n.sticky DESC,');

modules\node\node.module (1622): $query .= tablesort_sql($header);

modules\path\path.admin.inc (38): $sql .= tablesort_sql($header);

modules\poll\poll.pages.inc (37): $result = pager_query("SELECT pv.chorder, pv.uid, pv.hostname, u.name FROM {poll_votes} pv LEFT JOIN {users} u ON pv.uid = u.uid WHERE pv.nid = %d". tablesort_sql($header), 20, 0, NULL, $node->nid);

modules\statistics\statistics.admin.inc (20): $sql = 'SELECT a.aid, a.path, a.title, a.uid, u.name, a.timestamp FROM {accesslog} a LEFT JOIN {users} u ON u.uid = a.uid'. tablesort_sql($header);

modules\statistics\statistics.admin.inc (55): $sql .= tablesort_sql($header);

modules\statistics\statistics.admin.inc (85): $sql = "SELECT COUNT(a.uid) AS hits, a.uid, u.name, a.hostname, SUM(a.timer) AS total, ac.aid FROM {accesslog} a LEFT JOIN {access} ac ON ac.type = 'host' AND LOWER(a.hostname) LIKE (ac.mask) LEFT JOIN {users} u ON a.uid = u.uid GROUP BY a.hostname, a.uid, u.name, ac.aid". tablesort_sql($header);

modules\statistics\statistics.admin.inc (120): $query .= tablesort_sql($header);

modules\statistics\statistics.pages.inc (18): $result = pager_query("SELECT a.aid, a.timestamp, a.url, a.uid, u.name FROM {accesslog} a LEFT JOIN {users} u ON a.uid = u.uid WHERE a.path = 'node/%d' OR a.path LIKE 'node/%d/%%'". tablesort_sql($header), 30, 0, NULL, $node->nid, $node->nid);

modules\statistics\statistics.pages.inc (50): $result = pager_query('SELECT aid, timestamp, path, title FROM {accesslog} WHERE uid = %d'. tablesort_sql($header), 30, 0, NULL, $account->uid);

modules\system\system.module (1387): $result = pager_query($sql . tablesort_sql($header), 50);
includes\tablesort.inc (39): function tablesort_sql($header, $before = '') {

modules\taxonomy\taxonomy.admin.inc (113): $query .= tablesort_sql($header);

modules\user\user.admin.inc (152): $sql .= tablesort_sql($header);

modules\user\user.admin.inc (895): $result = db_query("SELECT aid, type, status, mask FROM {access}". tablesort_sql($header));

Esempio pratico:

<?php
 function moduloname_shownode_admin() {
  $header = array('Nid', 'Vid', 'Type', 'Language', 'Title', 'Uid', 'Status', 'Created', 'Changed', 'Comment', 'Promote', 'Moderate', 'Sticky', 'Tnid', 'Translate');
  $rows = array();
  $res = db_query('SELECT nid, vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate FROM {node} ORDER BY nid');
  $num_rows = FALSE;
  while ($row = db_fetch_array($res)) {
      $rows[] = $row;
       //$rows[] = array($row['nid'], $row['vid'], $row['type'], $row['language'], $row['title'], $row['uid'], $row['status'], $row['created'], $row['changed'], $row['comment'], $row['promote'], $row['moderate'], $row['sticky'], $row['tnid'], $row['translate'], );
      $num_rows = TRUE;
  }
  if ($num_rows) {
    $output .= theme('table', $header, $rows);
    print theme('page', $output);
    exit;
  } else {
    drupal_set_message(t("Nessun record per questa tabella."));
  }
} 
?>