[Release] Item Creator, SQL generator

Ship it now, and let the players patch it.
Post Reply
Tenyar
Posts: 9
Been thanked: 3 times

[Release] Item Creator, SQL generator

Post by Tenyar » Tue Apr 29, 2025 3:52 pm

Hey everyone,

After a lot of long nights (and probably way too many energy drinks), I’m wanted to share the first compiled version of a project I’ve been working on: an Item Creation Tool for World of Warcraft!
UI is definitely NOT my strong suit. crying_turtle
Image

The program is fully GUI based and designed to make creating SQL entries for items way faster, easier, and more reliable — especially on cores like CMaNGOS, Trinity, exc.

Here’s what it can do right now:

[*]
  • Generate full SQL INSERT strings for item_template with just a few clicks.

    Fill in key fields like entry ID, item class, subclass, name, display ID, quality, vendor prices, stats, spells, requirements, and loot settings.

    Dropdowns and smart selectors for inventory types, spell triggers, and other option-heavy fields

    Possible to randomize vendor pricing.

    Handle optional fields like required skills, limited bag slots, and more.

    I wanted to make is as simple as possible, so all dropdowns and selections are readable, understandable text so you no longer have to look up anything manually or remember values.

    Export your SQL directly to a file, or copy it to clipboard.
The thing that really kicked off this project was all the other tools I tried to use either didn't work for my core, or had broken field values — so I made the SQL field names configurable.

If your server’s database expects displayID instead of display_id, or iTeMlEvEl instead of itemlevel, you can easily adjust the field names in the config file. No code editing necessary.

This is just version one, but the goal is to keep building on it: more complex item creation (random properties, better displayID selection, Better UI/UX etc.) is already on the roadmap. I'd also like to expand into a suite of these types of tools in the future; NPC creator, Spell creator. Maybe more?

Image
Image
Image
Race/Class bitmask are calculated automatically
Image
Image

Finally, just a small hint for those who like secrets:
Caution: certain words might open gates to mysterious pastures. 🐄
Good luck out there.

Let me know about any bugs or things to add!

Hope it helps with your projects — and if you'd like to support continued development (or say thanks for saving you some SQL headaches), you can do so here:

Tenyar
Posts: 9
Been thanked: 3 times

Re: [Release] Item Creator, SQL generator

Post by Tenyar » Fri May 09, 2025 8:17 pm

Wanted to give a quick update; While I realize this isn't super popular, I wanted to update with V1.1.0, moving to Github and away from a sketchy Mega link ;)

User avatar
Zvyrhol
Bug Report Enthusiast
Posts: 681
Has thanked: 242 times
Been thanked: 67 times

Re: [Release] Item Creator, SQL generator

Post by Zvyrhol » Sun May 11, 2025 11:12 am

Great tool.

basednoob
Barrens Chat Casualty
Posts: 100
Has thanked: 7 times
Been thanked: 10 times

Re: [Release] Item Creator, SQL generator

Post by basednoob » Sun May 11, 2025 5:13 pm

this is pretty cool. thank you for sharing. guessing it can't generate how a item will look like?

User avatar
Zeran
Barrens Chat Casualty
Posts: 155
Location: South Africa 🇿🇦
Has thanked: 5 times
Been thanked: 23 times
Contact:

Re: [Release] Item Creator, SQL generator

Post by Zeran » Mon May 12, 2025 7:34 am

You ever 'av dreams of da Empire of Zul, mon?

Da Zandali di'chuka!

Main Toon's Armoury: Jil'nei

Guild Leader of <Glorious Amani Tribe>

I have alts, too turtle_tongue

Tenyar
Posts: 9
Been thanked: 3 times

Re: [Release] Item Creator, SQL generator

Post by Tenyar » Fri May 16, 2025 11:23 am

basednoob wrote: Sun May 11, 2025 5:13 pm this is pretty cool. thank you for sharing. guessing it can't generate how a item will look like?
At the moment, the icon selection only selects the inventory icon, however you can still manually type in the displayID of a weapon/armor piece and use it's model. I'm still working on a clean or simple way to amend/package a custom display icon/model.
Zeran wrote: Mon May 12, 2025 7:34 am Is this similar to https://dev.turtle-wow.org/#!/home ?
Yes, it's similar, but more flexible in some ways, like if your core expects (extreme example) "dIsPlAy_iD" instead of displayID, you have complete control over those field names.

Post Reply