SET NAMES utf8mb4;
SET time_zone = "+00:00";

START TRANSACTION;

-- =========================================================
-- ACCESS SETTINGS
-- =========================================================

INSERT INTO access_settings
(
    id,
    registration_enabled,
    manual_approval,
    email_verification,
    default_role,
    login_required_free,
    guest_download_limit,
    guest_limit_period,
    blocked_domains,
    admin_notes
)
VALUES
(
    1,
    1,
    0,
    0,
    'user',
    0,
    0,
    'daily',
    NULL,
    NULL
);

-- =========================================================
-- AUTH LOGIN / SIGNUP POPUP
-- Keep original Royal Apps style/settings.
-- =========================================================

INSERT INTO auth_popup_settings
(
    id,
    logo_icon,
    logo_name,
    grad_start,
    grad_end,
    login_headline,
    login_subline,
    login_btn_text,
    forgot_show,
    forgot_text,
    signup_headline,
    signup_subline,
    signup_btn_text,
    name_field,
    headline_size,
    input_size,
    btn_size,
    popup_width,
    popup_radius,
    btn_color,
    btn_text_color,
    input_focus_color,
    label_color,
    popup_bg,
    overlay_color,
    divider_show,
    divider_text,
    google_show,
    facebook_show,
    instagram_show,
    google_text,
    facebook_text,
    instagram_text,
    close_backdrop,
    close_esc
)
VALUES
(
    1,
    '👑',
    'Royal Apps',
    '#1a5c34',
    '#2ecc71',
    'Welcome Back!',
    'Sign in to access your downloads, wishlist and premium tools.',
    'Login to Royal Apps',
    1,
    'Forgot password?',
    'Join Royal Apps',
    'Create your free account and start downloading instantly.',
    'Create Free Account',
    1,
    22,
    13,
    15,
    440,
    24,
    '#27ae60',
    '#ffffff',
    '#27ae60',
    '#27ae60',
    '#ffffff',
    '#0a140f',
    1,
    'or continue with',
    1,
    1,
    0,
    'Continue with Google',
    'Continue with Facebook',
    'Continue with Instagram',
    1,
    1
);

-- =========================================================
-- EMAIL SETTINGS
-- Credentials remain empty. Installer fills buyer SMTP data.
-- =========================================================

INSERT INTO email_settings
(
    id,
    sender_name,
    sender_email,
    reply_to,
    smtp_host,
    smtp_port,
    smtp_username,
    smtp_password,
    smtp_encryption
)
VALUES
(
    1,
    'Royal Apps',
    NULL,
    NULL,
    NULL,
    587,
    NULL,
    NULL,
    'tls'
);

-- =========================================================
-- CORE APPLICATION SETTINGS
-- Installer updates site name, logo, favicon, email, language,
-- timezone and other buyer-specific values after this seed.
-- =========================================================

INSERT INTO settings
(
    setting_key,
    setting_value
)
VALUES
('sidebar_active', 'dashboard'),
('site_name', 'Royal Apps'),
('site_tagline', 'Download trusted software, apps, tools and games.'),
('site_logo', ''),
('site_favicon', ''),
('admin_email', ''),
('maintenance_mode', '0'),
('tagline', 'Download Free Software'),
('timezone', 'UTC'),
('email', ''),
('site_timezone', 'UTC'),
('site_language', 'en'),
('enabled_languages', '["en"]'),
('maintenance_title', 'We are improving the site'),
('maintenance_message', 'Our website is currently undergoing scheduled maintenance. Please check back soon.');

-- =========================================================
-- OPERATING SYSTEMS
-- =========================================================

INSERT INTO operating_systems
(
    id,
    name,
    slug,
    icon,
    description,
    custom_url,
    is_active,
    sort_order
)
VALUES
(1, 'Windows', 'windows', '', 'Windows software collection', NULL, 1, 1),
(2, 'Android', 'android', '', 'Android apps and tools', NULL, 1, 2),
(3, 'Mac', 'mac', '', 'Mac software collection', NULL, 1, 3);

-- =========================================================
-- NAVIGATION SETTINGS
-- =========================================================

INSERT INTO navigation_menu_settings
(
    id,
    desktop_text_color,
    desktop_hover_text_color,
    desktop_hover_bg,
    desktop_hover_opacity,
    desktop_active_text_color,
    desktop_active_bg,
    desktop_icon_color,
    desktop_active_icon_color,
    mobile_bg,
    mobile_text,
    mobile_active_bg,
    mobile_active_text
)
VALUES
(
    1,
    '#ffffff',
    '#ffffff',
    '#2ec26b',
    1.00,
    '#ffffff',
    '#2ec26b',
    '#ffffff',
    '#27ae60',
    '#27ae60',
    '#ffffff',
    '#ffffff',
    '#27ae60'
);

INSERT INTO navigation_menu_items
(
    id,
    sort_order,
    label,
    url,
    icon_url,
    is_active,
    show_desktop,
    show_mobile,
    mobile_direct
)
VALUES
(1, 1, 'Home', '/home', 'uploads/navigation-icons/icons8-home-48-1785063011-9601.svg', 1, 1, 1, 0),
(2, 2, 'Windows', '/windows', 'uploads/navigation-icons/icons8-windows-48-1785059043-9623.svg', 0, 1, 1, 1),
(3, 3, 'Android', '/android', 'uploads/navigation-icons/icons8-android-phone-48-1785059210-9090.svg', 0, 1, 1, 1),
(4, 4, 'Mac', '/mac', 'uploads/navigation-icons/icons8-apple-48-1785058705-7774.svg', 0, 1, 1, 1),
(5, 5, 'Top Downloads', 'top-downloads', 'uploads/navigation-icons/icons8-star-of-bethlehem-48-1785059720-5454.svg', 0, 1, 1, 0),
(6, 6, 'Pricing', 'pricing', 'uploads/navigation-icons/icons8-get-a-discount-48-1785060457-4140.svg', 0, 1, 0, 0);

-- =========================================================
-- INFO DROPDOWN
-- =========================================================

INSERT INTO info_dropdown_settings
(
    id,
    icon,
    iconSize,
    iconColor,
    iconHoverColor,
    iconActiveColor,
    btnSize,
    btnBg,
    btnHoverBg,
    btnActiveBg,
    btnBorder,
    headerShow,
    headerTitle,
    links
)
VALUES
(
    1,
    'i',
    20,
    '#00c241',
    '#ffffff',
    '#ffffff',
    30,
    '#ffffff',
    '#00c241',
    '#00c241',
    '#ffffff',
    0,
    '',
    '[{"type":"title","group_title":"","label":"Legal","url":"","icon":"","show":1,"sort_order":1},{"type":"link","group_title":"","label":"About Us","url":"/about-us","icon":"📜","show":1,"sort_order":2},{"type":"link","group_title":"","label":"Privacy Policy","url":"/privacy-policy","icon":"ℹ","show":1,"sort_order":3},{"type":"link","group_title":"","label":"Terms of Use","url":"/terms-of-use","icon":"📋","show":1,"sort_order":4}]'
);

-- =========================================================
-- DOWNLOAD POPUP SETTINGS
-- Keep original popup visual style but no private branding.
-- =========================================================

INSERT INTO popup_settings
(
    id,
    settings_json
)
VALUES
(
    1,
    '{"enabled":true,"width":620,"blur":true,"overlayDarkness":65,"radius":24,"footerIcon":"✓","footerText":"Royal Apps Genuine Download","footerSubText":"Verified Safe","footerGradient":"linear-gradient(135deg,#17703e 0%,#27ae60 36%,#35cf79 68%,#1f8e4e 100%)","badges":["🔒 100% Secure","✅ Virus Scanned","🛡 No Malware","No Adware","Fast Download","CDN Powered"],"autoClose":0,"closeBackdrop":true,"closeEsc":true}'
);

-- =========================================================
-- PAYMENT SETTINGS
-- No credentials. Installer fills buyer data.
-- =========================================================

INSERT INTO payment_settings
(
    id,
    currency,
    currency_symbol,
    mode,
    tax_rate,
    tax_enabled,
    invoice_prefix,
    success_url,
    cancel_url,
    allow_coupon,
    auto_activate,
    manual_review,
    admin_notes,

    razorpay_enabled,
    razorpay_key,
    razorpay_secret,
    razorpay_webhook_secret,

    stripe_enabled,
    stripe_key,
    stripe_secret,
    stripe_webhook_secret,

    paypal_enabled,
    paypal_key,
    paypal_secret,
    paypal_webhook_id,

    twocheckout_enabled,
    twocheckout_key,
    twocheckout_secret,
    twocheckout_merchant_code,

    paystack_enabled,
    paystack_public_key,
    paystack_secret_key,
    paystack_webhook_secret,

    flutterwave_enabled,
    flutterwave_public_key,
    flutterwave_secret_key,
    flutterwave_webhook_secret,

    mollie_enabled,
    mollie_api_key,
    mollie_webhook_secret,
    mollie_extra,

    bank_enabled,
    bank_key,
    bank_secret,
    bank_extra,

    default_gateway
)
VALUES
(
    1,
    'USD',
    '$',
    'test',
    0.00,
    0,
    'INV-',
    http://yourwebsiteurl/public/?route=checkout/success,
    http://yourwebsiteurl/shop/public/?route=checkout/cancel,
    1,
    1,
    0,
    NULL,

    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,
    0, NULL, NULL, NULL,

    NULL
);

-- =========================================================
-- HOMEPAGE CARD SETTINGS
-- No software IDs selected in clean installation.
-- =========================================================

INSERT INTO homepage_card_box_settings
(
    id,
    box_key,
    title,
    icon,
    title_color_mode,
    title_color_1,
    title_color_2,
    box_color_mode,
    box_color_1,
    box_color_2,
    button_enabled,
    button_text,
    button_color_mode,
    button_color_1,
    button_color_2,
    card_color_mode,
    card_color_1,
    card_color_2,
    items_per_row,
    total_items,
    latest_mode,
    latest_type,
    sort_order
)
VALUES
(
    1,
    'featured',
    'Featured Downloads',
    '📚',
    'gradient',
    '#1a7a3b',
    '#6318af',
    'solid',
    '#ffffff',
    '#ffffff',
    1,
    'Download',
    'gradient',
    '#920c75',
    '#18914c',
    'gradient',
    '#e8eff8',
    '#d5ecd7',
    2,
    6,
    'latest_auto',
    'all',
    0
),
(
    2,
    'latest',
    'Latest Downloads',
    '🆕',
    'gradient',
    '#166eb1',
    '#199310',
    'solid',
    '#ffffff',
    '#ffffff',
    1,
    'Download',
    'gradient',
    '#10942a',
    '#5911a2',
    'gradient',
    '#f9f0fb',
    '#f0fcff',
    1,
    6,
    'latest_auto',
    'all',
    1
),
(
    3,
    'popular',
    'Popular Downloads',
    '💾',
    'gradient',
    '#5925a7',
    '#2f8c0d',
    'solid',
    '#ffffff',
    '#000000',
    1,
    'Download',
    'gradient',
    '#1d962b',
    '#ad5710',
    'gradient',
    '#fff5f5',
    '#f5fbff',
    1,
    6,
    'latest_auto',
    'all',
    2
);

INSERT INTO essentials_box_settings
(
    id,
    enabled,
    title,
    subtitle
)
VALUES
(
    1,
    1,
    '⭐ Essentials',
    'Top tools users install first'
);

INSERT INTO popular_categories_settings
(
    id,
    visible,
    icon,
    title,
    subtitle,
    categories_json,
    accent,
    card_bg,
    bg,
    `limit`,
    columns_count,
    show_count,
    show_icon,
    count_label,
    card_style,
    bg_color,
    card_bg_color,
    title_color,
    text_color,
    accent_color,
    categories
)
VALUES
(
    1,
    1,
    '🗂️',
    'Popular Categories',
    '',
    '[]',
    '#27ae60',
    '#f9fbff',
    '#ffffff',
    6,
    3,
    1,
    1,
    'Software',
    'solid',
    '#ffffff',
    '#f9fbff',
    '#1a1a2e',
    '#666666',
    '#27ae60',
    '[]'
);

INSERT INTO topdownloadsettings
(
    id,
    visible,
    title,
    selectedIds
)
VALUES
(
    1,
    1,
    'Top Downloads',
    '[]'
);

INSERT INTO trending_download_settings
(
    id,
    visible,
    icon,
    title,
    titleCharLimit,
    titleSize,
    titleFont,
    titleWeight,
    titleColor,
    titleGrad,
    titleGrad1,
    titleGrad2,
    titleGrad3,
    bg1,
    bg2,
    bg3,
    borderColor,
    borderWidth,
    ribShow,
    rib1,
    rib2,
    ribText,
    ribFontSize,
    ribFont,
    ribWeight,
    ribPy,
    ribPx,
    ribTop,
    ribLeft,
    ribRight,
    ribRotate,
    selectedIds
)
VALUES
(
    1,
    1,
    '🔥',
    'Trending Downloads',
    25,
    22,
    '',
    '700',
    '#1a7a3c',
    1,
    '#1a7a3c',
    '#27ae60',
    '#f5a623',
    '#edfbf3',
    '#f4fff8',
    '#e6f7ed',
    '#28af49',
    4,
    1,
    '#af5728',
    '#752ecc',
    '#ffffff',
    10,
    '',
    '700',
    0,
    0,
    0,
    15,
    NULL,
    0,
    '[]'
);

INSERT INTO stats_bar_settings
(
    id,
    updated_text,
    strip_bg,
    badge_bg,
    badge_color,
    served_mode,
    served_label,
    served_manual,
    served_base,
    served_inc,
    served_start_date,
    today_mode,
    today_label,
    today_manual,
    today_base,
    today_inc,
    today_start_date,
    total_mode,
    total_label,
    total_manual,
    total_base,
    total_inc,
    total_start_date
)
VALUES
(
    1,
    'Updated recently',
    '#dbf0db',
    '#edfbf3',
    '#27ae60',
    'manual',
    'Served downloads',
    0,
    0,
    0,
    NULL,
    'manual',
    'New items today',
    0,
    0,
    0,
    NULL,
    'manual',
    'Items total',
    0,
    0,
    0,
    NULL
);

INSERT INTO subscription_settings
(
    id,
    default_badge,
    show_savings,
    show_trial,
    admin_notes
)
VALUES
(
    1,
    'Most Popular',
    1,
    0,
    ''
);

INSERT INTO site_settings
(
    id,
    setting_key,
    setting_value
)
VALUES
(
    1,
    'cardsectionsettings',
    '{"sources":{"featured_ids":[],"popular_ids":[],"latest_mode":"latest_auto","latest_count":6,"latest_type":"all"},"content":{"title_limit":30,"desc_limit":40,"show_name":1,"show_desc":1,"show_cat":1,"show_size":1,"show_dl":1,"show_count":1,"show_stars":1},"text_styles":{"name":{"color":"#144828","size":16,"font":"Poppins"},"desc":{"color":"#144828","size":12,"font":"Inter"},"cat":{"color":"#000000","size":11,"font":"Inter"},"size":{"color":"#56675b","size":11,"font":"Inter"},"dl":{"color":"#000000","size":11,"font":"Inter"},"count":{"color":"#000000","size":11,"font":"Inter"},"stars":{"color":"#008f1d","size":13,"font":"Inter"}}}'
);

INSERT INTO support_faqs
(
    id,
    faq_type,
    question,
    answer,
    sort_order,
    is_active
)
VALUES
(
    1,
    'pricing',
    'How do I download software?',
    'Open any software page and click the download button. Your download history will appear automatically in your dashboard.',
    1,
    1
),
(
    2,
    'pricing',
    'How do I access purchased software?',
    'Purchased software and plans are shown in your purchase history and subscription section.',
    2,
    1
),
(
    3,
    'pricing',
    'How do I contact support?',
    'You can submit a support ticket or send a message from Help and Support.',
    3,
    1
),
(
    4,
    'pricing',
    'How do I delete my account?',
    'Open Help and Support and use the Delete Account option. Your request will be sent for review.',
    4,
    1
);

INSERT INTO footersettings (`id`, `enabled`, `desktopshow`, `mobileshow`, `bg`, `bordershow`, `bordercolor`, `paddingy`, `logoShow`, `logoSize`, `leftshow`, `lefticon`, `lefttext`, `lefticonsize`, `lefttextsize`, `leftcolor`, `centershow`, `centerlayout`, `centergap`, `linksgap`, `centergroups`, `sepshow`, `sepicon`, `sepsize`, `sepcolor`, `rightshow`, `rightheart`, `righttext`, `rightheartcolor`, `righttextcolor`, `righttextsize`, `align`, `mobilelayout`, `fontfamily`, `basecolor`, `copytext`, `copycolor`, `block3show`, `block3layout`, `block3bg`, `copyshow`, `copysize`, `bottomlinksshow`, `bottomlinkslayout`, `bottomlinksgap`, `bottomlinkscolor`, `bottomlinkshover`, `bottomlinksfont`, `bottomlinkssize`, `bottomlinksjson`, `top_left_json`, `top_center_json`, `middle_strip_json`, `bottom_left_json`, `bottom_center_json`, `bottom_social_json`, `bottom_right_json`, `top_bg`, `top_border_show`, `top_border_color`, `top_radius`, `top_padding_y`, `top_padding_x`, `top_left_show`, `top_left_logo`, `top_left_logo_width`, `top_left_title`, `top_left_desc`, `top_left_title_color`, `top_left_desc_color`, `top_left_title_size`, `top_left_desc_size`, `top_left_title_font`, `top_left_desc_font`, `top_center_show`, `top_center_groups`, `top_right_show`, `top_right_icon`, `top_right_text`, `top_right_subtext`, `top_right_icon_color`, `top_right_text_color`, `top_right_subtext_color`, `top_right_text_size`, `top_right_subtext_size`, `top_right_font`, `top_right_style`, `middle_bg`, `middle_border_show`, `middle_border_color`, `middle_radius`, `middle_padding_y`, `middle_padding_x`, `middle_image`, `middle_image_alt`, `middle_link`, `middle_open_new_tab`, `bottom_bg`, `bottom_border_show`, `bottom_border_color`, `bottom_radius`, `bottom_padding_y`, `bottom_padding_x`, `bottom_left_show`, `bottom_left_text`, `bottom_left_color`, `bottom_left_size`, `bottom_left_font`, `bottom_center_show`, `bottom_center_links`, `bottom_center_gap`, `bottom_center_color`, `bottom_center_hover_color`, `bottom_center_size`, `bottom_center_font`, `bottom_right_show`, `bottom_right_socials`, `bottom_right_gap`, `bottom_right_icon_size`, `bottom_right_icon_color`, `bottom_right_hover_color`, `top_show`, `middle_show`, `bottom_show`, `block1show`, `block1layout`, `block1bg`, `block2show`, `block2layout`, `block2bg`, `leftdesc`, `leftdescsize`, `leftdesccolor`, `midleftshow`, `midlefticon`, `midlefttext`, `midleftsubtext`, `midcentershow`, `midcentericon`, `midcentertext`, `midcentersubtext`, `midrightshow`, `midrighticon`, `midrighttext`, `midfourthshow`, `midfourthicon`, `midfourthtext`, `midfourthsubtext`, `midrightsubtext`, `midiconcolor`, `midiconbg`, `midiconbgopacity`, `midtextcolor`, `midtitlecolor`, `midsubtitlecolor`, `midfont`, `midsize`, `midtitlesize`, `midsubtitlesize`, `midgap`, `middividershow`, `middividercolor`, `middividerheight`, `middividerwidth`, `midiconboxsize`, `midiconsize`, `miditemgap`, `midtextgap`) VALUES
(1, 1, 1, 1, '101c14', 1, 'f0f0f0', 0, 0, 18, 1, '👑', 'Royal Apps', 22, 18, '808080', 1, 'horizontal', 24, 10, '[{\"icon\":\"\",\"title\":\"Quick Links\",\"show\":1,\"showTitle\":1,\"direction\":\"vertical\",\"titleColor\":\"363636\",\"titleSize\":14,\"titleFont\":\"Inter, poppins\",\"linkColor\":\"646464\",\"linkHoverColor\":\"27ae60\",\"linkSize\":13,\"linkFont\":\"Inter, poppins\",\"links\":[{\"icon\":\"\",\"label\":\"Latest Software\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Popular Downloads\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Games\",\"url\":\"\",\"target\":\"self\"}]},{\"icon\":\"\",\"title\":\"Support\",\"show\":1,\"showTitle\":1,\"direction\":\"vertical\",\"titleColor\":\"363636\",\"titleSize\":14,\"titleFont\":\"Inter, sans-serif\",\"linkColor\":\"646464\",\"linkHoverColor\":\"27ae60\",\"linkSize\":13,\"linkFont\":\"Inter, sans-serif\",\"links\":[{\"icon\":\"\",\"label\":\"About Us\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Contact\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Help & FAQs\",\"url\":\"\",\"target\":\"self\"}]},{\"icon\":\"\",\"title\":\"Categories\",\"show\":1,\"showTitle\":1,\"direction\":\"vertical\",\"titleColor\":\"363636\",\"titleSize\":14,\"titleFont\":\"Inter, sans-serif\",\"linkColor\":\"646464\",\"linkHoverColor\":\"27ae60\",\"linkSize\":13,\"linkFont\":\"Inter, sans-serif\",\"links\":[{\"icon\":\"\",\"label\":\"Windows\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Android\",\"url\":\"\",\"target\":\"self\"},{\"icon\":\"\",\"label\":\"Mac\",\"url\":\"\",\"target\":\"self\"}]}]', 1, '❗', 14, '27ae60', 1, '❤️', 'ROYAL APPS', '#ff4d6d', '#137c36', 14, 'center', 'stack', 'Museo Sans Condensed', 'dfeee3', '© 2026 Royal Apps. All Rights Reserved.', 'a6a6a6', 1, 'horizontal', '#c4c4c4', 1, 13, 1, 'horizontal', 10, '757575', '27ae60', 'Inter, POPPINS', 13, '[{\"label\":\"Privacy Policy\",\"url\":\"#\",\"target\":\"self\"},{\"label\":\"Terms of Use\",\"url\":\"#\",\"target\":\"self\"},{\"label\":\"Contact\",\"url\":\"#\",\"target\":\"self\"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 0, 34, 26, 1, 'http://localhost/shop/storage/uploads/settings/newl.png', 120, '', 'Download trusted software, apps, tools and games with a clean experience across Windows, Android and Mac.', '#00661f', '#4e6555', 18, 13, 'Museo Sans Condensed, sans-serif', 'Museo Sans Condensed, sans-serif', 1, '[{\"title\":\"Quick Links\",\"show\":1,\"title_color\":\"#005218\",\"title_size\":14,\"link_color\":\"#3f8351\",\"link_hover_color\":\"#27ae60\",\"link_size\":13,\"links\":[{\"label\":\"Latest Software\",\"url\":\"latest.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Popular Downloads\",\"url\":\"popular-downloads.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Games\",\"url\":\"games.php\",\"target\":\"self\",\"show\":1}]},{\"title\":\"Support\",\"show\":1,\"title_color\":\"#004d1a\",\"title_size\":14,\"link_color\":\"#505e53\",\"link_hover_color\":\"#27ae60\",\"link_size\":13,\"links\":[{\"label\":\"Help & FAQs\",\"url\":\"help.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Terms of Service\",\"url\":\"terms.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Privacy Policy\",\"url\":\"privacy.php\",\"target\":\"self\",\"show\":1}]},{\"title\":\"Categories\",\"show\":1,\"title_color\":\"#004715\",\"title_size\":14,\"link_color\":\"#606c63\",\"link_hover_color\":\"#27ae60\",\"link_size\":13,\"links\":[{\"label\":\"Windows\",\"url\":\"get-os.php?slug=windows\",\"target\":\"self\",\"show\":1},{\"label\":\"Android\",\"url\":\"get-os.php?slug=android\",\"target\":\"self\",\"show\":1},{\"label\":\"Mac\",\"url\":\"get-os.php?slug=mac\",\"target\":\"self\",\"show\":1}]}]', 1, '❤', 'ROYAL APPS', 'Trusted downloads, cleaner experience', 'ff4d6d', 'ffffff', 'b7c9bd', 16, 12, 'Inter, sans-serif', 'badge', NULL, 1, NULL, 16, 12, 0, 'uploads/site/2nd.jpg', 'Royal Apps footer promo banner', NULL, 0, NULL, 1, NULL, 0, 18, 0, 1, '© 2026 Royal Apps. All Rights Reserved.', '#004d17', 13, 'Museo Sans Condensed, sans-serif', 1, '[{\"label\":\"About Us\",\"url\":\"about.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Contact\",\"url\":\"contact.php\",\"target\":\"self\",\"show\":1},{\"label\":\"Terms of Use\",\"url\":\"submit-software.php\",\"target\":\"self\",\"show\":1}]', 18, '#5f6d63', '#00a336', 13, 'Museo Sans Condensed', 1, '[{\"icon\":\"facebook\",\"label\":\"Facebook\",\"url\":\"#\",\"target\":\"blank\",\"show\":1},{\"icon\":\"twitter\",\"label\":\"Twitter\",\"url\":\"#\",\"target\":\"blank\",\"show\":1},{\"icon\":\"instagram\",\"label\":\"Instagram\",\"url\":\"#\",\"target\":\"blank\",\"show\":1},{\"icon\":\"telegram\",\"label\":\"Telegram\",\"url\":\"#\",\"target\":\"blank\",\"show\":1}]', 12, 18, 'ffffff', '27ae60', 1, 1, 1, 1, 'horizontal', '#f2f2f2', 1, 'horizontal', '#e3e3e3', 'Download Free Full version of Apps & Games for Windows, Mac and Android  Platform.', 14, '6e6e6e', 1, 'uploads/footer-icons/fast-20260913154608-5a21213748d9.png', 'High Speed', 'Fastest Download', 1, 'uploads/footer-icons/document-20260913155151-2631ca41317e.png', '100 % Safe', 'All files scanned', 1, 'uploads/footer-icons/verified-20260913155950-1d357971ff20.png', 'Verified Apps', 1, 'uploads/footer-icons/software-20260913160214-f4cb49d7ca95.png', 'Daily Updates', 'New apps & Games every day', '100% Secure & safe', '#00bd4f', '#ffffff', '1', '404040', '#262626', '#878787', 'Museo Sans Condensed', 15, 15, 12, -5, 1, 'e8e8e8', 52, 1, 60, 35, 16, 8);


COMMIT;