HELP

Quote:

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.
[Only registered and activated users can see links. Click Here To Register...]

Thanks for answer :handsdown:

for casual here is a script:

Code:

-- ----------------------------
-- +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:

Code:

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

Quote:

e_money += XXXX

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

Quote:

'You found XXXX EudemonPoints from a SpiderQueen

and there you have it thats all there is to it :)