[HELP] Composing rate Failure

02/27/2010 22:33 eliasjuh1234#1
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 :) )
02/27/2010 22:48 ilikenachos#2
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
02/27/2010 23:33 chaosblade#3
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
Code:
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.
02/28/2010 00:29 eliasjuh1234#4
Quote:
Originally Posted by chaosblade View Post
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
Code:
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.
02/28/2010 01:42 chaosblade#5
why dont you try to change the *4 to a complete number for example
Code:
UPDATE `cq_eudemon_rbn_rqr` SET `min`='50' 
UPDATE `cq_eudemon_rbn_rqr` SET `max`='100'
02/28/2010 03:57 catface2345#6
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
02/28/2010 05:16 chaosblade#7
Quote:
Originally Posted by catface2345 View Post
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.
03/11/2010 21:37 eliasjuh1234#8
Ok, I fixed it, if that query doesn't work for anyone else, this one worked for me

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