|
You last visited: Today at 19:42
Advertisement
[Helpful] New token exchange event
Discussion on [Helpful] New token exchange event within the EO PServer Hosting forum part of the Eudemons Online category.
09/14/2010, 08:40
|
#1
|
elite*gold: 0
Join Date: Aug 2010
Posts: 49
Received Thanks: 46
|
[Helpful] New token exchange event
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.
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
|
#2
|
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
|
Will be helpful to the people who don't know how to do these things.
|
|
|
09/14/2010, 08:47
|
#3
|
elite*gold: 5
Join Date: Feb 2010
Posts: 1,040
Received Thanks: 441
|
nice, added to the all things guide.
|
|
|
09/14/2010, 11:27
|
#4
|
elite*gold: 0
Join Date: May 2010
Posts: 222
Received Thanks: 668
|
nice one dude ^^
|
|
|
09/14/2010, 14:20
|
#5
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
|
SQL rewritten for performance and ending comment added:
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
|
#6
|
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 926
|
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
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
|
#7
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
|
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.
#Fixed
|
|
|
|
Similar Threads
|
[HELP]VIP TOKEN EXCHANGE
05/28/2010 - EO PServer Hosting - 5 Replies
Would someone please tell me how i remove this from the game as it is not required? Or at the very least, deactivate it.:confused:
Before anyone suggests using search, i tried that and there was nothing on REMOVING it.
Thank you.
:handsdown:
|
Helpful map
03/24/2009 - LotRO Guides & Templates - 0 Replies
Hi all,
I came across this site a while ago and thought it was very useful. Hope it can come in handy for some of you guys too.
MEHQ - LOTRO - Dynamic Map - North Downs
|
Token Exchange question
04/01/2007 - Eudemons Online - 2 Replies
Lately in EO... i went to check how many tokens i will get for giveing a 12-star mdefpdef...
cause im try to gether 80k tokens to get that thunder juice
well as class and level it passed but it failed in the star number..so here is my question
I have found out that minimum lvl to be given is 50 but does anyone know how many
stars and which pets can be given?
Thanks in advance for answering and sorry if that is post somewhere but i looked and
i found nothing
|
All times are GMT +2. The time now is 19:42.
|
|