You can eother do it manualy per mob in dbo.mobs via money1 and money2 or the easier way is to find the procedure (forget which hence Im not at my server) and add the "*1.2" or something similiar to it and execute. Possum wrote in e*pvp how to do but it was a little unclear. If you rightclick on gamedata and look at "dependencies" you can get a list of all procedures writing to it.
From the read Mobs stored procedure you can slightly increase the gold rates.
Money1 is the base gold drop rate, Money2 is the random range.
Say the SP (Stored Proc) has "..., Money1, Money2, ..." etc you can double the base by doing "..., Money1 (Money1 * 2), Money2, ...".
Take note that some values are high and increasing them will cause an overflow error. Then you will need to use a switch statement to take into account overflow errors.
Code:
...,
(
CASE
WHEN (Money1 * 2) > 32767 THEN 32767
ELSE (Money1 * 2)
END
) AS Money1,
...
You could make it so all Mobs drop 65,534k each time. Put high gold-rate drops is a bad idea. From our observations any more even 7x gold drop multipliers with Evo as the total Gold Player Reserves was steadily increasing which is a very bad thing despite the extra Gold Sinks we used. 5x is a nice amount I guess but even then I would recommend adding more/larger gold sinks from the default in order to take gold out of the game.
From the read Mobs stored procedure you can slightly increase the gold rates.
Money1 is the base gold drop rate, Money2 is the random range.
Say the SP (Stored Proc) has "..., Money1, Money2, ..." etc you can double the base by doing "..., Money1 (Money1 * 2), Money2, ...".
Take note that some values are high and increasing them will cause an overflow error. Then you will need to use a switch statement to take into account overflow errors.
Code:
...,
(
CASE
WHEN (Money1 * 2) > 32767 THEN 32767
ELSE (Money1 * 2)
END
) AS Money1,
...
Dependemces was just so you know what procedures write to the table. You actualy have to go into the procedure as possum described here to make the altercations. "Read Mob stored procedure".
I know I am probably going to get probably a few people saying I'm rude but I believe in being up-front and questions seem to be going in a circle and people asking the same questions over and over again.
Your trying to get running and manage, and even customize a fairly complex Database structure without doing enough basic tutorials in learning the SQL language.
Whenever you want to make some customizations or apply fixes on the database side it often requires changes to the stored procedures, and perhaps even the Table structures (Not referring to the data records here).
Rather than trying to learn from a complex DB like a private Server I suggest you start with the basics and work from the bottom up.
My Recommendations:
Step1. Learn the basic SQL syntax. Learn how to write SELECT, UPDATE, and DELETE statements from your memory. The EXECUTE command is very useful here too.
ref:
Step2. Learn about Creating/Modifying Table Structures. You will pass this hurdle when you have a good idea on how to create, and modify tables and what different data-types there are and perhaps some of the MIN, MAX ranges, and a rough understanding of Primary and Foreign Keys (Shaiya pServers do not use PKs,FKs much, not in MSSQL's native way at least anyway).
Step3. Learn about creating Stored Procedures and User Custom Functions. You will pass this when you can comfortably program a Stored-Procedure to implement a piece of business Logic that you want to do from Scratch. You will also be comfortable in Modify pre-existing SP's.
Final Note:
Google has a multitude of resources. Granted I did learn some SQL in a business Environment for a year or so but the majority of my learning and experience came from Internet Resources, and the most important "Practising" what you are doing. This knowledge you can directly apply to pServers and not just Shaiya, almost all MMO's use DB's, this forum uses a DB, they are all over the Web, in finance, business, nearly everywhere where organised data storage has become a necessity. And the beauty of this gained knowledge is the syntax hasn't changed in a large number of years once you learn it's like riding a bike and I would almost consider it an essential skill in Computing.
Golddrop bot 07/17/2010 - Last Chaos - 9 Replies Gibt es ein bot für LastChaos ger wo man z.B 1xx mal 1k Gold aus dem eigenen Inventar fallen lässt und das blitzschnell ???
wenn ja bitte einen Link ^^
Golddrop
