Module: Display n "Hotlinks" from the Links Directory

[Natch]

Original Hack (http://www.vbulletin.org/forum/showthread.php?t=60403) - Some of you will recognise this from the addon I wrote for vBIndex - I have been converted to this wonderful portal by it's featureset and general groovyness :D

Firstly, upload this attached hotlinks.php to the modules folder.

Make a couple of new templates:

adv_portal_hotlinks<table align="center" border="0" class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" width="100%">
<tr>
<td class="tcat" colspan="100%"><span class="smallfont"><a name="hotties"></a><strong>$vba_options[portal_blockbullet] <a href="$vboptions[bburl]/local_links.php?$session[sessionurl]">Hottest Downloads</a></strong></span></td>
</tr>
<tr>
<td class="alt2"><span class="smallfont"><strong>Link</strong></span></td><td class="alt2"><span class="smallfont"><strong>Hits</strong></span></td>
</tr>
$hotlinksbits
</table>
<br />


adv_portal_hotlinksbits <tr>
<td class="alt1"><span class="smallfont"><if condition="$linkstatus==1"><a href="$vboptions[bburl]/local_links.php?action=jump&id=$linkid" target="_blank">$linkname</a></if><if condition="$linkstatus>1"><a href="$vboptions[bburl]/local_links.php?action=jump&id=$linkid" target="_blank">$linkname</a> [$linkstatus kb]</if><if condition="$linkstatus<=0">$linkname (not available)</if></span></td>
<td class="alt2"><span class="smallfont">$linkhits</span></td>
</tr>


In your Admincp - vBa CMPS - Add Module

- Module Title - HotLinks
- Module Identifier - Leave blank
- File to include - Select hotlinks.php
- OR Template to Include - Leave blank
- Activate and select the column you want it in.

Save and you're all done. :eek:

Here's a link to a demo - now active CPMS! (http://www.mobileforces.org/index.php)

[Rids]

Thanks for this hack, I just installed it and it adds a nice extra bit of connectivity to my site :)

[BoNfiRe]

Nice thx Natch just what I needed :D

[ixian]

Very nice, although the extra "hits" column really throws off the look of the block compared to the rest of the page. I'll edit that out.

Natch, have you figured out, by chance, how to integrate local_links.php with the rest of CMPS? i.e. as you can with other parts of vb, as outlined here:

http://www.vbadvanced.com/membersarea.php?do=viewmanual&productid=4&pageid=6

The problem with local_links.php is he uses a different scheme for print_output and I cannot, no matter what I try, get it to work. Any ideas?

[ixian]

Fix for width issue:

Replace the adv_portal_hotlinks template above with this:


<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr>
<td class="tcat" colspan="88%"><span class="smallfont2"><a name="hotties"></a><strong>$vba_options[portal_blockbullet] <a href="$vboptions[bburl]/local_links.php?$session[sessionurl]">Hottest Downloads</a></strong></span></td>
</tr>
<tr>
<td class="alt2"><span class="smallfont"><strong>Link</strong></span></td><td class="alt2"><span class="smallfont"><strong>Hits</strong></span></td>
</tr>
$hotlinksbits
</table>
<br />


And the Latest links block will both fit perfectly with the rest of the blocks and display the number of hits, as well.

[Realist]

I installed this but when I activate it I get a DB error:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT * FROM local_linksadmin
mysql error: Table 'xxxxxxx_xxx.local_linksadmin' doesn't exist

mysql error number: 1146

Date: Friday 25th of June 2004 01:51:04 PM
Script: http://www.tech-tronix.com/index.php
Referer:
Username: Realist
IP Address: xx.xxx.xxx.xxx

[Natch]

Have you installed the Links hack in question ? if so and if you have altered the hack to use a different prefix then you will need to alter this hack file to alter the prefix as well ...

[Natch]

Another note:

My members requested a sifferent count of the hits - one that "reset" every month to show the current most popular links, not just the All time most popular links...

So I did it.

Replace your current hotlinks.php module with the following:<?
// ######################## USER-EDITABLE VAR ############################
// If you want to use the standard VBulletin database table prefix, comment out
// the following line and uncomment the line after it
define('THIS_TABLE', 'local_');
// define ('THIS_TABLE', TABLE_PREFIX);
//
// ######################### REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/functions_misc.php');

global $DB_site, $vboptions, $forumcache;

$limit = "3"; // default number of HotLinks to display in case not set in database

$links_permissions = array();
$links_defaults = array();

$asb = $DB_site->query("SELECT * FROM ".THIS_TABLE."linksadmin");
while ($admin_settings = $DB_site->fetch_array($asb)) {
if (substr($admin_settings["settingname"],0,3) == "can") {
$array = preg_split("/[\s,]+/", $admin_settings["setting"]);
$links_permissions[$admin_settings["settingname"]] = iif(in_array($bbuserinfo[usergroupid], $array), 1, 0);
} else {
$links_defaults[$admin_settings["settingname"]] = $admin_settings["setting"];
}
}

if (isset($links_permissions[can_see_protected_links_on_portal])) {
$cansee = $links_permissions[can_see_protected_links_on_portal];
} else {
$cansee = 0;
}

$thismonth = vbdate("n")-1;
$thisyear = vbdate("Y");
$lastmonth = vbmktime("6","0","0",$thismonth,"1",$thisyear);

$filter = "WHERE link.linkmoderate = 0 AND ldown.usertime > $lastmonth ";

if (!$cansee) {
$limitfids = array(0);
$forumperms = array();
foreach ($forumcache AS $forum) {
$forumperms["$forum[forumid]"] = fetch_permissions($forum['forumid']);
if (!($forumperms["$forum[forumid]"] & CANVIEW) || !($forumperms["$forum[forumid]"] & CANVIEWOTHERS)) {
$limitfids[] = $forum['forumid'];
}
}
$filter .= 'AND link.linkforum NOT IN ('.implode(',', $limitfids).') ';
}

if (isset($links_defaults[categories_seen_on_portal])) {
$catsee = $links_defaults[categories_seen_on_portal];
} else {
$catsee = '';
}
if ($catsee != '') $filter .= 'AND ltoc.catid IN ('.$catsee.')';

if (isset($links_defaults[links_seen_on_portal])) {
$linksee = $links_defaults[links_seen_on_portal];
} else {
$linksee = $limit;
}

$hotquery = "
SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkdesc AS linkdesc,
COUNT(ldown.usertime) AS linkhits, link.linkstatus AS linkstatus,
ltoc.catid AS linkcatid, link.linkhits AS olinkhits
FROM ".THIS_TABLE."linkslink AS link
LEFT JOIN ".THIS_TABLE."linksdownloads AS ldown
ON link.linkid = ldown.linkid
LEFT JOIN ".THIS_TABLE."linksltoc AS ltoc
ON link.linkid = ltoc.linkid
$filter
GROUP BY olinkhits ORDER BY linkhits DESC
LIMIT $linksee
";

$hotties = $DB_site->query($hotquery);

while ($myrow=$DB_site->fetch_array($hotties)) {
$linkid = $myrow["linkid"];
$linkname = parse_bbcode2($myrow["linkname"], 1, 1, 1, 1);
$linkdesc = parse_bbcode2($myrow["linkdesc"], 1, 1, 1, 1);
$linkhits = $myrow["olinkhits"];
$monthhits = $myrow["linkhits"];
$linkstatus = $myrow["linkstatus"];
if ($linkstatus > 1) { // filesize, convert to KB
$linkstatus = intval (round($linkstatus / 1024));
}
eval('$hotlinksbits .= "' . fetch_template('adv_portal_hotlinksbits') . '";');
$nhits++;
}
eval('$home[$mods[\'modid\']][\'content\'] = "' . fetch_template('adv_portal_hotlinks') . '";');
?>

Enjoy!

[MorrisMcD]

Have you installed the Links hack in question ? if so and if you have altered the hack to use a different prefix then you will need to alter this hack file to alter the prefix as well ...

I get this exact error message as well, but I am a newb and have no idea what you are suggesting.. I followed the intructions to the tee.. Not sure what linksadmin is.. Any help would be appreciated much

[Natch]

At the top of your module, you will find something that looks like this...

// ######################## USER-EDITABLE VAR ############################
// If you want to use the standard VBulletin database table prefix, comment out
// the following line and uncomment the line after it
define('THIS_TABLE', 'local_');
// define ('THIS_TABLE', TABLE_PREFIX);
//


Read that set of comments there, and follow the instructions...

HTH

[ricoche]

I get this exact error message as well, but I am a newb and have no idea what you are suggesting.. I followed the intructions to the tee.. Not sure what linksadmin is.. Any help would be appreciated much

I agree with this gentleman. I have no idea what hack or addon this module is for. I installed it thinking it might be for the "Links Directory" addon available on this site, but that just gives me database errors which makes me think otherwise.

Would anyone happen to know what exact addon this is for? I know about vbindex, but not all of the hacks for that CMS.

Thanks kindly,

Jim :)

P.S. Looking for either a "Top 10" or "Latest Links" sideblock for the Links Directory script found on this site. Thanks!! ;)

[Natch]

OK - this is (as it states at the top) a addon module for the Links Directory written by AndrewD, released on vB.org - there is a link at the top of the thread stating this...

If you do not have this hack installed, then this module is of no use to you.

[Brian]

P.S. Looking for either a "Top 10" or "Latest Links" sideblock for the Links Directory script found on this site. Thanks!! ;)
There's one in the hacks forum in the links directory categories. ;)

[Lizard King]

I have it working perfectly .
I just have a small question.I have right now 5 links appear over there but I want more then 5 links to be shown over there (around 15-20) how can i make that change ?

[Natch]

There's a limiting function built in - search in the module for $limit="n"; and cheng "n" to whatever you like - in your example - 15, or 20.

[Lizard King]

I tried like this : $limit = "20"; / "20"; but both didint worked . I used to have vbiAdvanced-links_directory- installed before ı upgraded to cmps and it had 20 links . I dont know what i can do

[Natch]

OK - then you will find the local_links.php script and select "Administer" then enter the number of links you want in the portal there - that will be overriding the setting in the file.

[Zen]

Thanks for the hack, worked first time!

:)

[curetheitch]

Thanks for the hack, worked first time!

:)

Same! Nice hack! :D

[Quelyn]

How many hits does a link have to get to show up on there. I have 2 links in the directory, but none of them are showing up in the side module yet.

[Natch]

Please confirm that you are using the Links hack from vb.org, and not the vbadvanced hack...

[Lizard King]

How many hits does a link have to get to show up on there. I have 2 links in the directory, but none of them are showing up in the side module yet.
It even shows 0 hit files.You just need to have the original hack and configure it from the administer links section...

[Quelyn]

Yes, I have the right hack.
And the LInks show on portal selection is set to 5.

[Chuckie]

in you hotlinks.php file located in your modules folder you can change line 14 to limit the number of links as well.

$limit = "10";


I wrote mine to do random links instead of hot links but the limit code should still be there.

[Natch]

There may have been updates since you got this hack: best bet is to get the latest version of this template, module and the Links hack from vb.org, as that has all the latest controls and configs: that way the AdminCP bit of the Links hack will control the number of links to show on the portal...

[Quelyn]

Yeah I got the latest one, I just downloaded and installed it like less than a week ago. And there IS an option in the Admin control panel for how many links are shown on portal. I have 1.41 which is the latest version.

[Natch]

Only way I can help you further, is to see your forum: can you link me up?

[Quelyn]

Sure what exactly do you need to see, some code stuff? I mean the empty module is running on the front page.
http://www.emocrap.com

[Natch]

I think that I might have discovered the problem: this addon was originally designed as a *download* tracker: and it looks like you have only links: I will need to modify this to include the link *hits* in the count if the item is a link... however, it may be another issue as well.

I have just signed up (username Natch): if you can make a usergroup with access to the links admin, and permissions to see all details of the links hack, and move me into that group, I'll get as much info as I can and test a few things on my own site, then get back to you with a solution.

[thejaxx]

Natch, have you figured out, by chance, how to integrate local_links.php with the rest of CMPS? i.e. as you can with other parts of vb, as outlined here:

http://www.vbadvanced.com/membersarea.php?do=viewmanual&productid=4&pageid=6

The problem with local_links.php is he uses a different scheme for print_output and I cannot, no matter what I try, get it to work. Any ideas?

Has anyone got this working? I sat here for a little bit trying to figure this out myself and I must be either blind or stupid, but havne't been able to get menu's to work at all with the links page.

[Quelyn]

Sorry for the long time in reply, I've been feeding my World of Warcraft Addiction. I added you as a links administrator now. I'm sorry I thought this would work as a link directory thing too :(

[Natch]

The funny thing is, that this hack does not seem to track hits properly...

I would post a bug in the Links hack thread on vb.org, and once it's tracking hits peroperly, it will show up in the list ... you will see that even when you follow the links the hits counter doesn't increment?

[Quelyn]

But it's showing up 10 hits, and 4 hits, I'm not quite sure I know what you mean :(

I just clicked on the link now, and it's showing 11 hits.

[Natch]

Is it possible the account I used to login does not have permissions to view hits?

[Natch]

I clicked on a few Web Comics links, and the tallies didn't go up at all...

[lasto]

anyone help me with this

ive uploaded it but all i get at top of the page is this code

Enjoy!

thats it

looking in the php file i see that text so can anyone tell me why im seeing it on the vmps page ??

[lasto]

ok i hve the hack installed - done everything it says - im not getting no errors but it simply aint showing at all

Any ideas and yeah i do have it activated but nothing at all shows yet other ones ive added work.

[Natch]

Is it possible that your server doesn't recognise <? as a shortcut for <?php

[maniac]

Great hack! Very easy to integrate and install...

Thanks!

Quick question - is there a way to restrict what links are returned and displayed on the module? I basically want to create a link category and then display all of the links on the module - basically to create a secondary navigation bar. I have a bunch of sponsors/partners and I always want them to show up on my home page.

And, instead of actually sending the user to the external link I want to send them to the link description page...

Thanks in advance.

[Natch]

Possible yes: you would need to create a query based on one category only, and structure the ...bits tempalte to link to the content element you want...

[maniac]

Possible yes: you would need to create a query based on one category only, and structure the ...bits tempalte to link to the content element you want...

Thanks natch, I managed to get the script to display onlye the links from a specific category, but now I'm having a hard time figuring out exactly what to edit on the bits template to link directly to the actual link category rather than the external URL. This is something I only want for external sites, not internal links...

I'm not quite surer what variable to put in the href tag...

Thanks in advance for your help

[Natch]

You would need to adjust the query to look up at the parents catid: then create the URL from that...

[burley]

Great hack, i clicked install. But althought it installed without a problem i can't seem to get the Links button on the forum navbar. Below is my navbar template code, looks to me if i'm did everything correctly?!

Can any1 figure out what i did wrong? Why the link button isn't showing up?

<!-- nav buttons bar -->
<div align="center">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
<tr align="center">
<!--<td class="vbmenu_control"><a href="$vboptions[forumhome].php?$session[sessionurl]">Home</a></td>-->
<if condition="$show['member']">
<td class="vbmenu_control"><a href="usercp.php?$session[sessionurl]">$vbphrase[user_cp]</a></td>
</if>
<if condition="$show['registerbutton']">
<td class="vbmenu_control"><a href="register.php?$session[sessionurl]">$vbphrase[register]</a></td>
</if>
<td class="vbmenu_control"><a href="faq.php?$session[sessionurl]" accesskey="5">$vbphrase[faq]</a></td>
<td class="vbmenu_control"><a href="local_links.php?$session[sessionurl]">Links</a></td>
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>
<td class="vbmenu_control"><a href="calendar.php?$session[sessionurl]">$vbphrase[calendar]</a></td>
<if condition="$show['popups']">
<if condition="$show['searchbuttons']">
<if condition="$show['member']">
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a></td>
<else />
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getdaily" accesskey="2">$vbphrase[todays_posts]</a></td>
</if>
<td id="navbar_search" class="vbmenu_control"><a href="search.php?$session[sessionurl]" accesskey="4">$vbphrase[search]</a> <script type="text/javascript"> vbmenu_register("navbar_search"); </script></td>
</if>
<if condition="$bbuserinfo['userid']">
<td id="usercptools" class="vbmenu_control"><a href="#usercptools">$vbphrase[quick_links]</a> <script type="text/javascript"> vbmenu_register("usercptools"); </script></td>
</if>
<else />
<if condition="$show['searchbuttons']">
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]" accesskey="4">$vbphrase[search]</a></td>
<if condition="$show['member']">
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a></td>
<else />
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getdaily" accesskey="2">$vbphrase[todays_posts]</a></td>
</if>
</if>
<td class="vbmenu_control"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td>
<if condition="$bbuserinfo['userid']">
<td class="vbmenu_control"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,menubar=no,toolbar=no,scrollbars =yes,resizable=yes,width=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td>
</if>
</if>
<if condition="$bbuserinfo['userid']">
<td class="vbmenu_control"><a href="login.php?$session[sessionurl]do=logout&amp;u=$bbuserinfo[userid]" onclick="return log_out()">$vbphrase[log_out]</a></td>
</if>
</tr>
</table>
</div>
<!-- / nav buttons bar -->

[PtP]

Absolutely fantastic Natch, any chance of sharing your "latest Uploads" module mate as that would be even more useful than hottest downloads ;)

PS: Your links database has grown into a very functional and feature rich Addon from a small hack, keep up the good work.

[Natch]

Absolutely fantastic Natch, any chance of sharing your "latest Uploads" module mate as that would be even more useful than hottest downloads ;)I'll see if I can upload the template and the module here OK?PS: Your links database has grown into a very functional and feature rich Addon from a small hack, keep up the good work.The links database is not my script: I just wrote the addon. AndrewD is the author of the links database...

adv_portal_newlinks Template:<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<thead>
<tr>
<td class="tcat" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('cmpsnewlies')"><img id="collapseimg_cmpsnewlies" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_cmpsnewlies.gif" alt="" border="0" /></a>
<span class="smallfont"><a name="newlies"></a><strong>$vba_options[portal_blockbullet] <a href="$vboptions[bburl]/local_links.php?$session[sessionurl]">Newest Uploads</a></strong></span>
</td>
</tr>
</thead>
<tbody id="collapseobj_cmpsnewlies" style="$collapseobj_cmpsnewlies">
<tr>
<td class="alt2"><span class="smallfont"><strong>Link</strong></span></td><td class="alt2" align="center"><span class="smallfont"><strong>Date</strong></span></td>
</tr>
$newlinksbits
</tbody>
</table>
<br />
adv_portal_newlinksbits <tr>
<td class="alt1"><span class="smallfont"><if condition="$linkstatus==1"><a href="$vboptions[bburl]/local_links.php?action=jump&amp;id=$linkid" target="_blank">$linkname</a></if><if condition="$linkstatus>1"><a href="$vboptions[bburl]/local_links.php?action=jump&amp;id=$linkid" target="_blank">$linkname</a> [$linkstatus kb]</if><if condition="$linkstatus<=0">$linkname (not available)</if></span></td>
<td class="alt2" align="center"><span class="smallfont"><strong>$linkdaymonth</strong><br />$linkyear</span></td>
</tr>
Then create your module as usual, entering the two templates to prevent uncaching.

HTH

[PtP]

My apologies for the confusion, module installed and I am in love ;)

Thank you very much sir.

[GiJoe]

Anyone know how to get this to key of a specified CatId (Catagory Id)?

[maniac]

Anyone know how to get this to key of a specified CatId (Catagory Id)?

I changed my query so it pulls out links from specified categories by changing this in hotlinks.php:


$filter = 'WHERE link.linkmoderate = 0 ';


to something like this:

If you want to pull from more than one category...

$filter = 'WHERE link.linkmoderate = 0 AND ltoc.catid = 2 OR ltoc.catid = 3 OR ltoc.catid = 4 ';

Or if you want to pull from a single category...

$filter = 'WHERE link.linkmoderate = 0 AND ltoc.catid = 7 ';


Hope this is what you're looking for...

[maniac]

A little nudge please?

I know enough php to get me in trouble, but I'm learing...

My goal was to creaete an instance of hotlinks that retrieved only "x" number of links from a specific category in a specific order. So, I went ahead an changed some stuff in hot links.php, primarily one of the queries and one of the variables, here's what I changed:

$filter = 'WHERE link.linkmoderate = 0 ';
to:
$filter = 'WHERE link.linkmoderate = 0 AND ltoc.catid = 7 ';
And,
$hotquery = "
SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkdesc AS linkdesc,
link.linkhits AS linkhits, link.linkstatus AS linkstatus,
ltoc.catid AS linkcatid
FROM ".THIS_TABLE."linkslink AS link
LEFT JOIN ".THIS_TABLE."linksltoc AS ltoc
ON link.linkid = ltoc.linkid
$filter
ORDER BY linkhits DESC
LIMIT $linksee
";
to:
$hotquery = "
SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkdesc AS linkdesc,
link.linkhits AS linkhits, link.linkstatus AS linkstatus,
ltoc.catid AS linkcatid
FROM ".THIS_TABLE."linkslink AS link
LEFT JOIN ".THIS_TABLE."linksltoc AS ltoc
ON link.linkid = ltoc.linkid
$filter
ORDER BY linkname DESC
LIMIT $linksee
";

Tha works like a charm.

Now, I want to add a second instance of the module to my page with links from a separate category, but I can't get them to display.

I basically created a second php file - called it hotlinks2.php and changed the parameters on my query, but, I get the same results on both modules.

What do I need to change in my second instance of hotlinks.php? I tried creating new templates but that didn;t work either.

A hint or nudge in the right direction would be appreciated.

Thanks in advance!

[Natch]

In the module, try replacing eval('$hotlinksbits .= "' . fetch_template('adv_portal_hotlinksbits') . '";');
with eval('$hotlinksbits2 .= "' . fetch_template('adv_portal_hotlinksbits') . '";');
Then make a new copy of the adv_portal_hotlinks template with the $hotlinksbits renamed to $hotlinksbits2 to match the altered module.