How can I increase the 32 character limit in the Checkout Referral Box?

[postergame]

Can anyone tell me how to increase the amount of text a customer can type into the referral box on the checkout page? It appears to be limited to 32 characters.

I am using the referral code box simply as a place for customers to leave their comments. It is titled: "OPTIONAL: How did you hear about us?".

A customer recently wrote "website @ bot. of pic @ work". They meant to say, "I saw your web address printed on the bottom of a poster at work", but couldn't write all that, given the 32 character limit.

I wonder if I need to increase some field length in my database, however I can find no field labeled "referral ..." , nor would I know how to change the length anyway.

Can anyone help?

Thanks!

[virtualahmad]

umm... i'm sure there is a field in the db for it... but without looking for that... why not use: http://www.zen-cart.com/index.php?ma...roducts_id=186 ?

[postergame]

Thanks, but I have looked at that module in the past and it involves a drop-down box listing choices.

I want a comment box similar to the one on the shipping instructions page, where a customer can write unlimited text. Is there a way to duplicate the shipping comments box and place it on the first checkout page?

[J_Schilz]

postergame,

I think the simplest way to do this would be to create a new field in create account, and then include that entry in the e-mail you receive from create account success.

So, first you'd create a form in tpl_modules_create_account.php with something like this:

<?php echo zen_draw_textarea_field('ourReferralBox', '45', '3'); ?>

I'm not terribly familiar with the inputs of the draw textarea field function, you'll have to change the parameters to fit your needs.

Then in /includes/modules/yourtemplate/create_account.php, towards the end where it's adding on extra info you'd want to modify:

      $extra_info=email_collect_extra_info($name,$email_address, $account->fields['customers_firstname'] . ' ' . $account->fields['customers_lastname'] , $account->fields['customers_email_address']);

      $html_msg['EXTRA_INFO'] = $extra_info['HTML'];
      zen_mail('', SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO, SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO_SUBJECT . ' ' . EMAIL_SUBJECT,
      $email_text . $extra_info['TEXT'], STORE_NAME, EMAIL_FROM, $html_msg, 'welcome_extra');
    } //endif send extra emails

such that:

      $extra_info=email_collect_extra_info($name,$email_address, $account->fields['customers_firstname'] . ' ' . $account->fields['customers_lastname'] , $account->fields['customers_email_address']);

      $html_msg['EXTRA_INFO'] = $extra_info['HTML'];
      zen_mail('', SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO, SEND_EXTRA_CREATE_ACCOUNT_EMAILS_TO_SUBJECT . ' ' . EMAIL_SUBJECT,
      $email_text . $_POST['ourReferalBox'] . "\n" . $extra_info['TEXT'], STORE_NAME, EMAIL_FROM, $html_msg, 'welcome_extra');
    } //endif send extra emails

For this to work, you have to receive the account creation e-mails, and read them. If you like this and need help tweaking it or such, let me know.

--Joe

[kobra]

Second poster is correct - this is a DB driven field size and to be capable of storing this info you need to increase the var for it in the DB. Zen Cart will auto size the box based on the value in the DB

[postergame]

J_Schilz

Thanks for your hard work.

kobra

Thanks for confirming the field limitation in the php database. I searched harder and found customers > customers_referral and was able to change the field length there. Much better!

Zencart does not automatically resize the field on my form. I changed the form length in the tpl create account module, under zen_set_field_length.

Do you know the code to make the display box several lines taller? Can I add a set_field_height or something? I couldn't manage to find the code description for the shipping comments box, to copy it.

Thanks!