Multiple database update on article submit.
Posted on 2010-04-01
Hello everybody, am a programmer since 14 years in windows technology and I've used PHP a bit but am far from being an expert in PHP. Anyhow this to say that here's what I want to do:
I have 16 sites on subdomains that are running ( at this moment ) an exact copy of each others. So same site on 16 different subdomains all running on they're own separate database. On one of this subdomain, from the FRONT END we could log in and edit the articles ( cannot add just edit them ). Now what I want to do is add under the METADATA section another section that would list the 15 other websites with a check box beside. Once the article edited the user will checkmark the sites that he/she wants to have this article publish to also. So basically if I checkmark the 15 website well when I will hit the save button I want to insert this articles in the 15 other database as well.
Pretty simple in theory but I have no clue on how to do it in Joomla cause am all confused with the extensions.. modules.. plugins.. and so on..
Can you help me out on pointing me on how I need to do it ( not code it for me ) but really the structure of what I have to do.. Currently I have manage to add the form under the METADATA section that list the websites with the checkbox.. I have edited the file in : \templates\templateName\html\com_content\article\form.php -- Maybe this is not even the good way to go?
Anyhow, this is why I am asking for some help.