SQL

5 months 2 weeks 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.

5 months 2 weeks 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.

5 months 2 weeks 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.

5 months 2 weeks 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.

4 months 6 days ago #11 by Christopher Mavros
Replied by Christopher Mavros on topic SQL
Hi jcmdlv.
I just released an update that fixes this.
Thank you for your patience!

Christopher Mavros
mavrosxristoforos@gmail.com
If you like our extensions, please rate us on the JED!
The following user(s) said Thank You: jcmdlv

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

4 months 1 day ago #12 by jcmdlv
Replied by jcmdlv on topic SQL
Thanx Christopher,
It works very well

I ve got another question to the comunity.

I put name and surname of parents in my database with this :

INSERT INTO DTB_PARENTS_CHILDREN (NAME1,SURNAME1,NAME2,SURNAME2) VALUES ('<fieldid>10</fieldid>','<fieldid>11</fieldid>','<fieldid>20</fieldid>','<fieldid>21</fieldid>');

But if i want input more like name and surname of chidren with a Field Group Creator (4 posibility ) width ID = 150


INSERT INTO DTB_PARENTS_CHILDREN (NAME1,SURNAME1,NAME2,SURNAME2,NAMECHILD1,SURNAMECHILD1,NAMECHILD2,SURNAMECHILD2....) VALUES ('<fieldid>10</fieldid>','<fieldid>11</fieldid>','<fieldid>20</fieldid>','<fieldid>21</fieldid>',....????);

It's posible to make this ?

Thanks

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

Moderators: Christopher Mavros