$active_deployment = 10;
session_start();
include "util/mysql_connect.php";
$res = mysql_query("SELECT * FROM funk.page_includes");
$row = mysql_fetch_array($res);
$ad_mp_top728 = stripslashes($row['main_top_728']);
$ad_mp_top120 = stripslashes($row['main_top_120']);
$ad_mp_mid300 = stripslashes($row['main_mid_300']);
$ad_mp_bot728 = stripslashes($row['main_bot_728']);
$whats_new_copy = stripslashes($row['whats_new']);
$ad_alt_top728 = stripslashes($row['alt_top_728']);
$ad_alt_top120 = stripslashes($row['alt_top_120']);
$ad_alt_mid300 = stripslashes($row['alt_mid_300']);
$ad_alt_bot728 = stripslashes($row['alt_bot_728']);
$res = mysql_query("SELECT artist_id FROM funk.deployments WHERE depl_id = '" . $active_deployment."'");
$row = mysql_fetch_array($res);
$artist_id = $row['artist_id'];
$ares = mysql_query("SELECT name FROM funk.deployment_artist WHERE artist_id = '" . $artist_id."'");
$arow = mysql_fetch_array($ares);
$fmixres = mysql_query("select a.song_id, a.depl_id, a.name, a.listen_count, a.vocal_component_id, b.name as vocal_name from funk.deployment_songs a, funk.deployment_components b where a.vocal_component_id = b.component_id AND a.depl_id = '" . $active_deployment . "' order by song_id desc limit 1");
$fmixrow = mysql_fetch_array($fmixres);
$fmixname = $fmixrow['name'];
if (strlen($fmixname)==0) $fmixname = "(untitled)";
$mmixres = mysql_query("select a.song_id, a.depl_id, a.name, a.listen_count, a.vocal_component_id, b.name as vocal_name from funk.deployment_songs a, funk.deployment_components b where a.vocal_component_id = b.component_id AND a.depl_id = '" . $active_deployment . "' order by song_id desc limit 5");
$view_user_id = (int)($_GET['user_id']);
mysql_query("UPDATE funk.users SET views = views + 1 WHERE user_id = " . $view_user_id);
$res = mysql_query("SELECT * FROM funk.users WHERE user_id = '" . $view_user_id."'");
$row = mysql_fetch_array($res);
$view_username = $row['username'];
$view_profile_picture = $row['profile_picture_link'];
$all_im_string = "";
if (!(($row['im_aol']==null)||($row['im_aol']==""))) {
$all_im_string = $row['im_aol'] . " (AOL)";
}
if (!(($row['im_yah']==null)||($row['im_yah']==""))) {
$all_im_string .= "
" . $row['im_yah'] . " (Yahoo)";
}
if (!(($row['im_msn']==null)||($row['im_msn']==""))) {
$all_im_string .= "
" . $row['im_msn'] . " (MSN)";
}
if (!(($row['im_goo']==null)||($row['im_goo']==""))) {
$all_im_string .= "
" . $row['im_goo'] . " (Google)";
}
if (!(($row['im_skype']==null)||($row['im_skype']==""))) {
$all_im_string .= "
" . $row['im_skype'] . " (Skype)";
}
while (substr($all_im_string, 0, 4)=="
")
{
$all_im_string = substr($all_im_string, 4, strlen($all_im_string) - 4);
}
$artists_string = "";
if (strlen($row['fav_artist1'])>0)
{
$artists_string = $row['fav_artist1'];
}
if (strlen($row['fav_artist2'])>0)
{
if (strlen($artists_string)>0)
{
$artists_string .= ", ";
}
$artists_string .= $row['fav_artist2'];
}
if (strlen($row['fav_artist3'])>0)
{
if (strlen($artists_string)>0)
{
$artists_string .= ", ";
}
$artists_string .= $row['fav_artist3'];
}
if (strlen($row['fav_artist3'])>0)
{
if (strlen($artists_string)>0)
{
$artists_string .= ", ";
}
$artists_string .= $row['fav_artist3'];
}
if (strlen($row['fav_artist4'])>0)
{
if (strlen($artists_string)>0)
{
$artists_string .= ", ";
}
$artists_string .= $row['fav_artist4'];
}
if (strlen($row['fav_artist5'])>0)
{
if (strlen($artists_string)>0)
{
$artists_string .= ", ";
}
$artists_string .= $row['fav_artist5'];
}
if ($row['gender']!=''){
if ($row['gender']=='M')
{
$gender = "Male";
} else if ($row['gender']=='F'){
$gender = "Female";
} else {
$gender = "";
}
} else {
$gender = "";
}
$row_year = substr($row['birthdate'], 0, 4);
$row_month = substr($row['birthdate'], 6, 2);
$row_mday = substr($row['birthdate'], 8, 2);
$birthdate = $row['birthdate'];
$age = date("Y") - $row_year;
if ((date("n") < date("n",$birthdate)) or ((date("n") == date("n",$birthdate)) and (date("j") < date("j",$birthdate)))) {
$age--;
}
if ($age>13&&$age<100){
$age = $age;
} else {
$age ="";
}
if ($age!=''){
$agegender = '
'.$age.' '.$gender;
} else if ($gender!=''){
$agegender = '
'.$gender;
}
$address = "";
if ($row['city']!=''){
$address = $row['city'];
if ($row['state']!=''){
$address .= ", " .$row['state'];
}
} else if ($row['state']!=''){
$address = $row['state'];
} else {
$address = "";
}
if (strlen($address)>0){
$address = "
".$address;
}
if($row['headline']!=''){
$headline = ''.$row['username'].' - "'.stripslashes($row['headline']).'"
';
}
?>
|
|
|
|
if (isset($_SESSION['session_user'])) { ?>
Welcome back, =$_SESSION['session_user_name']?>. Logout
} else { ?>
Login or Sign Up
} ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
| =$view_username?>=$agegender?>=$address?>
|
|
|
for ($i=0;$i<10;$i++) { ?>
|
 |
|
Loading... |
|
|
Loading... |
| Loading... |
0 Plays Comments Remix! |
|
|
|
} ?>
Loading...
| =$display_name?> Comments |
|
|
$cmtres = mysql_query("SELECT user_comments.*, users.username 'commenting_user' FROM funk.user_comments, funk.users WHERE user_comments.user_id = '" . $view_user_id . "' AND user_comments.commenting_user_id = users.user_id ORDER BY comment_timestamp DESC LIMIT 5");
while (($cmtrow = mysql_fetch_array($cmtres))!=null) {
$comment_date = $cmtrow['comment_timestamp'];
$new_comment_date = date('M j', strtotime($comment_date)).", ". date('Y', strtotime($comment_date))." ".date('g:i a', strtotime($comment_date));
?>
|
|
} ?>
| Add Comment | View All |
|
|
|
|
| =$display_name?> Statistics |
|
|
Status: =$status?> Average Rating: =number_format($rs['acr'],1)?> Total Points: =$rs['points']?> |
Total Plays: =$rs['plays']?> Times Remixed: =$remixes?> Profile Views: =$row['views']?> |
|
| =$display_name?> Friends |
|
|
$abres = mysql_query("SELECT * FROM funk.user_address_book a, funk.users b WHERE a.target_user_id = b.user_id AND a.user_id = '" . $view_user_id . "' LIMIT 4");
$abi = 0;
$count = mysql_num_rows($abres);
if ($count>0){
while (($abrow = mysql_fetch_array($abres))!=null) { $abi++; ?>
 =$abrow['username']?> |
if ($abi==4) { $abi=0?>
} ?>
} ?>
while ($abi<3) { $abi++; ?>
|
} ?>
| View All |
} else { ?>
| =$display_name?> Has Not Added Any Friends Yet |
} ?>
|
|
|
|
|
Close
for ($i=0;$i<10;$i++) { ?>
|
 |
|
Loading... |
|
|
Loading... |
| Loading... |
0 Plays Comments Remix! |
|
|
|
} ?>
Close
for ($i=0;$i<10;$i++) { ?>
|
 |
|
Loading... |
|
|
Loading... |
| Loading... |
0 Plays Comments Remix! |
|
|
|
} ?>