PHP phpbb_clean_username函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中phpbb_clean_username函数的典型用法代码示例。如果您正苦于以下问题：PHP phpbb_clean_username函数的具体用法？PHP phpbb_clean_username怎么用？PHP phpbb_clean_username使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了phpbb_clean_username函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: validate_username

function validate_username($username)
{
    global $db, $lang, $userdata;
    // Remove doubled up spaces
    $username = preg_replace('#\\s+#', ' ', trim($username));
    $username = phpbb_clean_username($username);
    $sql = "SELECT username \r\n\t\tFROM " . USERS_TABLE . "\r\n\t\tWHERE LOWER(username) = '" . strtolower($username) . "'";
    if ($result = $db->sql_query($sql)) {
        while ($row = $db->sql_fetchrow($result)) {
            if ($userdata['session_logged_in'] && $row['username'] != $userdata['username'] || !$userdata['session_logged_in']) {
                $db->sql_freeresult($result);
                return array('error' => true, 'error_msg' => $lang['Username_taken']);
            }
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT group_name\r\n\t\tFROM " . GROUPS_TABLE . " \r\n\t\tWHERE LOWER(group_name) = '" . strtolower($username) . "'";
    if ($result = $db->sql_query($sql)) {
        if ($row = $db->sql_fetchrow($result)) {
            $db->sql_freeresult($result);
            return array('error' => true, 'error_msg' => $lang['Username_taken']);
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT disallow_username\r\n\t\tFROM " . DISALLOW_TABLE;
    if ($result = $db->sql_query($sql)) {
        if ($row = $db->sql_fetchrow($result)) {
            do {
                if (preg_match("#\\b(" . str_replace("\\*", ".*?", preg_quote($row['disallow_username'], '#')) . ")\\b#i", $username)) {
                    $db->sql_freeresult($result);
                    return array('error' => true, 'error_msg' => $lang['Username_disallowed']);
                }
            } while ($row = $db->sql_fetchrow($result));
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT word \r\n\t\tFROM  " . WORDS_TABLE;
    if ($result = $db->sql_query($sql)) {
        if ($row = $db->sql_fetchrow($result)) {
            do {
                if (preg_match("#\\b(" . str_replace("\\*", ".*?", preg_quote($row['word'], '#')) . ")\\b#i", $username)) {
                    $db->sql_freeresult($result);
                    return array('error' => true, 'error_msg' => $lang['Username_disallowed']);
                }
            } while ($row = $db->sql_fetchrow($result));
        }
    }
    $db->sql_freeresult($result);
    // Don't allow " and ALT-255 in username.
    if (strstr($username, '"') || strstr($username, '&quot;') || strstr($username, chr(160)) || strstr($username, chr(173))) {
        return array('error' => true, 'error_msg' => $lang['Username_invalid']);
    }
    return array('error' => false, 'error_msg' => '');
}

开发者ID:Nekrofage，项目名称:FJR，代码行数:54，代码来源:functions_validate.php

示例2: get_userdata

function get_userdata($user, $force_str = false)
{
    global $db;
    if (intval($user) == 0 || $force_str) {
        $user = phpbb_clean_username($user);
    } else {
        $user = intval($user);
    }
    $sql = "SELECT *\n\t\tFROM " . USERS_TABLE . " \n\t\tWHERE ";
    $sql .= (is_integer($user) ? "user_id = {$user}" : "username = '" . $user . "'") . " AND user_id <> " . ANONYMOUS;
    if (!($result = $db->sql_query($sql))) {
        message_die(GENERAL_ERROR, 'Tried obtaining data for a non-existent user', '', __LINE__, __FILE__, $sql);
    }
    return ($row = $db->sql_fetchrow($result)) ? $row : false;
}

开发者ID:Juuro，项目名称:Dreamapp-Website，代码行数:15，代码来源:functions.php

示例3: get_userdata_notifications

function get_userdata_notifications($target_user, $force_str = false)
{
    global $db;
    $target_user = !is_numeric($target_user) || $force_str ? phpbb_clean_username($target_user) : intval($target_user);
    $sql = "SELECT *\n\t\t\tFROM " . USERS_TABLE . "\n\t\t\tWHERE ";
    $sql .= (is_integer($target_user) ? "user_id = " . $target_user : "username = '" . $db->sql_escape($target_user) . "'") . " AND user_id <> " . ANONYMOUS;
    $result = $db->sql_query($sql);
    $return_value = ($row = $db->sql_fetchrow($result)) ? $row : false;
    $db->sql_freeresult($result);
    return $return_value;
}

开发者ID:ALTUN69，项目名称:icy_phoenix，代码行数:11，代码来源:functions_post.php

示例4: message_die

         message_die(GENERAL_ERROR, "Could not obtain message details", "", __LINE__, __FILE__, $sql);
     }
     if (!($row = $db->sql_fetchrow($result))) {
         message_die(GENERAL_MESSAGE, $lang['No_such_post']);
     }
     $db->sql_freeresult($result);
     unset($row);
 }
 if ($submit) {
     // session id check
     if ($sid == '' || $sid != $userdata['session_id']) {
         $error = true;
         $error_msg .= (!empty($error_msg) ? '<br />' : '') . $lang['Session_invalid'];
     }
     if (!empty($HTTP_POST_VARS['username'])) {
         $to_username = phpbb_clean_username($HTTP_POST_VARS['username']);
         $sql = "SELECT user_id, user_notify_pm, user_email, user_lang, user_active \r\n\t\t\t\tFROM " . USERS_TABLE . "\r\n\t\t\t\tWHERE username = '" . str_replace("\\'", "''", $to_username) . "'\r\n\t\t\t\t\tAND user_id <> " . ANONYMOUS;
         if (!($result = $db->sql_query($sql))) {
             $error = TRUE;
             $error_msg = $lang['No_such_user'];
         }
         if (!($to_userdata = $db->sql_fetchrow($result))) {
             $error = TRUE;
             $error_msg = $lang['No_such_user'];
         }
     } else {
         $error = TRUE;
         $error_msg .= (!empty($error_msg) ? '<br />' : '') . $lang['No_to_user'];
     }
     $privmsg_subject = trim(htmlspecialchars($HTTP_POST_VARS['subject']));
     if (empty($privmsg_subject)) {

开发者ID:Nekrofage，项目名称:FJR，代码行数:31，代码来源:privmsg.php

示例5: implode

     }
     if (count($mark_list)) {
         $delete_sql_id = implode(', ', $mark_list);
         $delete_text_sql = "DELETE FROM " . PRIVMSGS_TEXT_TABLE . "\n\t\t\t\t\tWHERE privmsgs_text_id IN ({$delete_sql_id})";
         $delete_sql = "DELETE FROM " . PRIVMSGS_TABLE . "\n\t\t\t\t\tWHERE privmsgs_id IN ({$delete_sql_id})";
         if (!$db->sql_query($delete_sql)) {
             message_die(GENERAL_ERROR, 'Could not delete private message info', '', __LINE__, __FILE__, $delete_sql);
         }
         if (!$db->sql_query($delete_text_sql)) {
             message_die(GENERAL_ERROR, 'Could not delete private message text', '', __LINE__, __FILE__, $delete_text_sql);
         }
     }
     $message = $lang['User_deleted'] . '<br /><br />' . sprintf($lang['Click_return_useradmin'], '<a href="' . append_sid("admin_users.{$phpEx}") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.{$phpEx}?pane=right") . '">', '</a>');
     message_die(GENERAL_MESSAGE, $message);
 }
 $username = !empty($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
 $email = !empty($HTTP_POST_VARS['email']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['email']))) : '';
 $password = !empty($HTTP_POST_VARS['password']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['password']))) : '';
 $password_confirm = !empty($HTTP_POST_VARS['password_confirm']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['password_confirm']))) : '';
 $icq = !empty($HTTP_POST_VARS['icq']) ? trim(strip_tags($HTTP_POST_VARS['icq'])) : '';
 $aim = !empty($HTTP_POST_VARS['aim']) ? trim(strip_tags($HTTP_POST_VARS['aim'])) : '';
 $msn = !empty($HTTP_POST_VARS['msn']) ? trim(strip_tags($HTTP_POST_VARS['msn'])) : '';
 $yim = !empty($HTTP_POST_VARS['yim']) ? trim(strip_tags($HTTP_POST_VARS['yim'])) : '';
 $website = !empty($HTTP_POST_VARS['website']) ? trim(strip_tags($HTTP_POST_VARS['website'])) : '';
 $location = !empty($HTTP_POST_VARS['location']) ? trim(strip_tags($HTTP_POST_VARS['location'])) : '';
 $occupation = !empty($HTTP_POST_VARS['occupation']) ? trim(strip_tags($HTTP_POST_VARS['occupation'])) : '';
 $interests = !empty($HTTP_POST_VARS['interests']) ? trim(strip_tags($HTTP_POST_VARS['interests'])) : '';
 $signature = !empty($HTTP_POST_VARS['signature']) ? trim(str_replace('<br />', "\n", $HTTP_POST_VARS['signature'])) : '';
 validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature);
 $viewemail = isset($HTTP_POST_VARS['viewemail']) ? $HTTP_POST_VARS['viewemail'] ? TRUE : 0 : 0;
 $allowviewonline = isset($HTTP_POST_VARS['hideonline']) ? $HTTP_POST_VARS['hideonline'] ? 0 : TRUE : TRUE;

开发者ID:bitweaver，项目名称:phpbb，代码行数:31，代码来源:admin_users.php

示例6: redirect

 //
 if (!empty($HTTP_POST_VARS['add']) || !empty($HTTP_POST_VARS['remove']) || isset($HTTP_POST_VARS['approve']) || isset($HTTP_POST_VARS['deny'])) {
     if (!$userdata['session_logged_in']) {
         redirect(append_sid("login.{$phpEx}?redirect=groupcp.{$phpEx}&" . POST_GROUPS_URL . "={$group_id}", true));
     } else {
         if ($sid !== $userdata['session_id']) {
             message_die(GENERAL_ERROR, $lang['Session_invalid']);
         }
     }
     if (!$is_moderator) {
         $template->assign_vars(array('META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("index.{$phpEx}") . '">'));
         $message = $lang['Not_group_moderator'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.{$phpEx}") . '">', '</a>');
         message_die(GENERAL_MESSAGE, $message);
     }
     if (isset($HTTP_POST_VARS['add'])) {
         $username = isset($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
         $sql = "SELECT user_id, user_email, user_lang, user_level  \n\t\t\t\t\tFROM " . USERS_TABLE . " \n\t\t\t\t\tWHERE username = '" . str_replace("\\'", "''", $username) . "'";
         if (!($result = $db->sql_query($sql))) {
             message_die(GENERAL_ERROR, "Could not get user information", $lang['Error'], __LINE__, __FILE__, $sql);
         }
         if (!($row = $db->sql_fetchrow($result))) {
             $template->assign_vars(array('META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.{$phpEx}?" . POST_GROUPS_URL . "={$group_id}") . '">'));
             $message = $lang['Could_not_add_user'] . "<br /><br />" . sprintf($lang['Click_return_group'], "<a href=\"" . append_sid("groupcp.{$phpEx}?" . POST_GROUPS_URL . "={$group_id}") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_index'], "<a href=\"" . append_sid("index.{$phpEx}") . "\">", "</a>");
             message_die(GENERAL_MESSAGE, $message);
         }
         if ($row['user_id'] == ANONYMOUS) {
             $template->assign_vars(array('META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("groupcp.{$phpEx}?" . POST_GROUPS_URL . "={$group_id}") . '">'));
             $message = $lang['Could_not_anon_user'] . '<br /><br />' . sprintf($lang['Click_return_group'], '<a href="' . append_sid("groupcp.{$phpEx}?" . POST_GROUPS_URL . "={$group_id}") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.{$phpEx}") . '">', '</a>');
             message_die(GENERAL_MESSAGE, $message);
         }
         $sql = "SELECT ug.user_id, u.user_level \n\t\t\t\t\tFROM " . USER_GROUP_TABLE . " ug, " . USERS_TABLE . " u \n\t\t\t\t\tWHERE u.user_id = " . $row['user_id'] . " \n\t\t\t\t\t\tAND ug.user_id = u.user_id \n\t\t\t\t\t\tAND ug.group_id = {$group_id}";

开发者ID:ZerGabriel，项目名称:adr-rpg，代码行数:31，代码来源:groupcp.php

示例7: isset

//
// Define initial vars
//
if (isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode'])) {
    $mode = isset($HTTP_POST_VARS['mode']) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
} else {
    $mode = '';
}
if (isset($HTTP_POST_VARS['search_keywords']) || isset($HTTP_GET_VARS['search_keywords'])) {
    $search_keywords = isset($HTTP_POST_VARS['search_keywords']) ? $HTTP_POST_VARS['search_keywords'] : $HTTP_GET_VARS['search_keywords'];
} else {
    $search_keywords = '';
}
if (isset($HTTP_POST_VARS['search_author']) || isset($HTTP_GET_VARS['search_author'])) {
    $search_author = isset($HTTP_POST_VARS['search_author']) ? $HTTP_POST_VARS['search_author'] : $HTTP_GET_VARS['search_author'];
    $search_author = phpbb_clean_username($search_author);
} else {
    $search_author = '';
}
$search_id = isset($HTTP_GET_VARS['search_id']) ? $HTTP_GET_VARS['search_id'] : '';
$show_results = isset($HTTP_POST_VARS['show_results']) ? $HTTP_POST_VARS['show_results'] : 'posts';
$show_results = $show_results == 'topics' ? 'topics' : 'posts';
if (isset($HTTP_POST_VARS['search_terms'])) {
    $search_terms = $HTTP_POST_VARS['search_terms'] == 'all' ? 1 : 0;
} else {
    $search_terms = 0;
}
if (isset($HTTP_POST_VARS['search_fields'])) {
    $search_fields = $HTTP_POST_VARS['search_fields'] == 'all' ? 1 : 0;
} else {
    $search_fields = 0;

开发者ID:Juuro，项目名称:Dreamapp-Website，代码行数:31，代码来源:search.php

示例8: die

 ***************************************************************************/
/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *
 ***************************************************************************/
if (!defined('IN_PHPBB')) {
    die('Hacking attempt');
    exit;
}
if (isset($_POST['submit'])) {
    $username = !empty($_POST['username']) ? phpbb_clean_username($_POST['username']) : '';
    $email = !empty($_POST['email']) ? trim(strip_tags(htmlspecialchars($_POST['email']))) : '';
    $sql = "SELECT user_id, username, user_email, user_active, user_lang \n\t\tFROM " . USERS_TABLE . " \n\t\tWHERE user_email = '" . str_replace("\\'", "''", $email) . "' \n\t\t\tAND username = '" . str_replace("\\'", "''", $username) . "'";
    if ($result = $db->sql_query($sql)) {
        if ($row = $db->sql_fetchrow($result)) {
            if (!$row['user_active']) {
                message_die(GENERAL_MESSAGE, $lang['No_send_account_inactive']);
            }
            $username = $row['username'];
            $user_id = $row['user_id'];
            $user_actkey = gen_rand_string(true);
            $key_len = 54 - strlen($server_url);
            $key_len = $key_len > 6 ? $key_len : 6;
            $user_actkey = substr($user_actkey, 0, $key_len);
            $user_password = gen_rand_string(false);
            $sql = "UPDATE " . USERS_TABLE . " \n\t\t\t\tSET user_newpasswd = '" . md5($user_password) . "', user_actkey = '{$user_actkey}'  \n\t\t\t\tWHERE user_id = " . $row['user_id'];

开发者ID:nmpetkov，项目名称:ZphpBB2，代码行数:31，代码来源:usercp_sendpasswd.php

示例9: intval

         } else {
             $_varary = $_POST['pending_members'];
         }
         $_data = '';
         for ($i = 0; $i < sizeof($_varary); $i++) {
             $_data .= ($_data != '' ? ', ' : '') . intval($_varary[$i]);
         }
         $content .= '[Group Edit: ' . $_tmp1 . ' ==> ' . $_data . ']';
         if ($db_log_actions == true) {
             $db_log = array('action' => 'GROUP_EDIT', 'desc' => $_tmp1, 'target' => $_data);
         }
         $update_log = true;
     } elseif (isset($_POST['add']) && isset($_POST['username'])) {
         $content .= '[Group Add: ' . $_tmp1 . ' ==> ' . $_POST['username'] . ']';
         if ($db_log_actions == true) {
             $sql = get_users_sql(phpbb_clean_username($_POST['username']), false, false, true, true);
             $result = $db->sql_query($sql);
             $user_row = $db->sql_fetchrow($result);
             $db->sql_freeresult($result);
             $db_log = array('action' => 'GROUP_ADD', 'desc' => $_tmp1, 'target' => $user_row['user_id']);
         }
         $update_log = true;
     } elseif (isset($_POST['groupstatus']) && isset($_POST['group_type'])) {
         $content .= '[Group Type: ' . $_tmp1 . ' ==> ' . intval($_POST['group_type']) . ']';
         if ($db_log_actions == true) {
             $db_log = array('action' => 'GROUP_TYPE', 'desc' => $_tmp1 . ';' . intval($_POST['group_type']), 'target' => '');
         }
         $update_log = true;
     }
 }
 break;

开发者ID:ALTUN69，项目名称:icy_phoenix，代码行数:31，代码来源:log_http_cmd.php

示例10: sizeof

 }
 $db->sql_freeresult($result);
 // remove friends from the username array
 $n = sizeof($data['add']);
 $data['add'] = array_diff($data['add'], $friends);
 // remove foes from the username array
 $n = sizeof($data['add']);
 $data['add'] = array_diff($data['add'], $foes);
 // remove the user himself from the username array
 $n = sizeof($data['add']);
 $data['add'] = array_diff($data['add'], array($user->data['username']));
 unset($friends, $foes, $n);
 if (sizeof($data['add'])) {
     $users_to_add = '';
     foreach ($data['add'] as $user_tmp) {
         $username_tmp = phpbb_clean_username($user_tmp);
         //$users_to_add .= (($users_to_add == '') ? '' : ', ') . "'" . $db->sql_escape($username_tmp) . "'";
         $users_to_add .= ($users_to_add == '' ? '' : ', ') . "'" . $db->sql_escape(utf8_clean_string($username_tmp)) . "'";
     }
     //$users_to_add = implode('\',\'', $data['add']);
     $sql = "SELECT user_id, user_level\n\t\t\t\t\tFROM " . USERS_TABLE . "\n\t\t\t\t\tWHERE username_clean IN (" . $users_to_add . ")\n\t\t\t\t\t\tAND user_active = 1";
     //die($sql);
     $result = $db->sql_query($sql);
     $user_id_ary = array();
     $user_id_level = array();
     while ($row = $db->sql_fetchrow($result)) {
         if ($row['user_id'] != ANONYMOUS) {
             $user_id_ary[$row['user_id']] = $row['user_id'];
             $user_id_level[$row['user_id']] = $row['user_level'];
         }
     }

开发者ID:ALTUN69，项目名称:icy_phoenix，代码行数:31，代码来源:usercp_zebra.php

示例11: append_sid

	}

	$params[] = 'users_per_page=' . $users_per_page;
	$sort_params[] = 'users_per_page=' . $users_per_page;
	$params[] = 'mode=' . $mode;
	$sort_params[] = 'mode=' . $mode;
}

$pagination_url = append_sid(CMS_PAGE_MEMBERLIST, false, false, implode('&amp;', $params));
$sort_url = append_sid(CMS_PAGE_MEMBERLIST, false, false, implode('&amp;', $sort_params));

unset($search_params, $sort_params);

if (!empty($alphanum))
{
	$alphanum = ($alphanum == '#') ? '#' : (phpbb_clean_username(ip_clean_username(strtolower(urldecode($alphanum)))));
	$sql_where = ($alphanum == '#') ? "AND LOWER(username) NOT RLIKE '^[a-z]'" : "AND LOWER(username) LIKE '" . $db->sql_escape($alphanum) . "%'";
}

if (($action == 'searchuser') && ($user->data['user_level'] == ADMIN))
{
	$template->assign_vars(array(
		'USERNAME' => $username,
		'EMAIL' => $email,
		'AIM' => $aim,
		'ICQ' => $icq,
		'JABBER' => $jabber,
		'MSNM' => $msn,
		'SKYPE' => $skype,
		'YAHOO' => $yahoo,
		'JOINED' => implode('-', $joined),

开发者ID:ALTUN69，项目名称:icy_phoenix，代码行数:31，代码来源:memberlist.php

示例12: rss_get_user

function rss_get_user()
{
    global $db, $HTTP_SERVER_VARS, $HTTP_GET_VARS;
    if ((!isset($HTTP_SERVER_VARS['PHP_AUTH_USER']) || !isset($HTTP_SERVER_VARS['PHP_AUTH_PW'])) && isset($HTTP_SERVER_VARS['REMOTE_USER']) && preg_match('/Basic\\s+(.*)$/i', $HTTP_SERVER_VARS['REMOTE_USER'], $matches)) {
        list($name, $password) = explode(':', base64_decode($matches[1]), 2);
        $HTTP_SERVER_VARS['PHP_AUTH_USER'] = strip_tags($name);
        $HTTP_SERVER_VARS['PHP_AUTH_PW'] = strip_tags($password);
    }
    if (isset($HTTP_SERVER_VARS['PHP_AUTH_USER']) && isset($HTTP_SERVER_VARS['PHP_AUTH_PW'])) {
        $username = phpbb_clean_username($HTTP_SERVER_VARS['PHP_AUTH_USER']);
        $password = md5($HTTP_SERVER_VARS['PHP_AUTH_PW']);
        if (isset($HTTP_GET_VARS['uid'])) {
            $uid = intval($HTTP_GET_VARS['uid']);
            $sql = "SELECT * FROM " . USERS_TABLE . " WHERE user_id = {$uid}";
        } else {
            $sql = "SELECT user_id, username, user_password, user_active, user_level\n\t\t\tFROM " . USERS_TABLE . "\n\t\t\tWHERE username = '" . str_replace("\\'", "''", $username) . "'";
        }
        if (!($result = $db->sql_query($sql))) {
            message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);
        }
        if ($row = $db->sql_fetchrow($result)) {
            if ($password == $row['user_password'] && $row['user_active']) {
                // Yes!!!  It's good user
                return $row['user_id'];
            } else {
                GetHTTPPasswd();
            }
        }
    } else {
        GetHTTPPasswd();
    }
    return ANONYMOUS;
}

开发者ID:BackupTheBerlios，项目名称:flushcms，代码行数:33，代码来源:rss_functions.php

示例13: get_users_sql

function get_users_sql($username, $sql_like = false, $all_data = false, $data_escape = true, $clean_username = false)
{
    global $config, $cache, $db;
    $username = !empty($clean_username) ? phpbb_clean_username($username) : $username;
    $sql = "SELECT " . (!empty($all_data) ? "*" : "user_id, username, username_clean, user_active, user_color, user_level") . " FROM " . USERS_TABLE . "\n\t\tWHERE username_clean " . (!empty($sql_like) ? " LIKE " : " = ") . "'" . (!empty($data_escape) ? $db->sql_escape(utf8_clean_string($username)) : $username) . "'" . (!empty($sql_like) ? "" : " LIMIT 1");
    return $sql;
}

开发者ID:GabrielAnca，项目名称:icy_phoenix，代码行数:7，代码来源:functions.php

示例14: implode

     }
     if (count($mark_list)) {
         $delete_sql_id = implode(', ', $mark_list);
         $delete_text_sql = "DELETE FROM " . PRIVMSGS_TEXT_TABLE . "\n\t\t\t\t\tWHERE privmsgs_text_id IN ({$delete_sql_id})";
         $delete_sql = "DELETE FROM " . PRIVMSGS_TABLE . "\n\t\t\t\t\tWHERE privmsgs_id IN ({$delete_sql_id})";
         if (!$db->sql_query($delete_sql)) {
             message_die(GENERAL_ERROR, 'Could not delete private message info', '', __LINE__, __FILE__, $delete_sql);
         }
         if (!$db->sql_query($delete_text_sql)) {
             message_die(GENERAL_ERROR, 'Could not delete private message text', '', __LINE__, __FILE__, $delete_text_sql);
         }
     }
     $message = $lang['User_deleted'] . '<br /><br />' . sprintf($lang['Click_return_useradmin'], '<a href="' . append_sid("admin_users.{$phpEx}") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.{$phpEx}?pane=right") . '">', '</a>');
     message_die(GENERAL_MESSAGE, $message);
 }
 $username = !empty($HTTP_POST_VARS['username']) ? ereg_replace("&amp;", "&", phpbb_clean_username($HTTP_POST_VARS['username'])) : '';
 $email = !empty($HTTP_POST_VARS['email']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['email']))) : '';
 $password = !empty($HTTP_POST_VARS['password']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['password']))) : '';
 $password_confirm = !empty($HTTP_POST_VARS['password_confirm']) ? trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['password_confirm']))) : '';
 $icq = !empty($HTTP_POST_VARS['icq']) ? trim(strip_tags($HTTP_POST_VARS['icq'])) : '';
 $aim = !empty($HTTP_POST_VARS['aim']) ? trim(strip_tags($HTTP_POST_VARS['aim'])) : '';
 $msn = !empty($HTTP_POST_VARS['msn']) ? trim(strip_tags($HTTP_POST_VARS['msn'])) : '';
 $yim = !empty($HTTP_POST_VARS['yim']) ? trim(strip_tags($HTTP_POST_VARS['yim'])) : '';
 $skype = !empty($HTTP_POST_VARS['skype']) ? trim(strip_tags($HTTP_POST_VARS['skype'])) : '';
 $website = !empty($HTTP_POST_VARS['website']) ? trim(strip_tags($HTTP_POST_VARS['website'])) : '';
 $location = !empty($HTTP_POST_VARS['location']) ? trim(strip_tags($HTTP_POST_VARS['location'])) : '';
 $occupation = !empty($HTTP_POST_VARS['occupation']) ? trim(strip_tags($HTTP_POST_VARS['occupation'])) : '';
 $interests = !empty($HTTP_POST_VARS['interests']) ? trim(strip_tags($HTTP_POST_VARS['interests'])) : '';
 $gender = isset($HTTP_POST_VARS['gender']) ? intval($HTTP_POST_VARS['gender']) : 0;
 if (isset($HTTP_POST_VARS['birthday'])) {
     $birthday = intval($HTTP_POST_VARS['birthday']);

开发者ID:BackupTheBerlios，项目名称:flushcms，代码行数:31，代码来源:admin_users.php

示例15: message_die

				AND privmsgs_from_userid = ' . $userdata['user_id'];
                        if (!($result = $db->sql_query($sql))) {
                            message_die(GENERAL_ERROR, "Could not obtain message details", "", __LINE__, __FILE__, $sql);
                        }
                        if (!($row = $db->sql_fetchrow($result))) {
                            message_die(GENERAL_MESSAGE, $lang['No_such_post']);
                        }
                        $db->sql_freeresult($result);
                        unset($row);
                    }
                    if ($submit) {
                        if (!empty($HTTP_POST_VARS['username'])) {
                            $to_username_array = explode(";", $HTTP_POST_VARS['username']);
                            usort($to_username_array, create_function('$a,$b', 'return strcasecmp($a,$b);'));
                            foreach ($to_username_array as $name) {
                                $to_usernames .= "'" . phpbb_clean_username($name) . "',";
                            }
                            $to_usernames[strlen($to_usernames) - 1] = " ";
                            $sql = "SELECT user_id, username, user_notify_pm, user_email, user_lang, user_active \n\t\t\t\tFROM " . USERS_TABLE . "\n\t\t\t\tWHERE username IN (" . str_replace("\\'", "''", $to_usernames) . ")\n\t\t\t\t\tAND user_id <> " . ANONYMOUS . " \n\t\t\t\tORDER BY username ASC";
                            if (!($result2 = $db->sql_query($sql))) {
                                message_die(GENERAL_ERROR, 'Could not obtain users PM information', '', __LINE__, __FILE__, $sql);
                            }
                            if (!($to_users = $db->sql_fetchrowset($result2))) {
                                $error = TRUE;
                                $error_msg = $lang['No_such_user'];
                            }
                            $n = 0;
                            while ($to_username_array[$n] && !$error) {
                                if (strcasecmp($to_users[$n]['username'], str_replace("\\'", "'", $to_username_array[$n]))) {
                                    $error = TRUE;
                                    $error_msg .= $lang['No_such_user'] . " '" . str_replace("\\'", "'", $to_username_array[$n]);

开发者ID:BackupTheBerlios，项目名称:flushcms，代码行数:31，代码来源:privmsg.php

示例16: search_attachments

function search_attachments($order_by, &$total_rows)
{
    global $db, $HTTP_POST_VARS, $HTTP_GET_VARS, $lang;
    $where_sql = array();
    // Get submitted Vars
    $search_vars = array('search_keyword_fname', 'search_keyword_comment', 'search_author', 'search_size_smaller', 'search_size_greater', 'search_count_smaller', 'search_count_greater', 'search_days_greater', 'search_forum', 'search_cat');
    for ($i = 0; $i < sizeof($search_vars); $i++) {
        ${$search_vars}[$i] = get_var($search_vars[$i], '');
    }
    // Author name search
    if ($search_author != '') {
        // Bring in line with 2.0.x expected username
        $search_author = addslashes(html_entity_decode($search_author));
        $search_author = stripslashes(phpbb_clean_username($search_author));
        // Prepare for directly going into sql query
        $search_author = str_replace('*', '%', attach_mod_sql_escape($search_author));
        // We need the post_id's, because we want to query the Attachment Table
        $sql = 'SELECT user_id
			FROM ' . USERS_TABLE . "\n\t\t\tWHERE username LIKE '{$search_author}'";
        if (!($result = $db->sql_query($sql))) {
            message_die(GENERAL_ERROR, 'Couldn\'t obtain list of matching users (searching for: ' . $search_author . ')', '', __LINE__, __FILE__, $sql);
        }
        $matching_userids = '';
        if ($row = $db->sql_fetchrow($result)) {
            do {
                $matching_userids .= ($matching_userids != '' ? ', ' : '') . intval($row['user_id']);
            } while ($row = $db->sql_fetchrow($result));
            $db->sql_freeresult($result);
        } else {
            message_die(GENERAL_MESSAGE, $lang['No_attach_search_match']);
        }
        $where_sql[] = ' (t.user_id_1 IN (' . $matching_userids . ')) ';
    }
    // Search Keyword
    if ($search_keyword_fname != '') {
        $match_word = str_replace('*', '%', $search_keyword_fname);
        $where_sql[] = " (a.real_filename LIKE '" . attach_mod_sql_escape($match_word) . "') ";
    }
    if ($search_keyword_comment != '') {
        $match_word = str_replace('*', '%', $search_keyword_comment);
        $where_sql[] = " (a.comment LIKE '" . attach_mod_sql_escape($match_word) . "') ";
    }
    // Search Download Count
    if ($search_count_smaller != '' || $search_count_greater != '') {
        if ($search_count_smaller != '') {
            $where_sql[] = ' (a.download_count < ' . (int) $search_count_smaller . ') ';
        } else {
            if ($search_count_greater != '') {
                $where_sql[] = ' (a.download_count > ' . (int) $search_count_greater . ') ';
            }
        }
    }
    // Search Filesize
    if ($search_size_smaller != '' || $search_size_greater != '') {
        if ($search_size_smaller != '') {
            $where_sql[] = ' (a.filesize < ' . (int) $search_size_smaller . ') ';
        } else {
            if ($search_size_greater != '') {
                $where_sql[] = ' (a.filesize > ' . (int) $search_size_greater . ') ';
            }
        }
    }
    // Search Attachment Time
    if ($search_days_greater != '') {
        $where_sql[] = ' (a.filetime < ' . (time() - (int) $search_days_greater * 86400) . ') ';
    }
    // Search Forum
    if ($search_forum) {
        $where_sql[] = ' (p.forum_id = ' . intval($search_forum) . ') ';
    }
    // Search Cat... nope... sorry :(
    $sql = 'SELECT a.*, t.post_id, p.post_time, p.topic_id
		FROM ' . ATTACHMENTS_TABLE . ' t, ' . ATTACHMENTS_DESC_TABLE . ' a, ' . POSTS_TABLE . ' p WHERE ';
    if (sizeof($where_sql) > 0) {
        $sql .= implode('AND', $where_sql) . ' AND ';
    }
    $sql .= 't.post_id = p.post_id AND a.attach_id = t.attach_id ';
    $total_rows_sql = $sql;
    $sql .= $order_by;
    if (!($result = $db->sql_query($sql))) {
        message_die(GENERAL_ERROR, 'Couldn\'t query attachments', '', __LINE__, __FILE__, $sql);
    }
    $attachments = $db->sql_fetchrowset($result);
    $num_attach = $db->sql_numrows($result);
    $db->sql_freeresult($result);
    if ($num_attach == 0) {
        message_die(GENERAL_MESSAGE, $lang['No_attach_search_match']);
    }
    if (!($result = $db->sql_query($total_rows_sql))) {
        message_die(GENERAL_ERROR, 'Could not query attachments', '', __LINE__, __FILE__, $sql);
    }
    $total_rows = $db->sql_numrows($result);
    $db->sql_freeresult($result);
    return $attachments;
}

开发者ID:BackupTheBerlios，项目名称:flushcms，代码行数:95，代码来源:functions_admin.php

示例17: message_die

         message_die(GENERAL_ERROR, "Could not obtain message details", "", __LINE__, __FILE__, $sql);
     }
     if (!($row = $db->sql_fetchrow($result))) {
         message_die(GENERAL_MESSAGE, $lang['No_such_post']);
     }
     $db->sql_freeresult($result);
     unset($row);
 }
 if ($submit) {
     // session id check
     if ($sid == '' || $sid != $userdata['session_id']) {
         $error = true;
         $error_msg .= (!empty($error_msg) ? '<br />' : '') . $lang['Session_invalid'];
     }
     if (!empty($_POST['username'])) {
         $to_username = phpbb_clean_username($_POST['username']);
         // Begin PNphpBB2 Module
         //			$sql = "SELECT user_id, user_notify_pm, user_email, user_lang, user_active
         //				FROM " . USERS_TABLE . "
         //				WHERE username = '" . str_replace("\'", "''", $to_username) . "'
         //					AND user_id <> " . ANONYMOUS;
         $sql = "SELECT user_id, user_notify_pm, user_email, user_lang, user_active \n\t\t\t\tFROM " . USERS_TABLE . "\n\t\t\t\tWHERE username = '" . DataUtil::formatForStore($to_username) . "'\n\t\t\t\t\tAND user_id <> " . ANONYMOUS;
         // End PNphpBB2 Module
         if (!($result = $db->sql_query($sql))) {
             $error = TRUE;
             $error_msg = $lang['No_such_user'];
         }
         if (!($to_userdata = $db->sql_fetchrow($result))) {
             $error = TRUE;
             $error_msg = $lang['No_such_user'];
         }

开发者ID:nmpetkov，项目名称:ZphpBB2，代码行数:31，代码来源:privmsg.php

示例18: intval

 include $phpbb_root_path . 'includes/bbcode.' . $phpEx;
 include $phpbb_root_path . 'includes/functions_post.' . $phpEx;
 if ($mode == 'editprofile') {
     $user_id = intval($HTTP_POST_VARS['user_id']);
     $current_email = trim(htmlspecialchars($HTTP_POST_VARS['current_email']));
 }
 $strip_var_list = array('email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'skype' => 'skype', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests', 'confirm_code' => 'confirm_code');
 // Strip all tags from data ... may p**s some people off, bah, strip_tags is
 // doing the job but can still break HTML output ... have no choice, have
 // to use htmlspecialchars ... be prepared to be moaned at.
 while (list($var, $param) = @each($strip_var_list)) {
     if (!empty($HTTP_POST_VARS[$param])) {
         ${$var} = str_replace("&amp;", "&", trim(htmlspecialchars($HTTP_POST_VARS[$param])));
     }
 }
 $username = !empty($HTTP_POST_VARS['username']) ? str_replace('&amp;', '&', phpbb_clean_username($HTTP_POST_VARS['username'])) : '';
 $trim_var_list = array('cur_password' => 'cur_password', 'new_password' => 'new_password', 'password_confirm' => 'password_confirm', 'signature' => 'signature');
 while (list($var, $param) = @each($trim_var_list)) {
     if (!empty($HTTP_POST_VARS[$param])) {
         ${$var} = trim($HTTP_POST_VARS[$param]);
     }
 }
 $signature = isset($signature) ? str_replace('<br />', "\n", $signature) : '';
 $signature_bbcode_uid = '';
 $allow_mass_pm = isset($HTTP_POST_VARS['allow_mass_pm']) ? intval($HTTP_POST_VARS['allow_mass_pm']) : 2;
 $gender = isset($HTTP_POST_VARS['gender']) ? intval($HTTP_POST_VARS['gender']) : 0;
 if (isset($HTTP_POST_VARS['birthday'])) {
     $birthday = intval($HTTP_POST_VARS['birthday']);
     if ($birthday != 999999) {
         $b_day = realdate('j', $birthday);
         $b_md = realdate('n', $birthday);

开发者ID:BackupTheBerlios，项目名称:flushcms，代码行数:31，代码来源:usercp_register.php

示例19: validate_username

function validate_username($username)
{
    global $db, $user, $lang;
    // Remove doubled up spaces
    $username = preg_replace('#\\s+#', ' ', trim($username));
    $username = phpbb_clean_username($username);
    $sql = get_users_sql($username, false, false, true, false);
    $db->sql_return_on_error(true);
    $result = $db->sql_query($sql);
    $db->sql_return_on_error(false);
    if ($result) {
        while ($row = $db->sql_fetchrow($result)) {
            if ($user->data['session_logged_in'] && $row['username'] != $user->data['username'] || !$user->data['session_logged_in']) {
                $db->sql_freeresult($result);
                return array('error' => true, 'error_msg' => $lang['Username_taken']);
            }
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT group_name\n\t\tFROM " . GROUPS_TABLE . "\n\t\tWHERE LOWER(group_name) = '" . $db->sql_escape(strtolower($username)) . "'";
    $db->sql_return_on_error(true);
    $result = $db->sql_query($sql);
    $db->sql_return_on_error(false);
    if ($result) {
        if ($row = $db->sql_fetchrow($result)) {
            $db->sql_freeresult($result);
            return array('error' => true, 'error_msg' => $lang['Username_taken']);
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT disallow_username\n\t\tFROM " . DISALLOW_TABLE;
    $db->sql_return_on_error(true);
    $result = $db->sql_query($sql);
    $db->sql_return_on_error(false);
    if ($result) {
        if ($row = $db->sql_fetchrow($result)) {
            do {
                if (preg_match("#\\b(" . str_replace("\\*", ".*?", preg_quote($row['disallow_username'], '#')) . ")\\b#i", $username)) {
                    $db->sql_freeresult($result);
                    return array('error' => true, 'error_msg' => $lang['Username_disallowed']);
                }
            } while ($row = $db->sql_fetchrow($result));
        }
    }
    $db->sql_freeresult($result);
    $sql = "SELECT word\n\t\tFROM " . WORDS_TABLE;
    $db->sql_return_on_error(true);
    $result = $db->sql_query($sql);
    $db->sql_return_on_error(false);
    if ($result) {
        if ($row = $db->sql_fetchrow($result)) {
            do {
                if (preg_match("#\\b(" . str_replace("\\*", ".*?", preg_quote($row['word'], '#')) . ")\\b#i", $username)) {
                    $db->sql_freeresult($result);
                    return array('error' => true, 'error_msg' => $lang['Username_disallowed']);
                }
            } while ($row = $db->sql_fetchrow($result));
        }
    }
    $db->

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP phpbb_email_hash函数代码示例发布时间：2022-05-15

PHP phpbb_clean_search_string函数代码示例发布时间：2022-05-15

solegalli/feature-selection-for-machine-

1 Delphi对Excel表格的各种操作

使用Excel最好用Comobj方式，它能够达到完全控制excel的目的。不过这种方式在Delphi中

阅读：530|2022-07-18

2 librespeed/speedtest: Self-hosted Speedt

librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam

阅读：1215|2022-08-30

3 CVE-2022-29892

Improper input validation vulnerability in Space of Cybozu Garoon 4.0.0 to 5.5.1

阅读：861|2022-07-08

4 avehtari/BDA_m_demos: Bayesian Data Anal

avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave

阅读：1124|2022-08-17

5 四维彩超怎么看性别？四维看男孩女孩诀窍

女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的

阅读：934|2022-11-06

6 medfreeman/markdown-it-toc-and-anchor: m

medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho

阅读：1331|2022-08-18

7 Delphi的字符及字符串[5]-字符串与WindowsA

WindowsAPI中的字符串对应这Delphi的PChar(PAnsiChar);在API中使用Delphi的字符串还是

阅读：537|2022-07-18

8 sydney0zq/covid-19-detection: The implem

sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor

阅读：483|2022-08-16

9 清明节的古诗词38首赏析

《寒食野望吟》唐白居易乌啼鹊噪昏乔木，清明寒食谁家哭。风吹旷野纸钱飞，古墓垒

阅读：547|2022-07-30

10 世界上哪个国家离中国最远？

离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾

阅读：632|2022-11-06

客服电话

电子邮件

PHP phpbb_clean_username函数代码示例

示例1: validate_username

示例2: get_userdata

示例3: get_userdata_notifications

示例4: message_die

示例5: implode

示例6: redirect

示例7: isset

示例8: die

示例9: intval

示例10: sizeof

示例11: append_sid

示例12: rss_get_user

示例13: get_users_sql

示例14: implode

示例15: message_die

示例16: search_attachments

示例17: message_die

示例18: intval

示例19: validate_username

请发表评论

全部评论

上一篇：

下一篇：

MikeMcQuaid/strap:

headcr4sh/node-maven: Maven for Node.js

CVE-2022-26527

traex/RippleEffect: Implementation of Ri

pravega/zookeeper-operator: Kubernetes O

solegalli/feature-selection-for-machine-

微信小程序获取滚动标签位置高度

barneygale/quarry: Python library that i

win7系统重装系统初始设置的操作方法

CVE-2022-1637

mne-tools/mne-matlab: MNE scripting with

关于我们

产品与服务

解决方案

139-2527-9053