[Release] 5th SummonStone.

[jayk10304]

Originally Posted by mama020153

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

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

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!

hey its me again, "Mr.Pain in the ass noob question guy" lmao, so how do i add the 5th summon to my server?

[.Ash]

Originally Posted by jayk10304

hey its me again, "Mr.Pain in the *** noob question guy" lmao, so how do i add the 5th summon to my server?

Lol Run the query...and insert it into a item... Acctually, This can be upto 12 summon lol. Change 'maxeudemon = 5' and that's all

[jayk10304]

Originally Posted by SpongeBox

Lol Run the query...and insert it into a item... Acctually, This can be upto 12 summon lol. Change 'maxeudemon = 5' and that's all

ok, but how do i add it? like what do i add to a query? and do i put in my or mysql? , im not good with cq_itemtype and the other cq_itemtype's in my navicat, they arent translated to english >.> same with the pets lol
i need like mega help with it, and i need a register script for my server, can u teach me and give me a step by step tutorial, personal message me the answeres plz, thank u spongebox, and when do u wanna chill? ill bring my laptop to ur house or w,e and u can help me and teach me how to do it face to face? i live around the cornor from u, when u PM me well talk more, thank u bro

[Manly393]

Should this work with the new db/client? I have this problem and it won't go away.. I assume its client sided but I'm not sure. The image of the item is in the mall, it says how much it is and everything but it cannot be bought. When i spawn the stone on my pm account it works, its just the mall >_> its not my first mall add but something isn't right. Anyone help?

[xCookieZx]

Originally Posted by Manly393

Should this work with the new db/client? I have this problem and it won't go away.. I assume its client sided but I'm not sure. The image of the item is in the mall, it says how much it is and everything but it cannot be bought. When i spawn the stone on my pm account it works, its just the mall >_> its not my first mall add but something isn't right. Anyone help?

im guessing you messed up the code or the item id when you hexed it

[WickedSweet]

did u put it in cq_goods?

[Manly393]

thank you very much WickedSweet :P thought I saw that in the query but apparently i didn't lol.

[Marcus*]

this error happened to me
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);
[Err] 1136 - Column count doesn't match value count at row 1

[King_Arthur]

Originally Posted by Marcus*

this error happened to me
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);
[Err] 1136 - Column count doesn't match value count at row 1

Your db has more or less columns than the query has values for. You should compare the values this query would add to your db against the columns you have and see where the discrepancy is, and then fix the query to work with your db.

[Marcus*]

and how do i do that?

[Jack Sparrow]

Originally Posted by magewarior2

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

[COLOR="Red"]Guy whit 2 summon buys 5th summon stone, use it, have 5 summon[/COLOR]

[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!!

Has anyone managed to get it to work this way ?
i been trying that all the day but the truth is i kinda suck at cq-action so can anyone help with it ? or at least give a hint ?
thanks

[Eurion]

Originally Posted by Zero300

Has anyone managed to get it to work this way ?
i been trying that all the day but the truth is i kinda suck at cq-action so can anyone help with it ? or at least give a hint ?
thanks

It's been a while since I worked with the summons options but something like this should do what you want.

1	2	3	1001	0	[color=red]medal_select == 4[/color]
2	4	0	1001	0	maxeudemon = 5
3	0	0	126	0	Sorry you need summons 4 before you can get 5th summons
4	0	0	126	0	Way to go you just got 5th summons

The red checks for the players current summons.

[grey97]

[SQL] delete from cq_action
where
id >= 8921523
and
id <= 8921528;
Affected rows: 6
Time: 0.063ms

[SQL]

delete from cq_action
where
id >= 8921531
and
id <= 8921532;
Affected rows: 2
Time: 0.015ms

[SQL]

delete from cq_itemtype
where
id >= 721550
and
id <= 721550;
Affected rows: 0
Time: 0.016ms

[SQL]

INSERT INTO `cq_action` VALUES ('8921523', '8921524', '8921527', '1001', '0', 'maxeudemon < 5');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921524', '8921525', '0000', '0502', '721550', '');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921525', '8921526', '0000', '1001', '0', 'maxeudemon = 5');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921526', '8921528', '0000', '1027', '0', 'self skill156');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921527', '0000', '0000', '0126', '0', 'Sorry, You already have 5 Summon.');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921528', '8921531', '8921531', '1080', '1021', 'new');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921531', '8921532', '8921532', '1081', '1021', 'phase = 17');
Affected rows: 1
Time: 0.000ms

[SQL]
INSERT INTO `cq_action` VALUES ('8921532', '0000', '0000', '1010', '2011', 'Congraz!~You~Have~5th~Summon~Now.');
Affected rows: 1
Time: 0.000ms

[SQL]

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);
[Err] 1136 - Column count doesn't match value count at row 1

got error , can tell me why ?

[amirrozlan]

TQ very much!

[magewarior2]

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)
[Err] 1136 - Column [COLOR="red"]count doesn't match value count at row 1[/COLOR]

so go to cq_itemtype and add it manually