***UPDATED*** DB Technosystems Form Processor 02/09/2011

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.
There is a dedicated section for commercial extensions.
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by zinc »

George what is the latest version of this extension? Does it support 11?
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

Last version: 2.7.5.7
Yes, works fine with v.11
www.dbtechnosystems.com
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by zinc »

Thanks George, also will it work with Recaptcha V2?

http://www.wysiwygwebbuilder.com/recaptchav2.html
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

It should work with the standard WWb Recaptcha 2 but I have not tried it.
www.dbtechnosystems.com
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by zinc »

Cheers will give it a try. Are you going to recompile this extension with the latest EXT Builder as recommend by Pablo?
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

When / if a new version comes out.
www.dbtechnosystems.com
User avatar
zinc
 
 
Posts: 2146
Joined: Sat Dec 08, 2007 3:06 pm
Location: London, United Kingdom
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by zinc »

Navaldesign wrote:When / if a new version comes out.
viewtopic.php?f=1&t=72086
Running WYSIWYG Web Builder since 2007...
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

Your settings seem correct, however the error message should NOT be an URL but a simple text message.
Edit, publish again, refresh your browser and test.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

Please remove the code you have added, it is not needed, then publish and try again.
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Patrik iden »

Hello, Do the Form Processor work with PHP version 5 and 7?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

As far as I know (haven't tested) it does.
www.dbtechnosystems.com
derold
 
 
Posts: 51
Joined: Tue Feb 28, 2012 10:49 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by derold »

WB12.1.1
Is there a way to number the emails Like a reference number.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

It will require some custom coding.

You may have a look at how this is done in the Webshop Plus and apply the same through the "Custom coding" properties of the processor. Some PHP knowledge is required.
www.dbtechnosystems.com
derold
 
 
Posts: 51
Joined: Tue Feb 28, 2012 10:49 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by derold »

WB12.1.1

OK I am looking at it.
derold
 
 
Posts: 51
Joined: Tue Feb 28, 2012 10:49 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by derold »

If I add this to the value of an edit box <?php echo mt_rand(100000, 999999);?> I get a random number. but I am working on doing better then this.
like in sequence.
And is there a way to move the edit box from the bottom to the top. I changed the tab order and moved it to the top. but in the email it still shows at the bottom.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

To get sequence numbers, you need to keep track of each email number.
You can do this by storing and retrieving the last number from a database or file stored on the server.
This is what Webshop Plus does (stores the last order number on the server, and then retrieves it when a new order is made).
If you look at how this is done in Webshop Plus, you can apply exactly the same solution.
It will be enough using a hidden field (instead of an editbox) to "echo" the number and receive it with the mail details.
www.dbtechnosystems.com
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by protectourlands »

Hi George

Where can we download the latest version of this extension?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

The version available through the Extension Manager is the latest one.
www.dbtechnosystems.com
User avatar
protectourlands
 
 
Posts: 443
Joined: Sat May 24, 2008 2:16 am
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by protectourlands »

Perfect! Thank you. This is a great extension.
derold
 
 
Posts: 51
Joined: Tue Feb 28, 2012 10:49 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by derold »

wb12

Quick Question when I add form processor to a page that has layout grid using the form option it sends the form but no information.
if I add it to a page with just a regular form it works fine.
Image
derold
 
 
Posts: 51
Joined: Tue Feb 28, 2012 10:49 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by derold »

wb12

Ok I got it working but I don't no what was wrong.
lummis
 
 
Posts: 211
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by lummis »

George, I tried to update the Form Processor extension (mine was still at 2.6.0) but the update failed. I then removed the extension to try a clean install but the downloaded failed again. I am not sure if it has any significance but the latest version according to the Extension Manager is 2.7.5.7 whilst your Change Log says the latest is 2.7.5.6

Brian

EDIT - Having closed WB12 and then reopened, the updated file has been loaded. It must have been a glitch in the system.
lummis
 
 
Posts: 211
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by lummis »

Unfortunately the updated extension has not solved my initial problem as hoped. My host has just upgraded it's servers to PHP7 and this appears to have caused the DBTS Form Processor to fail. I have tried both PHP5 and PHP7 in the Page Properties without success.

Having enabled the debugger I have received the following:

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php:208 Stack trace: #0 /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php(154): db_connect() #1 /home/********/public_html/********.org.uk/dbts_includes/dbts_formprocessor.php(247): WriteToMySQL('********...', 'localhost', '********', '********', 'clothing', Array, Array, 'Yes', 'Yes') #2 /home/********/public_html/********.org.uk/clothing_order_form.php(233): include('/home/********/...') #3 {main} thrown in /home/********/public_html/********.org.uk/dbts_includes/dbts_functions.php on line 208

I have a very basic knowledge of PHP/MySQL but I am wondering whether the problem lies with the mysql_connect function in the includes_dbtsfunctions folder - should this be mysqli_connect with PHP7?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

Obviously your server has switched to mysqli.
However it is not that simle, as all functions have to be updated for mysqli.
www.dbtechnosystems.com
lummis
 
 
Posts: 211
Joined: Sun Apr 24, 2011 9:18 am
Location: UK

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by lummis »

That's what I thought, George. It looks as though I will have to change to the built in Form Processor although I am having some problems setting that up - hopefully Pablo will come to my rescue if needed. Many thanks.

Brian
tdr
 
 
Posts: 28
Joined: Sat Sep 26, 2009 10:14 am

Recaptcha V2 with DBTS

Post by tdr »

Has anybody been able to integrate Pablo's reCAPTCHA v2 extension with DBTS form processor?

I use both DBTS form processor and DBTS preview, and I really would like to avoid having to rebuild it from scratch as it is not a short form. But with reCAPTCHA v1 now deprecated, I really need to remove DBTS reCAPTCHA and would rather not. Yes, I could do some kind of different "are you human" test, but if anybody has been able to integrate the v2 extension with DBTS I would be keen to hear how you did it!

Thanks
Last edited by tdr on Sat Apr 07, 2018 9:01 pm, edited 1 time in total.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Navaldesign »

I have not tried it but, knowing how the script structure is, I think there should be no issues. It will simply work independently from the DBTS Form Processor.
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Patrik iden »

Hi, i just put it in the form, and in DBTS settings i have this for E.Captcha:

WWW Captcha rewrite = No
Recaptcha Force Verification = No
Recaptcha private key = Empty
Use reverse captcha = No
tdr
 
 
Posts: 28
Joined: Sat Sep 26, 2009 10:14 am

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by tdr »

Thanks Patrik! I've tried this and now have some minor issues where if the person clicks submit button before passing the reCAPTCHA challenge, the error handling is lost. With DBTS form processor I could control most of this. I'm thinking if I could disable the submit button and then enable it when successfully passed the robot test. I've seen some scripting examples online which might help, but I can't figure out how to insert the data-callback example as per below. Any ideas would be much appreciated as I'm a novice on the scripting side.
<form>
<div class="g-recaptcha" data-sitekey="YOUR_PRIVATE_KEY" data-callback="recaptchaCallback"></div>
<button type="submit" class="btn btn-default hidden" id="btnSubmit">Submit</button>
</form>

<script>
function recaptchaCallback() {
var btnSubmit = document.getElementById("btnSubmit");

if ( btnSubmit.classList.contains("hidden") ) {
btnSubmit.classList.remove("hidden");
btnSubmitclassList.add("show");
}
}
</script>
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by Patrik iden »

Well, i just set a error page in the Recaptcha settings.
I also have the same error page set in the DBTS error page settings.
grundman
 
 
Posts: 22
Joined: Mon May 14, 2018 11:09 am

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by grundman »

My host service has updated PHP to version 7 and DBTS Form Processor do not work with my database. Is there a solution for this matter or a new version available?. The latest one I have is 2.7.5.x (according to the documentation)-
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: ***UPDATED*** DB Technosystems Form Processor 02/09/2011

Post by WWBman »

This probably won't help but have you set the PHP version in Page Properties > Advanced to PHP5-PHP7?

EDIT: I've just seen some posts about this issue (on previous page to this!) and it looks like the extension doesn't work for PHP7.
It's regarding the MySQLi new formats.
Post Reply