Code Duplication    Length = 22-24 lines in 2 locations

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

@@ 1253-1276 (lines=24) @@
1250
        $course_id = api_get_course_int_id();
1251
        $html = null;
1252
1253
        if ($type == 'post') {
1254
            // Check if the user has already rated this post
1255
            $sql = "SELECT rating_id FROM $tbl_blogs_rating
1256
                    WHERE c_id = $course_id AND
1257
                    blog_id = '".(int) $blog_id."'
1258
                    AND item_id = '".(int) $post_id."'
1259
                    AND rating_type = '".Database::escape_string($type)."'
1260
                    AND user_id = '".(int) $_user['user_id']."'";
1261
            $result = Database::query($sql);
1262
            // Add rating
1263
            if (Database::num_rows($result) == 0) {
1264
                $html .= '<form class="form-horizontal" method="get" action="blog.php" id="frm_rating_'.$type.'_'.$post_id.'" name="frm_rating_'.$type.'_'.$post_id.'">';
1265
                $html .= '<div class="form-group">';
1266
                $html .= '<label class="col-sm-3 control-label">'.get_lang('RateThis').'</label>';
1267
                $html .= '<div class="col-sm-9">';
1268
                $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.'" />';
1269
                $html .= '</div>';
1270
                $html .= '</div>';
1271
                $html .= '</form>';
1272
1273
                return $html;
1274
            } else {
1275
                return '';
1276
            }
1277
        }
1278
1279
        if ($type = 'comment') {
@@ 1279-1300 (lines=22) @@
1276
            }
1277
        }
1278
1279
        if ($type = 'comment') {
1280
            // Check if the user has already rated this comment
1281
            $sql = "SELECT rating_id FROM $tbl_blogs_rating
1282
                    WHERE c_id = $course_id AND blog_id = '".(int) $blog_id."'
1283
                    AND item_id = '".(int) $comment_id."'
1284
                    AND rating_type = '".Database::escape_string($type)."'
1285
                    AND user_id = '".(int) $_user['user_id']."' ";
1286
            $result = Database::query($sql);
1287
            if (Database::num_rows($result) == 0) {
1288
                $html .= '<form class="form-horizontal" method="get" action="blog.php" id="frm_rating_'.$type.'_'.$comment_id.'" name="frm_rating_'.$type.'_'.$comment_id.'">';
1289
                $html .= '<div class="form-group">';
1290
                $html .= '<label class="col-sm-3 control-label">'.get_lang('RateThis').'</label>';
1291
                $html .= '<div class="col-sm-9">';
1292
                $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.'" />';
1293
                $html .= '</div>';
1294
                $html .= '</div>';
1295
                $html .= '</form>';
1296
1297
                return $html;
1298
            } else {
1299
                return '';
1300
            }
1301
        }
1302
    }
1303