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.