Mini Mods - Advanced Navbar Links

Author: Andrew Harmor
Version: 2.0.2
File Edits: 0
Template Edits: 2
Difficulty: Easy


Description:
You can add links or multiple menus to the navbar quickly through a form. Specify which usergroups can see each link via the permissions system.


F.A.Q.
Q: Why aren't the links showing?
A: Edit the link in your Admin CP and check the usergroup permissions

Q: All the links I made from the last version are gone
A: Go into phpmyadmin and select your vbulletin database.
Browse the table named "custom_droplinks". Change all the "catid's" with 0 to 1.
Go into your ACP --> Advanced Navbar Links --> Modify/Delete The links should show up under the first category. You can edit the links from here and select a different category to place it in.

Q: How do I get the links to appear on vBAdvanced?
A: Go into your ACP --> vBa CMPS --> Default Settings
Look for "Portal Output Global Variables". Add the following into the text area.

custom_singlelinks
custom_droplinks
custom_droplinks_cat

If you install this mod please press the "Install" button.

--Change Log--
1.0.0 - Initial Release

1.0.1 - took out the code that automatically added HTML to the navbar. I thought having it do it automatically was cool but can be annoying because you can't easily customize the class or placement

2.0.0 - Added the functionality to add multiple drop down menus

2.0.1 - Added missing table prefixes

[Kiint]

I was hoping you would release something like this and you've done a great job of it

I had to do some slight modifications for the Epic skin that I use and that was just changing calls to vbmenu_control over to vbmenu_control_header but that only took a few minutes.

Thanks for doing this, It's much appreciated.

[giovannicosta]

tried importing the new attached file and I get this error:

Database error in vBulletin 3.6.5:

Invalid SQL:
CREATE TABLE `vb_custom_droplinks` (
`linkid` mediumint(10) unsigned NOT NULL auto_increment,
`url` varchar(120) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`new_window` tinyint(2) unsigned NOT NULL default '0',
`alt` varchar(60) NOT NULL default '',
`number` int(20) unsigned NOT NULL default '0',
`image` varchar(230) NOT NULL default '',
`link_perms` varchar(100) NOT NULL default '',
PRIMARY KEY (`linkid`)
);;

MySQL Error : Table 'vb_custom_droplinks' already exists
Error Number : 1050
Date : Saturday, April 21st 2007 @ 11:16:05 AM
Script : http://URL/admincp/plugin.php?do=productimport
Referrer : http://URL/admincp/plugin.php?do=productadd
IP Address : my ip
Username : my username
Classname : vb_database

[harmor19]

Originally Posted by giovannicosta

tried importing the new attached file and I get this error:

Database error in vBulletin 3.6.5:

Invalid SQL:
CREATE TABLE `vb_custom_droplinks` (
`linkid` mediumint(10) unsigned NOT NULL auto_increment,
`url` varchar(120) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`new_window` tinyint(2) unsigned NOT NULL default '0',
`alt` varchar(60) NOT NULL default '',
`number` int(20) unsigned NOT NULL default '0',
`image` varchar(230) NOT NULL default '',
`link_perms` varchar(100) NOT NULL default '',
PRIMARY KEY (`linkid`)
);;

MySQL Error : Table 'vb_custom_droplinks' already exists
Error Number : 1050
Date : Saturday, April 21st 2007 @ 11:16:05 AM
Script : http://URL/admincp/plugin.php?do=productimport
Referrer : http://URL/admincp/plugin.php?do=productadd
IP Address : my ip
Username : my username
Classname : vb_database

You'll need to uninstall it first then reimport it.

[giovannicosta]

I cant uninstall it as it doesnt appear in my products area.

[harmor19]

Originally Posted by giovannicosta

I cant uninstall it as it doesnt appear in my products area.

Run these queries in your ACP --> Maintenance --> Execute SQL Query

DROP TABLE `vb_custom_droplinks`;
DROP TABLE `vb_custom_droplinks_cat`;
DROP TABLE `vb_custom_singlelinks`;

[giovannicosta]

I get this message:
You are not authorized to execute SQL queries

[harmor19]

You'll need to edit config.php and add your userid.
If you do not have access to the FTP I will create a product for the sole purpose of removing those tables.

[giovannicosta]

Where is the config.php file located, I do have access to the FTP...

[harmor19]

the config.php file is in "public_html/includes/"

[giovannicosta]

Executed queries now what?