chamilo /
chamilo-lms
| @@ 246-251 (lines=6) @@ | ||
| 243 | $sql.= ' WHERE id = '.intval($id); |
|
| 244 | $paramcount ++; |
|
| 245 | } |
|
| 246 | if (isset($type)) { |
|
| 247 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 248 | else $sql .= ' WHERE'; |
|
| 249 | $sql .= ' type = '.intval($type); |
|
| 250 | $paramcount ++; |
|
| 251 | } |
|
| 252 | if (isset($ref_id)) { |
|
| 253 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 254 | else $sql .= ' WHERE'; |
|
| @@ 252-257 (lines=6) @@ | ||
| 249 | $sql .= ' type = '.intval($type); |
|
| 250 | $paramcount ++; |
|
| 251 | } |
|
| 252 | if (isset($ref_id)) { |
|
| 253 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 254 | else $sql .= ' WHERE'; |
|
| 255 | $sql .= ' ref_id = '.intval($ref_id); |
|
| 256 | $paramcount ++; |
|
| 257 | } |
|
| 258 | if (isset($user_id)) { |
|
| 259 | if ($paramcount != 0) { |
|
| 260 | $sql .= ' AND'; |
|
| @@ 258-266 (lines=9) @@ | ||
| 255 | $sql .= ' ref_id = '.intval($ref_id); |
|
| 256 | $paramcount ++; |
|
| 257 | } |
|
| 258 | if (isset($user_id)) { |
|
| 259 | if ($paramcount != 0) { |
|
| 260 | $sql .= ' AND'; |
|
| 261 | } else { |
|
| 262 | $sql .= ' WHERE'; |
|
| 263 | } |
|
| 264 | $sql .= ' user_id = '.intval($user_id); |
|
| 265 | $paramcount ++; |
|
| 266 | } |
|
| 267 | if (isset($course_code)) { |
|
| 268 | if ($paramcount != 0) { |
|
| 269 | $sql .= ' AND'; |
|
| @@ 276-284 (lines=9) @@ | ||
| 273 | $sql .= " course_code = '".Database::escape_string($course_code)."'"; |
|
| 274 | $paramcount ++; |
|
| 275 | } |
|
| 276 | if (isset($category_id)) { |
|
| 277 | if ($paramcount != 0) { |
|
| 278 | $sql .= ' AND'; |
|
| 279 | } else { |
|
| 280 | $sql .= ' WHERE'; |
|
| 281 | } |
|
| 282 | $sql .= ' category_id = '.intval($category_id); |
|
| 283 | $paramcount ++; |
|
| 284 | } |
|
| 285 | if (isset($visible)) { |
|
| 286 | if ($paramcount != 0) { |
|
| 287 | $sql .= ' AND'; |
|
| @@ 285-292 (lines=8) @@ | ||
| 282 | $sql .= ' category_id = '.intval($category_id); |
|
| 283 | $paramcount ++; |
|
| 284 | } |
|
| 285 | if (isset($visible)) { |
|
| 286 | if ($paramcount != 0) { |
|
| 287 | $sql .= ' AND'; |
|
| 288 | } else { |
|
| 289 | $sql .= ' WHERE'; |
|
| 290 | } |
|
| 291 | $sql .= ' visible = '.intval($visible); |
|
| 292 | } |
|
| 293 | ||
| 294 | $result = Database::query($sql); |
|
| 295 | $links = AbstractLink::create_objects_from_sql_result($result); |
|
| @@ 397-406 (lines=10) @@ | ||
| 394 | $paramcount ++; |
|
| 395 | } |
|
| 396 | ||
| 397 | if (isset($user_id)) { |
|
| 398 | $user_id = intval($user_id); |
|
| 399 | if ($paramcount != 0) { |
|
| 400 | $sql .= ' AND'; |
|
| 401 | } else { |
|
| 402 | $sql .= ' WHERE'; |
|
| 403 | } |
|
| 404 | $sql .= ' user_id = '.intval($user_id); |
|
| 405 | $paramcount++; |
|
| 406 | } |
|
| 407 | ||
| 408 | if (isset($course_code)) { |
|
| 409 | if ($paramcount != 0) { |
|
| @@ 439-447 (lines=9) @@ | ||
| 436 | $paramcount ++; |
|
| 437 | } |
|
| 438 | ||
| 439 | if (isset($parent_id)) { |
|
| 440 | if ($paramcount != 0) { |
|
| 441 | $sql .= ' AND '; |
|
| 442 | } else { |
|
| 443 | $sql .= ' WHERE '; |
|
| 444 | } |
|
| 445 | $sql .= ' parent_id = '.intval($parent_id); |
|
| 446 | $paramcount++; |
|
| 447 | } |
|
| 448 | ||
| 449 | if (isset($visible)) { |
|
| 450 | if ($paramcount != 0) { |
|
| @@ 449-456 (lines=8) @@ | ||
| 446 | $paramcount++; |
|
| 447 | } |
|
| 448 | ||
| 449 | if (isset($visible)) { |
|
| 450 | if ($paramcount != 0) { |
|
| 451 | $sql .= ' AND'; |
|
| 452 | } else { |
|
| 453 | $sql .= ' WHERE'; |
|
| 454 | } |
|
| 455 | $sql .= ' visible = '.intval($visible); |
|
| 456 | } |
|
| 457 | ||
| 458 | if (!empty($order_by)) { |
|
| 459 | if (!empty($order_by) && $order_by != '') { |
|
| @@ 234-239 (lines=6) @@ | ||
| 231 | $paramcount ++; |
|
| 232 | } |
|
| 233 | ||
| 234 | if (isset($user_id)) { |
|
| 235 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 236 | else $sql .= ' WHERE'; |
|
| 237 | $sql .= ' user_id = '.intval($user_id); |
|
| 238 | $paramcount ++; |
|
| 239 | } |
|
| 240 | ||
| 241 | if (isset($course_code) && $course_code <> '-1') { |
|
| 242 | $courseInfo = api_get_course_info($course_code); |
|
| @@ 254-259 (lines=6) @@ | ||
| 251 | } |
|
| 252 | } |
|
| 253 | ||
| 254 | if (isset($category_id)) { |
|
| 255 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 256 | else $sql .= ' WHERE'; |
|
| 257 | $sql .= ' category_id = '.intval($category_id); |
|
| 258 | $paramcount ++; |
|
| 259 | } |
|
| 260 | ||
| 261 | if (isset($visible)) { |
|
| 262 | if ($paramcount != 0) $sql .= ' AND'; |
|
| @@ 261-266 (lines=6) @@ | ||
| 258 | $paramcount ++; |
|
| 259 | } |
|
| 260 | ||
| 261 | if (isset($visible)) { |
|
| 262 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 263 | else $sql .= ' WHERE'; |
|
| 264 | $sql .= ' visible = '.intval($visible); |
|
| 265 | $paramcount ++; |
|
| 266 | } |
|
| 267 | ||
| 268 | if (isset($locked)) { |
|
| 269 | if ($paramcount != 0) $sql .= ' AND'; |
|
| @@ 268-272 (lines=5) @@ | ||
| 265 | $paramcount ++; |
|
| 266 | } |
|
| 267 | ||
| 268 | if (isset($locked)) { |
|
| 269 | if ($paramcount != 0) $sql .= ' AND'; |
|
| 270 | else $sql .= ' WHERE'; |
|
| 271 | $sql .= ' locked = '.intval($locked); |
|
| 272 | } |
|
| 273 | ||
| 274 | $result = Database::query($sql); |
|
| 275 | $allEval = Evaluation::create_evaluation_objects_from_sql_result($result); |
|
