Jeanzinh0

Untitled

Mar 15th, 2017
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1.  
  2. CREATE TABLE `items_crackable` (
  3. `item_id` int(11) NOT NULL,
  4. `count` int(11) NOT NULL,
  5. `prizes` varchar(255) NOT NULL COMMENT 'Used in the format of item_id:chance;item_id_2:chance. item_id must be id in the items_base table. Default value for chance is 100.',
  6. `achievement_tick` varchar(64) NOT NULL,
  7. `achievement_cracked` varchar(64) NOT NULL
  8. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  9.  
  10. --
  11. -- Extraindo dados da tabela `items_crackable`
  12. --
  13.  
  14. INSERT INTO `items_crackable` (`item_id`, `count`, `prizes`, `achievement_tick`, `achievement_cracked`) VALUES
  15. (3901, 1000, '678;688;698;708;718;728;738;748;758', 'EggCracker', 'EggMaster'),
  16. (3902, 5000, '3913;3914;3915;3916', 'EggCracker', 'EggMaster'),
  17. (3903, 10000, '3909;3910;3911;3912', 'EggCracker', 'EggMaster'),
  18. (3904, 20000, '3900;3905;3906', 'EggCracker', 'EggMaster'),
  19. (8678, 1, '8679;8680;8681;8682;8683;8684', '', ''),
  20. (8609, 1, '8610;8611;8612;8613;8614;8615', '', ''),
  21. (8584, 12, '8552;8555;8558', '', 'CreatureRearer'),
  22. (8552, 15, '8553;8554', '', 'CreatureRearer'),
  23. (8555, 15, '8556;8557', '', 'CreatureRearer'),
  24. (8558, 15, '8559;8560', '', 'CreatureRearer'),
  25. (7400, 12, '7400;7401;7402', '', 'Horticulturist'),
  26. (7401, 12, '7400;7401;7402', '', 'Horticulturist'),
  27. (7402, 12, '7400;7401;7402', '', 'Horticulturist'),
  28. (7413, 12, '7413;7414;7415', '', 'Horticulturist'),
  29. (7414, 12, '7413;7414;7415', '', 'Horticulturist'),
  30. (7415, 12, '7413;7414;7415', '', 'Horticulturist'),
  31. (7465, 12, '7465;7466;7467', '', 'Horticulturist'),
  32. (7466, 12, '7465;7466;7467', '', 'Horticulturist'),
  33. (7467, 12, '7465;7466;7467', '', 'Horticulturist'),
  34. (7468, 12, '7468;7469;7470', '', 'Horticulturist'),
  35. (7469, 12, '7468;7469;7470', '', 'Horticulturist'),
  36. (7470, 12, '7468;7469;7470', '', 'Horticulturist');
Advertisement
Add Comment
Please, Sign In to add comment