[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]

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `itemid4` , `count4` , `offer_type` , `offer_description` , `offer_name` )
VALUES ( NULL , '100', '2466', '1' '9776', '1', '9778', '1', '9777', '1', 'container', 'Buy bag with Yalahari Armor, Yalahari Mask and Yalahari Leg Piece!', 'Yalahari Bag'; )

REMEMBER: Always match the query on top with the query on bottom. They should have the same amount of fields and have the same rows.

 

[Teddy]

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'; )

REMEMBER: count isn't the same as itemID.

i need all items in 1 :S
how do i make so it its 3 diffret item's in 1 bag

 

[Teddy]

i wait that i most wait 24 h but this post was very long down ^^
i hate my english
yeyeye
BUMP !

 

[Zoriath]

Try my new one

 

[Teddy]

What ?

 

[Teddy]

Fel

SQL-fråga:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `itemid4` , `count4` , `offer_type` , `offer_description` , `offer_name` )
VALUES (
NULL , '100', '2466', '1' '9776', '1', '9778', '1', '9777', '1', 'container', 'Buy bag with Yalahari Armor, Yalahari Mask and Yalahari Leg Piece!', 'Yalahari Bag';

MySQL sa: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

 

[Zoriath]

you didn't copy the last ')'.

 

[Teddy]

wrong

 

[Teddy]

nope still dont work :S

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `itemid4` , `count4` , `offer_type` , `offer_description` , `offer_name` )
VALUES ( NULL , '100', '2466', '1' '9776', '1', '9778', '1', '9777', '1', 'container', 'Buy bag with Yalahari Armor, Yalahari Mask and Yalahari Leg Piece!', 'Yalahari Bag'; )

i think the problem are in red

 

[Zoriath]

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `itemid4` , `count4` , `offer_type` , `offer_description` , `offer_name` )
VALUES ( NULL , '100', '2466', '1' '9776', '1', '9778', '1', '9777', '1', 'container', 'Buy bag with Yalahari Armor, Yalahari Mask and Yalahari Leg Piece!', 'Yalahari Bag' );

 

[Teddy]

samma error

Fel

SQL-fråga:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `itemid3` , `count3` , `itemid4` , `count4` , `offer_type` , `offer_description` , `offer_name` )
VALUES (
NULL , '100', '2466', '1' '9776', '1', '9778', '1', '9777', '1', 'container', 'Buy bag with Yalahari Armor, Yalahari Mask and Yalahari Leg Piece!', 'Yalahari Bag'
)

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

 

[Teddy]

...

?? :S

 

[Teddy]

Bump

 

[Teddy]

bump

 

[Master-m]

remove , 'Yalahari Bag' U.u

 

[Teddy]

It did not work, I think I have to add those lines
"itemid3", "count3", "itemid4", "count4"
for I do not have them in my phpmyadmin I only have:

id, points, itemid1, count1, itemid2, count2, offer_type, offer_description, offer_name,

are the only ones I have so if you need to add "itemid3", "count3", "itemid4", "count4" how do they do?

 

[Dalale]

you mean this?

INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '3', '5785', '1', '0', '1', 'container', 'Buy VIP and get access to ViP town!. ', 'Vip Certificate');

 

[Teddy]

no -.-

 

[Teddy]

may not be able to do this?