[Release] 5th SummonStone.

Page 2 of 3 1 2 3
05/11/2010 02:31 jayk10304#16
Quote:
Originally Posted by mama020153 View Post
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!
hey its me again, "Mr.Pain in the ass noob question guy" lmao, so how do i add the 5th summon to my server?
05/11/2010 12:50 .Ash#17
Quote:
Originally Posted by jayk10304 View Post
hey its me again, "Mr.Pain in the ass 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
05/12/2010 05:00 jayk10304#18
Quote:
Originally Posted by SpongeBox View Post
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
05/27/2010 22:23 Manly393#19
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?
05/27/2010 22:45 xCookieZx#20
Quote:
Originally Posted by Manly393 View Post
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
05/27/2010 22:51 WickedSweet#21
did u put it in cq_goods?
05/27/2010 22:55 Manly393#22
thank you very much WickedSweet :P thought I saw that in the query but apparently i didn't lol.
02/04/2011 00:05 Marcus*#23
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
02/04/2011 01:15 King_Arthur#24
Quote:
Originally Posted by Marcus* View Post
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.
02/04/2011 01:27 Marcus*#25
and how do i do that?
05/06/2011 17:30 Jack Sparrow#26
Quote:
Originally Posted by magewarior2 View Post
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!!
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
05/06/2011 18:00 Eurion#27
Quote:
Originally Posted by Zero300 View Post
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.

Code:
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.
10/13/2011 05:35 grey97#28
Quote:
[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 ?
10/13/2011 07:47 amirrozlan#29
TQ very much! [Only registered and activated users can see links. Click Here To Register...]
10/13/2011 17:18 magewarior2#30
Code:
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 :)
Page 2 of 3 1 2 3