Board3

Code: Select all

INSERT INTO phpbb_portal_config( config_name, config_value )
VALUES ('portal_gallery', 1);
INSERT INTO phpbb_portal_config( config_name, config_value )
VALUES ('portal_gallery_center', 0);
INSERT INTO phpbb_portal_config( config_name, config_value )
VALUES ('album_id', 0);
INSERT INTO phpbb_portal_config( config_name, config_value )
VALUES ('images_number', 1);
INSERT INTO phpbb_portal_config( config_name, config_value )
VALUES ('images_sort', 0);

Code: Select all

DELETE FROM `phpbb_portal_config` WHERE CONVERT(`phpbb_portal_config`.`config_name` USING utf8) = 'portal_gallery' LIMIT 1;
DELETE FROM `phpbb_portal_config` WHERE CONVERT(`phpbb_portal_config`.`config_name` USING utf8) = 'portal_gallery_center' LIMIT 1;
DELETE FROM `phpbb_portal_config` WHERE CONVERT(`phpbb_portal_config`.`config_name` USING utf8) = 'album_id' LIMIT 1;
DELETE FROM `phpbb_portal_config` WHERE CONVERT(`phpbb_portal_config`.`config_name` USING utf8) = 'images_number' LIMIT 1;
DELETE FROM `phpbb_portal_config` WHERE CONVERT(`phpbb_portal_config`.`config_name` USING utf8) = 'images_sort' LIMIT 1;