Lines Matching refs:sqladd
114 $sqladd = $username !== '' ? "AND username<>'$username'" : '';
115 …this->db->result_first("SELECT email FROM ".UC_DBTABLEPRE."members WHERE email='$email' $sqladd");
133 $sqladd = $uid ? "uid='".intval($uid)."'," : '';
134 …$sqladd .= $questionid > 0 ? " secques='".$this->quescrypt($questionid, $answer)."'," : " secques=…
135 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."members SET $sqladd username='$username', password=…
155 $sqladd = $newpw ? "password='".md5(md5($newpw).$data['salt'])."'" : '';
156 $sqladd .= $email ? ($sqladd ? ',' : '')." email='$email'" : '';
159 $sqladd .= ($sqladd ? ',' : '')." secques='".$this->quescrypt($questionid, $answer)."'";
161 $sqladd .= ($sqladd ? ',' : '')." secques=''";
164 if($sqladd || $emailadd) {
165 $this->db->query("UPDATE ".UC_DBTABLEPRE."members SET $sqladd WHERE username='$username'");
196 function get_total_num($sqladd = '') { argument
197 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."members $sqladd");
201 function get_list($page, $ppp, $totalnum, $sqladd) { argument
203 $data = $this->db->fetch_all("SELECT * FROM ".UC_DBTABLEPRE."members $sqladd LIMIT $start, $ppp");