If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
owner's approval for a comment in the adv. guestbook  XML
Forum Index » Advanced Guestbook Forum
Author Message
corto66
Beginner

Joined: 09/06/2005 13:42:38
Messages: 5
Offline

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.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
corto66
Beginner

Joined: 09/06/2005 13:42:38
Messages: 5
Offline

How much complex by the way?
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
corto66
Beginner

Joined: 09/06/2005 13:42:38
Messages: 5
Offline

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?
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
corto66
Beginner

Joined: 09/06/2005 13:42:38
Messages: 5
Offline

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

JTD
Graduate

Joined: 08/05/2004 21:52:50
Messages: 529
Location: Arkansas
Offline

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

LINK-> Use Lazarus Guestbook
[WWW] [Yahoo!] aim icon [MSN]
corto66
Beginner

Joined: 09/06/2005 13:42:38
Messages: 5
Offline

What is that?
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

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.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
rj
Newbie

Joined: 30/07/2005 06:28:16
Messages: 1
Offline

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

RJ
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Wow would of been easier installing Lazarus lol

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum