StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6022738
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-05-16T20:10:23.693
FavoriteCount
0
LastActivityDate
2011-05-16T20:10:23.693
LastEditDate
LastEditorUserId
0
OwnerUserId
573222
ParentId
5977464
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
If you are using the core Profile module, you could use something like below. It will show the nodes created by the user whose profile is being viewed. As an added benefit, it only needs to execute one custom database query. Insert this snippet into <code>template.php</code> in your theme's folder and change "THEMENAME" to the name of your theme: <pre><code>function THEMENAME_preprocess_user_profile(&$variables) { // Information about user profile being viewed $account = $variables['account']; // Get info on all content types $content_types = node_get_types('names'); // Get node counts for all content types for current user $stats = array(); $node_counts = db_query('SELECT type, COUNT(type) AS num FROM {node} WHERE status = 1 AND uid = %d GROUP BY type', $account->uid); while ($row = db_fetch_array($node_counts)) { $stats[] = array( 'name' => $content_types[$row['type']], 'type' => $row['type'], 'num' => $row['num'], ); } $variables['node_stats'] = $stats; } </code></pre> Now, in <code>user-profile.tpl.php</code> can add something similar to: <pre><code>// If user has created content, display stats <?php if (count($node_stats) > 0): ?> // For each content type, display a DIV with name and number of nodes <?php foreach ($node_stats as $value): ?> <div><?php print $value['name']; ?> (<?php print $value['num']; ?>)</div> <?php endforeach; ?> // Message to show for user that hasn't created any content <?php else: ?> <?php print $account->name; ?> has not created any content. <?php endif; ?> </code></pre> This is just a general idea of what you can do. You can also add restrictions to the content types you look for/display, check permissions for users to see these stats, use CSS to change the look of the stats, etc. If you are using <a href="http://drupal.org/project/content_profile" rel="nofollow">Content Profile</a>, you could use <code>THEMENAME_preprocess_node()</code> and check that the node is a profile node before executing this code.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODrupal: Display a list of contribution (posted content) for each user
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USLaxman13
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PODrupal: Display a list of contribution (posted content) for each user
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.