SQL

3 weeks 20 hours ago #7 by Christopher Mavros
Replied by Christopher Mavros on topic SQL
I understand what you mean now. It gets filtered by Joomla.
Please also change file administrator/components/com_rapidcontactex/config.xml and edit line 87:
Change from:
<field name="custom_sql" type="textarea" default="" ...
to:
<field name="custom_sql" type="textarea" filter="raw" default="" ...

This should fix it.
Please confirm.

Christopher Mavros
mavrosxristoforos@gmail.com
If you like our extensions, please rate us on the JED!

Please Log in or Create an account to join the conversation.

3 weeks 17 hours ago #8 by jcmdlv
Replied by jcmdlv on topic SQL
The form send my data in the database and send mail.

But this data is empty (Null) in the database.

->
I think you must fix the lib.php in line 1000

          $query = str_replace('<fieldid>'.$myFieldId.'</fieldid>', $db->escape($input->get($form_id."rpx_".getFieldName($mField->name), '', 'raw')), $query);

In the form, the name and id of my <input> textbox is <input id="rpx_2rpx_ Prenom" name="rpx_2rpx_ Prenom" ....>

If i put this, in the line 1000 :
          $query = str_replace('<fieldid>'.$myFieldId.'</fieldid>', $db->escape($input->get($form_id."rpx_2rpx_ ".getFieldName($mField->name), '', 'raw')), $query);

It's ok the form send the good data in the database

JC


 

Please Log in or Create an account to join the conversation.

3 weeks 11 hours ago #9 by Christopher Mavros
Replied by Christopher Mavros on topic SQL
Thanks for all the debugging!
It seems this function hasn't been used in a while, so it has grown out of sync with the rest of the component.
If you have fixed it on your system for now, please keep it that way and I will make sure to include a proper fix in the next version.
Unless you have more than one forms and need it to automatically obtain the unique form ID.
Let me know.

Christopher Mavros
mavrosxristoforos@gmail.com
If you like our extensions, please rate us on the JED!

Please Log in or Create an account to join the conversation.

3 weeks 39 minutes ago #10 by jcmdlv
Replied by jcmdlv on topic SQL
Good morning,
I actually have several forms, but I can wait.
THANKS

Please Log in or Create an account to join the conversation.

Moderators: Christopher Mavros