user_helper::fetch_user_username() - Code Metrics - Inspection of "use pdo" - the-real-sumsome/subrocks-2012 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — main (#3)

unknown

created 2021-10-03 12:30 UTC

user_helper::fetch_user_username() A

↳ Parent: Project

Complexity

Conditions	2
Paths	2

Size

Total Lines	13
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	10
nc	2
nop	1
dl	0
loc	13
rs	9.9332
c	0
b	0
f	0

<?php

/**
* @Auther: bhief
* @Version: 1.0
* @Added Base
*
* Use this class for getting user information
*
**/
class user_helper {
    public $__db;

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

    function fetch_pfp($username) {
        $stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username")
        $stmt->bindParam(":username", $username);

        $stmt->execute();
        while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $pfp = $row['pfp'];
        } // why the while statement? just remove it (i cant be bothered to)

        return (isset($pfp) ? $pfp : "default.png")
    }

    
    function fetch_unread_pms($user) {
        $stmt = $this->__db->prepare("SELECT * FROM pms WHERE touser = :user AND readed = 'n'");
        $stmt->bindParam(":user", $user);
        $stmt->execute();
    
        return $stmt->rowCount();
    }

    function if_blocked($user, $reciever) {
        $stmt = $this->__db->prepare("SELECT reciever FROM block WHERE sender = :user AND reciever = :reciever");
        $stmt->bindParam(":user", $user);
        $stmt->bindParam(":reciever", $reciever);
        $stmt->execute();

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

    function if_cooldown($user) {
        $stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username AND cooldown_comment >= NOW() - INTERVAL 1 MINUTE");
        $stmt->bindParam(":username", $user);
        $stmt->execute();
        
        return $stmt->rowCount() === 1;
    }

    function if_upload_cooldown($user) {
        $stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username AND upload_cooldown >= NOW() - INTERVAL 10 MINUTE");
        $stmt->bindParam(":username", $user);
        $stmt->execute();
        
        return $stmt->rowCount() === 1;
    }

    function fetch_user_username($username) {
        $stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username");
        $stmt->bindParam(":username", $username);
        $stmt->execute();

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

    function user_exists($user) {
        $stmt = $this->__db->prepare("SELECT username FROM users WHERE username = :username");
        $stmt->bindParam(":username", $user);
        $stmt->execute();

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

    function if_subscribed($user, $reciever) {
        $stmt = $this->__db->prepare("SELECT reciever FROM subscribers WHERE sender = :sender AND reciever = :reciever");
        $stmt->bindParam(":sender", $user);
        $stmt->bindParam(":reciever", $reciever);
        $stmt->execute();

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

    function fetch_subs_count($username) {
        $stmt = $this->__db->prepare("SELECT * FROM subscribers WHERE reciever = :username");
        $stmt->bindParam(":username", $username);
        $stmt->execute();

        return $stmt->rowCount();
    }

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

    function fetch_user_favorites(string $username) {
        $stmt = $this->__db->prepare("SELECT reciever FROM favorite_video WHERE sender = :username");
        $stmt->bindParam(":username", $username);
        $stmt->execute(); 
    
        return $stmt->rowCount();
    }

    function fetch_subscriptions($username) {
        $stmt = $this->__db->prepare("SELECT * FROM subscribers WHERE sender = :username");
        $stmt->bindParam(":username", $username);
        $stmt->execute();
    
        return $stmt->rowCount();
    }

    function get_channel_views(string $rid) {
        $stmt = $this->__db->prepare("SELECT * FROM channel_views WHERE channel = :rid");
        $stmt->bindParam(":rid", $rid);
        $stmt->execute();
        
        return $stmt->rowCount();
    }

    function fetch_friends_accepted($username) {
        $stmt = $this->__db->prepare("SELECT * FROM friends WHERE reciever = :username AND status = 'a'");
        $stmt->bindParam(":username", $username);
        $stmt->execute();
    
        $friends = $stmt->rowCount();

        $stmt = $this->__db->prepare("SELECT * FROM friends WHERE sender = :username AND status = 'a'");
        $stmt->bindParam(":username", $username);
        $stmt->execute();
    
        return $friends + $stmt->rowCount();
    }
}

?>

1			<?php
2
3			/**
4			* @Auther: bhief
5			* @Version: 1.0
6			* @Added Base
7			*
8			* Use this class for getting user information
9			*
10			**/
11			class user_helper {
12			public $__db;
13
14			public function __construct($conn){
15			$this->__db = $conn;
16			}
17
18			function fetch_pfp($username) {
19			$stmt = $this->__db->prepare("SELECT pfp FROM users WHERE username = :username")
20			$stmt->bindParam(":username", $username);
			0 ignored issues – show Bug introduced 2021-10-03 12:32 UTC by Report Bug Copy Issue Report A parse error occurred: Syntax error, unexpected T_VARIABLE on line 20 at column 8 Loading history...
21			$stmt->execute();
22			while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
23			$pfp = $row['pfp'];
24			} // why the while statement? just remove it (i cant be bothered to)
25
26			return (isset($pfp) ? $pfp : "default.png")
27			}
28
29
30			function fetch_unread_pms($user) {
31			$stmt = $this->__db->prepare("SELECT * FROM pms WHERE touser = :user AND readed = 'n'");
32			$stmt->bindParam(":user", $user);
33			$stmt->execute();
34
35			return $stmt->rowCount();
36			}
37
38			function if_blocked($user, $reciever) {
39			$stmt = $this->__db->prepare("SELECT reciever FROM block WHERE sender = :user AND reciever = :reciever");
40			$stmt->bindParam(":user", $user);
41			$stmt->bindParam(":reciever", $reciever);
42			$stmt->execute();
43
44			return $stmt->rowCount() === 1;
45			}
46
47			function if_cooldown($user) {
48			$stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username AND cooldown_comment >= NOW() - INTERVAL 1 MINUTE");
49			$stmt->bindParam(":username", $user);
50			$stmt->execute();
51
52			return $stmt->rowCount() === 1;
53			}
54
55			function if_upload_cooldown($user) {
56			$stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username AND upload_cooldown >= NOW() - INTERVAL 10 MINUTE");
57			$stmt->bindParam(":username", $user);
58			$stmt->execute();
59
60			return $stmt->rowCount() === 1;
61			}
62
63			function fetch_user_username($username) {
64			$stmt = $this->__db->prepare("SELECT * FROM users WHERE username = :username");
65			$stmt->bindParam(":username", $username);
66			$stmt->execute();
67
68			return ($stmt->rowCount() === 0 ? 0 : $stmt->fetch(PDO::FETCH_ASSOC));
69			}
70
71			function user_exists($user) {
72			$stmt = $this->__db->prepare("SELECT username FROM users WHERE username = :username");
73			$stmt->bindParam(":username", $user);
74			$stmt->execute();
75
76			return $stmt->rowCount() === 1;
77			}
78
79			function if_subscribed($user, $reciever) {
80			$stmt = $this->__db->prepare("SELECT reciever FROM subscribers WHERE sender = :sender AND reciever = :reciever");
81			$stmt->bindParam(":sender", $user);
82			$stmt->bindParam(":reciever", $reciever);
83			$stmt->execute();
84
85			return $stmt->rowCount() === 1;
86			}
87
88			function fetch_subs_count($username) {
89			$stmt = $this->__db->prepare("SELECT * FROM subscribers WHERE reciever = :username");
90			$stmt->bindParam(":username", $username);
91			$stmt->execute();
92
93			return $stmt->rowCount();
94			}
95
96			function fetch_user_videos(string $id) {
97			$stmt = $this->__db->prepare("SELECT rid FROM videos WHERE author = :id");
98			$stmt->bindParam(":id", $id);
99			$stmt->execute();
100
101			return $stmt->rowCount();
102			}
103
104			function fetch_user_favorites(string $username) {
105			$stmt = $this->__db->prepare("SELECT reciever FROM favorite_video WHERE sender = :username");
106			$stmt->bindParam(":username", $username);
107			$stmt->execute();
108
109			return $stmt->rowCount();
110			}
111
112			function fetch_subscriptions($username) {
113			$stmt = $this->__db->prepare("SELECT * FROM subscribers WHERE sender = :username");
114			$stmt->bindParam(":username", $username);
115			$stmt->execute();
116
117			return $stmt->rowCount();
118			}
119
120			function get_channel_views(string $rid) {
121			$stmt = $this->__db->prepare("SELECT * FROM channel_views WHERE channel = :rid");
122			$stmt->bindParam(":rid", $rid);
123			$stmt->execute();
124
125			return $stmt->rowCount();
126			}
127
128			function fetch_friends_accepted($username) {
129			$stmt = $this->__db->prepare("SELECT * FROM friends WHERE reciever = :username AND status = 'a'");
130			$stmt->bindParam(":username", $username);
131			$stmt->execute();
132
133			$friends = $stmt->rowCount();
134
135			$stmt = $this->__db->prepare("SELECT * FROM friends WHERE sender = :username AND status = 'a'");
136			$stmt->bindParam(":username", $username);
137			$stmt->execute();
138
139			return $friends + $stmt->rowCount();
140			}
141			}
142
143			?>

the-real-sumsome / subrocks-2012

Pull Request — main (#3)

user_helper::fetch_user_username() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like