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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13038 seconds Memory Usage 2,325KB Queries Executed 25 (?)
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 (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 (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)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!