[Release] Hurdle Race Map

[jvt619]

Thanks To Soulerman!
Today will present way to implement this Hurdle Maze Map into any server you run!
In attachment you will find:
- Server side files
- Client side files
and here DB inputs:

Here we inserting this map into DB:

 
delete from cq_map where id = 8979;
INSERT INTO `cq_map` (`id`, `name`, `describe_text`, `mapdoc`, `type`, `sort`, `owner_id`, `mapgroup`, `idxserver`, `weather`, `bgmusic`, `bgmusic_show`, `portal0_x`, `portal0_y`, `reborn_map`, `reborn_portal`, `res_lev`, `owner_type`, `link_map`, `link_x`, `link_y`, `del_flag`, `province_id`) VALUES
(8979, 'RaceMap', 'RaceMap', 8979, 3274178572, 0, 0, 0000, -1, 0000, 0000, 0000, 0204, 0409, 3000, 0000, 000, 000, 0000, 0000, 0000, 000, 0);Here are all NPCs - 2 in this map (start and end line)
+ 1 main NPC to enter this map of course

 
delete from cq_npc where id = 99911;
delete from cq_npc where id = 99912;
INSERT INTO `cq_npc` VALUES 
('99911', '0', '0', 'TAKEMEBACK', '0001', '99880', '0', '0', '-1', '8979', '619', '591', '1990090', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_npc` VALUES 
('99912', '0', '0', 'TAKEMEBACK', '0001', '99880', '0', '0', '-1', '8979', '617', '428', '1990090', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
delete from cq_npc where id >= 88791 and id <= 88791;
INSERT INTO `cq_npc` VALUES 
('88791', '0', '0', 'EventTelep', '0002', '88890', '0', '0', '-1', '1000', '0330', '0415', '6915085', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '?', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');Here actions and task so we will be able to use NPC's properly etc:

 
delete from cq_task where id >= 6915085 and id <= 6915085;
delete from cq_task where id >= 6991140 and id <= 6991140;
INSERT INTO `cq_task` VALUES 
('6915085', '6915085', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'),
('6991140', '6991140', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
 
delete from cq_action where id >= 6915085 and id <= 6915104;
delete from cq_action where id >= 6991140 and id <= 6991141;
INSERT INTO `cq_action` (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES
(6915085, 6915100, 6915088, 0123, 0, '2009-06-11 22:00 2009-06-11 23:05'),
(6915088, 6915089, 0000, 0101, 0, 'SORRY!~PLEASE~COME~BACK~WHEN~EVENT~WILL~BE~OPEN!'),
(6915089, 5915105, 0000, 0101, 0, 'SEE~YA~LATER'),
(6915100, 6915101, 0000, 0101, 0, 'Hello!~''Today~"Hurdle~Race"~Event~is~open~for~everyone!'),
(6915101, 6915102, 0000, 0101, 0, 'If~You~want~to~participate~just~let~me~know~this!'),
(6915102, 6915103, 0000, 0101, 0, 'Remember~that~this~Event~could~have~additional~rules~set~by~Organizator!'),
(6915103, 6915104, 0000, 0102, 0, 'Take~me~to~the~"HURDLE~RACE"~Event~now. 6991140'),
(6915104, 4000034, 0000, 0102, 0, 'Nevermind. 0'),
(6991140, 0000, 6991141, 1107, 0, '8979 615 592'),
('6991141', '0000', '0000', '1003', '0', '8979 615 592');

THEN you just can decide when you want to have this map open by simply updating DB as you wishes:

UPDATE cq_action SET param = '2009-06-22 01:45 2009-06-22 02:00' where id = 6915085;where "2009-06-22 01:45" is from when open and
"2009-06-22 02:00" till when its closed (so 2009-06-22 02:01 will be already impossible to enter anymore!)

Now small help to use it easy without plannig or restarting server etc ...
For example - you update DB with time chosen by you:

 
UPDATE cq_action SET param = '2009-07-14 00:00 2009-07-15 00:00' where id = 6915085;and insdie game as a PM you just put:
/reloadaction 6915085 
and done, server refreshed to new time of opening

Additonally info where is START and where is FINISH line:
coords of start == 8979 596 589
coords of finish == 8979 600 428
So PM can use fast teleport:
/chgmap 8979 596 589
or
/chgmap 8979 600 428
---------------------
NOW Server and Client side part explanations:
1) CLIENT SIDE
In attachment I put all necessary files that will be required for this map!
There are INI and ANI files which you all must open - copy what is there and just put into your own files by pasting
- GameMap
- NPC
Additionally copy files from map and puzzle map into your clients to be sure there are these maps
2) SERVER SIDE
Here as well you all must copy Map and puzzle map files
and additionally whole content from GameMap.ini copy and paste to your own GameMap.ini file
--------
Thats pretty all in this.
I hope this will help everyone to have pleasure from this MAZE

Regards,
JVT-Gaming Community

[AloNzo]

thx very much JVT..nice release

[AloNzo]

thx thx thx bro

[Toad]

nice release bro, good job