https://proxy2.de/forum/posts/list/5.php JForum - http://www.jforum.net
That's in case of offensive or similiar messages.]]> https://proxy2.de/forum/posts/preList/4712/16432.php https://proxy2.de/forum/posts/preList/4712/16432.php GMT https://proxy2.de/forum/posts/preList/4712/16438.php https://proxy2.de/forum/posts/preList/4712/16438.php GMT ]]> https://proxy2.de/forum/posts/preList/4712/16439.php https://proxy2.de/forum/posts/preList/4712/16439.php GMT https://proxy2.de/forum/posts/preList/4712/16440.php https://proxy2.de/forum/posts/preList/4712/16440.php GMT


Is it possibile to have published in this forum the instructions to proceed?]]> https://proxy2.de/forum/posts/preList/4712/16441.php https://proxy2.de/forum/posts/preList/4712/16441.php GMT https://proxy2.de/forum/posts/preList/4712/16442.php https://proxy2.de/forum/posts/preList/4712/16442.php GMT
]]> https://proxy2.de/forum/posts/preList/4712/16443.php https://proxy2.de/forum/posts/preList/4712/16443.php GMT https://proxy2.de/forum/posts/preList/4712/16464.php https://proxy2.de/forum/posts/preList/4712/16464.php GMT ]]> https://proxy2.de/forum/posts/preList/4712/16579.php https://proxy2.de/forum/posts/preList/4712/16579.php GMT 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.]]> https://proxy2.de/forum/posts/preList/4712/16580.php https://proxy2.de/forum/posts/preList/4712/16580.php GMT
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 "[u]where O_K='Y' [/u]"
-- 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) [color="red"]where O_K='Y' [/color]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]]> https://proxy2.de/forum/posts/preList/4712/17309.php https://proxy2.de/forum/posts/preList/4712/17309.php GMT https://proxy2.de/forum/posts/preList/4712/17310.php https://proxy2.de/forum/posts/preList/4712/17310.php GMT