chamilo /
chamilo-lms
| @@ 411-416 (lines=6) @@ | ||
| 408 | $tbl_group = Database::get_main_table(TABLE_MAIN_GROUP); |
|
| 409 | $user_id = intval($user_id); |
|
| 410 | ||
| 411 | if ($relation_type == 0) { |
|
| 412 | $where_relation_condition = ''; |
|
| 413 | } else { |
|
| 414 | $relation_type = intval($relation_type); |
|
| 415 | $where_relation_condition = "AND gu.relation_type = $relation_type "; |
|
| 416 | } |
|
| 417 | ||
| 418 | $sql = "SELECT g.picture_uri, g.name, g.description, g.id, gu.relation_type |
|
| 419 | FROM $tbl_group g |
|
| @@ 1341-1346 (lines=6) @@ | ||
| 1338 | $tbl_group = Database::get_main_table(TABLE_MAIN_GROUP); |
|
| 1339 | $user_id = intval($user_id); |
|
| 1340 | ||
| 1341 | if ($relation_type == 0) { |
|
| 1342 | $where_relation_condition = ''; |
|
| 1343 | } else { |
|
| 1344 | $relation_type = intval($relation_type); |
|
| 1345 | $where_relation_condition = "AND gu.relation_type = $relation_type "; |
|
| 1346 | } |
|
| 1347 | ||
| 1348 | $sql = "SELECT count(g.id) as count |
|
| 1349 | FROM $tbl_group g |
|
| @@ 2089-2094 (lines=6) @@ | ||
| 2086 | $tbl_group = $this->table; |
|
| 2087 | $user_id = intval($user_id); |
|
| 2088 | ||
| 2089 | if ($relation_type == 0) { |
|
| 2090 | $where_relation_condition = ''; |
|
| 2091 | } else { |
|
| 2092 | $relation_type = intval($relation_type); |
|
| 2093 | $where_relation_condition = "AND gu.relation_type = $relation_type "; |
|
| 2094 | } |
|
| 2095 | ||
| 2096 | $sql = "SELECT count(g.id) as count |
|
| 2097 | FROM $tbl_group g |
|
