PHP update_pms_read Exemples

Exemple #1

Fichier : train_user.php Projet : winiceo/job

    $joinsql = " LEFT JOIN  " . table('members') . " AS i  ON  p.msgfromuid=i.uid ";
    $orderby = " order by p.pmid desc";
    if ($new > 0) {
        $wheresql .= " AND p.`new`='{$new}' ";
    }
    if ($msgtype > 0) {
        $wheresql .= " AND p.msgtype='{$msgtype}' ";
    }
    $total_sql = "SELECT COUNT(*) AS num FROM " . table('pms') . ' AS p ' . $wheresql;
    $total_val = $db->get_total($total_sql);
    $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET));
    $currenpage = $page->nowindex;
    $offset = ($currenpage - 1) * $perpage;
    $sql = "SELECT p.* FROM " . table('pms') . ' AS p' . $joinsql . $wheresql . $orderby;
    //获取所查看消息的pmid , 并且将其修改为已读
    $pmid = update_pms_read($offset, $perpage, $sql);
    if (!empty($pmid)) {
        $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}' and pmid in (" . $pmid . ")");
    } else {
        $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}'");
    }
    get_pms_no_num();
    $smarty->assign('pms', get_pms($offset, $perpage, $sql));
    $smarty->assign('total1', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1' "));
    $smarty->assign('total2', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `msgtype`='1'"));
    $smarty->assign('total3', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `msgtype`='2'"));
    $smarty->assign('title', '短消息 - 会员中心 - ' . $_CFG['site_name']);
    $smarty->assign('page', $page->show(3));
    $smarty->assign('uid', $uid);
    $smarty->display('member_train/train_user_pm.htm');
} elseif ($act == 'pm_del') {

Exemple #2

Fichier : company_user.php Projet : dalinhuang/yy

    $smarty->assign('title', '账号绑定 - 会员中心 - ' . $_CFG['site_name']);
    $smarty->display('member_company/company_binding.htm');
} elseif ($act == 'pm') {
    require_once QISHI_ROOT_PATH . 'include/page.class.php';
    $perpage = 10;
    $uid = intval($_SESSION['uid']);
    $wheresql = " WHERE (p.msgfromuid='{$uid}' OR p.msgtouid='{$uid}') ";
    $joinsql = " LEFT JOIN  " . table('members') . " AS i  ON  p.msgfromuid=i.uid ";
    $orderby = " order by p.pmid desc";
    $total_sql = "SELECT COUNT(*) AS num FROM " . table('pms') . ' AS p ' . $wheresql;
    $total_val = $db->get_total($total_sql);
    $page = new page(array('total' => $total_val, 'perpage' => $perpage));
    $currenpage = $page->nowindex;
    $offset = ($currenpage - 1) * $perpage;
    $sql = "SELECT p.* FROM " . table('pms') . ' AS p' . $joinsql . $wheresql . $orderby;
    $db->query("UPDATE " . table('pms') . " SET `new`='2' WHERE new=1 AND msgtouid='{$uid}' and pmid in (" . update_pms_read($offset, $perpage, $sql) . ")");
    get_pms_no_num();
    $smarty->assign('pms', get_pms($offset, $perpage, $sql));
    $smarty->assign('total', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1'"));
    $smarty->assign('title', '短消息 - 会员中心 - ' . $_CFG['site_name']);
    $smarty->assign('page', $page->show(3));
    $smarty->assign('uid', $uid);
    // $db->query("UPDATE ".table('pms')." SET `new`='2' WHERE new=1 AND msgtouid='{$uid}'");
    // 3.5.2
    $smarty->display('member_company/company_user_pm.htm');
} elseif ($act == 'pm_del') {
    $pmid = intval($_GET['pmid']);
    $uid = intval($_SESSION['uid']);
    $pms = $db->getone("select * from " . table('pms') . " where pmid = '{$pmid}' AND (msgfromuid='{$uid}' OR msgtouid='{$uid}') LIMIT 1");
    if (!empty($pms)) {
        $db->query("Delete from " . table('pms') . " WHERE pmid='{$pms['pmid']}'");