Mulderdev Beekeeping & Brewing System V4.0.0

A complete RedM/VORP beekeeping and brewing resource with placeable hives, wild hives, queen management, flower field bonuses, time-based brewing, persistent props, and the new V4 hive upgrade system.

Built for roleplay servers that want a deeper economy loop around honey, beeswax, queens, mead, drinks, medicine, and player-owned production.

---

What's New in V4.0.0

Hive Upgrade System

Players can now upgrade each placed beehive directly from the hive menu.

Each hive stores its own upgrade levels, and upgrades stay saved when the hive is picked up and placed again.

| Upgrade | Effect |

|---|---|

| **Reinforced Frame** | Reduces hive health loss when harvesting |

| **Protective Net** | Reduces the final bee sting chance |

| **Large Brood Box** | Adds bonus honeycomb yield |

| **Feeder Chamber** | Reduces food consumption when harvesting boosted hives |

Default upgrade values:

| Upgrade | Level 1 | Level 2 | Level 3 |

|---|---:|---:|---:|

| **Reinforced Frame** | 20% less health loss | 35% less health loss | 50% less health loss |

| **Protective Net** | 10% lower sting chance | 20% lower sting chance | 35% lower sting chance |

| **Large Brood Box** | +1 honeycomb | +2 honeycomb | +3 honeycomb |

| **Feeder Chamber** | 15% less food consumed | 30% less food consumed | 50% less food consumed |

Upgrade effects and material costs are fully configurable in `Config.HiveUpgrades`.

Improved Hive UI

- Wider hive menu layout for the new upgrade system

- Upgrade levels are visible in the menu

- Required upgrade materials are shown before upgrading

- Upgrade effects are displayed directly in the NUI

- Queen status, queen lifetime, flower field bonus, hive health, food, and harvest progress are still included

Stability, Security & Config Cleanup

- Consolidated all SQL setup into one file: `sql.sql`

- Removed old duplicate SQL files

- Added startup config validation warnings

- Added server-side distance checks for sensitive actions

- Added optional owner protection for hive and barrel actions

- Added optional max hive and barrel limits per player

- Improved protection against invalid wild hive interactions

- Improved protection against duplicate brewing starts

- Stabilized queen expiry checks

- Added missing locale keys

---

Beekeeping Features

Placeable Beehives

Players can place their own beehives with the configured hive item.

Placed hives are persistent and reload after a resource or server restart.

Bee Queen System

Beehives require a Bee Queen before they can produce honey.

- Hives start inactive without a queen

- Players can install a queen from the hive menu

- Queens have a configurable lifetime

- Expired queens must be replaced

- Picking up a hive returns the queen item to the player when possible

Wild Beehives

Wild hives spawn at configurable locations and use native hornet nest props.

- Configurable wild hive locations

- Configurable cooldown per player

- Higher sting risk than owned hives

- Lower honey yield than owned hives

- Chance to find a Bee Queen while harvesting

- Bee swarm particle effects

- Beekeeper hat protection also works on wild hives

Flower Field Bonus

Beehives placed near configured flower fields can produce more honey.

- Configurable field locations

- Configurable radius and falloff distance

- Honey multiplier scales by distance

- The hive menu shows the nearest field and current multiplier

Hive Maintenance

Hives are not just static props. They need maintenance.

- Hive health can decrease during harvesting

- Players can repair hives with configured materials

- Bees can be fed with sugar water to boost production

- Upgrade effects can reduce health loss and food consumption

Risk & Immersion

- Chance to get stung when harvesting

- Beekeeper hat reduces risk

- Stings can trigger stumble/ragdoll effects

- Optional bear attack chance while harvesting

- Harvesting animations and prop interactions included

- Beeswax can be harvested as a byproduct

---

Brewing Features

Placeable Brewing Barrels

Players can place brewing barrels and create drinks, medicine, and roleplay economy items.

Time-Based Quality System

Brewing quality depends on when the finished brew is collected.

| Time After Ready | Quality | Yield Multiplier |

|---|---|---:|

| 0-1 min | Normal | 1.0x |

| 1-2 min | Fine | 1.5x |

| 2-3 min | Excellent | 2.0x |

| After overcook time | Overcooked | 0.5x |

Included Recipe Categories

- Alcohol

- Juices

- Medicine

Included Recipes

- Mead

- Beer

- Whiskey

- Apple Juice

- Berry Juice

- Herbal Tonic

- Stamina Brew

Barrel Ownership

- Optional owner-only brewing

- Optional theft system for finished brews

- Inventory safety checks to prevent ingredient loss

- Quality metadata is visible on produced items

---

NUI Features

- Western black and gold styled interface

- Hive menu with honeycomb progress

- Queen status badge

- Install Queen button

- Queen lifetime bar

- Flower field proximity bar

- Upgrade section with levels, effects, and material costs

- Brewing menu with recipe categories

- Live brewing timers

- Quality tier display

---

Technical Features

- Persistent hives and barrels

- Resource restart reload support

- Admin reload command: `/bkreload`

- Player placement reset command: `/resetplacement`

- Optimized idle and nearby prop logic

- German and English locale support

- Configurable item names, props, recipes, cooldowns, risks, limits, and upgrade values

- Server-side validation for important actions

- SQL setup consolidated into one file

---

Configuration Highlights

Server owners can customize the system through `config.lua`.

Important V4 config sections:

| Config Section | Description |

|---|---|

| `Config.HiveUpgrades` | Enable upgrades, set upgrade strength, and define material costs |

| `Config.Security` | Owner checks, distance checks, and startup config validation |

| `Config.Limits` | Optional max hives and barrels per player |

| `Config.Beekeeping` | Hive item, queen item, cooldowns, honey yield, sting chance, queen lifetime |

| `Config.WildHives` | Wild hive locations, cooldown, yield, sting chance, queen chance |

| `Config.FlowerFields` | Flower field locations, radius, multiplier, and falloff |

| `Config.Brewing` | Recipes, ownership, theft, quality timing, and overcook behavior |

---

SQL / Update Notes

V4.0.0 uses only one SQL file:

`sql.sql`

For a fresh install, run **Section A**.

For updating from an older version, run **Section B**.

V4.0.0 adds these hive upgrade columns:

- `upgrade_frame`

- `upgrade_net`

- `upgrade_brood`

- `upgrade_feeder`

Old SQL files such as `sql_install.sql`, `sql_migration.sql`, and `sql_update.sql` are no longer used.

---

Compatibility

| Requirement | Status |

|---|---|

| Game | RedM |

| Framework | VORP Core |

| Inventory | VORP Inventory |

| Database | oxmysql |

| Menu | VORP Menu |

| Standalone | No |

---

Summary

Mulderdev Beekeeping & Brewing V4.0.0 expands the script from a simple production resource into a deeper server economy system.

Players can place and maintain hives, install queens, hunt for wild hives, benefit from flower fields, upgrade their hives, produce honey and wax, and use the brewing system to craft drinks and medicine with time-based quality.

For server owners, V4.0.0 also adds cleaner SQL, stronger validation, safer server-side checks, configurable upgrade balancing, and more control over ownership and player limits.