加入收藏 | 设为首页 | 我要投稿 | RSS中药方rss
中药方大全小图标
您当前的位置:首页 > 其他 > 网站日记

【帝国cms插件】批量添加会员

提示: 手机抄药方--选中文字可生成二维码  来源:远程  作者:海蓝

程序名称:会员数据从文本文件导入帝国CMS的插件使用说明

修改: jiuhecai

××××× 导入的文件格式说明 ×××××

第一行为字段名称,比如

username,password,email,registertime

(其中用户名跟密码字段是必须的,其他字段不论在主表副表都可以)

其余行为数据行,与第一行对应

---------------------------------------------

用户名[分隔符]密码[分隔符]字段名1[分隔符]字段名2...

---------------------------------------------


举例:如下面第二行起每行为一个记录,字段之间用逗号隔开。

---------------------------------------------

username,password,email,registertime

用户名1,密码1,邮箱1,注册时间1

用户名2,密码2,邮箱2,注册时间2

---------------------------------------------


××××××××××× 导入步骤 ×××××××


1、先配置导入参数,打开“index.php”文件,配置以下参数:

---------------------------------------------


$file="user.txt";//导入的文件

$rexp="\r\n";//每条记录分隔符,默认为回车

$fexp=",";//字段之间分隔符,默认为逗号


---------------------------------------------

修改后保存文件。

2、将“index.php”跟要导入的文件同时上传到帝国e/extend/memberImport下目录;

3、后天登录后添加菜单  会员导入 /e/extend/memberImport  金刚模式;

4、点击添加的菜单

5、导入完毕。可以删除e/extend/memberImport目录,也可以留着。因为需要后台登录才能导入,所以安全的。


附: phome_enewsmember会员主表数据结构

Array

(

    [Field] => userid

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => PRI

    [Default] => 

    [Extra] => auto_increment

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => username

    [Type] => char(20)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => UNI

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => password

    [Type] => char(32)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => rnd

    [Type] => char(20)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => email

    [Type] => char(50)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => registertime

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => groupid

    [Type] => smallint(5) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => MUL

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => userfen

    [Type] => mediumint(8) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => userdate

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => money

    [Type] => float(11,2)

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0.00

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => zgroupid

    [Type] => smallint(5) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => havemsg

    [Type] => tinyint(1)

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => checked

    [Type] => tinyint(1)

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => salt

    [Type] => char(8)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => userkey

    [Type] => char(12)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)



会员附表phome_enewsmember数据结构:


Array

(

    [Field] => userid

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => PRI

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => truename

    [Type] => varchar(20)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => oicq

    [Type] => varchar(25)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => msn

    [Type] => varchar(120)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => mycall

    [Type] => varchar(30)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => phone

    [Type] => varchar(30)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => address

    [Type] => varchar(255)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => zip

    [Type] => varchar(8)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => spacestyleid

    [Type] => smallint(6)

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => homepage

    [Type] => varchar(200)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => saytext

    [Type] => text

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => company

    [Type] => varchar(255)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => fax

    [Type] => varchar(30)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => userpic

    [Type] => varchar(200)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => spacename

    [Type] => varchar(255)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => spacegg

    [Type] => text

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => viewstats

    [Type] => int(11)

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => regip

    [Type] => varchar(20)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => lasttime

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => lastip

    [Type] => varchar(20)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => loginnum

    [Type] => int(10) unsigned

    [Collation] => 

    [Null] => NO

    [Key] => 

    [Default] => 0

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => regipport

    [Type] => varchar(6)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)

Array

(

    [Field] => lastipport

    [Type] => varchar(6)

    [Collation] => utf8_general_ci

    [Null] => NO

    [Key] => 

    [Default] => 

    [Extra] => 

    [Privileges] => select,insert,update,references

    [Comment] => 

)


tags: 插件 返回顶部
验证码
  • 评论
0条评论
  • 最新评论
推荐资讯
视频:田纪钧讲关节不痛的秘密、膝关节拉筋法
视频:田纪钧讲关节不
白露到了,你还好吗?
白露到了,你还好吗?
尿疗与断食
尿疗与断食
给风疹反复发作女孩的药方(组图)
给风疹反复发作女孩的
相关文章
栏目更新
栏目热门
  1. 帝国cms7.2后台信息列表页批量添加tags
  2. 帝国cms之批量替换字段值
  3. 帝国cms7.2改用百度编辑器
  4. 如何禁止内容关键字替换ALT和A标签中的关键
  5. 帝国cms百度主动推送插件支持分页推送
  6. 显示二维码
  7. 帝国cms插件大全
  8. 帝国cms获取当前页的地址
  9. 【帝国cms插件】之三级联动+伪静态
  10. 帝国cms之egetzy函数