About PP's Rain Event

[zulflbeatz]

can someone give some example how to kick player from map event after this time

171200000	171200001	171200003	123	4	00:01 23:00

, i had ask for help from other server onwer how to edit but they mad at me because they dont want to teach me how to fix this problem..problem is player can still inside the map until server restart again....so they can hunt for pp for hours using autobot..

this owner

Dragons Online
Raiser Online
EuJin Online
SangEudemons
Nightmare Online



cq_action

171200000	171200001	171200003	123	4	00:01 23:00
171200001	171200002	0		101	0	Rain~PP~Event~is~a~daily~event.~The~event~will~start~at~23:00~and~will~end~at~00:00~(1~hour)~server~time.
171200002	4000010		0		102	0	Ok~I~will~come~again~later. 0
171200003	171200004	0		101	0	Hi~%user_name,~Do~you~like~to~enter~Rain~PP~Event~Map~Now?
171200004	171200005	0		102	0	Yes,~Im~ready~now!. 171200006
171200005	4000010		0		102	0	No~Im~not~ready~yet!. 0
171200006	0		0		1003	0	1712 183 59 1
171100000	171100001	171100003	123	4	23:01 00:00
171100001	171100002	0		2003	0	%user_map_id == 1712
171100002	0		0		1003	0	1000 295 425
171100003	171100010	171100004	5001	0	== 1
171100004	171100011	171100005	5001	0	== 2
171100005	171100012	171100006	5001	0	== 3
171100006	171100013	171100007	5001	0	== 4
171100007	171100014	171100008	5001	0	== 5
171100008	171100015	171100009	5001	0	== 6
171100009	171100016	0		5001	0	== 7
171100010	171100017	0		1001	0	token_emoney += 15
171100011	171100018	0		1001	0	token_emoney += 20
171100012	171100019	0		1001	0	token_emoney += 5000
171100013	171100020	0		1001	0	token_emoney += 5000
171100014	171100021	0		1001	0	token_emoney += 35
171100015	171100022	0		1001	0	token_emoney += 40
171100016	171100023	0		1001	0	token_emoney += 7000
171100017	0		0		1010	2005	You found 15 PaladinPoints from Downpour!
171100018	0		0		1010	2005	You found 20 PaladinPoints from Downpour!
171100019	0		0		1010	2005	You found 5000 PaladinPoints from Downpour!
171100020	0		0		1010	2005	You found 5000 PaladinPoints from Downpour!
171100021	0		0		1010	2005	You found 35 PaladinPoints from Downpour!
171100022	0		0		1010	2005	You found 40 PaladinPoints from Downpour!
171100023	0		0		1010	2005	You found 7000 PaladinPoints from Downpour!

cq_npc

171200	0	0	Rain	123	1234067	0	0	-1	1000	167	405	171200000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0

cq_task

171200000	171200000	0			0	0	999	-100000	100000	999	0	0	-1	0
171200006	171200006	0			0	0	999	-100000	100000	999	0	0	-1	0

cq_monstertype

21059	Downpour	230	417	0	0	500	0	1000	100	0	0	0	0	0	0	0	1	15	0	1000	0	60	32771	0	0	3	171100000	0	99	99	99	99	99	99	99	0	80000	0	0	0	43	0	10000	100	100	100	21059	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

cq_map

1712	Rain~PP~Map	Rain~PP~Map	1712	524300	0	0	0	-1	0	0	0	0	0	1000	0	0	0	0	0	0	0	0

cq_dropitemrule

3053	21059	21059	1400000	1028610	1028610	1028610	1028610	1020002	1028610	1028610	1028610	1028610	1020002	0	0	0	1020002	1020002

cq_generator

17140024	1712	177	58	1	1	1	25	1	101	0	0	0	0	0
17140023	1712	179	63	1	1	1	25	1	101	0	0	0	0	0
17140022	1712	189	59	1	1	1	25	1	101	0	0	0	0	0
17140021	1712	188	65	1	1	1	25	1	101	0	0	0	0	0
17140020	1712	407	297	95	95	25	25	1	101	0	0	0	0	0
17140000	1712	148	60	25	25	25	25	20	21059	0	0	0	0	0
17140001	1712	181	87	25	25	25	25	20	21059	0	0	0	0	0
17140002	1712	225	90	25	25	25	25	20	21059	0	0	0	0	0
17140003	1712	195	95	25	25	25	25	20	21059	0	0	0	0	0
17140004	1712	207	70	25	25	25	25	20	21059	0	0	0	0	0
17140005	1712	128	50	25	25	25	25	20	21059	0	0	0	0	0
17140006	1712	200	150	45	45	45	25	45	21059	0	0	0	0	0
17140007	1712	268	160	45	45	45	25	35	21059	0	0	0	0	0
17140008	1712	161	180	15	15	25	25	15	21059	0	0	0	0	0
17140009	1712	145	240	55	55	25	25	55	21059	0	0	0	0	0
17140010	1712	253	141	15	15	25	25	10	21059	0	0	0	0	0
17140011	1712	176	234	55	55	25	25	55	21059	0	0	0	0	0
17140012	1712	108	219	15	15	25	25	15	21059	0	0	0	0	0
17140013	1712	467	369	65	65	25	25	65	21059	0	0	0	0	0
17140014	1712	408	487	85	85	25	25	95	21059	0	0	0	0	0
17140015	1712	342	429	95	95	25	25	95	21059	0	0	0	0	0
17140016	1712	351	359	95	95	25	25	95	21059	0	0	0	0	0
17140017	1712	294	369	95	95	25	25	95	21059	0	0	0	0	0
17140018	1712	334	238	95	95	25	25	100	21059	0	0	0	0	0
17140019	1712	68	188	85	85	25	25	55	21059	0	0	0	0	0

sorry for my bad english

[SoulNecturn]

Let me help you out there

So your problem with this even appears to be forcing players to leave the map after 1 hour event is done.

Check at this like you have there:
171100000 171100001 171100003 123 4 23:01 00:00
thats the first action that will happen when player will kill monster on this map to get the PPs (basing on cq_monster table info...).

So lets analyze it:
171100001 - happens when event is ongoing - this will first check if player is at proper map
and if will move back to Cronus - Little messed up part

now what if event time is not proper it appears will do this:
171100003
wich seems to be doing the rain even action ...

So try this way:

 Spoiler

171100000 171100001 171100002 123 4 23:01 00:00
171100001 171100003 0 2003 0 %user_map_id == 1712
171100002 0 0 1003 0 1000 295 425
171100003 171100010 171100004 5001 0 == 1

now between 23:00-00:00 monster killed on this event map will provide PPs basing on VIPS
IF time is not between 23:00-00:00 (its not yet started or over) - when player kill monster on this map - will automatically be moved back to cronus map.

Good luck

cheers

[zulflbeatz]

ok but at the last video.lol

[SoulNecturn]

You must precise what is wrong for you there still exactly

but I can guess you mean entry to this map...

THIS line for NPC:
171200000 171200001 171200003 123 4 00:01 23:00

this setup tells:
If its any hour besides the event time (23:00 - 00:00) you can enter the map :P
So just switch the codes like this:
171200000 171200003 171200001 123 4 00:01 23:00

this way you can enter map only when event is running...
at least this I understand from this and code right

I dont know who build this simple "event?" or maybe you jusr edit it this way ? :P Just always scan code step by step (what is on true and on fail) ....

Cheers

[zulflbeatz]

Originally Posted by SoulNecturn

You must precise what is wrong for you there still exactly

but I can guess you mean entry to this map...

THIS line for NPC:
171200000 171200001 171200003 123 4 00:01 23:00

this setup tells:
If its any hour besides the event time (23:00 - 00:00) you can enter the map :P
So just switch the codes like this:
171200000 171200003 171200001 123 4 00:01 23:00

this way you can enter map only when event is running...
at least this I understand from this and code right

I dont know who build this simple "event?" or maybe you jusr edit it this way ? :P Just always scan code step by step (what is on true and on fail) ....

Cheers

i hve try 171200001,171200002 and 171200003 but dont work and still same like on video..may i need to check all cq_action query again

[SoulNecturn]

you need to give more details... whats your aim here and what exactly is your issue. Till now I was just shooting on what I believed was your problem...

i hve try 171200001,171200002 and 171200003 but dont work..may i need to check all cq_action query again

what do you mean by that ? Exactly what is not working and what you want to achieve here?


From my view this whole event is more then trivial in execution :/



NPC part of cq_action (remember that at NPC is attached action: 171200000 as first and the same action has relevant place at cq_task in order to use it - if you change action at NPC you must update cq_task)

now the code:

171200000	171200001	171200003	123	4	00:01 23:00
171200001	171200002	0		101	0	Rain~PP~Event~is~a~daily~event.~The~event~will~start~at~23:00~and~will~end~at~00:00~(1~hour)~server~time.
171200002	4000010		0		102	0	Ok~I~will~come~again~later. 0
171200003	171200004	0		101	0	Hi~%user_name,~Do~you~like~to~enter~Rain~PP~Event~Map~Now?
171200004	171200005	0		102	0	Yes,~Im~ready~now!. 171200006
171200005	4000010		0		102	0	No~Im~not~ready~yet!. 0
171200006	0		0		1003	0	1712 183 59 1

In order to work proper I would do it this way:

Event start and finish: 23:00 till 23:59 server time:

delete from cq_action where id >= 171200000 and id <= 171200007;
INSERT INTO `cq_action` VALUES 
(171200000, 171200001, 171200003, 123, 4, '00:00 22:59'),
(171200001, 171200002, 0, 101, 0, 'Rain~PP~Event~is~a~daily~event.~The~event~will~start~at~23:00~and~will~end~at~00:00~(1~hour)~server~time.'),
(171200002, 4000010, 0, 102, 0, 'Ok~I~will~come~again~later. 0'),

(171200003, 171200004, 0, 101, 0, 'Hi~%user_name,~Do~you~like~to~enter~Rain~PP~Event~Map~Now?'),
(171200004, 171200005, 0, 102, 0, 'Yes,~Im~ready~now!. 171200006'),
(171200005, 4000010, 0, 102, 0, 'No~Im~not~ready~yet!. 0'),

(171200006, 171200007, 0, 1003, 0, '1712 183 59 1'),
(171200007, 0, 0, 126, 0, 'Event is over!');

/* ACTIONS FOR MONSTERS that will be slayed on event map */

delete from cq_action where id >= 171100000 and id <= 171100023;
INSERT INTO `cq_action` VALUES 
(171100000, 171100001, 171100002, 123, 4, '23:00 23:59'),  /* checkig if monster were slayed at proper event time */
(171100001, 171100003, 171100002, 2003, 4, '%user_map_id == 1712'), /* checking if player that killed this monster is at Event map */
(171100002, 0, 0, 1003, 0, '1000 295 425'), /* If time is not between event time OR if player is not on event map - will be teleported to Cronus */

(171100003, 171100010, 171100004, 5001, 0, '== 1'), /* checking VIP levels here */
(171100004, 171100011, 171100005, 5001, 0, '== 2'), /* checking VIP levels here */
(171100005, 171100012, 171100006, 5001, 0, '== 3'), /* checking VIP levels here */
(171100006, 171100013, 171100007, 5001, 0, '== 4'), /* checking VIP levels here */
(171100007, 171100014, 171100008, 5001, 0, '== 5'), /* checking VIP levels here */
(171100008, 171100015, 171100009, 5001, 0, '== 6'), /* checking VIP levels here */
(171100009, 171100016, 0, 5001, 0, '== 7'), /* checking VIP levels here */

(171100010, 171100017, 0, 1001, 0, 'token_emoney += 15'), /* Basing on VIP level provide proper amount of PPs */
(171100011, 171100018, 0, 1001, 0, 'token_emoney += 20'), /* Basing on VIP level provide proper amount of PPs */
(171100012, 171100019, 0, 1001, 0, 'token_emoney += 35'), /* Basing on VIP level provide proper amount of PPs */
(171100013, 171100020, 0, 1001, 0, 'token_emoney += 50'), /* Basing on VIP level provide proper amount of PPs */
(171100014, 171100021, 0, 1001, 0, 'token_emoney += 70'), /* Basing on VIP level provide proper amount of PPs */
(171100015, 171100022, 0, 1001, 0, 'token_emoney += 80'), /* Basing on VIP level provide proper amount of PPs */
(171100016, 171100023, 0, 1001, 0, 'token_emoney += 100'), /* Basing on VIP level provide proper amount of PPs */

(171100017, 0, 0, 1010, 2005, 'You found 15 PaladinPoints from Downpour!'), /* message for player to show up */
(171100018, 0, 0, 1010, 2005, 'You found 20 PaladinPoints from Downpour!'), 
(171100019, 0, 0, 1010, 2005, 'You found 35 PaladinPoints from Downpour!'), 
(171100020, 0, 0, 1010, 2005, 'You found 50 PaladinPoints from Downpour!'), 
(171100021, 0, 0, 1010, 2005, 'You found 70 PaladinPoints from Downpour!'), 
(171100022, 0, 0, 1010, 2005, 'You found 80 PaladinPoints from Downpour!'), 
(171100023, 0, 0, 1010, 2005, 'You found 100 PaladinPoints from Downpour!');

This way all should work Properly (as long monster at cq_monster will have attached proper action: 171100000 and at NPC will be proper action: 171200000


Now ... the code I wrote on fast from hand here so didnt check it (but on first glance of eye looks proper )... So just test this as here.

And if something will be wrong - Please clarify exactly what you have on mind - meaning what exactly is not working for you ... as honestly not sure all time what is the issue you suffering there (movie give much clues there...)

Good luck

[hasbul]

they dont want to teach or they dont know how to teach?