chamilo /
chamilo-lms
| @@ 233-238 (lines=6) @@ | ||
| 230 | $paramcount++; |
|
| 231 | } |
|
| 232 | ||
| 233 | if (isset($user_id)) { |
|
| 234 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 235 | else $sql .= ' WHERE'; |
|
| 236 | $sql .= ' user_id = '.intval($user_id); |
|
| 237 | $paramcount++; |
|
| 238 | } |
|
| 239 | ||
| 240 | if (isset($course_code) && $course_code <> '-1') { |
|
| 241 | $courseInfo = api_get_course_info($course_code); |
|
| @@ 253-258 (lines=6) @@ | ||
| 250 | } |
|
| 251 | } |
|
| 252 | ||
| 253 | if (isset($category_id)) { |
|
| 254 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 255 | else $sql .= ' WHERE'; |
|
| 256 | $sql .= ' category_id = '.intval($category_id); |
|
| 257 | $paramcount++; |
|
| 258 | } |
|
| 259 | ||
| 260 | if (isset($visible)) { |
|
| 261 | if ($paramcount != 0) $sql .= ' AND'; |
|
| @@ 260-265 (lines=6) @@ | ||
| 257 | $paramcount++; |
|
| 258 | } |
|
| 259 | ||
| 260 | if (isset($visible)) { |
|
| 261 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 262 | else $sql .= ' WHERE'; |
|
| 263 | $sql .= ' visible = '.intval($visible); |
|
| 264 | $paramcount++; |
|
| 265 | } |
|
| 266 | ||
| 267 | if (isset($locked)) { |
|
| 268 | if ($paramcount != 0) $sql .= ' AND'; |
|
| @@ 267-271 (lines=5) @@ | ||
| 264 | $paramcount++; |
|
| 265 | } |
|
| 266 | ||
| 267 | if (isset($locked)) { |
|
| 268 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 269 | else $sql .= ' WHERE'; |
|
| 270 | $sql .= ' locked = '.intval($locked); |
|
| 271 | } |
|
| 272 | ||
| 273 | $result = Database::query($sql); |
|
| 274 | $allEval = self::create_evaluation_objects_from_sql_result($result); |
|
| @@ 403-412 (lines=10) @@ | ||
| 400 | $paramcount++; |
|
| 401 | } |
|
| 402 | ||
| 403 | if (isset($user_id)) { |
|
| 404 | $user_id = intval($user_id); |
|
| 405 | if ($paramcount != 0) { |
|
| 406 | $sql .= ' AND'; |
|
| 407 | } else { |
|
| 408 | $sql .= ' WHERE'; |
|
| 409 | } |
|
| 410 | $sql .= ' user_id = '.intval($user_id); |
|
| 411 | $paramcount++; |
|
| 412 | } |
|
| 413 | ||
| 414 | if (isset($course_code)) { |
|
| 415 | if ($paramcount != 0) { |
|
| @@ 445-453 (lines=9) @@ | ||
| 442 | $paramcount++; |
|
| 443 | } |
|
| 444 | ||
| 445 | if (isset($parent_id)) { |
|
| 446 | if ($paramcount != 0) { |
|
| 447 | $sql .= ' AND '; |
|
| 448 | } else { |
|
| 449 | $sql .= ' WHERE '; |
|
| 450 | } |
|
| 451 | $sql .= ' parent_id = '.intval($parent_id); |
|
| 452 | $paramcount++; |
|
| 453 | } |
|
| 454 | ||
| 455 | if (isset($visible)) { |
|
| 456 | if ($paramcount != 0) { |
|
| @@ 455-462 (lines=8) @@ | ||
| 452 | $paramcount++; |
|
| 453 | } |
|
| 454 | ||
| 455 | if (isset($visible)) { |
|
| 456 | if ($paramcount != 0) { |
|
| 457 | $sql .= ' AND'; |
|
| 458 | } else { |
|
| 459 | $sql .= ' WHERE'; |
|
| 460 | } |
|
| 461 | $sql .= ' visible = '.intval($visible); |
|
| 462 | } |
|
| 463 | ||
| 464 | if (!empty($order_by)) { |
|
| 465 | if (!empty($order_by) && $order_by != '') { |
|
| @@ 249-254 (lines=6) @@ | ||
| 246 | $sql .= ' WHERE id = '.intval($id); |
|
| 247 | $paramcount++; |
|
| 248 | } |
|
| 249 | if (isset($type)) { |
|
| 250 | if ($paramcount != 0) { |
|
| 251 | $sql .= ' AND'; |
|
| 252 | } else { |
|
| 253 | $sql .= ' WHERE'; |
|
| 254 | } |
|
| 255 | $sql .= ' type = '.intval($type); |
|
| 256 | $paramcount++; |
|
| 257 | } |
|
| @@ 258-263 (lines=6) @@ | ||
| 255 | $sql .= ' type = '.intval($type); |
|
| 256 | $paramcount++; |
|
| 257 | } |
|
| 258 | if (isset($ref_id)) { |
|
| 259 | if ($paramcount != 0) { |
|
| 260 | $sql .= ' AND'; |
|
| 261 | } else { |
|
| 262 | $sql .= ' WHERE'; |
|
| 263 | } |
|
| 264 | $sql .= ' ref_id = '.intval($ref_id); |
|
| 265 | $paramcount++; |
|
| 266 | } |
|
| @@ 267-275 (lines=9) @@ | ||
| 264 | $sql .= ' ref_id = '.intval($ref_id); |
|
| 265 | $paramcount++; |
|
| 266 | } |
|
| 267 | if (isset($user_id)) { |
|
| 268 | if ($paramcount != 0) { |
|
| 269 | $sql .= ' AND'; |
|
| 270 | } else { |
|
| 271 | $sql .= ' WHERE'; |
|
| 272 | } |
|
| 273 | $sql .= ' user_id = '.intval($user_id); |
|
| 274 | $paramcount++; |
|
| 275 | } |
|
| 276 | if (isset($course_code)) { |
|
| 277 | if ($paramcount != 0) { |
|
| 278 | $sql .= ' AND'; |
|
| @@ 288-296 (lines=9) @@ | ||
| 285 | $paramcount++; |
|
| 286 | } |
|
| 287 | } |
|
| 288 | if (isset($category_id)) { |
|
| 289 | if ($paramcount != 0) { |
|
| 290 | $sql .= ' AND'; |
|
| 291 | } else { |
|
| 292 | $sql .= ' WHERE'; |
|
| 293 | } |
|
| 294 | $sql .= ' category_id = '.intval($category_id); |
|
| 295 | $paramcount++; |
|
| 296 | } |
|
| 297 | if (isset($visible)) { |
|
| 298 | if ($paramcount != 0) { |
|
| 299 | $sql .= ' AND'; |
|
| @@ 297-304 (lines=8) @@ | ||
| 294 | $sql .= ' category_id = '.intval($category_id); |
|
| 295 | $paramcount++; |
|
| 296 | } |
|
| 297 | if (isset($visible)) { |
|
| 298 | if ($paramcount != 0) { |
|
| 299 | $sql .= ' AND'; |
|
| 300 | } else { |
|
| 301 | $sql .= ' WHERE'; |
|
| 302 | } |
|
| 303 | $sql .= ' visible = '.intval($visible); |
|
| 304 | } |
|
| 305 | ||
| 306 | $result = Database::query($sql); |
|
| 307 | $links = self::create_objects_from_sql_result($result); |
|
