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); }
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; }
function get_by_id($nid) { $data = $this->db->get_one("SELECT * FROM " . UC_DBTABLEPRE . "ucnotify WHERE nid=" . UC::escape($nid)); return $data; }
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) . "' "; } }
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; }
function implode($array) { return implode(',', UC::escape($array)); }