Rate Links Mod

[David]

A big thanks to yktan for this mod, which will likely be added to future releases. This mod allows users to rate links, but only one rating per ip address is allowed.

Attention: this mod has been edited. Please read the entire thread!

[seothatworks]

Good one. But hopefully it will be only optional in future releases. I have seen it being misused mostly :(.

[yktan]

Originally Posted by seothatworks

Good one. But hopefully it will be only optional in future releases. I have seen it being misused mostly :(.

Thanks seothatworks. Don't worry, the rating feature can be turned on and off in the admin panel, so rest assured.

Regards,
YK

[David]

Yep, and that is one of the beauties of this program, tehe ability to customize it to your needs. We just now releasing the Featured Links module and Payment mudule in the latest development version in the WebSVN.

[yktan]

Hi, this Rate Mod has been upgraded to cater for the most recent release of PHP Link Directory. Please use this version if you are using RC4 and above.

Regards,
York Kie

[ant1980]

Hi Yktan,
in the RC4 i do not find this code[in red color] but the first line only:

#-----[ OPEN ]------------------------------------------
#
/admin/dir_links_edit.php
#
#-----[ FIND ]------------------------------------------
#
$data = $db->GetRow("SELECT * FROM {$tables['link']['name']} WHERE ID = $id");
if ($db->Execute("DELETE FROM {$tables['link']['name']} WHERE ID='$id'")) {
$data['STATUS'] = 0;
send_status_notifications($data, false);
if (isset ($_SESSION['return'])) {
header("Location: ".$_SESSION['return']);
exit;
}
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}
#
#-----[ REPLACE WITH ]------------------------------------------
#
$data = $db->GetRow("SELECT * FROM {$tables['link']['name']} WHERE ID = $id");
if ($db->Execute("DELETE FROM {$tables['link']['name']} WHERE ID='$id'")) {
$data['STATUS'] = 0;
send_status_notifications($data, false);
if ($db->Execute("DELETE FROM {$tables['link_rate']['name']} WHERE LINK_ID='$id'")) {
if (isset ($_SESSION['return'])) {
header("Location: ".$_SESSION['return']);
exit;
}
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}

Bye

[yktan]

Hi ant1980,

The Mod is done for the lastest release of PHP Link Directory. If you are using RC4, you may have to follow some instructions from the first version of the Mod and some from the new version of the Mod.

Ie. The instruction for the part you're trying to change (for the first version of the Mod) is:

#
#-----[ OPEN ]------------------------------------------
#
/admin/dir_links_edit.php
#
#-----[ FIND ]------------------------------------------
#
if ($db->Execute("DELETE FROM {$tables['link']['name']} WHERE ID='$id'")) {
	if (isset ($_SESSION['return'])) {
		header("Location: ".$_SESSION['return']);
		exit;
	}
} else {
	$tpl->assign('sql_error', $db->ErrorMsg());
}
#
#-----[ REPLACE WITH ]------------------------------------------
#
if ($db->Execute("DELETE FROM {$tables['link']['name']} WHERE ID='$id'")) {
	if ($db->Execute("DELETE FROM {$tables['link_rate']['name']} WHERE LINK_ID='$id'")) {
		if (isset ($_SESSION['return'])) {
			header("Location: ".$_SESSION['return']);
			exit;
		}
	} else {
		$tpl->assign('sql_error', $db->ErrorMsg());
	}
} else {
	$tpl->assign('sql_error', $db->ErrorMsg());
}

Regards,
YK

[ant1980]

Thx yktan,
i'have solved applying the mod to the version in development {url removed because it is no longer active}
Now it work fine :wink:

Regards

[malooga]

Is there any way to display a "Top Rated Links" page or box?

[yktan]

Hi, attached is the Rating Mod that includes sorting by Rating in the index page.

For those who already applied Rating Mod v1.0.1, just do the following changes:

Open /index.php
Find:

$sort_cols = array ( 'P' => 'PAGERANK', 'H' => 'HITS', 'A' => 'TITLE');
$sort_ord = array ( 'P' => 'DESC', 'H' => 'DESC', 'A' => 'ASC');

Replace with:

$sort_cols = array ( 'P' => 'PAGERANK', 'H' => 'HITS', 'R' => 'RATE', 'A' => 'TITLE');
$sort_ord = array ( 'P' => 'DESC', 'H' => 'DESC', 'R' => 'DESC', 'A' => 'ASC');

Open /templates/main.tpl
Find:

{if $sort eq 'H'} <span class="sort">{l}Hits{/l}</span>{else} {l}Hits{/l}{/if}

Add below:

{if $sort eq 'R'} | <span class="sort">{l}Rating{/l}</span>{else} | {l}Rating{/l}{/if}

Regards,
York Kie

[jetlag]

Hello
Thanks for the rate mod it works great. The only problem i had (im new to this) was i use wordpad and when copying/paste the code it pasted it wrong... or wordpad displays it wrong. It didnt show the "Rate It" link.

#
/templates/link.tpl
#
#-----[ FIND ]------------------------------------------
#


{$link.DESCRIPTION}</p>
#
#-----[ REPLACE WITH ]------------------------------------------
#


{$link.DESCRIPTION}
{if $link.RATE_ENABLED eq 1}
<span class="url">(Hits: {$link.HITS} Rating: {$link.RATE} Votes: {$link.RATE_COUNT}) <a href=
	"{$smarty.const.DOC_ROOT}/rate.php?id={$link.ID}">Rate It</a></span>{/if}</p>
#

Changed to this...

{$link.DESCRIPTION}
{if $link.RATE_ENABLED eq 1}
<span class="url">(Hits: {$link.HITS} Rating: {$link.RATE} Votes: {$link.RATE_COUNT}) Rate It</span>{/if}</p>

[minstrel]

Don't use WordPad to edit php files... it adds formatting and probably wordwrap.

You need a plain ascii text editor like NotePad or a php editor such as Crimson Editor (excellent and freeware -- download at http://www.crimsoneditor.com).

[vkaryl]

Another good free editor is Notepad2 from http://www.flos-freeware.ch - in fact, it's SO good I've set it to replace windows' notepad. Line counting, color coding, etc. standard....

[jetlag]

great...thanks for the links

[jetlag]

Hello
what do you change to make the font smaller and change the color to grey or black on the "Rate It" link. I find it sticks out too much.
(Hits: 2 Rating: 0.00 Votes: 0) Rate It <--

Thanks
Jetlag
canadianpwc.com/directory/Rentals/

[yktan]

Hi jetlag, the font I used is a class from css called "url". To change it, simply open templates\link.tpl and change it to another class that you want.

Regards,
York Kie

[jetlag]

Thanks

[righthosts]

Hi,

Does this mod work with 5.2?

[Nobody]

Will the next release of the major script include this mod?

[VSDan]

1. Original mod works with RC5.2

2. Here are some changes you can make to display a [Top Rated] in your Top Menu Bar:

(a) Locate the following code in /templates/top_bar.tpl:

htxp://{$smarty.const.DOC_ROOT}/index.php?p=h"]{l}Top Hits{/l}
|

...and add the following afterwards:

htxp://{$smarty.const.DOC_ROOT}/index.php?p=r"]{l}Top Rated{/l}
|

(b) Locate the following code in /index.php:

case 'h':
$links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 $expire_where ORDER BY hits desc limit 0, ".LINKS_TOP);
$path[] = array ('ID' => '0', 'TITLE' => _L('Popular Listings'), 'TITLE_URL' => '', 'DESCRIPTION' => '');
break;

...and add the following afterwards:

case 'r':
$links = $db->GetAll("SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 $expire_where ORDER BY rate desc limit 0, ".LINKS_TOP);
$path[] = array ('ID' => '0', 'TITLE' => _L('Top Rated'), 'TITLE_URL' => '', 'DESCRIPTION' => '');
break;

(c) Locate the following code in /rss.php:

case 'h':
$sql = "SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 $expire_where ORDER BY HITS DESC";
$tpl->assign('title', ' - Popular Listings');
break;

...and add the following afterwards:

case 'r':
$sql = "SELECT * FROM {$tables['link']['name']} WHERE STATUS=2 $expire_where ORDER BY RATE DESC";
$tpl->assign('title', ' - Top Rated Listings');
break;

I revised post and added (c). Otherwise, RSS feed was broken when you clicked on RSS icon on [Top Rated Listings] page.


Regards,

Dan
Virtual Solutions
monster-submit.com