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

[Xelation]

Is the build confirmed working yet?

[cindyd]

That does it!

The other problem I have seen is that this does not relate well to other browsers. I use Opera most of the time and back a few pages I have a screen shot of one of the pages that shows a big empty column, where on IE, it looks great.

[jacobi]

Xelation said this in Post #601
Is the build confirmed working yet?

After I apply Bob's fixes, I'll let ya know!

[jacobi]

Everything works like a charm Thanks, Bob/Dark_Wizard!!

[DrkFusion]

I will actually be recoding the administration for build 250. I did not even touch the admin script for the upgrade. When Dark_Wizard helps me finalize the upgrade script it will include all fixes.

By the way, if many do not know Dark_Wizard is one of the people who have been helping out with vB Links Directory 3.0!

[DrkFusion]

[high]vB Links Directory 2.0 Build 2.5.0 Upgrade[/high]
This upgrade is a manual upgrade, it contains template fixes, new templates, and new links.php file. Follow the instructions in the files.

This new version has query load decrease, better template integration, and a much better integration with vB.

Note that this will be the version that we will provide an upgrade to v3.0 when we release it.

If anyone gets any errors, please forward them to my Private Message Box immediatly

If you install the hack, please click the install button, as constant upgrades, and patches will be provided. Also we will provide news of vBulletin Links Directory 3.0 to only users who have installed, because its easier to manage. You can also receive better support.

Regard,

[DrkFusion]

The upgrade files were updated with a new links.php file and a new weblinksadmin.php file.

Both contain changes, which include structure, and minor bug fixes. If anyone runs into any problems, please Private Message me immediatly.

The new post above contains a RAR upgrade script, and the one on page 35 there is a zip version.

Regards

[DiscussAnything]

after the update the link and description are not inserted into the database, when I add a new link. Everything looks alright though, and I didnt change any of the code/templates

[Dark_Wizard]

Today at 09:41 AM DiscussAnything said this in Post #608
after the update the link and description are not inserted into the database, when I add a new link. Everything looks alright though, and I didnt change any of the code/templates

Apply my fixes and let me know if it works then...

[DiscussAnything]

I've done all 3 of your fixes, but with the same results. The admin panel is also giving dbase errors left and right.

for View all links:

PHP Code:

Invalid query id  specified
mysql error: 

mysql error number: 0 


For edit link in admin panel:

PHP Code:

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

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

mysql error number: 1054 


and for add new link, after selecting the category:

PHP Code:

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

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

mysql error number: 1054 


If i'm the only one dealing with this, I can redo the hack, but if its something in the hack, I'll help to try hunting it down. So just let me know. Is anyone else getting strange behavior after the update?