function delete($uids) { if ($uids) { $this->db->update("DELETE FROM " . UC_DBTABLEPRE . "members WHERE uid IN (" . UC::implode($uids) . ')'); return $this->db->affected_rows(); } return 0; }
function sqlMulti($array) { $str = ''; foreach ($array as $val) { if (!empty($val)) { $str .= ($str ? ', ' : ' ') . '(' . UC::implode($val) . ') '; } } return $str; }
function get($uids) { $ucredit = $ucd = $mcd = array(); $syncredit = $this->base->config('uc_syncredit'); foreach ($syncredit as $key => $value) { if (is_numeric($key)) { $ucd[] = $key; } elseif ($this->isAllow($key)) { $key == 'rvrc' && ($key = "FLOOR(rvrc/10) AS rvrc"); $mcd[] = $key; } } if ($mcd) { $query = $this->db->query("SELECT uid," . implode(',', $mcd) . " FROM " . UC_DBTABLEPRE . "memberdata WHERE uid IN(" . UC::implode($uids) . ')'); while ($rt = $this->db->fetch_array($query)) { $ucredit[$rt['uid']] = $rt; } } if ($ucd) { $query = $this->db->query("SELECT * FROM " . UC_DBTABLEPRE . "membercredit WHERE uid IN(" . UC::implode($uids) . ') AND cid IN(' . UC::implode($ucd) . ')'); while ($rt = $this->db->fetch_array($query)) { $ucredit[$rt['uid']][$rt['cid']] = $rt['value']; } } return $ucredit; }