function RefreshMsg($uid) { if (empty($uid)) { return; } $messages = array('msg1' => "(SELECT COUNT(*) FROM hh_techforum WHERE pubuser='******' AND isnewmsg=1 AND type=1)", 'msg2' => "(SELECT COUNT(*) FROM hh_techforum WHERE pubuser='******' AND isnewmsg=1 AND type=2)", 'msg3' => "(SELECT COUNT(*) FROM hh_techqzhi WHERE pubuser='******' AND isnewmsg=1)", 'msg4' => "(SELECT COUNT(*) FROM hh_techforum_list WHERE at='{$uid}' AND isnewat=1 AND type=1)", 'msg5' => "(SELECT COUNT(*) FROM hh_techforum_list WHERE at='{$uid}' AND isnewat=1 AND type=2)", 'msg6' => "(SELECT COUNT(*) FROM hh_techqzhi_list WHERE at='{$uid}' AND isnewat=1)", 'msg7' => "(SELECT COUNT(*) FROM hh_zhaopin WHERE ofuser='******' AND isnewmsg=1)", 'msg8' => "(SELECT COUNT(*) FROM hh_zhaopin_list WHERE at='{$uid}' AND isnewat=1)", 'msg9_0' => RefreshMsgByDianzan($uid, 1, 0), 'msg9_1' => RefreshMsgByDianzan($uid, 1, 1), 'msg10_0' => RefreshMsgByDianzan($uid, 2, 0), 'msg10_1' => RefreshMsgByDianzan($uid, 2, 1), 'msg11_0' => RefreshMsgByDianzan($uid, 3, 0), 'msg11_1' => RefreshMsgByDianzan($uid, 3, 1), 'msg12_0' => RefreshMsgByDianzan($uid, 4, 0), 'msg12_1' => RefreshMsgByDianzan($uid, 4, 1), 'msg9' => "msg9_0+msg9_1", 'msg10' => "msg10_0+msg10_1", 'msg11' => "msg11_0+msg11_1", 'msg12' => "msg12_0+msg12_1"); foreach ($messages as $key => $sql) { $fields = array($key => $sql); StorageEditByID('hh_techuser', $fields, $uid); } }
<?php require_once 'index.php'; RefreshMsgByDianzan(89, 4, 0, TRUE);