|
You last visited: Today at 05:08
Advertisement
[HELP]Teleporter dont work
Discussion on [HELP]Teleporter dont work within the EO PServer Hosting forum part of the Eudemons Online category.
12/10/2009, 05:18
|
#1
|
elite*gold: 20 
Join Date: Oct 2008
Posts: 556
Received Thanks: 140
|
[HELP]Teleporter dont work
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
|
#2
|
elite*gold: 0
Join Date: Aug 2009
Posts: 347
Received Thanks: 114
|
Quote:
Originally Posted by keithbell1234
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
|
#3
|
elite*gold: 20
Join Date: Oct 2008
Posts: 556
Received Thanks: 140
|
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
|
#4
|
elite*gold: 0
Join Date: Aug 2009
Posts: 347
Received Thanks: 114
|
Quote:
Originally Posted by keithbell1234
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
|
#5
|
elite*gold: 20
Join Date: Oct 2008
Posts: 556
Received Thanks: 140
|
it still dont work :s
|
|
|
|
|
12/10/2009, 07:27
|
#6
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
|
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
|
#7
|
elite*gold: 20
Join Date: Oct 2008
Posts: 556
Received Thanks: 140
|
im adding a teleporter wat takes me to lost land and cata for in market
|
|
|
|
|
12/10/2009, 08:18
|
#8
|
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
|
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
|
#9
|
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,746
|
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
|
#10
|
elite*gold: 20
Join Date: Mar 2008
Posts: 1,548
Received Thanks: 817
|
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
|
#11
|
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
|
Quote:
Originally Posted by funhacker
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
|
#12
|
elite*gold: 20
Join Date: Oct 2008
Posts: 556
Received Thanks: 140
|
Quote:
Originally Posted by magewarior2
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
|
#13
|
elite*gold: 20
Join Date: Mar 2008
Posts: 1,548
Received Thanks: 817
|
Quote:
Originally Posted by keithbell1234
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 
|
|
|
|
 |
Similar Threads
|
Work with artmoney dont work
05/25/2009 - Kal Online - 4 Replies
Hello together
I have artmoney with the Spyware process detector but when i am select the game (Kalonline) spyware the engine exe not find have anybody an good idea for me ?
thanks and an good night
|
sv dont work?
11/22/2007 - Conquer Online 2 - 2 Replies
I have been using SV 1.17..It has been working until the new patch...The error is something like reinstall game or get latest patch......Does any sv work?
|
CO dont work man
04/28/2007 - Conquer Online 2 - 1 Replies
its so f***ed up i cant even use cyclone on my trojan and the fonts availible are so hert its wore then the original
aslo it adds a sh!t load of random letters onto my messages where if i type "sup" to someone it looks like "sup§?□□□□□` 33;□ἶἶἶởở̖ 3;ở" anyone know of anyways to fix i reinstalled everything no mods and i had also just migrated my xp install of CO2 over the network casuse its a new computer and i was just trying that and that wouldnt even start up but it ran fine on the xp machine
...
|
l2w dont work
12/14/2005 - Lineage 2 - 0 Replies
Hi i have l2w 10.2.3 but if i press BeginCombat my l2w target mob and say this to l2w window 21:49:53 超出时间,换目& #26631;. and target other mobs .what is it ?
|
All times are GMT +1. The time now is 05:08.
|
|
![[HELP]Teleporter dont work](https://www.elitepvpers.com/forum/iconimages/eo-pserver-hosting/help-teleporter-dont-work_ltr.gif){kind=small}
![PraDevil[ELITE]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1857785_25.gif){kind=avatar}
