+ public static function get_usermeta(&$u)
+ {
+ //do_log($u);
+ $list = &$u['meta'];
+ $id = $u['id'];
+ $conn = sqlnew();
+ if (isset($id))
+ {
+ $prep = $conn->prepare("SELECT * FROM " . SQL_PREFIX . "user_meta WHERE user_id = :id");
+ $prep->execute(["id" => $id]);
+ }
+ foreach ($prep->fetchAll() as $row)
+ {
+ $list[$row['meta_key']] = $row['meta_value'];
+ }
+ }
+
+ public static function add_usermeta(&$meta)
+ {
+ $meta = $meta['meta'];
+ $conn = sqlnew();
+ /* check if it exists first, update it if it does */
+ $query = "SELECT * FROM " . SQL_PREFIX . "user_meta WHERE user_id = :id AND meta_key = :key";
+ $stmt = $conn->prepare($query);
+ $stmt->execute(["id" => $meta['id'], "key" => $meta['key']]);
+ if ($stmt->rowCount()) // it exists, update instead of insert
+ {
+ $query = "UPDATE " . SQL_PREFIX . "user_meta SET meta_value = :value WHERE user_id = :id AND meta_key = :key";
+ $stmt = $conn->prepare($query);
+ $stmt->execute($meta);
+ if ($stmt->rowCount())
+ return true;
+ return false;
+ }
+
+ else
+ {
+ $query = "INSERT INTO " . SQL_PREFIX . "user_meta (user_id, meta_key, meta_value) VALUES (:id, :key, :value)";
+ $stmt = $conn->prepare($query);
+ $stmt->execute($meta);
+ if ($stmt->rowCount())
+ return true;
+ return false;
+ }
+ }
+ public static function del_usermeta(&$u)
+ {
+ $conn = sqlnew();
+ $query = "DELETE FROM " . SQL_PREFIX . "user_meta WHERE user_id = :id AND meta_key = :key";
+ $stmt = $conn->prepare($query);
+ $stmt->execute($u['meta']);
+ if ($stmt->rowCount())
+ return true;
+ return false;
+ }
+}
+
+
+function security_check()
+{
+ $ip = $_SERVER['REMOTE_ADDR'];
+ if (dnsbl_check($ip))
+ return true;
+
+ else if (fail2ban_check($ip))
+ {
+
+ }
+}
+
+function dnsbl_check($ip)
+{
+ $dnsbl_lookup = DNSBL;
+
+ // clear variable just in case
+ $listed = NULL;
+
+ // if the IP was not given because you're an idiot, stop processing
+ if (!$ip) { return; }
+
+ // get the first two segments of the IPv4
+ $because = split($ip, "."); // why you
+ $you = $because[1]; // gotta play
+ $want = $because[2]; // that song
+ $to = $you.".".$want."."; // so loud?
+
+ // exempt local connections because sometimes they get a false positive
+ if ($to == "192.168." || $to == "127.0.") { return NULL; }
+
+ // you spin my IP right round, right round, to check the records baby, right round-round-round
+ $reverse_ip = glue(array_reverse(split($ip, ".")), ".");
+
+ // checkem
+ foreach ($dnsbl_lookup as $host) {
+
+ //if it was listed
+ if (checkdnsrr($reverse_ip . "." . $host . ".", "A")) {
+
+ //take note
+ $listed = $host;
+ }
+ }
+
+ // if it was safe, return NOTHING
+ if (!$listed) {
+ return NULL;
+ }
+
+ // else, you guessed it, return where it was listed
+ else {
+ return $listed;
+ }
+}
+
+function fail2ban_check($ip)
+{
+