[HELP]Teleporter dont work

12/10/2009 05:18 keithbell1234#1
hey i was wondering wat i did wrong in my query here it is

Code:
INSERT INTO `cq_action` VALUES ('99999100', '99999101', '0000', '0101', '1020010', 'Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!');
INSERT INTO `cq_action` VALUES ('99999101', '99999102', '0000', '0102', '0', 'I~want~to~go~to~Cata~Maze.40404000');
INSERT INTO `cq_action` VALUES ('99999102', '99999103', '0000', '0102', '0', 'I~want~to~go~to~Lostland. 404040401');
INSERT INTO `cq_action` VALUES ('99999103', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('99999104', '99999104', '9999105', '0', '0', 'level < 1');
INSERT INTO `cq_action` VALUES ('99999105', '99999105', '9999106', '0', '0', 'level < 1');
INSERT INTO `cq_action` VALUES ('99999106', '99999106', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('99999107', '4000010', '0000', '0102', '0', 'Aylright. 0');
INSERT INTO `cq_action` VALUES ('99999108', '0000', '0000', '1003', '0', '5200 598 596');
INSERT INTO `cq_action` VALUES ('99999109', '0000', '0000', '1003', '0', '5100 890 435');


INSERT INTO `cq_task` VALUES ('i99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999101', '99999102', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999102', '99999103', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999103', '4000010', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999104', '99999104', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999105', '99999105', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999106', '99999106', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999107', '4000010', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999108', '0000', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999109', '0000', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_npc` VALUES ('999999', '0', '0', 'Ownerr', '2', '10527', '0', '0', '-1', '1000', '292', '466', '9999100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'нч', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
i will be very please if u fixed it
12/10/2009 05:57 matrix89#2
Quote:
Originally Posted by keithbell1234 View Post
INSERT INTO `cq_action` VALUES ('99999101', '99999102', '0000', '0102', '0', 'I~want~to~go~to~Cata~Maze.40404000');
INSERT INTO `cq_action` VALUES ('99999102', '99999103', '0000', '0102', '0', 'I~want~to~go~to~Lostland. 404040401');
you try to view the data you need to have this word catamaze distance between the code,;)
if you do not separate the system will not read the numbers on the back

another,
ps try to check whether the id 404040401 and 40404000 are correct
ps does this have on the database you..;)

Quote:
INSERT INTO `cq_task` VALUES ('i99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
Please Remove the letter is in the id!
12/10/2009 06:02 keithbell1234#3
i might of fixed it lol

Quote:
INSERT INTO `cq_task` VALUES ('i99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
i put an i in one of the tasks alittle mistake
12/10/2009 06:13 matrix89#4
Quote:
Originally Posted by keithbell1234 View Post
i might of fixed it lol
i put an i in one of the tasks alittle mistake
possible database you can not read properly when ade letter ..

Code:
INSERT INTO `cq_action` VALUES ('99999100', '99999101', '0000', '0101', '1020010', 'Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!');
INSERT INTO `cq_action` VALUES ('99999101', '99999102', '0000', '0102', '0', 'I~want~to~go~to~Cata~Maze. 99999104');
INSERT INTO `cq_action` VALUES ('99999102', '99999103', '0000', '0102', '0', 'I~want~to~go~to~Lostland. 99999105');
INSERT INTO `cq_action` VALUES ('99999103', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('99999104', '99999108', '9999106', '0', '0', 'level < 1');
INSERT INTO `cq_action` VALUES ('99999105', '99999109', '9999106', '0', '0', 'level < 1');
INSERT INTO `cq_action` VALUES ('99999106', '99999107', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('99999107', '4000010', '0000', '0102', '0', 'Aylright. 0');
INSERT INTO `cq_action` VALUES ('99999108', '0000', '0000', '1003', '0', '5200 598 596');
INSERT INTO `cq_action` VALUES ('99999109', '0000', '0000', '1003', '0', '5100 890 435');


INSERT INTO `cq_task` VALUES ('99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999101', '99999102', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999102', '99999103', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999103', '4000010', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999104', '99999105', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999105', '99999106', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999106', '99999107', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999107', '4000010', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999108', '99999109', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('99999109', '0000', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');

INSERT INTO `cq_npc` VALUES ('999999', '0', '0', 'Ownerr', '2', '10527', '0', '0', '-1', '1000', '292', '466', '9999100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'нч', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Repair It..make same like this..!!
12/10/2009 06:51 keithbell1234#5
it still dont work :s
12/10/2009 07:27 PraDevil[ELITE]#6
if u are to trying to modified npc just a little pieces it will not work..
(eg:make it full,delete all then add it again..FULL)
use cronus teleporter as example..im also got this prob before..
12/10/2009 08:11 keithbell1234#7
im adding a teleporter wat takes me to lost land and cata for in market
12/10/2009 08:18 Eurion#8
Here's the correct sql, make sure you restart your server.

Code:
DELETE FROM `cq_action WHERE id >= 99999100 AND id <= 99999109;
DELETE FROM cq_task WHERE id >= 99999100 AND id <= 99999109;
DELETE FROM `cq_npc` WHERE id = 999999;

INSERT INTO `cq_action` VALUES 
('99999100', '99999101', '0000', '101', '0', 'Hello my Name is Ownerr i can Teleport you to any map!'),
('99999101', '99999102', '0000', '102', '0', 'I~want~to~go~to~Cata~Maze. 99999104'),
('99999102', '99999103', '0000', '102', '0', 'I~want~to~go~to~Lostland. 99999105'),
('99999103', '4000010', '0000', '102', '0', 'I~want~to~leave. 0'),
('99999104', '99999106', '9999108', '1001', '0', 'level < 1'),
('99999105', '99999106', '9999109', '1001', '0', 'level < 1'),
('99999106', '99999107', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!'),
('99999107', '4000010', '0000', '0102', '0', 'Aylright. 0'),
('99999108', '0000', '0000', '1003', '0', '5200 598 596'),
('99999109', '0000', '0000', '1003', '0', '5100 890 435');

INSERT INTO `cq_task` VALUES 
('99999100', '99999100', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0'),
('99999104', '99999104', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0'),
('99999105', '99999105', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');


INSERT INTO `cq_npc` VALUES 
('999999', '0', '0', 'Ownerr', '2', '10527', '0', '0', '-1', '1000', '292', '466', '99999100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '?T', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Now onto the errors.

1. You don't need all the INSERT INTO `TABLE` VALUES.
2. On the action id 99999100 you don't need something in the data column
3. You have too many inserts for the cq_task table. You only need the first npc talk, and then the options.
4. Most times your cq_tasks id and id_next will be the same.
5. The most important one is your cq_npc's task0 was missing a 9
6. The checks for the levels need a type of 1003
12/10/2009 11:12 funhacker#9
Although Eurion is right the query could still have a clean up. It makes it hard to read such things when they are so messy. Another thing I am really getting tired of saying is post ERROR logs! Or in this case the SQL error that is returned.

Eurion is incorrect in the action type. 1001 is the level check but keith you can not see if someone is > a certain level. You will have to use < a certain level and swap your id_next with id_nextfail. As for type 1003 that is used for teleporting to other maps.
12/10/2009 15:36 magewarior2#10
if it is still not working i have a little question for you

If you click on your npc, do you see the data? (at chat) or also not?

if its not then the problem is moste of the time in cq_task

maybe try those ('99999100', '99999100', '0', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '-1', '0'),

instead of ('99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0'), (hell this cq_task has miss placed table's?)

and if you see the data the problem can be in how you write it maybe you need to start your npc with a space ... i have got that problem to if i did not enter the first space it dint pop up ..

example (only first line of the npc!)
'Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!' );
' Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!' );

also if you have message's like
('99999106', '99999107', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!'),

its maybe easy'er to make the 101 to a 126, that also doesn't need a task ... and its lots easy'er with the space ect ...
than it just popups a message

also it can be a a lot more of things but maybe you shall try to check those things first

have a nice day, magewarior2
12/10/2009 17:54 Eurion#11
Quote:
Originally Posted by funhacker View Post

Eurion is incorrect in the action type. 1001 is the level check but keith you can not see if someone is > a certain level. You will have to use < a certain level and swap your id_next with id_nextfail. As for type 1003 that is used for teleporting to other maps.

That is correct, sorry about that keith it was 2 AM when I was looking at this.

I've edited my first post to reflect the changes that funhacker pointed out.
12/11/2009 00:04 keithbell1234#12
Quote:
Originally Posted by magewarior2 View Post
if it is still not working i have a little question for you

If you click on your npc, do you see the data? (at chat) or also not?

if its not then the problem is moste of the time in cq_task

maybe try those ('99999100', '99999100', '0', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '-1', '0'),

instead of ('99999100', '99999101', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0'), (hell this cq_task has miss placed table's?)

and if you see the data the problem can be in how you write it maybe you need to start your npc with a space ... i have got that problem to if i did not enter the first space it dint pop up ..

example (only first line of the npc!)
'Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!' );
' Hello~my~Name~is~Ownerr~i~can~Teleport~you~to~any~map!' );

also if you have message's like
('99999106', '99999107', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!'),

its maybe easy'er to make the 101 to a 126, that also doesn't need a task ... and its lots easy'er with the space ect ...
than it just popups a message

also it can be a a lot more of things but maybe you shall try to check those things first

have a nice day, magewarior2
yeh every time i click it i see nothing in params nothing comes up
12/11/2009 18:04 magewarior2#13
Quote:
Originally Posted by keithbell1234 View Post
yeh every time i click it i see nothing in params nothing comes up
try my new table's of cq_task i have noticed you have some rows wrong ...

copy this '99999100', '99999100', '0', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '-1', '0'),

and add them "manual" into your cq_talk (always better than msql commands)

also add the next of them (manual)

and than restart your server ... if you did that the rows have to show in to your data (PM account request than) If not ... than you have to say it :bandit: