The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
[vB3.0.3]+[vBIndex + Links 1.x] Addon: Tie-in for Links Directory beta and vBIndex Details »» | |||||||||||||||||||||||||||
[vB3.0.3]+[vBIndex + Links 1.x] Addon: Tie-in for Links Directory beta and vBIndex
Developer Last Online: Apr 2022
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:
PHP Code:
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:
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:
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 ! Show Your Support
|
Comments |
#12
|
||||
|
||||
Quote:
|
#13
|
|||
|
|||
It does'nt have to do something about your hack but why do I get:
You are not authorized to execute SQL queries ??? |
#14
|
|||
|
|||
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? |
#15
|
|||
|
|||
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. |
#16
|
||||
|
||||
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...)
|
#17
|
||||
|
||||
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
|
#18
|
||||
|
||||
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?
|
#19
|
||||
|
||||
Quote:
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 ? |
#20
|
||||
|
||||
Why rude? I'm just expressing short my idea and I do will release my hacks, when the Gold comes out ...
|
#21
|
||||
|
||||
Quote:
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. |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|