[ Moderated, that was a misleading topic title.
To give some background, our current website is in the financial sector. Essentially, we track trading statistics for each of our users. We do this by referring traders to brokers which we are partnered with - this is how we gain access to their trading data and also how we make money. Unfortunately, I can't share the site now as it's undergoing reno.
The webiste is written from scratch in PHP leveraging a lot of MySQL tables. Luckily, I used a lot of the WordPress-style theme files in writing my own PHP code (header, footer, sidebar, etc.), so most of the structural conversion should be pretty straight forward. I'll also move the content into Posts with lots of custom fields (will probably use custom post types). Don't see any huge issues here.
There are 2 areas that I have questions about:
1) Conversion of users in WP users - We have our users stored in a MySQL table. Their login credentials are checked against this table, and once they're logged in they can see all their own trading data. How would I go about converting them to WP users?
2) Our custom trading data tool (which displays to each of our users) has a customized php-built front end, and retrieves data from 6-7 MySQL tables. The php front-end I think can be put into a plug-in (not too sure?). As for the MySQL tables - do I just manually recreate them under the default database created by WordPress, and import all the data over?
Just looking for a little direction, guidance, best practice, anything regarding the 2 question areas above.
Thanks so much for your help!