How to create NPC for VIP

[haizamlee]

I wanna create a npc where the buyer just for vip. So I need an example of the coding SQL for it. THANK YOU.

[dani-filth0]

already released by zuikislol use search function

[~*Kronic*~]

Even if you cannot find the post it's not very hard to make a query yourself, you need to learn to do some things independantly... or at least try. If you use the search button you should be able to find a cq_action list that will help you make things for yourself.

[haizamlee]

Originally Posted by ~*Kronic*~

Even if you cannot find the post it's not very hard to make a query yourself, you need to learn to do some things independantly... or at least try. If you use the search button you should be able to find a cq_action list that will help you make things for yourself.

i've tried.. But it still cannot use..

[dani-filth0]

i guess its kinda hard to search for things with only 3 letters
try this

INSERT INTO `cq_action` VALUES ('5991100', '5991101', '0000', '0101', '0', 'Hello!~I\'m~the~VIP~Teleporter!~and~I~can~Telepor t~you~to~any~of~these~VIP~Locations!');
INSERT INTO `cq_action` VALUES ('5991101', '5991102', '0000', '0102', '0', 'Take~me~to~the~VIP~4~Map. 5991106');
INSERT INTO `cq_action` VALUES ('5991102', '5991103', '0000', '0102', '0', 'Take~me~to~the~VIP~5~Map. 5991110');
INSERT INTO `cq_action` VALUES ('5991103', '5991104', '0000', '0102', '0', 'Take~me~to~the~VIP~6~Map. 5991114');
INSERT INTO `cq_action` VALUES ('5991104', '5991105', '0000', '0102', '0', 'Take~me~to~the~VIP~7~Map. 5991118');
INSERT INTO `cq_action` VALUES ('5991105', '4000034', '0000', '0102', '0', 'Nevermind. 0');
INSERT INTO `cq_action` VALUES ('5991106', '5991107', '5991109', '5001', '0', ' < 4');
INSERT INTO `cq_action` VALUES ('5991107', '5991108', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~4.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991108', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991109', '0000', '0000', '1003', '0', '8900 72 22 1');
INSERT INTO `cq_action` VALUES ('5991110', '5991111', '5991113', '5001', '0', ' < 5');
INSERT INTO `cq_action` VALUES ('5991111', '5991112', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~5.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991112', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991113', '0000', '0000', '1003', '0', '1902 80 23 1');
INSERT INTO `cq_action` VALUES ('5991114', '5991115', '5991117', '5001', '0', ' < 6');
INSERT INTO `cq_action` VALUES ('5991115', '5991116', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~6.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991116', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991117', '0000', '0000', '1003', '0', '1917 107 98 1');
INSERT INTO `cq_action` VALUES ('5991118', '5991119', '5991121', '5001', '0', ' < 7');
INSERT INTO `cq_action` VALUES ('5991119', '5991120', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~7.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991120', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991121', '0000', '0000', '1003', '0', '1918 108 97 1');

[haizamlee]

I need someone to check my coding... here i attached it ..

[haizamlee]

Can someone help me

[server2010]

hey man open navicat and right click on my and choise consol and put this code


INSERT INTO `cq_action` VALUES ('5991100', '5991101', '0000', '0101', '0', 'Hello!~I\'m~the~VIP~Teleporter!~and~I~can~Telepor t~you~to~any~of~these~VIP~Locations!');
INSERT INTO `cq_action` VALUES ('5991101', '5991102', '0000', '0102', '0', 'Take~me~to~the~VIP~4~Map. 5991106');
INSERT INTO `cq_action` VALUES ('5991102', '5991103', '0000', '0102', '0', 'Take~me~to~the~VIP~5~Map. 5991110');
INSERT INTO `cq_action` VALUES ('5991103', '5991104', '0000', '0102', '0', 'Take~me~to~the~VIP~6~Map. 5991114');
INSERT INTO `cq_action` VALUES ('5991104', '5991105', '0000', '0102', '0', 'Take~me~to~the~VIP~7~Map. 5991118');
INSERT INTO `cq_action` VALUES ('5991105', '4000034', '0000', '0102', '0', 'Nevermind. 0');
INSERT INTO `cq_action` VALUES ('5991106', '5991107', '5991109', '5001', '0', ' < 4');
INSERT INTO `cq_action` VALUES ('5991107', '5991108', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~4.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991108', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991109', '0000', '0000', '1003', '0', '8900 72 22 1');
INSERT INTO `cq_action` VALUES ('5991110', '5991111', '5991113', '5001', '0', ' < 5');
INSERT INTO `cq_action` VALUES ('5991111', '5991112', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~5.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991112', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991113', '0000', '0000', '1003', '0', '1902 80 23 1');
INSERT INTO `cq_action` VALUES ('5991114', '5991115', '5991117', '5001', '0', ' < 6');
INSERT INTO `cq_action` VALUES ('5991115', '5991116', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~6.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991116', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991117', '0000', '0000', '1003', '0', '1917 107 98 1');
INSERT INTO `cq_action` VALUES ('5991118', '5991119', '5991121', '5001', '0', ' < 7');
INSERT INTO `cq_action` VALUES ('5991119', '5991120', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~7.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('5991120', '4000034', '0000', '0102', '0', 'I\'m~Sorry. 0');
INSERT INTO `cq_action` VALUES ('5991121', '0000', '0000', '1003', '0', '1918 108 97 1');

[kyushiro]

what code you wanna change just use the code given and you ready to go lol

[magewarior2]

Originally Posted by haizamlee

I need someone to check my coding... here i attached it ..

interesting ...

why you add every line into the cq_task?

[haizamlee]

I dont mean npc to vip map.. i mean that npc that sell items just for vip only..

[kyushiro]

stop spamming and double posting guys remember follow the rules here we got moderators so please respect them and help them by not making any nonsense thread

[~Sword~Stalker~.]

Originally Posted by kyushiro

stop spamming and double posting guys remember follow the rules here we got moderators so please respect them and help them by not making any nonsense thread

whats the spam / double post in here ?

[DEADP00L]

i deleted it sword

[AziQ]

maybe u can use this guide and put the npc in vip map .so vip player only can buy that things .