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 · #**362** 12-21-2002, 05:47 PM

Quote:

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

- miSt

Yes, its on the to do, its actually in the code, I am doing the math functions for it right now.

Smoothie · #**363** 12-21-2002, 05:53 PM

One small request, heh, maybe not too small. How about allowing banners. Uploaded, or linked.

Dean C · #**364** 12-21-2002, 06:50 PM

Lil one's tho

arracing · #**365** 12-21-2002, 07:15 PM

you know how you can exlude domains from the site referrer list. Well I want to know how I can bring back those domains I excluded?

Smoothie · #**366** 12-22-2002, 08:19 AM

DrkFusion-

I need to replace "catagory" with "category", but its not so easy. I have way too many styles to do this manually. Any suggestions?
I tried the find and replace, but its only listing one template, and I know there are more.

DrkFusion · #**367** 12-22-2002, 01:47 PM

Smoothie, there should be 2 ways you can do this, one way is set your board to debug (be careful) and edit the global template, which will affect all styles. (I would say this is the most effective way) but be careful

or

you can go into a database administration software like phpmyadmin, first go to your admin, find out the template ids for the global templates, and then run
[SQL]SELECT * FROM `template` WHERE templateid=globaltemplateidonly[/SQL]

I would really suggest the first one, because you have so many styles, you might want to look into closing yourboard while doing these jobs to be on the safe side, we really do not know how many stuff debug mode opens to the public if any, so be safe, but it is the easier way, the 2.X update will have this.

Sorry, and good luck Smoothie

DrkFusion · #**368** 12-22-2002, 01:53 PM

Quote:

Originally posted by Smoothie
One small request, heh, maybe not too small. How about allowing banners. Uploaded, or linked.

I am sure you wouldn't want to allow viewing of other sites banners off of yours, I think it would be wise if the user who adds links have the banner uploaded and link to it

Also the standard banner (468x60) will not fit in any of the current tables, so if you want those sorts of banners then for the mod, I can add a new <tr> if you want buttons thats ok, but to benifit all, I will include instructions for both

Smoothie · #**369** 12-22-2002, 08:03 PM

DrkFusion,

You say the next release will fix the spelling errors? Ok, I just checked, out of the 13 templates, 3 of them have the word catagory, with a total of 5 instances. So, 9 styles x 5=45 changes I have to make.

DrkFusion · #**370** 12-22-2002, 09:01 PM

Did you try the first way above?

Smoothie · #**371** 12-22-2002, 10:57 PM

What I did was find and replace in the templates with a text editor. Then debug mode on, edited the vblinks global templates. Replaced drkslinks_main, drkslinks_error and drkslinks_addnewlink templates.

DrkFusion · #**372** 12-22-2002, 11:04 PM

So everything is fixed?
I see the html problem was fixed too.
Note, the same html problem is on browselinks, Top 10 visisted, and top 10 last added
Sorry about the template errors, I focused alot on the code for the release, and really did not revise the templates.

Smoothie · #**373** 12-23-2002, 12:15 AM

Quote:

Originally posted by DrkFusion
So everything is fixed?
I see the html problem was fixed too.
Note, the same html problem is on browselinks, Top 10 visisted, and top 10 last added
Sorry about the template errors, I focused alot on the code for the release, and really did not revise the templates.

Yep!

JakeC · #**374** 12-27-2002, 02:51 AM

Im not sure if this has been covered yet but for some reason whenever I try to admin the links directory in the admin panel I must submit my username and password each step of the way. Sometimes to do one function such as remove a link, it asks me for my username and password 3 times. Any ideas? Great hack by the way. Are you planning to add a deeper directory structure and the ability to move links? Just wondering. Thanks in advance.

JakeC

Axe · #**375** 12-27-2002, 03:31 AM

Quote:

All copyright notices must stay intact, all links, and messages in templates must be included in order for legal use of this modification.

Bummer, such a shame we're under restriction not to advertise other hosting companies on the site.

Ahhh well, never mind.

XrayHead · #**376** 12-27-2002, 02:18 PM

OK, after some messing around and forgetting to upload the links.php (i was a bit merry on boxing day) file i got the hack working on 2.8.

Nice hack, thanks.

DrkFusion · #**377** 12-28-2002, 01:01 AM

@Axe, we do not do hosting anymore, the site will go up soon, no hosting :-/ (plans changed) we lost one of the business locations.

DrkFusion · #**378** 12-28-2002, 01:01 AM

@Axe, we do not do hosting anymore, the site will go up soon, no hosting :-/ (plans changed) we lost one of the business locations.

Units · #**379** 12-29-2002, 12:51 AM

No vb codes?
I want to bold something.. <b> and [b] doesnt work

DrkFusion · #**380** 12-29-2002, 03:23 AM

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.

ethics · #**381** 12-29-2002, 04:48 AM

Great hack! Installed and rolling with it. Works really nice.

Units · #**382** 12-29-2002, 06:38 AM

Quote:

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 · #**383** 12-29-2002, 12:04 PM

Ratings for version 3.0 drk!

DrkFusion · #**384** 12-29-2002, 05:36 PM

Mist, its in

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

Units · #**385** 12-29-2002, 08:59 PM

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

Chris M · #**386** 12-29-2002, 10:01 PM

Version 3.0 is very near to completion...

Satan

SS9267547 · #**387** 12-29-2002, 10:48 PM

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

DrkFusion · #**388** 12-30-2002, 01:06 PM

Quote:

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 · #**389** 12-30-2002, 01:07 PM

Quote:

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 · #**390** 12-30-2002, 11:15 PM

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 · #**391** 12-31-2002, 04:53 AM

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

DrkFusion · #**392** 12-31-2002, 06:08 AM

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 · #**393** 12-31-2002, 09:03 AM

Yes but it's not released yet

nighteyes · #**394** 01-01-2003, 01:49 PM

Quote:

Originally posted by DrkFusion

Hopefully next year.

Any idea when 3.0 might be released at all?

Units · #**395** 01-02-2003, 01:31 AM

Quote:

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 · #**396** 01-02-2003, 05:24 PM

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 · #**397** 01-03-2003, 10:57 PM

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 · #**398** 01-04-2003, 05:53 PM

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 · #**399** 01-04-2003, 07:30 PM

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

Quote:

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 · #**400** 01-04-2003, 07:35 PM

Quote:

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 · #**401** 01-04-2003, 07:52 PM

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 havent been able to test it thoroughly but it works great so far. Thanks for a great update. I really like it.

JakeC

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08026 seconds Memory Usage 2,655KB 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 (7)bbcode_php (11)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 (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!