forgetful DB ?

01/20/2013 05:50 Senglade#1
ok i been working on my DB for sometime now an got almost everything working till today when i lost my astral teleporter the npc is there but dose nothing when clicked checked CQ action an the ID's where just gone i made a new SQL from a backup an just inserted em no problems but still non functioning any help here my sql

INSERT INTO `cq_action` VALUES ('999001', '999002', '0000', '0101', '0', 'Hi~%user_name,~Im~Astral~Quest~teleporter.');
INSERT INTO `cq_action` VALUES ('999002', '999003', '0000', '0101', '0', 'I~can~send~you~to~Astral~Domain.~you~can~know~all ~information~about~quest~in~Astral~Domain');
INSERT INTO `cq_action` VALUES ('999003', '999004', '0000', '0101', '0', 'Are~you~want~enter~Astral~Domain?');
INSERT INTO `cq_action` VALUES ('999004', '999007', '0000', '0102', '0', 'Yes,~I~want~enter~Astral~Domain!999005');
INSERT INTO `cq_action` VALUES ('999005', '999006', '0000', '1003', '0', '5397 134 135');
INSERT INTO `cq_action` VALUES ('999006', '0000', '0000', '0126', '0', 'Welcome to Astral Domain.');
INSERT INTO `cq_action` VALUES ('999007', '4000036', '0000', '0102', '0', 'No~Thank~you. 0');
INSERT INTO `cq_action` VALUES ('999008', '999009', '0000', '0104', '0', '0 0 998006');
01/20/2013 18:45 georgeion92#2
the npc that is created has not action,try and put the id action on that npc via cq_npc
01/23/2013 09:34 pretzel666#3
999001 <- make sure that line is on the npc action , also make sure the actions are added into cq_task
01/23/2013 19:14 Senglade#4
ty for those that try an help me on this far as i can tell i got all set right this my first teleporter i have had to work on so it all new can anyone add a working teleporter sql for me to study plz an ty