I am fairly new to database and php, so I would be very grateful if you all could help me with the following. What I want is I want to integrate Joomla with another site on my subdomain. I have more than 2000 users on my site which is on the subdomain, so I would like all of them to be available in Joomla as well. So, can I make Joomla access that other site's user tables instead of its(joomla's) own and also people can sign up from either of the site, but the users have to stored on the existing site? Is it simple to do this in Joomla? or do I have to carry out alot of modifications in the Joomla code.
You might want to take a look at this: http://forum.joomla.org/index.php/topic,85406.new/topicseen.html#new I don't know if that's exactly what you are trying to do, and if not, you at least can look around the Joomla forums to see if you can find that exact answer to what you are trying to do. Good luck!
Yes it is a custom script. Lets look from a generic point of view. If there were two scripts which use two different user tables in different databases, can I later on modify one to stop reading it's default user tables, and make it pull of information(username, password) from the other script's database table? I just want the ONE authentication.
it is possible i think. Joomla has doing this with several standalone script like smf, phpbb. It's called a bridge. Maybe you should take alook at these bridge and learn how to do it http://www.joomlahacks.com/component/option,com_remository/Itemid,41/func,select/id,13/ ---->>> smf bridge http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,744/Itemid,35/ --->>> phpbb bridge