Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "how to import phpcms v9 members through the database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

There is an old system user needs to import into the new system, the new system uses the phpcms v9 secondary development system, needs to import the old system user to the new system, the network has the use import module thing but the use effect is not good, all uses the method which operates directly in the database.

1. Determine the two tables that will be used to add phpcms v9: v9_member v9_sso_members (this is related to whether or not to install sso)

two。 User password encryption rules: MD5 (MD5 (password) + random number) means that the password entered using MD5 encryption is added to the system-generated random number (v9_member table encrypt column).

3. The phpssouid of v9_member is the same as that of v9_sso_members.

4. The new user id in the system is self-increasing.

Understand the above rules and get started:

INSERT INTO `phpcmsv9`.`v9 _ member` (`userid`, `phpssouid`, `username`, `password`, `mobilt`, `nickname`, `regdate`, `lastdate`, `regip`, `lastip`, `loginnum`, `email`, `groupid`, `areaid`, `Sount`, `point`, `modelid`, `message`, `islock`, `vip`, `overduedate`, `siteid`, `connectid`, `from`, `mobile`) VALUES ('10000001password,' 10000001password, 'username', MD5 (MD5 (password 'here is plaintext password', random number), random number, xxxx', '1564468777,' 15644849`) '172.16.1.1,' 172.16.1.1, '0levels,' 11levels qq.compositions, '2levels,' 0cycles, '0.005 miles,' 1grams, '10cycles,' 0cycles, '0cycles,' 0cycles, '1cycles,')

INSERT INTO `phpcmsv9`.`v9 _ sso_ members` (`uid`, `username`, `password`, `regdate`, `email`, `regip`, `regdate`, `lastip`, `lastdate`, `appname`, `type`, `avatar`, `ucuserid`) VALUES ('10000001password,' user name', MD5 (MD5 ('here is plaintext password'), 'random number'), 'random number', 11roomqq.compositions, '172.16.1.1numbers,' 1564468773numbers, '127.0.0.1cards,' 1564470571numbers, 'phpcmsv9', 'app'') '0#,' 0')

The id here uses a relatively large one, and the system can not be used by itself.

Follow-up additions, in the follow-up operations in accordance with this method are the problems and solutions:

I use to import the columns that need to be inserted into excle and then add the sql statement before and after to assemble the sql statement.

Question 1. Using navicat to run sql files, no matter what kind of encoding is used, will cause the Chinese to become? The situation of No. Finally, paste the sql statement directly into the console to run the method, import correctly.

Question 2. The account name or password of the original system that begins with 0 is removed by default when entering the excle. Concatenate fixed strings in front of these when exporting from the original database, generate sql and then replace them.

When concatenating sql in question 3.excle, the beginning cannot be 'otherwise it starts with 0. You can't avoid using a method similar to question 2, adding a fixed string at the beginning of the splicing.

Modify password length limit

Modify login is_password

Phpcms/libs/functions/global.func.php

The two numbers 1 to 20 determined by if are the range of password strings.

This is the end of the introduction of "phpcms v9 how to import members through the database". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.