CloneSet349


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
19310.976statement_sequence[6]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
11948
plugins/authentication/openid/Auth/OpenID/MySQLStore.php
22152
plugins/authentication/openid/Auth/OpenID/PostgreSQLStore.php
31934
plugins/authentication/openid/Auth/OpenID/SQLiteStore.php
Clone Instance
1
Line Count
19
Source Line
48
Source File
plugins/authentication/openid/Auth/OpenID/MySQLStore.php

        $this->sql['get_assocs']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ?";

        $this->sql['get_assoc']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ? AND handle = ?";

        $this->sql['remove_assoc']=
            "DELETE FROM %s WHERE server_url = ? AND handle = ?";

        $this->sql['add_nonce']=
            "INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)";

        $this->sql['clean_nonce']=
            "DELETE FROM %s WHERE timestamp < ?";

        $this->sql['clean_assoc']=
            "DELETE FROM %s WHERE issued + lifetime < ?";


Clone Instance
2
Line Count
21
Source Line
52
Source File
plugins/authentication/openid/Auth/OpenID/PostgreSQLStore.php

        $this->sql['get_assocs']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ?";

        $this->sql['get_assoc']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ? AND handle = ?";

        $this->sql['remove_assoc']=
            "DELETE FROM %s WHERE server_url = ? AND handle = ?";

        $this->sql['add_nonce']=
                  "INSERT INTO %s (server_url, timestamp, salt) VALUES "
                  . "(?, ?, ?)";


        $this->sql['clean_nonce']=
            "DELETE FROM %s WHERE timestamp < ?";

        $this->sql['clean_assoc']=
            "DELETE FROM %s WHERE issued + lifetime < ?";


Clone Instance
3
Line Count
19
Source Line
34
Source File
plugins/authentication/openid/Auth/OpenID/SQLiteStore.php

        $this->sql['get_assocs']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ?";

        $this->sql['get_assoc']=
            "SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
            . "WHERE server_url = ? AND handle = ?";

        $this->sql['remove_assoc']=
            "DELETE FROM %s WHERE server_url = ? AND handle = ?";

        $this->sql['add_nonce']=
            "INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)";

        $this->sql['clean_nonce']=
            "DELETE FROM %s WHERE timestamp < ?";

        $this->sql['clean_assoc']=
            "DELETE FROM %s WHERE issued + lifetime < ?";


Clone AbstractionParameter Count: 1Parameter Bindings

$this->sql['get_assocs']="SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
                         . "WHERE server_url = ?";
$this->sql['get_assoc']="SELECT handle, secret, issued, lifetime, assoc_type FROM %s "
                        . "WHERE server_url = ? AND handle = ?";
$this->sql['remove_assoc']="DELETE FROM %s WHERE server_url = ? AND handle = ?";
$this->sql['add_nonce']= [[#variable53d1c0e0]];
$this->sql['clean_nonce']="DELETE FROM %s WHERE timestamp < ?";
$this->sql['clean_assoc']="DELETE FROM %s WHERE issued + lifetime < ?";
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#53d1c0e0]]
"INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)" 
12[[#53d1c0e0]]
"INSERT INTO %s (server_url, timestamp, salt) VALUES "
. "(?, ?, ?)" 
13[[#53d1c0e0]]
"INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)"