[Release] 5th SummonStone.

06/13/2009 11:15 mama020153#1
Hey, I was just playing around and i got bored so i created a Sql for 5th SummonStone for any Server that wants it here is the Info.
4th SummonStone. By: haciveli
Code:
delete from cq_action where id >= 8920523 and id <= 8920532;
delete from cq_itemtype where id= 724025;
delete from cq_goods where id= 724025;

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920523, 8920524, 8920527, 1001, 0, 'maxeudemon < 4');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920524, 8920525, 0, 502, 724025, '');	

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920525, 8920526, 0, 1001, 0, 'maxeudemon = 4');


INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920526, 8920528, 0, 1027, 0, 'self skill156');


INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920527, 0, 0, 126, 0, 'Sorry Dude, You already have 4 Summon. Maybe Next time :)');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920528, 8920531, 8920531, 1080, 1021, 'new');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920531, 8920532, 8920532, 1081, 1021, 'phase = 17');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (8920532, 0, 0, 1010, 2011, 'you~take~gather~the~semen,~a~share~of~strange~charm~from~in~vivo~turbulent,~seal~of~glass~the~god~disrupts~equally~likely,~you~felt~your~strength~summon~three~Eudemons~sufficiently.');

INSERT INTO cq_itemtype
   (`id`, `name`, `req_profession`, `level`, `req_level`, `req_sex`, `req_force`, `req_dex`, `req_health`, `req_soul`, `monopoly`, `weight`, `price`, `id_action`, `attack_max`, `attack_min`, `defense`, `magic_atk_min`, `dodge`, `life`, `mana`, `amount`, `amount_limit`, `ident`, `gem1`, `gem2`, `magic1`, `magic2`, `magic3`, `magic_atk_max`, `magic_def`, `atk_range`, `atk_speed`, `hitrate`, `monster_type`, `target`, `able_mask`, `exp_type`, `emoney`)
VALUES
   (724025, 'FourSummonStone', 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 8920523, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500000);

INSERT INTO cq_goods
   (`id`, `ownerid`, `itemtype`)
VALUES
   (724025, 1207, 724025);
5th SummonStone. By: mama020153
Code:
delete from cq_action
where 
id >= 8921523
and
id <= 8921528;

delete from cq_action
where 
id >= 8921531
and
id <= 8921532;

delete from cq_itemtype
where 
id >= 721550
and
id <= 721550;

INSERT INTO `cq_action` VALUES ('8921523', '8921524', '8921527', '1001', '0', 'maxeudemon < 5');
INSERT INTO `cq_action` VALUES ('8921524', '8921525', '0000', '0502', '721550', '');
INSERT INTO `cq_action` VALUES ('8921525', '8921526', '0000', '1001', '0', 'maxeudemon = 5');
INSERT INTO `cq_action` VALUES ('8921526', '8921528', '0000', '1027', '0', 'self skill156');
INSERT INTO `cq_action` VALUES ('8921527', '0000', '0000', '0126', '0', 'Sorry, You already have 5 Summon.');
INSERT INTO `cq_action` VALUES ('8921528', '8921531', '8921531', '1080', '1021', 'new');
INSERT INTO `cq_action` VALUES ('8921531', '8921532', '8921532', '1081', '1021', 'phase = 17');
INSERT INTO `cq_action` VALUES ('8921532', '0000', '0000', '1010', '2011', 'Congraz!~You~Have~5th~Summon~Now.');

INSERT INTO `cq_itemtype` VALUES (721550,'5th SummonStone',0,0,0,0,0,0,0,0,28,0,1,8921523,0,0,0,0,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000000,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
The code for the Stone is /awarditem 721550
Once you have Ran the Sql run the Patch in your Client. Hope you like.

Dont forget to hit thinks!
06/13/2009 12:10 magewarior2#2
Its nice job, only cant you add that you need 4th summon before you can get 5th summon ??

Greets.
06/13/2009 12:29 rexes13#3
nice work dude...
06/13/2009 15:24 ArabianPrince#4
Great Man.....
06/13/2009 18:47 mama020153#5
No you dont have to have 4th Summon before 5th Summon. You need 4th Summon in your Db Tho... and Thank you all.

I added a Client Side so if you dont know how to Hex Edit...
06/13/2009 20:54 magewarior2#6
Quote:
Originally Posted by mama020153 View Post
No you dont have to have 4th Summon before 5th Summon. You need 4th Summon in your Db Tho... and Thank you all.

I added a Client Side so if you dont know how to Hex Edit...
I mean, before you can use 5 summon you need to have 4th summon


and before you can use 4th summon you need to have 3th summon

Red, how i do NOT mean , Green is how i mean it
Code:
[COLOR="Red"]Guy whit 2 summon buys 5th summon stone, use it, have 5 summon[/COLOR]
Code:
[COLOR="Lime"]guy whit 2 summon  buys 5th summon stone, its not working..
he buys 4th summon stone, not working
he buys 3th summon stone, its working 
he try's 5th summon stone again, not working, he uses 4th summon, it is working.
now the Final 5th summon stone is working to [/COLOR]
So, i mean, you need to have 4th summon before you can get 5 summon ...

that is what i want, my question is = Can he make that ? if yes, that would be very nice!!
06/13/2009 22:05 mama020153#7
Shur i can do 4 Summon to but you can have 3 Summon or even 2 Summon and use the 5 SummonStone. You dont have to be at 4th summon for it to work ....

Is that what you mean?


Iv added the 4th SummonStone Sql too.
06/13/2009 22:14 magewarior2#8
Quote:
Originally Posted by mama020153 View Post
Shur i can do 4 Summon to but you can have 3 Summon or even 2 Summon and use the 5 SummonStone. You dont have to be at 4th summon for it to work ....

Is that what you mean?
Yes that is what i need, 3th and 4th summon BEFORE i can use 5th summon

can you make this script for me?

and if it is possible of the 4th summon to.

In the 4th summon need to be that i first need 3th summon before i can use it!

Can you make this??


Thank you.
06/14/2009 00:41 mama020153#9
I Posted the 4th and 5th Up top...
06/14/2009 11:05 Spy520#10
Quote:
Originally Posted by mama020153 View Post
I Posted the 4th and 5th Up top...
I know mama his english can't be understanded easy i will tell you what he means
Code:
I want the 5th Summon stone to check if the ppl has the 4th summon before its activated so the PPl has to pay for the 3rd summon then 4th then 5th
Regards
Spy520
06/14/2009 11:58 magewarior2#11
Quote:
Originally Posted by Spy520 View Post
I know mama his english can't be understanded easy i will tell you what he means
Code:
I want the 5th Summon stone to check if the ppl has the 4th summon before its activated so the PPl has to pay for the 3rd summon then 4th then 5th
Regards
Spy520
Thankyou.

This is what i mean :)

in my country, the words in different order ... that is why it's so difficult for me
06/14/2009 19:38 mama020153#12
Well i dont know hwo but i can shur give it a shot for you and ty Spy520. :)
06/14/2009 20:13 rexes13#13
maybe it needs a new cq_action...TQ made it so that the guys must enable the 3rd summon but didnt plan to make a 4th ...so it is a must to enable 3rd...
06/14/2009 21:04 magewarior2#14
Quote:
Originally Posted by mama020153 View Post
Well i dont know hwo but i can shur give it a shot for you and ty Spy520. :)
that would be very grate ;D
06/15/2009 01:30 mama020153#15
Yea thats what i was thinking Rexx