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

[Units]

Originally posted by DrkFusion
Units, currently no, but if its something you would like to see in the 3.0 version (which by the way is nearing completion) you are welcome to confirm a suggestion.

Also, I was wondering.. My designer is trying to make it so that, for each category it displays how many links are inside.. Any hints/tips for him?

[Dean C]

Ratings for version 3.0 drk!

[DrkFusion]

Mist, its in

Units, the number of links is not done through design, but through coding, it is in vB links 3

[Units]

I understand that.
But thats one feature all my members are requesting at the moment.

[Chris M]

Version 3.0 is very near to completion...

Satan

[SS9267547]

Look forward to the release of Version 3.0, so going to be released in this year or next year?

[DrkFusion]

Originally posted by Units
I understand that.
But thats one feature all my members are requesting at the moment.

Sorry, its something I can't do right now.
Please don't think I am not supporting this hack, hopefully you can look at it my way, alot of unhappy clients...alot of them, design, code, network, server building and stuff.

Sorry Again, you are welcome to add it manually, but it is standard in vB Links 3.0 and I will provide full upgrade information, so you won't have to worry about loosing data.

[DrkFusion]

Originally posted by SS9267547
Look forward to the release of Version 3.0, so going to be released in this year or next year?

Hopefully next year.

I am planning to make 2 versions of vB Links Directory 3.0
[One for vBulletin 3.0 and another for the vBulletin 2.2.x]

[kastle]

For those who are interested in catagory counts, this might help some...

1. Edit your vB Links Directory Templates > drkslinks_catbit file as such (for example) -- I've added a [$linkcounted] to mine, more on what it is ....

PHP Code:

<tr valign="top">
<td bgcolor="#F1F1F1"><normalfont><b><a href="links.php?action=viewlinks&catid=$catid">$catname</a></b> [$linkcounted] </smallfont></normalfont></td>
<td bgcolor="#DFDFDF"><normalfont>$catdesc</normalfont></td>
</tr> 


2. In the links.php, change

PHP Code:

// #################### Links Home ####################
if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
  while ($myrow=$DB_site->fetch_array($ebg)) {
            $hasattach=1;
            $catid=$myrow["webcatid"];
            $catname=$myrow["catname"];
            $catdesc=$myrow["catdesc"];
                        eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
  }
}
eval("dooutput(\"".gettemplate('drkslinks_main')."\");");
} 


TO

PHP Code:

// #################### Links Home ####################
if ($action=="main") {
$ebg = $DB_site->query("SELECT * FROM gportal_weblinkscat ORDER BY catname");
if ($DB_site->num_rows($ebg)) {
  while ($myrow=$DB_site->fetch_array($ebg)) {
            $hasattach=1;
            $catid=$myrow["webcatid"];
            $catname=$myrow["catname"];
            $catdesc=$myrow["catdesc"];
            $linkcount=$DB_site->query_first("select count(*) 
                        as linkcounted from `gportal_weblinkslink` 
                        where catagoryid=$catid[webcatid]");
            $linkcounted=$linkcount[linkcounted];                        
                        eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
  }
}
eval("dooutput(\"".gettemplate('drkslinks_main')."\");");
} 


[JakeC]

I'm running into the apostrophe problem like Visionray was on page 10. Basically when I try to add a link with a ' in it, it will not upload. There was a fix given but it appears it was for an earlier version or something because the code looks different. Any help you could give would be very much appreciated. Thanks.

JakeC