View GitHub Repository XoopsCore

Schedule Inspection
Subscribe

Code Duplication    Length = 9-13 lines in 6 locations

htdocs/class/database/manager.php 3 locations

@@ 137-145 (lines=9) @@
134 
            if ($prefixed_query != false) {
135 
                $table = $this->db->prefix($prefixed_query[4]);
136 
                if ($prefixed_query[1] === 'CREATE TABLE') {
137 
                    if ($this->db->$queryFunc($prefixed_query[0]) != false) {
138 
                        if (!isset($this->s_tables['create'][$table])) {
139 
                            $this->s_tables['create'][$table] = 1;
140 
                        }
141 
                    } else {
142 
                        if (!isset($this->f_tables['create'][$table])) {
143 
                            $this->f_tables['create'][$table] = 1;
144 
                        }
145 
                    }
146 
                } else {
147 
                    if ($prefixed_query[1] === 'INSERT INTO') {
148 
                        if ($this->db->$queryFunc($prefixed_query[0]) != false) {
@@ 163-171 (lines=9) @@
160 
                        }
161 
                    } else {
162 
                        if ($prefixed_query[1] === 'ALTER TABLE') {
163 
                            if ($this->db->$queryFunc($prefixed_query[0]) != false) {
164 
                                if (!isset($this->s_tables['alter'][$table])) {
165 
                                    $this->s_tables['alter'][$table] = 1;
166 
                                }
167 
                            } else {
168 
                                if (!isset($this->s_tables['alter'][$table])) {
169 
                                    $this->f_tables['alter'][$table] = 1;
170 
                                }
171 
                            }
172 
                        } else {
173 
                            if ($prefixed_query[1] === 'DROP TABLE') {
174 
                                if ($this->db->$queryFunc('DROP TABLE ' . $table) != false) {
@@ 172-184 (lines=13) @@
169 
                                    $this->f_tables['alter'][$table] = 1;
170 
                                }
171 
                            }
172 
                        } else {
173 
                            if ($prefixed_query[1] === 'DROP TABLE') {
174 
                                if ($this->db->$queryFunc('DROP TABLE ' . $table) != false) {
175 
                                    if (!isset($this->s_tables['drop'][$table])) {
176 
                                        $this->s_tables['drop'][$table] = 1;
177 
                                    }
178 
                                } else {
179 
                                    if (!isset($this->s_tables['drop'][$table])) {
180 
                                        $this->f_tables['drop'][$table] = 1;
181 
                                    }
182 
                                }
183 
                            }
184 
                        }
185 
                    }
186 
                }
187 
            }

upgrade/upd-2.4.x-to-2.5.0/dbmanager.php 3 locations

@@ 80-88 (lines=9) @@
77 
            if ($prefixed_query != false ) {
78 
                $table = $this->db->prefix($prefixed_query[4]);
79 
                if ($prefixed_query[1] == 'CREATE TABLE') {
80 
                    if ($this->db->query($prefixed_query[0]) != false) {
81 
                        if (!isset($this->s_tables['create'][$table])) {
82 
                            $this->s_tables['create'][$table] = 1;
83 
                        }
84 
                    } else {
85 
                        if (!isset($this->f_tables['create'][$table])) {
86 
                            $this->f_tables['create'][$table] = 1;
87 
                        }
88 
                    }
89 
                } else if ($prefixed_query[1] == 'INSERT INTO') {
90 
                    if ($this->db->query($prefixed_query[0]) != false) {
91 
                        if (!isset($this->s_tables['insert'][$table])) {
@@ 104-112 (lines=9) @@
101 
                        }
102 
                    }
103 
                } else if ($prefixed_query[1] == 'ALTER TABLE') {
104 
                    if ($this->db->query($prefixed_query[0]) != false) {
105 
                        if (!isset($this->s_tables['alter'][$table])) {
106 
                            $this->s_tables['alter'][$table] = 1;
107 
                        }
108 
                    } else {
109 
                        if (!isset($this->s_tables['alter'][$table])) {
110 
                            $this->f_tables['alter'][$table] = 1;
111 
                        }
112 
                    }
113 
                } else if ($prefixed_query[1] == 'DROP TABLE') {
114 
                    if ($this->db->query('DROP TABLE '.$table) != false) {
115 
                        if (!isset($this->s_tables['drop'][$table])) {
@@ 113-123 (lines=11) @@
110 
                            $this->f_tables['alter'][$table] = 1;
111 
                        }
112 
                    }
113 
                } else if ($prefixed_query[1] == 'DROP TABLE') {
114 
                    if ($this->db->query('DROP TABLE '.$table) != false) {
115 
                        if (!isset($this->s_tables['drop'][$table])) {
116 
                            $this->s_tables['drop'][$table] = 1;
117 
                        }
118 
                    } else {
119 
                        if (!isset($this->s_tables['drop'][$table])) {
120 
                            $this->f_tables['drop'][$table] = 1;
121 
                        }
122 
                    }
123 
                }
124 
            }
125 
        }
126 
        return true;