Hello friends, I have a little doubt, try several days trying and I can not find the solution. I need to sell vocations on the web, the offers I can only make from phpadmin here I leave a sample. in the original way that it gives error in console
line 37 to 45
C++:
-- Extraindo dados da tabela `z_shop_offer`
--
INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`) VALUES
(1, 20, 12633, 1, 0, 0, 'item', 'Armor: 60 | Speed +25 | Ki Blasting +5 | Ki +3000/s.', 'Cell Helmet'),
(2, 10, 12661, 1, 0, 0, 'item', 'Armor: 150 | Ki Blasting +20 | Ki +3000/s.', 'Cell Armor'),
(3, 15, 12632, 1, 0, 0, 'item', 'Armor: 60 | Speed +20 | Sword +5 | Health & Ki +2000/s.', 'Janemba Helmet'),
(4, 10, 12654, 1, 0, 0, 'item', 'Armor: 125 | Sword +10 | Health & Ki +3000/s.', 'Janemba Armor'),
(5, 10, 12679, 1, 0, 0, 'item', 'Armor: 75 | Sword +5 | Health & Ki +3000/s.', 'Janemba Legs'),
(6, 10, 12689, 1, 0, 0, 'item', 'Armor: 30 | Health & Ki +2000/s.', 'Janemba Boots'),
(7, 10, 12660, 1, 0, 0, 'item', 'Armor: 150 | Speed +15 | Health & Ki +3500/s.', 'Fusion Armor'),
(8, 10, 12680, 1, 0, 0, 'item', 'Armor: 85 | Speed +15 | Health & Ki +3500/s.', 'Fusion Legs'),
(9, 10, 12694, 1, 0, 0, 'item', 'Armor: 75 | Speed +15 | Health & Ki +3000/s.', 'Fusion Boots'),
(11, 5, 12655, 1, 0, 0, 'item', 'Armor: 85 | Health +5000/3s.', 'Goku Armor'),
(12, 5, 12675, 0, 0, 0, 'item', 'Armor: 50 | Ki +5000/3s.', 'Goku Legs'),
(13, 7, 12693, 0, 0, 0, 'item', 'Armor: 50 | Health & Ki +5000/3s.', 'Goku Boots'),
(14, 6, 12678, 1, 0, 0, 'item', 'Armor: 75 | Health & Ki +2500/s.', 'Goku SSJ5 Legs'),
(15, 15, 12662, 1, 0, 0, 'item', 'Armor: 200 | All Skills +5 | Health & Ki +5000/s.', 'Legendary Armor'),
(16, 15, 12681, 1, 0, 0, 'item', 'Armor: 100 | Health & Ki +5000/s.', 'Legendary Legs'),
(17, 15, 12695, 1, 0, 0, 'item', 'Armor: 85 | Health & Ki +4000/s.', 'Legendary Boots'),
(18, 20, 12663, 1, 0, 0, 'item', 'Armor: 250 | All Skills +5 | Health & Ki +6500/s.', 'Supreme North Armor'),
(19, 20, 12682, 1, 0, 0, 'item', 'Armor: 150 | All Skills +5 | Health & Ki +6500/s.', 'Supreme North Legs'),
(20, 20, 12696, 1, 0, 0, 'item', 'Armor: 100 | Health & Ki +5000/s.', 'Supreme North Boots'),
(21, 25, 13497, 1, 0, 0, 'item', 'Armor: 150 | Speed +25 | Ki Level +5 | Health & Ki +7500/s.', 'Bills Armor'),
(22, 25, 13498, 1, 0, 0, 'item', 'Armor: 100 | Speed +50 | Ki Level +5 | Health & Ki +7500/s.', 'Bills Legs'),
(23, 25, 13499, 1, 0, 0, 'item', 'Armor: 65 | Speed +100| Ki Level +3 | Health & Ki +5000/s.', 'Bills Boots'),
(24, 15, 12714, 1, 0, 0, 'item', 'Atk: 20 | Def: 20 | Strenght +10 | Effect | Fast Attack.', 'Glove Of Lies'),
(25, 15, 12733, 1, 0, 0, 'item', 'Atk: 20 | Def: 20 | Sword +10 | Effect | Fast Attack.', 'Hell Janemba Sword'),
(26, 15, 13447, 1, 0, 0, 'item', 'Atk: 20 | Def: 20 | Weapon +10 | Effect | Fast Attack.', 'Elypson'),
(27, 20, 13467, 1, 0, 0, 'item', 'Atk: 25 Def: 25 | Attack Speed +10 Strenght & Defense +10 | Effect | Fast Attack.', 'Golden Crystal Glove'),
(28, 20, 13466, 1, 0, 0, 'item', 'Atk: 25 Def: 25 | Attack Speed +10 Sword & Defense +10 | Effect | Fast Attack.', 'Mystic Sword'),
(29, 20, 12734, 1, 0, 0, 'item', 'Atk: 25 Def: 25 | Attack Speed +10 Weapon & Defense +10 | Effect | Fast Attack.', 'Goku Staff'),
(30, 15, 12735, 1, 0, 0, 'item', 'Def: 100 | Protect All 5% | Speed +100', 'Shield Of Glory'),
(31, 15, 13398, 1, 0, 0, 'item', 'Def: 250 | Protect All 5% | Speed -100', 'Tortoiseshell'),
(32, 20, 12759, 1, 0, 0, 'item', 'Protect All 10%.', 'Earring Of Magic'),
(33, 20, 10220, 1, 0, 0, 'item', 'Protect All 10%.', 'Leviathans Amulet'),
(36, 30, 13484, 1, 0, 0, 'mounts', 'Transforme-se em um Shenron.', 'Vocação Shenron'),
(37, 30, 13485, 1, 0, 0, 'mounts', 'Transforme-se em um Vegetto.', 'Vocação Vegetto'),
(38, 30, 13486, 1, 0, 0, 'mounts', 'Transforme-se em um Tapion.', 'Vocação Tapion'),
(39, 30, 13487, 1, 0, 0, 'mounts', 'Transforme-se em um Kame.', 'Vocação Kame'),
(40, 30, 13488, 1, 0, 0, 'mounts', 'Transforme-se em um King Vegeta.', 'Vocação King Vegeta'),
(41, 30, 13489, 1, 0, 0, 'mounts', 'Transforme-se em uma Kagome.', 'Vocação Kagome'),
(42, 30, 13490, 1, 0, 0, 'mounts', 'Transforme-se em um Zaiko.', 'Vocação Zaiko'),
(43, 30, 13491, 1, 0, 0, 'mounts', 'Transforme-se em um Chilled.', 'Vocação Chilled'),
(44, 30, 13492, 1, 0, 0, 'mounts', 'Transforme-se em um C8.', 'Vocação C8'),
(45, 27, 9004, 1, 0, 0, 'addons', 'Premium Scroll de 90 dias.', 'Premium Scroll'),
(48, 10, 5958, 1, 0, 0, 'addons', 'Premium Scroll de 30 dias.', 'Premium Scroll'),
(49, 7, 5957, 1, 0, 0, 'addons', 'Premium Scroll de 10 dias.', 'Premium Scroll'),
(50, 5, 12289, 1, 0, 0, 'addons', 'Recupera toda a Stamina.', 'Stamina Potion'),
(51, 5, 7440, 1, 0, 0, 'addons', 'Remove todos frags unjustified do seu personagem.', 'Remover Unjust');
line 37 to 45