[HELP] Composing rate Failure

[eliasjuh1234]

So... I ran that query like a hundred times and everytime i try to multiply my rates min & max change to 0. (Yes I am sure i typed it right).
I don't know what I am doing wrong. Anyway could anyone post a .sql with Compose rates *4?

Thanks Alot! (Any other help is also appreciated )

[ilikenachos]

hmmm the query messed ur file up u have to get the file again and then run the script and try going up *2 at a time

[chaosblade]

Query sometimes can screw up your compose rates so i would be carful what I would do is enter them manually but if u dont have the time heres a query

UPDATE `cq_eudemon_rbn_rqr` SET `min`='*4' 
UPDATE `cq_eudemon_rbn_rqr` SET `max`='*4'

you can change the *4 to anything you want.

[eliasjuh1234]

Originally Posted by chaosblade

Query sometimes can screw up your compose rates so i would be carful what I would do is enter them manually but if u dont have the time heres a query

UPDATE `cq_eudemon_rbn_rqr` SET `min`='*4' 
UPDATE `cq_eudemon_rbn_rqr` SET `max`='*4'

you can change the *4 to anything you want.

That's the query that i've been running all the time.
I Just did it again and once again both min & max columns turned into 0.

[chaosblade]

why dont you try to change the *4 to a complete number for example

UPDATE `cq_eudemon_rbn_rqr` SET `min`='50' 
UPDATE `cq_eudemon_rbn_rqr` SET `max`='100'

[catface2345]

lol the query wont work, u have to manualy add them in and make sure every pet is differnet so its more unique like mine

[chaosblade]

Originally Posted by catface2345

lol the query wont work, u have to manualy add them in and make sure every pet is differnet so its more unique like mine

Both the querys worked fine with me I dont know must be something wrong with the DB.

[eliasjuh1234]

Ok, I fixed it, if that query doesn't work for anyone else, this one worked for me

update cq_eudemon_rbn_rqr set min=min*4
update cq_eudemon_rbn_rqr set max=max*4