-
Active Member
Originally Posted by
ponchifek
I have several questions about this repack:
1) I'd like to complete a dungeon and get all its loot from bosses. Can I somehow increase drop rate to 100% only for them?
2) How can I get honor and arena points to buy pvp gear?
Install an SQL manager like DBeaver or HeidiSQL and you can find the item loot list in 'item_loot_template' and set the drop chance for the item
And by get do you mean earn or give yourself with gm command?
GM commands would be .honor add and .modify arenapoints
List of GM Commands
Last edited by skuly; 08-20-2021 at 10:06 AM.
-
Post Thanks / Like - 1 Thanks
ponchifek (1 members gave Thanks to skuly for this useful post)
-
Member
Thanks for your answer.
Install an SQL manager like DBeaver or HeidiSQL and you can find the item loot list in 'item_loot_template' and set the drop chance for the item
Will items id from wotlkdb.com work?
And by get do you mean earn or give yourself with gm command?
I meant earn. Is there any in-game mechanic in this repack for earning them? I know about killing guards, but what about arena points? If there isn't, I will do it using GM commands, thanks for recommendation.
And I have another question: can I change in-game date?
-
Active Member
Originally Posted by
ponchifek
Thanks for your answer.
Will items id from wotlkdb.com work?
I meant earn. Is there any in-game mechanic in this repack for earning them? I know about killing guards, but what about arena points? If there isn't, I will do it using GM commands, thanks for recommendation.
And I have another question: can I change in-game date?
Yeah wotlkdb has id's
Also I just made an Eluna script for you.
This script will give 100 honor and Arenapoints when you kill a boss. It actually gives it to everyone in your party.
I got a list of ID's from the database Creature template and Trinitycore Wiki says rank 3 is bosses so I exported a list of bosses using DBeaver and used this ID's in the Script.
Imgur: The magic of the Internet
Last edited by skuly; 08-20-2021 at 12:04 PM.
-
Post Thanks / Like - 1 Thanks
ponchifek (1 members gave Thanks to skuly for this useful post)
-
Active Member
I can make a short video of a trick I use to make a table of ID's quick and easy instead of having to manually get a list from wotlkdb
EDIT, here is a new link to the eluna script. I realized when I exported the list of Boss ID's from Database I didn't scroll all the way down to get the full list.
https://mega.nz/file/nxhlACqT#bVXULJ...FIlVwtWKe-9SSw
Last edited by skuly; 08-20-2021 at 11:59 AM.
-
Post Thanks / Like - 1 Thanks
ponchifek (1 members gave Thanks to skuly for this useful post)
-
Member
I'm not sure if this is something you are able to fix or if the trinitycore devs need to, but for this repack the Warrior's Charge and the Druid's Charge spell isn't functioning properly. When you charge a target, they are stunned, but you don't launch an auto attack. Its like the command to do so gets overlooked.
[3.3.5a]Druid feral charge (bear) resetting auto attacks . Issue #24626 . TrinityCore/TrinityCore . GitHub
I found it on github, but no one has been able to fix it. I was wondering if you had some knowledge of the issue, or a way to patch it for this repack if possible. Thank you again for update 7.
-
Member
Originally Posted by
skuly
Yeah wotlkdb has id's
Also I just made an Eluna script for you.
This script will give 100 honor and Arenapoints when you kill a boss.
I got a list of ID's from the database Creature template and
Trinitycore Wiki says rank 3 is bosses so I exported a list of bosses using DBeaver and used this ID's in the Script.
Imgur: The magic of the Internet

Originally Posted by
skuly
I can make a short video of a trick I use to make a table of ID's quick and easy instead of having to manually get a list from wotlkdb
EDIT, here is a new link to the eluna script. I realized when I exported the list of Boss ID's from Database I didn't scroll all the way down to get the full list.
https://mega.nz/file/nxhlACqT#bVXULJ...FIlVwtWKe-9SSw
Thank you for the script and for the video! What about changing date? Is it possible?
-
Active Member
Originally Posted by
ponchifek
Thank you for the script and for the video! What about changing date? Is it possible?
Change what date?
-
Post Thanks / Like - 1 Thanks
ponchifek (1 members gave Thanks to skuly for this useful post)
-
Active Member
Originally Posted by
swampus
I'm not sure if this is something you are able to fix or if the trinitycore devs need to, but for this repack the Warrior's Charge and the Druid's Charge spell isn't functioning properly. When you charge a target, they are stunned, but you don't launch an auto attack. Its like the command to do so gets overlooked.
[3.3.5a]Druid feral charge (bear) resetting auto attacks . Issue #24626 . TrinityCore/TrinityCore . GitHub
I found it on github, but no one has been able to fix it. I was wondering if you had some knowledge of the issue, or a way to patch it for this repack if possible. Thank you again for update 7.
If you are using my update7 try this worldserver.exe I just compiled https://mega.nz/file/jwIClZAK#lLss6p...Cywo4tOx3Ivwp0
It's kind of a hack I figured out but I am not sure if it will break something.
Basically I stopped the player from entering UNIT_STATE_CHARGING, I guess going to that state makes auto attack unusable for a few seconds. My hack should only effect players and not NPC's that charge.
I am not sure of the purpose of UNIT_STATE_CHARGING or even where to find it in the sourcecode all I could find was that when a player charges UNIT_STATE_CHARGING gets applied to them so I made it not get applied and it fixed the problem.
Maybe UNIT_STATE_CHARGING has some purpose and my hack will cause some problem elsewhere idk .
Last edited by skuly; 08-20-2021 at 02:23 PM.
-
Post Thanks / Like - 1 Thanks
swampus (1 members gave Thanks to skuly for this useful post)
-
Member
Originally Posted by
skuly
You actually fixed it in like 2 hours, you seriously know your stuff. I should have asked you sooner. Thank you for this!
-
Member
Originally Posted by
skuly
Change what date?
Changing in-game date. To January 1, for example. I want to trigger holiday events.
-
Active Member
Originally Posted by
ponchifek
Changing in-game date. To January 1, for example. I want to trigger holiday events.
Gm commands GM Commands - TrinityCore - TrinityCore Collaboration Platform
There is the commant .event start/stop
Holidays - World Events - WotLK Database 3.3.5a
And in the world database game_event there is a list of events.
So I assume .event start 7 would start the Lunar Festival
Last edited by skuly; 08-20-2021 at 11:31 PM.
-
Post Thanks / Like - 1 Thanks
ponchifek (1 members gave Thanks to skuly for this useful post)
-
Active Member
I made a script that auto revives a player to where they died right after they release, It's set to only do it until level 30. And it shouldn't do it when you were in a dungeon/bg or when you have pvp on.
When the player revives they have an immunity buff and rezz sickness for 45 seconds so they have a chance to run away if they need.
I doubt anyone is interested but I figured I'd share it. https://mega.nz/file/PxRjRKyY#MY8LCC...FC-mLzJpBZSVxU
Last edited by skuly; 08-22-2021 at 06:16 AM.
-
Member
First off, my thanks to everyone contributing to this repack. I've been enjoying it, as the npcbots make playing solo a lot of fun. I have a question also if I may. Is there any sort of enchanting npc in this release? I havent been able to locate one, or even find one to spawn in. I know its quite possible I've simply overlooked it, as its a big game after all.
Originally Posted by
swampus
The only thing I am wondering now, is there anything similar to the all race/all class patch for azerothcore for this version of trinity that anyone knows of?
I know this question was posted a while back and you may have located such files by yourself by now, but i'm new to this repack and thread, so I thought I'd post a link to the ARAC I'm currently using in case anyone else was interested. I've added it to my database with zero errors, and have been enjoying it for a while now with no known issues. As always everyone's experience may differ, so be sure to make a backup before you start in case something doesn't work for you.
1. Download and use the world.sql posted by leechking at the bottom of the following link. You will also need to create a couple of sql files so you can run the two fixes he has posted, ie the undead paladin weapon skill, and the bugged quest fix.
[TrinityCore] All Race All Class [3.3.5a] - Page 15
2. Download the azerothcore ARAC mod from the following link and ONLY (I will say it again) ONLY use the Patch-A.MPQ file from that release.
GitHub - azerothcore/mod-arac: Module & pacthes - "All Classes All Races (ARAC)"
-
Active Member
Originally Posted by
anwe
Is there any sort of enchanting npc in this release? I havent been able to locate one, or even find one to spawn in. I know its quite possible I've simply overlooked it, as its a big game after all.
]
NPC ID's
Enchanter = 96001
Profession = 96005
Template NPC ID = 55002
1v1Arena NPC ID = 190001
Reforger NPC ID = 190011
-
Member