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

Could it be:
1) Downloads
2) Links

a?

Explain your question (and not just the a? bit) ?

[Tradjick]

It does'nt have to do something about your hack but why do I get:

You are not authorized to execute SQL queries

???

[Tradjick]

i ran the query in phpmyadmin and now i get this as an error on index.php:


Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
SELECT link.linkid AS linkid, link.linkname AS linkname, link.linkdesc AS linkdesc,
link.linkhits AS linkhits, link.linkstatus AS linkstatus
FROM vb3_local_linkslink AS link
ORDER BY linkhits DESC
LIMIT 5

mysql error: Table 'vbullet.vb3_local_linkslink' doesn't exist

mysql error number: 1146

Date: Tuesday 17th of February 2004 10:04:06 PM
Script: http://localhost/index.php?
Referer: http://localhost/forum/index.php?
Username: Abrel_Knezquawr
IP Address: 127.0.0.1

Any ideas on this?

[Tradjick]

maybe it's because i did this with the new 0.95 version from AndrewD???

edit: now that i deleted that require line from vbindex.php everything works fine.

[Natch]

I haven't modified this to test it with v0.95 yet ... but the SQL query may have had problems if you were running it after v0.3 as v0.3 didn't require you to run that step (the instructions in the upgrade to 0.3 from AndrewD were pretty clear on that...)

[Natch]

The new version upgrade tool from AndrewD deleted the template - so you will need to re-add the template "links_hotlinks" - after doing that, the addon WILL WORK

[gmarik]

Not only show the latest downloads (with some more meta data, not only the name, also the filesize and date atleast), but a link catalogue as well. Got it?

[Natch]

Originally Posted by gmarik

Not only show the latest downloads (with some more meta data, not only the name, also the filesize and date atleast), but a link catalogue as well. Got it?

OMFG gmarik : I have seen a lot of posts by you (or someone using your account), and they are all rude and close to being insulting ...

If you are not going to participate by either writing or supporting hacks, or by providing helpful and constructive criticism, BACK OFF and let us do our work ... (unless you are gonna pay $$$, in which case you can be as rude as you like) ...

Got it ?

[gmarik]

Why rude? I'm just expressing short my idea and I do will release my hacks, when the Gold comes out ...

[Hoffi]

Originally Posted by gmarik

Why rude? I'm just expressing short my idea and I do will release my hacks, when the Gold comes out ...

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.