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

[Lionel]

I got it install no problem on the gold release, it is just the $linkhits that does not display on advanced page. I get []. All permissions are set and it does display on main page.

[Natch]

Originally Posted by Lionel

I got it install no problem on the gold release, it is just the $linkhits that does not display on advanced page. I get []. All permissions are set and it does display on main page.

You mean on vBAdvanced ?

[Lionel]

yes vbadvanced

[marandb]

vbindex_customblock_1 (template used)

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

Thanks,
-- Marand

[Natch]

Originally Posted by Lionel

yes vbadvanced

Lionel - this is the hack that ties in with vBIndex, not vBAdvanced - there is a very different hack that works with vBAdvanced ...

[Natch]

Originally Posted by marandb

vbindex_customblock_1 (template used)

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

Thanks,
-- Marand

It seems that you have some problems with your copy of the get_hotlinks.php file ... the value of the variable is "1", not the list of links ...

Can you confirm that you are using the latest versions of the get_hotlinks.php file ?

[marandb]

Hmm.... Just uploaded the newest (downloaded from the first post in this thread) get_hotlinks.php file. Haven't seen a newer one than that.

Still the same result.

The # above the title bar (Hottest Downloads) is the Custom Block #. Example: changes to 2 is I use Custom Block 2.

Thanks again,
Any help is appreciated. Would be REALLY nice to get this up & running soon.

-- Marand

[Lionel]

Originally Posted by Natch

Lionel - this is the hack that ties in with vBIndex, not vBAdvanced - there is a very different hack that works with vBAdvanced ...

Ouch, I got confused by the mention of your name on the other hack.

[hopester]

Was there any fix for the problem Marand had above as I have exactly the same problem?

Thanks

[Natch]

Are you running the latest version of the Links DB ?