[Help] Problem With Mp Bar!!

03/17/2010 22:18 .Ash#16
Quote:
Originally Posted by matrix89 View Post
yup..but all player become to..
Put a number in Soul..

Example
Code:
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=xxx where soul=0; (option..)
update cq_user set soul=xxx where profession=10;
update cq_user set soul=xxx where profession=30;
03/18/2010 01:10 matrix89#17
Quote:
Originally Posted by SpongeBox View Post
Put a number in Soul..

Example
Code:
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=xxx where soul=0; (option..)
update cq_user set soul=xxx where profession=10;
update cq_user set soul=xxx where profession=30;
thanx..SpongeBox..
it working!!
;);):):)
03/18/2010 12:37 .Ash#18
Quote:
Originally Posted by matrix89 View Post
thanx..SpongeBox..
it working!!
;);):):)
Np ;)
03/23/2010 03:06 HwabiFury#19
Quote:
Originally Posted by SpongeBox View Post
Put a number in Soul..

Example
Code:
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=xxx where soul=0; (option..)
update cq_user set soul=xxx where profession=10;
update cq_user set soul=xxx where profession=30;
you a smartie pom pom eh?
03/23/2010 23:04 zspider#20
Quote:
Originally Posted by SpongeBox View Post
Put a number in Soul...
Quick query:

update cq_user set soul=xxx where soul=0; (option..)
update cq_user set soul=xxx where profession=10;
update cq_user set soul=xxx where profession=30;
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??
03/24/2010 00:28 .Ash#21
Quote:
Originally Posted by zspider View Post
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??
The xxx stands for the number you want.. and im not sure about the SoulBox..Sorry about that..
03/24/2010 05:07 matrix89#22
Quote:
Originally Posted by zspider View Post
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...
Code:
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
03/24/2010 14:15 zspider#23
Quote:
Originally Posted by SpongeBox View Post
The xxx stands for the number you want.. and im not sure about the SoulBox..Sorry about that..
xxx like what 2000 for example ??
Quote:
Originally Posted by matrix89 View Post
i think your soulbox have problem..
try to fix it...
Code:
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 :(
03/24/2010 19:43 .Ash#24
Yes, put any number you want in 'xxx'