MySQLI & File locations (Users & Mail tables)

[boionfire81]

Version of script: 2.7.5
Hosting company: GoDaddy
URL of phpinfo.php: (n/a)
URL of session_test.php: (?)
What terms did you try when SEARCHING for a solution:
Looked at threads, read faq at hesk.

Write your message below:
In order to do a database integration I will need to modify 2 things. The users table and the mail table. Mail table I need to rename 5 of the 7 column names. And about 5 of the users table will need renamed.

What files hold these so I can rename them within the files?

[Klemen]

A lot of files use columns from those tables; you will need to verify, search and replace each file manually, there is no list.

[TechCoder]

boionfire81,

Not sure what sort of 'database integration' you are looking to do, but from a lot of experience in doing integration from one program (with its existing data) to another, I can tell you that it is ALWAYS simpler (better) to 'translate' the old data to the new software - writing a small program to read the existing data and put it where it needs to be in the new table is a 1-time thing, while making mods as you suggest is a LOT of work up front, plus all the work you will have to do every time you upgrade the software every time there is another feature/bug fix you need.

If you need other 'integration' - perhaps on a more full-time basis (like tying the two program together for ongoing functions), then still the 'translator' program is better to have. It can run from a cron job or something to keep things in sync.......

It all depends on what you want to do, really - but renaming columns in the database and hacking all the associated files....... NOT what I would call a 'plan for success'!

[Klemen]

That's good advise.

If you do end up modifying the files/structure, I would definitely use some sort of versioning software (git, subversion...) to track all the changes so you can easily apply them to future updates.