main/inc/lib/course.lib.php 1 location
|
@@ 3183-3192 (lines=10) @@
|
| 3180 |
|
WHERE user_id = $hr_manager_id AND relation_type=" . COURSE_RELATION_TYPE_RRHH . " "; |
| 3181 |
|
} |
| 3182 |
|
$result = Database::query($sql); |
| 3183 |
|
if (Database::num_rows($result) > 0) { |
| 3184 |
|
while ($row = Database::fetch_array($result)) { |
| 3185 |
|
$sql = "DELETE FROM $tbl_course_rel_user |
| 3186 |
|
WHERE |
| 3187 |
|
c_id = '{$row['c_id']}' AND |
| 3188 |
|
user_id = $hr_manager_id AND |
| 3189 |
|
relation_type=" . COURSE_RELATION_TYPE_RRHH . " "; |
| 3190 |
|
Database::query($sql); |
| 3191 |
|
} |
| 3192 |
|
} |
| 3193 |
|
|
| 3194 |
|
// inserting new courses list |
| 3195 |
|
if (is_array($courses_list)) { |
main/inc/lib/sessionmanager.lib.php 1 location
|
@@ 3137-3146 (lines=10) @@
|
| 3134 |
|
} |
| 3135 |
|
$result = Database::query($sql); |
| 3136 |
|
|
| 3137 |
|
if (Database::num_rows($result) > 0) { |
| 3138 |
|
while ($row = Database::fetch_array($result)) { |
| 3139 |
|
$sql = "DELETE FROM $tbl_session_rel_user |
| 3140 |
|
WHERE |
| 3141 |
|
session_id = {$row['session_id']} AND |
| 3142 |
|
user_id = $userId AND |
| 3143 |
|
relation_type =" . SESSION_RELATION_TYPE_RRHH; |
| 3144 |
|
Database::query($sql); |
| 3145 |
|
} |
| 3146 |
|
} |
| 3147 |
|
} |
| 3148 |
|
|
| 3149 |
|
// Inserting new sessions list. |
main/inc/lib/usermanager.lib.php 1 location
|
@@ 4541-4550 (lines=10) @@
|
| 4538 |
|
} |
| 4539 |
|
$result = Database::query($sql); |
| 4540 |
|
|
| 4541 |
|
if (Database::num_rows($result) > 0) { |
| 4542 |
|
while ($row = Database::fetch_array($result)) { |
| 4543 |
|
$sql = "DELETE FROM $userRelUserTable |
| 4544 |
|
WHERE |
| 4545 |
|
user_id = {$row['user_id']} AND |
| 4546 |
|
friend_user_id = $userId AND |
| 4547 |
|
relation_type = $relationType"; |
| 4548 |
|
Database::query($sql); |
| 4549 |
|
} |
| 4550 |
|
} |
| 4551 |
|
|
| 4552 |
|
if ($deleteUsersBeforeInsert) { |
| 4553 |
|
$sql = "DELETE FROM $userRelUserTable |
main/wiki/wiki.inc.php 1 location
|
@@ 5304-5309 (lines=6) @@
|
| 5301 |
|
echo '</ul></form>'; |
| 5302 |
|
} else { // We show the differences between two versions |
| 5303 |
|
$version_old = array(); |
| 5304 |
|
if (isset($_POST['old'])) { |
| 5305 |
|
$sql_old = "SELECT * FROM $tbl_wiki |
| 5306 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'"; |
| 5307 |
|
$result_old = Database::query($sql_old); |
| 5308 |
|
$version_old = Database::fetch_array($result_old); |
| 5309 |
|
} |
| 5310 |
|
|
| 5311 |
|
$sql_new = "SELECT * FROM $tbl_wiki |
| 5312 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'"; |