Gossamer Forum
Home : Products : Gossamer Links : Discussions :

updating bad link table

Quote Reply
updating bad link table
Hello,

I have created a new column in my bad_link table named 'REASON'. I set the type to varchar(150) and NULL to 'yes'.

Then in my bad_link.html I added the following:

<select name="REASON" size="4" multiple>
<option value="Link doesn't work">Link doesn't work</option>
<option value="Site is overly misleading">Site is overly misleading</option>
<option value="Site tries to send viruses">Site tries to send viruses</option>
<option value="Illegal content">Illegal content</option>
</select>

I also modified the bad_link report so that the column for REASON shows up. Now on to my question :)

How do I pass the reasons into the REASON column in the bad_link table? I think it is handled by bad_link.cgi. I tried this:

$db_bad_links->add ( { LinkID => $id,
REASON => $rec->{'REASON'}
URL => $rec->{'URL'},
Title => $rec->{'Title'},
IP => $ENV{'REMOTE_ADDR'}
} );

But, that doesn't work. I don't know what that section means, I was just taking a random guess. If I manually input a reason using mysqlman then the reason does show up on my bad link report. I just can't figure out how to pass the value from my html form into MYSQL.

I really did try to figure this out on my own, but is beyond me. Any help would be most appreciated!!
Subject Author Views Date
Thread updating bad link table Demolitioncrew 7968 Mar 20, 2003, 12:03 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 7709 Mar 20, 2003, 12:18 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 7748 Mar 20, 2003, 12:24 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 7725 Mar 20, 2003, 12:33 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 7764 Mar 20, 2003, 12:41 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 7769 Mar 20, 2003, 12:47 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 7735 Mar 20, 2003, 12:55 PM
Thread Re: [Demolitioncrew] updating bad link table
Paul 7706 Mar 20, 2003, 1:19 PM
Thread Re: [Paul] updating bad link table
Demolitioncrew 7716 Mar 20, 2003, 1:53 PM
Thread Re: [Demolitioncrew] updating bad link table
Jonze 7720 Mar 20, 2003, 9:59 PM
Thread Re: [Jonze] updating bad link table
Demolitioncrew 7675 Mar 20, 2003, 10:03 PM
Post Re: [Demolitioncrew] updating bad link table
Jonze 7673 Mar 20, 2003, 10:18 PM
Thread Re: [Jonze] updating bad link table
afinlr 7745 Mar 21, 2003, 5:31 AM
Thread Re: [afinlr] updating bad link table
Jonze 7697 Mar 21, 2003, 8:40 AM
Thread Re: [Jonze] updating bad link table
afinlr 7693 Mar 21, 2003, 8:48 AM
Thread Re: [afinlr] updating bad link table
Jonze 7671 Mar 21, 2003, 9:07 AM
Thread Re: [Jonze] updating bad link table
pugdog 7664 Mar 21, 2003, 9:35 AM
Thread Re: [pugdog] updating bad link table
Jonze 7672 Mar 21, 2003, 11:30 AM
Thread Re: [Jonze] updating bad link table
Paul 7636 Mar 21, 2003, 12:14 PM
Thread Re: [Paul] updating bad link table
ronzo 7643 Mar 21, 2003, 1:46 PM
Thread Re: [ronzo] updating bad link table
Paul 7651 Mar 21, 2003, 4:11 PM
Thread Re: [Paul] updating bad link table
ronzo 7649 Mar 21, 2003, 5:07 PM
Post Re: [ronzo] updating bad link table
pugdog 7587 Mar 22, 2003, 11:19 AM