Hello !! pls tell me someone how to find some NPC or item in HeidiSQL and how to delete them !!!!!!!! Ty !!!
Hello !! pls tell me someone how to find some NPC or item in HeidiSQL and how to delete them !!!!!!!! Ty !!!
Its easier to use Navicat from my own opinion, Look up Navicat lite.
From that it will give you the option to delete records once you are connected by simply clicking on the "-" button at the bottom.
You can also look through Tables etc, and run SQL commadns to find specfic parts without looking.
HAPPY HOLIDAYS.
A query template you can use to speed up things:
SELECT *FROM `creature_names` WHERE `entry` = '50';
Well select that npc in creature_names so that you can edit it, and:
DELETE FROM `creature_names` WHERE `entry` = '50;
Will delete it. You also need to edit the proto remember, and different emulators work differently.
Spread out helping seems to work great.
I.E someone suggests something, then someone supplies whats needed
Ty for your help !
Stoneharry: it work !
Kiev: i will try that Navicat !
Ty to all of you !!!!
Your welcome my friend!