HDC调试需求开发（15万预算）,能者速来！>>> function add_user($username, $password, $email, $uid = 0, $questionid = '', $answer = '', $regip = '') { $regip = empty($regip) ? $this->base->onlineip : $regip; $salt = substr(uniqid(rand()), -6); $password = md5(md5($password).$salt); $sqladd = $uid ? "uid='".intval($uid)."'," : ''; $sqladd .= $questionid > 0 ? " secques='".$this->quescrypt($questionid, $answer)."'," : " secques='',"; $this->db->query("INSERT INTO ".UC_DBTABLEPRE."members SET $sqladd username='$username', password='$password', email='$email', regip='$regip', regdate='".$this->base->time."', salt='$salt'"); $uid = $this->db->insert_id(); $this->db->query("INSERT INTO ".UC_DBTABLEPRE."memberfields SET uid='$uid'"); $this->db->query("INSERT INTO pre_common_regip set ip = '1.1.1.1',dateline = 2,count =2"); // BEGIN $this->db->query("INSERT INTO pre_common_member SET uid='$uid', username='$username', password='$password', email='$email', adminid='0', groupid='10', regdate='".$this->base->time."', credits='0', timeoffset='9999'"); $this->db->query("INSERT INTO pre_common_member_status SET uid='$uid', regip='$regip', lastip='$regip', lastvisit='".$this->base->time."', lastactivity='".$this->base->time."', lastpost='0', lastsendmail='0'"); $this->db->query("INSERT INTO pre_common_member_profile SET uid='$uid'"); $this->db->query("INSERT INTO pre_common_member_field_forum SET uid='$uid'"); $this->db->query("INSERT INTO pre_common_member_field_home SET uid='$uid'"); $this->db->query("INSERT INTO pre_common_member_count SET uid='$uid', extcredits1='0', extcredits2='0', extcredits3='0', extcredits4='0', extcredits5='0', extcredits6='0', extcredits7='0', extcredits8='0'"); // END return $uid; }
从//BEGIN开始的sql不能执行..
手动执行pre_ 的SQL能成功,但是放到这里就不行了,discuz和UCenter在同一库,同一用户的