Mod Sql Help

Looking for a MOD? Have a MOD request? Post here for help. (Note: This forum is community supported; phpBB does not have official MOD authors)
Scam Warning
Locked
User avatar
shadow07
Registered User
Posts: 34
Joined: Fri Nov 23, 2007 12:25 am

Mod Sql Help

Post by shadow07 »

Ok um I didnt know where to put this. But how do you make this do the opposite? Like make it remove the sql mods if I wanted to remove a mod completely.

I dont want to accidently rmeove any user or post stuff..

Heres a snipet of one of the sql mod codes I want to remove...

Code: Select all

#-----[ SQL ]-------------------------------------------
#
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_enable',2);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_ban',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_delay',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_ports','005008fd0c3819bc1f401f90');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_cache_time',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_block',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_sort','last_checked,DESC');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('proxy_user_agent','phpBB Open Proxy Detector');
CREATE TABLE phpbb_proxies (
   ip_address char(8) DEFAULT '0' NOT NULL,
   behavior tinyint(2) DEFAULT '0' NOT NULL,
   port char(4) DEFAULT '0' NULL,
   last_checked int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (ip_address)
);
#

User avatar
dellsystem
Former Team Member
Posts: 3879
Joined: Sat Apr 09, 2005 8:54 pm
Location: Montreal
Name: Wendy
Contact:

Re: Mod Sql Help

Post by dellsystem »

It doesn't hurt to keep them there, but if you just want to keep your db size down then you can do this:

DROP TABLE phpbb_proxies;

and

DELETE FROM phpbb_config WHERE config_name = 'proxy_enable';
etc
Former moderator and website team member | My MODs, and more (GitHub)

Locked

Return to “[3.0.x] MOD Requests”