[Release] EOCARD,PPCARD And GMCARD

11/27/2009 20:15 matrix89#1

ok..this my release to show you make a EO and PP card

first extract to cq_action

Code:

delete from cq_action where id >= 7081735 and id <= 7081735;
delete from cq_action where id >= 7081736 and id <= 7081736;
delete from cq_action where id >= 7081737 and id <= 7081737;
delete from cq_action where id >= 7081738 and id <= 7081738;
delete from cq_action where id >= 6960010 and id <= 6960010;
delete from cq_action where id >= 6960011 and id <= 6960011;
delete from cq_action where id >= 6960012 and id <= 6960012;
delete from cq_action where id >= 6960013 and id <= 6960013;
delete from cq_action where id >= 6960000 and id <= 6960000;
delete from cq_action where id >= 6960001 and id <= 6960001;
delete from cq_action where id >= 6960002 and id <= 6960002;
delete from cq_action where id >= 6960003 and id <= 6960003;
delete from cq_action where id >= 6960020 and id <= 6960020;
delete from cq_action where id >= 6960021 and id <= 6960021;
delete from cq_action where id >= 6960022 and id <= 6960022;
delete from cq_action where id >= 6960023 and id <= 6960023;
delete from cq_action where id >= 6960030 and id <= 6960030;
delete from cq_action where id >= 6960031 and id <= 6960031;
delete from cq_action where id >= 6960032 and id <= 6960032;
delete from cq_action where id >= 6960033 and id <= 6960033;
delete from cq_action where id >= 6960036 and id <= 6960039;
delete from cq_action where id >= 7770000 and id <= 7770003;

INSERT INTO `cq_action` VALUES ('7081735', '7081736', '0000', '1001', '0', 'e_money += 500');
INSERT INTO `cq_action` VALUES ('7081737', '7081738', '0000', '0502', '1020140', '');
INSERT INTO `cq_action` VALUES ('7081736', '7081737', '0000', '1010', '2005', 'Conguratulation!!~You~Get~500EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('7081738', '0000', '0000', '1027', '0', 'self skill305');
INSERT INTO `cq_action` VALUES ('6960010', '6960011', '0000', '0502', '1020150', '');
INSERT INTO `cq_action` VALUES ('6960011', '6960012', '0000', '1001', '0', 'e_money += 270');
INSERT INTO `cq_action` VALUES ('6960012', '6960013', '0000', '0126', '0', 'Conguratulation!!~You~Get~270EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('6960013', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,270,0,0,729018,0,0');
INSERT INTO `cq_action` VALUES ('6960000', '6960001', '0000', '0502', '1020160', '');
INSERT INTO `cq_action` VALUES ('6960001', '6960002', '0000', '1001', '0', 'e_money += 2700');
INSERT INTO `cq_action` VALUES ('6960002', '6960003', '0000', '0126', '0', 'Conguratulation!!~You~Get~2700EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('6960003', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,2700,0,729017,0,0');
INSERT INTO `cq_action` VALUES ('6960020', '6960021', '0000', '0502', '729017', '');
INSERT INTO `cq_action` VALUES ('6960021', '6960022', '0000', '1001', '0', 'e_money += 2700');
INSERT INTO `cq_action` VALUES ('6960022', '6960023', '0000', '0126', '0', 'GM~Item~Can~Get~2700EP!!');
INSERT INTO `cq_action` VALUES ('6960023', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,270,0,729016,0,0');
INSERT INTO `cq_action` VALUES ('6960030', '6960031', '0000', '0502', '729018', '');
INSERT INTO `cq_action` VALUES ('6960031', '6960032', '0000', '1001', '0', 'e_money += 270');
INSERT INTO `cq_action` VALUES ('6960032', '6960033', '0000', '0126', '0', 'GM~Item~Can~Get~270EP!!');
INSERT INTO `cq_action` VALUES ('6960033', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,2700,0,729015,0,0');
INSERT INTO `cq_action` VALUES ('6960036', '6960037', '0000', '0502', '780001', '');
INSERT INTO `cq_action` VALUES ('6960037', '6960038', '0000', '1001', '0', 'e_money += 1000000000');
INSERT INTO `cq_action` VALUES ('6960038', '6960039', '0000', '0126', '0', 'GM~Item~Can~Get~1000000000EP!!');
INSERT INTO `cq_action` VALUES ('6960039', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,1000000000,0,729014,0,0');
INSERT INTO `cq_action` VALUES ('7770000', '7770001', '0000', '0502', '780000', '');
INSERT INTO `cq_action` VALUES ('7770001', '7770002', '0000', '1001', '0', 'e_money += 1000000');
INSERT INTO `cq_action` VALUES ('7770002', '7770003', '0000', '0126', '0', 'GM~Item~Can~Get~1000000EP!!');
INSERT INTO `cq_action` VALUES ('7770003', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,1000000,0,729013,0,0');

Second in cq_itemtype

Code:

delete from cq_itemtype where id >= 1020140 and id <= 1020140;
delete from cq_itemtype where id >= 1020150 and id <= 1020150;
delete from cq_itemtype where id >= 1020160 and id <= 1020160;
delete from cq_itemtype where id >= 729017 and id <= 729017;
delete from cq_itemtype where id >= 729018 and id <= 729018;
delete from cq_itemtype where id >= 780000 and id <= 780001;

INSERT INTO `cq_itemtype` VALUES ('1020140', 'EOCARD500', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960040', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1020150', 'EOCARD270', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960010', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1020160', 'EOCARD2700','0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960000', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('729017', 'EOPPCARD', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960020', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('729018', 'EOPPCARD2', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960030', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('780000', 'GM-EOCARD', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '7770000', '0', '0', '0', '0', '0', '0', '0', '1', '65535', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('780001', 'GM-EOCARD2', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960036', '0', '0', '0', '0', '0', '0', '0', '1', '65535', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

and..lastly...is a code only..:D

Quote:

/awarditem 1020140 EOCARD500
/awarditem 1020150 EOCARD270
/awarditem 1020160 EOCARD2700
/awarditem 729017 EOPPCARD
/awarditem 729018 EOPPCARD2
/awarditem 780000 GM-EOCARD <-- Just For PM Only
/awarditem 780001 GM-EOCARD2 <-- Just For PM Only

11/27/2009 21:35 PraDevil[ELITE]#2

can u make a EOCard680 for me..??? :p:p:p

11/27/2009 22:08 hio77#3

once again its a Chinese release this time translated ... Google translator ild say

11/28/2009 01:47 CyberServer#4

is it stackbale eps matrix?

11/28/2009 05:07 hio77#5

Quote:

Originally Posted by CyberServer

is it stackbale eps matrix?

just looked over it ... nope it aint

11/28/2009 05:20 matrix89#6

Quote:

Originally Posted by CyberServer

is it stackbale eps matrix?

Just EOCARD270,EOCARD500 and EOCARD2700

Quote:

Originally Posted by PraDevil

can u make a EOCard680 for me..??? :p:p:p

Just change param box 500 to 680

Code:

INSERT INTO `cq_action` VALUES ('7081735', '7081736', '0000', '1001', '0', 'e_money += [COLOR="Red"]500 [COLOR="Black"]or[/COLOR] [COLOR="SeaGreen"]680[/COLOR][/COLOR]'); <--choose one only..

Quote:

Originally Posted by hio77

once again its a Chinese release this time translated ... Google translator ild say

:D is not Chinese release..is malay release..in forgot to change it...:p

11/28/2009 06:50 DEADP00L#7

Seriously use the dang edit button. THis is your first offical warning. Next time i have to tell you i am making it an infraction. The edit button was there for a reason

11/29/2009 13:34 SoulNecturn#8

Quote:

Originally Posted by matrix89

/awarditem 1020140 EOCARD500
/awarditem 1020150 EOCARD270
/awarditem 1020160 EOCARD2700
/awarditem 729017 EOPPCARD
/awarditem 729018 EOPPCARD2
/awarditem 780000 GM-EOCARD <-- Just For PM Only
/awarditem 780001 GM-EOCARD2 <-- Just For PM Only

Ymmm - I didnt check your release before - but now I found time to look at it more less AND:

1020140
1020150
1020160
EO cards - are pretty ok - standard already almost in all server existing ...

729017
729018
PP cards - pretty new idea (lets say idea).... but as you pointed here these 2 items are as well for players usage...

Now basing on this release I will say - these 2 items are giving like - UNLIMITED PP to anyone who posses even 1 such a item...
You did this purposely?? By releasing this item every player could have unlimited PP :)

How?
Simply:
Make 1 such a item in game and then go to grocery (or anywhere you wish to) and use REPAIR function on this item ;) and yea enjoy: 60000 of such a cards .... and you can repair untill you get bored ;)

About these 2 GM only items - doesnt matter since they are only for GMs/PMs right?

So simply here - DO NOT ANYONE USE THIS RELEASE TO MAKE PP CARDS like here is described!!!! ;)

Besides nice try of release ;)

05/09/2013 16:35 gseafood1998#9

Quote:

Originally Posted by matrix89

ok..this my release to show you make a EO and PP card

first extract to cq_action

Code:

delete from cq_action where id >= 7081735 and id <= 7081735;
delete from cq_action where id >= 7081736 and id <= 7081736;
delete from cq_action where id >= 7081737 and id <= 7081737;
delete from cq_action where id >= 7081738 and id <= 7081738;
delete from cq_action where id >= 6960010 and id <= 6960010;
delete from cq_action where id >= 6960011 and id <= 6960011;
delete from cq_action where id >= 6960012 and id <= 6960012;
delete from cq_action where id >= 6960013 and id <= 6960013;
delete from cq_action where id >= 6960000 and id <= 6960000;
delete from cq_action where id >= 6960001 and id <= 6960001;
delete from cq_action where id >= 6960002 and id <= 6960002;
delete from cq_action where id >= 6960003 and id <= 6960003;
delete from cq_action where id >= 6960020 and id <= 6960020;
delete from cq_action where id >= 6960021 and id <= 6960021;
delete from cq_action where id >= 6960022 and id <= 6960022;
delete from cq_action where id >= 6960023 and id <= 6960023;
delete from cq_action where id >= 6960030 and id <= 6960030;
delete from cq_action where id >= 6960031 and id <= 6960031;
delete from cq_action where id >= 6960032 and id <= 6960032;
delete from cq_action where id >= 6960033 and id <= 6960033;
delete from cq_action where id >= 6960036 and id <= 6960039;
delete from cq_action where id >= 7770000 and id <= 7770003;

INSERT INTO `cq_action` VALUES ('7081735', '7081736', '0000', '1001', '0', 'e_money += 500');
INSERT INTO `cq_action` VALUES ('7081737', '7081738', '0000', '0502', '1020140', '');
INSERT INTO `cq_action` VALUES ('7081736', '7081737', '0000', '1010', '2005', 'Conguratulation!!~You~Get~500EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('7081738', '0000', '0000', '1027', '0', 'self skill305');
INSERT INTO `cq_action` VALUES ('6960010', '6960011', '0000', '0502', '1020150', '');
INSERT INTO `cq_action` VALUES ('6960011', '6960012', '0000', '1001', '0', 'e_money += 270');
INSERT INTO `cq_action` VALUES ('6960012', '6960013', '0000', '0126', '0', 'Conguratulation!!~You~Get~270EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('6960013', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,270,0,0,729018,0,0');
INSERT INTO `cq_action` VALUES ('6960000', '6960001', '0000', '0502', '1020160', '');
INSERT INTO `cq_action` VALUES ('6960001', '6960002', '0000', '1001', '0', 'e_money += 2700');
INSERT INTO `cq_action` VALUES ('6960002', '6960003', '0000', '0126', '0', 'Conguratulation!!~You~Get~2700EP~From~This~Card!!');
INSERT INTO `cq_action` VALUES ('6960003', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,2700,0,729017,0,0');
INSERT INTO `cq_action` VALUES ('6960020', '6960021', '0000', '0502', '729017', '');
INSERT INTO `cq_action` VALUES ('6960021', '6960022', '0000', '1001', '0', 'e_money += 2700');
INSERT INTO `cq_action` VALUES ('6960022', '6960023', '0000', '0126', '0', 'GM~Item~Can~Get~2700EP!!');
INSERT INTO `cq_action` VALUES ('6960023', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,270,0,729016,0,0');
INSERT INTO `cq_action` VALUES ('6960030', '6960031', '0000', '0502', '729018', '');
INSERT INTO `cq_action` VALUES ('6960031', '6960032', '0000', '1001', '0', 'e_money += 270');
INSERT INTO `cq_action` VALUES ('6960032', '6960033', '0000', '0126', '0', 'GM~Item~Can~Get~270EP!!');
INSERT INTO `cq_action` VALUES ('6960033', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,2700,0,729015,0,0');
INSERT INTO `cq_action` VALUES ('6960036', '6960037', '0000', '0502', '780001', '');
INSERT INTO `cq_action` VALUES ('6960037', '6960038', '0000', '1001', '0', 'e_money += 1000000000');
INSERT INTO `cq_action` VALUES ('6960038', '6960039', '0000', '0126', '0', 'GM~Item~Can~Get~1000000000EP!!');
INSERT INTO `cq_action` VALUES ('6960039', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,1000000000,0,729014,0,0');
INSERT INTO `cq_action` VALUES ('7770000', '7770001', '0000', '0502', '780000', '');
INSERT INTO `cq_action` VALUES ('7770001', '7770002', '0000', '1001', '0', 'e_money += 1000000');
INSERT INTO `cq_action` VALUES ('7770002', '7770003', '0000', '0126', '0', 'GM~Item~Can~Get~1000000EP!!');
INSERT INTO `cq_action` VALUES ('7770003', '0000', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,0,1000000,0,729013,0,0');

Second in cq_itemtype

Code:

delete from cq_itemtype where id >= 1020140 and id <= 1020140;
delete from cq_itemtype where id >= 1020150 and id <= 1020150;
delete from cq_itemtype where id >= 1020160 and id <= 1020160;
delete from cq_itemtype where id >= 729017 and id <= 729017;
delete from cq_itemtype where id >= 729018 and id <= 729018;
delete from cq_itemtype where id >= 780000 and id <= 780001;

INSERT INTO `cq_itemtype` VALUES ('1020140', 'EOCARD500', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960040', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1020150', 'EOCARD270', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960010', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1020160', 'EOCARD2700','0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960000', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('729017', 'EOPPCARD', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960020', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('729018', 'EOPPCARD2', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960030', '0', '0', '0', '0', '0', '0', '0', '1', '60000', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('780000', 'GM-EOCARD', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '7770000', '0', '0', '0', '0', '0', '0', '0', '1', '65535', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('780001', 'GM-EOCARD2', '0', '0', '0', '0', '0', '0', '0', '0', '55', '0', '0', '6960036', '0', '0', '0', '0', '0', '0', '0', '1', '65535', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

and..lastly...is a code only..:D

where is the action for PPcard? i just see e_money + , that PP is same?

09/07/2013 08:31 zulflbeatz#10

mcm mna nk install ni?buat query bru ke?

09/10/2013 13:02 narutobbb#11

PP is token_emoney/e_money2

09/17/2013 03:51 pretzel666#12

e_money2 is pp , token money is tokens i believe (not 100%)

09/26/2013 15:08 MdaizatZ#13

but as well .. i prefered using token_emoney .. work more than e_money2 :) ..
@Pretzel666 token_money is PP :) ..