123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287 |
- <?php
- /**
- * This file has the very important job of ensuring forum security.
- * This task includes banning and permissions, namely.
- *
- * Simple Machines Forum (SMF)
- *
- * @package SMF
- * @author Simple Machines http://www.simplemachines.org
- * @copyright 2011 Simple Machines
- * @license http://www.simplemachines.org/about/smf/license.php BSD
- *
- * @version 2.1 Alpha 1
- */
- if (!defined('SMF'))
- die('Hacking attempt...');
- /**
- * Check if the user is who he/she says he is
- * Makes sure the user is who they claim to be by requiring a password to be typed in every hour.
- * Is turned on and off by the securityDisable setting.
- * Uses the adminLogin() function of Subs-Auth.php if they need to login, which saves all request (post and get) data.
- * @param string $type = admin
- */
- function validateSession($type = 'admin')
- {
- global $modSettings, $sourcedir, $user_info, $sc, $user_settings;
- // We don't care if the option is off, because Guests should NEVER get past here.
- is_not_guest();
- // Validate what type of session check this is.
- $types = array();
- call_integration_hook('integrate_validateSession', array($types));
- $type = in_array($type, $types) || $type == 'moderate' ? $type : 'admin';
- // If we're using XML give an additional ten minutes grace as an admin can't log on in XML mode.
- $refreshTime = isset($_GET['xml']) ? 4200 : 3600;
- // Is the security option off?
- if (!empty($modSettings['securityDisable' . ($type != 'admin' ? '_' . $type : '')]))
- return;
- // Or are they already logged in?, Moderator or admin sesssion is need for this area
- if ((!empty($_SESSION[$type . '_time']) && $_SESSION[$type . '_time'] + $refreshTime >= time()) || (!empty($_SESSION['admin_time']) && $_SESSION['admin_time'] + $refreshTime >= time()))
- return;
- require_once($sourcedir . '/Subs-Auth.php');
- // Hashed password, ahoy!
- if (isset($_POST[$type . '_hash_pass']) && strlen($_POST[$type . '_hash_pass']) == 40)
- {
- checkSession();
- $good_password = in_array(true, call_integration_hook('integrate_verify_password', array($user_info['username'], $_POST[$type . '_hash_pass'], true)), true);
- if ($good_password || $_POST[$type . '_hash_pass'] == sha1($user_info['passwd'] . $sc))
- {
- $_SESSION[$type . '_time'] = time();
- return;
- }
- }
- // Posting the password... check it.
- if (isset($_POST[$type. '_pass']))
- {
- checkSession();
- $good_password = in_array(true, call_integration_hook('integrate_verify_password', array($user_info['username'], $_POST[$type . '_pass'], false)), true);
- // Password correct?
- if ($good_password || sha1(strtolower($user_info['username']) . $_POST[$type . '_pass']) == $user_info['passwd'])
- {
- $_SESSION[$type . '_time'] = time();
- return;
- }
- }
- // OpenID?
- if (!empty($user_settings['openid_uri']))
- {
- require_once($sourcedir . '/Subs-OpenID.php');
- smf_openID_revalidate();
- $_SESSION[$type . '_time'] = time();
- return;
- }
- // Need to type in a password for that, man.
- if (!isset($_GET['xml']))
- adminLogin($type);
- else
- return 'session_verify_fail';
- }
- /**
- * Require a user who is logged in. (not a guest.)
- * Checks if the user is currently a guest, and if so asks them to login with a message telling them why.
- * Message is what to tell them when asking them to login.
- * @param string $message = ''
- */
- function is_not_guest($message = '')
- {
- global $user_info, $txt, $context, $scripturl;
- // Luckily, this person isn't a guest.
- if (!$user_info['is_guest'])
- return;
- // People always worry when they see people doing things they aren't actually doing...
- $_GET['action'] = '';
- $_GET['board'] = '';
- $_GET['topic'] = '';
- writeLog(true);
- // Just die.
- if (isset($_REQUEST['xml']))
- obExit(false);
- // Attempt to detect if they came from dlattach.
- if (!WIRELESS && SMF != 'SSI' && empty($context['theme_loaded']))
- loadTheme();
- // Never redirect to an attachment
- if (strpos($_SERVER['REQUEST_URL'], 'dlattach') === false)
- $_SESSION['login_url'] = $_SERVER['REQUEST_URL'];
- // Load the Login template and language file.
- loadLanguage('Login');
- // Are we in wireless mode?
- if (WIRELESS)
- {
- $context['login_error'] = $message ? $message : $txt['only_members_can_access'];
- $context['sub_template'] = WIRELESS_PROTOCOL . '_login';
- }
- // Apparently we're not in a position to handle this now. Let's go to a safer location for now.
- elseif (empty($context['template_layers']))
- {
- $_SESSION['login_url'] = $scripturl . '?' . $_SERVER['QUERY_STRING'];
- redirectexit('action=login');
- }
- else
- {
- loadTemplate('Login');
- $context['sub_template'] = 'kick_guest';
- $context['robot_no_index'] = true;
- }
- // Use the kick_guest sub template...
- $context['kick_message'] = $message;
- $context['page_title'] = $txt['login'];
- obExit();
- // We should never get to this point, but if we did we wouldn't know the user isn't a guest.
- trigger_error('Hacking attempt...', E_USER_ERROR);
- }
- /**
- * Do banning related stuff. (ie. disallow access....)
- * Checks if the user is banned, and if so dies with an error.
- * Caches this information for optimization purposes.
- * Forces a recheck if force_check is true.
- * @param bool $forceCheck = false
- */
- function is_not_banned($forceCheck = false)
- {
- global $txt, $modSettings, $context, $user_info;
- global $sourcedir, $cookiename, $user_settings, $smcFunc;
- // You cannot be banned if you are an admin - doesn't help if you log out.
- if ($user_info['is_admin'])
- return;
- // Only check the ban every so often. (to reduce load.)
- if ($forceCheck || !isset($_SESSION['ban']) || empty($modSettings['banLastUpdated']) || ($_SESSION['ban']['last_checked'] < $modSettings['banLastUpdated']) || $_SESSION['ban']['id_member'] != $user_info['id'] || $_SESSION['ban']['ip'] != $user_info['ip'] || $_SESSION['ban']['ip2'] != $user_info['ip2'] || (isset($user_info['email'], $_SESSION['ban']['email']) && $_SESSION['ban']['email'] != $user_info['email']))
- {
- // Innocent until proven guilty. (but we know you are! :P)
- $_SESSION['ban'] = array(
- 'last_checked' => time(),
- 'id_member' => $user_info['id'],
- 'ip' => $user_info['ip'],
- 'ip2' => $user_info['ip2'],
- 'email' => $user_info['email'],
- );
- $ban_query = array();
- $ban_query_vars = array('current_time' => time());
- $flag_is_activated = false;
- // Check both IP addresses.
- foreach (array('ip', 'ip2') as $ip_number)
- {
- if ($ip_number == 'ip2' && $user_info['ip2'] == $user_info['ip'])
- continue;
- $ban_query[] = constructBanQueryIP($user_info[$ip_number]);
- // IP was valid, maybe there's also a hostname...
- if (empty($modSettings['disableHostnameLookup']) && $user_info[$ip_number] != 'unknown')
- {
- $hostname = host_from_ip($user_info[$ip_number]);
- if (strlen($hostname) > 0)
- {
- $ban_query[] = '({string:hostname} LIKE bi.hostname)';
- $ban_query_vars['hostname'] = $hostname;
- }
- }
- }
- // Is their email address banned?
- if (strlen($user_info['email']) != 0)
- {
- $ban_query[] = '({string:email} LIKE bi.email_address)';
- $ban_query_vars['email'] = $user_info['email'];
- }
- // How about this user?
- if (!$user_info['is_guest'] && !empty($user_info['id']))
- {
- $ban_query[] = 'bi.id_member = {int:id_member}';
- $ban_query_vars['id_member'] = $user_info['id'];
- }
- // Check the ban, if there's information.
- if (!empty($ban_query))
- {
- $restrictions = array(
- 'cannot_access',
- 'cannot_login',
- 'cannot_post',
- 'cannot_register',
- );
- $request = $smcFunc['db_query']('', '
- SELECT bi.id_ban, bi.email_address, bi.id_member, bg.cannot_access, bg.cannot_register,
- bg.cannot_post, bg.cannot_login, bg.reason, IFNULL(bg.expire_time, 0) AS expire_time
- FROM {db_prefix}ban_items AS bi
- INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group AND (bg.expire_time IS NULL OR bg.expire_time > {int:current_time}))
- WHERE
- (' . implode(' OR ', $ban_query) . ')',
- $ban_query_vars
- );
- // Store every type of ban that applies to you in your session.
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- foreach ($restrictions as $restriction)
- if (!empty($row[$restriction]))
- {
- $_SESSION['ban'][$restriction]['reason'] = $row['reason'];
- $_SESSION['ban'][$restriction]['ids'][] = $row['id_ban'];
- if (!isset($_SESSION['ban']['expire_time']) || ($_SESSION['ban']['expire_time'] != 0 && ($row['expire_time'] == 0 || $row['expire_time'] > $_SESSION['ban']['expire_time'])))
- $_SESSION['ban']['expire_time'] = $row['expire_time'];
- if (!$user_info['is_guest'] && $restriction == 'cannot_access' && ($row['id_member'] == $user_info['id'] || $row['email_address'] == $user_info['email']))
- $flag_is_activated = true;
- }
- }
- $smcFunc['db_free_result']($request);
- }
- // Mark the cannot_access and cannot_post bans as being 'hit'.
- if (isset($_SESSION['ban']['cannot_access']) || isset($_SESSION['ban']['cannot_post']) || isset($_SESSION['ban']['cannot_login']))
- log_ban(array_merge(isset($_SESSION['ban']['cannot_access']) ? $_SESSION['ban']['cannot_access']['ids'] : array(), isset($_SESSION['ban']['cannot_post']) ? $_SESSION['ban']['cannot_post']['ids'] : array(), isset($_SESSION['ban']['cannot_login']) ? $_SESSION['ban']['cannot_login']['ids'] : array()));
- // If for whatever reason the is_activated flag seems wrong, do a little work to clear it up.
- if ($user_info['id'] && (($user_settings['is_activated'] >= 10 && !$flag_is_activated)
- || ($user_settings['is_activated'] < 10 && $flag_is_activated)))
- {
- require_once($sourcedir . '/ManageBans.php');
- updateBanMembers();
- }
- }
- // Hey, I know you! You're ehm...
- if (!isset($_SESSION['ban']['cannot_access']) && !empty($_COOKIE[$cookiename . '_']))
- {
- $bans = explode(',', $_COOKIE[$cookiename . '_']);
- foreach ($bans as $key => $value)
- $bans[$key] = (int) $value;
- $request = $smcFunc['db_query']('', '
- SELECT bi.id_ban, bg.reason
- FROM {db_prefix}ban_items AS bi
- INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group)
- WHERE bi.id_ban IN ({array_int:ban_list})
- AND (bg.expire_time IS NULL OR bg.expire_time > {int:current_time})
- AND bg.cannot_access = {int:cannot_access}
- LIMIT ' . count($bans),
- array(
- 'cannot_access' => 1,
- 'ban_list' => $bans,
- 'current_time' => time(),
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- $_SESSION['ban']['cannot_access']['ids'][] = $row['id_ban'];
- $_SESSION['ban']['cannot_access']['reason'] = $row['reason'];
- }
- $smcFunc['db_free_result']($request);
- // My mistake. Next time better.
- if (!isset($_SESSION['ban']['cannot_access']))
- {
- require_once($sourcedir . '/Subs-Auth.php');
- $cookie_url = url_parts(!empty($modSettings['localCookies']), !empty($modSettings['globalCookies']));
- smf_setcookie($cookiename . '_', '', time() - 3600, $cookie_url[1], $cookie_url[0], false, false);
- }
- }
- // If you're fully banned, it's end of the story for you.
- if (isset($_SESSION['ban']['cannot_access']))
- {
- // We don't wanna see you!
- if (!$user_info['is_guest'])
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_online
- WHERE id_member = {int:current_member}',
- array(
- 'current_member' => $user_info['id'],
- )
- );
- // 'Log' the user out. Can't have any funny business... (save the name!)
- $old_name = isset($user_info['name']) && $user_info['name'] != '' ? $user_info['name'] : $txt['guest_title'];
- $user_info['name'] = '';
- $user_info['username'] = '';
- $user_info['is_guest'] = true;
- $user_info['is_admin'] = false;
- $user_info['permissions'] = array();
- $user_info['id'] = 0;
- $context['user'] = array(
- 'id' => 0,
- 'username' => '',
- 'name' => $txt['guest_title'],
- 'is_guest' => true,
- 'is_logged' => false,
- 'is_admin' => false,
- 'is_mod' => false,
- 'can_mod' => false,
- 'language' => $user_info['language'],
- );
- // A goodbye present.
- require_once($sourcedir . '/Subs-Auth.php');
- $cookie_url = url_parts(!empty($modSettings['localCookies']), !empty($modSettings['globalCookies']));
- smf_setcookie($cookiename . '_', implode(',', $_SESSION['ban']['cannot_access']['ids']), time() + 3153600, $cookie_url[1], $cookie_url[0], false, false);
- // Don't scare anyone, now.
- $_GET['action'] = '';
- $_GET['board'] = '';
- $_GET['topic'] = '';
- writeLog(true);
- // You banned, sucka!
- fatal_error(sprintf($txt['your_ban'], $old_name) . (empty($_SESSION['ban']['cannot_access']['reason']) ? '' : '<br />' . $_SESSION['ban']['cannot_access']['reason']) . '<br />' . (!empty($_SESSION['ban']['expire_time']) ? sprintf($txt['your_ban_expires'], timeformat($_SESSION['ban']['expire_time'], false)) : $txt['your_ban_expires_never']), 'user');
- // If we get here, something's gone wrong.... but let's try anyway.
- trigger_error('Hacking attempt...', E_USER_ERROR);
- }
- // You're not allowed to log in but yet you are. Let's fix that.
- elseif (isset($_SESSION['ban']['cannot_login']) && !$user_info['is_guest'])
- {
- // We don't wanna see you!
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_online
- WHERE id_member = {int:current_member}',
- array(
- 'current_member' => $user_info['id'],
- )
- );
- // 'Log' the user out. Can't have any funny business... (save the name!)
- $old_name = isset($user_info['name']) && $user_info['name'] != '' ? $user_info['name'] : $txt['guest_title'];
- $user_info['name'] = '';
- $user_info['username'] = '';
- $user_info['is_guest'] = true;
- $user_info['is_admin'] = false;
- $user_info['permissions'] = array();
- $user_info['id'] = 0;
- $context['user'] = array(
- 'id' => 0,
- 'username' => '',
- 'name' => $txt['guest_title'],
- 'is_guest' => true,
- 'is_logged' => false,
- 'is_admin' => false,
- 'is_mod' => false,
- 'can_mod' => false,
- 'language' => $user_info['language'],
- );
- // SMF's Wipe 'n Clean(r) erases all traces.
- $_GET['action'] = '';
- $_GET['board'] = '';
- $_GET['topic'] = '';
- writeLog(true);
- require_once($sourcedir . '/LogInOut.php');
- Logout(true, false);
- fatal_error(sprintf($txt['your_ban'], $old_name) . (empty($_SESSION['ban']['cannot_login']['reason']) ? '' : '<br />' . $_SESSION['ban']['cannot_login']['reason']) . '<br />' . (!empty($_SESSION['ban']['expire_time']) ? sprintf($txt['your_ban_expires'], timeformat($_SESSION['ban']['expire_time'], false)) : $txt['your_ban_expires_never']) . '<br />' . $txt['ban_continue_browse'], 'user');
- }
- // Fix up the banning permissions.
- if (isset($user_info['permissions']))
- banPermissions();
- }
- /**
- * Fix permissions according to ban status.
- * Applies any states of banning by removing permissions the user cannot have.
- */
- function banPermissions()
- {
- global $user_info, $sourcedir, $modSettings, $context;
- // Somehow they got here, at least take away all permissions...
- if (isset($_SESSION['ban']['cannot_access']))
- $user_info['permissions'] = array();
- // Okay, well, you can watch, but don't touch a thing.
- elseif (isset($_SESSION['ban']['cannot_post']) || (!empty($modSettings['warning_mute']) && $modSettings['warning_mute'] <= $user_info['warning']))
- {
- $denied_permissions = array(
- 'pm_send',
- 'calendar_post', 'calendar_edit_own', 'calendar_edit_any',
- 'poll_post',
- 'poll_add_own', 'poll_add_any',
- 'poll_edit_own', 'poll_edit_any',
- 'poll_lock_own', 'poll_lock_any',
- 'poll_remove_own', 'poll_remove_any',
- 'manage_attachments', 'manage_smileys', 'manage_boards', 'admin_forum', 'manage_permissions',
- 'moderate_forum', 'manage_membergroups', 'manage_bans', 'send_mail', 'edit_news',
- 'profile_identity_any', 'profile_extra_any', 'profile_title_any',
- 'post_new', 'post_reply_own', 'post_reply_any',
- 'delete_own', 'delete_any', 'delete_replies',
- 'make_sticky',
- 'merge_any', 'split_any',
- 'modify_own', 'modify_any', 'modify_replies',
- 'move_any',
- 'send_topic',
- 'lock_own', 'lock_any',
- 'remove_own', 'remove_any',
- 'post_unapproved_topics', 'post_unapproved_replies_own', 'post_unapproved_replies_any',
- );
- $user_info['permissions'] = array_diff($user_info['permissions'], $denied_permissions);
- }
- // Are they absolutely under moderation?
- elseif (!empty($modSettings['warning_moderate']) && $modSettings['warning_moderate'] <= $user_info['warning'])
- {
- // Work out what permissions should change...
- $permission_change = array(
- 'post_new' => 'post_unapproved_topics',
- 'post_reply_own' => 'post_unapproved_replies_own',
- 'post_reply_any' => 'post_unapproved_replies_any',
- 'post_attachment' => 'post_unapproved_attachments',
- );
- foreach ($permission_change as $old => $new)
- {
- if (!in_array($old, $user_info['permissions']))
- unset($permission_change[$old]);
- else
- $user_info['permissions'][] = $new;
- }
- $user_info['permissions'] = array_diff($user_info['permissions'], array_keys($permission_change));
- }
- // @todo Find a better place to call this? Needs to be after permissions loaded!
- // Finally, some bits we cache in the session because it saves queries.
- if (isset($_SESSION['mc']) && $_SESSION['mc']['time'] > $modSettings['settings_updated'] && $_SESSION['mc']['id'] == $user_info['id'])
- $user_info['mod_cache'] = $_SESSION['mc'];
- else
- {
- require_once($sourcedir . '/Subs-Auth.php');
- rebuildModCache();
- }
- // Now that we have the mod cache taken care of lets setup a cache for the number of mod reports still open
- if (isset($_SESSION['rc']) && $_SESSION['rc']['time'] > $modSettings['last_mod_report_action'] && $_SESSION['rc']['id'] == $user_info['id'])
- $context['open_mod_reports'] = $_SESSION['rc']['reports'];
- elseif ($_SESSION['mc']['bq'] != '0=1')
- {
- require_once($sourcedir . '/ModerationCenter.php');
- recountOpenReports();
- }
- else
- $context['open_mod_reports'] = 0;
- }
- /**
- * Log a ban in the database.
- * Log the current user in the ban logs.
- * Increment the hit counters for the specified ban ID's (if any.)
- * @param array $ban_ids = array()
- * @param string $email = null
- */
- function log_ban($ban_ids = array(), $email = null)
- {
- global $user_info, $smcFunc;
- // Don't log web accelerators, it's very confusing...
- if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch')
- return;
- $smcFunc['db_insert']('',
- '{db_prefix}log_banned',
- array('id_member' => 'int', 'ip' => 'string-16', 'email' => 'string', 'log_time' => 'int'),
- array($user_info['id'], $user_info['ip'], ($email === null ? ($user_info['is_guest'] ? '' : $user_info['email']) : $email), time()),
- array('id_ban_log')
- );
- // One extra point for these bans.
- if (!empty($ban_ids))
- $smcFunc['db_query']('', '
- UPDATE {db_prefix}ban_items
- SET hits = hits + 1
- WHERE id_ban IN ({array_int:ban_ids})',
- array(
- 'ban_ids' => $ban_ids,
- )
- );
- }
- /**
- * Checks if a given email address might be banned.
- * Check if a given email is banned.
- * Performs an immediate ban if the turns turns out positive.
- * @param string $email
- * @param string $restriction
- * @param string $error
- */
- function isBannedEmail($email, $restriction, $error)
- {
- global $txt, $smcFunc;
- // Can't ban an empty email
- if (empty($email) || trim($email) == '')
- return;
- // Let's start with the bans based on your IP/hostname/memberID...
- $ban_ids = isset($_SESSION['ban'][$restriction]) ? $_SESSION['ban'][$restriction]['ids'] : array();
- $ban_reason = isset($_SESSION['ban'][$restriction]) ? $_SESSION['ban'][$restriction]['reason'] : '';
- // ...and add to that the email address you're trying to register.
- $request = $smcFunc['db_query']('', '
- SELECT bi.id_ban, bg.' . $restriction . ', bg.cannot_access, bg.reason
- FROM {db_prefix}ban_items AS bi
- INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group)
- WHERE {string:email} LIKE bi.email_address
- AND (bg.' . $restriction . ' = {int:cannot_access} OR bg.cannot_access = {int:cannot_access})
- AND (bg.expire_time IS NULL OR bg.expire_time >= {int:now})',
- array(
- 'email' => $email,
- 'cannot_access' => 1,
- 'now' => time(),
- )
- );
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- if (!empty($row['cannot_access']))
- {
- $_SESSION['ban']['cannot_access']['ids'][] = $row['id_ban'];
- $_SESSION['ban']['cannot_access']['reason'] = $row['reason'];
- }
- if (!empty($row[$restriction]))
- {
- $ban_ids[] = $row['id_ban'];
- $ban_reason = $row['reason'];
- }
- }
- $smcFunc['db_free_result']($request);
- // You're in biiig trouble. Banned for the rest of this session!
- if (isset($_SESSION['ban']['cannot_access']))
- {
- log_ban($_SESSION['ban']['cannot_access']['ids']);
- $_SESSION['ban']['last_checked'] = time();
- fatal_error(sprintf($txt['your_ban'], $txt['guest_title']) . $_SESSION['ban']['cannot_access']['reason'], false);
- }
- if (!empty($ban_ids))
- {
- // Log this ban for future reference.
- log_ban($ban_ids, $email);
- fatal_error($error . $ban_reason, false);
- }
- }
- /**
- * Make sure the user's correct session was passed, and they came from here.
- * Checks the current session, verifying that the person is who he or she should be.
- * Also checks the referrer to make sure they didn't get sent here.
- * Depends on the disableCheckUA setting, which is usually missing.
- * Will check GET, POST, or REQUEST depending on the passed type.
- * Also optionally checks the referring action if passed. (note that the referring action must be by GET.)
- * @param string $type = 'post' (post, get, request)
- * @param string $from_action = ''
- * @param bool $is_fatal = true
- * @return string the error message if is_fatal is false.
- */
- function checkSession($type = 'post', $from_action = '', $is_fatal = true)
- {
- global $sc, $modSettings, $boardurl;
- // Is it in as $_POST['sc']?
- if ($type == 'post')
- {
- $check = isset($_POST[$_SESSION['session_var']]) ? $_POST[$_SESSION['session_var']] : (empty($modSettings['strictSessionCheck']) && isset($_POST['sc']) ? $_POST['sc'] : null);
- if ($check !== $sc)
- $error = 'session_timeout';
- }
- // How about $_GET['sesc']?
- elseif ($type == 'get')
- {
- $check = isset($_GET[$_SESSION['session_var']]) ? $_GET[$_SESSION['session_var']] : (empty($modSettings['strictSessionCheck']) && isset($_GET['sesc']) ? $_GET['sesc'] : null);
- if ($check !== $sc)
- $error = 'session_verify_fail';
- }
- // Or can it be in either?
- elseif ($type == 'request')
- {
- $check = isset($_GET[$_SESSION['session_var']]) ? $_GET[$_SESSION['session_var']] : (empty($modSettings['strictSessionCheck']) && isset($_GET['sesc']) ? $_GET['sesc'] : (isset($_POST[$_SESSION['session_var']]) ? $_POST[$_SESSION['session_var']] : (empty($modSettings['strictSessionCheck']) && isset($_POST['sc']) ? $_POST['sc'] : null)));
- if ($check !== $sc)
- $error = 'session_verify_fail';
- }
- // Verify that they aren't changing user agents on us - that could be bad.
- if ((!isset($_SESSION['USER_AGENT']) || $_SESSION['USER_AGENT'] != $_SERVER['HTTP_USER_AGENT']) && empty($modSettings['disableCheckUA']))
- $error = 'session_verify_fail';
- // Make sure a page with session check requirement is not being prefetched.
- if (isset($_SERVER['HTTP_X_MOZ']) && $_SERVER['HTTP_X_MOZ'] == 'prefetch')
- {
- ob_end_clean();
- header('HTTP/1.1 403 Forbidden');
- die;
- }
- // Check the referring site - it should be the same server at least!
- $referrer = isset($_SERVER['HTTP_REFERER']) ? @parse_url($_SERVER['HTTP_REFERER']) : array();
- if (!empty($referrer['host']))
- {
- if (strpos($_SERVER['HTTP_HOST'], ':') !== false)
- $real_host = substr($_SERVER['HTTP_HOST'], 0, strpos($_SERVER['HTTP_HOST'], ':'));
- else
- $real_host = $_SERVER['HTTP_HOST'];
- $parsed_url = parse_url($boardurl);
- // Are global cookies on? If so, let's check them ;).
- if (!empty($modSettings['globalCookies']))
- {
- if (preg_match('~(?:[^\.]+\.)?([^\.]{3,}\..+)\z~i', $parsed_url['host'], $parts) == 1)
- $parsed_url['host'] = $parts[1];
- if (preg_match('~(?:[^\.]+\.)?([^\.]{3,}\..+)\z~i', $referrer['host'], $parts) == 1)
- $referrer['host'] = $parts[1];
- if (preg_match('~(?:[^\.]+\.)?([^\.]{3,}\..+)\z~i', $real_host, $parts) == 1)
- $real_host = $parts[1];
- }
- // Okay: referrer must either match parsed_url or real_host.
- if (isset($parsed_url['host']) && strtolower($referrer['host']) != strtolower($parsed_url['host']) && strtolower($referrer['host']) != strtolower($real_host))
- {
- $error = 'verify_url_fail';
- $log_error = true;
- }
- }
- // Well, first of all, if a from_action is specified you'd better have an old_url.
- if (!empty($from_action) && (!isset($_SESSION['old_url']) || preg_match('~[?;&]action=' . $from_action . '([;&]|$)~', $_SESSION['old_url']) == 0))
- {
- $error = 'verify_url_fail';
- $log_error = true;
- }
- if (strtolower($_SERVER['HTTP_USER_AGENT']) == 'hacker')
- fatal_error('Sound the alarm! It\'s a hacker! Close the castle gates!!', false);
- // Everything is ok, return an empty string.
- if (!isset($error))
- return '';
- // A session error occurred, show the error.
- elseif ($is_fatal)
- {
- if (isset($_GET['xml']))
- {
- ob_end_clean();
- header('HTTP/1.1 403 Forbidden - Session timeout');
- die;
- }
- else
- fatal_lang_error($error, isset($log_error) ? 'user' : false);
- }
- // A session error occurred, return the error to the calling function.
- else
- return $error;
- // We really should never fall through here, for very important reasons. Let's make sure.
- trigger_error('Hacking attempt...', E_USER_ERROR);
- }
- /**
- * Check if a specific confirm parameter was given.
- * @param string $action
- */
- function checkConfirm($action)
- {
- global $modSettings;
- if (isset($_GET['confirm']) && isset($_SESSION['confirm_' . $action]) && md5($_GET['confirm'] . $_SERVER['HTTP_USER_AGENT']) == $_SESSION['confirm_' . $action])
- return true;
- else
- {
- $token = md5(mt_rand() . session_id() . (string) microtime() . $modSettings['rand_seed']);
- $_SESSION['confirm_' . $action] = md5($token . $_SERVER['HTTP_USER_AGENT']);
- return $token;
- }
- }
- /**
- * Lets give you a token of our appreciation.
- * @param string $action
- * @param string $type = 'post'
- * @return array
- */
- function createToken($action, $type = 'post')
- {
- global $modSettings, $context;
- $token = md5(mt_rand() . session_id() . (string) microtime() . $modSettings['rand_seed'] . $type);
- $token_var = substr(preg_replace('~^\d+~', '', md5(mt_rand() . (string) microtime() . mt_rand())), 0, rand(7, 12));
- $_SESSION['token'][$type . '-' . $action] = array($token_var, md5($token . $_SERVER['HTTP_USER_AGENT']), time(), $token);
- $context[$action . '_token'] = $token;
- $context[$action . '_token_var'] = $token_var;
- return array($token_var, $token);
- }
- /**
- * Only patrons with valid tokens can ride this ride.
- *
- * @param string $action
- * @param string $type = 'post' (get, request, or post)
- * @param bool $reset = true
- * @return bool
- */
- function validateToken($action, $type = 'post', $reset = true)
- {
- global $modSettings;
- $type = $type == 'get' || $type == 'request' ? $type : 'post';
- // This nasty piece of code validates a token.
- /*
- 1. The token exists in session.
- 2. The {$type} variable should exist.
- 3. We concat the variable we received with the user agent
- 4. Match that result against what is in the session.
- 5. If it matchs, success, otherwise we fallout.
- */
- if (isset($_SESSION['token'][$type . '-' . $action], $GLOBALS['_' . strtoupper($type)][$_SESSION['token'][$type . '-' . $action][0]]) && md5($GLOBALS['_' . strtoupper($type)][$_SESSION['token'][$type . '-' . $action][0]] . $_SERVER['HTTP_USER_AGENT']) == $_SESSION['token'][$type . '-' . $action][1])
- {
- // Invalidate this token now.
- unset($_SESSION['token'][$type . '-' . $action]);
- return true;
- }
- // Patrons with invalid tokens get the boot.
- if ($reset)
- {
- // Might as well do some cleanup on this.
- cleanTokens();
- // I'm back baby.
- createToken($action, $type);
- fatal_lang_error('token_verify_fail', false);
- }
- // Remove this token as its useless
- else
- unset($_SESSION['token'][$type . '-' . $action]);
- // Randomly check if we should remove some older tokens.
- if (mt_rand(0, 138) == 23)
- cleanTokens();
- return false;
- }
- /**
- * Clean up a little.
- * @param bool $complete = false
- */
- function cleanTokens($complete = false)
- {
- // We appreciate cleaning up after yourselves.
- if (!isset($_SESSION['token']))
- return;
- // Clean up tokens, trying to give enough time still.
- foreach ($_SESSION['token'] as $key => $data)
- if ($data[2] + 10800 < time() || $complete)
- unset($_SESSION['token'][$key]);
- }
- /**
- * Check whether a form has been submitted twice.
- * Registers a sequence number for a form.
- * Checks whether a submitted sequence number is registered in the current session.
- * Depending on the value of is_fatal shows an error or returns true or false.
- * Frees a sequence number from the stack after it's been checked.
- * Frees a sequence number without checking if action == 'free'.
- *
- * @param string $action
- * @param bool $is_fatal = true
- * @return bool
- */
- function checkSubmitOnce($action, $is_fatal = true)
- {
- global $context;
- if (!isset($_SESSION['forms']))
- $_SESSION['forms'] = array();
- // Register a form number and store it in the session stack. (use this on the page that has the form.)
- if ($action == 'register')
- {
- $context['form_sequence_number'] = 0;
- while (empty($context['form_sequence_number']) || in_array($context['form_sequence_number'], $_SESSION['forms']))
- $context['form_sequence_number'] = mt_rand(1, 16000000);
- }
- // Check whether the submitted number can be found in the session.
- elseif ($action == 'check')
- {
- if (!isset($_REQUEST['seqnum']))
- return true;
- elseif (!in_array($_REQUEST['seqnum'], $_SESSION['forms']))
- {
- $_SESSION['forms'][] = (int) $_REQUEST['seqnum'];
- return true;
- }
- elseif ($is_fatal)
- fatal_lang_error('error_form_already_submitted', false);
- else
- return false;
- }
- // Don't check, just free the stack number.
- elseif ($action == 'free' && isset($_REQUEST['seqnum']) && in_array($_REQUEST['seqnum'], $_SESSION['forms']))
- $_SESSION['forms'] = array_diff($_SESSION['forms'], array($_REQUEST['seqnum']));
- elseif ($action != 'free')
- trigger_error('checkSubmitOnce(): Invalid action \'' . $action . '\'', E_USER_WARNING);
- }
- /**
- * Check the user's permissions.
- * checks whether the user is allowed to do permission. (ie. post_new.)
- * If boards is specified, checks those boards instead of the current one.
- * Always returns true if the user is an administrator.
- * @param string $permission
- * @param array $boards = null
- * @return bool if the user can do the permission
- */
- function allowedTo($permission, $boards = null)
- {
- global $user_info, $modSettings, $smcFunc;
- // You're always allowed to do nothing. (unless you're a working man, MR. LAZY :P!)
- if (empty($permission))
- return true;
- // You're never allowed to do something if your data hasn't been loaded yet!
- if (empty($user_info))
- return false;
- // Administrators are supermen :P.
- if ($user_info['is_admin'])
- return true;
- // Are we checking the _current_ board, or some other boards?
- if ($boards === null)
- {
- // Check if they can do it.
- if (!is_array($permission) && in_array($permission, $user_info['permissions']))
- return true;
- // Search for any of a list of permissions.
- elseif (is_array($permission) && count(array_intersect($permission, $user_info['permissions'])) != 0)
- return true;
- // You aren't allowed, by default.
- else
- return false;
- }
- elseif (!is_array($boards))
- $boards = array($boards);
- $request = $smcFunc['db_query']('', '
- SELECT MIN(bp.add_deny) AS add_deny
- FROM {db_prefix}boards AS b
- INNER JOIN {db_prefix}board_permissions AS bp ON (bp.id_profile = b.id_profile)
- LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})
- WHERE b.id_board IN ({array_int:board_list})
- AND bp.id_group IN ({array_int:group_list}, {int:moderator_group})
- AND bp.permission {raw:permission_list}
- AND (mods.id_member IS NOT NULL OR bp.id_group != {int:moderator_group})
- GROUP BY b.id_board',
- array(
- 'current_member' => $user_info['id'],
- 'board_list' => $boards,
- 'group_list' => $user_info['groups'],
- 'moderator_group' => 3,
- 'permission_list' => (is_array($permission) ? 'IN (\'' . implode('\', \'', $permission) . '\')' : ' = \'' . $permission . '\''),
- )
- );
- // Make sure they can do it on all of the boards.
- if ($smcFunc['db_num_rows']($request) != count($boards))
- return false;
- $result = true;
- while ($row = $smcFunc['db_fetch_assoc']($request))
- $result &= !empty($row['add_deny']);
- $smcFunc['db_free_result']($request);
- // If the query returned 1, they can do it... otherwise, they can't.
- return $result;
- }
- /**
- * Fatal error if they cannot.
- * Uses allowedTo() to check if the user is allowed to do permission.
- * Checks the passed boards or current board for the permission.
- * If they are not, it loads the Errors language file and shows an error using $txt['cannot_' . $permission].
- * If they are a guest and cannot do it, this calls is_not_guest().
- * @param string $permission
- * @param array $boards = null
- */
- function isAllowedTo($permission, $boards = null)
- {
- global $user_info, $txt;
- static $heavy_permissions = array(
- 'admin_forum',
- 'manage_attachments',
- 'manage_smileys',
- 'manage_boards',
- 'edit_news',
- 'moderate_forum',
- 'manage_bans',
- 'manage_membergroups',
- 'manage_permissions',
- );
- // Make it an array, even if a string was passed.
- $permission = is_array($permission) ? $permission : array($permission);
- // Check the permission and return an error...
- if (!allowedTo($permission, $boards))
- {
- // Pick the last array entry as the permission shown as the error.
- $error_permission = array_shift($permission);
- // If they are a guest, show a login. (because the error might be gone if they do!)
- if ($user_info['is_guest'])
- {
- loadLanguage('Errors');
- is_not_guest($txt['cannot_' . $error_permission]);
- }
- // Clear the action because they aren't really doing that!
- $_GET['action'] = '';
- $_GET['board'] = '';
- $_GET['topic'] = '';
- writeLog(true);
- fatal_lang_error('cannot_' . $error_permission, false);
- // Getting this far is a really big problem, but let's try our best to prevent any cases...
- trigger_error('Hacking attempt...', E_USER_ERROR);
- }
- // If you're doing something on behalf of some "heavy" permissions, validate your session.
- // (take out the heavy permissions, and if you can't do anything but those, you need a validated session.)
- if (!allowedTo(array_diff($permission, $heavy_permissions), $boards))
- validateSession();
- }
- /**
- * Return the boards a user has a certain (board) permission on. (array(0) if all.)
- * returns a list of boards on which the user is allowed to do the specified permission.
- * Returns an array with only a 0 in it if the user has permission to do this on every board.
- * Returns an empty array if he or she cannot do this on any board.
- * If check_access is true will also make sure the group has proper access to that board.
- * @param array $permissions
- * @param bool $check_access = true
- * @param bool $simple = true
- */
- function boardsAllowedTo($permissions, $check_access = true, $simple = true)
- {
- global $user_info, $modSettings, $smcFunc;
- // Arrays are nice, most of the time.
- $permissions = (array) $permissions;
- /*
- * Set $simple to true to use this function as it were in SMF 2.0.x.
- * Otherwise, the resultant array becomes split into the multiple
- * permissions that were passed. Other than that, it's just the normal
- * state of play that you're used to.
- */
- // Administrators are all powerful, sorry.
- if ($user_info['is_admin'])
- {
- if ($simple)
- return array(0);
- else
- {
- $result = array();
- foreach ($permissions as $permission)
- $result[$permission] = array(0);
- return $result;
- }
- }
- // All groups the user is in except 'moderator'.
- $groups = array_diff($user_info['groups'], array(3));
- $request = $smcFunc['db_query']('', '
- SELECT b.id_board, bp.add_deny
- FROM {db_prefix}board_permissions AS bp
- INNER JOIN {db_prefix}boards AS b ON (b.id_profile = bp.id_profile)
- LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})
- WHERE bp.id_group IN ({array_int:group_list}, {int:moderator_group})
- AND bp.permission IN ({array_string:permissions})
- AND (mods.id_member IS NOT NULL OR bp.id_group != {int:moderator_group})' .
- ($check_access ? ' AND {query_see_board}' : ''),
- array(
- 'current_member' => $user_info['id'],
- 'group_list' => $groups,
- 'moderator_group' => 3,
- 'permissions' => $permissions,
- )
- );
- $boards = $deny_boards = $result = array();
- while ($row = $smcFunc['db_fetch_assoc']($request))
- {
- if ($simple)
- {
- if (empty($row['add_deny']))
- $deny_boards[$row['permission']][] = $row['id_board'];
- else
- $boards[$row['permission']][] = $row['id_board'];
- }
- else
- {
- if (empty($row['add_deny']))
- $deny_boards[$row['permission']][] = $row['id_board'];
- else
- $boards[$row['permission']][] = $row['id_board'];
- }
- }
- $smcFunc['db_free_result']($request);
- if ($simple)
- $result = array_unique(array_values(array_diff($boards, $deny_boards)));
- else
- foreach ($permissions as $permission)
- $result[$permission] = array_unique(array_values(array_diff($boards[$permission], $deny_boards[$permission])));
- return $result;
- }
- /**
- * Returns whether an email address should be shown and how.
- * Possible outcomes are
- * 'yes': show the full email address
- * 'yes_permission_override': show the full email address, either you
- * are a moderator or it's your own email address.
- * 'no_through_forum': don't show the email address, but do allow
- * things to be mailed using the built-in forum mailer.
- * 'no': keep the email address hidden.
- * @param bool $userProfile_hideEmail
- * @param int $userProfile_id
- * @return string (yes, yes_permission_override, no_through_forum, no)
- */
- function showEmailAddress($userProfile_hideEmail, $userProfile_id)
- {
- global $modSettings, $user_info;
- // Should this user's email address be shown?
- // If you're guest and the forum is set to hide email for guests: no.
- // If the user is post-banned: no.
- // If it's your own profile and you've set your address hidden: yes_permission_override.
- // If you're a moderator with sufficient permissions: yes_permission_override.
- // If the user has set their email address to be hidden: no.
- // If the forum is set to show full email addresses: yes.
- // Otherwise: no_through_forum.
- if ((!empty($modSettings['guest_hideContacts']) && $user_info['is_guest']) || isset($_SESSION['ban']['cannot_post']))
- return 'no';
- elseif ((!$user_info['is_guest'] && $user_info['id'] == $userProfile_id && !$userProfile_hideEmail) || allowedTo('moderate_forum'))
- return 'yes_permission_override';
- elseif ($userProfile_hideEmail)
- return 'no';
- elseif (!empty($modSettings['make_email_viewable']) )
- return 'yes';
- else
- return 'no_through_forum';
- }
- /**
- * This function attempts to protect from spammed messages and the like.
- * The time taken depends on error_type - generally uses the modSetting.
- *
- * @param string $error_type, used also as a $txt index. (not an actual string.)
- * @return boolean
- */
- function spamProtection($error_type)
- {
- global $modSettings, $txt, $user_info, $smcFunc;
- // Certain types take less/more time.
- $timeOverrides = array(
- 'login' => 2,
- 'register' => 2,
- 'remind' => 30,
- 'sendtopic' => $modSettings['spamWaitTime'] * 4,
- 'sendmail' => $modSettings['spamWaitTime'] * 5,
- 'reporttm' => $modSettings['spamWaitTime'] * 4,
- 'search' => !empty($modSettings['search_floodcontrol_time']) ? $modSettings['search_floodcontrol_time'] : 1,
- );
- // Moderators are free...
- if (!allowedTo('moderate_board'))
- $timeLimit = isset($timeOverrides[$error_type]) ? $timeOverrides[$error_type] : $modSettings['spamWaitTime'];
- else
- $timeLimit = 2;
- // Delete old entries...
- $smcFunc['db_query']('', '
- DELETE FROM {db_prefix}log_floodcontrol
- WHERE log_time < {int:log_time}
- AND log_type = {string:log_type}',
- array(
- 'log_time' => time() - $timeLimit,
- 'log_type' => $error_type,
- )
- );
- // Add a new entry, deleting the old if necessary.
- $smcFunc['db_insert']('replace',
- '{db_prefix}log_floodcontrol',
- array('ip' => 'string-16', 'log_time' => 'int', 'log_type' => 'string'),
- array($user_info['ip'], time(), $error_type),
- array('ip', 'log_type')
- );
- // If affected is 0 or 2, it was there already.
- if ($smcFunc['db_affected_rows']() != 1)
- {
- // Spammer! You only have to wait a *few* seconds!
- fatal_lang_error($error_type . 'WaitTime_broken', false, array($timeLimit));
- return true;
- }
- // They haven't posted within the limit.
- return false;
- }
- /**
- * A generic function to create a pair of index.php and .htaccess files in a directory
- * @param string $path, the (absolute) directory path
- * @param boolean $attachments, if the directory is an attachments directory or not
- * @return true on success, error string if anything fails
- */
- function secureDirectory($path, $attachments = false)
- {
- if (empty($path))
- return 'empty_path';
- if (!is_writable($path))
- return 'path_not_writable';
- $directoryname = basename($path);
- $errors = array();
- $close = empty($attachments) ? '
- </Files>' : '
- Allow from localhost
- </Files>
- RemoveHandler .php .php3 .phtml .cgi .fcgi .pl .fpl .shtml';
- if (file_exists($path . '/.htaccess'))
- $errors[] = 'htaccess_exists';
- else
- {
- $fh = @fopen($path . '/.htaccess', 'w');
- if ($fh) {
- fwrite($fh, '<Files *>
- Order Deny,Allow
- Deny from all' . $close);
- fclose($fh);
- }
- $errors[] = 'htaccess_cannot_create_file';
- }
- if (file_exists($path . '/index.php'))
- $errors[] = 'index-php_exists';
- else
- {
- $fh = @fopen($path . '/index.php', 'w');
- if ($fh) {
- fwrite($fh, '<?php
- // This file is here solely to protect your ' . $directoryname . ' directory.
- // Look for Settings.php....
- if (file_exists(dirname(dirname(__FILE__)) . \'/Settings.php\'))
- {
- // Found it!
- require(dirname(dirname(__FILE__)) . \'/Settings.php\');
- header(\'Location: \' . $boardurl);
- }
- // Can\'t find it... just forget it.
- else
- exit;
- ?>');
- fclose($fh);
- }
- $errors[] = 'index-php_cannot_create_file';
- }
- if (!empty($errors))
- return $errors;
- else
- return true;
- }
- /**
- * Another helper function that put together the
- * @param string $fullip An IP address either IPv6 or not
- * @return string A SQL condition
- */
- function constructBanQueryIP($fullip)
- {
- // First attempt a IPv6 address.
- if (isValidIPv6($fullip))
- {
- $ip_parts = convertIPv6toInts($fullip);
- $ban_query = '((' . $ip_parts[0] . ' BETWEEN bi.ip_low1 AND bi.ip_high1)
- AND (' . $ip_parts[1] . ' BETWEEN bi.ip_low2 AND bi.ip_high2)
- AND (' . $ip_parts[2] . ' BETWEEN bi.ip_low3 AND bi.ip_high3)
- AND (' . $ip_parts[3] . ' BETWEEN bi.ip_low4 AND bi.ip_high4)
- AND (' . $ip_parts[4] . ' BETWEEN bi.ip_low5 AND bi.ip_high5)
- AND (' . $ip_parts[5] . ' BETWEEN bi.ip_low6 AND bi.ip_high6)
- AND (' . $ip_parts[6] . ' BETWEEN bi.ip_low7 AND bi.ip_high7)
- AND (' . $ip_parts[7] . ' BETWEEN bi.ip_low8 AND bi.ip_high8))';
- }
- // Check if we have a valid IPv4 address.
- elseif (preg_match('/^(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})$/', $fullip, $ip_parts) == 1)
- $ban_query = '((' . $ip_parts[1] . ' BETWEEN bi.ip_low1 AND bi.ip_high1)
- AND (' . $ip_parts[2] . ' BETWEEN bi.ip_low2 AND bi.ip_high2)
- AND (' . $ip_parts[3] . ' BETWEEN bi.ip_low3 AND bi.ip_high3)
- AND (' . $ip_parts[4] . ' BETWEEN bi.ip_low4 AND bi.ip_high4))';
- // We use '255.255.255.255' for 'unknown' since it's not valid anyway.
- else
- $ban_query = '(bi.ip_low1 = 255 AND bi.ip_high1 = 255
- AND bi.ip_low2 = 255 AND bi.ip_high2 = 255
- AND bi.ip_low3 = 255 AND bi.ip_high3 = 255
- AND bi.ip_low4 = 255 AND bi.ip_high4 = 255)';
- return $ban_query;
- }
- ?>
|