[Help] Problem With Mp Bar!!

[.Ash]

Originally Posted by matrix89

yup..but all player become to..

Put a number in Soul..

Example

i put in 3000 in soul and 100 in mana.. i got 100/60000
i put in 2000 in soul and 100 in mana.. i got 100/40000

Basically, Soul x 20 = outcome.

4000*20 = 80000
10000*20 = 200000

Edit:

Quick query:
update cq_user set soul=*** where soul=0; (option..)
update cq_user set soul=*** where profession=10;
update cq_user set soul=*** where profession=30;

[matrix89]

Originally Posted by SpongeBox

Put a number in Soul..

Example

i put in 3000 in soul and 100 in mana.. i got 100/60000
i put in 2000 in soul and 100 in mana.. i got 100/40000

Basically, Soul x 20 = outcome.

4000*20 = 80000
10000*20 = 200000

Edit:

Quick query:
update cq_user set soul=*** where soul=0; (option..)
update cq_user set soul=*** where profession=10;
update cq_user set soul=*** where profession=30;

thanx..SpongeBox..
it working!!

[.Ash]

Originally Posted by matrix89

thanx..SpongeBox..
it working!!

Np

[HwabiFury]

Originally Posted by SpongeBox

Put a number in Soul..

Example

i put in 3000 in soul and 100 in mana.. i got 100/60000
i put in 2000 in soul and 100 in mana.. i got 100/40000

Basically, Soul x 20 = outcome.

4000*20 = 80000
10000*20 = 200000

Edit:

Quick query:
update cq_user set soul=*** where soul=0; (option..)
update cq_user set soul=*** where profession=10;
update cq_user set soul=*** where profession=30;

you a smartie pom pom eh?

[zspider]

Originally Posted by SpongeBox

Put a number in Soul...
Quick query:

update cq_user set soul=*** where soul=0; (option..)
update cq_user set soul=*** where profession=10;
update cq_user set soul=*** where profession=30;

sorry for Noby question but if i wanaa it work change (***) to what and this soul=0 to what ???
and i have another problem in soul is 0/0 and when i use SoulBox no thing happen just clicked right on it and nothing happen any help plz??

[.Ash]

Originally Posted by zspider

sorry for Noby question but if i wanaa it work change (***) to what and this soul=0 to what ???
and i have another problem in soul is 0/0 and when i use SoulBox no thing happen just clicked right on it and nothing happen any help plz??

The *** stands for the number you want.. and im not sure about the SoulBox..Sorry about that..

[matrix89]

Originally Posted by zspider

sorry for Noby question but if i wanaa it work change (xxx) to what and this soul=0 to what ???
and i have another problem in soul is 0/0 and when i use SoulBox no thing happen just clicked right on it and nothing happen any help plz??

i think your soulbox have problem..
try to fix it...

delete from cq_itemtype where id = 1012010;
delete from cq_itemtype where id = 729098;

INSERT INTO `cq_itemtype` VALUES ('729098', 'SoulBox', '30', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '6200000', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '29', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1012010', 'Soul', '30', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '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', '[COLOR="Red"]6000[/COLOR]');


delete from cq_action where id = 6200000;
delete from cq_action where id = 6200001;
delete from cq_action where id = 6200002;
delete from cq_action where id = 6200003;

INSERT INTO `cq_action` VALUES ('6200000', '6200001', '0000', '0498', '729098', '');
INSERT INTO `cq_action` VALUES ('6200001', '6200002', '0000', '0501', '1012010', '');
INSERT INTO `cq_action` VALUES ('6200002', '6200003', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,1012010,1,0,729098,0,0');
INSERT INTO `cq_action` VALUES ('6200003', '0000', '0000', '0126', '0', 'You~have~recived~a~SoulBox.');

RED Number is Soul_Value

[zspider]

Originally Posted by SpongeBox

The xxx stands for the number you want.. and im not sure about the SoulBox..Sorry about that..

xxx like what 2000 for example ??

Originally Posted by matrix89

i think your soulbox have problem..
try to fix it...

delete from cq_itemtype where id = 1012010;
delete from cq_itemtype where id = 729098;

INSERT INTO `cq_itemtype` VALUES ('729098', 'SoulBox', '30', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '6200000', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '29', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1012010', 'Soul', '30', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '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', '[COLOR="Red"]6000[/COLOR]');


delete from cq_action where id = 6200000;
delete from cq_action where id = 6200001;
delete from cq_action where id = 6200002;
delete from cq_action where id = 6200003;

INSERT INTO `cq_action` VALUES ('6200000', '6200001', '0000', '0498', '729098', '');
INSERT INTO `cq_action` VALUES ('6200001', '6200002', '0000', '0501', '1012010', '');
INSERT INTO `cq_action` VALUES ('6200002', '6200003', '0000', '1085', '0', 'gmlog/action_log 380,%user_name[%user_id],0,0,1012010,1,0,729098,0,0');
INSERT INTO `cq_action` VALUES ('6200003', '0000', '0000', '0126', '0', 'You~have~recived~a~SoulBox.');

RED Number is Soul_Value

it isn't work too

[.Ash]

Yes, put any number you want in '***'