The Arcive of Official vBulletin Modifications Site.

vB Links Directory 2.0 *NEW VERSION* · **Released**: 10-11-2002

[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 · #**322** 11-21-2002, 09:14 PM

It seems as the catagoryid was not passed through, so then catagoryid was blank.

I am not really sure how to fix your hit problem, but try doing this, in links.php
fnd:

PHP Code:


			
if ($noshutdownfunc) {

  $DB_site->query("UPDATE gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'");

} else {

  $shutdownqueries[]="UPDATE LOW_PRIORITY gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'";

}

replace with

PHP Code:


			
$DB_site->query("UPDATE gportal_weblinkslink SET hits=hits+1 WHERE linkid='$id'");

Also can you please PM me your site url.

Thanks

DrkFusion · #**323** 11-21-2002, 09:15 PM

Quote:

Originally posted by cklaszlo
Is it possible to add a "New" image next to new links and also next to the main catagories if there are new links in the respective cats?

Do you mean add an image beside a link if it is new since the last time they visited?

cklaszlo · #**324** 11-21-2002, 10:36 PM

No I mean when a new image has been added to the directory. Say it stays "New" for like 5 days (or length is set by the admin).

Banana · #**325** 11-22-2002, 06:26 AM

The "Top 10 Visited Links" doesn't sort properly. The problem is that the db column is text and not a number. Therefore "9" comes above "11" etc. My top ten list reads: 9,9,6,5,4,36,29,17,15,14.

Will a simple alteration of the column type work or will that muck up the PHP? Thanks

DrkFusion · #**326** 11-22-2002, 06:53 PM

Umm...Yea I noticed that, I thought I had fixed that and updated it all, I had changed alot of the tables from the first release...I will check it out.

ForYou · #**327** 11-24-2002, 06:29 AM

Hello ,

When i need to do first install there is message for me like this ..
---------------------------------------

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: CREATE TABLE `gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` VARCHAR(255) NOT NULL,
`catdesc` TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
mysql error: You have an error in your SQL syntax near '`gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` V' at line 1

mysql error number: 1064
----------------------------------------------

what can i do please to solve it ..

regards

DrkFusion · #**328** 11-24-2002, 11:58 AM

Run this manually through phpmyadmin
[sql]CREATE TABLE gportal_weblinkscat (
webcatid INT(11) NOT NULL AUTO_INCREMENT,
catname VARCHAR(255) NOT NULL,
catdesc TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM[/sql]

Highlander · #**329** 11-26-2002, 02:40 AM

hi there.. is there a ability to user this linkdatabase with yours.. i mean i needed it merged.. some option yours and some option of mine would be a GREAT hack ..

direkt link
http://www.spieleplanet.org/forum/do...hp?dominator=2

would be cool if i get an answer on
admin@spieleplanet.net

(i just user the quick reply box for this answer so i did not get notifivation by email.. )

Legacy · #**330** 11-30-2002, 03:44 PM

Admin CP Error

Fatal error: Cannot redeclare maketableheaderview() in /home/virtual/site1/fst/var/www/html/forums/admin/adminfunctions.php on line 132

EDITED...NEVER MIND..FOUND PROBLEM

You do not need to edit the adminfunctions.php file if your upgrading

doh

But the Validation doesnt work...also glad to see the serch function working with ensim now

great Job...any solution on validation

Banana · #**331** 11-30-2002, 03:50 PM

Quote:

Originally posted by Banana
The "Top 10 Visited Links" doesn't sort properly. The problem is that the db column is text and not a number. Therefore "9" comes above "11" etc. My top ten list reads: 9,9,6,5,4,36,29,17,15,14.

Will a simple alteration of the column type work or will that muck up the PHP? Thanks

Hi, is there a fix for this yet? Thanks

ArunanS · #**332** 11-30-2002, 09:47 PM

Try
[SQL]ALTER TABLE `gportal_weblinkslink` CHANGE `hits` `quantity` INT(99) DEFAULT '0'[/SQL]

GMeadows · #**333** 12-01-2002, 10:52 AM

There must be a simple way to include the links box on the front page of the forum....? Down under the forums.

Got me beat right now.

ArunanS · #**334** 12-01-2002, 12:27 PM

Well if you check out http://www.noxmedia.net/links.php

I have done it for that site.

Martin64 · #**335** 12-01-2002, 02:26 PM

Great hack, installed.

DrkFusion · #**336** 12-04-2002, 12:55 AM

Well can we please move this to pm.

Thanks

DrkFusion · #**337** 12-04-2002, 02:12 AM

Many of you may be wondering why the stuff I have promised is not out yet, its because I have been busy with my personal life, and thanks to alot of people here at vB.org i have learned alot of new stuff in php and Mysql, and will be releasing yet a new big release, with great new features, and a full code revamp.

Also I will be making a new one for vB3 when that comes out.
Here are some features on the TODO
- Sub Categories
- Link Editing (By user who added the link and admin on the site itself)
- Revamped Admin Panel with more control in vB options
- New Style
- Link Rating
- Mini Topsites
- Advanced Toggle Options in AdminCP for all features
- UserGroup Permissions (Allow certan usergoups to view/add links)
- Built-In Banner/Button rotator (Maybe)
- Banner/Button Engine (Allows the user to display a button or banner, can be toggled on or off)
- Adding Rules (make it so only 1 user can add 1 link etc)
- Easy Integration Instructions (vBhome, main site etc)
and many other features, this will be a full re-write of the code, and the best part about all this is, the goal is no more than 11 queires per major function. The Currect Directory potentially only has 6-7 queries, but with all the extra addons less than 11, 10, and if all features are turned off less than 8, I will be giving you more information soon.

supreemball · #**338** 12-04-2002, 10:52 PM

great hack..

only one problem.. seems that when users add some links with ' or commas or other special characters in the description field, they don't show up on validation, even though it says they added the link successfully.

any solutions? tia

DrkFusion · #**339** 12-05-2002, 01:20 AM

I believe this problem was fixed...hmm well the Validation Feature isn't really something that appeals to me, but I have to say Mark has done an excellent job with it, I will look into it, if you are willing to wait, I will get out a new update as soon as I am not full of work.

Xer · #**340** 12-06-2002, 11:56 AM

thx DrkFusion !!
working on 2.2.9

this hack very nice..
waiting your vb3 Power edition!!

cessna140 · #**341** 12-06-2002, 04:42 PM

Not sure if it has been requested or not but how about a "suggest a category" link.

Perhaps it could be set up similar to posting a link but would be moderated. The admin could approve it and have the new category added or disapprove and it would be deleted.

Another option would be to allow users to suggest a new category when posting a link. The admin could add the category or change the category to an existing one when moderating the link?

Would be a nice touch.
Installed on 2.2.8 and working like a champ! Thanks for a great hack!

Visionray · #**342** 12-06-2002, 05:06 PM

Quote:

Originally posted by supreemball
great hack..

only one problem.. seems that when users add some links with ' or commas or other special characters in the description field, they don't show up on validation, even though it says they added the link successfully.

any solutions? tia

Yup, that was a bug fix I suggested awhile back that obviously didn't get fixed. MarkB solved it though.

You can find the fix for that in this post.

https://vborg.vbsupport.ru/showthrea...002#post317002

Littlebit · #**343** 12-06-2002, 05:14 PM

Drkfusion,
I haven't got to your hack yet, but as I was reinstalling my hacks after upgrading to 2.2.9, I got an idea...I'll PM you
:smoke:

DrkFusion · #**344** 12-06-2002, 07:48 PM

Visionray, I am sure the v2 had the fixes in them. Sorry

FlyBoy73 · #**345** 12-07-2002, 11:28 PM

Wow, this is a great hack. I just spent $195.00 for In-Link's directory and this one looks more appealing to me! lol Think I will sell the In-Link.
Great job, DrkFusion

Littlebit · #**346** 12-08-2002, 05:59 AM

Hi Drk,
I installed and all works great! I love it

I am wondering if you have already written this part yet or not:

Quote:

UserGroup Permissions (Allow certan usergoups to view/add links)

I guess, would it be similar to the hack used to give the option of what usergroups can see the Calendar?
Anyway, thanks for the very precise instructions too
-littlebit

arracing · #**347** 12-09-2002, 01:56 AM

You should make it so people cannont submit duplicate links if their is already that same link address already submitted.

coolsurfin · #**348** 12-09-2002, 08:55 PM

Hi,
Getting this error when installing
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: CREATE TABLE `gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` VARCHAR(255) NOT NULL,
`catdesc` TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
mysql error: You have an error in your SQL syntax near '`gportal_weblinkscat` (
`webcatid` INT(11) NOT NULL AUTO_INCREMENT,
`catname` V' at line 1

mysql error number: 1064

Date: Monday 09th of December 2002 05:04:24 PM
Script: http://www.coolsurfin.com/forum/foru....php?install=3
Referer: http://www.coolsurfin.com/forum/admi....php?install=2

DrkFusion · #**349** 12-11-2002, 08:18 PM

coolsurfin, run the following manually
[SQL]CREATE TABLE gportal_weblinkscat (
webcatid INT(11) NOT NULL AUTO_INCREMENT,
catname VARCHAR(255) NOT NULL,
catdesc TEXT NOT NULL,
PRIMARY KEY (`webcatid`)) TYPE = MYISAM
[/SQL]

buss2002 · #**350** 12-18-2002, 07:40 PM

Hi,

1.The hack seems cool...i installed but dont know about the folder with templates in the zip...dont know what to do with them....no instruction for those?

2.Is that link directory suppose to be added to the forum home somehow?I can pull it up tru the url to links.php but isent it supose to be implemented into the forum home page?

3.how do i add a extra field for site owners to put in information
about ther return link?

4. were can i display a rule for adding lnks to the directory?

hope for some help to a newbie -

JakeC · #**351** 12-20-2002, 09:40 PM

I'm having a slight difficulty. I have changed around some of my styles tweaking things hear and there and now all of my links and links directories have disappeared. They still show in the forum admin under the links directory section but nothing shows up on the site. also, how many templates are supposed to show up in the custom templates portion of the template set? I only count three in mine. drkslinks_addnewlink, drkslinks_browselink, and drkslinks_main. Here are a couple of screenshots:

Links Directory in the CP

Links directory in the site

My templates

Any help would be very much appreciated.

JakeC

P.S. I'm not completely sure that tweaking my styles had anything to do with the links error. I just happened to notice it after messing with my styles.

JakeC · #**352** 12-20-2002, 10:22 PM

Never mind, I got it. I guess for some reason I lost all but three of my templates. I went ahead and created them by hand and everything is good to go. Thanks.

JakeC

buss2002 · #**353** 12-20-2002, 11:01 PM

somebody out there?

Smoothie · #**354** 12-21-2002, 02:43 AM

Hey! Finally got around to installing. Nice Job!
[high]* Smoothie clicks that darn install button.

[/high]

Smoothie · #**355** 12-21-2002, 02:45 AM

BTW, it's "category", not catagory.

Dean C · #**356** 12-21-2002, 05:50 AM

Hehe awesome... you installed after all

!

Regards

- miSt

arracing · #**357** 12-21-2002, 02:49 PM

if you excluded a domain and you want to bring it back, how do you do that?

DrkFusion · #**358** 12-21-2002, 03:39 PM

Quote:

Originally posted by buss2002
somebody out there?

Some of your questions have been answered in the support forum.

DrkFusion · #**359** 12-21-2002, 03:41 PM

Quote:

Originally posted by Smoothie
BTW, it's "category", not catagory.

I can't start teo tell you how many people told me, lol I keep forgetting when I update, also some people might have problems with html while viewing the Links Directory, there should be a solution to this in this thread, I will look for it, and fix it.

I have started to code the major update of 2.5, on my site I am running 2.5a

It has major security fixes, and some new features, that have been coded in but not used yet.

DrkFusion · #**360** 12-21-2002, 03:42 PM

Quote:

Originally posted by arracing
if you excluded a domain and you want to bring it back, how do you do that?

Can you please rephrase your question, sorry I do not understand

Regards

Dean C · #**361** 12-21-2002, 04:48 PM

Have you included ratings because this is the only thing thats stopping me from installing?

- miSt

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09452 seconds Memory Usage 2,612KB Queries Executed 55 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (41)post_thanks_box (41)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (41)post_thanks_postbit_info (40)postbit (41)postbit_onlinestatus (41)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!