CREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL,
UNIQUE (
`ad_id`
)
);
INSERT INTO `phpbb_ads` ( `ad_type` , `ad_id` , `ad_code`, `ad_name` )
VALUES (
'first_post', '1', '<script type="text/javascript"><!--
google_ad_client = "pub-2930568312118905";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_channel ="";
google_ad_type = "text_image";
google_color_link = "0000FF";
google_color_url = "008000";
google_color_text = "000000";
google_color_border = "336699";
google_color_bg = "FFFFFF";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>', 'Defualt'
);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_after_post', '1'
);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_every_post', '0'
);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_who', 'all'
);
INSERT INTO `phpbb_config` ( `config_name` , `config_value` )
VALUES (
'ad_forums', 'all'
);
Wchodze w phpMyAdmin > SQL > Wklejam ten kod i daje Wykonaj
I wyskakuje mi takie coś:
Błąd
zapytanie SQL:
CREATE TABLE `phpbb_ads` (
`ad_type` VARCHAR( 10 ) NOT NULL ,
`ad_id` TINYINT( 5 ) NOT NULL ,
`ad_code` TEXT NOT NULL ,
`ad_name` TINYINT( 25 ) NOT NULL ,
UNIQUE (
`ad_id`
)
);
MySQL zwrócił komunikat:
#1050 - Table 'phpbb_ads' already exists
To się tyczy forum Przemo i wprowadzenia modyfikacji "baner pod X postem"
