Post by Jacob » Sun Jan 11, 2009 8:05 pm

Hi, Please can someone help with the sql bit. I am running V 0.7.9.5

Code: Select all

-- Insert the following into your database to create the new settings.
delete from `setting` where `group` = 'admin_ip';
insert into `setting` (`type`, `group`, `key`, `value`) values('global','admin_ip','admin_ip_address','0.0.0.0');
insert into `setting` (`type`, `group`, `key`, `value`) values('global','admin_ip','admin_ip_status','0');


-- !!! ONLY USE THE FOLLOWING IF USING THE DB-BASED ADMIN MENU !!!
-- Insert new menu option for admin menu db table
-- !!! ONLY USE THE FOLLOWING IF USING THE DB-BASED ADMIN MENU !!!


# Dynamic-level db-based menu
delete from `ad_menu` where title = 'Admin IP';
SET @mid=0;
SELECT @mid:=menu_id
FROM ad_menu
WHERE title = 'Configuration';
insert into `ad_menu` (`menu_id`, `parent_id`, `title`, `icon`, `href`, `language_id`, `sort_order`) values(NULL,@mid,'Admin IP','user.png','admin/index.php?controller=admin_ip',1,5);

Also, I am not sure if I am using the DB-ADMIN MENUE

Thanks

Running v1.5.5.1


Active Member

Posts

Joined
Thu Dec 04, 2008 9:17 pm

Post by Qphoria » Mon Jan 12, 2009 2:46 am

Nobody is running the db-admin because I never released it. It is planned for v0.8

So just run the top 3 lines in your phpmyadmin

Code: Select all

-- Insert the following into your database to create the new settings.
delete from `setting` where `group` = 'admin_ip';
insert into `setting` (`type`, `group`, `key`, `value`) values('global','admin_ip','admin_ip_address','0.0.0.0');
insert into `setting` (`type`, `group`, `key`, `value`) values('global','admin_ip','admin_ip_status','0');

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Jacob » Mon Jan 12, 2009 4:06 am

Thanks again Q

That is my first ever sql run  :)

Running v1.5.5.1


Active Member

Posts

Joined
Thu Dec 04, 2008 9:17 pm

Post by Jacob » Mon Jan 12, 2009 4:34 am

And my first successful installment of a contribution  ;D

Running v1.5.5.1


Active Member

Posts

Joined
Thu Dec 04, 2008 9:17 pm

Post by Qphoria » Mon Jan 12, 2009 6:00 am

good to hear:)

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 4 guests