chamilo /
chamilo-lms
| @@ 16-31 (lines=16) @@ | ||
| 13 | */ |
|
| 14 | class WSCMInbox extends WSCM |
|
| 15 | { |
|
| 16 | public function unreadMessage($username, $password) |
|
| 17 | { |
|
| 18 | if ($this->verifyUserPass($username, $password) == "valid") |
|
| 19 | { |
|
| 20 | $table_message = Database::get_main_table(TABLE_MESSAGE); |
|
| 21 | $user_id = UserManager::get_user_id_from_username($username); |
|
| 22 | $condition_msg_status = ' msg_status = 1 '; // define('MESSAGE_STATUS_UNREAD', '1'); |
|
| 23 | ||
| 24 | $sql_query = "SELECT COUNT(*) as number_messages FROM $table_message WHERE $condition_msg_status AND user_receiver_id=".$user_id; |
|
| 25 | ||
| 26 | $sql_result = Database::query($sql_query); |
|
| 27 | $result = Database::fetch_array($sql_result); |
|
| 28 | return $result['number_messages']; |
|
| 29 | } |
|
| 30 | return "0"; |
|
| 31 | } |
|
| 32 | ||
| 33 | ||
| 34 | public function get_message_id( |
|
| @@ 565-580 (lines=16) @@ | ||
| 562 | } |
|
| 563 | } |
|
| 564 | } |
|
| 565 | public function unreadMessage($username, $password) |
|
| 566 | { |
|
| 567 | if ($this->verifyUserPass($username, $password) == "valid") |
|
| 568 | { |
|
| 569 | $table_message = Database::get_main_table(TABLE_MESSAGE); |
|
| 570 | $user_id = UserManager::get_user_id_from_username($username); |
|
| 571 | $condition_msg_status = ' msg_status = 1 '; // define('MESSAGE_STATUS_UNREAD', '1'); |
|
| 572 | ||
| 573 | $sql_query = "SELECT COUNT(*) as number_messages FROM $table_message WHERE $condition_msg_status AND user_receiver_id=".$user_id; |
|
| 574 | ||
| 575 | $sql_result = Database::query($sql_query); |
|
| 576 | $result = Database::fetch_array($sql_result); |
|
| 577 | return $result['number_messages']; |
|
| 578 | } |
|
| 579 | return "0"; |
|
| 580 | } |
|
| 581 | ||
| 582 | public function get_message_data($username, $password) |
|
| 583 | { |
|
