• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Save data to another Database

Save data to another Database 17 years 4 months ago #1435

Hi Alex

Great component.

I can access the Table jos_forme_data using OpenOffice Base, but for safety, would prefer RSform's data to be stored in a separate database to the one my site is in.

could this be done ?.
The administrator has disabled public write access.

Re:Save data to another Database 17 years 4 months ago #1442

  • alex
  • alex's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 443
  • Thank you received: 3
Hi John,

that is possible, but you have to customize the code of /components/com_forme/forme.php

find the code
$data_id = $row->id;

and change it to
$data_id = $row->id;
$query = \"INSERT INTO `#__my_new_table` VALUES ('$row->id', '$row->form_id', '$row->date_added', '$row->uip', '$row->uid', '$row->params','$row->lang');\"
$database->setQuery($query);
$database->query();
Of course, create a copy of your jos_forme_data with the same structure, to jos_my_new_table.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!