vB Links Directory 2.0 *NEW VERSION*

[high]vB Link Directory v2.0[/high]*new*

[high]News on new versions[/high]
? vB Links Directory 2.0 Build 250 is almost here, it summarizes all the fixes, and has template fixes including spelling fixes new template look, template look fixes, and over all some organization of the templates.
? vB Links Directory 3.0 development is complete. We will be releasing this privatly to select few, and will be discussing futher public release later on.

[high]What Does it do?[/high]
This hack allows you to have a database of links, you add catagories and users may add there site, this is sort of a Links Management, but more organized and attractive, with easy to use admin panel, built in search panel and more.

This Hack should work on ALL 2.2.x versions.
Please check out the features list below, for a list of new admin, and user features.

[high]Installation:[/high]
- Open readme.txt and follow the instructions
- Upload links.php to your forum root, and weblinksadmin.php to your forum admin dir.

[high]Screenshots:[/high]
- AdminCP : View Catagory and Options
- AdminCP : View Links in Catagory
- AdminCP : Validate vB Option
- AdminCP : Validate New Links
- Main : Links Directory Home
- Main : View Links in Catagory
- Main : Error when Not Registered and Trying to add link
- Main : Add New Link to DB
- Main : Error when Field from adding a link is missing
- Main : Search Results

All copyright notices must stay intact, all links, and messages in templates must be included in order for legal use of this modification.

[high]Features:[/high]
Admin CP::
? View Catagories
? Edit Catagories
? Remove Catagories
? Add New Link
? Edit Link
? Remove Link
? View ALL Links in database as bulk (With Catagory information)*new*
? Link Validation (Option to turn off)*new*
Public::
? View Catagory
? Browse Catagory
? Visit Links
? Add Link
? Search Link Database *new*
? View Top 10 Visited Links *new*
? View Last 10 Added Links *new*

SUPPORT FOR THIS HACK WILL ONLY BE PROVIDED IN THIS THREAD, AND IN THIS THREAD ONLY.

If you use this hack on your site please click Install, so proper support, and upgrades can be provided for you. Thanks

[high]QUERIES GENERATED[/high]
- Main Links Directory Page (11 Queries STANDARD )
- Viewing Links in Catagory (10 Queries STANDARD)
- Search (7 Queries Standard)
- Search Results (9 Queries Standard)
- Top 10 Visited Links (9 Queries Standard)
- Last 10 Added Links (9 Queries Standard)
STANDARD = doesn't change with more cats, link etc

[high]VERSIONS[/high]
v2.0 - Major Bug Fixes, new search engine, admin validation, and many new coding enhancements, and new features added
v1.03 - Minor Bug Fixes in Admin File
v1.02c - New Standard Build

[high]Updates[/high]
11/7/2002
If you are running the previous version, there are upgrade instructions in the zip.
I have included also a new 'Installer', 'Un-Installer' and 'Upgrade' Feature to reduce hassle, and help you upgrade your version, install a new copy, or uninstall at ease. If any problems occure, please PM me immediatly.
11/8/2002
Minor mistake in Top 10 Visited Sites, if you have validation enabled, pleae download the new zip, and overwrite the links.php with the new one, if you don't...I would suggest you still download the new links.php and overwrite it.
11/8/2002
There was a little error in Top 10 Visited sites, if you downloaded the zip after the new zip file, please download this new zip file, and replace the links.php file with the one in this zip.
11/11/2002
There was an error with the code in the upgrade file, if you upgraded, and the hack didn't work, please run this query in PhpMyAdmin
SQL Query: (how to run queries)
ALTER TABLE gportal_weblinkslink ADD hits VARCHAR (255) NOT NULL, ADD valid int(11) DEFAULT '1' NOT NULL

7/10/2002
Database field error. Some fields in the links table, including hits, link url etc, are of wrong value, and on the Top 10 Links when a site gets 99 hits, it will go back to 0 hits and start again. If you have installed vB Links Directory before July 10th 2003 then please CLICK HERE to download the file db_fix.php. Follow the instructions in the post.


AFTER INSTALLATION YOU MUST GO TO VBULLETIN OPTIONS, AND SUBMIT THE OPTIONS, AFTER YOU CHANGE THE VALIDATION OPTION. THIS IS MANDATORY, DO THIS EVEN IF YOU WISH TO HAVE VALIDATION.

Also out of respect I ask that you please do not release revamped versions of this hack as a new one, I have put countless hours into working on the basic functions, and coding it, and I would really be dissappointed. Thanks

Enjoy!
mfInc
http://www.zunepoint.com
- Microsoft Zune Source - Win a free Zune Player
CLICK HERE TO DOWNLOAD THE ZIP
CLICK HERE - If you installed this hack to receive updates, patches, and support

[DrkFusion]

Originally posted by AndrewD
Minor comments/buglets/suggestions for sometime in the future. Sorry if these seem pedantic

A standard navigation bar - yes I do think this is needed - no more than $bburl -> Links - otherwise it's inconsistent

There's a bug when using admin CP View/Edit links to modify category names/descriptions, if some html magic characters appear (e.g. &) - each time through the edit, the character gets remapped, so one ends up with & amp; amp; etc

All the dropdown category lists should be in alphabetical order

The doneaddlink template is missing a couple of closing </table> tags

thanks

Its not missing any it has too many I have this fixed, but didn't think anyone else would have this prob, I will look into the remapp problem, I have tested these out and 2 sorts of servers, but I can never guess how they will work in different conditions :-/

-Arunan

[DrkFusion]

Originally posted by trilOByte
Hey Drk fusion, I wonder if you can help? I'm having a little problem with the templates. I've enclose my forum in a border, via the header/footer, but on *some* of the vBlinks pages the footer displays outside of the border and I cant for the life of me figure why.

The search page is fine, but the main page shows the footer outside of the border.

Take a look...

http://www.britishblades.com/forums/links.php

Hi, the solution for this is on couple of pages before, the last instance of </td></tr></table> I believe should be removed off in all templates this problem occurs in.

[Visionray]

Originally posted by NuclioN
After upgrading i get this error when i click on a category

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT * FROM gportal_weblinkslink WHERE catagoryid=3 AND valid='1' ORDER BY linkname
mysql error: Unknown column 'valid' in 'where clause'

mysql error number: 1054


----oops, problem solved! old links en cats removed, upgrade again, all went well. Great update -----

Hey guys,

I just upgraded. Im getting the same exact error when I click on a category or when I click on search. I don't understand your explanation to fix it. What is "en cats"? How do I fix this?

Im running 2.2.8


Thanks

[trilOByte]

Originally posted by DrkFusion

Hi, the solution for this is on couple of pages before, the last instance of </td></tr></table> I believe should be removed off in all templates this problem occurs in.

Bingo! Thanks

[Visionray]

Ok actually I just uninstalled everything and reinstalled and it seems to be working great now. I have no idea why the upgrade wouldn't work.

There are a couple of questions that I have.


1. Is there any way to arrange the order of category list? Is there a way to move one category down the list etc? This would really be helpful for me because I have about 20 categories I am going to add, and they are all three distinct separate subjects. Right now, my categories are in no coherent order and it would be great if I could organize them into sections...for example,

-----------------------------------------------
1. Film

Category 1
Category 2
Category 3

2. Digital Video

Category 1
Category 2
Category 3

3. Web

Category 1
Category 2
Category 3
--------------------------------------------------

Im not really talking about "sub categories"...just arranging the main categories on the main list. When they are all put in alphabetical order, there is no order to the categories. I know this may be a lot to ask, but I really really think this would increase the usabilty of your hack.



Question 2.

How do you validate the links? THis may be a dumb question, but...I have validation set to "yes". I tried submitting a link on the actual links page. It didn't show up which is correct...and it shows up in my admin cp which is correct...but how do I go about making this link valid? I don't see any option to do that anywhere.


Suggestion.....

You misspelled "category" on a lot of pages that show up not only in the admin PC, but on the links page. You have it as "catagory". Not really a big deal but you might want to fix that just to make it perfect.

Thanks for all the help. Great hack indeed!

[DrkFusion]

For the catagories to be moved up or down, new field has to be added, where the order can be specified, I can work on something like this specifically for you, and other who want it, if you wish.

-Arunan

[Visionray]

:banana: That would be awesome if you could do that!

[DrkFusion]

I made a big mistake with the upgrade :-/ it added the new values to the cat table, not the links table, the zip is fixed.

[DrkFusion]

Ok, if you upgraded latly, and the hack didn't work, please see the updates section on the first post for how to fix this.

Thanks, and sorry
-Arunan

[Visionray]

oops, I just found the validate link option in the CP...for some reason I missed it. Sorry about that.

[DrkFusion]

The vB option have to be set, so the change take place, if validation is set in your vB option, then the validate link will appear, if it isn't the Validate Link will not apear

[ricoche]

Great addon. Thanks a lot for this.

I installed it and everything works just fine on vbulletin 2.2.8!

Thanks again,

Ricoche

[DrkFusion]

Your welcome Ricoche, have fun, and report any problems in this thread.

[ricoche]

I'm not sure if this is a problem or not and this also could be just my system.

After clicking a few links to try this out I notice it kept reloading my site. For a while there I thought the script wasn't working and then while sitting there for a moment longer I noticed it kind of redirected itself to the actual link.

My minor concern here is that my users will think the link is broken because it's reloading my site. There is a message there that says "one moment please..." but it kind of fooled me because it was very small and the link wouldn't load until after my site finished reloading.

Is this normal or might there be some system problem I'm having.

I love this script because it looks much nicer than my vbportal version but I wish it would load the new site first and not reload my site.

Oh well, I'll keep toying with it.

Thanks again,

Ricoche

[Kohhal]

Originally posted by ricoche
... There is a message there that says "one moment please..." but it kind of fooled me because it was very small and the link wouldn't load until after my site finished reloading....

You are supposed to get this intermediate page, I suspect it's because the database is being updated with no. of hits the link has received. It's the same reason there are intermediate pages after posting in vbulletin etc. to give the database a chance to be written to.

HTH, G :rambo:

[JakeC]

After clicking a few links to try this out I notice it kept reloading my site. For a while there I thought the script wasn't working and then while sitting there for a moment longer I noticed it kind of redirected itself to the actual link.

Is there any way around this? I see this as being a real annoyance to my users, especially ones on dial-up. On broadband you can't even see what the page is even supposed to say it sort of just blinks on then off when the new page loads. Which is sort of annoying as well. Great hack by the way. Thanks.

JakeC

[DrkFusion]

You could always give up tracking hits

[MonsterDK]

I have installed the hack. appears in admin controll fine and displays fine in admin. But on the main board I don't see a sign of it.....ummmm help me please

Please note that i'm new to all this, so I am a learner! :surprised:

I have VB 2.2.8

here is what I did..... edited all the files adminfunctions, index, template. deleted and updated the files with the newly edited ones.
did the vbldir_install which went fine. Deleted the vbldir_install file as per instructions.
uploaded templates what come with the .zip for the hack, into the vbulletin root. Copied links.php into vbulletin root.
Copied weblinksadmin.php into admin folder

Thanks, MonsterDK

[x8oz]

does vb links support a user permission (user masks) or can you enable a password on a vblinks forum? basically to restrict access to a certain weblink forum?

[CtrlAltDel]

good stuff man, nick hack
you just saved me a lot of time

[Kohhal]

Originally posted by MonsterDK
I have installed the hack. appears in admin controll fine and displays fine in admin. But on the main board I don't see a sign of it.....ummmm help me please...

You need to create a link to it yourself and put it somewhere on your main index or homepage. The link to the directory should be something like http://www.yoursite.com/forum/links.php

HTH,

G :rambo:

[MonsterDK]

Sorry but i'm new at this.
Do I edit the index.php in the root on vB or do you mean link it into a index.htm page that links to the board itself?

With it saying..
iii.) To view ALL the Links in the Database, click 'View ALL Links'
link under the Vb Link Directory Nav.
I'm confused how linking to an index.htm will ensure its appearance there.

Help me please.

[DrkFusion]

Originally posted by MonsterDK
I have installed the hack. appears in admin controll fine and displays fine in admin. But on the main board I don't see a sign of it.....ummmm help me please

Please note that i'm new to all this, so I am a learner! :surprised:

I have VB 2.2.8

here is what I did..... edited all the files adminfunctions, index, template. deleted and updated the files with the newly edited ones.
did the vbldir_install which went fine. Deleted the vbldir_install file as per instructions.
uploaded templates what come with the .zip for the hack, into the vbulletin root. Copied links.php into vbulletin root.
Copied weblinksadmin.php into admin folder


Thanks, MonsterDK

You do not upload the templates that came with the zip, they are only there for refrence if you want to edit.

go to your admin panel, and add new catagories.

[DrkFusion]

Originally posted by x8oz
does vb links support a user permission (user masks) or can you enable a password on a vblinks forum? basically to restrict access to a certain weblink forum?

The only permission I have bothered to put is you have to be registered, activated and not a COPPA user. Password protection and other sorts will not come in use to the majority of the people who use this hack, so it will not be made a default addon, unless 51% of the people who installed want it.

[DrkFusion]

Originally posted by CtrlAltDel
good stuff man, nick hack
you just saved me a lot of time

Thanks CTRLALTDEL

[DrkFusion]

SubForums are done, I will get people to beta it, and post screenshots, and release it soon!

[Cyberhouse]

Installed

Very nice hack DrkFusion!

[DrkFusion]

Thank You Cyberhouse

[Kohhal]

This is a great hack, there's just a couple of small things outstanding that I think it needs:

- When validating a link, the category should be shown with the option of changing it if it's in the wrong place, same thing for edit link

- hits still increment by 2 each time

- no. of links shown beside each category would be nice

With these options added/fixed this hack would be complete for me, I don't really have a need for what's coming in the next upgrade.

Thanks again and if you can help with the above that would be great,

G :rambo:

[DrkFusion]

There should be a problem for incrementing my 2, my other sites have not had this problem, and no one else has had this problem, if you have not upgraded, I would suggest trying to upgrade.

[Dark_Wizard]

Originally posted by DrkFusion
SubForums are done, I will get people to beta it, and post screenshots, and release it soon!

I'm ready for the beta test...I will be on AIM today...

[cklaszlo]

Trying to Download and Install but the link to the .ZIP is broken from the first post.

Actually there is a problem with the .ZIP link. If you link via the IP and not the URL it downloads fine. Might be on my end.

This is a great hack. Installed really well. One thing. In the READ ME it never says to upload link.php to the board dir and to link to that for the actual web link directory.

Are you going to add sub catagories to this? Or is this what this is (lol) :

"SubForums are done, I will get people to beta it, and post screenshots, and release it soon!"

Cause if thats the case I would like to test it too.

Thanks!!!

[DrkFusion]

Upload Links.php to the forum root, and weblinksadmin.php to ur admin.

Subforums will be added soon.

[DrkFusion]

ATTENTION ALL VBHOME(LITE) USERS
If you use vBHome(lite) (by:TECK) check out http://www.teckwizards.com for more information on how to integrate this Links Directory into your vBHome!
You must be liscensed vb user, so you will get access to the addons forum at TeckWizards.

See Below for Screenshot

[Goldknight]

lol @ Drfusion, not bad but I already do that with myvbindex, it aint that hard. Good one

[Crinos]

Originally posted by TheMasterG
- When validating a link, the category should be shown with the option of changing it if it's in the wrong place, same thing for edit link

Yeah, this is what's preventing me from making the "submit link" feature available to the public (I have it commented out) Is this already addressed in the recent update, Drk?

Great hack, nevertheless...

[DrkFusion]

Yes It is, I will be re coding the validate option fully, as the current version is really unappropriate for huge links that are added.

[DrkFusion]

Originally posted by Goldknight
lol @ Drfusion, not bad but I already do that with myvbindex, it aint that hard. Good one

Yes very :-D

[Kohhal]

Originally posted by DrkFusion
There should be a problem for incrementing my 2, my other sites have not had this problem, and no one else has had this problem, if you have not upgraded, I would suggest trying to upgrade.

-Arunan

I've compared my links.php to your latest one from vblinksdir2012.zip and the only difference is the chdir I added as I have my links.php outside my forums directory ( chdir("./forum"); )

Is it possible that this is causing my hits counter to increment by 2 each time? If so, have you any idea how I could fix this????

TIA,

G :smoke:

Edit: I also got this database error today? :

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM gportal_weblinkslink WHERE catagoryid= AND valid='1' ORDER BY linkname
mysql error: You have an error in your SQL syntax near 'AND valid='1' ORDER BY linkname' at line 1

mysql error number: 1064

Date: Thursday 21st of November 2002 07:43:45 AM
Script: http://www.-------------/forum/links...ks&amp;catid=1
Referer: http://aolsearch.aol.co.uk/web.adp?q...nufacturers...

Any idea what caused that, the hack is working well but obviously one of my users triggered something the database didn't like?

[cklaszlo]

Is it possible to add a "New" image next to new links and also next to the main catagories if there are new links in the respective cats?