Change Mineral ammount when mining.

5 posts

1. CopperM0E
   
   Member
   Joined: Aug '08
   Posts: 24

   Okay, I'm still a 'noob'. so what file needs to be changed and what program do I need to do it? OR.. do I have the program, but not the filename?

   Posted 1 year ago » Permalink

2. BmmB
   
   Regular
   Joined: Feb '08
   Posts: 141

   Here's a hint how I think it should be done...
   Note: maybe some tables' names were changed since I haven't played (therefore updated mangos) recently.

   Program: You'll need a MySQL manager/editor
   Files: gameobject_template and gameobject_loot_template tables and maybe item_template table, too, all in the mangos database.

   1. open gameobject_template table; find all entries with type=3 (those are either mineral veins or various types of chests, boxes etc.); if name conatains 'vein' or mineral name that means that's a mineral vein (not being sarcastic, just trying to point you in the right direction - how to easily make a query or find manually what you need); in data1 column/field is the entry number in gameobject_loot_template table of the item (e.g. mineral ore) contained in that vein
   2. open gameobject_loot_template table and find entry by the number from previous step; usually there will be many items with the same entry number, you'll need to find appropriate one -> look at the item field (there is a number which represents entry number in item_template table of the item in that loot template) and look for that entry number in item_template table -> do this until you find appropriate mineral ore in the item_template table, then in gameobject_loot_template table change the mincount and maxcount numbers of appropriate loot template to suit your needs -> note: should be mincount <= maxcount, e.g. mincount=5 and maxcount=7.

   Regards...

   Posted 1 year ago » Permalink

3. Aznex
   
   Member
   Joined: Jan '08
   Posts: 24

   or do it the easy way and go into your mangosd.conf file and look for:
   Rate.Mining.Amount = 1
   Rate.Mining.Next = 1
   and change those:p

   Let's say from a normal vein you would get 1 ore each time u loot
   if u change this Rate.Mining.Amount to 2 u would get 2 ores each time u loot

   Posted 1 year ago » Permalink

4. BmmB
   
   Regular
   Joined: Feb '08
   Posts: 141

   Yay, I completely forgot about being possible to do that in mangos configuration file. Thanks Aznex for reminding me and saving CopperM0E mizzeries

   Posted 1 year ago » Permalink

5. CopperM0E
   
   Member
   Joined: Aug '08
   Posts: 24

   Hmm.. actually I've allready taken the liberty of modifying the mangos config file and all that does is allow you to mine from the same ore 'X' times...which is fine... really, but the other way, editing the database, seems to be a more permanent way to fix it, albeit a troublesome one. and the player can get 5X the ore in one swipe instead of 5...that was my point...Thank you both for your suggestions, at least I have two options now...and bugs to fix, so maybe getting into the database editing part this way would be..a...umm...'beginners step' to fixing bigger, nastier things.

   Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.