[Archive] SQL Develop
[Archive] SQL Develop
11-04-2025, 05:13 PM
Original source
What does it take to fix SQL's my self ?
Like, which programs, maybe some tutorials
Seen Dolgan fixing a lot on 4.3.4 through SQL
rektbyfaith
11-04-2025, 05:13 PM #1Archived author: Blackvision • Posted: 2025-11-04T18:13:13.609810
Original source
What does it take to fix SQL's my self ?
Like, which programs, maybe some tutorials
Seen Dolgan fixing a lot on 4.3.4 through SQL
11-04-2025, 05:13 PM
Original source
Quote:Blackvision said:I use programs like HeidiSQL when working in WoW SQL/DB stuff. Other people have different preferences depending on what they need it for, however.
What does it take to fix SQL's my self ?
Like, which programs, maybe some tutorials
Seen Dolgan fixing a lot on 4.3.4 through SQL
Click to expand...
I don't have any tutorials to provide, maybe someone else could help there, as I don't typically work on SQL stuff.
The easy fixes are NPCs missing, dialogues missing, etc, which I believe you can learn to fix yourself by looking up stuff like "How to add custom dialogue to NPC's" or something along those lines, then copying the SQL query you made and post it.
That's just simple stuff though, could be slightly different as again, I don't typically make SQL fixes - although I may actually be doing this a bit more often soon due to a personal project, so I might be able to help in the future.
Good luck to you though, hopefully someone has a better idea of how to get you started.
rektbyfaith
11-04-2025, 05:13 PM #2Archived author: Blackvision • Posted: 2025-11-04T18:13:13.609810
Original source
Quote:Blackvision said:I use programs like HeidiSQL when working in WoW SQL/DB stuff. Other people have different preferences depending on what they need it for, however.
What does it take to fix SQL's my self ?
Like, which programs, maybe some tutorials
Seen Dolgan fixing a lot on 4.3.4 through SQL
Click to expand...
I don't have any tutorials to provide, maybe someone else could help there, as I don't typically work on SQL stuff.
The easy fixes are NPCs missing, dialogues missing, etc, which I believe you can learn to fix yourself by looking up stuff like "How to add custom dialogue to NPC's" or something along those lines, then copying the SQL query you made and post it.
That's just simple stuff though, could be slightly different as again, I don't typically make SQL fixes - although I may actually be doing this a bit more often soon due to a personal project, so I might be able to help in the future.
Good luck to you though, hopefully someone has a better idea of how to get you started.
11-04-2025, 05:13 PM
Original source
Quote:Mr. Satan said:I'm using HeidiSQL as well.
I use programs like HeidiSQL when working in WoW SQL/DB stuff. Other people have different preferences depending on what they need it for, however.
I don't have any tutorials to provide, maybe someone else could help there, as I don't typically work on SQL stuff.
The easy fixes are NPCs missing, dialogues missing, etc, which I believe you can learn to fix yourself by looking up stuff like "How to add custom dialogue to NPC's" or something along those lines, then copying the SQL query you made and post it.
That's just simple stuff though, could be slightly different as again, I don't typically make SQL fixes - although I may actually be doing this a bit more often soon due to a personal project, so I might be able to help in the future.
Good luck to you though, hopefully someone has a better idea of how to get you started.
Click to expand...
e.g i would like to fix
but its harder than i thought.
The Ruthless Gladiator sets are missing from NPC : Knight-Lieutenant T'Maire Sydes & Blood Guard Zar'shi
You cant trade any of these tokens from NPC Faldren Tillsdale & Jamus' Vaz
Corrupted Protector
Corrupted Vanquisher
Corrupted Conqueror
Gear is missing from npc
rektbyfaith
11-04-2025, 05:13 PM #3Archived author: Blackvision • Posted: 2025-11-04T18:13:13.609810
Original source
Quote:Mr. Satan said:I'm using HeidiSQL as well.
I use programs like HeidiSQL when working in WoW SQL/DB stuff. Other people have different preferences depending on what they need it for, however.
I don't have any tutorials to provide, maybe someone else could help there, as I don't typically work on SQL stuff.
The easy fixes are NPCs missing, dialogues missing, etc, which I believe you can learn to fix yourself by looking up stuff like "How to add custom dialogue to NPC's" or something along those lines, then copying the SQL query you made and post it.
That's just simple stuff though, could be slightly different as again, I don't typically make SQL fixes - although I may actually be doing this a bit more often soon due to a personal project, so I might be able to help in the future.
Good luck to you though, hopefully someone has a better idea of how to get you started.
Click to expand...
e.g i would like to fix
but its harder than i thought.
The Ruthless Gladiator sets are missing from NPC : Knight-Lieutenant T'Maire Sydes & Blood Guard Zar'shi
You cant trade any of these tokens from NPC Faldren Tillsdale & Jamus' Vaz
Corrupted Protector
Corrupted Vanquisher
Corrupted Conqueror
Gear is missing from npc
11-04-2025, 05:13 PM
Original source
you can fix both of those problems by editing the npc_vendor table
there are plenty of lists of extendedcost values on the internet aswell... like this one
rektbyfaith
11-04-2025, 05:13 PM #4Archived author: Blackvision • Posted: 2025-11-04T18:13:13.609810
Original source
you can fix both of those problems by editing the npc_vendor table
there are plenty of lists of extendedcost values on the internet aswell... like this one
11-04-2025, 05:13 PM
Original source
Quote:heyitsmexd said:Thank you mate.
you can fix both of those problems by editing the npc_vendor table
there are plenty of lists of extendedcost values on the internet aswell... like this one
Click to expand...
But that list is incomplete
I found another one : Link
rektbyfaith
11-04-2025, 05:13 PM #5Archived author: Blackvision • Posted: 2025-11-04T18:13:13.609810
Original source
Quote:heyitsmexd said:Thank you mate.
you can fix both of those problems by editing the npc_vendor table
there are plenty of lists of extendedcost values on the internet aswell... like this one
Click to expand...
But that list is incomplete
I found another one : Link
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)