Fun with user_profile.tpl.php - stuff for MySpace or Friendster like customizable profile

Yes, at last, audio and playlist are also embeddable in user_profile

<?php $nlimit = 10; ?>
<?php $userid=$user->uid; ?>
<?php $result7 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'audio_playlist' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result7)) {$output7 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output7; ?>

<?php $nlimit = 10; ?>
<?php $userid=$user->uid; ?>
<?php $result3 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'audio' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result3)) {$output6 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output6; ?>

This snippet return the number of buddies that user has (not yours)

<?php
$uid = arg(1);
$buddies = db_fetch_object(db_query("SELECT COUNT(buddy) AS count FROM {buddylist} WHERE uid= %d AND received=0", $uid));
echo "This member has $buddies->count buddies";
?>

About MySite: u can specify that the user's MySite is `full view' (no side blocks)

So u can use iframe to display the user's MySite (http://domain.com/mysite/ID) where ID is the userid

For chatroom, u can use iframe so that people can go straight into the user's chatroom and create chats or choose which chat to join. U have to use Pathauto to obtain http://domain.com/chatroom/ID

For user's URL, u can display the website directly, however some Friendster profiles are known to be `hijacking' the browser, and Myspace profiles are so laden with widgets and glitters that the browser will crash. Its up to you to use iframe, or just a link with target=_blank. I prefer iframe for user's URL just so that he/she stays longer in our site while having the ability to monitor his own site

<style type="text/css"><?php print $user->profile_css ?></style>
<?php if($user->picture): ?>
<div class="picture">
<a name="atas"></a>
<img align="right" src="http://muflihun.com/<?php print $user->picture ?>">
</div>
<?php endif; ?>

<?php
print "<div class=\"fields\">";
print "Status ";
$time_period = variable_get('user_block_seconds_online', 2700);
$uid = arg(1); // get the current userid that is being viewed.
$users = db_query("SELECT uid, name, access FROM {users} WHERE access >= %d AND uid = $uid", time() - $time_period);
          $total_users = db_num_rows($users);

          if ($total_users == 1) {
            $output = t(' ::  Online');
          }
          else {
            $output = t(' ::  Offline');     
          }

              print $output;
                      print "</div>";
?>

<?php
$uid = arg(1);
$buddies = db_fetch_object(db_query("SELECT COUNT(buddy) AS count FROM {buddylist} WHERE uid= %d AND received=0", $uid));
echo "$buddies->count buddies";
?>
<p>

<?php
if (module_exists('chatroom')) {
     print module_invoke('chatroom', 'page', $user->uid);
}
?>


      <?php
      // Grid block (4 random images in 2 columns from useralbum of the profile's owner)
      $params = array(
        'blocks' => implode('|', array_fill(0, 4, 'randomImage')),
        'itemId' => 'user:'. $user->uid
      );
      $block = gallery_get_block($params, 2);
      print $block['content'];
      ?>


<div id="pictures">
<marquee>
<?php
// Display N most recent thumbnails of images submitted by the user
//  Each thumbnail is linked back to it's image node
// Can optional limit the photos shown by specififying one or taxonomy term id's

// The number of thumbnail images to show
$nlimit = 20;
$taxo_id = array();
// Add one line for each taxonomy term id you want to limit the thumbnails to
// As an example, the following two lines would select images associated with taxonomy terms 36 OR 37
// $taxo_id[] = 36;
// $taxo_id[] = 37;
// Note, if not taxonomy term ids are specified, the selection is from all the user submitted images

//   $userid=$user->uid;    replace with   $userid = arg(1);  
// If you want to put this in a block - create a custom block and set it to only show up on user/*

$userid=$user->uid;

if ( count($taxo_id) > 0 ) {
    // Limit images based on taxonomy term id's
    $taxo_str = implode(',', $taxo_id);
    $sql = "SELECT n.created, n.title, n.nid, n.changed FROM node n INNER JOIN term_node ON n.nid = term_node.nid AND term_node.tid IN ($taxo_str) WHERE n.type = 'image' AND n.uid = $userid AND n.status = 1 ORDER BY n.changed DESC";
}
else {
    $sql = "SELECT n.created, n.title, n.nid, n.changed FROM node n WHERE n.type = 'image' AND n.uid = $userid AND n.status = 1 ORDER BY n.changed DESC";
}

$result = db_query_range($sql, 0, $nlimit);
$output = '';
while ( $info = db_fetch_object($result) ) {
  $node = node_load(array('nid' => $info->nid));
  $img_tag = image_display($node, 'thumbnail');
  $link = 'node/' . $node->nid;
  $output .= l($img_tag, $link, array(), NULL, NULL, FALSE, TRUE);
}
print $output;
?>
</marquee>
</div>


<?php $nlimit = 1; ?>
<?php $userid=$user->uid; ?>
<?php $result9 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'publicprofile' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result9)) {$output9 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output9; ?>


<?php $nlimit = 3; ?>
<?php $userid=$user->uid; ?>
<?php $result8 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'event' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result8)) {$output8 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output8; ?>

<?php $nlimit = 5; ?>
<?php $userid=$user->uid; ?>
<?php $result7 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'album' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result7)) {$output7 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output7; ?>

<?php $nlimit = 5; ?>
<?php $userid=$user->uid; ?>
<?php $result6 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'audio' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result6)) {$output6 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output6; ?>

<?php $nlimit = 1; ?>
<?php $userid=$user->uid; ?>
<?php $result5 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'poll' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result5)) {$output5 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output5; ?>

<?php $nlimit = 3; ?>
<?php $userid=$user->uid; ?>
<?php $result4 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'acidfree' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result4)) {$output4 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output4; ?>


<?php $nlimit = 3; ?>
<?php $userid=$user->uid; ?>
<?php $result10 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'chatroom' AND n.status = 1 AND n.uid = $userid ORDER BY n.created DESC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result10)) {$output10 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output10; ?>


<div id="muflihun_profile">
<div class="birthday">
Important / Birth date: <?php print $user->profile_date['day']."/".$user->profile_date['month']."/".$user->profile_date['year'];?><br>
<?php
    $year_diff = date("Y") - ($user->profile_lahir{year});
    $month_diff = date("m") - ($user->profile_lahir{month});
    $day_diff = date("d") - ($user->profile_lahir{day});
    if ($day_diff < 0 && $month_diff < 0)
      $year_diff--;?>
<p>Age: <?php print $year_diff; ?> </p>
</div>
<div class="fields">Business or Professional Field or Specialty: <a href="http://muflihun.com/profile/profile_userfield/<?php print $user->profile_userfield ?>"> <?php print $user->profile_userfield ?> </a> </div><p>
<div class="fields">Description: <?php print $user->profile_describe ?></div><p>
<div class="fields">Location: <a href="http://muflihun.com/profile/profile_location/<?php print $user->profile_location ?>"> <?php print $user->profile_location ?> </a> </div><p>
<div class="fields">Country: <a href="http://muflihun.com/profile/profile_country/<?php print $user->profile_country ?>"> <?php print $user->profile_country ?> </a> </div><p>
<div class="fields">Free e-mails: <?php print $user->profile_freeemail ?></div><p>
<div class="fields">Message to all: <?php print $user->profile_messageto ?></div><p>
<div class="fields">Online: <?php print $user->profile_online ?></div><p>
<div class="fields">Video: <?php print $user->profile_video ?></div><p>
<div class="fields">URL: <a target="_blank" href="<?php print $user->profile_url ?>"> <?php print $user->profile_url ?> </a> </div><p>
</div>

<?php
  if ($user->uid != $account->uid && user_access('administer users')) {
  print check_plain($user->profile_confidential);
  }
?>
<p>



<div class="fields">Usage: <a href="http://muflihun.com/profile/profile_usage/<?php print $user->profile_usage ?>"> <?php print $user->profile_usage ?> </a> </div><p>
<div class="fields">Languages: <a href="http://muflihun.com/profile/profile_language/<?php print $user->profile_language ?>"> <?php print $user->profile_language ?> </a> </div><p>


<div id="interaction">

<?php
  if ($user->uid != $account->uid) {
  print "<a target=\"_blank\" href=\"http://muflihun.com/contact/".$user->uid."\">Contact " .$user->name. " using your registered email</a>";
  }
?>

<p>
<?php
  if ($user->uid != $account->uid && user_access('access private messages')) {
  print "<a target=\"_blank\" href=\"http://muflihun.com/privatemsg/msgto/".$user->uid."\">Send private message to " .$user->name. " </a>";
  }
?>
<p>


<?php
  if ($user->uid != $account->uid && user_access('access user guestbook')) {
  print "<a target=\"_blank\" href=\"http://muflihun.com/guestbook/".$user->uid."\">View the guestbook of " .$user->name. "</a>";
  }
?>
<p>

<?php
  print "<a target=\"_blank\" href=\"http://muflihun.com/mysite/".$user->uid."\">View RSS feeds of " .$user->name. "</a>";
?>
<p>

<?php
  if ($user->uid != $account->uid && user_access('view buddy lists')) {
  print "<a target=\"_blank\" href=\"http://muflihun.com/buddylist/".$user->uid."\">View buddylist of " .$user->name. " </a>";
  }
?>
<p>

<?php
if (@in_array($user->uid, array_keys(buddylist_get_buddies($account->uid))) && user_access('maintain buddy list')) { 
  print "<a target=\"_blank\" href=\"http://muflihun.com/buddy/delete/".$user->uid."\">Remove " .$user->name. " from your buddylist</a>";
  } 
else {
  if ($user->uid != $account->uid && user_access('maintain buddy list')) {
  print "<a target=\"_blank\" href=\"http://muflihun.com/buddy/add/".$user->uid."\">Add " .$user->name. " to your buddylist</a>";
  }
}
?>
<p>
</div>

<?php
if (module_exists('guestbook')) {
  if(!$user->guestbook_status){  
     print module_invoke('guestbook', 'page', $user->uid);
  }
}
?>


<div id="latest">
<p>Latest</p>
<?php
  $uid = arg(1);
  $nlimit = 15;
  $result = db_query("SELECT n.created, n.title, n.nid, n.changed
  FROM node n
  WHERE n.uid = $uid
  AND n.status = 1
  ORDER BY n.changed
  DESC LIMIT $nlimit");
  $output4 .= "<div class=\"item-list\"><ul>\n";
  $output4 .= node_title_list($result);
  $output4 .= "</ul></div>";
  print $output4;
  ?>
</div>



<div id="shareinterest">
<?php $fieldname = 'profile_offer'; ?>
<?php if($user->$fieldname != ""): ?>
<p><b>Have to offer:</b></p>
<ul>
<?php
$temp_array = split("[\n,]", $user->$fieldname);
$count_total = count($temp_array);
for($counter=0; $counter<$count_total; $counter++):?>
<?php $link = each($temp_array) ?>
<li><a href="http://muflihun.com/profile/<?php print $fieldname; ?>/<?php print preg_replace('[\s]', '+', trim($link[value])) ?>" title="Members"><?php print $link[value] ?></a></li>
<?php endfor ?>
</ul> 
<?php $fieldname1 = 'profile_Locations'; ?>
<p><b>Looking for:</b></p>
<ul>
<?php
$temp_array = split("[\n,]", $user->$fieldname1);
$count_total = count($temp_array);
for($counter=0; $counter<$count_total; $counter++):?>
<?php $link = each($temp_array) ?>
<li><a href="http://muflihun.com/profile/<?php print $fieldname1; ?>/<?php print preg_replace('[\s]', '+', trim($link[value])) ?>" title="Members"><?php print $link[value] ?></a></li>
<?php endfor ?>
</ul> 
<?php $fieldname2 = 'profile_interests'; ?>
<p><b>Interests:</b></p>
<ul>
<?php
$temp_array = split("[\n,]", $user->$fieldname2);
$count_total = count($temp_array);
for($counter=0; $counter<$count_total; $counter++):?>
<?php $link = each($temp_array) ?>
<li><a href="http://muflihun.com/profile/<?php print $fieldname2; ?>/<?php print preg_replace('[\s]', '+', trim($link[value])) ?>" title="Members"><?php print $link[value] ?></a></li>
<?php endfor ?>
</ul> 
</ul>
</div>
<?php endif ?>



<?php $nlimit = 10; ?>
<?php $userid=$user->uid; ?>
<?php $result1 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = $userid ORDER BY n.created ASC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result1)) {$output1 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output1; ?>


<?php $nlimit = 10; ?>
<?php $userid=$user->uid; ?>
<?php $result2 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'story' AND n.status = 1 AND n.uid = $userid ORDER BY n.created ASC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result2)) {$output2 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output2; ?>


<?php $nlimit = 10; ?>
<?php $userid=$user->uid; ?>
<?php $result3 = pager_query(db_rewrite_sql("SELECT n.nid, n.created FROM {node} n WHERE n.type = 'forum' AND n.status = 1 AND n.uid = $userid ORDER BY n.created ASC"), variable_get('default_nodes_main', $nlimit)); ?>
<?php while ($node = db_fetch_object($result3)) {$output3 .= node_view(node_load(array('nid' => $node->nid)), 1);}; ?>
<?php print $output3; ?>



<div id="buddy">
<p>
IKHWAN LIST
<?php
if ( user_access('view buddy lists') || user_access('administer users') ) {
    // if thisuser has friends, show friends
    $output = '';
    $i = 0;
    $cnt = variable_get('buddylist_prof_buddies', 15);
    if ($buddies = buddylist_get_buddies($user->uid)) {
      foreach(array_keys($buddies) as $buddy) {
        $account = user_load(array('uid' => $buddy));
        $output .=theme('user_picture', $account);
                $listbuddies[] = $account;
        $i++;
        if ($i > $cnt) {
          break;
        }
      }
      $output .= '</div>'. theme('user_list', $listbuddies);
    if (count($buddies) > variable_get('buddylist_prof_buddies', 15)) {
              $output .= '<div class="more-link">' . l(t('view'), 'buddylist', array('title' => t('View more.'))) . '</div>';
            }
  
      print $output;
    }
}
?>
</div>



<a href="#atas">Back to top of profile</a>

It depends on what theme you use

Foliage is the easiest

You can instruct the users to change what code for colors, fonts, even hide left/right sidebars, and also user's own banner in the header

It depends on what theme you use

Foliage is the easiest

You can instruct the users to change what code for colors, fonts, even hide left/right sidebars, and also user's own banner in the header