virgil.rockford

Can this issue please be resolved?

We need to clean up a database for a client ASAP so we can move it to a development environment- all the bloat in the DB from the 49,000 spam entries has pushed the db file to over 200mb.

If at all possible PLEASE SEND mysql queries so we can clean this up, or at least fix so we can trash entries.

We are experiencing this issue as well. Flamingo has logged over 49000 spam entries for a client site we are managing. We are also experiencing the very slow form processing redirect as noted in another submission to this forum.

We need to remove the over 49,000 spam entries from Flamingo.

Please let us know how we can identify the information in the database for ALL Flamingo entries so we can clean up this mess.

I discovered the issue. The endpoint was for global gateway e4.
My client is using exact transactions payment pages.

It seems that both global gateway and exact transactions use the same api – so I simply modified the Global Gateway e4.php file to use exact transactions endpoints (https://checkout.e-xact.com/payment and https://rpm.demo.e-xact.com/payment) and this plugin works. You may want to add a bit of logic to your setup to use either Global Gateway or Exact Transactions in the settings configuration that generates the confirm.php to use either endpoint.

I know your doing this for free so no big deal to you, but it would be cool and I’ll keep this in my repository as we work with many different clients at my company.

Thanks for doing all the hard work on this plugin!

I wrote a quick solution using current available cf-7 hooks: basically adding special characters then deleting what’s in between those special characters. It works- it isn’t pretty, makes for rather busy email templates, but it works.

I added the following to functions.php:

<br />
add_filter( 'wpcf7_special_mail_tags', 'empty_field_characters',10,2);</p>
<p>function empty_field_characters( $output,$name ) {<br />
	$name=trim(ltrim($name,'_'));<br />
	if(empty($_POST[$name])){<br />
		$output='{}';<br />
	} else $output=' ';<br />
	return $output;</p>
<p>}</p>
<p>//filter to remove any p tags that contain the special characters for an empty field</p>
<p>add_filter( 'wpcf7_mail_components', 'remove_blank_lines' );</p>
<p>function remove_blank_lines( $mail ) {<br />
	if ( is_array( $mail ) && ! empty( $mail['body'] ) )<br />
		$mail['body'] = preg_replace('/<span\b[^>]*>{}(.*?){}<\/span>/i', '', $mail['body'] );<br />
	return $mail;<br />
}<br />

I then marked up the email template, each line as follows:

<br />
<p><span>[_address_destination]Street Address: [address_destination][_address_destination]</span></p><br />

In this fashion, if the field is empty, curly braces are inserted after and before the span tags. This is then removed by the preg_replace function.

As I said, not pretty, but it gets the job done!

Oh- one last thing. The client currently has the ability to accept PO’s for membership payments- I imagine they then update the billing status of the member manually. Is this something that could be done? They ask the member for a PO number when they sign up.

Thanks!

Thanks for such a quick reply! Basically the member directory will only be visible to members (at this point).

Wondering- is it possible to create a two label groups, and assign a member to both those groups- the member doing so during the sign-up process? The client also has their directory members grouped by region, so there would be two categories of label: business sector and region.

I want to give them a better experience for navigating the directory listings than what they have currently, so creating a navigation structure won’t be a big deal. I just want to make sure we can offer their current member organization structure. As well they currently have over 220 members, so some kind of pagination will be required. (or ajax loading would be cool too!).

You guys rock- thanks again for your reply.

Mark-

Quick question. Are the shortcodes the same in 4.01 as those on your docs page? They don’t seem to be resolving to any meaningful output, the page is just displaying the shortcode text (yes, it’s been entered in text mode).

Ex: [MSTW_GS_COUNTDOWN SCHED=2014-season INTRO=”PAC-12 KICKOFF IN:”]

Can bee seen here:
https://transit.bluehatmarketing.net/2014-schedule/

Thanks a ton for your help!

Never mind- didn’t realize you can’t duplicate the first form in the list.

Mark-

Thanks! One thing- I don’t see a link to the post you mentioned in your reply. Again, thanks for replying so quickly- it’s appreciated!