Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Visual Verify Code (VVC)


sargenle

Recommended Posts

Lee, I have it on my site in Contact Us and Accounts....however you can't see it as I have disabled it temporarily. I don't use it in tell-a-friend but I am guessing the implementation would be similar to Contact Us. I also modified my version slightly to account for those who have trouble reading text (go figure, but they are out there).

I will post the info here shortly.

 

--Jeff

Link to comment
Share on other sites

Lee, I have it on my site in Contact Us and Accounts....however you can't see it as I have disabled it temporarily.  I don't use it in tell-a-friend but I am guessing the implementation would be similar to Contact Us.  I also modified my version slightly to account for those who have trouble reading text (go figure, but they are out there).

I will post the info here shortly.

 

--Jeff

 

 

Thank you.. thank you.

 

I contaced the author and go no response.

 

I'll be looking forward to your post.

 

I have a general understanding of PHP so some instruction to make the install clear would help me out. I don't program but I do de-bug and have added 14 contributions. So I am not afraid of a little coding work.

 

Lee

Link to comment
Share on other sites

My site code using VVC, I have included some fore code and post code surrounding the actual VVC code so you can see the placement in context.

 

My Contact Us, 2 sections:

Section 1, near line 20-30: (!!!notice my /* and */ within the code, take them out if you use it!!!)

 

 ? ?if (tep_validate_email($email_address) == false) {
? ? ?$error = true;
? ? ?$messageStack->add('contact', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
? ?}
//VISUAL VERIFY CODE start
/* ?require(DIR_WS_FUNCTIONS . 'visual_verify_code.php');

? ?$code_query = tep_db_query("select code from visual_verify_code where oscsid = '" . $HTTP_GET_VARS['osCsid'] . "'");
? ?$code_array = tep_db_fetch_array($code_query);
? ?$code = $code_array['code'];

? ?tep_db_query("DELETE FROM " . TABLE_VISUAL_VERIFY_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'"); //remove the visual verify code associated with this session to clean database and ensure new results

? ?$user_entered_code = $HTTP_POST_VARS['visual_verify_code'];
? ?if (!(strcasecmp($user_entered_code, $code) == 0)) { ? ?//make the check case insensitive
? ? ? ?$error = true;
? ? ? ?$messageStack->add('contact', VISUAL_VERIFY_CODE_ENTRY_ERROR2);
? ?}*/
//VISUAL VERIFY CODE stop
? ?if ($error == false) {
? ? ? ? tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $enquiry, $name, $email_address);
? ? ? ? tep_redirect(tep_href_link(FILENAME_CONTACT_US, 'action=success'));
? ?}
?}

?$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CONTACT_US));
?>

 

Section 2, near line 140-150 (!! again, the /* */):

 

 ? ? ? ? ? ? ? ?<td class="mainbold"><?php echo ENTRY_ENQUIRY; ?></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ?<td><?php echo tep_draw_textarea_field('enquiry', 'soft', 50, 15); ?></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
<!-------------------------------------------------------------------- -->
<!--
?VISUAL VERIFY CODE start -->
?<?php /* ? ?<tr>
? ? ? ?<td class="mainbold"><?php echo VISUAL_VERIFY_CODE_CATEGORY; ?></td>
? ? ?</tr>
?<tr><td class="smallText"><?php echo VISUAL_VERIFY_CODE_HINT; ?></td>
?</tr>
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBoxContents">
? ? ? ? ?<tr>
? ? ? ? ? ?<td><table border="0" cellspacing="2" cellpadding="2">
? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ?<td class="main">
? ? ? ? ? ? ? ? ?<?php
/* ? ? ? ? ? ? ? ? ? ? ?$visual_verify_code = substr(str_shuffle (VISUAL_VERIFY_CODE_CHARACTER_POOL), 0, rand(3,6)); //if you have PHP 4.3
? ? ? ? ? ? ? ? ? ?//$visual_verify_code = ""; 
? ? ? ? ? ? ? ? ? ?//for ($i = 1; $i <= rand(3,6); $i++){
? ? ? ? ? ? ? ? ? ? ?// ? ?$visual_verify_code = $visual_verify_code . substr(VISUAL_VERIFY_CODE_CHARACTER_POOL, rand(0, strlen(VISUAL_VERIFY_CODE_CHARACTER_POOL)-1), 1);
? ? ? ? ? ? ? ? ? ? //}
? ? ? ? ? ? ? ? ? ? $vvcode_oscsid = $HTTP_GET_VARS['osCsid'];
? ? ? ? ? ? ? ? ? ? tep_db_query("DELETE FROM " . TABLE_VISUAL_VERIFY_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'");
? ? ? ? ? ? ? ? ? ? $sql_data_array = array('oscsid' => $vvcode_oscsid, 'code' => $visual_verify_code);
? ? ? ? ? ? ? ? ? ? tep_db_perform(TABLE_VISUAL_VERIFY_CODE, $sql_data_array);
? ? ? ? ? ? ? ? ? ? $visual_verify_code = "";
? ? ? ? ? ? ? ? ? ? echo('<img src="' . FILENAME_VISUAL_VERIFY_CODE_DISPLAY . '?vvc=' . $vvcode_oscsid . '"');
? ? ? ? ? ? ? ? ??>
? ? ? ? ? ? ? ?</td>
? ?<td class="main"><?php echo VISUAL_VERIFY_CODE_TEXT_INSTRUCTIONS; ?></td>
? ? ? ? ? ? ? ?<td class="main"><?php echo tep_draw_input_field('visual_verify_code') . ' ' . '<span class="inputRequirement">' . VISUAL_VERIFY_CODE_ENTRY_TEXT . '</span>'; ?></td>
? ?
? ? ? ? ? ? ? ?<!--
? ? ? ? ? ? ? ?<td class="main"><?php //echo VISUAL_VERIFY_CODE_BOX_IDENTIFIER; ?></td> -->
? ? ? ? ? ? ?</tr>
?	</table>
?	</td>
?	</tr>
?	<!--<tr>
? ?<td class="main"><table border="0" cellspacing="2" cellpadding="2" class="infoBoxContents">
? ? ? ?<tr>
? ?	<td class="main"><?php echo VISUAL_VERIFY_CODE_REFRESH; ?></td>
? ? ?</tr>
? ?</table>
? ?</td>
? ? ?</tr>-->
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr> */ ?> 
<!-- 
?VISUAL VERIFY CODE stop ? -->
<!-------------------------------------------------------------------- -->
? <tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
? ? ? ? ?<tr class="infoBoxContents">
? ? ? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ? ?<td align="center"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? <tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

 

My /includes/languages/english.php defines for VVC (modified from original, notice the character pool):

 

// For the Visual Verify Code
define('VISUAL_VERIFY_CODE_CHARACTER_POOL', 'abcdefghijklmnpqrstuvwxyz23456789FJWNVB63HLAJAF'); ?//no zeros or O
define('VISUAL_VERIFY_CODE_CATEGORY', 'Verify security code');
define('VISUAL_VERIFY_CODE_ENTRY_ERROR', 'The security code you entered did not match the one displayed. Please re-enter your State/Province, Password, and Security Code. Code does not have spaces or special formatting. Characters only.');
define('VISUAL_VERIFY_CODE_ENTRY_ERROR2', 'The security code you entered did not match the one displayed. Please Re-Enter the Code, enter only characters, do not include spaces or special formatting');
define('VISUAL_VERIFY_CODE_ENTRY_TEXT', '*');
define('VISUAL_VERIFY_CODE_HINT', 'Enter characters only, ignore case and formatting (no spaces, etc). Refresh to change code.');

 

Now, do remember, this is quite modified from the original. Bill Peer did help me quite a bit on my install (THANKS BILL!!) and I may be able to find his original text code he sent me, so if you need it, let me know. Bill is very busy, at least he was months ago when I contacted him, so don't feel like he doesn't care, he's actually quite an awesome guy and he was very helpful.

Hopefully I can help carry some of that load off his schedule and help you out.

 

If you need any other code, or have any Q's, let me know.

:thumbsup:

 

edit: I can also turn my site VVC back on so you can see what mine looks like, let me know if you need/want that.

Edited by snuff
Link to comment
Share on other sites

I get unexpected T_string with this line above.

 

Could you check the coding.

 

Thanks

 

Lee

 

I had to remove that line and copy it back in again and now it works Thank you for all your help with getting this part of the process taken care of. : )

 

Any Idea about how to implement into tell a friend.

 

I just do't want my site used as an email spam port hole.

 

Lee

Link to comment
Share on other sites

I had to remove that line and copy it back in again and now it works Thank you for all your help with getting this part of the process taken care of.  : )

 

Any Idea about how to implement into tell a friend.

 

I just do't want my site used as an email spam port hole.

 

Lee

I'll check into it, but don't wait on me if you can figure it out yourself. I am pretty busy in that thing they call a day job, so I do need to make them think I actually work. I'll try to hop on it asap though...

Link to comment
Share on other sites

Leon, give this a shot:

 

tell-a-friend.php, starting near line 65, with fore and aft code:

 

    if (!tep_validate_email($to_email_address)) {
     $error = true;

     $messageStack->add('friend', ERROR_TO_ADDRESS);
   }
//VISUAL VERIFY CODE start
 require(DIR_WS_FUNCTIONS . 'visual_verify_code.php');

   $code_query = tep_db_query("select code from visual_verify_code where oscsid = '" . $HTTP_GET_VARS['osCsid'] . "'");
   $code_array = tep_db_fetch_array($code_query);
   $code = $code_array['code'];

   tep_db_query("DELETE FROM " . TABLE_VISUAL_VERIFY_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'"); //remove the visual verify code associated with this session to clean database and ensure new results

   $user_entered_code = $HTTP_POST_VARS['visual_verify_code'];
   if (!(strcasecmp($user_entered_code, $code) == 0)) {    //make the check case insensitive
       $error = true;
       $messageStack->add('friend', VISUAL_VERIFY_CODE_ENTRY_ERROR);
   }
//VISUAL VERIFY CODE stop
   if ($error == false) {
     $email_subject = sprintf(TEXT_EMAIL_SUBJECT, $from_name, STORE_NAME);
     $email_body = sprintf(TEXT_EMAIL_INTRO, $to_name, $from_name, $product_info['products_name'], STORE_NAME) . "\n\n";

     if (tep_not_null($message)) {
       $email_body .= $message . "\n\n";
     }

 

near line 199 AFTER adding the above code:

 

                  <tr>
                   <td class="main"><?php echo FORM_FIELD_FRIEND_EMAIL; ?></td>
                   <td class="main"><?php echo tep_draw_input_field('to_email_address') . ' <span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>'; ?></td>
                 </tr>
               </table></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
     <tr>
       <td class="main"><b><?php echo VISUAL_VERIFY_CODE_CATEGORY; ?></b></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
         <tr class="infoBoxContents">
           <td><table border="0" cellspacing="2" cellpadding="2">
             <tr>
               <td class="main"><?php echo VISUAL_VERIFY_CODE_TEXT_INSTRUCTIONS; ?></td>
               <td class="main"><?php echo tep_draw_input_field('visual_verify_code') . ' ' . '<span class="inputRequirement">' . VISUAL_VERIFY_CODE_ENTRY_TEXT . '</span>'; ?></td>

               <td class="main">
                 <?php
                     //can replace the following loop with $visual_verify_code = substr(str_shuffle (VISUAL_VERIFY_CODE_CHARACTER_POOL), 0, rand(3,6)); if you have PHP 4.3
                   $visual_verify_code = "";
                   for ($i = 1; $i <= rand(3,6); $i++){
                         $visual_verify_code = $visual_verify_code . substr(VISUAL_VERIFY_CODE_CHARACTER_POOL, rand(0, strlen(VISUAL_VERIFY_CODE_CHARACTER_POOL)-1), 1);
                    }
                    $vvcode_oscsid = $HTTP_GET_VARS['osCsid'];
                    tep_db_query("DELETE FROM " . TABLE_VISUAL_VERIFY_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'");
                    $sql_data_array = array('oscsid' => $vvcode_oscsid, 'code' => $visual_verify_code);
                    tep_db_perform(TABLE_VISUAL_VERIFY_CODE, $sql_data_array);
                    $visual_verify_code = "";
                    echo('<img src="' . FILENAME_VISUAL_VERIFY_CODE_DISPLAY . '?vvc=' . $vvcode_oscsid . '"');
                 ?>
               </td>
               <td class="main"><?php echo VISUAL_VERIFY_CODE_BOX_IDENTIFIER; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
     </tr>
         <tr>
           <td class="main"><b><?php echo FORM_TITLE_FRIEND_MESSAGE; ?></b></td>
         </tr>

 

Hope this helps!

 

I can also provide the original files for contact_us and tell_a_friend or the original code (as mine in previous posts was modified).

:thumbsup:

Link to comment
Share on other sites

Loaded the full package up to the contribs directory. It includes all original .php files modified for VVC and README for create_account, contact_us, tell_a_friend for 2.2 MS2.

 

I can provide further modified versions of these for people wanting a different layout, different texts, etc. It is pretty easy to modify the layout to have it appear the way you want.

 

Thanks Bill! :thumbsup:

Link to comment
Share on other sites

  • 1 year later...

VVC went it without a hitch. Worked great.

 

A few days later and after installing

Down For Maint, SSPC, Spiders.txt, SPPC Price Breaks, SPPC Price List, and Supertracker the image is now broken on create account, contact us and refer a friend.

 

Since it's across three pages, I'd assume the coding in there is not the issue.

 

I've re-loaded the supplied vvc pages and double check the manually applied code within the pages. Everything is still in tact as it was. I clearly mark all my code changes when adding contrib's. The snips of code are untouched.

 

I then thought this could be a db issue. Dropped the tables, created new ones (all through myphpadmin). Though to no avail I may only be left with removing vvc.

 

Any suggestions as to what may have caused this.

My Contributions

 

Henry Smith

Link to comment
Share on other sites

....

A few days later and after installing

Down For Maint, SSPC, Spiders.txt, SPPC Price Breaks, SPPC Price List, and Supertracker the image is now broken on create account, contact us and refer a friend.

.....

Henry,

I also run Supertracker and update the Spiders.txt, and I have a Price Breaks contrib, but I am not sure what SPPC is (for the 3 you mention). Mine works fine.

Can you link me to the SPPC part (or tell me what it is) so I can check into it? Maybe I'll load the same thing up and see if mine breaks.

Link to comment
Share on other sites

  • 2 weeks later...
Lee, I have it on my site in Contact Us and Accounts....however you can't see it as I have disabled it temporarily. I don't use it in tell-a-friend but I am guessing the implementation would be similar to Contact Us. I also modified my version slightly to account for those who have trouble reading text (go figure, but they are out there).

I will post the info here shortly.

 

--Jeff

 

 

I'd like to install this contribution... I have a dumb question though... how do I run the SQL script???

 

 

thanks,

 

Elaine

"There are only 10 types of people in this world: those who understand binary, and those who don't. "

Link to comment
Share on other sites

  • 2 weeks later...

Hello,

 

I installed this contribution but the contact_us.php file I have is different then the one in the readme.doc.

 

I will paste where I put the code in my file, but it isn't working right. It still lets me send an email even when the security code is blank.

 

Can somebody tell me where I have to put the VVC Code in the contact_us.php file so it works properly? This is the original copy of the contact_us.php file that was in the osCommerce download I did.

 

<?php

/*

 $Id: contact_us.php,v 1.42 2003/06/12 12:17:07 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License

*/


 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CONTACT_US);

 $error = false;

 if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'send')) {
$name = tep_db_prepare_input($HTTP_POST_VARS['name']);
$email_address = tep_db_prepare_input($HTTP_POST_VARS['email']);
$enquiry = tep_db_prepare_input($HTTP_POST_VARS['enquiry']);

 if (tep_validate_email($email_address)) {
  tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $enquiry, $name, $email_address);
  tep_redirect(tep_href_link(FILENAME_CONTACT_US, 'action=success'));
} else {
  $error = true;
  $messageStack->add('contact', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
}

//VISUAL VERIFY CODE start
 require(DIR_WS_FUNCTIONS . 'visual_verify_code.php');

$code_query = tep_db_query("select code from visual_verify_code where oscsid = '" . $HTTP_GET_VARS['osCsid'] . "'");
$code_array = tep_db_fetch_array($code_query);
$code = $code_array['code'];

tep_db_query("DELETE FROM " . TABLE_VISUAL_VERIFY_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'"); //remove the visual verify code associated with this session to clean database and ensure new results

$user_entered_code = $HTTP_POST_VARS['visual_verify_code'];
if (!(strcasecmp($user_entered_code, $code) == 0)) {	//make the check case insensitive
	$error = true;
	$messageStack->add('contact', VISUAL_VERIFY_CODE_ENTRY_ERROR);
}
//VISUAL VERIFY CODE stop

 }


 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CONTACT_US));

?>

 

 

Thank you,

 

olimits7

Link to comment
Share on other sites

...the contact_us.php file I have is different then the one in the readme.doc.

 

I also noticed several differences between the non-VVC portions of the files in the VVC2.1 patch and the same files in Milestone2/05113 (and earlier versions) and I noted them where I could, although I went with the downloaded files.

 

I never got as far as the images, however: my contact us page now has the VVC image missing and an error message

1146 - Table 'osc_myurl.com.visual_verify_code' doesn't exist

 

DELETE FROM visual_verify_code WHERE oscsid='e3aa58e9893ce898e022362ad04dd6a0'

 

The same thing happens at create an account and tell a friend... Has anyone else encountered this? The database table does exist, so along with olimits7's problem I'm looking at GD library issues.

Link to comment
Share on other sites

Two things:

(1) Perhaps not surprisingly the error message

1146 - Table 'osc_myurl.com.visual_verify_code' doesn't exist

 

DELETE FROM visual_verify_code WHERE oscsid='e3aa58e9893ce898e022362ad04dd6a0'

...means exactly what it says. I had inadvertently run the SQL script on a secondary database with too similar a name :-" (lazy db-managers beware!). With the VVC table installed on the correct database, the display works perfectly.

(2) I am now having the same problem as I've seen on other threads, which is while 'create an account' works perfectly (sends notices, rejects wrong codes), with vvc2.1 "contact us" 'is worse than broken: the VV code shows up --it doesn't object if it is filled in incorrectly-- and wither tru or fales there is no 'your message has been delivered' splash. (I get the 'Welcome Back [tester]' screen instead). And no messages are sent to me as the store owner. I'll try getting rid of the unnecessary tables (TEXT_IM, TEXT_PHONE, etc) and report back. (My catalog/contact_us.php without the VVC add-on works okay in the meantime as long as Mr. [email protected] doesn't come calling again.)

 

Is Snuff still subscribed to this thread?

 

peace, -C.

Edited by chuckh2d
Link to comment
Share on other sites

While I was puzzling out the stuff around the second flagged VCC patch, I noticed that there is a "submit" button around line 188 that SHOULD have been visible.

 

(1) There is no button_submit.gif in the current (or any of my earlier) versions of osCommerce, so when the vvc2.1 script called for it, the page displayed a (very small and) ambiguous default button centered underneath the text area. With the 'continue' button five times as large, it was easy to assume that was the correct one to click. I made a rather ugly temporary submit button myself and put it in includes/languages/english/images/buttons, but I assume there's one somewhere at the VVC contribution page that just got left out of the current download.

 

(2) But speaking of sloppy code (my learning curve is quite gradual...), I successfully commented out the confusing extra tables at the bottom (TEXT_IM, etc.: these should be opt-n, not comment-out: how many stores are taking IMs from customers?) and moved up the continue button so that you don't have to scroll down for it. (I think 'discard and return to the store' would make more sense.)

 

to delete the TEXT_PHONE, TEXT_IM, and TEXT_MAIL tables:

comment out from line 204 of the current vvc2.1 contact_us.php file (line 201 might be better: I may have left some orphaned code behind as a result... Tables everywhere.)

to the end of line 251 (just after the mysterious first of two 'continue' buttons that is already commented out)

 

I'll post a bug report for the misssing .gif file at the contribution page.

Link to comment
Share on other sites

The fix and the missing button_submit.gif are available at the VVC contribution-page:

http://www.oscommerce.com/community/contributions,1560

With some luck the extra tables will go away with version 2.2

Just wondering if anyone could post the vvc2.1 contact us code that is actually up

and running correctly on a site.

I am using the files from the latest vvc contrib provided.

Had to mess with the code to get rid of the extra stuff.

But the page does not work correctly even though it 'looks' okay.

Can anyone out there post a vvc2.1 code for contact us that actually works correctly?

Would be much appreciated by those of us who are presently stuck.

Thanks in advance! B)

Link to comment
Share on other sites

  • 1 month later...

I installed this VVC contrib and modified it to work with the Guestbook for osC v1.0 contribution.

 

I tested it and it appears to be working perfectly - I can't process the guestbook_sign.php unless I enter the code.

 

However, I am still getting spammed on the guestbook. Are some robots out there capable of reading the VVC and entering it?

 

Here is my page if anyone would test it for themselves or could give me some direction...

 

http://www.honeybeadjewelry.com/guestbook_sign.php

 

Thanks!

Brian Neuman

Link to comment
Share on other sites

I installed this VVC contrib and modified it to work with the Guestbook for osC v1.0 contribution.

 

I tested it and it appears to be working perfectly - I can't process the guestbook_sign.php unless I enter the code.

 

However, I am still getting spammed on the guestbook. Are some robots out there capable of reading the VVC and entering it?

 

Here is my page if anyone would test it for themselves or could give me some direction...

 

http://www.honeybeadjewelry.com/guestbook_sign.php

 

Thanks!

 

I figured this out for myself. This contrib uses osC session id's to store the codes in the database. The problem is, bots don't accept cookies and they will not get a session id if they access the guestbook_sign.php or contact_us.php directly. I'm just not sure how to modify the code to accomodate for this...

Brian Neuman

Link to comment
Share on other sites

  • 4 weeks later...
Two things:

(1) Perhaps not surprisingly the error message

...means exactly what it says. I had inadvertently run the SQL script on a secondary database with too similar a name :-" (lazy db-managers beware!). With the VVC table installed on the correct database, the display works perfectly.

 

 

So, what code needs to be entered in the mysql command to correct this problem?

 

1146 - Table 'dbclothes.visual_verify_code' doesn't exist

 

DELETE FROM visual_verify_code WHERE oscsid='28ff34c322c11253de8df2274566077d'

 

[TEP STOP]

Link to comment
Share on other sites

I'll run through the latest versions and see if they break my site. If so, maybe installing the older versions would fix some problems?

Link to comment
Share on other sites

  • 1 month later...
I installed this VVC contrib and modified it to work with the Guestbook for osC v1.0 contribution.

 

I tested it and it appears to be working perfectly - I can't process the guestbook_sign.php unless I enter the code.

 

However, I am still getting spammed on the guestbook. Are some robots out there capable of reading the VVC and entering it?

 

Here is my page if anyone would test it for themselves or could give me some direction...

 

http://www.honeybeadjewelry.com/guestbook_sign.php

 

Thanks!

 

I?m trying to get the VVC to work on my guestbook_sign.php aswell but can?t get it to work.

How did you implement the code?

 

thanks in advance

Per

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...