Latest posts for the topic "How to: Add an extra field for the advanced guestbook"

How to: Add an extra field for the advanced guestbook

Jam'n — GMT

One of the things people are looking for is to add an extra field to the guestbook.
So I tried this experiment.

This version is for the plain version of the advanced guestbook.

Until now is 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 to find out what the problem is and to support it.
But maybe somebody else knows what is wrong and shares the solution with us.

To use it:

1. Import the table.
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 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]

Jam'n — GMT

I updated the code it works with the preview function now.
I made a typo in the code

Anonymous — GMT

Ok, so we have to change “extra1” and “extra field” in every one of the code boxes listed. What is the first box of code though? The one that starts with "# MySQL dump 8.16"

The directions are very well written and look easy enough, but I don't understand that first box, I don't know where to find that part of code.

Anonymous — GMT

You have to change the motherfucking loc.php with v4.5 of the fucking inet, then download the tool com.php by this asshole website php.net!

When you did it, you can change the fucking loc.php with the motherfucking compiled com.php.

That`s it!

And everybody is motherfucking happy!

Anonymous — GMT

By the way, take a fucking new version of MYSQL, then you don`t have this motherfucking problem!

Anonymous — GMT

Ok....that was uncalled for.
So can anyone else tell me what that first box of code is?

Anonymous — GMT

The first code is an expansion in your database where the entry's of the extra fields will be written.

You will need phpmyadmin to import it.
Don't forget to change the name if you changed extra1

Anonymous — GMT

I think I've almost got this working...but I'm a little confused on the database editing part. Do I import my entire GB database or just the "book_data" file? And do I leave off the first part of that block of code? You know, the whole [color="green"]# MySQL dump 8.16 [/color]part and all?

I want to add two extra fields to my guestbook, for favorite console and game, so if I understand this correctly, my code to insert in the database would look like this:

[code]# --------------------------------------------------------

#
# alter Table structure for table 'Favorite Console'
#

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

# --------------------------------------------------------

#
# alter Table structure for table 'Favorite Game'
#

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

Anonymous — GMT

Hi,

You just need to select you guestbook in phpMyadmin an then import.

[code]# --------------------------------------------------------

#
# alter Table structure for table 'Favorite Console'
#

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

# --------------------------------------------------------

#
# alter Table structure for table 'Favorite Game'
#

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

All the lines starting with # are not used its just for the info.

Anonymous — GMT

Thank you very much for taking the time to provide this information on how to add extra fields. The only part that gave me a little confusion was right at the start:

1. Import the table.

I didn't know what this meant. Basically I just selected my database in PHPMyAdmin, clicked on the SQL button and entered the two SQL lines of code and this worked fine.

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.

The person wanting to add extra fields for "console" etc got a little confused with what they put as their SQL and this confused me too as I didn't have to enter my database name anywhere for it to work OK, just the name of my new field.

I believe you have to keep 'book_data' and 'book_private' in the SQL and just change 'extra1' to the name you want your new field to be. This is because you are wanting to add new fields to the 'book_data' and 'book_private' tables, not create a new table called "console" or whatever.

I wanted a new field for people to enter the name of the team they support, so I used 'team' as my new field name in place of every incidence of 'extra1' when making all the changes/addition. I was chuffed when the guestbook showed my new field and everything worked properly first time, which is why I thought I should say thanks.

As I wanted my new field name to be 'team' this is how my SQL was entered:

ALTER TABLE `book_data` ADD `team` varchar(70) NOT NULL default '';
ALTER TABLE `book_private` ADD `team` varchar(70) NOT NULL default '';