Why Trump Won and How Will the World Change?
The US, and indeed the world has seen a watershed event of Donald Trump's victory. It will change the US direction and may have pushed a World War by at least 3-4 years.
Type your search keyword in the followong form and click on the “Search” button.
Search for keyword:
2.
$searchkeyword = $_POST[“searchkeyword”];
if ( $searchkeyword!=”” ) {
print “Hier die Liste aller User, bei denen in einem der Profilfelder der Suchbegriff ” . $suchbegriff .” vorkommt”;
$rid=5;
$header = array(
array(‘data’ => t(‘Username’), ‘field’ => ‘name’, ‘sort’ => ‘asc’),
array(‘data’ => t(‘Status’), ‘field’ => ‘status’),
array(‘data’ => t(‘Member for’), ‘field’ => ‘created’),
array(‘data’ => t(‘Last access’), ‘field’ => ‘access’),
array(‘data’ => t(‘Datenfeld’), ‘field’ => ‘p_feldname’),
array(‘data’ => t(‘Picture’), ‘field’ => ‘picture’)
);
$sql = “SELECT u.uid, u.name, u.status, u.created, u.access, u.picture, MAX(pf.name) p_feldname FROM users u INNER JOIN users_roles ur ON u.uid = ur.uid INNER JOIN ( profile_values pv INNER JOIN profile_fields pf ON pv.fid = pf.fid ) ON u.uid = pv.uid WHERE ur.rid=$rid AND pv.value LIKE ‘%”.$searchkeyword.”%’ GROUP BY 1,2,3,4,5″;
$sql_count = “SELECT COUNT(DISTINCT u.uid) row_count FROM users u INNER JOIN users_roles ur ON u.uid = ur.uid INNER JOIN ( profile_values pv INNER JOIN profile_fields pf ON pv.fid = pf.fid ) ON u.uid = pv.uid WHERE ur.rid=$rid AND pv.value LIKE ‘%”.$searchkeyword.”%'”;
$sql .= tablesort_sql($header);
$result = pager_query($sql, 20,0,$sql_count );
$status = array(t(‘blocked’), t(‘active’));
while ($account = db_fetch_object($result)) {
$rows[] = array(theme(‘username’, $account),
$status[$account->status],
format_interval(time() – $account->created),
$account->access ? t(‘%time ago’, array(‘%time’ => format_interval(time() – $account->access))) : t(‘never’),
$account->p_feldname,
theme_user_picture($account)
);
}
$output = theme(‘table’, $header, $rows);
$output .= theme(‘pager’, NULL, 10, 0);
print ($output);
}
?>
If yuo have some feedback/proposals/wishes concerning this page, please post a comment or contact the admin directly via e-mail.
Every Sunday AM (US Time)/ PM (India time), we send out a weekly detailed newsletter. We also share other insightful notes during the week. Its free. Do sign up and share with friends!