CloneSet349


Clone Mass	Clones in CloneSet	Parameter Count	Clone Similarity	Syntax Category [Sequence Length]
19	3	1	0.976	statement_sequence[6]

Clone Abstraction

Parameter Bindings

Clone Instance (Click to see clone)	Line Count	Source Line	Source File
1	19	48	plugins/authentication/openid/Auth/OpenID/MySQLStore.php
2	21	52	plugins/authentication/openid/Auth/OpenID/PostgreSQLStore.php
3	19	34	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 Abstraction

Parameter Count: 1

Parameter 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
1	1	`[[#53d1c0e0]]`	"INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)"
1	2	`[[#53d1c0e0]]`	"INSERT INTO %s (server_url, timestamp, salt) VALUES " . "(?, ?, ?)"
1	3	`[[#53d1c0e0]]`	"INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)"