-- Demo content for the local SQLite store (storage/site.db).
--   sqlite3 storage/site.db < sql/seed_demo.sql
-- The item-shop catalog is NOT seeded here - it lives in player.ishop_data and
-- is managed by the game / the in-game item shop.

INSERT INTO news (slug, title, category, excerpt, body, author_name, is_pinned, published_at) VALUES
('welcome',     'Welcome to Cappuccino', 'news',   'The server is live.',            '<p>Grand opening! Balanced rates, weekly events, active staff.</p>', 'admin', 1, datetime('now')),
('patch-1-0-1', 'Patch 1.0.1',           'update', 'Bug fixes and balance tweaks.',  '<ul><li>Fixed Meley drop table</li><li>Reduced boss respawn timers</li></ul>', 'admin', 0, datetime('now','-2 days')),
('weekend-2x',  '2x EXP this weekend',   'event',  'Double experience Fri to Sun.',  '<p>Log in between Friday 18:00 and Sunday 23:59 for 2x EXP.</p>', 'admin', 0, datetime('now','-4 days'));

UPDATE settings SET value = datetime('now','+3 days','+3 hours') WHERE key = 'open_server_at';

INSERT INTO coin_packages (label, coins, bonus, price, currency, processors, is_featured, sort_order) VALUES
('Starter', 500,  0,    4.99,  'EUR', 'paypal,stripe', 0, 1),
('Popular', 1200, 150,  9.99,  'EUR', 'paypal,stripe', 1, 2),
('Value',   2600, 500,  19.99, 'EUR', 'paypal,stripe', 0, 3),
('Mega',    7000, 2000, 49.99, 'EUR', 'paypal,stripe', 0, 4);

INSERT INTO vote_sites (name, url, reward_coins, cooldown_h, sort_order) VALUES
('TopG',         'https://topg.org/',          15, 12, 1),
('Gtop100',      'https://gtop100.com/',        15, 12, 2),
('XtremeTop100', 'https://xtremetop100.com/',   15, 12, 3);

INSERT INTO redeem_codes (code, reward_type, reward_value, reward_count, max_uses) VALUES
('WELCOME2026', 'coins', 100,   1, 0),
('STARTERKIT',  'item',  50300, 1, 500);

-- Category names come from the built-in localised defaults unless an admin
-- overrides one at /itemshop/admin/categories.

-- Demo item-shop catalog.
INSERT INTO shop_items (name, description, category_type, category_subtype, item_vnum, price, discount, stock, featured, sort_order) VALUES
('Yang Kumi Pack',   'Duration: 7 days' || char(10) || 'Costume: 2000 HP, +15%' || char(10) || 'Mob damage, +50 Attack Value', 1, 0, 45001, 110, 0, 0, 1, 1),
('Yin Kumi Pack',    'Duration: 7 days' || char(10) || 'Costume: 2000 HP, +15%' || char(10) || 'Mob damage, +50 Attack Value', 1, 0, 45002, 110, 0, 0, 0, 2),
('King PvP Pack',    'Resistance Skill' || char(10) || 'Hairstyle: 3000 HP, +5%' || char(10) || 'Skill Damage', 1, 0, 45210, 1200, 10, 428, 1, 3),
('Permanent Water Pack', 'Contains all permanent waters', 3, 0, 27995, 149, 30, 609, 0, 4),
('Skill Pack',       'x20 Focused Reading' || char(10) || 'x20 Exorcism Scroll', 3, 0, 25040, 22, 50, 4143, 0, 5),
('Explorer Pack',    'x10 Orc Tooth' || char(10) || 'x15 Book of Curses' || char(10) || 'x20 Demon Souvenir', 3, 0, 50421, 100, 45, 4807, 0, 6),
('Biologist Pack',   'x20 Spiral of Time' || char(10) || 'x20 Exploration Elixir', 3, 0, 27996, 39, 49, 3667, 0, 7),
('EXP Pack',         'White Lion Seal 7d - 8% mob, 25% exp' || char(10) || 'Polar Bear 7d - 8% mob, 25% exp', 3, 0, 50480, 149, 0, 4718, 1, 8),
('PvP Pack (7d)',    'Competent Resistance' || char(10) || 'Hair: 3000 HP, +5%' || char(10) || 'Skin: 3000 HP, +10% Crit, 10% Pierce', 1, 0, 45211, 120, 12, NULL, 1, 9),
('Battle Horse (30d)', 'Sturdy war mount for 30 days' || char(10) || 'Movement speed +20%', 5, 0, 71114, 500, 0, NULL, 0, 10),
('Shadow Hair',      'A wispy dark hairstyle', 2, 0, 46012, 120, 0, NULL, 0, 11),
('Name Change Ticket', 'Rename one character', 3, 0, 72300, 90, 0, 250, 0, 12);
UPDATE shop_items SET sell_count = 3400 - id * 210;