hi can any one check this

02/02/2010 03:38 zspider#1
hi all can any one fix this to me i made it but it isn't work can any one tell me where i am wrong thanks:o:o:o
Quote:
INSERT INTO `cq_action` VALUES ('12345', '12346', '0000', '0101', '1020010', 'Hello~my~Name~is~Kayla~i~can~Teleport~you~to~any~ map!');
INSERT INTO `cq_action` VALUES ('12346', '12347', '0000', '0102', '0', 'I~want~to~go~to~*God~Land*. 123413');
INSERT INTO `cq_action` VALUES ('12347', '12348', '0000', '0103', '0', 'I~want~to~go~to~*LeGenD~Garden*. 123414');
INSERT INTO `cq_action` VALUES ('12348', '12349', '0000', '0104', '0', 'I~want~to~go~to~*WarZone*. 123415');
INSERT INTO `cq_action` VALUES ('12349', '123410', '0000', '0105', '0', 'I~want~to~go~to~*The~forest*. 123416');
INSERT INTO `cq_action` VALUES ('123410', '123611', '0000', '0106', '0', 'I~want~to~go~to~*Desert~WaRRioRs*. id 123417');
INSERT INTO `cq_action` VALUES ('123411', '123412', '0000', '0107', '0', 'I~want~to~go~to~*Canosa*. 123420');
INSERT INTO `cq_action` VALUES ('123412', '4000010', '0000', '0108', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('123413','123413', '123421', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123414', '123413', '123422', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123415', '123413', '123423', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123416', '123413', '123424', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123417', '123413', '123425', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123418', '123413', '123426', '0', '0', '155 < 0');
INSERT INTO `cq_action` VALUES ('123419', '123414', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('123420', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('123421', '0000', '0000', '1008', '0', '10000 322 564');
INSERT INTO `cq_action` VALUES ('123422', '0000', '0000', '1008', '0', '12000 908 1116');
INSERT INTO `cq_action` VALUES ('123423', '0000', '0000', '1008', '0', '1955 821 641');
INSERT INTO `cq_action` VALUES ('123424', '0000', '0000', '1008', '0', '1924 164 88');
INSERT INTO `cq_action` VALUES ('123425', '0000', '0000', '1008', '0', '1923 124 115');
INSERT INTO `cq_action` VALUES ('123426', '0000', '0000', '1008', '0', '10024 158 100');



INSERT INTO `cq_task` VALUES ('12345', '12345', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('12346', '12346', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('12347', '12347', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('12348', '12348', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('12349', '12349', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123410', '123410', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123411', '123411', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123412', '123412', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123413', '123413', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123414', '123414', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123415', '123415', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123416', '123416', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123417', '123417', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123418', '123418', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123419', '123419', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123420', '123420', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123421', '123421', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123422', '123422', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123423', '123423', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123424', '123424', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('123425', '123425', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');


INSERT INTO `cq_npc` VALUES ('7', '0', '0', 'Teleporter', '2', '10527', '0', '0', '-1', '1000', '292', '469', 'id 1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'خق', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
02/02/2010 04:13 PraDevil[ELITE]#2
Code:
example:

id1 = 10
id2 = 11
id3 = 12
id4 = 13

the 10 till 13 is the action id lol..u just need to put the number..

example:

INSERT INTO `cq_action` VALUES ('12345', '12346', '0000', '0101', '1020010', 'Hello~my~Name~is~Kayla);
INSERT INTO `cq_action` VALUES ('12346', '12347', '0000', '0102', '0', 'I~want~to~go~to~*God~Land*. id 7');
02/02/2010 04:31 DEADP00L#3
Quote:
Originally Posted by PraDevil View Post
Code:
example:

id1 = 10
id2 = 11
id3 = 12
id4 = 13

the 10 till 13 is the action id lol..u just need to put the number..

example:

INSERT INTO `cq_action` VALUES ('12345', '12346', '0000', '0101', '1020010', 'Hello~my~Name~is~Kayla);
INSERT INTO `cq_action` VALUES ('12346', '12347', '0000', '0102', '0', 'I~want~to~go~to~*God~Land*. id 7');

dont you also have to have the idnext here at the end of the pram as well otherwise it wont go anywhere
02/02/2010 04:39 PraDevil[ELITE]#4
ya..im not reading..im just see at the id, id_next and id_nextfail :p
02/02/2010 05:07 zspider#5
Quote:
the 10 till 13 is the action id lol..u just need to put the number..

example:

INSERT INTO `cq_action` VALUES ('12345', '12346', '0000', '0101', '1020010', 'Hello~my~Name~is~Kayla);
INSERT INTO `cq_action` VALUES ('12346', '12347', '0000', '0102', '0', 'I~want~to~go~to~*God~Land*. id 7');
Quote:
dont you also have to have the idnext here at the end of the pram as well otherwise it wont go anywhere
u can see now i did what u say but didn't work too when i click on Teleporter nothing show to me i mean i can't speak to Teleporter can u check it again
02/02/2010 05:18 PraDevil[ELITE]#6
cq_task lol..u need it too:D
02/02/2010 05:18 King_Arthur#7
You had a lot of stuff wrong with that code. Too much to explain. I rewrote cq_action from scratch with changing as little as possible to get you a minimal functioning teleporter with a level check. Also deleted unnecessary lines from cq_task and changed task0 in cq_npc.
Code:
insert into cq_action values
(1230000,1230001,0,101,0,'Hello~my~Name~is~Kayla~I~can~Teleport~you~to~any~map!'),
(1230001,1230002,0,102,0,'I~want~to~go~to~*God~Land*. 1230010'),
(1230002,1230003,0,102,0,'I~want~to~go~to~*LeGenD~Garden*. 1230012'),
(1230003,1230004,0,102,0,'I~want~to~go~to~*WarZone*. 1230014'),
(1230004,1230005,0,102,0,'I~want~to~go~to~*The~forest*. 1230016'),
(1230005,1230006,0,102,0,'I~want~to~go~to~*Desert~WaRRioRs*. 1230018'),
(1230006,1230007,0,102,0,'I~want~to~go~to~*Canosa*. 1230020'),
(1230007,4000010,0,102,0,'I~want~to~leave. 0'),
(1230008,1230009,0,101,0,'Your~level~is~too~low~to~leave!'),
(1230009,4000010,0,102,0,'Alright. 0'),
(1230010,1230008,1230011,1001,0,'level < 155'),
(1230011,0,0,1003,0,'10000 322 564'),
(1230012,1230008,1230013,1001,0,'level < 155'),
(1230013,0,0,1003,0,'12000 190 242'),
(1230014,1230008,1230015,1001,0,'level < 155'),
(1230015,0,0,1003,0,'1955 821 641'),
(1230016,1230008,1230017,1001,0,'level < 155'),
(1230017,0,0,1003,0,'1924 164 88'),
(1230018,1230008,1230019,1001,0,'level < 155'),
(1230019,0,0,1003,0,'1923 124 115'),
(1230020,1230008,1230021,1001,0,'level < 155'),
(1230021,0,0,1003,0,'10024 158 100');

insert into cq_task values
(1230000,1230000,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230008,1230008,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230010,1230010,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230012,1230012,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230014,1230014,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230016,1230016,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230018,1230018,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230020,1230020,'','','0','0','999','-100000','100000','999','0','0','0','0','0');

INSERT INTO `cq_npc` VALUES ('1234', '0', '0', 'LeGenDTele', '2', '10527', '0', '0', '-1', '1000', '292', '469', '1230000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
02/02/2010 05:37 zspider#8
Quote:
Originally Posted by King_Arthur View Post
You had a lot of stuff wrong with that code. Too much to explain. I rewrote cq_action from scratch with changing as little as possible to get you a minimal functioning teleporter with a level check. Also deleted unnecessary lines from cq_task and changed task0 in cq_npc.
Code:
insert into cq_action values
(1230000,1230001,0,101,0,'Hello~my~Name~is~Kayla~I~can~Teleport~you~to~any~map!'),
(1230001,1230002,0,102,0,'I~want~to~go~to~*God~Land*. 1230010'),
(1230002,1230003,0,102,0,'I~want~to~go~to~*LeGenD~Garden*. 1230012'),
(1230003,1230004,0,102,0,'I~want~to~go~to~*WarZone*. 1230014'),
(1230004,1230005,0,102,0,'I~want~to~go~to~*The~forest*. 1230016'),
(1230005,1230006,0,102,0,'I~want~to~go~to~*Desert~WaRRioRs*. 1230018'),
(1230006,1230007,0,102,0,'I~want~to~go~to~*Canosa*. 1230020'),
(1230007,4000010,0,102,0,'I~want~to~leave. 0'),
(1230008,1230009,0,101,0,'Your~level~is~too~low~to~leave!'),
(1230009,4000010,0,102,0,'Alright. 0'),
(1230010,1230008,1230011,1001,0,'level < 155'),
(1230011,0,0,1003,0,'10000 322 564'),
(1230012,1230008,1230013,1001,0,'level < 155'),
(1230013,0,0,1003,0,'12000 190 242'),
(1230014,1230008,1230015,1001,0,'level < 155'),
(1230015,0,0,1003,0,'1955 821 641'),
(1230016,1230008,1230017,1001,0,'level < 155'),
(1230017,0,0,1003,0,'1924 164 88'),
(1230018,1230008,1230019,1001,0,'level < 155'),
(1230019,0,0,1003,0,'1923 124 115'),
(1230020,1230008,1230021,1001,0,'level < 155'),
(1230021,0,0,1003,0,'10024 158 100');

insert into cq_task values
(1230000,1230000,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230008,1230008,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230010,1230010,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230012,1230012,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230014,1230014,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230016,1230016,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230018,1230018,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(1230020,1230020,'','','0','0','999','-100000','100000','999','0','0','0','0','0');

INSERT INTO `cq_npc` VALUES ('7', '0', '0', 'LeGenDTele', '2', '10527', '0', '0', '-1', '1000', '292', '469', '1230000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '??', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
i made that but the same problem when i speak to teleporter nothing show i think the problem in Cq_npc coz it's say error in 007 any idea??:o:o
02/02/2010 09:07 funhacker#9
try a larger id
02/02/2010 18:30 zspider#10
Quote:
Originally Posted by funhacker View Post
try a larger id
i tryed what u say still not working I'm complicated from this teleporter can u check this again plz
Quote:
insert into cq_action values
(11002030,11002031,0,101,0,'Hello~my~Name~is~Kayla ~I~can~Teleport~you~to~any~map!'),
(11002031,11002032,0,102,0,'I~want~to~go~to~*God~L and*. 11002042'),
(11002032,11002033,0,102,0,'I~want~to~go~to~*LeGen D~Garden*. 11002044'),
(11002033,11002034,0,102,0,'I~want~to~go~to~*WarZo ne*. 11002046'),
(11002034,11002035,0,102,0,'I~want~to~go~to~*The~f orest*. 11002046'),
(11002035,11002036,0,102,0,'I~want~to~go~to~*Deser t~WaRRioRs*. 11002048'),
(11002036,11002037,0,102,0,'I~want~to~go~to~*Canos a*. 11002050'),
(11002037,4000010,0,102,0,'I~want~to~leave. 0'),
(11002038,11002039,0,101,0,'Your~level~is~too~low~ to~leave!'),
(11002039,4000010,0,102,0,'Alright. 0'),
(11002040,11002038,11002041,1001,0,'level < 155'),
(11002041,0,0,1003,0,'10000 322 564'),
(11002042,11002038,11002043,1001,0,'level < 155'),
(11002043,0,0,1003,0,'12000 190 242'),
(11002044,11002038,11002045,1001,0,'level < 155'),
(11002045,0,0,1003,0,'1955 821 641'),
(11002046,11002038,11002047,1001,0,'level < 155'),
(11002047,0,0,1003,0,'1924 164 88'),
(11002048,11002038,11002049,1001,0,'level < 155'),
(11002049,0,0,1003,0,'1923 124 115'),
(11002050,11002038,11002051,1001,0,'level < 155'),
(11002051,0,0,1003,0,'10024 158 100');

insert into cq_task values
(11002030,11002030,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002038,11002038,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002040,11002040,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002042,11002042,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002044,11002044,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002046,11002046,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002048,11002048,'','','0','0','999','-100000','100000','999','0','0','0','0','0'),
(11002050,11002050,'','','0','0','999','-100000','100000','999','0','0','0','0','0');

INSERT INTO `cq_npc` VALUES ('7', '0', '0', 'Teleporter', '2', '10527', '0', '0', '-1', '1000', '292', '469', '1230000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '??', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
02/02/2010 18:43 matrix89#11
Quote:
Originally Posted by zspider View Post
(11002031,11002032,0,102,0,'I~want~to~go~to~*God~L and*. 11002042'),
(11002032,11002033,0,102,0,'I~want~to~go~to~*LeGen D~Garden*. 11002044'),
(11002033,11002034,0,102,0,'I~want~to~go~to~*WarZo ne*. 11002046'),
(11002034,11002035,0,102,0,'I~want~to~go~to~*The~f orest*. 11002046'),
(11002035,11002036,0,102,0,'I~want~to~go~to~*Deser t~WaRRioRs*. 11002048'),
(11002036,11002037,0,102,0,'I~want~to~go~to~*Canos a*. 11002050'),
Make sure u put ~ in param if u want make a space..
02/02/2010 22:28 zspider#12
Quote:
Originally Posted by matrix89 View Post
Make sure u put ~ in param if u want make a space..
it just be like that here it is fine in mine but i think the problem is here
Quote:
INSERT INTO `cq_npc` VALUES ('7', '0', '0', 'Teleporter', '2', '10527', '0', '0', '-1', '1000', '292', '469', '1230000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '??', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
but idk:(:(:confused::confused:
02/03/2010 02:53 PraDevil[ELITE]#13
try to make a npc id more than 4 (XXXX)
02/03/2010 16:33 King_Arthur#14
updated script in [Only registered and activated users can see links. Click Here To Register...] with a new id in the cq_npc line if you are still having problems with it.
02/06/2010 02:23 zspider#15
Quote:
delete from cq_action where id >= 5991122 and id <= 5991135;
delete from cq_npc where id >= 88795 and id <= 88795;

INSERT INTO `cq_action` VALUES ('5991122', '5991123', '0000', '0101', '0', 'Hello!~I\'m~the~LeGenD~Teleporter!~and~I~can~Tele port~you~to~any~of~these~LeGenD~Locations!');
INSERT INTO `cq_action` VALUES ('5991123', '5991124', '0000', '0102', '0', 'Take~me~to~The~God~Land. 5991130');
INSERT INTO `cq_action` VALUES ('5991124', '5991125', '0000', '0102', '0', 'Take~me~to~LeGenD~Garden. 5991131');
INSERT INTO `cq_action` VALUES ('5991125', '5991126', '0000', '0102', '0', 'Take~me~to~WarZone. 5991132');
INSERT INTO `cq_action` VALUES ('5991126', '5991127', '0000', '0102', '0', 'Take~me~to~The~Forest. 5991133');
INSERT INTO `cq_action` VALUES ('5991127', '5991128', '0000', '0102', '0', 'Take~me~to~Desert~For~Warriors. 5991134');
INSERT INTO `cq_action` VALUES ('5991128', '5991129', '0000', '0102', '0', 'Take~me~to~Canosa. 5991135');
INSERT INTO `cq_action` VALUES ('5991129', '4000034', '0000', '0102', '0', 'Nevermind. 0');
INSERT INTO `cq_action` VALUES ('5991130', '0000', '0000', '1003', '0', '10000 322 564 1');
INSERT INTO `cq_action` VALUES ('5991131', '0000', '0000', '1003', '0', '12000 190 242 1');
INSERT INTO `cq_action` VALUES ('5991132', '0000', '0000', '1003', '0', '1955 821 641 1');
INSERT INTO `cq_action` VALUES ('5991133', '0000', '0000', '1003', '0', '1924 164 88 1');
INSERT INTO `cq_action` VALUES ('5991134', '0000', '0000', '1003', '0', '1923 124 115 1');
INSERT INTO `cq_action` VALUES ('5991135', '0000', '0000', '1003', '0', '10024 158 100 1');

INSERT INTO `cq_npc` VALUES ('88795', '0', '0', 'LeGTele', '0002', '10527', '0', '0', '-1', '1000', '0292', '0469', '5991122', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '无', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
i make this from vip ones so i know i must add some cq_task for it but i see cq_task id is from cq_action'Condition like lvl of vip lvl or some thing like that can any one tell me what i must add or can any one tell me in all teleproter's i have 2 pages i wanaa change the places in the second page to go to my maps