exp rate for pets

Page 1 of 2 1 2
08/19/2011 22:02 xxmarktxx#1
hi every one

this is my first topic

how i can change the exp rate for pets so thats the pets in the server can lvl fastly
08/19/2011 22:14 Limery#2
Search button.
08/19/2011 22:43 Ranma014#3
As far as its known, pet exp gain has a hard coded limit.
What I did was raise the exp % bonus of the skill "Creature Breeding" for breeder classes. I am not sure if this will work. I use it with a relatively low exp rate and it works just fine, but I didnt encounter that hardcoded limit yet, since I am not playing high rates.
08/19/2011 23:43 HeavenOnlyWishes#4
Now your just affecting a single class, since not all classes have creature breeding. Instead you should change the experience tables for pets in the database. For instance if you want pets to gain 20% exp instead of the normal 10% then take 20% of the current rates off of each. Etc. That is the simplest way to effectively change the rates at the moment.
08/20/2011 00:45 ironhammer500#5
Quote:
Originally Posted by HeavenOnlyWishes View Post
Now your just affecting a single class, since not all classes have creature breeding. Instead you should change the experience tables for pets in the database. For instance if you want pets to gain 20% exp instead of the normal 10% then take 20% of the current rates off of each. Etc. That is the simplest way to effectively change the rates at the moment.
Yes correct this was stated on arcadia to by speedy =)

and i gave a query which is here

Code:
UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] / 2
GO

This will lower pet exp by 50%
08/20/2011 14:13 Crestyx#6
Code:
UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] * 2
GO
it will give +50% 0.0???
08/20/2011 22:07 SilentBill#7
What?
No, it will take 2x as much exp to level.
08/20/2011 22:14 ironhammer500#8
Quote:
Originally Posted by Crestyx View Post
Code:
UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] * 2
GO
it will give +50% 0.0???
Quote:
Originally Posted by SilentBill View Post
What?
No, it will take 2x as much exp to level.
he used a star which will multiply in a mssql query i used the forward slash which divdes the values

Code:
UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] / 2
GO
THIS LOWERS IT TO HALF! plz read it properly.

Code:
UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] * 1.5
GO
This will raise the amount needed to lv pets by 50%
08/20/2011 23:04 HeavenOnlyWishes#9
Thank you Iron, I wasn't sure if you would post your query on here or not and I wasn't going to post it since you had already made one on the forums. It'd be like copying.

But yes please pay close attention to your signs. * Mulitplies, / Divides, + Adds, and - Subtracts.... You could even do some fun advanced equations like:
SET normal_exp = normal_exp*((normal_exp / 2) + (58-36^87))
and see what you get.... lol ;)

In any case, this is the best method at the moment. And don't forget you can use decimals.
08/20/2011 23:46 ironhammer500#10
To be honest i dont mind if ppl use my querys aslong as it helps im happy, as well i use google to find most querys when i get stuck =)

Plus i havnt used this tho anyways ty for updating it ^^
08/23/2011 06:29 StCloud#11
i cant get any of these queries to work... perphaps they should be tested first.
08/23/2011 07:25 SilentBill#12
They have been. It's pretty damn basic SQL.
Honestly, if you can't get this query to work, you might want to leave the private servering to the big boys.
On that note, messing with the exp table will bork how the client displays experience for them. You'll see that you have negative experience which only gets more and more negative as you continue leveling. The pet will still level normally, and it will take less experience to level. And you can check out how much exp your pet has in the database, but I found it a little too annoying not to be able to check my progress in-game.
08/23/2011 12:07 SilentBill#13
Quote:
Originally Posted by speedy-nl
for the -xp just set the max lv170 xp back when you alter the xp table
when pet hit max level the -xp will adjust itself then
To be honest I would have never thought of that. Makes a Korean Dev twisted sort of sense though. I'll give it a try.
Quote:
Originally Posted by speedy-nl
its peeps there own fault that a pet lag behind, playing with 500x xp or even more make your toon gaining ? levels in 1 kill but the pet gain only ?? (max) xp

but best solution just leave the xp table alone, dont get higher then 30x xp
use ac so pet get max xp and keep close to player lv

peeps demand just to much from pservers, you now more rooms. to low xp, drop sucks, ect, want it better just play on your own pserver and use the settings you want
I have to agree, I do play on my own lonely, lagless server, and I only ran into this when I was pushing the exp rates.
08/25/2011 22:53 StCloud#14
Quote:
Originally Posted by SilentBill View Post
They have been. It's pretty damn basic SQL.
Honestly, if you can't get this query to work, you might want to leave the private servering to the big boys.
On that note, messing with the exp table will bork how the client displays experience for them. You'll see that you have negative experience which only gets more and more negative as you continue leveling. The pet will still level normally, and it will take less experience to level. And you can check out how much exp your pet has in the database, but I found it a little too annoying not to be able to check my progress in-game.
I admit i am not a SQL Guru or a big boy like yourself.. but the reason i wasnt successful running the query its because the Statement was missing a letter

UPDATE [Arcadia].[dbo].[SummonLevelResouce]
SET [normal_exp] = [normal_exp] / 2
GO

I am pretty sure you will find what letter i am talking about..perhaps not since you assumed i was the error and not the Statement

[SummonLevelResource]

as i try , i noticed it takes half to level but pets will stop leveling fast after 60+ , 1. question , could you run the Statement twice and get results without errrors, like you run it once and the pet level faster, how about if you run it again??, i try and my pets will stop leveling and only get - exp point.
08/26/2011 00:29 ironhammer500#15
UPDATE [Arcadia].[dbo].[SummonLevelResource]
SET [normal_exp] = [normal_exp] / 2
GO


thx cloud for pointing out my typo sorry =(
Page 1 of 2 1 2