[gelöst] User list

am 07.07.2010 - 21:26 Uhr in
SELECT DISTINCT(node.nid) AS nid,
users.picture AS users_picture,
users.uid AS users_uid,
users.name AS users_name,
users.mail AS users_mail,
users.created AS users_created,
users.login AS users_login
FROM node node
INNER JOIN users users ON node.uid = users.uid
WHERE users.status <> 0
GROUP BY nid
ORDER BY users_name ASC
So sieht meine View für die userlist aus. Leider zeigt es mir nur den User 1 an und nicht alle anderen... an welchem Schräubchen muss ich denn noch drehen?
Danke!
Wenn ich auf exportieren klicke, dann kommt folgender Code:
$view = new view; $view->name = 'profile'; $view->description = ''; $view->tag = ''; $view->view_php = ''; $view->base_table = 'node'; $view->is_cacheable = FALSE; $view->api_version = 2; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->override_option('fields', array( 'picture' => array( 'id' => 'picture', 'table' => 'users', 'field' => 'picture', ), )); $handler->override_option('sorts', array( 'name' => array( 'id' => 'name', 'table' => 'users', 'field' => 'name', ), )); $handler->override_option('arguments', array( 'uid' => array( 'id' => 'uid', 'table' => 'users', 'field' => 'uid', ), )); $handler->override_option('filters', array( 'status' => array( 'id' => 'status', 'table' => 'users', 'field' => 'status', ), )); $handler->override_option('access', array( 'type' => 'none', )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('style_plugin', 'fluid_grid'); $handler->override_option('row_options', array( 'inline' => array( 'picture' => 'picture', ), 'separator' => '', 'hide_empty' => 0, )); $handler = $view->new_display('page', 'Page', 'page_1'); $handler->override_option('fields', array( 'picture' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'exclude' => 0, 'id' => 'picture', 'table' => 'users', 'field' => 'picture', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), 'name' => array( 'label' => 'Name', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'link_to_user' => 1, 'overwrite_anonymous' => 0, 'anonymous_text' => '', 'exclude' => 0, 'id' => 'name', 'table' => 'users', 'field' => 'name', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), 'created' => array( 'label' => 'Member since', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'date_format' => 'custom', 'custom_date_format' => 'F j, Y', 'exclude' => 0, 'id' => 'created', 'table' => 'users', 'field' => 'created', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), 'login' => array( 'label' => 'Last online', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'date_format' => 'custom', 'custom_date_format' => 'F j, Y', 'exclude' => 0, 'id' => 'login', 'table' => 'users', 'field' => 'login', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), 'contact' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'text' => 'Contact member', 'link_display' => 'link', 'exclude' => 0, 'id' => 'contact', 'table' => 'users', 'field' => 'contact', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), )); $handler->override_option('sorts', array( 'name' => array( 'order' => 'ASC', 'id' => 'name', 'table' => 'users', 'field' => 'name', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), )); $handler->override_option('arguments', array()); $handler->override_option('filters', array( 'status' => array( 'operator' => '=', 'value' => '1', 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'status', 'table' => 'users', 'field' => 'status', 'override' => array( 'button' => 'Use default', ), 'relationship' => 'none', ), )); $handler->override_option('access', array( 'type' => 'role', 'role' => array( '2' => 2, ), )); $handler->override_option('title', 'Our Members'); $handler->override_option('items_per_page', 16); $handler->override_option('use_pager', 'mini'); $handler->override_option('distinct', 1); $handler->override_option('style_options', array( 'grouping' => '', 'advanced_layout' => array( 'css3' => TRUE, ), 'items_width' => '', 'items_height' => '', 'list_alignment' => '', 'items_alignment' => '', 'items_h_margin' => '', 'items_v_margin' => '', 'box_shadow' => '1', 'border_radius' => '1', )); $handler->override_option('row_options', array()); $handler->override_option('path', 'profile'); $handler->override_option('menu', array( 'type' => 'none', 'title' => '', 'description' => '', 'weight' => 0, 'name' => 'navigation', )); $handler->override_option('tab_options', array( 'type' => 'none', 'title' => '', 'description' => '', 'weight' => 0, 'name' => 'navigation', ));
- Anmelden oder Registrieren um Kommentare zu schreiben
Erstmal nur eine Vermutung,
am 07.07.2010 - 21:55 Uhr
Erstmal nur eine Vermutung, aber könnte das Problem damit zusammenhängen?
Die Ansicht zeigt Einträge vom Typ Node an
Dass du also als Views-Typ Node und nicht Benutzer genommen hast?
Denn so, wie du die View momentan konfiguriert hast, bekommst du natürlich zu jedem Node den Benutzername etc. des Autors angezeigt und keine allgemeinen Benutzerdaten, weil es eben ein Node-View ist. Versuche mal, das ganze auf Basis einer User-View zu machen (also neue View erstellen und als Ansichtstyp nicht Node sondern User bzw. Benutzer wählen.
Wie blöd kann man sein ....
am 07.07.2010 - 22:14 Uhr
Dass du also als Views-Typ Node und nicht Benutzer genommen hast?
Hallo,
DANKE - das war's. Ist mir gar nicht aufgefallen, dass ich nicht Benutzer genommen habe ....