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++;
}
?>