SQL Develop

[Blackvision]

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

 

[Mr. Satan]

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

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.

 

[Blackvision]

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.

I'm using HeidiSQL as well.

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

 

[heyitsmexd]

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

 

[Blackvision]

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

Thank you mate.
But that list is incomplete

I found another one : Link