where is the “change user password" source code in Discuz code. Please help me

[marcuszmy]

I am currently having this problem:

I have two websites, one is the main website with SQL Server database and the other one is the Discuz forum with MySQL database. Basically these two websites share the same user information. However, the mysql database only receive users’ information when they are registering new user on the main website. So if I change the password on the main website, the password for the Discuz will not change at the same time.

Now, I am thinking to write an API for change the password in mysql when the main website receive the new password from users. However, I could not find any information from the Discuz source code (such as the function to change user’s password).

Can anyone help me? Thanks a lot!

[Topcoder]

In theory, you can create a link from MSSQL to MYSql with these instructions…

https://www.packtpub.com/books/content/mysql-linked-server-sql-server-2008

Then in MSSQL you can add a trigger on the user table that anytime the password is changed to update it in the mysql table through that database link.

But the reverse is impossible, because mysql doesn’t support linking to mssql.