首页 > 其他 > 网站日记>正文

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

提示: 阅读权限:公开  

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

售价:100元

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

第一行为字段名称,比如

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="rn";//每条记录分隔符,默认为回车

$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] => 

)


上一篇:【帝国cms插件】之随机指定信息发布者

下一篇:【帝国cms插件】简繁体转换

tags: 插件 帝国cms 批量 帝国

返回首页

相关

热门

站内直通车

[!--temp.bottomnav--]
返回顶部