- Joined
- Apr 17, 2008
- Messages
- 103
- Reaction score
- 0
yeah
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(shop id goes here, npc id goes here);
but the npc has to have the shop id to match i dont know how to make an npc into a shop <-- nubness i know lol i soo nub with java but like i dunno how to change a normal npc like thmas into a shop seller i d k if thats even possible so i was like use a shop u dont want and replace it ... if there is a better way im sure there is please tell me lol
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1940, 1052002);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070000, 10000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070001, 250000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070008, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070002, 650000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070009, 650000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070012, 800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070013, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070003, 1650000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070010, 1700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070011, 2000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070004, 5000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070005, 15000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070006, 25000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070007, 35000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070016, 50000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1940, 2070018, 75000000, 16);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1940, 1052002);
i use odin i used to use titan source back in the day.
moved to vana in its baby stages when it wasnt so good and i dont feel like goign back but yeah wow thanks for this major upgrade on my script tommrow i will test and fix it up! again i owe u haha do u have msn?
yteah i know thats not my script lolz i ment ied fix mine i wanna fix mine no better way to make sure i learn it is if i do it myself :] but its late and i have school tommrow itll have to wait till tommrow