Question

Hey i was wondering what is the stored procedure or a query to run to edit Exp in gamedefs. I tried to half the exp and it made all the exp values 1 lol Not exactly what i wanted seen as anyone can get to 60 by just killing a monkey :)

Quote:

Originally Posted by whiteyadam Hey i was wondering what is the stored procedure or a query to run to edit Exp in gamedefs. I tried to half the exp and it made all the exp values 1 lol Not exactly what i wanted seen as anyone can get to 60 by just killing a monkey :)

I forget off the top of my head which one it was.. it buried in my queries atm on the PC.. but if you run across the right 1.. (little bit of looking in procedures) just put a multiplier after em.. ex. *1.2 or *2 and execute.

Possum explained once or twice how to do it. Probly can dig up his post via profile.

~Phish

Thanks alot ill try it out :)

hmm you should just be able to edit them to the values you want, ive tried this on a different server and it worked perfectly for us.. so just try and edit them manually :P

Quote:

Originally Posted by adamkoolkid2 hmm you should just be able to edit them to the values you want, ive tried this on a different server and it worked perfectly for us.. so just try and edit them manually :P

Lol thats the long way round and i need to learn more about SQL queries and stored procedures to be able to run a succesful server haha thanks for the input

ahh i see well np if u dont find a solution u can always use the long way round lol :P

UPDATE PS_GameDefs.dbo.ExpDefs SET Exp=Exp/2 ....

Thanks prof that worked :)