[Rate Link] Mod

[VSDan]

Description: Allows surfers to rate links, with option to display top XX rated links. Highly configurable. You can define:

- how long (in XX hours) that someone must wait before they can rate the same listing again [default = 24] [logged IPs in SQL database are automatically purged every XX hours by rate.php]
- whether to use Form-Based, Smilie-Based, or AJAX-Based Rating System [default = Form-Based]
- default rating value [default = 10]
- number rating options [default=10]
- rating values / labels
- maximum number of Top Rated to display [default=10]

Demo: http://www.monster-submit.com/directory/
(find listing, and click on 'Rate' link)

Download: http://www.monster-submit.com/phpld/


To download this and other VS mods, please go here : VS phpLD Mods (http://www.monster-submit.com/phpld/)

[bobby9101]

very nice update. I really should buy 3+

[Psyclones]

Got a bit of a problem?

I installed your mod, added tables, added columns, on trying to rate a link i get.

Content visible to registered users only.

ip xxx`d out

any help would be great dan.

[VSDan]

Could you send me URL to your phpMyAdmin (or equivalent mySQL control panel) and username/password so I check your phpLD database. You can PM me

[Psyclones]

sorry mate cannot do that, its not my domain,

but if you could tell me what to look for i will gladly have a gander.

[bobby9101]

I don't have the mod, so I am firing blind.
My guess it check to make sure you enetred the data correctly into either tables.php, fucntions.php or init.php :o

[VSDan]

I think I might see the problem. I forgot to write in the readme file that you need to edit include/tables.php by adding the following at the end:

$tables['link_rate'] = array (
'name' => TABLE_PREFIX.'LINK_RATE' ,
'fields' => array (
'ID' => 'I KEY AUTO' ,
'LINK_ID' => 'C(64) NULL' ,
'IP' => 'C(15) NULL' ,
'TIMESTAMP' => 'T DEFDATE'
)
);

(add after last ); and before ?>)

I'll update the readme file in the ZIP file. My apologies!

[Psyclones]

that resolved it dan, sorry for the late reply but i had lots of beer to drink this week end :)

[klammer06]

Hello VSDan,

I downloaded your MOD after buying it.

Installed everything like in Readme.

Now i get error:

Notice: SmartyValidate: [validate plugin] form 'rate_link_form' is not registered. in libs\smarty\plugins\function.validate.php on line 47

Can you please help me?

thx

W*

[VSDan]

'rate_link_form' is not used in my mod. Can you post your rate.tpl file.

[klammer06]

Hi,

it's just the original file:

Content visible to registered users only.

Now I don't get the error any more (cleaned up the cache), but when rating is submitted, nothing is written into the database and the form loads again!?!

Thanks

W*

[VSDan]

Can you post URL (publically or via PM) the URL to your directory so I can see the rate mod in action. Thanks.

[e-rafael]

Hi,
How to change urls form: /rate.php?id=354
to
/rate/link-354.html

I have done changing in file link.tpl:
Content visible to registered users only.
and in .htaccess:
Content visible to registered users only.
but this not working:(

[VSDan]

Try changing:

RewriteRule (.*)rate/link-(.*).html$ rate.php [QSA,NC]

to:

RewriteRule (.*)rate/link-(.*).html$ rate.php?id=$1 [QSA,NC]

But, I believe the mod only accepts via POST, and not GET. You would have to edit mod to accept both POST and GET. Mind you, why do you want to make ratings SEO-friendly? Normally, this is not the sort of thing you want spiders to spider.

[Density5]

i have bought Rate Listing [phpLD 3.04+ Only] installed it on to 3.0.5 - form shows but no submittion of rating - any ideas?

[VSDan]

I think you mean rate.css and rate.js. These are only used if you use optional [Smilie Rating System] Mod - its in that mod's ZIP file that you will find those two files (in addition to the smilie images and instructions).

[pragent]

I gave up! I get not to run the MOD :-(
(Version 3.0.6 beta2)

I installed your mod, added tables, added columns, on trying to rate a link i get.
Here is problem:
Content visible to registered users only.

[gangavalli]

Dan, how do we display the total number of ratings for a particular listing in the details page? or a category page?

[Optimit]

I have a list of top rated links, but how do I filter them? I would lilke them to have at least 3 votes. The way it currently lists them, 1 rating of a 10 will beat 5 ratings of a 9.

Here is an example. http://www.bloggeries.com/rate.php?list=top

[VSDan]

{$RATE} = average rating
{$RATE_COUNT} = total number ratings

[VSDan]

Open rate.php, and change:

Content visible to registered users only.

to:

Content visible to registered users only.

[Optimit]

Was a little different coding in the version I have, but worked great Dan!!

Thanks for everything you do here.!!!!

[VSDan]

Glad you got it working. And, you're welcome =)

[giggler]

The version I have is also different and doen't have links1 and links2...what else do I need to change if I change this code to links1 and links2?

Content visible to registered users only.

[Zorrocaesar]

I tried to install this mod in phpld 3.1.0 and I activated the AJAX-Based Rating System by setting $TYPE = 2 in the rate_lang.php file.

But when I click rate, I get the following error:

Content visible to registered users only.

[VSDan]

Hi:

Please post here:

http://www.monster-submit.com/phpld/members/forum/

[direalm]

Hi, after trying to update database from readme file I get the following error:

Error

SQL query:
CREATE TABLE `PLD_LINK_RATE` ( `ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`LINK_ID` varchar( 64 ) default NULL ,
`IP` varchar( 15 ) default NULL ,
`TIMESTAMP` datetime default '0000-00-00 00:00:00',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;


MySQL said:
#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ' at line 7

[VSDan]

Try:

Content visible to registered users only.

If still error:

Content visible to registered users only.

[direalm]

Thank You, the first code worked fine. Just sitting trying to figure out why in the featured links the rating image is stretched out into a box and in the Recent featured links there is no rating:)

Eddited: Also noticed that if I change the rating system to set 5, it will allow you to vote upto 5 but the default image under site url will show ten stars:(

[jharri26]

I am trying to get the ajax based rating to work being integrated right into the details page. I did an include from the details.tpl to the rate.php file and the images show but when i click on a star rating the please wait image just keeps going and nothing happens. Any ideas how to get this to work on the details page.

[VSDan]

Content visible to registered users only.

Can you post here:

http://www.monster-submit.com/phpld/members/forum/

Thanks.

[jharri26]

thanks, went ahead and did that. I noticed a couple other posts on the forums similar to what i am doing. I think has to do with the /detail/ subdirectory thats re-written. Is it easy to rewrite the detail/link-id to root/ as something more seo friendly?