[Help] npc teliporting script i made

Page 1 of 2 1 2
07/11/2009 06:51 Crusaders-Online#1
does anyone know whats wrong with this npc teliport script i made it adds the npc and no errors when running the sql file but when i click the npc nothing happens. the script looks fine to me




Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '1020010', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
INSERT INTO `cq_action` VALUES ('19822', '19823', '0000', '0102', '0', 'I~want~to~go~to~dark~castle. 19826');
INSERT INTO `cq_action` VALUES ('19823', '19824', '0000', '0102', '0', 'I~want~to~go~to~rose~hall. 19825');
INSERT INTO `cq_action` VALUES ('19824', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('19825', '19827', '198210', '0', '0', 'level < 0'); 
INSERT INTO `cq_action` VALUES ('19826', '19827', '19829', '0', '0', 'level < 0'); 
INSERT INTO `cq_action` VALUES ('19827', '19828', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('19828', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('19829', '0000', '0000', '1003', '0', '1980 220 380'); 
INSERT INTO `cq_action` VALUES ('198210', '0000', '0000', '1003', '0', '8901 30 50'); 


INSERT INTO `cq_task` VALUES ('19821', '19821', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19822', '19822', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19823', '19823', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19824', '19824', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19825', '19825', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19826', '19826', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19827', '19827', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19828', '19828', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19829', '19829', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('198210', '198210', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');

INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '19822', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
07/11/2009 07:35 hio77#2
Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '0', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
your issue is an extra number here

Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '[COLOR=Red]1020010[/COLOR]', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
this red number should be an 0 as above
07/11/2009 08:36 Crusaders-Online#3
Quote:
Originally Posted by hio77 View Post
Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '0', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
your issue is an extra number here

Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '[COLOR=Red]1020010[/COLOR]', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
this red number should be an 0 as above
it still dont work when i click the npc nothing opens =/ do you see anything else wrong with the script.
07/11/2009 08:53 hio77#4
Quote:
Originally Posted by Crusaders-Online View Post
it still dont work when i click the npc nothing opens =/ do you see anything else wrong with the script.
now that i look at it yup yup :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19821[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
incorrect action id :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19822[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
07/11/2009 08:57 Romur#5
Post was meaningless.
07/11/2009 09:07 hio77#6
Quote:
Originally Posted by hio77 View Post
Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '0', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
your issue is an extra number here

Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '[COLOR=Red]1020010[/COLOR]', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
this red number should be an 0 as above
Quote:
Originally Posted by Romur View Post
Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '[COLOR=red]1020010[/COLOR]', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
Another thing why do you have the red 1020010 in with an npc's talk? The data should be 0 with a 101 type.
mind telling me whats the difference thats the same as i told him early lol
07/11/2009 09:12 Romur#7
Sorry, I didn't catch that part :P Blame the time.
07/11/2009 09:13 Crusaders-Online#8
Quote:
Originally Posted by hio77 View Post
now that i look at it yup yup :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19821[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
incorrect action id :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19822[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
nope that fix still dont make the npc open when i click it hehe seems there still is something wrong in the script lol. )= and this is hpow it looks now



Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '0', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
INSERT INTO `cq_action` VALUES ('19822', '19823', '0000', '0102', '0', 'I~want~to~go~to~dark~castle. 19826');
INSERT INTO `cq_action` VALUES ('19823', '19824', '0000', '0102', '0', 'I~want~to~go~to~rose~hall. 19825');
INSERT INTO `cq_action` VALUES ('19824', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('19825', '19827', '198210', '0', '0', 'level < 0'); 
INSERT INTO `cq_action` VALUES ('19826', '19827', '19829', '0', '0', 'level < 0'); 
INSERT INTO `cq_action` VALUES ('19827', '19828', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('19828', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('19829', '0000', '0000', '1003', '0', '1980 220 380'); 
INSERT INTO `cq_action` VALUES ('198210', '0000', '0000', '1003', '0', '8901 30 50'); 


INSERT INTO `cq_task` VALUES ('19821', '19821', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19822', '19822', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19823', '19823', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19824', '19824', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19825', '19825', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19826', '19826', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19827', '19827', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19828', '19828', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19829', '19829', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('198210', '198210', '', '', '0', '0', '999', '-100000', '100000', '999', '0', '0', '0', '0', '0');

INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '19821', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
07/11/2009 09:15 hio77#9
Quote:
Originally Posted by Crusaders-Online View Post
nope that fix still dont make the npc open when i click it hehe seems there still is something wrong in the script lol. )=
lol how could you have messed it sooo badly .... ill have to dump it into a tmp db so i can see all your errors ...
07/11/2009 09:18 Crusaders-Online#10
Quote:
Originally Posted by hio77 View Post
now that i look at it yup yup :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19821[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
incorrect action id :D

Code:
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcastle', '2', '10527', '0', '0', '-1', '1000', '0295', '0435', '[COLOR=Red]19822[/COLOR]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '无', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Quote:
Originally Posted by hio77 View Post
lol how could you have messed it sooo badly .... ill have to dump it into a tmp db so i can see all your errors ...
the sql file runs just fine with no errors so its the script lol
07/11/2009 09:30 hio77#11
Quote:
Originally Posted by Crusaders-Online View Post
the sql file runs just fine with no errors so its the script lol
ok so far all your tasks are wrong .... you would need a massive pk to use it .....

on your level cheeks though at 0 they are usless ... had the wrong type ... should be 1001

corrected sql:
Code:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: hgfhfh
Target Host: localhost
Target Database: hgfhfh
Date: 7/11/2009 7:28:40 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cq_action
-- ----------------------------
CREATE TABLE `cq_action` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `id_next` int(4) unsigned zerofill NOT NULL default '0000',
  `id_nextfail` int(4) unsigned zerofill NOT NULL default '0000',
  `type` int(4) unsigned zerofill NOT NULL default '0000',
  `data` int(4) NOT NULL default '0',
  `param` char(127) character set latin1 collate latin1_bin NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cq_npc
-- ----------------------------
CREATE TABLE `cq_npc` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `ownerid` int(4) unsigned default '0',
  `playerid` int(4) unsigned default '0',
  `name` char(15) character set latin1 collate latin1_bin default '脦麓脙眉脙没',
  `type` int(4) unsigned zerofill default '0000',
  `lookface` int(4) unsigned zerofill default '0000',
  `length` tinyint(4) NOT NULL default '0',
  `fat` tinyint(4) NOT NULL default '0',
  `idxserver` int(4) default '-1',
  `mapid` int(4) unsigned zerofill default '0000',
  `cellx` int(4) unsigned zerofill default '0000',
  `celly` int(4) unsigned zerofill default '0000',
  `task0` int(4) unsigned zerofill default '0000',
  `task1` int(4) unsigned zerofill default '0000',
  `task2` int(4) unsigned zerofill default '0000',
  `task3` int(4) unsigned zerofill default '0000',
  `task4` int(4) unsigned zerofill default '0000',
  `task5` int(4) unsigned zerofill default '0000',
  `task6` int(4) unsigned zerofill default '0000',
  `task7` int(4) unsigned zerofill default '0000',
  `data0` int(4) NOT NULL default '0',
  `data1` int(4) NOT NULL default '0',
  `data2` int(4) NOT NULL default '0',
  `data3` int(4) NOT NULL default '0',
  `datastr` char(15) character set latin1 collate latin1_bin default '脦脼',
  `linkid` int(4) unsigned zerofill NOT NULL default '0000',
  `life` smallint(2) unsigned zerofill NOT NULL default '00',
  `maxlife` smallint(2) unsigned zerofill NOT NULL default '00',
  `base` int(4) unsigned zerofill NOT NULL default '0000',
  `sort` smallint(2) unsigned zerofill NOT NULL default '00',
  `itemid` int(4) unsigned zerofill NOT NULL default '0000',
  `size_front` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_back` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_left` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_right` smallint(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cq_task
-- ----------------------------
CREATE TABLE `cq_task` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `id_next` int(4) unsigned zerofill NOT NULL default '0000',
  `id_nextfail` int(4) unsigned zerofill NOT NULL default '0000',
  `itemname1` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `itemname2` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `money` int(4) unsigned NOT NULL default '0',
  `profession` int(4) unsigned NOT NULL default '0',
  `sex` int(4) unsigned NOT NULL default '0',
  `min_pk` int(4) NOT NULL default '0',
  `max_pk` int(4) NOT NULL default '0',
  `team` int(4) unsigned zerofill NOT NULL default '0000',
  `metempsychosis` int(4) unsigned zerofill NOT NULL default '0000',
  `query` tinyint(1) unsigned zerofill NOT NULL default '0',
  `marriage` tinyint(4) NOT NULL default '-1',
  `client_active` tinyint(1) unsigned zerofill NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '1020010', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
INSERT INTO `cq_action` VALUES ('19822', '19823', '0000', '0102', '0', 'I~want~to~go~to~dark~castle. 19826');
INSERT INTO `cq_action` VALUES ('19823', '19824', '0000', '0102', '0', 'I~want~to~go~to~rose~hall. 19825');
INSERT INTO `cq_action` VALUES ('19824', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('19825', '19827', '198210', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19826', '19827', '19829', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19827', '19828', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('19828', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('19829', '0000', '0000', '1003', '0', '1980 220 380');
INSERT INTO `cq_action` VALUES ('198210', '0000', '0000', '1003', '0', '8901 30 50');
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcas', '0002', '10527', '0', '0', '-1', '1000', '0295', '0435', '19821', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '脦脼', '0000', '00', '00', '0000', '00', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_task` VALUES ('19821', '19821', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19822', '19822', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19823', '19823', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19824', '19824', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19825', '19825', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19826', '19826', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19827', '19827', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19828', '19828', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19829', '19829', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('198210', '198210', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');

.... i have not included a delete into that
07/11/2009 09:43 Crusaders-Online#12
Quote:
Originally Posted by hio77 View Post
ok so far all your tasks are wrong .... you would need a massive pk to use it .....

on your level cheeks though at 0 they are usless ... had the wrong type ... should be 1001

corrected sql:
Code:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: hgfhfh
Target Host: localhost
Target Database: hgfhfh
Date: 7/11/2009 7:28:40 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cq_action
-- ----------------------------
CREATE TABLE `cq_action` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `id_next` int(4) unsigned zerofill NOT NULL default '0000',
  `id_nextfail` int(4) unsigned zerofill NOT NULL default '0000',
  `type` int(4) unsigned zerofill NOT NULL default '0000',
  `data` int(4) NOT NULL default '0',
  `param` char(127) character set latin1 collate latin1_bin NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cq_npc
-- ----------------------------
CREATE TABLE `cq_npc` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `ownerid` int(4) unsigned default '0',
  `playerid` int(4) unsigned default '0',
  `name` char(15) character set latin1 collate latin1_bin default '脦麓脙眉脙没',
  `type` int(4) unsigned zerofill default '0000',
  `lookface` int(4) unsigned zerofill default '0000',
  `length` tinyint(4) NOT NULL default '0',
  `fat` tinyint(4) NOT NULL default '0',
  `idxserver` int(4) default '-1',
  `mapid` int(4) unsigned zerofill default '0000',
  `cellx` int(4) unsigned zerofill default '0000',
  `celly` int(4) unsigned zerofill default '0000',
  `task0` int(4) unsigned zerofill default '0000',
  `task1` int(4) unsigned zerofill default '0000',
  `task2` int(4) unsigned zerofill default '0000',
  `task3` int(4) unsigned zerofill default '0000',
  `task4` int(4) unsigned zerofill default '0000',
  `task5` int(4) unsigned zerofill default '0000',
  `task6` int(4) unsigned zerofill default '0000',
  `task7` int(4) unsigned zerofill default '0000',
  `data0` int(4) NOT NULL default '0',
  `data1` int(4) NOT NULL default '0',
  `data2` int(4) NOT NULL default '0',
  `data3` int(4) NOT NULL default '0',
  `datastr` char(15) character set latin1 collate latin1_bin default '脦脼',
  `linkid` int(4) unsigned zerofill NOT NULL default '0000',
  `life` smallint(2) unsigned zerofill NOT NULL default '00',
  `maxlife` smallint(2) unsigned zerofill NOT NULL default '00',
  `base` int(4) unsigned zerofill NOT NULL default '0000',
  `sort` smallint(2) unsigned zerofill NOT NULL default '00',
  `itemid` int(4) unsigned zerofill NOT NULL default '0000',
  `size_front` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_back` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_left` smallint(4) unsigned zerofill NOT NULL default '0000',
  `size_right` smallint(4) unsigned zerofill NOT NULL default '0000',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for cq_task
-- ----------------------------
CREATE TABLE `cq_task` (
  `id` int(4) unsigned zerofill NOT NULL default '0000',
  `id_next` int(4) unsigned zerofill NOT NULL default '0000',
  `id_nextfail` int(4) unsigned zerofill NOT NULL default '0000',
  `itemname1` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `itemname2` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `money` int(4) unsigned NOT NULL default '0',
  `profession` int(4) unsigned NOT NULL default '0',
  `sex` int(4) unsigned NOT NULL default '0',
  `min_pk` int(4) NOT NULL default '0',
  `max_pk` int(4) NOT NULL default '0',
  `team` int(4) unsigned zerofill NOT NULL default '0000',
  `metempsychosis` int(4) unsigned zerofill NOT NULL default '0000',
  `query` tinyint(1) unsigned zerofill NOT NULL default '0',
  `marriage` tinyint(4) NOT NULL default '-1',
  `client_active` tinyint(1) unsigned zerofill NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '1020010', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
INSERT INTO `cq_action` VALUES ('19822', '19823', '0000', '0102', '0', 'I~want~to~go~to~dark~castle. 19826');
INSERT INTO `cq_action` VALUES ('19823', '19824', '0000', '0102', '0', 'I~want~to~go~to~rose~hall. 19825');
INSERT INTO `cq_action` VALUES ('19824', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('19825', '19827', '198210', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19826', '19827', '19829', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19827', '19828', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('19828', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('19829', '0000', '0000', '1003', '0', '1980 220 380');
INSERT INTO `cq_action` VALUES ('198210', '0000', '0000', '1003', '0', '8901 30 50');
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcas', '0002', '10527', '0', '0', '-1', '1000', '0295', '0435', '19821', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '脦脼', '0000', '00', '00', '0000', '00', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_task` VALUES ('19821', '19821', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19822', '19822', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19823', '19823', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19824', '19824', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19825', '19825', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19826', '19826', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19827', '19827', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19828', '19828', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19829', '19829', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('198210', '198210', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');

.... i have not included a delete into that
nope npc is still not working lol i been working on this for over 6 hours and still dont work
07/11/2009 09:57 hio77#13
Quote:
Originally Posted by Crusaders-Online View Post
nope npc is still not working lol i been working on this for over 6 hours and still dont work
you sure .... ill look at it tomorrow when i can think .... i never tested just looked at numbers in navicat :D
07/11/2009 10:03 Crusaders-Online#14
Quote:
Originally Posted by hio77 View Post
you sure .... ill look at it tomorrow when i can think .... i never tested just looked at numbers in navicat :D
i have this and the npc dont even open lol this is what you gave me


Code:
INSERT INTO `cq_action` VALUES ('19821', '19822', '0000', '0101', '1020010', 'would~you~like~to~go~to~the~dark~castle~or~rose~hall!');
INSERT INTO `cq_action` VALUES ('19822', '19823', '0000', '0102', '0', 'I~want~to~go~to~dark~castle. 19826');
INSERT INTO `cq_action` VALUES ('19823', '19824', '0000', '0102', '0', 'I~want~to~go~to~rose~hall. 19825');
INSERT INTO `cq_action` VALUES ('19824', '4000010', '0000', '0102', '0', 'I~want~to~leave. 0');
INSERT INTO `cq_action` VALUES ('19825', '19827', '198210', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19826', '19827', '19829', '1001', '0', 'level < 0');
INSERT INTO `cq_action` VALUES ('19827', '19828', '0000', '0101', '0', 'Your~level~is~too~low~too~leave!');
INSERT INTO `cq_action` VALUES ('19828', '4000010', '0000', '0102', '0', 'Alright. 0');
INSERT INTO `cq_action` VALUES ('19829', '0000', '0000', '1003', '0', '1980 220 380');
INSERT INTO `cq_action` VALUES ('198210', '0000', '0000', '1003', '0', '8901 30 50');
INSERT INTO `cq_npc` VALUES ('22998', '0', '0', 'rosehalldarkcas', '0002', '10527', '0', '0', '-1', '1000', '0295', '0435', '19821', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '无', '0000', '00', '00', '0000', '00', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_task` VALUES ('19821', '19821', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19822', '19822', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19823', '19823', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19824', '19824', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19825', '19825', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19826', '19826', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19827', '19827', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19828', '19828', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('19829', '19829', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
INSERT INTO `cq_task` VALUES ('198210', '198210', '0000', '', '0', '0', '999', '0', '-100000', '100000', '0000', '0000', '0', '0', '0');
07/11/2009 11:51 Crusaders-Online#15
i got it fixed seems after the cords it needs to have a 1

'1980 220 380 1');


thanks hio77 i hit thanks for you hehe.
Page 1 of 2 1 2