Need to add fields to the guest book, howto?

npereira — GMT

Hi,

Love the guest book.

Although i need the ability to add a few fields specificaly motorcycle Make/Model/year, years experience, and a few others.

I also want to replace AIM and ICQ with Hotmail account.

Is this possible and how do I do this?

Me too.

yea — GMT

I want to add fields as well. I'm a novice at this and don't know how to do anything to the script. I can only do little things like change background color with html code.

I'd also like to change the aim and icq to something else.

Jam'n — GMT

I made this tutorial 2 years ago to add the extra fields
I know it works, the only problem at the moment is that when you preview the entry the extra field isn’t written away.

I don’t have any time at the moment and I stopped support for the guestbook.
So I never looked to fix this problem

To use it:

1. Import the table (with phpMyadmin).
2. Change “extra1” and “extra field:” with the name you want, “extra1 is the database name and “extra field:” is what the guestbook shows the guests.
3. Replace “Your_picture.gif"” with the image you want to see.
4. Just follow the instructions.

Import (with phpMyadmin) this table into your database:

[code]# MySQL dump 8.16
#
# Host: localhost Database: gb23
#--------------------------------------------------------
# Server version 3.23.42

#
# alter Table structure for table 'Extra Field'
#

ALTER TABLE `book_data` ADD `extra1` varchar(70) NOT NULL default '';
ALTER TABLE `book_private` ADD `extra1` varchar(70) NOT NULL default ''; [/code]

Open index.php

Find:
[code]$gb_post->location = (isset($HTTP_POST_VARS["gb_location"])) ? $HTTP_POST_VARS["gb_location"] : '';[/code]

Add after:
[code]$gb_post->extra1 = (isset($HTTP_POST_VARS["gb_ extra1"])) ? $HTTP_POST_VARS["gb_ extra1"] : '';[/code]

Open addentry.php

Find:
[code]$gb_post->location = (isset($HTTP_POST_VARS["gb_location"])) ? $HTTP_POST_VARS["gb_location"] : '';[/code]

Add after:
[code]$gb_post->extra1 = (isset($HTTP_POST_VARS["gb_extra1"])) ? $HTTP_POST_VARS["gb_extra1"] : '';[/code]

Open templates/entry.php

Find:
[code]
$LANG[FormLoc]: $row[location]
[/code]

Add after:
[code]
Extra Field 1: $row[extra1]
[/code]

Open templates/form.php

Find:
[code]
$LANG[FormLoc]:

[/code]

Add after:
[code]
Extra Field 1:

[/code]

Open templates/previewentry.php

Find:
[code]$LANG[FormLoc]:
$row[location]
[/code]

Add after:
[code]Extra Field 1:
$row[extra1]
[/code]

Open admin/panel_edit.php

Find:
[code]
Location:

[/code]
Add after:
[code]
Extra Field 1:

[/code]

Open admin/panel_easy.php

Find:
[code]if ($row['location']) {
echo " \n Location:
$row[location]\n \n";
} [/code]
Add after:
[code]if ($row['extra1']) {
echo " \n Extra Field 1:
$row[extra1]\n \n";
}[/code]

Open lib/add.class.php

Find:
[code] var $location = '';[/code]

Add after:
[code] var $extra1 = '';[/code]

Find:
[code] $this->location = $this->db->FormatString($this->location);[/code]
Add after:
[code] $this->extra1 = $this->db->FormatString($this->extra1);[/code]

Find:
[code] $this->location = addslashes($this->location);[/code]

Add after:
[code] $this->extra1 = addslashes($this->extra1);[/code]

Find:
[code]$this->db->query("INSERT INTO $sql_usertable (name,gender,email,url,date,location,host,browser,comment,icq,aim) VALUES ('$this->name','$this->gender','$this->email','$this->url','$the_time','$this->location' ,'$host','$agent','$this->comment','$this->icq','$this->aim')");[/code]

And replace with:
[code]$this->db->query("INSERT INTO $sql_usertable (name,gender,email,url,date,location,extra1,host,browser,comment,icq,aim) VALUES ('$this->name','$this->gender','$this->email','$this->url','$the_time','$this->location','$this->extra1','$host','$agent','$this->comment','$this->icq','$this->aim')");[/code]

Find:
[code] $this->location = stripslashes($this->location);[/code]

Add after:
[code] $this->extra1 = stripslashes($this->extra1);[/code]

Find:
[code] $HIDDEN .= "location."\">\n";[/code]

Add after:
[code] $HIDDEN .= "extra1."\">\n";[/code]

Find:
[code] $row['location'] = $this->location;[/code]

Add after:
[code] $row['extra1'] = $this->extra1;[/code]

Open lib/admin.class.php

Find:
[code] $sqlquery= "UPDATE $gb_tbl set name='$HTTP_POST_VARS[name]', email='$HTTP_POST_VARS[email]', gender='$HTTP_POST_VARS[gender]', url='$HTTP_POST_VARS[url]', location='$HTTP_POST_VARS[location]', ";[/code]

And replace with:
[code] $sqlquery= "UPDATE $gb_tbl set name='$HTTP_POST_VARS[name]', email='$HTTP_POST_VARS[email]', gender='$HTTP_POST_VARS[gender]', url='$HTTP_POST_VARS[url]', location='$HTTP_POST_VARS[location]',
extra1='$HTTP_POST_VARS[extra1]', ";[/code]

Open lib/comment.class.php

[code]Find:
if (!$row['location']) {
$row['location'] = "-";
}[/code]

Add after:
[code] if (!$row['extra1']) {
$row['extra1'] = "-";
}[/code]

Open lib/gb.class.php

Find:
[code] if (!$row['location']) {
$row['location'] = "-";
}[/code]

Add after:
[code] if (!$row['extra1']) {
$row['extra1'] = "-";
}[/code]

Latest posts for the topic "Need to add fields to the guest book, howto?"

Need to add fields to the guest book, howto?

Me too.