Additional contact us fields

28 May 2007, 00:48

#1

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Additional contact us fields

Hi,

I have just finished with a new new contribution called: Additional contact us fields. Quite similar to the additional customers fields but for the contact us page.

Site: 'http://www.storm.ca/~oracle'

Good luck !

MODERATOR NOTE: This mod is apparently no longer available nor supported by its author. The reasons given on the author's website are only half the story. This discussion thread remains available for reference for those who have already downloaded and attempted to use the contribution.

28 May 2007, 11:11

#2

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Rather than just downloading the MOD, what are the inputs on this one ? :mellow:

31 May 2007, 22:57

#3

stenrique

Zen Follower

Join Date:: Apr 2005
Posts:: 355
Plugin Contributions:: 0

Re: Additional contact us fields

Hi TheOracle, I've just downloaded the mod. too early to make much comment yet. I do have a question though. Having installed a num. of other mods., I am just curious on the file structure for the
includes/modules/<your_template>/pages/contact_us/header_php.php file.

Mind sharing with us the rational for creating the /pages/contact_us/ folder under ones template folder rather than integrating the required changes into the existing header_php.php file at /includes/modules/pages/contact_us?

01 Jun 2007, 02:51

#4

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Several hundreds (perhaps thousands) of Zen-Cart users are using template overrides as well as modules overrides. Which is why, I always state the customized template name within my MOD steps in order to avoid any confusion that might be involved. :wink2:

01 Jun 2007, 03:04

#5

kim

Obaa-san

Join Date:: Jun 2003
Posts:: 26,564
Plugin Contributions:: 0

Re: Additional contact us fields

Only one little problem ... the /pages/ directory is NOT overridable.

01 Jun 2007, 11:11

#6

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Oh ... just noticed what you meant there ... 'your_template' folders are not being used at the right place in my package ... I will dig into that today. :blush:

02 Jun 2007, 00:25

#7

stenrique

Zen Follower

Join Date:: Apr 2005
Posts:: 355
Plugin Contributions:: 0

Re: Additional contact us fields

While you are at it, would it be too much to ask if you could make an additional field "required/not required"? :wink:
Btw, is it possible to place the new field between the "Email Address" and "Message" fields?

02 Jun 2007, 00:31

#8

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

While you are at it, would it be too much to ask if you could make an additional field "required/not required"?

Already planned for the next release. :wink2:

Btw, is it possible to place the new field between the "Email Address" and "Message" fields?

You can modify the while loop statement block, under your customized contact us template page, the way you want it to be by placing this one blocks onto the place you wish too. :smile:

However, for now, individual additional fields are not yet implemented. All blocks must be executed together.

04 Jun 2007, 06:12

#9

stenrique

Zen Follower

Join Date:: Apr 2005
Posts:: 355
Plugin Contributions:: 0

Re: Additional contact us fields

Thank for the mod. dude, I anxiously awaits your next version :thumbsup:

10 Jun 2007, 10:36

#10

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Update:

http://www.zen-cart.com/forum/showpost.php?p=387608&postcount=41

Another update will be posted once it is back online.

10 Jun 2007, 11:45

#11

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

http://www.zen-cart.com/forum/showpost.php?p=387633&postcount=2

11 Jun 2007, 09:53

#12

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

THanks for your kind mod.

But when i try to add a field from admin panel ..

I got the error

Unknown column 'customer_id' in 'field list'

What is the problems.

Thanks body.

11 Jun 2007, 10:29

#13

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Very vague description. Please provide more details on how this is happening.

- PHP Version.
- mySQL Version
- Zen-Cart Version.
- From which action this is happening ?
- Do you still have readings inside your TABLE_CUSTOMERS table (by looking into phpmyadmin) ?

11 Jun 2007, 14:00

#14

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

TheOracle:
Very vague description. Please provide more details on how this is happening.

- PHP Version.
- mySQL Version
- Zen-Cart Version.
- From which action this is happening ?
- Do you still have readings inside your TABLE_CUSTOMERS table (by looking into phpmyadmin) ?

Thanks and my

PHP version is Version 5.1.2

Mysql is MySQL 5.0.18

Zen-Cart Version. is 1.3.5

after i fill the two fields and click the submit,

The error happens

1054 Unknown column 'customer_id' in 'field list'
in:
[INSERT INTO ec_contact_us_additional (field_id, customer_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status) VALUES (NULL, '', 'dd', 'dd', '2007-06-11', '13:55:53', '', '', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have deleted the exsited information in Table customers..
But it cannot solve the problem!!

11 Jun 2007, 14:05

#15

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

It is weird !

I have only "field_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status" in my TABLE contact_us_additional..

But the error says

Unknown column 'customer_id' in the field list .......

what happens....

11 Jun 2007, 14:18

#16

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

In your

additional_contact_us.php

at arround 260 line

$sql_insert = "INSERT INTO " . TABLE_ADDITIONAL_CONTACT_US . " (field_id, [color=green]customer_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status) VALUES (NULL, '', '" . $contact_us_field_name . "', '" . $contact_us_field_description . "', '" . $date . "', '" . $time . "', '', '', '1')";[/color]

But where is the custome_ID field in Contact_us_additional table.......

After i remove the customer_id from the above sentence...
I got another error..

1136 Column count doesn't match value count at row 1

11 Jun 2007, 14:34

#17

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

ok ,Now i 've added the customer_id to the Table contact_us_additional artificially

After click the submit...

I got the error.

Warning: Cannot modify header information - headers already sent by (output started at D:\2spy\ecgadget\2spymanager\additional_contact_us.php:42) in D:\2spy\ecgadget\2spymanager\includes\functions\general.php on line 34

Has anyone succeeded in this mod??

11 Jun 2007, 15:26

#18

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Confirmed bugs. I have now refreshed the package from my site.

In the mean time, please do not post 5 topics in a row. If you're expecting more than a single issue with this MOD, post under a thread or two.

Empty (not just delete - but "empty") your additional contact us table and create new contact us fields again from the admin section.

12 Jun 2007, 16:31

#19

adam9110

New Zenner

Join Date:: Jan 2006
Posts:: 92
Plugin Contributions:: 0

Re: Additional contact us fields

Hi Oracle,,

Did you updated ?

I still have interest to test it .

THanks.

12 Jun 2007, 18:02

#20

theoracle

Suspended

Join Date:: Aug 2004
Posts:: 3,180
Plugin Contributions:: 1

Re: Additional contact us fields

Like I said on my previous post ... I updated the package on my site ...