石鑫华视觉论坛微信公众号:石鑫华视觉

 找回密码
 注册会员
查看: 1321|回复: 0

[站务] 用户栏目个人资料只真实姓名的异常处理

[复制链接]
  • TA的每日心情
    慵懒
    14 小时前
  • 签到天数: 3156 天

    连续签到: 26 天

    [LV.Master]2000FPS

    发表于 2021-1-2 01:19:58 | 显示全部楼层 |阅读模式 来自:广东省东莞市 联通

    注册登陆后可查看附件和大图,以及购买相关内容

    您需要 登录 才可以下载或查看,没有账号?注册会员

    x
    打开数据库,发现在pre_common_member_profile_setting表中,只有真实姓名、出生地、出生县等少量几行。可以将这些数据全部删除。然后打开discuz的全新安装包,查找到\upload\install\data\install_data.sql数据库文件,鼠标右键编辑(文件比较小,可以直接使用txt来编辑),然后查找pre_common_member_profile_setting关键字,可以得到以下内容:

    INSERT INTO pre_common_member_profile_setting VALUES('realname', 1, 0, 0, '真实姓名', '', 0, 0, 0, 0, 0, 0, 1, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('gender', 1, 0, 0, '性别', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthyear', 1, 0, 0, '出生年份', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthmonth', 1, 0, 0, '出生月份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthday', 1, 0, 0, '生日', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('constellation', 1, 1, 0, '星座', '星座(根据生日自动计算)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('zodiac', 1, 1, 0, '生肖', '生肖(根据生日自动计算)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('telephone', 1, 1, 0, '固定电话', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('mobile', 1, 1, 0, '手机', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('idcardtype', 1, 1, 0, '证件类型', '身份证 护照 驾驶证等', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '身份证\n护照\n驾驶证', '');
    INSERT INTO pre_common_member_profile_setting VALUES('idcard', 1, 1, 0, '证件号', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('address', 1, 1, 0, '邮寄地址', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('zipcode', 1, 1, 0, '邮编', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('nationality', 0, 0, 0, '国籍', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthprovince', 1, 0, 0, '出生省份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthcity', 1, 0, 0, '出生地', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthdist', 1, 0, 0, '出生县', '出生行政区/县', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('birthcommunity', 1, 0, 0, '出生小区', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('resideprovince', 1, 0, 0, '居住省份', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('residecity', 1, 0, 0, '居住地', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('residedist', 1, 0, 0, '居住县', '居住行政区/县', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('residecommunity', 1, 0, 0, '居住小区', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('residesuite', 0, 0, 0, '房间', '小区、写字楼门牌号', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('graduateschool', 1, 0, 0, '毕业学校', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('education', 1, 0, 0, '学历', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '博士\n硕士\n本科\n专科\n中学\n小学\n其它', '');
    INSERT INTO pre_common_member_profile_setting VALUES('company', 1, 0, 0, '公司', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('occupation', 1, 0, 0, '职业', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('position', 1, 0, 0, '职位', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('revenue', 1, 1, 0, '年收入', '单位 元', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('affectivestatus', 1, 1, 0, '情感状态', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('lookingfor', 1, 0, 0, '交友目的', '希望在网站找到什么样的朋友', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('bloodtype', 1, 1, 0, '血型', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, 'A\nB\nAB\nO\n其它', '');
    INSERT INTO pre_common_member_profile_setting VALUES('height', 0, 1, 0, '身高', '单位 cm', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('weight', 0, 1, 0, '体重', '单位 kg', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('alipay', 1, 1, 0, '支付宝', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('icq', 0, 1, 0, 'ICQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('qq', 1, 1, 0, 'QQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('yahoo', 0, 1, 0, 'YAHOO帐号', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('msn', 1, 1, 0, 'MSN', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('taobao', 1, 1, 0, '阿里旺旺', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('site', 1, 0, 0, '个人主页', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('bio', 1, 1, 0, '自我介绍', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('interest', 1, 0, 0, '兴趣爱好', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field1', 0, 1, 0, '自定义字段1', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field2', 0, 1, 0, '自定义字段2', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field3', 0, 1, 0, '自定义字段3', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field4', 0, 1, 0, '自定义字段4', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field5', 0, 1, 0, '自定义字段5', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field6', 0, 1, 0, '自定义字段6', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field7', 0, 1, 0, '自定义字段7', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
    INSERT INTO pre_common_member_profile_setting VALUES('field8', 0, 1, 0, '自定义字段8', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');



    将这些内容复制到php执行语句或者是Discuz的数据库升级中,将新的用户栏目插入到上面的表中即可出现完整的用户栏目。
    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 注册会员

    本版积分规则

    LabVIEW HALCON图像处理入门教程(第二版)
    石鑫华机器视觉与LabVIEW Vision图像处理PDF+视频教程11种全套
    《LabVIEW Vision函数实例详解》教程-NI Vision所有函数使用方法介绍,基于NI VISION2020,兼容VDM21/22/23
    LabVIEW图像处理教程
    机器视觉商城淘宝店铺
    视觉论坛充值赞助方法

    QQ|石鑫华视觉论坛 |网站地图

    GMT+8, 2024-3-29 21:47

    Powered by Discuz! X3.4

    © 2001-2024 Discuz! Team.

    快速回复 返回顶部 返回列表