示例#1
0
文件: msgfun.php 项目: novnan/meiju
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);
    }
}
示例#2
0
文件: connect.php 项目: novnan/meiju
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");
    }
}