Wise
20-04-13, 11:02 PM
Hi everyone,
I’ve created many SQL scripts that you can use on your Trinity 4.3.4 cores or repacks. Some of them are already posted by the trinity team. Some of them are still in review. And others will never be posted because they are not Blizzlike enough or they simply hack a quest so it can be completed.
The scripts were made for recent cores (2013-04-01) but probably could be used on older ones also. If you want to use many of them, you should run them in your world database in order. I use HeidiSQL to run the script in the world database but I guess other software could also do the trick.
Feel free to use them in any core or repack that you have and tell me if they work for you. Of course, I do not guarantee the results so it’s a good idea to do a backup of your world database before running them.
Script #1 – Main quest fix
This script fixes lots of quests everywhere but mostly in the Dun Morogh, Loch Modan, Wetlands, Arathi Highlands, The Hinterlands, Westfall, Dusk Woods, Winterspring, Tanaris and Ice Crown. Most of the fixes are legit but some of them simply hack the quest so it can be completed. More than half of those fixes are already posted or being reviewed by the trinity team.
Link: http://promiterra.iwebs.ws/scripts/1...34_SQL_fix.rar (http://promiterra.iwebs.ws/scripts/1_trinity_434_SQL_fix.rar)
Script #2 – Loot for all Cataclysm mobs
This one is huge. It’s a script that gives loot to all mobs for Cataclysm, which many of those don’t have in the latest trinity core. It’s currently being reviewed by the trinity team but since it’s so big it might take a lot of time for them to test it. It fixes tons of drop quests.
Link: http://promiterra.iwebs.ws/scripts/2...e_with_ref.rar (http://promiterra.iwebs.ws/scripts/2_creature_loot_template_with_ref.rar)
Script #3 – Fix all quest chains
This one is also pretty big. This script fixes all the quest chains from Cataclysm. This prevents a lot of “You don’t meet the requirement for this quest” errors. It recreates the quest chains based on wowhead data and gives a way better questing experience to your players. This script is also being reviewed by Trinity right now.
Link: http://promiterra.iwebs.ws/scripts/3...est_chains.rar (http://promiterra.iwebs.ws/scripts/3_all_quest_chains.rar)
Script #4 – Uldum
Uldum is an awesome zone in Cataclysm but it’s pretty bugged right now. This SQL script allows the player to do all the quests without error, some of them are simply hacked to be auto completed. This script also spawns all the missing NPCs that are managed by phases. It gives damage to all the mobs that didn’t do any damage before (The damage is probably not exact but it’s a start). It also allows you to complete the Lost City dungeon and the Halls of origination dungeon and do the quests in those dungeons. Since Uldum is the only zone that really works now for levels 80 to 84, I’ve reduced the quest requirement level to 80 so any players 80 and + can go there and do the quests. I’ve also added many obsidium mines everywhere in Uldum because none of them are spawned anywhere right now in 4.3.4. None of those fixes were sent to Trinity because they are not Blizzlike so you are the only ones to get them.
Link: http://promiterra.iwebs.ws/scripts/4_uldum.rar
Script #5 – Trinity forum fixes
Many fixes are posted on the trinity forums but not all of them are pushed into the master build. These are a few that I’ve kept that are quite useful, especially the one to prevent crashes in the Argent Tournament zone.
Link: http://promiterra.iwebs.ws/scripts/5_forum.rar
Script #6 – Kezan
The team from Trinity added all the NPCs for Kezan in march but most of the quests are not working yet. This script corrects all the quests and allow the player to leave the island on the last quest on the dock. The last quest shows the destruction of Kezan cutscene and teleport the player to the Durotar docks since the Lost Isles are not yet implemented. This script only works with a recent core or repack.
Link: http://promiterra.iwebs.ws/scripts/6_kezan.rar
Script #7 – Death Knights
This script corrects all the Runeforge for Death Knights in Ebon Hold. It also fixes the starting quest chains so players can start Death Knights, do the starting area quests, gain the DK quest bonus and play normally after that.
Link: http://promiterra.iwebs.ws/scripts/7_death_knight.rar
That’s it for now, I’ll update the scripts from time to time with more quest and zone fixes. If you got similar scripts for trinity 4.3.4 please post them. If a noob like me could do all of this, a big team could create a great trinity database in no time.
I hope you like the scripts, keep on WOWing!
I’ve created many SQL scripts that you can use on your Trinity 4.3.4 cores or repacks. Some of them are already posted by the trinity team. Some of them are still in review. And others will never be posted because they are not Blizzlike enough or they simply hack a quest so it can be completed.
The scripts were made for recent cores (2013-04-01) but probably could be used on older ones also. If you want to use many of them, you should run them in your world database in order. I use HeidiSQL to run the script in the world database but I guess other software could also do the trick.
Feel free to use them in any core or repack that you have and tell me if they work for you. Of course, I do not guarantee the results so it’s a good idea to do a backup of your world database before running them.
Script #1 – Main quest fix
This script fixes lots of quests everywhere but mostly in the Dun Morogh, Loch Modan, Wetlands, Arathi Highlands, The Hinterlands, Westfall, Dusk Woods, Winterspring, Tanaris and Ice Crown. Most of the fixes are legit but some of them simply hack the quest so it can be completed. More than half of those fixes are already posted or being reviewed by the trinity team.
Link: http://promiterra.iwebs.ws/scripts/1...34_SQL_fix.rar (http://promiterra.iwebs.ws/scripts/1_trinity_434_SQL_fix.rar)
Script #2 – Loot for all Cataclysm mobs
This one is huge. It’s a script that gives loot to all mobs for Cataclysm, which many of those don’t have in the latest trinity core. It’s currently being reviewed by the trinity team but since it’s so big it might take a lot of time for them to test it. It fixes tons of drop quests.
Link: http://promiterra.iwebs.ws/scripts/2...e_with_ref.rar (http://promiterra.iwebs.ws/scripts/2_creature_loot_template_with_ref.rar)
Script #3 – Fix all quest chains
This one is also pretty big. This script fixes all the quest chains from Cataclysm. This prevents a lot of “You don’t meet the requirement for this quest” errors. It recreates the quest chains based on wowhead data and gives a way better questing experience to your players. This script is also being reviewed by Trinity right now.
Link: http://promiterra.iwebs.ws/scripts/3...est_chains.rar (http://promiterra.iwebs.ws/scripts/3_all_quest_chains.rar)
Script #4 – Uldum
Uldum is an awesome zone in Cataclysm but it’s pretty bugged right now. This SQL script allows the player to do all the quests without error, some of them are simply hacked to be auto completed. This script also spawns all the missing NPCs that are managed by phases. It gives damage to all the mobs that didn’t do any damage before (The damage is probably not exact but it’s a start). It also allows you to complete the Lost City dungeon and the Halls of origination dungeon and do the quests in those dungeons. Since Uldum is the only zone that really works now for levels 80 to 84, I’ve reduced the quest requirement level to 80 so any players 80 and + can go there and do the quests. I’ve also added many obsidium mines everywhere in Uldum because none of them are spawned anywhere right now in 4.3.4. None of those fixes were sent to Trinity because they are not Blizzlike so you are the only ones to get them.
Link: http://promiterra.iwebs.ws/scripts/4_uldum.rar
Script #5 – Trinity forum fixes
Many fixes are posted on the trinity forums but not all of them are pushed into the master build. These are a few that I’ve kept that are quite useful, especially the one to prevent crashes in the Argent Tournament zone.
Link: http://promiterra.iwebs.ws/scripts/5_forum.rar
Script #6 – Kezan
The team from Trinity added all the NPCs for Kezan in march but most of the quests are not working yet. This script corrects all the quests and allow the player to leave the island on the last quest on the dock. The last quest shows the destruction of Kezan cutscene and teleport the player to the Durotar docks since the Lost Isles are not yet implemented. This script only works with a recent core or repack.
Link: http://promiterra.iwebs.ws/scripts/6_kezan.rar
Script #7 – Death Knights
This script corrects all the Runeforge for Death Knights in Ebon Hold. It also fixes the starting quest chains so players can start Death Knights, do the starting area quests, gain the DK quest bonus and play normally after that.
Link: http://promiterra.iwebs.ws/scripts/7_death_knight.rar
That’s it for now, I’ll update the scripts from time to time with more quest and zone fixes. If you got similar scripts for trinity 4.3.4 please post them. If a noob like me could do all of this, a big team could create a great trinity database in no time.
I hope you like the scripts, keep on WOWing!