SQL
- Christopher Mavros
-
- Offline
- Administrator
-
2 years 3 months ago #7
by Christopher Mavros
Christopher Mavros
me@mavxr.com
If you like our extensions, please rate us on the JED!
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:
to:
This should fix it.
Please confirm.
Please also change file administrator/components/com_rapidcontactex/config.xml and edit line 87:
Change from:
Code:
<field name="custom_sql" type="textarea" default="" ...
Code:
<field name="custom_sql" type="textarea" filter="raw" default="" ...
This should fix it.
Please confirm.
Christopher Mavros
me@mavxr.com
If you like our extensions, please rate us on the JED!
Please Log in or Create an account to join the conversation.
- jcmdlv
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
2 years 3 months 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
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.
- Christopher Mavros
-
- Offline
- Administrator
-
2 years 3 months ago #9
by Christopher Mavros
Christopher Mavros
me@mavxr.com
If you like our extensions, please rate us on the JED!
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.
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
me@mavxr.com
If you like our extensions, please rate us on the JED!
Please Log in or Create an account to join the conversation.
- jcmdlv
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
2 years 3 months ago #10
by jcmdlv
Replied by jcmdlv on topic SQL
Good morning,
I actually have several forms, but I can wait.
THANKS
I actually have several forms, but I can wait.
THANKS
Please Log in or Create an account to join the conversation.
- Christopher Mavros
-
- Offline
- Administrator
-
2 years 2 months ago #11
by Christopher Mavros
Christopher Mavros
me@mavxr.com
If you like our extensions, please rate us on the JED!
Replied by Christopher Mavros on topic SQL
Hi jcmdlv.
I just released an update that fixes this.
Thank you for your patience!
I just released an update that fixes this.
Thank you for your patience!
Christopher Mavros
me@mavxr.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.
- jcmdlv
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 7
- Thank you received: 0
2 years 2 months 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
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