chamilo /
chamilo-lms
| @@ 241-254 (lines=14) @@ | ||
| 238 | $unique_name = false; // This MUST be initializead. |
|
| 239 | $i = 0; |
|
| 240 | // Change session name, verify that session doesn't exist. |
|
| 241 | while (!$unique_name) { |
|
| 242 | if ($i > 1) { |
|
| 243 | $suffix = ' - '.$i; |
|
| 244 | } |
|
| 245 | $sql = 'SELECT 1 FROM '.$tbl_session.' |
|
| 246 | WHERE name="'.Database::escape_string($session_name.$suffix).'"'; |
|
| 247 | $rs = Database::query($sql); |
|
| 248 | if (Database::result($rs, 0, 0)) { |
|
| 249 | $i++; |
|
| 250 | } else { |
|
| 251 | $unique_name = true; |
|
| 252 | $session_name .= $suffix; |
|
| 253 | } |
|
| 254 | } |
|
| 255 | ||
| 256 | // Creating the session. |
|
| 257 | $sql_session = "INSERT IGNORE INTO $tbl_session SET |
|
| @@ 4176-4190 (lines=15) @@ | ||
| 4173 | $i = 0; |
|
| 4174 | // Change session name, verify that session doesn't exist. |
|
| 4175 | $suffix = null; |
|
| 4176 | while (!$unique_name) { |
|
| 4177 | if ($i > 1) { |
|
| 4178 | $suffix = ' - ' . $i; |
|
| 4179 | } |
|
| 4180 | $sql = 'SELECT 1 FROM ' . $tbl_session . ' |
|
| 4181 | WHERE name="' . $session_name . $suffix . '"'; |
|
| 4182 | $rs = Database::query($sql); |
|
| 4183 | ||
| 4184 | if (Database::result($rs, 0, 0)) { |
|
| 4185 | $i++; |
|
| 4186 | } else { |
|
| 4187 | $unique_name = true; |
|
| 4188 | $session_name .= $suffix; |
|
| 4189 | } |
|
| 4190 | } |
|
| 4191 | ||
| 4192 | $sessionCondition = ''; |
|
| 4193 | if (!empty($session_category_id)) { |
|
