[help] Orb Composing

[djlooki]

Hi again.

So, lately orb composing is not working, a quick search revealed that its due to the fact that pets need to be in a certain range of IDs, ok so far, I changed the initial start to 2000000000, re-imported all the content of cq_eudemon and orb composing is working again but F1 and F3 skillbar got empty, although I still have my skills learned and I can put them back in shortcut, no major problem here.

Problem:
Pets loose their skills, gifts are ok though.

Anyone has a solution to this?

Thanks a lot

[no_1]

you forgot to change the owner id in the cq_magic table.
this must be the same *** the pets id.
So if you changed the pets id you must change this also.
Gift are given inside cq_eudemon table so they are not affected.

[djlooki]

I see yes, you are correct, but since all the id are changed from cq_eudemon table how will it match the ones in cq_magic since there are lots of pets? Is there something like LEFT JOIN query need to be done for that or will the ids be the same just by doing the same in this table?

[no_1]

i'm not that good with mysql querys. but i don't know what you did to the ids.
but if you don't know how to use a query for it i suggest you copy all the values of the pets into exel or something change the values and put them back.

[djlooki]

Originally Posted by no_1

i'm not that good with mysql querys. but i don't know what you did to the ids.
but if you don't know how to use a query for it i suggest you copy all the values of the pets into exel or something change the values and put them back.

Is quite simple, let me tell you what I did:

1. Export cq_eudemon table, except id part, since its the one causing the orb composing not working.

2. Empty cq_eudemon table

3. Design cq_eudemon table and set increment option to 2000000000

4. Import back the file from step 1.

Orb Composing is now working correctly.

As I said however, skillbar shortcuts, 2 of them get empty, but I still have the skills so I can put them back, its ok.

Pets do lose their skills however because as u said they don't match anymore because of cq_eudemon changes.

What is tricky here, is that if you have lets say 1k pets as example, you will need to change each id one by one, which is tedious and I don't see another way of doing it. That's my main concern.

Although once in game if you compose your pet once it will get back the initial skills, and you can teach it again the skills for its class, so its working yes, I'm just curious if there is a way to make cq_magic match the new cq_eudemon after the changes made to it to fix orb composing.

Hope that was a clear explanation