I wanna create a npc where the buyer just for vip. So I need an example of the coding SQL for it. THANK YOU.
How to create NPC for VIP
11/29/2010 21:50
haizamlee#1
11/30/2010 01:20
dani-filth0#2
already released by zuikislol use search function
11/30/2010 04:00
~*Kronic*~#3
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.
11/30/2010 04:06
haizamlee#4
i've tried.. But it still cannot use..Quote:
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.
11/30/2010 05:28
dani-filth0#5
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');
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');
11/30/2010 06:21
haizamlee#6
I need someone to check my coding... here i attached it ..
11/30/2010 09:48
haizamlee#7
Can someone help me
11/30/2010 16:31
server2010#8
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');
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');
11/30/2010 17:27
kyushiro#9
what code you wanna change just use the code given and you ready to go lol
11/30/2010 20:11
magewarior2#10
interesting ...Quote:
why you add every line into the cq_task?
11/30/2010 20:11
haizamlee#11
I dont mean npc to vip map.. i mean that npc that sell items just for vip only..
11/30/2010 20:51
kyushiro#12
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
11/30/2010 20:57
~Sword~Stalker~.#13
whats the spam / double post in here ?Quote:
11/30/2010 22:15
DEADP00L#14
i deleted it sword
12/01/2010 04:10
AziQ#15
[Only registered and activated users can see links. Click Here To Register...]
maybe u can use this guide and put the npc in vip map .so vip player only can buy that things .
maybe u can use this guide and put the npc in vip map .so vip player only can buy that things .