Manually change Compose rates?

Saraiyu · 03/05/2010, 22:05

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!

King_Arthur · 03/05/2010, 22:10

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.

Saraiyu · 03/05/2010, 22:20

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

PraDevil[ELITE] · 03/05/2010, 22:26

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

Saraiyu · 03/05/2010, 22:35

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

Eurion · 03/06/2010, 00:32

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

King_Arthur · 03/06/2010, 01:19

+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.

Phantomslaya · 03/06/2010, 04:46

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

Knight^Hawk · 03/06/2010, 08:13

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

Saraiyu · 03/06/2010, 19:05

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!

Knight^Hawk · 03/06/2010, 20:08

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.

Saraiyu · 03/06/2010, 20:09

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

King_Arthur · 03/06/2010, 22:24

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.

Saraiyu · 03/06/2010, 22:40

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

ChaoseOnline · 03/12/2010, 07:53

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.