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)) { |