How to change the users table

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
epuppet
New Member
New Member
Posts: 2
Joined: Sat Aug 18, 2012 2:26 am

How to change the users table

Post by epuppet »

I want to change the users table to accounts What files or folder of files will I need to change? I have google'd and searched in the forums.
cms ver: 1.11.1
PHP ver: 5.2.17
mysql ver: 5.1.63
Apache: Unknown
Linux Kernel: 2.6.32.36
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12709
Joined: Thu Mar 09, 2006 5:32 am
Location: Arizona

Re: How to change the users table

Post by Dr.CSS »

epuppet
New Member
New Member
Posts: 2
Joined: Sat Aug 18, 2012 2:26 am

Re: How to change the users table

Post by epuppet »

Read that first, and there really isn't any other way I know to explain what im trying to do.

I want to install cmsmadesimple and have it use a different table then the (prefix)_users.

For example have CMS use (prefix)_accounts instead.

Of course account and users would have the same structure & data just a different table
zigge
Forum Members
Forum Members
Posts: 75
Joined: Tue Jan 22, 2008 6:53 pm

Re: How to change the users table

Post by zigge »

epuppet wrote:
Read that first, and there really isn't any other way I know to explain what im trying to do.

I want to install cmsmadesimple and have it use a different table then the (prefix)_users.

For example have CMS use (prefix)_accounts instead.

Of course account and users would have the same structure & data just a different table
To do this you would mess with the core of CMSMS, and I really do not see why you would like to do that, since any future upgrade to the core would wreck your installation.

It would be interesting to know what you are trying to achieve or the reason for using a different name on the table. Are you trying to do something that a module could solve, like the Front End Users module?
spcherub
Power Poster
Power Poster
Posts: 402
Joined: Fri Jun 06, 2008 5:54 pm

Re: How to change the users table

Post by spcherub »

If you need to access the users table via some other system and the name "accounts" is hard coded there, why not create a view called [prefix]_accounts that points to the [prefix]_users table?
Locked

Return to “[locked] Installation, Setup and Upgrade”