程序名称:会员数据从文本文件导入帝国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] =>
)