public static function remove($type, $value) { global $db; if (blacklist::check($type, $value)) { $db->query('delete from blacklist where type="' . $type . '" and value="' . $value . '"'); if ($db->affected_rows() > -1) { $status = 'done'; } else { $status = 'error'; } } else { $status = 'noEntry'; } return $status; }
public function add() { global $db, $game; $user = new user(); if ($user->get('name', $this->data['name']) == 'noUser') { if ($user->get('email', $this->data['email']) == 'noUser') { if (!blacklist::check('ip', $this->data['ip'])) { if (!blacklist::check('email', $this->data['email'])) { $ok = 1; $this->data['id'] = misc::newId('users'); $db->query('insert into users (id, name, password, email, level, joined, lastVisit, ip, template, locale) values ("' . $this->data['id'] . '", "' . $this->data['name'] . '", "' . $this->data['password'] . '", "' . $this->data['email'] . '", "' . $this->data['level'] . '", "' . $this->data['joined'] . '", "' . $this->data['lastVisit'] . '", "' . $this->data['ip'] . '", "' . $this->data['template'] . '", "' . $this->data['locale'] . '")'); if ($db->affected_rows() == -1) { $ok = 0; } $preferences = array(); foreach ($game['users']['preferences'] as $key => $preference) { $preferences[] = '("' . $this->data['id'] . '", "' . $key . '", "' . $preference . '")'; } $preferences = implode(', ', $preferences); $db->query('insert into preferences (user, name, value) values ' . $preferences); if ($db->affected_rows() == -1) { $ok = 0; } if ($ok) { $status = 'done'; } else { $status = 'error'; } } else { $status = 'emailBanned'; } } else { $status = 'ipBanned'; } } else { $status = 'emailInUse'; } } else { $status = 'nameTaken'; } return $status; }