[help]Teleport

04/21/2011 08:13 DuaSelipar#1
can someone look on my script...when i click on npc..nothing happen...did i something wrong with this query?

Code:
 delete from cq_npc where id = 665100;
INSERT INTO `cq_npc` VALUES ('665100', '0', '0', 'Quest', '0123', '6651006', '0', '0', '-1', '1000', '307', '404', '531100000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'нч', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

delete from cq_action where id >= 531100000 and id <= 531100010;
INSERT INTO `cq_action` VALUES ('531100000', '531100001', '531100003', '0123', '4', '6 10:00 6 10:30');
INSERT INTO `cq_action` VALUES ('531100001', '531100002', '0000', '0101', '0', 'start~at~10:00~and~will~end~at~10:30~Every~Saturday');
INSERT INTO `cq_action` VALUES ('531100002', '4000010', '0000', '0102', '0', 'Ok~I~come~again~later. 0');
INSERT INTO `cq_action` VALUES ('531100003', '531100004', '0000', '0101', '0', 'Hi~%user_name,~Are~You~Ready~To~Go?');
INSERT INTO `cq_action` VALUES ('531100004', '531100005', '0000', '0101', '0', 'Ready~To~get~In?');
INSERT INTO `cq_action` VALUES ('531100005', '531100006', '0000', '0101', '0', 'You~Must~Level~255~To~Participate');
INSERT INTO `cq_action` VALUES ('531100006', '531100007', '0000', '0102', '0', 'Lets~Get~It~Start 531100007');
INSERT INTO `cq_action` VALUES ('531100007', '531100008', '531100009', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('531100008', '0', '0', '1003', '0', '1922 178 181');
INSERT INTO `cq_action` VALUES ('531100009', '531100010', '0000', '0101', '0', 'Sorry,~Your~Level~Must~Be~255');
INSERT INTO `cq_action` VALUES ('531100010', '4000010', '0000', '0102', '0', 'Ok~NeverMind 0');

delete from cq_task where id = 531100000;
delete from cq_task where id = 531100007;
INSERT `cq_task` VALUES ('531100007', '531100007', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT `cq_task` VALUES ('531100000', '531100000', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
04/21/2011 10:01 josh468#2
Yes there is something wrong, and even more than one important thing you forgot..

if you want to creat a dialog box your querry must consist the following types:

-101 - main chat
-102 - sub chat
-104 - you decide which face you want eg. param=0 0 3
-120 - this finish you dialog box param=must be empty!

and..

type 1003 MUST be also in cq_task! wthout cq_task it wont work


Soo lets do this.
04/21/2011 10:31 DuaSelipar#3
ok i have add in cq_task...still same result..

Code:
delete from cq_npc where id = 665100;
INSERT INTO `cq_npc` VALUES ('665100', '0', '0', 'Quest', '0123', '6651006', '0', '0', '-1', '1000', '307', '404', '531100000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'нч', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

delete from cq_action where id >= 531100000 and id <= 531100010;
INSERT INTO `cq_action` VALUES ('531100000', '531100001', '531100003', '0123', '4', '6 10:00 6 10:30');
INSERT INTO `cq_action` VALUES ('531100001', '531100002', '0000', '0101', '0', 'Legendary~Hunter~Event~will~start~at~10:00~and~will~end~at~10:30~Every~Saturday');
INSERT INTO `cq_action` VALUES ('531100002', '4000010', '0000', '0102', '0', 'Ok~I~come~again~later. 0');
INSERT INTO `cq_action` VALUES ('531100003', '531100004', '0000', '0101', '0', 'Hi~%user_name,~Are~You~Ready~To~Be?');
INSERT INTO `cq_action` VALUES ('531100004', '531100005', '0000', '0101', '0', 'Make~Sure~You~Strong~Enough~And~Ready~To~Get~In');
INSERT INTO `cq_action` VALUES ('531100005', '531100006', '0000', '0101', '0', 'You~Must~Level~255~To~Participate');
INSERT INTO `cq_action` VALUES ('531100006', '531100007', '0000', '0102', '0', 'Lets~Get~It~Start 531100007');
INSERT INTO `cq_action` VALUES ('531100007', '531100008', '531100009', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('531100008', '0', '0', '1003', '0', '1922 178 181');
INSERT INTO `cq_action` VALUES ('531100009', '531100010', '0000', '0101', '0', 'Sorry,~Your~Level~Must~Be~255');
INSERT INTO `cq_action` VALUES ('531100010', '4000010', '0000', '0102', '0', 'Ok~NeverMind 0');

delete from cq_task where id >= 531100000 and id <= 531100009;
INSERT INTO `cq_task` VALUES ('531100000', '531100000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100001', '531100001', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100003', '531100003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100007', '531100007', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100008', '531100008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100009', '531100009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
i have made that query base on this

Code:
delete from cq_action where id >= 570000000 and id <= 570000019;

INSERT INTO `cq_action` VALUES ('570000000', '570000001', '570000003', '0123', '4', '20:00 21:00');
INSERT INTO `cq_action` VALUES ('570000001', '570000002', '0000', '0101', '0', 'Event~will~start~at~20:00~and~will~end~at~21:00');
INSERT INTO `cq_action` VALUES ('570000002', '4000010', '0000', '0102', '0', 'Ok~I~come~again~later. 0');
INSERT INTO `cq_action` VALUES ('570000003', '570000004', '0000', '0101', '0', 'Hi~%user_name,~Please~choose~your~event~map~to~enter');
INSERT INTO `cq_action` VALUES ('570000004', '570000005', '0000', '0102', '0', 'Level~1~to~level~254~Map 570000008');
INSERT INTO `cq_action` VALUES ('570000005', '570000006', '0000', '0102', '0', 'Level~255~Map 570000012');
INSERT INTO `cq_action` VALUES ('570000006', '570000007', '0000', '0102', '0', 'Vip~7~Map 570000016');
INSERT INTO `cq_action` VALUES ('570000007', '4000010', '0000', '0102', '0', 'Im~Lazy.~Next~time~maybe. 0');
INSERT INTO `cq_action` VALUES ('570000008', '570000009', '570000010', '1001', '0', 'level < 255');
INSERT INTO `cq_action` VALUES ('570000009', '0', '0', '1003', '0', '9902 67 117');
INSERT INTO `cq_action` VALUES ('570000010', '570000011', '0000', '0101', '0', 'U~already~at~max~level.~Please~choose~other~map');
INSERT INTO `cq_action` VALUES ('570000011', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');
INSERT INTO `cq_action` VALUES ('570000012', '570000013', '570000014', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('570000013', '0', '0', '1003', '0', '9900 67 117');
INSERT INTO `cq_action` VALUES ('570000014', '570000015', '0000', '0101', '0', 'U~still~not~reach~level~255.~Please~choose~other~map');
INSERT INTO `cq_action` VALUES ('570000015', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');
INSERT INTO `cq_action` VALUES ('570000016', '570000017', '570000018', '5001', '0', '== 7');
INSERT INTO `cq_action` VALUES ('570000017', '0', '0', '1003', '0', '9901 67 117');
INSERT INTO `cq_action` VALUES ('570000018', '570000019', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~7.~You~cannot~go~to~this~VIP~map!');
INSERT INTO `cq_action` VALUES ('570000019', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');

delete from cq_task where id >= 570000000 and id <= 570000016;

INSERT INTO `cq_task` VALUES ('570000000', '570000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000001', '570000001', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000003', '570000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000008', '570000008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000009', '570000009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000011', '570000011', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000012', '570000012', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000013', '570000013', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000014', '570000014', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000016', '570000016', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
04/21/2011 11:21 josh468#4
If you read careful what did i wrote then your queryy should look like that

Code:
heh did you read whaty i wrote about characteristics about dialog box?

delete from cq_action where id >= 531100000 and id <= 531100010;
INSERT INTO `cq_action` VALUES ('531100000', '531100001', '531100003', '0123', '4', '6 10:00 6 10:30');
INSERT INTO `cq_action` VALUES ('531100001', '531100002', '0000', '0101', '0', 'Legendary~Hunter~Event~will~start~at~10:00~and~will~end~at~10:30~Every~Saturday');
INSERT INTO `cq_action` VALUES ('531100002', '3232', '0000', '0102', '0', 'Ok~I~come~again~later. 0');
INSERT INTO `cq_action` VALUES ('3232', '3233', '0000', '104', '0000', '0 0 3'
INSERT INTO `cq_action` VALUES ('3233', '0000', '0000', '120', '0000', '')
INSERT INTO `cq_action` VALUES ('531100003', '531100004', '0000', '0101', '0', 'Hi~%user_name,~Are~You~Ready~To~Be?');
INSERT INTO `cq_action` VALUES ('531100004', '531100005', '0000', '0101', '0', 'Make~Sure~You~Strong~Enough~And~Ready~To~Get~In');
INSERT INTO `cq_action` VALUES ('531100005', '531100006', '0000', '0101', '0', 'You~Must~Level~255~To~Participate');
INSERT INTO `cq_action` VALUES ('531100006', '3232', '0000', '0102', '0', 'Lets~Get~It~Start 531100007');
INSERT INTO `cq_action` VALUES ('531100007', '531100008', '531100009', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('531100008', '0', '0', '1003', '0', '1922 178 181');
INSERT INTO `cq_action` VALUES ('531100009', '531100010', '0000', '0101', '0', 'Sorry,~Your~Level~Must~Be~255');
INSERT INTO `cq_action` VALUES ('531100010', '3232', '0000', '0102', '0', 'Ok~NeverMind 0');

delete from cq_task where id >= 531100000 and id <= 531100009;
INSERT INTO `cq_task` VALUES ('531100000', '531100000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100001', '531100001', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100003', '531100003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100007', '531100007', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100008', '531100008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('531100009', '531100009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
Try this and if i didnt make any mistakes then it shoul works
04/21/2011 13:10 DuaSelipar#5
oh sorry xD..i miss that part...and still same :(
04/21/2011 13:57 josh468#6
Quote:
Originally Posted by UltimateChaos View Post
oh sorry xD..i miss that part...and still same :(
look at the first action!

There is a time aciotn and now task for u what is wrog there

tip [Only registered and activated users can see links. Click Here To Register...]



REGARDS
04/24/2011 02:22 -+Sezzy+-#7
Seriously stop posting it.