Manually change Compose rates?

i've tried several scripts to change the compose rates.... I want my compose rates at approx. 2-4 stars per compose, but all scripts don't work! HELP MEEEEEE!

Your thread title is your answer. Instead of using the scripts, take the time to manually edit them yourself till they work to your liking.

how can i change them? i don't even know how!

Quote:

Originally Posted by Saraiyu how can i change them? i don't even know how!

open your cq_eudemon_rbn_rqr set MIN and MAX to what u want..hope this help;)

indeed, ty

new problem..... now it says it doesn't have a key, and all compose rates are 1 point per compose?


this is what it says : [Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*200.35
Update cq_eudemon_rbn_rqr set max =*400.35' at line 1

Please post your sql statement so we can look at it.

+6 reported at: 5 Mar 2010 - 19:20:00 GMT -5 Cause: Double Post

#PostsMerged

Quote:

Originally Posted by Saraiyu new problem..... now it says it doesn't have a key, and all compose rates are 1 point per compose? this is what it says : [Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*200.35 Update cq_eudemon_rbn_rqr set max =*400.35' at line 1

You forgot the semicolon ; at the end of each query.

Quote:

Originally Posted by Saraiyu new problem..... now it says it doesn't have a key, and all compose rates are 1 point per compose? this is what it says : [Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '*200.35 Update cq_eudemon_rbn_rqr set max =*400.35' at line 1

Your script should look like this
UPDATE `cq_eudemon_rbn_rqr` SET `min`='your value';
UPDATE `cq_eudemon_rbn_rqr` SET `max`='your value';

If you want to define it to a certain required star universal to compose with
UPDATE `cq_eudemon_rbn_rqr` SET `min`='your value' Where `sacrifice_starlev` = 'star value';
UPDATE `cq_eudemon_rbn_rqr` SET `max`='your value' Where `sacrifice_starlev` = 'star value';
and so on

(note the standard sacrifice star values are, 0, 50, 75, 100, 200, 280, 480, 600, 800, 1200, 1500, 1800, 2000, 2500, 3000. Also note 100 here = 1* in game)

Hope this helps

or you can use excel and the paste special command which works quite well.. ill post a guide on it if needed

i need to know how to get a 2 to 4 star compose on EVERY pet in the candy db, and how to fix the negative def bug over 10k stars! please post a guide!

the def bug is cuased by the def stats going over 100k in the db which is cuased by the amount of stars going up by 1*-1000* . i dont know the fix sorry.

u just gotta play with the numbers to get the compose rate u want.

one person said 100.35? i think that's a tad high, isn't it?

You can't fix the negative def problem with these binaries. If you get to the negative, however, you can keep composing till it goes positive again.

[Only registered and activated users can see links. Click Here To Register...]

hmph, i guess i need to keep composing then.... but a et of numbers that equal out to 2 to 4 stars per compose would be nice, i been trying for 2 days, still can't get it right :(

i have changed all the numbers from 2500 in the cq_eudemon_rbn_rqr for min and max i put it down to 400 and it composes at 1000 points per compose sometimes hier and it goes down little by litte but when i take it to 200 it composes at 500 points per compose is there an easer way to use the navie cat pro i cant figure out how to right click it all a past it so it will all chang. like for instence i want to set all the max points per compose to 100 insted of doing one box at a time is there a way to do it to them all. but that max and min compose rates i got up there is anothere problem i think it should have went down to 2 stars per compose insted of 5.