function DelMsg_all($mid) { global $empire, $dbtbpre; $user = islogin(); $count = count($mid); if (!$count) { printerror("EmptyDelMsg", "", 1); } for ($i = 0; $i < $count; $i++) { $add .= "mid='" . intval($mid[$i]) . "' or "; } $add = substr($add, 0, strlen($add) - 4); $sql = $empire->query("delete from {$dbtbpre}enewsqmsg where (" . $add . ") and to_username='******'username']}'"); if ($sql) { $num = $empire->gettotal("select count(*) as total from {$dbtbpre}enewsqmsg where to_username='******'username']}' and haveread=0 limit 1"); if (!$num) { $newhavemsg = eReturnSetHavemsg($user['havemsg'], 0); $newhavemsg = $newhavemsg == 2 || $newhavemsg == 3 ? 2 : 0; $empire->query("update " . eReturnMemberTable() . " set " . egetmf('havemsg') . "='{$newhavemsg}' where " . egetmf('userid') . "='{$user['userid']}'"); } printerror("DelMsgSuccess", "../member/msg/", 1); } else { printerror("DbError", "", 1); } }
function eSendMsg($title, $msgtext, $to_username, $from_userid, $from_username, $isadmin, $issys, $ecms = 0) { global $empire, $dbtbpre; $tbname = $ecms == 1 ? $dbtbpre . 'enewshmsg' : $dbtbpre . 'enewsqmsg'; $msgtime = date("Y-m-d H:i:s"); $empire->query("insert into " . $tbname . "(title,msgtext,haveread,msgtime,to_username,from_userid,from_username,isadmin,issys) values('{$title}','{$msgtext}',0,'{$msgtime}','{$to_username}','{$from_userid}','{$from_username}','{$isadmin}','{$issys}');"); //消息状态 $userr = $empire->fetch1("select " . eReturnSelectMemberF('userid,havemsg') . " from " . eReturnMemberTable() . " where " . egetmf('username') . "='{$to_username}' limit 1"); if (!$userr['havemsg']) { $newhavemsg = eReturnSetHavemsg($userr['havemsg'], 0); $empire->query("update " . eReturnMemberTable() . " set " . egetmf('havemsg') . "='{$newhavemsg}' where " . egetmf('userid') . "='" . $userr['userid'] . "' limit 1"); } }