Code Duplication    Length = 16-17 lines in 5 locations

class/assessment_documentos.php 1 location

@@ 173-188 (lines=16) @@
170
     * @param  array $fields fields to fetch
171
     * @return XoopsObject {@link XoopsObject}
172
     */
173
    public function get($id = null, $fields = null)
174
    {
175
        $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_documentos') . ' WHERE cod_documento=' . $id;
176
        if (!$result = $this->db->query($sql)) {
177
            return false;
178
        }
179
        $numrows = $this->db->getRowsNum($result);
180
        if ($numrows == 1) {
181
            $assessment_documentos = new assessment_documentos();
182
            $assessment_documentos->assignVars($this->db->fetchArray($result));
183
184
            return $assessment_documentos;
185
        }
186
187
        return false;
188
    }
189
190
    /**
191
     * insert a new assessment_documentos in the database

class/assessment_perguntas.php 1 location

@@ 165-181 (lines=17) @@
162
     * @param  array $fields fields to fetch
163
     * @return XoopsObject {@link XoopsObject}
164
     */
165
    public function get($id = null, $fields = null)
166
    {
167
        $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_perguntas') . ' WHERE cod_pergunta=' . $id;
168
        if (!$result = $this->db->query($sql)) {
169
            return false;
170
        }
171
172
        $numrows = $this->db->getRowsNum($result);
173
        if ($numrows == 1) {
174
            $assessment_perguntas = new assessment_perguntas();
175
            $assessment_perguntas->assignVars($this->db->fetchArray($result));
176
177
            return $assessment_perguntas;
178
        }
179
180
        return false;
181
    }
182
183
    /**
184
     * insert a new assessment_perguntas in the database

class/assessment_provas.php 1 location

@@ 221-236 (lines=16) @@
218
     * @param  array $fields fields to fetch
219
     * @return XoopsObject {@link XoopsObject}
220
     */
221
    public function get($id = null, $fields = null)
222
    {
223
        $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_provas') . ' WHERE cod_prova=' . $id;
224
        if (!$result = $this->db->query($sql)) {
225
            return false;
226
        }
227
        $numrows = $this->db->getRowsNum($result);
228
        if ($numrows == 1) {
229
            $assessment_provas = new assessment_provas();
230
            $assessment_provas->assignVars($this->db->fetchArray($result));
231
232
            return $assessment_provas;
233
        }
234
235
        return false;
236
    }
237
238
    /**
239
     * insert a new assessment_provas in the database

class/assessment_respostas.php 1 location

@@ 159-174 (lines=16) @@
156
     * @param  array $fields fields to fetch
157
     * @return XoopsObject {@link XoopsObject}
158
     */
159
    public function get($id = null, $fields = null)
160
    {
161
        $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_respostas') . ' WHERE cod_resposta=' . $id;
162
        if (!$result = $this->db->query($sql)) {
163
            return false;
164
        }
165
        $numrows = $this->db->getRowsNum($result);
166
        if ($numrows == 1) {
167
            $assessment_respostas = new assessment_respostas();
168
            $assessment_respostas->assignVars($this->db->fetchArray($result));
169
170
            return $assessment_respostas;
171
        }
172
173
        return false;
174
    }
175
176
    /**
177
     * insert a new assessment_respostas in the database

class/assessment_resultados.php 1 location

@@ 281-296 (lines=16) @@
278
     * @param  array $fields fields to fetch
279
     * @return XoopsObject {@link XoopsObject}
280
     */
281
    public function get($id = null, $fields = null)
282
    {
283
        $sql = 'SELECT * FROM ' . $this->db->prefix('assessment_resultados') . ' WHERE cod_resultado=' . $id;
284
        if (!$result = $this->db->query($sql)) {
285
            return false;
286
        }
287
        $numrows = $this->db->getRowsNum($result);
288
        if ($numrows == 1) {
289
            $assessment_resultados = new assessment_resultados();
290
            $assessment_resultados->assignVars($this->db->fetchArray($result));
291
292
            return $assessment_resultados;
293
        }
294
295
        return false;
296
    }
297
298
    /**
299
     * insert a new assessment_resultados in the database