[Helpful] New token exchange event

09/14/2010 08:40 Death[PM]#1

Here i am going to give the event that I have maid with the REVO data base files. I have explained everything in the script as well what you need to edit in the files. As for the action ids and for the item ids that you have to give the npc and the one that it gives for the prize. An if you are using the clients that was released for this data base then all you need to do is go to the ani file and add the id in the ItemMinIcon,then take the special token id in the itemtype in data base and pick a dds file in the ItemMinIcon an use that to put for the dds file in the ItemMinIcon.ani and the MapItemIcon.ani. Sorry I am trying to explain the best i can. But here is the sql for it below.

Spoiler

Code:

delete from cq_action where id >= 1900000018 and id <= 1900000028;
delete from cq_task where id >= 1900000018 and id <= 1900000024;
delete from cq_npc where id >= 123451 and id <= 123451;

INSERT INTO `cq_action` VALUES ('1900000018', '1900000019', '0000', '0101', '0', 'Token~Exchange~for~1~Donator~Card');
INSERT INTO `cq_action` VALUES ('1900000019', '1900000020', '0000', '0101', '0', 'Please~provide~me~25~Tokens~for~it.');
INSERT INTO `cq_action` VALUES ('1900000020', '1900000021', '0000', '0101', '0', 'Once~you~got~10~Donator~Cards~go~see~Lindar~for~your~reward!');
INSERT INTO `cq_action` VALUES ('1900000021', '1900000025', '0000', '0102', '0', '[Get~1~Donator~Card] 1900000022');
INSERT INTO `cq_action` VALUES ('1900000022', '1900000023', '1900000028', '0507', '0', '726058 726058 25');
INSERT INTO `cq_action` VALUES ('1900000023', '1900000024', '0000', '0506', '0', '726058 726058 25');
INSERT INTO `cq_action` VALUES ('1900000024', '1900000026', '0000', '0501', '729034', '');
INSERT INTO `cq_action` VALUES ('1900000025', '4000026', '0000', '0102', '0', '[No~Thanks] 0');
INSERT INTO `cq_action` VALUES ('1900000026', '1900000027', '0000', '0101', '0', 'Enjoy!');
INSERT INTO `cq_action` VALUES ('1900000027', '4000026', '0000', '0102', '0', 'Alright~thanks 0');
INSERT INTO `cq_action` VALUES ('1900000028', '3015046', '0000', '0101', '0', 'You~dont~have~enough~Items~to~Exchange!');

INSERT INTO `cq_task` VALUES ('1900000018', '1900000018', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('1900000021', '1900000021', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('1900000022', '1900000022', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('1900000024', '1900000024', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

INSERT INTO `cq_npc` VALUES ('123451', '0', '0', 'Token', '002', '229980', '0', '0', '-1', '1000', '0291', '0495', '1900000018', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?T', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

/* The item number for the prize is the God Prize Bag. Id Number is 729034
The item number that you hav to get is 726058. This is the speacial token id in the REVO data base.
If you are using this data base this will give you the prize that will give you between 3-5 27k eps, and one god bless.
You can change it to what every you may want. But I think that it is better to give more prizes for collecting things.
Also you will need to go into the cq_itemtype and get the cq_action id for the item number 729034.
these are the action ids that you will need to change the items if you are wanting to use this item for the prize.
6940023
6940024
6940025
6940026
6940027
These action ideas are what gives the items once you right click on the prize that you recive for giving the amount of 
special tokens. The ideas will be in the data table in the cq_action.
You will aslo need to change the npc id if this one is taken. Also the cq_action ids if used in your data base. I hope you enjoy
the token event script that i have gave you. An this has been released before i just thaught i help out a little more with one that 
has all the ids in most data bases.

If you have any questions or need help with this please leave me a private message or as long as you do not spam this post you can leave it here and leave me your email address and i will email you what to do.

Thanks,
Death Gods Gamming

P.S. The Item Id For the 27k eps is 743086. Or you can use my release of the custom ep cards and add your own ep cards where you need to edit the item that it gives. When you click on the prize. If you want to see a example with it working just log onto Death Gods. I will post some screen shots after I get home from work.

09/14/2010 08:43 Eurion#2

Will be helpful to the people who don't know how to do these things. :)

09/14/2010 08:47 ~WARNING~#3

nice, added to the all things guide.

09/14/2010 11:27 ~Sword~Stalker~[PM]#4

nice one dude ^^

09/14/2010 14:20 King_Arthur#5

SQL rewritten for performance and ending comment added:

Spoiler

Code:

delete from cq_action where id >= 1900000018 and id <= 1900000028;
delete from cq_task where id >= 1900000018 and id <= 1900000024;
delete from cq_npc where id = 123451;

INSERT INTO `cq_action` VALUES 
(1900000018, 1900000019, 0000, 0101, 0, 'Token~Exchange~for~1~Donator~Card'),
(1900000019, 1900000020, 0000, 0101, 0, 'Please~provide~me~25~Tokens~for~it.'),
(1900000020, 1900000021, 0000, 0101, 0, 'Once~you~got~10~Donator~Cards~go~see~Lindar~for~your~reward!'),
(1900000021, 1900000025, 0000, 0102, 0, '[Get~1~Donator~Card] 1900000022'),
(1900000022, 1900000023, 1900000028, 0507, 0, '726058 726058 25'),
(1900000023, 1900000024, 0000, 0506, 0, '726058 726058 25'),
(1900000024, 1900000026, 0000, 0501, 729034, ''),
(1900000025, 4000026, 0000, 0102, 0, '[No~Thanks] 0'),
(1900000026, 1900000027, 0000, 0101, 0, 'Enjoy!'),
(1900000027, 4000026, 0000, 0102, 0, 'Alright~thanks 0'),
(1900000028, 3015046, 0000, 0101, 0, 'You~dont~have~enough~Items~to~Exchange!');

INSERT INTO `cq_task` VALUES 
(1900000018, 1900000018, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000021, 1900000021, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000022, 1900000022, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000024, 1900000024, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0);

INSERT INTO `cq_npc` VALUES (123451, 0, 0, 'Token', 002, 229980, 0, 0, -1, 1000, 0291, 0495, 1900000018, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 0, '?T', 0000, 00, 00, 0000, 01, 0000, 0000, 0000, 0000, 0000);

/* The item number for the prize is the God Prize Bag. Id Number is 729034
The item number that you hav to get is 726058. This is the speacial token id in the REVO data base.
If you are using this data base this will give you the prize that will give you between 3-5 27k eps, and one god bless.
You can change it to what every you may want. But I think that it is better to give more prizes for collecting things.
Also you will need to go into the cq_itemtype and get the cq_action id for the item number 729034.
these are the action ids that you will need to change the items if you are wanting to use this item for the prize.
6940023
6940024
6940025
6940026
6940027
These action ideas are what gives the items once you right click on the prize that you recive for giving the amount of 
special tokens. The ideas will be in the data table in the cq_action.
You will aslo need to change the npc id if this one is taken. Also the cq_action ids if used in your data base. I hope you enjoy
the token event script that i have gave you. An this has been released before i just thaught i help out a little more with one that 
has all the ids in most data bases.
*/

09/14/2010 18:07 Eurion#6

Quote:

Originally Posted by King_Arthur

SQL rewritten for performance and ending comment added:

You forgot the commas on the cq_action queries. It should look something like thig

Spoiler

Code:

delete from cq_action where id >= 1900000018 and id <= 1900000028;
delete from cq_task where id >= 1900000018 and id <= 1900000024;
delete from cq_npc where id = 123451;

INSERT INTO `cq_action` VALUES 
(1900000018, 1900000019, 0000, 0101, 0, 'Token~Exchange~for~1~Donator~Card'),
(1900000019, 1900000020, 0000, 0101, 0, 'Please~provide~me~25~Tokens~for~it.'),
(1900000020, 1900000021, 0000, 0101, 0, 'Once~you~got~10~Donator~Cards~go~see~Lindar~for~your~reward!'),
(1900000021, 1900000025, 0000, 0102, 0, '[Get~1~Donator~Card] 1900000022'),
(1900000022, 1900000023, 1900000028, 0507, 0, '726058 726058 25'),
(1900000023, 1900000024, 0000, 0506, 0, '726058 726058 25'),
(1900000024, 1900000026, 0000, 0501, 729034, ''),
(1900000025, 4000026, 0000, 0102, 0, '[No~Thanks] 0'),
(1900000026, 1900000027, 0000, 0101, 0, 'Enjoy!');
(1900000027, 4000026, 0000, 0102, 0, 'Alright~thanks 0'),
(1900000028, 3015046, 0000, 0101, 0, 'You~dont~have~enough~Items~to~Exchange!');

INSERT INTO `cq_task` VALUES 
(1900000018, 1900000018, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000021, 1900000021, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000022, 1900000022, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(1900000024, 1900000024, 0000, , , 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0);

INSERT INTO `cq_npc` VALUES (123451, 0, 0, 'Token', 002, 229980, 0, 0, -1, 1000, 0291, 0495, 1900000018, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0, 0, 0, 0, '?T', 0000, 00, 00, 0000, 01, 0000, 0000, 0000, 0000, 0000);

/* The item number for the prize is the God Prize Bag. Id Number is 729034
The item number that you hav to get is 726058. This is the speacial token id in the REVO data base.
If you are using this data base this will give you the prize that will give you between 3-5 27k eps, and one god bless.
You can change it to what every you may want. But I think that it is better to give more prizes for collecting things.
Also you will need to go into the cq_itemtype and get the cq_action id for the item number 729034.
these are the action ids that you will need to change the items if you are wanting to use this item for the prize.
6940023
6940024
6940025
6940026
6940027
These action ideas are what gives the items once you right click on the prize that you recive for giving the amount of 
special tokens. The ideas will be in the data table in the cq_action.
You will aslo need to change the npc id if this one is taken. Also the cq_action ids if used in your data base. I hope you enjoy
the token event script that i have gave you. An this has been released before i just thaught i help out a little more with one that 
has all the ids in most data bases.
*/

09/14/2010 18:56 King_Arthur#7

Quote:

Originally Posted by Eurion

You forgot the commas on the cq_action queries. It should look something like thig

Thanks for that. I must have been pressing "Find Next" instead of "Replace" when I went through that section. :o
#Fixed