How to display webform result on /user/x (e.g. /user/1, user/2) page?

Err..

$submission_count = db_result(db_query('SELECT count(*) FROM {webform_submissions} WHERE uid = %d', $user->uid));

should change to:

$submission = db_result(db_query('SELECT s.sid, s.nid, s.uid, sd.no, sd.data, c.form_key, c.name, c.type, c.value, c.extra FROM {webform_submissions} s inner join {webform_submitted_data} sd on (s.sid = sd.sid and s.nid = sd.nid) inner join {webform_component} c on (sd.cid = c.cid and sd.nid = c.nid) where uid = %d', $user->uid));

My bad.

@djalloway:

Wow! Thanks a lot for help.

On webform.module, there are two places need to change:

First one:

function webform_submission_access($node, $submission, $op = 'view', $account = NULL) {
  global $user;
  $account = isset($account) ? $account : $user;

  switch ($op) {
    case 'view':
      return user_access('access webform results') || (user_access('access own webform submissions') && ($account->uid == $submission->uid)) || (user_access('access own webform results') && $user->uid == $node->uid);

should change to

function webform_submission_access($node, $submission, $op = 'view', $account = NULL) {
  global $user;
  $account = isset($account) ? $account : $user;

  switch ($op) {
    case 'view':
      return user_access('access webform results') || user_access('access webform submissions') || (user_access('access own webform submissions') && ($account->uid == $submission->uid)) || (user_access('access own webform results') && $user->uid == $node->uid);

Second one:

/**
 * Implementation of hook_perm().
 */
function webform_perm() {
  return array('create webforms', 'edit own webforms', 'edit webforms', 'access webform results', 'access own webform results', 'clear webform results', 'access own webform submissions', 'edit own webform submissions', 'edit webform submissions', 'use PHP for additional processing');
}

Should change to:

/**
 * Implementation of hook_perm().
 */
function webform_perm() {
  return array('create webforms', 'edit own webforms', 'edit webforms', 'access webform results', 'access own webform results', 'clear webform results', 'access own webform submissions', 'access webform submissions', 'edit own webform submissions', 'edit webform submissions', 'use PHP for additional processing');
}

People intend to use the solution above should apply the code and then assign the 'access webform submission' right to the user role.

Meanwhile before djalloway replied to my request, I implemented hook_user() interface:

/**
 * Implementation of hook_user().
 */

function webform_user($op, &$edit, &$account, $category = NULL) {
 
  switch ($op) {
    case 'view':
      $result = db_query('SELECT s.sid, s.nid, s.uid, sd.no, sd.data, c.name, c.type, c.value, c.extra FROM {webform_submissions} s INNER JOIN {webform_submitted_data} sd ON (s.sid = sd.sid AND s.nid = sd.nid) INNER JOIN {webform_component} c ON (sd.cid = c.cid AND sd.nid = c.nid) WHERE (c.type="select" OR c.type="textfield" OR c.type = "textarea" OR c.type = "email" OR c.type = "file") AND s.uid = %d ORDER BY c.cid', $account->uid);
      $test = array();
      $answers = array();
      $theanswer = '';
      $output = '';
      $pre='';
      while($q = db_fetch_object($result)) {
        switch($q->type) {
          case 'select':
            $test = unserialize($q->extra);        
            $temps = split("[\n]", $test['items']);
            foreach ($temps as $temp) {
              $temp = split("[\|]", $temp);
              $answers[$temp[0]] = $temp[1];
              //var_dump($temp[0]);
            }
            $theanswer = $answers[$q->data];
            //var_dump($theanswer);
            //return;
            break;          
          case 'textfield':
          case 'textarea':
          case 'email':
          default:
            $theanswer = $q->data;
            break;
          //case 'file':
          }
          if ($q->name != $pre) $output.='<br /><strong>'.($pre=$q->name).':</strong><br />';
          $output.=($theanswer.'<br />');
      }
      $account->content['webform_show_submission'] = array(
        '#type'   => 'markup',        
        '#value'  => t('<h3>Submission</h3>'.substr($output,6).'<br />'), 
        '#weight' => -1,
      );
  }
}

Pure text mode output to individual user profile page.