Gossamer Forum
Home : Gossamer Threads Inc. : Custom Modification Jobs :

Comments MOD for Links SQL2

Quote Reply
Comments MOD for Links SQL2
Hi All,

I need someone to write a mod for me, The site is based arround holiday destinations and i would like visitors to the site to be able to post their views on the hotel/appartments etc. with a few drop down boxes for accommodation (good/bad) location etc. These will display instantly on the site or can be incorporated into the nect build, although i will have to be able to modify and delete entries.

Interested?? email me mail@isee-multimedia.co.uk
Regards

Mark
http://www.host4.me.uk

No doubt i'll be back for more answers!
Quote Reply
Re: [mdj1] Comments MOD for Links SQL2 In reply to
It would'nt be too difficult...

Here are some starting points:

1) Create a table called Links_Comments:

LinkID (Index, NOT UNIQUE)
UserID (Index, NOT UNIQUE)
Comments (LONGTEXT, NULL)
Rating (ENUM, 'Bad','Good', NOT NULL)

2) You could copy the add.cgi script and hack it to include Links_Comments DBSQL object rather than Links_Links.

3) Then you could use the "dynamic" version of the detailed pages, I believe written by pugdog (basically a hack of jump.cgi) to call the set of comments for the link.

I do believe that pugdog started a "reviews/rating" system awhile back, but had to put it on the back-burner due to health complications. May be you could find other info in the Plugins forum.

========================================
Buh Bye!

Cheers,
Me

Last edited by:

AnthroRules: Sep 19, 2001, 2:48 PM
Quote Reply
Re: [AnthroRules] Comments MOD for Links SQL2 In reply to
Thanks Eliot.

I'll give it a go!!
Regards

Mark
http://www.host4.me.uk

No doubt i'll be back for more answers!