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 6258 Mar 20, 2003, 12:03 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 6016 Mar 20, 2003, 12:18 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 6056 Mar 20, 2003, 12:24 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 6029 Mar 20, 2003, 12:33 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 6061 Mar 20, 2003, 12:41 PM
Thread Re: [Demolitioncrew] updating bad link table
afinlr 6072 Mar 20, 2003, 12:47 PM
Thread Re: [afinlr] updating bad link table
Demolitioncrew 6037 Mar 20, 2003, 12:55 PM
Thread Re: [Demolitioncrew] updating bad link table
Paul 6013 Mar 20, 2003, 1:19 PM
Thread Re: [Paul] updating bad link table
Demolitioncrew 6022 Mar 20, 2003, 1:53 PM
Thread Re: [Demolitioncrew] updating bad link table
Jonze 6026 Mar 20, 2003, 9:59 PM
Thread Re: [Jonze] updating bad link table
Demolitioncrew 5981 Mar 20, 2003, 10:03 PM
Post Re: [Demolitioncrew] updating bad link table
Jonze 5979 Mar 20, 2003, 10:18 PM
Thread Re: [Jonze] updating bad link table
afinlr 6052 Mar 21, 2003, 5:31 AM
Thread Re: [afinlr] updating bad link table
Jonze 6004 Mar 21, 2003, 8:40 AM
Thread Re: [Jonze] updating bad link table
afinlr 6000 Mar 21, 2003, 8:48 AM
Thread Re: [afinlr] updating bad link table
Jonze 5977 Mar 21, 2003, 9:07 AM
Thread Re: [Jonze] updating bad link table
pugdog 5970 Mar 21, 2003, 9:35 AM
Thread Re: [pugdog] updating bad link table
Jonze 5979 Mar 21, 2003, 11:30 AM
Thread Re: [Jonze] updating bad link table
Paul 5944 Mar 21, 2003, 12:14 PM
Thread Re: [Paul] updating bad link table
ronzo 5943 Mar 21, 2003, 1:46 PM
Thread Re: [ronzo] updating bad link table
Paul 5958 Mar 21, 2003, 4:11 PM
Thread Re: [Paul] updating bad link table
ronzo 5956 Mar 21, 2003, 5:07 PM
Post Re: [ronzo] updating bad link table
pugdog 5894 Mar 22, 2003, 11:19 AM