[HELP] Starts going down when using Thunder.

08/13/2011 10:42 mama12#1
Hello. I used search, but ony things that are related to thunder problems involve look face change.

My problem is when I use thunder juice, pets stars drop if eudemons is composed over 4 times and raise like 3* if used after first compose.
Where do I even look to fix the problem?

I dont have over 100* server, it is just basic maniquin server. I added a pet, but used a query from a different pet, just changed the neccessary fields.

This are the ids i used.
729435 - egg in the backpack
1081780
1071780 - 0 evolution
1071781 - 1st evolution
1071782 - 2nd evolution

Thanks guys. Really appreciate the help.
08/13/2011 11:00 Marcus*#2
[Only registered and activated users can see links. Click Here To Register...]
08/13/2011 11:10 mama12#3
Marcus thanks, but i saw that threat. <---that is not the issue with my pets

After rewriting the query and comparing each table to the other pets in the server, I found the solution:

1. Go to cq_grade
2. Find thunder IDS of the pet that was added.
3. Go to damage type.
4. Make sure it said 100 in that column for all 3 thunder IDS.

Example:
ID dmg_type
1079782 100
1079781 100
1079780 100
08/14/2011 02:54 XxFearReaperXx#4
Marc is right mama12 it is the problem your having.
Add
Code:
update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1071999;
update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1071999;
Add that as a query to run every 10 to 15 minutes or as desired that will auto thunder the pets giving required star rank and no pet transformations. unfortunately you cant add more then 100 pets with out having that problem
08/14/2011 02:56 mama12#5
Quote:
Originally Posted by XxFearReaperXx View Post
Marc is right mama12 it is the problem your having.
Add
Code:
update cq_eudemon set item_type = item_type + 4000, damage_type = 5 where item_type < 1075999 and magic_defence > 1071999;
update cq_eudemon set item_type = item_type - 3000 where item_type > 1077000 and magic_defence > 1071999;
Add that as a query to run every 10 to 15 minutes or as desired that will auto thunder the pets giving required star rank and no pet transformations. unfortunately you cant add more then 100 pets with out having that problem
No. that was not the problem. I got it to work - i wrote it in blue.

Thanks.