|
@@ 707-709 (lines=3) @@
|
| 704 |
|
FROM ' . $table_user.' u |
| 705 |
|
INNER JOIN ' . $table_certificate.' gc |
| 706 |
|
ON u.user_id=gc.user_id '; |
| 707 |
|
if (!is_null($cat_id) && $cat_id > 0) { |
| 708 |
|
$sql .= ' WHERE cat_id='.intval($cat_id); |
| 709 |
|
} |
| 710 |
|
if (!empty($userList)) { |
| 711 |
|
$userList = array_map('intval', $userList); |
| 712 |
|
$userListCondition = implode("','", $userList); |
|
@@ 744-746 (lines=3) @@
|
| 741 |
|
gc.id |
| 742 |
|
FROM '.$table_certificate.' gc |
| 743 |
|
WHERE gc.user_id="' . intval($user_id).'" '; |
| 744 |
|
if (!is_null($cat_id) && $cat_id > 0) { |
| 745 |
|
$sql .= ' AND cat_id='.intval($cat_id); |
| 746 |
|
} |
| 747 |
|
|
| 748 |
|
$rs = Database::query($sql); |
| 749 |
|
$list_certificate = array(); |