move/result.php at master · ectorrodrigues/move · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php

$username = $_GET['user'];
$link = $_GET['link'];

include 'app/config/database.php';
$conn = db();

$query  = $conn->prepare("SELECT id FROM users WHERE username = '$username' ");
$query->execute();
$username_id = $query->fetchColumn();

foreach($conn->query("SELECT * FROM links WHERE title = '$link' AND user_id = '$username_id' ") as $row) {
  $userlink     = $row['link'];
  $socialmedia  = $row['socialmedia'];
  $code         = $row['code'];
  $user_id      = $row['user_id'];
  $clicks       = $row['clicks'];
}

foreach($conn->query("SELECT * FROM users WHERE id = '$user_id' ") as $row) {
  $active   = $row['active'];
  $plan_id  = $row['plan_id'];
}

foreach($conn->query("SELECT SUM(clicks) AS totalclicks FROM links WHERE user_id = '$user_id' ") as $row) {
  $totalclicks   = $row['totalclicks'];
}

if($active == '1'){
  $continue = 'yes';

  foreach($conn->query("SELECT * FROM plans WHERE id = '$plan_id' ") as $row) {
    $links_limit   = $row['links_limit'];
  }

  if($links_limit < $totalclicks){
    $continue = 'no';
    $error_message = 'Este link excedeu o número de cliques do plano. Se você é o dono da conta que criou este link, acesse seu painel.<br><a href=\"https://movedl.com/admin\">Acesse movedl.com</a>';
  }

} else {
  $continue = 'no';
    $error_message = 'Este link está inativo. Se você é o dono desta conta, acesse seu painel.<br><a href=\"https://movedl.com/admin\">Acesse movedl.com</a>';
}


$clickscount = ($clicks+1);

$sql =  "UPDATE links SET clicks = $clickscount  WHERE code = '$code' ";
$query = $conn->prepare($sql);
$query->execute();

?>

<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>move link</title>
</head>
<body>

<div style="text-align:center; font-family:Arial, sans-serif; padding:150px 50px 0 50px; line-height:30px;" id="content">

<script type="text/javascript">
  if (screen.width <= 699) {

    <?php

    if($continue == 'yes'){
      if($socialmedia == 'instagram'){
        echo 'document.location = "instagram://'.$userlink.'";';
      }
      elseif($socialmedia == 'facebook'){
        echo 'document.location = "fb://profile/'.$userlink.'";';
      }
    } else {
      echo 'document.write("'.$error_message.'");';
    }
    ?>

  } else {

    <?php

    if($continue == 'yes'){
      if($socialmedia == 'instagram'){
        echo 'document.location = "https://instagram.com/'.$userlink.'";';
      }
      elseif($socialmedia == 'facebook'){
        echo 'document.location = "https://www.facebook.com/'.$userlink.'";';
      }
    } else {
      echo 'document.write("'.$error_message.'");';
    }

    ?>
  }
</script>

</div>

</body>
</html>