1. Double - Click it
2. It will open a query in SQL
3. HIT EXECUTE. Wait for finish>>
Think youre done :P
06/15/2012 16:52JohnHeatz#3
Just remember that when you have a .sql file, it means that there is a query in it, what you have to do is simply execute it on your SQL and it will take effect
06/15/2012 17:48STIV123#4
Oh and btw Remember restarting Server... for the effect... ^_^ And Importing in the client, of course.
08/29/2012 11:26hellgunner#5
I stumble upon this, for I was trying to do this too. Importing into the client, meaning into the data.sah? Or make new client (Not a completely new client) Or import the item.sdata into the data.sah?
08/29/2012 15:12TeddyBear94#6
importing into the client back ( not the sql file so still item.sdata) data.sah and data.saf = part of the client
08/29/2012 20:08hellgunner#7
I guess my question is, after I query it to the Database, how do I make it so it can be used in the new data.sah/client etc? I imported the item.sdata to the client (data.sah) but I get a character load error. What do I need to do to fix that?
08/30/2012 00:16TeddyBear94#8
if u get char load error that mostly happends because u imported the item.sdata in the wrong way back. remember if u extract stuff press "no" if u import stuff press "yes" just 1 execption if u export npcquest.data take care that it is decrypted to use it for ur server files. good hint always have back up clients with back up data.sah´s and data.saf´s ( they only work toghter)
after u edit the item.sdata safe it ones as item.sdata and ones as item.sql item.sdata goes back into data.sah for the client and the item.sql will be runned in db.
04/04/2013 20:59getupkid77#9
after i make new data.sah and data.saf can i move them directly to replace the ones in my client or do i have to make a patch? because i want to test it first
i made an item.sql from my item.Sdata ran it and executed it but ran with errors and the armor was not replaced anyone have an idea of what i did wrong ?