[vB3.0.3]+[vBIndex + Links 1.x] Addon: Tie-in for Links Directory beta and vBIndex
This modification is in the archives.
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: Code:
// ####################### GENERATE SIDE BAR ########################## // ## CUSTOM BLOCKS if (!empty($vbindex['customboxes'])) { Either (for the original style): PHP Code:
$hotlinks = require('forums/get_hotlinks.php');
PHP Code:
$hotlinks = require('forums/get_hotlinks_cat.php');
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%">
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>
Run the query that is contained in the SQL_QUERY.txt file in the attachment Contents here for the hell of it: SQL Query: (how to run queries)
ALTER TABLE `local_linkslink` CHANGE `linkhits` `linkhits` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL; 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 ! Download This modification is archived and cannot be downloaded. Screenshots
|
Similar Mods
[ADDON] cinq's vbArticles Latest 3 Articles VBIndex Block | vBulletin 3.0 Full Releases |
vB Links Directory v3.0 BETA | vBulletin 2.x Beta Releases |