示例#1
0
 function syncredit($arr)
 {
     if (is_array($arr)) {
         foreach ($arr as $uid => $setv) {
             $updateMemberData = array();
             foreach ($setv as $cid => $value) {
                 $value = intval($value);
                 $this->db->query("UPDATE " . $this->tablepre . "member SET member_points={$value} WHERE uid='" . UC::escape($uid) . "'");
                 $member_name = $this->db->result_first("SELECT member_name FROM " . $this->tablepre . "member WHERE member_id='" . UC::escape($uid) . "'");
                 $member_points = $this->db->result_first("SELECT member_points FROM " . $this->tablepre . "member WHERE member_id='" . UC::escape($uid) . "'");
                 $amount = $value - $member_points;
                 $member_info = $model_member->infoMember(array('member_id' => $_SESSION['member_id']), 'member_points');
                 $this->db->query("INSERT INTO " . $this->tablepre . "points_log (pl_memberid, pl_membername, pl_points, pl_addtime, pl_desc, pl_stage) VALUES ('{$uid}', '{$member_name}', '{$amount}', '" . time() . "', '" . getGBK('来自其它应用的积分兑入') . "', 'app')");
             }
         }
     }
     return new ApiResponse(1);
 }
示例#2
0
 function edit($uid, $username, $pwd, $email)
 {
     $user = $this->get_by_uid($uid);
     $ucsql = array();
     $retv = 0;
     if ($username && $user['username'] != $username) {
         $ucsql['username'] = $username;
         $retv++;
     }
     if ($pwd && $user['password'] != md5($pwd)) {
         $ucsql['password'] = md5($pwd);
     }
     if ($email && $user['email'] != $email) {
         $ucsql['email'] = $email;
     }
     if ($ucsql) {
         $retv++;
         $this->db->update("UPDATE " . UC_DBTABLEPRE . "members SET " . UC::sqlSingle($ucsql) . ' WHERE uid=' . UC::escape($uid));
     }
     return $retv;
 }
示例#3
0
文件: notify.php 项目: noikiy/ecmall
 function get_by_id($nid)
 {
     $data = $this->db->get_one("SELECT * FROM " . UC_DBTABLEPRE . "ucnotify WHERE nid=" . UC::escape($nid));
     return $data;
 }
示例#4
0
文件: js.php 项目: TopGrd/newxb
 function escape($var)
 {
     if (is_array($var)) {
         foreach ($var as $key => $value) {
             $var[$key] = trim(UC::escape($value));
         }
         return $var;
     } elseif (is_numeric($var)) {
         return " '" . $var . "' ";
     } else {
         return " '" . addslashes($var) . "' ";
     }
 }
示例#5
0
 function get22($uid)
 {
     $retv = array();
     $query = $this->db->query("SELECT cid,value FROM uc_usercredit WHERE uid=" . UC::escape($uid));
     while ($rt = $this->db->fetch_array($query)) {
         $retv[$rt['cid']] = $rt['value'];
     }
     return $retv;
 }
示例#6
0
 function implode($array)
 {
     return implode(',', UC::escape($array));
 }