Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
[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
Mod Version: 1.00, by Natch (Member) Natch is offline
Developer Last Online: Apr 2022 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.1 Rating: (0 vote - 0 average) Installs: 5
Released: 08 Feb 2004 Last Update: Never Downloads: 1
Not Supported  

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Add After: (if your forums are not in the "forums" directory, you will need to alter this.
Either (for the original style):

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Or (for the one specific category):

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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

Click image for larger version

Name:	screenshot.jpg
Views:	757
Size:	42.8 KB
ID:	16607  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
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  
Old 10 Feb 2004, 08:07
Tradjick Tradjick is offline
 
Join Date: Jan 2004
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?
Reply With Quote
  #3  
Old 10 Feb 2004, 09:04
PixelFx PixelFx is offline
 
Join Date: Dec 2002
can you add support for vb advanced as well please
Reply With Quote
  #4  
Old 10 Feb 2004, 09:46
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
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}

Last edited by Natch; 10 Feb 2004 at 09:51.
Reply With Quote
  #5  
Old 10 Feb 2004, 09:50
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Originally Posted by Tradjick
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?
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}
Reply With Quote
  #6  
Old 13 Feb 2004, 22:41
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
Originally Posted by Natch
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...
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.
Reply With Quote
  #7  
Old 14 Feb 2004, 01:57
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Originally Posted by Hoffi
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.
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

REPLACE WITH:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
Attached Files
File Type: zip get_hotlinks_cat.zip (972 Bytes, 12 views)
__________________
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}

Last edited by Natch; 14 Feb 2004 at 02:45.
Reply With Quote
  #8  
Old 15 Feb 2004, 13:50
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
Originally Posted by Natch
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

REPLACE WITH:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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.
yeah, taht works. Thanks. And with a copy named get_hotlinks_link.php I did another Box for Hot Downloads.
Reply With Quote
  #9  
Old 15 Feb 2004, 21:28
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Originally Posted by Hoffi
yeah, taht works. Thanks. And with a copy named get_hotlinks_link.php I did another Box for Hot Downloads.
Groovy glad that worked
__________________
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}
Reply With Quote
  #10  
Old 17 Feb 2004, 15:00
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
Could it be:
1) Downloads
2) Links

a?
Reply With Quote
  #11  
Old 17 Feb 2004, 15:09
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
Originally Posted by gmarik
Could it be:
1) Downloads
2) Links

a?
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}
Reply With Quote
  #12  
Old 17 Feb 2004, 18:48
Tradjick Tradjick is offline
 
Join Date: Jan 2004
It does'nt have to do something about your hack but why do I get:

You are not authorized to execute SQL queries

???
Reply With Quote
  #13  
Old 17 Feb 2004, 20:08
Tradjick Tradjick is offline
 
Join Date: Jan 2004
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?
Reply With Quote
  #14  
Old 17 Feb 2004, 20:21
Tradjick Tradjick is offline
 
Join Date: Jan 2004
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.

Last edited by Tradjick; 17 Feb 2004 at 22:18.
Reply With Quote
  #15  
Old 17 Feb 2004, 22:27
Natch's Avatar
Natch Natch is offline
 
Join Date: Nov 2002
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}
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:22.

Layout Options | Width: Wide Color: