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

[marandb]

Ok, I am having problems, I am getting this error:

Fatal error: Failed opening required 'forum/get_hotlinks.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/brik/public_html/forum/index.php on line 1041

The "get_hotlinks.php" file is in the forum directory. I know that the "/home/brik/public_html/forum/" is the proper CHDIR_PATH.

What is going on? If I was to try to put the full http path I get another error.

Can someone help??? Please.

Right now the site is up, but there is NO hot downloads counts. (Because I took the refering line out of index.php)

www.brikbattles.com/forum

Thanks,
-- Marand

[Natch]

The only reason why this would not work is a) the file is not there or b) you have modified the file so that it returns errors ...

Please ensure you have both the vBIndex installed properly and the Links Directory installed properly ...

[AndrewD]

Originally Posted by refertech

Any one got any ideas on this one yet?

Thanks,

Mark

Sorted...

Anyone who installed this hack and then installed an updated version of the basic Links and Files Database hack is likely to face the same problem.

Update your links_hotlinks template to the latest version to take into account the fact that Links and Files now tracks file sizes for local downloads.

Please use the attachment as your example.

This corrected template was included in the main Links and Files Download but may have escaped attention here.

[refertech]

Cool. Thanks man.

Mark

[Natch]

Updated post #1 with instructions to ensure everyone installs latest versions of the host hacks before this one will work.

It wasn't overlooked - unfortunately as this is not a "hack" but an addon, the vb.org admins decided that we don't get to provide 'updates' to the users of the hack ...

[marandb]

Hmmm..

Okay, I am getting a # above the title of the custom box (= the custom box #) and the Hottest Downloads doesn't seem to be working at all.

Can anyone help.
www.brikbattles.com

Thanks alot.

-- Marand

[marandb]

Hmmm.... Anyone?

I still have the custom box # displaying above the Title bar & the box will NOT display any downloads???

Can someone help? :ermm:

Thanks
-- Marand

[Natch]

Can I suggest that you paste in a [code] block here the contents of your local_hotlinks template ... that for a start ...

[marandb]

Sure, no prob....

local_hotlinks template:

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

Should be exaclty as listed on the first post.

Thanks alot for any help.

-- Marand

[Natch]

Sorry - what I actually need is the customblock template - sorry ...

Originally Posted by marandb

Sure, no prob....

local_hotlinks template:

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

Should be exaclty as listed on the first post.

Thanks alot for any help.

-- Marand