yourWBB | [WBB 2.3.x] Allg. Fragen und Probleme | SQL abfrage wieder rückgengig machen!

code:

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:

INSERT INTO `bb1_optiongroups` VALUES (20, 'marquee', 20, 2);	

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueeonoff', '1', 'truefalse', '1', '2'
);

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueehintergrundfarbe', '#CC0000', 'text', '2', '2'
);

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueetextfarbe', '#FFFFFF', 'text', '3', '2'
);

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueesize', '12', 'text', '4', '2'
);

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueespeed', '3', 'text', '5', '2'
);

INSERT INTO `bb1_options` ( `optionid` , `optiongroupid` , `varname` , `value` , `optioncode` , `showorder` , `acpmode` ) 
VALUES (
'', '20', 'marqueetext', 'Wichtig Ankündigung', 'textarea', '6', '2'
);

DELETE FROM `bb1_options` WHERE varname='marqueetext'; DELETE FROM `bb1_options` WHERE varname='marqueespeed'; DELETE FROM `bb1_options` WHERE varname='marqueesize'; DELETE FROM `bb1_options` WHERE varname='marqueetextfarbe'; DELETE FROM `bb1_options` WHERE varname='marqueehintergrundfarbe'; DELETE FROM `bb1_options` WHERE varname='marqueeonoff'; DELETE FROM `bb1_optiongroups WHERE optiongroupid=20;