| 1 |
<?php |
<?php |
| 2 |
// $Id$ |
// $Id: affiliate.module,v 1.3 2004/10/01 00:08:29 uwe Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* Implementation of hook_help(). |
* Implementation of hook_help(). |
| 120 |
array("data" => t('last access'), "field" => 'changed', 'sort' => 'desc'), |
array("data" => t('last access'), "field" => 'changed', 'sort' => 'desc'), |
| 121 |
array("data" => t('operations')) |
array("data" => t('operations')) |
| 122 |
); |
); |
| 123 |
$sql = 'SELECT uid, u.name, u.status, u.changed FROM {users} u JOIN {affiliates} a ON u.affiliate = a.aid WHERE affiliate = '. check_query($aid); |
$sql = 'SELECT uid, u.name, u.status, u.changed FROM {users} u JOIN {affiliates} a ON u.affiliate = a.aid WHERE affiliate = '. db_escape_string($aid); |
| 124 |
$sql .= tablesort_sql($header); |
$sql .= tablesort_sql($header); |
| 125 |
$result = pager_query($sql, 50); |
$result = pager_query($sql, 50); |
| 126 |
$status = array(t("blocked"), t("active")); |
$status = array(t("blocked"), t("active")); |