help with my private server

I got my private server running... I only need to do a few things... I need help with it too.

How do I edit:

The exp you get from mobs
The drops
The spawn times

hello russo :)

Cant remember how to do exp or spawn times..but ill keep searching for that.

For the drops though this is a little tricky. First go to the Game_Defs database then go to Items, right click>open table. Then go to the mobs table and do the same. Next locate the Grade of the item you want dropping, note this number down. Next go to your mobs table you opened and locate the grade coloumn. Enter the grade you noted down and save the table. Now the items should be dropping :)

To edit exp open the Server mgr under the gamegroups section right click Game click on commands then write /exp2xenable (the exp rate you want) without the brackets then press enter

Also a very simple way to adjust Game Define multipliers is to open the Stored Procedure find the Column in the SELECT statement for example [Exp] (Experience Points) -

SELECT .. , [Exp], ...

change the column to be something like:
SELECT .. , CONVERT(INT, ([Exp] * 2)) [Exp], ...

Which would effectively double the XP. However if the result is larger than the max data type value you would need to use something like a CASE statement to handle overflows see:
[Only registered and activated users can see links. Click Here To Register...]