SQL table assistance... not a easy one

[weaselking1973]

okay, I have a bit of a tough one for ya all.

here is the short of it.

customized NPC - originaly enteryID 684 (panther) name and ID changed to this

creature_name

999999 Weasels Pet Pet Store 1 1 2 4 0 10711 633 0 0 0 1 1 0 0

customized NPC - originaly enteryID 684 (panther), minPH, maxHP, mana all changed to 900k only

creature_proto

999999 70 70 189 900000 900000 900000 1.5 0 1200 1500 1800 0 0 0 0 45490 0 0 45490 0 0 0 0 0 360000 0 50 50 50 50 50 50 2 1 0 0 0 0 0 4 10 20 0

no creaturespawntemplate to keep with these exact values for the spawn

creature spawns correctly, tame, feed to yellow level, stable then log out and mod the new pet

once tamed it trasferes to the pet template (which made the hp/mana value change worthless, when tamed it recalculates on a different table i havne't found yet)

so here is the playerpet

5 1 Kitty Meow Meow 999999 23 9 9 999999 1066817668 0 0 0 0 0 0 0 5 0 5 0 153 1 0 0 0 0 1596 0 0 100 0 807500 3952 0 0 100 0 1000000 70 4 33556480 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16529 15329 15329 1065353216 1073741824 633 633 0 1168924597 1168924597 0 0 1536 23 1194776749 0 77300 0 0 1065353216 0 0 0 2293760 128 64 0 32 45 0 0 0 0 0 0 0 0 0 0 128 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 900000 206849 2336 0 1065353216 0 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  0 1 70 807500 117440514,117440513,117440512,23148,14917,14918,14919,100663298,100663297,100663296, 7300 0 0 1800 87300

now the thing NOT seen is the memo data, which is one problem.

modified the above, and pet spawns tamed with normal stats.

it does not use the creature_name or creature_proto, and not even the creaturespawntemplate. BUT if you look at the memo you will see the stats to change the HP only value (that i have tested so far)

1 9 9 2163 1061599670 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 910 0 0 100 0 866500 910 0 0 100 0 1000000 26 4 33556480 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1880 0 0 1065353216 1065353216 1006 1006 0 1125946303 1125946303 0 0 1536 1 1194208064 0 9725 0 0 1065353216 0 0 0 2031616 60 36 0 24 29 0 0 0 0 0 0 0 0 0 0 72 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 910 206849 583 0 1065353216 0 0 1065353216 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

changing those red values set it to what ever you want it.

but now this is where i need help.

the values maintain untill you have any stat changing effect/skill/traning changes. once you do it drops the values, and recalculates.

so the question is this. what table is used for the calculations on pets? its not the creaturespawntemplate or the creature_proto, or creature_name..

need some help here

[777devil777]

I've used custom pets before and I've found they work with proto but I have had a couple repacks that bases all pets off a premade stats for every level. Try a diffrent repack I guess.

[weaselking1973]

newp, not switching DBs.. this is the most current one and its already got alot of hours of work into ti