chamilo /
chamilo-lms
| @@ 254-270 (lines=17) @@ | ||
| 251 | * @param int $language_id |
|
| 252 | * @return bool |
|
| 253 | */ |
|
| 254 | public static function check_if_exist_language_by_id($language_id) |
|
| 255 | { |
|
| 256 | $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE); |
|
| 257 | $sql = 'SELECT count(*) as count |
|
| 258 | FROM ' . $table . ' |
|
| 259 | WHERE id="' . intval($language_id) . '"'; |
|
| 260 | $rs = Database::query($sql); |
|
| 261 | if (Database::num_rows($rs) > 0) { |
|
| 262 | if (Database::result($rs, 0, 'count') == 1) { |
|
| 263 | return true; |
|
| 264 | } else { |
|
| 265 | return false; |
|
| 266 | } |
|
| 267 | } else { |
|
| 268 | return false; |
|
| 269 | } |
|
| 270 | } |
|
| 271 | ||
| 272 | /** |
|
| 273 | * Get name of language by id |
|
| @@ 297-309 (lines=13) @@ | ||
| 294 | * |
|
| 295 | * @return bool |
|
| 296 | */ |
|
| 297 | public static function check_if_language_is_sub_language($language_id) |
|
| 298 | { |
|
| 299 | $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE); |
|
| 300 | $sql = 'SELECT count(*) AS count FROM ' . $table . ' |
|
| 301 | WHERE id = ' . intval($language_id) . ' AND NOT ISNULL(parent_id)'; |
|
| 302 | $rs = Database::query($sql); |
|
| 303 | ||
| 304 | if (Database::num_rows($rs) > 0 && Database::result($rs, '0', 'count') == 1) { |
|
| 305 | return true; |
|
| 306 | } else { |
|
| 307 | return false; |
|
| 308 | } |
|
| 309 | } |
|
| 310 | ||
| 311 | /** |
|
| 312 | * @param int $language_id |
|
| @@ 334-346 (lines=13) @@ | ||
| 331 | * @param Integer The language id |
|
| 332 | * @return Boolean |
|
| 333 | */ |
|
| 334 | public static function check_if_language_is_father($language_id) |
|
| 335 | { |
|
| 336 | $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE); |
|
| 337 | $sql = 'SELECT count(*) AS count FROM ' . $table . ' |
|
| 338 | WHERE parent_id= ' . intval($language_id) . ' AND NOT ISNULL(parent_id);'; |
|
| 339 | $rs = Database::query($sql); |
|
| 340 | ||
| 341 | if (Database::num_rows($rs) > 0 && Database::result($rs, '0', 'count') == 1) { |
|
| 342 | return true; |
|
| 343 | } else { |
|
| 344 | return false; |
|
| 345 | } |
|
| 346 | } |
|
| 347 | ||
| 348 | /** |
|
| 349 | * Make unavailable the language |
|
