[vB3.0.3]+[vBIndex + Links 1.x] Addon: Tie-in for Links Directory beta and vBIndex

NOTE: this has been integrated into the Links Directory hack - this version will noit be kept up to date!

WHAT THIS DOES:

It combines the excellent Links Directory 0.95 beta created by AndrewD and the unparalelled vBIndex by NTLDR to give you a "Hottest Downloads" customblock for your vBIndex powered homepage.

New Files: 2
forumhome/get_hotlinks.php << to have top # of all links / downloads
forumhome/get_hotlinks_cat.php << To have top # from one specific category

Files to Edit: 1
vbindex.php or whatever you renamed it to

DEPRECATED @1.00 - THIS TEMPLATE NOW INCLUDED IN THE LINKS HACK
New Templates: 1
links_hotlinks

Templates to edit: 1
vbindex_customblock_1 or whatever your first free customblock is

DEPRECATED @0.95 THIS QUERY NO LONGER NEEDED
SQL Queries to run: 1
This is simply to alter a field from "TEXT" to "MEDIUMINT(8)" for storing the hit-tracker

=============
INSTRUCTIONS:
=============
In vbindex.php (or whatever you have renamed it):

Find:

// ####################### GENERATE SIDE BAR ##########################
// ## CUSTOM BLOCKS
if (!empty($vbindex['customboxes'])) {

Add After: (if your forums are not in the "forums" directory, you will need to alter this.
Either (for the original style):

PHP Code:

    $hotlinks = require('forums/get_hotlinks.php'); 


Or (for the one specific category):

PHP Code:

    $hotlinks = require('forums/get_hotlinks_cat.php'); 


Upload the files get_hotlinks.php and get_hotlinks_cat.php to your forumhome folder
NOTE: if you want more than 5 links listed, please edit the $limit variable at the top of this file.
NOTE: If you are using the standard 0.95 TABLE PREFIX or the VB table prefix, make the appropraite alrterations @ the top of your new files
Edit vbindex_customblock_1 (or your chosen customblock) to match the contents of the text file in the attachment
Contents here for the hell of it:

PHP Code:

<table cellpadding="0" cellspacing="0" border="0" class="tborder" width="100%">
    <tr>
        <td>
            <table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
                <tr>
                    <td colspan="2" class="tcat" style="text-align: center">
                        <a name="hotties" style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('vbindex_customblock$box')"><img id="collapseimg_vbindex_customblock$box" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_vbindex_customblock.gif" alt="" border="0" /></a>
                        <strong><a href="$vboptions[bburl]/local_links.php" title="Visit the Downloads section">Hottest Downloads</a></strong>
                    </td>
                </tr>
                <tbody id="collapseobj_vbindex_customblock$box" style="$collapseobj_vbindex_customblock">
                    $hotlinks
                </tbody>
            </table>
        </td>
    </tr>
</table>
<br /> 


DEPRECATED @1.00 - THIS TEMPLATE NOW INCLUDED IN THE LINKS HACK
Create a new template called links_hotlinks and populate it with the contents of the text file in the attachment
Contents here for the hell of it:

PHP Code:

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


DEPRECATED - IF YOU HAVE INSTALLED 0.95, THIS IS NO LONGER NECESSARY
Run the query that is contained in the SQL_QUERY.txt file in the attachment
Contents here for the hell of it:[sql]ALTER TABLE `local_linkslink` CHANGE `linkhits` `linkhits` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL;[/sql]

UPDATED 25-02-2004:

Fixed a bug pointed out by Hoffi in the category specific file which caused multimples to appear - both files now use a DISTINCT select for the query.

Enjoy y'all

! MAKE SURE YOU HAVE THE LATEST VERSIONS OF BOTH INSTALLED !

[Natch]

Originally Posted by Hoffi

It works with the actual Version.
There is a small Bug in the Category Version. If a Link/Download is in two Categories It will show twice in the Box. Just Add a distinct in the SELECT clause.

Thx Hoffi I'll rectify the original post to include both versions and instructions on how to use them ....

[Natch]

This hack updated @ 25-02: upgrade to 0.95 - the only thing you need to do is re-upload the get_hotlinks.php and/or get_hotlinks_cat.php files, and re-add the links_hotlinks template and you should be back up and running ...

[Natch]

Should work just fine with V1.00 thanks to AndrewD for the inttegration of the hotlinks template

[achtungbaby]

thumbs up

[ixian]

Natch,

I converted this over to vbAdvanced, and also added an option to order the lists by latest date rather than number of hits.

It's rather large, so I'll post it separately, with all credit to you of course. Please let me know if you mind me doing this.

[refertech]

Can someone help to tell me what i did wrong. I keep getting the following error.

Warning: main(forum/get_hotlinks.php): failed to open stream: No such file or directory in /home/plmtech/public_html/forum/vbindex.php on line 1040

Fatal error: main(): Failed opening required 'forum/get_hotlinks.php' (include_path='/usr/local/lib/php:.') in /home/plmtech/public_html/forum/vbindex.php on line 1040

[ixian]

Originally Posted by refertech

Can someone help to tell me what i did wrong. I keep getting the following error.

Warning: main(forum/get_hotlinks.php): failed to open stream: No such file or directory in /home/plmtech/public_html/forum/vbindex.php on line 1040

Fatal error: main(): Failed opening required 'forum/get_hotlinks.php' (include_path='/usr/local/lib/php:.') in /home/plmtech/public_html/forum/vbindex.php on line 1040

Looks like you got the path to get_hotlinks.php wrong - you have it as "forum" where it should be the full path to the forum directory.

[refertech]

Yea, I'm silly. I got it.

Thanks for your help thou.

But for some reason 3 of the links are showing not available but I know they are good cause they work fine in my links section. Anyone got any ideas why 2 of them work and the last 3 dont. I'm scratching my head.

Thanks.

Mark

[refertech]

Originally Posted by refertech

But for some reason 3 of the links are showing not available but I know they are good cause they work fine in my links section. Anyone got any ideas why 2 of them work and the last 3 dont. I'm scratching my head.


Mark

Any one got any ideas on this one yet?

Thanks,

Mark

[Natch]

Check this one out with the author of the Links hack ... AndrerwD supports his hack - I'm not as up-to-speed with how his hack works to support it fully ....