Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
[Help] npc teliporting script i made [Help] npc teliporting script i made
You last visited: Today at 14:53

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Help] npc teliporting script i made

Discussion on [Help] npc teliporting script i made within the EO PServer Hosting forum part of the Eudemons Online category.

Reply
Page 1 of 2 1 2
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
[Help] npc teliporting script i made

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');
Crusaders-Online is offline  
Old 07/11/2009, 07:35   #2
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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
hio77 is offline  
Old 07/11/2009, 08:36   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
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.
Crusaders-Online is offline  
Old 07/11/2009, 08:53   #4
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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

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

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');
hio77 is offline  
Old 07/11/2009, 08:57   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 11
Received Thanks: 3
Post was meaningless.
Romur is offline  
Old 07/11/2009, 09:07   #6
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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
hio77 is offline  
Old 07/11/2009, 09:12   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 11
Received Thanks: 3
Sorry, I didn't catch that part :P Blame the time.
Romur is offline  
Old 07/11/2009, 09:13   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
Quote:
Originally Posted by hio77 View Post
now that i look at it yup yup

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

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');
Crusaders-Online is offline  
Old 07/11/2009, 09:15   #9
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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 ...
hio77 is offline  
Old 07/11/2009, 09:18   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
Quote:
Originally Posted by hio77 View Post
now that i look at it yup yup

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

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
Crusaders-Online is offline  
Old 07/11/2009, 09:30   #11
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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
Attached Files
File Type: rar fixed.sql.rar (1.2 KB, 2 views)
hio77 is offline  
Thanks
1 User
Old 07/11/2009, 09:43   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
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
Crusaders-Online is offline  
Old 07/11/2009, 09:57   #13
 
hio77's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 825
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
hio77 is offline  
Thanks
1 User
Old 07/11/2009, 10:03   #14
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
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
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');
Crusaders-Online is offline  
Old 07/11/2009, 11:51   #15
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2009
Posts: 25
Received Thanks: 8
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.
Crusaders-Online is offline  
Thanks
1 User
Reply
Page 1 of 2 1 2

« [Help] Boss Drops | [New Server]Ultimate Eo I want to see how much it can hold »

Similar Threads Similar Threads
Need help from who made a bot befor like how made jProxy and gproxy...
06/09/2010 - Conquer Online 2 - 0 Replies
Hey , im wonder is making bot easy or too hard , and what skill in codin i have learn to creat a one , and need advie in this stuff and which programs i should start with . any help you can add please do . and to be in mind i have some skills in C# , and which one do PRoxy C# or C++ or both . thanks for readin , and waitrin for help .
BIG TIME BUG!!!! A FRIEND MADE IT AND MADE A NICE TUT!
03/01/2010 - SRO Private Server - 27 Replies
--
Made script for mp pot... Problems tho
05/09/2009 - Lineage 2 - 1 Replies
Trying to get an emergency mp regen for my bot party in DO Label(Start) DELAY(1000) CharStatus(MP,<=,20) { USEITEM(Elixir of Mental Strength (S-Grade)) USEITEM(Soulshot: A-grade)



All times are GMT +2. The time now is 14:53.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.