Bazy danych SQL - Jak usunac modyfikacje z bazy?
Manieq_ - 30-03-2014, 19:23
Temat postu: Jak usunac modyfikacje z bazy?
Witam!
Jak mogę usunąć modyfikacje z bazy?
Chodzi o plus minus by lui.
Jak sie wgrywało moda to robilo sie zapytanie do bazy, a teraz chciałbym to cale zapytanie usunąć? To jak usunąć, żeby w bazie nie było ani śladu zapytania do bazy z plusow i minusow by lui?
[ Dodano: 31-03-2014, 19:36 ]
Pomoże ktoś?
Scooby?! - 31-03-2014, 22:09
Wklej te zapytanie to ktoś Ci odwróci albo usuń tabele przez myadmina po kolei patrząc na to co tam było create itd. i ręcznie pousuwaj.
Manieq_ - 01-04-2014, 21:38
Prosze cały kod:
| Kod: |
INSERT INTO phpbb_config SET config_name = 'plusminus_on_off', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_pod_avatarem', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_paginacja', config_value = '20';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow', config_value = '600';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow', config_value = '030';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_ban', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_ban1', config_value = '4';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_pw', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_lista_goscie', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_mod_ost', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_mod_ost1', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_zakaz_pisania_ile', config_value = '3';
INSERT INTO phpbb_config SET config_name = 'plusminus_zakaz_pisania', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_forum_disable_mod', config_value = '';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow_napis', config_value = '000000';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow_ramka', config_value = 'FFFFFF';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow_napis', config_value = '000000';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow_ramka', config_value = 'FFFFFF';
INSERT INTO phpbb_config SET config_name = 'plusminus_limit_plusow', config_value = '0';
ALTER TABLE `phpbb_users`
ADD `user_plusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_minusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_disallowed_write` TINYINT ( 1 ) DEFAULT '0' NOT NULL,
ADD `user_banedd` TINYINT ( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `phpbb_posts`
ADD `post_plusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `post_minusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ;
CREATE TABLE `phpbb_plusminus` (
`pm_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`post_id` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_time` INT ( 32 ) NOT NULL ,
`pm_from` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_to` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_type` INT ( 2 ) NOT NULL ,
`pm_reason` VARCHAR ( 255 ) ,
PRIMARY KEY ( `pm_id` )
); |
Te tabele usunąłem:
| Kod: |
ALTER TABLE `phpbb_users`
ADD `user_plusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_minusp` INT( 6 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `user_disallowed_write` TINYINT ( 1 ) DEFAULT '0' NOT NULL,
ADD `user_banedd` TINYINT ( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE `phpbb_posts`
ADD `post_plusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `post_minusp` INT( 2 ) UNSIGNED DEFAULT '0' NOT NULL ;
CREATE TABLE `phpbb_plusminus` (
`pm_id` INT ( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`post_id` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_time` INT ( 32 ) NOT NULL ,
`pm_from` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_to` INT ( 11 ) UNSIGNED NOT NULL ,
`pm_type` INT ( 2 ) NOT NULL ,
`pm_reason` VARCHAR ( 255 ) ,
PRIMARY KEY ( `pm_id` ) |
A co z tym? Też należałoby to usunąć? Czy może zostać?
Jak to można usunąć?
| Kod: |
INSERT INTO phpbb_config SET config_name = 'plusminus_on_off', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_pod_avatarem', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_paginacja', config_value = '20';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow', config_value = '600';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow', config_value = '030';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_ban', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_ban1', config_value = '4';
INSERT INTO phpbb_config SET config_name = 'plusminus_auto_pw', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_lista_goscie', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_mod_ost', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_mod_ost1', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_zakaz_pisania_ile', config_value = '3';
INSERT INTO phpbb_config SET config_name = 'plusminus_zakaz_pisania', config_value = '1';
INSERT INTO phpbb_config SET config_name = 'plusminus_forum_disable_mod', config_value = '';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow_napis', config_value = '000000';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_plusow_ramka', config_value = 'FFFFFF';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow_napis', config_value = '000000';
INSERT INTO phpbb_config SET config_name = 'plusminus_kolor_listy_minusow_ramka', config_value = 'FFFFFF';
INSERT INTO phpbb_config SET config_name = 'plusminus_limit_plusow', config_value = '0'; |
Woytec - 02-04-2014, 20:01
http://przemo.org/phpBB2/...p=580892#580892
|
|
|
