Code Duplication    Length = 23-25 lines in 2 locations

main/inc/lib/blog.lib.php 2 locations

@@ 1279-1303 (lines=25) @@
1276
        $type = Database::escape_string($type);
1277
        $html = null;
1278
1279
        if ($type == 'post') {
1280
            // Check if the user has already rated this post
1281
            $sql = "SELECT rating_id FROM $tbl_blogs_rating
1282
                    WHERE c_id = $course_id AND
1283
                    blog_id = $blog_id
1284
                    AND item_id = $post_id
1285
                    AND rating_type = '$type'
1286
                    AND user_id = " . $_user['user_id'];
1287
            $result = Database::query($sql);
1288
            // Add rating
1289
            if (Database::num_rows($result) == 0) {
1290
                $html .= '<form class="form-horizontal" method="get" action="blog.php" id="frm_rating_'.$type.'_'.$post_id.'" name="frm_rating_'.$type.'_'.$post_id.'">';
1291
                $html .= '<div class="form-group">';
1292
                $html .= '<label class="col-sm-3 control-label">'.get_lang('RateThis').'</label>';
1293
                $html .= '<div class="col-sm-9">';
1294
                $html .= '<select class="selectpicker" name="rating" onchange="document.forms[\'frm_rating_'.$type.'_'.$post_id.'\'].submit()"><option value="">-</option><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select><input type="hidden" name="action" value="view_post" /><input type="hidden" name="type" value="'.$type.'" /><input type="hidden" name="do" value="rate" /><input type="hidden" name="blog_id" value="'.$blog_id.'" /><input type="hidden" name="post_id" value="'.$post_id.'" />';
1295
                $html .= '</div>';
1296
                $html .= '</div>';
1297
                $html .= '</form>';
1298
1299
                return $html;
1300
            } else {
1301
                return '';
1302
            }
1303
        }
1304
1305
        if ($type = 'comment') {
1306
            // Check if the user has already rated this comment
@@ 1305-1327 (lines=23) @@
1302
            }
1303
        }
1304
1305
        if ($type = 'comment') {
1306
            // Check if the user has already rated this comment
1307
            $sql = "SELECT rating_id FROM $tbl_blogs_rating
1308
                    WHERE c_id = $course_id AND blog_id = $blog_id
1309
                    AND item_id = $comment_id
1310
                    AND rating_type = '$type'
1311
                    AND user_id = ".$_user['user_id'];
1312
            $result = Database::query($sql);
1313
            if (Database::num_rows($result) == 0) {
1314
                $html .= '<form class="form-horizontal" method="get" action="blog.php" id="frm_rating_'.$type.'_'.$comment_id.'" name="frm_rating_'.$type.'_'.$comment_id.'">';
1315
                $html .= '<div class="form-group">';
1316
                $html .= '<label class="col-sm-3 control-label">'.get_lang('RateThis').'</label>';
1317
                $html .= '<div class="col-sm-9">';
1318
                $html .= '<select  class="selectpicker" name="rating" onchange="document.forms[\'frm_rating_'.$type.'_'.$comment_id.'\'].submit()"><option value="">-</option><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select><input type="hidden" name="action" value="view_post" /><input type="hidden" name="type" value="'.$type.'" /><input type="hidden" name="do" value="rate" /><input type="hidden" name="blog_id" value="'.$blog_id.'" /><input type="hidden" name="post_id" value="'.$post_id.'" /><input type="hidden" name="comment_id" value="'.$comment_id.'" />';
1319
                $html .= '</div>';
1320
                $html .= '</div>';
1321
                $html .= '</form>';
1322
1323
                return $html;
1324
            } else {
1325
                return '';
1326
            }
1327
        }
1328
    }
1329
1330
    /**