Event Help

[karnyge]

Heres the files for an event i have.

It ran first time perfectly, the trouble is i cant figure out how to get it to run automatically. Any assistance that results in it functioning correctly will be thanked.

This is the start file details-
UPDATE cq_npc SET mapid = 1000 WHERE id = 123400;
UPDATE cq_npc SET cellx = 324 WHERE id = 123400;
UPDATE cq_npc SET celly = 406 WHERE id = 123400;
UPDATE cq_npc SET mapid = 1000 WHERE id = 123402;
UPDATE cq_npc SET cellx = 273 WHERE id = 123402;
UPDATE cq_npc SET celly = 482 WHERE id = 123402;

This is the off file details-
UPDATE cq_npc SET mapid = 100 WHERE id = 123400;
UPDATE cq_npc SET cellx = 60 WHERE id = 123400;
UPDATE cq_npc SET celly = 132 WHERE id = 123400;
UPDATE cq_npc SET mapid = 100 WHERE id = 123402;
UPDATE cq_npc SET cellx = 60 WHERE id = 123402;
UPDATE cq_npc SET celly = 132 WHERE id = 123402;

I require this to run every second weekend midnight server time friday, to midnight server time sunday/monday.
While trying to figure this out i noticed i have some db entries in cq_action for the hurdle race, which i would also like to run, if someone can help.

UPDATE
Used search- no guides.
Used All things thread- no guides
I have 3 events waiting to be added to my server- PM role, (if they want it) to anyone who adds them for me, or shows me how.

[danieldada]

it would be easier if you used a setup similar to the pk tournament, it spawns via cq_action command on the set time of day and week. and disapperes at the set time of day and week.


- just my 2 cents.. i could of written an example up but.. i am putting in my 2 cents.

[karnyge]

Well since this post was made i have found most of the cq_action details, relating to this event. But myself and the person who implemented the original running of this event, cannot figure why the autorun will not work. As i try to stay out of cq_action related coding for the server, I cannot tell what to do in order to remove the event and rebuild it. Or at the very least sort out the time so it does run.
For that reason i ask for help from the experienced coders.

I know some owners/coders out there will be thinking - noob cant do simple task like this, shouldnt be owner, blah blah blah. But everyone of you experienced coders/owners started out the same at some point.
Yes I am learning, and making mistakes, but at least I am trying to do what some of you do easily. Unlike some, I at least appreciate all advice and assistance I get, especially when it benefits the server I am trying to improve.

THX

[.Ash]

You learn from mistakes..

look again and cross check. Look how pk tournament is and cross check with your one. Sadly i dont have any DBs or anything, i deleted total size of 10GB~20GB EO stuff lol, So sorry cant help much.

[karnyge]

@Spongebox, would it be possible, if i gave you the right information, for you to teach me how to?
One of the events i want to add is yours, if you dont mind.

msn on my profile

PS love ya opinion of tq/netdragon

[Drenferalis]

just another thought, try a php cron job that updates the info with a php mysql script... just saying

[karnyge]

It seems no-one wants to help me add the events i have the files for, found here on epvp. So i shall try it this way-

I have the files, the folders, the query, everything i need to make the events, but.......

1- the map id is not in my db, will it matter if i use the id but use a different map?
2- will the query create the npc for the event?
3- will the query create the monsters in the event even if the ids do not currently exist, or will they need to be manuallly created after running the query?
4- will i have to make a patch? if so how?

Just a few examples of the questions i have regarding adding an event.

NOW WILL SOMEONE HELP ME?

@ drenferalis

Originally Posted by Drenferalis

just another thought, try a php cron job that updates the info with a php mysql script... just saying

I have no idea what you mean

UPDATE
Well i have tried adding this event and guess what? Complete and utter crash of all the servers.

/*
Created By Nukleus

Malaysia Boleh!

*/

/* adding 3 event map to cq_map
map style : no Pk - no random - no revive
*/

delete from cq_map where id >=9900 and id <= 9902;

INSERT INTO `cq_map` VALUES ('9900', 'Level255Map', 'Level255Map', '9900', '3274178572', '0', '0', '0000', '-1', '0000', '0000', '0000', '295', '426', '1000', '0000', '000', '000', '0000', '0000', '0000', '000', '0');
INSERT INTO `cq_map` VALUES ('9901', 'Vip7Map', 'Vip7Map', '9901', '3274178572', '0', '0', '0000', '-1', '0000', '0000', '0000', '295', '426', '1000', '0000', '000', '000', '0000', '0000', '0000', '000', '0');
INSERT INTO `cq_map` VALUES ('9902', 'Level1254Map', 'Level1254Map', '9902', '3274178572', '0', '0', '0000', '-1', '0000', '0000', '0000', '295', '426', '1000', '0000', '000', '000', '0000', '0000', '0000', '000', '0');

/* adding event npc to cq_npc*/

delete from cq_npc where id >= 123405 and id <= 123408;

INSERT INTO `cq_npc` VALUES ('123405', '0', '0', 'PakUde', '0123', '1234050', '0', '0', '-1', '1000', '0324', '0406', '570000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_npc` VALUES ('123406', '0', '0', 'Halimah', '0123', '1234060', '0', '0', '-1', '9900', '0056', '0109', '890000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_npc` VALUES ('123407', '0', '0', 'Halimah', '0123', '1234070', '0', '0', '-1', '9901', '0056', '0109', '890000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_npc` VALUES ('123408', '0', '0', 'Halimah', '0123', '1234080', '0', '0', '-1', '9902', '0056', '0109', '890000000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');


/* adding action to cq_action for npc inside event map*/

delete from cq_action where id >= 890000000 and id <= 890000003;


INSERT INTO `cq_action` VALUES ('890000000', '890000001', '0000', '0101', '0', 'Would~you~like~to~go~out~from~Event~Map?');
INSERT INTO `cq_action` VALUES ('890000001', '890000002', '0000', '0102', '0', 'Yes,~please. 890000003');
INSERT INTO `cq_action` VALUES ('890000002', '4000010', '0000', '0102', '0', 'Nevermind. 0');
INSERT INTO `cq_action` VALUES ('890000003', '0000', '0000', '1003', '0', '1000 296 428 1');

/* adding action to cq_action for event teleporter npc
default time setting is 1 hour = 20:00 to 21:00
*/

delete from cq_action where id >= 570000000 and id <= 570000019;

INSERT INTO `cq_action` VALUES ('570000000', '570000001', '570000003', '0123', '4', '20:00 21:00');
INSERT INTO `cq_action` VALUES ('570000001', '570000002', '0000', '0101', '0', 'Event~will~start~at~20:00~and~will~end~at~21:00') ;
INSERT INTO `cq_action` VALUES ('570000002', '4000010', '0000', '0102', '0', 'Ok~I~come~again~later. 0');
INSERT INTO `cq_action` VALUES ('570000003', '570000004', '0000', '0101', '0', 'Hi~%user_name,~Please~choose~your~event~map~to~en ter');
INSERT INTO `cq_action` VALUES ('570000004', '570000005', '0000', '0102', '0', 'Level~1~to~level~254~Map 570000008');
INSERT INTO `cq_action` VALUES ('570000005', '570000006', '0000', '0102', '0', 'Level~255~Map 570000012');
INSERT INTO `cq_action` VALUES ('570000006', '570000007', '0000', '0102', '0', 'Vip~7~Map 570000016');
INSERT INTO `cq_action` VALUES ('570000007', '4000010', '0000', '0102', '0', 'Im~Lazy.~Next~time~maybe. 0');
INSERT INTO `cq_action` VALUES ('570000008', '570000009', '570000010', '1001', '0', 'level < 255');
INSERT INTO `cq_action` VALUES ('570000009', '0', '0', '1003', '0', '9902 67 117');
INSERT INTO `cq_action` VALUES ('570000010', '570000011', '0000', '0101', '0', 'U~already~at~max~level.~Please~choose~other~map') ;
INSERT INTO `cq_action` VALUES ('570000011', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');
INSERT INTO `cq_action` VALUES ('570000012', '570000013', '570000014', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('570000013', '0', '0', '1003', '0', '9900 67 117');
INSERT INTO `cq_action` VALUES ('570000014', '570000015', '0000', '0101', '0', 'U~still~not~reach~level~255.~Please~choose~other~ map');
INSERT INTO `cq_action` VALUES ('570000015', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');
INSERT INTO `cq_action` VALUES ('570000016', '570000017', '570000018', '5001', '0', '== 7');
INSERT INTO `cq_action` VALUES ('570000017', '0', '0', '1003', '0', '9901 67 117');
INSERT INTO `cq_action` VALUES ('570000018', '570000019', '0000', '0101', '0', 'Your~Vip~is~lower~then~Level~7.~You~cannot~go~to~ this~VIP~map!');
INSERT INTO `cq_action` VALUES ('570000019', '4000010', '0000', '0102', '0', 'Ok~Im~Sorry 0');


/* adding generator for main event mob*/

delete from cq_generator where id >= 57000000 and id <= 57000002;

INSERT INTO `cq_generator` VALUES ('57000000', '9900', '0085', '0086', '001', '001', '0025', '0025', '0001', '7026', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('57000001', '9901', '0085', '0086', '001', '001', '0025', '0025', '0001', '7026', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('57000002', '9902', '0085', '0086', '001', '001', '0025', '0025', '0001', '7026', '0000', '0000', '0000', '0000', '0000');

/* adding action to cq_action for minor event mob
*** If your server not powerfull enuff, u might get slightly laggy due to time checking for auto boot player out from the map at 21:01
u can remove this time checker and make it manual - remove from action 58000000 to 58000004 and put action id to 58000005 at minor event mob
for manual boot player -
enter your server at 21:00 using your pm char
type /reloadaction 58000000 then type /processaction 58000000 and all user in event map will boot out to cronos
*/

delete from cq_action where id >= 58000000 and id <= 58000025;

INSERT INTO `cq_action` VALUES ('58000000', '58000001', '58000005', '0123', '4', '21:01 22:00');
INSERT INTO `cq_action` VALUES ('58000001', '58000004', '58000002', '2003', '0', '%user_map_id == 9900');
INSERT INTO `cq_action` VALUES ('58000002', '58000004', '58000003', '2003', '0', '%user_map_id == 9901');
INSERT INTO `cq_action` VALUES ('58000003', '58000004', '0000', '2003', '0', '%user_map_id == 9902');
INSERT INTO `cq_action` VALUES ('58000004', '0', '0000', '1003', '0', '1000 295 425 ');
INSERT INTO `cq_action` VALUES ('58000005', '58000012', '58000006', '5001', '0', '== 1');
INSERT INTO `cq_action` VALUES ('58000006', '58000013', '58000007', '5001', '0', '== 2');
INSERT INTO `cq_action` VALUES ('58000007', '58000014', '58000008', '5001', '0', '== 3');
INSERT INTO `cq_action` VALUES ('58000008', '58000015', '58000009', '5001', '0', '== 4');
INSERT INTO `cq_action` VALUES ('58000009', '58000016', '58000010', '5001', '0', '== 5');
INSERT INTO `cq_action` VALUES ('58000010', '58000017', '58000011', '5001', '0', '== 6');
INSERT INTO `cq_action` VALUES ('58000011', '58000018', '0000', '5001', '0', '== 7');
INSERT INTO `cq_action` VALUES ('58000012', '58000019', '0000', '1001', '0', 'e_money += 15');
INSERT INTO `cq_action` VALUES ('58000013', '58000020', '0000', '1001', '0', 'e_money += 20');
INSERT INTO `cq_action` VALUES ('58000014', '58000021', '0000', '1001', '0', 'e_money += 25');
INSERT INTO `cq_action` VALUES ('58000015', '58000022', '0000', '1001', '0', 'e_money += 30');
INSERT INTO `cq_action` VALUES ('58000016', '58000023', '0000', '1001', '0', 'e_money += 35');
INSERT INTO `cq_action` VALUES ('58000017', '58000024', '0000', '1001', '0', 'e_money += 40');
INSERT INTO `cq_action` VALUES ('58000018', '58000025', '0000', '1001', '0', 'e_money += 50');
INSERT INTO `cq_action` VALUES ('58000019', '0000', '0000', '1010', '2005', 'You found 15 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000020', '0000', '0000', '1010', '2005', 'You found 20 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000021', '0000', '0000', '1010', '2005', 'You found 25 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000022', '0000', '0000', '1010', '2005', 'You found 30 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000023', '0000', '0000', '1010', '2005', 'You found 35 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000024', '0000', '0000', '1010', '2005', 'You found 40 EudemonPoints from EventMonster!');
INSERT INTO `cq_action` VALUES ('58000025', '0000', '0000', '1010', '2005', 'You found 50 EudemonPoints from EventMonster!');


/* adding action for main event mob
each kill will give
- 200k eps
- 50 stackable uniXO
-50 stackable specialball
-2 pcs of unixo and specialball
* item id used : 1020250 , 1020260
** change the item id to your own item id.

*/

delete from cq_action where id >= 58500000 and id <= 58500007;

INSERT INTO `cq_action` VALUES ('58500000', '58500001', '0000', '1001', '0', 'e_money += 200000');
INSERT INTO `cq_action` VALUES ('58500001', '58500002', '0000', '0501', '1020260', '50 9999');
INSERT INTO `cq_action` VALUES ('58500002', '58500003', '0000', '0501', '1020250', '50 9999');
INSERT INTO `cq_action` VALUES ('58500003', '58500004', '0000', '0801', '0', 'dropitem 1020250');
INSERT INTO `cq_action` VALUES ('58500004', '58500005', '0000', '0801', '0', 'dropitem 1020260');
INSERT INTO `cq_action` VALUES ('58500005', '58500006', '0000', '0801', '0', 'dropitem 1020250');
INSERT INTO `cq_action` VALUES ('58500006', '58500007', '0000', '0801', '0', 'dropitem 1020260');
INSERT INTO `cq_action` VALUES ('58500007', '0000', '0000', '1010', '2005', 'You found 200,000 EudemonPoints from Hollow!');


/* adding event monster to cq_monstertype.Use any lookface u like */

delete from cq_monstertype where id >= 7026 and id <= 7027;

INSERT INTO `cq_monstertype` VALUES ('7027', 'Event-Ghost', '0069', '0420', '0', '0', '40000', '00', '010000', '08000', '0000', '0000', '0083', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0060', '32771', '0000', '0000', '0003', '58000000', '0000', '00', '00', '00', '00', '00', '00', '00', '0000', '00000', '0000', '0000', '0000', '0050', '0000', '10000', '0100', '0000', '0000', '400', '000', '0000000000', '0000000000', '0000000000', '0000000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `cq_monstertype` VALUES ('7026', 'Hollow', '0069', '0957', '0', '0', '2500000000', '00', '010000', '08000', '10000', '0000', '0083', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0060', '32771', '0000', '0000', '0003', '58500000', '0000', '099', '099', '099', '099', '099', '099', '099', '0000', '20000', '0000', '0000', '0000', '0043', '0000', '10000', '0100', '0030', '0060', '0', '000', '0000000000', '0000000000', '0000000000', '0000000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

/* adding droprule for minor event mob, change the chance and item id to your own */

delete from cq_dropitemrule where id >= 400;

INSERT INTO `cq_dropitemrule` VALUES ('400', '7027', '0001', '20000000', '1020260', '0000', '1020250', '0000', '0000', '1020260', '0000', '1020250', '0000', '1020260', '0000', '0000', '1020250','0000', '0000');


/* adding geneator for minor mob for Level255 Map.This is just a sample generator. */

delete from cq_generator where id >= 69000000 and id <= 69000015;

INSERT INTO `cq_generator` VALUES ('69000000', '9900', '0123', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000001', '9900', '0089', '0134', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000002', '9900', '0105', '0126', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000003', '9900', '0119', '0108', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000004', '9900', '0127', '0087', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000005', '9900', '0113', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000006', '9900', '0088', '0039', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000007', '9900', '0064', '0038', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000008', '9900', '0042', '0043', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000009', '9900', '0028', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000010', '9900', '0023', '0076', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000011', '9900', '0045', '0098', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000012', '9900', '0063', '0113', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000013', '9900', '0087', '0096', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000014', '9900', '0095', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69000015', '9900', '0073', '0071', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');


/* adding geneator for minor mob for Vip7 Map.This is just a sample generator. */

delete from cq_generator where id >= 69100000 and id <= 69100015;

INSERT INTO `cq_generator` VALUES ('69100000', '9901', '0123', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100001', '9901', '0089', '0134', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100002', '9901', '0105', '0126', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100003', '9901', '0119', '0108', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100004', '9901', '0127', '0087', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100005', '9901', '0113', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100006', '9901', '0088', '0039', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100007', '9901', '0064', '0038', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100008', '9901', '0042', '0043', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100009', '9901', '0028', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100010', '9901', '0023', '0076', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100011', '9901', '0045', '0098', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100012', '9901', '0063', '0113', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100013', '9901', '0087', '0096', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100014', '9901', '0095', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69100015', '9901', '0073', '0071', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');


/* adding geneator for minor mob for Level 1-254 Map.This is just a sample generator. */

delete from cq_generator where id >= 69200000 and id <= 69200015;

INSERT INTO `cq_generator` VALUES ('69200000', '9902', '0123', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200001', '9902', '0089', '0134', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200002', '9902', '0105', '0126', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200003', '9902', '0119', '0108', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200004', '9902', '0127', '0087', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200005', '9902', '0113', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200006', '9902', '0088', '0039', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200007', '9902', '0064', '0038', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200008', '9902', '0042', '0043', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200009', '9902', '0028', '0060', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200010', '9902', '0023', '0076', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200011', '9902', '0045', '0098', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200012', '9902', '0063', '0113', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200013', '9902', '0087', '0096', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200014', '9902', '0095', '0073', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('69200015', '9902', '0073', '0071', '005', '005', '005', '0025', '0002', '7027', '0000', '0000', '0000', '0000', '0000');


/* adding task to cq_task for teleporter npc */

delete from cq_task where id >= 890000000 and id <= 890000000;

INSERT INTO `cq_task` VALUES ('890000000', '890000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('890000003', '890000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

/* adding task to cq_task for main teleporter npc */

delete from cq_task where id >= 570000000 and id <= 570000016;

INSERT INTO `cq_task` VALUES ('570000000', '570000000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000001', '570000001', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000003', '570000003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000008', '570000008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000009', '570000009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000011', '570000011', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000012', '570000012', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000013', '570000013', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000014', '570000014', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('570000016', '570000016', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

[karnyge]

Before anyone moans about double posting- the last post was so **** long its easier for people to read this.

Ok i ran the above queries to put the event into my test server. I copied the associated files into the test server. Restarted the server and msg and npc crash immediately.

All i want i some help adding this event and 2 more i found here on epvp. Will someone please help me before i go insane asking, trying to do it on my own, and tearing my hair out because i do not know where i am going wrong?

[Nukleuz]

U can add me on msn if u need my help to install the event on your server ... btw what db u use and what msg/npc server u use ?
U need to copy the map file and add the map config into your gameserver map config or the msg server and npc server will be crash.If u dont want to use npc to exit.. u also can use portal.. easier to config

[karnyge]

DUUUUUUUUUUUUDE!
MSN YOU ALMOST IMMEDIATELY


NOW I REALISE WHERE I MAY HAVE GONE WRONG.
THX FOR READING. THX FOR RESPONDING. HOPEFULLY YOU WILL GET MY MSN INVITE AND WE CAN TALK THIS OUT.

UPDATE
DB- Revolution
Msg and Npc that came with it. Msg is 2.7
Now only the MSGserver doesnt open.

If you are referring to a town portal, that would make sense as the easier option. Either way you can help me get this running i would really appreciate it.
Will this require a patch for the server players to access it?
(Pretty sure i can use your skills in the future)

UPDATE
YEHAW- it works.
Reason for failure, ran as smaller queries. Tried as one huge query and it works.
Needs monsters tho.
And then i gotta create a patch- which i dunno how lol