[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]

On looking into it further, it looks unlikely to be related to php version or sql version ...

If you have tried uninstalling both hacks, then reinstalling from scratch, please let me know and I'll get access details to take a look @ your files / templates.

I know this is taking some time to get resolved, but there is no simple answer ..

[T3MEDIA]

What exactly does this do? A download page linker?
Not sure what this does completely.

[AndrewD]

Originally Posted by T3MEDIA

What exactly does this do? A download page linker?
Not sure what this does completely.

The Links/Files database in the Major Additions provides a full system for handling file downloads + web links database. This provides an interface between that hack and VBindex. It is now integrated into Links/Files