owner's approval for a comment in the adv. guestbook

Is there any script or way in order that a message in the guestbook appears only after the owner's approval?

That's in case of offensive or similiar messages.

It can be done with a complex modification to Advanced Guestbook.

How much complex by the way?

Alteration to 4 files, alteration to database as well. I have actually coded it in to Lazarus which is my off shoot of the Advanced Guestbook.

Do you think is it something to do easily or I risk of compromising everyting in the guestbook if I make those changes?

Is it possibile to have published in this forum the instructions to proceed?

Would probably take me a week to remember what I did. I may look into it next weekend when I have finished this project I am working on.

Oh cool! Thank you in advance if you will be able to post here what you did!

Why dont you just use carb's Lazarus guestbook???

What is that?

www.carbonize.co.uk/lazarusgb.zip is Lazarus. It's an offshoot of the Advanced guestbook I have made.

It is a release candidate so contains some minor bugs.

This is just to share what changes I made so that I could approve messages before they appeared. I haven't looked at Lazarus yet. Thanks to Carbonize and all other's messages here that have been of help to me.

This has really helped me keep the spam out and other entries I didn't want. You have to go in and approve the good entries which is high maintenance but I was spending time anyway removing spam. Now nothing goes in without me OK'ing it. Hope this helps someone else.
RJ

-- 1. Use PHPADMIN to create new column called O_K
ALTER TABLE `book_data` ADD `O_K` CHAR( 1 ) DEFAULT 'Y' NOT NULL AFTER `id` ;

-- 2. edit lib/gb.class select statement to add "where O_K='Y' "
-- Change:
-- $result = $this->db->query("select x.*, y.p_filename, y.width, y.height, z.comments from ".$this->db->table['data']." x left join ".$this->db->table['pics']." y on (x.id=y.msg_id and y.book_id=2) left join ".$this->db->table['com']." z on (x.id=z.id) group by x.id order by x.id desc limit $entry, $last_entry");

-- To This:
$result = $this->db->query("select x.*, y.p_filename, y.width, y.height, z.comments from ".$this->db->table['data']." x left join ".$this->db->table['pics']." y on (x.id=y.msg_id and y.book_id=2) left join ".$this->db->table['com']." z on (x.id=z.id) where O_K='Y' group by x.id order by x.id desc limit $entry, $last_entry");

-- 3. Change default value of O_K to 'N' for new entries from now on
ALTER TABLE `book_data` CHANGE `O_K` `O_K` CHAR( 1 ) DEFAULT 'N' NOT NULL;

-- From then on, approve or remove entries using PHPADMIN
-- 1. check for new entries, get only last 25
SELECT * FROM `book_data` WHERE O_K = 'N' order by date
desc limit 25;

-- 2. change value of O_K to 'Y' for rows with good entries
-- 3. delete spam and others you want to get rid of

Wow would of been easier installing Lazarus lol