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