You are not logged in.
Pages: 1
INSERT INTO phpbb_config VALUES ('ignore_or_hide_forums', 1);
ALTER TABLE phpbb_users ADD user_ignore_hide_forums VARCHAR(255);
ALTER TABLE `phpbb_forums` ADD `forum_count_posts` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `forum_last_post_id`;
ALTER TABLE phpbb_users ADD user_can_post TINYINT(1) default '1'
Basically, could someone supply the safest commands to "undo" these changes, please? Thanks.[/code]
Offline
INSERT INTO phpbb_config VALUES ('ignore_or_hide_forums', 1); ALTER TABLE phpbb_users ADD user_ignore_hide_forums VARCHAR(255); ALTER TABLE `phpbb_forums` ADD `forum_count_posts` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `forum_last_post_id`; ALTER TABLE phpbb_users ADD user_can_post TINYINT(1) default '1'
Basically, could someone supply the safest commands to "undo" these changes, please? Thanks.[/code]
For the first one, you would have to know what the column name is of the column containing the 'ignore_or_hide_forums' string value.
Then you can delete that entry based on that match...
[code]
delete from phpbb_config where column_name = 'ignore_or_hid_forums';
[/code]
something like that...
this should cover the rest..
but if you are real worried about it..either just leave them in there (if you arent using it..it doesnt matter) or do a dump and test locally to make sure they do what you want...
[code]
alter table phpbb_users drop user_ignore_hide_forums;
alter table phpbb_forums drop forum_count_posts;
alter table phpbb_users drop user_can_post ;
[/code]
"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍
Offline
dibblethewrecker wrote:INSERT INTO phpbb_config VALUES ('ignore_or_hide_forums', 1);
Basically, could someone supply the safest commands to "undo" these changes, please? Thanks.[/code]
For the first one, you would have to know what the column name is of the column containing the 'ignore_or_hide_forums' string value.
Then you can delete that entry based on that match...
[code]
delete from phpbb_config where column_name = 'ignore_or_hid_forums';
[/code]
phpbb_config has two columns: config_name and config_value
So will you command delete the entries in both columns based on the match in the first?
Thanks cactus
Offline
yeah.
delete from phpbb_config where config_name = 'ignore_or_hide_forums';
"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍
Offline
Pages: 1