video_helper - Code Metrics - Inspection of "chgggg" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — main ( e78405...a0a7aa )

by chief

created 2021-10-25 03:20 UTC

video_helper B

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	251
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	148
dl	0
loc	251
rs	8.96
c	1
b	0
f	0
wmc	43

22 Methods

Rating	Name	Size	Complexity
A	sh_exec()	12	6
A	fetch_video_views()	6	1
A	__construct()	2	1
A	file_get_contents_chunked()	17	3
A	fetch_views_from_user()	11	2
A	get_comments_from_video()	6	1
A	fetch_video_rid()	6	2
A	fetch_playlist_rid()	6	2
A	timeToSeekEquation()	17	4
A	if_comment_liked()	15	2
A	video_exists()	6	1
A	get_video_likes()	13	2
A	get_comment_likes()	13	2
A	if_liked()	15	2
A	get_video_stars_level()	7	1
A	shorten_description()	11	3
A	fetch_user_videos()	6	1
A	add_view()	5	1
A	if_favorited()	7	1
A	check_view()	7	2
A	get_video_responses()	6	1
A	fetch_comment_id()	6	2

How to fix Complexity

<?php

/**
* @Auther: bhief
* @Version: 1.0
*
* Gets info from videos 
*
**/
class video_helper {
    public $__db;

    public function sh_exec(string $cmd, string $outputfile = "", string $pidfile = "", bool $mergestderror = true, bool $bg = false) {
        $fullcmd = $cmd;
        if(strlen($outputfile) > 0) $fullcmd .= " >> " . $outputfile;
        if($mergestderror) $fullcmd .= " 2>&1";
        
        if($bg) {
            $fullcmd = "nohup " . $fullcmd . " &";
            if(strlen($pidfile)) $fullcmd .= " echo $! > " . $pidfile;
        } else {
            if(strlen($pidfile) > 0) $fullcmd .= "; echo $$ > " . $pidfile;
        }
        shell_exec($fullcmd);
    }

    function file_get_contents_chunked($file, $chunk_size, $callback) {

        try {
            $handle = fopen($file, "r");
            $i = 0;
            while (!feof($handle)) {
                call_user_func_array($callback,array(fread($handle,$chunk_size),&$handle,$i));
                $i++;
            }
    
            fclose($handle);
        }
        catch(Exception $e) {
            trigger_error("file_get_contents_chunked::" . $e->getMessage(),E_USER_NOTICE);
            return false;
        }

        return true;
    }

	public function __construct($conn){
        $this->__db = $conn;
	}

    function fetch_video_views(string $id) {

        $stmt = $this->__db->prepare("SELECT * FROM views WHERE videoid = :id");
        $stmt->bindParam(":id", $id);
        $stmt->execute();

        return $stmt->rowCount();
    }

    function fetch_views_from_user($user) {

        $stmt = $this->__db->prepare("SELECT `rid` FROM videos WHERE author = :username");
        $stmt->bindParam(":username", $user);
        $stmt->execute();
        
        $views = 0;
        while($video = $stmt->fetch(PDO::FETCH_ASSOC)) { 
            $views = $views + $this->fetch_video_views($video['rid']);
        }
        return $views;
        $stmt->close();
function fx() {
    try {
        doSomething();
        return true;
    }
    catch (\Exception $e) {
        return false;
    }

    return false;
}
    }

    function get_comments_from_video($id) {

        $stmt = $this->__db->prepare("SELECT * FROM comments WHERE toid = :id");
        $stmt->bindParam(":id", $id);
        $stmt->execute();
    
        return $stmt->rowCount();
    }

    /* Function by daylin */
    function timeToSeekEquation($time) { 

        $times = preg_split('/:/', $time);
        $timesc = count($times);
        $final = '';
        if ($times[0] != 0) {
            for ($i = 0; $i < $timesc; $i++) {
                $remaining = $timesc - $i - 1;
                if ($i < $timesc - 1) {
                    $final.=$times[$i].'*'.(60 ** $remaining).'+';
                } else {
                    $final.=$times[$i];
                }
            }
        } else {
            $final = $times[1];
        }
        return $final;
    }

    function shorten_description(string $description, int $limit, bool $newlines = false) {

        $description = trim($description);
        if(strlen($description) >= $limit) {
            $description = substr($description, 0, $limit) . "...";
        } 

        $description = htmlspecialchars($description);
        if($newlines) { $description = str_replace(PHP_EOL, "<br>", $description); }
        $description = preg_replace("/@([a-zA-Z0-9-]+|\\+\\])/", "<a href='/user/$1'>@$1</a>", $description);
        $description = preg_replace("/((\d{1,2}:)+\d{2})/", "<a onclick=\"yt.www.watch.player.seekTo('$1', false)\">$1</a>", $description);
        return $description;
    }

    function get_video_responses($id) {

        $stmt = $this->__db->prepare("SELECT * FROM video_response WHERE toid = :id");
        $stmt->bindParam(":id", $id);
        $stmt->execute();
    
        return $stmt->rowCount();
    }

    function get_video_likes($reciever, $liked) {

        if($liked) {
            $stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE reciever = :reciever AND type = 'l'");
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount();
        } else {
            $stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE reciever = :reciever AND type = 'd'");
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount();
        }
    }

    function check_view($vidid, $user) {

        $stmt = $this->__db->prepare("SELECT * FROM views WHERE viewer = :viewer AND videoid = :rid");
        $stmt->bindParam(":viewer", $user);
        $stmt->bindParam(":rid", $vidid);
        $stmt->execute();
        if($stmt->rowCount() === 0) {
            $this->add_view($vidid, $user);
        }
    }

    function add_view($vidid, $user) {

        $stmt = $this->__db->prepare("INSERT INTO views (viewer, videoid) VALUES (:user, :vidid)");
        $stmt->bindParam(":user", $user);
        $stmt->bindParam(":vidid", $vidid);
        $stmt->execute();
    }

    function get_comment_likes($reciever, $liked) {

        if($liked) {
            $stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE reciever = :reciever AND type = 'l'");
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount();
        } else {
            $stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE reciever = :reciever AND type = 'd'");
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount();
        }
    }

    function if_liked($user, $reciever, $liked) {

        if($liked) {
            $stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE sender = :sender AND reciever = :reciever AND type = 'l'");
            $stmt->bindParam(":sender", $user);
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount() === 1;
        } else {
            $stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE sender = :sender AND reciever = :reciever AND type = 'd'");
            $stmt->bindParam(":sender", $user);
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount() === 1;
        }
    }

    function if_comment_liked($user, $reciever, $liked) {

        if($liked) {
            $stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE sender = :sender AND reciever = :reciever AND type = 'l'");
            $stmt->bindParam(":sender", $user);
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount() === 1;
        } else {
            $stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE sender = :sender AND reciever = :reciever AND type = 'd'");
            $stmt->bindParam(":sender", $user);
            $stmt->bindParam(":reciever", $reciever);
            $stmt->execute();

            return $stmt->rowCount() === 1;
        }
    }

    function fetch_video_rid(string $rid) {

        $stmt = $this->__db->prepare("SELECT * FROM videos WHERE rid = :rid");
        $stmt->bindParam(":rid", $rid);
        $stmt->execute();

        return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
    }

    function fetch_playlist_rid(string $rid) {

        $stmt = $this->__db->prepare("SELECT * FROM playlists WHERE rid = :rid");
        $stmt->bindParam(":rid", $rid);
        $stmt->execute();

        return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
    }

    function fetch_comment_id(string $id) {

        $stmt = $this->__db->prepare("SELECT * FROM comments WHERE id = :id");
        $stmt->bindParam(":id", $id);
        $stmt->execute();

        return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
    }

    function get_video_stars_level($id, $level) {

        $stmt = $this->__db->prepare("SELECT * FROM stars WHERE reciever = :id AND type = :lvl");
        $stmt->bindParam(":id", $id);
        $stmt->bindParam(":lvl", $level, PDO::PARAM_INT);
        $stmt->execute();
    
        return $stmt->rowCount();
    }

    function video_exists($video) {

        $stmt = $this->__db->prepare("SELECT rid FROM videos WHERE rid = :rid");
        $stmt->bindParam(":rid", $video);
        $stmt->execute();
        
        return $stmt->rowCount() === 1;
    }

    function if_favorited($user, $reciever) {

        $stmt = $this->__db->prepare("SELECT `reciever` FROM favorite_video WHERE sender = :user AND reciever = :reciever");
        $stmt->bindParam(":user", $user);
        $stmt->bindParam(":reciever", $reciever);
        $stmt->execute();
        
        return $stmt->rowCount() === 1;
    }

    function fetch_user_videos($v) {

        $stmt = $this->__db->prepare("SELECT rid FROM videos WHERE author = :v");
        $stmt->bindParam(":v", $v);
        $stmt->execute(); 
    
        return $stmt->rowCount();
    }
}


/* SHITTY FIX INCOMING FOR EMBEDS - MOVE SO IT'S IN EVERY PAGE WHEN POSSIBLE AND NOT LAZY */
$__server->page_embeds->page_title = "SubRocks - " . $__server->page_title;
$__server->page_embeds->page_description = "Welcome to a Youtube recreation dedicated to replecating 2012's YouTube layout.";
$__server->page_embeds->page_url = "https://subrock.rocks/";
?>


1			<?php
2
3			/**
4			* @Auther: bhief
5			* @Version: 1.0
6			*
7			* Gets info from videos
8			*
9			**/
10			class video_helper {
11			public $__db;
12
13			public function sh_exec(string $cmd, string $outputfile = "", string $pidfile = "", bool $mergestderror = true, bool $bg = false) {
14			$fullcmd = $cmd;
15			if(strlen($outputfile) > 0) $fullcmd .= " >> " . $outputfile;
16			if($mergestderror) $fullcmd .= " 2>&1";
17
18			if($bg) {
19			$fullcmd = "nohup " . $fullcmd . " &";
20			if(strlen($pidfile)) $fullcmd .= " echo $! > " . $pidfile;
21			} else {
22			if(strlen($pidfile) > 0) $fullcmd .= "; echo $$ > " . $pidfile;
23			}
24			shell_exec($fullcmd);
25			}
26
27			function file_get_contents_chunked($file, $chunk_size, $callback) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
28			try {
29			$handle = fopen($file, "r");
30			$i = 0;
31			while (!feof($handle)) {
32			call_user_func_array($callback,array(fread($handle,$chunk_size),&$handle,$i));
33			$i++;
34			}
35
36			fclose($handle);
37			}
38			catch(Exception $e) {
39			trigger_error("file_get_contents_chunked::" . $e->getMessage(),E_USER_NOTICE);
40			return false;
41			}
42
43			return true;
44			}
45
46			public function __construct($conn){
47			$this->__db = $conn;
48			}
49
50			function fetch_video_views(string $id) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
51			$stmt = $this->__db->prepare("SELECT * FROM views WHERE videoid = :id");
52			$stmt->bindParam(":id", $id);
53			$stmt->execute();
54
55			return $stmt->rowCount();
56			}
57
58			function fetch_views_from_user($user) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
59			$stmt = $this->__db->prepare("SELECT `rid` FROM videos WHERE author = :username");
60			$stmt->bindParam(":username", $user);
61			$stmt->execute();
62
63			$views = 0;
64			while($video = $stmt->fetch(PDO::FETCH_ASSOC)) {
65			$views = $views + $this->fetch_video_views($video['rid']);
66			}
67			return $views;
68			$stmt->close();
			0 ignored issues – show Unused Code introduced 2021-10-16 05:41 UTC by Report Bug Copy Issue Report `$stmt->close()` is not reachable. This check looks for unreachable code. It uses sophisticated control flow analysis techniques to find statements which will never be executed. Unreachable code is most often the result of `return`, `die` or `exit` statements that have been added for debug purposes. function fx() { try { doSomething(); return true; } catch (\Exception $e) { return false; } return false; } In the above example, the last `return false` will never be executed, because a return statement has already been met in every possible execution path. Loading history...
69			}
70
71			function get_comments_from_video($id) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
72			$stmt = $this->__db->prepare("SELECT * FROM comments WHERE toid = :id");
73			$stmt->bindParam(":id", $id);
74			$stmt->execute();
75
76			return $stmt->rowCount();
77			}
78
79			/* Function by daylin */
80			function timeToSeekEquation($time) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
81			$times = preg_split('/:/', $time);
82			$timesc = count($times);
83			$final = '';
84			if ($times[0] != 0) {
85			for ($i = 0; $i < $timesc; $i++) {
86			$remaining = $timesc - $i - 1;
87			if ($i < $timesc - 1) {
88			$final.=$times[$i].''.(60 * $remaining).'+';
89			} else {
90			$final.=$times[$i];
91			}
92			}
93			} else {
94			$final = $times[1];
95			}
96			return $final;
97			}
98
99			function shorten_description(string $description, int $limit, bool $newlines = false) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
100			$description = trim($description);
101			if(strlen($description) >= $limit) {
102			$description = substr($description, 0, $limit) . "...";
103			}
104
105			$description = htmlspecialchars($description);
106			if($newlines) { $description = str_replace(PHP_EOL, "<br>", $description); }
107			$description = preg_replace("/@([a-zA-Z0-9-]+\|\\+\\])/", "<a href='/user/$1'>@$1</a>", $description);
108			$description = preg_replace("/((\d{1,2}:)+\d{2})/", "<a onclick=\"yt.www.watch.player.seekTo('$1', false)\">$1</a>", $description);
109			return $description;
110			}
111
112			function get_video_responses($id) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
113			$stmt = $this->__db->prepare("SELECT * FROM video_response WHERE toid = :id");
114			$stmt->bindParam(":id", $id);
115			$stmt->execute();
116
117			return $stmt->rowCount();
118			}
119
120			function get_video_likes($reciever, $liked) {
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
121			if($liked) {
122			$stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE reciever = :reciever AND type = 'l'");
123			$stmt->bindParam(":reciever", $reciever);
124			$stmt->execute();
125
126			return $stmt->rowCount();
127			} else {
128			$stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE reciever = :reciever AND type = 'd'");
129			$stmt->bindParam(":reciever", $reciever);
130			$stmt->execute();
131
132			return $stmt->rowCount();
133			}
134			}
135
136			function check_view($vidid, $user) {
			0 ignored issues – show Best Practice introduced 2021-10-10 22:11 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
137			$stmt = $this->__db->prepare("SELECT * FROM views WHERE viewer = :viewer AND videoid = :rid");
138			$stmt->bindParam(":viewer", $user);
139			$stmt->bindParam(":rid", $vidid);
140			$stmt->execute();
141			if($stmt->rowCount() === 0) {
142			$this->add_view($vidid, $user);
143			}
144			}
145
146			function add_view($vidid, $user) {
			0 ignored issues – show Best Practice introduced 2021-10-10 22:11 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
147			$stmt = $this->__db->prepare("INSERT INTO views (viewer, videoid) VALUES (:user, :vidid)");
148			$stmt->bindParam(":user", $user);
149			$stmt->bindParam(":vidid", $vidid);
150			$stmt->execute();
151			}
152
153			function get_comment_likes($reciever, $liked) {
			0 ignored issues – show Best Practice introduced 2021-10-10 22:11 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
154			if($liked) {
155			$stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE reciever = :reciever AND type = 'l'");
156			$stmt->bindParam(":reciever", $reciever);
157			$stmt->execute();
158
159			return $stmt->rowCount();
160			} else {
161			$stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE reciever = :reciever AND type = 'd'");
162			$stmt->bindParam(":reciever", $reciever);
163			$stmt->execute();
164
165			return $stmt->rowCount();
166			}
167			}
168
169			function if_liked($user, $reciever, $liked) {
			0 ignored issues – show Best Practice introduced 2021-10-10 22:11 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
170			if($liked) {
171			$stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE sender = :sender AND reciever = :reciever AND type = 'l'");
172			$stmt->bindParam(":sender", $user);
173			$stmt->bindParam(":reciever", $reciever);
174			$stmt->execute();
175
176			return $stmt->rowCount() === 1;
177			} else {
178			$stmt = $this->__db->prepare("SELECT `sender` FROM likes WHERE sender = :sender AND reciever = :reciever AND type = 'd'");
179			$stmt->bindParam(":sender", $user);
180			$stmt->bindParam(":reciever", $reciever);
181			$stmt->execute();
182
183			return $stmt->rowCount() === 1;
184			}
185			}
186
187			function if_comment_liked($user, $reciever, $liked) {
			0 ignored issues – show Best Practice introduced 2021-10-10 22:11 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
188			if($liked) {
189			$stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE sender = :sender AND reciever = :reciever AND type = 'l'");
190			$stmt->bindParam(":sender", $user);
191			$stmt->bindParam(":reciever", $reciever);
192			$stmt->execute();
193
194			return $stmt->rowCount() === 1;
195			} else {
196			$stmt = $this->__db->prepare("SELECT `sender` FROM comment_likes WHERE sender = :sender AND reciever = :reciever AND type = 'd'");
197			$stmt->bindParam(":sender", $user);
198			$stmt->bindParam(":reciever", $reciever);
199			$stmt->execute();
200
201			return $stmt->rowCount() === 1;
202			}
203			}
204
205			function fetch_video_rid(string $rid) {
			0 ignored issues – show Best Practice introduced 2021-10-16 05:32 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
206			$stmt = $this->__db->prepare("SELECT * FROM videos WHERE rid = :rid");
207			$stmt->bindParam(":rid", $rid);
208			$stmt->execute();
209
210			return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
211			}
212
213			function fetch_playlist_rid(string $rid) {
			0 ignored issues – show Best Practice introduced 2021-10-16 05:41 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
214			$stmt = $this->__db->prepare("SELECT * FROM playlists WHERE rid = :rid");
215			$stmt->bindParam(":rid", $rid);
216			$stmt->execute();
217
218			return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
219			}
220
221			function fetch_comment_id(string $id) {
			0 ignored issues – show Best Practice introduced 2021-10-24 03:07 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
222			$stmt = $this->__db->prepare("SELECT * FROM comments WHERE id = :id");
223			$stmt->bindParam(":id", $id);
224			$stmt->execute();
225
226			return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
227			}
228
229			function get_video_stars_level($id, $level) {
			0 ignored issues – show Best Practice introduced 2021-10-24 03:57 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
230			$stmt = $this->__db->prepare("SELECT * FROM stars WHERE reciever = :id AND type = :lvl");
231			$stmt->bindParam(":id", $id);
232			$stmt->bindParam(":lvl", $level, PDO::PARAM_INT);
233			$stmt->execute();
234
235			return $stmt->rowCount();
236			}
237
238			function video_exists($video) {
			0 ignored issues – show Best Practice introduced 2021-10-25 00:46 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
239			$stmt = $this->__db->prepare("SELECT rid FROM videos WHERE rid = :rid");
240			$stmt->bindParam(":rid", $video);
241			$stmt->execute();
242
243			return $stmt->rowCount() === 1;
244			}
245
246			function if_favorited($user, $reciever) {
			0 ignored issues – show Best Practice introduced 2021-10-25 00:46 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
247			$stmt = $this->__db->prepare("SELECT `reciever` FROM favorite_video WHERE sender = :user AND reciever = :reciever");
248			$stmt->bindParam(":user", $user);
249			$stmt->bindParam(":reciever", $reciever);
250			$stmt->execute();
251
252			return $stmt->rowCount() === 1;
253			}
254
255			function fetch_user_videos($v) {
			0 ignored issues – show Best Practice introduced 2021-10-25 03:23 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history...
256			$stmt = $this->__db->prepare("SELECT rid FROM videos WHERE author = :v");
257			$stmt->bindParam(":v", $v);
258			$stmt->execute();
259
260			return $stmt->rowCount();
261			}
262			}
263
264
265			/* SHITTY FIX INCOMING FOR EMBEDS - MOVE SO IT'S IN EVERY PAGE WHEN POSSIBLE AND NOT LAZY */
266			$__server->page_embeds->page_title = "SubRocks - " . $__server->page_title;
267			$__server->page_embeds->page_description = "Welcome to a Youtube recreation dedicated to replecating 2012's YouTube layout.";
268			$__server->page_embeds->page_url = "https://subrock.rocks/";
269			?>
			0 ignored issues – show Best Practice introduced 2021-10-01 05:40 UTC by Report Bug Copy Issue Report It is not recommended to use PHP's closing tag `?>` in files other than templates. Using a closing tag in PHP files that only contain PHP code is not recommended as you might accidentally add whitespace after the closing tag which would then be output by PHP. This can cause severe problems, for example headers cannot be sent anymore. A simple precaution is to leave off the closing tag as it is not required, and it also has no negative effects whatsoever. Loading history...

the-real-sumsome / subrocks-2012

Push — main ( e78405...a0a7aa )

video_helper B

Complexity

Size/Duplication

Importance

22 Methods

How to fix Complexity

Complex Class

Duplication Side-by-Side

Filter issues like