修改discuz用户名字段长度限制

change_discuz_username_length.php

<?php
//Discuz X 2.0版本

$dbhost = 'localhost';
$dbuser = '';
$dbpass = '';
$dbname = '';
$prefix = 'pre_';
$length = 30;

$link = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

if (!mysql_select_db($dbname, $link)){
    die('error: ' . mysql_error());
};

$fields = array(
    array('common_adminnote', 'admin', 'varchar'),
    array('common_banned', 'admin', 'varchar'),
    array('common_card_log', 'username', 'varchar'),
    array('common_diy_data', 'username', 'varchar'),
    array('common_failedlogin', 'username', 'char'),
    array('common_grouppm', 'author', 'varchar'),
    array('common_invite', 'fusername', 'varchar'),
    array('common_member', 'username', 'char'),
    array('common_member_validate', 'admin', 'varchar'),
    array('common_member_verify_info', 'username', 'varchar'),
    array('common_mytask', 'username', 'char'),
    array('common_report', 'username', 'varchar'),
    array('common_report', 'opname', 'varchar'),
    array('common_session', 'username', 'char'),
    array('common_word', 'admin', 'varchar'),
    array('forum_announcement', 'author', 'char'),
    array('forum_creditslog', 'fromto', 'char'),
    array('forum_forumrecommend', 'author', 'char'),
    array('forum_groupuser', 'username', 'char'),
    array('forum_order', 'admin', 'varchar'),
    array('forum_pollvoter', 'username', 'char'),
    array('forum_promotion', 'username', 'char'),
    array('forum_post', 'author', 'varchar'),
    array('forum_postcomment', 'author', 'varchar'),
    array('forum_ratelog', 'username', 'char'),
    array('forum_rsscache', 'author', 'varchar'),
    array('forum_thread', 'author', 'char'),
    array('forum_thread', 'lastposter', 'char'),
    array('forum_threadmod', 'username', 'char'),
    array('forum_trade', 'seller', 'char'),
    array('forum_trade', 'lastbuyer', 'char'),
    array('forum_tradecomment', 'rater', 'char'),
    array('forum_tradecomment', 'ratee', 'char'),
    array('forum_tradelog', 'seller', 'varchar'),
    array('forum_tradelog', 'buyer', 'varchar'),
    array('forum_warning', 'operator', 'char'),
    array('forum_warning', 'author', 'char'),
    array('home_album', 'username', 'varchar'),
    array('home_blog', 'username', 'varchar'),
    array('home_clickuser', 'username', 'varchar'),
    array('home_comment', 'author', 'varchar'),
    array('home_docomment', 'username', 'varchar'),
    array('home_doing', 'username', 'varchar'),
    array('home_feed', 'username', 'varchar'),
    array('home_feed_app', 'username', 'varchar'),
    array('home_friend', 'fusername', 'varchar'),
    array('home_friend_request', 'fusername', 'char'),
    array('home_notification', 'author', 'varchar'),
    array('home_pic', 'username', 'varchar'),
    array('home_poke', 'fromusername', 'varchar'),
    array('home_share', 'username', 'varchar'),
    array('home_show', 'username', 'varchar'),
    array('home_specialuser', 'username', 'varchar'),
    array('home_specialuser', 'opusername', 'varchar'),
    array('home_visitor', 'vusername', 'varchar'),
    array('portal_rsscache', 'author', 'varchar'),
    array('portal_topic_pic', 'username', 'varchar'),
);


foreach($fields as $field){
    list($table, $column, $type) = $field;
    echo "updating $prefix$table\n";
    if(!mysql_query("ALTER TABLE  `$prefix$table` CHANGE  `$column`  `$column` $type( {$length} ) NOT NULL DEFAULT  '' ", $link)){
        die("error: $table" . mysql_error());
    }
}

echo "done\n";
mysql_close($link);