@@ -11,9 +11,9 @@ |
||
11 | 11 | class user_helper { |
12 | 12 | public $__db; |
13 | 13 | |
14 | - public function __construct($conn){ |
|
14 | + public function __construct($conn){ |
|
15 | 15 | $this->__db = $conn; |
16 | - } |
|
16 | + } |
|
17 | 17 | |
18 | 18 | function fetch_pfp($username) { |
19 | 19 | $stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username"); |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | class user_helper { |
12 | 12 | public $__db; |
13 | 13 | |
14 | - public function __construct($conn){ |
|
14 | + public function __construct($conn) { |
|
15 | 15 | $this->__db = $conn; |
16 | 16 | } |
17 | 17 | |
@@ -19,7 +19,7 @@ discard block |
||
19 | 19 | $stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username"); |
20 | 20 | $stmt->bindParam(":username", $username); |
21 | 21 | $stmt->execute(); |
22 | - while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
22 | + while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { |
|
23 | 23 | $pfp = $row['pfp']; |
24 | 24 | } // why the while statement? just remove it (i cant be bothered to) |
25 | 25 | |
@@ -46,7 +46,7 @@ discard block |
||
46 | 46 | |
47 | 47 | function if_admin($user) { |
48 | 48 | $stmt = $this->__db->prepare("SELECT status FROM users WHERE username = :user AND status = 'admin'"); |
49 | - $stmt->bindParam(":user", $user);; |
|
49 | + $stmt->bindParam(":user", $user); ; |
|
50 | 50 | $stmt->execute(); |
51 | 51 | |
52 | 52 | return $stmt->rowCount() === 1; |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | |
55 | 55 | function if_partner($user) { |
56 | 56 | $stmt = $this->__db->prepare("SELECT partner FROM users WHERE username = :user AND partner = 'y'"); |
57 | - $stmt->bindParam(":user", $user);; |
|
57 | + $stmt->bindParam(":user", $user); ; |
|
58 | 58 | $stmt->execute(); |
59 | 59 | |
60 | 60 | return $stmt->rowCount() === 1; |
@@ -10,9 +10,9 @@ |
||
10 | 10 | class user_update { |
11 | 11 | public $__db; |
12 | 12 | |
13 | - public function __construct($conn){ |
|
13 | + public function __construct($conn){ |
|
14 | 14 | $this->__db = $conn; |
15 | - } |
|
15 | + } |
|
16 | 16 | |
17 | 17 | // fuck this, this can be compressed into 2 functions |
18 | 18 |
@@ -10,20 +10,20 @@ |
||
10 | 10 | class user_update { |
11 | 11 | public $__db; |
12 | 12 | |
13 | - public function __construct($conn){ |
|
13 | + public function __construct($conn) { |
|
14 | 14 | $this->__db = $conn; |
15 | 15 | } |
16 | 16 | |
17 | 17 | // fuck this, this can be compressed into 2 functions |
18 | 18 | |
19 | 19 | function update_cooldown_time($username, $rowName) { |
20 | - $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = now() WHERE username = :username"); |
|
20 | + $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = now() WHERE username = :username"); |
|
21 | 21 | $stmt->bindParam(":username", $username); |
22 | 22 | $stmt->execute(); |
23 | 23 | } |
24 | 24 | |
25 | 25 | function update_row($username, $rowName, $new) { |
26 | - $stmt = $this->__db->prepare("UPDATE users SET ".$rowName." = :new WHERE username = :username"); |
|
26 | + $stmt = $this->__db->prepare("UPDATE users SET " . $rowName . " = :new WHERE username = :username"); |
|
27 | 27 | $stmt->bindParam(":new", $new); |
28 | 28 | $stmt->bindParam(":username", $username); |
29 | 29 | $stmt->execute(); |
@@ -14,10 +14,10 @@ discard block |
||
14 | 14 | $ago = new DateTime($datetime); |
15 | 15 | $diff = $now->diff($ago); |
16 | 16 | |
17 | - $diff->w = floor($diff->d / 7); |
|
18 | - $diff->d -= $diff->w * 7; |
|
17 | + $diff->w = floor($diff->d/7); |
|
18 | + $diff->d -= $diff->w*7; |
|
19 | 19 | |
20 | - if(!isset($cLang)) { |
|
20 | + if (!isset($cLang)) { |
|
21 | 21 | $string = array( |
22 | 22 | 'y' => 'year', |
23 | 23 | 'm' => 'month', |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | ); |
40 | 40 | } |
41 | 41 | |
42 | - if(!isset($cLang)) { |
|
42 | + if (!isset($cLang)) { |
|
43 | 43 | foreach ($string as $k => &$v) { |
44 | 44 | if ($diff->$k) { |
45 | 45 | $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : ''); |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | } |
58 | 58 | } |
59 | 59 | |
60 | - if(!isset($cLang)) { |
|
60 | + if (!isset($cLang)) { |
|
61 | 61 | if (!$full) $string = array_slice($string, 0, 1); |
62 | 62 | return $string ? implode(', ', $string) . ' ago' : 'just now'; |
63 | 63 | } else { |
@@ -71,23 +71,23 @@ discard block |
||
71 | 71 | if ($seconds > 60*60*24) { |
72 | 72 | // over a day |
73 | 73 | return sprintf("%d:%s:%s:%s", |
74 | - floor($seconds/60/60/24), // Days |
|
75 | - str_pad( floor($seconds/60/60%24), 2, "0", STR_PAD_LEFT), // Hours |
|
76 | - str_pad( floor($seconds/60%60), 2, "0", STR_PAD_LEFT), // Minutes |
|
77 | - str_pad( $seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
74 | + floor($seconds/60/60/24), // Days |
|
75 | + str_pad(floor($seconds/60/60%24), 2, "0", STR_PAD_LEFT), // Hours |
|
76 | + str_pad(floor($seconds/60%60), 2, "0", STR_PAD_LEFT), // Minutes |
|
77 | + str_pad($seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
78 | 78 | ); |
79 | 79 | } else if ($seconds > 60*60) { |
80 | 80 | // over an hour |
81 | 81 | return sprintf("%d:%s:%s", |
82 | - floor($seconds/60/60), // Hours |
|
82 | + floor($seconds/60/60), // Hours |
|
83 | 83 | str_pad(floor($seconds/60%60), 2, "0", STR_PAD_LEFT), // Minutes |
84 | - str_pad( $seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
84 | + str_pad($seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
85 | 85 | ); |
86 | 86 | } else { |
87 | 87 | // less than an hour |
88 | 88 | return sprintf("%d:%s", |
89 | - floor($seconds/60), // Minutes |
|
90 | - str_pad( $seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
89 | + floor($seconds/60), // Minutes |
|
90 | + str_pad($seconds%60, 2, "0", STR_PAD_LEFT) // Seconds |
|
91 | 91 | ); |
92 | 92 | } |
93 | 93 | } |
@@ -58,10 +58,14 @@ |
||
58 | 58 | } |
59 | 59 | |
60 | 60 | if(!isset($cLang)) { |
61 | - if (!$full) $string = array_slice($string, 0, 1); |
|
61 | + if (!$full) { |
|
62 | + $string = array_slice($string, 0, 1); |
|
63 | + } |
|
62 | 64 | return $string ? implode(', ', $string) . ' ago' : 'just now'; |
63 | 65 | } else { |
64 | - if (!$full) $string = array_slice($string, 0, 1); |
|
66 | + if (!$full) { |
|
67 | + $string = array_slice($string, 0, 1); |
|
68 | + } |
|
65 | 69 | return $string ? implode($cLang['agoLeft'], $string) . " " . " " . $cLang['agoRight'] : $cLang['justNow']; |
66 | 70 | } |
67 | 71 | } |
@@ -10,9 +10,9 @@ |
||
10 | 10 | class video_updater { |
11 | 11 | public $__db; |
12 | 12 | |
13 | - public function __construct($conn){ |
|
13 | + public function __construct($conn){ |
|
14 | 14 | $this->__db = $conn; |
15 | - } |
|
15 | + } |
|
16 | 16 | |
17 | 17 | function update_row($video, $rowName, $new) { |
18 | 18 | $stmt = $this->__db->prepare("UPDATE videos SET ".$rowName." = :new WHERE rid = :rid"); |
@@ -10,12 +10,12 @@ discard block |
||
10 | 10 | class video_updater { |
11 | 11 | public $__db; |
12 | 12 | |
13 | - public function __construct($conn){ |
|
13 | + public function __construct($conn) { |
|
14 | 14 | $this->__db = $conn; |
15 | 15 | } |
16 | 16 | |
17 | 17 | function update_row($video, $rowName, $new) { |
18 | - $stmt = $this->__db->prepare("UPDATE videos SET ".$rowName." = :new WHERE rid = :rid"); |
|
18 | + $stmt = $this->__db->prepare("UPDATE videos SET " . $rowName . " = :new WHERE rid = :rid"); |
|
19 | 19 | $stmt->bindParam(":new", $new); |
20 | 20 | $stmt->bindParam(":rid", $video); |
21 | 21 | $stmt->execute(); |
@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | } |
25 | 25 | |
26 | 26 | function playlist_update_row($video, $rowName, $new) { |
27 | - $stmt = $this->__db->prepare("UPDATE playlists SET ".$rowName." = :new WHERE rid = :rid"); |
|
27 | + $stmt = $this->__db->prepare("UPDATE playlists SET " . $rowName . " = :new WHERE rid = :rid"); |
|
28 | 28 | $stmt->bindParam(":new", $new); |
29 | 29 | $stmt->bindParam(":rid", $video); |
30 | 30 | $stmt->execute(); |
@@ -10,13 +10,13 @@ |
||
10 | 10 | * |
11 | 11 | **/ |
12 | 12 | class db_helper { |
13 | - public function __construct(){ |
|
13 | + public function __construct(){ |
|
14 | 14 | |
15 | - } |
|
15 | + } |
|
16 | 16 | |
17 | - function fetch(string $table, array $where, string $extra) { |
|
17 | + function fetch(string $table, array $where, string $extra) { |
|
18 | 18 | |
19 | - } |
|
19 | + } |
|
20 | 20 | } |
21 | 21 | |
22 | 22 | ?> |
23 | 23 | \ No newline at end of file |
@@ -10,7 +10,7 @@ |
||
10 | 10 | * |
11 | 11 | **/ |
12 | 12 | class db_helper { |
13 | - public function __construct(){ |
|
13 | + public function __construct() { |
|
14 | 14 | |
15 | 15 | } |
16 | 16 |
@@ -18,7 +18,7 @@ |
||
18 | 18 | $video = $_video_fetch_utils->fetch_video_rid($video_response['toid']); |
19 | 19 | ?> |
20 | 20 | <?php |
21 | -if($video['author'] == $_SESSION['siteusername']) { |
|
21 | +if ($video['author'] == $_SESSION['siteusername']) { |
|
22 | 22 | $stmt = $conn->prepare("DELETE FROM video_response WHERE id = ?"); |
23 | 23 | $stmt->bind_param("s", $_GET['id']); |
24 | 24 | $stmt->execute(); |
@@ -20,13 +20,13 @@ |
||
20 | 20 | $name = $friend['reciever']; |
21 | 21 | $sender = $friend['sender']; |
22 | 22 | |
23 | -if($name != $_SESSION['siteusername']) { |
|
23 | +if ($name != $_SESSION['siteusername']) { |
|
24 | 24 | $doesnotown = true; |
25 | -} else if($sender != $_SESSION['siteusername']) { |
|
25 | +} else if ($sender != $_SESSION['siteusername']) { |
|
26 | 26 | $doesnotown2 = true; |
27 | 27 | } |
28 | 28 | |
29 | -if(!isset($_GET['id'])) { |
|
29 | +if (!isset($_GET['id'])) { |
|
30 | 30 | die("ID is not set"); |
31 | 31 | } |
32 | 32 |
@@ -17,7 +17,7 @@ |
||
17 | 17 | $comment = $_user_fetch_utils->fetch_profile_comment_id($_GET['id']); |
18 | 18 | ?> |
19 | 19 | <?php |
20 | -if($comment['toid'] == $_SESSION['siteusername']) { |
|
20 | +if ($comment['toid'] == $_SESSION['siteusername']) { |
|
21 | 21 | $stmt = $conn->prepare("DELETE FROM profile_comments WHERE id = ?"); |
22 | 22 | $stmt->bind_param("s", $_GET['id']); |
23 | 23 | $stmt->execute(); |
@@ -19,7 +19,7 @@ |
||
19 | 19 | |
20 | 20 | $name = $friend['reciever']; |
21 | 21 | |
22 | -if($name != $_SESSION['siteusername'] || !isset($_GET['id'])) { |
|
22 | +if ($name != $_SESSION['siteusername'] || !isset($_GET['id'])) { |
|
23 | 23 | die("You are not logged in or you did not put in an argument"); |
24 | 24 | } |
25 | 25 |