This was my intention, what I did, and what is happening. It's 5 pages long, I thought it would be best to include everything, I hope it all fits.

1. I wanted to include 2 more fields on the add.cgi script ( Contact Address, and Contact Telephone number)
I just read a response from Elliot Lee on lost links, saying to check the "Links.db" file to see if all the links are still there. I only seem to be able to find the links.cfg,links.def and db.pl file?
2. I made changes to these scripts:
add.cgi
Title: $in{'Title'}
URL: $in{'URL'}
Category: $in{'Category'}
Description: $in{'Description'}
Contact Name: $in{'Contact Name'}
Contact Email: $in{'Contact Email'}
Contact Address: $in{'Contact Address'}
Contact Telephone: $in{'Contact Telephone'}

Modify.cgi
ORIGINAL LINK:
===============================================
Title: $original{'Title'}
URL: $original{'URL'}
Description: $original{'Description'}
Country: $original{'Country'}
Type: $original{'Type'}
Contact Name: $original{'Contact Name'}
Contact Email: $original{'Contact Email'}
Contact Address: $original{'Contact Address'}
Contact Telephone: $original{'Contact Telephone'}
Category: $original{'Category'}

NEW LINK:
===============================================
Title: $in{'Title'}
URL: $in{'URL'}
Description: $in{'Description'}
Country: $in{'Country'}
Type: $in{'Type'}
Contact Name: $in{'Contact Name'}
Contact Email: $in{'Contact Email'}
Contact Address: $in{'Contact Address'}
Contact Telephone: $in{'Contact Telephone'}
Category: $in{'Category'}

Simple html changes to the html pages
add_success.html
add_error.html
modify_success.html
modify_error.html

Simple text changes to these files
Contact Address : <%Contact Address%>
Contact Telephone: <%Contact Telephone%>
email-add.txt
email-del.txt
email-modify.txt

At this point the information fields were present on the Internet when add a site was activated. When you filled out the information, the success page information appeared correctly, and I would receive an email with all the information.

When I would go to the Links Manager to validate the record, the file would appear minus the 2 extra rows of the table for the Contact Address and Contact Telephone.

I looked at the links.def file to see if there would be anything to try, so I decided to make these changes:
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
URL => [2, 'alpha', 40, 75, 1, 'http://', '^http|news|mailto|ftp'],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
Category => [4, 'alpha', 0, 150, 1, '', ''],
Description => [5, 'alpha', '40x3', 500, 0, '', ''],
'Contact Name' => [6, 'alpha', 40, 75, 1, '', ''],
'Contact Email' => [7, 'alpha', 40, 75, 1, '', '.+@.+\..+'],
Hits => [8, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [9, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [10, 'alpha', 0, 5, 0, 'No', ''],
Rating => [11, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [12, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [13, 'alpha', 10, 10, 1, 'Yes', 'No|Yes']
'Contact Address' => [14, 'alpha', 40, 75, 1, '', ''],
'Contact Telephone' => [15, 'alpha', 40, 75, 1, '', ''],
Also in this area:
# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_category = 4; $db_modified = 3; $db_url = 2;
$db_hits = 8; $db_isnew = 9; $db_ispop = 10;
$db_contact_name = 6; $db_contact_email = 7; $db_title = 1;
$db_votes = 12; $db_rating = 11; $db_mail = 13;
$db_contact_address = 14; $db_contact_telephone = 15;

At this point my steps were fast but my memory of actions taken and specific order start to fail. As I remember, the files were accepted for validation but when I tried to "build all" I got this (below):

I don't understand the error to the admin_html.pl file below, because I didn't make any changes to it?

The error building links is a big problem now, because the data base appears empty.

I'm figuring there is some way to activate a back up of all the links, but I don't know how?

I would like to still keep the 2 new fields if it isn't to difficult.

I'm also wondering if I reverse all that I have done and "build all", will all my links return?
Any help would be appreciated.
Michael

VALIDATING
CGI ERROR
==========================================
Error Message : fatal error: Illegal division by zero at /home/funcost/public_html/cgi-bin/links/admin/admin_html.pl line
1056.

Script Location : admin.cgi
Perl Version : 5.00502

Form Variables
-------------------------------------------
db : links
validate_form : 1

Environment Variables
-------------------------------------------
AUTH_TYPE : Basic
DOCUMENT_ROOT : /home/funcost/public_html
GATEWAY_INTERFACE : CGI/1.1
HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
HTTP_ACCEPT_CHARSET : iso-8859-1,*,utf-8
HTTP_ACCEPT_ENCODING: gzip
HTTP_ACCEPT_LANGUAGE: en
HTTP_CONNECTION : Keep-Alive
HTTP_HOST : funcostarica.com
HTTP_REFERER : http://funcostarica.com/cgi-bin/links/admin/admin.cgi?display=navigation
HTTP_USER_AGENT : Mozilla/4.7 [en] (WinNT; U)
PATH : /usr/local/bin:/usr/bin:/bin
QUERY_STRING : db=links&validate_form=1
REMOTE_ADDR : 196.40.47.236
REMOTE_PORT : 61985
REMOTE_USER : funcost
REQUEST_METHOD : GET
REQUEST_URI : /cgi-bin/links/admin/admin.cgi?db=links&validate_form=1
SCRIPT_FILENAME : /home/funcost/public_html/cgi-bin/links/admin/admin.cgi
SCRIPT_NAME : /cgi-bin/links/admin/admin.cgi
SERVER_ADMIN : funcost@funcostarica.com
SERVER_NAME : funcostarica.com
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.0
SERVER_SOFTWARE : Apache/1.3.3 (Unix) PHP/3.0.9 FrontPage/3.0.4.3
TZ : US/Central

BUILDING
Building Pages

Pages built on 4-Mar-2001 at 09:55:36
--------------------------------------------------------

Backing up database . . .
Backing up links, category and email database (File::Copy) ...
Done.

Building URL Index . . .
Done.

Updating New and Popular Records . . .
What's New Cutoff: 14 days
Popular Cutoff: 2 hits

CGI ERROR
==========================================
Error Message : Error building! Links database is 0 bytes!
Script Location : nph-build.cgi
Perl Version : 5.00502

Form Variables
-------------------------------------------

Environment Variables
-------------------------------------------
AUTH_TYPE : Basic
DOCUMENT_ROOT : /home/funcost/public_html
GATEWAY_INTERFACE : CGI/1.1
HTTP_ACCEPT : image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, image/png, */*
HTTP_ACCEPT_CHARSET : iso-8859-1,*,utf-8
HTTP_ACCEPT_ENCODING: gzip
HTTP_ACCEPT_LANGUAGE: en
HTTP_CONNECTION : Keep-Alive
HTTP_HOST : funcostarica.com
HTTP_REFERER : http://funcostarica.com/cgi-bin/links/admin/admin.cgi?display=navigation
HTTP_USER_AGENT : Mozilla/4.7 [en] (WinNT; U)
PATH : /usr/local/bin:/usr/bin:/bin
QUERY_STRING :
REMOTE_ADDR : 196.40.47.236
REMOTE_PORT : 62937
REMOTE_USER : funcost
REQUEST_METHOD : GET
REQUEST_URI : /cgi-bin/links/admin/nph-build.cgi
SCRIPT_FILENAME : /home/funcost/public_html/cgi-bin/links/admin/nph-build.cgi
SCRIPT_NAME : /cgi-bin/links/admin/nph-build.cgi
SERVER_ADMIN : funcost@funcostarica.com
SERVER_NAME : funcostarica.com
SERVER_PORT : 80
SERVER_PROTOCOL : HTTP/1.0
SERVER_SOFTWARE : Apache/1.3.3 (Unix) PHP/3.0.9 FrontPage/3.0.4.3
TZ : US/Central

Err...OPEN your data folder...voila! Do you see links.db and all the other database files...BTW: If you had taken the time to read the README file, you should've figured out where the .db files are located.

And the error you are getting means that you have NOT added any links to your links.db, thus 0 bytes.

Regards,

Eliot Lee

Thanks Eliot. I did locate everything and uploaded the links.db from the backup.

Now (my first problem, Re: Add.cgi) I'm still wondering about which file and whereelse to make the rest of the changes to make the 2 new fields I created (contact address and contact telephone) appear on the document at the Links Manager when validating links?

Thanks Michael

All you do is add them to links.def and they show up automatically

Paul Wilson.
Installations:
http://www.wiredon.net/gt/

Thanks Paul. I tried it a second time, and I get this error message.
Error including libraries: syntax error at /home/funcost/public_html/cgi-bin/links/admin/links.def line 37, near "'Link Address'"

Make sure they exist, permissions are set properly, and paths are set correctly.

A copy of the portions of the links.def file that I made are here. Chmod 755

# Database Definition: LINKS
# --------------------------------------------------------
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
URL => [2, 'alpha', 40, 75, 1, 'http://', '^http|news|mailto|ftp'],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
Category => [4, 'alpha', 0, 150, 1, '', ''],
Description => [5, 'alpha', '40x3', 500, 0, '', ''],
'Contact Name' => [6, 'alpha', 40, 75, 1, '', ''],
'Contact Email' => [7, 'alpha', 40, 75, 1, '', '.+@.+\..+'],
Hits => [8, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [9, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [10, 'alpha', 0, 5, 0, 'No', ''],
Rating => [11, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [12, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [13, 'alpha', 10, 10, 1, 'Yes', 'No|Yes']
'Link Address' => [14, 'alpha', 40, 75, 1, '', ''],
'Link Telephone' => [15, 'alpha', 40, 75, 1, '', ''],

# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_category = 4; $db_modified = 3; $db_url = 2;
$db_hits = 8; $db_isnew = 9; $db_ispop = 10;
$db_contact_name = 6; $db_contact_email = 7; $db_title = 1;
$db_votes = 12; $db_rating = 11; $db_mail = 13;
$db_link_address = 14; $db_link_telephone = 15;

You need to add a comma after the following line of code:



REMEMBER that there must be a comma after each line except the last line within a HASH.

Regards,

Eliot Lee

Replace .......

'Link Address' => [14, 'alpha', 40, 75, 1, '', ''],
'Link Telephone' => [15, 'alpha', 40, 75, 1, '', ''],

.....with.....

Link Address => [14, 'alpha', 40, 75, 1, '', ''],
Link Telephone => [15, 'numer', 40, 75, 1, '', '']



Paul Wilson.
Installations:
http://www.wiredon.net/gt/

I included the changes suggested by both Eliot and Paul. This is the links.def file I uploaded and tried chmoded 755&777,
but more errors.

# Database Definition: LINKS
# --------------------------------------------------------
# Definition of your database file.
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
URL => [2, 'alpha', 40, 75, 1, 'http://', '^http|news|mailto|ftp'],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
Category => [4, 'alpha', 0, 150, 1, '', ''],
Description => [5, 'alpha', '40x3', 500, 0, '', ''],
'Contact Name' => [6, 'alpha', 40, 75, 1, '', ''],
'Contact Email' => [7, 'alpha', 40, 75, 1, '', '.+@.+\..+'],
Hits => [8, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [9, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [10, 'alpha', 0, 5, 0, 'No', ''],
Rating => [11, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [12, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [13, 'alpha', 10, 10, 1, 'Yes', 'No|Yes'],
Link Address => [14, 'alpha', 40, 75, 1, '', ''],
Link Telephone => [15, 'numer', 40, 75, 1, '', '']
);

# Field Number of some important fields. The number is from %db_def above
# where the first field equals 0.
$db_category = 4; $db_modified = 3; $db_url = 2;
$db_hits = 8; $db_isnew = 9; $db_ispop = 10;
$db_contact_name = 6; $db_contact_email = 7; $db_title = 1;
$db_votes = 12; $db_rating = 11; $db_mail = 13;
$db_link_address = 14; $db_link_telephone = 15;

When activating add.cgi
Error including libraries: syntax error at /home/funcost/public_html/cgi-bin/links/admin/links.def line 37, near "Link Address"

Make sure they exist, permissions are set properly, and paths are set correctly. chmod 755 or 777


When going to links manager.
CGI ERROR
==========================================
Error Message : fatal error: syntax error at /home/funcost/public_html/cgi-bin/links/admin/links.def line 37, near "Link
Address"

Script Location : admin.cgi
Perl Version : 5.00502

Form Variables

Are you sure you don't need to just refresh?

The code in links.def looks ok to me unless I missed something.

Paul Wilson.
Installations:
http://www.wiredon.net/gt/

UH...for the following field names:

Link Address and Link Telephone, you need to either use single quotes or underscores...rather attempting to edit the hash again, JUST copy the COMPLETE set of codes BELOW and PASTE them into your links.def file....



GOT it!


Regards,

Eliot Lee

Thanks Eliot, that seems to be a step in the right direction. I'm able to activate the add.cgi and enter the links manager.

Now the problem is accepting the information, when all the information is filled in.
The error message is: There were the following errors trying to add your resource:

Link_Address (Can not be left blank)
Link_Telephone (Can not be left blank)

I tried changing the in put name of those fields with the underline between in the add, and add_success html files, but that didn't seem to do it. Any more suggestions?

The field names need to be identical to those in the database...ie ...

<input type="text" name="Link_Telephone">

Paul Wilson.
http://www.wiredon.net/gt/
Coming soon => www.perlmad.com

Actually, this ERROR relates to having these fields required in the links.def file. You need to change the following codes:



to the following:



Notice the bolded red codes....

And for more information about "FIELD DEFINITIONS", search the Links 2.0 Customization Forum for, surprisingly , field definitions.

Regards,

Eliot Lee

That did it.
Thanks again Eliot.

I jumped the gun Eliot. Everthing is working except when i get the email. The new fields are there but not the information submitted at the site. At the links manager the file has the new fields, but empty as well.

This is my email-add file
Title : <%Title%>
URL : <%URL%>
Category : <%Category%>
Description : <%Description%>
Contact Name : <%Contact Name%>
Contact Email : <%Contact Email%>
Link Address : <%Link Address%>
Link Telephone: <%Link Telephone%>
I don't think an underline is going to work?

Err....as I said, fields/tags have to be IDENTICAL to the ones you have in links.def

<%Link_Telephone%>
<%Link_Address%>

The script isn't clever enough to guess what you mean!


Paul Wilson.
http://www.wiredon.net/gt/
Coming soon => www.perlmad.com

thanks Paul, but I think the devil is working against me. The field name and information is visible on the add-success.html after submitting. I have replaced the link address and link telephone with the link_telephone and link_address in the

add.html
add-success.html
add-email.txt (if it works here, I can change the error and mod files later)
the only place left is I think Link.cgi

Link Address: $in{'Contact Address'}
Link Telephone: $in{'Contact Telephone'}
But it dosen't seem to be the right place for it.
The problem is in the email I receive. The fields are there, just not the information.

I'm also having a horrible time getting the add-success.html page to wrap the defintion text. This is the latest entry I've tried (not being a programmer, all I do is experiment)
<tr>
<td ALIGN=RIGHT><b>Description:</b></td>
<td><%Description%><textarea wrap="virtual" name="Description" value="" rows="5" cols="40"></td></tr></textarea>

I am really confused now...ARE YOU or ARE YOU NOT using Templates??? You are mixing codes for templates and non-templates.

Stop changing field names and copy the codes and suggestions that Paul and I have given you so far. It is real frustration when advice is given and users hack the suggestions and then complain that they don't work...

Regards,

Eliot Lee

Eliot,Paul
I'm sorry, the problem probably is I'm asking about 2 different things.
I am, using the yahoo templates. I have copied all the scripts as per both your instructions.
The results are:
1. The 2 new (link Address and link telephone) do appear on the Internet page when people click on add a
site.
2. The information that is entered in those areas also appears on the successfully submitted page.
3. I can also see the 2 new areas with the INFORMATION submitted when I go to validate the record at the links manager.
4. The 2 new (link Address and Link telephone) do appear on the email sent to me.
What doesn't happen is:
1. The INFORMATION ENTERED in those areas does not appear in the email I receive.

The other (totally separate) problem I refereed to in the last reply (about the html, deals with trying to wrap
the text that is entered in the description of the link box (which wraps fine when entering information on the
Internet, but doesn't wrap on the add_success.html page.

What I attempted was: placing the <%Link_address%> and <%Link_Telephone%>within a table on the
add_success_html page. The html in the reply was one version that didn't work.

Maybe I should of only asked about one thing at a time.
I really do appreciate both of your input.
Michael

Contradiction...please clarify point 4...

And for the other issue:

Simply remove the <pre></pre> anchors in your add_success.html file as mentioned quite a few times in these forums.

Regards,

Eliot Lee

I figured I should just send a copy of one of the test emails I receive.
This is what I receive, there is no information after the Link Address:
or the Link Telephone:, but the information (actual address and telephone number) that were submitted on the Internet, do appear at the links manager when validating the file.

The following link is awaiting validation:

Title: zzzzzzzzzzzzzzzzzzzzzzzzz
URL: http://crtimes.com
Category: Finance
Description: mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
Contact Name: me
Contact Email: michael@crtimes.com
Link Address:
Link Telephone:

Remote Host:
Referer: http://funcostarica.com/cgi-bin/links/add.cgi

To validate, please go to:
http://funcostarica.com/cgi-bin/links/admin/admin.cgi

Sincerely,

Links Manager.

About the <pre> anchors, Mine are long gone. This is what that part of the script looks like now.

<p><font face="Arial" size="2">We have received the following link:</font></p>

<table BORDER=0 CELLSPACING=2 CELLPADDING=0 COLS=2 WIDTH="450" >
<tr>
<td ALIGN=RIGHT WIDTH="140"><b>Title:</b></td>
<td WIDTH="280"><%Title%></td></tr>

<tr>
<td ALIGN=RIGHT><b>URL:</b></td>
<td><%URL%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Description:</b></td>
<td textarea wrap="virtual" name="Description" value="" rows="5" cols="40"></textarea><%Description%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Contact Name:</b></td>
<td><%Contact Name%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Contact Email:</b></td>
<td><%Contact Email%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Link Address:</b></td>
<td><%Link_Address%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Link Telephone:</b></td>
<td><%Link_Telephone%></td></tr>

<tr>
<td ALIGN=RIGHT><b>Category:</b></td>
<td><%Category%></td></tr>
</table>

<p><font face="Arial" size="2">Thank you! We will send you an email once your link has been validated.</font></p>
<table>

You need to use:

Link Address: $rec{'Link_Address'}
Link Telephone: $rec{'Link_Telephone'}

Regards,

Eliot Lee

You are really confusing me...

IS the NAME of the field called Link_address OR Link_Address???

You are mixing your field names too much to know the difference and IF you do not use the same case settings as the field name in your %db_def hash in the links.def in ALL the templates and scripts, then guess what...the scripts will not work effectively.

Paul has already told you about matching the cases of field names before...

Regards,

Eliot Lee

I decided to look at all the files again. The problem was the add.cgi it didn't have one of the new changes. Now the information is visible in my received email.

I'll keep working on trying to make the script wrap in the description section of the add_success.html and email I receive. If it gets to me I'll post a new message.
Thanks again to both of you.
Michael