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

[Gutspiller]

Yesterday at 11:58 PM mbowers said this in Post #490
It might benefit future users of this hack if you went through and corrected the spelling of "category". It's "catAgory" in a bunch of places. I think I got them all, but I'm sure my users will let me know if I didn't... aranoid:

Yeah I want mine spelled right too.

[cindyd]

I installed this hack and everything is running great, except, I put a border around the table and it is gray.

DOes anyone know how to change the color on this?

Here is the URL:

Board

And I also attached a screen shot showing the border.

I had to hack the template to make it different than the rest of the board.

[DrkFusion]

First of all, yes the new version has the spelling fixes. The categories are still ordered by catname or catid ONLY in this version. I am actually going through this thread finding all the errors and fixing them. There is also a new look to it

[brianstevz]

06-28-03 at 06:24 PM 97cobracpe said this in Post #468
Do you have direct access to you database? If so, do the following:

In the gportal_weblinkslink table, the field named 'hits' has the datatype set to 'text'. Change it to 'int'. I did it on my site, and it worked with no lost information in the hit counters. They all remained intact.

Otherwise, I could modify the install script that when it creates the tables for the database it has the change built it. You would end up having to uninstall the hack, upload the new modifed installer script, and run the new one instead. You would lose all your links this way and have to start over.

This worked like a champ. Thanks for the suggestion!!!

[DrkFusion]

[high]DATABASE FIX[/high]
? This is a required update, if you have installed vB Links Directory before July 10,2003, you must execute this script.

THIS MUST BE RUN AFTER THE INSTALLATION!

Instructions
1. Download the script
2. Upload to admin cp
3. Execute script
4. If all goes well delete it from admin cp

[Kohhal]

Thanks for the update, never realised that problem!

[AuthorZone.Com]

Ok, I installed this script and when I click on add link I get:

Call to undefined function: maketableheaderview() in /home/authorz/public_html/forums/admin/weblinksadmin.php on line 12

[Russ_T]

Hi,

This hack is very useful thank you, can be viewed at


Anyway I made a little mod, I don't know how this will be affected by the update.

Original code

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')." \");");
}

Modified code

if ($action=="main") {
$ebg = $DB_site->query("SELECT a.webcatid, a.catname, a.catdesc, COUNT(b.categoryid) AS catcount FROM gportal_weblinkscat a LEFT OUTER JOIN $gportal_weblinkslink b ON a.webcatid = b.categoryid GROUP BY a.webcatid, a.catname, a.catdesc ORDER BY a.catname ASC;");
if ($DB_site->num_rows($ebg)) {
while ($myrow=$DB_site->fetch_array($ebg)) {
$hasattach=1;
$catid=$myrow["webcatid"];
$catname=$myrow["catname"];
$catdesc=$myrow["catdesc"];
$catcount=$myrow[catcount];
eval("\$catlistbit .= \"".gettemplate('drkslinks_catbit')."\";");
}
}
eval("dooutput(\"".gettemplate('drkslinks_main')." \");");
}

Basically I can now count the number of items in each category so if you see I get a total links in category.

If you haven't already done this thought it would make a nice addition, can you let me know if your db update php will affect my mod please?

Regards

Russ

[AuthorZone.Com]

Can someone help please?

I have registered members and Premium (Group) members.

I only want to allow the Premium group members to be able to submit links.

How can I get this done?

Somebody please help?

Max

[AuthorZone.Com]

I still get:
Fatal error: Call to undefined function: maketableheaderview() in /home/authorz/public_html/forums/admin/weblinksadmin.php on line 12
whe I click View all Links in the cp.