chamilo /
chamilo-lms
| @@ 238-262 (lines=25) @@ | ||
| 235 | ); |
|
| 236 | } |
|
| 237 | ||
| 238 | if (!empty($this->course->type) && $this->course->type == 'partial') { |
|
| 239 | $sql = "SELECT d.id, d.path, d.comment, d.title, d.filetype, d.size |
|
| 240 | FROM $table_doc d |
|
| 241 | INNER JOIN $table_prop p |
|
| 242 | ON (p.ref = d.id AND d.c_id = p.c_id) |
|
| 243 | WHERE |
|
| 244 | d.c_id = $courseId AND |
|
| 245 | p.c_id = $courseId AND |
|
| 246 | tool = '".TOOL_DOCUMENT."' AND |
|
| 247 | p.visibility != 2 AND |
|
| 248 | path NOT LIKE '/images/gallery%' AND |
|
| 249 | $avoid_paths |
|
| 250 | $session_condition |
|
| 251 | ORDER BY path"; |
|
| 252 | } else { |
|
| 253 | $sql = "SELECT d.id, d.path, d.comment, d.title, d.filetype, d.size |
|
| 254 | FROM $table_doc d |
|
| 255 | INNER JOIN $table_prop p |
|
| 256 | ON (p.ref = d.id AND d.c_id = p.c_id) |
|
| 257 | WHERE |
|
| 258 | d.c_id = $courseId AND |
|
| 259 | p.c_id = $courseId AND |
|
| 260 | tool = '".TOOL_DOCUMENT."' AND |
|
| 261 | $avoid_paths AND |
|
| 262 | p.visibility != 2 $session_condition |
|
| 263 | ORDER BY path"; |
|
| 264 | } |
|
| 265 | ||
| @@ 279-304 (lines=26) @@ | ||
| 276 | $this->course->add_resource($doc); |
|
| 277 | } |
|
| 278 | } else { |
|
| 279 | if (!empty($this->course->type) && $this->course->type == 'partial') { |
|
| 280 | $sql = "SELECT d.id, d.path, d.comment, d.title, d.filetype, d.size |
|
| 281 | FROM $table_doc d |
|
| 282 | INNER JOIN $table_prop p |
|
| 283 | ON (p.ref = d.id AND d.c_id = p.c_id) |
|
| 284 | WHERE |
|
| 285 | d.c_id = $courseId AND |
|
| 286 | p.c_id = $courseId AND |
|
| 287 | tool = '".TOOL_DOCUMENT."' AND |
|
| 288 | p.visibility != 2 AND |
|
| 289 | path NOT LIKE '/images/gallery%' AND |
|
| 290 | $avoid_paths AND |
|
| 291 | (d.session_id = 0 OR d.session_id IS NULL) |
|
| 292 | ORDER BY path"; |
|
| 293 | } else { |
|
| 294 | $sql = "SELECT d.id, d.path, d.comment, d.title, d.filetype, d.size |
|
| 295 | FROM $table_doc d |
|
| 296 | INNER JOIN $table_prop p |
|
| 297 | ON (p.ref = d.id AND d.c_id = p.c_id) |
|
| 298 | WHERE |
|
| 299 | d.c_id = $courseId AND |
|
| 300 | p.c_id = $courseId AND |
|
| 301 | tool = '".TOOL_DOCUMENT."' AND |
|
| 302 | p.visibility != 2 AND |
|
| 303 | $avoid_paths AND |
|
| 304 | (d.session_id = 0 OR d.session_id IS NULL) |
|
| 305 | ORDER BY path"; |
|
| 306 | } |
|
| 307 | ||
