• 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: SQL Mappings for Created by Date etc

SQL Mappings for Created by Date etc 11 years 11 months ago #23777

Can anyone help me with the syntax that is needed for the SQL mappings so that the Author and date are filled in with the details of the user that created the submission. Or is it easier to set it as a hidden attribute in the form itself?

More information can be provided if needed. I just can't find many details on the SQL Mapping feature.

Many thanks
The administrator has disabled public write access.

SQL Mappings for Created by Date etc 11 years 11 months ago #23824

For anyone else who is searching, to get the User ID to show up complete the following:
Create a new hidden field in the Default value enter the code below

//<code>
$user = JFactory::getUser();
return $user->get('id');
//</code>

Save and go to SQL Mappings and input in
"created_by (int unsigned) {name here}"
substitute name here for the name of the hidden field!
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!