session_start();
if(isset($_GET['logoff']))
{
	$_SESSION = array();
	session_destroy();
	$_SESSION['usr']= "";
	$_SESSION['id'] = 0;
	header("Location: index.php");
	exit;
}
//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);
//error_reporting(E_ALL);
// print_r($_POST);
$user_id = $_SESSION['id'];
$username = $_SESSION['usr'];
$session_id = $_COOKIE['PHPSESSID'];
//print_r($_POST);
//print_r($_GET);
//print_r($_REQUEST);
$password = $_POST['password'];
$email = $_POST['email'];
$name = $_POST['name'];
$phone = $_POST['phone'];
$profile = $_POST['profile'];
$main = $_POST['main'];
$details = $_POST['details'];
$facebook = $_POST['facebook'];
$profile = $_POST['profile'];
$soundcloud = $_POST['soundcloud'];
$youtube = $_POST['youtube'];
$itunes = $_POST['itunes'];
$twitter = $_POST['twitter'];
$spotify = $_POST['spotify'];
$instagram = $_POST['instagram'];
$website = $_POST['website'];
$snapchat = $_POST['snapchat'];
$bandcamp = $_POST['bandcamp'];
$dailymotion = $_POST['dailymotion'];
$settings = $_POST['settings'];
$mailinglist = $_POST['mailinglist'];
$introflag = $_POST['introflag'];
$photoeffects = $_POST['photoeffects'];
$textfinished = $_POST['textfinished'];
$mailfinished = $_POST['mailfinished'];
		 
// dual file handling
//print_r($_SESSION);
//print_r($_COOKIE);
if($_SESSION['id']){
  //      header("Location: ./index.php");
    //    die();
	//echo "session id exists
";
    } else { // echo "no session id
"; 
	
	header("Location: index.php");
	exit;
	}
//echo $user_id;
//echo $username;
$db = mysqli_connect ("localhost", "pack", "watch3r");
mysqli_select_db ($db, "pack");
//$checker = mysqli_query("SELECT * FROM pack_engine LIMIT 1");
//	while ($gather = mysqli_fetch_array($checker)) {
//$enginestatus = $gather["status"];
//	}
//    if($enginestatus == 'DOWN'){
//        header("Location: ./index.php");
//        die();
//    } 
if ($main){
mysqli_query($db, "UPDATE pack_user set email = '$email' WHERE id = '$user_id'");
$event_text = "Updated Details";
// check that it isnt a placeholder:
if ($password != "placeholder"){
$pass = md5($password);
//echo $password;
//echo $pass;
$event_text = "Updated Details: Password Updated";
//$row = mysqli_fetch_assoc(mysql_query($db,"SELECT id,password FROM pack_user WHERE id='$user_id'"));
//echo $row["password"];
//if ($row) {
//echo "found this password";	
// }
// check if it matches exiting password -- if not update it
mysqli_query($db, "UPDATE pack_user set pass = '$pass' WHERE id = '$user_id'"); 
}
mysqli_query($db, "UPDATE pack_user_extended set cellphone = '$phone' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user set usr = '$name' WHERE id = '$user_id'");
	$event_type ="fas fa-coins";
	$credits = 10;
	$query = "INSERT INTO pack_notification VALUES ('','$user_id','$event_text','$event_type','$credits',now(),'$session_id')";
	mysqli_query($db,$query);
	//echo "proceed";
    $notes = "1";
	
	}
	
	
	
if ($details){
		//echo "details";
mysqli_query($db, "UPDATE pack_user_extended set facebook = '$facebook' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set snapchat = '$snapchat' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set profile = '$profile' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set website = '$website' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set soundcloud = '$soundcloud' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set youtube = '$youtube' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set bandcamp = '$bandcamp' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set itunes = '$itunes' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set spotify = '$spotify' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set twitter = '$twitter' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set dailymotion = '$dailymotion' WHERE user_id = '$user_id'");
mysqli_query($db, "UPDATE pack_user_extended set instagram = '$instagram' WHERE user_id = '$user_id'");
$event_text = "Updated Social Media";
	$event_type ="fas fa-coins";
	$credits = 0;
	$query = "INSERT INTO pack_notification VALUES ('','$user_id','$event_text','$event_type','$credits',now(),'$session_id')";
	mysqli_query($db,$query);
$notes = "1";
	}
	
if ($settings){
		echo "settings";
			
echo $mailinglist;	
mysqli_query($db, "UPDATE pack_user_extended set mailinglist = '$mailinglist' WHERE user_id = '$user_id'");
//mysqli_query($db, "UPDATE pack_user_extended set introflag = '$introflag' WHERE user_id = '$user_id'");
//mysqli_query($db, "UPDATE pack_user_extended set photoeffects = '$photoeffects' WHERE user_id = '$user_id'");
//mysqli_query($db, "UPDATE pack_user_extended set mailfinished = '$mailfinished' WHERE user_id = '$user_id'");
//mysqli_query($db, "UPDATE pack_user_extended set textfinished = '$textfinished' WHERE user_id = '$user_id'");
$event_text = "Updated Settings";
	$event_type ="fas fa-coins";
	$credits = 0;
	$query = "INSERT INTO pack_notification VALUES ('','$user_id','$event_text','$event_type','$credits',now(),'$session_id')";
	mysqli_query($db,$query);
$notes = "1";
	}
if(isset($_FILES["file"])){
	
 $output_dir = "/home/mvgen/public/mvgen.com/public/users/" . $username . "/";
  $filename = $_FILES["file"]['name'];
  $tmpfile = $_FILES["file"]['tmp_name'];
  $error = $_FILES["file"]["error"];
  $type = $_FILES["file"]['type'];
   $filename = preg_replace("/(?![.=$'€%-])\p{P}/u", "", $filename);
 $filename = preg_replace('/\s+/', '', $filename);
  //$filename = $current . $filename; 
//echo "files";
echo $filename;	
echo $output_dir;	
//if (!is_dir($output_dir)) {
	   mkdir($output_dir, 0777, true);
  //}
  move_uploaded_file($_FILES["file"]["tmp_name"],$output_dir. $filename);
mysqli_query($db, "UPDATE pack_user_extended set logo = '$filename' WHERE user_id = '$user_id'");
$event_text = "Updated Account Logo/Photo";
	$event_type ="fas fa-coins";
	$credits = 0;
	$query = "INSERT INTO pack_notification VALUES ('','$user_id','$event_text','$event_type','$credits',now(),'$session_id')";
	mysqli_query($db,$query);
$notes = "1";
}
?>
$stuff = mysqli_query($db,"SELECT * FROM pack_user where id = '$user_id'");
					while ($ratch = mysqli_fetch_array($stuff)) {
						$account_id = $ratch["id"];
						$email = $ratch["email"];
						$name = $ratch["usr"];
						$password = $ratch["password"];
						$df = $ratch["df"];
					}
					
				// pull all the info
$box = mysqli_query($db, "SELECT * FROM pack_user_extended where user_id = '$user_id'");
                    while ($rite = mysqli_fetch_array($box)) {
                        $extended_account_id = $rite["id"];
                        $logo = $rite["logo"];
                        $website = $rite["website"];
                        $facebook = $rite["facebook"];
                        $soundcloud = $rite["soundcloud"];
                        $youtube = $rite["youtube"];
                        $bandcamp = $rite["bandcamp"];
                        $twitter = $rite["twitter"];
                        $instagram = $rite["instagram"];
                        $snapchat = $rite["snapchat"];
                        $introflag = $rite["introflag"];
                        $status = $rite["status"];
                        $profile = $rite["profile"];
                        $photo = $rite["photo"];
                        $spotify = $rite["spotify"];
                        $cellphone = $rite["cellphone"];
                        $itunes = $rite["itunes"];
                        $mailinglist = $rite["mailinglist"];
                        $credits = $rite["credits"];
                        $coins = $rite["coins"];
                    }
					
					$crack = mysqli_query($db, "SELECT * FROM pack_song where user_id = '$user_id' and process_flag = 2 ORDER BY creation_date DESC");
					
$number_of_videos = mysqli_num_rows($crack);
					
					$total_views = 0;
					$total_likes = 0;
					
					$crack = mysqli_query($db, "SELECT * FROM pack_song where user_id = '$user_id' and process_flag = 2 ORDER BY creation_date DESC");
					while ($turtle = mysqli_fetch_array($crack)) {
						$old_video = $turtle["id"];
						# now go into pack_song_views
						$tabulate = mysqli_query($db, "SELECT * FROM pack_song_views where id = '$old_video'");
							while ($pip = mysqli_fetch_array($tabulate)) {
						$vs = $pip["views"];
						$ls = $pip["likes"];
						$total_views = $total_views + $vs;
						$total_likes = $total_likes + $ls;
							}
						
					}
					
					
					// need to pull views and likes!
					
$videosystem = 0;
$query = mysqli_query($db,"SELECT * FROM pack_song WHERE status LIKE '%PHASE%' order by status");
	while ($gather = mysqli_fetch_array($query )) {
		$videosystem++;
	}
	
                ?>