 | [Solved] how to uninstall sql |  |
 Posted: 06/22/2007 2:31 PM |
 |
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Nov 01, 2006
Local time: 11:30 AM
Location: Denver, PA
|
|
|
|
|
 |
Hi Nightrider, I installed a mod that is not working correctly for me and I would like to uninstall my edits, and run through easyMOD. Can you help me with uninstalling the SQL from it. This is what was run through phpmyadmin
| Code:
|
INSERT INTO phpbb_config values ('banner_source', 'logo_phpBB.gif');
INSERT INTO phpbb_config values ('banner_path', 'images/banners');
INSERT INTO phpbb_config values ('banner_cols', '2');
INSERT INTO phpbb_config values ('banner_width', '306');
INSERT INTO phpbb_config values ('banner_height', '155');
|
|
|
|
|
|
| Back to Top |
|
|
| Re: how to uninstall sql | |
| Posted: 06/23/2007 4:33 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 11:30 AM
Location: St Pete, FL
|
|
|
|
|
|
Here are the SQL queries that can delete these added records:
| Code:
|
DELETE FROM phpbb_config WHERE config_name='banner_source';
DELETE FROM phpbb_config WHERE config_name='banner_path';
DELETE FROM phpbb_config WHERE config_name='banner_cols';
DELETE FROM phpbb_config WHERE config_name='banner_width';
DELETE FROM phpbb_config WHERE config_name='banner_height';
|
If you want to run this through EM, this is the MOD script you could use:
| Code:
|
################################################################# #########################
## MOD Title: Delete Banner Config Records from Database...
## MOD Author: Nightrider < > (Blake) http://4fxearth.net/phpBB2
## MOD Description: This MOD will remove 5 Banner MOD records from the phpbb_config table...
## MOD Version: 1.0.0
##
## Installation Level: easy
## Installation Time: 1 minute using EM...
## Files To Edit: 0
## Included Files: 0
###################################################################### ####################
#
#-----[ SQL ]------------------------------------------
#
DELETE FROM phpbb_config WHERE config_name='banner_source';
DELETE FROM phpbb_config WHERE config_name='banner_path';
DELETE FROM phpbb_config WHERE config_name='banner_cols';
DELETE FROM phpbb_config WHERE config_name='banner_width';
DELETE FROM phpbb_config WHERE config_name='banner_height';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] how to uninstall sql | |
| Posted: 06/23/2007 7:36 AM |
|
|
|
|
|
| Caravan |
| Posts |
282 |
| Word Cnt. |
31,380 |
| BDay |
Apr 14 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Nov 01, 2006
Local time: 11:30 AM
Location: Denver, PA
|
|
|
|
|
|
Thank you bunches!  |
|
|
|
|
| Back to Top |
|
|
| Re: how to uninstall sql | |
| Posted: 06/23/2007 6:53 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:30 AM
Location: St Pete, FL
|
|
|
|
|
|
As always, you're quite welcome FTM!!!
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
