@@ -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; |
@@ -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 | |