delete from whos_online where time_last_click < '1718126087'
insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'cpsq869po03ooec1ct2q91r7gf', '18.225.98.177', '1718126987', '1718126987', '/faq.php/megastore_theme/megastore_js/notifications/dist/css/fonts/megastore_theme/megastore_styles/includes/languages/english/images/icon.gif')
select banners_id, date_scheduled from banners where date_scheduled != ''
CREATE TABLE IF NOT EXISTS `buyshop_theme` (
`color_value` varchar(200) NOT NULL,
`slider_type` varchar(200) NOT NULL,
`option_themecolor` varchar(200) NOT NULL,
`option_textcolor` varchar(200) NOT NULL,
`option_linkcolor` varchar(200) NOT NULL,
`option_linkhovercolor` varchar(200) NOT NULL,
`option_bgcolor` varchar(200) NOT NULL,
`option_captions_text_color` varchar(200) NOT NULL,
`option_captions_text_google` varchar(200) NOT NULL
) DEFAULT CHARSET=latin1 AUTO_INCREMENT=2
CREATE TABLE IF NOT EXISTS `custom_menu_block` (
`menu_block_id` int(11) NOT NULL,
`menu_block_content` text NOT NULL,
PRIMARY KEY (`menu_block_id`)
) DEFAULT CHARSET=latin1 AUTO_INCREMENT= 0
CREATE TABLE IF NOT EXISTS `custom_product_block` (
`menu_block_id` int(11) NOT NULL,
`menu_block_content` text NOT NULL,
PRIMARY KEY (`menu_block_id`)
) DEFAULT CHARSET=latin1 AUTO_INCREMENT= 0
CREATE TABLE IF NOT EXISTS `buyshop_stickers` (
`sticker_new_status` varchar(200) NOT NULL,
`sticker_new_position` varchar(200) NOT NULL,
`sticker_sale_status` varchar(200) NOT NULL,
`sticker_sale_position` varchar(200) NOT NULL,
`sticker_options_status` varchar(200) NOT NULL,
`sticker_options_position` varchar(200) NOT NULL
) DEFAULT CHARSET=latin1 AUTO_INCREMENT=2
select distinct c.categories_id, c.parent_id, cd.categories_id, cd.categories_name from categories c, categories_description cd, categories_classes cc where c.categories_id = cd.categories_id and c.parent_id = '0' and cd.language_id='3' and c.cat_class_id = cc.cat_class_id and cc.cat_visible_everywhere = '1' and c.cat_position < '2' order by sort_order, cd.categories_name