Skip to content

Instantly share code, notes, and snippets.

@diamondo25
Created November 1, 2016 16:54
Show Gist options
  • Select an option

  • Save diamondo25/d0d33d4c7927182c923e8ee2d03b9eea to your computer and use it in GitHub Desktop.

Select an option

Save diamondo25/d0d33d4c7927182c923e8ee2d03b9eea to your computer and use it in GitHub Desktop.
Miu shop
INSERT INTO `mcdb`.`user_shop_data` (`shopid`,`npcid`,`recharge_tier`) VALUES
(5450000, 9090000, 1);
INSERT INTO `mcdb`.`user_shop_items` (`shopid`, `itemid`, `quantity`, `price`, `sort`) VALUES
(5450000, 2000002, 1, 100, 24),
(5450000, 2000006, 1, 200, 23),
(5450000, 2002017, 1, 5000, 22),
(5450000, 2002018, 1, 5000, 21),
(5450000, 2002020, 1, 2800, 20),
(5450000, 2002021, 1, 2800, 19),
(5450000, 2002023, 1, 3800, 18),
(5450000, 2002024, 1, 1500, 17),
(5450000, 2002025, 1, 1500, 16),
(5450000, 2020012, 1, 4500, 15),
(5450000, 2020013, 1, 5600, 14),
(5450000, 2020014, 1, 8100, 13),
(5450000, 2020015, 1, 10200, 12),
(5450000, 2030000, 1, 400, 11),
(5450000, 2040000, 1, 200, 10),
(5450000, 2050001, 1, 200, 9),
(5450000, 2050002, 1, 300, 8),
(5450000, 2050003, 1, 500, 7),
(5450000, 2050004, 1, 4000, 6),
(5450000, 2060000, 1, 1400, 5),
(5450000, 2060003, 1, 40000, 4),
(5450000, 2061000, 1, 1400, 3),
(5450000, 2061003, 1, 40000, 2),
(5450000, 2120000, 1, 30, 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment