[WotLk] Limits? trinitycore 3.3.5a

[jasonvigo]

OK I've been trying to do some modding on my server but I've hit a wall. i think it's because I'm using trinity-core repack but I'm not sure since what i want to edit isn't that complicated.

The three things I'm trying to mod are:
Add stats to bags
Change 2 Talent  spells
boost hit to some items.

Bags:
          Just trying to add some minor stats to bags such as some haste or defense rating . just to make it easier for players to take on some raids since this is a low pop server and getting groups together can be a pain.

Talent:
           Two talents I want to change are Nerves of cold steel and threat of thassarian. I want both of them to affect Two handed weapons as i have given chars the ability to learn a lesser form of Titan grip

Hit:
      Just want to boost some of the hit on some items.

I've been trying to follow some guides to adjust these values but when ever i go into my SQL data base and try to pull up the items by ID they don't show, i only see a very small selection of items/spells in the lists. all the guides tell me to look in Item_template and spell_dbc. I know the items are in the game because players have them but i don't see them when i look in my SQL data base.

I think it's because I'm using trinity core rather then compiling my own. reason for this is i don't have alot of time to redo the scripting to make sure instances and raids are working. other then the modding this version is working perfectly.

So is this a limitation I'm going to face using this kind of server. i have about 15 or so people playing locally and if i have to recompile a new server. I'm afraid raids and dungeons wont work and that players will have to start over from scratch.

[guard90]

first add bag stats
in item_template go to bag entry next if you want to add 2 stats set statcount 2 next go to stat_type1 and  set 45 for spell power next in stat_value1 set value (but in repack max is 32767 for more compile new core) next stat_type2 set 30 for spell haste
and value in stat_value2 maxstatcount  is 10 and if stat are not showing in game delete cache
you can find stat type in itemtemplate.h in google
Second for spell you need to modify Spell.dbc and create custom patch
and Third for hit you can add stat mele rating  or modify delay in item_template

[Amaroth]

Your problems have absolutely nothing to do with the fact that you are using a repack. I'd suggest you to look at some MySQL guides and to some guides for MySQL editor you are using. Tables like item_template contain dozens of thousands of rows and of course, MySQL server won't show you all of them at once, that would be huge slap across performance. You need to specify which entries you want to browse by setting limits and/or filters and/or sorts. If you have absolutely no clue wth am I talking about, like I said, take a look at some MySQL tutorials (not here, I mean, MySQL in general) first and when you can perform some basic DB tasks, you won't have problems like this.

About database stuff:
1. open https://trinitycore.atlassian.net/wiki
2. enter table name into search window
3. open your table's documenttion to see, what is there for what. You should be able to figure out pretty much on your own with this documentation.

For DBCs, the same, just different wiki:
https://wowdev.wiki/Main_Page

How to create a custom patch and edit DBCs and stuff like that is all described in getting started tutorials:
viewforum.php?f=78
http://www.model-changing.net/tutorials ... -beginner/


I could describe to you just to make particular things you want to do happen, but that wouldn't teach you anything and you would be left unable to perform another tasks on your own. Which is why I've pretty much thrown a documentation and set of tutorials and guides on you. If you have any questions, feel free to ask them though.