HELP

[vieska]

how to make casual +255/element 255?
what i need to edit?.

Then how to change VIP lvl??

And i do not sure how to make auto ep,i find guide but od not understand what to change.


Thanks for answer

[pretzel666]

Id look here changing vip level go into cq_account and change VIP to desired level , to change the vip level you start with go to file , then hit design table then find vip click it , then type the desired starting vip . and for the auto eps can you explain what you want better?

[vieska]

Originally Posted by pretzel666

Id look here changing vip level go into cq_account and change VIP to desired level , to change the vip level you start with go to file , then hit design table then find vip click it , then type the desired starting vip . and for the auto eps can you explain what you want better?

Thanks for answers,(not sure will find it ,but will look for them ).
Auto ep?? Like kill madbull and get 1 ep,kill big fang get 5 ep or maybe 4 ).

Waiting for answers or full guides of this ))

[karnyge]

Try searching for Murtahs autoep system?

[pretzel666]

Get murtahs auto ep , search for them in cq_action and just change them in there

[vieska]

I have found it, but do not understand hwo to use it, his told to delete something, then paste somewhere ..

Originally Posted by karnyge

Try searching for Murtahs autoep system?

Have you read all post ??? I have placed link for it in first post ... lol ..

[karnyge]

Sheesh.

Open navicat, click back up, and wait for it to complete.
Click query, copy and paste the contents of the file in, hit run.
When done click save query.

BADDABING BADDABOOM- done!

[vieska]

Originally Posted by karnyge

Sheesh.

Open navicat, click back up, and wait for it to complete.
Click query, copy and paste the contents of the file in, hit run.
When done click save query.

BADDABING BADDABOOM- done!

Its first good comments in my life .... With normal explame

[buzz2289]

Originally Posted by vieska

how to make casual +255/element 255?
what i need to edit?.

Then how to change VIP lvl??

And i do not sure how to make auto ep,i find guide but od not understand what to change.


Thanks for answer

for casual here is a script:

-- ----------------------------
-- +255 With elements equipments
-- ----------------------------



update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=1;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=2;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=3;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=4;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=7;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=8;

update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=1;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '24' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=2;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=3;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '24' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=4;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '24' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=7;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=8;

update cq_item set type ='1020260' where type=813002;

-- ----------------------------
-- Script End
-- ----------------------------

-- --------------------------------------------
-- For Casual +255 ( with full +255 element ---
-- Script Start --
-- --------------------------------------------

update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=100008462 and position=12;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '24' , gem2 = '24', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=100008462 and position=12;

-- ----------------------------
-- Script End
-- ----------------------------


Info

Position=12 @= Casual currently wearing by char.
player_id = change the player id u want to upgrade the items ( can be found in cq_user under ID coloum ) 
TO set player/maker name = change forgename to any user u want 

ident = 4 @ make the item indestructable

Here is the list of Gem id's
18 = super amber
21 = super citrine
24 = super beryl
30 = super sapphire
27 = super amethyst
255 = empty sockets
0 = no sockets at all

To change F-Soul (warghostexp) here are some examples,,
1536 = +9
1024 = +8
512 = +4
256 = +2

Script is made by or atleast posted by nukleus so credits to him

As for changing VIP level open MySQL or Navicat, depending on what you use, go to "account" table and all the way to the right you cange your VIP level

Now for the EP system thats time consuming but i feel it is worth it here it is:

Just Download the file edit this:

INSERT INTO `cq_action` VALUES ('1', '2', '0000', '1001', '0', 'e_money += 5');
INSERT INTO `cq_action` VALUES ('2', '0', '0000', '1010', '2005', 'You found 5 EudemonPoints from a MadBull!');
INSERT INTO `cq_action` VALUES ('3', '4', '0000', '1001', '0', 'e_money += 10');
INSERT INTO `cq_action` VALUES ('4', '0', '0000', '1010', '2005', 'You found 10 EudemonPoints from a GreenGiant!');
INSERT INTO `cq_action` VALUES ('5', '6', '0000', '1001', '0', 'e_money += 15');
INSERT INTO `cq_action` VALUES ('6', '0', '0000', '1010', '2005', 'You found 15 EudemonPoints from a BullyWug!');
INSERT INTO `cq_action` VALUES ('7', '8', '0000', '1001', '0', 'e_money += 20');
INSERT INTO `cq_action` VALUES ('8', '0', '0000', '1010', '2005', 'You found 20 EudemonPoints from a Gnome!');
INSERT INTO `cq_action` VALUES ('9', '10', '0000', '1001', '0', 'e_money += 30');
INSERT INTO `cq_action` VALUES ('10', '0', '0000', '1010', '2005', 'You found 30 EudemonPoints from a Dragonkin!');
INSERT INTO `cq_action` VALUES ('11', '12', '0000', '1001', '0', 'e_money += 35');
INSERT INTO `cq_action` VALUES ('12', '0', '0000', '1010', '2005', 'You found 35 EudemonPoints from a GreenDevil!');
INSERT INTO `cq_action` VALUES ('13', '14', '0000', '1001', '0', 'e_money += 40');
INSERT INTO `cq_action` VALUES ('14', '0', '0000', '1010', '2005', 'You found 40 EudemonPoints from a Eyeball!');
INSERT INTO `cq_action` VALUES ('15', '16', '0000', '1001', '0', 'e_money += 45');
INSERT INTO `cq_action` VALUES ('16', '0', '0000', '1010', '2005', 'You found 45 EudemonPoints from a Banshee!');
INSERT INTO `cq_action` VALUES ('17', '18', '0000', '1001', '0', 'e_money += 50');
INSERT INTO `cq_action` VALUES ('18', '0', '0000', '1010', '2005', 'You found 50 EudemonPoints from a Satyr!');
INSERT INTO `cq_action` VALUES ('19', '20', '0000', '1001', '0', 'e_money += 55');
INSERT INTO `cq_action` VALUES ('20', '0', '0000', '1010', '2005', 'You found 55 EudemonPoints from a Ogre!');
INSERT INTO `cq_action` VALUES ('21', '22', '0000', '1001', '0', 'e_money += 60');
INSERT INTO `cq_action` VALUES ('22', '0', '0000', '1010', '2005', 'You found 60 EudemonPoints from a Orc!');
INSERT INTO `cq_action` VALUES ('23', '24', '0000', '1001', '0', 'e_money += 65');
INSERT INTO `cq_action` VALUES ('24', '0', '0000', '1010', '2005', 'You found 65 EudemonPoints from a BigFang!');
INSERT INTO `cq_action` VALUES ('25', '26', '0000', '1001', '0', 'e_money += 70');
INSERT INTO `cq_action` VALUES ('26', '0', '0000', '1010', '2005', 'You found 70 EudemonPoints from a Golem!');
INSERT INTO `cq_action` VALUES ('27', '28', '0000', '1001', '0', 'e_money += 75');
INSERT INTO `cq_action` VALUES ('28', '0', '0000', '1010', '2005', 'You found 75 EudemonPoints from a Lizard!');
INSERT INTO `cq_action` VALUES ('29', '30', '0000', '1001', '0', 'e_money += 80');
INSERT INTO `cq_action` VALUES ('30', '0', '0000', '1010', '2005', 'You found 80 EudemonPoints from a GhostKnight!');
INSERT INTO `cq_action` VALUES ('31', '32', '0000', '1001', '0', 'e_money += 85');
INSERT INTO `cq_action` VALUES ('32', '0', '0000', '1010', '2005', 'You found 85 EudemonPoints from a Wyverm!');
INSERT INTO `cq_action` VALUES ('33', '34', '0000', '1001', '0', 'e_money += 90');
INSERT INTO `cq_action` VALUES ('34', '0', '0000', '1010', '2005', 'You found 90 EudemonPoints from a Troglodyte!');
INSERT INTO `cq_action` VALUES ('35', '36', '0000', '1001', '0', 'e_money += 95');
INSERT INTO `cq_action` VALUES ('36', '0', '0000', '1010', '2005', 'You found 95 EudemonPoints from a Ghost!');
INSERT INTO `cq_action` VALUES ('37', '38', '0000', '1001', '0', 'e_money += 100');
INSERT INTO `cq_action` VALUES ('38', '0', '0000', '1010', '2005', 'You found 100 EudemonPoints from a DeadKnight!');
INSERT INTO `cq_action` VALUES ('39', '40', '0000', '1001', '0', 'e_money += 105');
INSERT INTO `cq_action` VALUES ('40', '0', '0000', '1010', '2005', 'You found 105 EudemonPoints from a Warlock!');
INSERT INTO `cq_action` VALUES ('41', '42', '0000', '1001', '0', 'e_money += 110');
INSERT INTO `cq_action` VALUES ('42', '0', '0000', '1010', '2005', 'You found 110 EudemonPoints from a FishDemon!');
INSERT INTO `cq_action` VALUES ('43', '44', '0000', '1001', '0', 'e_money += 115');
INSERT INTO `cq_action` VALUES ('44', '0', '0000', '1010', '2005', 'You found 115 EudemonPoints from a Dinothere!');
INSERT INTO `cq_action` VALUES ('45', '46', '0000', '1001', '0', 'e_money += 120');
INSERT INTO `cq_action` VALUES ('46', '0', '0000', '1010', '2005', 'You found 120 EudemonPoints from a AxDemon!');
INSERT INTO `cq_action` VALUES ('47', '48', '0000', '1001', '0', 'e_money += 125');
INSERT INTO `cq_action` VALUES ('48', '0', '0000', '1010', '2005', 'You found 125 EudemonPoints from a DwarfApe!');
INSERT INTO `cq_action` VALUES ('49', '50', '0000', '1001', '0', 'e_money += 130');
INSERT INTO `cq_action` VALUES ('50', '0', '0000', '1010', '2005', 'You found 130 EudemonPoints from a IceDemon!');
INSERT INTO `cq_action` VALUES ('51', '52', '0000', '1001', '0', 'e_money += 135');
INSERT INTO `cq_action` VALUES ('52', '0', '0000', '1010', '2005', 'You found 135 EudemonPoints from a Yeti!');
INSERT INTO `cq_action` VALUES ('53', '54', '0000', '1001', '0', 'e_money += 140');
INSERT INTO `cq_action` VALUES ('54', '0', '0000', '1010', '2005', 'You found 140 EudemonPoints from a Orc!');
INSERT INTO `cq_action` VALUES ('55', '56', '0000', '1001', '0', 'e_money += 145');
INSERT INTO `cq_action` VALUES ('56', '0', '0000', '1010', '2005', 'You found 145 EudemonPoints from a Worman!');
INSERT INTO `cq_action` VALUES ('57', '58', '0000', '1001', '0', 'e_money += 150');
INSERT INTO `cq_action` VALUES ('58', '0', '0000', '1010', '2005', 'You found 150 EudemonPoints from a FourTeeth!');
INSERT INTO `cq_action` VALUES ('59', '60', '0000', '1001', '0', 'e_money += 155');
INSERT INTO `cq_action` VALUES ('60', '0', '0000', '1010', '2005', 'You found 155 EudemonPoints from a FireGenasi!');
INSERT INTO `cq_action` VALUES ('61', '62', '0000', '1001', '0', 'e_money += 160');
INSERT INTO `cq_action` VALUES ('62', '0', '0000', '1010', '2005', 'You found 160 EudemonPoints from a Scorpion!');
INSERT INTO `cq_action` VALUES ('63', '64', '0000', '1001', '0', 'e_money += 220');
INSERT INTO `cq_action` VALUES ('64', '0', '0000', '1010', '2005', 'You found 220 EudemonPoints from a LostSiren!');
INSERT INTO `cq_action` VALUES ('65', '66', '0000', '1001', '0', 'e_money += 230');
INSERT INTO `cq_action` VALUES ('66', '0', '0000', '1010', '2005', 'You found 230 EudemonPoints from a Berserker!');
INSERT INTO `cq_action` VALUES ('67', '68', '0000', '1001', '0', 'e_money += 240');
INSERT INTO `cq_action` VALUES ('68', '0', '0000', '1010', '2005', 'You found 240 EudemonPoints from a SilentKnight!');
INSERT INTO `cq_action` VALUES ('69', '70', '0000', '1001', '0', 'e_money += 500');
INSERT INTO `cq_action` VALUES ('70', '0', '0000', '1010', '2005', 'You found 500 EudemonPoints from a HimalayanYeti!');
INSERT INTO `cq_action` VALUES ('71', '72', '0000', '1001', '0', 'e_money += 550');
INSERT INTO `cq_action` VALUES ('72', '0', '0000', '1010', '2005', 'You found 550 EudemonPoints from a IceLord!');
INSERT INTO `cq_action` VALUES ('73', '74', '0000', '1001', '0', 'e_money += 600');
INSERT INTO `cq_action` VALUES ('74', '0', '0000', '1010', '2005', 'You found 600 EudemonPoints from a IceSwordman!');
INSERT INTO `cq_action` VALUES ('75', '76', '0000', '1001', '0', 'e_money += 250');
INSERT INTO `cq_action` VALUES ('76', '0', '0000', '1010', '2005', 'You found 250 EudemonPoints from a Spider!');
INSERT INTO `cq_action` VALUES ('77', '78', '0000', '1001', '0', 'e_money += 5000');
INSERT INTO `cq_action` VALUES ('78', '0', '0000', '1010', '2005', 'You found 5000 EudemonPoints from a SpiderQueen!');

now all you edit here is

e_money += XXXX

where "X" is where the amount of EPs is and edit

'You found XXXX EudemonPoints from a SpiderQueen

and there you have it thats all there is to it