![]() |
|
Mod Options |
![]() |
|||||||||||||||||||||||||||||||||||
[vB3.0.3]+[vBIndex + Links 1.x] Addon: Tie-in for Links Directory beta and vBIndex
![]() Developer Last Online: Apr 2022 ![]() ![]() ![]() 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:
Add After: (if your forums are not in the "forums" directory, you will need to alter this. Either (for the original style):
Or (for the one specific category):
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:
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:
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:
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 Now Only licensed members can download files, Click Here for more information. Screenshots Show Your Support
No members have liked this post.
|
![]() |
||||
Mod | Developer | Type | Replies | Last Post |
[ADDON] cinq's vbArticles Latest 3 Articles VBIndex Block | cinq | vBulletin 3.0 Full Releases | 3 | 04 May 2005 19:01 |
vB Links Directory v3.0 BETA | DrkFusion | vBulletin 2.x Beta Releases | 17 | 22 Apr 2004 17:38 |
Comments |
#2
|
|||
|
|||
Could you be more clear on changing the vbindex.php cause i always get a parse error.
But even without this chang, it works! Thanks for this addon. I got one more question... would it be possible that the shoutbox and the vbcustomblock2 would keep their position after changing into the linksdirectory?
__________________
[HOWTO] integrate your Forum into Opera quicksearch No members have liked this post.
|
#3
|
|||
|
|||
can you add support for vb advanced as well please
![]() No members have liked this post.
|
#4
|
||||
|
||||
I dont use and never thought of using vBAdvanced (I only have one forum to work with, and I use vBIndex) - but if it uses custom blocks in the same way as vBIndex, then the template should be easily modifiable ...
Other than the template, the other changes are the same ... With regards adding the support for the vbadvanced index.php (main homepage) you would need to find the section of that script that deals with the custom blocks, and then add the include statement in that part of the script (so that it only gets included if you have an active customblock) ... Feel free to email me a copy of a vBAdvanced customblock, and a copy of the index.php for vbadvanced and I'll take a look @ it for ya ...
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
Last edited by Natch; 10 Feb 2004 at 09:51. |
#5
|
||||
|
||||
Originally Posted by Tradjick
Mate - I'm not sure how much clearer I can be - feel free to PM me about it and I'll take a look @ your vbindex.php file...
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
|
#6
|
||||
|
||||
Originally Posted by Natch
Hi,
thats good! But I use the Database for Links and Downloads and have two Main Categories. Can I easy modify it to only have the Downloads (And/or) Links. It's not very good to mix them up. ![]() No members have liked this post.
|
#7
|
||||||||
|
||||||||
Originally Posted by Hoffi
Yeah it's possible; its easier if YOU have specifically separated Links and Downloads into different categories: if so, we can change the structure of the query to get items from only one category ... the query becomes more complex, so what I'll do is create a different file to use for the include and get you to test it ok ?
After installing vBIndex, the Links directory and my addon, do the following to Limit to specified Categories: Find in vbindex.php:
REPLACE WITH:
Get the new file attached to this post and edit the variable at the top $cats to match the category ids you wanna include in teh hotlinks list.
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
Last edited by Natch; 14 Feb 2004 at 02:45. |
#8
|
||||||||
|
||||||||
Originally Posted by Natch
yeah, taht works. Thanks. And with a copy named get_hotlinks_link.php I did another Box for Hot Downloads.
No members have liked this post.
|
#9
|
||||
|
||||
Originally Posted by Hoffi
Groovy
![]() ![]() ![]()
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
|
#10
|
||||
|
||||
Could it be:
1) Downloads 2) Links a? No members have liked this post.
|
#11
|
||||
|
||||
Originally Posted by gmarik
Explain your question (and not just the a? bit) ?
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
|
#12
|
|||
|
|||
It does'nt have to do something about your hack but why do I get:
You are not authorized to execute SQL queries ???
__________________
[HOWTO] integrate your Forum into Opera quicksearch No members have liked this post.
|
#13
|
|||
|
|||
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?
__________________
[HOWTO] integrate your Forum into Opera quicksearch No members have liked this post.
|
#14
|
|||
|
|||
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.
__________________
[HOWTO] integrate your Forum into Opera quicksearch No members have liked this post.
Last edited by Tradjick; 17 Feb 2004 at 22:18. |
#15
|
||||
|
||||
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...)
__________________
Natcher00 ... is the Admin @ MobileForces.org - Official Community for a cult Vehicle based FPS - the only place for support! ... also he's Penfold to Dark_Wizard's Danger Mouse in development of vBWar http://www.mobileforces.org/sig.jpg {DaniWeb: Learn HOW-TO mod_rewrite your vB board} No members have liked this post.
|
![]() |
«
Previous Mod
|
Next Mod
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Mod Options | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 16:22.