INSERT INTO pages (title, slug, banner, content, seo_title, seo_description, seo_keywords, status)
VALUES
('What is RBCL?', 'what-is-rbcl', '/assets/img/demo/about.webp',
'<h2>Rising Bharat Cricket League</h2><p>RBCL is a premium cricket trial and league platform built to identify, verify, and support serious cricket talent through a structured registration, selection, match, and performance workflow.</p><div class="cms-note-grid"><div class="cms-note"><h3>Player First</h3><p>Players receive a registration number, secure profile access, document verification, trial updates, and match fee support.</p></div><div class="cms-note"><h3>Transparent Process</h3><p>Selection, match records, payments, and player status are managed through a central RBCL platform.</p></div><div class="cms-note"><h3>Performance Driven</h3><p>Match-by-match score data helps players and organisers track batting, bowling, wicketkeeping, and career growth.</p></div></div><p>RBCL combines professional sports operations with a modern digital experience for players, organisers, and parents.</p>',
'What is RBCL?', 'Learn about Rising Bharat Cricket League, cricket trials, registration and player development.', 'rbcl, cricket trials, rising bharat cricket league', 'published'),
('RBCL Organisers', 'rbcl-organisers', '/assets/img/demo/rewards.webp',
'<h2>RBCL Organisers</h2><p>RBCL is managed by a professional operations team focused on fair trials, smooth event execution, player communication, and secure digital records.</p><p>The organiser team coordinates registration support, venue readiness, match scheduling, score management, payment tracking, and player document verification.</p><ul class="check-list"><li>Trial planning and player coordination</li><li>Venue, squad, and match operations</li><li>Digital payment and registration support</li><li>Player communication and post-trial guidance</li></ul>',
'RBCL Organisers', 'RBCL organisers and cricket trial management information.', 'rbcl organisers, cricket management', 'published'),
('Teams', 'teams', '/assets/img/demo/teams/team-1.webp',
'<h2>RBCL Teams</h2><p>RBCL teams are formed according to trial requirements, player categories, state participation, and match format. Team composition may change match by match so every match record remains flexible and accurate.</p><div class="cms-note-grid"><div class="cms-note"><h3>Category Based</h3><p>Players are grouped by cricket role, age group, and trial category.</p></div><div class="cms-note"><h3>Match Flexible</h3><p>Admin can add players separately for every match score entry.</p></div><div class="cms-note"><h3>Performance Linked</h3><p>Batting, bowling, and wicketkeeping records update player career statistics.</p></div></div>',
'RBCL Teams', 'RBCL cricket teams and trial team selection information.', 'rbcl teams, cricket teams', 'published'),
('Selection Process', 'selection-process', '/assets/img/demo/trial-map.webp',
'<h2>Selection Process</h2><p>The RBCL selection process is designed to be clear, disciplined, and performance oriented. Players complete registration, payment, profile creation, document submission, and trial participation before final verification.</p><ol><li>Register online with correct player details.</li><li>Pay the registration fee and receive an RBCL registration number.</li><li>Create password through the secure one-time email link.</li><li>Complete profile and upload required documents.</li><li>Attend trial or assigned match activity as per RBCL schedule.</li><li>Admin verifies documents, payment, and player status.</li></ol><p>Final status is visible in the player dashboard and can be updated by the Super Admin after review.</p>',
'RBCL Selection Process', 'RBCL cricket trial selection process and registration workflow.', 'rbcl selection process, cricket trials', 'published'),
('Mandatory Documents', 'mandatory-documents', '/assets/img/demo/players-update.webp',
'<h2>Mandatory Documents</h2><p>Every player must complete document upload from the player dashboard before verification. Documents are securely stored and reviewed by the Super Admin.</p><ul class="check-list"><li>Recent player selfie</li><li>Aadhaar front image</li><li>Aadhaar back image</li><li>Correct mobile number and email address</li><li>Registration number linked to successful payment</li></ul><p>Players with incomplete documents remain in Documents Pending or Verification Pending status until the admin review is complete.</p>',
'RBCL Mandatory Documents', 'Required documents for RBCL player verification.', 'rbcl documents, aadhaar, player verification', 'published'),
('Anti-Corruption Committee', 'anti-corruption-committee', '/assets/img/demo/hero.webp',
'<h2>Anti-Corruption Committee</h2><p>The RBCL Anti-Corruption Committee supports fair play, clean competition, and responsible cricket operations. The committee reviews integrity concerns and helps protect the credibility of the trial and match process.</p><ul class="check-list"><li>Fair play monitoring</li><li>Integrity review of reported concerns</li><li>Guidance for organisers, players, and support staff</li><li>Escalation support for serious misconduct</li></ul><p>Players and organisers are expected to follow RBCL rules, respect match officials, and report suspicious activity responsibly.</p>',
'RBCL Anti-Corruption Committee', 'RBCL anti-corruption committee and fair play information.', 'rbcl anti corruption committee, fair play', 'published'),
('Disciplinary Committee', 'disciplinary-committee', '/assets/img/demo/gallery/gallery-2.webp',
'<h2>Disciplinary Committee</h2><p>The RBCL Disciplinary Committee reviews player conduct, organiser conduct, document concerns, match behaviour, and policy violations. The goal is to keep RBCL events safe, fair, and professionally managed.</p><ul class="check-list"><li>Review of misconduct reports</li><li>Player status recommendations</li><li>Suspension or rejection support when required</li><li>Code of conduct guidance</li></ul><p>All decisions should be recorded through admin logs and player status history for transparency.</p>',
'RBCL Disciplinary Committee', 'RBCL disciplinary committee, code of conduct and player status review.', 'rbcl disciplinary committee, code of conduct', 'published'),
('Management', 'management', '/assets/img/demo/gallery/gallery-1.webp',
'<h2>RBCL Management</h2><p>RBCL management brings together cricket operations, player support, event planning, and digital administration to deliver a premium trial experience.</p><div class="cms-split-block"><img src="/assets/img/demo/gallery/gallery-1.webp" alt="Trial Operations"><div><h3>Trial Operations Team</h3><p>Coordinates city-wise trials, player arrival flow, ground setup, match squads, and real-time organiser communication.</p></div></div><div class="cms-split-block"><img src="/assets/img/demo/gallery/gallery-3.webp" alt="Player Support"><div><h3>Player Support Desk</h3><p>Helps players and parents with registration numbers, profile completion, document verification, payment status, and trial updates.</p></div></div><div class="cms-split-block"><img src="/assets/img/demo/gallery/gallery-5.webp" alt="Digital Administration"><div><h3>Digital Administration</h3><p>Maintains CMS pages, player records, payment reports, score entries, match fee requests, exports, and audit logs through the Super Admin panel.</p></div></div>',
'RBCL Management', 'RBCL management, operations and digital administration team.', 'rbcl management, cricket operations', 'published'),
('FAQs', 'faqs', '/assets/img/demo/rewards.webp',
'<h2>Frequently Asked Questions</h2><h3>How do I register?</h3><p>Use the Register Now button, fill the player form, and complete the registration payment.</p><h3>How do I pay match fee?</h3><p>Use Pay Fee with your registration number and password. Registration fee must be completed before match fee payment.</p><h3>Where can I upload documents?</h3><p>Login to your player dashboard and complete your profile documents.</p>',
'RBCL FAQs', 'RBCL frequently asked questions.', 'rbcl faqs, cricket trials questions', 'published'),
('Contact Us', 'contact-us', '/assets/img/demo/trial-map.webp',
'<h2>Contact RBCL</h2><p>For registration, document, payment, match schedule, and trial support, contact the RBCL help desk.</p><ul class="check-list"><li>Call / WhatsApp: +91 92436 19991</li><li>Email: info@myrbcl.com</li><li>Support for registration, profile, payments, and trial updates</li></ul>',
'Contact RBCL', 'Contact RBCL for cricket trial and registration support.', 'rbcl contact, cricket trial support', 'published')
ON DUPLICATE KEY UPDATE
title = VALUES(title),
banner = VALUES(banner),
content = VALUES(content),
seo_title = VALUES(seo_title),
seo_description = VALUES(seo_description),
seo_keywords = VALUES(seo_keywords),
status = VALUES(status),
updated_at = CURRENT_TIMESTAMP;

DELETE child FROM menus child
INNER JOIN menus parent ON child.parent_id = parent.id
WHERE parent.name IN ('HOME', 'Home', 'ABOUT US', 'About Us', 'SELECTION', 'Selection', 'MANAGEMENT', 'Management', 'RBCL COMMITTEES', 'RBCL Committees', 'FAQS', 'FAQs', 'CONTACT US', 'Contact Us');

DELETE FROM menus WHERE name IN (
    'What is RBCL', 'RBCL Gallery', 'RBCL Organisers', 'Teams', 'Selection Process',
    'MANDATORY DOCUMENTS', 'Mandatory Documents', 'ANTI CORRUPTION COMMITTEES',
    'Anti Corruption Committees', 'DISCIPLINARY COMMITTEES', 'Disciplinary Committees'
);
DELETE FROM menus WHERE name IN ('HOME', 'Home', 'ABOUT US', 'About Us', 'SELECTION', 'Selection', 'MANAGEMENT', 'Management', 'RBCL COMMITTEES', 'RBCL Committees', 'FAQS', 'FAQs', 'CONTACT US', 'Contact Us');

INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES ('HOME', NULL, '/', 1, 1);
INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES ('ABOUT US', NULL, '/page/what-is-rbcl', 2, 1);
SET @about_menu_id = LAST_INSERT_ID();
INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES
('What is RBCL', @about_menu_id, '/page/what-is-rbcl', 1, 1),
('RBCL Gallery', @about_menu_id, '/gallery', 2, 1),
('RBCL Organisers', @about_menu_id, '/page/rbcl-organisers', 3, 1);

INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES ('SELECTION', NULL, '/page/selection-process', 3, 1);
SET @selection_menu_id = LAST_INSERT_ID();
INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES
('Teams', @selection_menu_id, '/page/teams', 1, 1),
('Selection Process', @selection_menu_id, '/page/selection-process', 2, 1),
('MANDATORY DOCUMENTS', @selection_menu_id, '/page/mandatory-documents', 3, 1);

INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES ('MANAGEMENT', NULL, '/page/management', 4, 1);
INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES ('RBCL COMMITTEES', NULL, '/page/anti-corruption-committee', 5, 1);
SET @committee_menu_id = LAST_INSERT_ID();
INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES
('ANTI CORRUPTION COMMITTEES', @committee_menu_id, '/page/anti-corruption-committee', 1, 1),
('DISCIPLINARY COMMITTEES', @committee_menu_id, '/page/disciplinary-committee', 2, 1);

INSERT INTO menus (name, parent_id, url, sort_order, active) VALUES
('FAQS', NULL, '/page/faqs', 6, 1),
('CONTACT US', NULL, '/page/contact-us', 7, 1);

INSERT INTO settings (setting_key, setting_value, setting_group) VALUES
('footer_about_links', '[{"label":"What is RBCL?","url":"/page/what-is-rbcl"},{"label":"Our Team","url":"/page/teams"},{"label":"Our Gallery","url":"/gallery"},{"label":"Selection Process","url":"/page/selection-process"}]', 'footer'),
('footer_quick_links', '[{"label":"Pay Fees","url":"/match-fee"},{"label":"Organisers","url":"/page/rbcl-organisers"},{"label":"Management","url":"/page/management"},{"label":"Contact Us","url":"/page/contact-us"}]', 'footer')
ON DUPLICATE KEY UPDATE setting_value = VALUES(setting_value), setting_group = VALUES(setting_group);
