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 · #**122** 10-27-2002, 12:39 AM

If a user doesn't select a catagory, this will bring an error, and prompt the user to press the back button, and select a catagory.

1. open the drkslinks_addnewlink template in your admin control panel, and replace everything with the attatched files.

2. Open links.php in the forum root, and find:

PHP Code:


			
// #################### Do Add New ####################

if ($HTTP_POST_VARS['action']=="doaddnew") {

add under it:

PHP Code:


			
if ($catid == '0'){

    echo "You did not pick a catagory, please hit your browser back button, and choose a catagory from the drop down<br>";

}else{

3. still in links.php file, find:

PHP Code:


			
}



// #################### Search Links ####################

if ($action=="search") {

and replace with:

PHP Code:


			
}

}



// #################### Search Links ####################

if ($action=="search") {

That should do it, now test out by adding a new link, via the website, not the admin*

Enjoy, and good luck
-Arunan

David_McPherson · #**123** 10-27-2002, 05:34 AM

Arunan,

I've been following this hack and I'd just like to know.... Is it 100% or is it continuing to develop? I think this idea is fantastic and cannot wait to install. Are your install directions complete and up to date on the original post? If so, I'm installing. Can you also give us a quick down and dirty update on its status.. ?

Thanks GREAT work.. I wish I had the talent many of you Hackers have.. Great tools and resources you all put out. Thanks.!!

DrkFusion · #**124** 10-27-2002, 04:37 PM

Hi David,
Well, I have been working on v2, taking suggestions for new features, I will be releasing that soon, but a friend of mine (mist) has been suggesting some more great features to add, so I will be looking into that.

Version 2, is at the moment 99% done in my point of view, but for instance in Mist's point of view, its like 75% done, because of the lack of the other feature, I will possibly post new screenshots soon, I would suggest to you to wait for v2, but I will include upgrade instructions in the v2 release.

The instructions for the current release are full, but I believe there is a minor template mistake.

I am sorry if I didn't answer all your questions.
Thanks
-Arunan

Chris M · #**125** 10-27-2002, 04:42 PM

I cant wait

Satan

David_McPherson · #**126** 10-27-2002, 05:41 PM

Arunan,
Thats perfect... This is a great hack...

And I'm sure it will only get better in V2.0. Thanks for what you do.

Legacy · #**127** 10-28-2002, 06:50 PM

DrkFusion

Thanks for the Catgory Fix.
Havent tried it yet but Will tonight but just wanted to thank you for taken the time to make a fix for it. I do appreciate what you have done.

Thank You again.

DrkFusion · #**128** 10-28-2002, 08:23 PM

Your welcome guys

Don't think anything of it

-Arunan

FleaBag · #**129** 10-28-2002, 09:47 PM

Working well on 2.2.8, thanks. It might be a good idea to get all the fixes posted here in the original archive though.

DrkFusion · #**130** 10-28-2002, 10:24 PM

I believe I updated the original zip with the fixes, I will look into it.

JulianD · #**131** 10-28-2002, 11:17 PM

The demo sites looks great!

/me Installs!

marc49 · #**132** 10-29-2002, 12:23 AM

I'm waiting for version 2.0 also, then I will install it

DrkFusion · #**133** 10-29-2002, 12:57 AM

Glad to know people are waiting

Possibly this will push me to release faster.

-Arunan

Tigga · #**134** 10-29-2002, 01:14 AM

Quote:

Originally posted by DrkFusion
Glad to know people are waiting Possibly this will push me to release faster.

-Arunan

Well if it helps any I'm waiting too and have been checking the thread for the last few days, just haven't posted yet.

So far it's looking great! Just waiting on v2 to install.

DrkFusion · #**135** 10-29-2002, 01:18 AM

Oh hehe,

sorry about that, I have been ignoreing the new features requested by Mist, because of school, but I will try to get those in this week, all last week I was focused on tests, and exams..sorry

By the way, can all beta-testers please PM me?
Thanks
-Arunan

Visionray · #**136** 10-29-2002, 03:01 AM

AWESOME HACK! One of the best and easiest to install that I have seen around here. Nice job. Im just testing it out right now and its working fine on 2.2.4

I have one question...is it possible to rearrange the categories once you post them? What if I want to move one main category to the top of the list, or to the bottom, or anywhere in between? Is that possible to do without having to reenter all of the links?

Thanks

Visionray · #**137** 10-29-2002, 11:00 AM

DrkFusion,

I dont know if this has been mentioned before so I apologize if so.

I found a strange bug. Whenever I try to enter a link in the link description box with an apostrophe like:

It's a great site, Straight from the horse's mouth etc....

It will not post the link. It wont post when I do it from the forums, as well as from the admin cp. Even if I try to edit the link description text in the admin cp, the edits to not take effect. Only edits without apostrophes change.

I couldn't figure out why one of my links wasn't posting and this is what it came down to. Is this happening for anyone else?

Thanks

DrkFusion · #**138** 10-29-2002, 11:04 AM

Can you give me a link to your board?
I will look into this problem, none of my members have encountered this at all, they have been adding links all day and night hehe...I will look into it.

Thanks for telling me
-Arunan

Visionray · #**139** 10-29-2002, 01:03 PM

Hi,

The URL is http://www.fusionarena.com/community/links.php

Thanks! Also I had another question at the bottom of the last page in this thread about rearranging categories. Is that possible?

Thanks again and great hack

DrkFusion · #**140** 10-29-2002, 08:30 PM

I believe right now it orders it all alphabetically, but if you add a new field to the cat dir, and then just number it off 1-x, and then in links.php have it organize by the field name, i guess that would work.

I will look into this for you
-Arunan

Visionray · #**141** 10-31-2002, 02:39 PM

DrkFusion,

It is a bug. I've tried this on three different forums here that have this hack installed. Why not try yourself to add a link to your own link database with an apostrophe anywhere in the link description? If you are using the code you posted here, it won't work.

For example, on two of the sites, I registered and entered in a link for Google. Here is the info I put in.

------------------------
Link Name = Google
Link URL = http://www.google.com
Category = Search Engines
Description = It's the greatest search engine on earth.
------------------------------

The link did not work for this entry on 3 sites I have tested.

If I enter this:

------------------------
Link Name = Google
Link URL = http://www.google.com
Category = Search Engines
Description = It is the greatest search engine on earth.
------------------------------

Then the link works.

Just giving you a heads up. A few of my members were wondering why their links weren't showing up at all.

MarkB · #**142** 10-31-2002, 02:50 PM

I had a fix for this (found it on my own version)... lemme grab the code

MarkB · #**143** 10-31-2002, 02:55 PM

(I'm assuming this is the cause for YOUR problem, since it was the cause for mine...)

Find this in links.php:

PHP Code:


			
// #################### Do Add New ####################

if ($HTTP_POST_VARS['action']=="doaddnew") {

$result = mysql_query("INSERT INTO gportal_weblinkslink (catagoryid, linkname, linkurl, linkdesc) 

VALUES ('$catid', '$linkname', '$linkurl', '$linkdesc')");



eval("dooutput(\"".gettemplate('drkslinks_doneaddlink')."\");");

}

Change it to:

PHP Code:


			
// #################### Do Add New ####################

if ($HTTP_POST_VARS['action']=="doaddnew") {

$result = mysql_query("INSERT INTO gportal_weblinkslink (catagoryid, linkname, linkurl, linkdesc) 

VALUES ('$catid', '".addslashes(htmlspecialchars($linkname))."', '$linkurl', '".addslashes(htmlspecialchars($linkdesc))."')");

    

eval("dooutput(\"".gettemplate('drkslinks_doneaddlink')."\");");

}

That should work...

adriandaz · #**144** 10-31-2002, 03:07 PM

This is cool, thanks

Visionray · #**145** 10-31-2002, 05:32 PM

MarkB

Yep! You're code worked. Thanks!!!

One more question...do the links spill over into muliple pages after a certain amount, or do they all remain on the same page?

Thanks

MarkB · #**146** 10-31-2002, 05:35 PM

Glad it worked!

All single page at the moment, AFAIK... not sure about v2 though. We'll have to see

Chris M · #**147** 10-31-2002, 05:45 PM

Version 2 has a few surprises

Its all im letting out

Satan

Visionray · #**148** 10-31-2002, 05:51 PM

Can't wait! This is a great hack which opens a lot of possibilities. I was looking for a way to do this exact same thing and now my users can do it too which is great.

I was thinking about another thing...don't know if this is going to be in version 2. My links don't display in alphabetical order. The first link entered remains at the top, second link underneath etc...

I think from a user standpoint, it should either be the other way around, or they should be alphabetical, because down the road when someone adds a link and it goes all the way to the bottom its not as efficient. If thats something being worked on then disregard that.

One more thing which would really be cool. I wonder if there is a way to break up the categories...for example on my site I have film links and then web links. It would be nice if I could make a divider between the two sections to differentiate them from each other, know what I mean? Just like on the vB forum home page how major sections are split up. Just an idea. I don't know anything about php, I just follow the instructions in the hacks lol.

Thanks guys this works great so far.

DrkFusion · #**149** 10-31-2002, 07:27 PM

Visionray, the code should display in alphabetical order by default. It was added later on, but I will take all your suggestions, and other peoples suggestion into thought as I finish it up.

MarkB, thanks for helping

have been a very big help.

Hellsatan, You don't know the new features

Anyways have a nice day, I will possibly post new screenshots later on.

-Arunan

DrkFusion · #**150** 10-31-2002, 08:25 PM

vB Links Directory 2.0
.:: Main

DrkFusion · #**151** 10-31-2002, 08:25 PM

vB Links Directory 2.0
.:: Link In Catagory

DrkFusion · #**152** 10-31-2002, 08:26 PM

vB Links Directory 2.0
.:: Last 10 Added Links

DrkFusion · #**153** 10-31-2002, 08:26 PM

vB Links Directory 2.0
.:: 10 Most Visited Links

DrkFusion · #**154** 10-31-2002, 08:28 PM

Thanks to MarkB for the hit counter, and admin validation feature, and Jeff and MarkB for the search engine help.

All the screenshots from above, are modified features, and/or new features that are done. There are more to be done.

Thanks for Waiting
-Arunan

Chris M · #**155** 10-31-2002, 09:02 PM

Oh...I think I do Arunan

Satan

Legacy · #**156** 11-01-2002, 01:18 AM

Cant seem to find the Fix for the SEARCH function if your host is on ENSIM

Is there a fix since i have ensim...generates me a error :9

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT linkid,catagoryid,linkname,linkdesc,hits FROM gportal_weblinkslink WHERE valid='1' AND linkname LIKE '%Guns%' OR linkdesc LIKE '%Guns%' ORDER BY linkname
mysql error: Unknown column 'hits' in 'field list'

mysql error number: 1054

Date: Thursday 31st of October 2002 10:27:07 PM
Script: http://www.squadgames.com/forums/forums/links.php
Referer: http://www.squadgames.com/forums/lin...?action=search

DrkFusion · #**157** 11-01-2002, 02:09 AM

Yea I fixed it

Hey Legacy if you wish to wait, I will make you an official beta tester, so you can upgrade from the buggy version to the new one.

_Arunan

WoodiE · #**158** 11-01-2002, 01:38 PM

I see lots of screen shots of 2.0, but no link to download it...where can i get it? Is it out yet?

-WoodiE

Chris M · #**159** 11-01-2002, 02:52 PM

Version 2.0 isnt released yet...

@Arunan - You should chuck it my way too - XPera use Ensim

Satan

Dark_Wizard · #**160** 11-01-2002, 03:38 PM

Quote:

Originally posted by DrkFusion
Yea I fixed it

Hey Legacy if you wish to wait, I will make you an official beta tester, so you can upgrade from the buggy version to the new one.

_Arunan

Would you like another beta tester?

Goldknight · #**161** 11-01-2002, 04:46 PM

I aint mind to be beta tester for drkfusion either but I doubt he will pick me anyway since I m "ant" to him...

Anyway I m keeping my eyes on this drkfusion's hack since drkfusion release.. very good hack and good luck with V2

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