main/inc/lib/course.lib.php 1 location
|
@@ 3222-3231 (lines=10) @@
|
| 3219 |
|
WHERE user_id = $hr_manager_id AND relation_type=".COURSE_RELATION_TYPE_RRHH." "; |
| 3220 |
|
} |
| 3221 |
|
$result = Database::query($sql); |
| 3222 |
|
if (Database::num_rows($result) > 0) { |
| 3223 |
|
while ($row = Database::fetch_array($result)) { |
| 3224 |
|
$sql = "DELETE FROM $tbl_course_rel_user |
| 3225 |
|
WHERE |
| 3226 |
|
c_id = '{$row['c_id']}' AND |
| 3227 |
|
user_id = $hr_manager_id AND |
| 3228 |
|
relation_type=".COURSE_RELATION_TYPE_RRHH." "; |
| 3229 |
|
Database::query($sql); |
| 3230 |
|
} |
| 3231 |
|
} |
| 3232 |
|
|
| 3233 |
|
// inserting new courses list |
| 3234 |
|
if (is_array($courses_list)) { |
main/inc/lib/sessionmanager.lib.php 1 location
|
@@ 3240-3249 (lines=10) @@
|
| 3237 |
|
} |
| 3238 |
|
$result = Database::query($sql); |
| 3239 |
|
|
| 3240 |
|
if (Database::num_rows($result) > 0) { |
| 3241 |
|
while ($row = Database::fetch_array($result)) { |
| 3242 |
|
$sql = "DELETE FROM $tbl_session_rel_user |
| 3243 |
|
WHERE |
| 3244 |
|
session_id = {$row['session_id']} AND |
| 3245 |
|
user_id = $userId AND |
| 3246 |
|
relation_type =".SESSION_RELATION_TYPE_RRHH; |
| 3247 |
|
Database::query($sql); |
| 3248 |
|
} |
| 3249 |
|
} |
| 3250 |
|
} |
| 3251 |
|
|
| 3252 |
|
// Inserting new sessions list. |
main/inc/lib/usermanager.lib.php 1 location
|
@@ 4542-4551 (lines=10) @@
|
| 4539 |
|
} |
| 4540 |
|
$result = Database::query($sql); |
| 4541 |
|
|
| 4542 |
|
if (Database::num_rows($result) > 0) { |
| 4543 |
|
while ($row = Database::fetch_array($result)) { |
| 4544 |
|
$sql = "DELETE FROM $userRelUserTable |
| 4545 |
|
WHERE |
| 4546 |
|
user_id = {$row['user_id']} AND |
| 4547 |
|
friend_user_id = $userId AND |
| 4548 |
|
relation_type = $relationType"; |
| 4549 |
|
Database::query($sql); |
| 4550 |
|
} |
| 4551 |
|
} |
| 4552 |
|
|
| 4553 |
|
if ($deleteUsersBeforeInsert) { |
| 4554 |
|
$sql = "DELETE FROM $userRelUserTable |
main/wiki/wiki.inc.php 1 location
|
@@ 5381-5386 (lines=6) @@
|
| 5378 |
|
echo '</ul></form>'; |
| 5379 |
|
} else { // We show the differences between two versions |
| 5380 |
|
$version_old = array(); |
| 5381 |
|
if (isset($_POST['old'])) { |
| 5382 |
|
$sql_old = "SELECT * FROM $tbl_wiki |
| 5383 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'"; |
| 5384 |
|
$result_old = Database::query($sql_old); |
| 5385 |
|
$version_old = Database::fetch_array($result_old); |
| 5386 |
|
} |
| 5387 |
|
|
| 5388 |
|
$sql_new = "SELECT * FROM $tbl_wiki |
| 5389 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'"; |