Changing Exp in sql

[mirlin6]

i want to change exp in my database so that it will make the rest of the exp for my server ive set it to 20 in kaori cript but my servers exp is 256 so need to put 56 in sql but not sure how to do it anyone tell me how it done i know its something to do with running a query but not sure what to do next

Thanks
mirlin6

 

[Kaori]

http://www.lomcn.co.uk/forum/showthread.php?p=146989#post146989

 

[mirlin6]

not working :S

 

[MasterQ]

Open Query on monster database.

You have to type
UPDATE [dbo].[HL_Monster] SET Exp=Exp*2

That would times the exp by two.
After you type in in right click the background at click Run. Then scroll down to the bottom of the mob table.

 

[mirlin6]

thanks master worked now