示例#1
0
 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;
 }
示例#2
0
文件: js.php 项目: TopGrd/newxb
function sqlMulti($array)
{
    $str = '';
    foreach ($array as $val) {
        if (!empty($val)) {
            $str .= ($str ? ', ' : ' ') . '(' . UC::implode($val) . ') ';
        }
    }
    return $str;
}
示例#3
0
 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;
 }