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

[Alien]

Still the same problem unfortunately. I submitted the 'validate' thing in options, and all files are hacked perfectly. I can click on "Add Category" without error, and submit a category with no error. I cannot click on 'links' to add a link though without that error above. When I also click on "view all links" it brings up the error again. Fix make work!

Here's those errors:

When clicking on "Add new Link -> Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

------------------------

When clicking on "View ALL Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

-Jason

[Dark_Wizard]

Today at 04:38 AM Alien said this in Post #651
Still the same problem unfortunately. I submitted the 'validate' thing in options, and all files are hacked perfectly. I can click on "Add Category" without error, and submit a category with no error. I cannot click on 'links' to add a link though without that error above. When I also click on "view all links" it brings up the error again. Fix make work!

Here's those errors:

When clicking on "Add new Link -> Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

------------------------

When clicking on "View ALL Links"

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

-Jason

Hmmm...these are the files from Keptic so something isn't right...I will look into it and get back to you...

[Alien]

Thanks so much.

His original 2.0 series installed fine for me and worked. I'm doing a completely fresh install each time with your files, figured that would help in the troubleshooting...

[Dark_Wizard]

Today at 11:12 AM Alien said this in Post #653
Thanks so much.

His original 2.0 series installed fine for me and worked. I'm doing a completely fresh install each time with your files, figured that would help in the troubleshooting...

Try this file...

[Dark_Wizard]

Version 3.0 is running on my site now http://www.dpclan.com/forums/links.php

[Alien]

v3 Looks real nice, I can't wait...

As for the previous issue, still problems:

Clicking on "View/Edit":

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
ORDER BY catid

mysql error: Unknown column 'catid' in 'order clause'

mysql error number: 1054

----------------------------------------------

Clicking on "Add new Link"

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
ORDER BY catid

mysql error: Unknown column 'catid' in 'order clause'

mysql error number: 1054

----------------------------------------------------

Clicking on "View ALL Links":

Database error in vBulletin Control Panel 2.3.0:

Invalid query id specified
mysql error:

mysql error number: 0

Hmm.

-Jason

[Dark_Wizard]

These are the same files that Keptic posted...if I wasn't so busy with 3.0 I would rewrite 2.0's admin piece...

[Alien]

Strange indeed... When I install 2.x it works fine, it was always 2.5 that I just couldn't get to work.. Must be something we're missing.. I could just be jinxed. :P

[raxafarian]

Yesterday at 02:40 PM Alien said this in Post #658
Strange indeed... When I install 2.x it works fine, it was always 2.5 that I just couldn't get to work.. Must be something we're missing.. I could just be jinxed. :P

I just installed 2.5 and get the same errors you have listed:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

Date: Wednesday 30th of July 2003 12:31:40 AM
Script: http://thedecostop.com/forums/forums...elinks&catid=1
Referer: http://www.thedecostop.com/forums/ad...nksadmin.php?&

[Dark_Wizard]

Today at 01:34 AM raxafarian said this in Post #659
I just installed 2.5 and get the same errors you have listed:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL:
SELECT *
FROM gportal_weblinkscat
WHERE webcatid = '1'
ORDER BY linkid

mysql error: Unknown column 'linkid' in 'order clause'

mysql error number: 1054

Date: Wednesday 30th of July 2003 12:31:40 AM
Script: http://thedecostop.com/forums/forums...elinks&catid=1
Referer: http://www.thedecostop.com/forums/ad...nksadmin.php?&

I'm working on an update for Keptic and it will be done today...