Parent Directory
| 
Revision Log
Add new message check
| 1 | sysadm | 1.1 | <? |
| 2 | function check_new_msg(int $uid, mysqli $db_conn) : int | ||
| 3 | { | ||
| 4 | $new_msg = 0; | ||
| 5 | |||
| 6 | $sql = "SELECT COUNT(*) AS msg_count FROM bbs_msg | ||
| 7 | WHERE toUID = $uid AND new = 1 AND deleted = 0"; | ||
| 8 | |||
| 9 | $rs = mysqli_query($db_conn, $sql); | ||
| 10 | if ($rs == false) | ||
| 11 | { | ||
| 12 | echo("Query message error: " . mysqli_error($db_conn)); | ||
| 13 | return -1; | ||
| 14 | } | ||
| 15 | |||
| 16 | if ($row = mysqli_fetch_array($rs)) | ||
| 17 | { | ||
| 18 | $new_msg = $row["msg_count"]; | ||
| 19 | } | ||
| 20 | |||
| 21 | mysqli_free_result($rs); | ||
| 22 | |||
| 23 | return $new_msg; | ||
| 24 | } | ||
| 25 | ?> |
| webmaster@leafok.com | ViewVC Help |
| Powered by ViewVC 1.3.0-beta1 |