[Making own Vendor] (HELP NEEDED!!!)

[Kasperi]

Can enyone tell me whats wrong coz i simply cant Execute this in my DB?

DELETE FROM items WHERE entry BETWEEN '1' AND '12';

INSERT INTO items VALUES (1,2,7,-1,"Gm sword","Gm sword","Gm sword","Gm sword",41418,5,0,0000,0000,13,-1,-1,500,70,0,0,0,0,0,0,0,2,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,2000,7000,0,2000,7000,2,2000,7000,1,2000,7000,4,2000,7000,6,0,0,0,0,0,0,0,1000,0,0,35844,1,0,0,0,0,34696,2,0,0,0,0,18060,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"Dont beg for it!",0,0,0,0,0,-1,3,0,0,0,0,0,0,0,0,0,1,0,1,0,1,0,426,0,0,0,0);
INSERT INTO items VALUES (8,4,1,-1,"Gm legs","Gm legs","Gm legs","Gm legs",31352,5,0,0000,0000,7,-1,-1,500,70,0,0,0,0,0,0,0,0,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (7,4,1,-1,"Gm spaulders","Gm spaulders","Gm spaulders","Gm spaulders",31510,5,0,0000,0000,3,-1,-1,500,70,0,0,0,0,0,0,0,0,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (9,4,1,-1,"Gm helm","Gm helm","Gm helm","Gm helm",31506,5,0,0000,0000,1,-1,-1,500,70,0,0,0,0,0,0,0,0,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (3,4,1,-1,"Gm gloves","Gm gloves","Gm gloves","Gm gloves",31507,5,0,0000,0000,10,-1,-1,500,70,0,0,0,0,0,0,0,1,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,7599,1,0,0,0,0,36067,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (2,4,1,-1,"Gm cloak","Gm cloak","Gm cloak","Gm cloak",15068,5,0,0000,0000,16,-1,-1,500,70,0,0,0,0,0,0,0,1,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,18060,1,0,0,0,0,35844,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,75,0,0,0,0,0,0,1,0,1,0,1,0,2932,0,0,0,0);
INSERT INTO items VALUES (10,4,1,-1,"Gm chest","Gm chest","Gm chest","Gm chest",31505,5,0,0000,0000,5,-1,-1,500,70,0,0,0,0,0,0,0,0,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (6,4,1,-1,"Gm bracers","Gm bracers","Gm bracers","Gm bracers",31509,5,0,0000,0000,9,-1,-1,500,70,0,0,0,0,0,0,0,0,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (4,4,1,-1,"Gm boots","Gm boots","Gm boots","Gm boots",31354,5,0,0000,0000,8,-1,-1,500,70,0,0,0,0,0,0,0,1,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,50,50,50,50,50,50,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (5,4,1,-1,"Gm belt","Gm belt","Gm belt","Gm belt",31353,5,0,0000,0000,6,-1,-1,500,70,0,0,0,0,0,0,0,1,1,0,3,75,4,75,5,75,6,75,7,175,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,500,75,75,75,75,75,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,-1,0,0,0,50,0,0,0,0,0,0,1,0,1,0,1,0,0,0,0,0,0);
INSERT INTO items VALUES (11,1,0,-1,"Gm bag","Gm bag","Gm bag","Gm bag",21858,5,0,2000000,5000000,18,-1,-1,100,70,0,0,0,0,0,0,0,0,1,32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,"",0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO items VALUES (12,6,2,-1,"Gm Arrows","Gm Arrows","Gm Arrows","Gm Arrows",31737,5,0,0000,0000,24,-1,-1,100,70,0,0,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,8000,0,100,200,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",0,0,0,0,0,2,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0);

DELETE FROM creature_proto WHERE entry BETWEEN '1' AND '12';
DELETE FROM creature_names WHERE entry BETWEEN '1' AND '12';

INSERT INTO creature_proto VALUES (1, 70, 814, 999999, 999999, 1, 16388, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0);
INSERT INTO creature_names INTO creature_names VALUES (1,"Seargent","Gm Item Vendor",0,7,1,0,0,NULL,18106,1,1,1,NULL);

INSERT INTO vendors VALUES (1,1,0);
INSERT INTO vendors VALUES (1,2,0);
INSERT INTO vendors VALUES (1,3,0);
INSERT INTO vendors VALUES (1,4,0);
INSERT INTO vendors VALUES (1,5,0);
INSERT INTO vendors VALUES (1,6,0);
INSERT INTO vendors VALUES (1,7,0);
INSERT INTO vendors VALUES (1,8,0);
INSERT INTO vendors VALUES (1,9,0);
INSERT INTO vendors VALUES (1,10,0);
INSERT INTO vendors VALUES (1,11,0);
INSERT INTO vendors VALUES (1,12,0);

Thx

[MentaL]

[melikeme]

look, i forgot where is the code for summoning the item, anyways it MUST be a unique code, not a normal code like 1 or 19 or something it must loook like 13371337 <<< or 18881888

[Kasperi]

WTF? Summoning item? you meen the NPC?