My Modifications

Hondo — GMT

Hi,
I'm missing 2 things at ADVGuestbook:
1. Spamwords Managements
2. Administration of new Items

My quick and dirty solutions:
Spamword management:
Edit add.class.php at about line 224 in function add_entry():
[code] $spam_array = array("viagra", "tadalafil", "hydrocodone", "diazepam");
foreach($spam_array as $spam_value) {
if (strpos(strtolower($this->comment), $spam_value)>0){
return $this->db->gb_error("Your guestbook-entry is canceled by the spam management!");
}
}[/code]

Second Managing new Entries:
I added a new field called validate tinyint(2) with 0 as default value.
Then changed gb.class.php as follow:
[code] function show_entries($entry=0) {
global $GB_PG, $ISADMIN;
$entry = intval($entry);
$LANG = &$this->db->LANG;
$VARS = &$this->db->VARS;
$this->db->fetch_array($this->db->query("select count(*) as total from ".$this->db->table['data']." Where validate = 1"));
if ($ISADMIN){
$this->db->fetch_array($this->db->query("select count(*) as total from ".$this->db->table['data']));
}[/code]

And function get_entries in same file:
[code] $result = $this->db->query(
"select x.*, y.p_filename, y.width, y.height from
".$this->db->table['data']." x left join ".$this->db->table['pics']." y on (x.id=y.msg_id and y.book_id=2)
Where (x.validate = 1)
order by x.id desc limit $entry, $last_entry"
);
if ($ISADMIN){
$result = $this->db->query(
"select x.*, y.p_filename, y.width, y.height from
".$this->db->table['data']." x left join ".$this->db->table['pics']." y on (x.id=y.msg_id and y.book_id=2)
order by x.id desc limit $entry, $last_entry"
);
}
while ($row = $this->db->fetch_array($result)) {
$row['email2'] = "";
$DATE = $this->db->DateFormat($row['date']);
$MESSAGE = nl2br($row['comment']);
$validate = $row['validate'];[/code]

I Inserted 2 Buttons for release and delete:
[code] if ($ISADMIN && $validate==0)
$ADMINBUTTONS = ' ';
else
$ADMINBUTTONS = '';[/code]

And I Inserted the $Adminbuttons in template entry.
Also I make a connection to SMF Forum, and from there I get the value of $ISADMIN. For confirming and deleting Entries I create 2 php files wich contains the mysql connection and the queries.

Here is a screenshot of an entry as the admin sees:
[url]http://www.mkportal-support.de/img/advguestbook.gif[/url]
You see the 2 icons over the entry.

OK, thats it. If somebody is interested of the code please send me an email or pm.

Andreas

Carbonize — GMT

1 - Spamwords is dealt by the bad words list in admin
2 - If you mean the ability to make new posts require moderating then this is something I added to Lazarus which is a fork of Advanced Guestbook.

Hondo — GMT

Hi,
as I know are words in bad words list only converted to something.
What I mean is that entries wich contains bad words are to cancel by system and not to save in table. I spend a lot of time every day to delete such spams. So I will spare me this time because spams are not at all saved.

2. Yes, moderate new entries. I don't want to use Lazerus, I use ADVGuestbook.

Carbonize — GMT

http://proxy2.de/forum/viewtopic.php?t=5540

I'm not suggesting you do switch to Lazarus (even though it's pretty much identical to AG being that is is AG but rewritten) I was just indicating I had added it already for those that do not want to modify their AG.

Hondo — GMT

Hi,
yes Lazerus seems much better than ADVGuestbook especially the spam management. But at this project I use ADVGuestbook and my modifications also works. But for next projects I think I will try Lazerus.

Thanks

Re:My Modifications

cebe100 — GMT

good !!

Latest posts for the topic "My Modifications"

My Modifications

Re:My Modifications