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]

Here are some basic information about vB Links Directory 3.0
vB Links Directory 3.0 Features
Administration:
? Better Category Management
? Better Link Management
? Full Management of settings (Name, fields, extras)
? --->You can set the name of your links directory, and fields, for example, instead of showing the word hits: you can put visits, or views, and instead of having a standard name of "Site Links Directory" you can set it in the vB options to be "Site Link Database" or "Site Links" or "Site Plugin", you can disable and enable features such as ratings, add links, user editing, user viewing.
? Advanced Link Validation System (better then current)
? Button/Banner Management
? New Sub Category Management
...(Will list more as finish date nears)

Links Directory (Public):
Main::
? Categories
? Sub Categories
? Number of Links in each Category
? Descriptions
? Search
Category View::
? Sub Categories
? Link Name
? Link Description
? Link Rating (Average)
? Admin Options (Viewable to admins, and others you specify)
? Search
? Link Hits
Extras::
? Built in Mini-Topsites (Can be disabled)
? Top 10 Visited Links (Can be disabled)
? Last 10 Added Links (Can be disabled)
? Banner Rotator (Can be disabled)
? Full Mas view (Can be disabled)

These are just some features of 3.0, which will be released with it

[Dean C]

Yes but it's not released yet

[nighteyes]

Originally posted by DrkFusion

Hopefully next year.

Any idea when 3.0 might be released at all?

[Units]

Originally posted by 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')."");");
} 


Thanks alot dude

[Units]

Dude.. My members are saying that they add there link, and it doesnt show up. I checked the link validation thing, and it said its off..

Im an admin, so i could see the link.. But they cant, any suggestions?

[Elvis]

Hi,

This is a very cool hack.... but lacks a couple things, namely in the category functionality.

Does anyone know how to add the category into the form when validating or editing a link?

Any help would be appreciated.

Thanks,

Elvis

[Elvis]

Well,

This isn't anything fancy... but it's my first hack (and of a hack), so go easy on me.

Replace weblinksadmin.php with the one attached here (weblinksadmin.php.txt), and you'll be able to change categories in both the Link Edit and when you Validate New Links. I also sorted View ALL Links by linkid.

Again, it's quick and dirty, but it works. All my changes are commented... just search the file for ' Elvis '.

Lemme know what you think... perhaps someone else can clean it up, and make it more efficient.

Elvis

[JakeC]

I gave it a try and I got an error when I tried to validate a link. Here is the error:

Fatal error: Call to undefined function: phprequire() in /home/jakec/public_html/forums/admin/weblinksadmin.php on line 1

I really would like this addition. All I did was rename the file to weblinksadmin.php and uploaded it to the admin folder, overwriting the old weblinksadmin.php file. Did I miss a step? Thanks in advance.

JakeC

[Elvis]

Originally posted by JakeC
I gave it a try and I got an error when I tried to validate a link. Here is the error:



I really would like this addition. All I did was rename the file to weblinksadmin.php and uploaded it to the admin folder, overwriting the old weblinksadmin.php file. Did I miss a step? Thanks in advance.

JakeC

Make sure the first 2 lines look like:

PHP Code:

<?php
require("./global.php");

[JakeC]

Ok, I got it. For some reason when I saved the file everything was run together and not in any structure of any kind. So, I just copied and pasted into a php file and it works great. I haven’t been able to test it thoroughly but it works great so far. Thanks for a great update. I really like it.

JakeC