[Geisor ACC] Try To Make a set to sell in shop

[Teddy]

i have a set and i wanna put it in shop
i give rep+

INSERT INTO `z_shop_offer`(`id`,`points` ,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`itemid3`,`count3`,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '100', '30', '200', '9776', '1', '9777' ,'1', '9778', '1', 'container', 'Buy Sweddy Set', 'Sweddy Set');

But every time i try to add that this error come

Fel/error

SQL-fråga:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `offer_type` , `offer_description` , `offer_name` )
VALUES (
NULL , '100', '2466', '2466', '1', '1987', '1987', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor'
)

MySQL sa: Dokumentation
#1136 - Column count doesn't match value count at row 1

The Set have 3 items
1

05:54 You see a yalahari armor (Arm:16, protection death +3%).
It can only be wielded properly by knights, elite knights, druids, elder druids, sorcerers, master sorcerers, paladins and royal paladins of
level 80 or higher.
It weighs 70.00 oz.
ItemID: [9776].
Position: [X: 123] [Y: 362] [Z: 6]

2

05:55 You see a yalahari mask (Arm:5, magic level +2).
It can only be wielded properly by sorcerers, master sorcerers, druids, elder druids, paladins, royal paladins, knights and elite knights of
level 80 or higher.
It weighs 35.00 oz.
ItemID: [9778].
Position: [X: 123] [Y: 362] [Z: 6].

3

05:55 You see a yalahari leg piece (Arm:8, distance fighting +2, protection death +5%).
It can only be wielded properly by paladins, royal paladins, druids, elder druids, sorcerers, master sorcerers, knights and elite knights of
level 80 or higher.
It weighs 65.00 oz.
ItemID: [9777].
Position: [X: 123] [Y: 362] [Z: 6].

 

[Zoriath]

I think you should edit shopsystem.php

No I don't want to do it for you -.-

(not bored right now ;O)

 

[Zoriax_]

Dis Work

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` )
VALUES (
NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor'
)

 

[Kjosen]

#1146 - Table 'roxx.z_shop_offer' doesn't exist

Please help.