main/inc/lib/course.lib.php 1 location
|
@@ 2925-2934 (lines=10) @@
|
| 2922 |
|
WHERE user_id = $hr_manager_id AND relation_type=" . COURSE_RELATION_TYPE_RRHH . " "; |
| 2923 |
|
} |
| 2924 |
|
$result = Database::query($sql); |
| 2925 |
|
if (Database::num_rows($result) > 0) { |
| 2926 |
|
while ($row = Database::fetch_array($result)) { |
| 2927 |
|
$sql = "DELETE FROM $tbl_course_rel_user |
| 2928 |
|
WHERE |
| 2929 |
|
c_id = '{$row['c_id']}' AND |
| 2930 |
|
user_id = $hr_manager_id AND |
| 2931 |
|
relation_type=" . COURSE_RELATION_TYPE_RRHH . " "; |
| 2932 |
|
Database::query($sql); |
| 2933 |
|
} |
| 2934 |
|
} |
| 2935 |
|
|
| 2936 |
|
// inserting new courses list |
| 2937 |
|
if (is_array($courses_list)) { |
main/inc/lib/usermanager.lib.php 1 location
|
@@ 4154-4163 (lines=10) @@
|
| 4151 |
|
} |
| 4152 |
|
$result = Database::query($sql); |
| 4153 |
|
|
| 4154 |
|
if (Database::num_rows($result) > 0) { |
| 4155 |
|
while ($row = Database::fetch_array($result)) { |
| 4156 |
|
$sql = "DELETE FROM $userRelUserTable " |
| 4157 |
|
. "WHERE user_id = {$row['user_id']} " |
| 4158 |
|
. "AND friend_user_id = $userId " |
| 4159 |
|
. "AND relation_type = $relationType"; |
| 4160 |
|
|
| 4161 |
|
Database::query($sql); |
| 4162 |
|
} |
| 4163 |
|
} |
| 4164 |
|
|
| 4165 |
|
// Inserting new user list |
| 4166 |
|
if (is_array($subscribedUsersId)) { |
main/wiki/wiki.inc.php 1 location
|
@@ 5247-5252 (lines=6) @@
|
| 5244 |
|
echo '</ul></form>'; |
| 5245 |
|
} else { // We show the differences between two versions |
| 5246 |
|
$version_old = array(); |
| 5247 |
|
if (isset($_POST['old'])) { |
| 5248 |
|
$sql_old = "SELECT * FROM $tbl_wiki |
| 5249 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['old'])."'"; |
| 5250 |
|
$result_old = Database::query($sql_old); |
| 5251 |
|
$version_old = Database::fetch_array($result_old); |
| 5252 |
|
} |
| 5253 |
|
|
| 5254 |
|
$sql_new = "SELECT * FROM $tbl_wiki |
| 5255 |
|
WHERE c_id = $course_id AND id='".Database::escape_string($_POST['new'])."'"; |
main/inc/lib/sessionmanager.lib.php 1 location
|
@@ 2920-2929 (lines=10) @@
|
| 2917 |
|
} |
| 2918 |
|
$result = Database::query($sql); |
| 2919 |
|
|
| 2920 |
|
if (Database::num_rows($result) > 0) { |
| 2921 |
|
while ($row = Database::fetch_array($result)) { |
| 2922 |
|
$sql = "DELETE FROM $tbl_session_rel_user |
| 2923 |
|
WHERE |
| 2924 |
|
session_id = {$row['session_id']} AND |
| 2925 |
|
user_id = $userId AND |
| 2926 |
|
relation_type=" . SESSION_RELATION_TYPE_RRHH . " "; |
| 2927 |
|
Database::query($sql); |
| 2928 |
|
} |
| 2929 |
|
} |
| 2930 |
|
} |
| 2931 |
|
// Inserting new sessions list. |
| 2932 |
|
if (!empty($sessions_list) && is_array($sessions_list)) { |